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; } }