
<?php

namespace App\Http\Controllers;

use App\Company;
use App\Income;
use App\IncomeHead;
use Brian2694\Toastr\Facades\Toastr;
use Illuminate\Http\Request;

class IncomeController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        $company = Company::latest()->first();
        $heads = IncomeHead::where('isDelete', 0)->get();
        $from = $request->get('from');
        $to = $request->get('to');
        $ex_id = $request->income_head_id;

        $total = Income::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) {
                $incomes = Income::whereBetween('date', array($from, $to))
                    ->orderBy('date', 'ASC')
                    ->paginate(20);

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

                    ->sum('amount');
            } else {
                $incomes = Income::with('incomeHead')
                    ->where('income_head_id', $ex_id)
                    ->orderBy('date', 'ASC')
                    ->whereBetween('date', array($from, $to))->paginate(20);


                $sum = Income::with('incomeHead')
                    ->where('income_head_id', $ex_id)
                    ->whereBetween('date', array($from, $to))

                    ->sum('amount');
            }
        } else if ($from == NULL && $to == NULL && $ex_id != NULL) {
            $incomes = Income::where('income_head_id', $ex_id)

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


            $sum = Income::where('income_head_id', $ex_id)

                ->orderBy('date', 'ASC')
                ->sum('amount');
        } else {
            $incomes = Income::with('incomeHead')
                ->orderBy('date', 'ASC')
                ->paginate(20);
            $sum = Income::sum('amount');
        }
        return view('income.manage-incomes', compact(
            'incomes',
            'total',
            'heads',
            'company',
            'sum',
            'from',
            'to',
            'ex_id'
        ));
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        $heads = IncomeHead::where('isDelete', 0)->get();
        return view('income.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([

            'date' => 'required',
            'amount' => 'required'
        ]);
        $income = new Income();
        $dateChange = date("Y-m-d", strtotime($request->date));
        $income->income_head_id = $request->income_head_id;
        $income->date =  $dateChange;
        $income->description = $request->description;
        $income->note = $request->note;
        $income->amount = $request->amount;
        $income->isDelete = 0;
        $income->save();
        Toastr::success('Income  Created ! :)', 'Success');
        return redirect()->back();
    }

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

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Expence  $expence
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        $income = Income::findOrFail($id);
        $heads = IncomeHead::where('isDelete', 0)->get();
        $dateChange = date("d-m-Y", strtotime($income->date));
        return view('income.edit', compact('income', '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([

            'date' => 'required',
            'amount' => 'required'
        ]);
        $income = Income::findOrFail($id);
        $income->income_head_id = $request->income_head_id;

        $income->description = $request->description;
        $income->note = $request->note;
        $income->amount = $request->amount;
        $income->save();
        Toastr::success('Income  Updated ! :)', 'Success');
        return redirect()->back();
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Expence  $expence
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        $expense = Income::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 = Income::whereBetween('created_at', [$string1, $string2])->get();
    //     } else {
    //         $expenses = Income::all();
    //     }
    //     $company = Company::latest()->first();
    //     return view('report.expense', compact('expenses', 'company'));
    // }
    // public function print(Request $request)
    // {
    //     $company = Company::latest()->first();
    //     $heads = IncomeHead::get();
    //     $from = $request->get('from');
    //     $to = $request->get('to');
    //     $ex_id = $request->expenses_heads_id;

    //     $total = In::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'));
    // }
}