include "code-list.php";
include "user-list.php";
$title = "{$system_name} Request Ranking List";
// Recommended way of limiting queries to not include sub-tables for 7.1
$result = awm_pgexec($dbconn, "SET SQL_Inheritance TO OFF;");
require_once "top-menu-bar.php";
require_once "page-header.php";
// Initialise variables.
include "system-list.php";
if (is_member_of('Admin', 'Support')) {
$system_list = get_system_list("", "{$system_id}");
} else {
$system_list = get_system_list("CES", "{$system_id}");
}
include "organisation-list.php";
$org_list = get_organisation_list("{$org_code}");
?>
<form method="POST" action="<?php
echo $PHP_SELF;
?>
" class=row1>
<table align=center>
<tr>
<td class=smb> System:</td>
<td class=sml>
<select class=sml name=system_id>
<option>(All)</option>
<?php
echo $system_list;
?>
$user_list = "<option value=\"\">--- All Users ---</option>" . get_user_list("Support,Contractor", "", $user_no);
}
echo "<td class=smb align=right> Work By:</td><td class=sml><select class=sml name=user_no>{$user_list}</select></td>\n";
printf("<td align=right><input type=checkbox value=1 name=uncharged%s></td><td align=left class=smb><label for=uncharged>Uncharged</label></td>\n", "{$uncharged}" != "" ? " checked" : "");
printf("<td align=right><input type=checkbox value=1 name=charge%s></td><td align=left class=smb><label for=charge>Charge</label></td>\n", "{$charge}" != "" ? " checked" : "");
echo "</tr></table></td>\n<tr><td><table border=0 cellpadding=0 cellspacing=0 width=100%>\n";
include "system-list.php";
if (is_member_of('Admin', 'Support')) {
$system_list = get_system_list("", "{$system_id}", 35);
} else {
$system_list = get_system_list("CES", "{$system_id}", 35);
}
echo "<td class=smb>System:</td><td class=sml><font size=1><select class=sml name=system_id><option value=\"\">--- All Systems ---</option>{$system_list}</select></font></td>\n";
if (is_member_of('Admin', 'Support')) {
include "organisation-list.php";
$orglist = "<option value=\"\">--- All Organisations ---</option>\n" . get_organisation_list("{$org_code}", 35);
echo "<td class=smb> Organisation:</td><td class=sml><select class=sml name=\"org_code\">\n{$orglist}</select></td>\n";
}
echo "<td align=left><input type=submit class=submit alt=go id=go value=\"GO>>\"name=go></td>\n";
echo "</tr></table></td></tr>\n<tr><td><table border=0 cellspacing=0 cellpadding=0 width=100%><tr valign=middle>\n<td class=smb align=right>Work From:</td>\n<td nowrap class=smb><input type=text size=10 name=from_date class=sml value=\"{$from_date}\">\n<a href=\"javascript:show_calendar('forms.form.from_date');\" onmouseover=\"window.status='Date Picker';return true;\" onmouseout=\"window.status='';return true;\">" . $theme->Image("date-picker.gif") . "</a>\n</td>\n\n<td class=smb align=right> To:</td>\n<td nowrap class=smb><input type=text size=10 name=to_date class=sml value=\"{$to_date}\">\n<a href=\"javascript:show_calendar('forms.form.to_date');\" onmouseover=\"window.status='Date Picker';return true;\" onmouseout=\"window.status='';return true;\">" . $theme->Image("date-picker.gif") . "</a>\n</td>\n<td class=smb align=right> Type:</td>\n<td nowrap class=smb><select name=\"type_code\" class=sml><option value=\"\">-- All Types --</option>{$request_types}</select></td>\n</tr></table></td>\n</tr>\n</table>\n</form>\n";
}
$numcols = 7;
if ("{$search_for}{$system_id} " != "") {
$query = "SELECT request.*, organisation.*, request_timesheet.*, ";
$query .= " worker.fullname AS worker_name, requester.fullname AS requester_name";
$query .= " FROM request, usr AS worker, usr AS requester, organisation, request_timesheet ";
$query .= " WHERE request_timesheet.request_id = request.request_id";
$query .= " AND worker.user_no = work_by_id ";
$query .= " AND requester.user_no = requester_id ";
$query .= " AND organisation.org_code = requester.org_code ";
if (isset($user_no) && $user_no > 0) {
}
if (!isset($to_date)) {
$to_date = date('d/m/y', mktime(0, 0, 0, date("m"), 0, date("Y")));
}
if (!isset($break_columns)) {
$break_columns = 2;
}
if (is_member_of('Admin', 'Accounts')) {
$system_list = get_system_list("", $system_id);
$user_list = get_user_list("Support", "", $users);
} else {
$system_list = get_system_list("CES", $system_id);
$users = array($session->user_no);
$user_list = "<option value=\"" . $session->user_no . "\">" . substr($session->fullname, 0, 25) . " (" . $session->abbreviation . ")" . "</option>";
}
$organisation_list = get_organisation_list($organisation_code);
$request_types = get_code_list("request", "request_type", "{$request_type}");
$quote_types = get_code_list("request_quote", "quote_type", "{$quote_type}");
$period_total = "week";
$select_columns = array("" => "", "Organisation" => "o.org_name", "System" => "ws.system_desc", "WR#" => "r.request_id", "Work By" => "rtu.fullname", "Request Brief" => "r.brief", "Request Status" => "r.last_status");
// $select_columns=array(""=>"","Organisation"=>"o.org_name","System"=>"r.system_id","WR#"=>"r.request_id","Work By"=>"rtu.fullname","Request Brief"=>"r.brief","Request Status"=>"r.last_status");
function buildSelect($name, $key_values, $current)
{
// global $select_columns;
$select = "<select name=\"" . $name . "\" class=\"sml\" id=\"" . $name . "\">\n";
foreach ($key_values as $key => $value) {
$select .= "<option";
if ($key == $current) {
$select .= " selected=\"selected\"";
}
$select .= ">{$key}</option>\n";
