@extends('admin.layouts.app')
@section('title', 'Product Report')
@section('content')
<div class="card" style="margin-bottom:20px;">
    <h3 style="margin-bottom:14px;">Best Selling Products</h3>
    <table>
        <thead><tr><th>Product</th><th>Qty Sold</th><th>Revenue</th></tr></thead>
        <tbody>
        @foreach($bestSelling as $b)
            <tr><td>{{ $b->product->name ?? '—' }}</td><td>{{ $b->total_qty }}</td><td>{{ $siteSettings['currency'] }}{{ number_format($b->total_revenue,2) }}</td></tr>
        @endforeach
        </tbody>
    </table>
</div>
<div class="grid-2">
    <div class="card">
        <h3 style="margin-bottom:14px;">Low Stock</h3>
        @foreach($lowStock as $p)<div style="padding:6px 0;">{{ $p->name }} — <span class="badge badge-yellow">{{ $p->stock_quantity }}</span></div>@endforeach
    </div>
    <div class="card">
        <h3 style="margin-bottom:14px;">Out of Stock</h3>
        @foreach($outOfStock as $p)<div style="padding:6px 0;">{{ $p->name }} — <span class="badge badge-red">0</span></div>@endforeach
    </div>
</div>
@endsection