<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\EmployeeProfile;
use App\Models\ActualWorkPlace;
use App\Models\AppointmentCategory;
use App\Models\BasicCategory;
use App\Models\Cadre;
use App\Models\Caste;
use App\Models\Designation;
use App\Models\EmployeeRelation;
use App\Models\Faculty;
use App\Models\Gender;
use App\Models\MaritalStatus;
use App\Models\Appointment;
use App\Models\ParallelReservation;
use App\Models\PayScale;
use App\Models\PayBand;
use App\Models\GradePay;
use App\Models\PayLevel;
use App\Models\PayLevelAmount;
use App\Models\Religion;
use App\Models\SanctionPost;
use App\Models\EmployeePayMatrix;

use App\Library\UserLib;

class PayLevelAmountController extends Controller
{
    protected $userLib;
    protected $UserSessionId;
    public function __construct(UserLib $userLib)
    {
        $this->userLib = $userLib;
    }

    ### Check PayLevel Amount if Exist
    public function checkPayLevelAmount(Request $request)
    {
        // if (empty($this->UserSessionId)) {
        //     return redirect('/');
        // }
        $PayLevelAmount = $request->input('PayLevelAmount');
        $PayLevelAmountId = $request->input('id');
        $PayLevelAmount = PayLevelAmount::where('PayLevelAmount', $PayLevelAmount)
            ->orWhere('PayLevelAmountId', $PayLevelAmountId)->first();
        if ($PayLevelAmount) {
            return response()->json(array("exists" => true));
        } else {
            return response()->json(array("exists" => false));
        }
    }

    ### Check Duplicate PayLevelAmount if Exist
    public function checkDuplicatePayLevelAmount(Request $request)
    {
        $getPayLevelAmount = PayLevelAmount::select('tbl_paylevel_amount.*')
            ->where('PayLevelAmount', $request->PayLevelAmount)
            ->where('PayLevelId', $request->PayLevelId)
            ->where('PayScaleId', $request->PayScaleId)
            ->where('PayBandId', $request->PayBandId)
            ->where('GradePayId', $request->GradePayId)
            ->first();
        if ($getPayLevelAmount) {
            echo 'false';
        } else {
            echo 'true';
        }
    }

    ### Store Pay Level
    public function storePayLevelAmount(Request $request)
    {
        if (empty(session('UserId'))) {
            return redirect('/');
        }
        
        $input = $request->all();
        $data = $input;
        $data['PayLevelAmountId'] =  $this->userLib->useridGenrator();
        $data['IsDeleted'] = 0;
        $data['Status'] = 1;
        $data['Created_by'] = session('UserId');
        $data['Created_at'] = date('Y-m-d H:i:s', time());
        $data['Updated_by'] = session('UserId');
        $data['Updated_at'] = date('Y-m-d H:i:s', time());

        unset($data['_token']);

        $insert_pl = PayLevelAmount::insert($data);
        if ($insert_pl) {
            return response()->json('success');
        } else {
            return response()->json('failed');
        }
    }
    ### Edit Pay Level Amount
    public function editPayLevelAmount($PayLevelAmountId)
    {
        // if (empty($this->UserSessionId)) {
        //     return redirect('/');
        // }

        $PayLevelAmount = PayLevelAmount::select('tbl_payband.*')
            ->where('PayLevelAmountId', $PayLevelAmountId)
            ->get()->first();
        return response()->json([
            'Status' => 200,
            'PayLevelAmount' => $PayLevelAmount
        ]);
    }

    ### Update Pay Level Amount
    public function updatePayLevelAmount(Request $request)
    {
        // if (empty($this->UserSessionId)) {
        //     return redirect('/');
        // }

        $PayLevelAmountId = $request->input('PayLevelAmountId');
        $pl_data['PayLevelAmount'] = $request->input('PayLevelAmount');
        $pl_data['Updated_by'] = session('UserId');
        $pl_data['Updated_at'] = date('Y-m-d H:i:s', time());

        $update_pla = PayLevelAmount::where('PayLevelAmountId', $PayLevelAmountId)->update($pl_data);
        if ($update_pla) {
            return response()->json('success');
        } else {
            return response()->json('failed');
        }
    }

    
    ### Check PayLevel Amount if Exist in EmployeePayMatrix Table
    public function checkEmployeePayLevelAmount(Request $request)
    {
        $this->UserSessionId = session('UserId');
        if (empty($this->UserSessionId)) {
            return redirect('/');
        }
        $PayLevelAmountId = $request->input('PayLevelAmountId');
        $GetPayLevelAmountId = EmployeePayMatrix::select('tbl_employees_paymatrix.*')
            ->where('PayLevelAmountId', $PayLevelAmountId)
            ->get()
            ->first();
        if ($GetPayLevelAmountId) {
            return response()->json(array("exists" => true));
        } else {
            return response()->json(array("exists" => false));
        }

    }

    #### Delete PayLevel Amount
    public function deletePayLevelAmount($PayLevelAmountId)
    {
        // if (empty($this->UserSessionId)) {
        //     return redirect('/');
        // }
        $CreatedDate = date('Y-m-d H:i:s', time());

        $value = array();
        $value['Updated_at'] = $CreatedDate;
        $value['IsDeleted'] = '1';
        $value['Status'] = '0';

        $delete_ps = PayLevelAmount::where('PayLevelAmountId', $PayLevelAmountId)->update($value);
        if ($delete_ps) {
            return response()->json('status_success');
        } else {
            return response()->json('status_failed');
        }
    }
    #### Restore PayLevel Amount
    public function restorePayLevelAmount($PayLevelAmountId)
    {
        // if (empty($this->UserSessionId)) {
        //     return redirect('/');
        // }
        $CreatedDate = date('Y-m-d H:i:s', time());

        $value = array();
        $value['Updated_at'] = $CreatedDate;
        $value['IsDeleted'] = '0';
        $value['Status'] = '1';

        $restore_ps = PayLevelAmount::where('PayLevelAmountId', $PayLevelAmountId)->update($value);
        if ($restore_ps) {
            return response()->json('status_success');
        } else {
            return response()->json('status_failed');
        }
    }

    #### Delete Permanent PayLevel Amount
    public function destroyPayLevelAmount($PayLevelAmountId)
    {
        if (empty($this->UserSessionId)) {
            return redirect('/');
        }
        $destroyData = PayLevelAmount::where('PayLevelAmountId', $PayLevelAmountId);
        $destroyData->delete();
    }

    #### Change Status PayLevel Amount
    public function changeStatusPayLevelAmount($PayLevelAmountId)
    {
        $value = array();
        $data = PayLevelAmount::where('PayLevelAmountId', $PayLevelAmountId)->get()->first();
        $Status = $data->Status;

        if ($Status == '1') {
            $value['Status'] = '0';
        } else {
            $value['Status'] = '1';
        }
        $UpdatedDate = date('Y-m-d H:i:s', time());
        $value['Updated_at'] = $UpdatedDate;
        $value['Updated_by'] = session('UserId');
        $change_status_ps = PayLevelAmount::where('PayLevelAmountId', $PayLevelAmountId)->update($value);
        if ($change_status_ps) {
            return response()->json('status_success');
        } else {
            return response()->json('status_failed');
        }
    }
}