@extends('layouts.app')

@section('title', 'Products Report - Admin')

@section('content')
<div class="container-fluid px-4">
    <div class="d-flex flex-wrap align-items-center justify-content-between mb-4">
        <div>
            <h1 class="h3 mb-1 fw-700">Products Report</h1>
            <p class="text-muted small mb-0">Product performance, stock, and conversion analysis</p>
        </div>
        <a href="{{ route('admin.reports.export', ['type' => 'products'] + request()->query()) }}" class="btn btn-sm btn-success">
            <i class="fas fa-file-export me-1"></i> Export CSV
        </a>
    </div>

    @include('admin.reports.partials.nav')
    @include('admin.reports.partials.period-filter', ['from' => $from, 'to' => $to])

    {{-- Summary Cards --}}
    <div class="row g-3 mb-4">
        <div class="col-xl-3 col-lg-6 col-md-6">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-body">
                    <p class="text-muted mb-1 small fw-600 text-uppercase">Total Products Sold</p>
                    <h4 class="mb-0 fw-700 text-primary">{{ number_format(collect($byType)->sum('total_units')) }}</h4>
                </div>
            </div>
        </div>
        <div class="col-xl-3 col-lg-6 col-md-6">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-body">
                    <p class="text-muted mb-1 small fw-600 text-uppercase">Product Revenue</p>
                    <h4 class="mb-0 fw-700 text-success">{{ number_format((float) collect($byType)->sum('total_revenue'), 2) }}</h4>
                </div>
            </div>
        </div>
        <div class="col-xl-3 col-lg-6 col-md-6">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-body">
                    <p class="text-muted mb-1 small fw-600 text-uppercase">Low Stock</p>
                    <h4 class="mb-0 fw-700 text-warning">{{ number_format($lowStock->count()) }}</h4>
                </div>
            </div>
        </div>
        <div class="col-xl-3 col-lg-6 col-md-6">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-body">
                    <p class="text-muted mb-1 small fw-600 text-uppercase">Out of Stock</p>
                    <h4 class="mb-0 fw-700 text-danger">{{ number_format($outOfStock) }}</h4>
                </div>
            </div>
        </div>
    </div>

    {{-- Top Products Table --}}
    <div class="card border-0 shadow-sm mb-4">
        <div class="card-header bg-white border-0 py-3">
            <h6 class="fw-700 mb-0"><i class="fas fa-crown text-primary me-2"></i>Top Selling Products</h6>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover align-middle mb-0">
                    <thead class="bg-light">
                        <tr>
                            <th>#</th>
                            <th>Product</th>
                            <th class="text-end">Units Sold</th>
                            <th class="text-end">Revenue</th>
                            <th class="text-end">Avg Price</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($topProducts as $index => $product)
                            <tr>
                                <td class="fw-600">{{ $index + 1 }}</td>
                                <td>
                                    <a href="{{ route('admin.products.show', $product->product_id) }}" class="text-decoration-none fw-600">
                                        {{ $product->product_title ?? 'Unknown' }}
                                    </a>
                                </td>
                                <td class="text-end">{{ number_format($product->units) }}</td>
                                <td class="text-end fw-700">{{ number_format((float) $product->revenue, 2) }}</td>
                                <td class="text-end">{{ number_format((float) $product->avg_price, 2) }}</td>
                            </tr>
                        @empty
                            <tr><td colspan="5" class="text-center text-muted py-4">No products sold in this period</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    {{-- Stock Alerts & Category Performance --}}
    <div class="row g-4 mb-4">
        <div class="col-lg-6">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-header bg-white border-0 py-3">
                    <h6 class="fw-700 mb-0"><i class="fas fa-exclamation-triangle text-warning me-2"></i>Low Stock Products</h6>
                </div>
                <div class="card-body p-0">
                    <div class="table-responsive" style="max-height:400px;overflow-y:auto;">
                        <table class="table table-hover table-sm align-middle mb-0">
                            <thead class="bg-light sticky-top">
                                <tr>
                                    <th>Product</th>
                                    <th class="text-end">Stock</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($lowStock as $product)
                                    <tr>
                                        <td class="text-truncate" style="max-width:250px;">{{ $product->slug }}</td>
                                        <td class="text-end">
                                            <span class="badge bg-warning text-dark">{{ $product->stock }}</span>
                                        </td>
                                    </tr>
                                @empty
                                    <tr><td colspan="2" class="text-center text-muted py-3">No low stock products</td></tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-lg-6">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-header bg-white border-0 py-3">
                    <h6 class="fw-700 mb-0"><i class="fas fa-tags text-primary me-2"></i>Category Performance</h6>
                </div>
                <div class="card-body p-0">
                    <div class="table-responsive" style="max-height:400px;overflow-y:auto;">
                        <table class="table table-hover table-sm align-middle mb-0">
                            <thead class="bg-light sticky-top">
                                <tr>
                                    <th>Category</th>
                                    <th class="text-end">Orders</th>
                                    <th class="text-end">Revenue</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($categoryPerformance as $category)
                                    <tr>
                                        <td class="fw-600">{{ $category->category_name }}</td>
                                        <td class="text-end">{{ number_format($category->total_orders) }}</td>
                                        <td class="text-end fw-700">{{ number_format((float) $category->total_revenue, 2) }}</td>
                                    </tr>
                                @empty
                                    <tr><td colspan="3" class="text-center text-muted py-3">No category data</td></tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@push('styles')
<style>
    .fw-600 { font-weight: 600; }
    .fw-700 { font-weight: 700; }
</style>
@endpush