@extends('layouts.app')

@section('title', 'Reservation Report - Tiqkets')
@section('page-title', 'Reservation Report')

@section('header-action')

@endsection
<style>
    th {
        text-transform: lowercase;
    }

    th::first-letter {
        text-transform: uppercase;
    }
</style>
@section('content')
    <div class="reservation-report-container">
        <!-- Filters Section -->
        <div class="filters-card h-100">
            <form action="{{ route('restaurant-admin.reports.reservation') }}" method="GET" id="filterForm">
                <input type="hidden" name="per_page" value="{{ request('per_page', 20) }}">

                <div class="filters-grid">
                    <!-- Search -->
                    {{-- <div class="filter-group">
                        <label class="filter-label">Search</label>
                        <div class="search-input-wrapper">
                            <i class="fas fa-search search-icon"></i>
                            <input type="text" class="filter-input" placeholder="Search by name, phone, or booking ID"
                                name="search" value="{{ request('search') }}">
                        </div>
                    </div> --}}

                    <!-- Date Range -->
                    <div class="filter-group">
                        <label class="filter-label">Date Range</label>
                        <div class="date-input-wrapper">
                            <input type="text" class="filter-input date-range-picker" placeholder="Select Date Range"
                                name="date_range" value="{{ request('date_range') }}" readonly>
                            <i class="far fa-calendar calendar-icon"></i>
                        </div>
                    </div>

                    <!-- Branch Filter -->
                    <div class="filter-group">
                        <label class="filter-label">Branch</label>
                        <select class="filter-select" name="branch_id">
                            <option value="">All Branches</option>
                            @foreach ($branches as $branch)
                                <option value="{{ $branch->id }}"
                                    {{ request('branch_id') == $branch->id ? 'selected' : '' }}>
                                    {{ $branch->branch_name }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                    {{-- <div class="filter-group">
                    </div> --}}
                    <div class="filter-group  d-flex align-items-end">
                        <button type="button" class="btn btn-primary btn-export " onclick="exportReport()">
                            Export
                        </button>
                    </div>
                </div>
            </form>
            {{-- </div> --}}

            <!-- Reservation Table -->
            <div class="report-table-card mt-3">
                @if ($paginatedData->count() > 0)
                    <div class="table-responsive">
                        <table class="report-table">
                            <thead>
                                <tr>
                                    <th>DATE</th>
                                    <th>BRANCH CODE</th>
                                    <th>BRANCH NAME</th>
                                    <th class="text-center">TOTAL RESERVED</th>
                                    <th class="text-center">ARRIVED</th>
                                    <th class="text-center">CANCELLED</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($paginatedData as $data)
                                    <tr>
                                        <td class="fw-medium">{{ $data['date'] }}</td>
                                        <td>{{ $data['branch_id'] }}</td>
                                        <td>{{ $data['branch_name'] }}</td>
                                        <td class="text-center">
                                            <span class="">{{ $data['reserved_count'] }}</span>
                                        </td>
                                        <td class="text-center">
                                            <span class="">{{ $data['arrived'] }}</span>
                                        </td>
                                        <td class="text-center">
                                            <span class="">{{ $data['cancelled'] }}</span>
                                        </td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>

                    <!-- Custom Pagination -->
                    <div class="pagination-wrapper">
                        <div class="pagination-info">
                            Showing
                            <strong>{{ $paginatedData->firstItem() ?? 1 }}</strong>
                            to
                            <strong>{{ $paginatedData->lastItem() ?? $paginatedData->count() }}</strong>
                            of
                            <strong>{{ $paginatedData->total() }}</strong>
                            entries
                        </div>

                        {{-- ✅ PAGINATION ONLY IF MORE THAN ONE PAGE --}}
                        @if ($paginatedData->hasPages())
                            <nav class="pagination-controls">
                                <ul class="pagination-list">

                                    {{-- Previous Button --}}
                                    @if ($paginatedData->onFirstPage())
                                        <li class="page-item disabled">
                                            <span class="page-link">
                                                <i class="fas fa-chevron-left"></i>
                                            </span>
                                        </li>
                                    @else
                                        <li class="page-item">
                                            <a class="page-link" href="{{ $paginatedData->previousPageUrl() }}">
                                                <i class="fas fa-chevron-left"></i>
                                            </a>
                                        </li>
                                    @endif

                                    {{-- Page Numbers --}}
                                    @foreach ($paginatedData->getUrlRange(1, $paginatedData->lastPage()) as $page => $url)
                                        @if ($page == $paginatedData->currentPage())
                                            <li class="page-item active">
                                                <span class="page-link">{{ $page }}</span>
                                            </li>
                                        @else
                                            <li class="page-item">
                                                <a class="page-link" href="{{ $url }}">{{ $page }}</a>
                                            </li>
                                        @endif
                                    @endforeach

                                    {{-- Next Button --}}
                                    @if ($paginatedData->hasMorePages())
                                        <li class="page-item">
                                            <a class="page-link" href="{{ $paginatedData->nextPageUrl() }}">
                                                <i class="fas fa-chevron-right"></i>
                                            </a>
                                        </li>
                                    @else
                                        <li class="page-item disabled">
                                            <span class="page-link">
                                                <i class="fas fa-chevron-right"></i>
                                            </span>
                                        </li>
                                    @endif

                                </ul>
                            </nav>
                        @endif

                        {{-- ✅ PER PAGE DROPDOWN (ALWAYS VISIBLE) --}}
                        <div class="pagination-per-page">
                            <label for="perPageSelect">Show:</label>
                            <select id="perPageSelect" class="per-page-select" onchange="changePerPage(this.value)">
                                <option value="10" {{ request('per_page') == 10 ? 'selected' : '' }}>10</option>
                                <option value="20"
                                    {{ request('per_page') == 20 || !request('per_page') ? 'selected' : '' }}>20</option>
                                <option value="50" {{ request('per_page') == 50 ? 'selected' : '' }}>50</option>
                                <option value="100" {{ request('per_page') == 100 ? 'selected' : '' }}>100</option>
                            </select>
                        </div>

                    </div>
                @else
                    <div class="empty-state">
                        <div class="empty-icon">
                            <i class="fas fa-calendar-check"></i>
                        </div>
                        <h5 class="empty-title">No Data Found</h5>
                        <p class="empty-text">No reservation data available for the selected filters.</p>
                        <button type="button" class="btn btn-primary" onclick="resetFilters()">
                            <i class="fas fa-refresh me-2"></i>Reset Filters
                        </button>
                    </div>
                @endif
            </div>
        </div>
    </div>
@endsection

@push('styles')
    <link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.css" />
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css" />
    <style>
        * {
            box-sizing: border-box;
        }

        /* ===== Global Container ===== */
        .reservation-report-container {
            padding: 0;
            display: flex;
            flex-direction: column;
            gap: 24px;
            max-width: 100%;
        }

        /* ===== Filters Card ===== */
        .filters-card {
            background: #ffffff;
            border: 1px solid #e5e7eb;
            border-radius: 12px;
            padding: 24px;
            box-shadow: 0 1px 3px rgba(0, 0, 0, 0.05);
        }

        .filters-grid {
            display: grid;
            grid-template-columns: repeat(3, 1fr);
            gap: 20px;
            align-items: end;
        }

        .filter-group {
            display: flex;
            flex-direction: column;
            gap: 8px;
        }

        .filter-label {
            font-size: 14px;
            font-weight: 400;
            color: #272626;

            margin-bottom: 0;
        }


        .filter-input,
        .filter-select {
            height: 44px;
            padding: 0 14px;
            border: 1.5px solid #d1d5db;
            border-radius: 8px;
            font-size: 14px;
            color: #111827;
            background: #ffffff;
            transition: all 0.2s ease;
            width: 100%;
        }

        .filter-input:focus,
        .filter-select:focus {
            outline: none;
            border-color: #667eea;
            box-shadow: 0 0 0 4px rgba(102, 126, 234, 0.1);
        }

        .filter-input::placeholder {
            color: #9ca3af;
        }

        .filter-select {
            appearance: none;
            background-image: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' width='16' height='16' viewBox='0 0 16 16'%3E%3Cpath fill='%23374151' d='M8 11L3 6h10z'/%3E%3C/svg%3E");
            background-repeat: no-repeat;
            background-position: right 14px center;
            padding-right: 40px;
            cursor: pointer;
        }

        .search-input-wrapper,
        .date-input-wrapper {
            position: relative;
        }

        .search-icon,
        .calendar-icon {
            position: absolute;
            top: 50%;
            transform: translateY(-50%);
            color: #9ca3af;
            font-size: 15px;
            pointer-events: none;
        }

        .search-icon {
            left: 14px;
        }

        .calendar-icon {
            right: 14px;
        }

        .search-input-wrapper .filter-input {
            padding-left: 42px;
        }

        .date-input-wrapper .filter-input {
            cursor: pointer;
        }

        /* ===== Report Table Card ===== */
        .report-table-card {
            background: #ffffff;
            border: 1px solid #e5e7eb;
            border-radius: 12px;
            overflow: hidden;
            box-shadow: 0 1px 3px rgba(0, 0, 0, 0.05);
        }

        .table-responsive {
            overflow-x: auto;
            -webkit-overflow-scrolling: touch;
        }

        .report-table {
            width: 100%;
            border-collapse: collapse;
            min-width: 900px;
        }

        .report-table thead {
            background: linear-gradient(to bottom, #f9fafb, #f3f4f6);
            border-bottom: 2px solid #e5e7eb;
        }

        .report-table th {
            padding: 16px 20px;
            font-size: 14px;
            font-weight: 600;
            color: #272626;
            text-align: left;
            /* text-transform: uppercase; */
            letter-spacing: 0.5px;
            white-space: nowrap;
        }

        .report-table td {
            padding: 16px 20px;
            font-size: 14px;
            color: #111827;
            border-bottom: 1px solid #f3f4f6;
        }

        .report-table tbody tr {
            transition: background-color 0.15s ease;
        }

        .report-table tbody tr:hover {
            background-color: #f9fafb;
        }

        .report-table tbody tr:last-child td {
            border-bottom: none;
        }

        .report-table th.text-center,
        .report-table td.text-center {
            text-align: center;
        }

        .fw-medium {
            font-weight: 500;
            color: #111827;
        }

        /* ===== Badges ===== */
        .badge {
            display: inline-flex;
            align-items: center;
            justify-content: center;
            min-width: 42px;
            padding: 6px 12px;
            font-size: 13px;
            font-weight: 600;
            border-radius: 6px;
            line-height: 1;
        }

        .badge-info {
            background-color: #dbeafe;
            color: #1e40af;
        }

        .badge-success {
            background-color: #d1fae5;
            color: #065f46;
        }

        .badge-danger {
            background-color: #fee2e2;
            color: #991b1b;
        }

        /* ===== Pagination Wrapper ===== */
        .pagination-wrapper {
            display: flex;
            justify-content: space-between;
            align-items: center;
            padding: 20px 24px;
            border-top: 1px solid #e5e7eb;
            background: #f9fafb;
            gap: 16px;
            flex-wrap: wrap;
        }

        .pagination-info {
            font-size: 14px;
            color: #6b7280;
            white-space: nowrap;
        }

        .pagination-info strong {
            color: #111827;
            font-weight: 600;
        }

        /* ===== Custom Pagination Controls ===== */
        .pagination-controls {
            flex: 1;
            display: flex;
            justify-content: center;
        }

        .pagination-list {
            display: flex;
            list-style: none;
            gap: 6px;
            margin: 0;
            padding: 0;
            align-items: center;
        }

        .pagination-list .page-item {
            list-style: none;
        }

        .pagination-list .page-link {
            display: inline-flex;
            align-items: center;
            justify-content: center;
            min-width: 38px;
            height: 38px;
            padding: 0 12px;
            border: 1.5px solid #d1d5db;
            border-radius: 8px;
            color: #374151;
            text-decoration: none;
            font-size: 14px;
            font-weight: 500;
            transition: all 0.2s ease;
            background: #ffffff;
            cursor: pointer;
        }

        .pagination-list .page-item.active .page-link {
            background: #667eea;
            border-color: #667eea;
            color: #ffffff;
            box-shadow: 0 2px 4px rgba(102, 126, 234, 0.3);
            cursor: default;
        }

        .pagination-list .page-item:not(.active):not(.disabled) .page-link:hover {
            background: #f3f4f6;
            border-color: #9ca3af;
            color: #111827;
        }

        .pagination-list .page-item.disabled .page-link {
            color: #d1d5db;
            background: #f9fafb;
            border-color: #e5e7eb;
            cursor: not-allowed;
            opacity: 0.6;
        }

        .pagination-list .page-link i {
            font-size: 12px;
        }

        /* ===== Per Page Selector ===== */
        .pagination-per-page {
            display: flex;
            align-items: center;
            gap: 8px;
            white-space: nowrap;
        }

        .pagination-per-page label {
            font-size: 14px;
            color: #6b7280;
            margin: 0;
        }

        .per-page-select {
            padding: 8px 32px 8px 12px;
            border: 1.5px solid #d1d5db;
            border-radius: 8px;
            font-size: 14px;
            color: #374151;
            background-color: #ffffff;
            background-image: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' width='16' height='16' viewBox='0 0 16 16'%3E%3Cpath fill='%23374151' d='M8 11L3 6h10z'/%3E%3C/svg%3E");
            background-repeat: no-repeat;
            background-position: right 10px center;
            appearance: none;
            cursor: pointer;
            transition: all 0.2s ease;
        }

        .per-page-select:focus {
            outline: none;
            border-color: #667eea;
            box-shadow: 0 0 0 4px rgba(102, 126, 234, 0.1);
        }

        /* ===== Empty State ===== */
        .empty-state {
            text-align: center;
            padding: 80px 24px;
        }

        .empty-icon {
            display: inline-flex;
            align-items: center;
            justify-content: center;
            width: 80px;
            height: 80px;
            background: #f3f4f6;
            border-radius: 50%;
            margin-bottom: 24px;
        }

        .empty-icon i {
            font-size: 36px;
            color: #9ca3af;
        }

        .empty-title {
            font-size: 20px;
            font-weight: 600;
            color: #111827;
            margin-bottom: 8px;
        }

        .empty-text {
            font-size: 14px;
            color: #6b7280;
            margin-bottom: 24px;
        }

        /* ===== Button Styles ===== */
        .btn-export {
            display: inline-flex;
            align-items: center;
            gap: 8px;
            padding: 10px 20px;
            border-radius: 8px;
            font-weight: 500;
        }

        /* ===== Responsive Design ===== */
        @media (max-width: 1200px) {
            .filters-grid {
                grid-template-columns: repeat(2, 1fr);
            }
        }

        @media (max-width: 768px) {
            .filters-card {
                padding: 20px;
            }

            .filters-grid {
                grid-template-columns: 1fr;
                gap: 16px;
            }

            .report-table th,
            .report-table td {
                padding: 12px 16px;
                font-size: 13px;
            }

            .pagination-wrapper {
                flex-direction: column;
                align-items: stretch;
                gap: 12px;
            }

            .pagination-info,
            .pagination-per-page {
                text-align: center;
                justify-content: center;
            }

            .pagination-controls {
                justify-content: center;
            }

            .pagination-list {
                flex-wrap: wrap;
                justify-content: center;
            }
        }

        @media (max-width: 480px) {
            .report-table-card {
                border-radius: 8px;
            }

            .filters-card {
                border-radius: 8px;
            }

            .empty-state {
                padding: 60px 16px;
            }
        }
    </style>
@endpush

@push('scripts')
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://cdn.jsdelivr.net/momentjs/latest/moment.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.min.js"></script>

    <script>
        $(document).ready(function() {
            // Initialize Date Range Picker
            $('.date-range-picker').daterangepicker({
                autoUpdateInput: false,
                locale: {
                    cancelLabel: 'Clear',
                    format: 'DD MMM YYYY'
                },
                ranges: {
                    'Today': [moment(), moment()],
                    'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
                    'Last 7 Days': [moment().subtract(6, 'days'), moment()],
                    'Last 30 Days': [moment().subtract(29, 'days'), moment()],
                    'This Month': [moment().startOf('month'), moment().endOf('month')],
                    'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1,
                        'month').endOf('month')]
                }
            });

            @if (request('date_range'))
                $('.date-range-picker').val('{{ request('date_range') }}');
            @endif

            $('.date-range-picker').on('apply.daterangepicker', function(ev, picker) {
                $(this).val(picker.startDate.format('DD MMM YYYY') + ' to ' + picker.endDate.format(
                    'DD MMM YYYY'));
                resetPageAndSubmit();
            });

            $('.date-range-picker').on('cancel.daterangepicker', function() {
                $(this).val('');
                resetPageAndSubmit();
            });

            // Auto-submit on search with debounce
            let searchTimeout;
            $('input[name="search"]').on('keyup', function() {
                clearTimeout(searchTimeout);
                searchTimeout = setTimeout(() => resetPageAndSubmit(), 600);
            });

            // Auto-submit on branch change
            $('select[name="branch_id"]').on('change', function() {
                resetPageAndSubmit();
            });

            // Helper function to reset page and submit
            function resetPageAndSubmit() {
                $('input[name="page"]').remove();
                $('#filterForm').append('<input type="hidden" name="page" value="1">');
                $('#filterForm').submit();
            }
        });

        // Export report function
        // Export report function - gets ALL data (not paginated)
        function exportReport() {
            // Get current filter parameters
            const form = document.getElementById('filterForm');
            const urlParams = new URLSearchParams(window.location.search);

            // Build export URL with all filters except pagination
            let exportUrl = '{{ route('restaurant-admin.reports.export-reservation') }}?';
            let params = [];

            // Add search parameter
            const search = $('input[name="search"]').val();
            if (search) {
                params.push(`search=${encodeURIComponent(search)}`);
            }

            // Add branch_id parameter
            const branchId = $('select[name="branch_id"]').val();
            if (branchId) {
                params.push(`branch_id=${encodeURIComponent(branchId)}`);
            }

            // Add date_range parameter
            const dateRange = $('input[name="date_range"]').val();
            if (dateRange) {
                params.push(`date_range=${encodeURIComponent(dateRange)}`);
            }

            // Also check URL parameters as fallback
            urlParams.forEach((value, key) => {
                if (['search', 'branch_id', 'date_range'].includes(key) && value) {
                    // Only add if not already added from form
                    if (!params.some(p => p.startsWith(key + '='))) {
                        params.push(`${key}=${encodeURIComponent(value)}`);
                    }
                }
            });

            if (params.length > 0) {
                exportUrl += params.join('&');
            }

            // Open export in new tab
            window.open(exportUrl, '_blank');
        }

        // Reset filters
        function resetFilters() {
            window.location.href = '{{ route('restaurant-admin.reports.reservation') }}';
        }

        // Change per page
        function changePerPage(value) {
            $('input[name="page"]').remove();
            $('input[name="per_page"]').val(value);
            $('#filterForm').append('<input type="hidden" name="page" value="1">');
            $('#filterForm').submit();
        }
        $(document).ready(function() {
            let searchInput = $('input[name="search"]');

            // Focus the input
            searchInput.focus();

            // Move cursor to end of text
            let val = searchInput.val();
            searchInput.val('').val(val);
        });
    </script>
@endpush