@if($orders->count() > 0)
| Order ID |
Date |
Customer |
Order Total |
Revenue |
COGS |
Profit |
Margin % |
Status |
@foreach($orders as $order)
|
#{{ $order['order_id'] }}
|
{{ \Carbon\Carbon::parse($order['date'])->format('M d, Y') }}
|
{{ $order['customer'] }}
|
₹{{ number_format($order['total_payable'], 2) }}
|
₹{{ number_format($order['revenue'], 2) }}
|
₹{{ number_format($order['cogs'], 2) }}
|
₹{{ number_format($order['profit'], 2) }}
|
{{ number_format($order['margin_percent'], 1) }}%
|
@php
$statusColors = [
'delivered' => 'success',
'shipped' => 'info',
'confirmed' => 'warning',
'placed' => 'secondary',
'cancelled' => 'danger'
];
$statusColor = $statusColors[$order['status']] ?? 'secondary';
@endphp
{{ ucfirst($order['status']) }}
|
@endforeach
| TOTALS |
₹{{ number_format($orders->sum('total_payable'), 2) }} |
₹{{ number_format($orders->sum('revenue'), 2) }} |
₹{{ number_format($orders->sum('cogs'), 2) }} |
₹{{ number_format($orders->sum('profit'), 2) }}
|
@php
$totalRevenue = $orders->sum('revenue');
$totalProfit = $orders->sum('profit');
$overallMargin = $totalRevenue > 0 ? ($totalProfit / $totalRevenue) * 100 : 0;
@endphp
{{ number_format($overallMargin, 1) }}%
|
|
{{ $orders->count() }}
Total Orders
{{ $orders->where('profit', '>', 0)->count() }}
Profitable Orders
{{ $orders->where('profit', '<', 0)->count() }}
Loss-making Orders
@php
$avgProfit = $orders->count() > 0 ? $orders->sum('profit') / $orders->count() : 0;
@endphp
₹{{ number_format($avgProfit, 2) }}
Avg. Profit per Order
@else
No Orders Found
No orders found for the selected criteria.
@endif