34 	 * @param array $options
38 	public function get($options = []) {  argument
91 		$options = zbx_array_merge($defOptions, $options);
93 		$this->validateGet($options);
96 		$sqlParts['where'][] = 'p.source='.zbx_dbstr($options['source']);
97 		$sqlParts['where'][] = 'p.object='.zbx_dbstr($options['object']);
100 		if ($userType != USER_TYPE_SUPER_ADMIN && !$options['nopermissions']) {
102 			if ($options['object'] == EVENT_OBJECT_TRIGGER) {
106 				if ($options['objectids'] !== null) {
107 					$options['objectids'] = array_keys(API::Trigger()->get([
109 						'triggerids' => $options['objectids'],
110 						'editable' => $options['editable'],
126 						' HAVING MAX(permission)<'.($options['editable'] ? PERM_READ_WRITE : PERM_READ).
132 				if ($options['source'] == EVENT_SOURCE_TRIGGERS) {
136 			elseif ($options['object'] == EVENT_OBJECT_ITEM || $options['object'] == EVENT_OBJECT_LLDRULE) {
138 				if ($options['objectids'] !== null) {
139 					if ($options['object'] == EVENT_OBJECT_ITEM) {
142 							'itemids' => $options['objectids'],
143 							'editable' => $options['editable'],
146 						$options['objectids'] = array_keys($items);
148 					elseif ($options['object'] == EVENT_OBJECT_LLDRULE) {
151 							'itemids' => $options['objectids'],
152 							'editable' => $options['editable'],
155 						$options['objectids'] = array_keys($items);
172 							' AND MAX(r.permission)>='.($options['editable'] ? PERM_READ_WRITE : PERM_READ).
179 		if ($options['eventids'] !== null) {
180 			zbx_value2array($options['eventids']);
181 			$sqlParts['where'][] = dbConditionInt('p.eventid', $options['eventids']);
185 		if ($options['objectids'] !== null) {
186 			zbx_value2array($options['objectids']);
187 			$sqlParts['where'][] = dbConditionInt('p.objectid', $options['objectids']);
191 		if ($options['groupids'] !== null) {
192 			zbx_value2array($options['groupids']);
195 			if ($options['object'] == EVENT_OBJECT_TRIGGER) {
202 				$sqlParts['where']['hg'] = dbConditionInt('hg.groupid', $options['groupids']);
205 			elseif ($options['object'] == EVENT_OBJECT_LLDRULE || $options['object'] == EVENT_OBJECT_ITEM) {
210 				$sqlParts['where']['hg'] = dbConditionInt('hg.groupid', $options['groupids']);
215 		if ($options['hostids'] !== null) {
216 			zbx_value2array($options['hostids']);
219 			if ($options['object'] == EVENT_OBJECT_TRIGGER) {
224 				$sqlParts['where']['i'] = dbConditionInt('i.hostid', $options['hostids']);
227 			elseif ($options['object'] == EVENT_OBJECT_LLDRULE || $options['object'] == EVENT_OBJECT_ITEM) {
230 				$sqlParts['where']['i'] = dbConditionInt('i.hostid', $options['hostids']);
235 		if ($options['applicationids'] !== null) {
236 			zbx_value2array($options['applicationids']);
239 			if ($options['object'] == EVENT_OBJECT_TRIGGER) {
244 				$sqlParts['where']['ia'] = dbConditionInt('ia.applicationid', $options['applicationids']);
247 			elseif ($options['object'] == EVENT_OBJECT_ITEM) {
250 				$sqlParts['where']['ia'] = dbConditionInt('ia.applicationid', $options['applicationids']);
256 		if ($options['severities'] !== null) {
258 			if ($options['object'] == EVENT_OBJECT_TRIGGER) {
259 				zbx_value2array($options['severities']);
260 				$sqlParts['where'][] = dbConditionInt('p.severity', $options['severities']);
266 		if ($options['acknowledged'] !== null) {
267 			$acknowledged = $options['acknowledged'] ? EVENT_ACKNOWLEDGED : EVENT_NOT_ACKNOWLEDGED;
272 		if ($options['suppressed'] !== null) {
273 			$sqlParts['where'][] = (!$options['suppressed'] ? 'NOT ' : '').
282 		if ($options['tags'] !== null && $options['tags']) {
283 …$sqlParts['where'][] = CApiTagHelper::addWhereCondition($options['tags'], $options['evaltype'], 'p…
289 		if ($options['recent'] !== null && $options['recent']) {
300 		if ($options['time_from'] !== null) {
301 			$sqlParts['where'][] = 'p.clock>='.zbx_dbstr($options['time_from']);
305 		if ($options['time_till'] !== null) {
306 			$sqlParts['where'][] = 'p.clock<='.zbx_dbstr($options['time_till']);
310 		if ($options['eventid_from'] !== null) {
311 			$sqlParts['where'][] = 'p.eventid>='.zbx_dbstr($options['eventid_from']);
315 		if ($options['eventid_till'] !== null) {
316 			$sqlParts['where'][] = 'p.eventid<='.zbx_dbstr($options['eventid_till']);
320 		if (is_array($options['search'])) {
321 			zbx_db_search('problem p', $options, $sqlParts);
325 		if (is_array($options['filter'])) {
326 			$this->dbFilter('problem p', $options, $sqlParts);
330 		if (zbx_ctype_digit($options['limit']) && $options['limit']) {
331 			$sqlParts['limit'] = $options['limit'];
334 …$sqlParts = $this->applyQueryOutputOptions($this->tableName(), $this->tableAlias(), $options, $sql…
335 …$sqlParts = $this->applyQuerySortOptions($this->tableName(), $this->tableAlias(), $options, $sqlPa…
338 			if ($options['countOutput']) {
346 		if ($options['countOutput']) {
351 			$result = $this->addRelatedObjects($options, $result);
352 			$result = $this->unsetExtraFields($result, ['object', 'objectid'], $options['output']);
356 		if (!$options['preservekeys']) {
368 	 * @param array $options
370 	protected function validateGet(array $options) {  argument
374 		if (!$sourceValidator->validate($options['source'])) {
381 		if (!$objectValidator->validate($options['object'])) {
386 …if (!$sourceObjectValidator->validate(['source' => $options['source'], 'object' => $options['objec…
393 		if (!$evaltype_validator->validate($options['evaltype'])) {
398 	protected function addRelatedObjects(array $options, array $result) {  argument
399 		$result = parent::addRelatedObjects($options, $result);
404 		if ($this->outputIsRequested('opdata', $options['output'])) {
421 		if ($options['selectAcknowledges'] !== null) {
422 			if ($options['selectAcknowledges'] != API_OUTPUT_COUNT) {
425 					'output' => $this->outputExtend($options['selectAcknowledges'],
434 					$options['selectAcknowledges']
455 …if ($options['selectSuppressionData'] !== null && $options['selectSuppressionData'] != API_OUTPUT_…
457 …		'output' => $this->outputExtend($options['selectSuppressionData'], ['eventid', 'maintenanceid']),
467 		if ($this->outputIsRequested('suppressed', $options['output'])) {
497 …if ($options['selectSuppressionData'] !== null && $options['selectSuppressionData'] != API_OUTPUT_…
498 				&& !$this->outputIsRequested('maintenanceid', $options['selectSuppressionData'])) {
506 		if ($this->outputIsRequested('urls', $options['output'])) {
543 		if ($options['selectTags'] !== null && $options['selectTags'] != API_OUTPUT_COUNT) {
544 			if ($options['selectTags'] === API_OUTPUT_EXTEND) {
545 				$options['selectTags'] = ['tag', 'value'];
549 				'output' => $this->outputExtend($options['selectTags'], ['eventid']),