Refine the fligth search:

[Project_webapp.git] / includes / reservations.php

<?php
global $is_logged_in;
if (!$is_logged_in) {
    echo "Please login first. <br>";
    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);
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) {
        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>
                    <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";
        echo "  </tr>\n";
    }
    echo "</table>";
}
?>