93 lines
3.9 KiB
PHP
Executable File
93 lines
3.9 KiB
PHP
Executable File
<?php
|
|
session_start();
|
|
header('P3P: CP="NOI ADM DEV PSAi COM NAV OUR OTRo STP IND DEM"');
|
|
if(isset($_SESSION['Admin']) and $_SESSION['Admin']==3 and isset($_SESSION['Id'])) {
|
|
$id_cap=$_SESSION['Id'];
|
|
?>
|
|
<html>
|
|
|
|
<head>
|
|
<meta http-equiv="Content-Language" content="fr">
|
|
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
|
|
|
|
<title>LE SERVEUR VOCAL DE RESERVATION DES SALLES DE TENNIS</title>
|
|
<link rel="stylesheet" href="style.css" type="text/css">
|
|
</head>
|
|
|
|
<body>
|
|
<div id="tout">
|
|
<?php
|
|
include("enTete.php");
|
|
include("menu.php");
|
|
include("conf.php");
|
|
|
|
include ("fonction_sms.php");
|
|
|
|
|
|
echo "<div id='contenu'>";
|
|
echo "<center><h1>Disponibilité des joueurs</h1></center><br />";
|
|
|
|
$demande=$_POST['demande'];
|
|
$id_joueur=$_POST['id_joueur'];
|
|
$id_date=$_POST['id_date'];
|
|
$dispo_texte=$_POST['dispo'];
|
|
$id_equipe=$_POST['id_equipe'];
|
|
|
|
$requete="SELECT * FROM dispo_champ WHERE id_date='$id_date' AND id_joueur='$id_joueur'";
|
|
$reponse=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."<br>");
|
|
$dispo=mysqli_fetch_object($reponse);
|
|
$requete="SELECT * FROM dates_champ WHERE id_date='$id_date'";
|
|
$reponse=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."<br>");
|
|
$rencontre=mysqli_fetch_object($reponse);
|
|
|
|
if($demande=="manu") {
|
|
$requete="SELECT numero FROM telephone WHERE id_joueur='$id_joueur'";
|
|
$reponse=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."<br>");
|
|
$tel=mysqli_fetch_object($reponse);
|
|
$num_tel=$tel->numero;
|
|
$ts_now=date("Y-m-d H:i:s",time());
|
|
$requete="SELECT id_dispo FROM dispo_champ WHERE id_joueur='$id_joueur' AND id_date='$id_date'";
|
|
$reponse=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."<br>");
|
|
$existe=mysqli_num_rows($reponse);
|
|
if($existe==0 and $dispo_texte!="") {
|
|
$requete="INSERT INTO dispo_champ(id_date, id_joueur, num_tel, type_demande, reponse, resultat_appel, a_appeler, date_dernier_essai,dispo)";
|
|
$requete.=" VALUES('$id_date', '$id_joueur','$num_tel','capitaine','oui','prevenu','non','$ts_now','$dispo_texte')";
|
|
$reponse=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."<br>");
|
|
|
|
echo "Les disponibilités ont étés ajoutées pour ce joueur.<br />";
|
|
}
|
|
else {
|
|
$dispo_bdd=mysqli_fetch_object($reponse);
|
|
if($dispo_texte=="") {
|
|
$requete="DELETE FROM dispo_champ WHERE id_dispo='$dispo_bdd->id_dispo'";
|
|
$reponse=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."<br>");
|
|
|
|
echo "Les disponibilités ont étés effacées pour ce joueur.<br />";
|
|
echo "Vous pouvez de nouveau utiliser les demandes automatiques.";
|
|
}
|
|
else {
|
|
$requete="UPDATE dispo_champ SET dispo='$dispo_texte', num_tel='$num_tel', type_demande='capitaine', reponse='oui', resultat_appel='prevenu', a_appeler='non', date_dernier_essai='$ts_now'";
|
|
$requete.=" WHERE id_dispo='$dispo_bdd->id_dispo'";
|
|
$reponse=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."<br>");
|
|
|
|
echo "Les disponibilités ont étés modifiées pour ce joueur.<br />";
|
|
}
|
|
}
|
|
|
|
}
|
|
|
|
echo "<br /><br />";
|
|
echo "<center><a href='dispo_champ_suite2.php?id_equipe=$id_equipe&date=$id_date'>Retour aux disponibilités des joueurs</a></center>";
|
|
|
|
echo "<br /><br />";
|
|
include("deco_champ.php");
|
|
include("piedDePage.php");
|
|
}
|
|
else {
|
|
echo("Non autorisé - Redirection vers la page d'identification dans 2 secondes");
|
|
sleep(2);
|
|
include("login_champ.php");
|
|
}
|
|
|
|
?>
|