Payment Report

@php $totalRevenue = 0; $totalNet = 0; $totalTax = 0; @endphp @foreach($orders as $order) @php $orderTax = 0; if ($order->items) { foreach ($order->items as $item) { $storedTax = (float) $item->tax_amount; if ($storedTax > 0) { $orderTax += $storedTax; } else { $rate = $item->product ? ($item->product->tax_code ?? 18) : 18; $itemTotal = $item->price * $item->quantity; $taxComponent = $itemTotal * ($rate / (100 + $rate)); $orderTax += $taxComponent; } } } $orderNet = $order->total_amount - $orderTax; if ($order->payment_status == 'paid') { $totalRevenue += $order->total_amount; $totalNet += $orderNet; $totalTax += $orderTax; } @endphp @endforeach

Order No	Customer	Method	Status	Date	Net Revenue	Tax	Total Amount
{{ $order->order_number }}	{{ $order->user ? $order->user->name : ($order->name ?: 'Guest') }}	{{ str_replace('_', ' ', $order->payment_method ?: 'N/A') }}	{{ strtoupper($order->payment_status) }}	{{ $order->created_at->format('Y-m-d') }}	₹{{ number_format($orderNet, 2) }}	₹{{ number_format($orderTax, 2) }}	₹{{ number_format($order->total_amount, 2) }}
Total (Paid Only)					₹{{ number_format($totalNet, 2) }}	₹{{ number_format($totalTax, 2) }}	₹{{ number_format($totalRevenue, 2) }}