@extends('layouts.app')
@section('title', 'Product Reports')

@section('content')
<div class="card p-3 mb-3">
    <form method="GET" class="row g-2 align-items-end">
        <div class="col-12 col-md-3">
            <label class="form-label small mb-1">Report</label>
            <select name="report" class="form-select form-select-sm" onchange="this.form.submit()">
                <option value="stock" @selected($report==='stock')>Product Stock</option>
                <option value="sales" @selected($report==='sales')>Sales (date range)</option>
                <option value="out_of_stock" @selected($report==='out_of_stock')>Out of Stock</option>
                <option value="top_sold" @selected($report==='top_sold')>Top Sold</option>
            </select>
        </div>
        @if($report==='sales')
            <div class="col-6 col-md-3"><label class="form-label small mb-1">From</label><input type="date" name="from" value="{{ $from }}" class="form-control form-control-sm"></div>
            <div class="col-6 col-md-3"><label class="form-label small mb-1">To</label><input type="date" name="to" value="{{ $to }}" class="form-control form-control-sm"></div>
        @endif
        <div class="col-12 col-md-2"><button class="btn btn-sm btn-dark"><i class="bi bi-funnel"></i> Run</button></div>
    </form>
</div>

@if($report==='sales' && $salesSummary)
<div class="row g-3 mb-3">
    <div class="col-6 col-lg-3"><div class="card p-3"><div class="text-muted small">Invoices</div><h4 class="mb-0">{{ $salesSummary->invoices }}</h4></div></div>
    <div class="col-6 col-lg-3"><div class="card p-3"><div class="text-muted small">Subtotal</div><h4 class="mb-0">{{ number_format($salesSummary->subtotal, 2) }}</h4></div></div>
    <div class="col-6 col-lg-3"><div class="card p-3"><div class="text-muted small">Discount</div><h4 class="mb-0 text-warning">{{ number_format($salesSummary->discount, 2) }}</h4></div></div>
    <div class="col-6 col-lg-3"><div class="card p-3"><div class="text-muted small">Grand Total</div><h4 class="mb-0 text-success">{{ number_format($salesSummary->grand, 2) }}</h4></div></div>
</div>
@endif

<div class="card p-0">
    <div class="table-responsive">
    <table class="table table-sm mb-0 align-middle">
        @if($report==='sales')
            <thead><tr><th>Invoice</th><th>Date</th><th>Items</th><th>Subtotal</th><th>Discount</th><th>Grand Total</th></tr></thead>
            <tbody>
            @forelse($rows as $s)
                <tr>
                    <td><a href="{{ route('product-sales.show', $s) }}">{{ $s->invoice_number }}</a></td>
                    <td>{{ $s->sale_date->format('d M Y') }}</td>
                    <td>{{ $s->items->count() }}</td>
                    <td>{{ number_format($s->subtotal, 2) }}</td>
                    <td>{{ number_format($s->discount_amount, 2) }}</td>
                    <td class="fw-bold">{{ number_format($s->grand_total, 2) }}</td>
                </tr>
            @empty
                <tr><td colspan="6" class="text-center text-muted py-3">No sales in this range.</td></tr>
            @endforelse
            </tbody>
        @elseif($report==='top_sold')
            <thead><tr><th>Product</th><th>Category</th><th>Total Sold</th><th>Current Stock</th></tr></thead>
            <tbody>
            @forelse($rows as $p)
                <tr><td>{{ $p->name }}</td><td>{{ $p->category->name ?? '—' }}</td><td>{{ (int) ($p->total_sold ?? 0) }}</td><td>{{ $p->quantity_stock }}</td></tr>
            @empty
                <tr><td colspan="4" class="text-center text-muted py-3">No products.</td></tr>
            @endforelse
            </tbody>
        @else {{-- stock / out_of_stock --}}
            <thead><tr><th>Product</th><th>Category</th><th>Sale Price</th><th>Stock</th>@if($report==='stock')<th>Total Sold</th>@endif<th>Status</th></tr></thead>
            <tbody>
            @forelse($rows as $p)
                <tr>
                    <td>{{ $p->name }}</td>
                    <td>{{ $p->category->name ?? '—' }}</td>
                    <td>{{ number_format($p->sale_price, 2) }}</td>
                    <td>{{ $p->quantity_stock }}</td>
                    @if($report==='stock')<td>{{ (int) ($p->total_sold ?? 0) }}</td>@endif
                    <td>@if($p->isOutOfStock())<span class="badge bg-danger">Out</span>@elseif($p->isLowStock())<span class="badge bg-warning text-dark">Low</span>@else<span class="badge bg-success">OK</span>@endif</td>
                </tr>
            @empty
                <tr><td colspan="6" class="text-center text-muted py-3">No products.</td></tr>
            @endforelse
            </tbody>
        @endif
    </table>
    </div>
</div>
<div class="mt-2 text-muted small">Total records: {{ $rows->count() }}</div>
@endsection