$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) {
$today[$row['0']][$start_t]["who"] = get_vocab("reservation au nom de") . affiche_nom_prenom_email($row['6'], $row['11']);
} else {
if ($settings->get("display_info_bulle") == 2) {
$today[$row['0']][$start_t]["who"] = $row['8'];
} else {
$today[$row['0']][$start_t]["who"] = "";
}
}
}
}
}
grr_sql_free($res);
$sql = "SELECT room_name, capacity, id, description, statut_room, show_fic_room, delais_option_reservation, moderate FROM " . TABLE_PREFIX . "_room WHERE area_id='" . protect_data_sql($area) . "' ORDER BY order_display, room_name";
$res = grr_sql_query($sql);
function reporton(&$row, $dformat)
{
global $vocab, $enable_periods;
echo "<tr>";
//Affiche "area"
$area_nom = htmlspecialchars($row[8]);
$areadescrip = htmlspecialchars($row[10]);
if ($areadescrip != "") {
$titre_area_descript = "title=\"" . $areadescrip . "\"";
} else {
$titre_area_descript = "";
}
echo "<td " . $titre_area_descript . " >" . $area_nom . "</td>";
//Affiche "room"
$room = htmlspecialchars($row[9]);
echo "<td>" . $room . "</td>";
// Breve description (title), avec un lien
$breve_description = affichage_lien_resa_planning($row[3], $row[0]);
$breve_description = "<a href=\"view_entry.php?id={$row['0']}\">" . $breve_description . "</a>";
echo "<td>" . $breve_description . "</td>\n";
// From date-time and duration:
echo "<td>";
if ($enable_periods == 'y') {
echo describe_period_span($row[1], $row[2]);
echo "</td>\n";
} else {
echo describe_span($row[1], $row[2], $dformat);
if (date("d\\/m\\/Y", $row[1]) == date("d\\/m\\/Y", $row[2])) {
echo "<br />" . date("H\\:i", $row[1]) . " ==> " . date("H\\:i", $row[2]) . "</td>\n";
} else {
echo "<br />" . date("d\\/m\\/Y\\ \\-\\ H\\:i", $row[1]) . " ==> " . date("d\\/m\\/Y\\ \\-\\ H\\:i", $row[2]) . "</td>\n";
}
}
//Description
if ($row[4] != "") {
$description = nl2br(htmlspecialchars($row[4]));
} else {
$description = " ";
}
echo "<td>" . $description . "</td>\n";
//Type de réservation
$et = grr_sql_query1("SELECT type_name FROM " . TABLE_PREFIX . "_type_area WHERE type_letter='" . $row[5] . "'");
if ($et == -1) {
$et = "?" . $row[5] . "?";
}
echo "<td>" . $et . "</td>\n";
//Affichage de "crée par"
$sql_beneficiaire = "SELECT prenom, nom FROM " . TABLE_PREFIX . "_utilisateurs WHERE login = '******'";
$res_beneficiaire = grr_sql_query($sql_beneficiaire);
if ($res_beneficiaire) {
$row_user = grr_sql_row($res_beneficiaire, 0);
}
echo "<td>" . htmlspecialchars($row_user[0]) . " " . htmlspecialchars($row_user[1]) . "</td>";
//Affichage de la date de la dernière mise à jour
echo "<td>" . date_time_string($row[7], $dformat) . "</td>\n";
echo "</tr>\n";
}
}
while ($t < $end_t) {
$d[$day_num][$month_num][$year_num]["id"][] = $row[2];
// Info-bulle
$temp = "";
if (Settings::get("display_info_bulle") == 1) {
$temp = get_vocab("reservee au nom de") . affiche_nom_prenom_email($row[4], $row[12], "nomail");
} else {
if (Settings::get("display_info_bulle") == 2) {
$temp = $row[7];
}
}
if ($temp != "") {
$temp = " - " . $temp;
}
$d[$day_num][$month_num][$year_num]["who1"][] = affichage_lien_resa_planning($row[3], $row[2]);
$d[$day_num][$month_num][$year_num]["room"][] = $row[5];
$d[$day_num][$month_num][$year_num]["res"][] = $row[6];
$d[$day_num][$month_num][$year_num]["color"][] = $row[10];
if ($row[9] > 0) {
$d[$day_num][$month_num][$year_num]["option_reser"][] = $row[8];
} else {
$d[$day_num][$month_num][$year_num]["option_reser"][] = -1;
}
$d[$day_num][$month_num][$year_num]["moderation"][] = $row[11];
$midnight_tonight = $midnight + 86400;
//Describe the start and end time, accounting for "all day"
//and for entries starting before/ending after today.
//There are 9 cases, for start time < = or > midnight this morning,
//and end time < = or > midnight tonight.
//Use ~ (not -) to separate the start and stop times, because MSIE
$midnight = mktime(0, 0, 0, $month_num, $day_num, $year_num);
}
while ($t <= $end_t) {
/* j'ajoute pour la résa en cours, le temps de début et de fin */
$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;
}
} else {
// Pour les jours de entre les deux , Hdebut = Heure debut journée/ Hfin = heure fin journée / duree = ( h fin jourrnée
// - h debut journée * nb bloc pr 1h )
$d[$weekday][$slot]["horaireDebut"] = mktime($morningstarts, 0, 0, date('m', $row[1]), date('d', $row[1]), date('Y', $row[1]));
$d[$weekday][$slot]["horaireFin"] = mktime($eveningends, 0, 0, date('m', $row[0]), date('d', $row[0]), date('Y', $row[0]));
$d[$weekday][$slot]["duree"] = ($eveningends - $morningstarts) * $heigthSlotHoure;
}
}
} else {
$d[$weekday][$slot]["horaireDebut"] = $row[0];
$d[$weekday][$slot]["horaireFin"] = $row[1];
$d[$weekday][$slot]["duree"] = ($row[1] - $row[0]) / $this_area_resolution;
}
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];
}
$back .= "&area=" . mrbsGetRoomArea($row1['1']);
}
if (isset($_GET["page"]) && ($_GET["page"] == "week" || $_GET["page"] == "month")) {
$back .= "&room=" . $row1['1'];
}
} else {
$back = "";
}
}
if (Settings::get("display_level_view_entry") == '1') {
print_header($day, $month, $year, $type_session);
if ($back != "") {
echo '<div><a href="', $back, '">', get_vocab("returnprev"), '</a></div>', PHP_EOL;
}
}
echo '<fieldset><legend style="font-size:12pt;font-weight:bold">' . get_vocab('entry') . get_vocab('deux_points') . affichage_lien_resa_planning($breve_description, $id) . '</legend>' . "\n";
?>
<table border="0">
<tr>
<td>
<b>
<?php
echo get_vocab("description");
?>
</b>
</td>
<td>
<?php
echo nl2br($description);
?>
</td>
}
while ($t < $end_t) {
if ($debug_flag) {
echo "<br />DEBUG: Entry {$row['2']} day {$day_num}\n";
}
$d[$day_num]['id'][] = $row[2];
$temp = '';
if (Settings::get('display_info_bulle') == 1) {
$temp = get_vocab('reservee au nom de') . $row_user[0] . ' ' . $row_user[1];
} elseif (Settings::get('display_info_bulle') == 2) {
$temp = $row[7];
}
if ($temp != '') {
$temp = ' - ' . $temp;
}
$d[$day_num]['who1'][] = affichage_lien_resa_planning($row[3], $row[2]);
$d[$day_num]['room'][] = $row[5];
$d[$day_num]['res'][] = $row[6];
$d[$day_num]['color'][] = $row[10];
$d[$day_num]['type'][] = grr_sql_query1('SELECT type_name FROM ' . TABLE_PREFIX . "_type_area WHERE type_letter='" . $row[10] . "'");
if ($row[9] > 0) {
$d[$day_num]['option_reser'][] = $row[8];
} else {
$d[$day_num]['option_reser'][] = -1;
}
$d[$day_num]['moderation'][] = $row[11];
$midnight_tonight = $midnight + 86400;
if ($enable_periods == 'y') {
$start_str = preg_replace('/ /', ' ', period_time_string($row[0]));
$end_str = preg_replace('/ /', ' ', period_time_string($row[1], -1));
switch (cmp3($row[0], $midnight) . cmp3($row[1], $midnight_tonight)) {
$tplArray['vocab']['end_date'] = get_vocab('end_date');
$tplArray['vocab']['type'] = get_vocab('type');
$tplArray['vocab']['reservation_au_nom_de'] = get_vocab('reservation au nom de');
$tplArray['vocab']['created_by'] = get_vocab('created_by');
$tplArray['vocab']['reservation_en_cours'] = get_vocab('reservation_en_cours');
$tplArray['vocab']['ressource_actuellement_empruntee'] = get_vocab('ressource actuellement empruntee');
$tplArray['vocab']['lastupdate'] = get_vocab('lastupdate');
$tplArray['vocab']['clef'] = get_vocab('clef');
$tplArray['vocab']['courrier'] = get_vocab('courrier');
$tplArray['vocab']['reservation_a_confirmer_au_plus_tard_le'] = get_vocab('reservation_a_confirmer_au_plus_tard_le');
$tplArray['vocab']['en_attente_moderation'] = get_vocab('en_attente_moderation');
$tplArray['vocab']['moderation'] = get_vocab('moderation');
$tplArray['vocab']['editentry'] = get_vocab('editentry');
$tplArray['vocab']['copyentry'] = get_vocab('copyentry');
$tplArray['vocab']['deleteentry'] = get_vocab('deleteentry');
$tplArray['lienResaPlanning'] = affichage_lien_resa_planning($breve_description, $id);
$tplArray['description'] = $description;
//echo '<fieldset><legend style="font-size:12pt;font-weight:bold">'.get_vocab('entry').get_vocab('deux_points').affichage_lien_resa_planning($breve_description, $id).'</legend>'."\n";
/*<table border="0">
<tr>
<td>
<b>
echo get_vocab('description');
</b>
</td>
<td>
echo nl2br($description);
$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]);
// Info-bulle
if (getSettingValue("display_info_bulle") == 1)
$today[$row[0]][$start_t]["who"] = get_vocab("reservation au nom de").affiche_nom_prenom_email($row[6],$row[11]);
else if (getSettingValue("display_info_bulle") == 2)
$today[$row[0]][$start_t]["who"] = $row[8];
else
$today[$row[0]][$start_t]["who"] = "";
}
}
grr_sql_free($res);
# We need to know what all the rooms area called, so we can show them all
# pull the data from the db and store it. Convienently we can print the room
# headings and capacities at the same time
$sql = "select room_name, capacity, id, description, statut_room, show_fic_room, delais_option_reservation, moderate from ".TABLE_PREFIX."_room where area_id='".protect_data_sql($area)."' order by order_display, room_name";
