auth_ensure_user_authenticated();
// Avoid indexing of the page, although it does not do much as Google and co do not have access behind the Eurocontrol gate
html_robots_noindex();
// re-use the default ARTAS Mantis header of the page
html_page_top("CAMOS Internal Meeting");
// display on the right top end the last issues visited in Mantis
print_recently_visited();
// List Issue Created during the last 2 weeks in CAMOS Support, ATR, ACP
?>
<br>
<center><h1> Priority List</h1></center>
<br>
<?php
$statusResolved = config_get('bug_resolved_status_threshold', null, null, 3);
$statusOpened = getValueFromTxt(config_get('status_enum_string'), "Opened");
$statusHolding = getValueFromTxt(config_get('status_enum_string'), "Holding");
// Get Issues sorted by Priority + Severity
//IN (3, 4, 1, 9)
?>
<center><h2> ATR 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 = 3 " . "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> 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;
auth_ensure_user_authenticated();
// Avoid indexing of the page, although it does not do much as Google and co do not have access behind the Eurocontrol gate
html_robots_noindex();
// re-use the default ARTAS Mantis header of the page
html_page_top("CAMOS Internal Meeting");
// display on the right top end the last issues visited in Mantis
print_recently_visited();
// List Issue Created during the last 2 weeks in CAMOS Support, ATR, ACP
?>
<center><h2> Blocking / High Issues </h2></center>
<br>
<br>
<?php
$PriorityHigh = getValueFromTxt(config_get('priority_enum_string'), "High");
$SeverityBlocking = getValueFromTxt(config_get('severity_enum_string'), "Blocking");
$statusSubmitted = getValueFromTxt(config_get('status_enum_string'), "Submitted");
$statusResolved = config_get('bug_resolved_status_threshold', null, null, 3);
// Get Priority High values
$query = "SELECT id " . "FROM mantis_bug_table " . "where priority = {$PriorityHigh} " . "and severity = {$SeverityBlocking} " . "and project_id = 3 " . "and status < {$statusResolved} " . "Order by date_submitted asc;";
//print $query;
openTable();
displayResults($query);
$statusResolved = config_get('bug_resolved_status_threshold', null, null, 4);
$query = "SELECT id " . "FROM mantis_bug_table " . "where priority = {$PriorityHigh} " . "and severity = {$SeverityBlocking} " . "and project_id = 4 " . "and status < {$statusResolved} " . "Order by date_submitted asc;";
//print $query;
displayResults($query);
closeTable();
?>
<br><br><center><h2> Issues submitted 2 weeks ago </h2></center>
<?php
