echo "</TR>\n"; ob_flush(); flush(); } echo "</TABLE>\n"; if (isset($_POST['xls'])) { $xlsresult = db_query($db, $sql); $columns = array("package", "jobcount", "cpuhours", "users", "groups"); result_as_xls($xlsresult, $columns, $_POST['system'] . "-software_usage-" . $_POST['start_date'] . "-" . $_POST['end_date']); } if (isset($_POST['ods'])) { $odsresult = db_query($db, $sql); $columns = array("package", "jobcount", "cpuhours", "users", "groups"); result_as_ods($odsresult, $columns, $_POST['system'] . "-software_usage-" . $_POST['start_date'] . "-" . $_POST['end_date']); } } db_disconnect($db); bookmarkable_url(); } else { begin_form("usage-summary.php"); system_chooser(); date_fields(); $orders = array("jobcount", "cpuhours", "users", "groups"); checkboxes_from_array("Supplemental reports", array("institution", "software")); $defaultorder = "cpuhours"; pulldown("order", "Order results by", $orders, $defaultorder); checkbox("Generate Excel files for supplemental reports", "xls"); checkbox("Generate ODF files for supplemental reports", "ods"); end_form(); } page_footer();
$keys = array_keys($_POST); if (isset($_POST['system'])) { $db = db_connect(); $sql = "SELECT username, groupname, COUNT(jobid) AS jobcount, SUM(nproc*TIME_TO_SEC(walltime))/3600 AS cpuhrs FROM Jobs WHERE system LIKE '" . $_POST['system'] . "' AND ( " . dateselect("submit", $_POST['start_date'], $_POST['end_date']) . " ) GROUP BY username ORDER BY " . $_POST['order'] . " DESC LIMIT " . $_POST['limit']; # echo "<PRE>".$sql."</PRE>\n"; $result = db_query($db, $sql); echo "<TABLE border=\"1\">\n"; echo "<TR><TH>user</TH><TH>group</TH><TH>job count</TH><TH>CPU-hours</TH></TR>\n"; while ($result->fetchInto($row)) { echo "<TR>"; $rkeys = array_keys($row); foreach ($rkeys as $key) { $data[$key] = array_shift($row); echo "<TD align=\"right\"><PRE>" . htmlspecialchars($data[$key]) . "</PRE></TD>"; } echo "</TR>\n"; } echo "</TABLE>\n"; db_disconnect($db); bookmarkable_url(); } else { begin_form("active-users.php"); system_chooser(); date_fields(); $choices = array("cpuhrs", "jobcount"); $defaultchoice = "cpuhrs"; pulldown("order", "Order by", $choices, $defaultchoice); textfield("limit", "Max shown", "10", 4); end_form(); } page_footer();
function preview() { tem_load('code/wfpl/metaform/preview.html'); tem_set('form_name', $GLOBALS['form_name']); tem_set('fields', $_REQUEST['fields']); $preview_tem = new tem(); $preview_tem->load_str(make_html(false)); if ($GLOBALS['opt_db'] == 'Yes') { $preview_tem->show('new_msg'); } $fields = get_fields(); foreach ($fields as $field) { list($name, $type, $input, $format, $sql) = $field; if ($type == 'pulldown') { pulldown($name, array('option 1', 'option 2', 'option 3')); } } $preview = $preview_tem->run(); unset($preview_tem); $preview = ereg_replace('type="submit"', 'type="submit" disabled="disabled"', $preview); tem_set('preview', $preview); tem_show('hiddens'); set_form_action(); tem_output(); }
function enc_provinces($province) { return enc_options(pulldown($province, $GLOBALS['wfpl_provinces_assoc'])); }
function formSelect($p, $opts = false) { $fname = $this->getFname($p[field]); $this->debug = false; if (is_array($opts)) { extract($opts); } else { unset($opts); } if ($this->debug) { da($opts); } if (!$opts[required]) { if (!$choose) { $choose = "Choose..."; } } elseif (!$choose) { $choose = false; } $this->fieldHeader($p, $opts); pulldown($p[rel]['foreign_table'], array("id_field" => $p[rel][foreign_field], "choose" => $choose, "fname" => $fname, "default" => $this->{$p}[field], "db" => $p[rel]['foreign_db'], "where" => $opts['where'], "frozen" => $opts['frozen']), $opts); $this->fieldFooter($p, $opts); }
$sql .= $pkgmatch[$key]; } else { $sql .= "script LIKE '%" . $key . "%' OR software LIKE '%" . $key . "%'"; } $sql .= " ) AND ( " . dateselect("start", $_POST['start_date'], $_POST['end_date']) . " )"; $result = db_query($db, $sql); while ($result->fetchInto($row)) { $rkeys = array_keys($row); echo "<TR>"; foreach ($rkeys as $rkey) { $data[$rkey] = array_shift($row); echo "<TD align=\"right\"><PRE>" . $data[$rkey] . "</PRE></TD>"; } echo "</TR>\n"; } echo "</TABLE>\n"; } } db_disconnect($db); bookmarkable_url(); } else { begin_form("software-usage-by-institution.php"); system_chooser(); date_fields(); $orders = array("jobcount", "cpuhours", "users", "groups"); $defaultorder = "cpuhours"; pulldown("order", "Order by", $orders, $defaultorder); checkboxes_from_array("Packages", $packages); end_form(); } page_footer();