@php $grandTotalDebt = 0; $grandTotalNotYetDue = 0; $grandTotal1to30Days = 0; $grandTotal31to60Days = 0; $grandTotal61to90Days = 0; $grandTotalOver90Days = 0; @endphp

Payable Aging Report

{{ \Carbon\Carbon::parse($startDate)->format('d F Y') }} - {{ \Carbon\Carbon::parse($endDate)->format('d F Y') }}

@if (empty($agingReport ))

No trial balance data available for the selected period.

@else @foreach ($agingReport as $supplierName => $report) @foreach ($report['debts'] as $debt) @php // Use the 'umur' property set in the controller to determine the aging group $agingGroup = ''; if ($debt->umur == 0) { $agingGroup = '0'; } elseif ($debt->umur > 0 && $debt->umur <= 30) { $agingGroup = '1-30'; } elseif ($debt->umur > 30 && $debt->umur <= 60) { $agingGroup = '31-60'; } elseif ($debt->umur > 60 && $debt->umur <= 90) { $agingGroup = '61-90'; } else { $agingGroup = 'over_90'; } @endphp @endforeach @php // Accumulate the grand totals $grandTotalDebt += $report['total_amount_due']; @endphp @endforeach @if ($grandTotalDebt > 0) @endif

				Days
Invoice Number	Invoice Date	{{__('Due Date')}}	Total Due	0	1-30	31-60	61-90	> 90
{{ $supplierName }}
{{ $debt->document_number }}	{{ \Carbon\Carbon::parse($debt->document_date)->format('d M y') }}	{{ \Carbon\Carbon::parse($debt->due_date)->format('d-m-y') }}	{{ number_format($debt->debt_balance, 0) }}	@if($agingGroup == '0') {{ number_format($debt->debt_balance) }} @php $grandTotalNotYetDue += $debt->debt_balance; @endphp @else 0 @endif	@if($agingGroup == '1-30') {{ number_format($debt->debt_balance) }} @php $grandTotal1to30Days += $debt->debt_balance; @endphp @else 0 @endif	@if($agingGroup == '31-60') {{ number_format($debt->debt_balance) }} @php $grandTotal31to60Days += $debt->debt_balance; @endphp @else 0 @endif	@if($agingGroup == '61-90') {{ number_format($debt->debt_balance) }} @php $grandTotal61to90Days += $debt->debt_balance; @endphp @else 0 @endif	@if($agingGroup == 'over_90') {{ number_format($debt->debt_balance) }} @php $grandTotalOver90Days += $debt->debt_balance; @endphp @else 0 @endif
Total for {{ $supplierName }}			{{ number_format($report['total_amount_due']) }}	{{ number_format($report['aging']['0'], 0) }}	{{ number_format($report['aging']['1-30']) }}	{{ number_format($report['aging']['31-60']) }}	{{ number_format($report['aging']['61-90']) }}	{{ number_format($report['aging']['over_90']) }}
Grand Total			{{ number_format($grandTotalDebt, 0) }}	{{ number_format($grandTotalNotYetDue, 0) }}	{{ number_format($grandTotal1to30Days, 0) }}	{{ number_format($grandTotal31to60Days, 0) }}	{{ number_format($grandTotal61to90Days, 0) }}	{{ number_format($grandTotalOver90Days, 0) }}

@endif

Payable Aging Report

{{ $supplierName }}