function get_open_tickets($conn)
{
Incident::search($conn, array('status' => 'not_closed'), 'life_time', 'ASC', 1, 10);
$tickets = Incident::search_count($conn);
$return['error'] = FALSE;
$return['output'] = intval($tickets);
return $return;
}
<?php
//include("mobile_header.php");
print_header($screen);
?>
<tr><td>
<?php
if ($screen == "status") {
echo "<style>div.legend td.legendLabel { border:0 none; width:120px }</style>";
// Get unresolved INCIDENTS
if (!$order_by) {
$order_by = 'life_time';
$order_mode = 'ASC';
}
$incident_list = Incident::search($conn, array("status" => "Open"), $order_by, $order_mode, 1, 10);
$unresolved_incidents = Incident::search_count($conn);
//$incident_list = Incident::get_list($conn, "ORDER BY date DESC");
$incident_list = Incident::search($conn, array(), "date", "DESC", 1, 1);
$incident_date1 = $incident_list[0] ? $incident_list[0]->get_date() : 0;
$incident_ticket_list = Incident_ticket::get_list($conn, "ORDER BY date DESC LIMIT 1");
$incident_date2 = $incident_ticket_list[0] ? $incident_ticket_list[0]->get_date() : 0;
if ($incident_list[0] || $incident_ticket_list[0]) {
$incident_date = strtotime($incident_date1) > strtotime($incident_date2) ? $incident_date1 : $incident_date2;
if ($incident_date == 0) {
$incident_date = "__/__/__ --:--:--";
}
}
//$incident_list = Incident::get_list($conn, "ORDER BY priority DESC");
$incident_list = Incident::search($conn, array("status" => "Open"), "priority", "DESC", 1, 1);
$incident_max_priority = $incident_list[0] ? $incident_list[0]->get_priority() : "-";
$incident_max_priority_id = $incident_list[0] ? $incident_list[0]->get_id() : "0";
</table>
</td>
</tr>
<?php
}
?>
</table>
<br/>
<!-- end filter -->
<?php
$rows_per_page = 50;
$incident_list = Incident::search($conn, $criteria, $order_by, $order_mode, $page, $rows_per_page);
$total_incidents = Incident::search_count($conn);
if (count($incident_list) >= $total_incidents) {
$total_incidents = count($incident_list);
if ($total_incidents > 0) {
$rows_per_page = $total_incidents;
}
}
if ($total_incidents > 0) {
$filter = '';
foreach ($criteria as $key => $value) {
$filter .= "&{$key}=" . urlencode($value);
}
if ($advanced_search) {
$filter .= "&advanced_search=" . urlencode($advanced_search);
}
// Next time reverse the order of the column
}
while (!$rs->EOF) {
$values = $rs->fields["Today"] . "," . $rs->fields["Yesterd"] . "," . $rs->fields["2DAgo"] . "," . $rs->fields["Week"] . "," . $rs->fields["2Weeks"];
$rs->MoveNext();
}
// Tickets
$incident_list = Incident::search($conn, array("status" => "Open", "last_update" => "CURDATE()"), "", "", 1, 99999999);
$today = Incident::search_count($conn);
$incident_list = Incident::search($conn, array("status" => "Open", "last_update" => array("DATE_ADD(CURDATE(), INTERVAL -1 DAY)", "CURDATE()")), "", "", 1, 999999999);
$yday = Incident::search_count($conn);
$incident_list = Incident::search($conn, array("status" => "Open", "last_update" => array("DATE_ADD(CURDATE(), " . $_2Ago . ")", $_2Ago_interv)), "", "", 1, 999999999);
$ago2 = Incident::search_count($conn);
$incident_list = Incident::search($conn, array("status" => "Open", "last_update" => array("DATE_ADD(CURDATE(), " . $_Week . ")", $_Week_interv)), "", "", 1, 999999999);
$week = Incident::search_count($conn);
$incident_list = Incident::search($conn, array("status" => "Open", "last_update" => array("DATE_ADD(CURDATE(), " . $_2Week . ")", $_2Week_interv)), "", "", 1, 999999999);
$week2 = Incident::search_count($conn);
$values2 = $today . "," . $yday . "," . $ago2 . "," . $week . "," . $week2;
//
$db->close($conn);
$db->close($conn2);
//
$alarm_urls = "'../control_panel/alarm_console.php?num_alarms_page=50&hmenu=Alarms&smenu=Alarms&hour=00&minutes=00&hide_closed=1&date_from=" . gmdate("Y-m-d", $timetz) . "&date_to=" . gmdate("Y-m-d", $timetz) . "'";
$alarm_urls .= ",'../control_panel/alarm_console.php?num_alarms_page=50&hmenu=Alarms&smenu=Alarms&hour=00&minutes=00&hide_closed=1&date_from=" . gmdate("Y-m-d", $timetz - 86400) . "&date_to=" . gmdate("Y-m-d", $timetz) . "'";
$alarm_urls .= ",'../control_panel/alarm_console.php?num_alarms_page=50&hmenu=Alarms&smenu=Alarms&hour=00&minutes=00&hide_closed=1&date_from=" . gmdate("Y-m-d", $timetz - 172800) . "&date_to=" . gmdate("Y-m-d", $timetz) . "'";
$alarm_urls .= ",'../control_panel/alarm_console.php?num_alarms_page=50&hmenu=Alarms&smenu=Alarms&hour=00&minutes=00&hide_closed=1&date_from=" . gmdate("Y-m-d", $timetz - 604800) . "&date_to=" . gmdate("Y-m-d", $timetz) . "'";
$alarm_urls .= ",'../control_panel/alarm_console.php?num_alarms_page=50&hmenu=Alarms&smenu=Alarms&hour=00&minutes=00&hide_closed=1&date_from=" . gmdate("Y-m-d", $timetz - 1209600) . "&date_to=" . gmdate("Y-m-d", $timetz) . "'";
?>
<script class="code" type="text/javascript">
var links = [<?php
