X-Git-Url: https://git.piment-noir.org/?a=blobdiff_plain;f=includes%2Freservations.php;h=9458dc77e98f76eb96f245db05d8c950aa701584;hb=181c3ee47dbbd650216b0e39d6539dc2c6d2b811;hp=0416bd5af660a159d5777a2029ebf2723021282a;hpb=c49f721926f5d76a8eef80bd5174d68b5a151442;p=Project_webapp.git

diff --git a/includes/reservations.php b/includes/reservations.php
index 0416bd5..9458dc7 100644
--- a/includes/reservations.php
+++ b/includes/reservations.php
@@ -17,16 +17,16 @@ $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
+               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();
-if (empty($rows)) {
+if (empty($reservations)) {
     echo "Aucune(s) re&#769;servation(s) en cours pour le moment. <br>";
 } else {
     echo "<table id=\"reservations\">\n";
@@ -41,24 +41,24 @@ if (empty($rows)) {
     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'] . "&euro;</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'] . "&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=\"button\" name=\"modify\" value=\"Modifier\" onClick=\"location.href='index.php?page=modify&flight_id=" . $row['NumVol'] . "&class_name=" . $row['Classe'] . "';\">
+                          <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";