| {{ ++$loop->index }} |
{{ $user->emp_name_english }} |
{{ $user->emp_id }} |
{{ $user->designation }} |
{{ date( 'd-m-Y', strtotime($user->joining_date) ) }} |
{{ $user->branchName }} |
{{-- Under ob --}}
@if($user->obPfOwn)
{{ number_format($user->obPfOwn,2) }}
@else
-
@endif
|
@if($user->obPfOrg)
{{ number_format($user->obPfOrg,2) }}
@else
-
@endif
|
@if($user->obPfInterest)
{{ number_format($user->obPfInterest,2) }}
@else
-
@endif
|
{{ number_format($user->obPfTotal,2) }} |
@php
$totalObPfOwn += $user->obPfOwn;
$totalObPfOrg += $user->obPfOrg;
$totalObPfInt += $user->obPfInterest;
$totalObPfTotal += $user->obPfTotal;
@endphp
{{-- Under Current Period Recovery --}}
@if($user->ownCurrentRecovery)
{{ number_format($user->ownCurrentRecovery,2) }}
@else
-
@endif
|
@if($user->orgCurrentRecovery)
{{ number_format($user->orgCurrentRecovery,2) }}
@else
-
@endif
|
@if($user->intCurrentRecovery)
{{ number_format($user->intCurrentRecovery,2) }}
@else
-
@endif
|
@if($user->totalCurrentRecovery)
{{ number_format($user->totalCurrentRecovery,2) }}
@else
-
@endif
|
@php
$totalCurrentRecoveryOwn += $user->ownCurrentRecovery;
$totalCurrentRecoveryOrg += $user->orgCurrentRecovery;
$totalCurrentRecoveryInt += $user->intCurrentRecovery;
$totalCurrentRecoveryTotal += $user->totalCurrentRecovery;
@endphp
{{-- Under Current Period Refund --}}
@if($user->cpRefundEmpAmount)
{{ number_format($user->cpRefundEmpAmount,2) }}
@else
-
@endif
|
@if($user->cpRefundOrgAmount)
{{ number_format($user->cpRefundOrgAmount,2) }}
@else
-
@endif
|
@if($user->cpRefundIntAmount)
{{ number_format($user->cpRefundIntAmount,2) }}
@else
-
@endif
|
@if($user->cpRefundTotalAmount)
{{ number_format($user->cpRefundTotalAmount,2) }}
@else
-
@endif
|
@php
$totalCurrentPeriodRefundOwn += $user->cpRefundEmpAmount;
$totalCurrentPeriodRefundOrg += $user->cpRefundOrgAmount;
$totalCurrentPeriodRefundInt += $user->cpRefundIntAmount;
$totalCurrentPeriodRefundTotal += $user->cpRefundTotalAmount;
@endphp
{{-- Under closing balance --}}
@if($user->cbOwn)
{{ number_format($user->cbOwn,2) }}
@else
-
@endif
|
@if($user->cbOrg)
{{ number_format($user->cbOrg,2) }}
@else
-
@endif
|
@if($user->cbInt)
{{ number_format($user->cbInt,2) }}
@else
-
@endif
|
@if($user->cbTotal)
{{ number_format($user->cbTotal,2) }}
@else
-
@endif
|
@php
$totalCbOwn += $user->cbOwn;
$totalCbOrg += $user->cbOrg;
$totalCbInt += $user->cbInt;
$totalCbTotal += $user->cbTotal;
@endphp
@endforeach
{{-- Table Footer --}}
| Total |
{{-- OB Total --}}
@if($totalObPfOwn)
{{ number_format($totalObPfOwn,2) }}
@else
-
@endif
|
@if($totalObPfOrg)
{{ number_format($totalObPfOrg,2) }}
@else
-
@endif
|
@if($totalObPfInt)
{{ number_format($totalObPfInt,2) }}
@else
-
@endif
|
@if($totalObPfTotal)
{{ number_format($totalObPfTotal,2) }}
@else
-
@endif
|
{{-- Current Period Deposit Total --}}
@if($totalCurrentRecoveryOwn)
{{ number_format($totalCurrentRecoveryOwn,2) }}
@else
-
@endif
|
@if($totalCurrentRecoveryOrg)
{{ number_format($totalCurrentRecoveryOrg,2) }}
@else
-
@endif
|
@if($totalCurrentRecoveryInt)
{{ number_format($totalCurrentRecoveryInt,2) }}
@else
-
@endif
|
@if($totalCurrentRecoveryTotal)
{{ number_format($totalCurrentRecoveryTotal,2) }}
@else
-
@endif
|
{{-- Current Period Refund total --}}
@if($totalCurrentPeriodRefundOwn)
{{ number_format($totalCurrentPeriodRefundOwn,2) }}
@else
-
@endif
|
@if($totalCurrentPeriodRefundOrg)
{{ number_format($totalCurrentPeriodRefundOrg,2) }}
@else
-
@endif
|
@if($totalCurrentPeriodRefundInt)
{{ number_format($totalCurrentPeriodRefundInt,2) }}
@else
-
@endif
|
@if($totalCurrentPeriodRefundTotal)
{{ number_format($totalCurrentPeriodRefundTotal,2) }}
@else
-
@endif
|
{{-- Closing Balance Total --}}
@if($totalCbOwn)
{{ number_format($totalCbOwn,2) }}
@else
-
@endif
|
@if($totalCbOrg)
{{ number_format($totalCbOrg,2) }}
@else
-
@endif
|
@if($totalCbInt)
{{ number_format($totalCbInt,2) }}
@else
-
@endif
|
@if($totalCbTotal)
{{ number_format($totalCbTotal,2) }}
@else
-
@endif
|