@if ($printLayer != 3)
    @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
                        @foreach($fundingOrgs as $fundingOrg)
                            @php 
                                $curSavingsData = $savingsData->where('fundingOrganizationId', $fundingOrg->id);
                                $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 ({{ $fundingOrg->name }})</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>
                        @endforeach
                        <tr class="grandTotal" style="font-weight:bold" >
                            <td colspan="2"  width="16%" rowspan="3" align="center" valign="middle" nowrap="nowrap">Grand 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>
@endif