<?php
global $is_logged_in;
if (!$is_logged_in) {
- echo "Please login first.";
+ echo "Please login first. <br>";
+ $_SESSION['login_referer'] = $_SERVER['HTTP_REFERER'];
redirect("index.php?page=login", 2);
+ include('footer.html');
+ exit();
+}
+?>
+<h1>Mes réservations</h1>
+<?php
+$client_id = get_client_id($_SESSION['email']);
+// Add teen minutes to permit to show reservations after the end of the flight
+$date_now = date('Y-m-d\TH:i', time() + 600);
+$oDateNow = new Datetime($date_now);
+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 = 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();
+$reservations = $connection->get_result_array();
+$connection->close_prepared_query();
+if (empty($reservations)) {
+ echo "Aucune(s) réservation(s) en cours pour le moment. <br>";
+} else {
+ echo "<table id=\"reservations\">\n";
+ echo " <tr>\n";
+ echo " <th>Numéro de vol</th>\n";
+ echo " <th>Ville de départ</th>\n";
+ echo " <th>Date de départ</th>\n";
+ echo " <th>Ville d'arrivée</th>\n";
+ echo " <th>Date d'arrivée</th>\n";
+ echo " <th>Classe</th>\n";
+ echo " <th>Nombre de place(s)</th>\n";
+ echo " <th>Prix</th>\n";
+ echo " <th>Actions</th>\n";
+ echo " </tr>\n";
+ foreach ($reservations as $reservation) {
+ $oDepartureDate = new DateTime($reservation['DateD']);
+ echo " <tr>\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=\"" . $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 {
+ echo "Vol en cours\n";
+ }
+ echo " </tr>\n";
+ }
+ echo "</table>\n";
}
?>
-<h1>Mes réservations<h1>