Réservation des locaux
"") {
db_select_detail_Events(); //appel procedure
} else {
$b_error = true;
$error_list["edit_detail_Events"]="Specify record to select.";
}
break;
}
$datedujour=date("j/n/Y"); // echo '$datedujour='.$datedujour;
$partie_datedujour = explode("/", $datedujour);
//':: handle the default case(s) (ignores value of action parameter)
if (!isset($_REQUEST["incDate"])) $incDate="";
else $incDate = $_REQUEST["incDate"];
if (!isset($_REQUEST["mo"])) $mo="";
else $mo = $_REQUEST["mo"];
if (!isset($_REQUEST["yr"])) $yr="";
else $yr = $_REQUEST["yr"];
if ("m/d/Y" == "m/d/Y") {
if (($incDate == "") and ($mo <> "") and ($yr <> "")) $incDate = $mo."/1/".$yr;
}else{
if (($incDate == "") and ($mo <> "") and ($yr <> "")) $incDate = "1/".$mo."/".$yr;
}
if ($action == "detail")
db_select_detail_events(); // appel de procedure
else
$b_display_new_content = true; // voir est-ce procedure ou variable
display_errs(); // appel de procedure dans i_utils.php
display_msg(); // appel de procedure dans i_utils.php
if ($action == "") {
If ($incDate == "") {
// get the current months first day
$incDate = Date("m")."/1/".Date("Y"); // voir ici c quoi date
}
//pixel size for the cell boxes
$boxSize = "40";
$boxSizeLarge = "40";
//' To change the month, Pass in a date with POST or GET of a valid date
//' to a variable named incDate
render_title($incDate); //La fonction est définie plus haut
if (!isset($_REQUEST["wk"])) $wk="";
else $wk = $_REQUEST["wk"];
$partie_incDate = explode("/", $incDate); // mm/jj/yyyy
if (!isset($_REQUEST["CatId"])) $CatId = "";
else $CatId = $_REQUEST["CatId"];
if ($wk == "") {
?>
Dimanche Lundi Mardi Mercredi Jeudi Vendredi Samedi
$_SESSION["CodeAdmin"]))
$a_events[$partie_dt_occur[2]] = $a_events[$partie_dt_occur[2]].$NomU." busy..
Date("w" , $incDateU)) && ($count < 8)) { // date fonction asp de dates à voir
?>
$dispDay";
if (!Empty($a_events[$dispDay])){ ?>
$dispDay ";
if (!Empty($a_events[$dispDay])) {
echo "";
}
echo "";
}
$count = $count + 1;
$dispDay = $dispDay + 1;
}Else{
//':: no date spacer cell
?>
";
}else{ //ligne 164
/******************************************Semaine**********************************/
?>
$_SESSION["CodeAdmin"]))
$a_events[$partie_dt_occur[2]] = $a_events[$partie_dt_occur[2]].$NomU." busy..
"") {
$rs=mysql_query($detail_Events_sql);
if (!$rs) {
echo "Could not successfully run query ($detail_Events_sql) from DB: " . mysql_error();
exit;
}
if ($rs) { //move first
$num_recs = mysql_num_rows($rs);
$results = true;
}else{
$results = false;
mysql_free_result($rs);
}
}else { //else du if ligne 717
$results = false;
}
$rec_count = 0;
///////////////////////////////////////////////////////////////////
$partie_incDate = explode("/", $incDate);
/****************Ajouté pour eviter redondance**********/
$incday= $partie_incDate[1];
$incmonth= $partie_incDate[0]; // mon ajout
$incyear= $partie_incDate[2];
?>
Horaire Titre Local
"") && ($tm_end1 <> "")) {
$tm_start = $tm_start1." - ".$tm_end1;
}elseif ($tm_start1 <> "") {
$tm_start = $tm_start1;
}else{
$tm_start = " --Toute la journée-- ";
}
echo ($tm_start);
?>
$CodeAdmin)) {
echo $NomU; ?> busy
[Pas de réservation]
"")) {
$DateincDate = $_GET["incDate"];
$partie_DateincDate = explode("/", $DateincDate);
$jour = $partie_DateincDate[1];
$mois = $partie_DateincDate[0]; // mon ajout
$annee= $partie_DateincDate[2];
}else{
$jour = date("j",time());
$mois = date("n",time());
$annee = date("Y",time());
$_SESSION["jour"] = date("j",date());
$_SESSION["mois"] = date("n",date());
$_SESSION["annee"] =date("Y",date());
}
if ((isset($jour)) && (isset($mois)) && (isset($annee))) {
$_SESSION["jour"] = $jour;
$_SESSION["mois"] = $mois;
$_SESSION["annee"] = $annee;
}
$strSQL="SELECT * FROM locaux" ;
$objRS=mysql_query($strSQL);
if (!$objRS) {
echo "Could not successfully run query ($strSQL) from DB: " . mysql_error();
exit;
}
if ($row2 = mysql_fetch_assoc($objRS)) {
$str_nbSalle= mysql_num_rows($objRS);
if (!mysql_data_seek($objRS, 0)) {
echo "Ne peut pointer vers la ligne : " . mysql_error() . "\n";
continue;
}
for ($i=0; $i <= $str_nbSalle; $i++) {
$journee[0][$i] = $row2["CodeL"];
$journee[1][$i]=$row2["Nom"];
$journee[2][$i]=$row2["Description"];
$row2 = mysql_fetch_assoc($objRS);
}
mysql_free_result($objRS); // a voir
for ($l=2;$l<19;$l++) {
$str_heure=$l+5;
$journee[$l][0]=strtotime($str_heure);
}
$journee[19][0]=strtotime("0");
$datesql=$annee."-".$mois."-".$jour." 00:00:00";
$strSQL="SELECT * FROM eventsoccur WHERE dt_occur='".$datesql."'";
//objRS.Open strSQL,Conn,3,3 // a voir
$objRS=mysql_query($strSQL);
//Redim desc(19, str_nbSalle) // a voir
if (!$objRS) {
echo "Could not successfully run query ($objRS) from DB: " . mysql_error();
exit;
}
while ($row3 = mysql_fetch_assoc($objRS)) {
$partie_tm_start = explode(" ", $row3["tm_start"]);
$partie_tm_end = explode(" ", $row3["tm_end"]);
$partie_tm_start_h = explode(":", $partie_tm_start[1]);
$partie_tm_end_h = explode(":", $partie_tm_end[1]);
$break=false;
for ($m=1;$m<=$str_nbSalle; $m++){
if ($journee[0][$m]==$row3["location"]) {
$col=$m;
$desc[0][$m]= $partie_tm_start_h[0];
$desc[1][$m]= $partie_tm_end_h[0];
$break=true;
}
if ($break) break;
}
$break1=false;
for ($q=2;$q<19;$q++) {
$stm_start = strtotime($partie_tm_start_h[0]);
if ($journee[$q][0]== $stm_start) {
$debut=$q;
$desc[2][$m]=$partie_tm_start[1];
$desc[3][$m]=$partie_tm_end[1];
$break1=true;
}
if ($break1) break;
}
/***************************datediff************************************/
if ($partie_tm_start_h[0] > $partie_tm_end_h[0])
$temps = diff_time($partie_tm_start[1],$partie_tm_end[1]);
else $temps = diff_time($partie_tm_end[1],$partie_tm_start[1]);
for ($n=$debut; $n<=($debut+$temps); $n++) {
$journee[$n][$col]="X";
}
}
?>
Liste des réservations confirmées pour le ".$jour."/".$mois."/".$annee."
") ;
Echo( "");
Echo( "");
Echo( "");
Echo( " Nom de local ");
for ($p=0; $p<$str_nbSalle; $p++) {
Echo( "");
Echo( "".$journee[1][$p]." ");
}
Echo( "");
Echo( " Nom de local ");
Echo( "
");
Echo( " ");
$h=7;
for ($k=2; $k <= 18; $k++) {
Echo( "") ;
Echo( "");
Echo( "");
Echo( "".$h." ");
for ($j=1; $j<=$str_nbSalle; $j++) {
if (isset($journee[$k][$j])&& ($journee[$k][$j]=="X")) {
Echo( "");
Echo( "
");
Echo( " ");
}else{
Echo( "");
Echo( " ");
Echo( " ");
}
}
Echo( "");
Echo( "".$h." ");
Echo( "
");
Echo( " ");
$h = $h+1;
}
Echo ( "" );
?>
![<? echo $a_events[$dispDay]; ?>](<? echo $path; ?>/images/icon/inboxV.gif "<? echo $a_events[$dispDay]; ?>"){kind=icon}
![".$a_events[$dispDay]."](".$path."/images/icon/inboxV.gif "\".$a_events[$dispDay].\""){kind=icon}
![commence de ".$desc[0][$j]." a ".$desc[1][$j]."](../images/reservation.gif "commence de \".$desc[0][$j].\" a \".$desc[1][$j].\"")