@push('title')
    Product Analytics
@endpush

<x-app-layout>
    <div class="row mb-4">
        <div class="col-12">
            <div class="card">
                <div class="card-header d-flex justify-content-between align-items-center">
                    <h5 class="mb-0">Product Performance Analytics</h5>
                </div>
                <div class="card-body">
                    <form action="{{ route('reports.product_analytics') }}" method="GET" class="row g-3">
                        <div class="col-md-3">
                            <label class="form-label">Start Date</label>
                            <input type="date" name="start_date" class="form-control" value="{{ $startDate }}">
                        </div>
                        <div class="col-md-3">
                            <label class="form-label">End Date</label>
                            <input type="date" name="end_date" class="form-control" value="{{ $endDate }}">
                        </div>
                        <div class="col-md-3">
                            <label class="form-label">Warehouse</label>
                            <select name="warehouse_id" class="form-select">
                                <option value="">All Warehouses</option>
                                @foreach($warehouses as $warehouse)
                                    <option value="{{ $warehouse->id }}" {{ request('warehouse_id') == $warehouse->id ? 'selected' : '' }}>
                                        {{ $warehouse->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-3 d-flex align-items-end">
                            <button type="submit" class="btn btn-primary me-2 w-100">Analyze</button>
                            <a href="{{ route('reports.product_analytics') }}" class="btn btn-label-secondary w-100">Reset</a>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    <!-- Analytics Table -->
    <div class="card mt-4">
        <div class="card-header">
            <h5 class="mb-0">Product Sales Performance</h5>
        </div>
        <div class="table-responsive text-nowrap">
            <table class="table table-striped table-borderless">
                <thead class="table-dark">
                    <tr>
                        <th>Product Details</th>
                        <th class="text-center">Total Sold</th>
                        <th class="text-end">Revenue</th>
                        <th class="text-end">Estimated Profit</th>
                        <th class="text-end">Profit Margin</th>
                    </tr>
                </thead>
                <tbody class="table-border-bottom-0">
                    @forelse($analytics as $item)
                        <tr>
                            <td>
                                <div class="d-flex flex-column">
                                    <span class="fw-bold text-heading">{{ $item->product_name }}</span>
                                    <small class="text-muted">{{ $item->product_code }} 
                                        @if($item->variation_name)
                                            | <span class="bg-label-info badge">{{ $item->variation_name }}</span>
                                        @endif
                                    </small>
                                </div>
                            </td>
                            <td class="text-center">
                                <span class="badge bg-label-secondary rounded-pill fw-bold">{{ number_format($item->total_qty) }}</span>
                            </td>
                            <td class="text-end fw-medium">{{ number_format($item->total_revenue, 2) }}</td>
                            <td class="text-end text-success fw-bold">{{ number_format($item->total_profit, 2) }}</td>
                            <td class="text-end">
                                <span class="text-{{ $item->total_revenue > 0 && ($item->total_profit / $item->total_revenue) > 0.2 ? 'success' : 'warning' }}">
                                    @if($item->total_revenue > 0)
                                        {{ number_format(($item->total_profit / $item->total_revenue) * 100, 1) }}%
                                    @else
                                        0%
                                    @endif
                                </span>
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="5" class="text-center py-4 text-muted">No sales data found for the selected period.</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
        <div class="card-footer py-3">
            {{ $analytics->links() }}
        </div>
    </div>
</x-app-layout>