} else {
// Order by Start date/time, Area, Room
$sql .= " ORDER BY 2,9,10";
}
// echo "<p>DEBUG: SQL: <tt> $sql </tt></p>\n";
$res = sql_query($sql);
if (!$res) {
fatal_error(0, sql_error());
}
$nmatch = sql_count($res);
if ($nmatch == 0) {
echo "<p class=\"report_entries\">" . get_vocab("nothing_found") . "</p>\n";
sql_free($res);
} else {
$last_area_room = "";
$last_date = "";
echo "<p class=\"report_entries\">" . $nmatch . " " . ($nmatch == 1 ? get_vocab("entry_found") : get_vocab("entries_found")) . "</p>\n";
for ($i = 0; $row = sql_row_keyed($res, $i); $i++) {
if ($summarize & 1) {
reporton($row, $last_area_room, $last_date, $sortby, $display);
}
if ($summarize & 2) {
empty($enable_periods) ? accumulate($row, $count, $hours, $report_start, $report_end, $room_hash, $name_hash) : accumulate_periods($row, $count, $hours, $report_start, $report_end, $room_hash, $name_hash);
}
}
if ($summarize & 2) {
do_summary($count, $hours, $room_hash, $name_hash);
}
}
}
require_once "trailer.inc";
echo "&pview=1";
}
echo "'>" . get_vocab("match_login") . "</a>";
} else {
echo "<b>>> " . get_vocab("match_login") . " <<</b>";
}
echo "</td>";
// Colonne "dernière modification"
echo "<td>" . get_vocab("lastupdate") . "</td>";
echo "</tr>";
}
for ($i = 0; $row = grr_sql_row($res, $i); $i++) {
// Récupération des données concernant l'affichage du planning du domaine
get_planning_area_values($row[11]);
if ($summarize == 1 || $summarize == 3) {
reporton($row, $dformat);
}
if ($summarize == 2 || $summarize == 3) {
if ($enable_periods == 'y') {
accumulate_periods($row, $count, $hours, $report_start, $report_end, $room_hash, $breve_description_hash, "n");
$do_sum1 = 'y';
} else {
accumulate($row, $count2, $hours2, $report_start, $report_end, $room_hash2, $breve_description_hash2, "n");
$do_sum2 = 'y';
}
}
}
if ($summarize == 1 || $summarize == 3) {
echo "</table>";
}
if ($summarize == 2 || $summarize == 3) {
if (!empty($descrmatch)) {
$sql .= " AND" . sql_syntax_caseless_contains("e.description", $descrmatch);
}
# Order by Area, Room, Start date/time:
$sql .= " ORDER BY 9,10,2";
# echo "<p>DEBUG: SQL: <tt> $sql </tt>\n";
$res = sql_query($sql);
if (!$res) {
fatal_error(0, sql_error());
}
$nmatch = sql_count($res);
if ($nmatch == 0) {
echo "<P><B>" . $vocab["nothing_found"] . "</B>\n";
sql_free($res);
} else {
$last_area_room = "";
echo "<P><B>" . $nmatch . " " . ($nmatch == 1 ? $vocab["entry_found"] : $vocab["entries_found"]) . "</B>\n";
for ($i = 0; $row = sql_row($res, $i); $i++) {
if ($summarize & 1) {
reporton($row, $last_area_room);
}
if ($summarize & 2) {
accumulate($row, $count, $hours, $report_start, $report_end, $room_hash, $name_hash);
}
}
if ($summarize & 2) {
do_summary($count, $hours, $room_hash, $name_hash);
}
}
}
include "trailer.inc";
