Файловый менеджер

Файловый менеджер - Редактировать - /home/carpe/public_html/space/lbrm3v/reservations.php.tar

Назад
home/carpe/public_html/space/reservations.php��0000644��00000065732�15117545701�0015443 0��ustar�00��<?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>��

| ver. 1.4 | Github | . | PHP 8.0.30 | Генерация страницы: 0 | proxy | phpinfo | Настройка