@extends('layouts.app')

@section('title', 'DOT Guest Statistics')
@section('nav_reports', 'bg-teal-50 text-teal-700 font-semibold')
@section('page_title', 'Reports')
@section('page_subtitle', 'DOT Guest Statistics')

@section('content')

@include('reports._filter', [
    'active' => 'reports.dot-statistics', 'mode' => 'range', 'from' => $from, 'to' => $to,
    'title' => 'DOT Guest Arrivals & Guest-Nights by Nationality',
    'subtitle' => 'Arrivals ' . \Carbon\Carbon::parse($from)->format('M j') . ' – ' . \Carbon\Carbon::parse($to)->format('M j, Y'),
])

{{-- Summary tiles --}}
<div class="grid grid-cols-2 lg:grid-cols-4 gap-4 mb-5">
    <div class="bg-white border-[0.5px] border-gray-200 rounded-xl px-5 py-4">
        <p class="text-gray-400 text-xs">Guest Arrivals</p>
        <p class="text-gray-800 font-bold text-2xl mt-1">{{ number_format($totalGuests) }}</p>
        <p class="text-gray-400 text-xs mt-1">persons · {{ number_format($totalArrivals) }} bookings</p>
    </div>
    <div class="bg-white border-[0.5px] border-gray-200 rounded-xl px-5 py-4">
        <p class="text-gray-400 text-xs">Guest-Nights</p>
        <p class="text-teal-700 font-bold text-2xl mt-1">{{ number_format($totalGuestNights) }}</p>
        <p class="text-gray-400 text-xs mt-1">persons × nights</p>
    </div>
    <div class="bg-white border-[0.5px] border-gray-200 rounded-xl px-5 py-4">
        <p class="text-gray-400 text-xs">Domestic / Foreign</p>
        <p class="text-gray-800 font-bold text-2xl mt-1">{{ $domesticArrivals }} <span class="text-gray-300">/</span> {{ $foreignArrivals }}</p>
        <p class="text-gray-400 text-xs mt-1">{{ number_format($domesticNights) }} / {{ number_format($foreignNights) }} guest-nights</p>
    </div>
    <div class="bg-white border-[0.5px] border-gray-200 rounded-xl px-5 py-4">
        <p class="text-gray-400 text-xs">Avg Length of Stay</p>
        <p class="text-gray-800 font-bold text-2xl mt-1">{{ number_format($avgLos, 1) }}<span class="text-base font-semibold text-gray-400">n</span></p>
        <p class="text-gray-400 text-xs mt-1">nights per arrival</p>
    </div>
</div>

{{-- By nationality --}}
<div class="bg-white border-[0.5px] border-gray-200 rounded-xl overflow-hidden">
    <div class="px-5 py-4 border-b border-gray-100">
        <h2 class="text-sm font-semibold text-gray-700">By Nationality</h2>
        <p class="text-xs text-gray-400 mt-0.5">Source markets by guest-nights · for DOT / LGU tourism reporting</p>
    </div>
    @if(empty($byNationality))
    <p class="px-5 py-10 text-center text-gray-300 text-sm">No arrivals for this period.</p>
    @else
    <div class="overflow-x-auto">
        <table class="w-full text-sm min-w-[720px]">
            <thead>
                <tr class="border-b border-gray-100 bg-gray-50/50">
                    <th class="px-5 py-2.5 text-left text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Nationality</th>
                    <th class="px-4 py-2.5 text-right text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Arrivals</th>
                    <th class="px-4 py-2.5 text-right text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Guests</th>
                    <th class="px-4 py-2.5 text-right text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Room-Nights</th>
                    <th class="px-4 py-2.5 text-right text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Guest-Nights</th>
                    <th class="px-5 py-2.5 text-right text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Revenue</th>
                </tr>
            </thead>
            <tbody>
                @foreach($byNationality as $nat => $n)
                <tr class="{{ !$loop->last ? 'border-b border-gray-50' : '' }} hover:bg-gray-50/50 transition-colors">
                    <td class="px-5 py-3">
                        <span class="font-medium text-gray-700">{{ $nat }}</span>
                        <span class="ml-1.5 inline-flex items-center px-1.5 py-0.5 rounded text-[9px] font-bold uppercase tracking-wider {{ $n['domestic'] ? 'bg-teal-50 text-teal-700' : 'bg-blue-50 text-blue-700' }}">{{ $n['domestic'] ? 'Domestic' : 'Foreign' }}</span>
                    </td>
                    <td class="px-4 py-3 text-right text-gray-700">{{ $n['arrivals'] }}</td>
                    <td class="px-4 py-3 text-right text-gray-600">{{ $n['guests'] }}</td>
                    <td class="px-4 py-3 text-right text-gray-600">{{ $n['room_nights'] }}</td>
                    <td class="px-4 py-3 text-right font-semibold text-gray-800">{{ $n['guest_nights'] }}</td>
                    <td class="px-5 py-3 text-right text-gray-600">₱{{ number_format($n['revenue'], 2) }}</td>
                </tr>
                @endforeach
            </tbody>
            <tfoot>
                <tr class="border-t-2 border-gray-200 bg-gray-50/70">
                    <td class="px-5 py-3 text-xs font-bold text-gray-500 uppercase tracking-wider">Total</td>
                    <td class="px-4 py-3 text-right font-bold text-gray-700">{{ $totalArrivals }}</td>
                    <td class="px-4 py-3 text-right font-bold text-gray-700">{{ $totalGuests }}</td>
                    <td class="px-4 py-3 text-right font-bold text-gray-700">{{ $totalRoomNights }}</td>
                    <td class="px-4 py-3 text-right font-bold text-teal-700">{{ $totalGuestNights }}</td>
                    <td class="px-5 py-3"></td>
                </tr>
            </tfoot>
        </table>
    </div>
    @endif
</div>

<p class="text-[11px] text-gray-400 mt-3">Nationality is captured per stay at booking (defaults to Filipino) and frozen on the reservation, so a later guest-profile edit can't reclassify a filed period. Set it on the booking form for accurate figures.</p>

@endsection