
<?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 App\Plot;
use App\SaleDetail;
use App\Account;
use App\BookingAmount;
use App\CustomBooking;
use App\CustomInstallment;
use App\DemoInstallment;
use App\MoneyReceipt;
use App\ReferenceIncome;
use App\Reference;
use App\SaleDue;
use App\SmsCounter;
use Brian2694\Toastr\Facades\Toastr;
use Illuminate\Http\Request;
use Intervention\Image\Filters\DemoFilter;

class InstallmentController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $installments = DemoInstallment::where('isDelete', 0)

            ->orderBy('id', 'DESC')
            ->get();

        $installment_C = CustomInstallment::where('isDelete', 0)
            ->orderBy('id', 'DESC')
            ->get();

        $company = Company::latest()->first();
        return view('installment.index', compact('installments', 'company', 'installment_C'));
    }
    public function Booking_list()
    {
        $booking = CustomBooking::where('isDelete', 0)

            ->orderBy('id', 'DESC')
            ->get();

        $company = Company::latest()->first();
        return view('installment.Booking_list', compact('booking', 'company'));
    }
    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function limitRand($start, $end)
    {
        return rand($start, $end);
    }
    public function create(Request $request)
    {

        $money =  $this->limitRand(0000, 9999);

        return view('installment.create', compact('money'));
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function target_booking(Request $request)
    {
        //dd('target_booking');
        $sale = SaleDetail::where('sales_id', $request->sales_id)->first();
        $booking = new BookingAmount();

        $dateChange = date("Y-m-d", strtotime($request->date_a));
        $sales = Sale::where('id', $request->sales_id)->first();

        $member = Member::where('id', $request->member_id)->first();
        $ref_id = $member->reference_id;
        $sale = SaleDetail::where('sales_id', $request->sales_id)->first();
        $b_id = $sales->block_id;
        $plan = CommisionPlan::where('block_id', $b_id)->first();

        $booking->member_id = $request->member_id;
        $booking->serial_id = $request->serial_id;
        $booking->sales_id = $request->sales_id;
        $booking->amount = $request->amount;
        $booking->date = $dateChange;
        $booking->sale_no = $sales->sale_no;
        $booking->reference_id = $ref_id;
        $booking->money_rec = $request->money_rec;
        $booking->remark = $request->remark;
        $booking->due = $sale->target_booking - $request->amount;
        $booking->save();

        $account = Account::where('sell_id',  $booking->sales_id)->first();
        $pre_account = $account->company_log;
        $account->company_log = $booking->amount + $pre_account;
        $account->save();


        $pre_target = $sale->target_booking;
        $pre_paid = $sale->paid;
        $member = Member::where('id', $request->member_id)->first();

        $id = $member->reference_id;
        $ref = Reference::where('id', $id)->first();
        $total_paid =  $pre_paid + $request->amount;

        $due  = ($sales->due_amount + $sales->paid + $sales->discount)  - $total_paid;


        $pre_paid = $sale->company_log;
        $sale->paid = $pre_paid + $request->amount;
        $sale->due_amount = $due;
        $sale->company_log = $booking->amount + $pre_paid;
        if ($pre_target + $request->amount > $sale->target_booking) {


            $ins_no = $sales->installment;
            $sale->target_booking = 0;
            $sale->installment_amount = $due / $ins_no;

            $sales->installment_amount = $due / $ins_no;
            $sales->save();
            $ref_income = ReferenceIncome::where('sell_id', $sales->id)->first();
            $ref_income->installment_amount = $due / $ins_no;
            $ref_income->save();
        } else {
            $sale->target_booking = $pre_target - $request->amount;
        }
        $sale->save();

        $deuAmount = new SaleDue();
        $deuAmount->sale_id = $booking->sales_id;
        $deuAmount->member_id = $booking->member_id;
        $deuAmount->amount =   $sale->due_amount;
        $deuAmount->status =   1;
        $deuAmount->booking_id =    $booking->id;
        $deuAmount->save();

        $money = new  MoneyReceipt();
        $money->booking_id = $booking->id;
        $money->save();

        $to = $member->mobile;
        $message = "Dear " . $member->name . ", You have paid an booking amount of " . $booking->amount . " for file No:" . $sales->sale_no .  " . Total booking Due amount " . $sale->paid . " TK.  Plot owner Login panal link:https://app.dhhl.ltd/login_customer";

        event(new SendSMS($to, $message));
        $sms = new SmsCounter();
        $sms->mobile = $member->mobile;
        $sms->sms = $message;
        $sms->total = 5000;
        $sms->save();
        Toastr::success('Booking amount Successfully paid :)', 'Success');
        return redirect()->back();
    }
    public function store(Request $request)
    {


        $request->validate([
            'member_id' => 'required',

            'sales_id' => 'required',
        ]);
        $installments = DemoInstallment::where('isDelete', 0)->where('sales_id', $request->sales_id)->where('member_id', $request->member_id)->get();
        if ($installments->isEmpty()) {
        } else {
            // Toastr::success('Installment request has been successfully sent to admin panal :)', 'Success');
            // return redirect()->back()->withErrors(['You have a pending installment. Before the approval of that']);
            return view('installment.pending_msg');
        }

        $installment = new installment();

        $dateChange = date("Y-m-d", strtotime($request->date_b));
        $installment->member_id = $request->member_id;
        $installment->serial_id = $request->serial_id;
        $installment->sales_id = $request->sales_id;
        $installment->amount = $request->amount;
        $installment->date = $dateChange;

        $member = Member::where('id', $request->member_id)->first();
        $ref_id = $member->reference_id;

        $installment->reference_id = $ref_id;
        $installment->money_rec = $request->money_rec;
        $installment->remark = $request->remark;
        $sale = SaleDetail::with(['installments'])->where('sales_id', $request->sales_id)->first();
        $sales = Sale::where('id', $request->sales_id)->first();
        $installment->due = $sale->due_amount - $request->amount;

        $installment->sale_no = $sales->sale_no;

        $installment->ins_no = $request->get('install');
        $b_id = $sales->block_id;
        $plan = CommisionPlan::where('block_id', $b_id)->first();
        $pay = $installment->amount;
        $paid_am = $plan->installment_amount;
        $installment->company_log = $pay;
        $account = Account::where('sell_id',  $installment->sales_id)->first();


        $pre_account = $account->company_log;

        $account->company_log = $installment->amount + $pre_account;
        $installment->save();
        $account->save();

        $sales = Sale::with(['installments'])->where('id', $installment->sales_id)->first();

        $paid_s = installment::where('sales_id', $installment->sales_id)->sum('amount');

        $company = installment::where('sales_id', $installment->sales_id)->sum('company_log');
        $refference = installment::where('sales_id', $installment->sales_id)->sum('refference_log');
        $paid_installment_count = installment::where('sales_id', $installment->sales_id)->count();
        $member = Member::where('id', $request->member_id)->first();
        $newPaid = $sale->paid;
        $id = $member->reference_id;
        $ref = Reference::where('id', $id)->first();
        $total_paid = $newPaid + $installment->amount;
        $due  = $sale->due_amount - $request->amount;

        $remain_installment = $sales->installment - $paid_installment_count;
        $book_cont = BookingAmount::where('sales_id', $installment->sales_id)->count();
        $pre_paid = $sale->company_log;
        $sale->paid = $total_paid;
        $sale->due_amount = $due;
        $sale->installment = $remain_installment;
        $sale->company_log = $installment->amount + $pre_paid;
        // $sale->refference_log = $refference + $sale->refference_log;


        $sale->save();

        $plot = Plot::where('id', $sales->plot_id)->first();
        $ri = new ReferenceIncome();
        $ri->member_id = $member->id;
        $ri->reference_id = $ref->id;
        $ri->amount =  ($pay * $paid_am) / 100;
        $ri->member_id = $member->id;
        $ri->rest_amount =  $ri->amount;
        $ri->installment_amount =  $installment->amount;
        $ri->intall_id =  $installment->id;
        $ri->booking_amount = $sale->booking_amount;
        $ri->installment_per_amount =   $sale->install_amount;
        $ri->ekkalin_per_amount =   $sale->ekkalin_amount;
        $ri->sell_id =   $sale->sales_id;

        $ri->block_id = $plan->block_id;
        $ri->block_name =   $plan->block_title;


        $ri->plot_size =   $plot->plot_size;
        $ri->face =  $plot->face;
        $ri->road =  $plot->road;


        $ri->status =  3;
        $ri->isDelete =  0;

        //dd($ri);
        $ri->save();

        $deuAmount = new SaleDue();
        $deuAmount->sale_id = $installment->sales_id;
        $deuAmount->member_id = $installment->member_id;
        $deuAmount->amount =   $installment->due;
        $deuAmount->status =   2;
        $deuAmount->ins_id =    $installment->id;
        $deuAmount->save();

        $money = new  MoneyReceipt();
        $money->ins_id = $installment->id;
        $money->save();

        $to = $member->mobile;
        $message = "Dear " . $member->name . ", You have paid an installment of " . $installment->amount . " Tk for File no: " . $sales->sale_no . " Number of remaining installments are " . $remain_installment . ". Total Due amount " . $due . "TK.  Plot owner Login panal link: https://app.dhhl.ltd/login_customer";

        event(new SendSMS($to, $message));
        $sms = new SmsCounter();
        $sms->mobile = $member->mobile;
        $sms->sms = $message;
        $sms->total = 5000;
        $sms->save();
        Toastr::success('Installment Successfully Created :)', 'Success');
        return redirect()->back();
    }

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

    public function show_installment($id)
    {

        $installment = installment::where('sales_id', $id)->get();

        $sales = Sale::with(['installments'])->where('id', $id)->first();
        $member = Member::with(['sales', 'installments'])->where('id', $sales->member_id)->first();
        $company = Company::latest()->first();
        //dd($sales);
        return view('installment.show', compact('installment', 'member', 'sales', 'company'));
    }

    /**
     * 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',

            'sales_id' => 'required',
        ]);

        $installment = installment::findOrFail($id);
        $installment->serial_id = $request->serial_id;
        $installment->member_id = $request->member_id;
        $installment->sales_id = $request->sales_id;
        $installment->amount = $request->amount;
        $installment->date = $request->date;

        $sale = SaleDetail::with(['installments'])->where('sales_id', $request->sales_id)->first();
        $installment->due = $sale->due_amount - $request->amount;
        $installment->ins_no = $request->get('install');
        $installment->save();
        $member = Member::where('id', $request->member_id)->first();
        $ref_id = $member->reference_id;
        $b_id = $member->block_id;
        $installment->reference_id = $ref_id;
        $installment->remark = $request->remark;
        //dd($installment->reference_id);
        $plan = CommisionPlan::where('block_id', $b_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->company_log = $pay;


        $account = account::where('reference_id', $installment->reference_id)->first();


        $pre_account = $account->company_log;

        $account->company_log = $installment->amount + $pre_account;
        // dd($account->company_log);
        $account->save();

        $sales = Sale::with(['installments'])->where('id', $installment->sales_id)->first();
        //dd($sales);

        $paid_s = installment::where('sales_id', $installment->sales_id)->sum('amount');
        // dd($paid_s);
        $company = installment::where('sales_id', $installment->sales_id)->sum('company_log');
        $refference = installment::where('sales_id', $installment->sales_id)->sum('refference_log');
        $paid_installment_count = installment::where('sales_id', $installment->sales_id)->count();
        $member = Member::where('id', $request->member_id)->first();

        $id = $member->reference_id;
        $ref = Reference::where('id', $id)->first();
        $total_paid = $sales->paid + $paid_s;
        $due  = ($sales->due_amount + $sales->paid + $sales->discount)  - $total_paid;

        $remain_installment = $sales->installment - $paid_installment_count;

        $pre_paid = $sale->company_log;
        $sale->paid = $total_paid;
        $sale->due_amount = $due;
        $sale->installment = $remain_installment;
        $sale->company_log = $installment->amount + $pre_paid;
        // $sale->refference_log = $refference + $sale->refference_log;

        $sale->save();

        $plot = Plot::where('id', $sales->plot_id)->first();
        $ri = new ReferenceIncome();
        $ri->member_id = $member->id;
        $ri->reference_id = $ref->id;
        $ri->amount =  ($pay * $paid_am) / 100;
        $ri->member_id = $member->id;
        $ri->rest_amount =  $ri->amount;
        $ri->installment_amount =  $sale->installment_amount;
        $ri->intall_id =  $installment->id;
        $ri->booking_amount = $sale->booking_amount;
        $ri->installment_per_amount =   $sale->install_amount;
        $ri->ekkalin_per_amount =   $sale->ekkalin_amount;


        $ri->block_id = $plan->block_id;
        $ri->block_name =   $plan->block_title;
        $ri->katha =  $plan->katha;

        $ri->plot_size =   $plot->plot_size;
        $ri->face =  $plot->face;
        $ri->road =  $plot->road;


        $ri->status =  3;
        $ri->isDelete =  0;

        //dd($ri);
        $ri->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->serial_id)->first();

        if (!$member) {
            Toastr::error('Something went wrong :(', 'Error');
            return redirect()->back();
        } else {
            $sale = Sale::with(['installments'])->where('serial_id', $request->serial_id)
                ->orderBy('id', 'ASC')

                ->get();
            return view('installment.create', compact('request', 'member', 'sale'));
        }
    }


    public function view_installment($id)
    {

        $installment = DemoInstallment::where('id', $id)

            ->first();


        $member = Member::where('id', $installment->member_id)->first();


        $company = Company::latest()->first();
        //dd($sales);
        return view('installment.view_installment', compact('installment', 'member', 'company'));
    }
    public function approve_installment($id)
    {


        $ins = DemoInstallment::where('id', $id)->first();
        $ins->isDelete = 1;
        $ins->save();
        $installment = new installment();
        $dateChange = date("Y-m-d", strtotime($ins->date));
        $installment->member_id = $ins->member_id;
        $installment->serial_id = $ins->serial_id;
        $installment->sales_id = $ins->sales_id;
        $installment->amount = $ins->amount;
        $installment->date = $dateChange;
        $member = Member::where('id', $ins->member_id)->first();
        $ref_id = $member->reference_id;

        $installment->reference_id = $ref_id;
        $installment->money_rec = $ins->money_rec;
        $installment->remark = $ins->remark;
        $sale = SaleDetail::with(['installments'])->where('sales_id', $ins->sales_id)->first();
        $sales = Sale::where('id', $ins->sales_id)->first();
        $installment->due = $sale->due_amount - $ins->amount;
        $installment->ins_no = $ins->ins_no;
        $installment->sale_no = $sales->sale_no;

        $b_id = $sales->block_id;
        $plan = CommisionPlan::where('block_id', $b_id)->first();
        $pay = $installment->amount;
        $paid_am = $plan->installment_amount;
        $installment->company_log = $pay;
        $account = Account::where('sell_id',  $installment->sales_id)->first();


        $pre_account = $account->company_log;

        $account->company_log = $installment->amount + $pre_account;


        $installment->save();
        $account->save();

        $sales = Sale::with(['installments'])->where('id', $installment->sales_id)->first();

        $paid_s = installment::where('sales_id', $installment->sales_id)->sum('amount');

        $company = installment::where('sales_id', $installment->sales_id)->sum('company_log');
        $refference = installment::where('sales_id', $installment->sales_id)->sum('refference_log');
        $paid_installment_count = installment::where('sales_id', $installment->sales_id)->count();
        $member = Member::where('id', $ins->member_id)->first();

        $id = $member->reference_id;
        $ref = Reference::where('id', $id)->first();
        $newPaid = $sale->paid;
        $total_paid = $newPaid + $installment->amount;
        $due  =  $due  = $sale->due_amount -  $installment->amount;


        $remain_installment = $sales->installment - $paid_installment_count;

        $pre_paid = $sale->company_log;
        $sale->paid = $total_paid;
        $sale->due_amount = $due;
        $sale->installment = $remain_installment;
        $sale->company_log = $installment->amount + $pre_paid;
        // $sale->refference_log = $refference + $sale->refference_log;


        $sale->save();

        $plot = Plot::where('id', $sales->plot_id)->first();
        $ri = new ReferenceIncome();
        $ri->member_id = $member->id;
        $ri->reference_id = $ref->id;
        $ri->amount =  ($pay * $paid_am) / 100;
        $ri->member_id = $member->id;
        $ri->rest_amount =  $ri->amount;
        $ri->installment_amount =  $installment->amount;
        $ri->intall_id =  $installment->id;
        $ri->booking_amount = $sale->booking_amount;
        $ri->installment_per_amount =   $sale->install_amount;
        $ri->ekkalin_per_amount =   $sale->ekkalin_amount;
        $ri->sell_id =   $sale->sales_id;

        $ri->block_id = $plan->block_id;
        $ri->block_name =   $plan->block_title;


        $ri->plot_size =   $plot->plot_size;
        $ri->face =  $plot->face;
        $ri->road =  $plot->road;


        $ri->status =  3;
        $ri->isDelete =  0;

        //  dd($ri);
        $ri->save();
        $deuAmount = new SaleDue();
        $deuAmount->sale_id = $installment->sales_id;
        $deuAmount->member_id = $installment->member_id;
        $deuAmount->amount =   $installment->due;
        $deuAmount->ins_id =    $installment->id;
        $deuAmount->status =   2;
        $deuAmount->save();
        $money = new  MoneyReceipt();
        $money->ins_id = $installment->id;
        $money->save();


        $to = $member->mobile;
        $message = "Dear " . $member->name . ", Your requesting payment of " . $installment->amount . " Tk. has been approved for File No: " . $sales->sale_no .  "  Number of remaining installments are " . $remain_installment . ". Total Due amount " . $due . " TK. Plot owner Login panel link: https://app.dhhl.ltd/login_customer";

        event(new SendSMS($to, $message));
        $sms = new SmsCounter();
        $sms->mobile = $member->mobile;
        $sms->sms = $message;
        $sms->total = 5000;
        $sms->save();
        Toastr::success('Installment  approved Successfully :)', 'Success');
        return redirect()->back();
    }
    public function approved_Booking_list($id)
    {


        $ins = CustomBooking::where('id', $id)->first();
        $ins->isDelete = 1;
        $ins->save();
        $sale = SaleDetail::where('sales_id', $ins->sales_id)->first();

        $booking = new BookingAmount();
        $sales = Sale::where('id', $ins->sales_id)->first();

        $dateChange = date("Y-m-d", strtotime($ins->date));

        $booking->member_id = $ins->member_id;
        $booking->serial_id = $ins->serial_id;
        $booking->sales_id = $ins->sales_id;
        $booking->amount = $ins->amount;
        $booking->date = $dateChange;
        $booking->sale_no = $sales->sale_no;
        $booking->image = $ins->image;
        $member = Member::where('id', $ins->member_id)->first();
        $ref_id = $member->reference_id;

        $booking->reference_id = $ref_id;
        $booking->money_rec = $ins->money_rec;
        $booking->remark = $ins->remark;

        $sale = SaleDetail::where('sales_id', $ins->sales_id)->first();

        $booking->due = $sale->target_booking - $ins->amount;

        $b_id = $sales->block_id;
        $plan = CommisionPlan::where('block_id', $b_id)->first();

        $account = Account::where('sell_id',  $booking->sales_id)->first();


        $pre_account = $account->company_log;

        $account->company_log = $booking->amount + $pre_account;

        $booking->save();
        $account->save();

        $sales = Sale::where('id', $booking->sales_id)->first();

        $paid_s = BookingAmount::where('sales_id', $booking->sales_id)->sum('amount');

        $company = BookingAmount::where('sales_id', $booking->sales_id)->sum('company_log');


        $member = Member::where('id', $ins->member_id)->first();

        $id = $member->reference_id;
        $ref = Reference::where('id', $id)->first();
        $total_paid = $sales->paid + $paid_s;
        $total_target = $sales->target_booking -  $paid_s;
        $due  = ($sales->due_amount + $sales->paid + $sales->discount)  - $total_paid;


        $pre_paid = $sale->company_log;
        $sale->paid = $total_paid;
        $sale->due_amount = $due;
        $sale->company_log = $booking->amount + $pre_paid;
        $sale->target_booking = $total_target;


        $sale->save();
        $deuAmount = new SaleDue();
        $deuAmount->sale_id = $booking->sales_id;
        $deuAmount->member_id = $booking->member_id;
        $deuAmount->amount =   $sale->due_amount;
        $deuAmount->booking_id =    $booking->id;
        $deuAmount->status =   1;
        $deuAmount->save();

        $money = new  MoneyReceipt();
        $money->booking_id = $booking->id;
        $money->save();

        $to = $member->mobile;
        // $message = "Dear " . $member->name . ", You have paid an booking amount of " . $booking->amount .  ". Total Due amount " . $due . "TK";
        $message = "Dear " . $member->name . ", You have paid an booking amount of " . $booking->amount . " for file No:" . $sales->sale_no .  " . Total Due amount " . $total_target . " TK.  Plot owner Login panel link: https://app.dhhl.ltd/login_customer";

        event(new SendSMS($to, $message));
        $sms = new SmsCounter();
        $sms->mobile = $member->mobile;
        $sms->sms = $message;
        $sms->total = 5000;
        $sms->save();
        Toastr::success('Booking Successfully Created :)', 'Success');
        return redirect()->back();
    }
    public function reject_installment($id)
    {

        $installment = DemoInstallment::where('id', $id)->first();
        $installment->isDelete = 2;
        $installment->save();
        $member = Member::where('id', $installment->member_id)->first();
        $message = "Dear " . $member->name . ", Your request of paying an installment of " . $installment->amount . "has been rejected";
        $to = $member->mobile;
        event(new SendSMS($to, $message));
        Toastr::success('Installment rejected successfully :)', 'Success');
        return redirect()->back();
    }
    public function rejected_Booking($id)
    {

        $installment = CustomBooking::where('id', $id)->first();
        $installment->isDelete = 2;
        $installment->save();
        $member = Member::where('id', $installment->member_id)->first();
        $message = "Dear " . $member->name . ", Your request of paying an installment of " . $installment->amount . "has been rejected";
        $to = $member->mobile;
        event(new SendSMS($to, $message));
        Toastr::success('Booking amount rejected successfully :)', 'Success');
        return redirect()->back();
    }
    public function view_Booking_list($id)
    {
        $company = Company::latest()->first();
        $installment = CustomBooking::where('id', $id)->first();

        $member = Member::where('id', $installment->member_id)->first();

        //dd($installment);
        return view('installment.view_Booking_list', compact('member', 'installment', 'company'));
    }
    public function approved_installment_list()
    {

        $installments = DemoInstallment::where('isDelete', 1)->get();
        $ins = CustomInstallment::where('isDelete', 1)->get();


        $company = Company::latest()->first();

        return view('installment.approved_installment_list', compact('installments',  'company', 'ins'));
    }
    public function rejected_installment_list()
    {

        $installments = DemoInstallment::where('isDelete', 2)->get();
        $company = Company::latest()->first();
        $ins = CustomInstallment::where('isDelete', 2)->get();
        return view('installment.rejected_installment_list', compact('installments',  'company', 'ins'));
    }

    public function view_custom_installment($id)
    {

        $installment = CustomInstallment::where('id', $id)

            ->first();


        $member = Member::where('id', $installment->member_id)->first();


        $company = Company::latest()->first();
        return view('installment.view_installment', compact('installment', 'member', 'company'));
    }

    public function approve_custom_installment($id)
    {


        $ins = CustomInstallment::where('id', $id)->first();
        $ins->isDelete = 1;
        $ins->save();
        $installment = new installment();
        $dateChange = date("Y-m-d", strtotime($ins->date));

        $installment->member_id = $ins->member_id;
        $installment->serial_id = $ins->serial_id;
        $installment->sales_id = $ins->saled_id;
        $installment->amount = $ins->amount;
        $installment->date =  $dateChange;
        $member = Member::where('id', $ins->member_id)->first();
        $ref_id = $member->reference_id;

        $installment->reference_id = $ref_id;
        $installment->money_rec = $ins->money_rec;
        $installment->remark = $ins->remark;
        $sale = SaleDetail::with(['installments'])->where('sales_id', $ins->saled_id)->first();
        $sales = Sale::where('id', $ins->saled_id)->first();
        $installment->sale_no = $sales->sale_no;

        $installment->due = $sale->due_amount - $ins->amount;
        $installment->ins_no = 0;
        $b_id = $sales->block_id;
        $plan = CommisionPlan::where('block_id', $b_id)->first();
        $pay = $installment->amount;
        $paid_am = $plan->installment_amount;
        $installment->company_log = $pay;
        $installment->save();
        $account = Account::where('sell_id',  $ins->saled_id)->first();


        $pre_account = $account->company_log;

        $account->company_log = $installment->amount + $pre_account;

        $account->save();

        $sales = Sale::with(['installments'])->where('id', $ins->saled_id)->first();

        $paid_s = installment::where('sales_id', $ins->saled_id)->sum('amount');

        $company = installment::where('sales_id', $ins->saled_id)->sum('company_log');
        $refference = installment::where('sales_id', $ins->saled_id)->sum('refference_log');
        $paid_installment_count = installment::where('sales_id', $ins->saled_id)->count();
        $member = Member::where('id', $ins->member_id)->first();

        $id = $member->reference_id;
        $ref = Reference::where('id', $id)->first();
        $newPaid = $sale->paid;
        $total_paid = $newPaid + $installment->amount;
        $due  =  $due  = $sale->due_amount -  $installment->amount;

        //$remain_installment = $sales->installment - $paid_installment_count;

        $pre_paid = $sale->company_log;
        $sale->paid = $total_paid;
        $sale->due_amount = $due;
        $sale->installment = 0;
        $sale->company_log = $installment->amount + $pre_paid;
        // $sale->refference_log = $refference + $sale->refference_log;


        $sale->save();

        $plot = Plot::where('id', $sales->plot_id)->first();
        $ri = new ReferenceIncome();
        $ri->member_id = $member->id;
        $ri->reference_id = $ref->id;
        $ri->amount =  ($pay * $paid_am) / 100;
        $ri->member_id = $member->id;
        $ri->rest_amount =  $ri->amount;
        $ri->installment_amount =  $ins->amount;
        $ri->intall_id =  $installment->id;
        $ri->booking_amount = $sale->booking_amount;
        $ri->installment_per_amount =   $sale->install_amount;
        $ri->ekkalin_per_amount =   $sale->ekkalin_amount;
        $ri->sell_id =   $sale->sales_id;

        $ri->block_id = $plan->block_id;
        $ri->block_name =   $plan->block_title;

        $ri->plot_size =   $plot->plot_size;
        $ri->face =  $plot->face;
        $ri->road =  $plot->road;


        $ri->status =  3;
        $ri->isDelete =  0;

        $deuAmount = new SaleDue();
        $deuAmount->sale_id = $installment->sales_id;
        $deuAmount->member_id = $installment->member_id;
        $deuAmount->amount =   $installment->due;
        $deuAmount->status =   2;
        $deuAmount->ins_id =    $installment->id;
        $deuAmount->save();
        //dd($ri);
        $ri->save();
        $deuAmount = new SaleDue();
        $deuAmount->sale_id = $installment->sales_id;
        $deuAmount->member_id = $installment->member_id;
        $deuAmount->amount =   $installment->due;
        $deuAmount->ins_id =    $installment->id;
        $deuAmount->status =   2;
        $deuAmount->save();

        $money = new  MoneyReceipt();
        $money->ins_id = $installment->id;
        $money->save();

        $to = $member->mobile;
        // $message = "Dear " . $member->name . ", Your request of paying an installment of " . $ins->amount . "has been approved" . " Tk. Number of remaining installments are " . 0 . ". Total Due amount " . $due . "TK";
        $message = "Dear " . $member->name . ", Your requesting payment of " . $ins->amount . " Tk. has been approved for File No: " . $sales->sale_no .  ". Total Due amount " . $due . " TK. Plot owner Login panel link: https://app.dhhl.ltd/login_customer";

        event(new SendSMS($to, $message));
        $sms = new SmsCounter();
        $sms->mobile = $member->mobile;
        $sms->sms = $message;
        $sms->total = 5000;
        $sms->save();
        Toastr::success('Installment Successfully Created :)', 'Success');
        return redirect()->back();
    }
    public function reject_custom_installment($id)
    {

        $installment = CustomInstallment::where('id', $id)->first();
        $installment->isDelete = 2;
        $installment->save();
        $member = Member::where('id', $installment->member_id)->first();
        $message = "Dear " . $member->name . ", Your request of paying an installment of " . $installment->amount . "has been rejected";
        $to = $member->mobile;
        event(new SendSMS($to, $message));
        return redirect()->back();
    }
    public function report(Request $request)
    {

        $from = $request->get('from');
        $to = $request->get('to');
        $mem = $request->get('member_id');
        $fileNo = $request->get('fileNo');

        if ($from || $to || $mem || $fileNo) {

            if ($from  != NULL && $to != NULL && $mem != NULL && $fileNo != NULL) {
                $from = date("Y-m-d", strtotime($request->from));
                $to = date("Y-m-d", strtotime($request->to));

                $installments = installment::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->orderBy('date', 'ASC')
                    ->get();
            } else if ($from  != NULL && $to != NULL && $mem == NULL && $fileNo != NULL) {
                $from = date("Y-m-d", strtotime($request->from));
                $to = date("Y-m-d", strtotime($request->to));
                $installments = installment::whereBetween('date', array($from, $to))
                    ->where('sale_no', $fileNo)
                    ->orderBy('date', 'ASC')
                    ->get();
            } else if ($from  != NULL && $to != NULL && $mem != NULL && $fileNo == NULL) {
                $from = date("Y-m-d", strtotime($request->from));
                $to = date("Y-m-d", strtotime($request->to));
                $installments = installment::whereBetween('date', array($from, $to))
                    ->where('sale_no', $fileNo)
                    ->orderBy('date', 'ASC')
                    ->get();
            } else if ($from  == NULL && $to == NULL && $mem != NULL && $fileNo == NULL) {
                // $from = date("Y-m-d", strtotime($request->from));
                // $to = date("Y-m-d", strtotime($request->to));
                $installments = installment::where('member_id', $mem)
                    ->orderBy('date', 'ASC')
                    ->get();
            } else if ($from  == NULL && $to == NULL && $mem == NULL && $fileNo != NULL) {
                $installments = installment::where('sale_no', $fileNo)
                    ->orderBy('date', 'ASC')
                    ->get();
            } else {
                Toastr::error('Something is wrong! :)', 'Danger');

                return redirect()->back();
            }
        } else {
            $installments = installment::all();
        }
        $company = Company::latest()->first();
        $members = Member::get();
        return view('report.installment', compact(
            'installments',
            'company',
            'from',
            'to',
            'mem',
            'fileNo',
            'members'
        ));
    }
}


// $from = date("Y-m-d", strtotime($request->from));
// $to = date("Y-m-d", strtotime($request->to));
// $installments = installment::whereBetween('date', array($from, $to))
//     ->orderBy('date', 'ASC')
//     ->paginate(20);