@extends('layouts.app')
@section('content')
<div class="max-w-7xl mx-auto p-6">
    <h1 class="text-xl font-semibold mb-4">Sales Summary</h1>
    <form method="GET" class="bg-white rounded shadow p-4 grid grid-cols-5 gap-4 mb-4">
        <div>
            <label class="block text-sm font-medium mb-1">From</label>
            <input type="date" name="from" value="{{ $from }}" class="w-full border rounded p-2">
        </div>
        <div>
            <label class="block text-sm font-medium mb-1">To</label>
            <input type="date" name="to" value="{{ $to }}" class="w-full border rounded p-2">
        </div>
        <div>
            <label class="block text-sm font-medium mb-1">Status</label>
            <select name="status" class="w-full border rounded p-2">
                <option value="">All</option>
                <option value="pre_booking" @selected(request('status')==='pre_booking')>Pre-Booking</option>
                <option value="booked" @selected(request('status')==='booked')>Booked</option>
                <option value="cancelled" @selected(request('status')==='cancelled')>Cancelled</option>
            </select>
        </div>
        <div class="flex items-end">
            <button class="px-4 py-2 bg-gray-800 text-white rounded">Filter</button>
        </div>
        <div class="flex items-end justify-end gap-2">
            <form method="POST" action="{{ route('reports.export.pdf', 'sales-summary') }}">
                @csrf
                <input type="hidden" name="from" value="{{ $from }}">
                <input type="hidden" name="to" value="{{ $to }}">
                <button class="px-3 py-2 bg-red-600 text-white rounded">PDF</button>
            </form>
            <form method="POST" action="{{ route('reports.export.excel', 'sales-summary') }}">
                @csrf
                <input type="hidden" name="from" value="{{ $from }}">
                <input type="hidden" name="to" value="{{ $to }}">
                <button class="px-3 py-2 bg-green-600 text-white rounded">Excel</button>
            </form>
        </div>
    </form>
    <div class="bg-white rounded shadow overflow-hidden">
        <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">CNIC</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-left text-xs font-medium text-gray-500">Category</th>
                    <th class="px-4 py-2 text-right text-xs font-medium text-gray-500">Total Price</th>
                    <th class="px-4 py-2 text-left text-xs font-medium text-gray-500">Booking 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($rows as $r)
                <tr>
                    <td class="px-4 py-2">{{ $r->booking_number }}</td>
                    <td class="px-4 py-2">{{ $r->customer?->name }}</td>
                    <td class="px-4 py-2">{{ $r->customer?->cnic }}</td>
                    <td class="px-4 py-2">{{ $r->unit?->unit_number }}</td>
                    <td class="px-4 py-2">{{ $r->unit?->unitCategory?->name }}</td>
                    <td class="px-4 py-2 text-right">{{ number_format($r->total_price, 2) }}</td>
                    <td class="px-4 py-2">{{ $r->booking_date?->format('Y-m-d') }}</td>
                    <td class="px-4 py-2">{{ $r->status }}</td>
                </tr>
                @endforeach
            </tbody>
            <tfoot class="bg-gray-50">
                <tr>
                    <td class="px-4 py-2 font-semibold" colspan="5">Totals</td>
                    <td class="px-4 py-2 text-right font-semibold">{{ number_format($totalAmount, 2) }}</td>
                    <td colspan="2"></td>
                </tr>
            </tfoot>
        </table>
    </div>
</div>
@endsection