$sqlFilter = '(finishDate >= \'' . strftime(TZN_DATE_SQL, PRJ_DTE_NOW) . '\' OR status < ' . AAT_STATUS_LEVELS . ')' . $sqlToday;
break;
default:
break;
}
if ($sqlFilter) {
$objItemList->addWhere('(' . $sqlFilter . ')');
}
if ($pShow == 'past') {
// past items from recent to old
$objItemList->addOrder('finishDate DESC, priority ASC');
} else {
// coming items from old to new ones
$objItemList->addOrder('finishDate ASC, priority ASC');
}
$objItemList->loadList();
// --- LOAD TYPES --------------------------------------------
$objTypeList = new Type();
$objTypeList->addWhere("type <> ''");
$objTypeList->loadList();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<title>AAT Queue!</title>
<link href="aat.css" rel="stylesheet" type="text/css" />
<!--[if gte IE 5.5]>
<![if lt IE 7]>
<style type="text/css">
include 'config.php';
include PRJ_ROOT_PATH . 'lang/lg_en.php';
include PRJ_CLASS_PATH . 'tzn_generic.php';
include PRJ_CLASS_PATH . TZN_DB_CLASS;
include PRJ_CLASS_PATH . 'pkg_aat.php';
$objItemList = new Queue();
// show today's Queue + Queue with no schedule and undone
$objItemList->addWhere('status < 5');
// --- ordering statement ---
$pSort = $_REQUEST['sort'] ? $_REQUEST['sort'] : (defined('AAT_SORT_COLUMN') ? AAT_SORT_COLUMN : 'finishDate');
$pDir = $_REQUEST['dir'] ? $_REQUEST['dir'] : (defined('AAT_SORT_ORDER') ? AAT_SORT_ORDER : 1);
$objItemList->setOrder($pSort, $pDir);
// number of items to load
$rssSize = '0,' . defined('AAT_RSS_SIZE') ? AAT_RSS_SIZE : 8;
// load
$objItemList->loadList($rssSize);
header('Content-type: text/xml');
echo '<' . '?xml version="1.0"?' . '>';
echo "\n";
?>
<rss version="2.0">
<channel>
<title>AAT Queue! Next queue</title>
<link><?php
echo PRJ_WWW_URL;
?>
</link>
<?php
while ($objItem = $objItemList->rNext()) {
?>
<item>
