X-Git-Url: https://git.piment-noir.org/?a=blobdiff_plain;f=includes%2Fformsearch.php;h=dc682dafb80803829b58db91d0d27805ab9853e2;hb=e14003dc40dec3eb928a58cdff78fddd31990907;hp=66c57c94b8412c8c0bbe6d654acaff78b6a5ad8b;hpb=22f1dc6402dbc9a9c5d2ed2f17ef54044d35ec2a;p=Project_webapp.git

diff --git a/includes/formsearch.php b/includes/formsearch.php
index 66c57c9..dc682da 100644
--- a/includes/formsearch.php
+++ b/includes/formsearch.php
@@ -40,17 +40,17 @@ if (empty($form_arrival_date)) {
 
 ?>
 
-<h1> Rechercher un vol <?php if ($action === "return_flight") { echo "retour"; } ?></h1>
+<h1> Rechercher un vol <?php if ($action === "return_flight") { echo "retour"; } ?> </h1>
 
 <form action="index.php" id="search" method="post">
  <input type="hidden" name="form" value="search" />
- <?php if ($action === "return_flight") echo "<input type=\"hidden\" name=\"action\" value=\"return_flight\" />" ?>
+ <?php if ($action === "return_flight") { echo "<input type=\"hidden\" name=\"action\" value=\"return_flight\" />"; } ?>
  <input type="hidden" name="date_now" value="<?php echo $form_date_now; ?>" />
  <label> De&#769;part : Ville -> </label>
  <select size="1" name="departure_city" required>
   <optgroup label="Se&#769;lectionner une ville">
  <?php
- $sql_pquery = "select distinct VilleD from VOLS";
+ $sql_pquery = "select distinct VilleD from VOLS order by VilleD";
  global $connection;
  $connection->prepare_query($sql_pquery);
  $connection->run_prepared_query();
@@ -73,7 +73,7 @@ if (empty($form_arrival_date)) {
  <select size="1" name="arrival_city" required>
   <optgroup label="Se&#769;lectionner une ville">
  <?php
- $sql_pquery = "select distinct VilleA from VOLS";
+ $sql_pquery = "select distinct VilleA from VOLS order by VilleA";
  global $connection;
  $connection->prepare_query($sql_pquery);
  $connection->run_prepared_query();
@@ -91,68 +91,93 @@ if (empty($form_arrival_date)) {
   </optgroup>
  </select>
  <label> Date -> </label>
- <input type="datetime-local" name="arrival_date" <?php if (isset($form_arrival_date)) echo "value=\"$form_arrival_date\"";?> />
+ <input type="datetime-local" name="arrival_date" <?php if (isset($form_arrival_date)) { echo "value=\"$form_arrival_date\""; } ?> />
  <input type="submit" value="Rechercher">
 </form>
 <br>
 
 <?php
 if (!$input_failure) {
-    global $connection;
-    $sql_pquery = "select VOLS.NumVol as NumVol, VilleD, DateD, VilleA, DateA, Classe, round(CoutVol*CoeffPrix, 2) as Prix, NumAv from VOLS, DEFCLASSES
-                   where DEFCLASSES.NumVol = VOLS.NumVol and
-                   DateD >= ? and VilleD = ? and DateA <= ? and VilleA = ?
-                   order by DateD, NumVol, Prix";
-    $connection->prepare_query($sql_pquery);
-    $connection->prepared_query_bind_param("ssss", array($form_departure_date, $form_departure_city, $form_arrival_date, $form_arrival_city));
-    $connection->run_prepared_query();
-    $connection->get_pquery_result();
-    $rows = $connection->get_result_array();
-    $connection->close_prepared_query();
-    //FIXME: Use NumAv to see if a flight is fully booked.
-    //var_dump($rows);
-    if (empty($rows)) {
-        echo "Aucun vol ne correspond aux crite&#768;res de recherche. <br>";
-    } else {
-        echo "<table id=\"search\">\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>Prix d'une place</th>\n";
-        echo "    <th>Re&#769;server</th>\n";
-        echo "  </tr>\n";
-        foreach ($rows as $row) {
-            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['Prix'] . "&euro;</td>\n";
-            echo "    <td>
+     global $connection;
+     $sql_pquery = "select VOLS.NumVol as NumVol, VilleD, DateD, VilleA, DateA, DEFCLASSES.Classe, round(CoutVol*CoeffPrix, 2) as Prix, CapAv
+                    from VOLS join DEFCLASSES on DEFCLASSES.NumVol = VOLS.NumVol
+                    join AVIONS on AVIONS.NumAv = VOLS.NumAv
+                    where DateD >= ? and VilleD = ? and DateA <= ? and VilleA = ?
+                    order by DateD, NumVol, Prix";
+     $connection->prepare_query($sql_pquery);
+     $connection->prepared_query_bind_param("ssss", array($form_departure_date, $form_departure_city, $form_arrival_date, $form_arrival_city));
+     $connection->run_prepared_query();
+     $connection->get_pquery_result();
+     $flights = $connection->get_result_array();
+     $connection->close_prepared_query();
+     //var_dump($flights);
+     if (empty($flights)) {
+         echo "Aucun vol ne correspond aux crite&#768;res de recherche. <br>";
+     } else {
+         if ($action === "return_flight" && isset($_SESSION['return_flight_nb_place'])) {
+             $nb_places = $_SESSION['return_flight_nb_place'];
+             unset($_SESSION['return_flight_nb_place']);
+         } else {
+             $nb_places = 1;
+         }
+         echo "<table id=\"search\">\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>Prix d'une place</th>\n";
+         echo "    <th>Re&#769;server</th>\n";
+         echo "  </tr>\n";
+         foreach ($flights as $flight) {
+             $sql_pquery = "select sum(NbPlaces) as BookedPlaces from RESERVATIONS where NumVol = ?";
+             $connection->prepare_query($sql_pquery);
+             $connection->prepared_query_bind_param("s", array($flight['NumVol']));
+             $connection->run_prepared_query();
+             $connection->get_pquery_result();
+             $rows = $connection->get_result_array();
+             $connection->close_prepared_query();
+             $booked_places = $rows[0][0];
+             if (is_null($booked_places)) {
+                 $booked_places = 0;
+             }
+             if (isset($flight['CapAv']) && isset($booked_places)) {
+                 $free_places = $flight['CapAv'] - $booked_places;
+             } else {
+                 $free_places = "Inconnu";
+             }
+             echo "  <tr>\n";
+             echo "    <td>" . $flight['NumVol'] . "</td>\n";
+             echo "    <td>" . $flight['VilleD'] . "</td>\n";
+             echo "    <td>" . $flight['DateD'] . "</td>\n";
+             echo "    <td>" . $flight['VilleA'] . "</td>\n";
+             echo "    <td>" . $flight['DateA'] . "</td>\n";
+             echo "    <td>" . $flight['Classe'] . "</td>\n";
+             echo "    <td>" . $flight['Prix'] . "&euro;</td>\n";
+             echo "    <td>
+                        Nombre de places libres : " . $free_places . "
                         <form action=\"index.php\" id=\"booking\" method=\"post\">
                           <input type=\"hidden\" name=\"form\" value=\"booking\" />
-                          <input type=\"hidden\" name=\"flight_id\" value=\"" . $row['NumVol'] . "\" />
-                          <input type=\"hidden\" name=\"class_name\" value=\"" . $row['Classe'] . "\" />
-                          <input type=\"hidden\" name=\"place_price\" value=\"" . $row['Prix'] . "\" />
+                          <input type=\"hidden\" name=\"flight_id\" value=\"" . $flight['NumVol'] . "\" />
+                          <input type=\"hidden\" name=\"class_name\" value=\"" . $flight['Classe'] . "\" />
+                          <input type=\"hidden\" name=\"place_price\" value=\"" . $flight['Prix'] . "\" />
                           <label> Place(s) : </label>
-                          <input type=\"number\" name=\"nb_place\" min=\"1\" max=\"9\" value=\"1\" required/>
-                          <label> Vol retour : </label>\n";
-                          if (!($action === "return_flight")) {
-                              echo "        <input type=\"checkbox\" name=\"return_flight\" checked/>\n";
-                          }
-            echo "        <input type=\"submit\" value=\"Re&#769;server\">\n";
-            echo "      </form>
-                     </td>\n";
-            echo "  </tr>\n";
-        }
-        echo "</table>\n";
-    }
-}
+                          <input type=\"number\" name=\"nb_place\" min=\"1\" max=\"9\" value=\"" . $nb_places . "\" required/>\n";
+             if ($action !== "return_flight") {
+                 echo "       <label> Vol retour : </label>\n";
+                 echo "       <input type=\"checkbox\" name=\"return_flight\" checked/>\n";
+             }
+             if ($free_places !== 0 || $free_places === "Inconnu") {
+                 echo "       <input type=\"submit\" value=\"Re&#769;server\">\n";
+             }
+             echo "     </form>
+                       </td>\n";
+             echo "  </tr>\n";
+         }
+         echo "</table>\n";
+     }
+ }
 
 ?>