@php
$serial = 1;
$zoneRawSpan = 0;
$zoneCount = 0;
//Grand Total
$grandFullPaidSavingsAmountSubTotal = 0;
$grandpartialPaidSavingsAmountSubTotal = 0;
$grandPrincipalSubTotal = 0;
$grandInterestSubTotal = 0;
$grandTotalSubTotal = 0;
@endphp
@foreach ($reportData['data'] as $zone)
@php
$zoneCount++;
$zoneNum = 0;
$zoneRawSpan = count($zone['areaInfo']);
foreach ($zone['areaInfo'] as $area) {
$zoneRawSpan += count($area['branchInfo']);
}
$areaRawSpan = 0;
//sub total of zone
$zoneFullPaidSavingsAmountSubTotal = 0;
$zonepartialPaidSavingsAmountSubTotal = 0;
$zonePrincipalSubTotal = 0;
$zoneInterestSubTotal = 0;
$zoneTotalSubTotal = 0;
@endphp
@foreach ($zone['areaInfo'] as $area)
@php
$areaNum = 0;
$areaRawSpan = count($area['branchInfo']);
$areaFullPaidSavingsAmountSubTotal = 0;
$areapartialPaidSavingsAmountSubTotal = 0;
$areaPrincipalSubTotal = 0;
$areaInterestSubTotal = 0;
$areaTotalSubTotal = 0;
@endphp
@foreach ($area['branchInfo'] as $branch)
@php
$zoneNum++;
$areaNum++;
//sub total of area
$areaFullPaidSavingsAmountSubTotal += $branch['fullPaidSavingsAmount'];
$areapartialPaidSavingsAmountSubTotal += $branch['partialPaidSavingsAmount'];
$areaPrincipalSubTotal += $branch['principal'];
$areaInterestSubTotal += $branch['interest'];
$areaTotalSubTotal += $branch['total'];
@endphp
@if ($zoneNum == 1)
| {{$serial++}} |
{{$zone['zoneNameCode']}} |
@endif
@if ($areaNum == 1)
{{$area['areaNameCode']}} |
@endif
{{$branch['branchNameCode']}} |
{{number_format($branch['fullPaidSavingsAmount'], 2) == 0 ? '-': number_format($branch['fullPaidSavingsAmount'], 2)}} |
{{number_format($branch['partialPaidSavingsAmount'],2) == 0 ? '-': number_format($branch['partialPaidSavingsAmount'],2)}} |
{{number_format($branch['principal'],2) == 0 ? '-': number_format($branch['principal'],2)}} |
{{number_format($branch['interest'], 2) == 0 ? '-': number_format($branch['interest'], 2)}} |
{{number_format($branch['total'], 2) == 0 ? '-': number_format($branch['total'], 2)}} |
@endforeach
@php
$zoneFullPaidSavingsAmountSubTotal += $areaFullPaidSavingsAmountSubTotal;
$zonepartialPaidSavingsAmountSubTotal += $areapartialPaidSavingsAmountSubTotal;
$zonePrincipalSubTotal += $areaPrincipalSubTotal;
$zoneInterestSubTotal += $areaInterestSubTotal;
$zoneTotalSubTotal += $areaTotalSubTotal;
@endphp
| Sub Total |
{{number_format($areaFullPaidSavingsAmountSubTotal, 2)}} |
{{number_format($areapartialPaidSavingsAmountSubTotal, 2)}} |
{{number_format($areaPrincipalSubTotal, 2)}} |
{{number_format($areaInterestSubTotal, 2)}} |
{{number_format($areaTotalSubTotal, 2)}} |
@endforeach
@php
$grandFullPaidSavingsAmountSubTotal += $zoneFullPaidSavingsAmountSubTotal;
$grandpartialPaidSavingsAmountSubTotal += $zonepartialPaidSavingsAmountSubTotal;
$grandPrincipalSubTotal += $zonePrincipalSubTotal;
$grandInterestSubTotal += $zoneInterestSubTotal;
$grandTotalSubTotal += $zoneTotalSubTotal;
@endphp
| Sub Total |
{{number_format($zoneFullPaidSavingsAmountSubTotal, 2)}} |
{{number_format($zonepartialPaidSavingsAmountSubTotal, 2)}} |
{{number_format($zonePrincipalSubTotal, 2)}} |
{{number_format($zoneInterestSubTotal, 2)}} |
{{number_format($zoneTotalSubTotal, 2)}} |
@php
if ($zoneCount % 2 == 0 && !$loop->last) {
echo '