
<?php

namespace App\Http\Controllers;

use DB;
use App\Account;
use App\Block;
use App\BookingAmount;
use App\BookingForm;
use App\CommisionPlan;
use App\Company;
use App\Events\SendSMS;
use App\installment;
use App\Member;
use App\MoneyReceipt;
use App\Nominee;
use App\Plot;
use App\Reference;
use App\ReferenceIncome;
use App\ReferenceWithdraw;
use App\Sale;
use App\SaleDetail;
use App\SmsCounter;
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(Request $request)
    {
        $salesI = Sale::get();
        $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));


                $sales = SaleDetail::orderBy('date', 'ASC')
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->whereBetween('date', array($from, $to))->get();

                $total = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('company_log');

                $total_due_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('due_amount');

                $total_booking_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('booking_amount');
                $total_install_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('install_amount');
                $total_ekkalin_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('ekkalin_amount');
            } 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));


                $sales = SaleDetail::orderBy('date', 'ASC')
                    ->where('sale_no', $fileNo)
                    ->whereBetween('date', array($from, $to))->get();

                $total = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('sale_no', $fileNo)
                    ->sum('company_log');

                $total_due_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('sale_no', $fileNo)
                    ->sum('due_amount');

                $total_paid_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('sale_no', $fileNo)
                    ->sum('paid');
                $total_booking_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('sale_no', $fileNo)
                    ->sum('booking_amount');
                $total_install_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('sale_no', $fileNo)
                    ->sum('install_amount');
                $total_ekkalin_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('sale_no', $fileNo)
                    ->sum('ekkalin_amount');
            } 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));


                $sales = SaleDetail::orderBy('date', 'ASC')
                    ->where('member_id', $mem)
                    ->whereBetween('date', array($from, $to))->get();

                $total = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->sum('company_log');

                $total_due_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->sum('due_amount');
                $total_paid_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->sum('paid');
                $total_booking_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->sum('booking_amount');
                $total_install_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->sum('install_amount');
                $total_ekkalin_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->sum('ekkalin_amount');
            } else if ($from  == NULL && $to == NULL && $mem == NULL && $fileNo != NULL) {


                $sales = SaleDetail::orderBy('date', 'ASC')
                    ->where('sale_no', $fileNo)
                    ->get();

                $total = SaleDetail::where('sale_no', $fileNo)
                    ->sum('company_log');

                $total_due_amount = SaleDetail::where('sale_no', $fileNo)
                    ->sum('due_amount');
                $total_paid_amount = SaleDetail::where('sale_no', $fileNo)
                    ->sum('paid');
                $total_booking_amount = SaleDetail::where('sale_no', $fileNo)
                    ->sum('booking_amount');
                $total_install_amount = SaleDetail::where('sale_no', $fileNo)
                    ->sum('install_amount');
                $total_ekkalin_amount = SaleDetail::where('sale_no', $fileNo)
                    ->sum('ekkalin_amount');
            } else if ($from  == NULL && $to == NULL && $mem != NULL && $fileNo == NULL) {


                $sales = SaleDetail::orderBy('date', 'ASC')
                    ->where('member_id', $mem)
                    ->get();

                $total = SaleDetail::where('member_id', $mem)

                    ->sum('company_log');

                $total_due_amount = SaleDetail::where('member_id', $mem)
                    ->sum('due_amount');
                $total_paid_amount = SaleDetail::where('member_id', $mem)
                    ->sum('paid');
                $total_booking_amount = SaleDetail::where('member_id', $mem)
                    ->sum('booking_amount');
                $total_install_amount = SaleDetail::where('member_id', $mem)
                    ->sum('install_amount');
                $total_ekkalin_amount = SaleDetail::where('member_id', $mem)
                    ->sum('ekkalin_amount');
            } 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));


                $sales = SaleDetail::orderBy('date', 'ASC')
                    ->whereBetween('date', array($from, $to))->get();

                $total = SaleDetail::whereBetween('date', array($from, $to))
                    ->sum('company_log');

                $total_due_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->sum('due_amount');
                $total_paid_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->sum('paid');
                $total_booking_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->sum('booking_amount');
                $total_install_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->sum('install_amount');
                $total_ekkalin_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->sum('ekkalin_amount');
            } else if ($from  == NULL && $to == NULL && $mem != NULL && $fileNo != NULL) {


                $sales = SaleDetail::orderBy('date', 'ASC')
                    ->where('member_id', $mem)->get();

                $total = SaleDetail::where('member_id', $mem)
                    ->sum('company_log');

                $total_due_amount = SaleDetail::where('member_id', $mem)
                    ->sum('due_amount');
                $total_paid_amount = SaleDetail::where('member_id', $mem)
                    ->sum('paid');
                $total_booking_amount = SaleDetail::where('member_id', $mem)
                    ->sum('booking_amount');
                $total_install_amount = SaleDetail::where('member_id', $mem)
                    ->sum('install_amount');
                $total_ekkalin_amount = SaleDetail::where('member_id', $mem)
                    ->sum('ekkalin_amount');
            } else {
                Toastr::error('Something is wrong! :)', 'Danger');

                return redirect()->back();
            }
        } else {
            $sales = SaleDetail::get();
            $total = SaleDetail::sum('company_log');
            $total_due_amount = SaleDetail::sum('due_amount');
            $total_paid_amount = SaleDetail::sum('paid');
            $total_booking_amount = SaleDetail::sum('booking_amount');
            $total_install_amount = SaleDetail::sum('install_amount');
            $total_ekkalin_amount = SaleDetail::sum('ekkalin_amount');
        }
        $company = Company::latest()->first();

        $members = Member::get();


        // $sales = Sale::with('member')
        //     ->orderBy('id', 'DESC')
        //     ->get();

        $company = Company::latest()->first();
        return view('sales.index', compact(


            'sales',
            'company',
            'total',
            'total_due_amount',
            'total_paid_amount',
            'total_booking_amount',
            'total_ekkalin_amount',
            'total_install_amount',
            'from',
            'to',
            'mem',
            'fileNo',
            'members',
            'salesI'
        ));
    }
    public function limitRand($start, $end)
    {
        return rand($start, $end);
    }
    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        $members = Member::select('serial_id', 'name', 'id')->get();
        $nominees = Nominee::get();

        $plots = Plot::where('quantity', '>', 0)
            ->where('status', 0)
            ->get();
        $money =  $this->limitRand(0000, 9999);
        return view('sales.create', compact('members', 'plots', 'money', 'nominees'));
    }

    /**
     * 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();

        $sale_plot = Sale::where('plot_id', $request->plot_id)->count();

        $plot_sale = Sale::where('plot_id', $request->plot_id)->first();

        $plot_member = Member::where('id', $request->member_id)->first();
        if ($plot->quantity > 0) {
            $member = Member::where('id', $request->member_id)->first();
            // dd($request->member_id);
            $serialID = $member->serial_id;
            $reference = Reference::where('id', $member->reference_id)->first();
            $r_id = $member->reference_id;
            $blk_id = $plot->block_id;

            $plan = CommisionPlan::where('block_id', $blk_id)->first();
            if (!$plan) {
                Toastr::success('commision plan is Not Available ! :)', 'Error');
                return redirect()->back();
            } else {

                $presale = Sale::get();


                $sale = new Sale();
                // if ($sale_plot > 0) {
                //     Toastr::error('Your Plot, Plot no: ' . $request->plot_no . ' face: ' . $plot->face . ' Road: ' . $plot->road . ' Size: ' . $plot->plot_size .

                //         ' has already been sold to  Member name: ' . $plot_member->name . ' File no: ' . $plot_sale->sale_no, 'Error');

                //     return redirect()->back();
                // }
                $dateChange = date("Y-m-d", strtotime($request->date));
                $sale->member_id = $request->member_id;
                $sale->reference_id = $r_id;
                $sale->nominee_id = $request->nominee_id;
                $sale->serial_id = $serialID;
                $sale->plot_id = $request->plot_id;

                $sale->plot_no = $request->plot_no;
                $sale->rate_per = $request->rate_per;
                $sale->total_rate = $request->total_rate;


                $sale->date = $dateChange;
                $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->member_id = $request->member_id;
                $sale->remark = $request->remark;
                $sale->money_rec = $request->money_rec;
                $sale->block_id = $blk_id;
                $sale->sale_no = $request->sale_no;
                $sale->target_booking = ($request->target_booking) * ($plot->plot_size);

                $sale->save();


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

                $sale_id = $sale->id;
                if (!($sale->installment)) {

                    $sale->status = 1;
                    $sale->save();

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

                    $plan = CommisionPlan::where('block_id', $blk_id)->first();
                    $ref = Reference::where('id', $id)->first();
                    $name = $ref->name;
                    $pay = $plan->ekkalin_amount;
                    $paid_am = $request->paid_amount;

                    $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 = $dateChange;
                    $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->company_log = $request->paid_amount;
                    $details->booking_amount = $plan->booking_amount;
                    $details->install_amount = $plan->installment_amount;
                    $details->ekkalin_amount = $plan->ekkalin_amount;
                    $details->sale_no = $request->sale_no;

                    $details->status = 0;
                    $details->total_rate = $request->total_rate;
                    //dd($details);
                    $total_target = ($request->target_booking) * ($plot->plot_size);
                    if ($total_target >= $request->paid_amount) {
                        $details->target_booking = ($total_target) - ($request->paid_amount);
                    } else {
                        $details->target_booking = 0;
                    }
                    //  $details->target_booking = ($request->target_booking) * ($plot->plot_size);

                    $details->money_rec = $request->money_rec;
                    $details->save();
                    //1= ek kalin; 2= booking,

                    $ri = new ReferenceIncome();
                    $ri->member_id = $member->id;
                    $ri->reference_id = $reference->id;
                    $ri->paid_amount =  $details->paid;
                    $ri->installment_amount =  $details->installment_amount;
                    $ri->booking_amount = $details->booking_amount;
                    $ri->installment_per_amount =   $details->install_amount;
                    $ri->ekkalin_per_amount =   $details->ekkalin_amount;
                    $ri->amount = ($pay * $paid_am) / 100;
                    $ri->sell_id =  $sale_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->rest_amount =  $ri->amount;
                    $ri->status =  1;
                    $ri->isDelete =  0;

                    $ri->save();
                    $account = new Account();
                    $account->reference_id = $reference->id;
                    $account->member_id =   $request->member_id;
                    $account->company_log = $details->paid;
                    $account->sell_id = $sale->id;

                    $account->save();

                    $bl = Block::where('id', $sale->block_id)->first();
                    $pt = Plot::where('id', $sale->plot_id)->first();
                    //$refd = Reference::where('id', $member->reference_id)->first();
                    $book = new BookingForm();
                    $book->sale_id = $sale_id;
                    $book->block = $bl->title;
                    $book->block_no = $bl->block_no;
                    $book->plot_no = $pt->plot_no;
                    $book->plot_size = $pt->plot_size;
                    $book->face = $pt->face;
                    $book->road = $pt->road;
                    $book->booking = $sale->paid;


                    $book->total_rate = $pt->rate;
                    $per =  $book->total_rate  / ($pt->plot_size);
                    $book->rate_per = $per;
                    $book->ins_no =  $sale->installment;
                    $book->ins_am =   $sale->installment_amount;
                    $book->file_no =   $sale->sale_no;

                    $book->member_id = $member->id;
                    $book->name = $member->name;
                    $book->so = $member->hus_father;

                    $book->mother = $member->mother;
                    $book->dob = $member->birthday;
                    $book->profession = $member->profession;
                    $book->religion = $member->religion;
                    $book->present_address = $member->present_address;
                    $book->permanent_address = $member->permanent_address;
                    $book->mobile = $member->mobile;
                    $book->email = $member->email;
                    $book->nationality = $member->nationality;
                    $book->serial_id = $member->serial_id;
                    $book->save();


                    $money = new  MoneyReceipt();
                    $money->sale_id = $sale_id;
                    $money->save();
                } else {
                    $sale->status = 2;
                    $sale->save();


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

                    $plan = CommisionPlan::where('block_id', $blk_id)->first();
                    $ref = Reference::where('id', $id)->first();

                    $name = $ref->name;
                    $pay_book = $plan->booking_amount;
                    $pay_katha = $plot->plot_size;
                    $pay = $pay_book * $pay_katha;
                    $paid_am = $request->paid_amount;

                    $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 = $dateChange;
                    $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->company_log = $request->paid_amount;
                    $details->booking_amount = $plan->booking_amount;
                    $details->install_amount = $plan->installment_amount;
                    $details->ekkalin_amount = $plan->ekkalin_amount;
                    $details->total_rate = $request->total_rate;
                    $details->sale_no = $request->sale_no;


                    $total_target = ($request->target_booking) * ($plot->plot_size);
                    if ($request->paid_amount ==  $request->total_rate || $total_target < $request->paid_amount) {
                        $details->target_booking = 0;
                    } else {
                        $details->target_booking = ($total_target) - ($request->paid_amount);
                    }

                    $details->money_rec = $request->money_rec;
                    $details->save();
                    $ri = new ReferenceIncome();
                    $ri->member_id = $member->id;
                    $ri->reference_id = $reference->id;

                    $ri->paid_amount = $details->paid;
                    $ri->installment_amount =  $details->installment_amount;
                    $ri->booking_amount = $details->booking_amount;
                    $ri->installment_per_amount =   $details->install_amount;
                    $ri->ekkalin_per_amount =   $details->ekkalin_amount;
                    $ri->amount =  $pay;

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

                    $ri->sell_id =  $sale_id;
                    $ri->plot_size =   $plot->plot_size;
                    $ri->face =  $plot->face;
                    $ri->road =  $plot->road;
                    $ri->status =  2;
                    $ri->isDelete =  0;

                    $ri->rest_amount =  $ri->amount;
                    $ri->save();
                    $account = new Account();
                    $account->member_id =   $request->member_id;
                    $account->company_log = $request->paid_amount;
                    $account->reference_id = $reference->id;
                    $account->sell_id = $sale->id;
                    $account->save();


                    $bl = Block::where('id', $sale->block_id)->first();
                    $pt = Plot::where('id', $sale->plot_id)->first();
                    $book = new BookingForm();
                    $book->sale_id = $sale_id;
                    $book->block = $bl->title;
                    $book->block_no = $bl->block_no;
                    $book->plot_no = $pt->plot_no;
                    $book->plot_size = $pt->plot_size;
                    $book->face = $pt->face;
                    $book->road = $pt->road;
                    $book->booking = $sale->paid;


                    $book->total_rate = $pt->rate;
                    $per =  $book->total_rate  / ($pt->plot_size);
                    $book->rate_per = $per;
                    $book->ins_no =  $sale->installment;
                    $book->ins_am =   $sale->installment_amount;
                    $book->file_no =   $sale->sale_no;

                    $book->member_id = $member->id;
                    $book->name = $member->name;
                    $book->so = $member->hus_father;

                    $book->mother = $member->mother;
                    $book->dob = $member->birthday;
                    $book->profession = $member->profession;
                    $book->religion = $member->religion;
                    $book->present_address = $member->present_address;
                    $book->permanent_address = $member->permanent_address;
                    $book->mobile = $member->mobile;
                    $book->email = $member->email;
                    $book->nationality = $member->nationality;
                    $book->serial_id = $member->serial_id;
                    $book->save();

                    $money = new  MoneyReceipt();
                    $money->sale_id = $sale_id;
                    $money->save();
                }
                $to = $member->mobile;
                $message = "Dear " . $member->name . ", You paid " . $sale->paid . " TK and Due amount " . $sale->due_amount . " TK for File No: " . $sale->sale_no . " Plot owner Login panel link: https://soft.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('Susseccesfully sold ! :) ', 'Success');
                return redirect()->route('admin.sale.show', $sale->id);
            }
        } else {
            Toastr::error('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);

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

        $block_id = $sale->block_id;
        $block = Block::where('id', $block_id)->first();

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

        $ref_id = $member->reference_id;
        $reference = Reference::where('id', $ref_id)->first();

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

        $salDetail = SaleDetail::where('sales_id', $id)->first();

        $company = Company::latest()->first();
        $book = BookingAmount::where('sales_id', $id)->get();


        return view('sales.show', compact(
            'reference',
            'company',
            'installment',
            'plot',
            'block',
            'salDetail',
            'sale',
            'member',
            'book'

        ));
    }

    /**
     * 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',
        ]);
        $plot = Plot::where('id', $request->plot_id)->first();
        $member = Member::where('id', $request->member_id)->first();
        $reference = Reference::where('id', $member->reference_id)->first();
        $id_r = $member->reference_id;
        $blk_id = $plot->block_id;
        $plan = CommisionPlan::where('block_id', $blk_id)->first();
        if (!$plan) {
            Toastr::error('commision plan is Not Available ! :)', 'Error');
            return redirect()->back();
        } else {

            $sale = Sale::where('id', $id)->first();

            $sale->member_id = $request->member_id;
            $sale->reference_id = $id_r;
            $sale->serial_id = $member->serial_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->remark = $request->remark;
            $sale->save();
            $sale_id = $sale->id;
            if (!($sale->installment)) {
                $member = Member::where('id', $request->member_id)->first();
                $ref = $member->reference_id;
                $blk_id = $plot->block_id;

                $plan = CommisionPlan::where('block_id', $blk_id)->first();
                $ref = Reference::where('id', $ref)->first();
                $name = $ref->name;
                $pay = $plan->ekkalin_amount;
                $paid_am = $request->paid_amount;

                $details = SaleDetail::where('sales_id', $sale_id)->first();

                $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->company_log = $request->paid_amount;
                $details->total_rate = $request->paid_amount;
                $details->booking_amount = $plan->booking_amount;
                $details->install_amount = $plan->installment_amount;
                $details->ekkalin_amount = $plan->ekkalin_amount;

                $details->save();

                //1= ek kalin; 2= booking,

                $ri =  ReferenceIncome::where('sell_id', $sale_id)->first();
                $ri->member_id = $member->id;
                $ri->reference_id = $reference->id;
                $ri->paid_amount =  $details->paid;
                $ri->installment_amount =  $details->installment_amount;
                $ri->booking_amount = $details->booking_amount;
                $ri->installment_per_amount =   $details->install_amount;
                $ri->ekkalin_per_amount =   $details->ekkalin_amount;
                $ri->amount = ($pay * $paid_am) / 100;
                $ri->sell_id =  $sale_id;
                $ri->block_id = $plan->block_id;
                $ri->block_name =   $plan->block_title;
                $ri->katha =  $plan->katha;
                $ri->rest_amount =  $ri->amount;
                $ri->plot_size =   $plot->plot_size;
                $ri->face =  $plot->face;
                $ri->road =  $plot->road;
                $ri->status =  1;
                $ri->isDelete =  0;
                $ri->save();

                $account =  Account::where('sell_id', $sale_id)->first();
                $account->member_id =   $request->member_id;
                $account->company_log = $request->paid_amount;
                $account->reference_id = $reference->id;
                $account->sell_id = $sale_id;
                $account->save();
            } else {

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

                $plan = CommisionPlan::where('block_id', $blk_id)->first();
                $ref = Reference::where('id', $id)->first();
                $member->block_id = $blk_id;
                $member->save();
                $name = $ref->name;
                $pay_book = $plan->booking_amount;
                $pay_katha = $plan->katha;
                $pay = $pay_book * $pay_katha;
                $paid_am = $request->paid_amount;


                $sale_id = $sale->id;
                $details = SaleDetail::where('sales_id', $sale_id)->first();

                $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->company_log = $request->paid_amount;
                $details->booking_amount = $plan->booking_amount;
                $details->install_amount = $plan->installment_amount;
                $details->ekkalin_amount = $plan->ekkalin_amount;

                $details->save();

                $ri =  ReferenceIncome::where('sell_id', $sale_id)->first();
                $mem_id = $member->id;

                $ri->member_id = $mem_id;
                $ri->reference_id = $reference->id;
                $ri->paid_amount = $details->paid;
                $ri->installment_amount =  $details->installment_amount;
                $ri->booking_amount = $details->booking_amount;
                $ri->installment_per_amount =   $details->install_amount;
                $ri->ekkalin_per_amount =   $details->ekkalin_amount;
                $ri->amount =  $pay;
                $ri->rest_amount =  $ri->amount;
                $ri->block_id = $plan->block_id;
                $ri->block_name =   $plan->block_title;
                $ri->katha =  $plan->katha;
                $ri->sell_id =  $sale_id;
                $ri->plot_size =   $plot->plot_size;
                $ri->face =  $plot->face;
                $ri->road =  $plot->road;
                $ri->status =  2;
                $ri->isDelete =  0;

                $ri->save();

                $account =  Account::where('sell_id', $sale_id)->first();
                $account->member_id =   $request->member_id;
                $account->company_log = $request->paid_amount;
                $account->reference_id = $reference->id;
                $account->sell_id = $sale_id;
                $account->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->status_del = 1;
        $sale->save();
        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(Request $request)
    {
        //$sales = SaleDetail::get();
        $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));


                $sales = SaleDetail::orderBy('date', 'ASC')
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->whereBetween('date', array($from, $to))->get();

                $total = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('company_log');

                $total_due_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('due_amount');

                $total_booking_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('booking_amount');
                $total_install_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('install_amount');
                $total_ekkalin_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('ekkalin_amount');

                $ref_amount = ReferenceIncome::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->where('file_no', $fileNo)
                    ->sum('rest_amount');
                $ref_with = ReferenceWithdraw::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->where('file_no', $fileNo)
                    ->sum('amount');
            } 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));


                $sales = SaleDetail::orderBy('date', 'ASC')
                    ->where('sale_no', $fileNo)
                    ->whereBetween('date', array($from, $to))->get();

                $total = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('sale_no', $fileNo)
                    ->sum('company_log');

                $total_due_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('sale_no', $fileNo)
                    ->sum('due_amount');

                $total_paid_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('sale_no', $fileNo)
                    ->sum('paid');
                $total_booking_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('sale_no', $fileNo)
                    ->sum('booking_amount');
                $total_install_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('sale_no', $fileNo)
                    ->sum('install_amount');
                $total_ekkalin_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('sale_no', $fileNo)
                    ->sum('ekkalin_amount');

                $ref_amount = ReferenceIncome::whereBetween('date', array($from, $to))

                    ->where('file_no', $fileNo)
                    ->sum('rest_amount');
                $ref_with = ReferenceWithdraw::whereBetween('date', array($from, $to))

                    ->where('file_no', $fileNo)
                    ->sum('amount');
            } 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));


                $sales = SaleDetail::orderBy('date', 'ASC')
                    ->where('member_id', $mem)
                    ->whereBetween('date', array($from, $to))->get();

                $total = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->sum('company_log');

                $total_due_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->sum('due_amount');
                $total_paid_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->sum('paid');
                $total_booking_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->sum('booking_amount');
                $total_install_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->sum('install_amount');
                $total_ekkalin_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->sum('ekkalin_amount');

                $ref_amount = ReferenceIncome::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)

                    ->sum('rest_amount');
                $ref_with = ReferenceWithdraw::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)

                    ->sum('amount');
            } else if ($from  == NULL && $to == NULL && $mem == NULL && $fileNo != NULL) {


                $sales = SaleDetail::orderBy('date', 'ASC')
                    ->where('sale_no', $fileNo)
                    ->get();

                $total = SaleDetail::where('sale_no', $fileNo)
                    ->sum('company_log');

                $total_due_amount = SaleDetail::where('sale_no', $fileNo)
                    ->sum('due_amount');
                $total_paid_amount = SaleDetail::where('sale_no', $fileNo)
                    ->sum('paid');
                $total_booking_amount = SaleDetail::where('sale_no', $fileNo)
                    ->sum('booking_amount');
                $total_install_amount = SaleDetail::where('sale_no', $fileNo)
                    ->sum('install_amount');
                $total_ekkalin_amount = SaleDetail::where('sale_no', $fileNo)
                    ->sum('ekkalin_amount');

                $ref_amount = ReferenceIncome::where('file_no', $fileNo)
                    ->sum('rest_amount');
                $ref_with = ReferenceWithdraw::where('file_no', $fileNo)
                    ->sum('amount');
            } else if ($from  == NULL && $to == NULL && $mem != NULL && $fileNo == NULL) {


                $sales = SaleDetail::orderBy('date', 'ASC')
                    ->where('member_id', $mem)
                    ->get();

                $total = SaleDetail::where('member_id', $mem)

                    ->sum('company_log');

                $total_due_amount = SaleDetail::where('member_id', $mem)
                    ->sum('due_amount');
                $total_paid_amount = SaleDetail::where('member_id', $mem)
                    ->sum('paid');
                $total_booking_amount = SaleDetail::where('member_id', $mem)
                    ->sum('booking_amount');
                $total_install_amount = SaleDetail::where('member_id', $mem)
                    ->sum('install_amount');
                $total_ekkalin_amount = SaleDetail::where('member_id', $mem)
                    ->sum('ekkalin_amount');
                $ref_amount = ReferenceIncome::where('member_id', $mem)

                    ->sum('rest_amount');
                $ref_with = ReferenceWithdraw::where('member_id', $mem)

                    ->sum('amount');
            } 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));


                $sales = SaleDetail::orderBy('date', 'ASC')
                    ->whereBetween('date', array($from, $to))->get();

                $total = SaleDetail::whereBetween('date', array($from, $to))
                    ->sum('company_log');

                $total_due_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->sum('due_amount');
                $total_paid_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->sum('paid');
                $total_booking_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->sum('booking_amount');
                $total_install_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->sum('install_amount');
                $total_ekkalin_amount = SaleDetail::whereBetween('date', array($from, $to))
                    ->sum('ekkalin_amount');
                $ref_amount = ReferenceIncome::whereBetween('date', array($from, $to))

                    ->sum('rest_amount');
                $ref_with = ReferenceWithdraw::whereBetween('date', array($from, $to))

                    ->sum('amount');
            } else if ($from  == NULL && $to == NULL && $mem != NULL && $fileNo != NULL) {


                $sales = SaleDetail::orderBy('date', 'ASC')
                    ->where('sale_no', $fileNo)
                    ->where('member_id', $mem)->get();

                $total = SaleDetail::where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('company_log');

                $total_due_amount = SaleDetail::where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('due_amount');
                $total_paid_amount = SaleDetail::where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('paid');
                $total_booking_amount = SaleDetail::where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('booking_amount');
                $total_install_amount = SaleDetail::where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('install_amount');
                $total_ekkalin_amount = SaleDetail::where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('ekkalin_amount');
                $ref_amount = ReferenceIncome::where('member_id', $mem)
                    ->where('file_no', $fileNo)
                    ->sum('rest_amount');
                $ref_with = ReferenceWithdraw::where('member_id', $mem)
                    ->where('file_no', $fileNo)
                    ->sum('amount');
            } else {
                Toastr::error('Something is wrong! :)', 'Danger');

                return redirect()->back();
            }
        } else {
            $sales = SaleDetail::get();
            $total = SaleDetail::sum('company_log');
            $total_due_amount = SaleDetail::sum('due_amount');
            $total_paid_amount = SaleDetail::sum('paid');
            $total_booking_amount = SaleDetail::sum('booking_amount');
            $total_install_amount = SaleDetail::sum('install_amount');
            $total_ekkalin_amount = SaleDetail::sum('ekkalin_amount');
            $ref_amount = ReferenceIncome::sum('rest_amount');
            $ref_with = ReferenceWithdraw::sum('amount');
        }
        $company = Company::latest()->first();

        $members = Member::get();


        return view('sales.list', compact(
            'sales',
            'company',
            'total',
            'total_due_amount',
            'total_paid_amount',
            'total_booking_amount',
            'total_ekkalin_amount',
            'total_install_amount',
            'from',
            'to',
            'mem',
            'fileNo',
            'members',
            'ref_amount',
            'ref_with'


        ));
    }


    // if ($from || $to) {
    //     $from = date("Y-m-d", strtotime($request->from));
    //     $to = date("Y-m-d", strtotime($request->to));
    //     $sales = SaleDetail::orderBy('date', 'ASC')
    //         ->whereBetween('date', array($from, $to))
    //         ->paginate(20);
    //     $total = SaleDetail::whereBetween('date', array($from, $to))
    //         ->sum('company_log');

    //     $total_due_amount = SaleDetail::whereBetween('date', array($from, $to))
    //         ->sum('due_amount');

    //     $total_booking_amount = SaleDetail::sum('booking_amount');
    //     $total_install_amount = SaleDetail::sum('install_amount');
    //     $total_ekkalin_amount = SaleDetail::sum('ekkalin_amount');
    // } else {
    //     $sales = SaleDetail::get();
    //     $total = SaleDetail::sum('company_log');
    //     $total_due_amount = SaleDetail::sum('due_amount');

    //     $total_booking_amount = SaleDetail::sum('booking_amount');
    //     $total_install_amount = SaleDetail::sum('install_amount');
    //     $total_ekkalin_amount = SaleDetail::sum('ekkalin_amount');
    // }

    public function show_list($id)

    {

        $salDetail = SaleDetail::where('sales_id', $id)->first();

        $sal_id = $salDetail->sales_id;

        $sale = Sale::findOrFail($sal_id);

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

        $block_id = $sale->block_id;

        $block = Block::where('id', $block_id)->first();

        $plot = Plot::where('id', $sale->plot_id)->first();
        $rate = $plot->rate;
        $per = $rate / ($plot->plot_size);
        $ref_id = $member->reference_id;
        $reference = Reference::where('id', $ref_id)->first();

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


        $company = Company::latest()->first();
        $book = BookingAmount::where('sales_id', $id)->get();

        return view('sales.show_list', compact(
            'reference',
            'company',
            'installment',
            'plot',
            'block',
            'salDetail',
            'sale',
            'member',
            'per',
            'book'
        ));
    }
    public function delete_list($id)
    {

        $sales = new SaleDetail();
        $sale = $sales::find($id);
        $sale->status = 1;
        $sale->save();
        Toastr::success('sale details Deleted ! :)', 'Success');

        return redirect()->back();
    }

    public function booking_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) {

            //dd($mem);

            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));
                $sales = Sale::orderBy('date', 'ASC')
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->whereBetween('date', array($from, $to))->get();

                $book_am = BookingAmount::orderBy('date', 'ASC')
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->whereBetween('date', array($from, $to))->get();
                $total = Sale::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('paid');
                $total_book = BookingAmount::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('amount');
            } 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));
                $sales = Sale::orderBy('date', 'ASC')
                    ->where('sale_no', $fileNo)
                    ->whereBetween('date', array($from, $to))->get();

                $book_am = BookingAmount::orderBy('date', 'ASC')
                    ->where('sale_no', $fileNo)
                    ->whereBetween('date', array($from, $to))->get();
                $total = Sale::whereBetween('date', array($from, $to))
                    ->where('sale_no', $fileNo)
                    ->sum('paid');
                $total_book = BookingAmount::whereBetween('date', array($from, $to))
                    ->where('sale_no', $fileNo)
                    ->sum('amount');
            } 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));
                $sales = Sale::orderBy('date', 'ASC')
                    ->where('member_id', $mem)

                    ->whereBetween('date', array($from, $to))->get();

                $book_am = BookingAmount::orderBy('date', 'ASC')
                    ->where('member_id', $mem)

                    ->whereBetween('date', array($from, $to))->get();
                $total = Sale::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)

                    ->sum('paid');
                $total_book = BookingAmount::whereBetween('date', array($from, $to))
                    ->where('member_id', $mem)
                    ->sum('amount');
            } 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));
                $sales = Sale::orderBy('date', 'ASC')
                    ->where('member_id', $mem)

                    ->get();

                $book_am = BookingAmount::orderBy('date', 'ASC')
                    ->where('member_id', $mem)

                    ->get();
                $total = Sale::where('member_id', $mem)

                    ->sum('paid');
                $total_book = BookingAmount::where('member_id', $mem)
                    ->sum('amount');
            } 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));
                $sales = Sale::orderBy('date', 'ASC')
                    ->where('sale_no', $fileNo)
                    ->get();

                $book_am = BookingAmount::orderBy('date', 'ASC')
                    ->where('sale_no', $fileNo)
                    ->get();
                $total = Sale::where('sale_no', $fileNo)

                    ->sum('paid');
                $total_book = BookingAmount::where('sale_no', $fileNo)
                    ->sum('amount');
            } 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));
                $sales = Sale::orderBy('date', 'ASC')

                    ->whereBetween('date', array($from, $to))->get();

                $book_am = BookingAmount::orderBy('date', 'ASC')

                    ->whereBetween('date', array($from, $to))->get();
                $total = Sale::whereBetween('date', array($from, $to))

                    ->sum('paid');
                $total_book = BookingAmount::whereBetween('date', array($from, $to))
                    ->sum('amount');
            } 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));
                $sales = Sale::orderBy('date', 'ASC')
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->get();

                $book_am = BookingAmount::orderBy('date', 'ASC')
                    ->where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->get();
                $total = Sale::where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('paid');
                $total_book = BookingAmount::where('member_id', $mem)
                    ->where('sale_no', $fileNo)
                    ->sum('amount');
            } else {

                Toastr::error('Something is wrong! :)', 'Danger');

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

            $sales = Sale::get();
            $book_am = BookingAmount::get();
            $total = Sale::sum('paid');
            $total_book = BookingAmount::sum('amount');
        }
        $company = Company::latest()->first();
        $members = Member::get();
        return view('report.booking', compact(
            'sales',
            'company',
            'total',
            'from',
            'to',
            'mem',
            'book_am',
            'total_book',
            'members',
            'fileNo'
        ));
    }

    public function marketier_commission(Request $request)
    {
        $from = $request->get('from');
        $to = $request->get('to');


        if ($from || $to) {

            $withdraws = ReferenceWithdraw::whereBetween('created_at', array($from, $to))
                ->orderBy('id', 'DESC')
                ->paginate(20);
        } else {
            $withdraws = ReferenceWithdraw::orderBy('id', 'DESC')->get();
        }

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


        return view('report.marketier', compact('withdraws', 'company', 'total'));
    }


    // public function check_number_code(Request $request)
    // {
    //     $NumberCode = $request->get('NumberCode');
    //     $db = Sale::where('plot_no', $NumberCode)->count();
    //     if ($db > 0) {
    //         $sale = Sale::where('plot_no', $NumberCode)->first();
    //         $plot = PLot::where('id', $sale->plot_id)->first();
    //         $member = Member::where('id', $sale->member_id)->first();

    //         return view('sales.code_alert_error', compact('plot', 'sale', 'member'));
    //     } else {

    //         return view('sales.code_alert_success');
    //     }
    // }

    // public function check_commision_code(Request $request)
    // {
    //     $NumberCode = $request->get('NumberCode');
    //     //
    //     $plot_id = $request->get('plot_id');
    //     $db = Sale::where('plot_id', $plot_id)->count();
    //     if ($db > 0) {
    //         $presale = Sale::where('plot_id', $plot_id)->get();
    //         foreach ($presale as $presale) {
    //             if ($presale->plot_id ==   $plot_id && $presale->plot_no ==    $NumberCode) {
    //                 return view('sales.code_alert_error');
    //             }
    //         }
    //     } else {

    //         return view('sales.code_alert_success');
    //     }
    // }

    public function check_number_code(Request $request)
    {
        $NumberCode = $request->get('NumberCode');

        $pt = $request->get('plot_id');
        $presale = Sale::where('plot_id', $pt)->get();
        $db = Sale::where('plot_id', $pt)
            ->where('plot_no', $NumberCode)
            ->count();
        //dd($db);
        if ($db > 0) {
            $sale = Sale::where('plot_no', $NumberCode)
                ->where('plot_id', $pt)
                ->first();
            $plot = PLot::where('id', $sale->plot_id)->first();
            $member = Member::where('id', $sale->member_id)->first();

            return view('sales.code_alert_error', compact('plot', 'sale', 'member', 'NumberCode'));
        } else {
            return view('sales.code_alert_success');
        }
    }
}