prepare(
'UPDATE bookings SET status = "cancelled" WHERE id = ? AND driver_id = ? AND status IN ("pending","confirmed")'
);
$stmt->execute([$cancelId, $driverId]);
if ($stmt->rowCount()) {
// Restore availability
$svcStmt = db()->prepare('SELECT service_type_id FROM bookings WHERE id = ?');
$svcStmt->execute([$cancelId]);
$svcId = $svcStmt->fetchColumn();
if ($svcId) {
db()->prepare(
'UPDATE availability SET available_slots = LEAST(total_slots, available_slots + 1)
WHERE service_type_id = ?'
)->execute([$svcId]);
}
flash('Booking cancelled successfully.', 'success');
} else {
flash('Could not cancel this booking.', 'error');
}
header('Location: my-bookings.php');
exit;
}
// Fetch bookings
$bookings = db()->prepare(
'SELECT b.id, b.booking_ref, b.check_in, b.check_out, b.vehicle_number, b.guests,
b.total_amount, b.status, b.notes, s.label AS service_label, s.icon
FROM bookings b
JOIN service_types s ON s.id = b.service_type_id
WHERE b.driver_id = ?
ORDER BY b.created_at DESC'
);
$bookings->execute([$driverId]);
$rows = $bookings->fetchAll();
renderHeader('My Bookings');
?>