@extends('layouts.app')
@section('content')
<div class="max-w-7xl mx-auto p-6">
    <h1 class="text-2xl font-semibold mb-6">Executive Dashboard</h1>
    <div class="grid grid-cols-1 sm:grid-cols-2 lg:grid-cols-4 gap-4 mb-6">
        <div class="p-4 bg-white rounded shadow">
            <div class="text-sm text-gray-500">Total Units</div>
            <div class="text-2xl font-semibold">{{ $totalUnits }}</div>
            <div class="text-xs text-gray-500 mt-1">Sold: {{ $soldUnits }} • Available: {{ $availableUnits }} • Reserved: {{ $reservedUnits }}</div>
        </div>
        <div class="p-4 bg-white rounded shadow">
            <div class="text-sm text-gray-500">Total Bookings (MTD)</div>
            <div class="text-2xl font-semibold">{{ $bookingsMtd }}</div>
            <div class="text-xs text-gray-500 mt-1">Amount: {{ number_format($bookingsMtdAmount, 2) }}</div>
        </div>
        <div class="p-4 bg-white rounded shadow">
            <div class="text-sm text-gray-500">Revenue Collected (MTD)</div>
            <div class="text-2xl font-semibold">{{ number_format($revenueMtd, 2) }}</div>
            <div class="text-xs mt-1 {{ $revenuePct!==null && $revenuePct>=0 ? 'text-green-600' : 'text-red-600' }}">{{ $revenuePct!==null ? $revenuePct.'%' : '-' }}</div>
        </div>
        <div class="p-4 bg-white rounded shadow">
            <div class="text-sm text-gray-500">Pending Installments</div>
            <div class="text-2xl font-semibold">{{ $pendingInstCount }}</div>
            <div class="text-xs text-gray-500 mt-1">Amount: {{ number_format($pendingInstAmount, 2) }}</div>
        </div>
        <div class="p-4 bg-white rounded shadow">
            <div class="text-sm text-gray-500">Overdue Amount</div>
            <div class="text-2xl font-semibold">{{ number_format($overdueAmount, 2) }}</div>
            <div class="text-xs text-gray-500 mt-1">Overdue: {{ $overdueCount }}</div>
        </div>
        <div class="p-4 bg-white rounded shadow">
            <div class="text-sm text-gray-500">Fine Collected (MTD)</div>
            <div class="text-2xl font-semibold">{{ number_format($fineCollectedMtm, 2) }}</div>
        </div>
        <div class="p-4 bg-white rounded shadow">
            <div class="text-sm text-gray-500">Active Customers</div>
            <div class="text-2xl font-semibold">{{ $activeCustomers }}</div>
        </div>
    </div>
    <div class="grid grid-cols-1 lg:grid-cols-3 gap-6">
        <div class="lg:col-span-2">
            <div class="bg-white rounded shadow overflow-hidden">
                <div class="px-4 py-2 font-semibold bg-gray-50">Recent Bookings</div>
                <table class="min-w-full">
                    <thead class="bg-gray-50">
                        <tr>
                            <th class="px-4 py-2 text-left text-xs font-medium text-gray-500">Booking#</th>
                            <th class="px-4 py-2 text-left text-xs font-medium text-gray-500">Customer</th>
                            <th class="px-4 py-2 text-left text-xs font-medium text-gray-500">Unit#</th>
                            <th class="px-4 py-2 text-right text-xs font-medium text-gray-500">Amount</th>
                            <th class="px-4 py-2 text-left text-xs font-medium text-gray-500">Date</th>
                            <th class="px-4 py-2 text-left text-xs font-medium text-gray-500">Status</th>
                        </tr>
                    </thead>
                    <tbody class="divide-y divide-gray-100">
                        @foreach($recentBookings as $b)
                        <tr>
                            <td class="px-4 py-2">{{ $b->booking_number }}</td>
                            <td class="px-4 py-2">{{ $b->customer?->name }}</td>
                            <td class="px-4 py-2">{{ $b->unit?->unit_number }}</td>
                            <td class="px-4 py-2 text-right">{{ number_format($b->total_price, 2) }}</td>
                            <td class="px-4 py-2">{{ $b->booking_date?->format('Y-m-d') }}</td>
                            <td class="px-4 py-2">
                                <span class="px-2 py-1 text-xs rounded {{ $b->status==='booked' ? 'bg-green-100 text-green-800' : ($b->status==='pre_booking' ? 'bg-amber-100 text-amber-800' : 'bg-gray-100 text-gray-800') }}">{{ str_replace('_',' ', $b->status) }}</span>
                            </td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
                <div class="px-4 py-2 bg-gray-50 text-right">
                    <a href="{{ route('bookings.index') }}" class="text-blue-700">View All</a>
                </div>
            </div>
        </div>
        <div>
            <div class="bg-white rounded shadow overflow-hidden mb-6">
                <div class="px-4 py-2 font-semibold bg-gray-50">Units by Phase</div>
                <table class="min-w-full">
                    <thead class="bg-gray-50">
                        <tr>
                            <th class="px-4 py-2 text-left text-xs font-medium text-gray-500">Phase</th>
                            <th class="px-4 py-2 text-right text-xs font-medium text-gray-500">Total</th>
                            <th class="px-4 py-2 text-right text-xs font-medium text-gray-500">Sold</th>
                            <th class="px-4 py-2 text-right text-xs font-medium text-gray-500">Available</th>
                        </tr>
                    </thead>
                    <tbody class="divide-y divide-gray-100">
                        @foreach($unitsByPhase as $p)
                        <tr>
                            <td class="px-4 py-2">{{ $p->name }}</td>
                            <td class="px-4 py-2 text-right">{{ $p->total_units ?? 0 }}</td>
                            <td class="px-4 py-2 text-right">{{ $p->sold_units ?? 0 }}</td>
                            <td class="px-4 py-2 text-right">{{ $p->available_units ?? 0 }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
            <div class="bg-white rounded shadow overflow-hidden">
                <div class="px-4 py-2 font-semibold bg-gray-50">Top Schemes</div>
                <table class="min-w-full">
                    <thead class="bg-gray-50">
                        <tr>
                            <th class="px-4 py-2 text-left text-xs font-medium text-gray-500">Scheme</th>
                            <th class="px-4 py-2 text-right text-xs font-medium text-gray-500">Bookings</th>
                            <th class="px-4 py-2 text-right text-xs font-medium text-gray-500">Amount</th>
                        </tr>
                    </thead>
                    <tbody class="divide-y divide-gray-100">
                        @foreach($topSchemes as $s)
                        <tr>
                            <td class="px-4 py-2">{{ $s->name }}</td>
                            <td class="px-4 py-2 text-right">{{ $s->total_bookings ?? 0 }}</td>
                            <td class="px-4 py-2 text-right">{{ number_format($s->total_amount ?? 0, 2) }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>
@endsection