@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">{{num($cumSerChargeCollectionPKSF,$filRoundUup)}}</td>
                        <td class="amount">-</td>
                        <td class="amount">{{num($cumSerChargeCollectionPKSF,$filRoundUup)}}</td>
                    <tr>
                        <td align="left">Total Others Income</td>
                        <td class="amount">{{num($totalOthersIncomePKSF,$filRoundUup)}}</td>
                        <td class="amount">-</td>
                        <td class="amount">{{num($totalOthersIncomePKSF,$filRoundUup)}}</td>
                    </tr>
                    <tr>
                        <td align="left">Cumulative Total Income</td>
                        <td class="amount">{{num($cumSerChargeCollectionPKSF + $totalOthersIncomePKSF,$filRoundUup)}}</td>
                        <td class="amount">-</td>
                        <td class="amount">{{num($cumSerChargeCollectionPKSF + $totalOthersIncomePKSF,$filRoundUup)}}</td>
                    </tr>
                    <tr>
                        <td align="left">Cumulative Total Expenditure</td>
                        <td class="amount">{{num($cumTotalExpenditurePKSF,$filRoundUup)}}</td>
                        <td class="amount">-</td>
                        <td class="amount">{{num($cumTotalExpenditurePKSF,$filRoundUup)}}</td>
                    </tr>
                    <tr>
                        <td align="left">Fund Account (Surplus)</td>
                        <td class="amount">{{num($surplusPKSF,$filRoundUup)}}</td>
                        <td class="amount">-</td>
                        <td class="amount">{{num($surplusPKSF,$filRoundUup)}}</td>
                    </tr>
                    <tr>
                        <td align="left">Reserve Fund</td>
                        <td class="amount">{{num($reserveFundPKSF,$filRoundUup)}}</td>
                        <td class="amount">-</td>
                        <td class="amount">{{num($reserveFundPKSF,$filRoundUup)}}</td>
                    </tr>
                                                <tr>
                        <td align="left">Cumulative Total Salary Paid</td>
                        <td class="amount">{{num($staffSalaryPKSF,$filRoundUup)}}</td>
                        <td class="amount">-</td>
                        <td class="amount">{{num($staffSalaryPKSF,$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">
        <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($pksfFundLoanProducts)+2}}" align="center" valign="middle" nowrap="nowrap"><div class="rotating">Note-2 (PKSF)</div></td>
                            <th width="17%" 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>

                        @foreach($pksfFundLoanProducts as $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>
                                <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
    @endif
    {{-- End Second Table --}}

    {{-- Forth Table Note-3 --}}
    @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;">
                    <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 (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
                                $totalMaleSavCollection = $cumGenSavCollMale + $cumVOlSavCollMale + $cumOthSavCollMale;
                                $totalFemaleSavCollection = $cumGenSavCollFemale + $cumVOlSavCollFemale + $cumOthSavCollFemale;
                            @endphp
                            <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 align="left" 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
                                $totalMaleSavCollection = $cumGenSavCollMale + $cumVOlSavCollMale + $cumOthSavCollMale;
                                $totalFemaleSavCollection = $cumGenSavCollFemale + $cumVOlSavCollFemale + $cumOthSavCollFemale;
                            @endphp
                            <td nowrap="nowrap" class="name">Total Savings (C) = (A) + (B) </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>
                            @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 --}}

    {{-- Sixth Table Note-4 --}}

    @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"><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');
                                    $pksfLoanCollectionFemale = $pksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$pksfFemaleMemberIds)->sum('amount');

                                    $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');
                                    $pksfLoanCollectionFemale = $pksfLoanCollections->whereIn('productIdFk',$loanProductIds)->whereIn('memberIdFk',$pksfFemaleMemberIds)->sum('amount');

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

    {{-- writeoff Table --}}
    @if (count($pksfCatgCumServiceCharges)>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 ($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                                          
                    </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>