@extends('layouts.app')
@section('content')
<div class="max-w-7xl mx-auto p-6">
    <h1 class="text-2xl font-semibold mb-4">All Projects — Bookings</h1>
    <form method="GET" class="mb-4 flex items-end gap-3">
        <div class="flex-1">
            <label class="block text-sm font-medium mb-1">Search</label>
            <input type="text" name="q" value="{{ $qText }}" class="w-full border rounded p-2" placeholder="Project, Booking #, Customer, Unit #">
        </div>
        <div>
            <label class="block text-sm font-medium mb-1">Status</label>
            <select name="status" class="border rounded p-2">
                <option value="">All</option>
                <option value="pre_booking" @selected($status==='pre_booking')>Pre‑Booking</option>
                <option value="booked" @selected($status==='booked')>Booked</option>
                <option value="cancelled" @selected($status==='cancelled')>Cancelled</option>
            </select>
        </div>
        <div>
            <button class="px-4 py-2 rounded-2xl bg-gradient-to-r from-[var(--primary)] to-blue-600 text-white shadow hover:shadow-md hover:-translate-y-0.5 transition">Filter</button>
        </div>
    </form>
<div class="flex items-center gap-3 mb-3">
        <a href="{{ route('admin.bookings.all') }}?{{ http_build_query(request()->only('q','status')) }}&export=excel" class="px-3 py-2 rounded bg-emerald-600 text-white text-sm">Export Excel</a>
        <a href="{{ route('admin.bookings.all') }}?{{ http_build_query(request()->only('q','status')) }}&export=pdf" class="px-3 py-2 rounded bg-gray-800 text-white text-sm">Export PDF</a>
    </div>
    @php
        $groups = $rows->getCollection()->groupBy(fn($b) => $b->project?->name ?? 'Unknown Project');
    @endphp
    @foreach($groups as $projectName => $items)
    @php
        $totals = [
            'total' => (float) $items->sum('total_price'),
            'token' => (float) $items->flatMap->payments->where('payment_category','token')->sum('amount'),
            'down' => (float) $items->flatMap->payments->where('payment_category','down_payment')->sum('amount'),
            'inst' => (float) $items->flatMap->payments->where('payment_category','installment')->sum('amount'),
        ];
        $paidAll = $totals['token'] + $totals['down'] + $totals['inst'];
        $balanceAll = max(0, $totals['total'] - $paidAll);
    @endphp
    <details class="mb-4 bg-white rounded shadow" open>
        <summary class="px-4 py-3 flex items-center justify-between cursor-pointer">
            <div class="font-medium">{{ $projectName }}</div>
            <div class="text-sm text-gray-600">Total: {{ number_format($totals['total'],2) }} · Paid: {{ number_format($paidAll,2) }} · Balance: {{ number_format($balanceAll,2) }}</div>
        </summary>
        <div class="overflow-x-auto">
            <table class="min-w-full">
                <thead class="bg-gray-50">
                    <tr>
                        <th class="px-3 py-2 text-left text-xs font-medium text-gray-500">Booking #</th>
                        <th class="px-3 py-2 text-left text-xs font-medium text-gray-500">Customer</th>
                        <th class="px-3 py-2 text-left text-xs font-medium text-gray-500">Unit</th>
                        <th class="px-3 py-2 text-left text-xs font-medium text-gray-500">Total</th>
                        <th class="px-3 py-2 text-left text-xs font-medium text-gray-500">Token Paid</th>
                        <th class="px-3 py-2 text-left text-xs font-medium text-gray-500">Down Paid</th>
                        <th class="px-3 py-2 text-left text-xs font-medium text-gray-500">Installments Paid</th>
                        <th class="px-3 py-2 text-left text-xs font-medium text-gray-500">Balance</th>
                        <th class="px-3 py-2 text-left text-xs font-medium text-gray-500">Status</th>
                        <th class="px-3 py-2 text-left text-xs font-medium text-gray-500">Actions</th>
                    </tr>
                </thead>
                <tbody class="divide-y divide-gray-100">
                    @foreach($items as $b)
                    @php
                        $tokenPaid = (float) $b->payments->where('status','cleared')->where('payment_category','token')->sum('amount');
                        $downPaid = (float) $b->payments->where('status','cleared')->where('payment_category','down_payment')->sum('amount');
                        $instPaid = (float) $b->payments->where('status','cleared')->where('payment_category','installment')->sum('amount');
                        $paid = $tokenPaid + $downPaid + $instPaid;
                        $balance = max(0, (float) $b->total_price - $paid);
                    @endphp
                    <tr>
                        <td class="px-3 py-2">{{ $b->booking_number }}</td>
                        <td class="px-3 py-2">{{ $b->customer?->name }}</td>
                        <td class="px-3 py-2">{{ $b->unit?->unit_number }}</td>
                        <td class="px-3 py-2">{{ number_format($b->total_price, 2) }}</td>
                        <td class="px-3 py-2">{{ number_format($tokenPaid, 2) }}</td>
                        <td class="px-3 py-2">{{ number_format($downPaid, 2) }}</td>
                        <td class="px-3 py-2">{{ number_format($instPaid, 2) }}</td>
                        <td class="px-3 py-2 font-semibold {{ $balance>0?'text-amber-700':'text-emerald-700' }}">{{ number_format($balance, 2) }}</td>
                        <td class="px-3 py-2 capitalize">{{ $b->status }}</td>
                        <td class="px-3 py-2">
                            <a class="inline-flex items-center px-3 py-1.5 rounded-lg bg-gray-800 text-white text-xs shadow hover:-translate-y-0.5 transition" href="{{ route('bookings.show', $b) }}">Open</a>
                        </td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </details>
    @endforeach
    <div class="mt-4">
        {{ $rows->links() }}
    </div>
    <div class="mt-4 text-sm text-gray-600">
        Balance = Total Price − Cleared Payments (token, down payment, installments).
    </div>
    </div>
@endsection