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__);
?>