@php
$savingBalanceColspan = sizeof($data['savingProducts']);
$savingProducts = $data['savingProducts'];
$loans = $data['loans'];
$loanArrayData = $data['loanArrayData'];
$samitys = $data['samitys'];
$member = $data['member'];
$loanProducts = $data['loanProducts'];
$loanCategories = $data['loanCategories'];
$loanInfo = $data['loanInfo'];
$savingsDeposits = $data['savingsDeposits'];
$savingsWithdraws = $data['savingsWithdraws'];
$primmaryProductIds = $data['primmaryProductIds'];
$openingSavingsInfo = $data['openingSavingsInfo'];
$savingProducts = $data['savingProducts'];
$loanProductCategoryType = $data['loanProductCategoryType'];
$loanCategoryInfo = $data['loanCategoryInfo'];
$loanProductInfo = $data['loanProductInfo'];
@endphp
    {{-- second table --}}
    <div class="row">
        <div class="col-lg-12">
            <div class="table-responsive">
                @if($loanProductCategoryType == 1)
                Product Wise
                @else
                Category Wise
                @endif
                <table id="dueRegister2" width="100%" class="table table-striped table-bordered dueRegister" border="1pt solid ash" style="color:black; border-collapse: collapse;">
                    <thead>
                        <tr>
                            <th rowspan="2">SL#</th>
                            <th rowspan="2">
                                @if($loanProductCategoryType == 1)
                                Product Name
                                @else
                                Category Name
                                @endif
                            </th>
                            <th rowspan="2">Disburse Amount</th>
                            <th rowspan="2">Present Loan Amount</th>
                            <th rowspan="2">Due Amount</th>
                            <th rowspan="2">Saving Balance</th>
                            <th colspan="2">Net Claim</th>
                        </tr>
                        <tr>
                            <th>Member</th>
                            <th>Organization</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php
                            $tDisbursedAmount = 0;
                            $tOutstandingAmount = 0;
                            $tDueAmount = 0;
                            $tSavingsBalance = 0;
                            $tMemberClaim = 0;
                            $tOrganizationClaim = 0;
                            if($loanProductCategoryType == 1){
                                $commonloanProductCategoryInfo = collect($loanProductInfo);
                                $targetLoop = $loanProducts;
                            }else{
                                $commonloanProductCategoryInfo = collect($loanCategoryInfo);
                                $targetLoop = $loanCategories;
                            }

                        @endphp
                        @foreach ($targetLoop as $key => $loanProductCategory)
                            @php
                            if($loanProductCategoryType == 1){
                                $disbursedAmount = $commonloanProductCategoryInfo->where('loanProductId',$loanProductCategory->id)->sum('disbursementAmount');
                                $outstandingAmount = $commonloanProductCategoryInfo->where('loanProductId',$loanProductCategory->id)->sum('outstandingAmount');
                                $dueAmount = $commonloanProductCategoryInfo->where('loanProductId',$loanProductCategory->id)->sum('dueAmount');
                                $savingsBalance = $commonloanProductCategoryInfo->where('loanProductId',$loanProductCategory->id)->sum('savingsBalance');
                                $memberClaim = $commonloanProductCategoryInfo->where('loanProductId',$loanProductCategory->id)->sum('memberClaim');
                                $organizationClaim = $commonloanProductCategoryInfo->where('loanProductId',$loanProductCategory->id)->sum('organizationClaim');
                            }else{
                                $disbursedAmount = $commonloanProductCategoryInfo->where('loanCategoryId',$loanProductCategory->id)->sum('disbursementAmount');
                                $outstandingAmount = $commonloanProductCategoryInfo->where('loanCategoryId',$loanProductCategory->id)->sum('outstandingAmount');
                                $dueAmount = $commonloanProductCategoryInfo->where('loanCategoryId',$loanProductCategory->id)->sum('dueAmount');
                                $savingsBalance = $commonloanProductCategoryInfo->where('loanCategoryId',$loanProductCategory->id)->sum('savingsBalance');
                                $memberClaim = $commonloanProductCategoryInfo->where('loanCategoryId',$loanProductCategory->id)->sum('memberClaim');
                                $organizationClaim = $commonloanProductCategoryInfo->where('loanCategoryId',$loanProductCategory->id)->sum('organizationClaim');
                            }

                            @endphp
                            <tr>
                                <td>{{$key+1}}</td>
                                <td>{{ $loanProductCategory->shortName }}</td>
                                <td class="amount">{{ number_format($disbursedAmount) }}</td>
                                <td class="amount">{{ number_format($outstandingAmount) }}</td>
                                <td class="amount">{{ number_format($dueAmount) }}</td>
                                <td class="amount">{{ number_format($savingsBalance) }}</td>
                                <td class="amount">{{ number_format($memberClaim) }}</td>
                                <td class="amount">{{ number_format($organizationClaim) }}</td>
                            </tr>
                            @php
                                $tDisbursedAmount = $tDisbursedAmount + $disbursedAmount;
                                $tOutstandingAmount = $tOutstandingAmount + $outstandingAmount;
                                $tDueAmount = $tDueAmount + $dueAmount;
                                $tSavingsBalance = $tSavingsBalance + $savingsBalance;
                                $tMemberClaim = $tMemberClaim + $memberClaim;
                                $tOrganizationClaim = $tOrganizationClaim + $organizationClaim;
                            @endphp
                        @endforeach
                            <tr class="subTotalTr">
                                <td colspan="2">Total</td>
                                <td class="amount ">{{ number_format($tDisbursedAmount) }}</td>
                                <td class="amount ">{{ number_format($tOutstandingAmount) }}</td>
                                <td class="amount ">{{ number_format($tDueAmount) }}</td>
                                <td class="amount ">{{ number_format($tSavingsBalance) }}</td>
                                <td class="amount ">{{ number_format($tMemberClaim) }}</td>
                                <td class="amount">{{ number_format($tOrganizationClaim) }}</td>
                            </tr>
                    </tbody>
                </table>
            </div>      {{-- responseDIV --}}
        </div>
    </div>
    {{-- end second table --}}