function get_organisation_list($current = "", $maxwidth = 50)
{
global $session;
$sql = "SELECT organisation.org_code, organisation.abbreviation || ' - ' || organisation.org_name FROM organisation ";
if (!($session->AllowedTo("Admin") || $session->AllowedTo("Support"))) {
$sql .= "JOIN org_system USING (org_code) ";
$sql .= "JOIN work_system USING (system_id) ";
$sql .= "JOIN system_usr ON (work_system.system_id = system_usr.system_id ";
$sql .= "AND system_usr.user_no = {$session->user_no} ";
$sql .= "AND system_usr.role = 'S') ";
}
$sql .= "WHERE organisation.active ORDER BY LOWER(org_name)";
$q = new PgQuery($sql);
$org_code_list = $q->BuildOptionList($current, 'GetOrgList');
return $org_code_list;
}
if (isset($choose_columns) && $choose_columns) {
array_push($form_url_parameters, "choose_columns=1");
}
$form_url = "{$PHP_SELF}";
for ($i = 0; $i < count($form_url_parameters) && $i < 20; $i++) {
$form_url .= ($i == 0 ? '?' : '&') . $form_url_parameters[$i];
}
echo "<form name=\"search\" action=\"{$form_url}\" Method=\"POST\">";
$systems = new PgQuery(SqlSelectSystems($org_code));
$system_list = $systems->BuildOptionList($system_id, "requestlist");
echo "<table border=0 cellspacing=2 cellpadding=0 align=center class=row0 width=100% style=\"border: 1px dashed #aaaaaa;\">\n<tr>\n";
echo "<td width=100%><table border=0 cellspacing=0 cellpadding=0 width=100%><tr valign=middle>\n";
echo "<td class=smb> System:</td><td class=\"sml\"><select class=\"sml\" name=system_id><option value=\".\">--- All Systems ---</option>{$system_list}</select></td>\n";
if (is_member_of('Admin', 'Support', 'Contractor')) {
$organisations = new PgQuery(SqlSelectOrganisations($org_code));
$orglist = "<option value=\"\">--- All Organisations ---</option>\n" . $organisations->BuildOptionList("{$org_code}", "requestlist");
echo "<td class=\"smb\"> Organisation:</td><td class=\"sml\"><select class=\"sml\" name=\"org_code\">\n{$orglist}</select></td>\n";
}
echo "<td valign=middle class=smb align=center><input type=submit value=\"RUN\" alt=\"Run\" title=\"Run a query with these settings\" name=submit class=\"submit\">";
echo "</tr></table></td></tr>\n";
echo "</table></form>\n";
}
// if not plain or stripped style
/**
* Now we build the statement that will find those requests...
*/
$query = "";
$maxresults = isset($maxresults) && intval($maxresults) > 0 ? intval($maxresults) : 100;
$flipped_columns = array_flip($columns);
$query .= "SELECT request.request_id, brief, usr.fullname, usr.email, request_on, status.lookup_desc AS status_desc, last_activity, detailed ";
$query .= ", request_type.lookup_desc AS request_type_desc, lower(usr.fullname) AS lfull, lower(brief) AS lbrief ";
/**
* Function to output a page header
*/
function PageHeader($style = "normal")
{
global $c, $session, $tmnu;
if (!$this->panel_top) {
return;
}
echo '<div id="topbar">';
echo $this->ImgLink('pwl-logo.png', '/', 252, 60);
echo '</div>' . "\n";
if ($session->logged_in) {
echo '<div id="searchbar">';
echo '<form action="/wrsearch.php" method="post" name="search">';
echo '<span class="prompt" style="vertical-align: 0%;">Find:</span>';
echo '<span class="entry"><input class="search_for" type="text" name="search_for" value="' . $GLOBALS['search_for'] . '"/></span>';
$systems = new PgQuery(SqlSelectSystems($GLOBALS['org_code']));
$system_list = $systems->BuildOptionList($GLOBALS['system_id'], 'Config::LocPgHdr');
echo '<span class="prompt" style="vertical-align: 0%;">Systems:</span>';
echo '<span class="entry"><select name="system_id" class="search_for"><option value="">-- select --</option>' . $system_list;
echo '</select></span>';
echo '<span class="entry""><input type="submit" alt="go" class="fsubmit" value="Search" /></span>';
echo '</form>';
echo '</div>' . "\n";
}
echo '<div id="top_menu">';
if ($session->logged_in) {
echo '<span style="float:right; margin-right:3px; margin-top:3px;">';
echo $session->fullname;
echo '</span>';
}
if (isset($tmnu) && is_object($tmnu) && $tmnu->Size() > 0) {
echo $tmnu->Render();
}
echo '</div>' . "\n";
}
/**
* Function to output a page header
*/
function PageHeader($style = "normal")
{
global $c, $session, $tmnu;
if (!$this->panel_top) {
return;
}
$systems = new PgQuery(SqlSelectSystems($GLOBALS['org_code']));
$system_list = $systems->BuildOptionList($GLOBALS['system_id'], 'PageHeader');
echo <<<EOHDR
<table border="0" cellspacing="0" cellpadding="0" style="height:86px;width:100%;background:url('/images/eduforge/eduforge_paua.jpg');">
<tr>
<td width="175" nowrap="nowrap" align="center">
<a href="/"><img alt="logo" border="0" src="/images/eduforge/eduforge_logo.gif" width="145" height="62" /></a>
</td>
<td class="spaced-out">s u p p o r t <span class="spaced-out-grey">. e d u f o r g e . o r g</span></td>
EOHDR;
if ($session->logged_in) {
echo '<td valign="bottom" style="background: inherit;"><div id="searchbar" style="background: inherit;">';
echo '<form action="/requestlist.php" method="post" name="search">';
echo '<span class="prompt" style="vertical-align: 0%;">Find:</span>';
echo '<span class="entry"><input class="search_for" type="text" name="search_for" value="' . $GLOBALS['search_for'] . '"/></span>';
echo '<span class="prompt" style="vertical-align: 0%;">Systems:</span>';
echo '<span class="entry"><select name="system_code" class="search_for"><option value="">-- select --</option>' . $system_list;
echo '</select></span>';
echo '<span class="entry""><input type="submit" alt="go" class="fsubmit" value="Search" /></span>';
echo '</form>';
echo '</div></td>' . "\n";
}
echo "</tr>\n</table>\n";
echo '<div id="top_menu">';
if ($session->logged_in) {
echo '<span style="float:right; margin-right:3px; margin-top:3px;">';
echo $session->fullname;
echo '</span>';
}
if (isset($tmnu) && is_object($tmnu) && $tmnu->Size() > 0) {
echo $tmnu->Render();
}
echo '</div>' . "\n";
}
function local_page_header()
{
global $system_name, $sysabbr, $session, $images, $tmnu;
echo '<div id="topbar"><a href="/"><img src="' . $images . '/logo_main.gif" width="383" height="77" border="0"></a></div>' . "\n";
if ($session->logged_in) {
echo '<div id="searchbar">';
echo '<form action="/wrsearch.php" method="post" name="search">';
echo '<span class="prompt" style="vertical-align: 0%;">Find:</span>';
echo '<span class="entry"><input class="search_for" type="text" name="search_for" value="' . $GLOBALS['search_for'] . '"/></span>';
$systems = new PgQuery(SqlSelectSystems($GLOBALS['org_code']));
$system_list = $systems->BuildOptionList($GLOBALS['system_id'], 'Config::LocPgHdr');
echo '<span class="prompt" style="vertical-align: 0%;">Systems:</span>';
echo '<span class="entry"><select name="system_id" class="search_for"><option value="">-- select --</option>' . $system_list;
echo '</select></span>';
echo '<span class="entry""><input type="submit" alt="go" class="fsubmit" value="Search" /></span>';
echo '</form>';
echo '</div>' . "\n";
}
echo '<div id="top_menu">';
if ($session->logged_in) {
echo '<span style="float:right; margin-right:3px; margin-top:3px;">';
echo $session->fullname;
echo '</span>';
}
if (isset($tmnu) && is_object($tmnu) && $tmnu->Size() > 0) {
echo $tmnu->Render();
}
echo '</div>' . "\n";
}
/**
* Render an EntryField into HTML
* @see EntryField::EntryField(), EntryForm::DataEntryLine()
*
* @return text An HTML fragment for the data-entry field.
*/
function Render()
{
global $session;
$r = "<";
switch ($this->ftype) {
case "select":
$r .= "select name=\"{$this->fname}\"%%attributes%%>";
reset($this->attributes);
while (list($k, $v) = each($this->attributes)) {
if (substr($k, 0, 1) != '_') {
continue;
}
if ($k == '_help') {
continue;
}
$k = substr($k, 1);
$r .= "<option value=\"" . htmlentities($k) . "\"";
if ("{$this->current}" == "{$k}") {
$r .= " selected";
}
$r .= ">{$v}</option>";
}
$r .= "</select>";
break;
case "lookup":
$r .= "select name=\"{$this->fname}\"%%attributes%%>";
reset($this->attributes);
while (list($k, $v) = each($this->attributes)) {
if (substr($k, 0, 1) != '_') {
continue;
}
$k = substr($k, 1);
if ($k == 'help' || $k == "sql" || $k == "type") {
continue;
}
if ($k == "null") {
$k = "";
}
if ($k == "zero") {
$k = "0";
}
$r .= "<option value=\"" . htmlentities($k) . "\"";
if ("{$this->current}" == "{$k}") {
$r .= " selected";
}
$r .= ">{$v}</option>";
}
if (isset($this->attributes["_sql"])) {
$qry = new PgQuery($this->attributes["_sql"]);
} else {
list($tbl, $fld) = explode("|", $this->attributes['_type'], 2);
$qry = new PgQuery("SELECT lookup_code, lookup_desc FROM lookup_code WHERE source_table = ? AND source_field = ? ORDER BY lookup_seq, lookup_code", $tbl, $fld);
}
$r .= $qry->BuildOptionList($this->current, "rndr:{$this->fname}");
$r .= "</select>";
break;
case "date":
case "timestamp":
if (!isset($this->attributes['size']) || $this->attributes['size'] == "") {
$size = " size=" . ($this->ftype == 'date' ? "12" : "18");
}
$r .= "input type=\"text\" name=\"{$this->fname}\"{$size} value=\"" . $session->FormattedDate(htmlentities($this->current)) . "\"%%attributes%%>";
break;
case "checkbox":
// We send a hidden field with a false value, which will be overridden by the real
// field with a true value (if true) or not overridden (if false).
$r .= "input type=\"hidden\" name=\"{$this->fname}\" value=\"off\"><";
case "radio":
$checked = "";
if ($this->current == 't' || intval($this->current) == 1 || $this->current == 'on' || isset($this->attributes['value']) && $this->current == $this->attributes['value']) {
$checked = " checked";
}
$id = "id_{$this->fname}" . ($this->ftype == "radio" ? "_" . $this->attributes['value'] : "");
if (isset($this->attributes['_label'])) {
$r .= "label for=\"{$id}\"";
if (isset($this->attributes['class'])) {
$r .= ' class="' . $this->attributes['class'] . '"';
}
$r .= "><";
}
$r .= "input type=\"{$this->ftype}\" name=\"{$this->fname}\" id=\"{$id}\"{$checked}%%attributes%%>";
if (isset($this->attributes['_label'])) {
$r .= " " . $this->attributes['_label'];
$r .= "</label>";
}
break;
case "button":
$r .= "input type=\"button\" name=\"{$this->fname}\"%%attributes%%>";
break;
case "submit":
$r .= "input type=\"submit\" name=\"{$this->fname}\" value=\"" . htmlentities($this->current) . "\"%%attributes%%>";
break;
case "textarea":
$r .= "textarea name=\"{$this->fname}\"%%attributes%%>{$this->current}</textarea>";
break;
case "file":
if (!isset($this->attributes['size']) || $this->attributes['size'] == "") {
$size = " size=25";
}
$r .= "input type=\"file\" name=\"{$this->fname}\"{$size} value=\"" . htmlentities($this->current) . "\"%%attributes%%>";
break;
case "password":
$r .= "input type=\"password\" name=\"{$this->fname}\" value=\"" . htmlentities($this->current) . "\"%%attributes%%>";
break;
default:
$r .= "input type=\"text\" name=\"{$this->fname}\" value=\"" . htmlentities($this->current) . "\"%%attributes%%>";
break;
}
// Now process the generic attributes
reset($this->attributes);
$attribute_values = "";
while (list($k, $v) = each($this->attributes)) {
if ($k == '_readonly') {
$attribute_values .= " readonly";
} else {
if ($k == '_disabled') {
$attribute_values .= " disabled";
}
}
if (substr($k, 0, 1) == '_') {
continue;
}
$attribute_values .= " {$k}=\"" . htmlentities($v) . "\"";
}
$r = str_replace('%%attributes%%', $attribute_values, $r);
$this->rendered = $r;
return $r;
}
