echo grr_sql_error();
} else {
for ($i = 0; $row = grr_sql_row($res, $i); $i++) {
$start_t = max(round_t_down($row['1'], $resolution, $am7), $am7);
$end_t = min(round_t_up($row['2'], $resolution, $am7) - $resolution, $pm7);
$cellules[$row['4']] = ($end_t - $start_t) / $resolution + 1;
$compteur[$row['4']] = 0;
for ($t = $start_t; $t <= $end_t; $t += $resolution) {
$today[$row['0']][$t]["id"] = $row['4'];
$today[$row['0']][$t]["color"] = $row['5'];
$today[$row['0']][$t]["data"] = "";
$today[$row['0']][$t]["who"] = "";
$today[$row['0']][$t]["statut"] = $row['7'];
$today[$row['0']][$t]["moderation"] = $row['10'];
$today[$row['0']][$t]["option_reser"] = $row['9'];
$today[$row['0']][$t]["description"] = affichage_resa_planning($row['8'], $row['4']);
}
if ($row['1'] < $am7) {
$today[$row['0']][$am7]["data"] = affichage_lien_resa_planning($row['3'], $row['4']);
if ($settings->get("display_info_bulle") == 1) {
$today[$row['0']][$am7]["who"] = get_vocab("reservation au nom de") . affiche_nom_prenom_email($row['6'], $row['11'], "nomail");
} else {
if ($settings->get("display_info_bulle") == 2) {
$today[$row['0']][$am7]["who"] = $row['8'];
} else {
$today[$row['0']][$am7]["who"] = "";
}
}
} else {
$today[$row['0']][$start_t]["data"] = affichage_lien_resa_planning($row['3'], $row['4']);
if ($settings->get("display_info_bulle") == 1) {
$d[$day_num]['tStart'][] = $row['0'];
$d[$day_num]['tEnd'][] = $row['1'];
$d[$day_num]['id'][] = $row['2'];
if (Settings::get('display_info_bulle') == 1) {
$d[$day_num]['who'][] = get_vocab('reservee au nom de') . affiche_nom_prenom_email($row['4'], $row['12'], 'nomail');
} elseif (Settings::get('display_info_bulle') == 2) {
$d[$day_num]['who'][] = $row['8'];
} else {
$d[$day_num]['who'][] = '';
}
$d[$day_num]['whoDeBase'][] = affiche_nom_prenom_email($row['4'], $row['12'], 'nomail');
$d[$day_num]['who1'][] = affichage_lien_resa_planning($row['3'], $row['2']);
$d[$day_num]['id_room'][] = $row['5'];
$d[$day_num]['color'][] = $row['6'];
$d[$day_num]['res'][] = $row['7'];
$d[$day_num]['description'][] = affichage_resa_planning($row['8'], $row['2']);
if ($row['10'] > 0) {
$d[$day_num]['option_reser'][] = $row['9'];
} else {
$d[$day_num]['option_reser'][] = -1;
}
$d[$day_num]['moderation'][] = $row['11'];
$midnight_tonight = $midnight + 86400;
if (!isset($correct_heure_ete_hiver) || $correct_heure_ete_hiver == 1) {
if (heure_ete_hiver('hiver', $year_num, 0) == mktime(0, 0, 0, $month_num, $day_num, $year_num)) {
$midnight_tonight += 3600;
}
if (date('H', $midnight_tonight) == '01') {
$midnight_tonight -= 3600;
}
}
}
if ($prev_weekday != $weekday) {
$prev_weekday = $weekday;
$d[$weekday][$slot]["data"] = affichage_lien_resa_planning($row[3], $row[4]);
$d[$weekday][$slot]["id"] = $row[4];
if (Settings::get("display_info_bulle") == 1) {
$d[$weekday][$slot]["who"] = get_vocab("reservee au nom de") . affiche_nom_prenom_email($row[5], $row[10], "nomail");
} else {
if (Settings::get("display_info_bulle") == 2) {
$d[$weekday][$slot]["who"] = $row[7];
} else {
$d[$weekday][$slot]["who"] = "";
}
}
$d[$weekday][$slot]["statut"] = $row[6];
$d[$weekday][$slot]["description"] = affichage_resa_planning($row[7], $row[4]);
$d[$weekday][$slot]["option_reser"] = $row[8];
$d[$weekday][$slot]["moderation"] = $row[9];
}
}
$t += $resolution;
$slot++;
if ($slot > $last_slot) {
$weekday++;
$slot = $first_slot;
$t = $weekday * 86400 + $am7;
}
} while ($t < $end_t);
}
}
if ($debug_flag) {
{
if ($debug_flag)
echo "<br />DEBUG: Entry $row[2] day $day_num\n";
$d[$day_num]["id"][] = $row[2];
// Info-bulle
if (getSettingValue("display_info_bulle") == 1)
$d[$day_num]["who"][] = get_vocab("reservee au nom de").affiche_nom_prenom_email($row[4],$row[12],"nomail");
else if (getSettingValue("display_info_bulle") == 2)
$d[$day_num]["who"][] = $row[8];
else
$d[$day_num]["who"][] = "";
$d[$day_num]["who1"][] = affichage_lien_resa_planning($row[3],$row[2]);
$d[$day_num]["id_room"][]=$row[5] ;
$d[$day_num]["color"][]=$row[6];
$d[$day_num]["res"][] = $row[7];
$d[$day_num]["description"][] = affichage_resa_planning($row[8],$row[2]);;
if ($row[10] > 0)
$d[$day_num]["option_reser"][] = $row[9];
else
$d[$day_num]["option_reser"][] = -1;
$d[$day_num]["moderation"][] = $row[11];
$midnight_tonight = $midnight + 86400;
if (!isset($correct_heure_ete_hiver) or ($correct_heure_ete_hiver == 1)) {
// on s'arrange pour que l'heure $midnight_tonight corresponde à 0 h (00:00:00: )
if (heure_ete_hiver("hiver",$year_num,0) == mktime(0,0,0,$month_num,$day_num,$year_num))
$midnight_tonight +=3600;
if (date("H",$midnight_tonight) == "01")
$midnight_tonight -=3600;
}
# Describe the start and end time, accounting for "all day"
// Calcul du nombre de créneaux qu'occupe la réservation
$cellules[$row[4]]=($end_t-$start_t)/$resolution+1;
// Initialisation du compteur
$compteur[$row[4]]=0;
for ($t = $start_t; $t <= $end_t; $t += $resolution)
{
$today[$row[0]][$t]["id"] = $row[4];
$today[$row[0]][$t]["color"] = $row[5];
$today[$row[0]][$t]["data"] = "";
$today[$row[0]][$t]["who"] = "";
$today[$row[0]][$t]["statut"] = $row[7];
$today[$row[0]][$t]["moderation"] = $row[10];
$today[$row[0]][$t]["option_reser"] = $row[9];
// Construction des infos à afficher sur le planning
$today[$row[0]][$t]["description"] = affichage_resa_planning($row[8],$row[4]);
}
# Show the name of the booker in the first segment that the booking
# happens in, or at the start of the day if it started before today.
if ($row[1] < $am7) {
$today[$row[0]][$am7]["data"] = affichage_lien_resa_planning($row[3],$row[4]);
// Info-bulle
if (getSettingValue("display_info_bulle") == 1)
$today[$row[0]][$am7]["who"] = get_vocab("reservation au nom de").affiche_nom_prenom_email($row[6],$row[11],"nomail");
else if (getSettingValue("display_info_bulle") == 2)
$today[$row[0]][$am7]["who"] = $row[8];
else
$today[$row[0]][$am7]["who"] = "";
} else {
$today[$row[0]][$start_t]["data"] = affichage_lien_resa_planning($row[3],$row[4]);
