
<?php

namespace App\Http\Controllers;

use App\Company;
use App\Expence;
use App\ExpenceHead;
use Brian2694\Toastr\Facades\Toastr;
use Illuminate\Http\Request;

class ExpenceController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {

        $from = $request->get('from');
        $to = $request->get('to');
        $total = Expence::sum('amount');
        if ( $from || $to )
        {
            $expenses = Expence::with('expenseHead')
            ->whereBetween('date', array($from, $to))->paginate(20);
        } else{
            $expenses = Expence::with('expenseHead')->paginate(20);
        }
        return view('expenses.manage-expenses', compact('expenses', 'total'));
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        $heads = ExpenceHead::get();
        return view('expenses.create',compact('heads'));
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        $request->validate([
            'expenses_heads_id' => 'required',
            'date' => 'required',
            'amount' => 'required'
        ]);
        $expense = new Expence();
        $expense->expence_head_id = $request->expenses_heads_id;
        $expense->date = $request->date;
        $expense->description = $request->description;
        $expense->note = $request->note;
        $expense->amount = $request->amount;
        $expense->save();
        Toastr::success('Expense Head Created ! :)' ,'Success');
        return redirect()->back();
    }

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

    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Expence  $expence
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        $expense = Expence::findOrFail($id);
        $heads = ExpenceHead::all();
        return view('expenses.edit', compact('expense', 'heads'));
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Expence  $expence
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        $request->validate([
            'expence_head_id' => 'required',
            'date' => 'required',
            'amount' => 'required'
        ]);
        $expense = Expence::findOrFail($id);
        $expense->expence_head_id = $request->expence_head_id;
        $expense->date = $request->date;
        $expense->description = $request->description;
        $expense->note = $request->note;
        $expense->amount = $request->amount;
        $expense->save();
        Toastr::success('Expense  Updated ! :)' ,'Success');
        return redirect()->back();
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Expence  $expence
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        $expense = Expence::findOrFail($id);
        $expense->delete();
        Toastr::success('Expense Deleted Updated ! :)' ,'Success');
        return redirect()->back();
    }

    public function report(Request $request)
    {
        if ($request->date_range) {
            $x = 1;
            $delim = ' - ';
            $str = $request->date_range;
            $parts = explode($delim,$str);
            $string1 = implode($delim,array_slice($parts,0,$x)) . $delim;
            $string2 = implode($delim,array_slice($parts,$x));

            $string2 = date("y-m-d", strtotime($string2));
            $string1 = date("y-m-d", strtotime($string1));
            $expenses = Expence::whereBetween('created_at', [ $string1, $string2])->get();
        } else {
            $expenses = Expence::all();
        }
        $company = Company::latest()->first();
        return view('report.expense', compact('expenses', 'company'));
    }
}