global $connection;
$sql_pquery = "select RESERVATIONS.NumVol as NumVol, VilleD, DateD, VilleA, DateA, RESERVATIONS.Classe, NbPlaces, round(CoutVol*CoeffPrix*NbPlaces, 2) as Prix
from RESERVATIONS join VOLS on RESERVATIONS.NumVol = VOLS.NumVol
- join DEFCLASSES on DEFCLASSES.NumVol = VOLS.NumVol and RESERVATIONS.Classe = DEFCLASSES.Classe
+ join DEFCLASSES on DEFCLASSES.NumVol = RESERVATIONS.NumVol and DEFCLASSES.NumVol = VOLS.NumVol and DEFCLASSES.Classe = RESERVATIONS.Classe
where NumCl = ? and DateD > ?
order by DateD, NumVol, Prix";
$connection->prepare_query($sql_pquery);
$connection->prepared_query_bind_param("is", array($client_id, $date_now));
$connection->run_prepared_query();
$connection->get_pquery_result();
-$rows = $connection->get_result_array();
+$reservations = $connection->get_result_array();
$connection->close_prepared_query();
-//var_dump($rows);
-if (empty($rows)) {
+if (empty($reservations)) {
echo "Aucune(s) réservation(s) en cours pour le moment. <br>";
} else {
echo "<table id=\"reservations\">\n";
echo " <th>Prix</th>\n";
echo " <th>Actions</th>\n";
echo " </tr>\n";
- foreach ($rows as $row) {
- $oDepartureDate = new DateTime($row['DateD']);
+ foreach ($reservations as $reservation) {
+ $oDepartureDate = new DateTime($reservation['DateD']);
echo " <tr>\n";
- echo " <td>" . $row['NumVol'] . "</td>\n";
- echo " <td>" . $row['VilleD'] . "</td>\n";
- echo " <td>" . $row['DateD'] . "</td>\n";
- echo " <td>" . $row['VilleA'] . "</td>\n";
- echo " <td>" . $row['DateA'] . "</td>\n";
- echo " <td>" . $row['Classe'] . "</td>\n";
- echo " <td>" . $row['NbPlaces'] . "</td>\n";
- echo " <td>" . $row['Prix'] . "€</td>\n";
+ echo " <td>" . $reservation['NumVol'] . "</td>\n";
+ echo " <td>" . $reservation['VilleD'] . "</td>\n";
+ echo " <td>" . $reservation['DateD'] . "</td>\n";
+ echo " <td>" . $reservation['VilleA'] . "</td>\n";
+ echo " <td>" . $reservation['DateA'] . "</td>\n";
+ echo " <td>" . $reservation['Classe'] . "</td>\n";
+ echo " <td>" . $reservation['NbPlaces'] . "</td>\n";
+ echo " <td>" . $reservation['Prix'] . "€</td>\n";
if ($oDepartureDate > $oDateNow) {
echo " <td>
<form action=\"index.php\" id=\"reservations\" method=\"post\">
<input type=\"hidden\" name=\"form\" value=\"reservations\" />
- <input type=\"hidden\" name=\"flight_id\" value=\"" . $row['NumVol'] . "\" />
- <input type=\"hidden\" name=\"class_name\" value=\"" . $row['Classe'] . "\" />
- <input type=\"submit\" name=\"modify\" value=\"Modifier\">
- <input type=\"submit\" name=\"cancel\" value=\"Annuler\">
+ <input type=\"hidden\" name=\"flight_id\" value=\"" . $reservation['NumVol'] . "\" />
+ <input type=\"hidden\" name=\"class_name\" value=\"" . $reservation['Classe'] . "\" />
+ <input type=\"button\" name=\"modify\" value=\"Modifier\" onClick=\"location.href='index.php?page=modify&flight_id=" . $reservation['NumVol'] . "&class_name=" . $reservation['Classe'] . "';\">
+ <input type=\"button\" name=\"cancel\" value=\"Annuler\" onClick=\"ConfirmCancelFlight()\">
</form>
</td>\n";
} else {