if(check_user_permission(55) )
{
$page = IsSet($page) ? $page : 1;
$sort_by = IsSet($sort_by) ? stripslashes($sort_by) : '';
$sort_desc = IsSet($sort_desc) ? stripslashes($sort_desc) : 0;
$pageRecord = IsSet($pageRecord) ? $pageRecord : 50;
$varQueryString = formatURLQueryString('page,pageRecord', array($_REQUEST));
$url = formatURLQueryString('sort_by,sort_desc,page,pageRecord', array($_REQUEST));
$pageNum = 0;
$total = 0;
$query = "SELECT or.id, request_date, referral, CONCAT_WS(' ', f_name, l_name) AS user_name, company, CONCAT(city, ', ', os.name, ' - ',zip) as address, production_name, clearance_needed_date, composition, usage_description
FROM omp_request `or`
LEFT JOIN orchard_state os ON os.id = or.state
LEFT JOIN country co ON co.id = or.country
WHERE 1";
$query .= " ORDER BY ";
switch($sort_by)
{
case "id":
$query .= " or.id";
break;
case "request_date":
$query .= " or.request_date";
break;
case "name":
$query .= " user_name";
break;
case "company":
$query .= " or.company";
break;
case "address":
$query .= " address";
break;
case "clearance_needed_date":
$query .= " or.clearance_needed_date";
break;
case "production_name":
$query .= " or.production_name";
break;
case "composition":
$query .= " or.composition";
break;
case "usage_description":
$query .= " or.usage_description";
break;
default:
$query .= " or.request_date";
$sort_by = "request_date";
$sort_desc = 1;
break;
}
$query .= $sort_desc ? ' DESC' : '';
$query .= $viewall ? '' : ' LIMIT 5 ';
if(!$result = mysql_query($query))
showerror();
if($viewall) {
$total = mysql_num_rows($result);
$pageNum = ceil($total/$pageRecord);
if ($page > $pageNum)
$page = $pageNum;
if ($total) {
echo paginate($page, $pageRecord, $pageNum, $varQueryString);
} ?>
| =sortColumnHeader('ID', 'id', $url)?> |
=sortColumnHeader('Request Date', 'request_date', $url)?> |
=sortColumnHeader('Name', 'name', $url)?> |
=sortColumnHeader('Company', 'company', $url)?> |
=sortColumnHeader('Address', 'address', $url)?> |
=sortColumnHeader('Clearance Needed by Date', 'clearance_needed_date', $url)?> |
=sortColumnHeader('Production Name', 'production_name', $url)?> |
=sortColumnHeader('Track', 'composition', $url)?> |
=sortColumnHeader('Usage Description', 'usage_description', $url)?> |
if (mysql_num_rows($result)) {
$i = 0;
$rci = 0;
mysql_data_seek($result, (($page - 1) * $pageRecord));
while($row=mysql_fetch_array($result) and $i < $pageRecord) {
$i++;
$row_class = (++$rci & 1) ? '' : 'alt'; ?>
| =$row["id"]?> |
=$row["request_date"]?> |
=$row["user_name"]?> |
=$row["company"]?> |
=$row["address"]?> |
=$row["clearance_needed_date"]?> |
=$row["production_name"]?> |
=$row["composition"]?> |
=$row["usage_description"]?> |
}
}
else { ?>
| No promotional codes found. |
} ?>
if ($total) echo paginate($page, $pageRecord, $pageNum, $varQueryString, 'bottom'); ?>
}
elseif(mysql_num_rows($result)) { ?>
| ID |
Request Date |
Name |
Company |
Address |
Clearance Needed by Date |
Production Name |
Track |
Usage Description |
$i = 0;
$rci = 0;
while($row=mysql_fetch_array($result)) {
$i++;
$row_class = (++$rci & 1) ? '' : 'alt'; ?>
| =$row["id"]?> |
=$row["request_date"]?> |
=$row["user_name"]?> |
=$row["company"]?> |
=$row["address"]?> |
=$row["clearance_needed_date"]?> |
=$row["production_name"]?> |
=$row["composition"]?> |
=$row["usage_description"]?> |
} ?>
} ?>
} ?>