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
| <!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
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'];
}
}
$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(
'Salles' => 'Salles',
'Salle_1' => 'Salle 1',
'Salle_2' => 'Salle 2',
'Salle_3' => 'Salle 3',
'Salle_4' => 'Salle 4',
'Salle_5' => 'Salle 5',
'Cours' => 'Cours',
'Vestiaires' => 'Vestiaires'
);
var_dump($tableau);
foreach ($tblSalles as $key=>$Salle) {
echo '<tr>
<td>' . $Salle . '</td>';
for ($date = clone $objDatedebut; $date <= $objDatefin; $date->modify('+1 day')) {
if ($key === 'Salles') {
$case = $date->format('d/m/Y');
}
else {
$case = isset($tableau[$key][$date->format('Y-m-d')]) ? $tableau[$key][$date->format('Y-m-d')] : 'rien pour ' . $key . ' - ' . $date->format('Y-m-d');
}
echo '<td>' . $case .'</td>';
}
echo '</tr>';
}
?>
</table>
</body>
</html> |
Partager