36 	 * @param array  $options
37 	 * @param array  $options['groupids']				HostGroup IDs
38 	 * @param bool   $options['monitored_hosts']		only monitored Hosts
39 	 * @param bool   $options['templated_hosts']		include templates in result
40 	 * @param bool   $options['with_items']				only with items
41 	 * @param bool   $options['with_triggers']			only with triggers
42 	 * @param bool   $options['with_httptests']			only with http tests
43 	 * @param bool   $options['with_graphs']			only with graphs
44 	 * @param bool   $options['editable']				only with read-write permission. Ignored for SuperAdmins
45 	 * @param bool   $options['selectTemplates']		select Templates
46 	 * @param bool   $options['selectItems']			select Items
47 	 * @param bool   $options['selectTriggers']			select Triggers
48 	 * @param bool   $options['selectGraphs']			select Graphs
49 	 * @param int    $options['count']					count Hosts, returned column name is rowscount
50 	 * @param string $options['pattern']				search hosts by pattern in Host name
51 	 * @param string $options['extendPattern']			search hosts by pattern in Host name, ip and DNS
52 	 * @param int    $options['limit']					limit selection
53 	 * @param string $options['sortfield']				field to sort by
54 	 * @param string $options['sortorder']				sort order
58 	public function get($options = []) {  argument
95 		$options = zbx_array_merge($defOptions, $options);
102 		if (!is_null($options['dhostids'])) {
103 			zbx_value2array($options['dhostids']);
104 			$sqlParts['where']['dhostid'] = dbConditionInt('dh.dhostid', $options['dhostids']);
108 		if (!is_null($options['druleids'])) {
109 			zbx_value2array($options['druleids']);
111 			$sqlParts['where']['druleid'] = dbConditionInt('dh.druleid', $options['druleids']);
113 			if (!is_null($options['groupCount'])) {
119 		if (!is_null($options['dserviceids'])) {
120 			zbx_value2array($options['dserviceids']);
123 			$sqlParts['where'][] = dbConditionInt('ds.dserviceid', $options['dserviceids']);
126 			if (!is_null($options['groupCount'])) {
132 		if (is_array($options['filter'])) {
133 			$this->dbFilter('dhosts dh', $options, $sqlParts);
137 		if (is_array($options['search'])) {
138 			zbx_db_search('dhosts dh', $options, $sqlParts);
142 		if (zbx_ctype_digit($options['limit']) && $options['limit']) {
143 			$sqlParts['limit'] = $options['limit'];
147 …$sqlParts = $this->applyQueryOutputOptions($this->tableName(), $this->tableAlias(), $options, $sql…
148 …$sqlParts = $this->applyQuerySortOptions($this->tableName(), $this->tableAlias(), $options, $sqlPa…
151 			if (!is_null($options['countOutput'])) {
152 				if (!is_null($options['groupCount']))
162 		if (!is_null($options['countOutput'])) {
167 			$result = $this->addRelatedObjects($options, $result);
168 			$result = $this->unsetExtraFields($result, ['druleid'], $options['output']);
172 		if (is_null($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'] === null) {
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'],