{{-- 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 $k => $area) @php // dd($k) ; $areaBranchIds = explode(',', str_replace(['"', '[', ']'], '', $area->branchId)); // dd($areaBranchIds); // if($area->id == 22) { // $areaSpan = 2; // }elseif ($area->id == 23) { // $areaSpan = 1; // }else{ // $areaSpan = count($areaBranchIds); // } // if (in_array($areaBranchIds , $branchArrId)) { // $seletedAreaName[$area->id] = $area->id; // // array_push($seletedAreaName,$area->name) ; // } $areaSpan = count($areaBranchIds); // = 3; $ak = 0; $subTotalLoanAmount = 0; $subTotalP = 0; $subTotalI = 0; $subTotalPI = 0; $subTotCount = 0 ; $areaBrwiseSpan = 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 $ak++; $subTotCount++; $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 @if($subTotCount>0) @endif @endforeach @if($totalLoanAmount>0) @endif

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)}}	{{number_format($subTotalP,4)}}	{{number_format($subTotalI,4)}}	{{number_format($subTotalPI,4)}}
Grand Total			{{number_format($totalLoanAmount,4)}}	{{number_format($totalP,4)}}	{{number_format($totalI,4)}}	{{number_format($totalPI,4)}}