@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

Payable Report

@if (empty($suppliers ))

No trial balance data available for the selected period.

@else @php $grandTotalDebt = 0; $grandTotalDebtBalance = 0; @endphp @foreach ($suppliers as $total) @if ($total['debt_balance'] > 0) @foreach ($total->debts as $debt) @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['supplier_name'] }}
{{ $debt->document_number }}	{{ \Carbon\Carbon::parse($debt->document_date)->format('d-M-Y') }}	{{ \Carbon\Carbon::parse($debt->due_date)->format('d-M-Y') }}	{{ $debt->total_debt == 0 ? formatNumber($debt->total_debt) : formatNumber($debt->total_debt) }}	{{ $debt->debt_balance == 0 ? formatNumber($debt->debt_balance) : formatNumber($debt->debt_balance) }}	{{ $debt->umur }}
Total for {{ $total['supplier_name'] }}			{{ formatNumber($total['total_debt'], 2) }}	{{ formatNumber($total['debt_balance'], 2) }}
Grand Total			{{ formatNumber($grandTotalDebt, 2) }}	{{ formatNumber($grandTotalDebtBalance, 2) }}

@endif

Payable Report

{{ $total['supplier_name'] }}