rendered paste body<?php
include("fonctions.php");
include("info.inc.php");
include("mysql.inc.php");
echo (" <STYLE type=\"text/css\">@import url(calendrier/css/calendar_css.php);</STYLE>
<SCRIPT type=\"text/javascript\" src=\"calendrier/inc/calendar.js\"></SCRIPT>
<SCRIPT type=\"text/javascript\" src=\"calendrier/inc/calendar-setup.js.php\"></SCRIPT>");
// Si le variable t est dans l'url...
if(isset($_POST['date']))
{
if(!ereg("([0-9]{1,2})/([0-9]{1,2})/([0-9]{4})", $_POST['date']))
$time = time();
else
{
$jour = substr($_POST['date'], 0, 2);
$mois = substr($_POST['date'], 3, 2);
$annee = substr($_POST['date'], 6, 4);
$time = mktime(0, 0, 0, $mois, $jour, $annee);
}
$num_jour = date('N', $time);
// De sorte a ce que le premier jour de la semaine soit le lundi
switch($num_jour)
{
case '2':
$time = $time - 24*3600;
break;
case '3':
$time = $time - 2*24*3600;
break;
case '4':
$time = $time - 3*24*3600;
break;
case '5':
$time = $time - 4*24*3600;
break;
case '6':
$time = $time - 5*24*3600;
break;
case '7':
$time = $time - 6*24*3600;
break;
}
}
elseif(isset($_GET['t']))
$time = base64_decode($_GET['t']);
else
{
$time = time();
$num_jour = date('N', $time);
// De sorte a ce que le premier jour de la semaine soit le lundi
switch($num_jour)
{
case '2':
$time = $time - 24*3600;
break;
case '3':
$time = $time - 2*24*3600;
break;
case '4':
$time = $time - 3*24*3600;
break;
case '5':
$time = $time - 4*24*3600;
break;
case '6':
$time = $time - 5*24*3600;
break;
case '7':
$time = $time - 6*24*3600;
break;
}
}
$une_semaine_apres = $time + 6*24*3600;
$une_semaine_avant = $time - 6*24*3600;
?>
<!-- Debut corps -->
<table width="570" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>
<form name="entryform" method="post" action="<?php echo $_SERVER['PHP_SELF']?>" enctype="multipart/form-data">
<table border="0" cellpadding="0" cellspacing="1" width="100%">
<tr>
<td><b>Semaine du :</b></td>
<td>
<input type="text" class="form_en" name="date" id="ztDateDebut">
<input type="image" id="btCal1" src="images/picto_calendrier.gif" title="Afficher le calendrier"
style=" vertical-align: bottom"> <I>(Format jj/mm/aaaa)</I>
<input type="submit" class="bouton" value="OK" />
</td>
<SCRIPT type="text/javascript">
<!--
Calendar.setup( {
inputField : "ztDateDebut", // ID of the input field
ifFormat : "%d/%m/%Y", // the date format
button : "btCal1" // ID of the button
} );
//-->
</SCRIPT>
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td id="calendrier">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr style="color:#000000; background-color:#CCCCCC;">
<td align="center" colspan="11">
<?php
// date des cours d'une semaine
echo 'Semaine du <b>'.dayNumToName(date('w', $time)).' '.date('d', $time).' '.monthNumToName(date('n', $time)).'</b> ';
echo 'au <b>'.dayNumToName(date('w', $une_semaine_apres)).' '.date('d', $une_semaine_apres).' '.monthNumToName(date('n', $une_semaine_apres)).'</b> ';
?>
</td>
</tr>
<tr style="color:#000000; background-color:#999999; font-weight:bold">
<td class="tb_bg_p">Date</td>
<td>|</td>
<td class="tb_bg_p">Heure</td>
<td>|</td>
<td class="tb_bg_p">Formule</td>
<td>|</td>
<td class="tb_bg_p">Menu</td>
<td>|</td>
<td class="tb_bg_p">Prix</td>
<td>|</td>
<td class="tb_bg_p">Disponibilité</td>
</tr>
<?php
for($i = 1; $i <= 7; $i++)
{
$time = $time + 24*3600;
$date = date('Y-m-d', $time-24*3600);
$sql = "SELECT p.id, p.reference, p.date_cours, p.professeur, p.adresse, p.menu, p.prix, p.heure_debut, p.heure_fin, p.promotion, p.tva, p.etat, p.date_maj, p.on_stock, p.stock FROM cours p, cours_formules pc, formules_calendrier c WHERE p.id = pc.produit_id AND c.id = pc.formule_id AND p.lang = 'fr' AND p.etat ='1' AND p.date_cours = '".$date."' ORDER BY p.date_cours ASC, p.heure_debut ASC";
$result=mysql_query($sql) or DIE('Une erreur de connexion à la base s est produite ' . __LINE__ . '.<p>' . MYSQL_ERROR());
while ($ligne = mysql_fetch_array($result)) {
?>
<tr valign="top">
<td><?php echo return_date_fr_min($ligne['date_cours']) ?></td>
<td colspan="2">
<?php echo afficheHeure_list($ligne['heure_debut'])."-".afficheHeure_list($ligne['heure_fin']); ?>
</td>
<td colspan="2">
<?php
$sqlCAT = "SELECT id, nom FROM formules_calendrier c, cours_formules pc WHERE pc.produit_id = ".$ligne['id']." AND c.id = pc.formule_id";
$resCAT = mysql_query($sqlCAT);
if (mysql_num_rows($resCAT) > 0) {
while ($cat = mysql_fetch_array($resCAT)) {
echo html_entity_decode($cat['nom'])."<br />";
}
} else {
echo "<font color=\"red\"><b>n.f</b></font>";
}
?>
</td>
<td colspan="2">
<?php echo stripslashes($ligne['menu'])?>
</td>
<td colspan="2"><?php echo $ligne['prix']. " €" ?></td>
<td align="center" colspan="2">
<?php
if(time() > $time)
echo '<font color="red">Passé</font>';
else
{
if($ligne['stock'] == '0')
echo '<font color="red">COMPLET</font>';
else {
echo '<font color="blue">Libre</font>';
}
}
?>
</td>
</tr>
<?php } }
if (mysql_num_rows($result) == 0)
{
echo "<tr><td colspan=\"11\" style=\"color:red\" align=\"center\"><b>Nous sommes désolés, il n'y a pas de cours prévu pour cette date.</b></td></tr>";
}
?>
<tr style="color:#000000; background-color:#CCCCCC;">
<td align="center" colspan="11">
<?php
// Afficher suivant et precedent
echo "<a style=\"color:#000000; text-decoration:none\" href=\"".$_SERVER['PHP_SELF']."?t=".base64_encode($une_semaine_avant-24*3600)."\">Semaine précédente</a>";
echo " | ";
echo "<a style=\"color:#000000; text-decoration:none\" href=\"".$_SERVER['PHP_SELF']."?t=".base64_encode($une_semaine_apres+24*3600)."\">Semaine suivante</a>";
?>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>