@include('microfin/miscellaneous/monthEndPendingAlert')

@php
function num($number,$filRoundUup){
    if ($filRoundUup==1) {
        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">
    @include('microfin.reports.pksfPomisReport.pksfPomis5ReportNew.header')
    @include('microfin.reports.pksfPomisReport.pksfPomis5ReportNew.noteOne')
    @include('microfin.reports.pksfPomisReport.pksfPomis5ReportNew.loanRegister')

    {{-- Third Table --}}
        @php
            $savingsProductSegmentArray = [
                'gen' => 'General',
                'vol' => 'Voluntary',
                'others' => 'Others',
            ];
        @endphp
        <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>
                                @foreach($savingsProductSegmentArray as $savingsProductSegment)
                                    <th colspan="3" align="center">{{ $savingsProductSegment }} Savings</th>
                                @endforeach
                                <th colspan="3" align="center">Total Savings </th>
                            </tr>
                            <tr>
                                @foreach($savingsProductSegmentArray as $savingsProductSegment)
                                    <th width="7%" align="center">M</th>
                                    <th width="7%" align="center">F</th>
                                    <th width="7%" align="center">Total</th>
                                @endforeach
                                <th width="7%" align="center">M</th>
                                <th width="7%" align="center">F</th>
                                <th width="7%" align="center">Total</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php 
                                foreach($savingsProductSegmentArray as $i => $savingsProductSegment){
                                    ${'grand_'.$i.'BalanceMale'} = 0;
                                    ${'grand_'.$i.'BalanceFemale'} = 0;
                                }

                                $grand_balanceMale = 0;
                                $grand_balanceFemale = 0;
                            @endphp
                                @php 
                                    $curSavingsData = $savingsData->whereIn('fundingOrganizationId', $pksfOthersFundingOrgs);
                                    $curSavingsMaleData = $curSavingsData->where('genderTypeId', 1);
                                    $curSavingsFemaleData = $curSavingsData->where('genderTypeId', 2);
                                    $genSavingsMaleData = $curSavingsMaleData->whereIn('savingProductIdFk', $savingsType->where('savingsType', 1)->pluck('productIds')->toArray());
                                    $genSavingsFemaleData = $curSavingsFemaleData->whereIn('savingProductIdFk', $savingsType->where('savingsType', 1)->pluck('productIds')->toArray());
                                    $volSavingsMaleData = $curSavingsMaleData->whereIn('savingProductIdFk', $savingsType->where('savingsType', 2)->pluck('productIds')->toArray());
                                    $volSavingsFemaleData = $curSavingsFemaleData->whereIn('savingProductIdFk', $savingsType->where('savingsType', 2)->pluck('productIds')->toArray());
                                    $othersSavingsMaleData = $curSavingsMaleData->whereIn('savingProductIdFk', $savingsType->where('savingsType',  3)->pluck('productIds')->toArray());
                                    $othersSavingsFemaleData = $curSavingsFemaleData->whereIn('savingProductIdFk', $savingsType->where('savingsType',  3)->pluck('productIds')->toArray());

                                    foreach($savingsProductSegmentArray as $i => $savingsProductSegment){
                                        ${$i.'ProvisionMale'} = ${$i.'SavingsMaleData'}->sum('cumInterestProvision');
                                        ${$i.'ProvisionFemale'} = ${$i.'SavingsFemaleData'}->sum('cumInterestProvision');
                                        ${$i.'CollectionMale'} = ${$i.'SavingsMaleData'}->sum('cumCollection')-(${$i.'ProvisionMale'});
                                        ${$i.'CollectionFemale'} = ${$i.'SavingsFemaleData'}->sum('cumCollection')-(${$i.'ProvisionFemale'});
                                        ${$i.'SavingsMale'} = ${$i.'CollectionMale'}+${$i.'ProvisionMale'};
                                        ${$i.'SavingsFemale'} = ${$i.'CollectionFemale'}+${$i.'ProvisionFemale'};
                                        ${$i.'WithdrawMale'} = ${$i.'SavingsMaleData'}->sum('cumWithdraw')-(${$i.'ProvisionMale'});
                                        ${$i.'WithdrawFemale'} = ${$i.'SavingsFemaleData'}->sum('cumWithdraw')-(${$i.'ProvisionFemale'});
                                        ${$i.'BalanceMale'} = ${$i.'SavingsMale'}-${$i.'WithdrawMale'};
                                        ${$i.'BalanceFemale'} = ${$i.'SavingsFemale'}-${$i.'WithdrawFemale'};

                                        ${'grand_'.$i.'BalanceMale'} += ${$i.'BalanceMale'};
                                        ${'grand_'.$i.'BalanceFemale'} += ${$i.'BalanceFemale'};
                                    }

                                    $totalCollectionMale = $genCollectionMale+$volCollectionMale+$othersCollectionMale;
                                    $totalCollectionFemale = $genCollectionFemale+$volCollectionFemale+$othersCollectionFemale;
                                    $totalProvisionMale = $genProvisionMale+$volProvisionMale+$othersProvisionMale;
                                    $totalProvisionFemale = $genProvisionFemale+$volProvisionFemale+$othersProvisionFemale;
                                    $totalSavingsMale = $genSavingsMale+$volSavingsMale+$othersSavingsMale;
                                    $totalSavingsFemale = $genSavingsFemale+$volSavingsFemale+$othersSavingsFemale;
                                    $totalWithdrawMale = $genWithdrawMale+$volWithdrawMale+$othersWithdrawMale;
                                    $totalWithdrawFemale = $genWithdrawFemale+$volWithdrawFemale+$othersWithdrawFemale;
                                    $balanceMale = $genBalanceMale+$volBalanceMale+$othersBalanceMale;
                                    $balanceFemale = $genBalanceFemale+$volBalanceFemale+$othersBalanceFemale;

                                    $grand_balanceMale += $balanceMale;
                                    $grand_balanceFemale += $balanceFemale;
                                @endphp
                                <tr>
                                    <td width="4%" rowspan="5" align="center" valign="middle" nowrap="nowrap"  class="note"><div class="rotating">Note-3 ({{ $filFundingOrgName }})</div></td>
                                    <td nowrap="nowrap" class="name">Cumulative Savings Collection (A) </td>
                                    @foreach($savingsProductSegmentArray as $i => $savingsProductSegment)
                                        <td class="amount">{{ num(${$i.'CollectionMale'},$filRoundUup) }}</td>
                                        <td class="amount">{{ num(${$i.'CollectionFemale'},$filRoundUup) }}</td>
                                        <td class="amount">{{ num(${$i.'CollectionMale'}+${$i.'CollectionFemale'},$filRoundUup) }}</td>
                                    @endforeach
                                    <td class="amount">{{ num($totalCollectionMale,$filRoundUup) }}</td>
                                    <td class="amount">{{ num($totalCollectionFemale,$filRoundUup) }}</td>
                                    <td class="amount">{{ num($totalCollectionMale+$totalCollectionFemale,$filRoundUup) }}</td>
                                </tr>

                                <tr>
                                    <td nowrap="nowrap" class="name">Cumulative Interest Provission (B) </td>
                                    @foreach($savingsProductSegmentArray as $i => $savingsProductSegment)
                                        <td class="amount">{{ num(${$i.'ProvisionMale'},$filRoundUup) }}</td>
                                        <td class="amount">{{ num(${$i.'ProvisionFemale'},$filRoundUup) }}</td>
                                        <td class="amount">{{ num(${$i.'ProvisionMale'}+${$i.'ProvisionFemale'},$filRoundUup) }}</td>
                                    @endforeach
                                    
                                    <td class="amount">{{ num($totalProvisionMale,$filRoundUup) }}</td>
                                    <td class="amount">{{ num($totalProvisionFemale,$filRoundUup) }}</td>
                                    <td class="amount">{{ num($totalProvisionMale+$totalProvisionFemale,$filRoundUup) }}</td>
                                </tr>

                                <tr>
                                    <td nowrap="nowrap" class="name">Total Savings (C) = (A) + (B)</td>
                                    @foreach($savingsProductSegmentArray as $i => $savingsProductSegment)
                                        <td class="amount">{{ num(${$i.'SavingsMale'},$filRoundUup) }}</td>
                                        <td class="amount">{{ num(${$i.'SavingsFemale'},$filRoundUup) }}</td>
                                        <td class="amount">{{ num(${$i.'SavingsMale'}+${$i.'SavingsFemale'},$filRoundUup) }}</td>
                                    @endforeach

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

                                <tr>
                                    <td nowrap="nowrap" class="name">Cumulative Savings Return/Withdrwal (D)</td>
                                    @foreach($savingsProductSegmentArray as $i => $savingsProductSegment)
                                        <td class="amount">{{ num(${$i.'WithdrawMale'},$filRoundUup) }}</td>
                                        <td class="amount">{{ num(${$i.'WithdrawFemale'},$filRoundUup) }}</td>
                                        <td class="amount">{{ num(${$i.'WithdrawMale'}+${$i.'WithdrawFemale'},$filRoundUup) }}</td>
                                    @endforeach
                                    
                                    <td class="amount">{{ num($totalWithdrawMale,$filRoundUup) }}</td>
                                    <td class="amount">{{ num($totalWithdrawFemale,$filRoundUup) }}</td>
                                    <td class="amount">{{ num($totalWithdrawMale+$totalWithdrawFemale,$filRoundUup) }}</td>
                                </tr>

                                <tr>
                                    <td nowrap="nowrap" class="name">Current Savings Balance (E) = (C) - (D)</td>
                                    @foreach($savingsProductSegmentArray as $i => $savingsProductSegment)
                                        <td class="amount">{{ num(${$i.'BalanceMale'},$filRoundUup) }}</td>
                                        <td class="amount">{{ num(${$i.'BalanceFemale'},$filRoundUup) }}</td>
                                        <td class="amount">{{ num(${$i.'BalanceMale'}+${$i.'BalanceFemale'},$filRoundUup) }}</td>
                                    @endforeach
                                    <td class="amount">{{ num($balanceMale,$filRoundUup) }}</td>
                                    <td class="amount">{{ num($balanceFemale,$filRoundUup) }}</td>
                                    <td class="amount">{{ num($balanceMale+$balanceFemale,$filRoundUup) }}</td>
                                </tr>
                            <tr class="grandTotal" style="font-weight:bold" >
                                <td colspan="2"  width="16%" rowspan="3" align="center" valign="middle" nowrap="nowrap">Grnad Total</td>
                                @foreach($savingsProductSegmentArray as $i => $savingsProductSegment)
                                    <td class="amount">{{ num(${'grand_'.$i.'BalanceMale'},$filRoundUup) }}</td>
                                    <td class="amount">{{ num(${'grand_'.$i.'BalanceFemale'},$filRoundUup) }}</td>
                                    <td class="amount">{{ num(${'grand_'.$i.'BalanceMale'} + ${'grand_'.$i.'BalanceFemale'},$filRoundUup) }}</td>
                                @endforeach
                                <td class="amount">{{ num($grand_balanceMale,$filRoundUup) }}</td>
                                <td class="amount">{{ num($grand_balanceFemale,$filRoundUup) }}</td>
                                <td class="amount">{{ num($grand_balanceMale+$grand_balanceFemale,$filRoundUup) }}</td>
                            </tr>

                        </tbody>
                    </table>
                </div>
            </div>
        </div>
        
    {{-- End Table Note-3 --}}
                            
    {{-- note 4 table--}}
    @include('microfin.reports.pksfPomisReport.pksfPomis5ReportNew.noteFour')
    {{-- note 4 table end--}}
    
    {{-- writeoff table --}}
    @include('microfin.reports.pksfPomisReport.pksfPomis5ReportNew.writeOffPksfAndOthers')
    {{-- writeoff table end --}}
</div>      {{-- printDiv DIV --}}


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

    $('.amount').each(function(){        
        if ($(this).text() == 0)
        {
            $(this).text('-');
        }
    });
</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() {

        /*setNote3totalTableWidth();
        $(window).resize(function(event) {
            setNote3totalTableWidth();
        });*/        

        function setNote3totalTableWidth() {
            for (i = 2; i <= 13; i++) { 
                $("#note3totalTable tr td:nth-child("+i+")").width($("#tableFour tbody tr:first td:nth-child("+(i+1)+")").width());
            }
            
        }
    });
</script>