function accumulate_periods(&$row, &$count, &$hours, $report_start, $report_end, &$room_hash, &$breve_description_hash, $csv = "n") { global $vocab, $periods_name; $max_periods = count($periods_name); if ($_GET["sumby"] == "5") { $temp = grr_sql_query1("SELECT type_name FROM " . TABLE_PREFIX . "_type_area WHERE type_letter = '" . $row[$_GET["sumby"]] . "'"); } else { if ($_GET["sumby"] == "3" or $_GET["sumby"] == "6") { $temp = $row[$_GET["sumby"]]; } else { $temp = grrExtractValueFromOverloadDesc($row[12], $_GET["sumby"]); } } if ($temp == "") { $temp = "(Autres)"; } if ($csv == "n") { $breve_description = htmlspecialchars($temp); // Area and room separated by break: $room = htmlspecialchars($row[8]) . $vocab["deux_points"] . "<br />" . htmlspecialchars($row[9]); } else { // Use brief description or created by as the name: $breve_description = $temp; // Area and room separated by break: $room = $row[9] . " " . $row[10]; } // Accumulate the number of bookings for this room and name: @$count[$room][$breve_description]++; // Accumulate hours used, clipped to report range dates: $dur = (min((int) $row[2], $report_end) - max((int) $row[1], $report_start)) / 60; if ($dur < 24 * 60) { @($hours[$room][$breve_description] += $dur); } else { @($hours[$room][$breve_description] += $dur % $max_periods + floor($dur / (24 * 60)) * $max_periods); } $room_hash[$room] = 1; $breve_description_hash[$breve_description] = 1; }
function accumulate_periods(&$row, &$count, &$hours, $report_start, $report_end, &$room_hash, &$breve_description_hash, $csv="n") { global $vocab, $periods_name; $max_periods = count($periods_name); if ($_GET["sumby"] == "5") $temp = grr_sql_query1("select type_name from ".TABLE_PREFIX."_type_area where type_letter = '".$row[$_GET["sumby"]]."'"); else if (($_GET["sumby"] == "3") or ($_GET["sumby"] == "6")) $temp = $row[$_GET["sumby"]]; else $temp = grrExtractValueFromOverloadDesc($row[12],$_GET["sumby"]); if ($temp == "") $temp = "(Autres)"; if ($csv == "n") { $breve_description = grr_htmlSpecialChars($temp); # Area and room separated by break: $room = grr_htmlSpecialChars($row[8]) .$vocab["deux_points"]. "<br />" . grr_htmlSpecialChars($row[9]); } else { # Use brief description or created by as the name: $breve_description = ($temp); # Area and room separated by break: $room = ($row[9]) . " " . ($row[10]); } # Accumulate the number of bookings for this room and name: @$count[$room][$breve_description]++; # Accumulate hours used, clipped to report range dates: $dur = (min((int)$row[2], $report_end) - max((int)$row[1], $report_start))/60; if ($dur < (24*60)) @$hours[$room][$breve_description] += $dur; else @$hours[$room][$breve_description] += ($dur % $max_periods) + floor( $dur/(24*60) ) * $max_periods; $room_hash[$room] = 1; $breve_description_hash[$breve_description] = 1; }