@if (empty($config) || $config['writeoff'] == true)
@if ($printLayer == 1) @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; $fundlayers = array_filter($layer1, function($value) use($fundingOrg) { return in_array($fundingOrg->id,json_decode($value->fund_ids)); }); @endphp @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); $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',$components->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) @endif @php $fundStart++; @endphp @endforeach @endforeach
Layer-1
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
{{ $fundingOrg->name }}{{$components->sl_code}} {{$components->name}} {{$noOfMemberMale}} {{num($writeOfAmountMale,$filRoundUup)}} {{$noOfMemberFemale}} {{num($writeOfAmountFemale,$filRoundUup)}} {{$noOfMemberMale+$noOfMemberFemale}} {{num($writeOfAmountMale+$writeOfAmountFemale,$filRoundUup)}} {{num($scCollection,$filRoundUup)}}
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)}}
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)}}
@endif @if ($printLayer == 2) @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) @endif @if ($l2Start == 1) @endif @php $fundStart++; $l2Start ++; @endphp @endforeach @endif @endforeach @endforeach
Layer-2
Component Cumulative Write Off Information Total Cumulative Service Charge Collection
Funding Organization Name SL Name Of Main Component Sub SL Loan Product Category Name Male Female
No. of Member Amount No. of Member Amount No. of Member Amount
{{ $fundingOrg->name }}{{ $components->sl_code }} {{ $components->name }}{{$item2->sl_code}} {{$item2->name}} {{$noOfMemberMale}} {{num($writeOfAmountMale,$filRoundUup)}} {{$noOfMemberFemale}} {{num($writeOfAmountFemale,$filRoundUup)}} {{$noOfMemberMale+$noOfMemberFemale}} {{num($writeOfAmountMale+$writeOfAmountFemale,$filRoundUup)}} {{num($scCollection,$filRoundUup)}}
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)}}
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)}}
@endif @if ($printLayer == 3) {{-- --}} @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; $fundlayers3 = array_filter($l3SubComponents, function($value) use($fundingOrg) { return in_array($fundingOrg->id,json_decode($value->fund_ids)); }); @endphp @foreach($fundlayers3 as $component) @if (isset($layer3[$component->id])) @php $showTotal = 1; $l3Start = 1; $rowspan = count($layer3[$component->id]); @endphp @foreach ($layer3[$component->id] as $item3) @php // $productIds = $loanProducts->where('productCategoryId', $loanCategorie->id)->where('fundingOrganizationId', $fundingOrg->id)->pluck('id')->toArray(); $productIds = !empty($item3->product_ids) ? $item3->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',$item3->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) @endif @if ($l3Start == 1) @endif {{-- --}} @php $fundStart++; $l3Start++; @endphp @endforeach @endif @endforeach @endforeach
Layer-3
Component Cumulative Write Off Information Total Cumulative Service Charge Collection
Funding Organization Name Sub SL Name Of Sub-Loan Component SLLoan Product Category Name Male Female
No. of Member Amount No. of Member Amount No. of Member Amount
{{ $fundingOrg->name }}{{ $component->sl_code }} {{ $component->name }}{{$item3->sl_code}}{{$item3->name}} {{$noOfMemberMale}} {{num($writeOfAmountMale,$filRoundUup)}} {{$noOfMemberFemale}} {{num($writeOfAmountFemale,$filRoundUup)}} {{$noOfMemberMale+$noOfMemberFemale}} {{num($writeOfAmountMale+$writeOfAmountFemale,$filRoundUup)}} {{num($scCollection,$filRoundUup)}}
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)}}
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)}}
@endif
@else
@if ($printLayer != 3) @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; $fundlayers = array_filter($layer1, function($value) use($fundingOrg) { return in_array($fundingOrg->id,json_decode($value->fund_ids)); }); @endphp @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); $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',$components->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) @endif @php $fundStart++; @endphp @endforeach @endforeach
Layer-1
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
{{ $fundingOrg->name }}{{$components->sl_code}} {{$components->name}} {{$noOfMemberMale}} {{num($writeOfAmountMale,$filRoundUup)}} {{$noOfMemberFemale}} {{num($writeOfAmountFemale,$filRoundUup)}} {{$noOfMemberMale+$noOfMemberFemale}} {{num($writeOfAmountMale+$writeOfAmountFemale,$filRoundUup)}} {{num($scCollection,$filRoundUup)}}
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)}}
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)}}
@endif
@endif