<?php

namespace App\Http\Controllers;

use App\arears;
use App\Model\Employee;
use Illuminate\Http\Request;
use App\setdate;
use Illuminate\Support\Facades\DB;

class ArearsController extends Controller
{
    public function __construct()
    {
        $this->middleware('auth');
    }
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()

    {
        

        $arears = arears::get();
        return view('arears_index', ['arears' =>   $arears ]);
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */


    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function  create_add_arears(Request $request)
    {
        $data = $request->all();

        if ($data['id'] > 0) {
            $model = arears::find($data['id']);
            $msg = "Claim updated";
        } else {
            $model = new arears();
            $msg = "Claim inserted";
        }


        $setdate = setdate::get();
        $datetime1 = $setdate[0]->fromdate;

        $datetime2 = $setdate[0]->todate;


    $emplname = Employee::with('designation')->where('employee_id',$data['emp_id'])->first();

         $model->emp_name =  $emplname->first_name.' '.$emplname->last_name;
         $model->emp_id =    $data['emp_id'];
        
         $model->date =    $data['date'];
      
         $model->salary_amount =    $data['salary_amount'];
         $model->exp_amount =    $data['exp_amount'];

         $darte = DB::table('arears')->where('emp_id', $data['emp_id'])->whereBetween('date', [$datetime1, $datetime2])->get();

        
         if ($darte->isEmpty() || $data['id'] > 0 ) {
 
             // dd($model);
             $model->save();
         } else {
             return redirect('arears_edit')->with('error', 'Employee Already exist attendance.');
         }
        //$model->save();
        $request->session()->flash('message', $msg);
        return redirect('/arears_edit');
    }

    public function edit(Request $request,  $id = "")
    {

        if ($id > 0) {
           

            $arr = arears::where(['id' => $id])->get();
            $result['date'] =  $arr['0']->date;
          
            $result['emp_id'] =  $arr['0']->emp_id;
            $result['salary_amount'] =  $arr['0']->salary_amount;
            $result['exp_amount'] =  $arr['0']->exp_amount;
            

            $result['id'] =  $arr['0']->id;

            
        } else {
            $result['date'] =  "";
            $result['emp_id'] =  "";
          
            $result['salary_amount'] =  "";
          
            $result['exp_amount'] =  "";
          
            $result['id'] = 0;
        }
        $setdate = setdate::get();
        $result['datetime1'] = $setdate[0]->fromdate;

    //    $datetime2 = $setdate[0]->todate;
        
        $result['emp'] = Employee::with('designation')->get();
    
        //$result['datetime1'] = Employee::with('designation')->get();
        return view('arears_form', $result);
        //
    }
    public function delete(Request $request,  $id)
    {
        //
        $result = arears::find($id);

        $result->delete();
        $request->session()->flash('message', ' epansive delete successful');

        return redirect(
            'arears_index'
        );
    }
}