{{View::make('layout.header')}}

@php

$user_join_year = date('d-m-Y',strtotime($userPay->date_commence));

$cutOffStartMonth = getSettingsValue("cut_of_startmonth");



if($cutOffStartMonth!=1){

    if($cutOffStartMonth > date('m')){

        $currentYear = date('Y');

    }else{

        $currentYear = date('Y')+1;

    }

}else{

    $currentYear = date('Y');

}

@endphp



    <style>

     

    .timeline .timeline-item .timeline-event h6{ 

        word-break : break-all; 

    }

    .MiniRightnav1 span {

        font-family: 'Raleway', sans-serif;

        font-size:14px;

        font-weight: 400;

        letter-spacing: 1px;

        top: 1px;

        right: 0px;

        line-height: 38px;

        overflow: hidden;

        padding: 0;

        position: absolute;

        white-space: nowrap;

        width: 0;

        

        /* CSS3 Transition: */

        -webkit-transition: 0.50s;

        /* Future proofing (these do not work yet): */

        -moz-transition: 0.50s;

        transition: 0.50s;  

    }

    .MiniRightnav1 a:hover span{ width:auto; padding:0px;overflow:visible; }

    .MiniRightnav1 a:hover{text-decoration:none;}

    .MiniRightnav1 a span{

        background-color:transparent;

        color:#82868b;

    } 

    </style>

    <!-- BEGIN: Content-->

    <div class="app-content content ">

        <div class="content-overlay"></div>

        <div class="header-navbar-shadow"></div>

        <div class="content-wrapper">

            <div class="content-header row">

                <div class="content-header-left col-md-9 col-12 mb-2">

                    <div class="row breadcrumbs-top">

                        <div class="col-12">

                            <h2 class="content-header-title float-left mb-0">E-Leave</h2>

                            <div class="breadcrumb-wrapper">

                                <ol class="breadcrumb">

                                    <li class="breadcrumb-item">Search

                                    </li>

                                </ol>

                            </div>

                        </div>

                    </div>

                </div>

                <div class="content-header-right text-md-right col-md-3 col-12">

                    <div class="form-group breadcrumb-right MiniRightnav1">

                    <!--<form id="leave-form">-->

                    <!--    <input type="hidden" value="{{ $personal->username }}" name="staff_name" id="staff_name">-->

                                        

                    <!--    <a onclick="exportpdf()" class="text-danger" ><i class="fa fa-file-pdf-o report-download-btn" style="font-size:25px;"></i><span>Download PDF</span></a>-->

                    <!--    &nbsp;&nbsp;-->

                    <!--    <a  onclick="exportexcel()" class="text-success"><i class="fa fa-file-excel-o report-download-btn" style="font-size:25px;"></i><span>Download Excel</span></a>-->

                                           

                    <!--</form>                -->

                     </div>

                </div>

            </div>

            <div class="content-body">

               <div class="content-body">

                        <section id="dashboard-ecommerce">

                            <div class="row match-height">

                                <div class="col-md-12">

                                    <div class="card">

                                        <div class="card-header">

                                            <h4>Staff Information</h4>

                                            <div class="d-sm-flex justify-content-between align-items-center" style="margin: 0px 0;">

                                                <div class="d-flex align-items-right">

                                                    <div class="btn-group btn-align-right MiniRightnav">

                                                        <form id="leave-form">

                                                            <input type="hidden" value="{{ $personal->username }}" name="staff_name" id="staff_name">

                                                                            

                                                            <a onclick="exportpdf()" class="text-danger" ><i class="fa fa-file-pdf-o report-download-btn" style="font-size:25px;"></i><span>Download PDF</span></a>

                                                            &nbsp;&nbsp;

                                                            <a  onclick="exportexcel()" class="text-success"><i class="fa fa-file-excel-o report-download-btn" style="font-size:25px;"></i><span>Download Excel</span></a>

                                                                               

                                                        </form>

                                                    </div>

                                                </div>    

                                            </div>

                                        </div>

                                       

                                        <div class="card-body">

                                            <div class="table-responsive" style="padding: 0 15px 15px 15px;">

                                                <table  class="table table-bordered my-leave-summary-entitle" style="font-size:11px;text-align: center;" width="100%" border="1">

                                                    <thead>

                                                        <tr style="height:50px;">

                                                            <th style="width:8%;text-align: center;text-transform: capitalize;">Emp No</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;">Name</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;white-space: nowrap;">Date of Join</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;">Date confirm</th>

                                                            <th style="width:5%;text-align:center;text-transform: capitalize;">Entitle category</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;">Rest day group</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;">Phone No</th>

                                                            <th style="width:4%;text-align:center;text-transform: capitalize;">Branch</th>

                                                            <th style="width:4%;text-align:center;text-transform: capitalize;">Department</th>

                                                            <th style="width:4%;text-align:center;text-transform: capitalize;">Category</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;">Employee Role</th>

                                                            <th style="width:4%;text-align:center;text-transform: capitalize;">State</th>

                                                        </tr>

                                                    </thead>

                                                    <tbody>

                                                        <tr  style="height:30px;">

                                                            <td >{{ $personal->employee_no }}</td>

                                                            <td >{{ $personal->name }}</td>

                                                            <td >{{ date('d-m-Y', strtotime($pay->date_commence)) }}</td>

                                                            <td >01-01-1970</td>

                                                           

                                                            <td >{{ $pay->ecategory }}</td>

                                                            <td >{{ $personal->rcategory }}</td>

                                                            <td >{{ $personal->phone_no }}</td>

                                                            <td >{{ $pay->bname }}</td>

                                                            <td >{{ $pay->dname }}</td>

                                                            <td >{{ $pay->cname }}</td>

                                                            <td>{{ $permission->group_name }}</td>

                                                            <td >{{ $personal->state }}</td>

                                                        </tr>

                                                    </tbody>

                                                </table>

                                            </div>

                                        </div>

                                    </div>

                                </div>

                            </div>



                            <div class="row match-height">

                                <div class="col-md-12">

                                    <div class="card">

                                        <div class="card-header">

                                            <h4>Supervisor Information</h4>

                                           

                                        </div>

                                        <div class="card-body">

                                            <div class="table-responsive" style="padding: 0 15px 15px 15px;">

                                                <table  class="table table-bordered my-leave-summary-entitle" style="font-size:11px;text-align: center;" width="100%" border="1">

                                                    <thead>

                                                        <tr style="height:50px;">

                                                            <th style="width:8%;text-align: center;text-transform: capitalize;">Emp No</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;">Name</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;white-space: nowrap;">Date of Join</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;">Phone No</th>

                                                            <th style="width:4%;text-align:center;text-transform: capitalize;">Branch</th>

                                                            <th style="width:4%;text-align:center;text-transform: capitalize;">Department</th>

                                                            <th style="width:4%;text-align:center;text-transform: capitalize;">Category</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;">Employee Role</th>

                                                            <th style="width:4%;text-align:center;text-transform: capitalize;">State</th>

                                                        </tr>

                                                    </thead>

                                                    <tbody>

                                                        @foreach($getSupervisors as $getSupervisor)

                                                            <tr  style="height:30px;">

                                                                <td >{{ $getSupervisor->approver_id }}</td>

                                                                <td >{{ $getSupervisor->name }}</td>

                                                                <td >@if($getSupervisor->date_joined!='') {{  date('d-m-Y', strtotime($getSupervisor->date_joined)) }} @endif</td>

                                                                <td >{{ $getSupervisor->phone_no }}</td>

                                                                <td >{{ $getSupervisor->branch }}</td>

                                                                <td >{{ $getSupervisor->department }}</td>

                                                                <td >{{ $getSupervisor->category }}</td>

                                                                <td >{{ $getSupervisor->Role }}</td>

                                                                <td >{{ $getSupervisor->state }}</td>

                                                            </tr>

                                                        @endforeach   

                                                    </tbody>

                                                </table>

                                            </div>

                                        </div>

                                    </div>

                                </div>

                            </div>







                            <div class="row match-height">

                                <div class="col-md-12">

                                    <div class="card">

                                        <div class="card-header">

                                            <h4>Leave Summary</h4>

                                           

                                        </div>

                                        <div class="card-body">

                                            <div class="table-responsive" style="padding: 0 15px 15px 15px;">
                                            <form method="GET" action="{{ route('global-search') }}" id="yearFilterForm1" style="width:150px;">
                                            <div class="mb-3">
                                                <label for="leave_year">Select Year:</label>
                                                <select name="leave_year" id="leave_year" class="form-control" onchange="document.getElementById('yearFilterForm1').submit();">
                                                    @for ($year = date('Y'); $year > date('Y') - 5; $year--)
                                                        <option value="{{ $year }}" @if((request('leave_year') ?? date('Y')) == $year) selected @endif>
                                                            {{ $year }}
                                                        </option>
                                                    @endfor
                                                </select>
                                            </div>

                                            <!-- Preserve all other query parameters except 'leave_year' -->
                                            @foreach(request()->except('leave_year') as $name => $value)
                                                <input type="hidden" name="{{ $name }}" value="{{ $value }}">
                                            @endforeach
                                        </form>

                                                <table  class="table table-bordered my-leave-summary-entitle" style="font-size:11px;text-align: center;" width="100%" border="1">

                                                    <thead>

                                                        <tr style="height:50px;">

                                                            <th style="width:5%;text-align: center;text-transform: capitalize;">Type</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;">BF</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;white-space: nowrap;">BF Adj</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;">Entitle</th>

                                                            <th style="width:5%;text-align:center;text-transform: capitalize;">Earn</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;">Claimable

                                                            </th><th style="width:4%;text-align:center;text-transform: capitalize;">NPL

                                                            </th><th style="width:11%;text-align:center;text-transform: capitalize; padding-left: 0px !important; padding-right: 0px !important; padding-bottom: 0px !important;">Taken

                                                            <table class="tableheading" style="width:100%; margin-top: 0.72rem !important;     border-top: 1px solid #ebe9f1;">

                                                            <tbody><tr>

                                                                <td style="border-top:none;border-bottom:none;padding:0;width:50%;">EL</td>

                                                                <td style="border-top:none;border-bottom:none;border-right:none;padding:0;width:50%;">AL</td>

                                                            </tr></tbody></table>

                                                            </th>

                                                            <th style="width:15%;text-align:center;text-transform: capitalize; padding-left: 0px !important; padding-right: 0px !important; padding-bottom: 0px !important;">Forfeit

                                                            <table class="tableheading" style="width:100%; margin-top: 0.72rem !important;     border-top: 1px solid #ebe9f1;">

                                                            <tbody><tr>

                                                                    <td style="border-top:none;border-bottom:none;padding:0;width:50%;">BF</td>

                                                                    <td style="border-top:none;border-bottom:none;padding:0;width:50%;">Adj</td>

                                                            </tr></tbody></table></th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;">Balance</th>

                                                        </tr>

                                                    </thead>

                                                    <tbody>

                                                        <tr style="height:30px;" class="text-center">

                                                            <th style=""><b>AL</b></th>

                                                            <td>{{ $myLeaveSumm->abf }}</td>

                                                            <td>{{ $myLeaveSumm->abfadj }}</td>

                                                            <td>{{ $myLeaveSumm->aentitle }}</td>

                                                            <td>{{ $myLeaveSumm->aearn }}</td>

                                                            <td>{{ $myLeaveSumm->claimable }}</td>

                                                            <td>{{ $myLeaveSumm->anpl ?? 0 }}</td>

                                                            <td style="width:11%;  padding:0px !important;">

                                                                <table class="tableheading" style="width:100%; height: 50px;">

                                                                <tbody><tr>

                                                                    <td style="border-left:none;border-top:none;border-bottom:none;padding:0;width:50%;border-right:1px solid; border-color:#ebe9f1;">{{ $myLeaveSumm->atakenel }}</td>

                                                                    <td style="width:50%; border-top:none;border-bottom:none;border-right:none;padding:10px;">{{$myLeaveSumm->atakenal }}</td>

                                                                </tr></tbody></table>

                                                            </td>

                                                            <td style="width:11%; padding:0px !important;">

                                                                <table class="tableheading" style="width:100%; height: 50px;">

                                                                <tbody><tr>

                                                                        <td style="width:50%;  border-left:none;border-top:none;border-bottom:none;padding:0; border-right:1px solid; border-color:#ebe9f1;">{{ $myLeaveSumm->aforfeitbf }}</td>

                                                                        <td style="width:50%; border-top:none;border-bottom:none;padding:10px;border-right:none;">{{ $myLeaveSumm->aforfeitadj }}</td>

                                                                </tr></tbody></table>

                                                            </td>

                                                            <td >{{ $myLeaveSumm->balance ?? 0 }}</td>

                                                        </tr>

                                                        <tr  style="height:30px;">

                                                            <th class="type text-center" style=""><b>MC</b></th>

                                                            <td  >{{ $medicalSumm->mbf }}</td>

                                                            <td >{{ $medicalSumm->mbfadj }}</td>

                                                            <td >{{ $medicalSumm->mentitle }}</td>

                                                            <td >-</td>

                                                            <td >{{ $medicalSumm->mclaimable }}</td>

                                                            <td >-</td>
                                                            <!-- {{ $medicalSumm->mnpl }} -->

                                                            <td >{{ $medicalSumm->mtaken }}</td>

                                                            

                                                            <td >0</td>

                                                            <td >{{ $medicalSumm->mbalance }}</td>

                                                        </tr>

                                                    <tr  style="height:30px;">

                                                            <th class="type text-center"  style=""><b>RL1</b></th>

                                                            <td >{{ $myLeaveSummSm['bf'] ?? 0 }}</td>

                                                            <td >{{ $myLeaveSummSm['bfadj'] ?? 0}}</td>

                                                            <td >-</td>

                                                            <td >{{ $myLeaveSummSm['granted'] ?? 0 }}</td>

                                                            <td >-</td>

                                                            <td >-</td>

                                                            <td >{{ $myLeaveSummSm['taken'] ?? 0 }}</td>

                                                           

                                                            <td >{{ $myLeaveSummSm['forfeit'] ?? 0 }}</td>

                                                            <td >{{ $myLeaveSummSm['balance'] ?? 0 }}</td>

                                                        </tr>

                                                        <tr  style="height:30px;">

                                                            <th class="type text-center"  style=""><b>RL2</b></th>

                                                            <td >{{ $myLeaveSummSm1['bf'] ?? 0 }}</td>

                                                            <td >{{ $myLeaveSummSm1['bfadj'] ?? 0}}</td>

                                                            <td >-</td>

                                                            <td >{{ $myLeaveSummSm1['granted'] ?? 0 }}</td>

                                                            <td >-</td>

                                                            <td >-</td>

                                                            <td >{{ $myLeaveSummSm1['taken'] ?? 0 }}</td>

                                                           

                                                            <td >{{ $myLeaveSummSm1['forfeit'] ?? 0 }}</td>

                                                            <td >{{ $myLeaveSummSm1['balance'] ?? 0 }}</td>

                                                        </tr>

                                                    </tbody>

                                                </table>

                                            </div>

                                        </div>

                                    </div>

                                </div>

                            </div>



                            <div class="row match-height">

                                <div class="col-md-12">

                                    <div class="card">

                                        <div class="card-header">

                                            <h4>All Leave Summary</h4>

                                           

                                        </div>

                                        <div class="card-body">

                                            <div class="table-responsive" style="padding: 0 15px 15px 15px;">
                                            <form method="GET" action="{{ route('global-search') }}" id="yearFilterForm" style="width:150px;">
                                                <div class="mb-3">
                                                    <label for="select_year">Select Year:</label>
                                                    <select name="select_year" id="select_year" class="form-control" onchange="document.getElementById('yearFilterForm').submit();">
                                                        @for ($year = date('Y'); $year > date('Y') - 5; $year--)
                                                            <option value="{{ $year }}" @if((request('select_year') ?? date('Y')) == $year) selected @endif>
                                                                {{ $year }}
                                                            </option>
                                                        @endfor
                                                    </select>
                                                </div>

                                                <!-- Preserve all other query parameters except 'select_year' -->
                                                @foreach(request()->except('select_year') as $name => $value)
                                                    <input type="hidden" name="{{ $name }}" value="{{ $value }}">
                                                @endforeach
                                            </form>

                                                <table  class="table table-bordered my-leave-summary-entitle" style="font-size:11px;text-align: center;" width="100%" border="1">

                                                    <thead>

                                                        <tr style="height:50px;">

                                                            <th style="width:8%;text-align: center;text-transform: capitalize;">User</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;">MT</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;white-space: nowrap;">MR</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;">CL</th>

                                                            <th style="width:5%;text-align:center;text-transform: capitalize;">HL</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;">EX</th>

                                                            <th style="width:8%;text-align:center;text-transform: capitalize;">PT</th>

                                                            <th style="width:4%;text-align:center;text-transform: capitalize;">AD</th>

                                                            <th style="width:4%;text-align:center;text-transform: capitalize;">LS</th>

                                                            <th style="width:4%;text-align:center;text-transform: capitalize;">AB</th>

                                                        </tr>

                                                    </thead>

                                                    <tbody>

                                                        <tr  style="height:30px;">

                                                            <td >{{ $personal->name }}</td>

                                                            <td >@if($ml=='') 0 @else {{ $ml }} @endif</td>

                                                            <td >@if($mr=='') 0 @else {{ $mr }} @endif</td>

                                                            <td >@if($cl=='') 0 @else {{ $cl }} @endif</td>

                                                            <td >@if($hl=='') 0 @else {{ $hl }} @endif</td>

                                                            <td >@if($ex=='') 0 @else {{ $ex }} @endif</td>

                                                            <td >@if($pt=='') 0 @else {{ $pt }} @endif</td>

                                                            <td >@if($ad=='') 0 @else {{ $ad }} @endif</td>

                                                            <td >@if($ls=='') 0 @else {{ $ls }} @endif</td>

                                                            <td >@if($ab=='') 0 @else {{ $ab }} @endif</td>

                                                        </tr>

                                                    </tbody>

                                                </table>

                                            </div>

                                        </div>

                                    </div>

                                </div>

                            </div>



                            <div class="row match-height">

                                <div class="col-md-12">

                                    <div class="card">

                                        <div class="card-header">

                                            <h4>Leave Information</h4>

                                           

                                        </div>

                                        <div class="card-body">

                                            <div class="table-responsive" style="padding: 0 15px 15px 15px;">

                                            <form method="GET" action="{{ route('global-search') }}" id="yearFilterForm2" style="width:150px;">
                                                <div class="mb-3">
                                                    <label for="info_year">Select Year:</label>
                                                    <select name="info_year" id="info_year" class="form-control" onchange="document.getElementById('yearFilterForm2').submit();">
                                                        @for ($year = date('Y'); $year > date('Y') - 5; $year--)
                                                            <option value="{{ $year }}" @if((request('info_year') ?? date('Y')) == $year) selected @endif>
                                                                {{ $year }}
                                                            </option>
                                                        @endfor
                                                    </select>
                                                </div>

                                                <!-- Preserve all other query parameters except 'info_year' -->
                                                @foreach(request()->except('info_year') as $name => $value)
                                                    <input type="hidden" name="{{ $name }}" value="{{ $value }}">
                                                @endforeach
                                            </form>

                                                <!--<table  id="example11" class="table table-bordered" style="font-size:11px;text-align: center;" width="100%" border="1">-->

                                                <table class="table table-striped  my-leave-summary-entitle" id="example11" style="font-size:12px;" >

                                                   <thead>

                                                        <tr style="height:50px;">

                                                            <th width="10%" style="text-transform: capitalize;">Date Applied</th>

                                                            <th width="15%" style="text-transform: capitalize;">Relieve</th>

                                                            <th width="10%" style="text-transform: capitalize;white-space: nowrap;">Leave Type</th>

                                                            <th width="10%" style="text-transform: capitalize;">Leave Date</th>

                                                            <th width="7%" style="text-transform: capitalize;">Days</th>

                                                            <th width="23%" style="text-transform: capitalize;">Reason</th>

                                                            <th width="20%" style="text-transform: capitalize;">Status</th>

                                                            

                                                        </tr>

                                                    </thead>

                                                    <tbody>

                                                        @foreach($leaveinformation as $leaveinformations)

                                                    <br />
<b>Fatal error</b>:  Uncaught Error: Class 'DB' not found in /home/ecoleave/public_html/backup/v6/resources/views/E-Leave/global-search.blade.php:798
Stack trace:
#0 {main}
  thrown in <b>/home/ecoleave/public_html/backup/v6/resources/views/E-Leave/global-search.blade.php</b> on line <b>798</b><br />