
<?php

namespace App\Http\Controllers;

use App\Bank;
use App\Company;
use Brian2694\Toastr\Facades\Toastr;
use Illuminate\Http\Request;

class BankController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        $query = $request->get('query');
        if ($query) {
            $banks = Bank::where('name', 'like', '%' . $query . '%')
                ->orWhere('ac_number', 'like', '%' . $query . '%')
                ->with(['deposits', 'withdraws'])
                ->where('status', 0)
                ->orderBy('id', 'DESC')
                ->paginate(20);

            $total_dep = Bank::where('name', 'like', '%' . $query . '%')
                ->orWhere('ac_number', 'like', '%' . $query . '%')

                ->where('status', 0)
                ->sum('current_balance');
        } else {
            $banks = Bank::with(['deposits', 'withdraws'])
                ->orderBy('id', 'DESC')
                ->where('status', 0)

                ->paginate(20);

            $total_dep = Bank::where('status', 0)
                ->sum('current_balance');
        }

        $company = Company::latest()->first();
        return view('bank.index', compact('banks', 'company', 'total_dep'));
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        return view('bank.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',
            'ac_number' => 'required',
        ]);

        $bank = new Bank();
        $bank->name = $request->name;
        $bank->ac_number = $request->ac_number;
        $bank->current_balance = 0;
        $bank->status = 0;
        $bank->save();

        Toastr::success('Bank Created :)', 'Success');

        return redirect()->back();
    }

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

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Bank  $bank
     * @return \Illuminate\Http\Response
     */
    public function edit(Bank $bank)
    {
        $b = Bank::where('id', $bank)
            ->where('status', 0);
        return view('bank.edit', compact('bank'));
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Bank  $bank
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, Bank $bank)
    {
        $request->validate([
            'name' => 'required',
            'ac_number' => 'required',
        ]);

        $bank->name = $request->name;
        $bank->ac_number = $request->ac_number;
        $bank->save();

        Toastr::success('Bank Updated :)', 'Success');

        return redirect()->back();
    }

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


        $bank->status = 1;
        $bank->save();
        Toastr::success('Bank Deleted :)', 'Success');

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