{{-- layer 1 --}}
<div class="row" id="layer1">
    <div class="col-lg-12">
        <div class="table-responsive">
            <table id="tableSix" class="table table-striped table-bordered pomisOne" border="1pt solid ash" style="color:black; border-collapse: collapse;">
                <tbody>
                    <tr class="tableHead"><th colspan="7">Layer-1</th></tr></tr>
                    <tr class="tableHead">
                        <th colspan="2" align="left"><div align="left">SL</div></th>
                        <th align="left"><div align="left">Name of main Loan Component</div></th>
                        <th align="left"><div align="left">Indicators</div></th>
                        <th width="15%" align="center">Male</th>
                        <th width="14%" align="center">Female</th>
                        <th width="15%" align="center">Total</th>
                    </tr>
                    
                    @php 
                        $grand_disbursementMale = 0;
                        $grand_disbursementFemale = 0;
                        $grand_collectionMale = 0;
                        $grand_collectionFemale = 0;
                        $grand_outstandingMale = 0;
                        $grand_outstandingFemale = 0;
                    @endphp
                    @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($pksfOthersFundingOrgs){
                            return array_intersect($pksfOthersFundingOrgs,json_decode($value->fund_ids));
                        });
                    @endphp
                    <tr>
                        <td rowspan="{{sizeof($fundlayers)*3 +1}}" align="center" valign="middle" nowrap="nowrap"  class="note"><div class="rotating">Note-4 ({{$filFundingOrgName}})</div></td>
                    </tr>
                    @foreach($fundlayers as $components)
                        @php 
                            $productIds = !empty($components->product_ids) ? $components->product_ids : "0";
                            $productIds = explode(',',$productIds);
                            // dd($loanData);
                            $curLoanData = $loanData->whereIn('productIdFk', $productIds)->whereIn('fundingOrganizationId',$pksfOthersFundingOrgs);
                            $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
                        <tr>
                            <td rowspan="3">{{$components->sl_code}}</td>
                            <td rowspan="3" class="name">{{$components->name}}</td>
                            <td class="name">Cumulative Loan Disbursement </td>
                            <td class="amount">{{num($disbursementMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($disbursementFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($disbursementMale+$disbursementFemale,$filRoundUup)}}</td>
                        </tr>

                        <tr>
                            <td class="name">Cumulative Loan Collection	</td>
                            <td class="amount">{{num($collectionMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($collectionFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($collectionMale+$collectionFemale,$filRoundUup)}}</td>
                        </tr>

                        <tr style="font-weight:bold">
                            <td class="name">Current Outstanding	</td>
                            <td class="amount">{{num($outstandingMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($outstandingFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($outstandingMale+$outstandingFemale,$filRoundUup)}}</td>
                        </tr>
                        @php $fundStart++; @endphp
                    @endforeach
                    {{-- @if(count($fundingOrgs) > 1) --}}
                        <tr class="grandTotal"  style="font-weight:bold">
                            <th colspan="3" align="center" valign="middle" nowrap="nowrap" rowspan="3"><strong>Grand Total</strong></th>
                            <td class="name">Cumulative Loan Disbursement</td>
                            <td class="amount">{{num($grand_disbursementMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($grand_disbursementFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($grand_disbursementMale+$grand_disbursementFemale,$filRoundUup)}}</td>
                        </tr>
                        <tr class="subTotalTr"  style="font-weight:bold">
                            <td class="name">Cumulative Loan Collection	</td>
                            <td class="amount">{{num($grand_collectionMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($grand_collectionFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($grand_collectionMale+$grand_collectionFemale,$filRoundUup)}}</td>
                        </tr>
                        <tr class="subTotalTr"  style="font-weight:bold">
                            <td class="name">Current Outstanding</td>
                            <td class="amount">{{num($grand_outstandingMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($grand_outstandingFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($grand_outstandingMale+$grand_outstandingFemale,$filRoundUup)}}</td>
                        </tr>
                    {{-- @endif --}}
                </tbody>
            </table>

        </div>
    </div>
</div>
{{-- layer 1| End --}}

{{-- layer 2 --}}
@if (!empty($layer2))
<div class="row" id="layer2">
    <div class="col-lg-12">
        <div class="table-responsive">
            <table id="tableSix" class="table table-striped table-bordered pomisOne" border="1pt solid ash" style="color:black; border-collapse: collapse;">
                <tbody>
                    <tr class="tableHead"><th colspan="9">Layer-2</th></tr></tr>
                    <tr class="tableHead">
                        <th colspan="2" align="left"><div align="left">SL</div></th>
                        <th align="left"><div align="left">Name of main Loan Component</div></th>
                        <th align="left"><div align="left">SUB SL.No.</div></th>
                        <th align="left"><div align="left">Name of Sub-Loan Component</div></th>
                        <th align="left"><div align="left">Indicators</div></th>
                        <th width="15%" align="center">Male</th>
                        <th width="14%" align="center">Female</th>
                        <th width="15%" align="center">Total</th>
                    </tr>
                    
                    @php 
                        $grand_disbursementMale = 0;
                        $grand_disbursementFemale = 0;
                        $grand_collectionMale = 0;
                        $grand_collectionFemale = 0;
                        $grand_outstandingMale = 0;
                        $grand_outstandingFemale = 0;
                    @endphp
                    @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($pksfOthersFundingOrgs){
                            return array_intersect($pksfOthersFundingOrgs,json_decode($value->fund_ids));
                        });
                        // $layer1 = $fundlayers1;
                    @endphp
                    <tr>
                        <td rowspan="{{$layer2Rowspan }}" align="center" valign="middle" nowrap="nowrap"  class="note"><div class="rotating">Note-4 ({{$filFundingOrgName}})</div></td>
                    </tr>
                    @foreach($fundlayers1 as $components) 
                        @if (isset($layer2[$components->id]))
                            @php
                                $l2Start = 1;
                                $fundlayers2 = array_filter($layer2[$components->id], function($value) use($pksfOthersFundingOrgs){
                                    return array_intersect($pksfOthersFundingOrgs,json_decode($value->fund_ids));
                                });
                                
                                $rowspan = count($fundlayers2) *3;
                                // $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)->whereIn('fundingOrganizationId',$pksfOthersFundingOrgs);
                                    $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
                                
                                <tr>
                                    @if($l2Start ==1)
                                    <td rowspan="{{$rowspan}}">{{$components->sl_code}}</td>
                                    <td rowspan="{{$rowspan}}">{{$components->name}}</td>
                                    @endif
                                    <td rowspan="3">{{$item2->sl_code}}</td>
                                    <td rowspan="3" class="name">{{$item2->name}}</td>
                                    <td class="name">Cumulative Loan Disbursement </td>
                                    <td class="amount">{{num($disbursementMale,$filRoundUup)}}</td>
                                    <td class="amount">{{num($disbursementFemale,$filRoundUup)}}</td>
                                    <td class="amount">{{num($disbursementMale+$disbursementFemale,$filRoundUup)}}</td>
                                </tr>

                                <tr>
                                    <td class="name">Cumulative Loan Collection	</td>
                                    <td class="amount">{{num($collectionMale,$filRoundUup)}}</td>
                                    <td class="amount">{{num($collectionFemale,$filRoundUup)}}</td>
                                    <td class="amount">{{num($collectionMale+$collectionFemale,$filRoundUup)}}</td>
                                </tr>

                                <tr style="font-weight:bold">
                                    <td class="name">Current Outstanding	</td>
                                    <td class="amount">{{num($outstandingMale,$filRoundUup)}}</td>
                                    <td class="amount">{{num($outstandingFemale,$filRoundUup)}}</td>
                                    <td class="amount">{{num($outstandingMale+$outstandingFemale,$filRoundUup)}}</td>
                                </tr>
                                @php 
                                    $fundStart++; 
                                    $l2Start++;
                                @endphp
                            @endforeach
                        @endif
                    @endforeach
                    {{-- @if(count($fundingOrgs) > 1) --}}
                        <tr class="grandTotal"  style="font-weight:bold">
                            <th colspan="5" align="center" valign="middle" nowrap="nowrap" rowspan="3"><strong>Grand Total</strong></th>
                            <td class="name">Cumulative Loan Disbursement</td>
                            <td class="amount">{{num($grand_disbursementMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($grand_disbursementFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($grand_disbursementMale+$grand_disbursementFemale,$filRoundUup)}}</td>
                        </tr>
                        <tr class="subTotalTr"  style="font-weight:bold">
                            <td class="name">Cumulative Loan Collection	</td>
                            <td class="amount">{{num($grand_collectionMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($grand_collectionFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($grand_collectionMale+$grand_collectionFemale,$filRoundUup)}}</td>
                        </tr>
                        <tr class="subTotalTr"  style="font-weight:bold">
                            <td class="name">Current Outstanding</td>
                            <td class="amount">{{num($grand_outstandingMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($grand_outstandingFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($grand_outstandingMale+$grand_outstandingFemale,$filRoundUup)}}</td>
                        </tr>
                    {{-- @endif --}}
                </tbody>
            </table>

        </div>
    </div>
</div>
@endif
{{-- layer 2| End --}}

{{-- layer 3 --}}
@if (!empty($layer3))
<div class="row" id="layer3">
    <div class="col-lg-12">
        <div class="table-responsive">
            <table id="tableSix" class="table table-striped table-bordered pomisOne" border="1pt solid ash" style="color:black; border-collapse: collapse;">
                <tbody>
                    <tr class="tableHead"><th colspan="9">Layer-3</th></tr>
                    <tr class="tableHead">
                        <th colspan="2" align="left"><div align="left">SUB SL.No.</div></th>
                        <th align="left"><div align="left">Name of Sub-Loan Component</div></th>
                        <th align="left"><div align="left">Name of Associate Loan Component</div></th>
                        <th align="left"><div align="left">Indicators</div></th>
                        <th width="15%" align="center">Male</th>
                        <th width="14%" align="center">Female</th>
                        <th width="15%" align="center">Total</th>
                    </tr>
                    
                    @php 
                        $grand_disbursementMale = 0;
                        $grand_disbursementFemale = 0;
                        $grand_collectionMale = 0;
                        $grand_collectionFemale = 0;
                        $grand_outstandingMale = 0;
                        $grand_outstandingFemale = 0;
                    @endphp
                        @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($pksfOthersFundingOrgs){
                                return array_intersect($pksfOthersFundingOrgs,json_decode($value->fund_ids));
                            });
                            // $l3SubComponents = $fundlayers3;
                        @endphp
                        <tr>
                            <td rowspan="{{$layer3Rowspan }}" align="center" valign="middle" nowrap="nowrap"  class="note"><div class="rotating">Note-4 ({{$filFundingOrgName}})</div></td>
                        </tr>

                        @foreach($fundlayers3 as $component) 
                            @if (isset($layer3[$component->id]))
                                @php
                                    $l3Start = 1;
                                    $rowspan = count($layer3[$component->id]) *3;
                                @endphp
                                {{-- <tr>
                                    <td rowspan="{{$rowspan +1}}">{{$component->sl_code}}</td>
                                    <td rowspan="{{$rowspan +1}}">{{$component->name}}</td>
                                </tr> --}}
                                @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)->whereIn('fundingOrganizationId',$pksfOthersFundingOrgs);
                                        $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
                                    <tr>
                                        @if ($l3Start == 1)
                                            <td rowspan="{{$rowspan}}">{{$component->sl_code}}</td>
                                            <td rowspan="{{$rowspan}}">{{$component->name}}</td>
                                        @endif
                                        <td rowspan="3" class="name">{{$item2->name}}</td>
                                        <td class="name">Cumulative Loan Disbursement </td>
                                        <td class="amount">{{num($disbursementMale,$filRoundUup)}}</td>
                                        <td class="amount">{{num($disbursementFemale,$filRoundUup)}}</td>
                                        <td class="amount">{{num($disbursementMale+$disbursementFemale,$filRoundUup)}}</td>
                                    </tr>

                                    <tr>
                                        <td class="name">Cumulative Loan Collection	</td>
                                        <td class="amount">{{num($collectionMale,$filRoundUup)}}</td>
                                        <td class="amount">{{num($collectionFemale,$filRoundUup)}}</td>
                                        <td class="amount">{{num($collectionMale+$collectionFemale,$filRoundUup)}}</td>
                                    </tr>

                                    <tr style="font-weight:bold">
                                        <td class="name">Current Outstanding	</td>
                                        <td class="amount">{{num($outstandingMale,$filRoundUup)}}</td>
                                        <td class="amount">{{num($outstandingFemale,$filRoundUup)}}</td>
                                        <td class="amount">{{num($outstandingMale+$outstandingFemale,$filRoundUup)}}</td>
                                    </tr>
                                    @php 
                                        $fundStart++; 
                                        $l3Start ++;
                                    @endphp
                                @endforeach
                            @endif
                            
                        @endforeach
                    {{-- @if(count($fundingOrgs) > 1) --}}
                    <tr class="grandTotal"  style="font-weight:bold">
                        <th colspan="4" align="center" valign="middle" nowrap="nowrap" rowspan="3"><strong>Grand Total</strong></th>
                        <td class="name">Cumulative Loan Disbursement</td>
                        <td class="amount">{{num($grand_disbursementMale,$filRoundUup)}}</td>
                        <td class="amount">{{num($grand_disbursementFemale,$filRoundUup)}}</td>
                        <td class="amount">{{num($grand_disbursementMale+$grand_disbursementFemale,$filRoundUup)}}</td>
                    </tr>
                    <tr class="subTotalTr"  style="font-weight:bold">
                        <td class="name">Cumulative Loan Collection	</td>
                        <td class="amount">{{num($grand_collectionMale,$filRoundUup)}}</td>
                        <td class="amount">{{num($grand_collectionFemale,$filRoundUup)}}</td>
                        <td class="amount">{{num($grand_collectionMale+$grand_collectionFemale,$filRoundUup)}}</td>
                    </tr>
                    <tr class="subTotalTr"  style="font-weight:bold">
                        <td class="name">Current Outstanding</td>
                        <td class="amount">{{num($grand_outstandingMale,$filRoundUup)}}</td>
                        <td class="amount">{{num($grand_outstandingFemale,$filRoundUup)}}</td>
                        <td class="amount">{{num($grand_outstandingMale+$grand_outstandingFemale,$filRoundUup)}}</td>
                    </tr>
                    {{-- @endif --}}
                </tbody>
            </table>
        </div>
    </div>
</div>
@endif
{{-- layer 3| End --}}