@php
    $loans = $data['loans'];
    $filBranch = $data['filBranch'];
    $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'];
    $dateFrom = $data['dateFrom'];
    $dateTo = $data['dateTo'];
@endphp
@php
    $slNo = 0;
    $currentSamityId = isset($samitys[0]) ? $samitys[0]->id : null;
    $isSamityChanged = 0;

    $gTopeningAdvance = 0;
    $gTadjustment = 0;
    $gTnetRecoverable = 0;

    $gTcurrentMonthRecoverable = 0;
    $gTregular = 0;
    $gTdue = 0;
    $gTadvance = 0;
    $gTcurrentMonthDue = 0;

    $loanCategoryInfo = [];
@endphp

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

    @if($branchMapingDataWithType['type']== 'area' )
        @foreach($cdata['child'] as $key1 => $childData )
            @if(count($loans->where('branchIdFk',$childData)) > 0)
            @php
                $slNo = 0;
                $currentSamityId = isset($samitys[0]) ? $samitys[0]->id : null;
                $isSamityChanged = 0;

                $gTopeningAdvance = 0;
                $gTadjustment = 0;
                $gTnetRecoverable = 0;

                $gTcurrentMonthRecoverable = 0;
                $gTregular = 0;
                $gTdue = 0;
                $gTadvance = 0;
                $gTcurrentMonthDue = 0;

                $loanCategoryInfo = [];
            @endphp

                @foreach ($samitys as $samity)
                    @php
                        $currentLoans = $loans->where('samityIdFk',$samity->id)->where('branchIdFk',$childData);

                        $sTopeningAdvance = 0;
                        $sTadjustment = 0;
                        $sTnetRecoverable = 0;

                        $sTcurrentMonthRecoverable = 0;
                        $sTregular = 0;
                        $sTdue = 0;
                        $sTadvance = 0;
                        $sTcurrentMonthDue = 0;
                    @endphp
                    @foreach ($currentLoans as $loan)
                        @php
                            if ($loan->samityIdFk!=$currentSamityId) {
                                $currentSamityId = $loan->samityIdFk;
                                $isSamityChanged = 1;
                            }else{
                                $isSamityChanged = 0;
                            }
                            $samityRowSpan = $loans->where('samityIdFk',$loan->samityIdFk)->where('branchIdFk',$childData)->count();

                            $currentMonthRecoverable = (float) $loanInfo->where('loanId',$loan->id)->max('currentMonthRecoverable');
                            $regular = (float) $loanInfo->where('loanId',$loan->id)->max('regular');
                            $due = (float) $loanInfo->where('loanId',$loan->id)->max('due');
                            $advance = (float) $loanInfo->where('loanId',$loan->id)->max('advance');
                            $openingAdvance = (float) $loanInfo->where('loanId',$loan->id)->max('openingAdvance');
                            $adjustment = (float) $loanInfo->where('loanId',$loan->id)->max('adjustment');
                            $netRecoverable = (float) $loanInfo->where('loanId',$loan->id)->max('netRecoverable');
                            $currentMonthDue = (float) $loanInfo->where('loanId',$loan->id)->max('currentMonthDue');
                        @endphp
                        <tr>
                            <td class="tsl"></td>
                            <td style="text-align: center;">{{++$slNo}}</td>
                            @if($branchMapingDataWithType['type']== 'area' )
                                <td >{{ $cdata['name'] }}</td>
                            @endif
                            <td>{{ $zoneareaList[$childData]}}</td>
                            <td>{{$member->where('id',$loan->memberIdFk)->first()->code}}</td>
                            <td class="name">{{$member->where('id',$loan->memberIdFk)->first()->name}}</td>
                            <td>{{$loanProducts->where('id',$loan->productIdFk)->first()->shortName}}</td>
                            <td>{{$loan->loanCode}}</td>
                            <td>{{$loan->numberOfInstallment}}</td>
                            <td class="disburseDate">{{date('d-m-Y',strtotime($loan->disbursementDate))}}</td>
                            <td class="amount">{{number_format($loan->loanAmount,2)}}</td>
                            <td class="amount">{{number_format($openingAdvance,2)}}</td>
                            <td class="amount">{{number_format($currentMonthRecoverable,2)}}</td>
                            <td class="amount">{{number_format($adjustment,2)}}</td>
                            <td class="amount">{{number_format($netRecoverable,2)}}</td>
                            <td class="amount">{{number_format($regular,2)}}</td>
                            <td class="amount">{{number_format($due,2)}}</td>
                            <td class="amount">{{number_format($advance,2)}}</td>
                            <td class="amount">{{number_format($regular+$due+$advance,2)}}</td>
                            <td class="amount">{{number_format($currentMonthDue,2)}}</td>
                            @if($currentMonthDue-$due < 0)
                                <td class="amount">{{'('.number_format(-1*($currentMonthDue-$due),2).')'}}</td>
                            @else
                                <td class="amount">{{number_format($currentMonthDue-$due,2)}}</td>
                            @endif
                        </tr>

                        @php
                            $sTopeningAdvance = $sTopeningAdvance + $openingAdvance;
                            $sTadjustment = $sTadjustment + $adjustment;
                            $sTnetRecoverable = $sTnetRecoverable + $netRecoverable;

                            $sTcurrentMonthRecoverable = $sTcurrentMonthRecoverable + $currentMonthRecoverable;
                            $sTregular = $sTregular + $regular;
                            $sTdue = $sTdue + $due;
                            $sTadvance = $sTadvance + $advance;
                            $sTcurrentMonthDue = $sTcurrentMonthDue + $currentMonthDue;
                        @endphp
                    @endforeach
                    @php
                        $gTopeningAdvance = $gTopeningAdvance + $sTopeningAdvance;
                        $gTadjustment = $gTadjustment + $sTadjustment;
                        $gTnetRecoverable = $gTnetRecoverable + $sTnetRecoverable;

                        $gTcurrentMonthRecoverable = $gTcurrentMonthRecoverable + $sTcurrentMonthRecoverable;
                        $gTregular = $gTregular + $sTregular;
                        $gTdue = $gTdue + $sTdue;
                        $gTadvance = $gTadvance + $sTadvance;
                        $gTcurrentMonthDue = $gTcurrentMonthDue + $sTcurrentMonthDue;
                    @endphp
                @endforeach

                <tr class="subtoalrow">
                    <td colspan="10">Subtotal</td>
                    <td class="amount loanAmount">{{ number_format($loans->sum('loanAmount'),2) }}</td>
                    <td class="amount openingAdvance">{{ number_format($gTopeningAdvance,2) }}</td>
                    <td class="amount currentMonthRecoverable">{{ number_format($gTcurrentMonthRecoverable,2) }}</td>
                    <td class="amount adjustment">{{ number_format($gTadjustment,2) }}</td>
                    <td class="amount netRecoverable">{{ number_format($gTnetRecoverable,2) }}</td>
                    <td class="amount regular">{{ number_format($gTregular,2) }}</td>
                    <td class="amount due">{{ number_format($gTdue,2) }}</td>
                    <td class="amount advance">{{ number_format($gTadvance,2) }}</td>
                    <td class="amount totalDue">{{ number_format($gTregular+$gTdue+$gTadvance,2) }}</td>
                    <td class="amount currentMonthDue">{{ number_format($gTcurrentMonthDue,2) }}</td>
                    @if($gTcurrentMonthDue-$gTdue < 0)
                        <td class="amount currentMonthDueCompare">{{'('.number_format(-1*($gTcurrentMonthDue-$gTdue),2).')'}}</td>
                    @else
                        <td class="amount currentMonthDueCompare">{{number_format($gTcurrentMonthDue-$gTdue,2)}}</td>
                    @endif
                </tr>
            @endif
        @endforeach
    @endif

    @if($branchMapingDataWithType['type']== 'zone' )

        @foreach($cdata['child'] as $key1 => $childData )
            @if(isset($cdata['data']['area'][$childData]))
                @foreach($cdata['data']['area'][$childData]['child'] as $branchkey => $branchChildData )
                    @if( count($loans->where('branchIdFk',$branchChildData)) > 0)
                    @php
                        $slNo = 0;
                        $currentSamityId = isset($samitys[0]) ? $samitys[0]->id : null;
                        $isSamityChanged = 0;

                        $gTopeningAdvance = 0;
                        $gTadjustment = 0;
                        $gTnetRecoverable = 0;

                        $gTcurrentMonthRecoverable = 0;
                        $gTregular = 0;
                        $gTdue = 0;
                        $gTadvance = 0;
                        $gTcurrentMonthDue = 0;

                        $loanCategoryInfo = [];
                    @endphp

                            @foreach ($samitys as $samity)
                                @php
                                    $currentLoans = $loans->where('samityIdFk',$samity->id)->where('branchIdFk',$branchChildData);

                                    $sTopeningAdvance = 0;
                                    $sTadjustment = 0;
                                    $sTnetRecoverable = 0;

                                    $sTcurrentMonthRecoverable = 0;
                                    $sTregular = 0;
                                    $sTdue = 0;
                                    $sTadvance = 0;
                                    $sTcurrentMonthDue = 0;
                                @endphp
                                @foreach ($currentLoans as $loan)
                                    @php
                                        if ($loan->samityIdFk!=$currentSamityId) {
                                            $currentSamityId = $loan->samityIdFk;
                                            $isSamityChanged = 1;
                                        }else{
                                            $isSamityChanged = 0;
                                        }
                                        $samityRowSpan = $loans->where('samityIdFk',$loan->samityIdFk)->where('branchIdFk',$branchChildData)->count();

                                        $currentMonthRecoverable = (float) $loanInfo->where('loanId',$loan->id)->max('currentMonthRecoverable');
                                        $regular = (float) $loanInfo->where('loanId',$loan->id)->max('regular');
                                        $due = (float) $loanInfo->where('loanId',$loan->id)->max('due');
                                        $advance = (float) $loanInfo->where('loanId',$loan->id)->max('advance');
                                        $openingAdvance = (float) $loanInfo->where('loanId',$loan->id)->max('openingAdvance');
                                        $adjustment = (float) $loanInfo->where('loanId',$loan->id)->max('adjustment');
                                        $netRecoverable = (float) $loanInfo->where('loanId',$loan->id)->max('netRecoverable');
                                        $currentMonthDue = (float) $loanInfo->where('loanId',$loan->id)->max('currentMonthDue');
                                    @endphp
                                    <tr>
                                        <td class="tsl"></td>
                                        <td style="text-align: center;">{{++$slNo}}</td>
                                        @if($branchMapingDataWithType['type']== 'zone' )
                                            <td >{{$cdata['name']}}</td>
                                            <td >{{ $cdata['data']['area'][$childData]['name'] }}</td>
                                        @endif
                                        <td>{{ $zoneareaList[$branchChildData]}}</td>
                                        <td>{{$member->where('id',$loan->memberIdFk)->first()->code}}</td>
                                        <td class="name">{{$member->where('id',$loan->memberIdFk)->first()->name}}</td>
                                        <td>{{$loanProducts->where('id',$loan->productIdFk)->first()->shortName}}</td>
                                        <td>{{$loan->loanCode}}</td>
                                        <td>{{$loan->numberOfInstallment}}</td>
                                        <td class="disburseDate">{{date('d-m-Y',strtotime($loan->disbursementDate))}}</td>
                                        <td class="amount">{{number_format($loan->loanAmount,2)}}</td>
                                        <td class="amount">{{number_format($openingAdvance,2)}}</td>
                                        <td class="amount">{{number_format($currentMonthRecoverable,2)}}</td>
                                        <td class="amount">{{number_format($adjustment,2)}}</td>
                                        <td class="amount">{{number_format($netRecoverable,2)}}</td>
                                        <td class="amount">{{number_format($regular,2)}}</td>
                                        <td class="amount">{{number_format($due,2)}}</td>
                                        <td class="amount">{{number_format($advance,2)}}</td>
                                        <td class="amount">{{number_format($regular+$due+$advance,2)}}</td>
                                        <td class="amount">{{number_format($currentMonthDue,2)}}</td>
                                        @if($currentMonthDue-$due < 0)
                                            <td class="amount">{{'('.number_format(-1*($currentMonthDue-$due),2).')'}}</td>
                                        @else
                                            <td class="amount">{{number_format($currentMonthDue-$due,2)}}</td>
                                        @endif
                                    </tr>

                                    @php
                                        $sTopeningAdvance = $sTopeningAdvance + $openingAdvance;
                                        $sTadjustment = $sTadjustment + $adjustment;
                                        $sTnetRecoverable = $sTnetRecoverable + $netRecoverable;

                                        $sTcurrentMonthRecoverable = $sTcurrentMonthRecoverable + $currentMonthRecoverable;
                                        $sTregular = $sTregular + $regular;
                                        $sTdue = $sTdue + $due;
                                        $sTadvance = $sTadvance + $advance;
                                        $sTcurrentMonthDue = $sTcurrentMonthDue + $currentMonthDue;
                                    @endphp
                                @endforeach
                                @php
                                    $gTopeningAdvance = $gTopeningAdvance + $sTopeningAdvance;
                                    $gTadjustment = $gTadjustment + $sTadjustment;
                                    $gTnetRecoverable = $gTnetRecoverable + $sTnetRecoverable;

                                    $gTcurrentMonthRecoverable = $gTcurrentMonthRecoverable + $sTcurrentMonthRecoverable;
                                    $gTregular = $gTregular + $sTregular;
                                    $gTdue = $gTdue + $sTdue;
                                    $gTadvance = $gTadvance + $sTadvance;
                                    $gTcurrentMonthDue = $gTcurrentMonthDue + $sTcurrentMonthDue;
                                @endphp
                            @endforeach

                            <tr class="subtoalrow">
                                <td colspan="11">Subtotal</td>
                                <td class="amount loanAmount">{{ number_format($loans->sum('loanAmount'),2) }}</td>
                                <td class="amount openingAdvance">{{ number_format($gTopeningAdvance,2) }}</td>
                                <td class="amount currentMonthRecoverable">{{ number_format($gTcurrentMonthRecoverable,2) }}</td>
                                <td class="amount adjustment">{{ number_format($gTadjustment,2) }}</td>
                                <td class="amount netRecoverable">{{ number_format($gTnetRecoverable,2) }}</td>
                                <td class="amount regular">{{ number_format($gTregular,2) }}</td>
                                <td class="amount due">{{ number_format($gTdue,2) }}</td>
                                <td class="amount advance">{{ number_format($gTadvance,2) }}</td>
                                <td class="amount totalDue">{{ number_format($gTregular+$gTdue+$gTadvance,2) }}</td>
                                <td class="amount currentMonthDue">{{ number_format($gTcurrentMonthDue,2) }}</td>
                                @if($gTcurrentMonthDue-$gTdue < 0)
                                    <td class="amount currentMonthDueCompare">{{'('.number_format(-1*($gTcurrentMonthDue-$gTdue),2).')'}}</td>
                                @else
                                    <td class="amount currentMonthDueCompare">{{number_format($gTcurrentMonthDue-$gTdue,2)}}</td>
                                @endif
                            </tr>

                    @endif
                @endforeach
            @endif
        @endforeach
    @endif

@endforeach