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
| <?php
require_once("connexionsallesMysql.php");
$sth=$pdo->prepare("SELECT SALLE, PRODUITS, JOUR_DEBUT, JOUR_FIN FROM planning WHERE SALLE IN ('Salle_1','Salle_2','Salle_3','Salle_4','Salle_5','Cours','Vestiaires')AND JOUR_DEBUT <=:j_fin AND JOUR_FIN >=:j_debut");
$sth->execute(array(':j_debut'=>'2015-07-20',':j_fin'=>'2015-07-20'));
while ($donnees = $sth->fetch(PDO::FETCH_ASSOC)) {
$objDatedebut = date_create($donnees['JOUR_DEBUT']);
$objDatefin = date_create($donnees['JOUR_FIN']);
for( $date = clone $objDatedebut; $date <= $objDatefin; $date->modify('+1 day')) {
$tableau[$donnees['SALLE']][$date->format('Y-m-d')][] = $donnees['PRODUITS'];
}
}
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr">
<head>
<meta http-equiv="Refresh" content="10" >
<title>Gestion des Salles</title>
</head>
<body>
<table border="1" cellspacing="1" cellpadding="30">
<?php
$objDatedebut = date_create('2015-07-20');
$objDatefin = date_create('2015-07-26');
$objDatedebut = date_create();
if ($objDatedebut->format('N') != 1) {
$objDatedebut->modify('last monday');
}
$tblSalles = array(
0 => 'Salles',
1 => 'Salle 1',
2 => 'Salle 2',
3 => 'Salle 3',
4 => 'Salle 4',
5 => 'Salle 5',
6 => 'Cours',
7 => 'Vestiaires'
);
foreach ($tblSalles as $key=>$Salle) {
echo '<tr>
<td>' . $Salle . '</td>';
for ($date = clone $objDatedebut; $date <= $objDatefin; $date->modify('+1 day')) {
if ($key == 0) {
$case = $date->format('d/m/y');
}
else {
$case = isset($tableau[$Salle][$date->format('Y-m-d')]) ? $tableau[$Salle][$date->format('Y-m-d')] : '';
}
echo '<td>' . $case .'</td>';
}
echo '</tr>';
}
?>
</table>
</body>
</html> |
Partager