
<?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)
    {
        $company = Company::latest()->first();
        $heads = ExpenceHead::where('isDelete', 0)->get();
        $from = $request->get('from');
        $to = $request->get('to');
        $ex_id = $request->expenses_heads_id;

        $total = Expence::sum('amount');
        if ($from || $to) {
            $from = date("Y-m-d", strtotime($request->from));
            $to = date("Y-m-d", strtotime($request->to));
            if ($ex_id == NULL) {
                $expenses = Expence::whereBetween('date', array($from, $to))

                    ->orderBy('date', 'ASC')
                    ->paginate(20);

                $sum = Expence::whereBetween('date', array($from, $to))

                    ->sum('amount');
            } else {
                $expenses = Expence::with('expenseHead')
                    ->where('expence_head_id', $ex_id)
                    ->orderBy('date', 'ASC')
                    ->whereBetween('date', array($from, $to))->paginate(20);
                $sum = Expence::with('expenseHead')
                    ->where('expence_head_id', $ex_id)
                    ->whereBetween('date', array($from, $to))
                    ->sum('amount');
            }
        } else if ($from == NULL && $to == NULL && $ex_id != NULL) {
            $expenses = Expence::where('expence_head_id', $ex_id)

                ->orderBy('date', 'ASC')
                ->paginate(20);


            $sum = Expence::where('expence_head_id', $ex_id)

                ->orderBy('date', 'ASC')
                ->sum('amount');
        } else {
            $expenses = Expence::with('expenseHead')
                ->orderBy('date', 'ASC')
                ->paginate(20);
            $sum = Expence::sum('amount');
        }

        return view('expenses.manage-expenses', compact(
            'expenses',
            'total',
            'heads',
            'company',
            'sum',
            'from',
            'to',
            'ex_id'
        ));
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        $heads = ExpenceHead::where('isDelete', 0)

            ->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();
        $dateChange = date("Y-m-d", strtotime($request->date));
        $expense->expence_head_id = $request->expenses_heads_id;
        $expense->date = $dateChange;
        $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::where('isDelete', 0)->get();
        $dateChange = date("d-m-Y", strtotime($expense->date));
        return view('expenses.edit', compact('expense', 'heads', 'dateChange'));
    }

    /**
     * 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',

            'amount' => 'required'
        ]);
        $expense = Expence::findOrFail($id);
        $expense->expence_head_id = $request->expence_head_id;

        $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('date', [$string1, $string2])->get();
        } else {
            $expenses = Expence::all();
        }
        $company = Company::latest()->first();
        return view('report.expense', compact('expenses', 'company'));
    }
    public function print(Request $request)
    {
        $company = Company::latest()->first();
        $heads = ExpenceHead::get();
        $from = $request->get('from');
        $to = $request->get('to');
        $ex_id = $request->expenses_heads_id;

        $total = Expence::sum('amount');
        if ($from || $to) {

            $expenses = Expence::with('expenseHead')
                ->where('expence_head_id', $ex_id)
                ->whereBetween('date', array($from, $to))->paginate(20);
        } else {
            $expenses = Expence::with('expenseHead')->paginate(20);
        }

        return view('expenses.print', compact('expenses', 'total', 'heads', 'company'));
    }
}