@if($loanInfo)

<div class="col-lg-12">
    <div class="table-responsive">
        <table id="pomisOne1" class="table table-striped table-bordered pomisOne" border="1pt solid ash" style="color:black; border-collapse: collapse;">
            <thead>
                <tr>
                    <th colspan="3">Types of Loan</th>

                    <th rowspan="2" class="w90">Loan Disbursement (LD) During this Half Year (Principal)</th>
                    <th colspan="2" class="w80">Loan Recoverable(LRc) During this Half Year</th>
                    <th colspan="2">Loan Realization(LR) in this Half Year</th>

                    <th rowspan="2" class="w90">Cumulative Loan Disbursement after the end of this Half Year (Principal)</th>
                    <th colspan="2">Cumulative Loan Collection after the end of this Half Year</th>

                    <th rowspan="2" class="w40">Number of Borrowers</th>
                    <th rowspan="2" class="w80">Loan Balance (Principal)</th>
                    <th rowspan="2" class="w50">Tenure of the Loan</th>
                    <th rowspan="2" class="w50">Total Number of Installments</th>
                    <th rowspan="2" class="w70">Amount of Advance Installments at the end of this Half Year (Principal)</th>
                    <th rowspan="2" class="w40">Recovery Rate of this Half Year</th>
                    <th rowspan="2" class="w40">Declared Rate of Service Charge(%)</th>
                </tr>

                <tr>
                    <th rowspan="2" class="w60">Category</th>
                    <th rowspan="2" class="w60">Sub-Category</th>
                    <th rowspan="2" class="w60">Sub-Sub-Category</th>

                    <th class="w80">Principal</th>
                    <th class="w80">Service Charge</th>

                    <th class="w80">Principal</th>
                    <th class="w80">Service Charge</th>

                    <th class="w60">Principal</th>
                    <th class="w60">Service Charge</th>
                </tr>

                <tr>
                    <th>1</th>
                    <th>2</th>
                    <th>3</th>
                    <th>4</th>
                    <th>5</th>
                    <th>6</th>
                    <th>7</th>
                    <th>8</th>
                    <th>9</th>
                    <th>10 = 6-7</th>
                    <th>11</th>
                    <th>12</th>
                    <th>13</th>
                    <th>14</th>
                    <th>15</th>
                </tr>
            </thead>

            <tbody>
                @php
                    $total_currentQuarterDisbursementAmount = 0;
                    $total_currentQuarterRepayAmount_Principal = 0;
                    $total_currentQuarterRepayAmount_Interest = 0;
                    $total_currentQuarterCollectionAmount_Principal = 0;
                    $total_currentQuarterCollectionAmount_Interest = 0;
                    $total_disbursementAmount_upto = 0;
                    $total_collectionAmount_Principal_upto = 0;
                    $total_collectionAmount_Interest_upto = 0;
                    $total_numberOfLoanAccounts = 0;
                    $total_balance = 0;
                    $total_totalAdvanceInstallmentAmount = 0;
                @endphp

                @foreach($loanInfo as $key => $loanItem)
                <tr>
                    @if( $key == 0 )
                        <td class="text-left" rowspan="{{ count($loanInfo) }}">{{ $loanItem['mraProductGroup'] }}</td>
                    @endif
                    
                    @if($loanItem['loan_purpose_code_level_1_group'])
                        <td class="text-left" rowspan="{{ $loanItem['rowspan_level_1'] }}">{{ $loanItem['loan_purpose_level_1'] }}</td>
                    @endif
                    @if($loanItem['loan_purpose_code_level_3_group'])
                        <td class="text-left" rowspan="{{ $loanItem['rowspan_level_3'] }}">{{ $loanItem['loan_purpose_level_3'] }}</td>
                    @endif

                    <td class="text-right">{{ number_format($loanItem['currentQuarterDisbursementAmount'], 2) }}</td>
                    <td class="text-right">{{ number_format($loanItem['currentQuarterRepayAmount_Principal'], 2) }}</td>
                    <td class="text-right">{{ number_format($loanItem['currentQuarterRepayAmount_Interest'], 2) }}</td>
                    <td class="text-right">{{ number_format($loanItem['currentQuarterCollectionAmount_Principal'], 2) }}</td>
                    <td class="text-right">{{ number_format($loanItem['currentQuarterCollectionAmount_Interest'], 2) }}</td>

                    <td class="text-right">{{ number_format($loanItem['disbursementAmount_upto'], 2) }}</td>
                    <td class="text-right">{{ number_format($loanItem['collectionAmount_Principal_upto'], 2) }}</td>
                    <td class="text-right">{{ number_format($loanItem['collectionAmount_Interest_upto'], 2) }}</td>

                    <td class="text-center">{{ $loanItem['numberOfLoanAccounts'] }}</td>
                    <td class="text-right">{{ number_format($loanItem['balance'], 2) }}</td>

                    <td class="text-left">{{ $loanItem['tenureOfLoan'] }}</td>
                    <td class="text-left">{{ $loanItem['totalNoOfInstallments'] }}</td>
                    <td class="text-right">{{ number_format($loanItem['totalAdvanceInstallmentAmount'], 2) }}</td>

                    @php
                        if( $loanItem['currentQuarterRepayAmount_Principal'] == 0 ) $recoveryRate = 0;
                        else $recoveryRate = ( $loanItem['currentQuarterCollectionAmount_Principal'] / $loanItem['currentQuarterRepayAmount_Principal'] ) * 100;
                    @endphp
                    <td class="text-right">{{ number_format($recoveryRate, 2) }}%</td>

                    <td class="text-right">{{ $loanItem['declaredRateOfServiceCharge'] }}</td>
                </tr>

                    @php
                        $total_currentQuarterDisbursementAmount += floatVal($loanItem['currentQuarterDisbursementAmount']);
                        $total_currentQuarterRepayAmount_Principal += floatVal($loanItem['currentQuarterRepayAmount_Principal']);
                        $total_currentQuarterRepayAmount_Interest += floatVal($loanItem['currentQuarterRepayAmount_Interest']);
                        $total_currentQuarterCollectionAmount_Principal += floatVal($loanItem['currentQuarterCollectionAmount_Principal']);
                        $total_currentQuarterCollectionAmount_Interest += floatVal($loanItem['currentQuarterCollectionAmount_Interest']);
                        $total_disbursementAmount_upto += floatVal($loanItem['disbursementAmount_upto']);
                        $total_collectionAmount_Principal_upto += floatVal($loanItem['collectionAmount_Principal_upto']);
                        $total_collectionAmount_Interest_upto += floatVal($loanItem['collectionAmount_Interest_upto']);

                        $total_numberOfLoanAccounts += intVal($loanItem['numberOfLoanAccounts']);
                        $total_balance += floatVal($loanItem['balance']);
                        $total_totalAdvanceInstallmentAmount += floatVal($loanItem['totalAdvanceInstallmentAmount']);
                    @endphp
                @endforeach

                <tr class="subTotalTr">

                    @php
                        if( $total_currentQuarterRepayAmount_Principal == 0 ) $recoveryRate = 0;
                        else $recoveryRate = ( $total_currentQuarterCollectionAmount_Principal / $total_currentQuarterRepayAmount_Principal ) * 100;
                    @endphp

                    <td colspan="3"><strong>Grand total</strong></td>

                    <td class="text-right fontBold">{{ number_format( $total_currentQuarterDisbursementAmount, 2 ) }}</td>
                    <td class="text-right fontBold">{{ number_format( $total_currentQuarterRepayAmount_Principal, 2 ) }}</td>
                    <td class="text-right fontBold">{{ number_format( $total_currentQuarterRepayAmount_Interest, 2 ) }}</td>
                    <td class="text-right fontBold">{{ number_format( $total_currentQuarterCollectionAmount_Principal, 2 ) }}</td>
                    <td class="text-right fontBold">{{ number_format( $total_currentQuarterCollectionAmount_Interest, 2 ) }}</td>

                    <td class="text-right fontBold">{{ number_format( $total_disbursementAmount_upto, 2 ) }}</td>
                    <td class="text-right fontBold">{{ number_format( $total_collectionAmount_Principal_upto, 2 ) }}</td>
                    <td class="text-right fontBold">{{ number_format( $total_collectionAmount_Interest_upto, 2 ) }}</td>

                    <td class="text-center fontBold">{{ $total_numberOfLoanAccounts }}</td>
                    <td class="text-right  fontBold">{{ number_format( $total_balance, 2 ) }}</td>

                    <td class=""></td>
                    <td class=""></td>
                    <td class="text-right fontBold">{{ number_format( $total_totalAdvanceInstallmentAmount, 2 ) }}</td>
                    <td class="text-right fontBold">{{ number_format( $recoveryRate, 2 ) }}%</td>
                    <td class=""></td>
                </tr>

            </tbody>
        </table>
    </div>
</div>

@endif