$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";