@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">
        <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;"> 
                    <tbody>
                        <tr class="tableHead">
                            <td width="3%" rowspan="11" align="center" valign="middle" nowrap="nowrap"><div class="rotating">Note-1</div></td>
                            <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>
                        <tr>
                            <th align="right">-</th>
                            <th width="20%" colspan="2" align="right">-</th>
                            <th width="20%" align="right">-</th>
                        </tr>   

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

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

    @if(in_array(1,$filBranchIds))

    {{-- Third Table --}}
    @if(count($non_pksfFundLoanProducts)>0)
    <div class="row">
        <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;"> 
                  <tbody>
                        <tr class="tableHead">
                            <td width="3%" rowspan="{{count($non_pksfFundLoanProducts)+2}}" align="center" valign="middle" nowrap="nowrap"><div class="rotating">Note-2 (NON-PKSF)</div></td>
                            <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 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>

                        @foreach($non_pksfFundLoanProducts as $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>
                                <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 --}}

    {{-- 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;">
                <tbody>
                    <tr  class="tableHead">
                        <th colspan="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  class="tableHead">
                        <td width="4%" rowspan="6" align="center" valign="middle" nowrap="nowrap"><div class="rotating">Note-3 (NON-PKSF)</div></td>
                        <td width="10%" align="left" nowrap="nowrap">&nbsp;</td>
                        <td width="7%" align="center">M</td>
                        <td width="7%" align="center">F</td>
                        <td width="7%" align="center">Total</td>
                        <td width="7%" align="center">M</td>
                        <td width="7%" align="center">F</td>
                        <td width="7%" align="center">Total</td>
                        <td width="7%" align="center">M</td>
                        <td width="7%" align="center">F</td>
                        <td width="7%" align="center">Total</td>
                        <td width="7%" align="center">M</td>
                        <td width="7%" align="center">F</td>
                        <td width="7%" align="center">Total</td>
                    </tr>
                    <tr>
                        @php
                            $totalMaleSavCollectionNonPksf = $cumGenSavCollMaleNonPksf + $cumVOlSavCollMaleNonPksf + $cumOthSavCollMaleNonPksf;
                            $totalFemaleSavCollectionNonPksf = $cumGenSavCollFemaleNonPksf + $cumVOlSavCollFemaleNonPksf + $cumOthSavCollFemaleNonPksf;
                        @endphp
                        <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(0,$filRoundUup)}}</td>
                        <td class="amount">{{num(0,$filRoundUup)}}</td>
                        <td class="amount">{{num(0,$filRoundUup)}}</td>
                        <td class="amount">{{num(0,$filRoundUup)}}</td>
                        <td class="amount">{{num(0,$filRoundUup)}}</td>
                        <td class="amount">{{num(0,$filRoundUup)}}</td>
                        <td class="amount">{{num(0,$filRoundUup)}}</td>
                        <td class="amount">{{num(0,$filRoundUup)}}</td>
                        <td class="amount">{{num(0,$filRoundUup)}}</td>
                        <td class="amount">{{num(0,$filRoundUup)}}</td>
                        <td class="amount">{{num(0,$filRoundUup)}}</td>
                        <td class="amount">{{num(0,$filRoundUup)}}</td>
                    </tr>
                  
                    {{-- Interest Will be added later --}}
                    <tr>
                        @php
                            $totalMaleSavCollectionNonPksf = $cumGenSavCollMaleNonPksf + $cumVOlSavCollMaleNonPksf + $cumOthSavCollMaleNonPksf;
                            $totalFemaleSavCollectionNonPksf = $cumGenSavCollFemaleNonPksf + $cumVOlSavCollFemaleNonPksf + $cumOthSavCollFemaleNonPksf;
                        @endphp
                        <td nowrap="nowrap" class="name">Total Savings (C) = (A) + (B) </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>
                        @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 --}}


    {{-- 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"><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');
                                    $nonPksfLoanCollectionFemale = $nonPksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$nonPksfFemaleMemberIds)->sum('amount');

                                    $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');
                                    $nonPksfLoanCollectionFemale = $nonPksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$nonPksfFemaleMemberIds)->sum('amount');

                                    $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 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 --}}

    {{-- writeoff Table --}}
    @if (count($nonPksfCatgCumServiceCharges)>0)
    <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 ($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                        
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    @endif
    {{-- End writeoff Table --}}


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


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

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

    .pomisOne > thead > tr .sNo {
        width: 23px !important;
    }
    .pomisOne > thead > tr .code {
        width: 90px !important;
    }
    .pomisOne > thead > tr .priPro {
        width: 55px !important;
    }
    .pomisOne > thead > tr .name {
        width: 72px !important;
    }
    .pomisOne > thead > tr .spouse {
        width: 72px !important;
    }
    .pomisOne > thead > tr .opBalance {
        width: 60px !important;
    }
    .pomisOne > thead > tr .weeks {
        width: 75px !important;
    }
    .pomisOne > 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;
    }
    .note{
        color: white;
        font-size: 10px;
        margin-top: 1px;
    }

    .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;
    }
    tr.tableHead td, tr.tableHead th{
        background-color: #696969;
        color: white;
        border-color: white !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>