| Type |
Entitled |
Taken |
Balance |
| Carried Forward |
{{ $leaves->carry_forward ?? '0' }} |
N/A |
N/A |
| AL |
{{ ($leaves->AL ?? '0') + $ALtaken}} |
{{ $ALtaken }} |
{{ $leaves->AL ?? 0 }} |
| RL |
{{ ($leaves->RL ?? '0') + $RLtaken}} |
{{ $RLtaken }} |
{{ $leaves->RL ?? 0 }} |
| Total AL |
{{ (($leaves->AL ?? '0') + $ALtaken) + ($leaves->carry_forward ?? 0) }} |
{{ $ALtaken }} |
{{ $leaves->AL ?? 0 }} |
| EL |
{{ ($leaves->EL ?? '0') + $ELtaken}} |
{{ $ELtaken }} |
{{ $leaves->EL ?? 0 }} |
| ML |
{{ ($leaves->ML ?? '0') + $MLtaken}} |
{{ $MLtaken }} |
{{ $leaves->ML ?? 0 }} |
| HOSP |
{{ ($leaves->HOSP ?? '0') + $HOSPtaken}} |
{{ $HOSPtaken }} |
{{ $leaves->HOSP ?? 0 }} |
| MTL |
{{ ($leaves->MTL ?? '0') + $MTLtaken}} |
{{ $MTLtaken }} |
{{ $leaves->MTL ?? 0 }} |
| PTL |
{{ ($leaves->PTL ?? '0') + $PTLtaken}} |
{{ $PTLtaken }} |
{{ $leaves->PTL ?? 0 }} |
| CL |
{{ ($leaves->CL ?? '0') + $CLtaken}} |
{{ $CLtaken }} |
{{ $leaves->CL ?? 0 }} |
| CML |
{{ ($leaves->CML ?? '0') + $CMLtaken}} |
{{ $CMLtaken }} |
{{ $leaves->CML ?? 0 }} |
| MGL |
{{ ($leaves->MGL ?? '0') + $MGLtaken}} |
{{ $MGLtaken }} |
{{ $leaves->MGL ?? 0 }} |
| PI |
{{ ($leaves->PI ?? '0') + $PItaken}} |
{{ $PItaken }} |
{{ $leaves->PI ?? 0 }} |
| UPL |
N/A |
{{ $UPLtaken }} |
N/A |
| Date |
Annual Leave Info |
MC |
UPL |
Reason |
Remark |
| Apply |
Start |
End |
AL Taken |
EL Taken |
T |
Bal AL |
ML Taken |
Bal |
@if($leaveapply->isEmpty())
| NO LEAVE APPLIED |
@else
@php
$entitledAL = DB::table('leave_entitled')
->where('user_id', $leaveapply->first()->user_id)
->where('year_entitled', date('Y'))
->value('total_AL');
$entitledML = DB::table('leave_entitled')
->where('user_id', $leaveapply->first()->user_id)
->where('year_entitled', date('Y'))
->value('ML');
$ALTaken = 0;
$ELTaken = 0;
$MLTaken = 0;
$ULTaken = 0;
$TSTaken = 0;
@endphp
@foreach($leaveapply as $leave)
@php
if ($leave->leave_type_id == 1) {
$ALTaken += $leave->total_days;
}
if ($leave->leave_type_id == 2) {
$ELTaken += $leave->total_days;
}
if ($leave->leave_type_id == 3) {
$MLTaken += $leave->total_days;
}
if ($leave->leave_type_id == 4) {
$ULTaken += $leave->total_days;
}
if ($leave->leave_type_id == 15) {
$TSTaken += $leave->total_days;
}
$ALBalance = $entitledAL - $ALTaken;
$MLBalance = $entitledML - $MLTaken;
@endphp
| {{ \Carbon\Carbon::parse($leave->created_date)->format('l, d M Y') }} |
{{ \Carbon\Carbon::parse($leave->start_date)->format('l, d M Y') }} |
{{ \Carbon\Carbon::parse($leave->end_date)->format('l, d M Y') }} |
{{ $ALTaken }} |
{{ $ELTaken }} |
{{ $TSTaken }} |
{{ $ALBalance }} |
{{ $MLTaken }} |
{{ $MLBalance }} |
{{ $ULTaken }} |
{{ $leave->reason }} |
{{ $leave->leavetype_code }} [{{ $leave->total_days}} DAYS] |
@endforeach
@endif