{{-- 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)); $zk = 0; $zoneTotalLoanAmount = 0; $zoneTotalP = 0; $zoneTotalI = 0; $zoneTotalPI = 0; $zoneWiseSpan = 0; $zoneAreaBrrSpan = 0; @endphp @foreach ($zoneAreaIds as $areaId) @if(in_array($areaId,$seletedAreaId)) @php $zoneWiseSpan++; @endphp @php $areaInfo = DB::table('gnr_area')->where('id', $areaId)->first(); $areaBranchIds = explode(',', str_replace(['"', '[', ']'], '', $areaInfo->branchId)); @endphp @foreach ($areaBranchIds as $branchId) @if(in_array($branchId,$selectedBrId)) @php $zoneAreaBrrSpan++; @endphp @endif @endforeach @endif @endforeach @foreach ($zoneAreaIds as $areaId) @if(in_array($areaId,$seletedAreaId)) @php $areaInfo = DB::table('gnr_area')->where('id', $areaId)->first(); $areaBranchIds = explode(',', str_replace(['"', '[', ']'], '', $areaInfo->branchId)); $ak = 0; $subTotalLoanAmount = 0; $subTotalP = 0; $subTotalI = 0; $subTotalPI = 0; $areaBrwiseSpan = 0 ; $subTotCount = 0 ; @endphp @foreach ($areaBranchIds as $branchId) @if(in_array($branchId,$selectedBrId)) @php $areaBrwiseSpan++; @endphp @endif @endforeach @foreach ($areaBranchIds as $branchId) @if(in_array($branchId,$selectedBrId)) @php $zk++; $ak++; $subTotCount++; $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 @if($subTotCount>0) @endif @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}}	{{$zoneWiseSpan}}{{$zone->name}}**{{$zoneAreaBrrSpan}}	{{$areaBrwiseSpan}}{{$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}}