/**
* Constructor
*
* @return void
*/
public function __construct()
{
parent::__construct();
$this->params['host_register'] = '0';
$this->register = 0;
$this->action = "HTPL";
}
$query .= " AND (mop1.ticket_value LIKE '" . $dbb->escape($preferences['ticket_id_search']) . "' OR mop2.ticket_value LIKE '" . $dbb->escape($preferences['ticket_id_search']) . "') ";
}
if (isset($preferences['ticket_subject_search']) && $preferences['ticket_subject_search'] != "") {
$query .= " AND (mopd1.subject LIKE '" . $dbb->escape($preferences['ticket_subject_search']) . "' OR mopd2.subject LIKE '" . $dbb->escape($preferences['ticket_subject_search']) . "') ";
}
$orderby = "hostname ASC , description ASC";
if (isset($preferences['order_by']) && $preferences['order_by'] != "") {
$orderby = $preferences['order_by'];
}
$query .= "ORDER BY {$orderby}";
$query .= " LIMIT " . $page * $preferences['entries'] . "," . $preferences['entries'];
$res = $dbb->query($query);
$nbRows = $dbb->numberRows();
$data = array();
$outputLength = $preferences['output_length'] ? $preferences['output_length'] : 50;
$hostObj = new CentreonHost($db);
$svcObj = new CentreonService($db);
$gmt = new CentreonGMT($db);
$gmt->getMyGMTFromSession(session_id(), $db);
while ($row = $res->fetchRow()) {
foreach ($row as $key => $value) {
if ($key == "last_check") {
$value = $gmt->getDate("Y-m-d H:i:s", $value);
//$value = date("Y-m-d H:i:s", $value);
} elseif ($key == "last_state_change" || $key == "last_hard_state_change") {
$value = time() - $value;
$value = CentreonDuration::toString($value);
} elseif ($key == "check_attempt") {
$value = $value . "/" . $row['max_check_attempts'] . ' (' . $aStateType[$row['state_type']] . ')';
} elseif ($key == "s_state") {
$data[$row['host_id'] . "_" . $row['service_id']]['color'] = $stateSColors[$value];
