
<?php

namespace App\Http\Controllers;

use App\CommisionPlan;
use App\Reference;
use Brian2694\Toastr\Facades\Toastr;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Storage;

class ReferenceController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        $query = $request->get('query');
        if ($query) {
            $references = Reference::where('name', 'like', '%' . $query . '%')
                ->orWhere('father_name', 'like', '%' . $query . '%')
                ->orWhere('mother_name', 'like', '%' . $query . '%')
                ->orWhere('nid', 'like', '%' . $query . '%')
                ->orWhere('email', 'like', '%' . $query . '%')
                ->orWhere('permanent_address', 'like', '%' . $query . '%')
                ->orWhere('present_address', 'like', '%' . $query . '%')
                ->orWhere('mobile', 'like', '%' . $query . '%')
                ->with(['referenceIncomes', 'withdraws'])
                ->paginate(20);
        } else {
            $references = Reference::with(['referenceIncomes', 'withdraws'])->paginate(20);
        }
        return view('reference.index', compact('references'));
    }

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

    /**
     * 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',
            'father_name' => 'required',
            'mother_name' => 'required',
            'nid' => 'required',
            'dob' => 'required',
            'email' => 'required',
            'profession' => 'required',
            'present_address' => 'required',
            'permanent_address' => 'required',
            'mobile' => 'required',
            'religion' => 'required',
            'image' => 'required',
        ]);

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

        $reference = new Reference();

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

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

        return redirect()->back();
    }

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

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

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Reference  $reference
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, Reference $reference)
    {
        $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'
        ]);

        $picture = $reference->image;
        if ($request->hasFile('image')) {
            $picture = Storage::disk('public')->put('members', $request->file('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->save();

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

        return redirect()->back();
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Reference  $reference
     * @return \Illuminate\Http\Response
     */
    public function destroy(Reference $reference)
    {
        $reference->delete();

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

        return redirect()->back();
    }

    public function add_plan()
    {
        // dd('ss');
        $plans = CommisionPlan::get();
        //dd($plans);
        return view('plans.index', compact('plans'));
    }

    public function create_plan()
    {

        $references = Reference::all();
        //dd($references);
        return view('plans.create', compact('references'));
    }

    public function store_plan(Request $request)
    {
        $request->validate([
            'booking_amount'     => 'required',
            'installment_amount'     => 'required',
            'ekkalin_amount'     => 'required',
            'refference_id'       => 'required',
        ]);
        $plan = new CommisionPlan();
        $plan->booking_amount = $request->booking_amount;
        $plan->installment_amount = $request->installment_amount;
        $plan->ekkalin_amount = $request->ekkalin_amount;
        $plan->refference_id = $request->refference_id;
        ////dd($plan);
        $plan->save();


        $ref = $plan->refference_id;
        $reference = Reference::where('id', $ref)->first();
        //dd($reference->id);
        if ($reference->id ==  $plan->refference_id) {
            $reference->booking_amount = $request->booking_amount;
            $reference->installment_amount = $request->installment_amount;
            $reference->ekkalin_amount = $request->ekkalin_amount;
            // dd($reference);
            $reference->save();
        }
        Toastr::success('Commision plan Successfully Created :)', 'Success');
        return redirect()->back();
    }
    public function show_plan($id)
    {

        $plan = CommisionPlan::where('id', $id)->first();
        $ref = $plan->refference_id;
        $reference = Reference::where('id', $ref)->first();
        //dd($ri);
        return view('plans.show', compact('plan', 'reference'));
    }
    public function edit_plan($id)
    {
        //dd('a');
        $references = Reference::all();
        $plan = CommisionPlan::where('id', $id)->first();
        $ref = $plan->refference_id;
        $reference = Reference::where('id', $ref)->first();
        //dd($references);
        return view('plans.edit', compact('reference', 'references', 'plan'));
    }
    public function update_plan(Request $request, $id)
    {
        $plan = CommisionPlan::where('id', $id)->first();


        $plan->booking_amount = $request->booking_amount;
        $plan->installment_amount = $request->installment_amount;
        $plan->ekkalin_amount = $request->ekkalin_amount;
        $plan->refference_id = $request->refference_id;

        $ref = $plan->refference_id;
        $reference = Reference::where('id', $ref)->first();

        if ($reference->id ==  $plan->refference_id) {
            $reference->booking_amount = $request->booking_amount;
            $reference->installment_amount = $request->installment_amount;
            $reference->ekkalin_amount = $request->ekkalin_amount;
            $reference->update();
        }
        if ($plan->save()) {
            Toastr::success('plan updated successfully :)', 'Success');
            return redirect()->route('add_plan');
        } else {
            Toastr::error('Something went wrong :(', 'Error');
            return redirect()->back();
        }
    }

    public function delete_plan($id)
    {
        $plan = new CommisionPlan;
        $plan = $plan::find($id);

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

        return redirect()->back();
    }
    public function create_withdraw()
    {
        $references = Reference::all();
        return view('admin-ref-withdraw.create', compact('references'));
    }
}