@extends('layouts.app')

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

@section('content')
@php
    $bucketMeta = [
        'in_house' => ['In-House', 'text-blue-700'],
        'current'  => ['Current', 'text-gray-600'],
        'd1_30'    => ['1–30 days', 'text-amber-600'],
        'd31_60'   => ['31–60 days', 'text-orange-600'],
        'd60_plus' => ['60+ days', 'text-red-600'],
    ];
@endphp

@include('reports._filter', [
    'active' => 'reports.ar-aging', 'mode' => 'none',
    'title' => 'AR Aging / Outstanding Balances',
    'subtitle' => 'Live snapshot as of ' . $today->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">Total Outstanding</p>
        <p class="text-red-600 font-bold text-2xl mt-1">₱{{ number_format($totalOutstanding, 2) }}</p>
        <p class="text-gray-400 text-xs mt-1">{{ $accounts }} account{{ $accounts !== 1 ? 's' : '' }} owing</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">In-House Exposure</p>
        <p class="text-blue-700 font-bold text-2xl mt-1">₱{{ number_format($inHouseExposure, 2) }}</p>
        <p class="text-gray-400 text-xs mt-1">still checked in</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">Departed Owing</p>
        <p class="text-gray-800 font-bold text-2xl mt-1">₱{{ number_format($departedOwing, 2) }}</p>
        <p class="text-gray-400 text-xs mt-1">checked out, unpaid</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">Credit Balances</p>
        <p class="text-gray-800 font-bold text-2xl mt-1">₱{{ number_format($creditTotal < 0 ? -$creditTotal : 0, 2) }}</p>
        <p class="text-gray-400 text-xs mt-1">{{ count($credits) }} over-payment{{ count($credits) !== 1 ? 's' : '' }}</p>
    </div>
</div>

{{-- Aging bucket strip --}}
<div class="grid grid-cols-2 sm:grid-cols-5 gap-3 mb-5">
    @foreach($bucketMeta as $key => [$label, $color])
    <div class="bg-white border-[0.5px] border-gray-200 rounded-xl px-4 py-3">
        <p class="text-gray-400 text-[10px] uppercase tracking-wider font-semibold">{{ $label }}</p>
        <p class="{{ $color }} font-bold text-lg mt-0.5">₱{{ number_format($buckets[$key], 0) }}</p>
    </div>
    @endforeach
</div>

{{-- Main table --}}
<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">Outstanding Balances</h2>
        <p class="text-xs text-gray-400 mt-0.5">Highest balance first · in-house guests and departed-but-unpaid stays</p>
    </div>
    @if(empty($rows))
    <p class="px-5 py-10 text-center text-gray-300 text-sm">No outstanding balances — everyone's settled. 🎉</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">Check-out</th>
                    <th class="px-4 py-2.5 text-left text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Aging</th>
                    <th class="px-4 py-2.5 text-right text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Charges</th>
                    <th class="px-4 py-2.5 text-right text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Paid</th>
                    <th class="px-5 py-2.5 text-right text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Balance</th>
                </tr>
            </thead>
            <tbody>
                @foreach($rows as $row)
                @php [$blabel, $bcolor] = $bucketMeta[$row['bucket']]; @endphp
                <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_out']->format('M j, Y') }}</td>
                    <td class="px-4 py-3">
                        <span class="text-xs font-semibold {{ $bcolor }}">{{ $blabel }}</span>
                        @if($row['days_past'] !== null && $row['days_past'] > 0)
                        <span class="text-[10px] text-gray-400">· {{ $row['days_past'] }}d</span>
                        @endif
                    </td>
                    <td class="px-4 py-3 text-right text-gray-600">₱{{ number_format($row['charges'], 2) }}</td>
                    <td class="px-4 py-3 text-right text-gray-600">₱{{ number_format($row['paid'], 2) }}</td>
                    <td class="px-5 py-3 text-right font-bold text-red-600">₱{{ number_format($row['balance'], 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" colspan="6">Total Outstanding</td>
                    <td class="px-5 py-3 text-right font-bold text-red-700">₱{{ number_format($totalOutstanding, 2) }}</td>
                </tr>
            </tfoot>
        </table>
    </div>
    @endif
</div>

@if(!empty($credits))
<div class="bg-white border-[0.5px] border-gray-200 rounded-xl overflow-hidden mt-5">
    <div class="px-5 py-4 border-b border-gray-100">
        <h2 class="text-sm font-semibold text-gray-700">Credit Balances <span class="font-normal text-gray-400">— possible refunds due</span></h2>
    </div>
    <div class="overflow-x-auto">
        <table class="w-full text-sm min-w-[420px]">
            <tbody>
                @foreach($credits as $c)
                <tr class="{{ !$loop->last ? 'border-b border-gray-50' : '' }}">
                    <td class="px-5 py-2.5 font-medium text-gray-700">{{ $c['guest_name'] }} <span class="text-[10px] text-gray-400 font-mono">{{ $c['booking_no'] }}</span></td>
                    <td class="px-4 py-2.5 text-gray-500">Room {{ $c['room_no'] }}</td>
                    <td class="px-5 py-2.5 text-right font-semibold text-blue-700">+₱{{ number_format($c['credit'], 2) }}</td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div>
@endif

@endsection