@php use Carbon\Carbon; @endphp
{{-- 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: {{$branchText}}
Period: {{$rangeText}}

@php $Count = 0; @endphp @if(sizeof($arrangedData)>0) @php $totalLoanAmount = 0; $totalP = 0; $totalI = 0; $totalPI = 0; @endphp @foreach ($arrangedData as $branchId => $branchData) @php $subTotalLoanAmount = 0; $subTotalP = 0; $subTotalI = 0; $subTotalPI = 0; @endphp @foreach ($branchData as $data) @php $Count++@endphp @php $totalLoanAmount = $totalLoanAmount + $data['loanAmount']; $subTotalLoanAmount = $subTotalLoanAmount + $data['loanAmount']; @endphp @endforeach @endforeach @else @endif
SL. No.
Member Name
Member Code
Loan Code
Samity Name & Code
Disbursement Date
Installment Date as per Schedule
Re-scheduled Date of Installment
Loan Amount
Installment Amount as per Schedule
P
I
Total=P+I
{{$Count}} {{$data['name']}} {{$data['code']}} {{$data['loanCode']}} {{$data['samityName'].' '.$data['samityCode']}} {{Carbon::parse($data['disbursementDate'])->format('d-m-Y')}} @foreach ($data['shiftedSchedules'] as $item) @endforeach
{{Carbon::parse($item['prevScheduleDate'])->format('d-m-Y')}}
@foreach ($data['shiftedSchedules'] as $item) @endforeach
{{Carbon::parse($item['newScheduleDate'])->format('d-m-Y')}}
{{number_format($data['loanAmount'],2)}} @foreach ($data['shiftedSchedules'] as $item) @php $totalP = $totalP + $item['principalAmount']; $subTotalP = $subTotalP + $item['principalAmount']; @endphp @endforeach
{{number_format($item['principalAmount'],2)}}
@foreach ($data['shiftedSchedules'] as $item) @php $totalI = $totalI + $item['interestAmount']; $subTotalI = $subTotalI + $item['interestAmount']; @endphp @endforeach
{{number_format($item['interestAmount'],2)}}
@foreach ($data['shiftedSchedules'] as $item) @php $totalPI = $totalPI + $item['principalAmount']+$item['interestAmount']; $subTotalPI = $subTotalPI + $item['principalAmount']+$item['interestAmount']; @endphp @endforeach
{{number_format($item['principalAmount']+$item['interestAmount'], 2)}}
SubTotal- {{$branchNameIdWise[$branchId]}} {{number_format($subTotalLoanAmount,2)}} {{number_format($subTotalP,2)}} {{number_format($subTotalI,2)}} {{number_format($subTotalPI,2)}}
Total: {{number_format($totalLoanAmount,2)}} {{number_format($totalP,2)}} {{number_format($totalI,2)}} {{number_format($totalPI,2)}}
NO DATA FOUND!
{{-- REPORT FOOTER --}}