@extends('layouts.print')

@section('title', 'Revenue Report — ' . \Carbon\Carbon::parse($from)->format('M j') . '–' . \Carbon\Carbon::parse($to)->format('M j, Y'))

@section('content')
@php
    $periodLabel = \Carbon\Carbon::parse($from)->format('M j') . ' – ' . \Carbon\Carbon::parse($to)->format('M j, Y');
    $propName    = \App\Models\Setting::get('property_name', config('app.name', 'Parkview Hotel'));
    $pmTotal     = (float) $byPaymentMethod->sum('total');
@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' => 'Revenue Report',
        'periodLabel' => $periodLabel,
        'backUrl'     => route('reports.revenue', ['from' => $from, 'to' => $to]),
    ])

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

        {{-- Summary --}}
        <section>
            <h2 class="text-[10px] font-semibold text-gray-400 uppercase tracking-widest mb-3 pb-1.5 border-b border-gray-200">Summary <span class="font-normal normal-case tracking-normal text-gray-300">· reservations checked in during period</span></h2>
            <div class="grid grid-cols-4 gap-px bg-gray-200 border border-gray-200 rounded-lg overflow-hidden">
                @foreach([
                    ['Total Revenue', '₱' . number_format($totalRevenue, 2), 'booked room revenue'],
                    ['Reservations', number_format($totalCount), 'checked in'],
                    ['Avg / Booking', $totalCount > 0 ? '₱' . number_format($totalRevenue / $totalCount, 2) : '—', 'per reservation'],
                    ['Total Collected', '₱' . number_format($totalPaid, 2), 'payments on record'],
                ] 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 room type --}}
        <section>
            <h2 class="text-[10px] font-semibold text-gray-400 uppercase tracking-widest mb-3 pb-1.5 border-b border-gray-200">By Room Type</h2>
            @if($byRoomType->isEmpty())
            <p class="py-6 text-center text-gray-400 text-sm">No data for this period.</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">Room Type</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Bookings</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Avg Nights</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">ADR</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Revenue</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Share</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($byRoomType as $type => $row)
                    <tr class="border-b border-gray-100">
                        <td class="px-3 py-1.5 text-gray-700 font-medium">{{ $type }}</td>
                        <td class="px-3 py-1.5 text-right text-gray-700">{{ $row['count'] }}</td>
                        <td class="px-3 py-1.5 text-right text-gray-600">{{ $row['avg_nights'] }}</td>
                        <td class="px-3 py-1.5 text-right text-gray-600">₱{{ number_format($row['adr'], 2) }}</td>
                        <td class="px-3 py-1.5 text-right font-semibold text-gray-800">₱{{ number_format($row['revenue'], 2) }}</td>
                        <td class="px-3 py-1.5 text-right text-gray-500">{{ $row['share'] }}%</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">Total</td>
                        <td class="px-3 py-2 text-right text-gray-800">{{ $byRoomType->sum('count') }}</td>
                        <td class="px-3 py-2"></td>
                        <td class="px-3 py-2"></td>
                        <td class="px-3 py-2 text-right text-gray-900">₱{{ number_format($totalRevenue, 2) }}</td>
                        <td class="px-3 py-2 text-right text-gray-600">100%</td>
                    </tr>
                </tfoot>
            </table>
            @endif
        </section>

        {{-- By booking source --}}
        <section>
            <h2 class="text-[10px] font-semibold text-gray-400 uppercase tracking-widest mb-3 pb-1.5 border-b border-gray-200">By Booking Source</h2>
            @if($bySource->isEmpty())
            <p class="py-6 text-center text-gray-400 text-sm">No data for this period.</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">Source</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Bookings</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Avg Stay</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Revenue</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Share</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($bySource as $source => $row)
                    <tr class="border-b border-gray-100">
                        <td class="px-3 py-1.5 text-gray-700 font-medium">{{ $source }}</td>
                        <td class="px-3 py-1.5 text-right text-gray-700">{{ $row['count'] }}</td>
                        <td class="px-3 py-1.5 text-right text-gray-600">{{ $row['avg_nights'] }}n</td>
                        <td class="px-3 py-1.5 text-right font-semibold text-gray-800">₱{{ number_format($row['revenue'], 2) }}</td>
                        <td class="px-3 py-1.5 text-right text-gray-500">{{ $row['share'] }}%</td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
            @endif
        </section>

        {{-- By rate plan --}}
        <section>
            <h2 class="text-[10px] font-semibold text-gray-400 uppercase tracking-widest mb-3 pb-1.5 border-b border-gray-200">By Rate Plan</h2>
            @if($byRatePlan->isEmpty())
            <p class="py-6 text-center text-gray-400 text-sm">No data for this period.</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">Code</th>
                        <th class="px-3 py-2 text-left text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Rate Plan</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Bookings</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Revenue</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Share</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($byRatePlan as $row)
                    <tr class="border-b border-gray-100">
                        <td class="px-3 py-1.5 text-gray-500 font-mono">{{ $row['code'] }}</td>
                        <td class="px-3 py-1.5 text-gray-700 font-medium">{{ $row['name'] }}</td>
                        <td class="px-3 py-1.5 text-right text-gray-700">{{ $row['count'] }}</td>
                        <td class="px-3 py-1.5 text-right font-semibold text-gray-800">₱{{ number_format($row['revenue'], 2) }}</td>
                        <td class="px-3 py-1.5 text-right text-gray-500">{{ $row['share'] }}%</td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
            @endif
        </section>

        {{-- By payment method --}}
        <section>
            <h2 class="text-[10px] font-semibold text-gray-400 uppercase tracking-widest mb-3 pb-1.5 border-b border-gray-200">Payment Methods <span class="font-normal normal-case tracking-normal text-gray-300">· collected for these reservations</span></h2>
            @if($byPaymentMethod->isEmpty())
            <p class="py-6 text-center text-gray-400 text-sm">No payment records for this period.</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">Transactions</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Amount</th>
                        <th class="px-3 py-2 text-right text-[10px] font-semibold text-gray-500 uppercase tracking-wider">Share</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($byPaymentMethod as $pm)
                    <tr class="border-b border-gray-100">
                        <td class="px-3 py-1.5 text-gray-700 font-medium">{{ $pm->method }}</td>
                        <td class="px-3 py-1.5 text-right text-gray-600">{{ $pm->cnt }}</td>
                        <td class="px-3 py-1.5 text-right font-semibold text-gray-800">₱{{ number_format($pm->total, 2) }}</td>
                        <td class="px-3 py-1.5 text-right text-gray-500">{{ $pmTotal > 0 ? round($pm->total / $pmTotal * 100, 1) : 0 }}%</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">Total</td>
                        <td class="px-3 py-2 text-right text-gray-800">{{ $byPaymentMethod->sum('cnt') }}</td>
                        <td class="px-3 py-2 text-right text-gray-900">₱{{ number_format($pmTotal, 2) }}</td>
                        <td class="px-3 py-2 text-right text-gray-600">100%</td>
                    </tr>
                </tfoot>
            </table>
            @endif
        </section>

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

    </div>
</div>
@endsection