
<?php

namespace App\Http\Controllers;

use App\CommisionPlan;
use App\Company;
use App\Events\SendSMS;
use App\Member;
use App\Plot;
use App\Reference;
use App\ReferenceIncome;
use App\Sale;
use App\SaleDetail;
use Brian2694\Toastr\Facades\Toastr;
use Illuminate\Http\Request;

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

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        $members = Member::select('serial_id', 'name', 'id')->get();
        $plots = Plot::where('quantity', '>', 0)->get();
        return view('sales.create', compact('members', 'plots'));
    }

    /**
     * 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',
            'plot_id' => 'required',
            'due_amount' => 'required',
            'date' => 'required',
        ]);

        $plot = Plot::where('id', $request->plot_id)->first();

        if ($plot->quantity > 0) {

            $member = Member::where('id', $request->member_id)->first();
            $reference = Reference::where('id', $member->reference_id)->first();
            $id = $member->reference_id;
            //$name=$member->reference_id;
            $plan = CommisionPlan::where('refference_id', $id)->first();
            //dd($plan);

            if (!$plan) {
                Toastr::success('commision plan is Not Available ! :)', 'Error');
            } else {
                $sale = new Sale();
                $sale->member_id = $request->member_id;
                $sale->plot_id = $request->plot_id;
                $sale->date = $request->date;
                $sale->discount = $request->discount;
                $sale->paid = $request->paid_amount;
                $sale->due_amount = $request->due_amount;
                $sale->installment = $request->installment_number;
                $sale->installment_amount = $request->installment_amount;

                $sale->save();

                $plot->quantity = $plot->quantity - 1;
                $plot->save();

                $sale_id = $sale->id;
                if (!($sale->installment)) {
                    $member = Member::where('id', $request->member_id)->first();
                    $id = $member->reference_id;
                    //$name=$member->reference_id;
                    $plan = CommisionPlan::where('refference_id', $id)->first();
                    $ref = Reference::where('id', $id)->first();
                    //dd($ref);
                    $name = $ref->name;
                    //dd($name);
                    $pay = $plan->ekkalin_amount;
                    $paid_am = $request->paid_amount;
                    // dd($paid_am);
                    $details = new SaleDetail();
                    $details->member_id = $request->member_id;
                    $details->plot_id = $request->plot_id;
                    $details->sales_id = $sale_id;
                    $details->refference_id = $id;
                    $details->refference_name = $name;
                    $details->date = $request->date;
                    $details->discount = $request->discount;
                    $details->paid = $request->paid_amount;
                    $details->due_amount = $request->due_amount;
                    $details->installment = $request->installment_number;
                    $details->installment_amount = $request->installment_amount;
                    $details->refference_log = ($pay * $paid_am) / 100;
                    $details->company_log = $paid_am - ($details->refference_log);
                    // dd($details->company_log);
                    $details->save();

                    $ri = new ReferenceIncome();
                    $ri->member_id = $member->id;
                    $ri->reference_id = $reference->id;
                    $ri->amount =  $details->refference_log;
                    $ri->save();
                } else {
                    $member = Member::where('id', $request->member_id)->first();
                    $id = $member->reference_id;
                    $plan = CommisionPlan::where('refference_id', $id)->first();
                    $ref = Reference::where('id', $id)->first();
                    //dd($ref);
                    $name = $ref->name;
                    $pay = $plan->booking_amount;
                    $paid_am = $request->paid_amount;
                    // dd($paid_am);
                    $details = new SaleDetail();
                    $details->member_id = $request->member_id;
                    $details->plot_id = $request->plot_id;
                    $details->sales_id = $sale_id;
                    $details->refference_id = $id;
                    $details->refference_name = $name;
                    $details->date = $request->date;
                    $details->discount = $request->discount;
                    $details->paid = $request->paid_amount;
                    $details->due_amount = $request->due_amount;
                    $details->installment = $request->installment_number;
                    $details->installment_amount = $request->installment_amount;
                    $details->refference_log = ($pay * $paid_am) / 100;
                    $details->company_log = $paid_am - ($details->refference_log);
                    // dd($details->company_log);
                    $details->save();
                    $ri = new ReferenceIncome();
                    $ri->member_id = $member->id;
                    $ri->reference_id = $reference->id;
                    $ri->amount =  $details->refference_log;
                    $ri->save();
                }


                $to = $member->mobile;
                $message = "Dear " . $member->name . ", Thank For the purchase from us. You paid " . $sale->paid . "TK and Due amount " . $sale->due_amount . "TK.";


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

                Toastr::success('Sales Created ! :)', 'Success');
            }
        } else {
            Toastr::success('Plot Not Available ! :)', 'Error');
        }

        return redirect()->back();
    }

    /**
     * Display the specified resource.
     *
     * @param  \App\Sale  $sale
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        $sale = Sale::findOrFail($id);
        $company = Company::latest()->first();
        return view('sales.show', compact('sale', 'company'));
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Sale  $sale
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        $sale = Sale::findOrFail($id);
        $members = Member::select('serial_id', 'name', 'id')->get();
        $plots = Plot::all();
        return view('sales.edit', compact('sale', 'members', 'plots'));
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Sale  $sale
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        $request->validate([
            'member_id' => 'required',
            'plot_id' => 'required',
            'due_amount' => 'required',
            'date' => 'required',
        ]);
        $member = Member::where('id', $request->member_id)->first();
        $reference = Reference::where('id', $member->reference_id)->first();
        $id_r = $member->reference_id;
        //$name=$member->reference_id;
        $plan = CommisionPlan::where('refference_id', $id_r)->first();
        //dd($plan);
        if (!$plan) {
            Toastr::success('commision plan is Not Available ! :)', 'Error');
            return redirect()->back();
        } else {
            $sale = Sale::findOrFail($id);
            $sale->member_id = $request->member_id;
            $sale->plot_id = $request->plot_id;
            $sale->date = $request->date;
            $sale->discount = $request->discount;
            $sale->paid = $request->paid_amount;
            $sale->due_amount = $request->due_amount;
            $sale->installment = $request->installment_number;
            $sale->installment_amount = $request->installment_amount;
            $sale->save();
            $sale_id = $sale->id;
            if (!($sale->installment)) {
                $member = Member::where('id', $request->member_id)->first();
                $id = $member->reference_id;
                //$name=$member->reference_id;
                $plan = CommisionPlan::where('refference_id', $id)->first();
                $ref = Reference::where('id', $id)->first();
                //dd($ref);
                $name = $ref->name;
                //dd($name);
                $pay = $plan->ekkalin_amount;
                $paid_am = $request->paid_amount;
                // dd($paid_am);
                $details = new SaleDetail();
                $details->member_id = $request->member_id;
                $details->plot_id = $request->plot_id;
                $details->sales_id = $sale_id;
                $details->refference_id = $id;
                $details->refference_name = $name;
                $details->date = $request->date;
                $details->discount = $request->discount;
                $details->paid = $request->paid_amount;
                $details->due_amount = $request->due_amount;
                $details->installment = $request->installment_number;
                $details->installment_amount = $request->installment_amount;
                $details->refference_log = ($pay * $paid_am) / 100;
                $details->company_log = $paid_am - ($details->refference_log);
                // dd($details->company_log);
                $details->save();
            } else {
                $member = Member::where('id', $request->member_id)->first();
                $id = $member->reference_id;
                $plan = CommisionPlan::where('refference_id', $id)->first();
                $ref = Reference::where('id', $id)->first();
                //dd($ref);
                $name = $ref->name;
                $pay = $plan->booking_amount;
                $paid_am = $request->paid_amount;
                // dd($paid_am);
                $details = new SaleDetail();
                $details->member_id = $request->member_id;
                $details->plot_id = $request->plot_id;
                $details->sales_id = $sale_id;
                $details->refference_id = $id;
                $details->refference_name = $name;
                $details->date = $request->date;
                $details->discount = $request->discount;
                $details->paid = $request->paid_amount;
                $details->due_amount = $request->due_amount;
                $details->installment = $request->installment_number;
                $details->installment_amount = $request->installment_amount;
                $details->refference_log = ($pay * $paid_am) / 100;
                $details->company_log = $paid_am - ($details->refference_log);
                // dd($details->company_log);
                $details->save();
            }
            Toastr::success('Sales Updated ! :)', 'Success');

            return redirect()->back();
        }
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Sale  $sale
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        $sale = Sale::findOrFail($id);
        $sale->delete();
        Toastr::success('Sales Deleted ! :)', 'Success');

        return redirect()->back();
    }

    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));

            $sales = Sale::whereBetween('created_at', [$string1, $string2])->with('installments')->get();
        } else {
            $sales = Sale::with('installments')->get();
        }
        $company = Company::latest()->first();

        //        return $sales;

        return view('report.sales', compact('sales', 'company'));
    }
    public function list()
    {
        $sales = SaleDetail::get();

        return view('sales.list', compact('sales'));
    }
    public function show_list($id)
    {
        $sale = SaleDetail::findOrFail($id);
        $plot_id = $sale->plot_id;
        $member_id = $sale->member_id;
        $plot = Plot::where('id', $plot_id)->first();
        $company = Company::latest()->first();
        $member = Member::where('id', $member_id)->first();

        return view('sales.show_list', compact('sale', 'company', 'plot', 'member'));
    }
    public function delete_list($id)
    {

        $sales = new SaleDetail();
        $sale = $sales::find($id);

        $sale->delete();
        Toastr::success('sale details Deleted ! :)', 'Success');

        return redirect()->back();
    }
}