@php $grand_noOfMemberMale = 0; $grand_noOfMemberFemale = 0; $grand_writeOfAmountMale = 0; $grand_writeOfAmountFemale = 0; $grand_scCollection = 0; $fundStart = 1; @endphp @foreach($layer1 as $loanCategorie) @php // $productIds = $loanProducts->where('productCategoryId', $loanCategorie->id)->whereIn('fundingOrganizationId', $pksfOthersFundingOrgs)->pluck('id')->toArray(); $productIds = !empty($loanCategorie->product_ids) ? $loanCategorie->product_ids : "0"; $productIds = explode(',',$productIds); $curLoanData = $loanData->whereIn('productIdFk', $productIds); $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->whereIn('fundingOrganizationId', $pksfOthersFundingOrgs)->where('layerId',$loanCategorie->id)->sum('cumSerCharge'); $grand_noOfMemberMale += $noOfMemberMale; $grand_noOfMemberFemale += $noOfMemberFemale; $grand_writeOfAmountMale += $writeOfAmountMale; $grand_writeOfAmountFemale += $writeOfAmountFemale; $grand_scCollection += $scCollection; @endphp @if($fundStart == 1) @endif @php $fundStart++; @endphp @endforeach @if(count($fundingOrgs) > 1) @endif

Component			Cumulative Write Off Information						Cumulative Service Charge Collection
Funding Organization Name	SL	Loan Product Category Name	Male		Female		Total
			No. of Member	Amount	No. of Member	Amount	No. of Member	Amount
{{ $filFundingOrgName }}	{{$loanCategorie->sl_code}}	{{$loanCategorie->name}}	{{$noOfMemberMale}}	{{num($writeOfAmountMale,$filRoundUup)}}	{{$noOfMemberFemale}}	{{num($writeOfAmountFemale,$filRoundUup)}}	{{$noOfMemberMale+$noOfMemberFemale}}	{{num($writeOfAmountMale+$writeOfAmountFemale,$filRoundUup)}}	{{num($scCollection,$filRoundUup)}}
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)}}