{{-- 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 $slNo = 0; $totalLoanAmount = 0; $totalP = 0; $totalI = 0; $totalPI = 0; @endphp @foreach ($areaArr as $area) @php $areaBranchIds = explode(',', str_replace(['"', '[', ']'], '', $area->branchId)); if($area->id == 22) { $areaSpan = 2; }elseif ($area->id == 23) { $areaSpan = 1; }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 $ak++; $toalPrincInt = $loanBrWiseData[$branchId]['principalAmount'] + $loanBrWiseData[$branchId]['interestAmount'] ; $subTotalLoanAmount += $loanBrWiseData[$branchId]['loanAmount']; $subTotalP += $loanBrWiseData[$branchId]['principalAmount']; $subTotalI += $loanBrWiseData[$branchId]['interestAmount']; $subTotalPI += $toalPrincInt; $totalLoanAmount += $loanBrWiseData[$branchId]['loanAmount']; $totalP += $loanBrWiseData[$branchId]['principalAmount']; $totalI += $loanBrWiseData[$branchId]['interestAmount']; $totalPI += $toalPrincInt; @endphp @if($ak == 1) @endif @endif @endforeach @endforeach

SL#	Area	Branch	Loan Amount	Installment Amount as per Schedule
SL#	Area	Branch	Loan Amount	P	I	Total=P+I
{{++$slNo}}	{{$area->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)}}
Sub Total			{{number_format($subTotalLoanAmount,4)}}	{{$subTotalP}}	{{$subTotalI}}	{{$subTotalPI}}
Grand Total			{{number_format($totalLoanAmount,4)}}	{{$totalP}}	{{$totalI}}	{{$totalPI}}