@extends('layouts.app')

@section('title', 'Senior/PWD Discount Register')
@section('nav_reports', 'bg-teal-50 text-teal-700 font-semibold')
@section('page_title', 'Reports')
@section('page_subtitle', 'Senior/PWD Discount Register')

@section('content')

@include('reports._filter', [
    'active' => 'reports.discounts', 'mode' => 'range', 'from' => $from, 'to' => $to,
    'title' => 'Senior Citizen / PWD Discount Register',
    'subtitle' => 'RA 9994 / RA 10754 · 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">Total Discount</p>
        <p class="text-teal-700 font-bold text-2xl mt-1">₱{{ number_format($totalDiscount, 2) }}</p>
        <p class="text-gray-400 text-xs mt-1">claimable BIR deduction</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">Senior Citizen</p>
        <p class="text-gray-800 font-bold text-2xl mt-1">{{ $seniorCount }}</p>
        <p class="text-gray-400 text-xs mt-1">discounted stays</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">PWD</p>
        <p class="text-gray-800 font-bold text-2xl mt-1">{{ $pwdCount }}</p>
        <p class="text-gray-400 text-xs mt-1">discounted stays</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">Discount Rate</p>
        <p class="text-gray-800 font-bold text-2xl mt-1">{{ number_format($discountPct, 1) }}%</p>
        <p class="text-gray-400 text-xs mt-1">of ₱{{ number_format($totalGross, 0) }} gross</p>
    </div>
</div>

{{-- Register --}}
<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">Discount Register</h2>
        <p class="text-xs text-gray-400 mt-0.5">20% + VAT-exempt on one guest's share · present with OSCA/PWD IDs for the BIR deduction claim</p>
    </div>
    @if($rows->isEmpty())
    <p class="px-5 py-10 text-center text-gray-300 text-sm">No Senior/PWD discounts granted in this period.</p>
    @else
    <div class="overflow-x-auto">
        <table class="w-full text-sm min-w-[820px]">
            <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">Type</th>
                    <th class="px-4 py-2.5 text-left text-[10px] font-semibold text-gray-400 uppercase tracking-wider">ID No.</th>
                    <th class="px-4 py-2.5 text-right text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Gross</th>
                    <th class="px-4 py-2.5 text-right text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Discount</th>
                    <th class="px-5 py-2.5 text-right text-[10px] font-semibold text-gray-400 uppercase tracking-wider">Net</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 text-gray-600">{{ $row['room_no'] }}</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] {{ $row['type'] === 'senior' ? 'bg-teal-50 text-teal-700 border-teal-200' : 'bg-blue-50 text-blue-700 border-blue-200' }}">
                            {{ $row['type'] === 'senior' ? 'Senior' : 'PWD' }}
                        </span>
                    </td>
                    <td class="px-4 py-3 text-gray-500 font-mono text-xs">{{ $row['id_number'] ?: '—' }}</td>
                    <td class="px-4 py-3 text-right text-gray-600">₱{{ number_format($row['gross'], 2) }}</td>
                    <td class="px-4 py-3 text-right font-semibold text-teal-700">₱{{ number_format($row['discount'], 2) }}</td>
                    <td class="px-5 py-3 text-right text-gray-700">₱{{ number_format($row['net'], 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="5">Total</td>
                    <td class="px-4 py-3 text-right font-bold text-gray-700">₱{{ number_format($totalGross, 2) }}</td>
                    <td class="px-4 py-3 text-right font-bold text-teal-700">₱{{ number_format($totalDiscount, 2) }}</td>
                    <td class="px-5 py-3 text-right font-bold text-gray-700">₱{{ number_format($totalGross - $totalDiscount, 2) }}</td>
                </tr>
            </tfoot>
        </table>
    </div>
    @endif
</div>

@if($byType->isNotEmpty())
<div class="mt-3 flex flex-wrap gap-x-6 gap-y-1 text-xs text-gray-500">
    @foreach($byType as $t)
    <span><span class="font-semibold text-gray-700">{{ $t['label'] }}:</span> {{ $t['count'] }} stay{{ $t['count'] !== 1 ? 's' : '' }} · ₱{{ number_format($t['discount'], 2) }}</span>
    @endforeach
</div>
@endif

<p class="text-[11px] text-gray-400 mt-3">Discount = one qualified guest's share (room total ÷ pax), net of 12% VAT, less 20%. Confirm the interpretation with your accountant before filing.</p>

@endsection