
<?php

namespace App\Http\Controllers;

use App\Account;
use Illuminate\Http\Request;
use App\Reference;
use App\ReferenceWithdraw;
use App\SaleDetail;
use App\Member;
use App\ReferenceIncome;
use Illuminate\Support\Facades\DB;
use Session;
use App\Block;
use App\CommisionPlan;
use App\Company;
use App\Plot;
use App\Sale;
use Brian2694\Toastr\Facades\Toastr;

use Illuminate\Support\Facades\Storage;

class referenceManageController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $userId = Session::get('userID');
        // $paid_s = installment::where('sales_id', $installment->sales_id)->sum('amount');

        $total_income = ReferenceIncome::where('reference_id', $userId)->sum('amount');
        //dd($userId );
        $total_withdraw =  ReferenceWithdraw::where('reference_id', $userId)->sum('amount');
        $sale = SaleDetail::get();
        $count = 0;
        foreach ($sale as $sale) {
            if ($sale->refference_id == $userId)
                $count++;
        }
        $total_sale = $count;

        $due_amount = $total_income - $total_withdraw;
        $baynas = '';
        $company = '';
        return view('otherusers.reference.dashboard', compact('baynas', 'company', 'total_income', 'total_withdraw', 'due_amount', 'total_sale'));
    }

    /**
     * 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 reference_profile()
    {
        $userId = Session::get('userID');
        //dd($userId);
        $reference = Reference::where('id', $userId)->first();
        $sale = Sale::where('reference_id', $userId)->get();

        $total_with = ReferenceWithdraw::where('reference_id', $userId)->sum('amount');
        $total_bal = \App\ReferenceIncome::where('reference_id', $userId)->sum('amount');

        $saleD = SaleDetail::get();
        $count = 0;
        foreach ($saleD as $saleD) {
            if ($saleD->refference_id == $userId)
                $count++;
        }
        $total_sale = $count;

        $due_amount = $total_bal - $total_with;
        //dd($reference);
        $company = Company::latest()->first();

        return view('otherusers.reference.profile', compact(
            'reference',
            'total_with',
            'total_bal',
            'sale',
            'total_sale',
            'due_amount',
            'company'
        ));
    }
    public function reference_withdraw()
    {
        $userId = Session::get('userID');
        //dd($userId);
        $reference = ReferenceWithdraw::where('reference_id', $userId)->get();
        $company = Company::latest()->first();

        return view('otherusers.reference.reference_withdraw', compact('reference', 'company'));
    }
    public function member_detail()
    {
        //dd('hh');
        $userId = Session::get('userID');
        //dd($userId);
        $sale = SaleDetail::where('refference_id', $userId)->get();
        $company = Company::latest()->first();

        return view('otherusers.reference.member_detail', compact('sale', 'company'));
    }


    public function view_member_details($id)
    {
        // /$member = Member::where('id', $id)->first();
        $member = Member::with(['subMembers', 'reference'])->where('id', $id)->first();
        $company = Company::latest()->first();
        $saleDeail = SaleDetail::where('member_id', $member->id)->first();
        $sale = Sale::where('member_id', $member->id)->first();
        $saleD = SaleDetail::get();
        $count = 0;
        foreach ($saleD as $saleD) {
            if ($saleD->member_id ==  $member->id)
                $count++;
        }
        $total_sale = $count;
        return view('otherusers.reference.view_member_details', compact('member', 'company', 'saleDeail', 'sale', 'total_sale'));
    }


    public function all_commission()
    {


        $plans = CommisionPlan::where('status', 0)
            ->orderBy('id', 'DESC')
            ->get();

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

        return view('otherusers.reference.all_commision', compact('plans', 'company'));
    }
    public function sale_detail($id)
    {

        $userId = Session::get('userID');

        //$sale = SaleDetail::where('refference_id', $userId)->get();
        $referenceIn = ReferenceIncome::where('sell_id', $id)
            ->where('isDelete', 0)
            ->first();

        $referenceIncome = ReferenceIncome::where('sell_id', $id)
            ->where('isDelete', 0)
            ->get();
        $referenceIncome2 = ReferenceIncome::where('sell_id', $id)
            ->where('isDelete', 0)
            ->get();
        $referenceIncome3 = ReferenceIncome::where('sell_id', $id)
            ->where('isDelete', 0)
            ->get();
        $sale = Sale::where('id', $id)->first();
        $mem_id = $sale->member_id;
        $saleDetails = SaleDetail::where('sales_id', $id)->first();
        $plot = Plot::where('id', $sale->plot_id)->first();
        $block = Block::where('id', $plot->block_id)->first();
        $member = Member::where('id', $mem_id)->first();
        $reference =  \App\Reference::where('id', $member->reference_id)->first();
        $company = Account::where('sell_id', $id)->first();
        $company_amount = $company->company_log;
        $company_amount_in = $company->company_log;
        $total_income = ReferenceIncome::where('sell_id', $id)->sum('amount');
        $company_add = Company::latest()->first();
        $total_wid = ReferenceWithdraw::where('sell_id', $id)->sum('amount');
        // $company = Company::latest()->first();


        return view('otherusers.reference.sale_detail', compact(
            'referenceIn',
            'referenceIncome',
            'referenceIncome2',
            'referenceIncome3',
            'total_income',
            'total_wid',
            'sale',
            'plot',
            'block',
            'member',
            'reference',
            'saleDetails',
            'company_amount',
            'company_amount_in',
            'company_add'
        ));
    }

    public function sale_view()
    {
        $userId = Session::get('userID');

        $sale = Sale::where('reference_id', $userId)->get();

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

        $reference = Reference::where('id', $userId)->first();
        $total_with = ReferenceWithdraw::where('reference_id', $userId)->sum('amount');
        $total_bal = \App\ReferenceIncome::where('reference_id', $userId)->sum('amount');

        $saleD = SaleDetail::get();
        $count = 0;
        foreach ($saleD as $saleD) {
            if ($saleD->refference_id == $userId)
                $count++;
        }
        $total_sale = $count;

        $due_amount = $total_bal - $total_with;


        return view('otherusers.reference.sale_view', compact(
            'total_with',
            'total_bal',
            'sale',
            'total_sale',
            'due_amount',
            'company',
            'reference'
        ));
    }

    public function ref_edit($id)
    {
        $reference = Reference::where('id', $id)->first();
        return view('otherusers.reference.ref_edit', compact('reference'));
    }
    public function ref_update(Request $request, $id)
    {
        $request->validate([
            'name' => 'required',
            'father_name' => 'required',
            'mother_name' => 'required',
            'nid' => 'required',
            'dob' => 'required',
            'email' => 'required',
            'profession' => 'required',
            'present_address' => 'required',
            'permanent_address' => 'required',
            'mobile' => 'required',
            'religion' => 'required'
        ]);
        $reference = Reference::where('id', $id)->first();
        $picture = $reference->image;
        if ($request->hasFile('image')) {
            $picture = Storage::disk('public')->put('members', $request->file('image'));
        }
        $picture2 = $reference->signature_image;
        if ($request->hasFile('signature_image')) {
            $picture2 = Storage::disk('public')->put('members', $request->file('signature_image'));
        }
        $reference->name = $request->name;
        $reference->father_name = $request->father_name;
        $reference->mother_name = $request->mother_name;
        $reference->nid = $request->nid;
        $reference->dob = $request->dob;
        $reference->email = $request->email;
        $reference->profession = $request->profession;
        $reference->permanent_address = $request->permanent_address;
        $reference->present_address = $request->present_address;
        $reference->mobile = $request->mobile;
        $reference->religion = $request->religion;
        $reference->image = $picture;
        $reference->booking_amount = 0;
        $reference->installment_amount = 0;
        $reference->ekkalin_amount = 0;
        $reference->password = $request->password;
        $reference->signature_image = $picture2;
        $reference->save();

        Toastr::success('Reference Updated ! :)', 'Success');

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