
<?php

namespace App\Http\Controllers;

use App\Company;
use App\Expence;
use App\LandPurchase;
use App\Plot;
use Brian2694\Toastr\Facades\Toastr;
use Illuminate\Http\Request;
use PhpParser\Node\Expr\New_;

class LandPurchaseController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        $from = $request->from;
        $to = $request->to;


        if ($from || $to) {
            $from = date("Y-m-d", strtotime($request->from));
            $to = date("Y-m-d", strtotime($request->to));
            // print_r($from);
            // print_r($to);
            // exit();
            $landPurchases = LandPurchase::whereBetween('date', array($from, $to))
                ->orderBy('date', 'ASC')
                ->paginate(20);

            //dd($landPurchases);
        } else {

            $landPurchases = LandPurchase::orderBy('date', 'ASC')->paginate(20);
        }
        $company = Company::latest()->first();
        return view('land-purchase.index', compact('landPurchases', 'company', 'from', 'to'));
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        return view('land-purchase.create');
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        // $request->validate([
        //     'donor_name' => 'required',
        //     'land_volume' => 'required',
        //     'stain_number' => 'required',
        //     'ledger' => 'required',
        //     'shotok_price' => 'required',
        //     'total_price' => 'required',
        //     'paid_amount' => 'required',
        //     'due_amount' => 'required',
        // ]);

        $land_purchase = new LandPurchase();
        $dateChange = date("Y-m-d", strtotime($request->date));
        $land_purchase->date = $dateChange;
        $land_purchase->owner_name = $request->owner_name;
        $land_purchase->reference_name = $request->reference_name;
        $land_purchase->reference_file_no = $request->reference_file_no;
        $land_purchase->dolil_no = $request->dolil_no;
        $land_purchase->rs_dag = $request->rs_dag;
        $land_purchase->land_poriman = $request->land_poriman;
        $land_purchase->commision_percentage = $request->commision_percentage;
        $land_purchase->investor_name = $request->investor_name;
        $land_purchase->investor_number = $request->investor_number;
        $land_purchase->investor_total_invest = $request->investor_total_invest;
        $land_purchase->total_commision = $request->total_commision;
        $land_purchase->investor_interest = $request->investor_interest;
        $land_purchase->investor_total_interest = $request->investor_total_interest;
        $land_purchase->registri_amount = $request->registri_amount;
        $land_purchase->total_fee = $request->total_fee;
        $land_purchase->details = $request->details;

        $land_purchase->ledger = $request->ledger;
        $land_purchase->shotok_price = $request->shotok_price;
        $land_purchase->total_price = $request->total_price;
        $land_purchase->paid_amount = $request->paid_amount;
        $land_purchase->deu_amount = $request->deu_amount;
        $land_purchase->investor_total_invest_1 = $request->investor_total_invest_1;


        $land_purchase->save();

        Toastr::success('Category Successfully Saved :)', 'Success');

        return redirect()->back();
    }

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

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\LandPurchase  $landPurchase
     * @return \Illuminate\Http\Response
     */
    public function edit(LandPurchase $landPurchase)
    {
        $dateChange = date("d-m-Y", strtotime($landPurchase->date));
        return view('land-purchase.edit', compact('landPurchase', 'dateChange'));
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\LandPurchase  $landPurchase
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, LandPurchase $landPurchase)
    {
        // $request->validate([
        //     'donor_name' => 'required',
        //     'land_volume' => 'required',
        //     'stain_number' => 'required',
        //     'ledger' => 'required',
        //     'shotok_price' => 'required',
        //     'total_price' => 'required',
        //     'paid_amount' => 'required',
        //     'due_amount' => 'required',
        // ]);
        if (
            $request->land_poriman == NULL || $request->commision_percentage == NULL || $request->investor_total_invest == NULL
            || $request->total_commision == NULL || $request->investor_interest == NULL || $request->investor_total_interest == NULL
            || $request->registri_amount == NULL || $request->total_fee == NULL
        ) {

            $landPurchase->owner_name = $request->owner_name;
            $landPurchase->reference_name = $request->reference_name;
            $landPurchase->reference_file_no = $request->reference_file_no;
            $landPurchase->dolil_no = $request->dolil_no;
            $landPurchase->rs_dag = $request->rs_dag;
            $landPurchase->investor_name = $request->investor_name;
            $landPurchase->investor_number = $request->investor_number;
            $landPurchase->details = $request->details;
            $landPurchase->ledger = $request->ledger;
        } else {

            $landPurchase->owner_name = $request->owner_name;
            $landPurchase->reference_name = $request->reference_name;
            $landPurchase->reference_file_no = $request->reference_file_no;
            $landPurchase->dolil_no = $request->dolil_no;
            $landPurchase->rs_dag = $request->rs_dag;
            $landPurchase->land_poriman = $request->land_poriman;
            $landPurchase->commision_percentage = $request->commision_percentage;
            $landPurchase->investor_name = $request->investor_name;
            $landPurchase->investor_number = $request->investor_number;
            $landPurchase->investor_total_invest = $request->investor_total_invest;
            $landPurchase->total_commision = $request->total_commision;
            $landPurchase->investor_interest = $request->investor_interest;
            $landPurchase->investor_total_interest = $request->investor_total_interest;
            $landPurchase->registri_amount = $request->registri_amount;
            $landPurchase->total_fee = $request->total_fee;
            $landPurchase->details = $request->details;
            $landPurchase->ledger = $request->ledger;
            $landPurchase->shotok_price = $request->shotok_price;
            $landPurchase->total_price = $request->total_price;
            $landPurchase->paid_amount = $request->paid_amount;
            $landPurchase->deu_amount = $request->deu_amount;
            $landPurchase->investor_total_invest_1 = $request->investor_total_invest_1;
        }

        $landPurchase->save();

        Toastr::success('Land Purchase Updated :)', 'Success');

        return redirect()->back();
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\LandPurchase  $landPurchase
     * @return \Illuminate\Http\Response
     */
    public function destroy(LandPurchase $landPurchase)
    {
        $landPurchase->delete();

        Toastr::success('Land Purchase Updated :)', '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));
            $purchases = LandPurchase::whereBetween('created_at', [$string1, $string2])->with('installments')->get();
        } else {
            $purchases = LandPurchase::with('installments')->get();
        }
        //        return $purchases;
        $company = Company::latest()->first();
        return view('report.purchase', compact('purchases', 'company'));
    }
}