1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81
| <?php
//////////////////////////////
/* Gestion des reservations */
//////////////////////////////
$result = mysql_query("Select * from reservations");
$cpt = 0;
while ( $reservation = mysql_fetch_assoc($result) )
{
$res[$cpt]['occ'] = ($h == $reservation['heure']) && ($j == $reservation['jour']);
$res[$cpt]['libelle'] = strtoupper($reservation['nom']). ' ' . $reservation['prenom'];
$cpt++;
}
for ( $h = 9 ; $h < 22 ; $h++ )
{
echo '<tr>';
echo '<td class="ui-state-disabled" >' . $h . 'h00 - ' . ($h + 1) . 'h00</td>';
for ( $j = 0 ; $j < 8 ; $j++ )
{
////////////////////////////////
/* Gestion de la salle occupé */
////////////////////////////////
// Menage
$menage = ($h <= 11) && ($j == 0);
// Midi => Lundi, Mardi, Jeudi, Vendredi
$midi = ($h == 13) && ($j != 2) && ($j != 5) && ($j != 6) && ($j != 7);
// Ecole
$ecole = ($h < 17) && ($j == 0) ||
($h < 17) && ($j == 1) ||
($h < 17) && ($j == 3) ||
($h < 17) && ($j == 4) ;
// Basket
$basket = ($h > 16) && ($j == 2) ||
($h > 13) && ($h < 17) && ($j == 5);
// Cours
$cours = ($h < 14) && ($j == 2) ||
($h > 17) && ($h < 22) && ($j == 3) ||
($h < 13) && ($j == 5);
// Menage
if ( $menage )
{
echo '<td class="ui-state-error" >Ménage</td>';
}
// Midi
elseif ( $midi )
{
echo '<td class="ui-state-error" > </td>';
}
// Ecole
elseif ( $ecole )
{
echo '<td class="ui-state-error" >Ecole</td>';
}
// Basket
elseif ( $basket )
{
echo '<td class="ui-state-error" >Basket</td>';
}
// Cours
elseif ( $cours )
{
echo '<td class="ui-state-error" >Cours de Tennis</td>';
}
// Salle libre
else {
echo '<td j="' . $j . '" h="' . $h . '" class="droppable" >Libre</td>';
}
}
echo '</tr>';
}
?> |