Customer Ledger

@php // ---------- Helper: status badges (order/workflow) ---------- function pillSale($status) { $s = strtolower(trim((string)$status)); if (preg_match('/\b(completed|approved|fulfilled|closed)\b/', $s)) return 'pill success'; if (preg_match('/\b(pending|awaiting|on hold)\b/', $s)) return 'pill warn'; if (preg_match('/\b(sent|shipped|in transit)\b/', $s)) return 'pill info'; if (preg_match('/\b(canceled|cancelled|rejected|void)\b/', $s))return 'pill danger'; return 'pill'; } // ---------- Helper: payment badges (avoid "unpaid" -> "paid") ---------- function pillPayment($status) { $s = strtolower(trim((string)$status)); if (preg_match('/\b(unpaid|not\s*paid|overdue|failed|due)\b/', $s)) return 'pill danger'; if (preg_match('/\b(partial|partially\s*paid|part-?paid)\b/', $s)) return 'pill warn'; if (preg_match('/\b(paid|settled|paid\s*in\s*full)\b/', $s)) return 'pill success'; return 'pill'; } // ---------- Section totals ---------- $salesGrandSum = $sales->sum('GrandTotal'); $salesPaidSum = $sales->sum('paid_amount'); $salesDueSum = $sales->sum(function($s){ return (float)($s->GrandTotal ?? 0) - (float)($s->paid_amount ?? 0); }); $paymentsSum = $payments->sum('montant'); $quotesGrand = $quotations->sum('GrandTotal'); $retGrandSum = $returns->sum('GrandTotal'); $retPaidSum = $returns->sum('paid_amount'); $retDueSum = $returns->sum(function($r){ return (float)($r->GrandTotal ?? 0) - (float)($r->paid_amount ?? 0); }); // ---------- Safe fallbacks for quick stats ---------- $qsSalesGrand = (float)($client->salesGrand ?? $salesGrandSum); $qsSalesPaid = (float)($client->salesPaid ?? $salesPaidSum); $qsSaleDue = (float)($client->sale_due ?? ($qsSalesGrand - $qsSalesPaid)); $qsReturnsDue = (float)($client->return_due ?? $retDueSum); $qsPaymentsTot = (float)($client->paymentsTotal ?? $paymentsSum); $qsQuotesGrand = (float)($client->quotationsTotal ?? $quotesGrand); $qsNetBalance = isset($client->netBalance) ? (float)$client->netBalance : ($qsSaleDue - $qsReturnsDue); @endphp

Customer Ledger

Generated at: {{ now()->format('Y-m-d H:i') }}

{{ $client->name }}
Code: {{ $client->code ?? '-' }}
City: {{ $client->city ?? '-' }}, Country: {{ $client->country ?? '-' }}

Email: {{ $client->email ?? '-' }}
Phone: {{ $client->phone ?? '-' }}
Tax #: {{ $client->tax_number ?? '-' }}

Sales (Grand)

Sales (Paid)

Sales (Due)

Returns (Due)

Payments (Total)

Quotations (Grand)

Net Balance

Sales

@forelse ($sales as $s) @empty @endforelse

Date	Ref	Warehouse	Status	Grand Total	Paid	Due	Payment Status
{{ $s->date }}	{{ $s->Ref }}	{{ optional($s->warehouse)->name }}	{{ $s->statut }}	{{ number_format($s->GrandTotal, 2) }}	{{ number_format($s->paid_amount, 2) }}	{{ number_format(($s->GrandTotal - $s->paid_amount), 2) }}	{{ $s->payment_statut }}
No sales found.
Totals				{{ number_format($salesGrandSum, 2) }}	{{ number_format($salesPaidSum, 2) }}	{{ number_format($salesDueSum, 2) }}

Payments

@forelse ($payments as $p) @empty @endforelse

Date	Payment Ref	Sale Ref	Method	Amount
{{ $p->date }}	{{ $p->Ref }}	{{ $p->Sale_Ref }}	{{ $p->payment_method }}	{{ number_format($p->montant, 2) }}
No payments found.
Total Payments				{{ number_format($paymentsSum, 2) }}

Quotations

@forelse ($quotations as $q) @empty @endforelse

Date	Ref	Status	Warehouse	Grand Total
{{ $q->date }}	{{ $q->Ref }}	{{ $q->statut }}	{{ optional($q->warehouse)->name }}	{{ number_format($q->GrandTotal, 2) }}
No quotations found.
Total Quotations				{{ number_format($quotesGrand, 2) }}

Returns

@forelse ($returns as $r) @empty @endforelse

Ref	Status	Sale Ref	Warehouse	Grand Total	Paid	Due	Payment Status
{{ $r->Ref }}	{{ $r->statut }}	{{ optional($r->sale)->Ref ?? '---' }}	{{ optional($r->warehouse)->name }}	{{ number_format($r->GrandTotal, 2) }}	{{ number_format($r->paid_amount, 2) }}	{{ number_format(($r->GrandTotal - $r->paid_amount), 2) }}	{{ $r->payment_statut }}
No returns found.
Totals				{{ number_format($retGrandSum, 2) }}	{{ number_format($retPaidSum, 2) }}	{{ number_format($retDueSum, 2) }}