X-Git-Url: https://git.piment-noir.org/?a=blobdiff_plain;f=includes%2Freservations.php;h=3230f342122fa57f72c52b16cd9136d04359c1b8;hb=22f1dc6402dbc9a9c5d2ed2f17ef54044d35ec2a;hp=e986fb6647a31dd56326f23bc016718178bb4f0c;hpb=01135b89a6848059df608e8c23e8684233772b4f;p=Project_webapp.git

diff --git a/includes/reservations.php b/includes/reservations.php
index e986fb6..3230f34 100644
--- a/includes/reservations.php
+++ b/includes/reservations.php
@@ -1,10 +1,73 @@
 <?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 re&#769;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 = VOLS.NumVol and RESERVATIONS.Classe = DEFCLASSES.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();
+$connection->close_prepared_query();
+//var_dump($rows);
+if (empty($rows)) {
+    echo "Aucune(s) re&#769;servation(s) en cours pour le moment. <br>";
+} else {
+    echo "<table id=\"reservations\">\n";
+    echo "  <tr>\n";
+    echo "    <th>Nume&#769;ro de vol</th>\n";
+    echo "    <th>Ville de de&#769;part</th>\n";
+    echo "    <th>Date de de&#769;part</th>\n";
+    echo "    <th>Ville d'arrive&#769;e</th>\n";
+    echo "    <th>Date d'arrive&#769;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 ($rows as $row) {
+        $oDepartureDate = new DateTime($row['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'] . "&euro;</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\">
+                        </form>
+                      </td>\n";
+        } else {
+            echo "Vol en cours\n";
+        }
+        echo "  </tr>\n";
+    }
+    echo "</table>\n";
+}
+?>