@extends('layouts.print')

@section('title', 'AR Aging — ' . $today->format('M j, Y'))

@section('content')
@php
    $propName = \App\Models\Setting::get('property_name', config('app.name', 'Parkview Hotel'));
    $bucketMeta = [
        'in_house' => 'In-House', 'current' => 'Current',
        'd1_30' => '1–30 days', 'd31_60' => '31–60 days', 'd60_plus' => '60+ days',
    ];
@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' => 'AR Aging',
        'periodLabel' => 'As of ' . $today->format('M j, Y'),
        'backUrl'     => route('reports.ar-aging'),
    ])

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

        {{-- Aging buckets --}}
        <section>
            <div class="grid grid-cols-5 gap-px bg-gray-200 border border-gray-200 rounded-lg overflow-hidden">
                @foreach($bucketMeta as $key => $label)
                <div class="bg-white px-3 py-3">
                    <p class="text-[9px] font-semibold text-gray-400 uppercase tracking-wider">{{ $label }}</p>
                    <p class="text-base font-black text-gray-900 mt-0.5">₱{{ number_format($buckets[$key], 0) }}</p>
                </div>
                @endforeach
            </div>
            <div class="flex justify-between mt-3 text-xs">
                <span class="text-gray-500">In-house exposure: <span class="font-semibold text-gray-700">₱{{ number_format($inHouseExposure, 2) }}</span> · Departed owing: <span class="font-semibold text-gray-700">₱{{ number_format($departedOwing, 2) }}</span></span>
                <span class="text-gray-700 font-bold">Total Outstanding: ₱{{ number_format($totalOutstanding, 2) }}</span>
            </div>
        </section>

        {{-- Table --}}
        <section>
            <h2 class="text-[10px] font-semibold text-gray-400 uppercase tracking-widest mb-3 pb-1.5 border-b border-gray-200">Outstanding Balances ({{ $accounts }})</h2>
            @if(empty($rows))
            <p class="py-8 text-center text-gray-400 text-sm">No outstanding balances.</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">Check-out</th>
                        <th class="px-3 py-2 text-left text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Aging</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Charges</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Paid</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Balance</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_out']->format('M j, Y') }}</td>
                        <td class="px-3 py-1.5 text-gray-600">{{ $bucketMeta[$row['bucket']] }}{{ $row['days_past'] ? ' · ' . $row['days_past'] . 'd' : '' }}</td>
                        <td class="px-3 py-1.5 text-right text-gray-600">₱{{ number_format($row['charges'], 2) }}</td>
                        <td class="px-3 py-1.5 text-right text-gray-600">₱{{ number_format($row['paid'], 2) }}</td>
                        <td class="px-3 py-1.5 text-right font-semibold text-gray-900">₱{{ number_format($row['balance'], 2) }}</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="7">Total Outstanding</td>
                        <td class="px-3 py-2 text-right text-gray-900">₱{{ number_format($totalOutstanding, 2) }}</td>
                    </tr>
                </tfoot>
            </table>
            @endif
        </section>

        @if(!empty($credits))
        <section>
            <h2 class="text-[10px] font-semibold text-gray-400 uppercase tracking-widest mb-3 pb-1.5 border-b border-gray-200">Credit Balances — possible refunds due</h2>
            <table class="w-full text-xs border border-gray-200">
                <tbody>
                    @foreach($credits as $c)
                    <tr class="border-b border-gray-100">
                        <td class="px-3 py-1.5 text-gray-700 font-medium">{{ $c['guest_name'] }}</td>
                        <td class="px-3 py-1.5 text-gray-500 font-mono">{{ $c['booking_no'] }}</td>
                        <td class="px-3 py-1.5 text-gray-600">Room {{ $c['room_no'] }}</td>
                        <td class="px-3 py-1.5 text-right font-semibold text-gray-900">+₱{{ number_format($c['credit'], 2) }}</td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
        </section>
        @endif

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