{{-- 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 Statement (Recoverable Calculation)
{{--

Ambala Foundation

House # 67, Block # Ka, Piciculture Housing Society, Shyamoli, Dhaka- 1207

--}} {{--

Member Ledger Report

--}}
Branch Name : @foreach ($BranchDatas as $key => $BranchData) {{$BranchData->name}} @endforeach
Branch Address : @foreach ($BranchDatas as $key => $BranchData) {{$BranchData->address}} @endforeach
Samity Name(Code) : @if (sizeof($SamityDatas)>0) @foreach ($SamityDatas as $key => $SamityData) {{$SamityData->name}} ({{$SamityData->code}}) @endforeach @else All @endif
Reporting Month-Year
: @php $DateArray = array('1' => 'January', '2' => 'February', '3' => 'March', '4' => 'April', '5' => 'May', '6' => 'Jun', '7' => 'July', '8' => 'August', '9' => 'September', '10' => 'October', '11' => 'November', '12' => 'December' ); @endphp @foreach ($DateArray as $key => $Date) @if ($key == $RequestMonth) {{$Date}}-{{$RequestYear}} @endif @endforeach
Print Date
: 2026-07-21
@php $ProductNameTracker = ''; $NameTracker = array(); $UniqueNames = array(); @endphp @if (sizeof($FieldOrganizationDatas)>0) @foreach ($FieldOrganizationDatas as $key => $FieldOrganizationData) @php $NameTracker[] = $FieldOrganizationData->name; @endphp @endforeach @else @endif @php $UniqueNames = array_unique($NameTracker); @endphp @if (sizeof($FieldOrganizationDatas)>0) @foreach ($UniqueNames as $key => $UniqueName) @endforeach @else @endif @php $ProductValueTracker = 0; @endphp @if (sizeof($FieldOrganizationDatas)>0) @foreach ($UniqueNames as $key => $UniqueName) @php $ProductValueTracker = $ProductValueTracker + 1; @endphp @endforeach @php // echo $ProductValueTracker; @endphp @else @endif @php $DateCompareArray = array(); $WeekLoopCount = 0; $MaleTotal_TotalDisbursUpToLastWeek = 0; $FemaleTotal_TotalDisbursUpToLastWeek = 0; $DateTracker = ''; $LoopTracker = 0; $Balance1 = 0; $Balance2 = 0; @endphp @if ($RequestRoundUp == 0) {{-- Request for not to Round Up the values --}} @if (sizeof($FieldOrganizationDatas)>0) @foreach ($WeekArray as $key => $WeekArrays) @php $WeekLoopCount = $WeekLoopCount + 1; // echo $WeekLoopCount; @endphp @foreach ($TotalDisbursUpToLastWeek as $key1 => $TotalDisbursUpToLastWeeks) @if (sizeof($TotalDisbursUpToLastWeeks) > 0) @foreach ($TotalDisbursUpToLastWeeks as $key2 => $TotalDisbursUpToLastWeekss) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @php $DateTracker = substr($key1, 0, 10); @endphp @if ($TotalDisbursUpToLastWeekss->disbursementDate < substr($WeekArrays, 0, 10)) @if ($TotalDisbursUpToLastWeekss->gender == 1) @php $MaleTotal_TotalDisbursUpToLastWeek = $MaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->loanAmount; @endphp @endif @if ($TotalDisbursUpToLastWeekss->gender == 2) @php $FemaleTotal_TotalDisbursUpToLastWeek = $FemaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->loanAmount; @endphp @endif @endif @endif @endforeach @if ($DateTracker == substr($WeekArrays, 0, 10)) @php $Balance1 = $Balance1 + $MaleTotal_TotalDisbursUpToLastWeek; $Balance2 = $Balance2 + $FemaleTotal_TotalDisbursUpToLastWeek; @endphp @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @php $MaleTotal_TotalDisbursUpToLastWeek = 0; $FemaleTotal_TotalDisbursUpToLastWeek = 0; @endphp @elseif(sizeof($TotalDisbursUpToLastWeeks) == 0) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @endif @php if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) { if (substr($key1, 11) == $ProductNameTracker) { $LoopTracker = 0; break; } } @endphp @endforeach @php $DateTracker = ''; @endphp @foreach ($TotalDisbursAtLastWeek as $key1 => $TotalDisbursUpToLastWeeks) @if (sizeof($TotalDisbursUpToLastWeeks) > 0) @foreach ($TotalDisbursUpToLastWeeks as $key2 => $TotalDisbursUpToLastWeekss) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @php $DateTracker = substr($key1, 0, 10); @endphp @if ($TotalDisbursUpToLastWeekss->disbursementDate >= substr($WeekArrays, 0, 10) and $TotalDisbursUpToLastWeekss->disbursementDate <= substr($WeekArrays, 14)) @if ($TotalDisbursUpToLastWeekss->gender == 1) @php $MaleTotal_TotalDisbursUpToLastWeek = $MaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->loanAmount; @endphp @endif @if ($TotalDisbursUpToLastWeekss->gender == 2) @php $FemaleTotal_TotalDisbursUpToLastWeek = $FemaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->loanAmount; @endphp @endif @endif @endif @endforeach @if ($DateTracker == substr($WeekArrays, 0, 10)) @php $Balance1 = $Balance1 + $MaleTotal_TotalDisbursUpToLastWeek; $Balance2 = $Balance2 + $FemaleTotal_TotalDisbursUpToLastWeek; @endphp @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @php $MaleTotal_TotalDisbursUpToLastWeek = 0; $FemaleTotal_TotalDisbursUpToLastWeek = 0; @endphp @elseif(sizeof($TotalDisbursUpToLastWeeks) == 0) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @endif @php if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) { if (substr($key1, 11) == $ProductNameTracker) { $LoopTracker = 0; break; } } @endphp @endforeach @php $DateTracker = ''; @endphp @foreach ($TotalFullyPaidUptoLastWeek as $key1 => $TotalDisbursUpToLastWeeks) @if (sizeof($TotalDisbursUpToLastWeeks) > 0) @foreach ($TotalDisbursUpToLastWeeks as $key2 => $TotalDisbursUpToLastWeekss) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @php $DateTracker = substr($key1, 0, 10); @endphp @if ($TotalDisbursUpToLastWeekss->disbursementDate >= substr($WeekArrays, 0, 10) and $TotalDisbursUpToLastWeekss->disbursementDate <= substr($WeekArrays, 14)) @if ($TotalDisbursUpToLastWeekss->gender == 1) @php $MaleTotal_TotalDisbursUpToLastWeek = $MaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->totalRepayAmount; @endphp @endif @if ($TotalDisbursUpToLastWeekss->gender == 2) @php $FemaleTotal_TotalDisbursUpToLastWeek = $FemaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->totalRepayAmount; @endphp @endif @endif @endif @endforeach @if ($DateTracker == substr($WeekArrays, 0, 10)) @php $Balance1 = $Balance1 + $MaleTotal_TotalDisbursUpToLastWeek; $Balance2 = $Balance2 + $FemaleTotal_TotalDisbursUpToLastWeek; @endphp @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @php $MaleTotal_TotalDisbursUpToLastWeek = 0; $FemaleTotal_TotalDisbursUpToLastWeek = 0; @endphp @elseif(sizeof($TotalDisbursUpToLastWeeks) == 0) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @endif @php if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) { if (substr($key1, 11) == $ProductNameTracker) { $LoopTracker = 0; break; } } @endphp @endforeach @php $DateTracker = ''; @endphp @foreach ($TotalOverDueLoan as $key1 => $TotalDisbursUpToLastWeeks) @if (sizeof($TotalDisbursUpToLastWeeks) > 0) @foreach ($TotalDisbursUpToLastWeeks as $key2 => $TotalDisbursUpToLastWeekss) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @php $DateTracker = substr($key1, 0, 10); @endphp @if ($TotalDisbursUpToLastWeekss->loanCompletedDate < substr($WeekArrays, 0, 10)) @if ($TotalDisbursUpToLastWeekss->gender == 1) @php $MaleTotal_TotalDisbursUpToLastWeek = $MaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->installmentDueAmount; @endphp @endif @if ($TotalDisbursUpToLastWeekss->gender == 2) @php $FemaleTotal_TotalDisbursUpToLastWeek = $FemaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->installmentDueAmount; @endphp @endif @endif @endif @endforeach @if ($DateTracker == substr($WeekArrays, 0, 10)) @php $Balance1 = $Balance1 + $MaleTotal_TotalDisbursUpToLastWeek; $Balance2 = $Balance2 + $FemaleTotal_TotalDisbursUpToLastWeek; @endphp @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @php $MaleTotal_TotalDisbursUpToLastWeek = 0; $FemaleTotal_TotalDisbursUpToLastWeek = 0; @endphp @elseif(sizeof($TotalDisbursUpToLastWeeks) == 0) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @endif @php if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) { if (substr($key1, 11) == $ProductNameTracker) { $LoopTracker = 0; break; } } @endphp @endforeach @php $DateTracker = ''; @endphp @foreach ($RegularCurrentLoan as $key1 => $TotalDisbursUpToLastWeeks) @if (sizeof($TotalDisbursUpToLastWeeks) > 0) @foreach ($TotalDisbursUpToLastWeeks as $key2 => $TotalDisbursUpToLastWeekss) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @php $DateTracker = substr($key1, 0, 10); @endphp @if ($TotalDisbursUpToLastWeekss->disbursementDate < substr($WeekArrays, 0, 10)) @if ($TotalDisbursUpToLastWeekss->gender == 1) @php $MaleTotal_TotalDisbursUpToLastWeek = $MaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->loanAmount; @endphp @endif @if ($TotalDisbursUpToLastWeekss->gender == 2) @php $FemaleTotal_TotalDisbursUpToLastWeek = $FemaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->loanAmount; @endphp @endif @endif @endif @endforeach @if ($DateTracker == substr($WeekArrays, 0, 10)) @php $Balance1 = $Balance1 + $MaleTotal_TotalDisbursUpToLastWeek; $Balance2 = $Balance2 + $FemaleTotal_TotalDisbursUpToLastWeek; @endphp @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @php $MaleTotal_TotalDisbursUpToLastWeek = 0; $FemaleTotal_TotalDisbursUpToLastWeek = 0; @endphp @elseif(sizeof($TotalDisbursUpToLastWeeks) == 0) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @endif @php if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) { if (substr($key1, 11) == $ProductNameTracker) { $LoopTracker = 0; break; } } @endphp @endforeach @php $DateTracker = ''; @endphp @foreach ($NetWeeklyCollectable as $key1 => $TotalDisbursUpToLastWeeks) @if (sizeof($TotalDisbursUpToLastWeeks) > 0) @foreach ($TotalDisbursUpToLastWeeks as $key2 => $TotalDisbursUpToLastWeekss) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @php $DateTracker = substr($key1, 0, 10); @endphp @if ($TotalDisbursUpToLastWeekss->disbursementDate < substr($WeekArrays, 0, 10)) {{-- @foreach ($Gendar as $key3 => $Gendars) @foreach ($Gendars as $key4 => $Gendarss) --}} @if ($TotalDisbursUpToLastWeekss->scheduleDate >= substr($WeekArrays, 0, 10) and $TotalDisbursUpToLastWeekss->scheduleDate <= substr($WeekArrays, 14, 10)) @if ($TotalDisbursUpToLastWeekss->gender == 1) @php $MaleTotal_TotalDisbursUpToLastWeek = $MaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->installmentAmount; @endphp @endif @if ($TotalDisbursUpToLastWeekss->gender == 2) @php $FemaleTotal_TotalDisbursUpToLastWeek = $FemaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->installmentAmount; @endphp @endif @endif {{-- @endforeach @endforeach --}} @endif @endif @endforeach @if ($DateTracker == substr($WeekArrays, 0, 10)) @php $Balance1 = $Balance1 + $MaleTotal_TotalDisbursUpToLastWeek; $Balance2 = $Balance2 + $FemaleTotal_TotalDisbursUpToLastWeek; @endphp @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @php $MaleTotal_TotalDisbursUpToLastWeek = 0; $FemaleTotal_TotalDisbursUpToLastWeek = 0; @endphp @elseif(sizeof($TotalDisbursUpToLastWeeks) == 0) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @endif @php if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) { if (substr($key1, 11) == $ProductNameTracker) { $LoopTracker = 0; break; } } @endphp @endforeach @foreach ($UniqueNames as $key => $UniqueName) @endforeach {{-- @php $LoopTracker = 0; echo $LoopTracker; @endphp --}} @endforeach @else @endif {{-- End of the Request for not to Round Up the values --}} @elseif ($RequestRoundUp == 1) {{-- Request for Round Up Values --}} @if (sizeof($FieldOrganizationDatas)>0) @foreach ($WeekArray as $key => $WeekArrays) @php $WeekLoopCount = $WeekLoopCount + 1; // echo $WeekLoopCount; @endphp @foreach ($TotalDisbursUpToLastWeek as $key1 => $TotalDisbursUpToLastWeeks) @if (sizeof($TotalDisbursUpToLastWeeks) > 0) @foreach ($TotalDisbursUpToLastWeeks as $key2 => $TotalDisbursUpToLastWeekss) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @php $DateTracker = substr($key1, 0, 10); @endphp @if ($TotalDisbursUpToLastWeekss->disbursementDate < substr($WeekArrays, 0, 10)) @if ($TotalDisbursUpToLastWeekss->gender == 1) @php $MaleTotal_TotalDisbursUpToLastWeek = $MaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->loanAmount; @endphp @endif @if ($TotalDisbursUpToLastWeekss->gender == 2) @php $FemaleTotal_TotalDisbursUpToLastWeek = $FemaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->loanAmount; @endphp @endif @endif @endif @endforeach @if ($DateTracker == substr($WeekArrays, 0, 10)) @php $Balance1 = $Balance1 + $MaleTotal_TotalDisbursUpToLastWeek; $Balance2 = $Balance2 + $FemaleTotal_TotalDisbursUpToLastWeek; @endphp @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @php $MaleTotal_TotalDisbursUpToLastWeek = 0; $FemaleTotal_TotalDisbursUpToLastWeek = 0; @endphp @elseif(sizeof($TotalDisbursUpToLastWeeks) == 0) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @endif @php if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) { if (substr($key1, 11) == $ProductNameTracker) { $LoopTracker = 0; break; } } @endphp @endforeach @php $DateTracker = ''; @endphp @foreach ($TotalDisbursAtLastWeek as $key1 => $TotalDisbursUpToLastWeeks) @if (sizeof($TotalDisbursUpToLastWeeks) > 0) @foreach ($TotalDisbursUpToLastWeeks as $key2 => $TotalDisbursUpToLastWeekss) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @php $DateTracker = substr($key1, 0, 10); @endphp @if ($TotalDisbursUpToLastWeekss->disbursementDate >= substr($WeekArrays, 0, 10) and $TotalDisbursUpToLastWeekss->disbursementDate <= substr($WeekArrays, 14)) @if ($TotalDisbursUpToLastWeekss->gender == 1) @php $MaleTotal_TotalDisbursUpToLastWeek = $MaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->loanAmount; @endphp @endif @if ($TotalDisbursUpToLastWeekss->gender == 2) @php $FemaleTotal_TotalDisbursUpToLastWeek = $FemaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->loanAmount; @endphp @endif @endif @endif @endforeach @if ($DateTracker == substr($WeekArrays, 0, 10)) @php $Balance1 = $Balance1 + $MaleTotal_TotalDisbursUpToLastWeek; $Balance2 = $Balance2 + $FemaleTotal_TotalDisbursUpToLastWeek; @endphp @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @php $MaleTotal_TotalDisbursUpToLastWeek = 0; $FemaleTotal_TotalDisbursUpToLastWeek = 0; @endphp @elseif(sizeof($TotalDisbursUpToLastWeeks) == 0) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @endif @php if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) { if (substr($key1, 11) == $ProductNameTracker) { $LoopTracker = 0; break; } } @endphp @endforeach @php $DateTracker = ''; @endphp @foreach ($TotalFullyPaidUptoLastWeek as $key1 => $TotalDisbursUpToLastWeeks) @if (sizeof($TotalDisbursUpToLastWeeks) > 0) @foreach ($TotalDisbursUpToLastWeeks as $key2 => $TotalDisbursUpToLastWeekss) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @php $DateTracker = substr($key1, 0, 10); @endphp @if ($TotalDisbursUpToLastWeekss->disbursementDate >= substr($WeekArrays, 0, 10) and $TotalDisbursUpToLastWeekss->disbursementDate <= substr($WeekArrays, 14)) @if ($TotalDisbursUpToLastWeekss->gender == 1) @php $MaleTotal_TotalDisbursUpToLastWeek = $MaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->totalRepayAmount; @endphp @endif @if ($TotalDisbursUpToLastWeekss->gender == 2) @php $FemaleTotal_TotalDisbursUpToLastWeek = $FemaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->totalRepayAmount; @endphp @endif @endif @endif @endforeach @if ($DateTracker == substr($WeekArrays, 0, 10)) @php $Balance1 = $Balance1 + $MaleTotal_TotalDisbursUpToLastWeek; $Balance2 = $Balance2 + $FemaleTotal_TotalDisbursUpToLastWeek; @endphp @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @php $MaleTotal_TotalDisbursUpToLastWeek = 0; $FemaleTotal_TotalDisbursUpToLastWeek = 0; @endphp @elseif(sizeof($TotalDisbursUpToLastWeeks) == 0) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @endif @php if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) { if (substr($key1, 11) == $ProductNameTracker) { $LoopTracker = 0; break; } } @endphp @endforeach @php $DateTracker = ''; @endphp @foreach ($TotalOverDueLoan as $key1 => $TotalDisbursUpToLastWeeks) @if (sizeof($TotalDisbursUpToLastWeeks) > 0) @foreach ($TotalDisbursUpToLastWeeks as $key2 => $TotalDisbursUpToLastWeekss) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @php $DateTracker = substr($key1, 0, 10); @endphp @if ($TotalDisbursUpToLastWeekss->loanCompletedDate < substr($WeekArrays, 0, 10)) @if ($TotalDisbursUpToLastWeekss->gender == 1) @php $MaleTotal_TotalDisbursUpToLastWeek = $MaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->installmentDueAmount; @endphp @endif @if ($TotalDisbursUpToLastWeekss->gender == 2) @php $FemaleTotal_TotalDisbursUpToLastWeek = $FemaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->installmentDueAmount; @endphp @endif @endif @endif @endforeach @if ($DateTracker == substr($WeekArrays, 0, 10)) @php $Balance1 = $Balance1 + $MaleTotal_TotalDisbursUpToLastWeek; $Balance2 = $Balance2 + $FemaleTotal_TotalDisbursUpToLastWeek; @endphp @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @php $MaleTotal_TotalDisbursUpToLastWeek = 0; $FemaleTotal_TotalDisbursUpToLastWeek = 0; @endphp @elseif(sizeof($TotalDisbursUpToLastWeeks) == 0) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @endif @php if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) { if (substr($key1, 11) == $ProductNameTracker) { $LoopTracker = 0; break; } } @endphp @endforeach @php $DateTracker = ''; @endphp @foreach ($RegularCurrentLoan as $key1 => $TotalDisbursUpToLastWeeks) @if (sizeof($TotalDisbursUpToLastWeeks) > 0) @foreach ($TotalDisbursUpToLastWeeks as $key2 => $TotalDisbursUpToLastWeekss) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @php $DateTracker = substr($key1, 0, 10); @endphp @if ($TotalDisbursUpToLastWeekss->disbursementDate < substr($WeekArrays, 0, 10)) @if ($TotalDisbursUpToLastWeekss->gender == 1) @php $MaleTotal_TotalDisbursUpToLastWeek = $MaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->loanAmount; @endphp @endif @if ($TotalDisbursUpToLastWeekss->gender == 2) @php $FemaleTotal_TotalDisbursUpToLastWeek = $FemaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->loanAmount; @endphp @endif @endif @endif @endforeach @if ($DateTracker == substr($WeekArrays, 0, 10)) @php $Balance1 = $Balance1 + $MaleTotal_TotalDisbursUpToLastWeek; $Balance2 = $Balance2 + $FemaleTotal_TotalDisbursUpToLastWeek; @endphp @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @php $MaleTotal_TotalDisbursUpToLastWeek = 0; $FemaleTotal_TotalDisbursUpToLastWeek = 0; @endphp @elseif(sizeof($TotalDisbursUpToLastWeeks) == 0) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @endif @php if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) { if (substr($key1, 11) == $ProductNameTracker) { $LoopTracker = 0; break; } } @endphp @endforeach @php $DateTracker = ''; @endphp @foreach ($NetWeeklyCollectable as $key1 => $TotalDisbursUpToLastWeeks) @if (sizeof($TotalDisbursUpToLastWeeks) > 0) @foreach ($TotalDisbursUpToLastWeeks as $key2 => $TotalDisbursUpToLastWeekss) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @php $DateTracker = substr($key1, 0, 10); @endphp @if ($TotalDisbursUpToLastWeekss->disbursementDate < substr($WeekArrays, 0, 10)) {{-- @foreach ($Gendar as $key3 => $Gendars) @foreach ($Gendars as $key4 => $Gendarss) --}} @if ($TotalDisbursUpToLastWeekss->scheduleDate >= substr($WeekArrays, 0, 10) and $TotalDisbursUpToLastWeekss->scheduleDate <= substr($WeekArrays, 14, 10)) @if ($TotalDisbursUpToLastWeekss->gender == 1) @php $MaleTotal_TotalDisbursUpToLastWeek = $MaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->installmentAmount; @endphp @endif @if ($TotalDisbursUpToLastWeekss->gender == 2) @php $FemaleTotal_TotalDisbursUpToLastWeek = $FemaleTotal_TotalDisbursUpToLastWeek + $TotalDisbursUpToLastWeekss->installmentAmount; @endphp @endif @endif {{-- @endforeach @endforeach --}} @endif @endif @endforeach @if ($DateTracker == substr($WeekArrays, 0, 10)) @php $Balance1 = $Balance1 + $MaleTotal_TotalDisbursUpToLastWeek; $Balance2 = $Balance2 + $FemaleTotal_TotalDisbursUpToLastWeek; @endphp @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @php $MaleTotal_TotalDisbursUpToLastWeek = 0; $FemaleTotal_TotalDisbursUpToLastWeek = 0; @endphp @elseif(sizeof($TotalDisbursUpToLastWeeks) == 0) @if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) @if (substr($key1, 11) == $ProductNameTracker) @php $Balance1 = 0; $Balance2 = 0; @endphp @endif @endif @endif @php if (substr($key1, 0, 10) == substr($WeekArrays, 0, 10)) { if (substr($key1, 11) == $ProductNameTracker) { $LoopTracker = 0; break; } } @endphp @endforeach @foreach ($UniqueNames as $key => $UniqueName) @endforeach {{-- @php $LoopTracker = 0; echo $LoopTracker; @endphp --}} @endforeach @else @endif {{-- End of the Request Round Up Values --}} @endif
Week No.
Description
{{$UniqueName}} @php $ProductNameTracker = $UniqueName; @endphp
Total
Male
Female
{{$WeekLoopCount}} Week
{{$WeekArrays}}
Total Disburse Upto Last Week{{number_format($MaleTotal_TotalDisbursUpToLastWeek,2)}} {{number_format($FemaleTotal_TotalDisbursUpToLastWeek,2)}}{{number_format($Balance1 + $Balance2,2)}}0.00 0.00{{number_format($Balance1 + $Balance2,2)}}
Disbursement at last week{{number_format($MaleTotal_TotalDisbursUpToLastWeek,2)}} {{number_format($FemaleTotal_TotalDisbursUpToLastWeek,2)}}{{number_format($Balance1 + $Balance2,2)}}0.00 0.00{{number_format($Balance1 + $Balance2,2)}}
Total Fully Paid Upto Last Week{{number_format($MaleTotal_TotalDisbursUpToLastWeek,2)}} {{number_format($FemaleTotal_TotalDisbursUpToLastWeek,2)}}{{number_format($Balance1 + $Balance2,2)}}0.00 0.00{{number_format($Balance1 + $Balance2,2)}}
Total Over Due Loan{{number_format($MaleTotal_TotalDisbursUpToLastWeek,2)}} {{number_format($FemaleTotal_TotalDisbursUpToLastWeek,2)}}{{number_format($Balance1 + $Balance2,2)}}0.00 0.00{{number_format($Balance1 + $Balance2,2)}}
Regular Current Loan{{number_format($MaleTotal_TotalDisbursUpToLastWeek,2)}} {{number_format($FemaleTotal_TotalDisbursUpToLastWeek,2)}}{{number_format($Balance1 + $Balance2,2)}}0.00 0.00{{number_format($Balance1 + $Balance2,2)}}
Net Weekly Collectable{{number_format($MaleTotal_TotalDisbursUpToLastWeek,2)}} {{number_format($FemaleTotal_TotalDisbursUpToLastWeek,2)}}{{number_format($Balance1 + $Balance2,2)}}0.00 0.00{{number_format($Balance1 + $Balance2,2)}}
Total amount for Installment Pause0.00 0.000.00
0.00 0.00
{{$WeekLoopCount}} Week
{{$WeekArrays}}
Total Disburse Upto Last Week{{$MaleTotal_TotalDisbursUpToLastWeek}} {{$FemaleTotal_TotalDisbursUpToLastWeek}}{{$Balance1 + $Balance2}}0 0{{$Balance1 + $Balance2}}
Disbursement at last week{{$MaleTotal_TotalDisbursUpToLastWeek}} {{$FemaleTotal_TotalDisbursUpToLastWeek}}{{$Balance1 + $Balance2}}0 0{{$Balance1 + $Balance2}}
Total Fully Paid Upto Last Week{{$MaleTotal_TotalDisbursUpToLastWeek}} {{$FemaleTotal_TotalDisbursUpToLastWeek}}{{$Balance1 + $Balance2}}0 0{{$Balance1 + $Balance2}}
Total Over Due Loan{{$MaleTotal_TotalDisbursUpToLastWeek}} {{$FemaleTotal_TotalDisbursUpToLastWeek}}{{$Balance1 + $Balance2}}0 0{{$Balance1 + $Balance2}}
Regular Current Loan{{$MaleTotal_TotalDisbursUpToLastWeek}} {{$FemaleTotal_TotalDisbursUpToLastWeek}}{{$Balance1 + $Balance2}}0 0{{$Balance1 + $Balance2}}
Net Weekly Collectable{{$MaleTotal_TotalDisbursUpToLastWeek}} {{$FemaleTotal_TotalDisbursUpToLastWeek}}{{$Balance1 + $Balance2}}0 0{{$Balance1 + $Balance2}}
Total amount for Installment Pause0 00
0 0
Prepared By :
Signature :
Designation :
Verified By :
Signature :
Designation :
Approved By :
Signature :
Designation: :