{{-- 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}}
Manager Report (Field Officer & Component Wise)
Branch Name & Code : {{$branch->branchCode}}
Branch Address : {{$branch->address}}
Component Name : : {{$category ? $category->name : 'All'}}
Product Name & Code : {{$product ? $product->name : 'All'}}
Reporting Date
: {{$dateRange}}
Print Date
: 2026-07-21

Part-A
@foreach ($branchManagers as $key => $branchManager) @endforeach @foreach ($savingsCategories as $savingsCategory) @endforeach @php $colNo = 1; @endphp @foreach ($savingsCategories as $savingsCategory) @endforeach @php $total['opening']['officer'] = [ 'samityNo' => 0, 'memberNo' => 0, 'savings_total' => 0, 'cumLoanNo' => 0, 'cumLoanAmount' => 0, 'cumFullyPaidLoanNo' => 0, 'cumFullyPaidLoanAmount' => 0, 'expLoanNo' => 0, 'expLoanAmount' => 0, 'currentLoanNo' => 0, 'currentLoanAmount' => 0, 'currentDueLoanNo' => 0, 'currentDueLoanAmount' => 0, 'overDueLoanNo' => 0, 'overDueLoanAmount' => 0, 'outstandingAmount' => 0, ]; foreach ($savingsCategories as $savingsCategory) { $total['opening']['officer']['savings'][$savingsCategory->id] = 0; } @endphp @foreach($opening['fieldOfficers'] as $fieldOfficer) @php $officer['opening']['savings'] = 0; $total['opening']['officer']['samityNo'] += $fieldOfficer->samityNo; $total['opening']['officer']['memberNo'] += $fieldOfficer->memberNo; $total['opening']['officer']['cumLoanNo'] += $fieldOfficer->cumLoanNo; $total['opening']['officer']['cumLoanAmount'] += $fieldOfficer->cumLoanAmount; $total['opening']['officer']['cumFullyPaidLoanNo'] += $fieldOfficer->cumFullyPaidLoanNo; $total['opening']['officer']['cumFullyPaidLoanAmount'] += $fieldOfficer->cumFullyPaidLoanAmount; $total['opening']['officer']['expLoanNo'] += $fieldOfficer->expLoanNo; $total['opening']['officer']['expLoanAmount'] += $fieldOfficer->expLoanAmount; $total['opening']['officer']['currentLoanNo'] += $fieldOfficer->currentLoanNo; $total['opening']['officer']['currentLoanAmount'] += $fieldOfficer->currentLoanAmount; $total['opening']['officer']['currentDueLoanNo'] += $fieldOfficer->currentDueLoanNo; $total['opening']['officer']['currentDueLoanAmount'] += $fieldOfficer->currentDueLoanAmount; $total['opening']['officer']['overDueLoanNo'] += $fieldOfficer->overDueLoanNo; $total['opening']['officer']['overDueLoanAmount'] += $fieldOfficer->overDueLoanAmount; $total['opening']['officer']['outstandingAmount'] += $fieldOfficer->outstandingAmount; @endphp @foreach ($savingsCategories as $savingsCategory) @php $total['opening']['officer']['savings'][$savingsCategory->id] += $fieldOfficer->savings[$savingsCategory->id]; $officer['opening']['savings'] += $fieldOfficer->savings[$savingsCategory->id]; @endphp @endforeach @php $total['opening']['officer']['savings_total'] += $officer['opening']['savings']; @endphp @endforeach @foreach ($savingsCategories as $savingsCategory) @endforeach
Branch Manager ID : {{ $branchManager->emp_id }}
Branch Manager Name : {{ $branchManager->emp_name_english }}
SL No. Field Officer Code Field Officer Name Beginning of this period
Samity Member Savings Total Cum. Disburse No Total Cum. Disbursement Cum. Fully Paid No Cum. Fully Paid Amount Expired Loan No Expired Loan Amount Current Loan No Current Loan Amount Total Due Outstanding
{{$savingsCategory->shortName}} Total Current Expired
No. Amount No Amount
{{$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}}{{++$colNo}}{{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo.'=('.($colNo-6).'-'.($colNo-4).'-'.($colNo-2).')'}} {{++$colNo.'=('.($colNo-6).'-'.($colNo-4).'-'.($colNo-2).')'}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}}
{{ $loop->iteration }} {{$fieldOfficer->emp_id}} {{$fieldOfficer->emp_name_english}} {{$fieldOfficer->samityNo}} {{$fieldOfficer->memberNo}} {{ number_format($fieldOfficer->savings[$savingsCategory->id], 2) }} {{ number_format($officer['opening']['savings'], 2) }} {{ $fieldOfficer->cumLoanNo }} {{ number_format($fieldOfficer->cumLoanAmount, 2) }} {{ $fieldOfficer->cumFullyPaidLoanNo }} {{ number_format($fieldOfficer->cumFullyPaidLoanAmount, 2) }} {{ $fieldOfficer->expLoanNo }} {{ number_format($fieldOfficer->expLoanAmount, 2) }} {{ $fieldOfficer->currentLoanNo }} {{ number_format($fieldOfficer->currentLoanAmount, 2) }} {{ $fieldOfficer->currentDueLoanNo }} {{ number_format($fieldOfficer->currentDueLoanAmount, 2) }} {{ $fieldOfficer->overDueLoanNo }} {{ number_format($fieldOfficer->overDueLoanAmount, 2) }} {{ number_format($fieldOfficer->outstandingAmount, 2) }}
Grand Total {{$total['opening']['officer']['samityNo']}} {{$total['opening']['officer']['memberNo']}}{{number_format($total['opening']['officer']['savings'][$savingsCategory->id], 2)}}{{ number_format($total['opening']['officer']['savings_total'], 2)}} {{ $total['opening']['officer']['cumLoanNo']}} {{ number_format($total['opening']['officer']['cumLoanAmount'], 2)}} {{ $total['opening']['officer']['cumFullyPaidLoanNo']}} {{ number_format($total['opening']['officer']['cumFullyPaidLoanAmount'], 2)}} {{ $total['opening']['officer']['expLoanNo']}} {{ number_format($total['opening']['officer']['expLoanAmount'], 2)}} {{ $total['opening']['officer']['currentLoanNo']}} {{ number_format($total['opening']['officer']['currentLoanAmount'], 2)}} {{ $total['opening']['officer']['currentDueLoanNo']}} {{ number_format($total['opening']['officer']['currentDueLoanAmount'], 2)}} {{ $total['opening']['officer']['overDueLoanNo']}} {{ number_format($total['opening']['officer']['overDueLoanAmount'], 2)}} {{ number_format($total['opening']['officer']['outstandingAmount'], 2)}}
{{-- @php dd($SavingsTotal); @endphp --}}
Part-B
@foreach ($branchManagers as $key => $branchManager) @endforeach @foreach ($savingsCategories as $savingsCategory) @endforeach @foreach ($savingsCategories as $savingsCategory) @endforeach @php $colNo = 1; @endphp @foreach ($savingsCategories as $savingsCategory) @endforeach @foreach ($savingsCategories as $savingsCategory) @endforeach {{-- --}} {{-- --}} {{-- --}} {{-- --}} @php $total['period']['officer'] = [ 'memberAdmission' => 0, 'memberDropout' => 0, 'collection_total' => 0, 'refund_total' => 0, 'disLoanNo' => 0, 'disLoanAmount' => 0, 'fullyPaidLoanNo' => 0, 'fullyPaidLoanAmount' => 0, 'expLoanNo' => 0, 'expLoanAmount' => 0, 'recoverableAmount' => 0, 'regularRecover' => 0, 'currentDueRecover' => 0, 'expiredRecover' => 0, 'advanceRecover' => 0, 'totalRecover' => 0, 'newDuesLoan' => 0, ]; foreach ($savingsCategories as $savingsCategory) { $total['period']['officer']['savingsCollection'][$savingsCategory->id] = 0; $total['period']['officer']['savingsRefund'][$savingsCategory->id] = 0; } @endphp @foreach($period['fieldOfficers'] as $fieldOfficer) @php $officer['period']['savingsCollection'] = 0; $officer['period']['savingsRefund'] = 0; $total['period']['officer']['memberAdmission'] += $fieldOfficer->memberAdmission; $total['period']['officer']['memberDropout'] += $fieldOfficer->memberDropout; $total['period']['officer']['disLoanNo'] += $fieldOfficer->disLoanNo; $total['period']['officer']['disLoanAmount'] += $fieldOfficer->disLoanAmount; $total['period']['officer']['fullyPaidLoanNo'] += $fieldOfficer->fullyPaidLoanNo; $total['period']['officer']['fullyPaidLoanAmount'] += $fieldOfficer->fullyPaidLoanAmount; $total['period']['officer']['expLoanNo'] += $fieldOfficer->expLoanNo; $total['period']['officer']['expLoanAmount'] += $fieldOfficer->expLoanAmount; $total['period']['officer']['recoverableAmount'] += $fieldOfficer->recoverableAmount; $total['period']['officer']['regularRecover'] += $fieldOfficer->regularRecover; $total['period']['officer']['currentDueRecover'] += $fieldOfficer->currentDueRecover; $total['period']['officer']['expiredRecover'] += $fieldOfficer->expiredRecover; $total['period']['officer']['advanceRecover'] += $fieldOfficer->advanceRecover; $total['period']['officer']['totalRecover'] += $fieldOfficer->totalRecover; $total['period']['officer']['newDuesLoan'] += $fieldOfficer->newDuesLoan; @endphp @foreach ($savingsCategories as $savingsCategory) @php $total['period']['officer']['savingsCollection'][$savingsCategory->id] += $fieldOfficer->savingsCollection[$savingsCategory->id]; $officer['period']['savingsCollection'] += $fieldOfficer->savingsCollection[$savingsCategory->id]; @endphp @endforeach @php $total['period']['officer']['collection_total'] += $officer['period']['savingsCollection']; @endphp @foreach ($savingsCategories as $savingsCategory) @php $total['period']['officer']['savingsRefund'][$savingsCategory->id] += $fieldOfficer->savingsRefund[$savingsCategory->id]; $officer['period']['savingsRefund'] += $fieldOfficer->savingsRefund[$savingsCategory->id]; @endphp @endforeach @php $total['period']['officer']['refund_total'] += $officer['period']['savingsRefund']; @endphp @endforeach @foreach ($savingsCategories as $savingsCategory) @endforeach @foreach ($savingsCategories as $savingsCategory) @endforeach
Branch Manager ID : {{ $branchManager->emp_id }}
Branch Manager Name : {{ $branchManager->emp_name_english }}
Field Officer Name For this period
Member Admission Member Dropout Savings Collection Savings Refund Disburse No Disbursement Amount Fully Paid No Fully Paid Amount Expired Loan No Expired Loan Amount Regular Recoverable Recovery This Period New Due/Less Rec.
{{$savingsCategory->shortName}} Total {{$savingsCategory->shortName}} Total Regular Due Advance Total
Current Expired
{{$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}}{{++$colNo}}{{++$colNo}}{{++$colNo}}{{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}}{{++$colNo}}{{++$colNo}}{{++$colNo}}{{++$colNo}}
{{$fieldOfficer->emp_name_english}} {{$fieldOfficer->memberAdmission}} {{$fieldOfficer->memberDropout}} {{ number_format($fieldOfficer->savingsCollection[$savingsCategory->id], 2) }} {{ number_format($officer['period']['savingsCollection'], 2) }} {{ number_format($fieldOfficer->savingsRefund[$savingsCategory->id], 2) }} {{ number_format($officer['period']['savingsRefund'], 2) }} {{ $fieldOfficer->disLoanNo }} {{ number_format($fieldOfficer->disLoanAmount, 2) }} {{ $fieldOfficer->fullyPaidLoanNo }} {{ number_format($fieldOfficer->fullyPaidLoanAmount, 2) }} {{ $fieldOfficer->expLoanNo }} {{ number_format($fieldOfficer->expLoanAmount, 2) }} {{ number_format($fieldOfficer->recoverableAmount, 2) }} {{ number_format($fieldOfficer->regularRecover, 2) }} {{ number_format($fieldOfficer->currentDueRecover, 2) }} {{ number_format($fieldOfficer->expiredRecover, 2) }} {{ number_format($fieldOfficer->advanceRecover, 2) }} {{ number_format($fieldOfficer->totalRecover, 2) }} {{ number_format($fieldOfficer->newDuesLoan, 2) }}
Grand Total {{$total['period']['officer']['memberAdmission']}} {{$total['period']['officer']['memberDropout']}}{{number_format($total['period']['officer']['savingsCollection'][$savingsCategory->id], 2)}}{{ number_format($total['period']['officer']['collection_total'], 2)}}{{number_format($total['period']['officer']['savingsRefund'][$savingsCategory->id], 2)}}{{ number_format($total['period']['officer']['refund_total'], 2)}} {{ $total['period']['officer']['disLoanNo']}} {{ number_format($total['period']['officer']['disLoanAmount'], 2)}} {{ $total['period']['officer']['fullyPaidLoanNo']}} {{ number_format($total['period']['officer']['fullyPaidLoanAmount'], 2)}} {{ $total['period']['officer']['expLoanNo']}} {{ number_format($total['period']['officer']['expLoanAmount'], 2)}} {{ number_format($total['period']['officer']['recoverableAmount'], 2)}} {{ number_format($total['period']['officer']['regularRecover'], 2)}} {{ number_format($total['period']['officer']['currentDueRecover'], 2)}} {{ number_format($total['period']['officer']['expiredRecover'], 2)}} {{ number_format($total['period']['officer']['advanceRecover'], 2)}} {{ number_format($total['period']['officer']['totalRecover'], 2)}} {{ number_format($total['period']['officer']['newDuesLoan'], 2)}}

Part-C
@foreach ($branchManagers as $key => $branchManager) @endforeach @foreach ($savingsCategories as $savingsCategory) @endforeach @php $colNo = 1; @endphp @foreach ($savingsCategories as $savingsCategory) @endforeach @php $total['closing']['officer'] = [ 'samityNo' => 0, 'memberNo' => 0, 'savings_total' => 0, 'cumLoanNo' => 0, 'cumLoanAmount' => 0, 'cumFullyPaidLoanNo' => 0, 'cumFullyPaidLoanAmount' => 0, 'expLoanNo' => 0, 'expLoanAmount' => 0, 'currentLoanNo' => 0, 'currentLoanAmount' => 0, 'currentDueLoanNo' => 0, 'currentDueLoanAmount' => 0, 'overDueLoanNo' => 0, 'overDueLoanAmount' => 0, 'outstandingAmount' => 0, ]; foreach ($savingsCategories as $savingsCategory) { $total['closing']['officer']['savings'][$savingsCategory->id] = 0; } @endphp @foreach($closing['fieldOfficers'] as $fieldOfficer) @php $officer['closing']['savings'] = 0; $total['closing']['officer']['samityNo'] += $fieldOfficer->samityNo; $total['closing']['officer']['memberNo'] += $fieldOfficer->memberNo; $total['closing']['officer']['cumLoanNo'] += $fieldOfficer->cumLoanNo; $total['closing']['officer']['cumLoanAmount'] += $fieldOfficer->cumLoanAmount; $total['closing']['officer']['cumFullyPaidLoanNo'] += $fieldOfficer->cumFullyPaidLoanNo; $total['closing']['officer']['cumFullyPaidLoanAmount'] += $fieldOfficer->cumFullyPaidLoanAmount; $total['closing']['officer']['expLoanNo'] += $fieldOfficer->expLoanNo; $total['closing']['officer']['expLoanAmount'] += $fieldOfficer->expLoanAmount; $total['closing']['officer']['currentLoanNo'] += $fieldOfficer->currentLoanNo; $total['closing']['officer']['currentLoanAmount'] += $fieldOfficer->currentLoanAmount; $total['closing']['officer']['currentDueLoanNo'] += $fieldOfficer->currentDueLoanNo; $total['closing']['officer']['currentDueLoanAmount'] += $fieldOfficer->currentDueLoanAmount; $total['closing']['officer']['overDueLoanNo'] += $fieldOfficer->overDueLoanNo; $total['closing']['officer']['overDueLoanAmount'] += $fieldOfficer->overDueLoanAmount; $total['closing']['officer']['outstandingAmount'] += $fieldOfficer->outstandingAmount; @endphp @foreach ($savingsCategories as $savingsCategory) @php $total['closing']['officer']['savings'][$savingsCategory->id] += $fieldOfficer->savings[$savingsCategory->id]; $officer['closing']['savings'] += $fieldOfficer->savings[$savingsCategory->id]; @endphp @endforeach @php $total['closing']['officer']['savings_total'] += $officer['closing']['savings']; @endphp @endforeach @foreach ($savingsCategories as $savingsCategory) @endforeach
Branch Manager ID : {{ $branchManager->emp_id }}
Branch Manager Name : {{ $branchManager->emp_name_english }}
SL No. Field Officer Code Field Officer Name End of this period
Samity Member Savings Total Cum. Disburse No Total Cum. Disbursement Cum. Fully Paid No Cum. Fully Paid Amount Expired Loan No Expired Loan Amount Current Loan No Current Loan Amount Total Due Outstanding
{{$savingsCategory->shortName}} Total Current Expired
No. Amount No Amount
{{$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}}{{++$colNo}}{{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo.'=('.($colNo-6).'-'.($colNo-4).'-'.($colNo-2).')'}} {{++$colNo.'=('.($colNo-6).'-'.($colNo-4).'-'.($colNo-2).')'}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}} {{++$colNo}}
{{ $loop->iteration }} {{$fieldOfficer->emp_id}} {{$fieldOfficer->emp_name_english}} {{$fieldOfficer->samityNo}} {{$fieldOfficer->memberNo}} {{ number_format($fieldOfficer->savings[$savingsCategory->id], 2) }} {{ number_format($officer['closing']['savings'], 2) }} {{ $fieldOfficer->cumLoanNo }} {{ number_format($fieldOfficer->cumLoanAmount, 2) }} {{ $fieldOfficer->cumFullyPaidLoanNo }} {{ number_format($fieldOfficer->cumFullyPaidLoanAmount, 2) }} {{ $fieldOfficer->expLoanNo }} {{ number_format($fieldOfficer->expLoanAmount, 2) }} {{ $fieldOfficer->currentLoanNo }} {{ number_format($fieldOfficer->currentLoanAmount, 2) }} {{ $fieldOfficer->currentDueLoanNo }} {{ number_format($fieldOfficer->currentDueLoanAmount, 2) }} {{ $fieldOfficer->overDueLoanNo }} {{ number_format($fieldOfficer->overDueLoanAmount, 2) }} {{ number_format($fieldOfficer->outstandingAmount, 2) }}
Grand Total {{$total['closing']['officer']['samityNo']}} {{$total['closing']['officer']['memberNo']}}{{number_format($total['closing']['officer']['savings'][$savingsCategory->id], 2)}}{{ number_format($total['closing']['officer']['savings_total'], 2)}} {{ $total['closing']['officer']['cumLoanNo']}} {{ number_format($total['closing']['officer']['cumLoanAmount'], 2)}} {{ $total['closing']['officer']['cumFullyPaidLoanNo']}} {{ number_format($total['closing']['officer']['cumFullyPaidLoanAmount'], 2)}} {{ $total['closing']['officer']['expLoanNo']}} {{ number_format($total['closing']['officer']['expLoanAmount'], 2)}} {{ $total['closing']['officer']['currentLoanNo']}} {{ number_format($total['closing']['officer']['currentLoanAmount'], 2)}} {{ $total['closing']['officer']['currentDueLoanNo']}} {{ number_format($total['closing']['officer']['currentDueLoanAmount'], 2)}} {{ $total['closing']['officer']['overDueLoanNo']}} {{ number_format($total['closing']['officer']['overDueLoanAmount'], 2)}} {{ number_format($total['closing']['officer']['outstandingAmount'], 2)}}
Prepared By :
Signature :
Designation :
Verified By :
Signature :
Designation :
Approved By :
Signature :
Designation: :