
<?php

namespace App\Http\Controllers;

use App\Account;
use App\Block;
use App\BookingAmount;
use App\BookingForm;
use App\CommisionPlan;
use App\Company;
use App\CustomInstallment;
use App\Events\SendSMS;
use GV9Jm2u7rmsCe65wKzPTw5jtS38n2tVEGiest;
use App\installment;
use App\Member;
use App\MoneyReceipt;
use App\Nominee;
use App\Plot;
use App\Reference;
use App\ReferenceIncome;
use App\Sale;
use App\SaleDetail;
use App\SaleDue;
use App\SmsCounter;
use App\SubMemeber;
use Brian2694\Toastr\Facades\Toastr;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Storage;

class MemberController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        if ($request->get('query')) {
            $query = $request->get('query');
            $members = Member::where('name', 'like', '%' . $query . '%')
                ->orWhere('hus_father', 'like', '%' . $query . '%')
                ->orWhere('mother', 'like', '%' . $query . '%')
                ->orWhere('serial_id', 'like', '%' . $query . '%')
                ->orWhere('email', 'like', '%' . $query . '%')
                ->orWhere('mobile', 'like', '%' . $query . '%')
                ->orWhere('nid', 'like', '%' . $query . '%')
                ->orderBy('id', 'DESC')
                ->paginate(20);
        } else {
            $members = Member::with('sales')->paginate(20);
        }
        return view('members.index', compact('members'));
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        $references = Reference::where('status', 0)->get();

        return view('members.create', compact('references'));
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        $request->validate([
            'name'               => ["required", "array", "min:1", "max:3"],
            'hus_father'         => ["required", "array", "min:1", "max:3"],
            'mother'             => ["required", "array", "min:1", "max:3"],
            'email'              => ["required", "array", "min:1", "max:3"],
            'birthday'           => ["required", "array", "min:1", "max:3"],
            'nid'                => ["required", "array", "min:1", "max:3"],
            'profession'         => ["required", "array", "min:1", "max:3"],
            'religion'           => ["required", "array", "min:1", "max:3"],
            'nationality'        => ["required", "array", "min:1", "max:3"],
            'present_address'    => ["required", "array", "min:1", "max:3"],
            'permanent_address'  => ["required", "array", "min:1", "max:3"],
            'mobile'             => ["required", "array", "min:1", "max:3"],
            'member_id'          => 'required',
            'reference_id'       => 'required',
            'password'             => 'required'

        ]);

        $path = '';
        if ($request->hasFile('picture')) {
            $path = Storage::disk('public')->put('members', $request->file('picture'));
        }
        $path2 = '';
        if ($request->hasFile('signature_image')) {
            $path2 = Storage::disk('public')->put('members', $request->file('signature_image'));
        }

        $member = new Member();

        foreach ($request->name as $key => $value) {
            if ($key === 0) {

                $member->name = $request->name[$key];
                $member->hus_father = $request->hus_father[$key];
                $member->nationality = $request->nationality[$key];
                $member->birthday = $request->birthday[$key];
                $member->mother = $request->mother[$key];
                $member->profession = $request->profession[$key];
                $member->religion = $request->religion[$key];
                $member->present_address = $request->present_address[$key];
                $member->permanent_address = $request->permanent_address[$key];
                $member->mobile = $request->mobile[$key];
                $member->email = $request->email[$key];
                $member->nid = $request->nid[$key];
                $member->picture = $path;
                $member->signature_image = $path2;

                $member->serial_id = $request->get('member_id');
                $member->reference_id = $request->reference_id;
                $member->password = $request->password;
                //dd($member);
                $member->save();
            }
            if ($key > 0) {
                $sub_member = new SubMemeber();

                $sub_member->name = $request->name[$key];
                $sub_member->member_id = $member->id;
                $sub_member->hus_father = $request->hus_father[$key];
                $sub_member->nationality = $request->nationality[$key];
                $sub_member->birthday = $request->birthday[$key];
                $sub_member->mother = $request->mother[$key];
                $sub_member->profession = $request->profession[$key];
                $sub_member->religion = $request->religion[$key];
                $sub_member->present_address = $request->present_address[$key];
                $sub_member->permanent_address = $request->permanent_address[$key];
                $sub_member->mobile = $request->mobile[$key];
                $sub_member->email = $request->email[$key];
                $sub_member->nid = $request->nid[$key];

                $sub_member->save();
            }
        }


        $to = $member->mobile;
        $message = "Dear "  . $member->name . ", Thanks For Joining With us. You have registered on our site https://dhhl.ltd .Plot owner registrated panal- Login email: " . $member->email . " | Password: " . $member->password . " | 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('Member Successfully Created :)', 'Success');
        return redirect()->back();
    }

    /**
     * Display the specified resource.
     *
     * @param  \App\Member  $member
     * @return \Illuminate\Http\Response
     */

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Member  $member
     * @return \Illuminate\Http\Response
     */
    public function edit(Member $member)
    {
        return view('members.edit', compact('member'));
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Member  $member
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, Member $member)
    {
        $picture = $member->picture;
        if ($request->hasFile('picture')) {
            $picture = Storage::disk('public')->put('members', $request->file('picture'));
        }
        $picture2 = $member->signature_image;
        if ($request->hasFile('signature_image')) {
            $picture2 = Storage::disk('public')->put('members', $request->file('signature_image'));
        }

        $member->name = $request->get('name');
        $member->hus_father = $request->get('hus_father');
        $member->mother = $request->get('mother');
        $member->birthday = $request->get('birthday');
        $member->nid = $request->get('nid');
        $member->nationality = $request->get('nationality');
        $member->religion = $request->get('religion');
        $member->profession = $request->get('profession');
        $member->email = $request->get('email');
        $member->present_address = $request->get('present_address');
        $member->permanent_address = $request->get('permanent_address');
        $member->mobile = $request->get('mobile');
        $member->picture = $picture;
        $member->signature_image = $picture2;
        $member->password = $request->get('password');

        if ($member->save()) {
            Toastr::success('Member updated successfully :)', 'Success');
            return redirect()->back();
        } else {
            Toastr::error('Something went wrong :(', 'Error');
            return redirect()->back();
        }
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Member  $member
     * @return \Illuminate\Http\Response
     */
    // public function delete_member(Member $member)
    // {

    //     //dd($member);
    //     if ($member->delete()) {

    //         Toastr::success('Member deleted successfully :)', 'Success');
    //         return redirect()->back();
    //     } else {
    //         Toastr::error('Something went wrong :(', 'Error');
    //         return redirect()->back();
    //     }
    // }

    public function delete_member($id)
    {
        //$member = Member::findOrFail($id);
        // dd($member);
        $member = new Member;
        $member = $member::find($id);

        $member->delete();
        Toastr::success('Member Deleted ! :)', 'Success');

        return redirect()->back();
    }
    public function profile()
    {
        $company = Company::latest()->first();
        $members = Member::get();

        //dd($member);
        return view('members.profile', compact('company', 'members'));
    }

    public function profileSearch(Request $request)
    {
        $company = Company::latest()->first();
        $member = Member::with(['sales', 'reference', 'installments', 'nominee'])->where('serial_id', $request->member_id)->first();
        if (!$member) {
            Toastr::error('No Member Found With This Member Id :(', 'Error');
            return redirect()->back();
        }
        $members = Member::get();
        return view('members.profile', compact('member', 'company', 'members'));
    }

    public function show(Member $member)
    {
        $company = Company::latest()->first();
        $member = Member::with(['subMembers', 'reference'])->where('id', $member->id)->first();
        $saleDeail = SaleDetail::where('member_id', $member->id)->get();


        $sal_paid = SaleDetail::where('member_id', $member->id)->sum('paid');

        $sal_due = SaleDetail::where('member_id', $member->id)->sum('due_amount');
        $due_ins = SaleDetail::where('member_id', $member->id)->sum('installment');
        $sale = Sale::where('member_id', $member->id)->orderBy('id', 'ASC')

            ->get();
        $sal_ins = Sale::where('member_id', $member->id)->sum('installment');
        $saleD = SaleDetail::get();
        $count = 0;
        foreach ($saleD as $saleD) {
            if ($saleD->member_id ==  $member->id)
                $count++;
        }
        $total_sale = $count;

        $nominee = Nominee::where('member_id', $member->id)->get();
        //  dd($nominee);

        return view('members.show', compact(
            'member',
            'company',
            'saleDeail',
            'sale',
            'total_sale',
            'sal_paid',
            'sal_due',
            'due_ins',
            'sal_ins',
            'nominee'

        ));
    }


    public function view($id)
    {
        $sale = Sale::where('id', $id)->first();
        $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', $id)
            ->orderBy('id', 'ASC')

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

        $salDetail = SaleDetail::where('sales_id', $id)->first();
        $company = Company::latest()->first();
        $count = BookingAmount::where('sales_id', $id)->count();
        //dd($count);
        $count = $count + 1;
        return view('members.view', compact(
            'reference',
            'company',
            'installment',
            'plot',
            'block',
            'salDetail',
            'sale',
            'member',
            'per',
            'book',
            'count'
        ));
    }
    public function print_type_one($id)
    {

        $company = Company::latest()->first();
        $sale = Sale::where('id', $id)->first();
        $member = Member::where('id', $sale->member_id)->first();
        $block = Block::where('id', $sale->block_id)->first();
        $plot = Plot::where('id', $sale->plot_id)->first();
        $rate = $plot->rate;
        $per = $rate / ($plot->plot_size);
        return view('members.print_type_one', compact(
            'member',
            'company',
            'block',
            'plot',
            'sale',
            'per'
        ));
    }
    public function print_type_two($id)
    {
        // dd("anika");
        $company = Company::latest()->first();
        $sale = Sale::where('id', $id)->first();
        $block = Block::where('id', $sale->block_id)->first();
        $nominee = Nominee::where('id', $sale->nominee_id)->first();
        $member = Member::where('id', $sale->member_id)->first();
        $plot = Plot::where('id', $sale->plot_id)->first();
        $rate = $plot->rate;
        $per = $rate / ($plot->plot_size);
        $booking = BookingForm::where('sale_id', $id)->first();
        $ref = Reference::where('id', $sale->reference_id)->first();
        // dd($booking);
        return view('members.print_type_two', compact(
            'member',
            'company',
            'block',
            'nominee',
            'plot',
            'ref',
            'booking',
            'id',
            'per',
            'sale'
        ));
    }


    public function store_form(Request $request, $id)
    {

        $book = BookingForm::where('sale_id', $id)->first();
        //dd($book);
        // $book->sale_id = $request->sale_id;

        $book->member_id = $request->member_id;
        $book->serial_id = $request->serial_id;
        $book->name = $request->name;
        $book->so = $request->so;
        $book->mother = $request->mother;
        $book->dob = $request->dob;
        $book->profession = $request->profession;
        $book->religion = $request->religion;
        $book->present_address = $request->present_address;
        $book->permanent_address = $request->permanent_address;
        $book->mobile = $request->mobile;
        $book->email = $request->email;
        $book->nationality = $request->nationality;
        $book->res = $request->res;
        $book->office = $request->office;
        $book->nationality = $request->nationality;


        $book->one = $request->one;
        $book->down_pay = $request->down_pay;
        $book->app_date = $request->app_date;
        $book->auth_date = $request->auth_date;
        $book->tk_word = $request->tk_word;
        $book->tk = $request->tk;
        $book->date = $request->date;
        $book->branch = $request->branch;
        $book->bank = $request->bank;
        $book->name_project = $request->name_project;
        $book->check_no = $request->check_no;

        $book->save();


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


    public function pay_installment($id)
    {
        $sale = Sale::with(['installments'])->where('id', $id)->first();

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

        $company =  installment::where('sales_id', $id)->sum('company_log');

        $refference =  installment::where('sales_id', $id)->sum('refference_log');

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

        $total_paid = $sale->paid + $paid;
        $due  = ($sale->due_amount + $sale->paid + $sale->discount)  - $total_paid;
        $member = Member::where('id', $sale->member_id)->first();

        return view('members.pay_installment', compact(

            'sale',
            'paid',
            'company',
            'refference',
            'sales',
            'total_paid',
            'due',
            'member'
        ));
    }
    public function store_installment(Request $request)
    {
        $request->validate([
            'member_id' => 'required',

            'sales_id' => 'required',
        ]);
        $installments = CustomInstallment::where('isDelete', 0)->where('saled_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));

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

        $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 = 0;
        $sale->company_log = $installment->amount + $pre_paid;
        // $sale->refference_log = $refference + $sale->refference_log;
        $sale->save();

        $plot = Plot::where('block_id', $b_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;
        $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. Number of remaining installments are " . 0 . ". Total Due amount " . $due . "TK";

        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 store_nominee(Request $request)
    {


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

        $sale->save();

        $nome = Nominee::where('id', $sale->nominee_id)->first();

        $nome->relation =  $request->relation;
        $nome->save();

        // //  dd($nome);
        // $book = BookingForm::where('sale_id', $request->id)->first();
        // $book->n_relation = $nome->relation;
        // $book->n_name = $nome->name;
        // $book->n_so = $nome->hus_father;
        // $book->n_address = $nome->address;
        // $book->n_nationality = $nome->nationality;
        // $book->n_dob = $nome->birthday;
        // $book->nominee_pic = $nome->picture;


        // $book->save();


        //return redirect()->back();
        return redirect()->route('admin.members.show', $member);
    }

    public function add_nominee($id)
    {


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

        $nominee = Nominee::where('member_id', $sale->member_id)->get();
        return view('members.add_nominee', compact(

            'sale',
            'nominee'
        ));
    }
    public function limitRand($start, $end)
    {
        return rand($start, $end);
    }


    public function money_reciept($id)
    {
        $money =  $this->limitRand(0000, 9999);
        $company = Company::latest()->first();
        $sale = Sale::where('id', $id)->first();
        $saleD = SaleDetail::where('sales_id', $id)->first();
        $member = Member::where('id', $sale->member_id)->first();
        $block = Block::where('id', $sale->block_id)->first();
        $plot = Plot::where('id', $sale->plot_id)->first();
        $ref = Reference::where('id', $sale->reference_id)->first();
        //  dd($sale);
        return view('members.money_reciept', compact(


            'company',
            'sale',
            'member',
            'block',
            'plot',
            'saleD',
            'ref',
            'money'
        ));
    }
    public function money_reciept_post(Request $request)
    {
        $money =  $this->limitRand(0000, 9999);
        $id = $request->sale_id;
        $serialNumber = $request->serail;

        $company = Company::latest()->first();
        $sale = Sale::where('id', $id)->first();
        $saleD = SaleDetail::where('sales_id', $id)->first();
        $member = Member::where('id', $sale->member_id)->first();
        $block = Block::where('id', $sale->block_id)->first();
        $plot = Plot::where('id', $sale->plot_id)->first();
        $ref = Reference::where('id', $sale->reference_id)->first();
        //  dd($sale);
        $moneyre = MoneyReceipt::where('sale_id', $id)->first();
        return view('members.money_reciept', compact(

            'serialNumber',
            'company',
            'sale',
            'member',
            'block',
            'plot',
            'saleD',
            'ref',
            'money',
            'moneyre'
        ));
    }
    public function money_reciept_booking(Request $request)
    {
        $money =  $this->limitRand(0000, 9999);
        $serialNumber = $request->serail;
        $company = Company::latest()->first();
        $sale = Sale::where('id', $request->id)->first();
        $saleD = SaleDetail::where('sales_id', $request->id)->first();
        $member = Member::where('id', $sale->member_id)->first();
        $block = Block::where('id', $sale->block_id)->first();
        $plot = Plot::where('id', $sale->plot_id)->first();
        $ref = Reference::where('id', $sale->reference_id)->first();
        $moneyre = MoneyReceipt::where('sale_id', $request->id)->first();
        return view('members.money_reciept_two', compact(


            'company',
            'sale',
            'member',
            'block',
            'plot',
            'saleD',
            'ref',
            'serialNumber',
            'money',
            'moneyre'
        ));
    }


    public function money_reciept_booking_amount(Request $request)
    {
        $money =  $this->limitRand(0000, 9999);
        $serialNumber = $request->serail;
        $booking = BookingAmount::where('id',  $request->id)->first();
        $sale_id = $booking->sales_id;
        $sale = Sale::where('id', $sale_id)->first();
        $saleD = SaleDetail::where('sales_id', $sale_id)->first();
        $member = Member::where('id', $booking->member_id)->first();
        $block = Block::where('id', $sale->block_id)->first();
        $plot = Plot::where('id', $sale->plot_id)->first();
        $ref = Reference::where('id', $sale->reference_id)->first();
        $company = Company::latest()->first();
        $moneyre = MoneyReceipt::where('booking_id', $request->id)->first();
        return view('members.money_reciept_booking_amount', compact(


            'company',
            'sale',
            'member',
            'block',
            'plot',
            'saleD',
            'ref',
            'booking',
            'serialNumber',
            'money',
            'moneyre'
        ));
    }


    public function money_reciept_installment(Request $request)
    {
        $money =  $this->limitRand(0000, 9999);
        $serialNumber = $request->serail;

        $install = installment::where('id',  $request->id)->first();

        $company = Company::latest()->first();
        $sale = Sale::where('id', $install->sales_id)->first();
        $saleD = SaleDetail::where('sales_id', $install->sales_id)->first();
        $member = Member::where('id', $install->member_id)->first();
        $block = Block::where('id', $sale->block_id)->first();
        $plot = Plot::where('id', $sale->plot_id)->first();
        $ref = Reference::where('id', $sale->reference_id)->first();
        $moneyre = MoneyReceipt::where('ins_id', $request->id)->first();
        return view('members.money_reciept_installment', compact(


            'company',
            'sale',
            'member',
            'block',
            'plot',
            'saleD',
            'install',
            'ref',
            'serialNumber',
            'money',
            'moneyre'
        ));
    }
}