                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
<?php
require_once __DIR__ . '/../config/config.php';
require_once __DIR__ . '/../includes/functions.php';
if (!isAdmin()) { header("Location: index.php"); exit; }
header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename=bookings_export_'.date('Ymd').'.csv');
$output = fopen('php://output', 'w');
fputcsv($output, ['Booking ID', 'Customer Name', 'Email', 'Phone', 'Package', 'Category', 'Event Date', 'Start Time', 'End Time', 'Venue', 'District', 'Total Price', 'Advance', 'Balance', 'Status', 'Payment Status', 'Created']);
$bookings = $conn->query("SELECT b.*, p.name as pname, c.name as cname, cu.name as cname2, cu.email as cemail, cu.phone as cphone FROM bookings b JOIN packages p ON b.package_id=p.id JOIN categories c ON b.category_id=c.id JOIN customers cu ON b.customer_id=cu.id ORDER BY b.created_at DESC")->fetch_all(MYSQLI_ASSOC);
foreach ($bookings as $b) {
    fputcsv($output, [$b['booking_id'], $b['cname2'], $b['cemail'], $b['cphone'], $b['pname'], $b['cname'], $b['event_date'], $b['start_time'], $b['end_time'], $b['venue'], $b['district'], $b['total_price'], $b['advance_amount'], $b['balance_amount'], $b['status'], $b['payment_status'], $b['created_at']]);
}
fclose($output);