";
}
if (!$datedeb) {
$msg.="Vous devez indiquer au minimum la date de début.
";
}
// pas de datefin, on travaille sur 1 jour
if (!$datefin) {
$datefin=$datedeb;
}
if ($datefin < $datedeb) {
$msg.="La date de fin ne peut pas être antérieure à la date de début.
";
}
if (!$msg) {
$mydate=$datedeb;
while ($mydate <= $datefin) {
$mysqlquery1 = "SELECT * FROM caldate WHERE idcal=$idcal AND date='$mydate'";
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);
if(mysql_num_rows($mysqlresult1)==0) {
$mysqlquery1 = "INSERT INTO caldate (idcal,date,valeur) VALUES ('$idcal','$mydate','$etat')";
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);
} else {
$mysqlquery1 = "UPDATE caldate SET valeur='$etat' WHERE idcal='$idcal' AND date='$mydate'";
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);
}
// on passe au jour suivant
$myyear=substr($mydate,0,4);
$mymonth=substr($mydate,4,2);
$myday=substr($mydate,6,2);
$mydate = mktime ( 3, 0, 0, $mymonth, $myday + 1, $myyear );
$mydate = date("Ymd",$mydate);
}
}
}
// On récupère les reglages systeme
$mysqlquery = "SELECT * FROM systeme";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult)>0) {
$row=mysql_fetch_row($mysqlresult);
$colonne=$row[0];
$couleur_fond=$row[1];
$legende_colonne=$row[2];
}
$i=0;
$mysqlquery = "SELECT * FROM etats";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult)>0) {
while($row=mysql_fetch_row($mysqlresult)) {
$couleur[$row[0]]=$row[2];
$libelle[$row[0]]=$row[1];
$i++; $etat[$i]=$row[0];
}
}
// On récupère les calendriers
// et on construit le menu déroulant
$i=0;
$mysqlquery = "SELECT * FROM calendrier";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult)>0) {
$menu = "