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