@extends('layouts.hirbnd')

@section('title', 'Revenue Report - HIRBND')

@push('styles')
<style>
    /* ===== STICKY HEADER WITH FILTER & STATS ===== */
    .report-sticky-header {
        position: sticky;
        top: 70px;
        z-index: 100;
        background: white;
        box-shadow: 0 4px 12px rgba(0, 0, 0, 0.1);
        border-radius: 12px;
        margin-bottom: 24px;
    }

    .header-content {
        background: linear-gradient(135deg, #28a745, #218838);
        color: white;
        border-radius: 12px 12px 0 0;
        padding: 24px 32px;
    }

    .header-top {
        display: flex;
        justify-content: space-between;
        align-items: start;
        margin-bottom: 20px;
    }

    .header-title h2 {
        font-size: 28px;
        margin-bottom: 4px;
        font-weight: 700;
    }

    .header-title p {
        font-size: 14px;
        opacity: 0.95;
    }

    .header-filter {
        display: flex;
        gap: 12px;
        align-items: center;
        background: rgba(255, 255, 255, 0.15);
        padding: 12px 16px;
        border-radius: 8px;
        backdrop-filter: blur(10px);
    }

    .header-filter label {
        font-size: 13px;
        font-weight: 600;
        margin-right: 8px;
        white-space: nowrap;
    }

    .header-filter select {
        padding: 8px 16px;
        border: 2px solid rgba(255, 255, 255, 0.3);
        border-radius: 6px;
        font-size: 13px;
        background: white;
        color: #333;
        min-width: 150px;
        font-weight: 600;
    }

    .header-filter select:focus {
        outline: none;
        border-color: white;
    }

    .btn-header {
        padding: 8px 20px;
        border: none;
        border-radius: 6px;
        font-weight: 600;
        cursor: pointer;
        font-size: 13px;
        transition: all 0.3s;
        display: flex;
        align-items: center;
        gap: 8px;
    }

    .btn-export {
        background: #0066CC;
        color: white;
    }

    .btn-export:hover {
        background: #0052A3;
        transform: translateY(-2px);
    }

    /* ===== STICKY STATS BAR ===== */
    .stats-bar {
        display: grid;
        grid-template-columns: repeat(4, 1fr);
        gap: 1px;
        background: #e0e0e0;
        border-radius: 0 0 12px 12px;
        overflow: hidden;
    }

    .stat-item {
        background: white;
        padding: 16px 20px;
        text-align: center;
    }

    .stat-item:first-child {
        border-radius: 0 0 0 12px;
    }

    .stat-item:last-child {
        border-radius: 0 0 12px 0;
    }

    .stat-label {
        font-size: 11px;
        color: #6c757d;
        text-transform: uppercase;
        letter-spacing: 0.5px;
        margin-bottom: 6px;
        font-weight: 600;
    }

    .stat-value {
        font-size: 20px;
        font-weight: 700;
        color: #28a745;
    }

    /* ===== REVENUE TABLE WITH STICKY HEADER ===== */
    .revenue-container {
        background: white;
        border-radius: 12px;
        box-shadow: 0 2px 8px rgba(0, 0, 0, 0.1);
        overflow: hidden;
    }

    .revenue-scroll-wrapper {
        overflow: auto;
        max-height: calc(100vh - 400px);
        position: relative;
    }

    .revenue-table {
        width: 100%;
        border-collapse: collapse;
        font-size: 13px;
        min-width: 1200px;
    }

    .revenue-table thead {
        position: sticky;
        top: 0;
        z-index: 10;
    }

    .revenue-table th {
        background: #28a745;
        color: white;
        padding: 14px 8px;
        text-align: center;
        font-weight: 600;
        border: 1px solid #218838;
        white-space: nowrap;
    }

    .revenue-table th:first-child {
        position: sticky;
        left: 0;
        z-index: 11;
        min-width: 120px;
        text-align: left;
        padding-left: 20px;
    }

    .revenue-table td {
        padding: 12px 8px;
        text-align: right;
        border: 1px solid #e0e0e0;
    }

    .revenue-table tbody tr:hover {
        background: #f8f9fa;
    }

    .revenue-table td.room-cell {
        position: sticky;
        left: 0;
        background: #f8f9fa;
        font-weight: 600;
        text-align: left;
        padding-left: 20px;
        z-index: 9;
        border-right: 2px solid #28a745;
    }

    .revenue-table tbody tr:hover td.room-cell {
        background: #d4edda;
    }

    .revenue-table td.amount {
        font-weight: 600;
        color: #28a745;
    }

    .revenue-table td.total-row {
        background: #d4edda;
        font-weight: 700;
        color: #155724;
    }

    .revenue-table td.average-row {
        background: #fff3cd;
        font-weight: 700;
        color: #856404;
    }

    /* ===== EMPTY STATE ===== */
    .empty-state {
        text-align: center;
        padding: 80px 20px;
        color: #6c757d;
    }

    .empty-state i {
        font-size: 64px;
        margin-bottom: 20px;
        color: #dee2e6;
    }

    .empty-state h3 {
        font-size: 20px;
        margin-bottom: 8px;
        color: #495057;
    }

    .empty-state p {
        font-size: 14px;
    }
</style>
@endpush

@section('content')
    @php
        $rooms = [];
        $grandTotal = 0;
        $totalRevenue = 0;
        
        if (isset($revenueData) && !is_null($revenueData)) {
            if($month === 'all') {
                $monthlyRevenue = [];
                
                foreach($revenueData as $monthName => $data) {
                    if ($data && is_iterable($data)) {
                        foreach($data as $record) {
                            $rooms[$record->Room] = true;
                            if(!isset($monthlyRevenue[$record->Room][$monthName])) {
                                $monthlyRevenue[$record->Room][$monthName] = 0;
                            }
                            $monthlyRevenue[$record->Room][$monthName] += $record->Amount_1;
                        }
                    }
                }
                
                $rooms = array_keys($rooms);
                sort($rooms);
                
                $monthlyTotals = [];
                foreach(['january', 'february', 'march', 'april', 'may', 'june', 'july', 'august', 'september', 'october', 'november', 'december'] as $monthName) {
                    $monthlyTotals[$monthName] = 0;
                    foreach($rooms as $room) {
                        $monthlyTotals[$monthName] += $monthlyRevenue[$room][$monthName] ?? 0;
                    }
                }
                
                $grandTotal = array_sum($monthlyTotals);
                
            } else {
                $roomRevenue = [];
                $roomDays = [];
                
                if (is_iterable($revenueData)) {
                    foreach($revenueData as $record) {
                        $rooms[$record->Room] = true;
                        if(!isset($roomRevenue[$record->Room])) {
                            $roomRevenue[$record->Room] = 0;
                            $roomDays[$record->Room] = [];
                        }
                        $roomRevenue[$record->Room] += $record->Amount_1;
                        $day = date('Y-m-d', strtotime($record->Posting_Date));
                        $roomDays[$record->Room][$day] = true;
                    }
                }
                
                $rooms = array_keys($rooms);
                sort($rooms);
                
                $totalRevenue = isset($roomRevenue) ? array_sum($roomRevenue) : 0;
            }
        }
    @endphp

    <!-- STICKY HEADER: Title + Filter + Stats -->
    <div class="report-sticky-header">
        <!-- Header Content with Filter -->
        <div class="header-content">
            <div class="header-top">
                <div class="header-title">
                    <h2><i class="fas fa-chart-line"></i> Revenue Report</h2>
                    <p>Analyze revenue performance by room and month</p>
                </div>

                <form method="GET" action="{{ route('hirbnd.reports.revenue') }}" class="header-filter">
                    <label for="monthFilter"><i class="fas fa-calendar-alt"></i> Period:</label>
                    <select id="monthFilter" name="month" onchange="this.form.submit()">
                        <option value="all" {{ $month === 'all' ? 'selected' : '' }}>All Months</option>
                        <option value="january" {{ $month === 'january' ? 'selected' : '' }}>January</option>
                        <option value="february" {{ $month === 'february' ? 'selected' : '' }}>February</option>
                        <option value="march" {{ $month === 'march' ? 'selected' : '' }}>March</option>
                        <option value="april" {{ $month === 'april' ? 'selected' : '' }}>April</option>
                        <option value="may" {{ $month === 'may' ? 'selected' : '' }}>May</option>
                        <option value="june" {{ $month === 'june' ? 'selected' : '' }}>June</option>
                        <option value="july" {{ $month === 'july' ? 'selected' : '' }}>July</option>
                        <option value="august" {{ $month === 'august' ? 'selected' : '' }}>August</option>
                        <option value="september" {{ $month === 'september' ? 'selected' : '' }}>September</option>
                        <option value="october" {{ $month === 'october' ? 'selected' : '' }}>October</option>
                        <option value="november" {{ $month === 'november' ? 'selected' : '' }}>November</option>
                        <option value="december" {{ $month === 'december' ? 'selected' : '' }}>December</option>
                    </select>

                    <button type="button" onclick="exportToExcel()" class="btn-header btn-export">
                        <i class="fas fa-file-excel"></i> Export
                    </button>
                </form>
            </div>
        </div>

        <!-- Stats Bar (Sticky with Header) -->
        <div class="stats-bar">
            <div class="stat-item">
                <div class="stat-label"><i class="fas fa-dollar-sign"></i> Total Revenue</div>
                <div class="stat-value">Rp {{ number_format($month === 'all' ? $grandTotal : $totalRevenue, 0, ',', '.') }}</div>
            </div>

            <div class="stat-item">
                <div class="stat-label"><i class="fas fa-chart-bar"></i> Avg/Room</div>
                <div class="stat-value">Rp {{ count($rooms) > 0 ? number_format(($month === 'all' ? $grandTotal : $totalRevenue) / count($rooms), 0, ',', '.') : 0 }}</div>
            </div>

            <div class="stat-item">
                <div class="stat-label"><i class="fas fa-bed"></i> Rooms</div>
                <div class="stat-value">{{ count($rooms) }}</div>
            </div>

            <div class="stat-item">
                <div class="stat-label"><i class="fas fa-calendar-check"></i> Period</div>
                <div class="stat-value" style="font-size: 16px;">{{ $month === 'all' ? 'All Months' : ucfirst($month) }}</div>
            </div>
        </div>
    </div>

    <!-- REVENUE TABLE with Sticky Header & Sticky First Column -->
    <div class="revenue-container">
        @if(count($rooms) === 0)
            <div class="empty-state">
                <i class="fas fa-inbox"></i>
                <h3>No Revenue Data Found</h3>
                <p>There are no revenue records for the selected period.</p>
            </div>
        @else
            <div class="revenue-scroll-wrapper">
                @if($month === 'all')
                    {{-- All Months View --}}
                    <table class="revenue-table">
                        <thead>
                            <tr>
                                <th>Room</th>
                                @foreach(['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'] as $monthName)
                                    <th>{{ $monthName }}</th>
                                @endforeach
                                <th>Total</th>
                                <th>Average</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($rooms as $room)
                                <tr>
                                    <td class="room-cell">Room {{ $room }}</td>
                                    @php
                                        $roomTotal = 0;
                                        $roomCount = 0;
                                    @endphp
                                    @foreach(['january', 'february', 'march', 'april', 'may', 'june', 'july', 'august', 'september', 'october', 'november', 'december'] as $monthName)
                                        @php
                                            $amount = $monthlyRevenue[$room][$monthName] ?? 0;
                                            $roomTotal += $amount;
                                            if($amount > 0) $roomCount++;
                                        @endphp
                                        <td class="amount">{{ number_format($amount, 0, ',', '.') }}</td>
                                    @endforeach
                                    <td class="amount" style="font-weight: 700;">{{ number_format($roomTotal, 0, ',', '.') }}</td>
                                    <td class="amount">{{ $roomCount > 0 ? number_format($roomTotal / $roomCount, 0, ',', '.') : 0 }}</td>
                                </tr>
                            @endforeach
                            
                            {{-- Total Row --}}
                            <tr>
                                <td class="total-row" style="text-align: left;">TOTAL</td>
                                @foreach(['january', 'february', 'march', 'april', 'may', 'june', 'july', 'august', 'september', 'october', 'november', 'december'] as $monthName)
                                    <td class="total-row">{{ number_format($monthlyTotals[$monthName], 0, ',', '.') }}</td>
                                @endforeach
                                <td class="total-row">{{ number_format($grandTotal, 0, ',', '.') }}</td>
                                <td class="total-row">-</td>
                            </tr>
                            
                            {{-- Average Row --}}
                            <tr>
                                <td class="average-row" style="text-align: left;">AVERAGE</td>
                                @foreach(['january', 'february', 'march', 'april', 'may', 'june', 'july', 'august', 'september', 'october', 'november', 'december'] as $monthName)
                                    <td class="average-row">{{ count($rooms) > 0 ? number_format($monthlyTotals[$monthName] / count($rooms), 0, ',', '.') : 0 }}</td>
                                @endforeach
                                <td class="average-row">{{ count($rooms) > 0 ? number_format($grandTotal / count($rooms), 0, ',', '.') : 0 }}</td>
                                <td class="average-row">-</td>
                            </tr>
                        </tbody>
                    </table>
                @else
                    {{-- Single Month View --}}
                    <table class="revenue-table">
                        <thead>
                            <tr>
                                <th>Room</th>
                                <th>Revenue</th>
                                <th>Days Occupied</th>
                                <th>ADR (Avg Daily Rate)</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($rooms as $room)
                                @php
                                    $revenue = $roomRevenue[$room] ?? 0;
                                    $days = isset($roomDays[$room]) ? count($roomDays[$room]) : 0;
                                    $adr = $days > 0 ? $revenue / $days : 0;
                                @endphp
                                <tr>
                                    <td class="room-cell">Room {{ $room }}</td>
                                    <td class="amount">{{ number_format($revenue, 0, ',', '.') }}</td>
                                    <td style="text-align: center; font-weight: 600;">{{ $days }}</td>
                                    <td class="amount">{{ number_format($adr, 0, ',', '.') }}</td>
                                </tr>
                            @endforeach
                            
                            {{-- Total Row --}}
                            <tr>
                                <td class="total-row" style="text-align: left;">TOTAL</td>
                                <td class="total-row">{{ number_format($totalRevenue, 0, ',', '.') }}</td>
                                <td class="total-row" colspan="2">-</td>
                            </tr>
                        </tbody>
                    </table>
                @endif
            </div>
        @endif
    </div>
@endsection

@push('scripts')
<script>
    function exportToExcel() {
        alert('Excel export feature coming soon!');
    }
</script>
@endpush