| Server IP : 109.234.162.214 / Your IP : 216.73.216.222 Web Server : Apache System : Linux servd162214.srv.odns.fr 4.18.0-372.26.1.lve.1.el8.x86_64 #1 SMP Fri Sep 16 14:08:19 EDT 2022 x86_64 User : carpe ( 1178) PHP Version : 8.0.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/carpe/public_html/space/ |
Upload File : |
<?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>