@php $pdfLocale = app()->getLocale(); $isRtl = $pdfLocale === 'ar'; @endphp {{ __('pdf.customer_ledger') }} @php $priceFormat = $settings->price_format ?? null; function formatPrice($number, $decimals = 2, $priceFormat = null) { $number = (float) $number; $decimals = (int) $decimals; if (empty($priceFormat)) { return number_format($number, $decimals, '.', ','); } switch ($priceFormat) { case 'comma_dot': return number_format($number, $decimals, '.', ','); case 'dot_comma': return number_format($number, $decimals, ',', '.'); case 'space_comma': return number_format($number, $decimals, ',', ' '); default: return number_format($number, $decimals, '.', ','); } } $pdfCssPath = public_path('css/customer_ledger_pdf.css'); @endphp @if (is_file($pdfCssPath) && is_readable($pdfCssPath)) @endif @php function pillSale($status) { $s = strtolower(trim((string)$status)); if (preg_match('/\b(completed|approved|fulfilled|closed)\b/', $s)) return 'ledg-pill ledg-pill--success'; if (preg_match('/\b(pending|awaiting|on hold)\b/', $s)) return 'ledg-pill ledg-pill--warn'; if (preg_match('/\b(sent|shipped|in transit)\b/', $s)) return 'ledg-pill ledg-pill--info'; if (preg_match('/\b(canceled|cancelled|rejected|void)\b/', $s)) return 'ledg-pill ledg-pill--danger'; return 'ledg-pill'; } function pillPayment($status) { $s = strtolower(trim((string)$status)); if (preg_match('/\b(unpaid|not\s*paid|overdue|failed|due)\b/', $s)) return 'ledg-pill ledg-pill--danger'; if (preg_match('/\b(partial|partially\s*paid|part-?paid)\b/', $s)) return 'ledg-pill ledg-pill--warn'; if (preg_match('/\b(paid|settled|paid\s*in\s*full)\b/', $s)) return 'ledg-pill ledg-pill--success'; return 'ledg-pill'; } $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); }); $qsOpeningBalance = (float)($client->opening_balance ?? 0); $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 : ($qsOpeningBalance + $qsSaleDue - $qsReturnsDue); @endphp
{{ __('pdf.customer_ledger') }}
Generated at: {{ now()->format('Y-m-d H:i') }}
{{-- (Optional) Logo / Company Name --}}
{{ $client->name }}
Code: {{ $client->code ?? '-' }}
City: {{ $client->city ?? '-' }}, Country: {{ $client->country ?? '-' }}
Email: {{ $client->email ?? '-' }}
Phone: {{ $client->phone ?? '-' }}
Tax #: {{ $client->tax_number ?? '-' }}
{{ __('pdf.opening_balance') }}
{{ formatPrice($qsOpeningBalance, 2, $priceFormat) }}
Sales (Grand)
{{ formatPrice($qsSalesGrand, 2, $priceFormat) }}
Sales (Paid)
{{ formatPrice($qsSalesPaid, 2, $priceFormat) }}
Sales (Due)
{{ formatPrice($qsSaleDue, 2, $priceFormat) }}
Returns (Due)
{{ formatPrice($qsReturnsDue, 2, $priceFormat) }}
Payments (Total)
{{ formatPrice($qsPaymentsTot, 2, $priceFormat) }}
Quotations (Grand)
{{ formatPrice($qsQuotesGrand, 2, $priceFormat) }}
{{ __('pdf.net_balance') }}
{{ formatPrice($qsNetBalance, 2, $priceFormat) }}
@if($qsOpeningBalance != 0)

Opening Balance (Previous Dues)

{{ __('pdf.type') }} {{ __('pdf.description') }} {{ __('pdf.amount') }} {{ __('pdf.notes') }}
{{ __('pdf.opening_balance') }} Previous Dues (Before System Start) {{ formatPrice($qsOpeningBalance, 2, $priceFormat) }} {{ __('pdf.balance_carried_forward') }}
@endif

{{ __('pdf.sales') }}

@forelse ($sales as $s) @empty @endforelse
{{ __('pdf.date') }} {{ __('pdf.ref') }} {{ __('pdf.warehouse') }} {{ __('pdf.status') }} {{ __('pdf.grand_total') }} {{ __('pdf.paid') }} {{ __('pdf.due') }} {{ __('pdf.payment_status') }}
@php $dateFormat = $settings->date_format ?? 'YYYY-MM-DD'; $dateTime = \Carbon\Carbon::parse($s->date); $phpDateFormat = str_replace(['YYYY', 'MM', 'DD'], ['Y', 'm', 'd'], $dateFormat); $hasTime = strpos($s->date, ' ') !== false && preg_match('/\d{1,2}:\d{2}/', $s->date); if ($hasTime) { $formattedDate = $dateTime->format($phpDateFormat . ' H:i'); if (preg_match('/:\d{2}:\d{2}/', $s->date)) { $formattedDate = $dateTime->format($phpDateFormat . ' H:i:s'); } } else { $formattedDate = $dateTime->format($phpDateFormat); } @endphp {{$formattedDate}} {{ $s->Ref }} {{ optional($s->warehouse)->name }} {{ $s->statut }} {{ formatPrice($s->GrandTotal, 2, $priceFormat) }} {{ formatPrice($s->paid_amount, 2, $priceFormat) }} {{ formatPrice(($s->GrandTotal - $s->paid_amount), 2, $priceFormat) }} {{ $s->payment_statut }}
No sales found.
{{ __('pdf.totals') }} {{ formatPrice($salesGrandSum, 2, $priceFormat) }} {{ formatPrice($salesPaidSum, 2, $priceFormat) }} {{ formatPrice($salesDueSum, 2, $priceFormat) }}

{{ __('pdf.payments') }}

@forelse ($payments as $p) @empty @endforelse
{{ __('pdf.date') }} {{ __('pdf.payment_ref') }} {{ __('pdf.type') }} {{ __('pdf.sale_ref') }} {{ __('pdf.method') }} {{ __('pdf.amount') }}
@php $dateFormat = $settings->date_format ?? 'YYYY-MM-DD'; $dateTime = \Carbon\Carbon::parse($p->date); $phpDateFormat = str_replace(['YYYY', 'MM', 'DD'], ['Y', 'm', 'd'], $dateFormat); $hasTime = strpos($p->date, ' ') !== false && preg_match('/\d{1,2}:\d{2}/', $p->date); if ($hasTime) { $formattedDate = $dateTime->format($phpDateFormat . ' H:i'); if (preg_match('/:\d{2}:\d{2}/', $p->date)) { $formattedDate = $dateTime->format($phpDateFormat . ' H:i:s'); } } else { $formattedDate = $dateTime->format($phpDateFormat); } @endphp {{$formattedDate}} {{ $p->Ref }} @if(isset($p->payment_type) && $p->payment_type === 'opening_balance') {{ __('pdf.opening_balance') }} @else {{ __('pdf.sale') }} @endif {{ $p->Sale_Ref ?? '-' }} {{ $p->payment_method }} {{ formatPrice($p->montant, 2, $priceFormat) }}
No payments found.
Total Payments {{ formatPrice($paymentsSum, 2, $priceFormat) }}

{{ __('pdf.quotations') }}

@forelse ($quotations as $q) @empty @endforelse
{{ __('pdf.date') }} {{ __('pdf.ref') }} {{ __('pdf.status') }} {{ __('pdf.warehouse') }} {{ __('pdf.grand_total') }}
@php $dateFormat = $settings->date_format ?? 'YYYY-MM-DD'; $dateTime = \Carbon\Carbon::parse($q->date); $phpDateFormat = str_replace(['YYYY', 'MM', 'DD'], ['Y', 'm', 'd'], $dateFormat); $hasTime = strpos($q->date, ' ') !== false && preg_match('/\d{1,2}:\d{2}/', $q->date); if ($hasTime) { $formattedDate = $dateTime->format($phpDateFormat . ' H:i'); if (preg_match('/:\d{2}:\d{2}/', $q->date)) { $formattedDate = $dateTime->format($phpDateFormat . ' H:i:s'); } } else { $formattedDate = $dateTime->format($phpDateFormat); } @endphp {{$formattedDate}} {{ $q->Ref }} {{ $q->statut }} {{ optional($q->warehouse)->name }} {{ formatPrice($q->GrandTotal, 2, $priceFormat) }}
No quotations found.
{{ __('pdf.total_quotations') }} {{ formatPrice($quotesGrand, 2, $priceFormat) }}

{{ __('pdf.returns') }}

@forelse ($returns as $r) @empty @endforelse
{{ __('pdf.ref') }} {{ __('pdf.status') }} {{ __('pdf.sale_ref') }} {{ __('pdf.warehouse') }} {{ __('pdf.grand_total') }} {{ __('pdf.paid') }} {{ __('pdf.due') }} {{ __('pdf.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.
{{ __('pdf.totals') }} {{ formatPrice($retGrandSum, 2, $priceFormat) }} {{ formatPrice($retPaidSum, 2, $priceFormat) }} {{ formatPrice($retDueSum, 2, $priceFormat) }}