66 lines
2.5 KiB
PHP
Executable File
66 lines
2.5 KiB
PHP
Executable File
<?PHP
|
|
session_start();
|
|
/* test si la session est lancée */
|
|
if((isset($_SESSION['Admin'])==true) && ($_SESSION['Admin']==2))
|
|
{
|
|
include("conf.php");
|
|
include("mysql_compat.php");
|
|
include ("conf.php");
|
|
include ("constantes.php");
|
|
|
|
$id_tournoi=$_GET['id_tournoi'];
|
|
|
|
$db_connection=mysql_connect($db_host,$db_user,$password);
|
|
mysql_select_db($db_name,$db_connection);
|
|
$titre="Crétion automatique des tableaux et du planning.";
|
|
include("enTete.php");
|
|
echo "<body background='images/balle_raquette3.jpg'> ";
|
|
echo "<h3><center>Selectionnez la date du planning ainsi que le type de courts à utiliser.</center></h3><br /><br />";
|
|
echo "<center><table>";
|
|
echo "<form action='baseFaitsTableau.php' method='get'>";
|
|
echo "<tr><td>Dates du tournoi : </td><td><select name='date'>";
|
|
$requete="SELECT debut, fin, id_club FROM tournoi WHERE id_tournoi='$id_tournoi'";
|
|
$reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."<br>");
|
|
$tournoi=mysql_fetch_object($reponse);
|
|
|
|
list($dbt_a,$dbt_m,$dbt_j)=explode("-",$tournoi->debut);
|
|
list($fin_a,$fin_m,$fin_j)=explode("-",$tournoi->fin);
|
|
|
|
$debut=mktime(10,0,0, $dbt_m, $dbt_j, $dbt_a);
|
|
$fin=mktime(10,0,0,$fin_m, $fin_j, $fin_a);
|
|
|
|
while($debut<=$fin) {
|
|
$en_cours=getdate($debut);
|
|
$date=$en_cours['mday']."-".$en_cours['mon']."-".$en_cours['year'];
|
|
echo "<option value='$date'>$date</option>";
|
|
|
|
$debut=$debut+(24*3600);
|
|
}
|
|
echo "</select></td></tr>";
|
|
echo "<tr><td>Type de courts : </td><td><select name='protection'><option value='exterieur'>Exterieur</option><option value='couvert'>Couvert</option><option value='deux'>Les deux</option></select></td></tr>";
|
|
echo "<input type='hidden' name='tournoi' value='$id_tournoi'>";
|
|
$requete="SELECT COUNT(id_reservable) FROM reservable WHERE id_club='$tournoi->id_club'";
|
|
$reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."<br>");
|
|
$temp=mysql_fetch_array($reponse);
|
|
$nb_terrains=$temp[0];
|
|
echo "<tr><td>Nombre de courts ouverts : </td><td><select name='nb_courts'>";
|
|
for($i=1;$i<=$nb_terrains;$i++) {
|
|
echo "<option value='$i'>$i</option>";
|
|
}
|
|
echo "</select></td></tr>";
|
|
echo "<tr><td><input type='submit' name='valider' value='Valider'></td><td></td></tr>";
|
|
echo "</form>";
|
|
echo "</table></center>";
|
|
include("deco_ja.php");
|
|
include("piedDePage.php");
|
|
/* sinon si la personne n'est pas autorisé la renvoyer àla page de login */
|
|
}
|
|
else
|
|
{
|
|
echo("Non autorisé - Redirection vers la page d'identification dans 2 secondes");
|
|
sleep(2);
|
|
include("admin_ja.php");
|
|
}
|
|
|
|
?>
|