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
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
| <!DOCTYPE html>
<html lang=fr>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" media="screen" type="text/css" href="css/styles.css"/>
</head>
<body>
<?php
$year0 = date('Y',strtotime('now - 1 year')); /* définit year n-1 */
$year1 = date('Y',strtotime('now')); /* définit year */
$year2 = date('Y',strtotime('now + 1 year')); /* définit year n+1 */
$month1 = date('m',strtotime('now')); /* définit month */
$year = !empty($_POST['year']) ? $_POST['year'] : $year1; /* vérifie si $year est posté */
$month = !empty($_POST['month']) ? $_POST['month'] : $month1; /* vérifie si $month est posté */
/* Fonction Réservation */
function get_resa($d,$m,$y,$chb) {
$date_1=$y.'-'.$m.'-'.$d; /* définition de la date passée en arguments */
/* connexion à la bdd */
try {
$bdd = new PDO('mysql:host=localhost;dbname=dispocol;charset=utf8', 'root', 'WaaZaa24');
}
catch(Exception $e) {
die('Erreur : '. $e->getMessage());
}
/* récupération des dates concernées */
/* requête sql */
$reponse = $bdd->query("SELECT * FROM resa WHERE date_1=\"$date_1\" AND chambre=\"$chb\"");
/* traitement des résultats de la requête */
while ($donnees = $reponse->fetch()) {
$date1=strtotime($donnees['date_1']);
$date2=strtotime($donnees['date_2']);
$nb_jours=($date2-$date1)/86400;
return $donnees['nom'];
}
$reponse->closeCursor();
}
?>
<!-- Début du formulaire général -->
<form method="post" action="index.php" id="hoteldisp">
<!-- Menu année / semaine -->
<ul id="menu">
<li><a href="#" style="color:yellow">Année <?php echo $year; ?></a>
<!-- sous-menu annee n-1, n, n+1 -->
<ul>
<li><a href="#" onclick="document.getElementById('year').value='<?php echo $year0; ?>';hoteldisp.submit();"><?php echo $year0; ?></a></li>
<li><a href="#" onclick="document.getElementById('year').value='<?php echo $year1; ?>';hoteldisp.submit();"><?php echo $year1; ?></a></li>
<li><a href="#" onclick="document.getElementById('year').value='<?php echo $year2; ?>';hoteldisp.submit();"><?php echo $year2; ?></a></li>
<input type="hidden" name="year" id="year" value="<?php echo $year; ?>">
</ul>
</li>
<!-- Menu semaine -->
<?php
$month_tab=array("JANVIER"=>"01","FÉVRIER"=>"02","MARS"=>"03","AVRIL"=>"04","MAI"=>"05","JUIN"=>"06","JUILLET"=>"07","AÔUT"=>"08","SEPTEMBRE"=>"09","OCTOBRE"=>"10","NOVEMBRE"=>"11","DÉCEMBRE"=>"12");
foreach($month_tab as $month_name => $month) {
?>
<li><a href="#" onclick="document.getElementById('month').value='<?php echo $month;?>';hoteldisp.submit();" style="<?php echo 'color:#00d0ff';?>"><?php echo $month_name; ?></a></li>
<?php
}
?>
<input type="hidden" name="month" id="month" value="<?php echo $month; ?>">
</ul>
<table border="1" width="100%">
<tr style="text-align:center">
<td> </td>
<td>Chambre 1</td>
<td>Chambre 2</td>
<td>Chambre 3</td>
<td>Chambre 4</td>
<td>Chambre 5</td>
<td>Chambre 6</td>
<td>Chambre 7</td>
</tr>
<?php
setlocale(LC_TIME, 'fr', 'fr_FR', 'fr_FR.ISO8859-1');
$date = date("$month-$year");
for ($i = 1; $i <= cal_days_in_month(CAL_GREGORIAN,$month,$year) ; $i++)
{
echo "<tr id='calrow'><td>".ucfirst(strftime("%A ", strtotime("$year-$month-$i"))).$i."</td>
<td>".get_resa($i,$month,$year,"1")."</td>
<td>".get_resa($i,$month,$year,"2")."</td>
<td>".get_resa($i,$month,$year,"3")."</td>
<td>".get_resa($i,$month,$year,"4")."</td>
<td>".get_resa($i,$month,$year,"5")."</td>
<td>".get_resa($i,$month,$year,"6")."</td>
<td>".get_resa($i,$month,$year,"7")."</td>
</tr>";
}
?>
</table>
</form>
</body>
</html> |
