@include('components.header')

<!-- Font Awesome for icons -->
{{-- <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css"> --}}

<style>
    .custom-blue {
        background-color: var(--primary-theme-color);
    }

    .custom-blue:hover {
        background-color: #0d2f57;
    }

    /* Card hover effect */
    .registration-card {
        transition: all 0.3s ease;
        border-left: 4px solid transparent;
    }

    .registration-card:hover {
        transform: translateY(-2px);
        box-shadow: 0 10px 25px rgba(0, 0, 0, 0.1);
        border-left-color: var(--primary-theme-color);
    }

    /* Accordion Animation */
    .reg-accordion-content {
        max-height: 0;
        overflow: hidden;
        transition: max-height 0.5s ease-out, opacity 0.3s ease-out;
        opacity: 0;
    }

    .reg-accordion-content.accordion-open {
        max-height: 10000px; /* Very large value to accommodate all content */
        opacity: 1;
        overflow-y: visible;
    }

    .accordion-icon {
        transition: transform 0.3s ease;
    }

    .accordion-icon.rotated {
        transform: rotate(180deg);
    }

    /* Details section styling */
    .details-section {
        background: linear-gradient(135deg, #f8f9fc 0%, #f0f4f8 100%);
        border-radius: 12px;
        padding: 16px;
        margin-bottom: 12px;
    }

    .details-section-title {
        display: flex;
        align-items: center;
        gap: 8px;
        font-weight: 600;
        color: #1e293b;
        margin-bottom: 12px;
        font-size: 0.95rem;
    }

    .details-section-title i {
        color: var(--primary-theme-color);
    }

    .details-row {
        display: flex;
        margin-bottom: 6px;
        font-size: 0.875rem;
    }

    .details-label {
        color: #64748b;
        width: 140px;
        flex-shrink: 0;
    }

    .details-value {
        color: #1e293b;
        font-weight: 500;
    }

    /* Custom select styling */
    .custom-select {
        appearance: none;
        background-image: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' fill='none' viewBox='0 0 24 24' stroke='%236b7280'%3E%3Cpath stroke-linecap='round' stroke-linejoin='round' stroke-width='2' d='M19 9l-7 7-7-7'%3E%3C/path%3E%3C/svg%3E");
        background-repeat: no-repeat;
        background-position: right 12px center;
        background-size: 16px;
        padding-right: 40px;
    }

    /* Search input styling */
    .search-input {
        transition: all 0.2s ease;
    }

    .search-input:focus {
        box-shadow: 0 0 0 3px rgba(0, 0, 128, 0.1);
    }

    /* Page section styling */
    .page-section {
        margin-bottom: 24px;
    }

    .page-section:last-child {
        margin-bottom: 0;
    }

    .page-header {
        background: linear-gradient(90deg, rgba(0, 0, 128, 0.05) 0%, transparent 100%);
        padding: 8px 12px;
        border-radius: 8px 8px 0 0;
    }

    /* Group section styling */
    .group-section {
        background: white;
        border-radius: 10px;
        padding: 16px;
        box-shadow: 0 1px 3px rgba(0, 0, 0, 0.05);
        border: 1px solid #e5e7eb;
    }

    .group-header h5 {
        margin: 0;
        color: #374151;
    }

    /* Field item styling */
    .field-item {
        padding: 8px 0;
    }

    .field-item span {
        display: block;
    }

    /* Status badge */
    .status-badge {
        font-size: 0.75rem;
        padding: 4px 12px;
        border-radius: 20px;
        font-weight: 600;
        text-transform: capitalize;
    }

    .status-paid {
        background-color: #dcfce7;
        color: #166534;
    }

    .status-pending {
        background-color: #fef3c7;
        color: #92400e;
    }

    .status-unpaid {
        background-color: #fee2e2;
        color: #991b1b;
    }

    /* Player tag */
    .player-tag {
        background: linear-gradient(135deg, #e0e7ff 0%, #c7d2fe 100%);
        padding: 4px 10px;
        border-radius: 6px;
        font-size: 0.8rem;
        color: #3730a3;
        font-weight: 500;
    }

    /* Filter container */
    .filter-container {
        background: #fff;
        border-radius: 12px;
        padding: 20px;
        box-shadow: 0 1px 3px rgba(0, 0, 0, 0.08);
        margin-bottom: 16px;
    }
</style>
</head>

<body class="bg-gray-100 h-dvh flex flex-col overflow-hidden topbar-layout">

    @include('components.navbar')
    @include('components.topbar', ['page' => 'past-registration'])

    <div class="flex-1 overflow-hidden">
        <main id="content" class="flex-1 overflow-y-auto bg-gray-100 p-6 transition-all duration-300 h-full">
            <div class="max-w-4xl mx-auto font-sans">
                
                <!-- Main Card Container -->
                <div class="rounded-xl shadow-2xl overflow-hidden">
                    
                    <!-- Main Header -->
                    <div class="bg-[var(--primary-theme-color)] text-white p-8 text-center">
                        <h1 id="page-title" class="text-2xl font-bold tracking-wide">
                            Past Registrations
                        </h1>
                        <p class="text-sm text-gray-300 mt-2">View and manage your previous registration history</p>
                    </div>

                    <!-- Content Area -->
                    <div class="bg-white p-6">
                        
                        <!-- Filter Container -->
                        <div class="filter-container">
                            <!-- Search Input -->
                            <div class="relative mb-4">
                                <span class="absolute inset-y-0 left-0 flex items-center pl-4">
                                    <i class="fa-solid fa-magnifying-glass text-gray-400"></i>
                                </span>
                                <input type="text" 
                                       id="search-input" 
                                       placeholder="Search by name or registration ID" 
                                       class="search-input w-full pl-12 pr-4 py-3 border border-gray-200 rounded-xl text-sm focus:outline-none focus:border-[var(--primary-theme-color)]">
                            </div>

                            <!-- Dropdowns Row -->
                            <div class="grid grid-cols-1 md:grid-cols-2 gap-4">
                                <!-- League Dropdown -->
                                <div class="relative">
                                    <select id="league-select" 
                                            class="custom-select w-full py-3 px-4 border border-gray-200 rounded-xl text-sm focus:outline-none focus:border-[var(--primary-theme-color)] bg-white cursor-pointer">
                                        <option value="">All Leagues</option>
                                    </select>
                                </div>

                                <!-- Season Dropdown -->
                                <div class="relative">
                                    <select id="season-select" 
                                            class="custom-select w-full py-3 px-4 border border-gray-200 rounded-xl text-sm focus:outline-none focus:border-[var(--primary-theme-color)] bg-white cursor-pointer">
                                        <option value="">All Seasons</option>
                                    </select>
                                </div>
                            </div>

                            <!-- Results Count -->
                            <div id="results-count" class="text-sm text-gray-500 mt-4 hidden">
                                Showing <span id="showing-count">0</span> of <span id="total-count">0</span> registrations
                            </div>
                        </div>
                        
                        <!-- Loading State -->
                        <div id="loading-state" class="text-center py-10">
                            <div class="animate-spin rounded-full h-12 w-12 border-b-2 border-[var(--primary-theme-color)] mx-auto"></div>
                            <p class="mt-4 text-gray-600">Loading past registrations...</p>
                        </div>

                        <!-- Past Registrations List -->
                        <div id="registrations-container" class="hidden space-y-4">
                            <!-- Registrations will be loaded here dynamically -->
                        </div>

                        <!-- Empty State -->
                        <div id="empty-state" class="hidden text-center py-16">
                            <div class="bg-gray-50 rounded-full w-24 h-24 mx-auto flex items-center justify-center mb-6">
                                <i class="fa-solid fa-folder-open text-gray-300 text-4xl"></i>
                            </div>
                            <h3 class="text-lg font-semibold text-gray-600">No Past Registrations</h3>
                            <p class="text-gray-400 mt-2 max-w-sm mx-auto">You don't have any previous registrations matching your filters.</p>
                        </div>

                        <!-- Error State -->
                        <div id="error-state" class="hidden text-center py-16">
                            <div class="bg-red-50 rounded-full w-24 h-24 mx-auto flex items-center justify-center mb-6">
                                <i class="fa-solid fa-exclamation-triangle text-red-400 text-4xl"></i>
                            </div>
                            <h3 class="text-lg font-semibold text-gray-600">Error Loading Data</h3>
                            <p class="text-gray-400 mt-2 max-w-sm mx-auto" id="error-message">Something went wrong. Please try again.</p>
                            <button onclick="loadInitialData()" class="mt-4 px-6 py-2 bg-[var(--primary-theme-color)] text-white rounded-lg text-sm font-medium hover:bg-[#000060] transition-colors">
                                <i class="fa-solid fa-refresh mr-2"></i>Retry
                            </button>
                        </div>
                        
                    </div>

                </div>

            </div>

            <script>
                // Global variables
                let authOrganisation = '';
                let authToken = '';
                let allRegistrations = [];
                let leaguesList = [];
                let allSeasons = [];

                // Initialize on page load
                function initPage() {
                    console.log('🚀 Past Registrations Page Initializing...');
                    
                    // Get auth tokens from localStorage
                    authToken = localStorage.getItem('authToken') || '';
                    authOrganisation = localStorage.getItem('organisation') || '';

                    console.log('Auth Token:', authToken ? 'Present' : 'Missing');
                    console.log('Organisation:', authOrganisation || 'Missing');

                    // Load initial data
                    loadInitialData();

                    // Setup event listeners
                    setupEventListeners();
                }

                // Check if DOM is already loaded
                if (document.readyState === 'loading') {
                    document.addEventListener('DOMContentLoaded', initPage);
                } else {
                    initPage();
                }

                // Setup event listeners for filters
                function setupEventListeners() {
                    const searchInput = document.getElementById('search-input');
                    const leagueSelect = document.getElementById('league-select');
                    const seasonSelect = document.getElementById('season-select');

                    // Debounce search input
                    let searchTimeout;
                    searchInput.addEventListener('input', function() {
                        clearTimeout(searchTimeout);
                        searchTimeout = setTimeout(() => {
                            filterRegistrations();
                        }, 300);
                    });

                    // League change - update seasons dropdown
                    leagueSelect.addEventListener('change', function() {
                        updateSeasonsDropdown();
                        loadRegistrations();
                    });

                    // Season change - filter registrations
                    seasonSelect.addEventListener('change', function() {
                        loadRegistrations();
                    });
                }

                // Load initial data
                async function loadInitialData() {
                    showState('loading');

                    try {
                        const response = await fetch('{{ config('api.url') }}/graphql/registration', {
                            method: 'POST',
                            headers: {
                                'Content-Type': 'application/json',
                                'X-Organisation': authOrganisation,
                                'X-Token': authToken,
                            },
                            body: JSON.stringify({
                                query: `query FetchMyPastRegistrationsNew {
                                    fetchMyPastRegistrationsNew(league_id: "all", season_id: "all")
                                    fetchLeaguesList {
                                        id
                                        name
                                        seasons {
                                            season_id
                                            season_name
                                        }
                                    }
                                }`
                            })
                        });

                        const result = await response.json();
                        console.log('✅ API Response:', result);

                        if (result.errors) {
                            console.error('❌ GraphQL Errors:', result.errors);
                            showState('error', result.errors[0]?.message || 'API Error');
                            return;
                        }

                        // Parse leagues list
                        if (result.data && result.data.fetchLeaguesList) {
                            leaguesList = result.data.fetchLeaguesList;
                            populateLeaguesDropdown();
                        }

                        // Parse registrations - handle the nested structure
                        if (result.data && result.data.fetchMyPastRegistrationsNew) {
                            const regData = result.data.fetchMyPastRegistrationsNew;
                            
                            // Check if it's the new structure with success/registrations
                            if (regData.registrations && Array.isArray(regData.registrations)) {
                                console.log('📝 Found registrations:', regData.registrations.length);
                                allRegistrations = regData.registrations;
                                renderRegistrations(allRegistrations);
                            } else if (Array.isArray(regData)) {
                                allRegistrations = regData;
                                renderRegistrations(allRegistrations);
                            } else {
                                showState('empty');
                            }
                        } else {
                            showState('empty');
                        }

                    } catch (error) {
                        console.error('💥 Error:', error);
                        showState('error', error.message);
                    }
                }

                // Load registrations with filters
                async function loadRegistrations() {
                    const leagueId = document.getElementById('league-select').value || 'all';
                    const seasonId = document.getElementById('season-select').value || 'all';

                    showState('loading');

                    try {
                        const response = await fetch('{{ config('api.url') }}/graphql/registration', {
                            method: 'POST',
                            headers: {
                                'Content-Type': 'application/json',
                                'X-Organisation': authOrganisation,
                                'X-Token': authToken,
                            },
                            body: JSON.stringify({
                                query: `query FetchMyPastRegistrationsNew {
                                    fetchMyPastRegistrationsNew(league_id: "${leagueId}", season_id: "${seasonId}")
                                }`
                            })
                        });

                        const result = await response.json();

                        if (result.errors) {
                            showState('error', result.errors[0]?.message || 'API Error');
                            return;
                        }

                        if (result.data && result.data.fetchMyPastRegistrationsNew) {
                            const regData = result.data.fetchMyPastRegistrationsNew;
                            if (regData.registrations && Array.isArray(regData.registrations)) {
                                allRegistrations = regData.registrations;
                                renderRegistrations(allRegistrations);
                            } else {
                                showState('empty');
                            }
                        } else {
                            showState('empty');
                        }

                    } catch (error) {
                        showState('error', error.message);
                    }
                }

                // Populate leagues dropdown
                function populateLeaguesDropdown() {
                    const leagueSelect = document.getElementById('league-select');
                    leagueSelect.innerHTML = '<option value="">All Leagues</option>';

                    leaguesList.forEach(league => {
                        const option = document.createElement('option');
                        option.value = league.id;
                        option.textContent = league.name;
                        leagueSelect.appendChild(option);
                    });

                    // Collect all seasons
                    allSeasons = [];
                    leaguesList.forEach(league => {
                        if (league.seasons) {
                            league.seasons.forEach(season => {
                                if (!allSeasons.find(s => s.season_id === season.season_id)) {
                                    allSeasons.push({ ...season, league_id: league.id });
                                }
                            });
                        }
                    });
                    updateSeasonsDropdown();
                }

                // Update seasons dropdown
                function updateSeasonsDropdown() {
                    const leagueSelect = document.getElementById('league-select');
                    const seasonSelect = document.getElementById('season-select');
                    const selectedLeagueId = leagueSelect.value;

                    seasonSelect.innerHTML = '<option value="">All Seasons</option>';

                    let seasonsToShow = selectedLeagueId 
                        ? (leaguesList.find(l => l.id == selectedLeagueId)?.seasons || [])
                        : allSeasons;

                    seasonsToShow.forEach(season => {
                        const option = document.createElement('option');
                        option.value = season.season_id;
                        option.textContent = season.season_name;
                        seasonSelect.appendChild(option);
                    });
                }

                // Filter registrations by search
                function filterRegistrations() {
                    const searchTerm = document.getElementById('search-input').value.toLowerCase().trim();
                    
                    if (!searchTerm) {
                        renderRegistrations(allRegistrations);
                        return;
                    }

                    const filtered = allRegistrations.filter(reg => {
                        const regId = (reg.registration_id || '').toString();
                        const formName = (reg.form_name || '').toLowerCase();
                        const playerName = getPlayerName(reg).toLowerCase();
                        const parentName = getParentName(reg).toLowerCase();
                        
                        return regId.includes(searchTerm) || 
                               formName.includes(searchTerm) ||
                               playerName.includes(searchTerm) ||
                               parentName.includes(searchTerm);
                    });

                    renderRegistrations(filtered);
                }

                // Get a field value from pages
                function getFieldValue(pages, pageName, fieldLabel) {
                    const page = pages?.find(p => p.page_name?.toLowerCase() === pageName.toLowerCase());
                    if (!page || !page.groups) return null;

                    for (const group of page.groups) {
                        if (group.fields) {
                            const field = group.fields.find(f => f.label?.toLowerCase() === fieldLabel.toLowerCase());
                            if (field && field.value) return field.value;
                        }
                    }
                    return null;
                }

                // Get player name
                function getPlayerName(reg) {
                    // Use player_name directly from API response
                    if (reg.player_name) return reg.player_name;
                    
                    // Fallback to extracting from pages if not available
                    const firstName = getFieldValue(reg.pages, 'Children', 'First Name') || '';
                    const lastName = getFieldValue(reg.pages, 'Children', 'Last Name') || '';
                    return `${firstName} ${lastName}`.trim() || 'N/A';
                }

                // Get parent name
                function getParentName(reg) {
                    const firstName = getFieldValue(reg.pages, 'Parents', 'First Name') || '';
                    const lastName = getFieldValue(reg.pages, 'Parents', 'Last Name') || '';
                    return `${firstName} ${lastName}`.trim() || 'N/A';
                }

                // Render registrations
                function renderRegistrations(registrations) {
                    const container = document.getElementById('registrations-container');
                    
                    if (!registrations || registrations.length === 0) {
                        showState('empty');
                        return;
                    }

                    document.getElementById('showing-count').textContent = registrations.length;
                    document.getElementById('total-count').textContent = allRegistrations.length;
                    document.getElementById('results-count').classList.remove('hidden');

                    let html = '';
                    registrations.forEach((reg, index) => {
                        html += renderRegistrationCard(reg, index);
                    });

                    container.innerHTML = html;
                    showState('registrations');
                }

                // Render a registration card
                function renderRegistrationCard(reg, index) {
                    const regId = `REG-${reg.registration_id}`;
                    const regDate = formatDate(reg.date);
                    const formName = reg.form_name || 'N/A';
                    const playerName = getPlayerName(reg);
                    const parentEmail = getFieldValue(reg.pages, 'Parents', 'Email') || 'N/A';

                    return `
                        <div class="registration-card bg-white border border-gray-100 rounded-xl overflow-hidden shadow-sm mb-4">
                            <!-- Card Header -->
                            <div class="p-5 cursor-pointer" onclick="toggleRegistration('reg-${index}', this)">
                                <div class="flex justify-between items-start">
                                    <div class="flex-1">
                                        <div class="flex items-center gap-3">
                                            <h3 class="font-bold text-gray-800 text-lg">${regId}</h3>
                                            <i class="fa-solid fa-chevron-down accordion-icon text-gray-400 text-sm"></i>
                                        </div>
                                        <p class="text-sm text-gray-400 mt-1">${regDate}</p>
                                    </div>
                                    <span class="status-badge status-paid">Paid</span>
                                </div>
                                
                                <div class="mt-4 space-y-2 text-sm">
                                    <div class="flex justify-between">
                                        <span class="text-gray-400">Season:</span>
                                        <span class="text-gray-700 font-medium">${formName}</span>
                                    </div>
                                    <div class="flex justify-between">
                                        <span class="text-gray-400">Player(s):</span>
                                        <span class="text-gray-700 font-medium">${playerName}</span>
                                    </div>
                                </div>
                            </div>

                            <!-- Expandable Details -->
                            <div id="reg-${index}" class="reg-accordion-content bg-gray-50 border-t border-gray-100">
                                <div class="p-5 space-y-6">
                                    ${renderAllPages(reg.pages)}
                                </div>
                            </div>
                        </div>
                    `;
                }

                // Render all pages with their groups and fields
                function renderAllPages(pages, reg) {
                    if (!pages || pages.length === 0) return '<p class="text-gray-500">No details available</p>';

                    // Sort pages by sort_order, but ensure Payment is ALWAYS last
                    const sortedPages = [...pages].sort((a, b) => {
                        const nameA = (a.page_name || '').toLowerCase();
                        const nameB = (b.page_name || '').toLowerCase();
                        const isPaymentA = nameA.includes('payment');
                        const isPaymentB = nameB.includes('payment');

                        if (isPaymentA && !isPaymentB) return 1;
                        if (!isPaymentA && isPaymentB) return -1;
                        
                        return (a.page_sort_order || 0) - (b.page_sort_order || 0);
                    });

                    let html = '';
                    sortedPages.forEach(page => {
                        html += renderPage(page, reg);
                    });

                    return html;
                }

                // Render a single page with its groups
                function renderPage(page, reg) {
                    const hasDirectFields = page.fields && page.fields.length > 0;
                    const hasGroups = page.groups && page.groups.length > 0;
                    
                    if (!hasDirectFields && !hasGroups) return '';

                    const icon = getPageIcon(page.page_name);
                    let contentHtml = '';

                    if (hasGroups) {
                        const sortedGroups = [...page.groups].sort((a, b) => {
                            const ga = a.group_sort_order || 0;
                            const gb = b.group_sort_order || 0;
                            if (ga !== gb) return ga - gb;
                            const minSortA = a.fields && a.fields.length > 0 ? Math.min(...a.fields.map(f => f.sort_order ?? 999)) : 999;
                            const minSortB = b.fields && b.fields.length > 0 ? Math.min(...b.fields.map(f => f.sort_order ?? 999)) : 999;
                            return minSortA - minSortB;
                        });
                        sortedGroups.forEach(group => {
                            contentHtml += renderGroup(group, reg);
                        });
                    } else if (hasDirectFields) {
                        contentHtml += renderGroup({
                            group_name: '', 
                            fields: page.fields
                        }, reg);
                    }

                    if (!contentHtml && !page.page_field_description) return '';

                    // Determine if this is a custom page (non-systemic)
                    const lowerName = (page.page_name || '').toLowerCase().trim();
                    const isSystemPage = ['parent', 'parents', 'child', 'children', 'player', 'players'].includes(lowerName);
                    
                    // Get page description: check top-level, then search in fields/groups 
                    let pageDescription = page.page_field_description || page.page_description || '';
                    
                    if (!pageDescription && page.fields) {
                        const descField = page.fields.find(f => f.page_field_description);
                        if (descField) pageDescription = descField.page_field_description;
                    }
                    
                    if (!pageDescription && page.groups) {
                        for (const group of page.groups) {
                            if (group.fields) {
                                const descField = group.fields.find(f => f.page_field_description);
                                if (descField) {
                                    pageDescription = descField.page_field_description;
                                    break;
                                }
                            }
                        }
                    }

                    let descriptionHtml = '';
                    if (pageDescription && pageDescription.trim() !== '') {
                         if (!isSystemPage) {
                            descriptionHtml = `
                                <div class="mb-4 text-sm text-gray-700 bg-blue-50/50 p-4 rounded-xl border border-blue-100 shadow-sm prose prose-sm max-w-none">
                                    ${pageDescription}
                                </div>
                            `;
                         }
                    }

                    return `
                        <div class="page-section mb-8">
                            <!-- Page Header -->
                            <div class="page-header flex items-center gap-3 mb-4 pb-2 border-b-2 border-[var(--primary-theme-color)]/20">
                                <i class="${icon} text-[var(--primary-theme-color)] text-lg"></i>
                                <h4 class="text-lg font-bold text-gray-800 uppercase tracking-tight">${page.page_name}</h4>
                            </div>

                            ${descriptionHtml}

                            <div class="space-y-4">
                                ${contentHtml}
                            </div>
                        </div>
                    `;
                }

                // Render a group with its fields
                function renderGroup(group, reg) {
                    if (!group.fields || group.fields.length === 0) return '';

                    // Filter out fields without values and sensitive fields
                    const validFields = group.fields.filter(f => {
                        const label = (f.label || '').toLowerCase();
                        // Skip password and internal fields
                        if (label.includes('password') || label === 'id' || label === 'token') return false;
                        // Keep fields with values, including 0
                        return f.value !== null && f.value !== undefined && f.value !== '';
                    });

                    if (validFields.length === 0) return '';

                    // Sort fields by sort_order
                    const sortedFields = [...validFields].sort((a, b) => (a.sort_order || 0) - (b.sort_order || 0));

                    let fieldsHtml = '';
                    sortedFields.forEach(field => {
                        fieldsHtml += renderField(field, reg);
                    });

                    const groupName = group.group_name || '';

                    return `
                        <div class="group-section bg-white rounded-lg p-4 shadow-sm border border-gray-100">
                            ${groupName ? `
                            <!-- Group Header -->
                            <div class="group-header mb-3">
                                <h5 class="text-sm font-semibold text-gray-500 uppercase tracking-wider border-b border-gray-100 pb-2">${groupName}</h5>
                            </div>
                            ` : ''}

                            <!-- Group Fields -->
                            <div class="group-fields grid grid-cols-1 md:grid-cols-2 gap-4">
                                ${fieldsHtml}
                            </div>
                        </div>
                    `;
                }

                // Render a single field
                function renderField(field, reg) {
                    const hideCheckLabel = (field.label || '').toLowerCase().trim();
                    if (hideCheckLabel === 'text only text' || hideCheckLabel === 'text') {
                        return '';
                    }

                    let label = field.label || 'Field';
                    const idTable = field.idTable || field.id_table || field.idtable;
                    const labelLower = label.toLowerCase();
                    const isMemoOrComment = labelLower.includes('comment') || labelLower.includes('memo');
                    
                    if (idTable == 1) {
                        const parentName = getParentName(reg);
                        if (parentName && parentName !== 'N/A') label = `${parentName} - ${label}`;
                    } else if (idTable == 2 || idTable == 3) {
                        const playerName = getPlayerName(reg);
                        if (playerName && playerName !== 'N/A') label = `${playerName} - ${label}`;
                    }

                    let value = field.value;

                    // Format value based on type
                    value = formatFieldValue(value, field.field_type, label);

                    return `
                        <div class="field-item">
                            ${isMemoOrComment ? '' : `<span class="text-xs text-gray-400 uppercase tracking-wide">${label}</span>`}
                            <p class="text-sm text-gray-800 font-medium mt-0.5">${value}</p>
                        </div>
                    `;
                }

                // Format field value based on type
                function formatFieldValue(value, fieldType, label) {
                    if (value === null || value === undefined || value === '') return 'N/A';

                    // Handle checkbox values
                    if (fieldType === 'checkbox') {
                        return parseFloat(value) === 1 || value === '1.00' || value === '1' ? '✓ Yes' : '✗ No';
                    }

                    // Handle gender
                    if (label.toLowerCase() === 'gender') {
                        if (value === '1.00' || value === '1') return 'Male';
                        if (value === '2.00' || value === '2') return 'Female';
                        return value;
                    }

                    // Handle dates
                    if (fieldType === 'date' && value) {
                        return formatDate(value);
                    }

                    // Handle numeric values that look like IDs (clean up .00)
                    if (typeof value === 'string' && value.endsWith('.00')) {
                        return parseInt(value).toString();
                    }

                    return value;
                }

                // Get icon for page based on name
                function getPageIcon(pageName) {
                    const name = (pageName || '').toLowerCase();
                    
                    if (name.includes('parent')) return 'fa-solid fa-users';
                    if (name.includes('child') || name.includes('player')) return 'fa-solid fa-user';
                    if (name.includes('emergency')) return 'fa-solid fa-phone-volume';
                    if (name.includes('medical') || name.includes('health')) return 'fa-solid fa-heart-pulse';
                    if (name.includes('waiver') || name.includes('release') || name.includes('consent')) return 'fa-solid fa-file-signature';
                    if (name.includes('code') || name.includes('conduct')) return 'fa-solid fa-scale-balanced';
                    if (name.includes('covid')) return 'fa-solid fa-virus-covid';
                    if (name.includes('concussion')) return 'fa-solid fa-head-side-medical';
                    if (name.includes('commercial') || name.includes('mail')) return 'fa-solid fa-envelope';
                    if (name.includes('zero') || name.includes('tolerance')) return 'fa-solid fa-ban';
                    
                    return 'fa-solid fa-file-lines';
                }

                // Toggle registration accordion
                function toggleRegistration(id, header) {
                    const section = document.getElementById(id);
                    const icon = header.querySelector('.accordion-icon');
                    
                    if (section.classList.contains('accordion-open')) {
                        section.classList.remove('accordion-open');
                        icon.classList.remove('rotated');
                    } else {
                        // Close all other accordions
                        document.querySelectorAll('.reg-accordion-content.accordion-open').forEach(el => {
                            el.classList.remove('accordion-open');
                            const otherIcon = el.closest('.registration-card')?.querySelector('.accordion-icon');
                            if (otherIcon) otherIcon.classList.remove('rotated');
                        });
                        
                        section.classList.add('accordion-open');
                        icon.classList.add('rotated');
                    }
                }

                // Format date
                function formatDate(dateStr) {
                    if (!dateStr) return 'N/A';
                    try {
                        const date = new Date(dateStr);
                        if (isNaN(date.getTime())) return dateStr;
                        return date.toLocaleDateString('en-US', { year: 'numeric', month: 'short', day: 'numeric' });
                    } catch (e) {
                        return dateStr;
                    }
                }

                // Show state
                function showState(state, errorMessage = '') {
                    const loadingState = document.getElementById('loading-state');
                    const registrationsContainer = document.getElementById('registrations-container');
                    const emptyState = document.getElementById('empty-state');
                    const errorState = document.getElementById('error-state');
                    const resultsCount = document.getElementById('results-count');

                    loadingState.classList.add('hidden');
                    registrationsContainer.classList.add('hidden');
                    emptyState.classList.add('hidden');
                    errorState.classList.add('hidden');
                    resultsCount.classList.add('hidden');

                    switch(state) {
                        case 'loading':
                            loadingState.classList.remove('hidden');
                            break;
                        case 'registrations':
                            registrationsContainer.classList.remove('hidden');
                            resultsCount.classList.remove('hidden');
                            break;
                        case 'empty':
                            emptyState.classList.remove('hidden');
                            break;
                        case 'error':
                            errorState.classList.remove('hidden');
                            if (errorMessage) {
                                document.getElementById('error-message').textContent = errorMessage;
                            }
                            break;
                    }
                }
            </script>
             <!-- Font Awesome -->
            <script src="https://kit.fontawesome.com/ff110e9818.js" crossorigin="anonymous"></script>
        </main>

    </div>

    @include('components.footer')