{{-- 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}}
Branch 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}}
Quarter
: {{-- @if ($SelectionType == 'N') {{$DateFrom}} - {{$DateTo}} @elseif ($SelectionType == 'Y') {{$DateTo}} @endif --}} {{$querter}}
Quarter Date
: @if ($requestedQuerter == '1-3') January-01 to March-31 ({{$requestedYear}}) @elseif ($requestedQuerter == '4-6') April-01 to June-30 ({{$requestedYear}}) @elseif ($requestedQuerter == '7-9') July-01 to September-30 ({{$requestedYear}}) @elseif ($requestedQuerter == '10-12') October-01 to December-31 ({{$requestedYear}}) @endif {{-- {{$requestedQuerter}} --}}
Print Date
: 2026-07-21

{{--
--}} @foreach ($SavingsProduct as $key => $SavingsProduct1) @endforeach @foreach ($SavingsProduct as $key => $SavingsProduct1) @endforeach @php $SerialNumber = 0; $RowCounter = 0; $SavingsCounter = 0; $LoanAmountTotal = 0; $RepaymentWeekTotal = 0; $OutstandingTotal = 0; $DueTotal = 0; $ManualSavingsTracker = 0; $ManualSavingsRowPrinter = 0; $SavingsTotal = array(); // echo sizeof($SavingsProduct); foreach ($SavingsProduct as $key => $SavingsProduct1) { $MemberSavingsArray[$SavingsProduct1->id] = 0; } foreach ($SavingsProduct as $key => $SavingsProduct1) { $MemberSavingsArrayPassBook[$SavingsProduct1->id] = 0; } $ManualOutstandingTotal = 0; $ManualDueTotal = 0; $Tracker = 0; $Total1 = 0; $Total2 = 0; $Total3 = 0; $Total4 = 0; $Total5 = 0; $Total6 = 0; $Total7 = 0; $Total8 = 0; @endphp @foreach ($CreditOfficerInfos as $key => $CreditOfficerInfo) @foreach ($SamityInfos as $key1 => $SamityInfo) @if ($CreditOfficerInfo->EmployeeID == $key1) @php $Total1 = $Total1 + $SamityInfo; @endphp @endif @endforeach @foreach ($MemberInfos as $key2 => $MemberInfo) @if ($CreditOfficerInfo->EmployeeID == $key2 and sizeof($MemberInfo) == 1) @php $Total2 = $Total2 + $MemberInfo; @endphp @elseif ($CreditOfficerInfo->EmployeeID == $key2 and sizeof($MemberInfo) > 1) @endif @endforeach @if (sizeof($LoanBorrowerInfos) > 0) @foreach ($LoanBorrowerInfos as $key3 => $LoanBorrowerInfo) @if ($CreditOfficerInfo->EmployeeID == $key3) @php $Total3 = $Total3 + $LoanBorrowerInfo; @endphp @endif @endforeach @elseif (sizeof($LoanBorrowerInfos) == 0) @endif @if (sizeof($LoanDisbursmentInfos) > 0) @foreach ($LoanDisbursmentInfos as $key4 => $LoanDisbursmentInfo) @if ($CreditOfficerInfo->EmployeeID == $key4) @php $Total4 = $Total4 + $LoanDisbursmentInfo; @endphp @endif @endforeach @elseif (sizeof($LoanDisbursmentInfos) == 0) @endif @if (sizeof($OutstandingInfos) > 0) @foreach ($OutstandingInfos as $key5 => $OutstandingInfos1) @if ($CreditOfficerInfo->EmployeeID == $key5) @php $Total5 = $Total5 + $OutstandingInfos1; @endphp @endif @endforeach @elseif (sizeof($OutstandingInfos) == 0) @endif @if (sizeof($DueInfos) > 0) @foreach ($DueInfos as $key6 => $DueInfo) @if ($CreditOfficerInfo->EmployeeID == $key6) @php $Total6 = $Total6 + $DueInfo; @endphp @endif @endforeach @elseif (sizeof($DueInfos) == 0) @endif @foreach ($SavingsInfos as $key7 => $SavingsInfo) @foreach ($SavingsInfo as $key7A => $SavingsInfo1) @if ($CreditOfficerInfo->EmployeeID == $key7) @php $MemberSavingsArray[$key7A] = $MemberSavingsArray[$key7A] + $SavingsInfo1; @endphp @endif @endforeach @endforeach @foreach ($ManualOutstandings as $key8 => $ManualOutstandings1) @if ($CreditOfficerInfo->EmployeeID == $key8) @php $Total7 = $Total7 + $ManualOutstandings1; @endphp @endif @endforeach @foreach ($ManualDue as $key9 => $ManualDue1) @if ($CreditOfficerInfo->EmployeeID == $key9) @php $Total8 = $Total8 + $ManualDue1; @endphp @endif @endforeach @foreach ($ManualSavings as $key10 => $ManualSavings1) @if ($CreditOfficerInfo->EmployeeID == $key10) @foreach ($ManualSavings1 as $key10A => $ManualSavings2) @php $MemberSavingsArrayPassBook[$key10A] = $MemberSavingsArrayPassBook[$key10A] + $ManualSavings2; @endphp @endforeach @endif @endforeach @endforeach @foreach ($MemberSavingsArray as $key => $MemberSavingsArray1) @endforeach @foreach ($MemberSavingsArrayPassBook as $key => $MemberSavingsArrayPassBook1) @endforeach
SL. No.
Credit Officer ID
Credit Officer Name
No of Samity
No.of member
No.of Borrower
Disburesment Loan Amount
Collection Sheet Balance
Pass Book Balance
Loan
Savings
Loan
Savings
Outstanding
Due
{{$SavingsProduct1->name}}
Outstanding
Due
{{$SavingsProduct1->name}}
{{++$SerialNumber}} {{$CreditOfficerInfo->emp_id}} {{$CreditOfficerInfo->emp_name_english}}{{$SamityInfo}}{{$MemberInfo}}0 {{$LoanBorrowerInfo}}0{{number_format($LoanDisbursmentInfo,2)}}0.00{{number_format($OutstandingInfos1,2)}}0.00{{number_format($DueInfo,2)}}0.00{{number_format($SavingsInfo1,2)}}{{number_format($ManualOutstandings1,2)}}{{number_format($ManualDue1,2)}}{{number_format($ManualSavings2,2)}}
Total {{$Total1}} {{$Total2}} {{$Total3}} {{number_format($Total4, 2)}} {{number_format($Total5, 2)}} {{number_format($Total6, 2)}} {{number_format($MemberSavingsArray1, 2)}} {{number_format($Total7, 2)}} {{number_format($Total8, 2)}} {{number_format($MemberSavingsArrayPassBook1, 2)}}

@php // dd(sizeof($LoanBorrowerInfos)); @endphp
{{--
--}} @foreach ($SavingsProduct as $key => $SavingsProduct1) @endforeach @foreach ($SavingsProduct as $key => $SavingsProduct1) @endforeach @php $SavingsArray = array(); $CategoryWiseTotal1 = 0; $CategoryWiseTotal2 = 0; $CategoryWiseTotal3 = 0; $CategoryWiseTotal4 = 0; foreach ($SavingsProduct as $key => $SavingsProduct1) { $SavingsArray[$SavingsProduct1->id] = 0; } foreach ($SavingsProduct as $key => $SavingsProduct1) { $SavingsArrayPassBook[$SavingsProduct1->id] = 0; } $CategoryWiseTotal5 = 0; $CategoryWiseTotal6 = 0; $CategoryWiseTotal7 = 0; $CategoryWiseTotal8 = 0; $CategoryWiseTotal9 = 0; @endphp @foreach ($CategoryName as $key => $CategoryName1) @foreach ($CategoryWiseOutstanding as $key1 => $CategoryWiseOutstanding1) @if ($CategoryName1 ->id == $key1) @php $CategoryWiseTotal1 = $CategoryWiseTotal1 + $CategoryWiseOutstanding1; @endphp @endif @endforeach @foreach ($CategoryWiseDue as $key2 => $CategoryWiseDue1) @if ($CategoryName1 ->id == $key2) @php $CategoryWiseTotal2 = $CategoryWiseTotal2 + $CategoryWiseDue1; @endphp @endif @endforeach @foreach ($CategoryWiseSavings as $key3 => $CategoryWiseSavings1) @if ($CategoryName1 ->id == $key3) @foreach ($CategoryWiseSavings1 as $key3A => $CategoryWiseSavings2) @php $SavingsArray[$key3A] = $SavingsArray[$key3A] + $CategoryWiseSavings2; @endphp @endforeach @endif @endforeach @foreach ($CategoryWiseManualOutstandings as $key4 => $CategoryWiseManualOutstandings1) @if ($CategoryName1 ->id == $key4) @php $CategoryWiseTotal3 = $CategoryWiseTotal3 + $CategoryWiseManualOutstandings1; @endphp @endif @endforeach @foreach ($CategoryWiseManualDue as $key5 => $CategoryWiseManualDue1) @if ($CategoryName1 ->id == $key5) @php $CategoryWiseTotal4 = $CategoryWiseTotal4 + $CategoryWiseManualDue1; @endphp @endif @endforeach @foreach ($CategoryWiseManualSavings as $key6 => $CategoryWiseManualSavings1) @if ($CategoryName1 ->id == $key6) @foreach ($CategoryWiseManualSavings1 as $key6A => $CategoryWiseManualSavings2) @php $SavingsArrayPassBook[$key6A] = $SavingsArrayPassBook[$key6A] + $CategoryWiseManualSavings2; @endphp @endforeach @endif @endforeach @endforeach @foreach ($SavingsArray as $key => $SavingsArray1) @endforeach @foreach ($SavingsArrayPassBook as $key => $SavingsArrayPassBook1) @endforeach @php // dd($Savings); @endphp
Product Catagory Name
Collection Sheet Balance
Pass Book Balance
Loan
Savings
Loan
Savings
Outstanding
Due
{{$SavingsProduct1->name}}
Outstanding
Due
{{$SavingsProduct1->name}}
{{$CategoryName1->name}}{{number_format($CategoryWiseOutstanding1, 2)}}{{number_format($CategoryWiseDue1, 2)}}{{number_format($CategoryWiseSavings2, 2)}}{{number_format($CategoryWiseManualOutstandings1, 2)}}{{number_format($CategoryWiseManualDue1, 2)}}{{number_format($CategoryWiseManualSavings2, 2)}}
Total {{number_format($CategoryWiseTotal1, 2)}} {{number_format($CategoryWiseTotal2, 2)}} {{number_format($SavingsArray1, 2)}} {{number_format($CategoryWiseTotal3, 2)}} {{number_format($CategoryWiseTotal4, 2)}} {{number_format($SavingsArrayPassBook1, 2)}}
{{-- --}}
Credit Officer Signature :
Credit Officer Name :
Designation :
{{-- --}}
Accounts & MIS Officer Signature :
Accounts & MIS Officer Name :
Designation :
{{-- --}}
Branch Manager Signature :
Branch Manager Name :
Designation :