@php
$filBranch = $data['filBranch'];
$dateTo = $data['dateTo'];
$filReportLevel = $data['filReportLevel'];
$filArea = $data['filArea'];
$filZone = $data['filZone'];
$filRegion = $data['filRegion'];
$members = $data['members'];
$loanData = $data['loanData'];
$savingsData = $data['savingsData'];
$savingsProducts = $data['savingsProducts'];
$repaymentFrequencies = $data['repaymentFrequencies'];
@endphp


@foreach ($branchMapingDataWithType['data'] as $key => $cdata)
    @if($branchMapingDataWithType['type']== 'area' )
        @foreach($cdata['child'] as $key1 => $childData )
            @if(count($members->where('branchId',$childData)) > 0)
                @php
                $slNo = 0;
                $gtLoanAmount = 0;
                $gtOutstanding = 0;
                $gtOverdue = 0;

                foreach($savingsProducts as $sp){
                    ${"gt".$sp->shortName} = 0;
                }
                $gTotalSavings = 0;
                @endphp
                @php
                    $memberLoans = $members->where('branchId',$childData);
                @endphp
                @foreach($members as $m)
                    @php
                    $ak = 0;
                    ++$slNo;
                    $memberLoans = $loanData[$m->id]??[];
                    if(sizeof($memberLoans) == 0){
                        $memberLoans = [
                            null => [
                                "repaymentFrequencyIdFk" => -1,
                                "loanTypeId" => null,
                                "disbursementDate" => null,
                                "loanAmount" => 0,
                                "outstanding" => 0,
                                "overdue" => 0
                            ]
                        ];
                    }

                    $hasPPLoan = false;
                    foreach ($memberLoans as $mppl) {
                        if($mppl['loanTypeId']==1){
                            $hasPPLoan = true;
                        }
                    }
                    $savingShown = false;

                    $mSpan = count($memberLoans);
                    // $totalSavings = isset($savingsData[$m->id]) ? array_sum($savingsData[$m->id]) : 0;
                    // $totalSavings =  0;

                    @endphp

                    @foreach($memberLoans as $ml)
                        @php
                        $ak++;
                        $wArea = DB::table('gnr_working_area')->where('status', 1)->where('id', $m->workingAreaId)->first();
                        if($wArea){
                            $village = DB::table('gnr_village')->where('status', 1)->where('id', $wArea->villageId)->first();
                            if($village){
                                $villName = $village->name;
                            }else{
                                $villName = '';
                            }
                        }
                        $totalSavings = 0;
                        @endphp
                        <tr>
                            <td class="tsl"></td>
                            @if($ak == 1) <td rowspan="{{$mSpan}}">{{$slNo}}</td> @endif
                            @if($branchMapingDataWithType['type']== 'area' )
                                <td >{{ $cdata['name'] }}</td>
                            @endif
                            <td>{{ $zoneareaList[$childData]}}</td>
                            @if($ak == 1) <td rowspan="{{$mSpan}}" style="text-align: left;">{{$m->name}}</td> @endif
                            @if($ak == 1) <td rowspan="{{$mSpan}}">{{$m->code}}</td> @endif
                            @if($ak == 1) <td rowspan="{{$mSpan}}" style="width: 12%">{{$m->samityName}}</td> @endif
                            @if($ak == 1) <td rowspan="{{$mSpan}}">{{$m->samityCode}}</td> @endif
                            @if($ak == 1) <td rowspan="{{$mSpan}}">{{$villName}}</td> @endif
                            {{-- @if($ak == 1) <td rowspan="{{$mSpan}}"></td> @endif --}}
                            <td>
                                @if($ml['repaymentFrequencyIdFk'] == 0)
                                    {{'OTL'}}
                                @else
                                    {{$repaymentFrequencies[$ml['repaymentFrequencyIdFk']]??''}}
                                @endif
                            </td>
                            <td>{{$ml['disbursementDate']}}</td>
                            <td class="amount">{{number_format($ml['loanAmount'])}}</td>
                            <td>{{isset($ml['paidInstallment']) ? $ml['paidInstallment'] : ""}}</td>
                            <td>{{isset($ml['lastTrxDate']) ? $ml['lastTrxDate'] : "" }}</td>

                            @if($ml['loanTypeId'] == 1 && $savingShown == false)
                                @foreach($savingsProducts as $savingsProduct)
                                    <td class="amount">
                                        {{number_format($savingsData[$m->id][$savingsProduct->id]??0)}}
                                        @php
                                        ${"gt".$savingsProduct->shortName} += $savingsData[$m->id][$savingsProduct->id]??0;
                                        $totalSavings += isset($savingsData[$m->id][$savingsProduct->id])?$savingsData[$m->id][$savingsProduct->id]:0;
                                        @endphp
                                    </td>
                                @endforeach
                                @php
                                $savingShown = true;
                                @endphp
                            @else
                                @if(!$hasPPLoan && $savingShown == false)
                                    @foreach($savingsProducts as $savingsProduct)
                                    <td class="amount">
                                        {{number_format($savingsData[$m->id][$savingsProduct->id]??0)}}
                                        @php
                                        ${"gt".$savingsProduct->shortName} += $savingsData[$m->id][$savingsProduct->id]??0;
                                        $totalSavings += isset($savingsData[$m->id][$savingsProduct->id])?$savingsData[$m->id][$savingsProduct->id]:0;
                                        @endphp
                                    </td>
                                    @endforeach
                                    @php
                                    $savingShown = true;
                                    @endphp
                                @else
                                    @foreach($savingsProducts as $savingsProduct)
                                    <td class="amount">{{0}}</td>
                                    @endforeach
                                @endif

                            @endif

                            <td class="amount">{{number_format($totalSavings)}}</td>
                            <td class="amount">{{number_format($ml['outstanding'])}}</td>
                            <td class="amount">{{number_format($ml['overdue'])}}</td>
                        </tr>
                        @php
                        $gtLoanAmount += $ml['loanAmount'];
                        $gtOutstanding += $ml['outstanding'];
                        $gtOverdue += $ml['overdue'];
                        $gTotalSavings += $totalSavings;
                        @endphp
                    @endforeach
                @endforeach
                <tr class="subtoalrow">
                    <td colspan="11"><b>Sub Total<b></td>
                    <td class="loanAmount">{{number_format($gtLoanAmount)}}</td>
                    <td class="amount"></td>
                    <td class="amount"></td>
                    @foreach($savingsProducts as $skey => $savingsProduct)
                        <td class="amount savingsBalance{{$skey}}">{{ number_format(${"gt".$savingsProduct->shortName}) }}</td>
                    @endforeach
                    <td class="savingsBalanceTotal">{{number_format($gTotalSavings)}}</td>
                    <td class="outstandingAmount">{{number_format($gtOutstanding)}}</td>
                    <td class="dueAmount">{{number_format($gtOverdue)}}</td>
                </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($members->where('branchId',$branchChildData)) > 0)

                        @php
                        $slNo = 0;
                        $gtLoanAmount = 0;
                        $gtOutstanding = 0;
                        $gtOverdue = 0;

                        foreach($savingsProducts as $sp){
                            ${"gt".$sp->shortName} = 0;
                        }
                        $gTotalSavings = 0;
                        @endphp
                        @php
                        $memberLoans = $members->where('branchId',$branchChildData);
                        @endphp
                        @foreach($members as $m)
                            @php
                            $ak = 0;
                            ++$slNo;
                            $memberLoans = $loanData[$m->id]??[];
                            if(sizeof($memberLoans) == 0){
                                $memberLoans = [
                                    null => [
                                        "repaymentFrequencyIdFk" => -1,
                                        "loanTypeId" => null,
                                        "disbursementDate" => null,
                                        "loanAmount" => 0,
                                        "outstanding" => 0,
                                        "overdue" => 0
                                    ]
                                ];
                            }
                            $hasPPLoan = false;
                            foreach ($memberLoans as $mppl) {
                                if($mppl['loanTypeId']==1){
                                    $hasPPLoan = true;
                                }
                            }
                            $savingShown = false;
                            $mSpan = count($memberLoans);
                            @endphp
                            @foreach($memberLoans as $ml)
                                @php
                                $ak++;
                                $wArea = DB::table('gnr_working_area')->where('status', 1)->where('id', $m->workingAreaId)->first();
                                if($wArea){
                                    $village = DB::table('gnr_village')->where('status', 1)->where('id', $wArea->villageId)->first();
                                    if($village){
                                        $villName = $village->name;
                                    }else{
                                        $villName = '';
                                    }
                                }
                                $totalSavings = 0;
                                @endphp
                                <tr>
                                    <td class="tsl"></td>
                                    @if($ak == 1) <td rowspan="{{$mSpan}}">{{$slNo}}</td> @endif
                                    @if($branchMapingDataWithType['type']== 'zone' )
                                        <td >{{$cdata['name']}}</td>
                                        <td >{{ $cdata['data']['area'][$childData]['name'] }}</td>
                                    @endif
                                    <td>{{ $zoneareaList[$branchChildData]}}</td>
                                    @if($ak == 1) <td rowspan="{{$mSpan}}" style="text-align: left;">{{$m->name}}</td> @endif
                                    @if($ak == 1) <td rowspan="{{$mSpan}}">{{$m->code}}</td> @endif
                                    @if($ak == 1) <td rowspan="{{$mSpan}}" style="width: 12%">{{$m->samityName}}</td> @endif
                                    @if($ak == 1) <td rowspan="{{$mSpan}}">{{$m->samityCode}}</td> @endif
                                    @if($ak == 1) <td rowspan="{{$mSpan}}">{{$villName}}</td> @endif
                                    {{-- @if($ak == 1) <td rowspan="{{$mSpan}}"></td> @endif --}}
                                    <td>
                                        @if($ml['repaymentFrequencyIdFk'] == 0)
                                            {{'OTL'}}
                                        @else
                                            {{$repaymentFrequencies[$ml['repaymentFrequencyIdFk']]??''}}
                                        @endif
                                    </td>
                                    <td>{{$ml['disbursementDate']}}</td>
                                    <td class="amount">{{number_format($ml['loanAmount'])}}</td>
                                    <td>{{isset($ml['paidInstallment']) ? $ml['paidInstallment'] : ""}}</td>
                                    <td>{{isset($ml['lastTrxDate']) ? $ml['lastTrxDate'] : "" }}</td>

                                    @if($ml['loanTypeId'] == 1 && $savingShown == false)
                                        @foreach($savingsProducts as $savingsProduct)
                                            <td class="amount">
                                                {{number_format($savingsData[$m->id][$savingsProduct->id]??0)}}
                                                @php
                                                ${"gt".$savingsProduct->shortName} += $savingsData[$m->id][$savingsProduct->id]??0;
                                                $totalSavings += isset($savingsData[$m->id][$savingsProduct->id])?$savingsData[$m->id][$savingsProduct->id]:0;
                                                @endphp
                                            </td>
                                        @endforeach
                                        @php
                                        $savingShown = true;
                                        @endphp
                                    @else
                                        @if(!$hasPPLoan && $savingShown == false)
                                            @foreach($savingsProducts as $savingsProduct)
                                            <td class="amount">
                                                {{number_format($savingsData[$m->id][$savingsProduct->id]??0)}}
                                                @php
                                                ${"gt".$savingsProduct->shortName} += $savingsData[$m->id][$savingsProduct->id]??0;
                                                $totalSavings += isset($savingsData[$m->id][$savingsProduct->id])?$savingsData[$m->id][$savingsProduct->id]:0;
                                                @endphp
                                            </td>
                                            @endforeach
                                            @php
                                            $savingShown = true;
                                            @endphp
                                        @else
                                            @foreach($savingsProducts as $savingsProduct)
                                            <td class="amount">{{0}}</td>
                                            @endforeach
                                        @endif

                                    @endif

                                    <td class="amount">{{number_format($totalSavings)}}</td>
                                    <td class="amount">{{number_format($ml['outstanding'])}}</td>
                                    <td class="amount">{{number_format($ml['overdue'])}}</td>
                                </tr>
                                @php
                                $gtLoanAmount += $ml['loanAmount'];
                                $gtOutstanding += $ml['outstanding'];
                                $gtOverdue += $ml['overdue'];
                                $gTotalSavings += $totalSavings;
                                @endphp
                            @endforeach
                        @endforeach

                        <tr class="subtoalrow">
                            <td colspan="12"><b>Sub Total<b></td>
                            <td class="loanAmount">{{number_format($gtLoanAmount)}}</td>
                            <td class="amount"></td>
                            <td class="amount"></td>
                            @foreach($savingsProducts as $skey => $savingsProduct)
                                <td class="amount savingsBalance{{$skey}}">{{ number_format(${"gt".$savingsProduct->shortName}) }}</td>
                            @endforeach
                            <td class="savingsBalanceTotal">{{number_format($gTotalSavings)}}</td>
                            <td class="outstandingAmount">{{number_format($gtOutstanding)}}</td>
                            <td class="dueAmount">{{number_format($gtOverdue)}}</td>
                        </tr>

                    @endif
                @endforeach
            @endif
        @endforeach
    @endif

@endforeach