protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
$userIds = zbx_objectValues($result, 'userid');
// adding usergroups
if ($options['selectUsrgrps'] !== null && $options['selectUsrgrps'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'userid', 'usrgrpid', 'users_groups');
$dbUserGroups = API::UserGroup()->get(array('output' => $options['selectUsrgrps'], 'usrgrpids' => $relationMap->getRelatedIds(), 'preservekeys' => true));
$result = $relationMap->mapMany($result, $dbUserGroups, 'usrgrps');
}
// adding medias
if ($options['selectMedias'] !== null && $options['selectMedias'] != API_OUTPUT_COUNT) {
$userMedias = API::UserMedia()->get(array('output' => $this->outputExtend($options['selectMedias'], array('userid', 'mediaid')), 'userids' => $userIds, 'preservekeys' => true));
$relationMap = $this->createRelationMap($userMedias, 'userid', 'mediaid');
$userMedias = $this->unsetExtraFields($userMedias, array('userid', 'mediaid'), $options['selectMedias']);
$result = $relationMap->mapMany($result, $userMedias, 'medias');
}
// adding media types
if ($options['selectMediatypes'] !== null && $options['selectMediatypes'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'userid', 'mediatypeid', 'media');
$mediaTypes = API::Mediatype()->get(array('output' => $options['selectMediatypes'], 'mediatypeids' => $relationMap->getRelatedIds(), 'preservekeys' => true));
$result = $relationMap->mapMany($result, $mediaTypes, 'mediatypes');
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
$proxyIds = array_keys($result);
// selectHosts
if ($options['selectHosts'] !== null && $options['selectHosts'] != API_OUTPUT_COUNT) {
$hosts = API::Host()->get(array('output' => $this->outputExtend($options['selectHosts'], array('hostid', 'proxy_hostid')), 'proxyids' => $proxyIds, 'preservekeys' => true));
$relationMap = $this->createRelationMap($hosts, 'proxy_hostid', 'hostid');
$hosts = $this->unsetExtraFields($hosts, array('proxy_hostid', 'hostid'), $options['selectHosts']);
$result = $relationMap->mapMany($result, $hosts, 'hosts');
}
// adding host interface
if ($options['selectInterface'] !== null && $options['selectInterface'] != API_OUTPUT_COUNT) {
$interfaces = API::HostInterface()->get(array('output' => $this->outputExtend($options['selectInterface'], array('interfaceid', 'hostid')), 'hostids' => $proxyIds, 'nopermissions' => true, 'preservekeys' => true));
$relationMap = $this->createRelationMap($interfaces, 'hostid', 'interfaceid');
$interfaces = $this->unsetExtraFields($interfaces, array('hostid', 'interfaceid'), $options['selectInterface']);
$result = $relationMap->mapOne($result, $interfaces, 'interface');
foreach ($result as $key => $proxy) {
if (!empty($proxy['interface'])) {
$result[$key]['interface'] = $proxy['interface'];
}
}
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
// select_drules
if ($options['selectDRules'] !== null && $options['selectDRules'] !== API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'dcheckid', 'druleid');
$drules = API::DRule()->get(array('output' => $options['selectDRules'], 'druleids' => $relationMap->getRelatedIds(), 'preservekeys' => true));
if (!is_null($options['limitSelects'])) {
order_result($drules, 'name');
}
$result = $relationMap->mapMany($result, $drules, 'drules', $options['limitSelects']);
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
// adding graphs
if ($options['selectGraphs'] !== null) {
$relationMap = $this->createRelationMap($result, 'gitemid', 'graphid');
$graphs = API::Graph()->get(['output' => $options['selectGraphs'], 'gitemids' => $relationMap->getRelatedIds(), 'preservekeys' => true]);
$result = $relationMap->mapMany($result, $graphs, 'graphs');
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
$triggerids = array_keys($result);
// adding groups
if ($options['selectGroups'] !== null && $options['selectGroups'] != API_OUTPUT_COUNT) {
$res = DBselect('SELECT f.triggerid,hg.groupid' . ' FROM functions f,items i,hosts_groups hg' . ' WHERE ' . dbConditionInt('f.triggerid', $triggerids) . ' AND f.itemid=i.itemid' . ' AND i.hostid=hg.hostid');
$relationMap = new CRelationMap();
while ($relation = DBfetch($res)) {
$relationMap->addRelation($relation['triggerid'], $relation['groupid']);
}
$groups = API::HostGroup()->get(array('output' => $options['selectGroups'], 'groupids' => $relationMap->getRelatedIds(), 'preservekeys' => true));
$result = $relationMap->mapMany($result, $groups, 'groups');
}
// adding hosts
if ($options['selectHosts'] !== null && $options['selectHosts'] != API_OUTPUT_COUNT) {
$res = DBselect('SELECT f.triggerid,i.hostid' . ' FROM functions f,items i' . ' WHERE ' . dbConditionInt('f.triggerid', $triggerids) . ' AND f.itemid=i.itemid');
$relationMap = new CRelationMap();
while ($relation = DBfetch($res)) {
$relationMap->addRelation($relation['triggerid'], $relation['hostid']);
}
$hosts = API::Host()->get(array('output' => $options['selectHosts'], 'hostids' => $relationMap->getRelatedIds(), 'templated_hosts' => true, 'nopermissions' => true, 'preservekeys' => true));
if (!is_null($options['limitSelects'])) {
order_result($hosts, 'host');
}
$result = $relationMap->mapMany($result, $hosts, 'hosts', $options['limitSelects']);
}
// adding functions
if ($options['selectFunctions'] !== null && $options['selectFunctions'] != API_OUTPUT_COUNT) {
$functions = API::getApiService()->select('functions', array('output' => $this->outputExtend($options['selectFunctions'], array('triggerid', 'functionid')), 'filter' => array('triggerid' => $triggerids), 'preservekeys' => true));
$relationMap = $this->createRelationMap($functions, 'triggerid', 'functionid');
$functions = $this->unsetExtraFields($functions, array('triggerid', 'functionid'), $options['selectFunctions']);
$result = $relationMap->mapMany($result, $functions, 'functions');
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
$eventIds = array_keys($result);
// adding hosts
if ($options['selectHosts'] !== null && $options['selectHosts'] != API_OUTPUT_COUNT) {
// trigger events
if ($options['object'] == EVENT_OBJECT_TRIGGER) {
$query = DBselect('SELECT e.eventid,i.hostid' . ' FROM events e,functions f,items i' . ' WHERE ' . dbConditionInt('e.eventid', $eventIds) . ' AND e.objectid=f.triggerid' . ' AND f.itemid=i.itemid' . ' AND e.object=' . zbx_dbstr($options['object']) . ' AND e.source=' . zbx_dbstr($options['source']));
} elseif ($options['object'] == EVENT_OBJECT_ITEM || $options['object'] == EVENT_OBJECT_LLDRULE) {
$query = DBselect('SELECT e.eventid,i.hostid' . ' FROM events e,items i' . ' WHERE ' . dbConditionInt('e.eventid', $eventIds) . ' AND e.objectid=i.itemid' . ' AND e.object=' . zbx_dbstr($options['object']) . ' AND e.source=' . zbx_dbstr($options['source']));
}
$relationMap = new CRelationMap();
while ($relation = DBfetch($query)) {
$relationMap->addRelation($relation['eventid'], $relation['hostid']);
}
$hosts = API::Host()->get(array('output' => $options['selectHosts'], 'hostids' => $relationMap->getRelatedIds(), 'nopermissions' => true, 'preservekeys' => true));
$result = $relationMap->mapMany($result, $hosts, 'hosts');
}
// adding the related object
if ($options['selectRelatedObject'] !== null && $options['selectRelatedObject'] != API_OUTPUT_COUNT && $options['object'] != EVENT_OBJECT_AUTOREGHOST) {
$relationMap = new CRelationMap();
foreach ($result as $event) {
$relationMap->addRelation($event['eventid'], $event['objectid']);
}
switch ($options['object']) {
case EVENT_OBJECT_TRIGGER:
$api = API::Trigger();
break;
case EVENT_OBJECT_DHOST:
$api = API::DHost();
break;
case EVENT_OBJECT_DSERVICE:
$api = API::DService();
break;
case EVENT_OBJECT_ITEM:
$api = API::Item();
break;
case EVENT_OBJECT_LLDRULE:
$api = API::DiscoveryRule();
break;
}
$objects = $api->get(array('output' => $options['selectRelatedObject'], $api->pkOption() => $relationMap->getRelatedIds(), 'nopermissions' => true, 'preservekeys' => true));
$result = $relationMap->mapOne($result, $objects, 'relatedObject');
}
// adding alerts
if ($options['select_alerts'] !== null && $options['select_alerts'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'eventid', 'alertid', 'alerts');
$alerts = API::Alert()->get(array('output' => $options['select_alerts'], 'selectMediatypes' => API_OUTPUT_EXTEND, 'alertids' => $relationMap->getRelatedIds(), 'nopermissions' => true, 'preservekeys' => true, 'sortfield' => 'clock', 'sortorder' => ZBX_SORT_DOWN));
$result = $relationMap->mapMany($result, $alerts, 'alerts');
}
// adding acknowledges
if ($options['select_acknowledges'] !== null) {
if ($options['select_acknowledges'] != API_OUTPUT_COUNT) {
// create the base query
$sqlParts = API::getApiService()->createSelectQueryParts('acknowledges', 'a', array('output' => $this->outputExtend($options['select_acknowledges'], array('acknowledgeid', 'eventid', 'clock')), 'filter' => array('eventid' => $eventIds)));
$sqlParts['order'][] = 'a.clock DESC';
// if the user data is requested via extended output or specified fields, join the users table
$userFields = array('alias', 'name', 'surname');
$requestUserData = array();
foreach ($userFields as $userField) {
if ($this->outputIsRequested($userField, $options['select_acknowledges'])) {
$requestUserData[] = $userField;
}
}
if ($requestUserData) {
foreach ($requestUserData as $userField) {
$sqlParts = $this->addQuerySelect('u.' . $userField, $sqlParts);
}
$sqlParts['from'][] = 'users u';
$sqlParts['where'][] = 'a.userid=u.userid';
}
$acknowledges = DBFetchArrayAssoc(DBselect($this->createSelectQueryFromParts($sqlParts)), 'acknowledgeid');
$relationMap = $this->createRelationMap($acknowledges, 'eventid', 'acknowledgeid');
$acknowledges = $this->unsetExtraFields($acknowledges, array('eventid', 'acknowledgeid', 'clock'), $options['select_acknowledges']);
$result = $relationMap->mapMany($result, $acknowledges, 'acknowledges');
} else {
$acknowledges = DBFetchArrayAssoc(DBselect('SELECT COUNT(a.acknowledgeid) AS rowscount,a.eventid' . ' FROM acknowledges a' . ' WHERE ' . dbConditionInt('a.eventid', $eventIds) . ' GROUP BY a.eventid'), 'eventid');
foreach ($result as &$event) {
if (isset($acknowledges[$event['eventid']])) {
$event['acknowledges'] = $acknowledges[$event['eventid']]['rowscount'];
} else {
$event['acknowledges'] = 0;
}
}
unset($event);
}
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
$interfaceIds = array_keys($result);
// adding hosts
if ($options['selectHosts'] !== null && $options['selectHosts'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'interfaceid', 'hostid');
$hosts = API::Host()->get(['output' => $options['selectHosts'], 'hosts' => $relationMap->getRelatedIds(), 'preservekeys' => true]);
$result = $relationMap->mapMany($result, $hosts, 'hosts');
}
// adding items
if ($options['selectItems'] !== null) {
if ($options['selectItems'] != API_OUTPUT_COUNT) {
$items = API::Item()->get(['output' => $this->outputExtend($options['selectItems'], ['itemid', 'interfaceid']), 'interfaceids' => $interfaceIds, 'nopermissions' => true, 'preservekeys' => true, 'filter' => ['flags' => null]]);
$relationMap = $this->createRelationMap($items, 'interfaceid', 'itemid');
$items = $this->unsetExtraFields($items, ['interfaceid', 'itemid'], $options['selectItems']);
$result = $relationMap->mapMany($result, $items, 'items', $options['limitSelects']);
} else {
$items = API::Item()->get(['interfaceids' => $interfaceIds, 'nopermissions' => true, 'filter' => ['flags' => null], 'countOutput' => true, 'groupCount' => true]);
$items = zbx_toHash($items, 'interfaceid');
foreach ($result as $interfaceId => $interface) {
$result[$interfaceId]['items'] = isset($items[$interfaceId]) ? $items[$interfaceId]['rowscount'] : 0;
}
}
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
$iconMapIds = array_keys($result);
if ($options['selectMappings'] !== null && $options['selectMappings'] != API_OUTPUT_COUNT) {
$mappings = API::getApiService()->select('icon_mapping', ['output' => $this->outputExtend($options['selectMappings'], ['iconmapid', 'iconmappingid']), 'filter' => ['iconmapid' => $iconMapIds], 'preservekeys' => true]);
$relationMap = $this->createRelationMap($mappings, 'iconmapid', 'iconmappingid');
$mappings = $this->unsetExtraFields($mappings, ['iconmapid', 'iconmappingid'], $options['selectMappings']);
$result = $relationMap->mapMany($result, $mappings, 'mappings');
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
$actionIds = array_keys($result);
// adding formulas
if ($options['selectFilter'] !== null) {
$formulaRequested = $this->outputIsRequested('formula', $options['selectFilter']);
$evalFormulaRequested = $this->outputIsRequested('eval_formula', $options['selectFilter']);
$conditionsRequested = $this->outputIsRequested('conditions', $options['selectFilter']);
$filters = array();
foreach ($result as $action) {
$filters[$action['actionid']] = array('evaltype' => $action['evaltype'], 'formula' => isset($action['formula']) ? $action['formula'] : '');
}
if ($formulaRequested || $evalFormulaRequested || $conditionsRequested) {
$conditions = API::getApiService()->select('conditions', array('output' => array('actionid', 'conditionid', 'conditiontype', 'operator', 'value'), 'filter' => array('actionid' => $actionIds), 'preservekeys' => true));
$relationMap = $this->createRelationMap($conditions, 'actionid', 'conditionid');
$filters = $relationMap->mapMany($filters, $conditions, 'conditions');
foreach ($filters as &$filter) {
// in case of a custom expression - use the given formula
if ($filter['evaltype'] == CONDITION_EVAL_TYPE_EXPRESSION) {
$formula = $filter['formula'];
} else {
$conditions = $filter['conditions'];
// sort conditions
$sortFields = array(array('field' => 'conditiontype', 'order' => ZBX_SORT_DOWN), array('field' => 'operator', 'order' => ZBX_SORT_DOWN), array('field' => 'value', 'order' => ZBX_SORT_DOWN));
CArrayHelper::sort($conditions, $sortFields);
$conditionsForFormula = array();
foreach ($conditions as $condition) {
$conditionsForFormula[$condition['conditionid']] = $condition['conditiontype'];
}
$formula = CConditionHelper::getFormula($conditionsForFormula, $filter['evaltype']);
}
// generate formulaids from the effective formula
$formulaIds = CConditionHelper::getFormulaIds($formula);
foreach ($filter['conditions'] as &$condition) {
$condition['formulaid'] = $formulaIds[$condition['conditionid']];
}
unset($condition);
// generated a letter based formula only for actions with custom expressions
if ($formulaRequested && $filter['evaltype'] == CONDITION_EVAL_TYPE_EXPRESSION) {
$filter['formula'] = CConditionHelper::replaceNumericIds($formula, $formulaIds);
}
if ($evalFormulaRequested) {
$filter['eval_formula'] = CConditionHelper::replaceNumericIds($formula, $formulaIds);
}
}
unset($filter);
}
// add filters to the result
foreach ($result as &$action) {
$action['filter'] = $filters[$action['actionid']];
}
unset($action);
}
// adding operations
if ($options['selectOperations'] !== null && $options['selectOperations'] != API_OUTPUT_COUNT) {
$operations = API::getApiService()->select('operations', array('output' => $this->outputExtend($options['selectOperations'], array('operationid', 'actionid', 'operationtype')), 'filter' => array('actionid' => $actionIds), 'preservekeys' => true));
$relationMap = $this->createRelationMap($operations, 'actionid', 'operationid');
$operationIds = $relationMap->getRelatedIds();
if ($this->outputIsRequested('opconditions', $options['selectOperations'])) {
foreach ($operations as &$operation) {
$operation['opconditions'] = array();
}
unset($operation);
$res = DBselect('SELECT op.* FROM opconditions op WHERE ' . dbConditionInt('op.operationid', $operationIds));
while ($opcondition = DBfetch($res)) {
$operations[$opcondition['operationid']]['opconditions'][] = $opcondition;
}
}
$opmessage = $opcommand = $opgroup = $optemplate = array();
foreach ($operations as $operationid => $operation) {
switch ($operation['operationtype']) {
case OPERATION_TYPE_MESSAGE:
$opmessage[] = $operationid;
break;
case OPERATION_TYPE_COMMAND:
$opcommand[] = $operationid;
break;
case OPERATION_TYPE_GROUP_ADD:
case OPERATION_TYPE_GROUP_REMOVE:
$opgroup[] = $operationid;
break;
case OPERATION_TYPE_TEMPLATE_ADD:
case OPERATION_TYPE_TEMPLATE_REMOVE:
$optemplate[] = $operationid;
break;
case OPERATION_TYPE_HOST_ADD:
case OPERATION_TYPE_HOST_REMOVE:
case OPERATION_TYPE_HOST_ENABLE:
case OPERATION_TYPE_HOST_DISABLE:
}
}
// get OPERATION_TYPE_MESSAGE data
if (!empty($opmessage)) {
if ($this->outputIsRequested('opmessage', $options['selectOperations'])) {
foreach ($opmessage as $operationId) {
$operations[$operationId]['opmessage'] = array();
}
$dbOpmessages = DBselect('SELECT o.operationid,o.default_msg,o.subject,o.message,o.mediatypeid' . ' FROM opmessage o' . ' WHERE ' . dbConditionInt('operationid', $opmessage));
while ($dbOpmessage = DBfetch($dbOpmessages)) {
$operations[$dbOpmessage['operationid']]['opmessage'] = $dbOpmessage;
}
}
if ($this->outputIsRequested('opmessage_grp', $options['selectOperations'])) {
foreach ($opmessage as $operationId) {
$operations[$operationId]['opmessage_grp'] = array();
}
$dbOpmessageGrp = DBselect('SELECT og.operationid,og.usrgrpid' . ' FROM opmessage_grp og' . ' WHERE ' . dbConditionInt('operationid', $opmessage));
while ($opmessageGrp = DBfetch($dbOpmessageGrp)) {
$operations[$opmessageGrp['operationid']]['opmessage_grp'][] = $opmessageGrp;
}
}
if ($this->outputIsRequested('opmessage_usr', $options['selectOperations'])) {
foreach ($opmessage as $operationId) {
$operations[$operationId]['opmessage_usr'] = array();
}
$dbOpmessageUsr = DBselect('SELECT ou.operationid,ou.userid' . ' FROM opmessage_usr ou' . ' WHERE ' . dbConditionInt('operationid', $opmessage));
while ($opmessageUsr = DBfetch($dbOpmessageUsr)) {
$operations[$opmessageUsr['operationid']]['opmessage_usr'][] = $opmessageUsr;
}
}
}
// get OPERATION_TYPE_COMMAND data
if (!empty($opcommand)) {
if ($this->outputIsRequested('opcommand', $options['selectOperations'])) {
foreach ($opcommand as $operationId) {
$operations[$operationId]['opcommand'] = array();
}
$dbOpcommands = DBselect('SELECT o.*' . ' FROM opcommand o' . ' WHERE ' . dbConditionInt('operationid', $opcommand));
while ($dbOpcommand = DBfetch($dbOpcommands)) {
$operations[$dbOpcommand['operationid']]['opcommand'] = $dbOpcommand;
}
}
if ($this->outputIsRequested('opcommand_hst', $options['selectOperations'])) {
foreach ($opcommand as $operationId) {
$operations[$operationId]['opcommand_hst'] = array();
}
$dbOpcommandHst = DBselect('SELECT oh.opcommand_hstid,oh.operationid,oh.hostid' . ' FROM opcommand_hst oh' . ' WHERE ' . dbConditionInt('operationid', $opcommand));
while ($opcommandHst = DBfetch($dbOpcommandHst)) {
$operations[$opcommandHst['operationid']]['opcommand_hst'][] = $opcommandHst;
}
}
if ($this->outputIsRequested('opcommand_grp', $options['selectOperations'])) {
foreach ($opcommand as $operationId) {
$operations[$operationId]['opcommand_grp'] = array();
}
$dbOpcommandGrp = DBselect('SELECT og.opcommand_grpid,og.operationid,og.groupid' . ' FROM opcommand_grp og' . ' WHERE ' . dbConditionInt('operationid', $opcommand));
while ($opcommandGrp = DBfetch($dbOpcommandGrp)) {
$operations[$opcommandGrp['operationid']]['opcommand_grp'][] = $opcommandGrp;
}
}
}
// get OPERATION_TYPE_GROUP_ADD, OPERATION_TYPE_GROUP_REMOVE data
if (!empty($opgroup)) {
if ($this->outputIsRequested('opgroup', $options['selectOperations'])) {
foreach ($opgroup as $operationId) {
$operations[$operationId]['opgroup'] = array();
}
$dbOpgroup = DBselect('SELECT o.operationid,o.groupid' . ' FROM opgroup o' . ' WHERE ' . dbConditionInt('operationid', $opgroup));
while ($opgroup = DBfetch($dbOpgroup)) {
$operations[$opgroup['operationid']]['opgroup'][] = $opgroup;
}
}
}
// get OPERATION_TYPE_TEMPLATE_ADD, OPERATION_TYPE_TEMPLATE_REMOVE data
if (!empty($optemplate)) {
if ($this->outputIsRequested('optemplate', $options['selectOperations'])) {
foreach ($optemplate as $operationId) {
$operations[$operationId]['optemplate'] = array();
}
$dbOptemplate = DBselect('SELECT o.operationid,o.templateid' . ' FROM optemplate o' . ' WHERE ' . dbConditionInt('operationid', $optemplate));
while ($optemplate = DBfetch($dbOptemplate)) {
$operations[$optemplate['operationid']]['optemplate'][] = $optemplate;
}
}
}
$operations = $this->unsetExtraFields($operations, array('operationid', 'actionid', 'operationtype'), $options['selectOperations']);
$result = $relationMap->mapMany($result, $operations, 'operations');
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
$graphids = array_keys($result);
// adding GraphItems
if ($options['selectGraphItems'] !== null && $options['selectGraphItems'] !== API_OUTPUT_COUNT) {
$gitems = API::GraphItem()->get(array('output' => $this->outputExtend($options['selectGraphItems'], array('graphid', 'gitemid')), 'graphids' => $graphids, 'nopermissions' => true, 'preservekeys' => true));
$relationMap = $this->createRelationMap($gitems, 'graphid', 'gitemid');
$gitems = $this->unsetExtraFields($gitems, array('graphid', 'gitemid'), $options['selectGraphItems']);
$result = $relationMap->mapMany($result, $gitems, 'gitems');
}
// adding HostGroups
if ($options['selectGroups'] !== null && $options['selectGroups'] !== API_OUTPUT_COUNT) {
$relationMap = new CRelationMap();
// discovered items
$dbRules = DBselect('SELECT gi.graphid,hg.groupid' . ' FROM graphs_items gi,items i,hosts_groups hg' . ' WHERE ' . dbConditionInt('gi.graphid', $graphids) . ' AND gi.itemid=i.itemid' . ' AND i.hostid=hg.hostid');
while ($relation = DBfetch($dbRules)) {
$relationMap->addRelation($relation['graphid'], $relation['groupid']);
}
$groups = API::HostGroup()->get(array('output' => $options['selectGroups'], 'groupids' => $relationMap->getRelatedIds(), 'nopermissions' => true, 'preservekeys' => true));
$result = $relationMap->mapMany($result, $groups, 'groups');
}
// adding Hosts
if ($options['selectHosts'] !== null && $options['selectHosts'] !== API_OUTPUT_COUNT) {
$relationMap = new CRelationMap();
// discovered items
$dbRules = DBselect('SELECT gi.graphid,i.hostid' . ' FROM graphs_items gi,items i' . ' WHERE ' . dbConditionInt('gi.graphid', $graphids) . ' AND gi.itemid=i.itemid');
while ($relation = DBfetch($dbRules)) {
$relationMap->addRelation($relation['graphid'], $relation['hostid']);
}
$hosts = API::Host()->get(array('output' => $options['selectHosts'], 'hostids' => $relationMap->getRelatedIds(), 'templated_hosts' => true, 'nopermissions' => true, 'preservekeys' => true));
$result = $relationMap->mapMany($result, $hosts, 'hosts');
}
// adding Templates
if ($options['selectTemplates'] !== null && $options['selectTemplates'] !== API_OUTPUT_COUNT) {
$relationMap = new CRelationMap();
// discovered items
$dbRules = DBselect('SELECT gi.graphid,i.hostid' . ' FROM graphs_items gi,items i' . ' WHERE ' . dbConditionInt('gi.graphid', $graphids) . ' AND gi.itemid=i.itemid');
while ($relation = DBfetch($dbRules)) {
$relationMap->addRelation($relation['graphid'], $relation['hostid']);
}
$templates = API::Template()->get(array('output' => $options['selectTemplates'], 'templateids' => $relationMap->getRelatedIds(), 'nopermissions' => true, 'preservekeys' => true));
$result = $relationMap->mapMany($result, $templates, 'templates');
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
$screenIds = array_keys($result);
// adding ScreenItems
if ($options['selectScreenItems'] !== null && $options['selectScreenItems'] != API_OUTPUT_COUNT) {
$screenItems = API::getApiService()->select('screens_items', array('output' => $this->outputExtend($options['selectScreenItems'], array('screenid', 'screenitemid')), 'filter' => array('screenid' => $screenIds), 'preservekeys' => true));
$relationMap = $this->createRelationMap($screenItems, 'screenid', 'screenitemid');
$screenItems = $this->unsetExtraFields($screenItems, array('screenid', 'screenitemid'), $options['selectScreenItems']);
$result = $relationMap->mapMany($result, $screenItems, 'screenitems');
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
$alertIds = array_keys($result);
// adding hosts
if ($options['selectHosts'] !== null && $options['selectHosts'] !== API_OUTPUT_COUNT) {
// trigger events
if ($options['eventobject'] == EVENT_OBJECT_TRIGGER) {
$query = DBselect('SELECT a.alertid,i.hostid' . ' FROM alerts a,events e,functions f,items i' . ' WHERE ' . dbConditionInt('a.alertid', $alertIds) . ' AND a.eventid=e.eventid' . ' AND e.objectid=f.triggerid' . ' AND f.itemid=i.itemid' . ' AND e.object=' . zbx_dbstr($options['eventobject']) . ' AND e.source=' . zbx_dbstr($options['eventsource']));
} elseif ($options['eventobject'] == EVENT_OBJECT_ITEM || $options['eventobject'] == EVENT_OBJECT_LLDRULE) {
$query = DBselect('SELECT a.alertid,i.hostid' . ' FROM alerts a,events e,items i' . ' WHERE ' . dbConditionInt('a.alertid', $alertIds) . ' AND a.eventid=e.eventid' . ' AND e.objectid=i.itemid' . ' AND e.object=' . zbx_dbstr($options['eventobject']) . ' AND e.source=' . zbx_dbstr($options['eventsource']));
}
$relationMap = new CRelationMap();
while ($relation = DBfetch($query)) {
$relationMap->addRelation($relation['alertid'], $relation['hostid']);
}
$hosts = API::Host()->get(['output' => $options['selectHosts'], 'hostids' => $relationMap->getRelatedIds(), 'preservekeys' => true]);
$result = $relationMap->mapMany($result, $hosts, 'hosts');
}
// adding users
if ($options['selectUsers'] !== null && $options['selectUsers'] !== API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'alertid', 'userid');
$users = API::User()->get(['output' => $options['selectUsers'], 'userids' => $relationMap->getRelatedIds(), 'preservekeys' => true]);
$result = $relationMap->mapMany($result, $users, 'users');
}
// adding media types
if ($options['selectMediatypes'] !== null && $options['selectMediatypes'] !== API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'alertid', 'mediatypeid');
$mediatypes = API::getApiService()->select('media_type', ['output' => $options['selectMediatypes'], 'filter' => ['mediatypeid' => $relationMap->getRelatedIds()], 'preservekeys' => true]);
$result = $relationMap->mapMany($result, $mediatypes, 'mediatypes');
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
// adding users
if ($options['selectUsers'] !== null && $options['selectUsers'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'usrgrpid', 'userid', 'users_groups');
$dbUsers = API::User()->get(['output' => $options['selectUsers'], 'userids' => $relationMap->getRelatedIds(), 'getAccess' => $options['selectUsers'] == API_OUTPUT_EXTEND ? true : null, 'preservekeys' => true]);
$result = $relationMap->mapMany($result, $dbUsers, 'users');
}
// adding usergroup rights
if ($options['selectRights'] !== null && $options['selectRights'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'groupid', 'rightid', 'rights');
if (is_array($options['selectRights'])) {
$pk_field = $this->pk('rights');
$output_fields = [$pk_field => $this->fieldId($pk_field, 'r')];
foreach ($options['selectRights'] as $field) {
if ($this->hasField($field, 'rights')) {
$output_fields[$field] = $this->fieldId($field, 'r');
}
}
$output_fields = implode(',', $output_fields);
} else {
$output_fields = 'r.*';
}
$db_rights = DBfetchArray(DBselect('SELECT ' . $output_fields . ' FROM rights r' . ' WHERE ' . dbConditionInt('r.rightid', $relationMap->getRelatedIds()) . (self::$userData['type'] == USER_TYPE_SUPER_ADMIN ? '' : ' AND r.permission>' . PERM_DENY)));
$db_rights = zbx_toHash($db_rights, 'rightid');
foreach ($db_rights as &$db_right) {
unset($db_right['rightid'], $db_right['groupid']);
}
unset($db_right);
$result = $relationMap->mapMany($result, $db_rights, 'rights');
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
// add application templates
if ($this->outputIsRequested('templateids', $options['output'])) {
$query = DBselect('SELECT at.application_templateid,at.applicationid,at.templateid' . ' FROM application_template at' . ' WHERE ' . dbConditionInt('at.applicationid', array_keys($result)));
$relationMap = new CRelationMap();
$templateApplications = array();
while ($templateApplication = DBfetch($query)) {
$relationMap->addRelation($templateApplication['applicationid'], $templateApplication['application_templateid']);
$templateApplications[$templateApplication['application_templateid']] = $templateApplication['templateid'];
}
$result = $relationMap->mapMany($result, $templateApplications, 'templateids');
}
// adding hosts (deprecated)
if ($options['selectHosts'] !== null && $options['selectHosts'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'applicationid', 'hostid');
$hosts = API::Host()->get(array('output' => $options['selectHosts'], 'hostids' => $relationMap->getRelatedIds(), 'nopermissions' => true, 'templated_hosts' => true, 'preservekeys' => true));
$result = $relationMap->mapMany($result, $hosts, 'hosts');
}
// adding one host
if ($options['selectHost'] !== null) {
$relationMap = $this->createRelationMap($result, 'applicationid', 'hostid');
$hosts = API::Host()->get(array('output' => $options['selectHost'], 'hostids' => $relationMap->getRelatedIds(), 'nopermissions' => true, 'templated_hosts' => true, 'preservekeys' => true));
$result = $relationMap->mapOne($result, $hosts, 'host');
}
// adding items
if ($options['selectItems'] !== null && $options['selectItems'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'applicationid', 'itemid', 'items_applications');
$items = API::Item()->get(array('output' => $options['selectItems'], 'itemids' => $relationMap->getRelatedIds(), 'nopermissions' => true, 'preservekeys' => true));
$result = $relationMap->mapMany($result, $items, 'items');
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
$dhostIds = array_keys($result);
// select_drules
if ($options['selectDRules'] !== null && $options['selectDRules'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'dhostid', 'druleid');
$drules = API::DRule()->get(array('output' => $options['selectDRules'], 'druleids' => $relationMap->getRelatedIds(), 'preservekeys' => true));
if (!is_null($options['limitSelects'])) {
order_result($drules, 'name');
}
$result = $relationMap->mapMany($result, $drules, 'drules', $options['limitSelects']);
}
// selectDServices
if (!is_null($options['selectDServices'])) {
if ($options['selectDServices'] != API_OUTPUT_COUNT) {
$dservices = API::DService()->get(array('output' => $this->outputExtend($options['selectDServices'], array('dserviceid', 'dhostid')), 'dhostids' => $dhostIds, 'preservekeys' => true));
$relationMap = $this->createRelationMap($dservices, 'dhostid', 'dserviceid');
$dservices = $this->unsetExtraFields($dservices, array('dserviceid', 'dhostid'), $options['selectDServices']);
if (!is_null($options['limitSelects'])) {
order_result($dservices, 'name');
}
$result = $relationMap->mapMany($result, $dservices, 'dservices', $options['limitSelects']);
} else {
$dservices = API::DService()->get(array('output' => $options['selectDServices'], 'dhostids' => $dhostIds, 'countOutput' => true, 'groupCount' => true));
$dservices = zbx_toHash($dservices, 'dhostid');
foreach ($result as $dhostid => $dhost) {
if (isset($dservices[$dhostid])) {
$result[$dhostid]['dservices'] = $dservices[$dhostid]['rowscount'];
} else {
$result[$dhostid]['dservices'] = 0;
}
}
}
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
// adding hosts
if ($options['selectHosts'] !== null && $options['selectHosts'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'itemid', 'hostid');
$hosts = API::Host()->get(['hostids' => $relationMap->getRelatedIds(), 'templated_hosts' => true, 'output' => $options['selectHosts'], 'nopermissions' => true, 'preservekeys' => true]);
$result = $relationMap->mapMany($result, $hosts, 'hosts');
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
$groupIds = array_keys($result);
sort($groupIds);
// adding hosts
if ($options['selectHosts'] !== null) {
if ($options['selectHosts'] !== API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'groupid', 'hostid', 'hosts_groups');
$hosts = API::Host()->get(array('output' => $options['selectHosts'], 'hostids' => $relationMap->getRelatedIds(), 'preservekeys' => true));
if (!is_null($options['limitSelects'])) {
order_result($hosts, 'host');
}
$result = $relationMap->mapMany($result, $hosts, 'hosts', $options['limitSelects']);
} else {
$hosts = API::Host()->get(array('groupids' => $groupIds, 'countOutput' => true, 'groupCount' => true));
$hosts = zbx_toHash($hosts, 'groupid');
foreach ($result as $groupid => $group) {
if (isset($hosts[$groupid])) {
$result[$groupid]['hosts'] = $hosts[$groupid]['rowscount'];
} else {
$result[$groupid]['hosts'] = 0;
}
}
}
}
// adding templates
if ($options['selectTemplates'] !== null) {
if ($options['selectTemplates'] !== API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'groupid', 'hostid', 'hosts_groups');
$hosts = API::Template()->get(array('output' => $options['selectTemplates'], 'templateids' => $relationMap->getRelatedIds(), 'preservekeys' => true));
if (!is_null($options['limitSelects'])) {
order_result($hosts, 'host');
}
$result = $relationMap->mapMany($result, $hosts, 'templates', $options['limitSelects']);
} else {
$hosts = API::Template()->get(array('groupids' => $groupIds, 'countOutput' => true, 'groupCount' => true));
$hosts = zbx_toHash($hosts, 'groupid');
foreach ($result as $groupid => $group) {
if (isset($hosts[$groupid])) {
$result[$groupid]['templates'] = $hosts[$groupid]['rowscount'];
} else {
$result[$groupid]['templates'] = 0;
}
}
}
}
// adding discovery rule
if ($options['selectDiscoveryRule'] !== null && $options['selectDiscoveryRule'] != API_OUTPUT_COUNT) {
// discovered items
$discoveryRules = DBFetchArray(DBselect('SELECT gd.groupid,hd.parent_itemid' . ' FROM group_discovery gd,group_prototype gp,host_discovery hd' . ' WHERE ' . dbConditionInt('gd.groupid', $groupIds) . ' AND gd.parent_group_prototypeid=gp.group_prototypeid' . ' AND gp.hostid=hd.hostid'));
$relationMap = $this->createRelationMap($discoveryRules, 'groupid', 'parent_itemid');
$discoveryRules = API::DiscoveryRule()->get(array('output' => $options['selectDiscoveryRule'], 'itemids' => $relationMap->getRelatedIds(), 'preservekeys' => true));
$result = $relationMap->mapOne($result, $discoveryRules, 'discoveryRule');
}
// adding group discovery
if ($options['selectGroupDiscovery'] !== null) {
$groupDiscoveries = API::getApiService()->select('group_discovery', array('output' => $this->outputExtend($options['selectGroupDiscovery'], array('groupid')), 'filter' => array('groupid' => $groupIds), 'preservekeys' => true));
$relationMap = $this->createRelationMap($groupDiscoveries, 'groupid', 'groupid');
$groupDiscoveries = $this->unsetExtraFields($groupDiscoveries, array('groupid'), $options['selectGroupDiscovery']);
$result = $relationMap->mapOne($result, $groupDiscoveries, 'groupDiscovery');
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
// Select mappings for value map.
if ($options['selectMappings'] !== null) {
if ($options['selectMappings'] == API_OUTPUT_COUNT) {
$db_mappings = DBselect('SELECT m.valuemapid,COUNT(*) AS cnt' . ' FROM mappings m' . ' WHERE ' . dbConditionInt('m.valuemapid', array_keys($result)) . ' GROUP BY m.valuemapid');
foreach ($result as &$valuemap) {
$valuemap['mappings'] = 0;
}
unset($valuemap);
while ($db_mapping = DBfetch($db_mappings)) {
$result[$db_mapping['valuemapid']]['mappings'] = $db_mapping['cnt'];
}
} else {
$db_mappings = API::getApiService()->select('mappings', ['output' => $this->outputExtend($options['selectMappings'], ['valuemapid']), 'filter' => ['valuemapid' => array_keys($result)]]);
foreach ($result as &$valuemap) {
$valuemap['mappings'] = [];
}
unset($valuemap);
foreach ($db_mappings as $db_mapping) {
$valuemapid = $db_mapping['valuemapid'];
unset($db_mapping['mappingid'], $db_mapping['valuemapid']);
$result[$valuemapid]['mappings'][] = $db_mapping;
}
}
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
$serviceIds = array_keys($result);
// selectDependencies
if ($options['selectDependencies'] !== null && $options['selectDependencies'] != API_OUTPUT_COUNT) {
$dependencies = $this->fetchChildDependencies($serviceIds, $this->outputExtend($options['selectDependencies'], array('serviceupid', 'linkid')));
$dependencies = zbx_toHash($dependencies, 'linkid');
$relationMap = $this->createRelationMap($dependencies, 'serviceupid', 'linkid');
$dependencies = $this->unsetExtraFields($dependencies, array('serviceupid', 'linkid'), $options['selectDependencies']);
$result = $relationMap->mapMany($result, $dependencies, 'dependencies');
}
// selectParentDependencies
if ($options['selectParentDependencies'] !== null && $options['selectParentDependencies'] != API_OUTPUT_COUNT) {
$dependencies = $this->fetchParentDependencies($serviceIds, $this->outputExtend($options['selectParentDependencies'], array('servicedownid', 'linkid')));
$dependencies = zbx_toHash($dependencies, 'linkid');
$relationMap = $this->createRelationMap($dependencies, 'servicedownid', 'linkid');
$dependencies = $this->unsetExtraFields($dependencies, array('servicedownid', 'linkid'), $options['selectParentDependencies']);
$result = $relationMap->mapMany($result, $dependencies, 'parentDependencies');
}
// selectParent
if ($options['selectParent'] !== null && $options['selectParent'] != API_OUTPUT_COUNT) {
$dependencies = $this->fetchParentDependencies($serviceIds, array('servicedownid', 'serviceupid'), false);
$relationMap = $this->createRelationMap($dependencies, 'servicedownid', 'serviceupid');
$parents = $this->get(array('output' => $options['selectParent'], 'serviceids' => $relationMap->getRelatedIds(), 'preservekeys' => true));
$result = $relationMap->mapOne($result, $parents, 'parent');
}
// selectTimes
if ($options['selectTimes'] !== null && $options['selectTimes'] != API_OUTPUT_COUNT) {
$serviceTimes = API::getApiService()->select('services_times', array('output' => $this->outputExtend($options['selectTimes'], array('serviceid', 'timeid')), 'filter' => array('serviceid' => $serviceIds), 'preservekeys' => true));
$relationMap = $this->createRelationMap($serviceTimes, 'serviceid', 'timeid');
$serviceTimes = $this->unsetExtraFields($serviceTimes, array('serviceid', 'timeid'), $options['selectTimes']);
$result = $relationMap->mapMany($result, $serviceTimes, 'times');
}
// selectAlarms
if ($options['selectAlarms'] !== null && $options['selectAlarms'] != API_OUTPUT_COUNT) {
$serviceAlarms = API::getApiService()->select('service_alarms', array('output' => $this->outputExtend($options['selectAlarms'], array('serviceid', 'servicealarmid')), 'filter' => array('serviceid' => $serviceIds), 'preservekeys' => true));
$relationMap = $this->createRelationMap($serviceAlarms, 'serviceid', 'servicealarmid');
$serviceAlarms = $this->unsetExtraFields($serviceAlarms, array('serviceid', 'servicealarmid'), $options['selectAlarms']);
$result = $relationMap->mapMany($result, $serviceAlarms, 'alarms');
}
// selectTrigger
if ($options['selectTrigger'] !== null && $options['selectTrigger'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'serviceid', 'triggerid');
$triggers = API::getApiService()->select('triggers', array('output' => $options['selectTrigger'], 'triggerids' => $relationMap->getRelatedIds(), 'preservekeys' => true));
$result = $relationMap->mapOne($result, $triggers, 'trigger');
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
if ($options['globalmacro'] === null) {
$hostMacroIds = array_keys($result);
/*
* Adding objects
*/
// adding groups
if ($options['selectGroups'] !== null && $options['selectGroups'] != API_OUTPUT_COUNT) {
$res = DBselect('SELECT hm.hostmacroid,hg.groupid' . ' FROM hostmacro hm,hosts_groups hg' . ' WHERE ' . dbConditionInt('hm.hostmacroid', $hostMacroIds) . ' AND hm.hostid=hg.hostid');
$relationMap = new CRelationMap();
while ($relation = DBfetch($res)) {
$relationMap->addRelation($relation['hostmacroid'], $relation['groupid']);
}
$groups = API::HostGroup()->get(array('output' => $options['selectGroups'], 'groupids' => $relationMap->getRelatedIds(), 'preservekeys' => true));
$result = $relationMap->mapMany($result, $groups, 'groups');
}
// adding templates
if ($options['selectTemplates'] !== null && $options['selectTemplates'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'hostmacroid', 'hostid');
$templates = API::Template()->get(array('output' => $options['selectTemplates'], 'templateids' => $relationMap->getRelatedIds(), 'preservekeys' => true));
$result = $relationMap->mapMany($result, $templates, 'templates');
}
// adding templates
if ($options['selectHosts'] !== null && $options['selectHosts'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'hostmacroid', 'hostid');
$templates = API::Host()->get(array('output' => $options['selectHosts'], 'hostids' => $relationMap->getRelatedIds(), 'preservekeys' => true));
$result = $relationMap->mapMany($result, $templates, 'hosts');
}
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
// adding users
if ($options['selectUsers'] !== null && $options['selectUsers'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'mediatypeid', 'userid', 'media');
$users = API::User()->get(array('output' => $options['selectUsers'], 'userids' => $relationMap->getRelatedIds(), 'preservekeys' => true));
$result = $relationMap->mapMany($result, $users, 'users');
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
$httpTestIds = array_keys($result);
// adding hosts
if ($options['selectHosts'] !== null && $options['selectHosts'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'httptestid', 'hostid');
$hosts = API::Host()->get(array('output' => $options['selectHosts'], 'hostid' => $relationMap->getRelatedIds(), 'nopermissions' => true, 'templated_hosts' => true, 'preservekeys' => true));
$result = $relationMap->mapMany($result, $hosts, 'hosts');
}
// adding steps
if ($options['selectSteps'] !== null) {
if ($options['selectSteps'] != API_OUTPUT_COUNT) {
$httpSteps = API::getApiService()->select('httpstep', array('output' => $this->outputExtend($options['selectSteps'], array('httptestid', 'httpstepid')), 'filters' => array('httptestid' => $httpTestIds), 'preservekeys' => true));
$relationMap = $this->createRelationMap($httpSteps, 'httptestid', 'httpstepid');
$httpSteps = $this->unsetExtraFields($httpSteps, array('httptestid', 'httpstepid'), $options['selectSteps']);
$result = $relationMap->mapMany($result, $httpSteps, 'steps');
} else {
$dbHttpSteps = DBselect('SELECT hs.httptestid,COUNT(hs.httpstepid) AS stepscnt' . ' FROM httpstep hs' . ' WHERE ' . dbConditionInt('hs.httptestid', $httpTestIds) . ' GROUP BY hs.httptestid');
while ($dbHttpStep = DBfetch($dbHttpSteps)) {
$result[$dbHttpStep['httptestid']]['steps'] = $dbHttpStep['stepscnt'];
}
}
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
$dserviceIds = array_keys($result);
// select_drules
if ($options['selectDRules'] !== null && $options['selectDRules'] != API_OUTPUT_COUNT) {
$relationMap = new CRelationMap();
// discovered items
$dbRules = DBselect('SELECT ds.dserviceid,dh.druleid' . ' FROM dservices ds,dhosts dh' . ' WHERE ' . dbConditionInt('ds.dserviceid', $dserviceIds) . ' AND ds.dhostid=dh.dhostid');
while ($rule = DBfetch($dbRules)) {
$relationMap->addRelation($rule['dserviceid'], $rule['druleid']);
}
$drules = API::DRule()->get(['output' => $options['selectDRules'], 'druleids' => $relationMap->getRelatedIds(), 'preservekeys' => true]);
if (!is_null($options['limitSelects'])) {
order_result($drules, 'name');
}
$result = $relationMap->mapMany($result, $drules, 'drules');
}
// selectDHosts
if ($options['selectDHosts'] !== null && $options['selectDHosts'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'dserviceid', 'dhostid');
$dhosts = API::DHost()->get(['output' => $options['selectDHosts'], 'dhosts' => $relationMap->getRelatedIds(), 'preservekeys' => true]);
if (!is_null($options['limitSelects'])) {
order_result($dhosts, 'dhostid');
}
$result = $relationMap->mapMany($result, $dhosts, 'dhosts', $options['limitSelects']);
}
// selectHosts
if (!is_null($options['selectHosts'])) {
if ($options['selectHosts'] != API_OUTPUT_COUNT) {
$relationMap = new CRelationMap();
// discovered items
$dbRules = DBselect('SELECT ds.dserviceid,i.hostid' . ' FROM dservices ds,interface i' . ' WHERE ' . dbConditionInt('ds.dserviceid', $dserviceIds) . ' AND ds.ip=i.ip');
while ($rule = DBfetch($dbRules)) {
$relationMap->addRelation($rule['dserviceid'], $rule['hostid']);
}
$hosts = API::Host()->get(['output' => $options['selectHosts'], 'hostids' => $relationMap->getRelatedIds(), 'preservekeys' => true, 'sortfield' => 'status']);
if (!is_null($options['limitSelects'])) {
order_result($hosts, 'hostid');
}
$result = $relationMap->mapMany($result, $hosts, 'hosts', $options['limitSelects']);
} else {
$hosts = API::Host()->get(['dserviceids' => $dserviceIds, 'countOutput' => true, 'groupCount' => true]);
$hosts = zbx_toHash($hosts, 'hostid');
foreach ($result as $dserviceid => $dservice) {
if (isset($hosts[$dserviceid])) {
$result[$dserviceid]['hosts'] = $hosts[$dserviceid]['rowscount'];
} else {
$result[$dserviceid]['hosts'] = 0;
}
}
}
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
// selectGroups
if ($options['selectGroups'] !== null && $options['selectGroups'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'maintenanceid', 'groupid', 'maintenances_groups');
$groups = API::HostGroup()->get(['output' => $options['selectGroups'], 'hostgroupids' => $relationMap->getRelatedIds(), 'preservekeys' => true]);
$result = $relationMap->mapMany($result, $groups, 'groups');
}
// selectHosts
if ($options['selectHosts'] !== null && $options['selectHosts'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'maintenanceid', 'hostid', 'maintenances_hosts');
$groups = API::Host()->get(['output' => $options['selectHosts'], 'hostids' => $relationMap->getRelatedIds(), 'preservekeys' => true]);
$result = $relationMap->mapMany($result, $groups, 'hosts');
}
// selectTimeperiods
if ($options['selectTimeperiods'] !== null && $options['selectTimeperiods'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'maintenanceid', 'timeperiodid', 'maintenances_windows');
$timeperiods = API::getApiService()->select('timeperiods', ['output' => $options['selectTimeperiods'], 'filter' => ['timeperiodid' => $relationMap->getRelatedIds()], 'preservekeys' => true]);
$result = $relationMap->mapMany($result, $timeperiods, 'timeperiods');
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
$druleids = array_keys($result);
// Adding Discovery Checks
if (!is_null($options['selectDChecks'])) {
if ($options['selectDChecks'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'druleid', 'dcheckid', 'dchecks');
$dchecks = API::DCheck()->get(array('output' => $options['selectDChecks'], 'dcheckids' => $relationMap->getRelatedIds(), 'nopermissions' => true, 'preservekeys' => true));
if (!is_null($options['limitSelects'])) {
order_result($dchecks, 'dcheckid');
}
$result = $relationMap->mapMany($result, $dchecks, 'dchecks', $options['limitSelects']);
} else {
$dchecks = API::DCheck()->get(array('druleids' => $druleids, 'nopermissions' => true, 'countOutput' => true, 'groupCount' => true));
$dchecks = zbx_toHash($dchecks, 'druleid');
foreach ($result as $druleid => $drule) {
if (isset($dchecks[$druleid])) {
$result[$druleid]['dchecks'] = $dchecks[$druleid]['rowscount'];
} else {
$result[$druleid]['dchecks'] = 0;
}
}
}
}
// Adding Discovery Hosts
if (!is_null($options['selectDHosts'])) {
if ($options['selectDHosts'] != API_OUTPUT_COUNT) {
$relationMap = $this->createRelationMap($result, 'druleid', 'dhostid', 'dhosts');
$dhosts = API::DHost()->get(array('output' => $options['selectDHosts'], 'dhostids' => $relationMap->getRelatedIds(), 'preservekeys' => true));
if (!is_null($options['limitSelects'])) {
order_result($dhosts, 'dhostid');
}
$result = $relationMap->mapMany($result, $dhosts, 'dhosts', $options['limitSelects']);
} else {
$dhosts = API::DHost()->get(array('druleids' => $druleids, 'countOutput' => true, 'groupCount' => true));
$dhosts = zbx_toHash($dhosts, 'druleid');
foreach ($result as $druleid => $drule) {
if (isset($dhosts[$druleid])) {
$result[$druleid]['dhosts'] = $dhosts[$druleid]['rowscount'];
} else {
$result[$druleid]['dhosts'] = 0;
}
}
}
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
// adding groups
if ($options['selectGroups'] !== null && $options['selectGroups'] != API_OUTPUT_COUNT) {
foreach ($result as $scriptId => $script) {
$result[$scriptId]['groups'] = API::HostGroup()->get(array('output' => $options['selectGroups'], 'groupids' => $script['groupid'] ? $script['groupid'] : null, 'editable' => $script['host_access'] == PERM_READ_WRITE ? true : null));
}
}
// adding hosts
if ($options['selectHosts'] !== null && $options['selectHosts'] != API_OUTPUT_COUNT) {
$processedGroups = array();
foreach ($result as $scriptId => $script) {
if (isset($processedGroups[$script['groupid'] . '_' . $script['host_access']])) {
$result[$scriptId]['hosts'] = $result[$processedGroups[$script['groupid'] . '_' . $script['host_access']]]['hosts'];
} else {
$result[$scriptId]['hosts'] = API::Host()->get(array('output' => $options['selectHosts'], 'groupids' => $script['groupid'] ? $script['groupid'] : null, 'hostids' => $options['hostids'] ? $options['hostids'] : null, 'editable' => $script['host_access'] == PERM_READ_WRITE ? true : null));
$processedGroups[$script['groupid'] . '_' . $script['host_access']] = $scriptId;
}
}
}
return $result;
}
protected function addRelatedObjects(array $options, array $result)
{
$result = parent::addRelatedObjects($options, $result);
$screenIds = array_keys($result);
// adding ScreenItems
if ($options['selectScreenItems'] !== null && $options['selectScreenItems'] != API_OUTPUT_COUNT) {
$screenItems = API::getApiService()->select('screens_items', ['output' => $this->outputExtend($options['selectScreenItems'], ['screenid', 'screenitemid']), 'filter' => ['screenid' => $screenIds], 'preservekeys' => true]);
$relation_map = $this->createRelationMap($screenItems, 'screenid', 'screenitemid');
$screenItems = $this->unsetExtraFields($screenItems, ['screenid', 'screenitemid'], $options['selectScreenItems']);
$result = $relation_map->mapMany($result, $screenItems, 'screenitems');
}
// Adding user shares.
if ($options['selectUsers'] !== null && $options['selectUsers'] != API_OUTPUT_COUNT) {
$relation_map = $this->createRelationMap($result, 'screenid', 'userid', 'screen_user');
// Get all allowed users.
$related_users = API::User()->get(['output' => ['userid'], 'userids' => $relation_map->getRelatedIds(), 'preservekeys' => true]);
$related_userids = zbx_objectValues($related_users, 'userid');
if ($related_userids) {
$users = API::getApiService()->select('screen_user', ['output' => $this->outputExtend($options['selectUsers'], ['screenid', 'userid']), 'filter' => ['screenid' => $screenIds, 'userid' => $related_userids], 'preservekeys' => true]);
$relation_map = $this->createRelationMap($users, 'screenid', 'screenuserid');
$users = $this->unsetExtraFields($users, ['screenuserid', 'userid', 'permission'], $options['selectUsers']);
foreach ($users as &$user) {
unset($user['screenid']);
}
unset($user);
$result = $relation_map->mapMany($result, $users, 'users');
} else {
foreach ($result as &$row) {
$row['users'] = [];
}
unset($row);
}
}
// Adding user group shares.
if ($options['selectUserGroups'] !== null && $options['selectUserGroups'] != API_OUTPUT_COUNT) {
$relation_map = $this->createRelationMap($result, 'screenid', 'usrgrpid', 'screen_usrgrp');
// Get all allowed groups.
$related_groups = API::UserGroup()->get(['output' => ['usrgrpid'], 'usrgrpids' => $relation_map->getRelatedIds(), 'preservekeys' => true]);
$related_groupids = zbx_objectValues($related_groups, 'usrgrpid');
if ($related_groupids) {
$user_groups = API::getApiService()->select('screen_usrgrp', ['output' => $this->outputExtend($options['selectUserGroups'], ['screenid', 'usrgrpid']), 'filter' => ['screenid' => $screenIds, 'usrgrpid' => $related_groupids], 'preservekeys' => true]);
$relation_map = $this->createRelationMap($user_groups, 'screenid', 'screenusrgrpid');
$user_groups = $this->unsetExtraFields($user_groups, ['screenusrgrpid', 'usrgrpid', 'permission'], $options['selectUserGroups']);
foreach ($user_groups as &$user_group) {
unset($user_group['screenid']);
}
unset($user_group);
$result = $relation_map->mapMany($result, $user_groups, 'userGroups');
} else {
foreach ($result as &$row) {
$row['userGroups'] = [];
}
unset($row);
}
}
return $result;
}
