{{-- div for Company --}} @php $company = DB::table('gnr_company')->where('id', Auth::user()->company_id_fk)->select('name','address')->first(); @endphp {{$company->name}}
{{$company->address}}
Loan Re-schedule Statement
Name of Branch:
Period: {{$rangeText}}

@php $totalLoanAmount = 0; $totalP = 0; $totalI = 0; $totalPI = 0; $slNo = 0; @endphp @foreach ($zoneArr as $zone) @php $zoneAreaIds = explode(',', str_replace(['"', '[', ']'], '', $zone->areaId)); if($zone->id == 4) { $zoneSpan = 16; }else{ $zoneSpan = count($branchesByZone[$zone->id]); } $zk = 0; $zoneTotalLoanAmount = 0; $zoneTotalP = 0; $zoneTotalI = 0; $zoneTotalPI = 0; @endphp @foreach ($zoneAreaIds as $areaId) @if($areaId != 24) @php $areaInfo = DB::table('gnr_area')->where('id', $areaId)->first(); $areaBranchIds = explode(',', str_replace(['"', '[', ']'], '', $areaInfo->branchId)); if($areaId == 22) { $areaSpan = 2; }elseif ($areaId == 23) { $areaSpan = 1; } elseif ($areaId == 15) { $areaSpan = 4; } else{ $areaSpan = count($areaBranchIds); } $ak = 0; $subTotalLoanAmount = 0; $subTotalP = 0; $subTotalI = 0; $subTotalPI = 0; @endphp @foreach ($areaBranchIds as $branchId) @if(in_array($branchId,$selectedBrId)) @php $zk++; $ak++; $toalPrincInt = $loanBrWiseData[$branchId]['principalAmount'] + $loanBrWiseData[$branchId]['interestAmount'] ; $subTotalLoanAmount += $loanBrWiseData[$branchId]['loanAmount']; $subTotalP += $loanBrWiseData[$branchId]['principalAmount']; $subTotalI += $loanBrWiseData[$branchId]['interestAmount']; $subTotalPI += $toalPrincInt; $zoneTotalLoanAmount += $loanBrWiseData[$branchId]['loanAmount']; $zoneTotalP += $loanBrWiseData[$branchId]['principalAmount']; $zoneTotalI += $loanBrWiseData[$branchId]['interestAmount']; $zoneTotalPI += $toalPrincInt; $totalLoanAmount += $loanBrWiseData[$branchId]['loanAmount']; $totalP += $loanBrWiseData[$branchId]['principalAmount']; $totalI += $loanBrWiseData[$branchId]['interestAmount']; $totalPI += $toalPrincInt; @endphp @if($zk == 1) @endif @if($ak == 1) @endif @endif @endforeach @endif @endforeach @endforeach

SL#	Zone	Area	Branch	Loan Amount	Installment Amount as per Schedule
SL#	Zone	Area	Branch	Loan Amount	P	I	Total=P+I
{{++$slNo}}	{{$zone->name}}	{{$areaInfo->name }}	{{$branchNameIdWise[$branchId]}}	{{number_format($loanBrWiseData[$branchId]['loanAmount'],2)}}	{{number_format($loanBrWiseData[$branchId]['principalAmount'],2)}}	{{number_format($loanBrWiseData[$branchId]['interestAmount'],2)}}	{{number_format($toalPrincInt,2)}}
	Area Sub Total	{{number_format($subTotalLoanAmount,4)}}	{{$subTotalP}}	{{$subTotalI}}	{{$subTotalPI}}
	zone Sub Total		{{number_format($zoneTotalLoanAmount,4)}}	{{$zoneTotalP}}	{{$zoneTotalI}}	{{$zoneTotalPI}}
Grand Total				{{number_format($totalLoanAmount,4)}}	{{$totalP}}	{{$totalI}}	{{$totalPI}}