$header = array(is_show_all_nodes() ? new CCol(S_NODE, 'left') : null, make_sorting_header(S_DISCOVERED_DEVICE, 'ip'), new CCol(S_MONITORED_HOST, 'left'), new CCol(array(S_UPTIME . '/', S_DOWNTIME), 'left'));
$css = getUserTheme($USER_DETAILS);
$vTextColor = $css == 'css_od.css' ? '&color=white' : '';
foreach ($services as $name => $foo) {
$header[] = new CImg('vtext.php?text=' . $name . $vTextColor);
}
$table = new CTableInfo();
$table->setHeader($header, 'vertical_header');
$options = array('filter' => array('status' => DRULE_STATUS_ACTIVE), 'selectDHosts' => API_OUTPUT_EXTEND, 'output' => API_OUTPUT_EXTEND);
if ($druleid > 0) {
$options['druleids'] = $druleid;
}
$drules = CDRule::get($options);
order_result($drules, 'name');
$options = array('druleids' => zbx_objectValues($drules, 'druleid'), 'selectDServices' => API_OUTPUT_REFER, 'output' => API_OUTPUT_REFER);
$db_dhosts = CDHost::get($options);
$db_dhosts = zbx_toHash($db_dhosts, 'dhostid');
$db_dservices = zbx_toHash($dservices, 'dserviceid');
//SDII($db_dservices);
foreach ($drules as $dnum => $drule) {
$discovery_info = array();
$dhosts = $drule['dhosts'];
foreach ($dhosts as $dhnum => $dhost) {
if (DHOST_STATUS_DISABLED == $dhost['status']) {
$hclass = 'disabled';
$htime = $dhost['lastdown'];
} else {
$hclass = 'enabled';
$htime = $dhost['lastup'];
}
// $primary_ip stores the primary host ip of the dhost
/**
* Get Host data
*
* {@source}
* @access public
* @static
* @since 1.8
* @version 1
*
* @param _array $options
* @param array $options['nodeids'] Node IDs
* @param array $options['groupids'] HostGroup IDs
* @param array $options['hostids'] Host IDs
* @param boolean $options['monitored_hosts'] only monitored Hosts
* @param boolean $options['templated_hosts'] include templates in result
* @param boolean $options['with_items'] only with items
* @param boolean $options['with_monitored_items'] only with monitored items
* @param boolean $options['with_historical_items'] only with historical items
* @param boolean $options['with_triggers'] only with triggers
* @param boolean $options['with_monitored_triggers'] only with monitored triggers
* @param boolean $options['with_httptests'] only with http tests
* @param boolean $options['with_monitored_httptests'] only with monitored http tests
* @param boolean $options['with_graphs'] only with graphs
* @param boolean $options['editable'] only with read-write permission. Ignored for SuperAdmins
* @param int $options['extendoutput'] return all fields for Hosts
* @param boolean $options['select_groups'] select HostGroups
* @param boolean $options['select_templates'] select Templates
* @param boolean $options['select_items'] select Items
* @param boolean $options['select_triggers'] select Triggers
* @param boolean $options['select_graphs'] select Graphs
* @param boolean $options['select_applications'] select Applications
* @param boolean $options['select_macros'] select Macros
* @param boolean $options['select_profile'] select Profile
* @param int $options['count'] count Hosts, returned column name is rowscount
* @param string $options['pattern'] search hosts by pattern in Host name
* @param string $options['extendPattern'] search hosts by pattern in Host name, ip and DNS
* @param int $options['limit'] limit selection
* @param string $options['sortfield'] field to sort by
* @param string $options['sortorder'] sort order
* @return array|boolean Host data as array or false if error
*/
public static function get($options = array())
{
global $USER_DETAILS;
$result = array();
$nodeCheck = false;
$user_type = $USER_DETAILS['type'];
$userid = $USER_DETAILS['userid'];
$sort_columns = array('hostid', 'host', 'status', 'dns', 'ip');
// allowed columns for sorting
$subselects_allowed_outputs = array(API_OUTPUT_REFER, API_OUTPUT_EXTEND, API_OUTPUT_CUSTOM);
// allowed output options for [ select_* ] params
$sql_parts = array('select' => array('hosts' => 'h.hostid'), 'from' => array('hosts' => 'hosts h'), 'where' => array(), 'group' => array(), 'order' => array(), 'limit' => null);
$def_options = array('nodeids' => null, 'groupids' => null, 'hostids' => null, 'proxyids' => null, 'templateids' => null, 'itemids' => null, 'triggerids' => null, 'maintenanceids' => null, 'graphids' => null, 'dhostids' => null, 'dserviceids' => null, 'monitored_hosts' => null, 'templated_hosts' => null, 'proxy_hosts' => null, 'with_items' => null, 'with_monitored_items' => null, 'with_historical_items' => null, 'with_triggers' => null, 'with_monitored_triggers' => null, 'with_httptests' => null, 'with_monitored_httptests' => null, 'with_graphs' => null, 'editable' => null, 'nopermissions' => null, 'filter' => null, 'search' => null, 'startSearch' => null, 'excludeSearch' => null, 'output' => API_OUTPUT_REFER, 'extendoutput' => null, 'select_groups' => null, 'selectParentTemplates' => null, 'select_items' => null, 'select_triggers' => null, 'select_graphs' => null, 'select_dhosts' => null, 'select_dservices' => null, 'select_applications' => null, 'select_macros' => null, 'select_profile' => null, 'countOutput' => null, 'groupCount' => null, 'preservekeys' => null, 'sortfield' => '', 'sortorder' => '', 'limit' => null, 'limitSelects' => null);
$options = zbx_array_merge($def_options, $options);
if (!is_null($options['extendoutput'])) {
$options['output'] = API_OUTPUT_EXTEND;
if (!is_null($options['select_groups'])) {
$options['select_groups'] = API_OUTPUT_EXTEND;
}
if (!is_null($options['selectParentTemplates'])) {
$options['selectParentTemplates'] = API_OUTPUT_EXTEND;
}
if (!is_null($options['select_items'])) {
$options['select_items'] = API_OUTPUT_EXTEND;
}
if (!is_null($options['select_triggers'])) {
$options['select_triggers'] = API_OUTPUT_EXTEND;
}
if (!is_null($options['select_graphs'])) {
$options['select_graphs'] = API_OUTPUT_EXTEND;
}
if (!is_null($options['select_applications'])) {
$options['select_applications'] = API_OUTPUT_EXTEND;
}
if (!is_null($options['select_macros'])) {
$options['select_macros'] = API_OUTPUT_EXTEND;
}
}
if (is_array($options['output'])) {
unset($sql_parts['select']['hosts']);
$sql_parts['select']['hostid'] = ' h.hostid';
foreach ($options['output'] as $key => $field) {
$sql_parts['select'][$field] = ' h.' . $field;
}
$options['output'] = API_OUTPUT_CUSTOM;
}
// editable + PERMISSION CHECK
if (USER_TYPE_SUPER_ADMIN == $user_type || $options['nopermissions']) {
} else {
$permission = $options['editable'] ? PERM_READ_WRITE : PERM_READ_ONLY;
$sql_parts['where'][] = 'EXISTS (' . ' SELECT hh.hostid ' . ' FROM hosts hh, hosts_groups hgg, rights r, users_groups ug ' . ' WHERE hh.hostid=h.hostid ' . ' AND hh.hostid=hgg.hostid ' . ' AND r.id=hgg.groupid ' . ' AND r.groupid=ug.usrgrpid ' . ' AND ug.userid=' . $userid . ' AND r.permission>=' . $permission . ' AND NOT EXISTS( ' . ' SELECT hggg.groupid ' . ' FROM hosts_groups hggg, rights rr, users_groups gg ' . ' WHERE hggg.hostid=hgg.hostid ' . ' AND rr.id=hggg.groupid ' . ' AND rr.groupid=gg.usrgrpid ' . ' AND gg.userid=' . $userid . ' AND rr.permission<' . $permission . ' )) ';
}
// nodeids
$nodeids = !is_null($options['nodeids']) ? $options['nodeids'] : get_current_nodeid();
// hostids
if (!is_null($options['hostids'])) {
zbx_value2array($options['hostids']);
$sql_parts['where']['hostid'] = DBcondition('h.hostid', $options['hostids']);
if (!$nodeCheck) {
$nodeCheck = true;
$sql_parts['where'][] = DBin_node('h.hostid', $nodeids);
}
}
// groupids
if (!is_null($options['groupids'])) {
zbx_value2array($options['groupids']);
if ($options['output'] != API_OUTPUT_SHORTEN) {
$sql_parts['select']['groupid'] = 'hg.groupid';
}
$sql_parts['from']['hosts_groups'] = 'hosts_groups hg';
$sql_parts['where'][] = DBcondition('hg.groupid', $options['groupids']);
$sql_parts['where']['hgh'] = 'hg.hostid=h.hostid';
if (!is_null($options['groupCount'])) {
$sql_parts['group']['groupid'] = 'hg.groupid';
}
if (!$nodeCheck) {
$nodeCheck = true;
$sql_parts['where'][] = DBin_node('hg.groupid', $nodeids);
}
}
// proxyids
if (!is_null($options['proxyids'])) {
zbx_value2array($options['proxyids']);
if ($options['output'] != API_OUTPUT_SHORTEN) {
$sql_parts['select']['proxy_hostid'] = 'h.proxy_hostid';
}
$sql_parts['where'][] = DBcondition('h.proxy_hostid', $options['proxyids']);
}
// templateids
if (!is_null($options['templateids'])) {
zbx_value2array($options['templateids']);
if ($options['output'] != API_OUTPUT_SHORTEN) {
$sql_parts['select']['templateid'] = 'ht.templateid';
}
$sql_parts['from']['hosts_templates'] = 'hosts_templates ht';
$sql_parts['where'][] = DBcondition('ht.templateid', $options['templateids']);
$sql_parts['where']['hht'] = 'h.hostid=ht.hostid';
if (!is_null($options['groupCount'])) {
$sql_parts['group']['templateid'] = 'ht.templateid';
}
if (!$nodeCheck) {
$nodeCheck = true;
$sql_parts['where'][] = DBin_node('ht.templateid', $nodeids);
}
}
// itemids
if (!is_null($options['itemids'])) {
zbx_value2array($options['itemids']);
if ($options['output'] != API_OUTPUT_SHORTEN) {
$sql_parts['select']['itemid'] = 'i.itemid';
}
$sql_parts['from']['items'] = 'items i';
$sql_parts['where'][] = DBcondition('i.itemid', $options['itemids']);
$sql_parts['where']['hi'] = 'h.hostid=i.hostid';
if (!$nodeCheck) {
$nodeCheck = true;
$sql_parts['where'][] = DBin_node('i.itemid', $nodeids);
}
}
// triggerids
if (!is_null($options['triggerids'])) {
zbx_value2array($options['triggerids']);
if ($options['output'] != API_OUTPUT_SHORTEN) {
$sql_parts['select']['triggerid'] = 'f.triggerid';
}
$sql_parts['from']['functions'] = 'functions f';
$sql_parts['from']['items'] = 'items i';
$sql_parts['where'][] = DBcondition('f.triggerid', $options['triggerids']);
$sql_parts['where']['hi'] = 'h.hostid=i.hostid';
$sql_parts['where']['fi'] = 'f.itemid=i.itemid';
if (!$nodeCheck) {
$nodeCheck = true;
$sql_parts['where'][] = DBin_node('f.triggerid', $nodeids);
}
}
// graphids
if (!is_null($options['graphids'])) {
zbx_value2array($options['graphids']);
if ($options['output'] != API_OUTPUT_SHORTEN) {
$sql_parts['select']['graphid'] = 'gi.graphid';
}
$sql_parts['from']['graphs_items'] = 'graphs_items gi';
$sql_parts['from']['items'] = 'items i';
$sql_parts['where'][] = DBcondition('gi.graphid', $options['graphids']);
$sql_parts['where']['igi'] = 'i.itemid=gi.itemid';
$sql_parts['where']['hi'] = 'h.hostid=i.hostid';
if (!$nodeCheck) {
$nodeCheck = true;
$sql_parts['where'][] = DBin_node('gi.graphid', $nodeids);
}
}
// dhostids
if (!is_null($options['dhostids'])) {
zbx_value2array($options['dhostids']);
if ($options['output'] != API_OUTPUT_SHORTEN) {
$sql_parts['select']['dhostid'] = 'ds.dhostid';
}
$sql_parts['from']['dservices'] = 'dservices ds';
$sql_parts['where'][] = DBcondition('ds.dhostid', $options['dhostids']);
$sql_parts['where']['dsh'] = 'ds.ip=h.ip';
if (!is_null($options['groupCount'])) {
$sql_parts['group']['dhostid'] = 'ds.dhostid';
}
}
// dserviceids
if (!is_null($options['dserviceids'])) {
zbx_value2array($options['dserviceids']);
if ($options['output'] != API_OUTPUT_SHORTEN) {
$sql_parts['select']['dserviceid'] = 'ds.dserviceid';
}
$sql_parts['from']['dservices'] = 'dservices ds';
$sql_parts['where'][] = DBcondition('ds.dserviceid', $options['dserviceids']);
$sql_parts['where']['dsh'] = 'ds.ip=h.ip';
if (!is_null($options['groupCount'])) {
$sql_parts['group']['dserviceid'] = 'ds.dserviceid';
}
}
// maintenanceids
if (!is_null($options['maintenanceids'])) {
zbx_value2array($options['maintenanceids']);
if ($options['output'] != API_OUTPUT_SHORTEN) {
$sql_parts['select']['maintenanceid'] = 'mh.maintenanceid';
}
$sql_parts['from']['maintenances_hosts'] = 'maintenances_hosts mh';
$sql_parts['where'][] = DBcondition('mh.maintenanceid', $options['maintenanceids']);
$sql_parts['where']['hmh'] = 'h.hostid=mh.hostid';
if (!is_null($options['groupCount'])) {
$sql_parts['group']['maintenanceid'] = 'mh.maintenanceid';
}
}
// node check !!!!!
// should last, after all ****IDS checks
if (!$nodeCheck) {
$nodeCheck = true;
$sql_parts['where'][] = DBin_node('h.hostid', $nodeids);
}
// monitored_hosts, templated_hosts
if (!is_null($options['monitored_hosts'])) {
$sql_parts['where']['status'] = 'h.status=' . HOST_STATUS_MONITORED;
} else {
if (!is_null($options['templated_hosts'])) {
$sql_parts['where']['status'] = 'h.status IN (' . HOST_STATUS_MONITORED . ',' . HOST_STATUS_NOT_MONITORED . ',' . HOST_STATUS_TEMPLATE . ')';
} else {
if (!is_null($options['proxy_hosts'])) {
$sql_parts['where']['status'] = 'h.status IN (' . HOST_STATUS_PROXY_ACTIVE . ',' . HOST_STATUS_PROXY_PASSIVE . ')';
} else {
$sql_parts['where']['status'] = 'h.status IN (' . HOST_STATUS_MONITORED . ',' . HOST_STATUS_NOT_MONITORED . ')';
}
}
}
// with_items, with_monitored_items, with_historical_items
if (!is_null($options['with_items'])) {
$sql_parts['where'][] = 'EXISTS (SELECT i.hostid FROM items i WHERE h.hostid=i.hostid )';
} else {
if (!is_null($options['with_monitored_items'])) {
$sql_parts['where'][] = 'EXISTS (SELECT i.hostid FROM items i WHERE h.hostid=i.hostid AND i.status=' . ITEM_STATUS_ACTIVE . ')';
} else {
if (!is_null($options['with_historical_items'])) {
$sql_parts['where'][] = 'EXISTS (SELECT i.hostid FROM items i WHERE h.hostid=i.hostid AND (i.status=' . ITEM_STATUS_ACTIVE . ' OR i.status=' . ITEM_STATUS_NOTSUPPORTED . ') AND i.lastvalue IS NOT NULL)';
}
}
}
// with_triggers, with_monitored_triggers
if (!is_null($options['with_triggers'])) {
$sql_parts['where'][] = 'EXISTS( ' . ' SELECT i.itemid ' . ' FROM items i, functions f, triggers t ' . ' WHERE i.hostid=h.hostid ' . ' AND i.itemid=f.itemid ' . ' AND f.triggerid=t.triggerid)';
} else {
if (!is_null($options['with_monitored_triggers'])) {
$sql_parts['where'][] = 'EXISTS( ' . ' SELECT i.itemid ' . ' FROM items i, functions f, triggers t ' . ' WHERE i.hostid=h.hostid ' . ' AND i.status=' . ITEM_STATUS_ACTIVE . ' AND i.itemid=f.itemid ' . ' AND f.triggerid=t.triggerid ' . ' AND t.status=' . TRIGGER_STATUS_ENABLED . ')';
}
}
// with_httptests, with_monitored_httptests
if (!is_null($options['with_httptests'])) {
$sql_parts['where'][] = 'EXISTS( ' . ' SELECT a.applicationid ' . ' FROM applications a, httptest ht ' . ' WHERE a.hostid=h.hostid ' . ' AND ht.applicationid=a.applicationid)';
} else {
if (!is_null($options['with_monitored_httptests'])) {
$sql_parts['where'][] = 'EXISTS( ' . ' SELECT a.applicationid ' . ' FROM applications a, httptest ht ' . ' WHERE a.hostid=h.hostid ' . ' AND ht.applicationid=a.applicationid ' . ' AND ht.status=' . HTTPTEST_STATUS_ACTIVE . ')';
}
}
// with_graphs
if (!is_null($options['with_graphs'])) {
$sql_parts['where'][] = 'EXISTS( ' . ' SELECT DISTINCT i.itemid ' . ' FROM items i, graphs_items gi ' . ' WHERE i.hostid=h.hostid ' . ' AND i.itemid=gi.itemid)';
}
// output
if ($options['output'] == API_OUTPUT_EXTEND) {
$sql_parts['select']['hosts'] = 'h.*';
}
// countOutput
if (!is_null($options['countOutput'])) {
$options['sortfield'] = '';
$sql_parts['select'] = array('count(DISTINCT h.hostid) as rowscount');
//groupCount
if (!is_null($options['groupCount'])) {
foreach ($sql_parts['group'] as $key => $fields) {
$sql_parts['select'][$key] = $fields;
}
}
}
// search
if (is_array($options['search'])) {
zbx_db_search('hosts h', $options, $sql_parts);
}
// filter
if (is_array($options['filter'])) {
zbx_db_filter('hosts h', $options, $sql_parts);
}
// order
// restrict not allowed columns for sorting
$options['sortfield'] = str_in_array($options['sortfield'], $sort_columns) ? $options['sortfield'] : '';
if (!zbx_empty($options['sortfield'])) {
$sortorder = $options['sortorder'] == ZBX_SORT_DOWN ? ZBX_SORT_DOWN : ZBX_SORT_UP;
$sql_parts['order'][$options['sortfield']] = 'h.' . $options['sortfield'] . ' ' . $sortorder;
if (!str_in_array('h.' . $options['sortfield'], $sql_parts['select']) && !str_in_array('h.*', $sql_parts['select'])) {
$sql_parts['select'][$options['sortfield']] = 'h.' . $options['sortfield'];
}
}
// limit
if (zbx_ctype_digit($options['limit']) && $options['limit']) {
$sql_parts['limit'] = $options['limit'];
}
//-------
$hostids = array();
$sql_parts['select'] = array_unique($sql_parts['select']);
$sql_parts['from'] = array_unique($sql_parts['from']);
$sql_parts['where'] = array_unique($sql_parts['where']);
$sql_parts['group'] = array_unique($sql_parts['group']);
$sql_parts['order'] = array_unique($sql_parts['order']);
$sql_select = '';
$sql_from = '';
$sql_where = '';
$sql_group = '';
$sql_order = '';
if (!empty($sql_parts['select'])) {
$sql_select .= implode(',', $sql_parts['select']);
}
if (!empty($sql_parts['from'])) {
$sql_from .= implode(',', $sql_parts['from']);
}
if (!empty($sql_parts['where'])) {
$sql_where .= implode(' AND ', $sql_parts['where']);
}
if (!empty($sql_parts['group'])) {
$sql_where .= ' GROUP BY ' . implode(',', $sql_parts['group']);
}
if (!empty($sql_parts['order'])) {
$sql_order .= ' ORDER BY ' . implode(',', $sql_parts['order']);
}
$sql_limit = $sql_parts['limit'];
$sql = 'SELECT ' . zbx_db_distinct($sql_parts) . ' ' . $sql_select . ' FROM ' . $sql_from . ' WHERE ' . $sql_where . $sql_group . $sql_order;
//SDI($sql);
$res = DBselect($sql, $sql_limit);
while ($host = DBfetch($res)) {
if (!is_null($options['countOutput'])) {
if (!is_null($options['groupCount'])) {
$result[] = $host;
} else {
$result = $host['rowscount'];
}
} else {
$hostids[$host['hostid']] = $host['hostid'];
if ($options['output'] == API_OUTPUT_SHORTEN) {
$result[$host['hostid']] = array('hostid' => $host['hostid']);
} else {
if (!isset($result[$host['hostid']])) {
$result[$host['hostid']] = array();
}
if (!is_null($options['select_groups']) && !isset($result[$host['hostid']]['groups'])) {
$result[$host['hostid']]['groups'] = array();
}
if (!is_null($options['selectParentTemplates']) && !isset($result[$host['hostid']]['parentTemplates'])) {
$result[$host['hostid']]['parentTemplates'] = array();
}
if (!is_null($options['select_items']) && !isset($result[$host['hostid']]['items'])) {
$result[$host['hostid']]['items'] = array();
}
if (!is_null($options['select_profile']) && !isset($result[$host['hostid']]['profile'])) {
$result[$host['hostid']]['profile'] = array();
$result[$host['hostid']]['profile_ext'] = array();
}
if (!is_null($options['select_triggers']) && !isset($result[$host['hostid']]['triggers'])) {
$result[$host['hostid']]['triggers'] = array();
}
if (!is_null($options['select_graphs']) && !isset($result[$host['hostid']]['graphs'])) {
$result[$host['hostid']]['graphs'] = array();
}
if (!is_null($options['select_dhosts']) && !isset($result[$host['hostid']]['dhosts'])) {
$result[$host['hostid']]['dhosts'] = array();
}
if (!is_null($options['select_dservices']) && !isset($result[$host['hostid']]['dservices'])) {
$result[$host['hostid']]['dservices'] = array();
}
if (!is_null($options['select_applications']) && !isset($result[$host['hostid']]['applications'])) {
$result[$host['hostid']]['applications'] = array();
}
if (!is_null($options['select_macros']) && !isset($result[$host['hostid']]['macros'])) {
$result[$host['hostid']]['macros'] = array();
}
// if(!is_null($options['select_maintenances']) && !isset($result[$host['hostid']]['maintenances'])){
// $result[$host['hostid']]['maintenances'] = array();
// }
// groupids
if (isset($host['groupid']) && is_null($options['select_groups'])) {
if (!isset($result[$host['hostid']]['groups'])) {
$result[$host['hostid']]['groups'] = array();
}
$result[$host['hostid']]['groups'][] = array('groupid' => $host['groupid']);
unset($host['groupid']);
}
// templateids
if (isset($host['templateid'])) {
if (!isset($result[$host['hostid']]['templates'])) {
$result[$host['hostid']]['templates'] = array();
}
$result[$host['hostid']]['templates'][] = array('templateid' => $host['templateid']);
unset($host['templateid']);
}
// triggerids
if (isset($host['triggerid']) && is_null($options['select_triggers'])) {
if (!isset($result[$host['hostid']]['triggers'])) {
$result[$host['hostid']]['triggers'] = array();
}
$result[$host['hostid']]['triggers'][] = array('triggerid' => $host['triggerid']);
unset($host['triggerid']);
}
// itemids
if (isset($host['itemid']) && is_null($options['select_items'])) {
if (!isset($result[$host['hostid']]['items'])) {
$result[$host['hostid']]['items'] = array();
}
$result[$host['hostid']]['items'][] = array('itemid' => $host['itemid']);
unset($host['itemid']);
}
// graphids
if (isset($host['graphid']) && is_null($options['select_graphs'])) {
if (!isset($result[$host['hostid']]['graphs'])) {
$result[$host['hostid']]['graphs'] = array();
}
$result[$host['hostid']]['graphs'][] = array('graphid' => $host['graphid']);
unset($host['graphid']);
}
// dhostids
if (isset($host['dhostid']) && is_null($options['select_dhosts'])) {
if (!isset($result[$host['hostid']]['dhosts'])) {
$result[$host['hostid']]['dhosts'] = array();
}
$result[$host['hostid']]['dhosts'][] = array('dhostid' => $host['dhostid']);
unset($host['dhostid']);
}
// dserviceids
if (isset($host['dserviceid']) && is_null($options['select_dservices'])) {
if (!isset($result[$host['hostid']]['dservices'])) {
$result[$host['hostid']]['dservices'] = array();
}
$result[$host['hostid']]['dservices'][] = array('dserviceid' => $host['dserviceid']);
unset($host['dserviceid']);
}
// maintenanceids
if (isset($host['maintenanceid'])) {
if (!isset($result[$host['hostid']]['maintenanceid'])) {
$result[$host['hostid']]['maintenances'] = array();
}
$result[$host['hostid']]['maintenances'][] = array('maintenanceid' => $host['maintenanceid']);
// unset($host['maintenanceid']);
}
//---
$result[$host['hostid']] += $host;
}
}
}
Copt::memoryPick();
if (!is_null($options['countOutput'])) {
if (is_null($options['preservekeys'])) {
$result = zbx_cleanHashes($result);
}
return $result;
}
// Adding Objects
// Adding Groups
if (!is_null($options['select_groups']) && str_in_array($options['select_groups'], $subselects_allowed_outputs)) {
$obj_params = array('nodeids' => $nodeids, 'output' => $options['select_groups'], 'hostids' => $hostids, 'preservekeys' => 1);
$groups = CHostgroup::get($obj_params);
foreach ($groups as $groupid => $group) {
$ghosts = $group['hosts'];
unset($group['hosts']);
foreach ($ghosts as $num => $host) {
$result[$host['hostid']]['groups'][] = $group;
}
}
}
// Adding Profiles
if (!is_null($options['select_profile'])) {
$sql = 'SELECT hp.* ' . ' FROM hosts_profiles hp ' . ' WHERE ' . DBcondition('hp.hostid', $hostids);
$db_profile = DBselect($sql);
while ($profile = DBfetch($db_profile)) {
$result[$profile['hostid']]['profile'] = $profile;
}
$sql = 'SELECT hpe.* ' . ' FROM hosts_profiles_ext hpe ' . ' WHERE ' . DBcondition('hpe.hostid', $hostids);
$db_profile_ext = DBselect($sql);
while ($profile_ext = DBfetch($db_profile_ext)) {
$result[$profile_ext['hostid']]['profile_ext'] = $profile_ext;
}
}
// Adding Templates
if (!is_null($options['selectParentTemplates'])) {
$obj_params = array('nodeids' => $nodeids, 'hostids' => $hostids, 'preservekeys' => 1);
if (is_array($options['selectParentTemplates']) || str_in_array($options['selectParentTemplates'], $subselects_allowed_outputs)) {
$obj_params['output'] = $options['selectParentTemplates'];
$templates = CTemplate::get($obj_params);
if (!is_null($options['limitSelects'])) {
order_result($templates, 'host');
}
foreach ($templates as $templateid => $template) {
unset($templates[$templateid]['hosts']);
$count = array();
foreach ($template['hosts'] as $hnum => $host) {
if (!is_null($options['limitSelects'])) {
if (!isset($count[$host['hostid']])) {
$count[$host['hostid']] = 0;
}
$count[$host['hostid']]++;
if ($count[$host['hostid']] > $options['limitSelects']) {
continue;
}
}
$result[$host['hostid']]['parentTemplates'][] =& $templates[$templateid];
}
}
} else {
if (API_OUTPUT_COUNT == $options['selectParentTemplates']) {
$obj_params['countOutput'] = 1;
$obj_params['groupCount'] = 1;
$templates = CTemplate::get($obj_params);
$templates = zbx_toHash($templates, 'hostid');
foreach ($result as $hostid => $host) {
if (isset($templates[$hostid])) {
$result[$hostid]['templates'] = $templates[$hostid]['rowscount'];
} else {
$result[$hostid]['templates'] = 0;
}
}
}
}
}
// Adding Items
if (!is_null($options['select_items'])) {
$obj_params = array('nodeids' => $nodeids, 'hostids' => $hostids, 'nopermissions' => 1, 'preservekeys' => 1);
if (is_array($options['select_items']) || str_in_array($options['select_items'], $subselects_allowed_outputs)) {
$obj_params['output'] = $options['select_items'];
$items = CItem::get($obj_params);
if (!is_null($options['limitSelects'])) {
order_result($items, 'description');
}
foreach ($items as $itemid => $item) {
unset($items[$itemid]['hosts']);
foreach ($item['hosts'] as $hnum => $host) {
if (!is_null($options['limitSelects'])) {
if (!isset($count[$host['hostid']])) {
$count[$host['hostid']] = 0;
}
$count[$host['hostid']]++;
if ($count[$host['hostid']] > $options['limitSelects']) {
continue;
}
}
$result[$host['hostid']]['items'][] =& $items[$itemid];
}
}
} else {
if (API_OUTPUT_COUNT == $options['select_items']) {
$obj_params['countOutput'] = 1;
$obj_params['groupCount'] = 1;
$items = CItem::get($obj_params);
$items = zbx_toHash($items, 'hostid');
foreach ($result as $hostid => $host) {
if (isset($items[$hostid])) {
$result[$hostid]['items'] = $items[$hostid]['rowscount'];
} else {
$result[$hostid]['items'] = 0;
}
}
}
}
}
// Adding triggers
if (!is_null($options['select_triggers'])) {
$obj_params = array('nodeids' => $nodeids, 'hostids' => $hostids, 'nopermissions' => 1, 'preservekeys' => 1);
if (is_array($options['select_triggers']) || str_in_array($options['select_triggers'], $subselects_allowed_outputs)) {
$obj_params['output'] = $options['select_triggers'];
$triggers = CTrigger::get($obj_params);
if (!is_null($options['limitSelects'])) {
order_result($triggers, 'description');
}
foreach ($triggers as $triggerid => $trigger) {
unset($triggers[$triggerid]['hosts']);
foreach ($trigger['hosts'] as $hnum => $host) {
if (!is_null($options['limitSelects'])) {
if (!isset($count[$host['hostid']])) {
$count[$host['hostid']] = 0;
}
$count[$host['hostid']]++;
if ($count[$host['hostid']] > $options['limitSelects']) {
continue;
}
}
$result[$host['hostid']]['triggers'][] =& $triggers[$triggerid];
}
}
} else {
if (API_OUTPUT_COUNT == $options['select_triggers']) {
$obj_params['countOutput'] = 1;
$obj_params['groupCount'] = 1;
$triggers = CTrigger::get($obj_params);
$triggers = zbx_toHash($triggers, 'hostid');
foreach ($result as $hostid => $host) {
if (isset($triggers[$hostid])) {
$result[$hostid]['triggers'] = $triggers[$hostid]['rowscount'];
} else {
$result[$hostid]['triggers'] = 0;
}
}
}
}
}
// Adding graphs
if (!is_null($options['select_graphs'])) {
$obj_params = array('nodeids' => $nodeids, 'hostids' => $hostids, 'nopermissions' => 1, 'preservekeys' => 1);
if (is_array($options['select_graphs']) || str_in_array($options['select_graphs'], $subselects_allowed_outputs)) {
$obj_params['output'] = $options['select_graphs'];
$graphs = CGraph::get($obj_params);
if (!is_null($options['limitSelects'])) {
order_result($graphs, 'name');
}
foreach ($graphs as $graphid => $graph) {
unset($graphs[$graphid]['hosts']);
foreach ($graph['hosts'] as $hnum => $host) {
if (!is_null($options['limitSelects'])) {
if (!isset($count[$host['hostid']])) {
$count[$host['hostid']] = 0;
}
$count[$host['hostid']]++;
if ($count[$host['hostid']] > $options['limitSelects']) {
continue;
}
}
$result[$host['hostid']]['graphs'][] =& $graphs[$graphid];
}
}
} else {
if (API_OUTPUT_COUNT == $options['select_graphs']) {
$obj_params['countOutput'] = 1;
$obj_params['groupCount'] = 1;
$graphs = CGraph::get($obj_params);
$graphs = zbx_toHash($graphs, 'hostid');
foreach ($result as $hostid => $host) {
if (isset($graphs[$hostid])) {
$result[$hostid]['graphs'] = $graphs[$hostid]['rowscount'];
} else {
$result[$hostid]['graphs'] = 0;
}
}
}
}
}
// Adding discovery hosts
if (!is_null($options['select_dhosts'])) {
$obj_params = array('nodeids' => $nodeids, 'hostids' => $hostids, 'nopermissions' => 1, 'preservekeys' => 1);
if (is_array($options['select_dhosts']) || str_in_array($options['select_dhosts'], $subselects_allowed_outputs)) {
$obj_params['output'] = $options['select_dhosts'];
$dhosts = CDHost::get($obj_params);
if (!is_null($options['limitSelects'])) {
order_result($dhosts, 'dhostid');
}
foreach ($dhosts as $dhostid => $dhost) {
unset($dhosts[$dhostid]['hosts']);
foreach ($dhost['hosts'] as $hnum => $host) {
if (!is_null($options['limitSelects'])) {
if (!isset($count[$host['hostid']])) {
$count[$host['hostid']] = 0;
}
$count[$host['hostid']]++;
if ($count[$host['hostid']] > $options['limitSelects']) {
continue;
}
}
$result[$host['hostid']]['dhosts'][] =& $dhosts[$dhostid];
}
}
} else {
if (API_OUTPUT_COUNT == $options['select_dhosts']) {
$obj_params['countOutput'] = 1;
$obj_params['groupCount'] = 1;
$dhosts = CDHost::get($obj_params);
$dhosts = zbx_toHash($dhosts, 'hostid');
foreach ($result as $hostid => $host) {
if (isset($dhosts[$hostid])) {
$result[$hostid]['dhosts'] = $dhosts[$hostid]['rowscount'];
} else {
$result[$hostid]['dhosts'] = 0;
}
}
}
}
}
// Adding applications
if (!is_null($options['select_applications'])) {
$obj_params = array('nodeids' => $nodeids, 'hostids' => $hostids, 'nopermissions' => 1, 'preservekeys' => 1);
if (is_array($options['select_applications']) || str_in_array($options['select_applications'], $subselects_allowed_outputs)) {
$obj_params['output'] = $options['select_applications'];
$applications = CApplication::get($obj_params);
if (!is_null($options['limitSelects'])) {
order_result($applications, 'name');
}
foreach ($applications as $applicationid => $application) {
unset($applications[$applicationid]['hosts']);
foreach ($application['hosts'] as $hnum => $host) {
if (!is_null($options['limitSelects'])) {
if (!isset($count[$host['hostid']])) {
$count[$host['hostid']] = 0;
}
$count[$host['hostid']]++;
if ($count[$host['hostid']] > $options['limitSelects']) {
continue;
}
}
$result[$host['hostid']]['applications'][] =& $applications[$applicationid];
}
}
} else {
if (API_OUTPUT_COUNT == $options['select_applications']) {
$obj_params['countOutput'] = 1;
$obj_params['groupCount'] = 1;
$applications = CApplication::get($obj_params);
$applications = zbx_toHash($applications, 'hostid');
foreach ($result as $hostid => $host) {
if (isset($applications[$hostid])) {
$result[$hostid]['applications'] = $applications[$hostid]['rowscount'];
} else {
$result[$hostid]['applications'] = 0;
}
}
}
}
}
// Adding macros
if (!is_null($options['select_macros']) && str_in_array($options['select_macros'], $subselects_allowed_outputs)) {
$obj_params = array('nodeids' => $nodeids, 'output' => $options['select_macros'], 'hostids' => $hostids, 'preservekeys' => 1);
$macros = CUserMacro::get($obj_params);
foreach ($macros as $macroid => $macro) {
$mhosts = $macro['hosts'];
unset($macro['hosts']);
foreach ($mhosts as $num => $host) {
$result[$host['hostid']]['macros'][] = $macro;
}
}
}
Copt::memoryPick();
// removing keys (hash -> array)
if (is_null($options['preservekeys'])) {
$result = zbx_cleanHashes($result);
}
return $result;
}
public static function get($options)
{
global $USER_DETAILS;
$result = array();
$nodeCheck = false;
$user_type = $USER_DETAILS['type'];
$sort_columns = array('dcheckid', 'druleid');
// allowed columns for sorting
$subselects_allowed_outputs = array(API_OUTPUT_REFER, API_OUTPUT_EXTEND, API_OUTPUT_CUSTOM);
// allowed output options for [ select_* ] params
$sql_parts = array('select' => array('dchecks' => 'dc.dcheckid'), 'from' => array('dchecks' => 'dchecks dc'), 'where' => array(), 'group' => array(), 'order' => array(), 'limit' => null);
$def_options = array('nodeids' => null, 'dcheckids' => null, 'druleids' => null, 'dhostids' => null, 'editable' => null, 'nopermissions' => null, 'filter' => null, 'search' => null, 'startSearch' => null, 'excludeSearch' => null, 'output' => API_OUTPUT_REFER, 'selectDRules' => null, 'selectDHosts' => null, 'countOutput' => null, 'groupCount' => null, 'preservekeys' => null, 'sortfield' => '', 'sortorder' => '', 'limit' => null, 'limitSelects' => null);
$options = zbx_array_merge($def_options, $options);
if (is_array($options['output'])) {
unset($sql_parts['select']['dchecks']);
foreach ($options['output'] as $key => $field) {
$sql_parts['select'][$field] = ' dc.' . $field;
}
$options['output'] = API_OUTPUT_CUSTOM;
}
// editable + PERMISSION CHECK
if (USER_TYPE_SUPER_ADMIN == $user_type) {
} else {
if (is_null($options['editable']) && $USER_DETAILS['type'] == USER_TYPE_ZABBIX_ADMIN) {
} else {
if (!is_null($options['editable']) && $USER_DETAILS['type'] != USER_TYPE_SUPER_ADMIN) {
return array();
}
}
}
// nodeids
$nodeids = !is_null($options['nodeids']) ? $options['nodeids'] : get_current_nodeid();
// dcheckids
if (!is_null($options['dcheckids'])) {
zbx_value2array($options['dcheckids']);
$sql_parts['where']['dcheckid'] = DBcondition('dc.dcheckid', $options['dcheckids']);
if (!$nodeCheck) {
$nodeCheck = true;
$sql_parts['where'][] = DBin_node('ds.dcheckid', $nodeids);
}
}
// druleids
if (!is_null($options['druleids'])) {
zbx_value2array($options['druleids']);
if ($options['output'] != API_OUTPUT_SHORTEN) {
$sql_parts['select']['druleid'] = 'dc.druleid';
}
$sql_parts['where'][] = DBcondition('dc.druleid', $options['druleids']);
if (!is_null($options['groupCount'])) {
$sql_parts['group']['druleid'] = 'dc.druleid';
}
if (!$nodeCheck) {
$nodeCheck = true;
$sql_parts['where'][] = DBin_node('dc.druleid', $nodeids);
}
}
// dhostids
if (!is_null($options['dhostids'])) {
zbx_value2array($options['dhostids']);
if ($options['output'] != API_OUTPUT_SHORTEN) {
$sql_parts['select']['dservices'] = 'dh.dhostid';
}
$sql_parts['from']['dhosts'] = 'dhosts dh';
$sql_parts['where']['dh'] = DBcondition('dh.dhostid', $options['dhostids']);
$sql_parts['where']['dcdh'] = 'dc.druleid=dh.druleid';
if (!is_null($options['groupCount'])) {
$sql_parts['group']['dhostid'] = 'dh.dhostid';
}
}
// dserviceids
if (!is_null($options['dserviceids'])) {
zbx_value2array($options['dserviceids']);
if ($options['output'] != API_OUTPUT_SHORTEN) {
$sql_parts['select']['dserviceid'] = 'ds.dserviceid';
}
$sql_parts['from']['dhosts'] = 'dhosts dh';
$sql_parts['from']['dservices'] = 'dservices ds';
$sql_parts['where']['ds'] = DBcondition('ds.dserviceid', $options['dserviceids']);
$sql_parts['where']['dcdh'] = 'dc.druleid=dh.druleid';
$sql_parts['where']['dhds'] = 'dh.hostid=ds.hostid';
if (!is_null($options['groupCount'])) {
$sql_parts['group']['dserviceid'] = 'ds.dserviceid';
}
}
// node check !!!!!
// should last, after all ****IDS checks
if (!$nodeCheck) {
$nodeCheck = true;
$sql_parts['where'][] = DBin_node('dc.dcheckid', $nodeids);
}
// output
if ($options['output'] == API_OUTPUT_EXTEND) {
$sql_parts['select']['dchecks'] = 'dc.*';
}
// countOutput
if (!is_null($options['countOutput'])) {
$options['sortfield'] = '';
$sql_parts['select'] = array('count(DISTINCT dc.dcheckid) as rowscount');
//groupCount
if (!is_null($options['groupCount'])) {
foreach ($sql_parts['group'] as $key => $fields) {
$sql_parts['select'][$key] = $fields;
}
}
}
// filter
if (is_array($options['filter'])) {
zbx_db_filter('dchecks dc', $options, $sql_parts);
}
// search
if (is_array($options['search'])) {
zbx_db_search('dchecks dc', $options, $sql_parts);
}
// order
// restrict not allowed columns for sorting
$options['sortfield'] = str_in_array($options['sortfield'], $sort_columns) ? $options['sortfield'] : '';
if (!zbx_empty($options['sortfield'])) {
$sortorder = $options['sortorder'] == ZBX_SORT_DOWN ? ZBX_SORT_DOWN : ZBX_SORT_UP;
$sql_parts['order'][$options['sortfield']] = 'dc.' . $options['sortfield'] . ' ' . $sortorder;
if (!str_in_array('dc.' . $options['sortfield'], $sql_parts['select']) && !str_in_array('dc.*', $sql_parts['select'])) {
$sql_parts['select'][$options['sortfield']] = 'dc.' . $options['sortfield'];
}
}
// limit
if (zbx_ctype_digit($options['limit']) && $options['limit']) {
$sql_parts['limit'] = $options['limit'];
}
//-------
$sql_parts['select'] = array_unique($sql_parts['select']);
$sql_parts['from'] = array_unique($sql_parts['from']);
$sql_parts['where'] = array_unique($sql_parts['where']);
$sql_parts['group'] = array_unique($sql_parts['group']);
$sql_parts['order'] = array_unique($sql_parts['order']);
$sql_select = '';
$sql_from = '';
$sql_where = '';
$sql_group = '';
$sql_order = '';
if (!empty($sql_parts['select'])) {
$sql_select .= implode(',', $sql_parts['select']);
}
if (!empty($sql_parts['from'])) {
$sql_from .= implode(',', $sql_parts['from']);
}
if (!empty($sql_parts['where'])) {
$sql_where .= implode(' AND ', $sql_parts['where']);
}
if (!empty($sql_parts['group'])) {
$sql_where .= ' GROUP BY ' . implode(',', $sql_parts['group']);
}
if (!empty($sql_parts['order'])) {
$sql_order .= ' ORDER BY ' . implode(',', $sql_parts['order']);
}
$sql_limit = $sql_parts['limit'];
$sql = 'SELECT ' . zbx_db_distinct($sql_parts) . ' ' . $sql_select . ' FROM ' . $sql_from . ' WHERE ' . $sql_where . $sql_group . $sql_order;
//SDI($sql);
$res = DBselect($sql, $sql_limit);
while ($dcheck = DBfetch($res)) {
if (!is_null($options['countOutput'])) {
if (!is_null($options['groupCount'])) {
$result[] = $dcheck;
} else {
$result = $dcheck['rowscount'];
}
} else {
$dcheckids[$dcheck['dcheckid']] = $dcheck['dcheckid'];
if ($options['output'] == API_OUTPUT_SHORTEN) {
$result[$dcheck['dcheckid']] = array('dcheckid' => $dcheck['dcheckid']);
} else {
if (!isset($result[$dcheck['dcheckid']])) {
$result[$dcheck['dcheckid']] = array();
}
if (!is_null($options['selectDRules']) && !isset($result[$dcheck['dcheckid']]['drules'])) {
$result[$dcheck['dcheckid']]['drules'] = array();
}
if (!is_null($options['selectDHosts']) && !isset($result[$dcheck['dcheckid']]['dhosts'])) {
$result[$dcheck['dcheckid']]['dhosts'] = array();
}
if (!is_null($options['selectHosts']) && !isset($result[$dcheck['dcheckid']]['hosts'])) {
$result[$dcheck['dcheckid']]['hosts'] = array();
}
// druleids
if (isset($dcheck['druleid']) && is_null($options['selectDRules'])) {
if (!isset($result[$dcheck['dcheckid']]['drules'])) {
$result[$dcheck['dcheckid']]['drules'] = array();
}
$result[$dcheck['dcheckid']]['drules'][] = array('druleid' => $dcheck['druleid']);
}
// dhostids
if (isset($dcheck['dhostid']) && is_null($options['selectDHosts'])) {
if (!isset($result[$dcheck['dcheckid']]['dhosts'])) {
$result[$dcheck['dcheckid']]['dhosts'] = array();
}
$result[$dcheck['dcheckid']]['dhosts'][] = array('dhostid' => $dcheck['dhostid']);
}
$result[$dcheck['dcheckid']] += $dcheck;
}
}
}
Copt::memoryPick();
if (!is_null($options['countOutput'])) {
if (is_null($options['preservekeys'])) {
$result = zbx_cleanHashes($result);
}
return $result;
}
// Adding Objects
// select_drules
if (!is_null($options['selectDRules'])) {
$obj_params = array('nodeids' => $nodeids, 'dcheckids' => $dcheckids, 'preservekeys' => 1);
if (is_array($options['selectDRules']) || str_in_array($options['selectDRules'], $subselects_allowed_outputs)) {
$obj_params['output'] = $options['selectDRules'];
$drules = CDRule::get($obj_params);
if (!is_null($options['limitSelects'])) {
order_result($drules, 'name');
}
foreach ($drules as $druleid => $drule) {
unset($drules[$druleid]['dchecks']);
$count = array();
foreach ($drule['dchecks'] as $dnum => $dcheck) {
if (!is_null($options['limitSelects'])) {
if (!isset($count[$dcheck['dcheckid']])) {
$count[$dcheck['dcheckid']] = 0;
}
$count[$dcheck['dcheckid']]++;
if ($count[$dcheck['dcheckid']] > $options['limitSelects']) {
continue;
}
}
$result[$dcheck['dcheckid']]['drules'][] =& $drules[$druleid];
}
}
} else {
if (API_OUTPUT_COUNT == $options['selectDRules']) {
$obj_params['countOutput'] = 1;
$obj_params['groupCount'] = 1;
$drules = CDRule::get($obj_params);
$drules = zbx_toHash($drules, 'dcheckid');
foreach ($result as $dcheckid => $dcheck) {
if (isset($drules[$dcheckid])) {
$result[$dcheckid]['drules'] = $drules[$dcheckid]['rowscount'];
} else {
$result[$dcheckid]['drules'] = 0;
}
}
}
}
}
// selectDHosts
if (!is_null($options['selectDHosts'])) {
$obj_params = array('nodeids' => $nodeids, 'dcheckids' => $dcheckids, 'preservekeys' => 1);
if (is_array($options['selectDHosts']) || str_in_array($options['selectDHosts'], $subselects_allowed_outputs)) {
$obj_params['output'] = $options['selectDHosts'];
$dhosts = CDHost::get($obj_params);
if (!is_null($options['limitSelects'])) {
order_result($dhosts, 'dhostid');
}
foreach ($dhosts as $dhostid => $dhost) {
unset($dhosts[$dhostid]['dchecks']);
foreach ($dhost['dchecks'] as $snum => $dcheck) {
if (!is_null($options['limitSelects'])) {
if (!isset($count[$dcheck['dcheckid']])) {
$count[$dcheck['dcheckid']] = 0;
}
$count[$dcheck['dcheckid']]++;
if ($count[$dcheck['dcheckid']] > $options['limitSelects']) {
continue;
}
}
$result[$dcheck['dcheckid']]['dhosts'][] =& $dhosts[$dhostid];
}
}
} else {
if (API_OUTPUT_COUNT == $options['selectDHosts']) {
$obj_params['countOutput'] = 1;
$obj_params['groupCount'] = 1;
$dhosts = CDHost::get($obj_params);
$dhosts = zbx_toHash($dhosts, 'dhostid');
foreach ($result as $dcheckid => $dcheck) {
if (isset($dhosts[$dcheckid])) {
$result[$dcheckid]['dhosts'] = $dhosts[$dcheckid]['rowscount'];
} else {
$result[$dcheckid]['dhosts'] = 0;
}
}
}
}
}
// select_hosts
if (!is_null($options['selectHosts'])) {
$obj_params = array('nodeids' => $nodeids, 'dcheckids' => $dcheckids, 'preservekeys' => 1, 'sortfield' => 'status');
if (is_array($options['selectHosts']) || str_in_array($options['selectHosts'], $subselects_allowed_outputs)) {
$obj_params['output'] = $options['selectHosts'];
$hosts = CHost::get($obj_params);
if (!is_null($options['limitSelects'])) {
order_result($hosts, 'hostid');
}
foreach ($hosts as $hostid => $host) {
unset($hosts[$hostid]['dchecks']);
foreach ($host['dchecks'] as $dnum => $dcheck) {
if (!is_null($options['limitSelects'])) {
if (!isset($count[$dcheck['dcheckid']])) {
$count[$dcheck['dcheckid']] = 0;
}
$count[$dcheck['dcheckid']]++;
if ($count[$dcheck['dcheckid']] > $options['limitSelects']) {
continue;
}
}
$result[$dcheck['dcheckid']]['hosts'][] =& $hosts[$hostid];
}
}
} else {
if (API_OUTPUT_COUNT == $options['selectHosts']) {
$obj_params['countOutput'] = 1;
$obj_params['groupCount'] = 1;
$hosts = CHost::get($obj_params);
$hosts = zbx_toHash($hosts, 'hostid');
foreach ($result as $dcheckid => $dcheck) {
if (isset($hosts[$dcheckid])) {
$result[$dcheckid]['hosts'] = $hosts[$dcheckid]['rowscount'];
} else {
$result[$dcheckid]['hosts'] = 0;
}
}
}
}
}
Copt::memoryPick();
// removing keys (hash -> array)
if (is_null($options['preservekeys'])) {
$result = zbx_cleanHashes($result);
}
return $result;
}