@php $totalRevenue = 0; $totalNet = 0; $totalTax = 0; @endphp @forelse($orders as $order) @php $orderTax = 0; // Calculate tax based on items if($order->items) { foreach($order->items as $item) { $storedTax = (float) $item->tax_amount; // Debugging: ensure we are capturing the value // dump($item->id, $storedTax); if ($storedTax > 0) { $orderTax += $storedTax; } else { // Fallback $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 @empty @endforelse @if($orders->count() > 0) @endif

Order No.	Customer	Method	Status	Txn Ref	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->payment_id ?: 'NO_REF' }}	{{ $order->created_at->format('M d, Y') }}	₹{{ number_format($orderNet, 2) }}	₹{{ number_format($orderTax, 2) }}	₹{{ number_format($order->total_amount, 2) }}
No financial records found.
Totals (Paid Only)						₹{{ number_format($totalNet, 2) }}	₹{{ number_format($totalTax, 2) }}	₹{{ number_format($totalRevenue, 2) }}