@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'];
@endphp
@php
    $cc = 0;
    // stotal
    $loanCategoryInfo = [];
    $loanProductInfo = [];
    $sToutstandingAmount = 0;
    $sTdueAmount = 0;
    foreach ($savingProducts as $singleItem) {
        ${'sT' . $singleItem->shortName} = 0;
    }
    $sTsavingsBalance = 0;
    $sTmemberClaim = 0;
    $sTorgClaim = 0;

@endphp
@foreach ($branchMapingDataWithType['data'] as $key => $cdata)


    @if($branchMapingDataWithType['type']== 'area' )
        @foreach($cdata['child'] as $key1 => $childData )
            @if(count($loanArrayData->where('branchIdFk',$childData)) > 0)
                @php
                    $slNo = 0;
                    $currentSamityId = isset($samitys[0]) ? $samitys[0]->id : null;
                    $isSamityChanged = 0;
                    $gToutstandingAmount = 0;
                    $gTdueAmount = 0;
                    $isv = 0;
                    foreach($savingProducts as $singleItem){
                        ${"gT" . $singleItem->shortName} = 0;
                        $subtotal['savingsBalance'][$isv]= 0;
                        $isv++;
                    }

                    $gTsavingsBalance = 0;
                    $gTmemberClaim = 0;
                    $gTorgClaim = 0;

                    // ===========  subtotal ==========
                    $subtotal['loanAmount']= 0;
                    $subtotal['outstandingAmount']= 0;
                    $subtotal['dueAmount']= 0;

                    $subtotal['savingsBalance']['total']= 0;
                    $subtotal['member']= 0;
                    $subtotal['organization']= 0;



                @endphp
                        @php
                            $currentLoans = $loanArrayData->where('branchIdFk',$childData);
                        @endphp
                        @foreach ($currentLoans as $loan)
                            @php
                                $cc++;
                                //subtoal
                                $loan =(object)$loan;
                                $subtotal['loanAmount'] += $loan->loanAmount;
                                $subtotal['outstandingAmount'] += $loan->outstandingAmount;
                                $subtotal['dueAmount'] += $loan->dueAmount;

                                //grandtotal
                                // $grandtotal['loanAmount'] += $subtotal['loanAmount'];
                                // $grandtotal['outstandingAmount'] += $subtotal['outstandingAmount'];
                                // $grandtotal['dueAmount'] += $subtotal['dueAmount'];
                            @endphp
                            <tr>
                                <td class="tsl"></td>
                                <td>{{ $cc }}</td>
                                @if($branchMapingDataWithType['type']== 'area' )
                                    <td >{{ $cdata['name'] }}</td>
                                @endif
                                <td>{{ $zoneareaList[$childData]}}</td>
                                <td class="name">{{$loan->creditOfficerName}}</td>
                                <td>{{$loan->memberCode}}</td>
                                <td class="name">{{$loan->memberName}}</td>
                                <td>{{$loan->productName}}</td>
                                <td>{{$loan->loanCode}}</td>
                                <td class="disburseDate">{{date('d-m-Y',strtotime($loan->loanDisbursedDate))}}</td>
                                <td class="amount">{{number_format($loan->loanAmount)}}</td>
                                <td class="amount">{{number_format($loan->outstandingAmount)}}</td>
                                <td class="amount">{{number_format($loan->dueAmount)}}</td>
                                @php
                                $memberTotalSavings = 0;
                                $sv = 0;
                                @endphp
                                @foreach ($loan->savingsBalances as $svkey => $svRow)
                                <td class="amount">{{$svRow}}</td>
                                @php
                                $subtotal['savingsBalance'][$sv] += $svRow;
                                $memberTotalSavings  += $svRow;
                                $sv++;
                                @endphp
                                @endforeach
                                @php
                                //subtotal
                                $subtotal['savingsBalance']['total'] += $memberTotalSavings;
                                $subtotal['member'] += $loan->memberClaim;
                                $subtotal['organization'] +=$loan->organizationClaim;
                                //grandtotal
                                // $grandtotal['savingsBalance']['total'] += $subtotal['savingsBalance']['total'];
                                // $grandtotal['member'] += $subtotal['member'];
                                // $grandtotal['organization'] += $subtotal['organization'];

                                @endphp
                                <td class="amount">{{ number_format($loan->savingsBalanceTotal) }}</td>
                                <td class="amount">{{ number_format($loan->memberClaim) }}</td>
                                <td class="amount">{{ number_format($loan->organizationClaim) }}</td>
                            </tr>

                            @php
                                $sToutstandingAmount = $sToutstandingAmount + $loan->outstandingAmount;
                                $sTdueAmount = $sTdueAmount + $loan->dueAmount;
                                $sTsavingsBalance = $sTsavingsBalance + $loan->savingsBalanceTotal;
                                $sTmemberClaim = $sTmemberClaim + $loan->memberClaim;
                                $sTorgClaim = $sTorgClaim + $loan->organizationClaim;

                                // store information for loan product
                                $categoryId = $loanProducts->where('id',$loan->primaryProductIdFk)->max('productCategoryId');
                                $data = array(
                                    'loanCategoryId' => $categoryId,
                                    'disbursementAmount' => $loan->loanAmount,
                                    'outstandingAmount' =>$loan->outstandingAmount,
                                    'dueAmount' => $loan->dueAmount,
                                    'savingsBalance' => $loan->savingsBalanceTotal,
                                    'memberClaim' => $loan->memberClaim,
                                    'organizationClaim' =>$loan->organizationClaim,
                                );
                                array_push($loanCategoryInfo,$data);

                                // store information for loan product
                                $pdata = array(
                                    'loanProductId' => $loan->primaryProductIdFk,
                                    'disbursementAmount' => $loan->loanAmount,
                                    'outstandingAmount' =>$loan->outstandingAmount,
                                    'dueAmount' => $loan->dueAmount,
                                    'savingsBalance' => $loan->savingsBalanceTotal,
                                    'memberClaim' => $loan->memberClaim,
                                    'organizationClaim' => $loan->organizationClaim,
                                );
                                array_push($loanProductInfo,$pdata);
                            @endphp
                        @endforeach
                <tr class="subtoalrow">
                    <td colspan="10">Subtotal</td>
                    <td class="loanAmount"> {{ number_format($subtotal['loanAmount']) }}</td>
                    <td class="outstandingAmount"> {{ number_format($subtotal['outstandingAmount']) }}</td>
                    <td class="dueAmount"> {{ number_format($subtotal['dueAmount']) }}</td>
                    @foreach ($savingProducts as $skey => $item)
                    <td class="savingsBalance{{$skey}}"> {{ number_format($subtotal['savingsBalance'][$skey]) }}</td>
                    @endforeach
                    <td class="savingsBalanceTotal"> {{ number_format($subtotal['savingsBalance']['total']) }}</td>
                    <td class="member"> {{ number_format($subtotal['member']) }}</td>
                    <td class="organization"> {{ number_format($subtotal['organization']) }}</td>
                </tr>
            @endif
        @endforeach
    @endif

    @if($branchMapingDataWithType['type']== 'zone' )
        @php
            // ===========  subtotal ==========
            $subtotal['loanAmount']= 0;
            $subtotal['outstandingAmount']= 0;
            $subtotal['dueAmount']= 0;
            $isv = 0;
            foreach($savingProducts as $singleItem){
                $subtotal['savingsBalance'][$isv]= 0;
                $isv++;
            }
            $subtotal['savingsBalance']['total']= 0;
            $subtotal['member']= 0;
            $subtotal['organization']= 0;

        @endphp
        @foreach($cdata['child'] as $key1 => $childData )
            @if(isset($cdata['data']['area'][$childData]))
                @foreach($cdata['data']['area'][$childData]['child'] as $branchkey => $branchChildData )
                    @if( count($loanArrayData->where('branchIdFk',$branchChildData)) > 0)

                        @php

                        $slNo = 0;
                        $currentSamityId = isset($samitys[0]) ? $samitys[0]->id : null;
                        $isSamityChanged = 0;
                        $gToutstandingAmount = 0;
                        $gTdueAmount = 0;
                        foreach($savingProducts as $singleItem){
                            ${"gT" . $singleItem->shortName} = 0;
                        }
                        $gTsavingsBalance = 0;
                        $gTmemberClaim = 0;
                        $gTorgClaim = 0;

                        @endphp
                            @php
                                $currentLoans = $loanArrayData->where('branchIdFk',$branchChildData);
                            @endphp
                            @foreach ($currentLoans as $loan)
                                @php
                                    $cc++;
                                    //subtoal
                                    $loan =(object)$loan;
                                    $subtotal['loanAmount'] += $loan->loanAmount;
                                    $subtotal['outstandingAmount'] += $loan->outstandingAmount;
                                    $subtotal['dueAmount'] += $loan->dueAmount;

                                    //grandtotal
                                    // $grandtotal['loanAmount'] += $subtotal['loanAmount'];
                                    // $grandtotal['outstandingAmount'] += $subtotal['outstandingAmount'];
                                    // $grandtotal['dueAmount'] += $subtotal['dueAmount'];
                                @endphp
                                <tr>
                                    <td class="tsl"></td>
                                    <td>{{ $cc }}</td>
                                    @if($branchMapingDataWithType['type']== 'zone' )
                                    <td >{{$cdata['name']}}</td>
                                    <td >{{ $cdata['data']['area'][$childData]['name'] }}</td>
                                    @endif
                                    <td>{{ $zoneareaList[$branchChildData]}}</td>
                                    <td class="name">{{$loan->creditOfficerName}}</td>
                                    <td>{{$loan->memberCode}}</td>
                                    <td class="name">{{$loan->memberName}}</td>
                                    <td>{{$loan->productName}}</td>
                                    <td>{{$loan->loanCode}}</td>
                                    <td class="disburseDate">{{date('d-m-Y',strtotime($loan->loanDisbursedDate))}}</td>
                                    <td class="amount">{{number_format($loan->loanAmount)}}</td>
                                    <td class="amount">{{number_format($loan->outstandingAmount)}}</td>
                                    <td class="amount">{{number_format($loan->dueAmount)}}</td>
                                    @php
                                    $memberTotalSavings = 0;
                                    $sv = 0;
                                    @endphp
                                    @foreach ($loan->savingsBalances as $svkey => $svRow)
                                    <td class="amount">{{$svRow}}</td>
                                    @php
                                    $subtotal['savingsBalance'][$sv] += $svRow;
                                    $memberTotalSavings  += $svRow;
                                    $sv++;
                                    @endphp
                                    @endforeach
                                    @php
                                    //subtotal
                                    $subtotal['savingsBalance']['total'] += $memberTotalSavings;
                                    $subtotal['member'] += $loan->memberClaim;
                                    $subtotal['organization'] +=$loan->organizationClaim;
                                    //grandtotal
                                    // $grandtotal['savingsBalance']['total'] += $subtotal['savingsBalance']['total'];
                                    // $grandtotal['member'] += $subtotal['member'];
                                    // $grandtotal['organization'] += $subtotal['organization'];

                                    @endphp
                                    <td class="amount">{{ number_format($loan->savingsBalanceTotal) }}</td>
                                    <td class="amount">{{ number_format($loan->memberClaim) }}</td>
                                    <td class="amount">{{ number_format($loan->organizationClaim) }}</td>
                                </tr>

                                @php
                                    $sToutstandingAmount = $sToutstandingAmount + $loan->outstandingAmount;
                                    $sTdueAmount = $sTdueAmount + $loan->dueAmount;
                                    $sTsavingsBalance = $sTsavingsBalance + $loan->savingsBalanceTotal;
                                    $sTmemberClaim = $sTmemberClaim + $loan->memberClaim;
                                    $sTorgClaim = $sTorgClaim + $loan->organizationClaim;

                                    // store information for loan product
                                    $categoryId = $loanProducts->where('id',$loan->primaryProductIdFk)->max('productCategoryId');
                                    $data = array(
                                        'loanCategoryId' => $categoryId,
                                        'disbursementAmount' => $loan->loanAmount,
                                        'outstandingAmount' =>$loan->outstandingAmount,
                                        'dueAmount' => $loan->dueAmount,
                                        'savingsBalance' => $loan->savingsBalanceTotal,
                                        'memberClaim' => $loan->memberClaim,
                                        'organizationClaim' =>$loan->organizationClaim,
                                    );
                                    array_push($loanCategoryInfo,$data);

                                    // store information for loan product
                                    $pdata = array(
                                        'loanProductId' => $loan->primaryProductIdFk,
                                        'disbursementAmount' => $loan->loanAmount,
                                        'outstandingAmount' =>$loan->outstandingAmount,
                                        'dueAmount' => $loan->dueAmount,
                                        'savingsBalance' => $loan->savingsBalanceTotal,
                                        'memberClaim' => $loan->memberClaim,
                                        'organizationClaim' => $loan->organizationClaim,
                                    );
                                    array_push($loanProductInfo,$pdata);
                                @endphp
                            @endforeach

                            <tr class="subtoalrow">
                                <td colspan="11">Subtotal</td>
                                <td class="loanAmount"> {{ number_format($subtotal['loanAmount']) }}</td>
                                <td class="outstandingAmount"> {{ number_format($subtotal['outstandingAmount']) }}</td>
                                <td class="dueAmount"> {{ number_format($subtotal['dueAmount']) }}</td>
                                @foreach ($savingProducts as $skey => $item)
                                <td class="savingsBalance{{$skey}}"> {{ number_format($subtotal['savingsBalance'][$skey]) }}</td>
                                @endforeach
                                <td class="savingsBalanceTotal"> {{ number_format($subtotal['savingsBalance']['total']) }}</td>
                                <td class="member"> {{ number_format($subtotal['member']) }}</td>
                                <td class="organization"> {{ number_format($subtotal['organization']) }}</td>
                            </tr>

                    @endif
                @endforeach
            @endif
        @endforeach
    @endif

@endforeach