1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65
| <?php
if (isset($_GET['RefDepart']) && !empty($_GET['RefDepart'])) {
$Heure_Depart = $heure_depart;
$Date_Depart= $date_depart;
$Date_Depart = new DateTime($Date_Depart . ''. $Heure_Depart);
$Date_limite = new DateTime('now+18 hour');
if ($Date_limite ->format('Y-m-d H:i')<= $Date_Depart ->format('Y-m-d H:i')) {
$deleteSQL = sprintf("DELETE FROM OnBoard WHERE id=%s",
GetSQLValueString($id, "int"));
mysql_query($deleteSQL)or die(mysql_error());
$deleteSQL = sprintf("DELETE FROM OnRoad WHERE id=%s",
GetSQLValueString($enroute_id, "int"));
mysql_query($deleteSQL or die(mysql_error()));
$sql = "UPDATE departure SET places_disponibles = '" .$places_disponibles. "' + '".$departs_utilises."'
WHERE id = " .$depart_id;
mysql_query($sql)or die(mysql_error()) ;
$sql = ("INSERT INTO compte_client (passager_id, depart_id, departs_annules, date)
VALUES ('" .$passager_id. "', '".$depart_id."', '".$departs_annules."','".$date."')");
mysql_query($sql)or die(mysql_error()) ;
if (!mysql_query($sql)OR ($deleteSQL) ) {
die('Erreur - :La requête n\'a pas fonctionné' . mysql_error());
}
header( "Location: confirmation_annulation.php" );
}else{
$deleteSQL = sprintf("DELETE FROM OnBoard WHERE depart_id=%s",
GetSQLValueString($id, "int"));
mysql_query($deleteSQL)or die(mysql_error()) ;
$deleteSQL = sprintf("DELETE FROM OnRoad WHERE id=%s",
GetSQLValueString($enroute_id, "int"));
mysql_query($deleteSQL)or die(mysql_error()) ;
$sql = "UPDATE departure SET places_disponibles = '" .$places_disponibles. "' + '".$departs_utilises."'
WHERE id = " .$depart_id;
mysql_query($sql)or die(mysql_error()) ;
}
if (!mysql_query($sql)OR ($deleteSQL)) {
die('Erreur - :La requête n\'a pas fonctionné' . mysql_error());
}
header( "Location: confirmation_annulation.php" );
}
?> |
Partager