';
}
}
// Fetch all routes from the database
try {
$pdo = db();
$stmt = $pdo->query('SELECT r.*, d.name as driver_name, v.make, v.model, v.license_plate FROM routes r LEFT JOIN drivers d ON r.driver_id = d.id LEFT JOIN vehicles v ON r.vehicle_id = v.id ORDER BY r.created_at DESC');
$routes = $stmt->fetchAll();
// Fetch drivers and vehicles for the form
$drivers_stmt = $pdo->query('SELECT id, name FROM drivers ORDER BY name');
$drivers = $drivers_stmt->fetchAll();
$vehicles_stmt = $pdo->query('SELECT id, make, model, license_plate FROM vehicles ORDER BY make, model');
$vehicles = $vehicles_stmt->fetchAll();
} catch (PDOException $e) {
$routes = [];
$drivers = [];
$vehicles = [];
$message .= '