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]);