@php
$grand_noOfMemberMale = 0;
$grand_noOfMemberFemale = 0;
$grand_writeOfAmountMale = 0;
$grand_writeOfAmountFemale = 0;
$grand_scCollection = 0;
$fundingOrgsCount = $fundingOrgs->count();
@endphp
@foreach($fundingOrgs as $fundingOrg)
@php
$fundStart = 1;
$fund_noOfMemberMale = 0;
$fund_noOfMemberFemale = 0;
$fund_writeOfAmountMale = 0;
$fund_writeOfAmountFemale = 0;
$fund_scCollection = 0;
$fundlayer1 = array_filter($layer1, function($value) use($fundingOrg) {
return in_array($fundingOrg->id,json_decode($value->fund_ids));
});
@endphp
@foreach($fundlayer1 as $components)
@if (isset($layer2[$components->id]))
@php
$showTotal = 1;
$l2Start = 1;
$fundlayers2 = array_filter($layer2[$components->id], function($value) use($fundingOrg) {
return in_array($fundingOrg->id,json_decode($value->fund_ids));
});
$rowspan = count($fundlayers2);
@endphp
@foreach ($fundlayers2 as $item2)
@php
// $productIds = $loanProducts->where('productCategoryId', $loanCategorie->id)->where('fundingOrganizationId', $fundingOrg->id)->pluck('id')->toArray();
$productIds = !empty($item2->product_ids) ? $item2->product_ids : "0";
$productIds = explode(',',$productIds);
$curLoanData = $loanData->whereIn('productIdFk', $productIds)->where('fundingOrganizationId',$fundingOrg->id);
$curMaleData = $curLoanData->where('genderTypeId', 1);
$curFemaleData = $curLoanData->where('genderTypeId', 2);
$noOfMemberMale = $curMaleData->sum('cumWriteOfMember');
$noOfMemberFemale = $curFemaleData->sum('cumWriteOfMember');
$writeOfAmountMale = $curMaleData->sum('cumWriteOfAmount');
$writeOfAmountFemale = $curFemaleData->sum('cumWriteOfAmount');
$scCollection = $catgCumServiceCharges->where('fundingOrganizationId', $fundingOrg->id)->where('layerId',$item2->id)->sum('cumSerCharge');
$fund_noOfMemberMale += $noOfMemberMale;
$fund_noOfMemberFemale += $noOfMemberFemale;
$fund_writeOfAmountMale += $writeOfAmountMale;
$fund_writeOfAmountFemale += $writeOfAmountFemale;
$fund_scCollection += $scCollection;
$grand_noOfMemberMale += $noOfMemberMale;
$grand_noOfMemberFemale += $noOfMemberFemale;
$grand_writeOfAmountMale += $writeOfAmountMale;
$grand_writeOfAmountFemale += $writeOfAmountFemale;
$grand_scCollection += $scCollection;
@endphp
@if($fundStart == 1) | {{ $fundingOrg->name }} | @endif
@if ($l2Start == 1)
{{ $components->sl_code }} |
{{ $components->name }} |
@endif
{{$item2->sl_code}} |
{{$item2->name}} |
{{$noOfMemberMale}} |
{{num($writeOfAmountMale,$filRoundUup)}} |
{{$noOfMemberFemale}} |
{{num($writeOfAmountFemale,$filRoundUup)}} |
{{$noOfMemberMale+$noOfMemberFemale}} |
{{num($writeOfAmountMale+$writeOfAmountFemale,$filRoundUup)}} |
{{num($scCollection,$filRoundUup)}} |
@php
$fundStart++;
$l2Start ++;
@endphp
@endforeach
@endif
@endforeach
| Total {{ $fundingOrg->name }} |
{{$fund_noOfMemberMale}} |
{{num($fund_writeOfAmountMale,$filRoundUup)}} |
{{$fund_noOfMemberFemale}} |
{{num($fund_writeOfAmountFemale,$filRoundUup)}} |
{{$fund_noOfMemberMale+$fund_noOfMemberFemale}} |
{{num($fund_writeOfAmountMale+$fund_writeOfAmountFemale,$filRoundUup)}} |
{{num($fund_scCollection,$filRoundUup)}} |
@endforeach
| Grand Total |
{{$grand_noOfMemberMale}} |
{{num($grand_writeOfAmountMale,$filRoundUup)}} |
{{$grand_noOfMemberFemale}} |
{{num($grand_writeOfAmountFemale,$filRoundUup)}} |
{{$grand_noOfMemberMale+$grand_noOfMemberFemale}} |
{{num($grand_writeOfAmountMale+$grand_writeOfAmountFemale,$filRoundUup)}} |
{{num($grand_scCollection,$filRoundUup)}} |