} 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]; $value = $stateLabels[$value];
$aclObj = new CentreonACL($centreon->user->user_id, $centreon->user->admin); $groupList = $aclObj->getAccessGroupsString(); $query .= " AND h.host_id = acl.host_id\n\tAND acl.service_id = s.service_id\n\tAND acl.group_id IN ({$groupList})"; } $orderby = "hostname ASC , description ASC"; if (isset($preferences['order_by']) && $preferences['order_by'] != "") { $orderby = $preferences['order_by']; } $query .= "ORDER BY {$orderby}"; $res = $dbb->query($query); $nbRows = $dbb->numberRows(); $data = array(); $outputLength = $preferences['output_length'] ? $preferences['output_length'] : 50; $commentLength = $preferences['comment_length'] ? $preferences['comment_length'] : 50; $hostObj = new CentreonHost($db); $svcObj = new CentreonService($db); while ($row = $res->fetchRow()) { foreach ($row as $key => $value) { if ($key == "last_check") { $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']; } elseif ($key == "s_state") { $data[$row['host_id'] . "_" . $row['service_id']]['color'] = $stateSColors[$value]; $value = $stateLabels[$value]; } elseif ($key == "h_state") { $data[$row['host_id'] . "_" . $row['service_id']]['hcolor'] = $stateHColors[$value]; $value = $stateLabels[$value];