prepare("UPDATE bookings SET status = ? WHERE id = ?"); $stmt->execute([$status, $booking_id]); } // Handle tour booking status update if (isset($_POST['update_tour_booking'])) { $booking_id = $_POST['booking_id']; $status = $_POST['status']; $stmt = $pdo->prepare("UPDATE tour_bookings SET status = ? WHERE id = ?"); $stmt->execute([$status, $booking_id]); } // Fetch vehicle bookings $stmt_bookings = $pdo->query('SELECT b.*, v.name as vehicle_name FROM bookings b JOIN vehicles v ON b.vehicle_id = v.id ORDER BY b.start_date DESC'); $vehicle_bookings = $stmt_bookings->fetchAll(PDO::FETCH_ASSOC); // Fetch tour bookings $stmt_tour_bookings = $pdo->query('SELECT tb.*, tp.name as package_name FROM tour_bookings tb JOIN tour_packages tp ON tb.tour_package_id = tp.id ORDER BY tb.tour_date DESC'); $tour_bookings = $stmt_tour_bookings->fetchAll(PDO::FETCH_ASSOC); $statuses = ['pending', 'confirmed', 'completed', 'cancelled']; require_once 'includes/admin_sidebar.php'; ?>

Manage Bookings

View and manage customer bookings for vehicles and tours.

Vehicle Rentals

Customer	Vehicle	Dates	Status	Action
No vehicle bookings found.
		to

Tour Package Bookings

Customer	Tour Package	Tour Date	# of People	Status	Action
No tour bookings found.