@php $totalAmount = 0; $totalPaid = 0; $totalUnpaid = 0; $sl = 1; @endphp @forelse($orders as $order) @php $totalAmount += $order->total_amount; // "advance" = partial payment already collected $advance = (float)($order->advance_amount ?? 0); if ($order->payment_status === 'paid') { $paidAmt = $order->total_amount; $unpaidAmt = 0; } elseif ($advance > 0) { $paidAmt = $advance; $unpaidAmt = $order->total_amount - $advance; } else { $paidAmt = 0; $unpaidAmt = $order->total_amount; } $totalPaid += $paidAmt; $totalUnpaid += $unpaidAmt; $rowClass = ($sl % 2 === 0) ? 'row-even' : 'row-odd'; @endphp @empty @endforelse @if($orders->count() > 0) @endif

#	Order #	Customer	Phone	Items	Total (৳)	Paid (৳)	Unpaid (৳)	Order Status	Payment	Date
{{ $sl++ }}	{{ $order->order_number }}	{{ $order->customer_name }}	{{ $order->phone }}	@foreach($order->items as $item) {{ $item->product_name ?? ($item->product->name ?? 'N/A') }} ×{{ $item->quantity }} @endforeach	{{ number_format($order->total_amount, 0) }}	@if($paidAmt > 0) {{ number_format($paidAmt, 0) }} @else — @endif	@if($unpaidAmt > 0) {{ number_format($unpaidAmt, 0) }} @else ✓ Clear @endif	{{ ucfirst($order->status) }}	{{ ucwords(str_replace('_', ' ', $order->payment_status)) }} @if($order->payment_method) {{ strtoupper($order->payment_method) }} @endif	{{ $order->created_at->format('d/m/Y') }}
No orders found.
Total Summary ({{ $orders->count() }} orders):					৳{{ number_format($totalAmount, 0) }}	৳{{ number_format($totalPaid, 0) }}	৳{{ number_format($totalUnpaid, 0) }}