@extends('admin.layouts.master')
@section('title', 'أكثر المنتجات مبيعاً')

@section('content')
<div class="page-content-wrapper"><div class="content-container"><div class="page-content">

    <div class="content-header d-flex justify-content-between align-items-center mb-3">
        <h4 class="mb-0"><i class="ti ti-trophy me-2 text-warning"></i>أكثر المنتجات مبيعاً</h4>
        <a href="{{ route('admin.reports.index') }}" class="btn btn-outline-secondary btn-sm">
            <i class="ti ti-arrow-right me-1"></i> التقارير
        </a>
    </div>

    {{-- Filters --}}
    <div class="card mb-3 border-0 shadow-sm">
        <div class="card-body">
            <div class="row g-3 align-items-end">
                <div class="col-md-3">
                    <label class="form-label">من تاريخ</label>
                    <input type="date" id="f-from" class="form-control" value="{{ $from?->format('Y-m-d') }}">
                </div>
                <div class="col-md-3">
                    <label class="form-label">إلى تاريخ</label>
                    <input type="date" id="f-to" class="form-control" value="{{ $to?->format('Y-m-d') }}">
                </div>
                <div class="col-md-3">
                    <label class="form-label">المخزن</label>
                    <select id="f-warehouse" class="form-select">
                        <option value="">الكل</option>
                        @foreach($warehouses as $w)
                            <option value="{{ $w->id }}" {{ $warehouseId == $w->id ? 'selected' : '' }}>{{ $w->name }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-3">
                    <button id="btn-filter" class="btn btn-primary w-100">
                        <i class="ti ti-filter me-1"></i> تصفية
                    </button>
                </div>
            </div>
        </div>
    </div>

    {{-- Table --}}
    <div class="card border-0 shadow-sm">
        <div class="card-body">
            <table id="report-table" class="table table-bordered table-hover w-100">
                <thead class="table-light">
                    <tr>
                        <th>المنتج</th>
                        <th>الرمز (SKU)</th>
                        <th>الكمية المباعة</th>
                        <th>الإيرادات</th>
                        <th>التكلفة</th>
                        <th>الربح</th>
                        <th>عدد الفواتير</th>
                    </tr>
                </thead>
            </table>
        </div>
    </div>

</div></div></div>
@endsection

@push('scripts')
<script>
$(function () {
    const table = $('#report-table').DataTable({
        processing: true, serverSide: true, responsive: true,
        language: { url: 'https://cdn.datatables.net/plug-ins/1.13.8/i18n/ar.json' },
        ajax: {
            url: '{{ route('admin.reports.top-products') }}',
            data: d => {
                d.date_from    = $('#f-from').val();
                d.date_to      = $('#f-to').val();
                d.warehouse_id = $('#f-warehouse').val();
            }
        },
        order: [[3, 'desc']],
        columns: [
            { data: 'product' },
            { data: 'sku' },
            { data: 'sold_qty',      className: 'text-end' },
            { data: 'revenue',       className: 'text-end' },
            { data: 'cost',          className: 'text-end' },
            { data: 'profit',        className: 'text-end' },
            { data: 'invoice_count', className: 'text-center' },
        ]
    });
    $('#btn-filter').on('click', () => table.ajax.reload());
});
</script>
@endpush