GROCERY ORDERS REPORT

Vendor: {{ $vendor_name ?? 'N/A' }}

From: {{ $from_date }} To: {{ $to_date }}

@if(count($orders) > 0) @foreach($orders as $index => $order) @endforeach @else @endif

Sl No	Order Code	Order Date	Customer Name	Customer Email	Customer Mobile	Subtotal	Discount	Delivery Fee	Tax	Total Amount	Earnings	Commission	Payment Status	Payment Type
{{ $index + 1 }}	{{ $order->order_code ?? 'N/A' }}	{{ $order->created_at ? date('d-m-Y H:i', strtotime($order->created_at)) : 'N/A' }}	{{ $order->user_name ?? 'N/A' }}	{{ $order->user_email ?? 'N/A' }}	{{ ($order->country_code ?? '') . ($order->user_mobile ?? 'N/A') }}	{{ number_format($order->subtotal ?? 0, 2) }}	{{ number_format($order->discount ?? 0, 2) }}	{{ number_format($order->delivery_fee ?? 0, 2) }}	{{ number_format($order->tax ?? 0, 2) }}	{{ number_format($order->total ?? 0, 2) }}	{{ number_format($order->earnings_total ?? 0, 2) }}	{{ number_format($order->commission_amount ?? 0, 2) }}	@if($order->payment_status == 1) Pending @elseif($order->payment_status == 2) Paid @elseif($order->payment_status == 3) Failed @elseif($order->payment_status == 4) Refunded @else Unknown @endif	@if($order->payment_type == '1') Cash @elseif($order->payment_type == '2') Online @else N/A @endif
No orders found for the selected date range

@if(count($orders) > 0)

Total Orders: {{ count($orders) }}

Total Sales Amount: {{ number_format($orders->sum('total'), 2) }}

Total Earnings (After Commission): {{ number_format($orders->sum('earnings_total'), 2) }}

Total Commission: {{ number_format($orders->sum('commission_amount'), 2) }}

@endif