function jas_getServerRankings($count)
{
if (!$count) {
$source = "jas_getServerRankings";
$message = "Missing number of results to return !";
$hint = "Please specify \$count for this function.";
ER_Handler::getInstance()->logCrit($source, $message, $hint);
return false;
}
// Clean the input variables and prepare query
$count = DB_escape_string($count, true);
// Build the query
$query = "SELECT server,SUM(copies*pages) as total FROM jobs_log ";
$query .= "GROUP BY server ORDER BY total DESC LIMIT {$count}";
if ($result = DB_query($query)) {
//Assignment !
//return DB_Dump_Result($result);
$tableSR = new TBL_table();
$tableSR->setCaption("server rankings");
$tableSR->setColumns(array('server', 'total'));
global $jas_serverStatsPage;
while ($row = mysql_fetch_assoc($result)) {
if (isset($jas_serverStatsPage)) {
$row['server'] = "<a href=\"" . $jas_serverStatsPage . $row['server'] . "\">" . $row['server'] . "</a>";
}
$tableSR->addRow($row);
}
mysql_free_result($result);
return $tableSR->displayTable('20');
} else {
$source = "jas_getServerRankings";
$message = "Query failed !";
$hint = "Check for the query syntax, and that the MySQL host is up.";
ER_Handler::getInstance()->logCrit($source, $message, $hint);
return false;
}
}
function jas_getPrinterRankings($count, $dpt = "")
{
/*$query="SELECT printer,SUM(copies*pages) as total FROM jobs_log ";
$query.="GROUP BY printer ORDER BY total DESC LIMIT $count";
$result=DB_query($query);
DB_dump_result($result);*/
if (!$count) {
$source = "jas_getPrinterRankings";
$message = "Missing number of results to return !";
$hint = "Please specify \$count for this function.";
$severity = ERWARN;
ER_log_error($source, $message, $severity, $hint);
return false;
}
// Clean the input variables and prepare query
$count = DB_escape_string($count);
$dpt = $dpt ? DB_escape_string($dpt) : 0;
// Build the query
$query = "SELECT printer,SUM(copies*pages) as total FROM jobs_log ";
// For $dpt, let's give up for now, we need to manage user groups...
// That'll be in a later version :P !
$query .= "GROUP BY printer ORDER BY total DESC LIMIT {$count}";
if ($result = DB_query($query)) {
//Assignment !
//return DB_Dump_Result($result);
$tableULJ = new TBL_table();
$tableULJ->setCaption("Printer rankings");
$tableULJ->setColumns(array('printer', 'total'));
global $jas_printerStatsPage;
while ($row = mysql_fetch_assoc($result)) {
if (isset($jas_printerStatsPage)) {
$row['printer'] = "<a href=\"" . $jas_printerStatsPage . $row['printer'] . "\">" . $row['printer'] . "</a>";
}
$tableULJ->addRow($row);
}
mysql_free_result($result);
return $tableULJ->displayTable('20');
} else {
$source = "jas_getPrinterRankings";
$message = "Query failed !";
$hint = "Check for the query syntax, and that the MySQL host is up.";
$severity = ERWARN;
ER_log_error($source, $message, $severity, $hint);
return false;
}
}
