closeTable();
?>
<center><h2> ACP Priority List</h2></center> <br>
<?php 
$query = "SELECT    id, (priority + severity) as s1, from_unixtime(due_date) as duedate " . "FROM      mantis_bug_table " . "where     project_id = 4 " . "and       status >= {$statusOpened} " . "and       status <> {$statusHolding} " . "and       status < {$statusResolved} " . "Order by s1 desc LIMIT 20;";
//print $query;
$fields = array("s1", "duedate");
openTable();
displayResultsWithFields($query, $fields);
closeTable();
?>
<center><h2> ATS Priority List</h2></center> <br>
<?php 
$query = "SELECT    id, (priority + severity) as s1, from_unixtime(due_date) as duedate " . "FROM      mantis_bug_table " . "where     project_id = 1 " . "and       status >= {$statusOpened} " . "and       status <> {$statusHolding} " . "and       status < {$statusResolved} " . "Order by s1 desc LIMIT 20;";
//print $query;
$fields = array("s1", "duedate");
openTable();
displayResultsWithFields($query, $fields);
closeTable();
?>
<center><h2> CAMOS Actions Priority List</h2></center> <br>
<?php 
$query = "SELECT    id, (priority + severity) as s1, from_unixtime(due_date) as duedate " . "FROM      mantis_bug_table " . "where     project_id = 9 " . "and       status >= {$statusOpened} " . "and       status <> {$statusHolding} " . "and       status < {$statusResolved} " . "Order by s1 desc LIMIT 10;";
//print $query;
$fields = array("s1", "duedate");
openTable();
displayResultsWithFields($query, $fields);
closeTable();
?>

openTable(array("Due date"));
displayResultsWithFields($query, array("duedate"));
closeTable();
?>

<br><br><center><h2> Milestones in the next 2 weeks </h2></center>
<br>
<br>
<?php 
$query = "SELECT    id, from_unixtime(due_date) as duedate, datediff(now(), from_unixtime(due_date)) as s1 " . "FROM      mantis_bug_table " . "where     project_id = 9  " . "and       category_id = 64 " . "and       status < {$statusResolved} " . "HAVING    s1 >= -15 and s1 <= 0 " . "Order by  due_date asc;";
openTable(array("Due date"));
displayResultsWithFields($query, array("duedate"));
closeTable();
?>


<br><br><center><h2> Issue Overdue </h2></center>

<?php 
$query = "SELECT id, datediff( from_unixtime(due_date), now() ) as s1,from_unixtime(due_date) as duedate " . "FROM      mantis_bug_table " . "where     due_date > 1 " . "HAVING    s1 < 0 " . "Order by  s1 desc;";
openTable();
displayResultsWithFields($query, array("duedate"));
closeTable();
?>

<?php 
// display the bottom of the page
html_page_bottom1(__FILE__);
?>