@extends('layouts.print')

@section('title', 'Advance Deposits — ' . \Carbon\Carbon::parse($asOf)->format('M j, Y'))

@section('content')
@php
    $propName = \App\Models\Setting::get('property_name', config('app.name', 'Parkview Hotel'));
@endphp

<div class="max-w-4xl mx-auto my-8 bg-white shadow-sm rounded-xl overflow-hidden border border-gray-200
            print:shadow-none print:border-0 print:rounded-none print:my-0 print:max-w-none">

    @include('reports.print._letterhead', [
        'reportTitle' => 'Advance Deposits',
        'periodLabel' => 'As of ' . \Carbon\Carbon::parse($asOf)->format('M j, Y'),
        'backUrl'     => route('reports.advance-deposits', ['date' => $asOf]),
    ])

    <div class="px-10 py-8 space-y-7">

        {{-- Summary --}}
        <section>
            <div class="grid grid-cols-3 gap-px bg-gray-200 border border-gray-200 rounded-lg overflow-hidden">
                @foreach([
                    ['Advance Deposits Held', '₱' . number_format($totalHeld, 2), 'unearned revenue (liability)'],
                    ['Prepaid Bookings', number_format($bookings), 'upcoming & in-house, with a deposit'],
                    ['Avg per Booking', $bookings > 0 ? '₱' . number_format($totalHeld / $bookings, 2) : '₱0.00', 'average deposit'],
                ] as [$label, $value, $sub])
                <div class="bg-white px-4 py-3">
                    <p class="text-[10px] font-semibold text-gray-400 uppercase tracking-wider">{{ $label }}</p>
                    <p class="text-lg font-black text-gray-900 mt-0.5">{{ $value }}</p>
                    <p class="text-[10px] text-gray-400">{{ $sub }}</p>
                </div>
                @endforeach
            </div>
        </section>

        {{-- By method + by month --}}
        <section class="grid grid-cols-2 gap-6">
            <div>
                <h2 class="text-[10px] font-semibold text-gray-400 uppercase tracking-widest mb-3 pb-1.5 border-b border-gray-200">By Payment Method</h2>
                @if(empty($byMethod))
                <p class="py-4 text-center text-gray-400 text-sm">None.</p>
                @else
                <table class="w-full text-xs border border-gray-200">
                    <thead>
                        <tr class="bg-gray-50 border-b border-gray-200">
                            <th class="px-3 py-2 text-left text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Method</th>
                            <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Pmts</th>
                            <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Amount</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($byMethod as $method => $m)
                        <tr class="border-b border-gray-100">
                            <td class="px-3 py-1.5 text-gray-700 font-medium">{{ $method }}</td>
                            <td class="px-3 py-1.5 text-right text-gray-600">{{ $m['count'] }}</td>
                            <td class="px-3 py-1.5 text-right font-semibold text-gray-800">₱{{ number_format($m['total'], 2) }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
                @endif
            </div>
            <div>
                <h2 class="text-[10px] font-semibold text-gray-400 uppercase tracking-widest mb-3 pb-1.5 border-b border-gray-200">By Arrival Month</h2>
                @if(empty($byMonth))
                <p class="py-4 text-center text-gray-400 text-sm">None.</p>
                @else
                <table class="w-full text-xs border border-gray-200">
                    <thead>
                        <tr class="bg-gray-50 border-b border-gray-200">
                            <th class="px-3 py-2 text-left text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Month</th>
                            <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Bkgs</th>
                            <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Held</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($byMonth as $m)
                        <tr class="border-b border-gray-100">
                            <td class="px-3 py-1.5 text-gray-700 font-medium">{{ $m['label'] }}</td>
                            <td class="px-3 py-1.5 text-right text-gray-600">{{ $m['count'] }}</td>
                            <td class="px-3 py-1.5 text-right font-semibold text-gray-800">₱{{ number_format($m['total'], 2) }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
                @endif
            </div>
        </section>

        {{-- Detail --}}
        <section>
            <h2 class="text-[10px] font-semibold text-gray-400 uppercase tracking-widest mb-3 pb-1.5 border-b border-gray-200">Prepaid Upcoming &amp; In-House Stays ({{ $bookings }})</h2>
            @if(empty($rows))
            <p class="py-6 text-center text-gray-400 text-sm">No advance deposits held as of this date.</p>
            @else
            <table class="w-full text-xs border border-gray-200">
                <thead>
                    <tr class="bg-gray-50 border-b border-gray-200">
                        <th class="px-3 py-2 text-left text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Guest</th>
                        <th class="px-3 py-2 text-left text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Booking #</th>
                        <th class="px-3 py-2 text-left text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Room</th>
                        <th class="px-3 py-2 text-left text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Arrival</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Value</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Prepaid</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">% Paid</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($rows as $row)
                    <tr class="border-b border-gray-100">
                        <td class="px-3 py-1.5 text-gray-700 font-medium">{{ $row['guest_name'] }}</td>
                        <td class="px-3 py-1.5 text-gray-500 font-mono">{{ $row['booking_no'] }}</td>
                        <td class="px-3 py-1.5 text-gray-600">{{ $row['room_no'] }}</td>
                        <td class="px-3 py-1.5 text-gray-600">{{ $row['check_in']->format('M j, Y') }}</td>
                        <td class="px-3 py-1.5 text-right text-gray-600">₱{{ number_format($row['amount'], 2) }}</td>
                        <td class="px-3 py-1.5 text-right font-semibold text-gray-800">₱{{ number_format($row['prepaid'], 2) }}</td>
                        <td class="px-3 py-1.5 text-right text-gray-500">{{ $row['pct'] }}%</td>
                    </tr>
                    @endforeach
                </tbody>
                <tfoot>
                    <tr class="border-t-2 border-gray-300 bg-gray-50 font-bold">
                        <td class="px-3 py-2 text-[10px] text-gray-600 uppercase tracking-wider" colspan="5">Total Held</td>
                        <td class="px-3 py-2 text-right text-gray-900">₱{{ number_format($totalHeld, 2) }}</td>
                        <td class="px-3 py-2"></td>
                    </tr>
                </tfoot>
            </table>
            @endif
        </section>

        <div class="pt-4 border-t border-gray-100 flex items-center justify-between text-[10px] text-gray-300">
            <span>{{ $propName }} · Advance Deposits</span>
            <span>Printed {{ now()->format('M j, Y g:i A') }}</span>
        </div>
    </div>
</div>
@endsection