
<?php

namespace App\Http\Controllers;

use App\CommisionPlan;
use App\Company;
use App\Events\SendSMS;
use App\installment;
use App\Member;
use App\Sale;
use Brian2694\Toastr\Facades\Toastr;
use Illuminate\Http\Request;

class InstallmentController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $installments = installment::with(['sale', 'member'])->get();
        $company = Company::latest()->first();
        return view('installment.index', compact('installments', 'company'));
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create(Request $request)
    {
        return view('installment.create');
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        $request->validate([
            'member_id' => 'required',
            'date' => 'required',
            'sales_id' => 'required',
        ]);

        $installment = new installment();
        $installment->member_id = $request->member_id;
        $installment->sales_id = $request->sales_id;
        $installment->amount = $request->amount;
        $installment->date = $request->date;
        $member = Member::where('id', $request->member_id)->first();
        $r_id = $member->reference_id;
        $plan = CommisionPlan::where('refference_id', $r_id)->first();
        $pay = $installment->amount;
        $paid_am = $plan->installment_amount;
        $installment->refference_log = ($pay * $paid_am) / 100;

        $ins =  $installment->refference_log;

        $installment->company_log = $pay - $ins;


        $installment->save();

        $sales = Sale::with(['installments'])->where('id', $request->sales_id)->first();
        $paid = installment::where('sales_id', $request->sales_id)->sum('amount');
        $paid_installment_count = installment::where('sales_id', $request->sales_id)->count();
        $member = Member::where('id', $request->member_id)->first();

        $total_paid = $sales->paid + $paid;
        $due  = $sales->due_amount + $sales->paid + $sales->discount - $total_paid;
        $remain_installment = $sales->installment - $paid_installment_count;

        $to = $member->mobile;
        $message = "Dear " . $member->name . ", You have paid an installment of " . $installment->amount . " Tk. Number of remaining installments are " . $remain_installment . ". Total Due amount " . $due . "TK";

        event(new SendSMS($to, $message));

        Toastr::success('Installment Successfully Created :)', 'Success');
        return redirect()->route('admin.installment.index');
    }

    /**
     * Display the specified resource.
     *
     * @param  \App\installment  $installment
     * @return \Illuminate\Http\Response
     */
    public function show(installment $installment)
    {
        return view('installment.show', compact('installment'));
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\installment  $installment
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        $installment = installment::findOrFail($id);
        return view('installment.edit', compact('installment'));
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\installment  $installment
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        $request->validate([
            'member_id' => 'required',
            'date' => 'required',
            'sales_id' => 'required',
        ]);

        $installment = installment::findOrFail($id);
        $installment->member_id = $request->member_id;
        $installment->sales_id = $request->sales_id;
        $installment->amount = $request->amount;
        $installment->date = $request->date;
        $member = Member::where('id', $request->member_id)->first();
        $r_id = $member->reference_id;
        $plan = CommisionPlan::where('refference_id', $r_id)->first();
        $pay = $installment->amount;
        $paid_am = $plan->installment_amount;

        $installment->refference_log = ($pay * $paid_am) / 100;

        $ins =  $installment->refference_log;

        $installment->company_log = $pay - $ins;


        $installment->save();

        Toastr::success('Installment Successfully Updated :)', 'Success');
        return redirect()->back();
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\installment  $installment
     * @return \Illuminate\Http\Response
     */
    public function destroy(installment $installment)
    {
        if ($installment->delete()) {
            Toastr::success('Member deleted successfully :)', 'Success');
            return redirect()->back();
        } else {
            Toastr::error('Something went wrong :(', 'Error');
            return redirect()->back();
        }
    }

    public function search(Request $request)
    {
        $member = Member::with(['sales', 'installments'])->where('serial_id', $request->member_id)->first();
        return view('installment.create', compact('request', 'member'));
    }

    public function report(Request $request)
    {
        if ($request->date_range) {
            $x = 1;
            $delim = ' - ';
            $str = $request->date_range;
            $parts = explode($delim, $str);
            $string1 = implode($delim, array_slice($parts, 0, $x)) . $delim;
            $string2 = implode($delim, array_slice($parts, $x));

            $string2 = date("y-m-d", strtotime($string2));
            $string1 = date("y-m-d", strtotime($string1));
            $installments = installment::whereBetween('created_at', [$string1, $string2])->get();
        } else {
            $installments = installment::all();
        }
        $company = Company::latest()->first();

        return view('report.installment', compact('installments', 'company'));
    }
}