@php function formatNumber($number) { // Check if the number has a decimal part if (floor($number) == $number) { // If it's a whole number, format without decimals return number_format($number, 0); } else { // If it has a decimal part, format with 2 decimal places return number_format($number, 2); } } @endphp

Receivable Report

Date: {{ \Carbon\Carbon::now()->format('d F Y') }}

@if (empty($customers ))

No trial balance data available for the selected period.

@else @php $grandTotalDebt = 0; $grandTotalDebtBalance = 0; @endphp @foreach ($customers as $total) @if ($total['debt_balance'] > 0) @foreach ($total->receivables as $rei) @endforeach @php $grandTotalDebt += $total['total_debt']; $grandTotalDebtBalance += $total['debt_balance']; @endphp @endif @endforeach @if ($grandTotalDebtBalance > 0) @endif

Document Number	{{__('Document Date')}}	{{__('Due Date')}}	Total Debt	Debt Balance	Age (Days)
{{ $total['customer_name'] }}
{{ $rei->document_number }}	{{ \Carbon\Carbon::parse($rei->document_date)->format('d-M-Y') }}	{{ \Carbon\Carbon::parse($rei->due_date)->format('d-M-Y') }}	{{ $rei->total_debt == 0 ? formatNumber($rei->total_debt) : formatNumber($rei->total_debt) }}	{{ $rei->debt_balance == 0 ? formatNumber($rei->debt_balance) : formatNumber($rei->debt_balance) }}	{{ $rei->umur }}
Total for {{ $total['customer_name'] }}			{{ formatNumber($total['total_debt'], 2) }}	{{ formatNumber($total['debt_balance'], 2) }}
Grand Total			{{ formatNumber($grandTotalDebt, 2) }}	{{ formatNumber($grandTotalDebtBalance, 2) }}

@endif

Receivable Report

{{ $total['customer_name'] }}