@extends('layouts.app')

@section('title', 'Advance Deposits')
@section('nav_reports', 'bg-teal-50 text-teal-700 font-semibold')
@section('page_title', 'Reports')
@section('page_subtitle', 'Advance Deposits')

@section('content')

@include('reports._filter', [
    'active' => 'reports.advance-deposits', 'mode' => 'date', 'date' => $asOf,
    'title' => 'Advance Deposits / Unearned Revenue',
    'subtitle' => 'Prepayments held for stays not yet completed as of ' . \Carbon\Carbon::parse($asOf)->format('l, F 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">Advance Deposits Held</p>
        <p class="text-teal-700 font-bold text-2xl mt-1">₱{{ number_format($totalHeld, 2) }}</p>
        <p class="text-gray-400 text-xs mt-1">unearned revenue (liability)</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">Prepaid Bookings</p>
        <p class="text-gray-800 font-bold text-2xl mt-1">{{ number_format($bookings) }}</p>
        <p class="text-gray-400 text-xs mt-1">upcoming &amp; in-house stays with a deposit</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 per Booking</p>
        <p class="text-gray-800 font-bold text-2xl mt-1">₱{{ $bookings > 0 ? number_format($totalHeld / $bookings, 2) : '0.00' }}</p>
        <p class="text-gray-400 text-xs mt-1">average deposit held</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">Payment Methods</p>
        <p class="text-gray-800 font-bold text-2xl mt-1">{{ count($byMethod) }}</p>
        <p class="text-gray-400 text-xs mt-1">channels used</p>
    </div>
</div>

<div class="grid grid-cols-1 xl:grid-cols-2 gap-5 mb-5">
    {{-- By method --}}
    <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 Payment Method</h2>
        </div>
        @if(empty($byMethod))
        <p class="px-5 py-8 text-center text-gray-300 text-sm">No deposits held.</p>
        @else
        <div class="overflow-x-auto">
        <table class="w-full text-sm">
            <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">Method</th>
                    <th class="px-4 py-2.5 text-right text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Payments</th>
                    <th class="px-5 py-2.5 text-right text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Amount</th>
                </tr>
            </thead>
            <tbody>
                @foreach($byMethod as $method => $m)
                <tr class="{{ !$loop->last ? 'border-b border-gray-50' : '' }} hover:bg-gray-50/50 transition-colors">
                    <td class="px-5 py-3 font-medium text-gray-700">{{ $method }}</td>
                    <td class="px-4 py-3 text-right text-gray-600">{{ $m['count'] }}</td>
                    <td class="px-5 py-3 text-right font-semibold text-gray-800">₱{{ number_format($m['total'], 2) }}</td>
                </tr>
                @endforeach
            </tbody>
        </table>
        </div>
        @endif
    </div>

    {{-- By arrival month --}}
    <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 Arrival Month</h2>
            <p class="text-xs text-gray-400 mt-0.5">When these deposits will be earned</p>
        </div>
        @if(empty($byMonth))
        <p class="px-5 py-8 text-center text-gray-300 text-sm">No deposits held.</p>
        @else
        <div class="overflow-x-auto">
        <table class="w-full text-sm">
            <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">Arrival Month</th>
                    <th class="px-4 py-2.5 text-right text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Bookings</th>
                    <th class="px-5 py-2.5 text-right text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Held</th>
                </tr>
            </thead>
            <tbody>
                @foreach($byMonth as $m)
                <tr class="{{ !$loop->last ? 'border-b border-gray-50' : '' }} hover:bg-gray-50/50 transition-colors">
                    <td class="px-5 py-3 font-medium text-gray-700">{{ $m['label'] }}</td>
                    <td class="px-4 py-3 text-right text-gray-600">{{ $m['count'] }}</td>
                    <td class="px-5 py-3 text-right font-semibold text-gray-800">₱{{ number_format($m['total'], 2) }}</td>
                </tr>
                @endforeach
            </tbody>
        </table>
        </div>
        @endif
    </div>
</div>

{{-- Detail --}}
<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">Prepaid Upcoming &amp; In-House Stays</h2>
        <p class="text-xs text-gray-400 mt-0.5">Stays not yet completed · ordered by arrival date</p>
    </div>
    @if(empty($rows))
    <p class="px-5 py-10 text-center text-gray-300 text-sm">No advance deposits held as of this date.</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">Guest / Booking</th>
                    <th class="px-4 py-2.5 text-left text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Room</th>
                    <th class="px-4 py-2.5 text-left text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Arrival</th>
                    <th class="px-4 py-2.5 text-left text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Status</th>
                    <th class="px-4 py-2.5 text-right text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Booking Value</th>
                    <th class="px-4 py-2.5 text-right text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Prepaid</th>
                    <th class="px-5 py-2.5 text-right text-[10px] font-semibold text-gray-400 uppercase tracking-wider">% Paid</th>
                </tr>
            </thead>
            <tbody>
                @foreach($rows as $row)
                <tr class="{{ !$loop->last ? 'border-b border-gray-50' : '' }} hover:bg-gray-50/50 transition-colors">
                    <td class="px-5 py-3">
                        <p class="font-medium text-gray-700">{{ $row['guest_name'] }}</p>
                        <p class="text-[10px] text-gray-400 font-mono">{{ $row['booking_no'] }}</p>
                    </td>
                    <td class="px-4 py-3">
                        <p class="text-gray-700">{{ $row['room_no'] }}</p>
                        <p class="text-[10px] text-gray-400">{{ $row['room_type'] }}</p>
                    </td>
                    <td class="px-4 py-3 text-gray-600">{{ $row['check_in']->format('M j, Y') }}</td>
                    <td class="px-4 py-3">
                        <span class="inline-flex items-center px-2 py-0.5 rounded-full text-[10px] font-semibold border-[0.5px] {{ \Illuminate\Support\Str::headline($row['status']) === 'Checked In' ? 'bg-green-50 text-green-700 border-green-200' : 'bg-teal-50 text-teal-700 border-teal-200' }}">
                            {{ \Illuminate\Support\Str::headline($row['status']) }}
                        </span>
                    </td>
                    <td class="px-4 py-3 text-right text-gray-600">₱{{ number_format($row['amount'], 2) }}</td>
                    <td class="px-4 py-3 text-right font-semibold text-teal-700">₱{{ number_format($row['prepaid'], 2) }}</td>
                    <td class="px-5 py-3 text-right text-gray-500">{{ $row['pct'] }}%</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" colspan="5">Total Held</td>
                    <td class="px-4 py-3 text-right font-bold text-teal-700">₱{{ number_format($totalHeld, 2) }}</td>
                    <td class="px-5 py-3"></td>
                </tr>
            </tfoot>
        </table>
    </div>
    @endif
</div>

@endsection