<?php

namespace App\Http\Controllers\instructor;

use App\Http\Controllers\Controller;
use App\Models\Course;
use App\Models\Payout;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Session;

class PayoutController extends Controller
{
    public function index()
    {
        $page_data['start_date'] = strtotime('first day of this month');
        $page_data['end_date']   = strtotime('last day of this month');

// modify date and prepare to compare with database
        if (request()->has('eDateRange')) {
            $date                    = explode('-', urldecode(request()->query('eDateRange')));
            $page_data['start_date'] = strtotime($date[0] . ' 00:00:00');
            $page_data['end_date']   = strtotime($date[1] . ' 23:59:59');
        }
        $query = Payout::where('user_id', auth()->user()->id)->where('created_at', '>=', date('Y-m-d H:i:s', $page_data['start_date']))
            ->where('created_at', '<=', date('Y-m-d H:i:s', $page_data['end_date']))->latest('id');

        $page_data['payout_reports'] = $query->paginate(10)->appends(request()->query('eDateRange'));
        $page_data['payout_request'] = Payout::where('user_id', auth()->user()->id)->where('status', 0)->first();
        $page_data['total_payout']   = instructor_total_payout();
        $page_data['balance']        = instructor_available_balance();

        return view('instructor.payout_report.index', $page_data);
    }

    public function store(Request $request)
    {
        // check old request
        if (Payout::where('user_id', auth()->user()->id)->where('status', 0)->exists()) {
            Session::flash('error', get_phrase('Your request is in process.'));
            return redirect()->back();
        }

        // check amount validity
        $total_income      = instructor_total_revenue();
        $total_payout      = instructor_total_payout();
        $balance_remaining = $total_income - $total_payout;

        if ($request->amount < 1 || $request->amount > $balance_remaining) {
            Session::flash('error', get_phrase('You do not have sufficient balance.'));
            return redirect()->back();
        }

        $data['user_id'] = auth()->user()->id;
        $data['amount']  = $request->amount;
        Payout::insert($data);

        Session::flash('success', get_phrase('Your request has been submitted.'));
        return redirect()->back();
    }

    public function delete($id)
    {
        if (Payout::where('id', $id)->where('user_id', auth()->user()->id)->doesntExist()) {
            Session::flash('error', get_phrase('Data not found.'));
            return redirect()->back();
        }
        Payout::where('id', $id)->delete();
        Session::flash('success', get_phrase('Your request has been deleted.'));
        return redirect()->back();
    }
}