<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Auth;
use App\CashRegister;

class CashRegisterController extends Controller
{
    /**
     * Create a new controller instance.
     *
     * @return void
     */
    public $data = [];
    public function __construct(){
    }

    /**
     * Show the application dashboard.
     *
     * @return \Illuminate\Http\Response
     */

    public function cashRegister(Request $request)
    {
        $this->data['title'] = 'Cash Register';
        $this->data['data'] = DB::table('cash_register as r')
            ->leftJoin('users as u', 'u.id', '=', 'r.user_id')
            ->whereRaw('Date(r.created_at) = CURDATE()')
            ->select('r.*', 'u.name as user_name')->orderBy('r.id', 'desc')->paginate(30);

        return view('admin.cashregister.cash_register', $this->data);
    }

    public function cashRegisterArchive(Request $request)
    {
        $this->data['title'] = 'Cash Register Archive';
        $register = DB::table('cash_register as r')
            ->leftJoin('users as u', 'u.id', '=', 'r.user_id');

        if ($request->user) {
            $register = $register->whereDate('r.user_id',$request->user);
        }
        if ($request->date) {
            $register = $register->whereDate('r.created_at',$request->date);
        }
        if ($request->type) {
            $register = $register->where('r.type', $request->type);
        }
        if ($request->shift) {
            $register = $register->where('r.shift', $request->shift);
        }
        $register = $register->select('r.*', 'u.name as user_name')->orderBy('r.id', 'desc')->paginate(30);
        $this->data['data'] = $register;

        return view('admin.cashregister.cash_register_archive', $this->data);
    }

    public function saveCashRegister(Request $request)
    {
        $create = new CashRegister;
        $create->user_id = Auth::User()->id;
        $create->type = $request->type;
        $create->shift = $request->shift;
        $create->amount = $request->amount;
        $create->created_at = date("Y-m-d", strtotime($request->date)).' '.date("H:i:s");
        $create->save();

        $request->session()->flash('message', 'Added new recored successfully!');
        return back();
    }

    public function deleteCashRegister(Request $request)
    {
        $delete = CashRegister::findorFail($request->id);
        $delete->delete();
        
        $request->session()->flash('error', 'Deleted successfully!');
        return back();
    }

}