@include('microfin/miscellaneous/monthEndPendingAlert')

@php
    function num($number,$filRoundUup){
        if ($filRoundUup==1) {
            // return number_format(round($number),2);
            return number_format($number);
        }
        else{
            return number_format($number,2);
        }
    }

    if ($filServiceCharge==1) {
        $serviceChargeText = '(With Service Charge)';
    }
    else{
        $serviceChargeText = '(Without Service Charge)';
    }
@endphp
<div id="printDiv">
    <div class="row" style="padding-bottom: 10px; text-align: center; vertical-align: middle; color: black; font-weight: bold; "> {{-- div for Company --}}
        @php
            $company = DB::table('gnr_company')->where('id', Auth::user()->company_id_fk)->select('name','address')->first();
            if($filBranch==null){
                $branchName = 'All';
            }
            else{
                $branchName = DB::table('gnr_branch')->where('id',$filBranch)->value('name');
            }
        @endphp
        <span style="font-size:14px;">{{$company->name}}</span><br/>
        <span style="font-size:11px;">{{$company->address}}</span><br/>
        <span style="font-size:11px;">{{'Reporting Branch: '.$branchName}}</span><br/>
        <span style="text-decoration: underline;  font-size:14px;">Notes to Balance Sheet - POMIS-5(A) {{$serviceChargeText}}</span>
    </div>

    {{-- report info div --}}
    @php
        use Carbon\Carbon;
        $reportDate = Carbon::parse($filDate)->format('d-m-Y');
        $printDate = Carbon::now()->format('d-m-Y');
    @endphp
    <div class="row">
        <div class="col-lg-12">
            <table style="color:black; font-size: 11px; border-collapse: collapse; width:100%;" >
                <tbody>
                    <tr>
                        <td>Report Date : {{$reportDate}}</td>
                        <td style="text-align: right;">Print Date : {{$printDate}}
                    </tr>
                </tbody>
            </table>
        </div>
    </div>
    {{-- end report info div --}}

    {{-- First Table --}}
    <div class="row" class="tableDiv">
        <div class="col-lg-12">
            <div class="table-responsive">
                <table id="tableOne" 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="20%" rowspan="2" align="left">(A) Dissaster Management Fund(DMF)</th>
                            <th width="20%" align="center">DMF Received from PKSF</th>
                            <th width="20%" colspan="2" align="center">PKSF DMF USED</th>
                            <th width="20%" align="center">NON-PKSF DMF USED</th>
                        </tr>
                    </thead>
                    <tbody>
                        <tr>
                            <td width="3%" rowspan="10" align="center" valign="middle" nowrap="nowrap" class="note"><div class="rotating">Note-1</div></td>
                            <td align="right">-</td>
                            <td width="20%" align="right">-</td>
                            <td width="20%" colspan="2" align="right">-</td>
                            <td width="20%" align="right">-</td>
                        </tr>

                        <tr class="tableHead">
                            <td width="15%" rowspan="9" align="left">(B) Fund Account </td>
                            <td width="15%" bgcolor="#D4D4D4">&nbsp;</td>
                            <td width="15%" align="center">PKSF</td>
                            <td width="15%" align="center">NON-PKSF</td>
                            <td width="15%" align="center">PKSF &amp; NON-PKSF</td>
                        </tr>
                    <tr>
                        <td align="left">Cumulative Service Charge Collection</td>
                        <td class="amount">{{num($cumSerChargeCollectionPKSF,$filRoundUup)}}</td>
                        <td class="amount">{{num($cumSerChargeCollectionNON_PKSF,$filRoundUup)}}</td>
                        <td class="amount">{{num($cumSerChargeCollectionPKSF + $cumSerChargeCollectionNON_PKSF,$filRoundUup)}}</td>
                    <tr>
                        <td align="left">Total Others Income</td>
                        <td class="amount">{{num($totalOthersIncomePKSF,$filRoundUup)}}</td>
                        <td class="amount">{{num($totalOthersIncomeNON_PKSF,$filRoundUup)}}</td>
                        <td class="amount">{{num($totalOthersIncomePKSF + $totalOthersIncomeNON_PKSF,$filRoundUup)}}</td>
                    </tr>
                    <tr>
                        <td align="left">Cumulative Total Income</td>
                        <td class="amount">{{num($cumSerChargeCollectionPKSF + $totalOthersIncomePKSF,$filRoundUup)}}</td>
                        <td class="amount">{{num($cumSerChargeCollectionNON_PKSF + $totalOthersIncomeNON_PKSF,$filRoundUup)}}</td>
                        <td class="amount">{{num($cumSerChargeCollectionPKSF + $cumSerChargeCollectionNON_PKSF + $totalOthersIncomePKSF + $totalOthersIncomeNON_PKSF,$filRoundUup)}}</td>
                    </tr>
                    <tr>
                        <td align="left">Cumulative Total Expenditure</td>
                        <td class="amount">{{num($cumTotalExpenditurePKSF,$filRoundUup)}}</td>
                        <td class="amount">{{num($cumTotalExpenditureNON_PKSF,$filRoundUup)}}</td>
                        <td class="amount">{{num($cumTotalExpenditurePKSF + $cumTotalExpenditureNON_PKSF,$filRoundUup)}}</td>
                    </tr>
                    <tr>
                        <td align="left">Fund Account (Surplus)</td>
                        <td class="amount">{{num($surplusPKSF,$filRoundUup)}}</td>
                        <td class="amount">{{num($surplusNON_PKSF,$filRoundUup)}}</td>
                        <td class="amount">{{num($surplusPKSF + $surplusNON_PKSF,$filRoundUup)}}</td>
                    </tr>
                    <tr>
                        <td align="left">Reserve Fund</td>
                        <td class="amount">{{num($reserveFundPKSF,$filRoundUup)}}</td>
                        <td class="amount">{{num($reserveFundNON_PKSF,$filRoundUup)}}</td>
                        <td class="amount">{{num($reserveFundPKSF + $reserveFundNON_PKSF,$filRoundUup)}}</td>
                    </tr>
                                                <tr>
                        <td align="left">Cumulative Total Salary Paid</td>
                        <td class="amount">{{num($staffSalaryPKSF,$filRoundUup)}}</td>
                        <td class="amount">{{num($staffSalaryNON_PKSF,$filRoundUup)}}</td>
                        <td class="amount">{{num($staffSalaryPKSF + $staffSalaryNON_PKSF,$filRoundUup)}}</td>
                    </tr>
                </tbody>
            </table>

            </div>
        </div>
    </div>
    {{-- End First Table --}}

    {{-- Second Table --}}
    @if(in_array(1,$filBranchIds))
    @if(count($pksfFundLoanProducts)>0)
    <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="16%" rowspan="2" align="left">PKSF Fund Account: </th>
                            <th width="12%" rowspan="2" 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%" rowspan="2" align="center">Next 12 month Payable Amount</th>
                        </tr>
                        <tr class="tableHead">
                            <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>
                        @foreach($pksfFundLoanProducts as $key => $pksfLoanProduct)
                            @php
                                $cumulativeReceive = $pksfFundAccounts->where('loanProductId_fk',$pksfLoanProduct->id)->sum('loanAmount');
                                $accountIds = $pksfFundAccounts->where('loanProductId_fk',$pksfLoanProduct->id)->pluck('id')->toArray();
                                $paymentPrincipal = $payments->whereIn('accId_fk',$accountIds)->sum('principalAmount');
                                $paymentInterest = $payments->whereIn('accId_fk',$accountIds)->sum('interestAmount');
                                $outstanding = $pksfFundAccounts->whereIn('id',$accountIds)->sum('repayAmount') - $payments->whereIn('accId_fk',$accountIds)->sum('totalAmount');

                                $duePrincipal = $paymentSchedules->whereIn('accId_fk',$accountIds)->sum('principalAmount') - $payments->whereIn('accId_fk',$accountIds)->sum('principalAmount');

                                $dueInterest = $paymentSchedules->whereIn('accId_fk',$accountIds)->sum('interestAmount') - $payments->whereIn('accId_fk',$accountIds)->sum('interestAmount');
                                $nextPayable = $nextPaymentSchedules->whereIn('accId_fk',$accountIds)->sum('totalAmount');
                            @endphp
                            <tr>
                                @if ($key==0)
                                    <td width="3%" rowspan="{{count($pksfFundLoanProducts)}}" align="center" valign="middle" nowrap="nowrap" class="note"><div class="rotating">Note-2 (PKSF)</div></td>
                                @endif
                                <td class="name">{{$pksfLoanProduct->name}}</td>
                                <td class="amount">{{num($cumulativeReceive,$filRoundUup)}}</td>
                                <td class="amount">{{num($paymentPrincipal,$filRoundUup)}}</td>
                                <td class="amount">{{num($paymentInterest,$filRoundUup)}}</td>
                                <td class="amount">{{num($outstanding,$filRoundUup)}}</td>
                                <td class="amount">{{num($duePrincipal,$filRoundUup)}}</td>
                                <td class="amount">{{num($dueInterest,$filRoundUup)}}</td>
                                <td class="amount">{{num($nextPayable,$filRoundUup)}}</td>
                            </tr>
                        @endforeach

                        <tr>
                            @php
                                $cumulativeReceive = $pksfFundAccounts->sum('loanAmount');
                                $accountIds = $pksfFundAccounts->pluck('id')->toArray();
                                $paymentPrincipal = $payments->whereIn('accId_fk',$accountIds)->sum('principalAmount');
                                $paymentInterest = $payments->whereIn('accId_fk',$accountIds)->sum('interestAmount');
                                $outstanding = $pksfFundAccounts->whereIn('id',$accountIds)->sum('repayAmount') - $payments->whereIn('accId_fk',$accountIds)->sum('totalAmount');

                                $duePrincipal = $paymentSchedules->whereIn('accId_fk',$accountIds)->sum('principalAmount') - $payments->whereIn('accId_fk',$accountIds)->sum('principalAmount');

                                $dueInterest = $paymentSchedules->whereIn('accId_fk',$accountIds)->sum('interestAmount') - $payments->whereIn('accId_fk',$accountIds)->sum('interestAmount');
                                $nextPayable = $nextPaymentSchedules->whereIn('accId_fk',$accountIds)->sum('totalAmount');
                            @endphp
                            <td colspan="2">Total</td>
                            <td class="amount">{{num($cumulativeReceive,$filRoundUup)}}</td>
                            <td class="amount">{{num($paymentPrincipal,$filRoundUup)}}</td>
                            <td class="amount">{{num($paymentInterest,$filRoundUup)}}</td>
                            <td class="amount">{{num($outstanding,$filRoundUup)}}</td>
                            <td class="amount">{{num($duePrincipal,$filRoundUup)}}</td>
                            <td class="amount">{{num($dueInterest,$filRoundUup)}}</td>
                            <td class="amount">{{num($nextPayable,$filRoundUup)}}</td>
                        </tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    @endif
    {{-- End Second Table --}}

    {{-- Third Table --}}
    @if(count($non_pksfFundLoanProducts)>0)
    <div class="row" class="tableDiv">
        <div class="col-lg-12">
            <div class="table-responsive">
                <table id="tableThree" class="table table-striped table-bordered pomisOne" border="1pt solid ash" style="color:black; border-collapse: collapse;">
                    <thead>
                        <tr>
                            <th width="3%" rowspan="2" align="left"></th>
                            <th width="17%" rowspan="2" align="left">NON-PKSF Fund Account: </th>
                            <th width="12%" rowspan="2" 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%" rowspan="2" align="center">Next 12 month Payable Amount</th>
                        </tr>
                        <tr>
                            <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>
                        @foreach($non_pksfFundLoanProducts as $key => $non_pksfLoanProduct)
                            @php
                                $cumulativeReceive = $non_pksfFundAccounts->where('loanProductId_fk',$non_pksfLoanProduct->id)->sum('loanAmount');
                                $accountIds = $non_pksfFundAccounts->where('loanProductId_fk',$non_pksfLoanProduct->id)->pluck('id')->toArray();
                                $paymentPrincipal = $payments->whereIn('accId_fk',$accountIds)->sum('principalAmount');
                                $paymentInterest = $payments->whereIn('accId_fk',$accountIds)->sum('interestAmount');
                                $outstanding = $non_pksfFundAccounts->whereIn('id',$accountIds)->sum('repayAmount') - $payments->whereIn('accId_fk',$accountIds)->sum('totalAmount');

                                $duePrincipal = $paymentSchedules->whereIn('accId_fk',$accountIds)->sum('principalAmount') - $payments->whereIn('accId_fk',$accountIds)->sum('principalAmount');

                                $dueInterest = $paymentSchedules->whereIn('accId_fk',$accountIds)->sum('interestAmount') - $payments->whereIn('accId_fk',$accountIds)->sum('interestAmount');
                                $nextPayable = $nextPaymentSchedules->whereIn('accId_fk',$accountIds)->sum('totalAmount');
                            @endphp
                            <tr>
                                @if ($key==0)
                                    <td width="3%" rowspan="{{count($non_pksfFundLoanProducts)}}" align="center" valign="middle" nowrap="nowrap" class="note"><div class="rotating">Note-2 (NON-PKSF)</div></td>
                                @endif
                                <td class="name">{{$non_pksfLoanProduct->name}}</td>
                                <td class="amount">{{num($cumulativeReceive,$filRoundUup)}}</td>
                                <td class="amount">{{num($paymentPrincipal,$filRoundUup)}}</td>
                                <td class="amount">{{num($paymentInterest,$filRoundUup)}}</td>
                                <td class="amount">{{num($outstanding,$filRoundUup)}}</td>
                                <td class="amount">{{num($duePrincipal,$filRoundUup)}}</td>
                                <td class="amount">{{num($dueInterest,$filRoundUup)}}</td>
                                <td class="amount">{{num($nextPayable,$filRoundUup)}}</td>
                            </tr>
                        @endforeach

                        <tr>
                            @php
                                $cumulativeReceive = $non_pksfFundAccounts->sum('loanAmount');
                                $accountIds = $non_pksfFundAccounts->pluck('id')->toArray();
                                $paymentPrincipal = $payments->whereIn('accId_fk',$accountIds)->sum('principalAmount');
                                $paymentInterest = $payments->whereIn('accId_fk',$accountIds)->sum('interestAmount');
                                $outstanding = $non_pksfFundAccounts->whereIn('id',$accountIds)->sum('repayAmount') - $payments->whereIn('accId_fk',$accountIds)->sum('totalAmount');

                                $duePrincipal = $paymentSchedules->whereIn('accId_fk',$accountIds)->sum('principalAmount') - $payments->whereIn('accId_fk',$accountIds)->sum('principalAmount');

                                $dueInterest = $paymentSchedules->whereIn('accId_fk',$accountIds)->sum('interestAmount') - $payments->whereIn('accId_fk',$accountIds)->sum('interestAmount');
                                $nextPayable = $nextPaymentSchedules->whereIn('accId_fk',$accountIds)->sum('totalAmount');
                            @endphp
                            <td colspan="2">Total</td>
                            <td class="amount">{{num($cumulativeReceive,$filRoundUup)}}</td>
                            <td class="amount">{{num($paymentPrincipal,$filRoundUup)}}</td>
                            <td class="amount">{{num($paymentInterest,$filRoundUup)}}</td>
                            <td class="amount">{{num($outstanding,$filRoundUup)}}</td>
                            <td class="amount">{{num($duePrincipal,$filRoundUup)}}</td>
                            <td class="amount">{{num($dueInterest,$filRoundUup)}}</td>
                            <td class="amount">{{num($nextPayable,$filRoundUup)}}</td>
                        </tr>
                    </tbody>
                </table>

            </div>
        </div>
    </div>
    @endif
    @endif
    {{-- End Third Table --}}

    {{-- Forth Table Note-3 --}}
    @php
        $totalSavBalMale = 0;
        $totalSavBalFemale = 0;
    @endphp
    @if (count($pksfMaleMemberIds)>0 || count($pksfFemaleMemberIds)>0)
    <div class="row">
        <div class="col-lg-12">
            <div class="table-responsive">
                <table id="tableFour" class="table table-striped table-bordered pomisOne" border="1pt solid ash" style="color:black; border-collapse: collapse;">
                    <thead>
                        <tr>
                            <th rowspan="2"></th>
                            <th rowspan="2" align="center" valign="middle"><strong>Savings Fund</strong></th>
                            <th colspan="3" align="center">General Savings</th>
                            <th colspan="3" align="center">Voluntary Savings</th>
                            <th colspan="3" align="center">Other Savings </th>
                            <th colspan="3" align="center">Total Savings </th>
                        </tr>
                        <tr>
                            <th width="7%" align="center">M</th>
                            <th width="7%" align="center">F</th>
                            <th width="7%" align="center">Total</th>
                            <th width="7%" align="center">M</th>
                            <th width="7%" align="center">F</th>
                            <th width="7%" align="center">Total</th>
                            <th width="7%" align="center">M</th>
                            <th width="7%" align="center">F</th>
                            <th width="7%" align="center">Total</th>
                            <th width="7%" align="center">M</th>
                            <th width="7%" align="center">F</th>
                            <th width="7%" align="center">Total</th>
                        </tr>
                    </thead>
                    <tbody>
                        <tr>
                            @php
                                $totalMaleSavCollection = $cumGenSavCollMale + $cumVOlSavCollMale + $cumOthSavCollMale;
                                $totalFemaleSavCollection = $cumGenSavCollFemale + $cumVOlSavCollFemale + $cumOthSavCollFemale;
                            @endphp
                            <td width="4%" rowspan="5" align="center" valign="middle" nowrap="nowrap"  class="note"><div class="rotating">Note-3 (PKSF)</div></td>
                            <td nowrap="nowrap" class="name">Cumulative Savings Collection (A) </td>
                            <td class="amount">{{num($cumGenSavCollMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavCollFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavCollMale + $cumGenSavCollFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavCollMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavCollFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavCollMale + $cumVOlSavCollFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavCollMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavCollFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavCollMale + $cumOthSavCollFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalMaleSavCollection,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalFemaleSavCollection,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalMaleSavCollection + $totalFemaleSavCollection,$filRoundUup)}}</td>
                        </tr>

                        <tr>
                            <td nowrap="nowrap" class="name">Cumulative Interest Provission (B) </td>
                            <td class="amount">{{num($cumGenSavInterestMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavInterestFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavInterestMale + $cumGenSavInterestFemale,$filRoundUup)}}</td>

                            <td class="amount">{{num($cumVOlSavInterestMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavInterestFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavInterestMale + $cumVOlSavInterestFemale,$filRoundUup)}}</td>

                            <td class="amount">{{num($cumOthSavInterestMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavInterestFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavInterestMale + $cumOthSavInterestFemale,$filRoundUup)}}</td>

                            @php
                                $cumSavInterestMale = $cumGenSavInterestMale + $cumVOlSavInterestMale + $cumOthSavInterestMale;
                                $cumSavInterestFemale = $cumGenSavInterestFemale + $cumVOlSavInterestFemale + $cumOthSavInterestFemale;
                            @endphp

                            <td class="amount">{{num($cumSavInterestMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumSavInterestFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumSavInterestMale + $cumSavInterestFemale,$filRoundUup)}}</td>
                        </tr>

                        {{-- Interest Will be added later --}}
                        <tr>
                            @php

                                $cumGenSavMaleAB = $cumGenSavCollMale + $cumGenSavInterestMale;
                                $cumGenSavFemaleAB = $cumGenSavCollFemale + $cumGenSavInterestFemale;

                                $cumVOlSavMaleAB = $cumVOlSavCollMale + $cumVOlSavInterestMale;
                                $cumVOlSavFemaleAB = $cumVOlSavCollFemale + $cumVOlSavInterestFemale;

                                $cumOthSavMaleAB = $cumOthSavCollMale + $cumOthSavInterestMale;
                                $cumOthSavFemaleAB = $cumOthSavCollFemale + $cumOthSavInterestFemale;

                                $totalMaleSavCollection = $cumGenSavMaleAB + $cumVOlSavMaleAB + $cumOthSavMaleAB;
                                $totalFemaleSavCollection = $cumGenSavFemaleAB + $cumVOlSavFemaleAB + $cumOthSavFemaleAB;
                            @endphp
                            <td nowrap="nowrap" class="name">Total Savings (C) = (A) + (B) </td>
                            <td class="amount">{{num($cumGenSavMaleAB,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavFemaleAB,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavMaleAB + $cumGenSavFemaleAB,$filRoundUup)}}</td>

                            <td class="amount">{{num($cumVOlSavMaleAB,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavFemaleAB,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavMaleAB + $cumVOlSavFemaleAB,$filRoundUup)}}</td>

                            <td class="amount">{{num($cumOthSavMaleAB,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavFemaleAB,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavMaleAB + $cumOthSavFemaleAB,$filRoundUup)}}</td>

                            <td class="amount">{{num($totalMaleSavCollection,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalFemaleSavCollection,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalMaleSavCollection + $totalFemaleSavCollection,$filRoundUup)}}</td>
                        </tr>

                        <tr>
                            @php
                                $totalMaleWithdraw = $cumGenSavWithdrawMale + $cumVOlSavWithdrawMale + $cumOthSavWithdrawMale;
                                $totalFemaleWithdraw = $cumGenSavWithdrawFemale + $cumVOlSavWithdrawFemale + $cumOthSavWithdrawFemale;
                            @endphp
                            <td nowrap="nowrap" class="name">Cumulative Savings Return/withdrwal (D) </td>
                            <td class="amount">{{num($cumGenSavWithdrawMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavWithdrawFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavWithdrawMale + $cumGenSavWithdrawFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavWithdrawMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavWithdrawFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavWithdrawMale + $cumVOlSavWithdrawFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavWithdrawMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavWithdrawFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavWithdrawMale + $cumOthSavWithdrawFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalMaleWithdraw,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalFemaleWithdraw,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalMaleWithdraw + $totalFemaleWithdraw,$filRoundUup)}}</td>
                        </tr>

                        <tr>
                            @php
                                $totalSavBalMale = $cumGenSavBalMale + $cumVOlSavBalMale + $cumOthSavBalMale;
                                $totalSavBalFemale = $cumGenSavBalFemale + $cumVOlSavBalFemale + $cumOthSavBalFemale;
                            @endphp
                            <td nowrap="nowrap" class="name">Current Savings Balance (E) = (C) - (D) </td>
                            <td class="amount">{{num($cumGenSavBalMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavBalFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavBalMale + $cumGenSavBalFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavBalMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavBalFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavBalMale + $cumVOlSavBalFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavBalMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavBalFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavBalMale + $cumOthSavBalFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalSavBalMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalSavBalFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalSavBalMale + $totalSavBalFemale,$filRoundUup)}}</td>
                        </tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    @endif
    {{-- End Forth Table Note-3 --}}

    {{-- Fifth Table Note-3 --}}
    @if (count($nonPksfMaleMemberIds)>0 || count($nonPksfFemaleMemberIds)>0)
    <div class="row">
        <div class="col-lg-12">
            <div class="table-responsive">
                <table id="tableFive" class="table table-striped table-bordered pomisOne" border="1pt solid ash" style="color:black; border-collapse: collapse;">
                    <thead>
                        <tr>
                            <th rowspan="2"></th>
                            <th rowspan="2" align="center" valign="middle"><strong>Savings Fund</strong></th>
                            <th colspan="3" align="center">General Savings</th>
                            <th colspan="3" align="center">Voluntary Savings</th>
                            <th colspan="3" align="center">Other Savings </th>
                            <th colspan="3" align="center">Total Savings </th>
                        </tr>
                        <tr>
                            <th width="7%" align="center">M</th>
                            <th width="7%" align="center">F</th>
                            <th width="7%" align="center">Total</th>
                            <th width="7%" align="center">M</th>
                            <th width="7%" align="center">F</th>
                            <th width="7%" align="center">Total</th>
                            <th width="7%" align="center">M</th>
                            <th width="7%" align="center">F</th>
                            <th width="7%" align="center">Total</th>
                            <th width="7%" align="center">M</th>
                            <th width="7%" align="center">F</th>
                            <th width="7%" align="center">Total</th>
                        </tr>
                    </thead>
                    <tbody>
                        <tr>
                            @php
                                $totalMaleSavCollectionNonPksf = $cumGenSavCollMaleNonPksf + $cumVOlSavCollMaleNonPksf + $cumOthSavCollMaleNonPksf;
                                $totalFemaleSavCollectionNonPksf = $cumGenSavCollFemaleNonPksf + $cumVOlSavCollFemaleNonPksf + $cumOthSavCollFemaleNonPksf;
                            @endphp
                            <td width="4%" rowspan="5" align="center" valign="middle" nowrap="nowrap"  class="note"><div class="rotating">Note-3 (NON-PKSF)</div></td>
                            <td nowrap="nowrap" class="name">Cumulative Savings Collection (A) </td>
                            <td class="amount">{{num($cumGenSavCollMaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavCollFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavCollMaleNonPksf + $cumGenSavCollFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavCollMaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavCollFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavCollMaleNonPksf + $cumVOlSavCollFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavCollMaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavCollFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavCollMaleNonPksf + $cumOthSavCollFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalMaleSavCollectionNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalFemaleSavCollectionNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalMaleSavCollectionNonPksf + $totalFemaleSavCollectionNonPksf,$filRoundUup)}}</td>
                        </tr>

                        <tr>
                            <td nowrap="nowrap" class="name">Cumulative Interest Provission (B) </td>
                            <td class="amount">{{num($cumGenSavInterestMaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavInterestFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavInterestMaleNonPksf + $cumGenSavInterestFemaleNonPksf,$filRoundUup)}}</td>

                            <td class="amount">{{num($cumVOlSavInterestMaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavInterestFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavInterestMaleNonPksf + $cumVOlSavInterestFemaleNonPksf,$filRoundUup)}}</td>

                            <td class="amount">{{num($cumOthSavInterestMaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavInterestFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavInterestMaleNonPksf + $cumOthSavInterestFemaleNonPksf,$filRoundUup)}}</td>

                            @php
                                $cumSavInterestMaleNonPksf = $cumGenSavInterestMaleNonPksf + $cumVOlSavInterestMaleNonPksf + $cumOthSavInterestMaleNonPksf;
                                $cumSavInterestFemaleNonPksf = $cumGenSavInterestFemaleNonPksf + $cumVOlSavInterestFemaleNonPksf + $cumOthSavInterestFemaleNonPksf;
                            @endphp

                            <td class="amount">{{num($cumSavInterestMaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumSavInterestFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumSavInterestMaleNonPksf + $cumSavInterestFemaleNonPksf,$filRoundUup)}}</td>
                        </tr>

                        {{-- Interest Will be added later --}}
                        <tr>
                            @php
                                $cumGenSavMaleNonPksfAB = $cumGenSavCollMaleNonPksf + $cumGenSavInterestMaleNonPksf;
                                $cumGenSavFemaleNonPksfAB = $cumGenSavCollFemaleNonPksf + $cumGenSavInterestFemaleNonPksf;

                                $cumVOlSavMaleNonPksfAB = $cumVOlSavCollMaleNonPksf + $cumVOlSavInterestMaleNonPksf;
                                $cumVOlSavFemaleNonPksfAB = $cumVOlSavCollFemaleNonPksf + $cumVOlSavInterestFemaleNonPksf;

                                $cumOthSavMaleNonPksfAB = $cumOthSavCollMaleNonPksf + $cumOthSavInterestMaleNonPksf;
                                $cumOthSavFemaleNonPksfAB = $cumOthSavCollFemaleNonPksf + $cumOthSavInterestFemaleNonPksf;

                                $cumSavMaleNonPksfAB = $cumGenSavMaleNonPksfAB + $cumVOlSavMaleNonPksfAB + $cumOthSavMaleNonPksfAB;
                                $cumSavFemaleNonPksfAB = $cumGenSavFemaleNonPksfAB + $cumVOlSavFemaleNonPksfAB + $cumOthSavFemaleNonPksfAB;



                               /* $totalMaleSavCollectionNonPksf = $cumGenSavCollMaleNonPksf + $cumVOlSavCollMaleNonPksf + $cumOthSavCollMaleNonPksf;
                                $totalFemaleSavCollectionNonPksf = $cumGenSavCollFemaleNonPksf + $cumVOlSavCollFemaleNonPksf + $cumOthSavCollFemaleNonPksf;*/
                            @endphp
                            <td nowrap="nowrap" class="name">Total Savings (C) = (A) + (B) </td>
                            <td class="amount">{{num($cumGenSavMaleNonPksfAB,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavFemaleNonPksfAB,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavMaleNonPksfAB + $cumGenSavFemaleNonPksfAB,$filRoundUup)}}</td>

                            <td class="amount">{{num($cumVOlSavMaleNonPksfAB,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavFemaleNonPksfAB,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavMaleNonPksfAB + $cumVOlSavFemaleNonPksfAB,$filRoundUup)}}</td>

                            <td class="amount">{{num($cumOthSavMaleNonPksfAB,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavFemaleNonPksfAB,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavMaleNonPksfAB + $cumOthSavFemaleNonPksfAB,$filRoundUup)}}</td>

                            <td class="amount">{{num($cumSavMaleNonPksfAB,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumSavFemaleNonPksfAB,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumSavMaleNonPksfAB + $cumSavFemaleNonPksfAB,$filRoundUup)}}</td>
                        </tr>

                        <tr>
                            @php
                                $totalMaleWithdrawNonPksf = $cumGenSavWithdrawMaleNonPksf + $cumVOlSavWithdrawMaleNonPksf + $cumOthSavWithdrawMaleNonPksf;
                                $totalFemaleWithdrawNonPksf = $cumGenSavWithdrawFemaleNonPksf + $cumVOlSavWithdrawFemaleNonPksf + $cumOthSavWithdrawFemaleNonPksf;
                            @endphp
                            <td nowrap="nowrap" class="name">Cumulative Savings Return/withdrwal (D) </td>
                            <td class="amount">{{num($cumGenSavWithdrawMaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavWithdrawFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavWithdrawMaleNonPksf + $cumGenSavWithdrawFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavWithdrawMaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavWithdrawFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavWithdrawMaleNonPksf + $cumVOlSavWithdrawFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavWithdrawMaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavWithdrawFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavWithdrawMaleNonPksf + $cumOthSavWithdrawFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalMaleWithdrawNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalFemaleWithdrawNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalMaleWithdrawNonPksf + $totalFemaleWithdrawNonPksf,$filRoundUup)}}</td>
                        </tr>

                        <tr>
                            @php
                                $totalSavBalMaleNonPksf = $cumGenSavBalMaleNonPksf + $cumVOlSavBalMaleNonPksf + $cumOthSavBalMaleNonPksf;
                                $totalSavBalFemaleNonPksf = $cumGenSavBalFemaleNonPksf + $cumVOlSavBalFemaleNonPksf + $cumOthSavBalFemaleNonPksf;
                            @endphp
                            <td nowrap="nowrap" class="name">Current Savings Balance (E) = (C) - (D) </td>
                            <td class="amount">{{num($cumGenSavBalMaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavBalFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumGenSavBalMaleNonPksf + $cumGenSavBalFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavBalMaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavBalFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumVOlSavBalMaleNonPksf + $cumVOlSavBalFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavBalMaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavBalFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumOthSavBalMaleNonPksf + $cumOthSavBalFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalSavBalMaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalSavBalFemaleNonPksf,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalSavBalMaleNonPksf + $totalSavBalFemaleNonPksf,$filRoundUup)}}</td>
                        </tr>
                    </tbody>
            </table>

            </div>
        </div>
    </div>
    @endif
    {{-- End Fifth Table Note-3 --}}

    {{-- Note-3 Total Table --}}
    <div class="row">
        <div class="col-lg-12">
            <div class="table-responsive">
                <table id="note3totalTable" class="table table-striped table-bordered pomisOne" border="1pt solid ash" style="color:black; border-collapse: collapse;">
                    <tr>
                        @php
                            $tCumGenSavBalMale = $cumGenSavBalMale +  $cumGenSavBalMaleNonPksf;
                            $tCumGenSavBalFemale = $cumGenSavBalFemale + $cumGenSavBalFemaleNonPksf;
                            $tCumGenSavBal = $tCumGenSavBalMale + $tCumGenSavBalFemale;
                            $tCumVOlSavBalMale = $cumVOlSavBalMale + $cumVOlSavBalMaleNonPksf;
                            $tCumVOlSavBalFemale = $cumVOlSavBalFemale + $cumVOlSavBalFemaleNonPksf;
                            $tCumVOlSavBal = $tCumVOlSavBalMale + $tCumVOlSavBalFemale;
                            $tCumOthSavBalMale = $cumOthSavBalMale + $cumOthSavBalMaleNonPksf;
                            $tCumOthSavBalFemale = $cumOthSavBalFemale + $cumOthSavBalFemaleNonPksf;
                            $tCumOthSavBal = $tCumOthSavBalMale + $tCumOthSavBalFemale;
                            $tTotalSavBalMale = @$totalSavBalMale + @$totalSavBalMaleNonPksf;
                            $tTotalSavBalFemale = @$totalSavBalFemale + @$totalSavBalFemaleNonPksf;
                            $tTotalSavBal = $tTotalSavBalMale + $tTotalSavBalFemale;
                        @endphp
                        <td colspan="2">Total PKSF & NON-PKSF</td>
                        <td class="amount">{{num($tCumGenSavBalMale,$filRoundUup)}}</td>
                        <td class="amount">{{num($tCumGenSavBalFemale,$filRoundUup)}}</td>
                        <td class="amount">{{num($tCumGenSavBal,$filRoundUup)}}</td>
                        <td class="amount">{{num($tCumVOlSavBalMale,$filRoundUup)}}</td>
                        <td class="amount">{{num($tCumVOlSavBalFemale,$filRoundUup)}}</td>
                        <td class="amount">{{num($tCumVOlSavBal,$filRoundUup)}}</td>
                        <td class="amount">{{num($tCumOthSavBalMale,$filRoundUup)}}</td>
                        <td class="amount">{{num($tCumOthSavBalFemale,$filRoundUup)}}</td>
                        <td class="amount">{{num($tCumOthSavBal,$filRoundUup)}}</td>
                        <td class="amount">{{num($tTotalSavBalMale,$filRoundUup)}}</td>
                        <td class="amount">{{num($tTotalSavBalFemale,$filRoundUup)}}</td>
                        <td class="amount">{{num($tTotalSavBal,$filRoundUup)}}</td>
                    </tr>
                </table>
            </div>
        </div>
    </div>
    {{-- End Note-3 Total Table --}}

    {{-- Sixth Table Note-4 --}}
    {{-- initialize some variables for the total calculation --}}
    @php
        $pksfLoanDisbursementMale = 0;
        $nonPksfLoanDisbursementMale = 0;
        $pksfLoanDisbursementFemale = 0;
        $nonPksfLoanDisbursementFemale = 0;
        $pksfLoanCollectionMale = 0;
        $nonPksfLoanCollectionMale = 0;
        $pksfLoanCollectionFemale = 0;
        $nonPksfLoanCollectionFemale = 0;
        $pksfOutstandingMale = 0;
        $nonPksfOutstandingMale = 0;
        $pksfOutstandingFemale = 0;
        $nonPksfOutstandingFemale = 0;
    @endphp

    @if(count($pksfLoanCategories)>0)
    <div class="row">
        <div class="col-lg-12">
            <div class="table-responsive">
                <table id="tableSix" class="table table-striped table-bordered pomisOne" border="1pt solid ash" style="color:black; border-collapse: collapse;">
                    <tbody>
                        <tr class="tableHead">
                            <td width="3%" rowspan="{{count($pksfLoanCategories)*3+1}}" align="center" valign="middle" nowrap="nowrap" class="note"><div class="rotating">Note-4 (PKSF)</div></td>
                            <th colspan="2" align="left"><div align="left">Outstanding Account (Outstanding in the Field) </div></th>
                            <th width="15%" align="center">Male</th>
                            <th width="14%" align="center">Female</th>
                            <th width="15%" align="center">Total</th>
                        </tr>

                        @foreach ($pksfLoanCategories as $key => $loanCategory)
                            @php
                                $loanProductIds = $pksfLoanProducts->where('productCategoryId',$loanCategory->id)->pluck('id')->toArray();

                                $pksfLoanDisbursementMale = $pksfLoanDisbursements->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$pksfMaleMemberIds)->sum('loanAmount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',1)->sum('disbursedAmount');

                                $pksfLoanDisbursementFemale = $pksfLoanDisbursements->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$pksfFemaleMemberIds)->sum('loanAmount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',2)->sum('disbursedAmount');

                                if ($filServiceCharge==1) {
                                    $pksfLoanCollectionMale = $pksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$pksfMaleMemberIds)->sum('amount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',1)->sum('recoveryAmount');
                                    $pksfLoanCollectionFemale = $pksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$pksfFemaleMemberIds)->sum('amount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',2)->sum('recoveryAmount');

                                    $pksfLoanRepayAmountMale = $pksfLoanDisbursements->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$pksfMaleMemberIds)->sum('totalRepayAmount');
                                    $pksfLoanRepayAmountFemale = $pksfLoanDisbursements->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$pksfFemaleMemberIds)->sum('totalRepayAmount');
                                }
                                else{
                                    $pksfLoanCollectionMale = $pksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$pksfMaleMemberIds)->sum('principalAmount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',1)->sum('principalRecoveryAmount');

                                    $pksfLoanCollectionFemale = $pksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$pksfFemaleMemberIds)->sum('principalAmount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',2)->sum('principalRecoveryAmount');

                                    $pksfLoanRepayAmountMale = $pksfLoanDisbursementMale;
                                    $pksfLoanRepayAmountFemale = $pksfLoanDisbursementFemale;
                                }


                                $pksfOutstandingMale = $pksfLoanRepayAmountMale - $pksfLoanCollectionMale;
                                $pksfOutstandingFemale = $pksfLoanRepayAmountFemale - $pksfLoanCollectionFemale;
                            @endphp
                            <tr>
                                <td width="9%" rowspan="3" align="left">{{$loanCategory->name}}</td>
                                <td width="42%" class="name">Cumulative Loan Disbursement </td>
                                <td class="amount">{{num($pksfLoanDisbursementMale,$filRoundUup)}}</td>
                                <td class="amount">{{num($pksfLoanDisbursementFemale,$filRoundUup)}}</td>
                                <td class="amount">{{num($pksfLoanDisbursementMale + $pksfLoanDisbursementFemale,$filRoundUup)}}</td>
                            </tr>
                            <tr>
                                <td class="name">Cumulative Loan Collection </td>
                                <td class="amount">{{num($pksfLoanCollectionMale,$filRoundUup)}}</td>
                                <td class="amount">{{num($pksfLoanCollectionFemale,$filRoundUup)}}</td>
                                <td class="amount">{{num($pksfLoanCollectionMale + $pksfLoanCollectionFemale,$filRoundUup)}}</td>
                            </tr>
                            <tr>
                                <td class="name"><strong>Current Outstanding</strong></td>
                                <td class="amount">{{num($pksfOutstandingMale,$filRoundUup)}}</td>
                                <td class="amount">{{num($pksfOutstandingFemale,$filRoundUup)}}</td>
                                <td class="amount">{{num($pksfOutstandingMale + $pksfOutstandingFemale,$filRoundUup)}}</td>
                            </tr>

                        @endforeach

                        <tr>
                            @php
                                $loanProductIds = $pksfLoanProducts->pluck('id')->toArray();

                                $pksfLoanDisbursementMale = $pksfLoanDisbursements->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$pksfMaleMemberIds)->sum('loanAmount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',1)->sum('disbursedAmount');

                                $pksfLoanDisbursementFemale = $pksfLoanDisbursements->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$pksfFemaleMemberIds)->sum('loanAmount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',2)->sum('disbursedAmount');

                                if ($filServiceCharge==1) {
                                    $pksfLoanCollectionMale = $pksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$pksfMaleMemberIds)->sum('amount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',1)->sum('recoveryAmount');

                                    $pksfLoanCollectionFemale = $pksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$pksfFemaleMemberIds)->sum('amount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',2)->sum('recoveryAmount');

                                    $pksfLoanRepayAmountMale = $pksfLoanDisbursements->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$pksfMaleMemberIds)->sum('totalRepayAmount');
                                    $pksfLoanRepayAmountFemale = $pksfLoanDisbursements->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$pksfFemaleMemberIds)->sum('totalRepayAmount');
                                }
                                else{
                                    $pksfLoanCollectionMale = $pksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$pksfMaleMemberIds)->sum('principalAmount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',1)->sum('principalRecoveryAmount');

                                    $pksfLoanCollectionFemale = $pksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$pksfFemaleMemberIds)->sum('principalAmount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',2)->sum('principalRecoveryAmount');

                                    $pksfLoanRepayAmountMale = $pksfLoanDisbursementMale;
                                    $pksfLoanRepayAmountFemale = $pksfLoanDisbursementFemale;
                                }

                                $pksfOutstandingMale = $pksfLoanRepayAmountMale - $pksfLoanCollectionMale;
                                $pksfOutstandingFemale = $pksfLoanRepayAmountFemale - $pksfLoanCollectionFemale;
                            @endphp
                            <th colspan="2" rowspan="3" align="center" valign="middle" nowrap="nowrap"><strong>Total PKSF</strong></th>
                            <td width="42%" class="name">Cumulative Loan Disbursement </td>
                            <td class="amount">{{num($pksfLoanDisbursementMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($pksfLoanDisbursementFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($pksfLoanDisbursementMale + $pksfLoanDisbursementFemale,$filRoundUup)}}</td>
                        </tr>
                        <tr>
                            <td class="name">Cumulative Loan Collection </td>
                            <td class="amount">{{num($pksfLoanCollectionMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($pksfLoanCollectionFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($pksfLoanCollectionMale + $pksfLoanCollectionFemale,$filRoundUup)}}</td>
                        </tr>
                        <tr>
                            <td class="name"><strong>Current Outstanding</strong></td>
                            <td class="amount">{{num($pksfOutstandingMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($pksfOutstandingFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($pksfOutstandingMale + $pksfOutstandingFemale,$filRoundUup)}}</td>
                        </tr>
                    </tbody>
                </table>

            </div>
        </div>
    </div>
    @endif
    {{-- End Sixth Table Note-4 --}}


    {{-- Seventh Table Note-4 --}}
    @if(count($nonPksfLoanCategories)>0)
    <div class="row">
        <div class="col-lg-12">
            <div class="table-responsive">
                <table id="tableSeven" class="table table-striped table-bordered pomisOne" border="1pt solid ash" style="color:black; border-collapse: collapse;">
                    <tbody>
                        <tr class="tableHead">
                            <td width="3%" rowspan="{{count($nonPksfLoanCategories)*3+1}}" align="center" valign="middle" nowrap="nowrap" class="note"><div class="rotating">Note-4 (NON-PKSF)</div></td>
                            <th colspan="2" align="left"><div align="left">Outstanding Account (Outstanding in the Field) </div></th>
                            <th width="15%" align="center">Male</th>
                            <th width="14%" align="center">Female</th>
                            <th width="15%" align="center">Total</th>
                        </tr>

                        @foreach ($nonPksfLoanCategories as $key => $loanCategory)
                            @php
                                $loanProductIds = $nonPksfLoanProducts->where('productCategoryId',$loanCategory->id)->pluck('id')->toArray();

                                $nonPksfLoanDisbursementMale = $nonPksfLoanDisbursements->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$nonPksfMaleMemberIds)->sum('loanAmount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',1)->sum('disbursedAmount');

                                $nonPksfLoanDisbursementFemale = $nonPksfLoanDisbursements->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$nonPksfFemaleMemberIds)->sum('loanAmount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',2)->sum('disbursedAmount');

                                if ($filServiceCharge==1) {
                                    $nonPksfLoanCollectionMale = $nonPksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$nonPksfMaleMemberIds)->sum('amount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',1)->sum('recoveryAmount');

                                    $nonPksfLoanCollectionFemale = $nonPksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$nonPksfFemaleMemberIds)->sum('amount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',2)->sum('recoveryAmount');

                                    $nonPksfLoanReapayAmountMale = $nonPksfLoanDisbursements->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$nonPksfMaleMemberIds)->sum('totalRepayAmount');

                                    $nonPksfLoanReapayAmountFemale = $nonPksfLoanDisbursements->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$nonPksfFemaleMemberIds)->sum('totalRepayAmount');
                                }
                                else{
                                    $nonPksfLoanCollectionMale = $nonPksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$nonPksfMaleMemberIds)->sum('principalAmount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',1)->sum('principalRecoveryAmount');

                                    $nonPksfLoanCollectionFemale = $nonPksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$nonPksfFemaleMemberIds)->sum('principalAmount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',2)->sum('principalRecoveryAmount');

                                    $nonPksfLoanReapayAmountMale = $nonPksfLoanDisbursementMale;
                                    $nonPksfLoanReapayAmountFemale = $nonPksfLoanDisbursementFemale;
                                }

                                $nonPksfOutstandingMale = $nonPksfLoanReapayAmountMale - $nonPksfLoanCollectionMale;
                                $nonPksfOutstandingFemale = $nonPksfLoanReapayAmountFemale - $nonPksfLoanCollectionFemale;
                            @endphp
                            <tr>
                                <td width="9%" rowspan="3" align="left">{{$loanCategory->name}}</td>
                                <td width="42%" class="name">Cumulative Loan Disbursement </td>
                                <td class="amount">{{num($nonPksfLoanDisbursementMale,$filRoundUup)}}</td>
                                <td class="amount">{{num($nonPksfLoanDisbursementFemale,$filRoundUup)}}</td>
                                <td class="amount">{{num($nonPksfLoanDisbursementMale + $nonPksfLoanDisbursementFemale,$filRoundUup)}}</td>
                            </tr>
                            <tr>
                                <td class="name">Cumulative Loan Collection </td>
                                <td class="amount">{{num($nonPksfLoanCollectionMale,$filRoundUup)}}</td>
                                <td class="amount">{{num($nonPksfLoanCollectionFemale,$filRoundUup)}}</td>
                                <td class="amount">{{num($nonPksfLoanCollectionMale + $nonPksfLoanCollectionFemale,$filRoundUup)}}</td>
                            </tr>
                            <tr>
                                <td class="name"><strong>Current Outstanding</strong></td>
                                <td class="amount">{{num($nonPksfOutstandingMale,$filRoundUup)}}</td>
                                <td class="amount">{{num($nonPksfOutstandingFemale,$filRoundUup)}}</td>
                                <td class="amount">{{num($nonPksfOutstandingMale + $nonPksfOutstandingFemale,$filRoundUup)}}</td>
                            </tr>

                        @endforeach

                        <tr>
                            @php
                                $loanProductIds = $nonPksfLoanProducts->pluck('id')->toArray();

                                $nonPksfLoanDisbursementMale = $nonPksfLoanDisbursements->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$nonPksfMaleMemberIds)->sum('loanAmount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',1)->sum('disbursedAmount');

                                $nonPksfLoanDisbursementFemale = $nonPksfLoanDisbursements->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$nonPksfFemaleMemberIds)->sum('loanAmount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',2)->sum('disbursedAmount');

                                if ($filServiceCharge==1) {
                                    $nonPksfLoanCollectionMale = $nonPksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$nonPksfMaleMemberIds)->sum('amount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',1)->sum('recoveryAmount');

                                    $nonPksfLoanCollectionFemale = $nonPksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$nonPksfFemaleMemberIds)->sum('amount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',2)->sum('recoveryAmount');

                                    $nonPksfLoanReapayAmountMale = $nonPksfLoanDisbursements->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$nonPksfMaleMemberIds)->sum('totalRepayAmount');
                                    $nonPksfLoanReapayAmountFemale = $nonPksfLoanDisbursements->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$nonPksfFemaleMemberIds)->sum('totalRepayAmount');
                                }
                                else{
                                    $nonPksfLoanCollectionMale = $nonPksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$nonPksfMaleMemberIds)->sum('principalAmount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',1)->sum('principalRecoveryAmount');

                                    $nonPksfLoanCollectionFemale = $nonPksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$nonPksfFemaleMemberIds)->sum('principalAmount') + $branchOpeningLoanInfo->whereIn('productIdFk',$loanProductIds)->where('genderTypeId',2)->sum('principalRecoveryAmount');

                                    $nonPksfLoanReapayAmountMale = $nonPksfLoanDisbursementMale;
                                    $nonPksfLoanReapayAmountFemale = $nonPksfLoanDisbursementFemale;
                                }

                                $nonPksfOutstandingMale = $nonPksfLoanReapayAmountMale - $nonPksfLoanCollectionMale;
                                $nonPksfOutstandingFemale = $nonPksfLoanReapayAmountFemale - $nonPksfLoanCollectionFemale;
                            @endphp
                            <th colspan="2" rowspan="3" align="center" valign="middle" nowrap="nowrap"><strong>Total NON-PKSF</strong></th>
                            <td width="42%" class="name">Cumulative Loan Disbursement </td>
                            <td class="amount">{{num($nonPksfLoanDisbursementMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($nonPksfLoanDisbursementFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($nonPksfLoanDisbursementMale + $nonPksfLoanDisbursementFemale,$filRoundUup)}}</td>
                        </tr>
                        <tr>
                            <td class="name">Cumulative Loan Collection </td>
                            <td class="amount">{{num($nonPksfLoanCollectionMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($nonPksfLoanCollectionFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($nonPksfLoanCollectionMale + $nonPksfLoanCollectionFemale,$filRoundUup)}}</td>
                        </tr>
                        <tr>
                            <td class="name"><strong>Current Outstanding</strong></td>
                            <td class="amount">{{num($nonPksfOutstandingMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($nonPksfOutstandingFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($nonPksfOutstandingMale + $nonPksfOutstandingFemale,$filRoundUup)}}</td>
                        </tr>
                    </tbody>
                </table>

            </div>
        </div>
    </div>
    @endif
    {{-- End Seventh Table Note-4 --}}

    {{-- Note-4 Total Table --}}
    <div class="row">
        <div class="col-lg-12">
            <div class="table-responsive">
                <table id="note3totalTable" class="table table-striped table-bordered pomisOne" border="1pt solid ash" style="color:black; border-collapse: collapse;">
                    <tbody>
                        @php
                            $loanDisbursementMale = $pksfLoanDisbursementMale + $nonPksfLoanDisbursementMale;
                            $loanDisbursementFemale = $pksfLoanDisbursementFemale + $nonPksfLoanDisbursementFemale;
                            $totalLoanDisbursement = $loanDisbursementMale + $loanDisbursementFemale;

                            $loanCollectionMale = $pksfLoanCollectionMale + $nonPksfLoanCollectionMale;
                            $loanCollectionFemale = $pksfLoanCollectionFemale + $nonPksfLoanCollectionFemale;
                            $totalLoanCollection = $loanCollectionMale + $loanCollectionFemale;

                            $outstandingMale = $pksfOutstandingMale + $nonPksfOutstandingMale;
                            $outstandingFemale = $pksfOutstandingFemale + $nonPksfOutstandingFemale;
                            $totalOutstanding = $outstandingMale + $outstandingFemale;
                        @endphp
                        <tr>
                            <th colspan="2" width="16%" rowspan="3" align="center" valign="middle" nowrap="nowrap"><strong>Total PKSF &amp; NON-PKSF</strong></th>
                            <td width="42%" class="name">Cumulative Loan Disbursement </td>
                            <td class="amount">{{num($loanDisbursementMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($loanDisbursementFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalLoanDisbursement,$filRoundUup)}}</td>
                        </tr>
                        <tr>
                            <td class="name">Cumulative Loan Collection </td>
                            <td class="amount">{{num($loanCollectionMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($loanCollectionFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalLoanCollection,$filRoundUup)}}</td>
                        </tr>
                        <tr>
                            <td class="name"><strong>Current Outstanding</strong></td>
                            <td class="amount">{{num($outstandingMale,$filRoundUup)}}</td>
                            <td class="amount">{{num($outstandingFemale,$filRoundUup)}}</td>
                            <td class="amount">{{num($totalOutstanding,$filRoundUup)}}</td>
                        </tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    {{-- End Note-4 Total Table --}}

    {{-- writeoff Table --}}
    <div class="row">
        <div class="col-lg-12">
            <div class="table-responsive">
                <table  id="tableWriteoff" class="table table-striped table-bordered pomisOne" border="1pt solid ash" style="color:black; border-collapse: collapse;">
                    <thead>
                        <tr>
                            <th colspan="2"> Component</th>
                            <th colspan="6"> Cumulative Write Off Information</th>
                            <th rowspan="3"> Cumulative Service Charge Collection </th>
                        </tr>
                        <tr>
                            <th rowspan="2">Funding Organization Name</th>
                            <th rowspan="2">Loan Product Category Name</th>
                            <th colspan="2">Male</th>
                            <th colspan="2">Female</th>
                            <th colspan="2">Total</th>
                        </tr>
                        <tr>
                           <th width="80px">No. of Member</th>
                           <th><b>Amount</b></th>
                           <th width="80px">No. of Member</th>
                           <th><b>Amount</b></th>
                           <th width="80px">No. of Member</th>
                           <th>Amount</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($pksfLoanCategories as $key => $pksfLoanCategory)
                            @php
                                $cumServiceChargeAmount = $pksfCatgCumServiceCharges->where('categoryId',$pksfLoanCategory->id)->sum('cumSerCharge');
                                $maleWriteOffNo = $pksfCatgCumServiceCharges->where('categoryId',$pksfLoanCategory->id)->sum('maleWriteOffNo');
                                $maleWriteOffAmount = $pksfCatgCumServiceCharges->where('categoryId',$pksfLoanCategory->id)->sum('maleWriteOffAmount');
                                $femaleWriteOffNo = $pksfCatgCumServiceCharges->where('categoryId',$pksfLoanCategory->id)->sum('femaleWriteOffNo');
                                $femaleWriteOffAmount = $pksfCatgCumServiceCharges->where('categoryId',$pksfLoanCategory->id)->sum('femaleWriteOffAmount');
                                $bothWtiteOffNo = $maleWriteOffNo + $femaleWriteOffNo;
                                $bothWriteOffAmount = $maleWriteOffAmount + $femaleWriteOffAmount;
                            @endphp
                            <tr>
                                @if ($key==0)
                                    <td rowspan="{{count($pksfLoanCategories)}}">PKSF</td>
                                @endif
                                <td> {{$pksfLoanCategory->name}} </td>
                                <td>{{$maleWriteOffNo}}</td>
                                <td class="amount">{{num($maleWriteOffAmount,$filRoundUup)}}</td>
                                <td>{{$femaleWriteOffNo}}</td>
                                <td class="amount">{{num($femaleWriteOffAmount,$filRoundUup)}}</td>
                                <td>{{$bothWtiteOffNo}}</td>
                                <td class="amount">{{num($bothWriteOffAmount,$filRoundUup)}}</td>
                                <td class="amount">{{num($cumServiceChargeAmount,$filRoundUup)}}</td>
                            </tr>
                        @endforeach
                        @if (count($pksfLoanCategories)>0)
                            @php
                                $cumServiceChargeAmount = $pksfCatgCumServiceCharges->sum('cumSerCharge');
                                $maleWriteOffNo = $pksfCatgCumServiceCharges->sum('maleWriteOffNo');
                                $maleWriteOffAmount = $pksfCatgCumServiceCharges->sum('maleWriteOffAmount');
                                $femaleWriteOffNo = $pksfCatgCumServiceCharges->sum('femaleWriteOffNo');
                                $femaleWriteOffAmount = $pksfCatgCumServiceCharges->sum('femaleWriteOffAmount');
                                $bothWtiteOffNo = $maleWriteOffNo + $femaleWriteOffNo;
                                $bothWriteOffAmount = $maleWriteOffAmount + $femaleWriteOffAmount;
                            @endphp
                            <tr class="subTotalTr">
                                <td colspan="2" align="center" valign="middle" nowrap="nowrap"><strong>Total PKSF</strong></td>
                                <td>{{$maleWriteOffNo}}</td>
                                <td class="amount">{{num($maleWriteOffAmount,$filRoundUup)}}</td>
                                <td>{{$femaleWriteOffNo}}</td>
                                <td class="amount">{{num($femaleWriteOffAmount,$filRoundUup)}}</td>
                                <td>{{$bothWtiteOffNo}}</td>
                                <td class="amount">{{num($bothWriteOffAmount,$filRoundUup)}}</td>
                                <td class="amount">{{num($cumServiceChargeAmount,$filRoundUup)}}</td>
                            </tr>
                        @endif

                        @foreach ($nonPksfLoanCategories as $key => $nonPksfLoanCategory)
                            @php
                                $cumServiceChargeAmount = $nonPksfCatgCumServiceCharges->where('categoryId',$nonPksfLoanCategory->id)->sum('cumSerCharge');
                                $maleWriteOffNo = $nonPksfCatgCumServiceCharges->where('categoryId',$nonPksfLoanCategory->id)->sum('maleWriteOffNo');
                                $maleWriteOffAmount = $nonPksfCatgCumServiceCharges->where('categoryId',$nonPksfLoanCategory->id)->sum('maleWriteOffAmount');
                                $femaleWriteOffNo = $nonPksfCatgCumServiceCharges->where('categoryId',$nonPksfLoanCategory->id)->sum('femaleWriteOffNo');
                                $femaleWriteOffAmount = $nonPksfCatgCumServiceCharges->where('categoryId',$nonPksfLoanCategory->id)->sum('femaleWriteOffAmount');
                                $bothWtiteOffNo = $maleWriteOffNo + $femaleWriteOffNo;
                                $bothWriteOffAmount = $maleWriteOffAmount + $femaleWriteOffAmount;

                            @endphp
                            <tr>
                                @if ($key==0)
                                    <td rowspan="{{count($nonPksfLoanCategories)}}">NON-PKSF</td>
                                @endif
                                <td> {{$nonPksfLoanCategory->name}} </td>
                                <td>{{$maleWriteOffNo}}</td>
                                <td class="amount">{{num($maleWriteOffAmount,$filRoundUup)}}</td>
                                <td>{{$femaleWriteOffNo}}</td>
                                <td class="amount">{{num($femaleWriteOffAmount,$filRoundUup)}}</td>
                                <td>{{$bothWtiteOffNo}}</td>
                                <td class="amount">{{num($bothWriteOffAmount,$filRoundUup)}}</td>
                                <td class="amount">{{num($cumServiceChargeAmount,$filRoundUup)}}</td>
                            </tr>
                        @endforeach
                        @if (count($nonPksfLoanCategories)>0)
                            @php
                                $cumServiceChargeAmount = $nonPksfCatgCumServiceCharges->sum('cumSerCharge');
                                $maleWriteOffNo = $nonPksfCatgCumServiceCharges->sum('maleWriteOffNo');
                                $maleWriteOffAmount = $nonPksfCatgCumServiceCharges->sum('maleWriteOffAmount');
                                $femaleWriteOffNo = $nonPksfCatgCumServiceCharges->sum('femaleWriteOffNo');
                                $femaleWriteOffAmount = $nonPksfCatgCumServiceCharges->sum('femaleWriteOffAmount');
                                $bothWtiteOffNo = $maleWriteOffNo + $femaleWriteOffNo;
                                $bothWriteOffAmount = $maleWriteOffAmount + $femaleWriteOffAmount;
                            @endphp
                            <tr class="subTotalTr">
                                <td colspan="2" align="center" valign="middle" nowrap="nowrap"><strong>Total NON-PKSF</strong></td>
                                <td>{{$maleWriteOffNo}}</td>
                                <td class="amount">{{num($maleWriteOffAmount,$filRoundUup)}}</td>
                                <td>{{$femaleWriteOffNo}}</td>
                                <td class="amount">{{num($femaleWriteOffAmount,$filRoundUup)}}</td>
                                <td>{{$bothWtiteOffNo}}</td>
                                <td class="amount">{{num($bothWriteOffAmount,$filRoundUup)}}</td>
                                <td class="amount">{{num($cumServiceChargeAmount,$filRoundUup)}}</td>
                            </tr>

                        @endif

                        <tr class="grandTotal">
                            @php
                                $cumServiceChargeAmount = $pksfCatgCumServiceCharges->sum('cumSerCharge') + $nonPksfCatgCumServiceCharges->sum('cumSerCharge');
                                $maleWriteOffNo = $pksfCatgCumServiceCharges->sum('maleWriteOffNo') + $nonPksfCatgCumServiceCharges->sum('maleWriteOffNo');
                                $maleWriteOffAmount = $pksfCatgCumServiceCharges->sum('maleWriteOffAmount') + $nonPksfCatgCumServiceCharges->sum('maleWriteOffAmount');
                                $femaleWriteOffNo = $pksfCatgCumServiceCharges->sum('femaleWriteOffNo') + $nonPksfCatgCumServiceCharges->sum('femaleWriteOffNo');
                                $femaleWriteOffAmount = $pksfCatgCumServiceCharges->sum('femaleWriteOffAmount') + $nonPksfCatgCumServiceCharges->sum('femaleWriteOffAmount');
                                $bothWtiteOffNo = $maleWriteOffNo + $femaleWriteOffNo;
                                $bothWriteOffAmount = $maleWriteOffAmount + $femaleWriteOffAmount;
                            @endphp
                            <td colspan="2" align="center" valign="middle" nowrap="nowrap"><strong>Total PKSF &amp; NON-PKSF</strong></td>
                            <td >{{$maleWriteOffNo}}</td>
                            <td class="amount">{{num($maleWriteOffAmount,$filRoundUup)}}</td>
                            <td >{{$femaleWriteOffNo}}</td>
                            <td class="amount">{{num($femaleWriteOffAmount,$filRoundUup)}}</td>
                            <td >{{$bothWtiteOffNo}}</td>
                            <td class="amount">{{num($bothWriteOffAmount,$filRoundUup)}}</td>
                            <td class="amount">{{num($cumServiceChargeAmount,$filRoundUup)}}</td>
                        </tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    {{-- End writeoff Table --}}


</div>      {{-- printDiv DIV --}}


<script type="text/javascript">
    $("#loadingModal").hide();
</script>

<style type="text/css">
    table > thead > tr > td, table > tbody > tr > td, table > thead > tr > th, table > tbody > tr > th {
        padding: 2px !important;
        font-size: 10px !important;
        text-transform: capitalize!important;
    }

    table > thead > tr .sNo {
        width: 23px !important;
    }
    table > thead > tr .code {
        width: 90px !important;
    }
    table > thead > tr .priPro {
        width: 55px !important;
    }
    table > thead > tr .name {
        width: 72px !important;
    }
    table > thead > tr .spouse {
        width: 72px !important;
    }
    table > thead > tr .opBalance {
        width: 60px !important;
    }
    table > thead > tr .weeks {
        width: 75px !important;
    }
    table > thead > tr .balance {
        width: 60px !important;
    }

    .subTotalTr td{
        background-color: #9cb1d3;
    }
    .grandTotal td{
        background-color: #819bc4;
    }
    .funTotal td{
        background-color: #8296b7;
    }
    .allFunOrgTotal td{
        background-color: #55729e;
    }

    .rotating
    {
        -ms-writing-mode: tb-rl;
        -webkit-writing-mode: vertical-rl;
        -moz-writing-mode: vertical-rl;
        -ms-writing-mode: vertical-rl;
        writing-mode: vertical-rl;
    }
    table tr td.note{
        background-color: #696969 !important;
        color: white;
        border-color: white !important;
    }
    tr.tableHead td, tr.tableHead th{
        background-color: #696969;
        color: white;
        border-color: white !important;
    }

    .tableDiv{
        padding-top: 10px !important;
    }
</style>

<script type="text/javascript">
    $(document).ready(function() {
        $("#note3totalTable tbody tr td:gt(1)").each(function(index, el) {
            // $("#tableFive tbody tr td").nth-child(index);
            // alert(index);
        });
    });
</script>