@extends('dashboard.layouts.app')

@section('title', __('dashboard.Product Sales Statistics'))
@section('page_heading', __('dashboard.Product Sales Statistics'))

@section('breadcrumb')
<li class="breadcrumb-item text-muted">
    <a href="{{ route('dashboard.home') }}" class="text-muted text-hover-primary">{{ __('dashboard.Home') }}</a>
</li>
<li class="breadcrumb-item text-muted">
    <a href="{{ route('dashboard.statistics.index') }}"
        class="text-muted text-hover-primary">{{ __('dashboard.Statistics') }}</a>
</li>
<li class="breadcrumb-item text-muted">{{ __('dashboard.Product Sales') }}</li>
@endsection

@section('content')
<div class="card">
    <div class="card-header">
        <h3 class="card-title">{{ __('dashboard.Product Sales Statistics') }}</h3>
        <div class="card-toolbar">
            <form action="{{ route('dashboard.statistics.product_sales.export') }}" method="POST">
                @csrf
                <input type="hidden" name="category_id" value="{{ $selectedCategoryId }}">
                <input type="hidden" name="start_date" value="{{ $startDate->toDateString() }}">
                <input type="hidden" name="end_date" value="{{ $endDate->toDateString() }}">
                <input type="hidden" name="range" value="{{ $range }}">
                <button type="submit" class="btn btn-sm btn-light-primary">
                    <i class="bi bi-file-earmark-excel-fill fs-2"></i>
                    {{ __('dashboard.Export') }}
                </button>
            </form>
        </div>
    </div>
    <div class="card-body">
        <form action="{{ route('dashboard.statistics.product_sales') }}" method="GET">
            <div class="row mb-5">
                <div class="col-md-3">
                    <label class="form-label">{{ __('dashboard.Select Category') }}</label>
                    <select name="category_id" class="form-select" onchange="this.form.submit()">
                        <option value="">{{ __('dashboard.All Categories') }}</option>
                        @foreach ($categories as $category)
                        <option value="{{ $category->id }}" {{ $selectedCategoryId==$category->id ? 'selected' : ''
                            }}>
                            {{ $category->name }}
                        </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-3">
                    <label class="form-label">{{ __('dashboard.Select Range') }}</label>
                    <select name="range" id="range" class="form-select" onchange="this.form.submit()">
                        <option value="last_week" {{ $range=='last_week' ? 'selected' : '' }}>
                            {{ __('dashboard.Last Week') }}</option>
                        <option value="last_month" {{ $range=='last_month' ? 'selected' : '' }}>
                            {{ __('dashboard.Last Month') }}</option>
                        <option value="last_3_months" {{ $range=='last_3_months' ? 'selected' : '' }}>
                            {{ __('dashboard.Last 3 Months') }}</option>
                        <option value="last_6_months" {{ $range=='last_6_months' ? 'selected' : '' }}>
                            {{ __('dashboard.Last 6 Months') }}</option>
                        <option value="last_9_months" {{ $range=='last_9_months' ? 'selected' : '' }}>
                            {{ __('dashboard.Last 9 Months') }}</option>
                        <option value="last_year" {{ $range=='last_year' ? 'selected' : '' }}>
                            {{ __('dashboard.Last Year') }}</option>
                        <option value="custom" {{ $range == 'custom' ? 'selected' : '' }}>
                            {{ __('dashboard.Custom Range') }}</option>
                    </select>
                </div>
                <div class="col-md-3" id="start_date_container"
                    style="display: {{ $range == 'custom' ? 'block' : 'none' }};">
                    <label for="custom_start" class="form-label">{{ __('dashboard.From Date') }}</label>
                    <input type="date" name="custom_start" id="custom_start" class="form-control"
                        value="{{ request('custom_start') }}">
                </div>
                <div class="col-md-3" id="end_date_container"
                    style="display: {{ $range == 'custom' ? 'block' : 'none' }};">
                    <label for="custom_end" class="form-label">{{ __('dashboard.To Date') }}</label>
                    <input type="date" name="custom_end" id="custom_end" class="form-control"
                        value="{{ request('custom_end') }}">
                </div>
               
            </div>
            <div class="row mb-5">
                <div class="col-md-3 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary me-3">{{ __('dashboard.Filter') }}</button>
                    <a href="{{ route('dashboard.statistics.product_sales') }}"
                        class="btn btn-secondary">{{ __('dashboard.Reset') }}</a>
                </div>
            </div>
        </form>

        <table class="table table-striped table-row-bordered gy-5 gs-7">
            <thead>
                <tr class="fw-bold fs-6 text-gray-800">
                    <th>{{ __('dashboard.Product Name') }}</th>
                    <th>{{ __('dashboard.SKU') }}</th>
                    <th>{{ __('dashboard.Category') }}</th>
                    <th>{{ __('dashboard.Quantity Sold') }}</th>
                    <th>{{ __('dashboard.Total Sales Value') }}</th>
                </tr>
            </thead>
            <tbody>
                @foreach ($productSales as $productSale)
                <tr>
                    <td>{{ $productSale['name'] }}</td>
                    <td>{{ $productSale['sku'] }}</td>
                    <td>{{ $productSale['category'] }}</td>
                    <td>{{ $productSale['quantity'] }}</td>
                    <td>{{ number_format($productSale['price'], 2) }}</td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
        @section('scripts')
        <script>
            $(document).ready(function () {
                $('select[name="range"]').change(function () {
                    if ($(this).val() === 'custom') {
                        $('#start_date_container').show();
                        $('#end_date_container').show();
                    } else {
                        $('#start_date_container').hide();
                        $('#end_date_container').hide();
                        this.form.submit();
                    }
                });

                $('input[name="custom_start"], input[name="custom_end"]').change(function () {
                    if ($('select[name="range"]').val() === 'custom') {
                        // No automatic submission, wait for the Filter button
                    }
                });
            });
        </script>
        @endsection
</div>
@endsection