}
echo "</TABLE>\n";
# by institution
# NOTE By-institution jobstats involves OSC site-specific logic. You may
# want to comment out the following statement.
$inst_summary = true;
if (isset($_POST['institution']) && isset($inst_summary) && $inst_summary == true) {
echo "<H3>Usage By Institution</H#>\n";
$result = get_metric($db, $_POST['system'], 'institution', 'usage', $_POST['start_date'], $_POST['end_date']);
metric_as_table($result, 'institution', 'usage');
if (isset($_POST['xls'])) {
$xlsresult = get_metric($db, $_POST['system'], 'institution', 'usage', $_POST['start_date'], $_POST['end_date']);
metric_as_xls($xlsresult, 'institution', 'usage', $_POST['system'], $_POST['start_date'], $_POST['end_date']);
}
if (isset($_POST['ods'])) {
$odsresult = get_metric($db, $_POST['system'], 'institution', 'usage', $_POST['start_date'], $_POST['end_date']);
metric_as_ods($odsresult, 'institution', 'usage', $_POST['system'], $_POST['start_date'], $_POST['end_date']);
}
ob_flush();
flush();
}
# software usage
if (isset($_POST['software'])) {
echo "<H3>Software Usage</H3>\n";
echo "<TABLE border=1>\n";
echo "<TR><TH>package</TH><TH>jobcount</TH><TH>cpuhours</TH><TH>users</TH><TH>groups</TH></TR>\n";
ob_flush();
flush();
$first = 1;
$sql = "";
foreach ($packages as $pkg) {
function jobstats_summary($db, $system, $start_date, $end_date)
{
$result = get_metric($db, $system, "", "cpuhours", $start_date, $end_date);
$result->fetchInto($row);
$jobcount = $row[0];
$cpuhours = $row[1];
echo "<P><B>" . $jobcount . " jobs run<BR>\n";
echo $cpuhours . " CPU-hours consumed";
$nproc = nprocs($system);
if ($nproc > 0) {
$data = ndays($db, $system, $start_date, $end_date);
$ndays = $data[0];
$cpuhours_avail = $data[1];
if ($ndays > 0) {
$avgutil = 100.0 * $cpuhours / $cpuhours_avail;
printf(" (avg. %6.2f%% utilization over %d days)", $avgutil, $ndays);
}
}
echo "<BR>\n";
$usercount = get_metric($db, $system, "", "usercount", $start_date, $end_date);
$usercount->fetchInto($counts);
$nusers = $counts[1];
$ngroups = $counts[2];
echo $nusers . " distinct users, " . $ngroups . " distinct groups";
echo "</B></P>\n";
}
