";
echo "
Programmation des matchs
";
if(isset($_POST['id_equipe'])) {
$id_equipe=$_POST['id_equipe'];
}
else {
$id_equipe=$_GET['id_equipe'];
}
if(isset($_POST['id_date'])) {
$id_date=$_POST['id_date'];
}
else {
$id_date=$_GET['id_date'];
}
$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)()."
");
$rencontre=mysqli_fetch_object($reponse);
$requete="SELECT nom, type_champ FROM equipes_champ WHERE id_equipe='$id_equipe'";
$reponse=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."
");
$equipe=mysqli_fetch_object($reponse);
$requete="SELECT nom FROM equipes_champ WHERE id_equipe='$rencontre->id_equipe_adverse'";
$reponse=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."
");
$equipe_adv=mysqli_fetch_object($reponse);
list($a, $m, $j)=explode("-", $rencontre->date);
$date="$j/$m/$a";
list($h,$m,$s)=explode(":", $rencontre->heure);
$heure="$h:$m";
echo "
Rencontre avec l'équipe $equipe_adv->nom se deroulant le $date à partir de $heure
";
echo "Championnat $rencontre->nom_champ
";
/* Nombre de matchs déja programmés */
$requete="SELECT id_match FROM match_champ WHERE id_date='$id_date' AND type_match='simple'";
$reponse=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."
");
$nb=mysqli_num_rows($reponse);
$requete="SELECT id_match, id_date, id_reservation, type_match FROM match_champ WHERE id_date='$id_date' ORDER BY type_match ASC";
$reponse=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."
");
$matchs_restants=NB_MAX_MATCHS_RENCONTRE_CHAMP - $nb;
echo "
Matchs programmés
";
if($nb>0) {
echo "
Les horaires, la date du match ainsi que le terrain peuvent être modifiés.";
echo "
";
echo "| Nom | Prénom | Classement | ";
if($equipe->type_champ=='corpo') {
echo "Joueur adverse | ";
}
echo "Date Match | Heure Match | Terrain | ";
echo "Modification | ";
echo "Suppression | ";
while($match=mysqli_fetch_object($reponse)) {
/* Resa */
$requete="SELECT heure_resa_deb, heure_resa_fin, date_resa, id_reservable, id_joueur, id_joueur_adverse FROM reservation WHERE id_reservation='$match->id_reservation'";
$rep=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."
");
$resa=mysqli_fetch_object($rep);
/* Terrain */
$requete="SELECT nom, prenom, classement FROM joueur WHERE id_joueur='$resa->id_joueur'";
$rep=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."
");
$joueur=mysqli_fetch_object($rep);
/* Terrain - CLub*/
$requete="SELECT t.nom, c.nom AS nom_club FROM reservable t LEFT JOIN club c ON c.id_club=t.id_club WHERE t.id_reservable='$resa->id_reservable'";
$rep=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."
");
$terrain=mysqli_fetch_object($rep);
echo "";
if($match->type_match=='double') {
echo "| Match de double | ";
}
else {
echo "$joueur->nom | ";
echo "$joueur->prenom | ";
echo "$joueur->classement | ";
if($equipe->type_champ=='corpo') {
$requete="SELECT nom, prenom FROM joueur WHERE id_joueur='$resa->id_joueur_adverse'";
$rep=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."
");
$joueur=mysqli_fetch_object($rep);
echo "$joueur->prenom $joueur->nom | ";
}
}
list($a, $m, $j)=explode("-", $resa->date_resa);
$date="$j/$m/$a";
echo "$date | ";
list($h, $m, $s)=explode(":", $resa->heure_resa_deb);
$debut="$h:$m";
list($h, $m, $s)=explode(":", $resa->heure_resa_fin);
$fin="$h:$m";
echo "$debut => $fin | ";
echo "$terrain->nom - $terrain->nom_club | ";
echo "Modifier | ";
echo "Supprimer | ";
echo "
";
}
echo "
";
}
else {
echo "
Il n'y a aucun match programmé.";
}
echo "
";
echo "
Programmation des matchs
";
/* Matchs de simple */
if($matchs_restants>0) {
echo "
Les matchs sans horaires ne seront pas programmés.";
echo "
";
}
else {
echo "Il n'y a plus de matchs à programmer.";
}
/* Matchs de doubles */
$requete="SELECT id_match FROM match_champ WHERE type_match='double' AND id_date='$id_date'";
$reponse=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."
");
$existe=mysqli_num_rows($reponse);
if($existe==0) {
echo "
Match de double
";
echo "
";
}
echo "
";
echo "
Modifier la rencontre de championnat";
echo "
";
echo "
Choisir une autre équipe";
echo "
";
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");
}
?>