{{-- Second Table --}}
    @if (empty($config) || $config['note2'] == true)
        @if ($filBranch == null || $filBranch == 1)
            <div c1lass="row" class="tableDiv">
                <div class="col-lg-12">
                    <div class="table-responsive">
                        @if ($printLayer == 1) 
                            <table id="tableTwo" class="table table-striped table-bordered pomisOne" border="1pt solid ash"style="color:black; border-collapse: collapse;">
                                <thead>
                                    <tr class="tableHead"><th colspan="13">Note-2 (Layer-1)</th></tr>
                                    <tr>
                                        <th width="4%" rowspan="2" align="left"></th>
                                        <th width="2%" rowspan="2" align="left">Sl</th>
                                        <th width="10%" rowspan="2" align="left">Fund Account </th>
                                        <th width="16%" colspan="3" align="center">Cumulative Receive </th>
                                        <th width="12%" colspan="2" align="center">Cumulative Payment </th>
                                        <th width="12%" rowspan="2" align="center">Current Outstanding</th>
                                        <th width="12%" colspan="2" align="center">End of the Month Due </th>
                                        <th width="10%" align="center" colspan="2">Next 12 month Payable Amount </th>
                                    </tr>
                                    <tr class="tableHead">
                                        <th align="center">Principle</th>
                                        <th align="center">Service Charge </th>
                                        <th align="center">Total </th>
                                        <th align="center">Principle</th>
                                        <th align="center">Service Charge </th>
                                        <th align="center">Principle</th>
                                        <th align="center">Service Charge </th>
                                        <th align="center">Principle</th>
                                        <th align="center">Service Charge </th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $grand_recPrin = 0;
                                        $grand_recSc = 0;
                                        $grand_recTotal = 0;
                                        $grand_paidPrin = 0;
                                        $grand_paidSc = 0;
                                        $grand_outstanding = 0;
                                        $grand_duePrin = 0;
                                        $grand_dueSc = 0;
                                        $grand_prinNextPayable = 0;
                                        $grand_scNextPayable = 0;

                                        $totalColspan = 3;
                                    @endphp
                                    @foreach ($fundLoanOrgs as $fundLoanOrg)
                                        @php
                                            $fundStart = 1;
                                            $fund_recPrin = 0;
                                            $fund_recSc = 0;
                                            $fund_recTotal = 0;
                                            $fund_paidPrin = 0;
                                            $fund_paidSc = 0;
                                            $fund_outstanding = 0;
                                            $fund_duePrin = 0;
                                            $fund_dueSc = 0;
                                            $fund_prinNextPayable = 0;
                                            $fund_scNextPayable = 0;
                                            $fundLoanProducts = $gnrLoanProducts->whereIn(
                                                'id',
                                                $fundAccountsData
                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                    ->unique('loanProductId_fk')
                                                    ->pluck('loanProductId_fk')
                                                    ->merge(
                                                        $fundAccountsOpening
                                                            ->where('fundingOrgId', $fundLoanOrg->id)
                                                            ->unique('loanProductId_fk')
                                                            ->pluck('loanProductId_fk')
                                                    )
                                            );
                                            $fundlayer1 = array_filter($layer1, function($value) use($fundLoanOrg) {
                                                return in_array($fundLoanOrg->id,json_decode($value->fund_ids));
                                            });

                                        @endphp
                                        @foreach ( $fundLoanOrg->id == 1 ? $fundlayer1 : $fundLoanProducts as $key => $fundProducts) 
                                            {{-- changed on 25/2/2024... will follow the "mfn_pksf_loan_product_layers" table. --}}
                                            @php
                                                $fundProductIds = $fundLoanOrg->id == 1 ? explode(',',$fundProducts->fund_product_ids) : [$fundProducts->id] ;
                                                empty($fundProductIds) ?? $fundProductIds = [0];
                                                $recPrin = $fundAccounts
                                                    ->whereIn('loanProductId_fk', $fundProductIds)
                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                    ->sum('loanAmount');
                                                $loanInterestAmt = $loanIntInfo
                                                    ->whereIn('loanProductId_fk', $fundProductIds)
                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                    ->sum('loanInterestAmt');
                                                if ($fundLoanOrg->id == 1) {
                                                    $recSc = $loanInterestAmt;
                                                } else {
                                                    $recSc = $loanInterestAmt +
                                                        $fundAccounts
                                                            ->whereIn('loanProductId_fk', $fundProductIds)
                                                            ->where('fundingOrgId', $fundLoanOrg->id)
                                                            ->sum('payableInterest');
                                                }
                                                $recTotal = $recPrin + $recSc;
                                                
                                                $paidSc =
                                                    $payments
                                                        ->whereIn('loanProductId_fk', $fundProductIds)
                                                        ->where('fundingOrgId', $fundLoanOrg->id)
                                                        ->sum('paidInterestAmount') + $loanInterestAmt;

                                                if ($fundLoanOrg->id == 1) {
                                                    $paidPrin = $payments
                                                        ->whereIn('loanProductId_fk', $fundProductIds)
                                                        ->where('fundingOrgId', $fundLoanOrg->id)
                                                        ->sum('paidPrincipalAmount');
                                                } else {
                                                    $paidPrin =
                                                        $payments
                                                            ->whereIn('loanProductId_fk', $fundProductIds)
                                                            ->where('fundingOrgId', $fundLoanOrg->id)
                                                            ->sum('paidPrincipalAmount') - $paidSc;
                                                }

                                                $outstanding = $recPrin - $paidPrin;
                                                
                                                $duePrin =
                                                    $paymentSchedules
                                                        ->whereIn('loanProductId_fk', $fundProductIds)
                                                        ->where('fundingOrgId', $fundLoanOrg->id)
                                                        ->sum('payablePrincipal') -
                                                    $regularPayments
                                                        ->whereIn('loanProductId_fk', $fundProductIds)
                                                        ->where('fundingOrgId', $fundLoanOrg->id)
                                                        ->sum('paidPrincipalAmount');
                                                $dueSc =
                                                    $paymentSchedules
                                                        ->whereIn('loanProductId_fk', $fundProductIds)
                                                        ->where('fundingOrgId', $fundLoanOrg->id)
                                                        ->sum('payableInterest') -
                                                    $regularPayments
                                                        ->whereIn('loanProductId_fk', $fundProductIds)
                                                        ->where('fundingOrgId', $fundLoanOrg->id)
                                                        ->sum('paidInterestAmount');

                                                if ($duePrin < 0) {
                                                    $duePrin = 0;
                                                }
                                                if ($dueSc < 0) {
                                                    $duePrin = 0;
                                                }

                                                $prinNextPayable = $nextPaymentSchedules
                                                    ->whereIn('loanProductId_fk', $fundProductIds)
                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                    ->sum('principalAmount');

                                                if(date('Y-m-d', strtotime($filDate)) > date('Y-m-d',strtotime("2024-02-01")))    if($prinNextPayable > $outstanding) $prinNextPayable = $outstanding;
                                                
                                                $scNextPayable = $nextPaymentSchedules
                                                    ->whereIn('loanProductId_fk', $fundProductIds)
                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                    ->sum('interestAmount');

                                                // $rowspan =  $fundLoanOrg->id == 1 ? sizeof($fundlayer1) : sizeof($fundLoanProducts);
                                            @endphp
                                            <tr @if ($fundLoanOrg->id != 1 && $printLayer == 1) style = "display:none" @endif>
                                                @if ($fundStart == 1)
                                                    <td width="4%" rowspan="{{ sizeof($fundlayer1) }}" align="center"
                                                        valign="middle" nowrap="nowrap" class="note">
                                                        <div class="rotating">Note-2 ({{ $fundLoanOrg->id == 1 ? $fundLoanOrg->name : "Bank" }})</div>
                                                    </td>
                                                @endif
                                                <td width="2%">{{  $fundLoanOrg->id == 1 ? $fundProducts->sl_code : $loop->iteration }}</td>
                                                <td width="9%" class="name">{{ $fundProducts->name }}</td>
                                                <td class="amount">{{ num($recPrin, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($recSc, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($recTotal, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($paidPrin, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($paidSc, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($outstanding, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($duePrin, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($dueSc, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($prinNextPayable, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($scNextPayable, $filRoundUup) }}</td>
                                            </tr>
                                            @php
                                                // $showTotal ++;
                                                // $l2Start++;
                                                $fundStart++;
                                            @endphp
                                            @php
                                                $fund_recPrin += $recPrin;
                                                $fund_recSc += $recSc;
                                                $fund_recTotal += $recTotal;
                                                $fund_paidPrin += $paidPrin;
                                                $fund_paidSc += $paidSc;
                                                $fund_outstanding += $outstanding;
                                                $fund_duePrin += $duePrin;
                                                $fund_dueSc += $dueSc;
                                                $fund_prinNextPayable += $prinNextPayable;
                                                $fund_scNextPayable += $scNextPayable;
                                            @endphp
                                        @endforeach
                                        @php
                                            $grand_recPrin += $fund_recPrin;
                                            $grand_recSc += $fund_recSc;
                                            $grand_recTotal += $fund_recTotal;
                                            $grand_paidPrin += $fund_paidPrin;
                                            $grand_paidSc += $fund_paidSc;
                                            $grand_outstanding += $fund_outstanding;
                                            $grand_duePrin += $fund_duePrin;
                                            $grand_dueSc += $fund_dueSc;
                                            $grand_prinNextPayable += $fund_prinNextPayable;
                                            $grand_scNextPayable += $fund_scNextPayable;
                                        @endphp
                                        @if ($printLayer == 1 && $fundLoanOrg->id != 1  )
                                            <tr>

                                                <td colspan="2"  align="center" valign="middle"></td>
                                                <td class="name" align="center" valign="middle">Bank Fund</td>
                                                <td class="amount">{{ num($fund_recPrin, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_recSc, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_recTotal, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_paidPrin, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_paidSc, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_outstanding, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_duePrin, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_dueSc, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_prinNextPayable, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_scNextPayable, $filRoundUup) }}</td>
                                            </tr>
                                        @endif
                                        @if (count($fundLoanOrgs) > 1)
                                            <tr class="subTotalTr" style="font-weight:bold">
                                                <td colspan="{{$totalColspan}}" class="name" align="center" valign="middle">Total {{ $fundLoanOrg->id == 1 ? $fundLoanOrg->name : "Bank" }}</td>
                                                <td class="amount">{{ num($fund_recPrin, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_recSc, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_recTotal, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_paidPrin, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_paidSc, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_outstanding, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_duePrin, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_dueSc, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_prinNextPayable, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_scNextPayable, $filRoundUup) }}</td>
                                            </tr>
                                        @endif
                                    @endforeach

                                    <tr class="grandTotal" style="font-weight:bold">
                                        <td colspan="{{$totalColspan}}" class="name" align="center" valign="middle">Grand Total</td>
                                        <td class="amount">{{ num($grand_recPrin, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_recSc, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_recTotal, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_paidPrin, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_paidSc, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_outstanding, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_duePrin, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_dueSc, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_prinNextPayable, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_scNextPayable, $filRoundUup) }}</td>
                                    </tr>
                                </tbody>
                            </table>
                        @endif

                        @if ($printLayer == 2)
                            <table id="tableTwo" class="table table-striped table-bordered pomisOne" border="1pt solid ash"
                                style="color:black; border-collapse: collapse;">
                                <thead>
                                    <tr class="tableHead"><th colspan="15">Note-2 (Layer-2)</th></tr>
                                    <tr>
                                        <th width="4%" rowspan="2" align="left"></th>
                                        <th width="2%" rowspan="2" align="left">Sl</th>
                                        <th width="2%" rowspan="2" align="left">Name Of Main Component</th> 
                                        <th width="2%" rowspan="2" align="left">Sub Sl</th>
                                        <th width="10%" rowspan="2" align="left">Fund Account </th>
                                        <th width="16%" colspan="3" align="center">Cumulative Receive </th>
                                        <th width="12%" colspan="2" align="center">Cumulative Payment </th>
                                        <th width="12%" rowspan="2" align="center">Current Outstanding</th>
                                        <th width="12%" colspan="2" align="center">End of the Month Due </th>
                                        <th width="10%" align="center" colspan="2">Next 12 month Payable Amount </th>
                                    </tr>
                                    <tr class="tableHead">
                                        <th align="center">Principle</th>
                                        <th align="center">Service Charge </th>
                                        <th align="center">Total </th>
                                        <th align="center">Principle</th>
                                        <th align="center">Service Charge </th>
                                        <th align="center">Principle</th>
                                        <th align="center">Service Charge </th>
                                        <th align="center">Principle</th>
                                        <th align="center">Service Charge </th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $grand_recPrin = 0;
                                        $grand_recSc = 0;
                                        $grand_recTotal = 0;
                                        $grand_paidPrin = 0;
                                        $grand_paidSc = 0;
                                        $grand_outstanding = 0;
                                        $grand_duePrin = 0;
                                        $grand_dueSc = 0;
                                        $grand_prinNextPayable = 0;
                                        $grand_scNextPayable = 0;

                                        $totalColspan = 3;
                                        if ($printLayer == 2 || $printLayer == 3) {
                                            $totalColspan= 5 ;
                                        }
                                    @endphp
                                    @foreach ($fundLoanOrgs as $fundLoanOrg)
                                        @php
                                            $fundStart = 1;
                                            $fund_recPrin = 0;
                                            $fund_recSc = 0;
                                            $fund_recTotal = 0;
                                            $fund_paidPrin = 0;
                                            $fund_paidSc = 0;
                                            $fund_outstanding = 0;
                                            $fund_duePrin = 0;
                                            $fund_dueSc = 0;
                                            $fund_prinNextPayable = 0;
                                            $fund_scNextPayable = 0;
                                            $fundLoanProducts = $gnrLoanProducts->whereIn(
                                                'id',
                                                $fundAccountsData
                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                    ->unique('loanProductId_fk')
                                                    ->pluck('loanProductId_fk')
                                                    ->merge(
                                                        $fundAccountsOpening
                                                            ->where('fundingOrgId', $fundLoanOrg->id)
                                                            ->unique('loanProductId_fk')
                                                            ->pluck('loanProductId_fk')
                                                    )
                                            );
                                            $fundlayer1 = array_filter($layer1, function($value) use($fundLoanOrg) {
                                                return in_array($fundLoanOrg->id,json_decode($value->fund_ids));
                                            });

                                        @endphp
                                        @foreach ( $fundLoanOrg->id == 1 ? $fundlayer1 : $fundLoanProducts as $key => $fundProducts) 
                                            @if (isset($layer2[$fundProducts->id]) && $fundLoanOrg->id == 1)
                                                @php
                                                    $showTotal = 1;
                                                    $l2Start = 1;
                                                    $fundlayers2 = array_filter($layer2[$fundProducts->id], function($value) use($fundLoanOrg) {
                                                        return in_array($fundLoanOrg->id,json_decode($value->fund_ids));
                                                    });
                                                    $rowspan = count($fundlayers2);
                                                @endphp
                                                @foreach ($fundlayers2 as $item2)
                                                    @php
                                                        $fundProductIds = $fundLoanOrg->id == 1 ? explode(',',$item2->fund_product_ids) : [$item2->id] ;
                                                        empty($fundProductIds) ?? $fundProductIds = [0];
                                                        $recPrin = $fundAccounts
                                                            ->whereIn('loanProductId_fk', $fundProductIds)
                                                            ->where('fundingOrgId', $fundLoanOrg->id)
                                                            ->sum('loanAmount');
                                                        $loanInterestAmt = $loanIntInfo
                                                            ->whereIn('loanProductId_fk', $fundProductIds)
                                                            ->where('fundingOrgId', $fundLoanOrg->id)
                                                            ->sum('loanInterestAmt');
                                                        if ($fundLoanOrg->id == 1) {
                                                            $recSc = $loanInterestAmt;
                                                        } else {
                                                            $recSc = $loanInterestAmt +
                                                                $fundAccounts
                                                                    ->whereIn('loanProductId_fk', $fundProductIds)
                                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                                    ->sum('payableInterest');
                                                        }
                                                        $recTotal = $recPrin + $recSc;
                                                        
                                                        $paidSc =
                                                            $payments
                                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                                ->sum('paidInterestAmount') + $loanInterestAmt;

                                                        if ($fundLoanOrg->id == 1) {
                                                            $paidPrin = $payments
                                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                                ->sum('paidPrincipalAmount');
                                                        } else {
                                                            $paidPrin =
                                                                $payments
                                                                    ->whereIn('loanProductId_fk', $fundProductIds)
                                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                                    ->sum('paidPrincipalAmount') - $paidSc;
                                                        }

                                                        $outstanding = $recPrin - $paidPrin;
                                                        
                                                        $duePrin =
                                                            $paymentSchedules
                                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                                ->sum('payablePrincipal') -
                                                            $regularPayments
                                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                                ->sum('paidPrincipalAmount');
                                                        $dueSc =
                                                            $paymentSchedules
                                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                                ->sum('payableInterest') -
                                                            $regularPayments
                                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                                ->sum('paidInterestAmount');

                                                        if ($duePrin < 0) {
                                                            $duePrin = 0;
                                                        }
                                                        if ($dueSc < 0) {
                                                            $duePrin = 0;
                                                        }

                                                        $prinNextPayable = $nextPaymentSchedules
                                                            ->whereIn('loanProductId_fk', $fundProductIds)
                                                            ->where('fundingOrgId', $fundLoanOrg->id)
                                                            ->sum('principalAmount');
                                                        $scNextPayable = $nextPaymentSchedules
                                                            ->whereIn('loanProductId_fk', $fundProductIds)
                                                            ->where('fundingOrgId', $fundLoanOrg->id)
                                                            ->sum('interestAmount');

                                                        // $rowspan =  $fundLoanOrg->id == 1 ? sizeof($fundlayer1) : sizeof($fundLoanProducts);
                                                    @endphp
                                                    <tr @if ($fundLoanOrg->id != 1 && $printLayer == 1) style = "display:none" @endif>
                                                        @if ($fundStart == 1)
                                                            <td width="4%" rowspan="{{ $note2layer2Rowspan }}" align="center"
                                                                valign="middle" nowrap="nowrap" class="note">
                                                                <div class="rotating">Note-2 ({{ $fundLoanOrg->id == 1 ? $fundLoanOrg->name : "Bank" }})</div>
                                                            </td>
                                                        @endif
                                                        @if ($l2Start == 1 && $fundLoanOrg->id == 1)
                                                            <td width="2%" rowspan="{{$rowspan}}">{{ $fundProducts->sl_code }}</td>
                                                            <td width="2%" rowspan="{{$rowspan}}">{{ $fundProducts->name }}</td>
                                                        @endif
                                                        <td width="2%">{{  $fundLoanOrg->id == 1 ? $item2->sl_code : $loop->iteration }}</td>
                                                        <td width="9%" class="name">{{ $item2->name }}</td>
                                                        <td class="amount">{{ num($recPrin, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($recSc, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($recTotal, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($paidPrin, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($paidSc, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($outstanding, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($duePrin, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($dueSc, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($prinNextPayable, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($scNextPayable, $filRoundUup) }}</td>
                                                    </tr>
                                                    @php
                                                        $showTotal ++;
                                                        $l2Start++;
                                                        $fundStart++;
                                                    @endphp
                                                    @php
                                                        $fund_recPrin += $recPrin;
                                                        $fund_recSc += $recSc;
                                                        $fund_recTotal += $recTotal;
                                                        $fund_paidPrin += $paidPrin;
                                                        $fund_paidSc += $paidSc;
                                                        $fund_outstanding += $outstanding;
                                                        $fund_duePrin += $duePrin;
                                                        $fund_dueSc += $dueSc;
                                                        $fund_prinNextPayable += $prinNextPayable;
                                                        $fund_scNextPayable += $scNextPayable;
                                                    @endphp
                                                @endforeach
                                            @else
                                                @if ($fundLoanOrg->id != 1)
                                                    @php
                                                        $fundProductIds = $fundLoanOrg->id == 1 ? explode(',',$fundProducts->fund_product_ids) : [$fundProducts->id] ;
                                                        empty($fundProductIds) ?? $fundProductIds = [0];
                                                        $recPrin = $fundAccounts
                                                            ->whereIn('loanProductId_fk', $fundProductIds)
                                                            ->where('fundingOrgId', $fundLoanOrg->id)
                                                            ->sum('loanAmount');
                                                        $loanInterestAmt = $loanIntInfo
                                                            ->whereIn('loanProductId_fk', $fundProductIds)
                                                            ->where('fundingOrgId', $fundLoanOrg->id)
                                                            ->sum('loanInterestAmt');
                                                        if ($fundLoanOrg->id == 1) {
                                                            $recSc = $loanInterestAmt;
                                                        } else {
                                                            $recSc = $loanInterestAmt +
                                                                $fundAccounts
                                                                    ->whereIn('loanProductId_fk', $fundProductIds)
                                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                                    ->sum('payableInterest');
                                                        }
                                                        $recTotal = $recPrin + $recSc;
                                                        
                                                        $paidSc =
                                                            $payments
                                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                                ->sum('paidInterestAmount') + $loanInterestAmt;

                                                        if ($fundLoanOrg->id == 1) {
                                                            $paidPrin = $payments
                                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                                ->sum('paidPrincipalAmount');
                                                        } else {
                                                            $paidPrin =
                                                                $payments
                                                                    ->whereIn('loanProductId_fk', $fundProductIds)
                                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                                    ->sum('paidPrincipalAmount') - $paidSc;
                                                        }

                                                        $outstanding = $recPrin - $paidPrin;
                                                        
                                                        $duePrin =
                                                            $paymentSchedules
                                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                                ->sum('payablePrincipal') -
                                                            $regularPayments
                                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                                ->sum('paidPrincipalAmount');
                                                        $dueSc =
                                                            $paymentSchedules
                                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                                ->sum('payableInterest') -
                                                            $regularPayments
                                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                                ->sum('paidInterestAmount');

                                                        if ($duePrin < 0) {
                                                            $duePrin = 0;
                                                        }
                                                        if ($dueSc < 0) {
                                                            $duePrin = 0;
                                                        }

                                                        $prinNextPayable = $nextPaymentSchedules
                                                            ->whereIn('loanProductId_fk', $fundProductIds)
                                                            ->where('fundingOrgId', $fundLoanOrg->id)
                                                            ->sum('principalAmount');
                                                        $scNextPayable = $nextPaymentSchedules
                                                            ->whereIn('loanProductId_fk', $fundProductIds)
                                                            ->where('fundingOrgId', $fundLoanOrg->id)
                                                            ->sum('interestAmount');

                                                        $rowspan =  $fundLoanOrg->id == 1 ? sizeof($fundlayer1) : sizeof($fundLoanProducts);
                                                    @endphp

                                                    <tr @if ($fundLoanOrg->id != 1 && $printLayer == 1) style = "display:none" @endif>
                                                        @if ($fundStart == 1)
                                                            <td width="4%" rowspan="{{ $rowspan }}" align="center"
                                                                valign="middle" nowrap="nowrap" class="note">
                                                                <div class="rotating">Note-2 ({{ $fundLoanOrg->id == 1 ? $fundLoanOrg->name : "Bank" }})</div>
                                                            </td>
                                                        @endif
                                                        <td width="2%">{{  $fundLoanOrg->id == 1 ? $fundProducts->sl_code : $loop->iteration }}</td>
                                                        <td width="9%" class="name" colspan="3" >{{ $fundProducts->name }}</td>
                                                        <td class="amount">{{ num($recPrin, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($recSc, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($recTotal, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($paidPrin, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($paidSc, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($outstanding, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($duePrin, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($dueSc, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($prinNextPayable, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($scNextPayable, $filRoundUup) }}</td>
                                                    </tr>
                                                    @php $fundStart++; @endphp
                                                    @php
                                                        $fund_recPrin += $recPrin;
                                                        $fund_recSc += $recSc;
                                                        $fund_recTotal += $recTotal;
                                                        $fund_paidPrin += $paidPrin;
                                                        $fund_paidSc += $paidSc;
                                                        $fund_outstanding += $outstanding;
                                                        $fund_duePrin += $duePrin;
                                                        $fund_dueSc += $dueSc;
                                                        $fund_prinNextPayable += $prinNextPayable;
                                                        $fund_scNextPayable += $scNextPayable;
                                                    @endphp
                                                @endif
                                            @endif
                                        @endforeach
                                        @php
                                            $grand_recPrin += $fund_recPrin;
                                            $grand_recSc += $fund_recSc;
                                            $grand_recTotal += $fund_recTotal;
                                            $grand_paidPrin += $fund_paidPrin;
                                            $grand_paidSc += $fund_paidSc;
                                            $grand_outstanding += $fund_outstanding;
                                            $grand_duePrin += $fund_duePrin;
                                            $grand_dueSc += $fund_dueSc;
                                            $grand_prinNextPayable += $fund_prinNextPayable;
                                            $grand_scNextPayable += $fund_scNextPayable;
                                        @endphp
                                        @if ($printLayer == 1 && $fundLoanOrg->id != 1  )
                                            <tr>

                                                <td colspan="2"  align="center" valign="middle"></td>
                                                <td class="name" align="center" valign="middle">Bank Fund</td>
                                                <td class="amount">{{ num($fund_recPrin, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_recSc, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_recTotal, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_paidPrin, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_paidSc, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_outstanding, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_duePrin, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_dueSc, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_prinNextPayable, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_scNextPayable, $filRoundUup) }}</td>
                                            </tr>
                                        @endif
                                        @if (count($fundLoanOrgs) > 1)
                                            <tr class="subTotalTr" style="font-weight:bold">
                                                <td colspan="{{$totalColspan}}" class="name" align="center" valign="middle">Total {{ $fundLoanOrg->id == 1 ? $fundLoanOrg->name : "Bank" }}</td>
                                                <td class="amount">{{ num($fund_recPrin, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_recSc, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_recTotal, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_paidPrin, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_paidSc, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_outstanding, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_duePrin, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_dueSc, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_prinNextPayable, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_scNextPayable, $filRoundUup) }}</td>
                                            </tr>
                                        @endif
                                    @endforeach

                                    <tr class="grandTotal" style="font-weight:bold">
                                        <td colspan="{{$totalColspan}}" class="name" align="center" valign="middle">Grand Total</td>
                                        <td class="amount">{{ num($grand_recPrin, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_recSc, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_recTotal, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_paidPrin, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_paidSc, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_outstanding, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_duePrin, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_dueSc, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_prinNextPayable, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_scNextPayable, $filRoundUup) }}</td>
                                    </tr>
                                </tbody>
                            </table>
                        @endif

                        {{-- for layer 3 --}}
                        @if ($printLayer == 3)
                        <table id="tableTwo" class="table table-striped table-bordered pomisOne" border="1pt solid ash" style="color:black; border-collapse: collapse;">
                                <thead>
                                    <tr class="tableHead"><th colspan="15">Note-2 (Layer-3)</th></tr></tr>
                                    <tr>
                                        <th width="4%" rowspan="2" align="left"></th>
                                        <th width="2%" rowspan="2" align="left">Sl</th>
                                        <th width="2%" rowspan="2" align="left">Name Of Main Component</th> 
                                        <th width="2%" rowspan="2" align="left">Sub Sl</th>
                                        <th width="10%" rowspan="2" align="left">Fund Account </th>
                                        <th width="16%" colspan="3" align="center">Cumulative Receive </th>
                                        <th width="12%" colspan="2" align="center">Cumulative Payment </th>
                                        <th width="12%" rowspan="2" align="center">Current Outstanding</th>
                                        <th width="12%" colspan="2" align="center">End of the Month Due </th>
                                        <th width="10%" align="center" colspan="2">Next 12 month Payable Amount </th>
                                    </tr>
                                    <tr class="tableHead">
                                        <th align="center">Principle</th>
                                        <th align="center">Service Charge </th>
                                        <th align="center">Total </th>
                                        <th align="center">Principle</th>
                                        <th align="center">Service Charge </th>
                                        <th align="center">Principle</th>
                                        <th align="center">Service Charge </th>
                                        <th align="center">Principle</th>
                                        <th align="center">Service Charge </th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $grand_recPrin = 0;
                                        $grand_recSc = 0;
                                        $grand_recTotal = 0;
                                        $grand_paidPrin = 0;
                                        $grand_paidSc = 0;
                                        $grand_outstanding = 0;
                                        $grand_duePrin = 0;
                                        $grand_dueSc = 0;
                                        $grand_prinNextPayable = 0;
                                        $grand_scNextPayable = 0;
                                        
                                        $totalColspan = 5;
                                    @endphp
                                    @foreach ($fundLoanOrgs as $fundLoanOrg)
                                        @php
                                            $fundStart = 1;
                                            $fund_recPrin = 0;
                                            $fund_recSc = 0;
                                            $fund_recTotal = 0;
                                            $fund_paidPrin = 0;
                                            $fund_paidSc = 0;
                                            $fund_outstanding = 0;
                                            $fund_duePrin = 0;
                                            $fund_dueSc = 0;
                                            $fund_prinNextPayable = 0;
                                            $fund_scNextPayable = 0;
                                            $fundLoanProducts = $gnrLoanProducts->whereIn(
                                                'id',
                                                $fundAccountsData
                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                    ->unique('loanProductId_fk')
                                                    ->pluck('loanProductId_fk')
                                                    ->merge(
                                                        $fundAccountsOpening
                                                            ->where('fundingOrgId', $fundLoanOrg->id)
                                                            ->unique('loanProductId_fk')
                                                            ->pluck('loanProductId_fk')
                                                    )
                                            );
                                            $fundlayers3 = array_filter($l3SubComponents, function($value) use($fundLoanOrg) {
                                                return in_array($fundLoanOrg->id,json_decode($value->fund_ids));
                                            });
                                        @endphp
                                        @foreach ($fundlayers3  as $component)
                                            {{-- changed on 25/2/2024... will follow the "mfn_pksf_loan_product_layers" table. --}}
                                            @if (isset($layer3[$component->id]))
                                                @php
                                                    $showTotal = 1;
                                                    $l3Start = 1;
                                                    $rowspan = count($layer3[$component->id]);
                                                @endphp
                                                @foreach ($layer3[$component->id] as $item3)
                                                    @php
                                                        $fundProductIds = $fundLoanOrg->id == 1 ? explode(',',$item3->fund_product_ids) : [$item3->id] ;
                                                        empty($fundProductIds) ?? $fundProductIds = [0];
                                                        $recPrin = $fundAccounts
                                                            ->whereIn('loanProductId_fk', $fundProductIds)
                                                            ->where('fundingOrgId', $fundLoanOrg->id)
                                                            ->sum('loanAmount');
                                                        $loanInterestAmt = $loanIntInfo
                                                            ->whereIn('loanProductId_fk', $fundProductIds)
                                                            ->where('fundingOrgId', $fundLoanOrg->id)
                                                            ->sum('loanInterestAmt');
                                                        if ($fundLoanOrg->id == 1) {
                                                            $recSc = $loanInterestAmt;
                                                        } else {
                                                            $recSc = $loanInterestAmt +
                                                                $fundAccounts
                                                                    ->whereIn('loanProductId_fk', $fundProductIds)
                                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                                    ->sum('payableInterest');
                                                        }
                                                        $recTotal = $recPrin + $recSc;
                                                        
                                                        $paidSc =
                                                            $payments
                                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                                ->sum('paidInterestAmount') + $loanInterestAmt;

                                                        if ($fundLoanOrg->id == 1) {
                                                            $paidPrin = $payments
                                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                                ->sum('paidPrincipalAmount');
                                                        } else {
                                                            $paidPrin =
                                                                $payments
                                                                    ->whereIn('loanProductId_fk', $fundProductIds)
                                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                                    ->sum('paidPrincipalAmount') - $paidSc;
                                                        }

                                                        $outstanding = $recPrin - $paidPrin;
                                                        
                                                        $duePrin =
                                                            $paymentSchedules
                                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                                ->sum('payablePrincipal') -
                                                            $regularPayments
                                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                                ->sum('paidPrincipalAmount');
                                                        $dueSc =
                                                            $paymentSchedules
                                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                                ->sum('payableInterest') -
                                                            $regularPayments
                                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                                ->sum('paidInterestAmount');

                                                        if ($duePrin < 0) {
                                                            $duePrin = 0;
                                                        }
                                                        if ($dueSc < 0) {
                                                            $duePrin = 0;
                                                        }

                                                        $prinNextPayable = $nextPaymentSchedules
                                                            ->whereIn('loanProductId_fk', $fundProductIds)
                                                            ->where('fundingOrgId', $fundLoanOrg->id)
                                                            ->sum('principalAmount');
                                                        $scNextPayable = $nextPaymentSchedules
                                                            ->whereIn('loanProductId_fk', $fundProductIds)
                                                            ->where('fundingOrgId', $fundLoanOrg->id)
                                                            ->sum('interestAmount');

                                                        // $rowspan =  $fundLoanOrg->id == 1 ? sizeof($fundlayer1) : sizeof($fundLoanProducts);
                                                    @endphp
                                                    <tr @if ($fundLoanOrg->id != 1 && $printLayer == 1) style = "display:none" @endif>
                                                        @if ($fundStart == 1)
                                                            <td width="4%" rowspan="{{ $note2layer3Rowspan }}" align="center" valign="middle" nowrap="nowrap" class="note">
                                                                <div class="rotating">Note-2 ({{ $fundLoanOrg->id == 1 ? $fundLoanOrg->name : "Bank" }})</div>
                                                            </td>
                                                        @endif
                                                        @if ($l3Start == 1)
                                                            <td width="2%" rowspan="{{$rowspan}}">{{ $component->sl_code }}</td>
                                                            <td width="2%" rowspan="{{$rowspan}}">{{ $component->name }}</td>
                                                        @endif
                                                        <td width="2%">{{  $fundLoanOrg->id == 1 ? $item3->sl_code : $loop->iteration }}</td>
                                                        <td width="9%" class="name">{{ $item3->name }}</td>
                                                        <td class="amount">{{ num($recPrin, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($recSc, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($recTotal, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($paidPrin, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($paidSc, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($outstanding, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($duePrin, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($dueSc, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($prinNextPayable, $filRoundUup) }}</td>
                                                        <td class="amount">{{ num($scNextPayable, $filRoundUup) }}</td>
                                                    </tr>
                                                    @php
                                                        $showTotal ++;
                                                        $l3Start++;
                                                        $fundStart++;
                                                    @endphp
                                                    @php
                                                    $fund_recPrin += $recPrin;
                                                    $fund_recSc += $recSc;
                                                    $fund_recTotal += $recTotal;
                                                    $fund_paidPrin += $paidPrin;
                                                    $fund_paidSc += $paidSc;
                                                    $fund_outstanding += $outstanding;
                                                    $fund_duePrin += $duePrin;
                                                    $fund_dueSc += $dueSc;
                                                    $fund_prinNextPayable += $prinNextPayable;
                                                    $fund_scNextPayable += $scNextPayable;
                                                @endphp
                                                @endforeach
                                            @endif
                                        @endforeach
                                        @php
                                            $grand_recPrin += $fund_recPrin;
                                            $grand_recSc += $fund_recSc;
                                            $grand_recTotal += $fund_recTotal;
                                            $grand_paidPrin += $fund_paidPrin;
                                            $grand_paidSc += $fund_paidSc;
                                            $grand_outstanding += $fund_outstanding;
                                            $grand_duePrin += $fund_duePrin;
                                            $grand_dueSc += $fund_dueSc;
                                            $grand_prinNextPayable += $fund_prinNextPayable;
                                            $grand_scNextPayable += $fund_scNextPayable;
                                        @endphp
                                        @if (count($fundLoanOrgs) > 1)
                                            <tr class="subTotalTr" style="font-weight:bold">
                                                <td colspan="{{$totalColspan}}" class="name" align="center" valign="middle">Total {{ $fundLoanOrg->id == 1 ? $fundLoanOrg->name : "Bank" }}</td>
                                                <td class="amount">{{ num($fund_recPrin, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_recSc, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_recTotal, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_paidPrin, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_paidSc, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_outstanding, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_duePrin, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_dueSc, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_prinNextPayable, $filRoundUup) }}</td>
                                                <td class="amount">{{ num($fund_scNextPayable, $filRoundUup) }}</td>
                                            </tr>
                                        @endif
                                    @endforeach

                                    <tr class="grandTotal" style="font-weight:bold">
                                        <td colspan="{{$totalColspan}}" class="name" align="center" valign="middle">Grand Total</td>
                                        <td class="amount">{{ num($grand_recPrin, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_recSc, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_recTotal, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_paidPrin, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_paidSc, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_outstanding, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_duePrin, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_dueSc, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_prinNextPayable, $filRoundUup) }}</td>
                                        <td class="amount">{{ num($grand_scNextPayable, $filRoundUup) }}</td>
                                    </tr>
                                </tbody>
                            </table> 
                        @endif
                        
                    </div>
                </div>
            </div>
        @endif
    @else
        {{-- Second Table --}}
        @if ($filBranch == null || $filBranch == 1 && $printLayer != 3)
            <div class="row" class="tableDiv">
                <div class="col-lg-12">
                    <div class="table-responsive">
                        <table id="tableTwo" class="table table-striped table-bordered pomisOne" border="1pt solid ash"
                            style="color:black; border-collapse: collapse;">
                            <thead>
                                <tr>
                                    <th width="4%" rowspan="2" align="left"></th>
                                    <th width="2%" rowspan="2" align="left">Sl</th>
                                    <th width="10%" rowspan="2" align="left">Fund Account </th>
                                    <th width="16%" colspan="3" align="center">Cumulative Receive </th>
                                    <th width="12%" colspan="2" align="center">Cumulative Payment </th>
                                    <th width="12%" rowspan="2" align="center">Current Outstanding</th>
                                    <th width="12%" colspan="2" align="center">End of the Month Due </th>
                                    <th width="10%" align="center" colspan="2">Next 12 month Payable Amount </th>
                                </tr>
                                <tr class="tableHead">
                                    <th align="center">Principle</th>
                                    <th align="center">Service Charge </th>
                                    <th align="center">Total </th>
                                    <th align="center">Principle</th>
                                    <th align="center">Service Charge </th>
                                    <th align="center">Principle</th>
                                    <th align="center">Service Charge </th>
                                    <th align="center">Principle</th>
                                    <th align="center">Service Charge </th>
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                    $grand_recPrin = 0;
                                    $grand_recSc = 0;
                                    $grand_recTotal = 0;
                                    $grand_paidPrin = 0;
                                    $grand_paidSc = 0;
                                    $grand_outstanding = 0;
                                    $grand_duePrin = 0;
                                    $grand_dueSc = 0;
                                    $grand_prinNextPayable = 0;
                                    $grand_scNextPayable = 0;
                                @endphp
                                @foreach ($fundLoanOrgs as $fundLoanOrg)
                                    @php
                                        $fundStart = 1;
                                        $fund_recPrin = 0;
                                        $fund_recSc = 0;
                                        $fund_recTotal = 0;
                                        $fund_paidPrin = 0;
                                        $fund_paidSc = 0;
                                        $fund_outstanding = 0;
                                        $fund_duePrin = 0;
                                        $fund_dueSc = 0;
                                        $fund_prinNextPayable = 0;
                                        $fund_scNextPayable = 0;
                                        $fundLoanProducts = $gnrLoanProducts->whereIn(
                                            'id',
                                            $fundAccountsData
                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                ->unique('loanProductId_fk')
                                                ->pluck('loanProductId_fk')
                                                ->merge(
                                                    $fundAccountsOpening
                                                        ->where('fundingOrgId', $fundLoanOrg->id)
                                                        ->unique('loanProductId_fk')
                                                        ->pluck('loanProductId_fk')
                                                )
                                        );
                                        $fundlayer1 = array_filter($layer1, function($value) use($fundLoanOrg) {
                                            return in_array($fundLoanOrg->id,json_decode($value->fund_ids));
                                        });

                                    @endphp
                                    @foreach ( $fundLoanOrg->id == 1 ? $fundlayer1 : $fundLoanProducts as $key => $fundProducts) 
                                        @php
                                            $fundProductIds = $fundLoanOrg->id == 1 ? explode(',',$fundProducts->fund_product_ids) : [$fundProducts->id] ;
                                            empty($fundProductIds) ?? $fundProductIds = [0];
                                            $recPrin = $fundAccounts
                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                ->sum('loanAmount');
                                            $loanInterestAmt = $loanIntInfo
                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                ->sum('loanInterestAmt');
                                            if ($fundLoanOrg->id == 1) {
                                                $recSc = $loanInterestAmt;
                                            } else {
                                                $recSc = $loanInterestAmt +
                                                    $fundAccounts
                                                        ->whereIn('loanProductId_fk', $fundProductIds)
                                                        ->where('fundingOrgId', $fundLoanOrg->id)
                                                        ->sum('payableInterest');
                                            }
                                            $recTotal = $recPrin + $recSc;
                                            
                                            $paidSc =
                                                $payments
                                                    ->whereIn('loanProductId_fk', $fundProductIds)
                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                    ->sum('paidInterestAmount') + $loanInterestAmt;

                                            if ($fundLoanOrg->id == 1) {
                                                $paidPrin = $payments
                                                    ->whereIn('loanProductId_fk', $fundProductIds)
                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                    ->sum('paidPrincipalAmount');
                                            } else {
                                                $paidPrin =
                                                    $payments
                                                        ->whereIn('loanProductId_fk', $fundProductIds)
                                                        ->where('fundingOrgId', $fundLoanOrg->id)
                                                        ->sum('paidPrincipalAmount') - $paidSc;
                                            }

                                            $outstanding = $recPrin - $paidPrin;
                                            
                                            $duePrin =
                                                $paymentSchedules
                                                    ->whereIn('loanProductId_fk', $fundProductIds)
                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                    ->sum('payablePrincipal') -
                                                $regularPayments
                                                    ->whereIn('loanProductId_fk', $fundProductIds)
                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                    ->sum('paidPrincipalAmount');
                                            $dueSc =
                                                $paymentSchedules
                                                    ->whereIn('loanProductId_fk', $fundProductIds)
                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                    ->sum('payableInterest') -
                                                $regularPayments
                                                    ->whereIn('loanProductId_fk', $fundProductIds)
                                                    ->where('fundingOrgId', $fundLoanOrg->id)
                                                    ->sum('paidInterestAmount');

                                            if ($duePrin < 0) {
                                                $duePrin = 0;
                                            }
                                            if ($dueSc < 0) {
                                                $duePrin = 0;
                                            }

                                            $prinNextPayable = $nextPaymentSchedules
                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                ->sum('principalAmount');
                                                
                                            if(date('Y-m-d', strtotime($filDate)) > date('Y-m-d',strtotime("2024-02-01")))    if($prinNextPayable > $outstanding) $prinNextPayable = $outstanding; 
                                            $scNextPayable = $nextPaymentSchedules
                                                ->whereIn('loanProductId_fk', $fundProductIds)
                                                ->where('fundingOrgId', $fundLoanOrg->id)
                                                ->sum('interestAmount');

                                            $rowspan =  $fundLoanOrg->id == 1 ? sizeof($fundlayer1) : sizeof($fundLoanProducts);
                                        @endphp
                                        <tr @if ($fundLoanOrg->id != 1 && $printLayer == 1) style = "display:none" @endif>
                                            @if ($fundStart == 1)
                                                <td width="4%" rowspan="{{ $rowspan }}" align="center"
                                                    valign="middle" nowrap="nowrap" class="note">
                                                    <div class="rotating">Note-2 ({{ $fundLoanOrg->id == 1 ? $fundLoanOrg->name : "Bank" }})</div>
                                                </td>
                                            @endif
                                            <td width="2%">{{  $fundLoanOrg->id == 1 ? $fundProducts->sl_code : $loop->iteration }}</td>
                                            <td width="9%" class="name">{{ $fundProducts->name }}</td>
                                            <td class="amount">{{ num($recPrin, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($recSc, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($recTotal, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($paidPrin, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($paidSc, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($outstanding, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($duePrin, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($dueSc, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($prinNextPayable, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($scNextPayable, $filRoundUup) }}</td>
                                        </tr>
                                        @php $fundStart++; @endphp
                                        @php
                                            $fund_recPrin += $recPrin;
                                            $fund_recSc += $recSc;
                                            $fund_recTotal += $recTotal;
                                            $fund_paidPrin += $paidPrin;
                                            $fund_paidSc += $paidSc;
                                            $fund_outstanding += $outstanding;
                                            $fund_duePrin += $duePrin;
                                            $fund_dueSc += $dueSc;
                                            $fund_prinNextPayable += $prinNextPayable;
                                            $fund_scNextPayable += $scNextPayable;
                                        @endphp
                                    @endforeach
                                    @php
                                        $grand_recPrin += $fund_recPrin;
                                        $grand_recSc += $fund_recSc;
                                        $grand_recTotal += $fund_recTotal;
                                        $grand_paidPrin += $fund_paidPrin;
                                        $grand_paidSc += $fund_paidSc;
                                        $grand_outstanding += $fund_outstanding;
                                        $grand_duePrin += $fund_duePrin;
                                        $grand_dueSc += $fund_dueSc;
                                        $grand_prinNextPayable += $fund_prinNextPayable;
                                        $grand_scNextPayable += $fund_scNextPayable;
                                    @endphp
                                    @if ($printLayer == 1 && $fundLoanOrg->id != 1  )
                                        <tr>

                                            <td colspan="2"  align="center" valign="middle"></td>
                                            <td class="name" align="center" valign="middle">Bank Fund</td>
                                            <td class="amount">{{ num($fund_recPrin, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($fund_recSc, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($fund_recTotal, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($fund_paidPrin, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($fund_paidSc, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($fund_outstanding, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($fund_duePrin, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($fund_dueSc, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($fund_prinNextPayable, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($fund_scNextPayable, $filRoundUup) }}</td>
                                        </tr>
                                    @endif
                                    @if (count($fundLoanOrgs) > 1)
                                        <tr class="subTotalTr" style="font-weight:bold">
                                            <td colspan="3" class="name" align="center" valign="middle">Total {{ $fundLoanOrg->id == 1 ? $fundLoanOrg->name : "Bank" }}</td>
                                            <td class="amount">{{ num($fund_recPrin, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($fund_recSc, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($fund_recTotal, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($fund_paidPrin, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($fund_paidSc, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($fund_outstanding, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($fund_duePrin, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($fund_dueSc, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($fund_prinNextPayable, $filRoundUup) }}</td>
                                            <td class="amount">{{ num($fund_scNextPayable, $filRoundUup) }}</td>
                                        </tr>
                                    @endif
                                @endforeach

                                <tr class="grandTotal" style="font-weight:bold">
                                    <td colspan="3" class="name" align="center" valign="middle">Grand Total</td>
                                    <td class="amount">{{ num($grand_recPrin, $filRoundUup) }}</td>
                                    <td class="amount">{{ num($grand_recSc, $filRoundUup) }}</td>
                                    <td class="amount">{{ num($grand_recTotal, $filRoundUup) }}</td>
                                    <td class="amount">{{ num($grand_paidPrin, $filRoundUup) }}</td>
                                    <td class="amount">{{ num($grand_paidSc, $filRoundUup) }}</td>
                                    <td class="amount">{{ num($grand_outstanding, $filRoundUup) }}</td>
                                    <td class="amount">{{ num($grand_duePrin, $filRoundUup) }}</td>
                                    <td class="amount">{{ num($grand_dueSc, $filRoundUup) }}</td>
                                    <td class="amount">{{ num($grand_prinNextPayable, $filRoundUup) }}</td>
                                    <td class="amount">{{ num($grand_scNextPayable, $filRoundUup) }}</td>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        @endif
        {{-- End Second Table --}}
    @endif
    
    {{-- End Second Table --}}