34 	 * @param array  $options
35 	 * @param array  $options['groupids']				HostGroup IDs
36 	 * @param bool   $options['monitored_hosts']		only monitored Hosts
37 	 * @param bool   $options['templated_hosts']		include templates in result
38 	 * @param bool   $options['with_items']				only with items
39 	 * @param bool   $options['with_triggers']			only with triggers
40 	 * @param bool   $options['with_httptests']			only with http tests
41 	 * @param bool   $options['with_graphs']			only with graphs
42 	 * @param bool   $options['editable']				only with read-write permission. Ignored for SuperAdmins
43 	 * @param bool   $options['selectTemplates']		select Templates
44 	 * @param bool   $options['selectItems']			select Items
45 	 * @param bool   $options['selectTriggers']			select Triggers
46 	 * @param bool   $options['selectGraphs']			select Graphs
47 	 * @param int    $options['count']					count Hosts, returned column name is rowscount
48 	 * @param string $options['pattern']				search hosts by pattern in Host name
49 	 * @param string $options['extendPattern']			search hosts by pattern in Host name, ip and DNS
50 	 * @param int    $options['limit']					limit selection
51 	 * @param string $options['sortfield']				field to sort by
52 	 * @param string $options['sortorder']				sort order
56 	public function get($options = []) {  argument
93 		$options = zbx_array_merge($defOptions, $options);
100 		if (!is_null($options['dhostids'])) {
101 			zbx_value2array($options['dhostids']);
102 			$sqlParts['where']['dhostid'] = dbConditionInt('dh.dhostid', $options['dhostids']);
106 		if (!is_null($options['druleids'])) {
107 			zbx_value2array($options['druleids']);
109 			$sqlParts['where']['druleid'] = dbConditionInt('dh.druleid', $options['druleids']);
111 			if ($options['groupCount']) {
117 		if (!is_null($options['dserviceids'])) {
118 			zbx_value2array($options['dserviceids']);
121 			$sqlParts['where'][] = dbConditionInt('ds.dserviceid', $options['dserviceids']);
124 			if ($options['groupCount']) {
130 		if (is_array($options['filter'])) {
131 			$this->dbFilter('dhosts dh', $options, $sqlParts);
135 		if (is_array($options['search'])) {
136 			zbx_db_search('dhosts dh', $options, $sqlParts);
140 		if (zbx_ctype_digit($options['limit']) && $options['limit']) {
141 			$sqlParts['limit'] = $options['limit'];
145 …$sqlParts = $this->applyQueryOutputOptions($this->tableName(), $this->tableAlias(), $options, $sql…
146 …$sqlParts = $this->applyQuerySortOptions($this->tableName(), $this->tableAlias(), $options, $sqlPa…
149 			if ($options['countOutput']) {
150 				if ($options['groupCount']) {
162 		if ($options['countOutput']) {
167 			$result = $this->addRelatedObjects($options, $result);
168 			$result = $this->unsetExtraFields($result, ['druleid'], $options['output']);
172 		if (!$options['preservekeys']) {
179 …protected function applyQueryOutputOptions($tableName, $tableAlias, array $options, array $sqlPart…  argument
180 		$sqlParts = parent::applyQueryOutputOptions($tableName, $tableAlias, $options, $sqlParts);
182 		if (!$options['countOutput']) {
183 			if ($options['selectDRules'] !== null) {
191 	protected function addRelatedObjects(array $options, array $result) {  argument
192 		$result = parent::addRelatedObjects($options, $result);
197 		if ($options['selectDRules'] !== null && $options['selectDRules'] != API_OUTPUT_COUNT) {
200 				'output' => $options['selectDRules'],
205 			if (!is_null($options['limitSelects'])) {
209 			$result = $relationMap->mapMany($result, $drules, 'drules', $options['limitSelects']);
213 		if (!is_null($options['selectDServices'])) {
214 			if ($options['selectDServices'] != API_OUTPUT_COUNT) {
216 					'output' => $this->outputExtend($options['selectDServices'], ['dserviceid', 'dhostid']),
222 …$dservices = $this->unsetExtraFields($dservices, ['dserviceid', 'dhostid'], $options['selectDServi…
223 				if (!is_null($options['limitSelects'])) {
226 				$result = $relationMap->mapMany($result, $dservices, 'dservices', $options['limitSelects']);
230 					'output' => $options['selectDServices'],