{{-- layer 1 --}} @if ($printLayer == 1)
@php $grand_disbursementMale = 0; $grand_disbursementFemale = 0; $grand_collectionMale = 0; $grand_collectionFemale = 0; $grand_outstandingMale = 0; $grand_outstandingFemale = 0; @endphp @foreach($fundingOrgs as $fundingOrg) @php $fundStart = 1; $fund_disbursementMale = 0; $fund_disbursementFemale = 0; $fund_collectionMale = 0; $fund_collectionFemale = 0; $fund_outstandingMale = 0; $fund_outstandingFemale = 0; $fundlayers = array_filter($layer1, function($value) use($fundingOrg) { return in_array($fundingOrg->id,json_decode($value->fund_ids)); }); @endphp @if (count($fundingOrgs) > 1) @else @endif @foreach($fundlayers as $components) @php // $productIds = $loanProducts->where('productCategoryId', $loanCategorie->id)->where('fundingOrganizationId', $fundingOrg->id)->pluck('id')->toArray(); $productIds = !empty($components->product_ids) ? $components->product_ids : "0"; $productIds = explode(',',$productIds); // dd($loanData); $curLoanData = $loanData->whereIn('productIdFk', $productIds)->where('fundingOrganizationId',$fundingOrg->id); $curMaleData = $curLoanData->where('genderTypeId', 1); $curFemaleData = $curLoanData->where('genderTypeId', 2); // $disbursementMale =0; // $disbursementFemale =0; $disbursementMale = $curMaleData->sum('cumDisbursement'); $disbursementFemale = $curFemaleData->sum('cumDisbursement'); // $collectionMale =0; // $collectionFemale =0; $collectionMale = $curMaleData->sum('cumPrinCollection'); $collectionFemale = $curFemaleData->sum('cumPrinCollection'); // $outstandingMale=0; // $outstandingFemale=0; $outstandingMale = $disbursementMale-$collectionMale; $outstandingFemale = $disbursementFemale-$collectionFemale; $fund_disbursementMale += $disbursementMale; $fund_disbursementFemale += $disbursementFemale; $fund_collectionMale += $collectionMale; $fund_collectionFemale += $collectionFemale; $fund_outstandingMale += $outstandingMale; $fund_outstandingFemale += $outstandingFemale; $grand_disbursementMale += $disbursementMale; $grand_disbursementFemale += $disbursementFemale; $grand_collectionMale += $collectionMale; $grand_collectionFemale += $collectionFemale; $grand_outstandingMale += $outstandingMale; $grand_outstandingFemale += $outstandingFemale; @endphp @php $fundStart++; @endphp @endforeach @endforeach @if(count($fundingOrgs) > 1) @endif
Note-4 (Layer-1)
SL
Name of main Loan Component
Indicators
Male Female Total
Note-4 ({{$fundingOrg->name}})
Note-4
{{$components->sl_code}} {{$components->name}} Cumulative Loan Disbursement {{num($disbursementMale,$filRoundUup)}} {{num($disbursementFemale,$filRoundUup)}} {{num($disbursementMale+$disbursementFemale,$filRoundUup)}}
Cumulative Loan Collection {{num($collectionMale,$filRoundUup)}} {{num($collectionFemale,$filRoundUup)}} {{num($collectionMale+$collectionFemale,$filRoundUup)}}
Current Outstanding {{num($outstandingMale,$filRoundUup)}} {{num($outstandingFemale,$filRoundUup)}} {{num($outstandingMale+$outstandingFemale,$filRoundUup)}}
Total {{ $fundingOrg->name }} Cumulative Loan Disbursement {{num($fund_disbursementMale,$filRoundUup)}} {{num($fund_disbursementFemale,$filRoundUup)}} {{num($fund_disbursementMale+$fund_disbursementFemale,$filRoundUup)}}
Cumulative Loan Collection {{num($fund_collectionMale,$filRoundUup)}} {{num($fund_collectionFemale,$filRoundUup)}} {{num($fund_collectionMale+$fund_collectionFemale,$filRoundUup)}}
Current Outstanding {{num($fund_outstandingMale,$filRoundUup)}} {{num($fund_outstandingFemale,$filRoundUup)}} {{num($fund_outstandingMale+$fund_outstandingFemale,$filRoundUup)}}
Grand Total Cumulative Loan Disbursement {{num($grand_disbursementMale,$filRoundUup)}} {{num($grand_disbursementFemale,$filRoundUup)}} {{num($grand_disbursementMale+$grand_disbursementFemale,$filRoundUup)}}
Cumulative Loan Collection {{num($grand_collectionMale,$filRoundUup)}} {{num($grand_collectionFemale,$filRoundUup)}} {{num($grand_collectionMale+$grand_collectionFemale,$filRoundUup)}}
Current Outstanding {{num($grand_outstandingMale,$filRoundUup)}} {{num($grand_outstandingFemale,$filRoundUup)}} {{num($grand_outstandingMale+$grand_outstandingFemale,$filRoundUup)}}
@endif {{-- layer 1| End --}} {{-- layer 2 --}} {{-- @if (!empty($layer2)) --}} @if ($printLayer == 2)
@php $grand_disbursementMale = 0; $grand_disbursementFemale = 0; $grand_collectionMale = 0; $grand_collectionFemale = 0; $grand_outstandingMale = 0; $grand_outstandingFemale = 0; @endphp @foreach($fundingOrgs as $fundingOrg) @php $fundStart = 1; $fund_disbursementMale = 0; $fund_disbursementFemale = 0; $fund_collectionMale = 0; $fund_collectionFemale = 0; $fund_outstandingMale = 0; $fund_outstandingFemale = 0; $fundlayers1 = array_filter($layer1, function($value) use($fundingOrg) { return in_array($fundingOrg->id,json_decode($value->fund_ids)); }); $showSideTr = 0; if (array_intersect_key($fundlayers1,$layer2)) { $showSideTr = 1; } // $layer1 = $fundlayers1; @endphp @if (count($fundingOrgs) > 1) @if ($showSideTr > 0) @endif @else @if ($showSideTr > 0) @endif @endif @foreach($fundlayers1 as $components) @php $showTotal = 0; @endphp @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) *3; // $layer2 = $fundlayers2; // $rowspan = count($layer2[$components->id]) *3; @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); $disbursementMale =0; $disbursementFemale =0; $disbursementMale = $curMaleData->sum('cumDisbursement'); $disbursementFemale = $curFemaleData->sum('cumDisbursement'); $collectionMale =0; $collectionFemale =0; $collectionMale = $curMaleData->sum('cumPrinCollection'); $collectionFemale = $curFemaleData->sum('cumPrinCollection'); $outstandingMale=0; $outstandingFemale=0; $outstandingMale = $disbursementMale-$collectionMale; $outstandingFemale = $disbursementFemale-$collectionFemale; $fund_disbursementMale += $disbursementMale; $fund_disbursementFemale += $disbursementFemale; $fund_collectionMale += $collectionMale; $fund_collectionFemale += $collectionFemale; $fund_outstandingMale += $outstandingMale; $fund_outstandingFemale += $outstandingFemale; $grand_disbursementMale += $disbursementMale; $grand_disbursementFemale += $disbursementFemale; $grand_collectionMale += $collectionMale; $grand_collectionFemale += $collectionFemale; $grand_outstandingMale += $outstandingMale; $grand_outstandingFemale += $outstandingFemale; @endphp @if($l2Start ==1) @endif @php $fundStart++; $l2Start++; @endphp @endforeach @endif @endforeach @if ($showTotal > 0) @endif @endforeach {{-- @if(count($fundingOrgs) > 1) --}} {{-- @endif --}}
Note-4 (Layer-2 )
SL
Name of main Loan Component
SUB SL.No.
Name of Sub-Loan Component
Indicators
Male Female Total
Note-4 {{$fundingOrg->name}}
Note-4
{{$components->sl_code}} {{$components->name}}{{$item2->sl_code}} {{$item2->name}} Cumulative Loan Disbursement {{num($disbursementMale,$filRoundUup)}} {{num($disbursementFemale,$filRoundUup)}} {{num($disbursementMale+$disbursementFemale,$filRoundUup)}}
Cumulative Loan Collection {{num($collectionMale,$filRoundUup)}} {{num($collectionFemale,$filRoundUup)}} {{num($collectionMale+$collectionFemale,$filRoundUup)}}
Current Outstanding {{num($outstandingMale,$filRoundUup)}} {{num($outstandingFemale,$filRoundUup)}} {{num($outstandingMale+$outstandingFemale,$filRoundUup)}}
Total {{ $fundingOrg->name }} Cumulative Loan Disbursement {{num($fund_disbursementMale,$filRoundUup)}} {{num($fund_disbursementFemale,$filRoundUup)}} {{num($fund_disbursementMale+$fund_disbursementFemale,$filRoundUup)}}
Cumulative Loan Collection {{num($fund_collectionMale,$filRoundUup)}} {{num($fund_collectionFemale,$filRoundUup)}} {{num($fund_collectionMale+$fund_collectionFemale,$filRoundUup)}}
Current Outstanding {{num($fund_outstandingMale,$filRoundUup)}} {{num($fund_outstandingFemale,$filRoundUup)}} {{num($fund_outstandingMale+$fund_outstandingFemale,$filRoundUup)}}
Grand Total Cumulative Loan Disbursement {{num($grand_disbursementMale,$filRoundUup)}} {{num($grand_disbursementFemale,$filRoundUup)}} {{num($grand_disbursementMale+$grand_disbursementFemale,$filRoundUup)}}
Cumulative Loan Collection {{num($grand_collectionMale,$filRoundUup)}} {{num($grand_collectionFemale,$filRoundUup)}} {{num($grand_collectionMale+$grand_collectionFemale,$filRoundUup)}}
Current Outstanding {{num($grand_outstandingMale,$filRoundUup)}} {{num($grand_outstandingFemale,$filRoundUup)}} {{num($grand_outstandingMale+$grand_outstandingFemale,$filRoundUup)}}
@endif {{-- layer 2| End --}} {{-- layer 3 --}} {{-- @if (!empty($layer3)) --}} @if ($printLayer == 3)
@php $grand_disbursementMale = 0; $grand_disbursementFemale = 0; $grand_collectionMale = 0; $grand_collectionFemale = 0; $grand_outstandingMale = 0; $grand_outstandingFemale = 0; @endphp @foreach($fundingOrgs as $fundingOrg) @php $fundStart = 1; $fund_disbursementMale = 0; $fund_disbursementFemale = 0; $fund_collectionMale = 0; $fund_collectionFemale = 0; $fund_outstandingMale = 0; $fund_outstandingFemale = 0; $fundlayers3 = array_filter($l3SubComponents, function($value) use($fundingOrg) { return in_array($fundingOrg->id,json_decode($value->fund_ids)); }); // $l3SubComponents = $fundlayers3; @endphp @if($fundlayers3) @if (count($fundingOrgs) > 1) @else @endif @endif @foreach($fundlayers3 as $component) @php $showTotal = 0; @endphp @if (isset($layer3[$component->id])) @php $showTotal = 1; $l3Start = 1; $rowspan = count($layer3[$component->id]) *3; @endphp {{-- --}} @foreach ($layer3[$component->id] 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); $disbursementMale =0; $disbursementFemale =0; $disbursementMale = $curMaleData->sum('cumDisbursement'); $disbursementFemale = $curFemaleData->sum('cumDisbursement'); $collectionMale =0; $collectionFemale =0; $collectionMale = $curMaleData->sum('cumPrinCollection'); $collectionFemale = $curFemaleData->sum('cumPrinCollection'); $outstandingMale=0; $outstandingFemale=0; $outstandingMale = $disbursementMale-$collectionMale; $outstandingFemale = $disbursementFemale-$collectionFemale; $fund_disbursementMale += $disbursementMale; $fund_disbursementFemale += $disbursementFemale; $fund_collectionMale += $collectionMale; $fund_collectionFemale += $collectionFemale; $fund_outstandingMale += $outstandingMale; $fund_outstandingFemale += $outstandingFemale; $grand_disbursementMale += $disbursementMale; $grand_disbursementFemale += $disbursementFemale; $grand_collectionMale += $collectionMale; $grand_collectionFemale += $collectionFemale; $grand_outstandingMale += $outstandingMale; $grand_outstandingFemale += $outstandingFemale; @endphp @if ($l3Start == 1) @endif @php $fundStart++; $l3Start ++; @endphp @endforeach @endif @endforeach @if ($showTotal > 0 && $fundlayers3) @endif @endforeach @if(count($fundingOrgs) > 1) @endif
Note-4 (Layer-3)
SUB SL.No.
Name of Sub-Loan Component
Name of Associate Loan Component
Indicators
Male Female Total
Note-4 {{$fundingOrg->name}}
Note-4
{{$component->sl_code}} {{$component->name}}
{{$component->sl_code}} {{$component->name}}{{$item2->name}} Cumulative Loan Disbursement {{num($disbursementMale,$filRoundUup)}} {{num($disbursementFemale,$filRoundUup)}} {{num($disbursementMale+$disbursementFemale,$filRoundUup)}}
Cumulative Loan Collection {{num($collectionMale,$filRoundUup)}} {{num($collectionFemale,$filRoundUup)}} {{num($collectionMale+$collectionFemale,$filRoundUup)}}
Current Outstanding {{num($outstandingMale,$filRoundUup)}} {{num($outstandingFemale,$filRoundUup)}} {{num($outstandingMale+$outstandingFemale,$filRoundUup)}}
Total {{ $fundingOrg->name }} Cumulative Loan Disbursement {{num($fund_disbursementMale,$filRoundUup)}} {{num($fund_disbursementFemale,$filRoundUup)}} {{num($fund_disbursementMale+$fund_disbursementFemale,$filRoundUup)}}
Cumulative Loan Collection {{num($fund_collectionMale,$filRoundUup)}} {{num($fund_collectionFemale,$filRoundUup)}} {{num($fund_collectionMale+$fund_collectionFemale,$filRoundUup)}}
Current Outstanding {{num($fund_outstandingMale,$filRoundUup)}} {{num($fund_outstandingFemale,$filRoundUup)}} {{num($fund_outstandingMale+$fund_outstandingFemale,$filRoundUup)}}
Grand Total Cumulative Loan Disbursement {{num($grand_disbursementMale,$filRoundUup)}} {{num($grand_disbursementFemale,$filRoundUup)}} {{num($grand_disbursementMale+$grand_disbursementFemale,$filRoundUup)}}
Cumulative Loan Collection {{num($grand_collectionMale,$filRoundUup)}} {{num($grand_collectionFemale,$filRoundUup)}} {{num($grand_collectionMale+$grand_collectionFemale,$filRoundUup)}}
Current Outstanding {{num($grand_outstandingMale,$filRoundUup)}} {{num($grand_outstandingFemale,$filRoundUup)}} {{num($grand_outstandingMale+$grand_outstandingFemale,$filRoundUup)}}
@endif {{-- layer 3| End --}}