{{-- 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}}
Member Wise Pass Book Balancing Register Report
Branch Name & Code : {{$branchInfo->name}}({{$branchInfo->branchCode}})
Area Name : {{$areaInfo}}
Creadit Officer : {{$creditOfficerName}}
Samity Name & Code : {{$samityInfo}}
Quarter
: {{$querter}}
Quarter Date
: @if ($requestedQuerter == '1-3') January-01 to March-31 @elseif ($requestedQuerter == '4-6') April-01 to June-30 @elseif ($requestedQuerter == '7-9') July-01 to September-30 @elseif ($requestedQuerter == '10-12') October-01 to December-31 @endif {{-- {{$RequestedQuerter}} --}}
Print Date
: 2026-07-21
@foreach ($SavingsProduct as $key => $SavingsProduct1) @endforeach @foreach ($SavingsProduct as $key => $SavingsProduct1) @endforeach @php $sl = 0; @endphp @foreach ($members as $member) @php $i = 0; $softSavings = $member['savings']; $pasBookSavings = $member['pasBookSavings']; $diffOfPassbookSavings = $member['diffOfPassbookSavings']; $sl++; @endphp @if (count($member['loans']) > 0) @foreach ($member['loans'] as $key => $loan) @if ($i == 0) @endif @if ($i == 0) @foreach ($softSavings as $item) @endforeach @else @foreach ($softSavings as $item) @endforeach @endif @if ($i == 0) @foreach ($pasBookSavings as $key => $item) @endforeach @else @foreach ($pasBookSavings as $item) @endforeach @endif @php $i++; @endphp @endforeach @else {{-- start --}} @if ($i == 0) @foreach ($softSavings as $item) @endforeach @else @foreach ($softSavings as $item) @endforeach @endif @if ($i == 0) @foreach ($pasBookSavings as $key => $item) @endforeach @else @foreach ($pasBookSavings as $item) @endforeach @endif @php $i++; @endphp {{-- end --}} @endif @endforeach @foreach ($totalCalculatedSum['totalSavings'] as $key => $totalSavingsItem) @endforeach @foreach ($totalCalculatedSum['totalPassBookSavings'] as $key => $totalPassbookSavingsItem) @endforeach
SL. No.
Member ID
Member Name
Spouse Name
Loan Desburesment Information
Repayment Week
Collection Sheet Balance
Pass Book Balance
Loan ID
Desburesment Date
Loan Amount
Loan
Savings
Loan
Savings
Outstanding
Due
{{$SavingsProduct1->name}}
Outstanding
Due
{{$SavingsProduct1->name}}
{{$sl}} {{$member['memberCode']}} {{$member['name']}} {{$member['spouseName']}}{{$loan['loanCode']}} {{ $loan['disbursementDate'] ? \Carbon\Carbon::parse($loan['disbursementDate'])->format('d-m-Y') : '' }} {{$loan['disbursement']}} {{$loan['numberOfInstallment']}} {{$loan['outstanding']}} {{$loan['due']}}{{$item}}0 {{$loan['passBookOutstanding']}} @if(!empty($loan['diffOutstanding']) && $loan['diffOutstanding'] != 0)
({{ $loan['diffOutstanding'] > 0 ? '+' : '' }}{{ $loan['diffOutstanding'] }}) @endif 		{{$loan['passBookDue']}} @if(!empty($loan['diffDue']) && $loan['diffDue'] != 0)
({{ $loan['diffDue'] > 0 ? '+' : '' }}{{ $loan['diffDue'] }}) @endif 		{{$item}} @if(!empty($diffOfPassbookSavings[$key]) && $diffOfPassbookSavings[$key] != 0)
({{ $diffOfPassbookSavings[$key] > 0 ? '+' : '' }}{{ $diffOfPassbookSavings[$key] }}) @endif 		0
{{$sl}} {{$member['memberCode']}} {{$member['name']}} {{$member['spouseName']}} - - - - - -{{$item}}0- - {{$item}} @if(!empty($diffOfPassbookSavings[$key]) && $diffOfPassbookSavings[$key] != 0)
({{ $diffOfPassbookSavings[$key] > 0 ? '+' : '' }}{{ $diffOfPassbookSavings[$key] }}) @endif 		0
Total {{number_format($totalCalculatedSum['totalDisbursement'],2)}} {{number_format($totalCalculatedSum['totalNumberOfInstallment'],2)}} {{number_format($totalCalculatedSum['totalOutstanding'],2)}} {{number_format($totalCalculatedSum['totalDue'],2)}} {{number_format($totalSavingsItem,2)}} {{number_format($totalCalculatedSum['totalPassBookOutstanding'],2)}} {{number_format($totalCalculatedSum['totalPassBookDue'],2)}} {{number_format($totalPassbookSavingsItem,2)}}