{{-- 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 : {{-- @if ($BranchId == 'All') {{$BranchId}} @elseif ($BranchId != 'All') --}} @foreach ($BranchInfos as $key => $BranchInfo) {{$BranchInfo->name}} ({{$BranchInfo->branchCode}}) @endforeach {{-- @endif --}}
Area Name : {{$AreaInfos}}
Creadit Officer : @foreach ($CreditOfficerInfos as $key => $CreditOfficerInfo) {{$CreditOfficerInfo->emp_name_english}} ({{$CreditOfficerInfo->emp_id}}) @endforeach
Quarter
: {{-- @if ($SelectionType == 'N') {{$DateFrom}} - {{$DateTo}} @elseif ($SelectionType == 'Y') {{$DateTo}} @endif --}} {{$Querter}}
Quarter Date
: @if ($requestedDateRange == '1-3') January-01 to March-31 @elseif ($requestedDateRange == '4-6') April-01 to June-30 @elseif ($requestedDateRange == '7-9') July-01 to September-30 @elseif ($requestedDateRange == '10-12') October-01 to December-31 @endif {{-- {{$requestedDateRange}} --}}
Print Date
: 2026-07-21

{{--
--}} @foreach ($SavingsProduct as $key => $SavingsProduct1) @endforeach @foreach ($SavingsProduct as $key => $SavingsProduct1) @endforeach @php $SerialNumber = 0; $Total1 = 0; $Total2 = 0; $Total3 = 0; $Total4 = 0; $Total5 = 0; $Total6 = 0; $Total7 = 0; $SavingsTotal = array(); foreach ($SavingsProduct as $key => $SavingsProduct1) { $MemberSavingsArray[$SavingsProduct1->id] = 0; } foreach ($SavingsProduct as $key => $SavingsProduct1) { $MemberSavingsArrayPassBook[$SavingsProduct1->id] = 0; } @endphp @foreach ($SamityInfos as $key1 => $SamityInfo) @foreach ($MemberInfos as $key2 => $MemberInfo) @if ($SamityInfo->id == $key2) @php $Total1 = $Total1 + $MemberInfo; @endphp @endif @endforeach @foreach ($BorrowerInfos as $key3 => $BorrowerInfo) @if ($SamityInfo->id == $key3) @php $Total2 = $Total2 + $BorrowerInfo; @endphp @endif @endforeach @foreach ($DisbursementAmountInfos as $key4 => $DisbursementAmountInfo) @if ($SamityInfo->id == $key4) @php $Total3 = $Total3 + $DisbursementAmountInfo; @endphp @endif @endforeach @foreach ($LoanOutstanding as $key5 => $LoanOutstanding1) @if ($SamityInfo->id == $key5) @php $Total4 = $Total4 + $LoanOutstanding1; @endphp @endif @endforeach @foreach ($LoanDue as $key6 => $LoanDue1) @if ($SamityInfo->id == $key6) {{-- {{$LoanDue1}} --}} @php $Total5 = $Total5 + $LoanDue1; @endphp @endif @endforeach @foreach ($SavingsAmount as $key7 => $SavingsAmount1) @if ($SamityInfo->id == $key7) @foreach ($SavingsAmount1 as $key7A => $SavingsAmount2) @foreach ($SavingsProduct as $key7B => $SavingsProduct1) @if ($SavingsProduct1->id == $key7A) @php $MemberSavingsArray[$SavingsProduct1->id] = $MemberSavingsArray[$SavingsProduct1->id] + $SavingsAmount2; @endphp @endif @endforeach @endforeach @endif @endforeach @foreach ($ManualOutstanding as $key8 => $ManualOutstanding1) @if ($SamityInfo->id == $key8) @php $Total6 = $Total6 + $ManualOutstanding1; @endphp @endif @endforeach @foreach ($ManualDue as $key9 => $ManualDue1) @if ($SamityInfo->id == $key9) @php $Total7 = $Total7 + $ManualDue1; @endphp @endif @endforeach @foreach ($ManualSavings as $key10 => $ManualSavings1) @if ($SamityInfo->id == $key10) @foreach ($ManualSavings1 as $key10A => $ManualSavings2) @foreach ($SavingsProduct as $key10B => $SavingsProduct1) @if ($SavingsProduct1->id == $key10A) @php $MemberSavingsArrayPassBook[$SavingsProduct1->id] = $MemberSavingsArrayPassBook[$SavingsProduct1->id] + $ManualSavings2; @endphp @endif @endforeach @endforeach @endif @endforeach @endforeach @foreach ($MemberSavingsArray as $key => $MemberSavingsArray1) @endforeach @foreach ($MemberSavingsArrayPassBook as $key => $MemberSavingsArrayPassBook1) @endforeach
SL. No.
Samity ID
Samity Name
No. of Member
No. of Borrower
Loan Amount
Collection Sheet Balance
Pass Book Balance
Loan
Savings
Loan
Savings
Outstanding
Due
{{$SavingsProduct1->name}}
Outstanding
Due
{{$SavingsProduct1->name}}
{{++$SerialNumber}} {{$SamityInfo->code}} {{$SamityInfo->name}}{{$MemberInfo}}{{$BorrowerInfo}}{{number_format($DisbursementAmountInfo,2)}}{{number_format($LoanOutstanding1,2)}}{{number_format($LoanDue1,2)}}{{number_format($SavingsAmount2,2)}}{{number_format($ManualOutstanding1,2)}}{{number_format($ManualDue1,2)}}{{number_format($ManualSavings2,2)}}
Total {{$Total1}} {{$Total2}} {{number_format($Total3,2)}} {{number_format($Total4,2)}} {{number_format($Total5,2)}} {{number_format($MemberSavingsArray1,2)}} {{number_format($Total6,2)}} {{number_format($Total7,2)}} {{number_format($MemberSavingsArrayPassBook1,2)}}
@php // dd($LoanDue); @endphp
{{-- --}}
Credit Officer Signature :
Credit Officer Name :
Designation :
{{-- --}}
Accounts & MIS Officer Signature :
Accounts & MIS Officer Name :
Designation :
{{-- --}}
Branch Manager Signature :
Branch Manager Name :
Designation :