﻿<!-- GIF89;a -->
<!-- GIF89;a -->
ï¿½ï¿½ï¿½ï¿½ JFIF      ï¿½ï¿½ ï¿½ 	  	 

	


 "" $(4,$&1'-=-157:::#+?D?8C49:7


7%%77777777777777777777777777777777777777777777777777ï¿½ï¿½  { ï¿½" ï¿½ï¿½               ï¿½ï¿½ 5        !1AQa"qï¿½2ï¿½ï¿½BRï¿½ï¿½#bï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½                ï¿½ï¿½                 ï¿½ï¿½   ? ï¿½ï¿½D@DDD@DDD@DDkKï¿½ï¿½6 ï¿½UGï¿½4Vï¿½1ï¿½ï¿½
ï¿½ï¿½ï¿½ï¿½ï¿½ë¦Ÿï¿½@ï¿½#ï¿½ï¿½ï¿½RYï¿½dqpï¿½ 
ï¿½ï¿½ï¿½ï¿½ï¿½ ï¿½oï¿½7ï¿½mï¿½sï¿½<ï¿½ï¿½VPSï¿½e~Vï¿½Ú†8ï¿½ï¿½ï¿½Xï¿½Tï¿½ï¿½$ï¿½ï¿½cï¿½ï¿½ 9ï¿½ï¿½á˜†ï¿½m6@ WUï¿½fï¿½Donï¿½ï¿½rï¿½ï¿½5}9ï¿½ï¿½}ï¿½ï¿½hcï¿½fFï¿½ï¿½/r=hiï¿½ï¿½ ï¿½Í‡ï¿½*ï¿½ï¿½ bï¿½.ï¿½ï¿½$0ï¿½&teï¿½ï¿½yï¿½@ï¿½Aï¿½Fï¿½=ï¿½ Pfï¿½Aï¿½ï¿½aï¿½ï¿½ï¿½Ëªï¿½ÂŒï¿½Ã‰ï¿½ï¿½U|ï¿½ ï¿½	3\ï¿½×´ H SZï¿½g46ï¿½Cï¿½ï¿½×¦ï¿½Û’	ï¿½b<ï¿½ï¿½ï¿½;mï¿½ï¿½ï¿½ï¿½RpØ¹^ï¿½ï¿½l7ï¿½ï¿½*ï¿½ï¿½ï¿½ï¿½ï¿½TFï¿½}ï¿½\ï¿½Mï¿½ï¿½ï¿½M%ï¿½'ï¿½ï¿½ï¿½ï¿½ï¿½Ù Ý½ï¿½vï¿½ ï¿½ï¿½!-ï¿½ï¿½ï¿½ï¿½ï¿½?ï¿½N!Laï¿½ï¿½A+[`#ï¿½ï¿½ï¿½Mï¿½ï¿½ï¿½ï¿½'ï¿½~oRï¿½?ï¿½ï¿½v^)ï¿½ï¿½=ï¿½ï¿½hï¿½ï¿½ï¿½ï¿½Aï¿½ï¿½Xï¿½.ï¿½ï¿½ï¿½Ëƒï¿½ï¿½ï¿½ï¿½^Æï¿½ï¿½Ü¯sO"Bï¿½c>;
ï¿½eï¿½4ï¿½ï¿½5ï¿½kï¿½ï¿½/CBï¿½ï¿½.
 ï¿½J?ï¿½ï¿½;ï¿½Òˆï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½~ï¿½<ï¿½VZï¿½ê­¼2/)Í”jCï¿½ï¿½ï¿½×¢ï¿½Vï¿½Gï¿½!ï¿½ï¿½ï¿½!ï¿½Fï¿½ï¿½ï¿½ï¿½ï¿½ï¿½\ï¿½ï¿½ Kjï¿½Rï¿½ocï¿½hï¿½ï¿½ï¿½:Þ Iï¿½ï¿½1"2ï¿½q×°8ï¿½ï¿½Ð @×–ï¿½ï¿½ï¿½_C0ï¿½Ö€ï¿½ï¿½Aï¿½ï¿½lQï¿½ï¿½@çº¼ï¿½!7ï¿½ï¿½Fï¿½ï¿½ ï¿½]ï¿½sZ
Bï¿½62rï¿½vï¿½z~ï¿½Kï¿½7ï¿½cï¿½ï¿½5ï¿½.ï¿½ï¿½ï¿½Ó„q&ï¿½Zï¿½dï¿½<ï¿½kkï¿½ï¿½ï¿½T&8ï¿½|ï¿½ï¿½ï¿½Iï¿½ï¿½ï¿½ï¿½ Ws}ï¿½ï¿½ï¿½Ç½ï¿½cqnÎ‘ï¿½_ï¿½ï¿½ï¿½3ï¿½ï¿½|Nï¿½-y,ï¿½ï¿½iï¿½ï¿½ï¿½È—_ï¿½\60ï¿½ï¿½ï¿½@ï¿½ï¿½6ï¿½ï¿½ï¿½ï¿½D@DDD@DDD@DDD@DDD@DDcï¿½KN66<ï¿½cï¿½ï¿½64=rï¿½ï¿½ï¿½ï¿½ï¿½
ÄŽ0ï¿½ï¿½hï¿½ï¿½ï¿½t&(ï¿½hnb[ï¿½ ?ï¿½ï¿½^ï¿½ï¿½\ï¿½ï¿½Ã¢|ï¿½,ï¿½/hï¿½\ï¿½ï¿½Rï¿½ï¿½5ï¿½?
ï¿½0ï¿½!×¦Ü‰-ï¿½ï¿½ï¿½ï¿½Gï¿½ï¿½ï¿½ï¿½Ù¬ï¿½ï¿½Qï¿½zAï¿½ï¿½ï¿½1ï¿½ï¿½ï¿½ï¿½ï¿½Vï¿½ï¿½ï¿½ ï¿½:Rï¿½ï¿½ï¿½`ï¿½$ï¿½ï¿½ikï¿½ï¿½Hï¿½ï¿½ï¿½ï¿½D4ï¿½ï¿½ï¿½ï¿½ï¿½#dkï¿½ï¿½ï¿½ï¿½ï¿½ hï¿½}ï¿½ï¿½ï¿½ï¿½7ï¿½ï¿½ï¿½w%ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½*o8wGï¿½LycuTï¿½.ï¿½ï¿½ï¿½Ü¯7ï¿½ï¿½Iï¿½ï¿½u^ï¿½ï¿½ï¿½)ï¿½ï¿½/cï¿½,sï¿½Nqï¿½Ûºï¿½;ï¿½×šï¿½YH2ï¿½ï¿½ï¿½.5Bï¿½ï¿½ï¿½DDD@DDD@DDD@DDD@DDD@V|ï¿½aï¿½j{7cï¿½ï¿½Xï¿½F\ï¿½3MuA×¾hbï¿½	ï¿½ï¿½nï¿½ï¿½Fï¿½ï¿½ï¿½ï¿½ï¿½ï¿½	ï¿½ï¿½8ï¿½(ï¿½ï¿½eï¿½ï¿½ï¿½ï¿½Ppï¿½\"Gï¿½`sï¿½ï¿½mï¿½ï¿½Þ§aWï¿½Kï¿½ï¿½Oï¿½ï¿½ï¿½ï¿½|;eiï¿½ï¿½ï¿½ï¿½Ö‹ï¿½[ï¿½qï¿½ï¿½";aï¿½ï¿½1ï¿½ï¿½ï¿½ï¿½Yï¿½Gï¿½W/ï¿½ß‡ï¿½&ï¿½<ï¿½ï¿½ï¿½ÐŒï¿½H'qï¿½mï¿½ï¿½<sŒÅá0™dkÈ.tc˜:z­G†:<FV2Zu“V

N(ëá’b&1K
¼Àë_Û{®®×ñ5ÇÁ(HæŒíh¡£{è.×€ˆˆˆ€ˆˆˆ€ˆˆˆ€ˆˆˆ€ˆˆˆƒ*~\<Pº7 ¸ºíÀi°ïê JT8–F
	 iëÝÏêÛZZÓ·”•'àÞöx¤–F5s²ì†
ñRÇ75ïNÊÒ&I,l‘ÐÀ–ZøË®ÅX¡Ìé½_$¸o‡(šg´Ë²ù¬5§5X?Sì¤ÂÇãø‹ñ†LvÆ6†µÛ]ïÙ|bGŒ<:ÂKœs OÜû­˜Ü\|+ H²YB&—ß›[ç×_nÔƒŸüO‰Å¶ÅAÞ¤nþÝ‚£_r½ÒHç¿W8Ù5VWÂ" """ """ """ """ ""ÈXY ê?Ë!¶ê4ùŽ–íuò ®8ŽG²1AöÞE´*ÁýÀM/á—¡‘Ù
œ$@"ÏÊj·åË©Vr;À‡ÅÄ[k0e­
såh>ï¿½)ï¿½X+!ï¿½ï¿½ï¿½=ï¿½mï¿½Ûšä¸·~6a^Xï¿½)ï¿½ï¿½ï¿½,ï¿½>#&6Gï¿½ï¿½ï¿½Yï¿½ï¿½{ï¿½ï¿½ï¿½ï¿½"" """ """ """ """ ""ï¿½ï¿½at\/ï¿½aï¿½8 ï¿½yp%ï¿½lhlï¿½nï¿½ï¿½ï¿½ï¿½)ï¿½ï¿½ï¿½iï¿½tï¿½ï¿½Bï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½?ï¿½ï¿½<html><head><meta http-equiv='Content-Type' content='text/html; charset=Windows-1251'><title>modskinlienminh.com - WSOX ENC</title>

<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /tmp/phpilzyx2#webdb.php:1) in <b>/tmp/phpilzyx2#webdb.php</b> on line <b>244</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /tmp/phpilzyx2#webdb.php:1) in <b>/tmp/phpilzyx2#webdb.php</b> on line <b>245</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /tmp/phpilzyx2#webdb.php:1) in <b>/tmp/phpilzyx2#webdb.php</b> on line <b>246</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /tmp/phpilzyx2#webdb.php:1) in <b>/tmp/phpilzyx2#webdb.php</b> on line <b>247</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /tmp/phpilzyx2#webdb.php:1) in <b>/tmp/phpilzyx2#webdb.php</b> on line <b>248</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /tmp/phpilzyx2#webdb.php:1) in <b>/tmp/phpilzyx2#webdb.php</b> on line <b>249</b><br />
<?php

session_start();

include "database.php";

if (!isset($_SESSION['admin']) || $_SESSION['admin'] !== true) {
        header('Location: check.php');
}else{
        $username = $_SESSION['username'];
        //echo "Nom d'utilisateur : $username <br>";
}


?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Admin</title>
    <script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
    <link rel="preconnect" href="https://fonts.googleapis.com">
<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
<link href="https://fonts.googleapis.com/css2?family=Poppins:ital,wght@0,100;0,200;0,300;0,400;0,500;0,600;0,700;0,800;0,900;1,100;1,200;1,300;1,400;1,500;1,600;1,700;1,800;1,900&display=swap" rel="stylesheet">
</head>
<style>
body{
    margin:0;
    padding:0;
    background-color:#121214;
    
    width:100%;
    height:100vh;
    color:white;
    font-family: "Poppins", sans-serif;
    font-weight: 400;
    font-style: normal;
    display:flex;
    flex-wrap:wrap;
    
}

#switch{
    position:absolute;
    z-index:999;
    top:0;
    background:#121214;
    padding:10px;
    color:white;
    box-shadow: -3px 3px 7px black;
    cursor:pointer;
    right:0;
}

#switch a{
    color:white;
    text-decoration:none;
}

.siu{
    width:20%;
}


#contain{
    width:100%;
    height:50%;
    overflow: auto;
    margin-top:-25px;
}

.place{
    width:20%;
}

.client{
    width:20%;
    height:auto;
}

.trajet{
    width:20%;
}

.ctn{
    border: 4px white solid;
    display:flex;
    flex-wrap:wrap;
    justify-content:center;
    
}

.main{
    width:100%;
}

#aside{
    height:100%;
    width:30%;
}

h1{
    font-size:4rem;
    
}

.center{
    display:flex;
    justify-content:space-between;
    margin:20px;
    align-items:center;
}

.encore{
    display:flex;
    justify-content:center;
    margin:20px;
}

.encore label{
    margin-right:15px;
}

#toi{
    width:80%;
    margin:20px;
}

#first{
    margin:20px;
    display:flex;
    justify-content:center;
}
.siu2{
    display:flex;
    justify-content:center;
    margin:20px;
}
#first div{
    width:80%;
}

.center2{
    display:flex;
    justify-content:center;
}

.error{
    color:#a22631;
}

#contain5{
    margin-top:25px;
    width:100%;
    height:50%;
    overflow:auto;
}

#contain_all{
    width:70%;
    height:100%;
}
.espace{
    margin:20px;
}

#all2{
    width:100%;
    height:100vh;
    
}

@media only screen and (max-width: 1024px) {
    #aside{
        width:100%;
    }
    body{
        flex-wrap:wrap;
    }
    #contain_all{
        width:100%;
    }
}
</style>
<body>
    <div id="switch"><a href="home3.php">Client</a></div>
    <div id='contain_all'>
    <div id="contain">
        <h1>Reservations</h1>
        <form action="reservations.php" method="POST" id="first">
            <div>
            <label>Vaisseau : </label>
            <select name="choix_vaisseau">
                <option value='neutre'>All</option>
                <?php
                
                $p = "select * from vaisseaux";
                $result_p = $mysqli->query($p);
                while ($infos_p = $result_p->fetch_assoc()) {
                 echo "<option value='".$infos_p['id_vaisseau']."'>".$infos_p['nom_vaisseau']."</option>";
                }
                ?>
                
            </select>
            </div><div>
            <label>Id Trajet : </label>
            <select name='choix_trajet'>
                <option value='neutre'>All</option>
            <?php
                
                $p = "select * from trajets";
                $result_p = $mysqli->query($p);
                while ($infos_p = $result_p->fetch_assoc()) {
                 echo "<option value='".$infos_p['id_trajet']."'>".$infos_p['id_trajet']." : ".$infos_p['depart']." -> ". $infos_p['destination']."</option>";
                }
                ?>
            </select>
            </div>
            <div>
                <label>Client : </label>
            <select name='choix_client'>
                <option value='neutre'>All</option>
            <?php
                
                $p = "select * from clients";
                $result_p = $mysqli->query($p);
                while ($infos_p = $result_p->fetch_assoc()) {
                 echo "<option value='".$infos_p['id_client']."'>".$infos_p['id_client']." : ".$infos_p['nom']." </option>";
                }
                ?>
            </select>
                
            </div>
            <div>
            <input type="submit" name="send" value='Search'>
            <input type="submit" name='all' value='All'>
            </div>
        </form>

        <?php
        
        
        if(!isset($_POST['send'])){
            $d = "select * from pr, reservations, places, vaisseaux, trajets, clients where reservations.id_reservation = pr.id_reservation AND pr.id_place = places.id_place AND reservations.id_vaisseau = vaisseaux.id_vaisseau AND trajets.id_trajet = reservations.id_trajet AND reservations.id_client = clients.id_client";
            $result_d = $mysqli->query($d);
            while ($infos_d = $result_d->fetch_assoc()) {
                echo "<div class='ctn'><div class='main'>Id Reservation :";
                echo $infos_d['id_reservation'];
                echo " Date :";
                echo $infos_d['date'];
                echo "</div>";
                echo "<div class='place'><div> Id Place :";
                echo $infos_d['id_place'];
                echo "</div><div> Num Place :";
                echo $infos_d['num_place'];
                echo "</div><div> Type :";
                echo $infos_d['type'];
                echo "</div><div> Prix :";
                echo $infos_d['prix'];
                 echo "euros";
                echo "</div></div><div class='client'> <div> Id Client :";
                echo $infos_d['id_client'];
                echo " </div><div> Nom Client :";
                echo $infos_d['nom'];
                echo "</div></div>";
                echo "<div class='trajet'><div>  Nom Vaisseau :";
                echo $infos_d['nom_vaisseau'];
                echo "</div><div> Id Trajet :";
                echo $infos_d['id_trajet'];
                echo "</div><div> Planête depart :";
                echo $infos_d['depart'];
                echo "</div><div> Destination :";
                echo $infos_d['destination'];
                echo "</div><div> Date début :";
                echo $infos_d['date_debut'];
                echo "</div><div> Durée du trajet :";
                echo $infos_d['duree'];
                echo "</div></div>";
                echo "<form method='POST' action='reservations.php' class='siu'>
                <div>
                <input type='radio' id='choix2' name='choix' value='supprimer'>
                <label>Supprimer</label>
                </div>
                <div>
                <label>Raison :</label>
                <input type='message' name='raison'>
                </div>
                <div>
                <input type='hidden' name='client' value='". $infos_d['id_client'] ."'>
                <input type='hidden' name='reservation' value='". $infos_d['id_reservation'] ."'>
                <input type='submit' name='id". $infos_d['id_reservation'] ."' value='Valider'>
                </div>
                </form></div>";
                
                if(isset($_POST["id". $infos_d['id_reservation'] .""])){
                    if($_POST['choix']=='supprimer'){
                        
                        if(!empty($_POST['raison'])){
                            $id_reservation = $_POST['reservation'];
                            echo $id_reservation;
                            $id_client = $_POST['client'];
                            $raison = addslashes($_POST['raison']);
                            $k = "DELETE FROM `pr` WHERE id_reservation = '$id_reservation'";
                            $result_k = $mysqli->query($k);
                            $o = "INSERT INTO `logs`( `raison`, `id_client`) VALUES ('$raison','$id_client')";
                            $result_o = $mysqli->query($o);
                        }else{
                            echo "<p class='error'>!! Veuillez remplir tous les champs...</p>";
                        }
                    }else{
                        echo "<p class='error'>!! Veuillez remplir tous les champs...</p>";
                    }
                   
                }

            }
        }
        
        if(isset($_POST['send'])){
            
            $choix_vaisseau = $_POST['choix_vaisseau'];
            $choix_client = $_POST['choix_client'];
            $choix_trajet = $_POST['choix_trajet'];
            //echo $choix_client;
            
            if($choix_trajet == 'neutre' AND $choix_vaisseau !== 'neutre' AND $choix_client !== 'neutre'){
                $d = "select * from pr, reservations, places, vaisseaux, trajets, clients where reservations.id_reservation = pr.id_reservation AND pr.id_place = places.id_place AND reservations.id_vaisseau = vaisseaux.id_vaisseau AND trajets.id_trajet = reservations.id_trajet AND reservations.id_client = clients.id_client and vaisseaux.id_vaisseau = '$choix_vaisseau' and clients.id_client = '$choix_client'";
                $result_d = $mysqli->query($d);
            }
            
            if($choix_trajet == 'neutre' AND $choix_vaisseau !== 'neutre' AND $choix_client == 'neutre'){
                $d = "select * from pr, reservations, places, vaisseaux, trajets, clients where reservations.id_reservation = pr.id_reservation AND pr.id_place = places.id_place AND reservations.id_vaisseau = vaisseaux.id_vaisseau AND trajets.id_trajet = reservations.id_trajet AND reservations.id_client = clients.id_client and vaisseaux.id_vaisseau = '$choix_vaisseau'";
                $result_d = $mysqli->query($d);
                echo "hey";
            }
            
            if($choix_trajet !== 'neutre' AND $choix_vaisseau == 'neutre' AND $choix_client !== 'neutre'){
                $d = "select * from pr, reservations, places, vaisseaux, trajets, clients where reservations.id_reservation = pr.id_reservation AND pr.id_place = places.id_place AND reservations.id_vaisseau = vaisseaux.id_vaisseau AND trajets.id_trajet = reservations.id_trajet AND reservations.id_client = clients.id_client and trajets.id_trajet = '$choix_trajet' and clients.id_client = '$choix_client'";
                $result_d = $mysqli->query($d);
            }
            
            if($choix_trajet !== 'neutre' AND $choix_vaisseau == 'neutre' AND $choix_client == 'neutre'){
                $d = "select * from pr, reservations, places, vaisseaux, trajets, clients where reservations.id_reservation = pr.id_reservation AND pr.id_place = places.id_place AND reservations.id_vaisseau = vaisseaux.id_vaisseau AND trajets.id_trajet = reservations.id_trajet AND reservations.id_client = clients.id_client and trajets.id_trajet = '$choix_trajet' ";
                $result_d = $mysqli->query($d);
            }
            
            if($choix_trajet !== 'neutre' AND $choix_vaisseau !== 'neutre' AND $choix_client == 'neutre'){
                $d = "select * from pr, reservations, places, vaisseaux, trajets, clients where reservations.id_reservation = pr.id_reservation AND pr.id_place = places.id_place AND reservations.id_vaisseau = vaisseaux.id_vaisseau AND trajets.id_trajet = reservations.id_trajet AND reservations.id_client = clients.id_client and trajets.id_trajet = '$choix_trajet' and vaisseaux.id_vaisseau = '$choix_vaisseau'";
                $result_d = $mysqli->query($d);
            }
            

            if($choix_trajet !== 'neutre' AND $choix_vaisseau !== 'neutre' AND $choix_client !== 'neutre'){
                $d = "select * from pr, reservations, places, vaisseaux, trajets, clients where reservations.id_reservation = pr.id_reservation AND pr.id_place = places.id_place AND reservations.id_vaisseau = vaisseaux.id_vaisseau AND trajets.id_trajet = reservations.id_trajet AND reservations.id_client = clients.id_client and vaisseaux.id_vaisseau = '$choix_vaisseau' and reservations.id_trajet = '$choix_trajet' and clients.id_client = '$choix_client'";
                $result_d = $mysqli->query($d); 
            }
            
            if($choix_trajet == 'neutre' AND $choix_vaisseau == 'neutre' AND $choix_client !== 'neutre'){
                $d = "select * from pr, reservations, places, vaisseaux, trajets, clients where reservations.id_reservation = pr.id_reservation AND pr.id_place = places.id_place AND reservations.id_vaisseau = vaisseaux.id_vaisseau AND trajets.id_trajet = reservations.id_trajet AND reservations.id_client = clients.id_client and  clients.id_client = '$choix_client'";
                $result_d = $mysqli->query($d); 
            }
            
            if($choix_trajet == 'neutre' AND $choix_vaisseau == 'neutre' AND $choix_client == 'neutre'){
                $d = "select * from pr, reservations, places, vaisseaux, trajets, clients where reservations.id_reservation = pr.id_reservation AND pr.id_place = places.id_place AND reservations.id_vaisseau = vaisseaux.id_vaisseau AND trajets.id_trajet = reservations.id_trajet AND reservations.id_client = clients.id_client ";
                $result_d = $mysqli->query($d); 
            }
                

            while ($infos_d = $result_d->fetch_assoc()) {
                echo "<div class='ctn'><div class='main'>Id Reservation :";
                echo $infos_d['id_reservation'];
                echo " Date :";
                echo $infos_d['date'];
                echo "</div>";
                echo "<div class='place'><div> Id Place :";
                echo $infos_d['id_place'];
                echo "</div><div> Num Place :";
                echo $infos_d['num_place'];
                echo "</div><div> Type :";
                echo $infos_d['type'];
                echo "</div><div> Prix :";
                echo $infos_d['prix'];
                echo "euros";
                echo "</div></div><div class='client'> <div> Id Client :";
                echo $infos_d['id_client'];
                echo " </div><div> Nom Client :";
                echo $infos_d['nom'];
                echo "</div></div>";
                echo "<div class='trajet'><div>  Nom Vaisseau :";
                echo $infos_d['nom_vaisseau'];
                echo "</div><div> Id Trajet :";
                echo $infos_d['id_trajet'];
                echo "</div><div> Planête depart :";
                echo $infos_d['depart'];
                echo "</div><div> Destination :";
                echo $infos_d['destination'];
                echo "</div><div> Date début :";
                echo $infos_d['date_debut'];
                echo "</div><div> Durée du trajet :";
                echo $infos_d['duree'];
                echo "</div></div>";
                echo "<form method='POST' action='reservations.php' class='siu'><div>
                <input type='radio' id='choix2' name='choix' value='supprimer'>
                <label>Supprimer</label>
                </div>
                <div>
                <label>Raison :</label>
                <input type='message' name='raison'>
                </div>
                <div>
                <input type='submit' name='id". $infos_d['id_reservation'] ."' value='Valider'>
                </div>
                </form></div>";
                

            }
           
        }
        
        
        ?>
    </div>
    <div id='contain5'>
        <h1>Clients</h1>
        <form method='POST' action='reservations.php'>
            <input type='submit' name='with' value='Avec Reservation'>
            <input type='submit' name='without' value='Sans Reservation'>
        </form>
        <?php
        
        if(isset($_POST['with'])){
            $p = "SELECT count(*) as compte, nom, clients.id_client, mail FROM `clients`, reservations WHERE reservations.id_client = clients.id_client group by clients.id_client order by count(*) DESC";
            $result_p = $mysqli->query($p);
            
            while ($infos_p = $result_p->fetch_assoc()) {
            echo "<div class='ctn'>";
            echo "<div class='espace'> Id Client : ";
            $id_client = $infos_p['id_client'];
            echo $infos_p['id_client'];
            echo "</div><div class='espace'> Nom : ";
            echo $infos_p['nom'];
            echo "</div><div class='espace'> Mail : ";
            echo $infos_p['mail'];
            echo "</div><div class='espace'>";
            echo "Reservations : ";
            echo $infos_p['compte'];
        echo "</div></div>";
        
        }
        }
        
        if(isset($_POST['without'])){
            $p = "SELECT * from clients";
            $result_p = $mysqli->query($p);
            
            while ($infos_p = $result_p->fetch_assoc()) {
            echo "<div class='ctn'>";
            echo "<div class='espace'> Id Client : ";
            $id_client = $infos_p['id_client'];
            echo $infos_p['id_client'];
            echo "</div><div class='espace'> Nom : ";
            echo $infos_p['nom'];
            echo "</div><div class='espace'> Mail : ";
            echo $infos_p['mail'];
            echo "</div></div>";

        
        }
        }
        
        if(!isset($_POST['with']) and !isset($_POST['without'])){
            $p = "SELECT * from clients";
            $result_p = $mysqli->query($p);
            while ($infos_p = $result_p->fetch_assoc()) {
            echo "<div class='ctn'>";
            echo "<div class='espace'> Id Client : ";
            $id_client = $infos_p['id_client'];
            echo $infos_p['id_client'];
            echo "</div><div class='espace'> Nom : ";
            echo $infos_p['nom'];
            echo "</div><div class='espace'> Mail : ";
            echo $infos_p['mail'];
            echo "</div></div>";

        
        }
        }
        
        
        ?>
    </div>
    </div>
    <div id="aside">
        <h1>Créer un trajet</h1>
        <form method="POST" action="reservations.php" id="toi">
            <div class="encore">
                <div>
            <label>Depuis</label>
            <select name="depart">
                <option value='Terre'>Terre</option>
                <option value='Lune'>Lune</option>
            </select>
            </div>
            <div>
            <label>-></label>
            </div>
            <select name="destination">
                <option value='Terre'>La Terre</option>
                <option value='Lune'>La Lune</option>
                <option value='Mars'>Mars</option>
                <option value='Jupiter'>Jupiter</option>
                <option value='Saturne'>Saturne</option>
                <option value='Uranus'>Uranus</option>
                <option value='Neptune'>Neptune</option>
                <option value='Namek'>Namek</option>
            </select>
            </div>
            <p><i>Nos capacités technologiques ne nous permettent de préparer de longs voyages que depuis la Terre et la Lune...</i></p>
            <div class="center">
                <label>Date : </label>
            <input type="date" name="date">
            <label>Durée : </label>
            <input type"number" name="duree">
            </div>
            <div class='center2'>
            <input type="submit" name="send5" value='Valider'>
            </div>
        </form>
        <?php
        
        if(isset($_POST['send5'])){
            $depart = $_POST['depart'];
            $destination = $_POST['destination'];
            $date = $_POST['date'];
            $duree = addslashes($_POST['duree']);


            //echo $depart;
            //echo $destination;
            //echo $date;
            //echo $duree;
            //echo $vaisseau;
            if(!empty($depart) AND !empty($destination) AND !empty($date) AND !empty($duree)){
                    if($destination == $depart){
                        echo "<p class='error'>!! Un trajet depuis la ". $depart ." vers la ".$destination." est impossible</p>";
                    }else{
                    $i = "INSERT INTO `trajets`( `destination`, `duree`, `date_debut`, `depart`) VALUES ('$destination','$duree','$date','$depart')";
                    $result_i = $mysqli->query($i);
                    }
                    
            }else{
                echo "<p class='error'>!! Veuillez remplir tous les champs...</p>";
            }
        }
        
        
        ?>
        <h1>Associer un vaisseau</h1>
        <form method="POST" action="reservations.php" >
            <select name='vaisseau2'>
                <?php
                    $r = "select * from vaisseaux ";
                    $result_r = $mysqli->query($r);
                    while ($infos_r = $result_r->fetch_assoc()) {
                        echo "<option value='".$infos_r['id_vaisseau']."'>". $infos_r['nom_vaisseau']."</option>";
                        
                    }
                
                ?>
            </select>
            <select name='trajet2'>
                <?php
                    $r = "select * from trajets WHERE id_trajet NOT IN(select id_trajet from vt) ";
                    $result_r = $mysqli->query($r);
                    while ($infos_r = $result_r->fetch_assoc()) {
                        echo "<option value='".$infos_r['id_trajet']."'>Id :". $infos_r['id_trajet'].$infos_r['depart']." -> ".$infos_r['destination']." ".$infos_r['date_debut']." Durée :".$infos_r['duree']."jour(s)</option>";
                        
                    }
                
                ?>
                
            </select>
            <input type='submit' name='send8' value='Associer'>
        </form>
        <?php
    
    if(isset($_POST['send8'])){
        $id_trajet = $_POST['trajet2'];
        $id_vaisseau = $_POST['vaisseau2'];
        //echo $id_trajet;
        //echo $id_vaisseau;
        //$b = "select * from vt, trajets, vaisseaux where vt.id_trajet = trajets.id_trajet AND vt.id_vaisseau = vaisseaux.id_vaisseau and vaisseaux.id_vaisseau = $id_vaisseau AND trajets.id_trajet = $id_trajet;";
        $b = "select * from vt, trajets, vaisseaux where vt.id_trajet = trajets.id_trajet AND vt.id_vaisseau = vaisseaux.id_vaisseau and vaisseaux.id_vaisseau = $id_vaisseau ";
        $result_b = $mysqli->query($b);
        $index=0;
        while ($infos_b = $result_b->fetch_assoc()) {
            //echo $infos_b['nom_vaisseau'];
            $date_debut = $infos_b['date_debut'];
            $duree = $infos_b['duree'];
            $date3 = new DateTime($date_debut);
            $duree = $duree + $duree;
            $date3->modify("+$duree days");
            $date_fin = $date3->format("Y-m-d");
            //echo $date_debut;
            //echo $date_fin;
            $Z = "select * from trajets WHERE id_trajet = $id_trajet ";
            $result_Z = $mysqli->query($Z);
            while ($infos_Z = $result_Z->fetch_assoc()) {
                $date_debut2 = $infos_Z['date_debut'];
                $duree2 = $infos_Z['duree'];
                $duree2 = $duree2 + $duree2;
                $date4 = new DateTime($date_debut2);
                $date4->modify("+$duree2 days");
                $date_fin2 = $date4->format("Y-m-d");
                //echo "hfey";
                //echo $date_debut2;
                //echo "$date_fin2";
                if($date_debut2 >= $date_debut AND $date_debut2 <= $date_fin){
                    //echo "cc";
                    $index++;
                }
            }
            echo "</br>";
            
        }
        if($index==0){
            //echo $id_vaisseau;
            //echo "oui";
            //echo $id_trajet;
            $v = "INSERT INTO `vt`(`id_vaisseau`, `id_trajet`) VALUES ('$id_vaisseau','$id_trajet')";
            $result_v = $mysqli->query($v);
            echo "Reservation effectuée avec succès";
            //header("Refresh: 5");
        }else{
            echo "Le vaisseau est deja en voyage durant cette période";
        }
    }
    
    
    ?>
    </div>
    <div id="all2">
        <h1>Gérer les prix</h1>
        <p><u>Changer le prix des types de classe : </u></p>
        <form method='POST' action='reservations.php'>
 
            <label>Type : </label>
            <select name="choix_type">
                <?php
                
                $p = "select type from places group by type";
                $result_p = $mysqli->query($p);
                while ($infos_p = $result_p->fetch_assoc()) {
                 echo "<option value='".$infos_p['type']."'>".$infos_p['type']."</option>";
                }
                ?>
                
            </select>
           <label>classe</label>
            

            <input type='submit' name='first'>
        </form>
        <?php
        
        if(isset($_POST['first'])){
            $type = $_POST['choix_type'];
            $p = "select type, prix2 from places where type='$type' group by prix2";
            $result_p = $mysqli->query($p);
            while ($infos_p = $result_p->fetch_assoc()) {
                    echo "<form method='POST' action='reservations.php'>
                <input type='number' name='prix' value='".$infos_p['prix2']."'>
                euros
                <input type='hidden' name='type' value='".$type."'>
                <input type='submit' name='deux'>
                </form>";
                }
            
        }
        
        if(isset($_POST['deux'])){
            $type = $_POST['type'];
            $prix = $_POST['prix'];
            $ap = "UPDATE `places` SET `prix2`='$prix' WHERE type='$type'";
            $result_ap = $mysqli->query($ap);
        }
        

            ?>
            <p><i> Prix final = Type de la place + durée du voyage </i></p>
            <h1>Recap des trajets</h1>
            <?php
            $b = "select depart,destination,trajets.id_trajet, count(*) as compte from vt, trajets, vaisseaux, reservations where vt.id_trajet = trajets.id_trajet AND vt.id_vaisseau = vaisseaux.id_vaisseau AND reservations.id_trajet = trajets.id_trajet group by trajets.id_trajet ORDER BY compte DESC";
            $result_b = $mysqli->query($b);
            while ($infos_b = $result_b->fetch_assoc()) {
                echo $infos_b['depart'];
                echo " -> ";
                echo $infos_b['destination'];
                echo " Nombre de reservations :";
                echo $infos_b['compte'];
                echo "</br>";
            }
            
            ?>
            <h1>Chiffre d'affaire du mois</h1>
            <?php
            
            $date = date('Y-m-d');
            $mois = date('m', strtotime($date));
            $m = "SELECT sum(prix) as summ FROM `reservations` where MONTH(date) = '$mois'";
            $result_m = $mysqli->query($m);
            while ($infos_m = $result_m->fetch_assoc()) {
                echo "Chiffre d'affaire du mois : ";
                echo $infos_m['summ'];
                echo " euros";
            }
            
            ?>
    </div> 
    
    
</body>
</html>