{{-- Sous-menu horizontal de l'événement courant (affiché en haut du contenu) --}}
@php
    $currentEventId = null;
    $currentEvent = null;

    if (request()->segment(1) === 'events' && is_numeric(request()->segment(2))) {
        $currentEventId = (int) request()->segment(2);
        $currentEvent = App\Models\Event::with('workshops', 'shows')->find($currentEventId);
    }
@endphp

@if ($currentEvent)
    @php
        $eventId = $currentEvent->id;
        $hasAdhesionBoPage = $currentEvent->has_adhesion_bo_page;
        $hasCateringBoPage = $currentEvent->has_catering_bo_page;
        $hasSessions =
            $currentEvent->workshops->where('f3', 'session')->count() > 0 ||
            $currentEvent->workshops->where('f3', 'atelier')->count() > 0;
        $currentPage = request()->segment(3);

        // ── Consolidated badge counts (single query per table) ──
        $participantCounts = DB::table('participants')
            ->where('event_id', $eventId)
            ->selectRaw('COUNT(*) as total')
            ->selectRaw("SUM(code != '' AND code IS NOT NULL) as confirmed")
            ->selectRaw("SUM(code != '' AND code IS NOT NULL AND is_present = '1') as present")
            ->selectRaw("SUM(code != '' AND code IS NOT NULL AND category = 'Prise en charge') as pec")
            ->first();

        $abstractCounts = null;
        if ($currentEvent->has_abstracts) {
            $abstractCounts = DB::table('abstracts')
                ->where('event_id', $eventId)
                ->selectRaw('COUNT(*) as total')
                ->selectRaw("SUM(review = 'Approuver') as approved")
                ->first();
        }

        $roomCounts = null;
        $reservationCounts = null;
        if ($currentEvent->has_hebergement_bo) {
            $roomCounts = DB::table('room_reservations')
                ->where('event_id', $eventId)
                ->selectRaw('COUNT(*) as total')
                ->selectRaw("SUM(code != '' AND code IS NOT NULL) as with_code")
                ->selectRaw("SUM(code != '' AND code IS NOT NULL AND is_checked = 1) as checked")
                ->first();

            $reservationCounts = DB::table('reservations')
                ->where('event_id', $eventId)
                ->selectRaw('COUNT(*) as total')
                ->selectRaw("SUM(status = 'validated') as validated")
                ->selectRaw("SUM(status = 'pending') as pending")
                ->first();
        }

        $evaluationCount = null;
        if ($currentEvent->has_evaluation) {
            $evaluationCount = DB::table('answers')
                ->where('event_id', $eventId)
                ->distinct('created_at')
                ->count('created_at');
        }
    @endphp

    <div class="event-submenu-bar">
        <div class="event-submenu-title">
            <i class="fa-solid fa-globe"></i>
            {!! preg_replace(
                '/(\d+)er/',
                '$1<sup>er</sup>',
                preg_replace('/(\d+)ème/', '$1<sup>ème</sup>', $currentEvent->bo_title),
            ) !!}
        </div>
        <nav class="event-submenu-nav">
            @can('statistiques')
                <a href="/events/{{ $eventId }}/statistique"
                    class="event-submenu-link {{ $currentPage === 'statistique' ? 'active' : '' }}">
                    Statistiques
                </a>
            @endcan

            @can('dashboard')
                <a href="/events/{{ $eventId }}/dashboard"
                    class="event-submenu-link {{ $currentPage === 'dashboard' ? 'active' : '' }}">
                    Dashboard
                </a>
            @endcan

            @can('cashboard_view')
                <a href="/events/{{ $eventId }}/cashboard"
                    class="event-submenu-link {{ $currentPage === 'cashboard' ? 'active' : '' }}">
                    Caisse Inscri.
                </a>
            @endcan

            @can('sponsorship_view')
                <a href="/events/{{ $eventId }}/sponsorship"
                    class="event-submenu-link {{ $currentPage === 'sponsorship' ? 'active' : '' }}">
                    Prise en charge
                    <span class="badge rounded-pill bg-success">{{ (int) $participantCounts->pec }}</span>
                </a>
            @endcan

            @if ($hasCateringBoPage)
                @can('catering_view')
                    <a href="/events/{{ $eventId }}/catering"
                        class="event-submenu-link {{ $currentPage === 'catering' ? 'active' : '' }}">
                        Catering
                    </a>
                @endcan
            @endif

            @if ($eventId == 45)
                @can('show_view')
                    <a href="/events/{{ $eventId }}/show"
                        class="event-submenu-link {{ $currentPage === 'show' ? 'active' : '' }}">
                        Spectacle
                        <span class="badge rounded-pill bg-info">{{ $currentEvent->shows->sum('ticket_count') }}</span>
                    </a>
                @endcan
            @endif

            @if ($hasAdhesionBoPage)
                @can('adherent_view')
                    <a href="/events/{{ $eventId }}/adherents"
                        class="event-submenu-link {{ $currentPage === 'adherents' ? 'active' : '' }}">
                        Adhérents
                    </a>
                @endcan
            @endif

            @can('abstracts_view')
                @if ($currentEvent->has_abstracts)
                    <a href="/events/{{ $eventId }}/abstracts"
                        class="event-submenu-link {{ $currentPage === 'abstracts' ? 'active' : '' }}">
                        Abstracts
                        <span class="badge rounded-pill bg-primary">{{ (int) $abstractCounts->total }}</span>
                        <span class="badge rounded-pill bg-success">{{ (int) $abstractCounts->approved }}</span>
                    </a>
                @endif
            @endcan

            @if ($hasSessions)
                @can('session_view')
                    <a href="/events/{{ $eventId }}/sessions"
                        class="event-submenu-link {{ $currentPage === 'sessions' ? 'active' : '' }}">
                        Sessions
                    </a>
                @endcan
            @endif

            @can('participants_view')
                <a href="/events/{{ $eventId }}/participants"
                    class="event-submenu-link {{ $currentPage === 'participants' ? 'active' : '' }}">
                    Participants
                    <span class="badge rounded-pill bg-primary">{{ (int) $participantCounts->total }}</span>
                    <span class="badge rounded-pill bg-success">{{ (int) $participantCounts->confirmed }}</span>
                    <span class="badge rounded-pill bg-info">{{ (int) $participantCounts->present }}</span>
                </a>
            @endcan

            @can('gestion_view')
                <a href="/events/{{ $eventId }}/manage"
                    class="event-submenu-link {{ $currentPage === 'manage' ? 'active' : '' }}">
                    Gestion
                    <span class="badge rounded-pill bg-primary">{{ (int) $participantCounts->total }}</span>
                    <span class="badge rounded-pill bg-success">{{ (int) $participantCounts->confirmed }}</span>
                    <span class="badge rounded-pill bg-info">{{ (int) $participantCounts->present }}</span>
                </a>
            @endcan

            @if ($currentEvent->has_hebergement_bo)
                @can('hebergement_view')
                    <a href="/events/{{ $eventId }}/hebergement"
                        class="event-submenu-link {{ $currentPage === 'hebergement' ? 'active' : '' }}">
                        Hébergement
                        <span class="badge rounded-pill bg-primary">{{ (int) $roomCounts->total }}</span>
                        <span class="badge rounded-pill bg-success">{{ (int) $roomCounts->with_code }}</span>
                        <span class="badge rounded-pill bg-info">{{ (int) $roomCounts->checked }}</span>
                    </a>
                @endcan

                @can('reservation_view')
                    @if ($eventId == 2)
                        <a href="/events/{{ $eventId }}/reservations"
                            class="event-submenu-link {{ $currentPage === 'reservations' ? 'active' : '' }}">
                            Réservations
                            <span class="badge rounded-pill bg-primary">{{ (int) $reservationCounts->total }}</span>
                            <span class="badge rounded-pill bg-success">{{ (int) $reservationCounts->validated }}</span>
                            <span class="badge rounded-pill bg-warning">{{ (int) $reservationCounts->pending }}</span>
                        </a>
                    @endif
                @endcan

                @can('booking_view')
                    <a href="/events/{{ $eventId }}/booking"
                        class="event-submenu-link {{ $currentPage === 'booking' ? 'active' : '' }}">
                        Booking
                    </a>
                @endcan
            @endif

            @if ($currentEvent->has_evaluation)
                @can('evaluation_view')
                    <a href="/events/{{ $eventId }}/evaluations/results"
                        class="event-submenu-link {{ str_contains($currentPage ?? '', 'evaluation') ? 'active' : '' }}">
                        Evaluations
                        <span class="badge rounded-pill bg-info">{{ (int) $evaluationCount }}</span>
                    </a>
                @endcan
            @endif

            @role(['Admin'])
                @php
                    // Load open forms with responses count to display badges
                    $eventForms = \App\Models\Form::where('event_id', $eventId)
                        ->where('is_closed', false)
                        ->withCount('responses')
                        ->get();
                @endphp
                @foreach ($eventForms as $ef)
                    <a href="{{ route('events.forms.responses.index', ['event' => $eventId, 'form' => $ef->id, 'compact' => 1]) }}"
                        class="event-submenu-link {{ request()->is('events/' . $eventId . '/forms/' . $ef->id . '/responses*') ? 'active' : '' }}">
                        {{ $ef->name }}
                        <span class="badge rounded-pill bg-primary">{{ (int) $ef->responses_count }}</span>
                    </a>
                @endforeach
            @endrole

            @can('gestion_import')
                <a href="/events/{{ $eventId }}/import"
                    class="event-submenu-link {{ $currentPage === 'import' ? 'active' : '' }}">
                    Imports
                </a>
            @endcan

            @role(['Admin'])
                <a href="/events/{{ $eventId }}/regenerate-badges"
                    class="event-submenu-link {{ $currentPage === 'regenerate-badges' ? 'active' : '' }}">
                    Regénérer badges
                </a>
                <a href="/events/{{ $eventId }}/massive-badges"
                    class="event-submenu-link {{ $currentPage === 'massive-badges' ? 'active' : '' }}">
                    Badges massifs
                </a>
                <a href="/events/{{ $eventId }}/workshops"
                    class="event-submenu-link {{ $currentPage === 'workshops' ? 'active' : '' }}">
                    Workshops
                </a>
                <a href="/events/{{ $eventId }}/event-badges"
                    class="event-submenu-link {{ $currentPage === 'event-badges' ? 'active' : '' }}">
                    Badges
                </a>
                <a href="/events/{{ $eventId }}/edit"
                    class="event-submenu-link {{ $currentPage === 'edit' ? 'active' : '' }}">
                    Configuration
                </a>
            @endrole
        </nav>
    </div>
@endif