
<?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\CustomBooking;
use App\CustomInstallment;
use App\DemoInstallment;
use App\installment;
use App\Member;
use App\Nominee;
use App\Plot;
use App\Reference;
use App\ReferenceIncome;
use App\Sale;
use App\SaleDetail;
use Illuminate\Http\Request;
use Session;
use Brian2694\Toastr\Facades\Toastr;
use Illuminate\Support\Facades\Storage;
use App\Events\SendSMS;
use App\SmsCounter;

class MemberManageController extends Controller
{

    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $memberID = Session::get('memberID');

        $paid = SaleDetail::where('member_id', $memberID)->sum('paid');
        $due = SaleDetail::where('member_id', $memberID)->sum('due_amount');
        $total = Sale::where('member_id', $memberID)->count();
        $total_ins = Sale::where('member_id', $memberID)->sum('installment');
        $due_ins = SaleDetail::where('member_id', $memberID)->sum('installment');

        $baynas = '';
        $company = '';
        return view('otherusers.customar.dashboard', compact(
            'baynas',
            'company',
            'paid',

            'due',
            'total',
            'total_ins',
            'due_ins'
        ));
    }

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

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        //
    }


    public function member_profile()
    {
        $memberID = Session::get('memberID');


        $paid = SaleDetail::where('member_id', $memberID)->sum('paid');
        $due = SaleDetail::where('member_id', $memberID)->sum('due_amount');
        $total = Sale::where('member_id', $memberID)->count();
        $total_ins = Sale::where('member_id', $memberID)->sum('installment');
        $due_ins = SaleDetail::where('member_id', $memberID)->sum('installment');


        $company = Company::latest()->first();
        $member = Member::with(['subMembers', 'reference'])->where('id', $memberID)->first();
        $saleDeail = SaleDetail::where('member_id', $member->id)->get();
        $sale = Sale::where('member_id', $member->id)->orderBy('id', 'ASC')

            ->get();
        $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();
        return view('otherusers.customar.member_profile', compact(
            'member',
            'company',
            'saleDeail',
            'sale',
            'total_sale',
            'paid',
            'due',
            'due_ins',
            'total_ins',
            'nominee'

        ));
    }
    public function view_details($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('otherusers.customar.view_details', compact(
            'reference',
            'company',
            'installment',
            'plot',
            'block',
            'salDetail',
            'sale',
            'member',
            'per',
            'book',
            'count'
        ));
    }
    public function member_plot()
    {
        $memberID = Session::get('memberID');
        $sale = Sale::where('member_id', $memberID)->orderBy('id', 'ASC')

            ->get();
        $member = Member::where('id', $memberID)->first();
        $company = Company::latest()->first();
        // $block_id = $member->block_id;
        // $plot = Plot::where('block_id', $block_id)->first();
        // $block = Block::where('id', $block_id)->first();
        return view('otherusers.customar.member_plot', compact('sale', 'company'));
    }
    public function member_installment()
    {
        $memberID = Session::get('memberID');
        $sale = Sale::where('member_id', $memberID)->orderBy('id', 'ASC')

            ->get();
        // $install = installment::where('member_id', $memberID)->get();

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

        return view('otherusers.customar.member_installment', compact('company', 'sale'));
    }
    public function member_reference()
    {
        $memberID = Session::get('memberID');
        $member = Member::where('id', $memberID)->first();

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

        return view('otherusers.customar.member_reference', compact('reference', 'company'));
    }
    public function print_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('otherusers.customar.print_one', compact(
            'member',
            'company',
            'block',
            'plot',
            'sale',
            'per'
        ));
    }
    public function print_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);
        // return view('otherusers.customar.print_two', compact(
        //     'member',
        //     'company',
        //     'nominee',
        //     'block',
        //     'plot',
        //     'sale',
        //     'per'
        // ));
        $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();
        return view('otherusers.customar.print_two', compact(
            'member',
            'company',
            'block',
            'nominee',
            'plot',
            'ref',
            'booking',
            'id',
            'per',
            'sale'
        ));
    }


    public function search_installment(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('otherusers.customar.member_pay', compact('request', 'member', 'sale'));
        }
    }
    public function member_pay()
    {

        $memberID = Session::get('memberID');
        $member = Member::with(['sales', 'installments'])->where('id', $memberID)->first();
        $sale = Sale::with(['installments'])->where('serial_id', $member->serial_id)
            ->orderBy('id', 'ASC')

            ->get();
        return view('otherusers.customar.member_pay', compact('member', 'sale', 'memberID'));
    }
    public function custom_booking(Request $request)
    {

        $booking = CustomBooking::where('isDelete', 0)->where('sales_id', $request->sales_id)->where('member_id', $request->member_id)->get();
        if ($booking->isEmpty()) {
        } else {
            return view('otherusers.customar.pending_msg');
        }

        $picture = '';

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


        $CustomBooking = new CustomBooking();

        $dateChange = date("Y-m-d", strtotime($request->date_a));
        $CustomBooking->member_id = $request->member_id;
        $CustomBooking->serial_id = $request->serial_id;
        $CustomBooking->sales_id = $request->sales_id;
        $CustomBooking->amount = $request->amount;
        $CustomBooking->date = $dateChange;
        $CustomBooking->image = $picture;


        $paid_s = BookingAmount::where('sales_id', $CustomBooking->sales_id)->sum('amount');
        $sale = SaleDetail::where('sales_id', $request->sales_id)->first();
        $sales = Sale::where('id', $request->sales_id)->first();
        $CustomBooking->due = $sale->target_booking - $request->amount;

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

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

        $CustomBooking->reference_id = $ref_id;
        $CustomBooking->money_rec = $request->money_rec;
        $CustomBooking->remark = $request->remark;
        $CustomBooking->company_log = $CustomBooking->amount + $pre_paid;
        $CustomBooking->due = $sale->target_booking - $request->amount;
        $CustomBooking->isDelete = 0;
        //dd($CustomBooking);
        $CustomBooking->save();

        $to = $member->mobile;
        $message = "Dear " . $member->name . ", You have sent an request of paying an booking amount of " . $CustomBooking->amount . " Tk. to the admin.";

        event(new SendSMS($to, $message));
        $sms = new SmsCounter();
        $sms->mobile = $member->mobile;
        $sms->sms = $message;
        $sms->total = 5000;
        $sms->save();
        return redirect()->back()->with('message', 'booking amount request has been successfully sent to admin panal :)');
    }
    public function store_demo_installment(Request $request)
    {
        $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('otherusers.customar.pending_msg');
        }
        //dd($request->hasFile('image'));
        $picture = '';
        if ($request->hasFile('image')) {
            $picture = Storage::disk('public')->put('members', $request->file('image'));
        }
        //dd($picture);
        $installment = new DemoInstallment();
        $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;

        $paid_s = installment::where('sales_id', $installment->sales_id)->sum('amount');
        $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 = $request->get('install');
        $b_id = $sales->block_id;
        $plan = CommisionPlan::where('block_id', $b_id)->first();
        $pay = $installment->amount;
        $paid_am = $plan->installment_amount;


        $member = Member::where('id', $request->member_id)->first();
        $ref_id = $member->reference_id;
        $paid_installment_count = installment::where('sales_id', $installment->sales_id)->count();
        $total_paid = $sales->paid + $paid_s;
        $due  = ($sales->due_amount + $sales->paid + $sales->discount)  - $total_paid;

        $remain_installment = $sales->installment - $paid_installment_count;
        $installment->reference_id = $ref_id;
        $installment->money_rec = $request->money_rec;
        $installment->remark = $request->remark;
        $installment->company_log = $pay;
        $installment->due = $sale->due_amount - $request->amount;
        $installment->ins_no = $request->get('install');
        $installment->via = $request->via;
        $installment->account_no = $request->account_no;
        $installment->bank_name = $request->bank_name;
        $installment->image = $picture;
        $installment->isDelete = 0;

        $installment->save();

        $to = $member->mobile;
        $message = "Dear " . $member->name . ", You have sent an request of paying an installment of " . $installment->amount . " Tk. to the admin.";

        event(new SendSMS($to, $message));
        $sms = new SmsCounter();
        $sms->mobile = $member->mobile;
        $sms->sms = $message;
        $sms->total = 5000;
        $sms->save();
        return redirect()->back()->with('message', 'Installment request has been successfully sent to admin panal :)');
    }
    public function approved_list()
    {
        $memberID = Session::get('memberID');
        $installments = DemoInstallment::where('isDelete', 1)
            ->where('member_id', $memberID)
            ->get();

        $installment_C = CustomInstallment::where('isDelete', 1)->get();
        $company = Company::latest()->first();

        return view('otherusers.customar.approved_list', compact('installments',  'company', 'installment_C'));
    }
    public function rejected_list()
    {
        $memberID = Session::get('memberID');
        $installments = DemoInstallment::where('isDelete', 2)
            ->where('member_id', $memberID)
            ->get();
        $company = Company::latest()->first();
        $installment_C = CustomInstallment::where('isDelete', 2)->get();
        return view('otherusers.customar.rejected_list', compact('installments',  'company', 'installment_C'));
    }

    public function pending_list()
    {
        $memberID = Session::get('memberID');
        $installments = DemoInstallment::where('isDelete', 0)
            ->where('member_id', $memberID)
            ->get();
        $installment_C = CustomInstallment::where('isDelete', 0)
            ->where('member_id', $memberID)
            ->get();

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

        return view('otherusers.customar.pending_list', compact(
            'installments',
            'company',
            'installment_C'
        ));
    }


    public function pay_member_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('otherusers.customar.pay_member_installment', compact(

            'sale',
            'paid',
            'company',
            'refference',
            'sales',
            'total_paid',
            'due',
            'member'
        ));
    }
    // public function store_member_installment(Request $request)
    // {
    //     $picture = '';
    //     if ($request->hasFile('image')) {
    //         $picture = Storage::disk('public')->put('members', $request->file('image'));
    //     }

    //     // dd($picture);
    //     $installment = new DemoInstallment();
    //     $installment->member_id = $request->member_id;
    //     $installment->serial_id = $request->serial_id;
    //     $installment->sales_id = $request->sales_id;
    //     $installment->amount = $request->amount;
    //     $installment->date = $request->date;

    //     $paid_s = installment::where('sales_id', $installment->sales_id)->sum('amount');
    //     $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 = $request->get('install');
    //     $b_id = $sales->block_id;
    //     $plan = CommisionPlan::where('block_id', $b_id)->first();
    //     $pay = $installment->amount;
    //     $paid_am = $plan->installment_amount;


    //     $member = Member::where('id', $request->member_id)->first();
    //     $ref_id = $member->reference_id;
    //     $paid_installment_count = installment::where('sales_id', $installment->sales_id)->count();
    //     $total_paid = $sales->paid + $paid_s;
    //     $due  = ($sales->due_amount + $sales->paid + $sales->discount)  - $total_paid;

    //     $remain_installment = $sales->installment - $paid_installment_count;
    //     $installment->reference_id = $ref_id;
    //     $installment->money_rec = $request->money_rec;
    //     $installment->remark = $request->remark;
    //     $installment->company_log = $pay;
    //     $installment->due = $sale->due_amount - $request->amount;
    //     $installment->ins_no = 0;
    //     $installment->via = $request->via;
    //     $installment->account_no = $request->account_no;
    //     $installment->bank_name = $request->bank_name;
    //     $installment->image = $picture;
    //     $installment->isDelete = 0;

    //     $installment->save();

    //     $to = $member->mobile;
    //     $message = "Dear " . $member->name . ", You have sent an request of paying an installment of " . $installment->amount . " Tk. to the admin.";

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

    //     Toastr::success('Installment request has been successfully sent to admin panal :)', 'Success');
    //     return redirect()->back();
    // }


    public function store_demo_installment_cus(Request $request)
    {

        $installments = CustomInstallment::where('isDelete', 0)->where('saled_id', $request->saled_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('otherusers.customar.pending_msg');
        }
        $picture = '';
        if ($request->hasFile('image')) {
            $picture = Storage::disk('public')->put('members', $request->file('image'));
        }


        $installment = new CustomInstallment();
        $dateChange = date("Y-m-d", strtotime($request->date));
        $installment->member_id = $request->member_id;
        $installment->saled_id = $request->saled_id;
        $installment->amount = $request->amount;
        $installment->date = $dateChange;
        $installment->serial_id = $request->serial_id;
        $paid_s = installment::where('sales_id', $installment->sales_id)->sum('amount');
        $sale = SaleDetail::with(['installments'])->where('sales_id', $request->saled_id)->first();
        $sales = Sale::where('id', $request->saled_id)->first();
        $b_id = $sales->block_id;
        $plan = CommisionPlan::where('block_id', $b_id)->first();
        $pay = $installment->amount;
        $paid_am = $plan->installment_amount;


        $member = Member::where('id', $request->member_id)->first();
        $ref_id = $member->reference_id;
        $paid_installment_count = installment::where('sales_id', $installment->sales_id)->count();
        $total_paid = $sales->paid + $paid_s;
        $due  = ($sales->due_amount + $sales->paid + $sales->discount)  - $total_paid;

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

        $installment->money_rec = $request->money_rec;
        $installment->remark = $request->remark;
        $installment->reference_id = $ref_id;
        $installment->via = $request->via;
        $installment->account_no = $request->account_no;
        $installment->bank_name = $request->bank_name;
        $installment->image = $picture;
        $installment->isDelete = 0;
        $installment->due = $sale->due_amount - $request->amount;
        $installment->save();

        // Toastr::success('Installment request has been successfully sent to admin panal :)', 'Success');
        $to = $member->mobile;
        $message = "Dear " . $member->name . ", You have sent an request of paying an installment of " . $installment->amount . " Tk. to the admin.";

        event(new SendSMS($to, $message));
        $sms = new SmsCounter();
        $sms->mobile = $member->mobile;
        $sms->sms = $message;
        $sms->total = 5000;
        $sms->save();

        return redirect()->back()->with('message', 'Installment request has been successfully sent to admin panal :)');
    }
    public function approved_booking_list()
    {
        $memberID = Session::get('memberID');
        $booking = CustomBooking::where('isDelete', 1)
            ->where('member_id', $memberID)
            ->get();

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

        return view('otherusers.customar.approved_booking_list', compact('booking',  'company'));
    }
    public function rejected_booking_list()
    {
        $memberID = Session::get('memberID');
        $booking = CustomBooking::where('isDelete', 2)
            ->where('member_id', $memberID)
            ->get();
        $company = Company::latest()->first();

        return view('otherusers.customar.rejected_booking_list', compact('booking',  'company'));
    }

    public function pending_booking_list()
    {
        $memberID = Session::get('memberID');
        $booking = CustomBooking::where('isDelete', 0)
            ->where('member_id', $memberID)
            ->get();

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

        return view('otherusers.customar.pending_booking_list', compact('booking',  'company'));
    }
    public function edit_member($id)
    {
        $member = Member::where('id', $id)->first();
        return view('otherusers.customar.custom_edit', compact('member'));
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Member  $member
     * @return \Illuminate\Http\Response
     */
    public function member_update(Request $request, $id)
    {
        $member = Member::where('id', $id)->first();
        $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()) {
            return redirect()->back()->with('message', 'Member updated successfully :)');
        } else {
            return redirect()->back()->with('message', 'Something went wrong :(');
        }
    }
}