Zabbix

<?php declare(strict_types = 0);

/*

** Copyright (C) 2001-2025 Zabbix SIA

**

** This program is free software: you can redistribute it and/or modify it under the terms of

** the GNU Affero General Public License as published by the Free Software Foundation, version 3.

**

** This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;

** without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

** See the GNU Affero General Public License for more details.

**

** You should have received a copy of the GNU Affero General Public License along with this program.

** If not, see <https://www.gnu.org/licenses/>.

**/

​

​

/**

 * SLA API implementation.

 */

class CSla extends CApiService {

​

    public const ACCESS_RULES = [

        'get' =>    ['min_user_type' => USER_TYPE_ZABBIX_USER],

        'getsli' => ['min_user_type' => USER_TYPE_ZABBIX_USER],

        'create' => ['min_user_type' => USER_TYPE_ZABBIX_ADMIN, 'action' => CRoleHelper::ACTIONS_MANAGE_SLA],

        'update' => ['min_user_type' => USER_TYPE_ZABBIX_ADMIN, 'action' => CRoleHelper::ACTIONS_MANAGE_SLA],

        'delete' => ['min_user_type' => USER_TYPE_ZABBIX_ADMIN, 'action' => CRoleHelper::ACTIONS_MANAGE_SLA]

    ];

​

    protected $tableName = 'sla';

    protected $tableAlias = 'sla';

    protected $sortColumns = ['slaid', 'name', 'period', 'slo', 'effective_date', 'timezone', 'status', 'description'];

​

    /**

     * @param array $options

     *

     * @throws APIException

     *

     * @return array|string

     */

    public function get(array $options = []) {

        $api_input_rules = ['type' => API_OBJECT, 'fields' => [

            // filter

            'slaids' =>                     ['type' => API_IDS, 'flags' => API_ALLOW_NULL | API_NORMALIZE, 'default' => null],

            'evaltype' =>                   ['type' => API_INT32, 'in' => implode(',', [TAG_EVAL_TYPE_AND_OR, TAG_EVAL_TYPE_OR]), 'default' => TAG_EVAL_TYPE_AND_OR],

            'service_tags' =>               ['type' => API_OBJECTS, 'default' => [], 'fields' => [

                'tag' =>                        ['type' => API_STRING_UTF8, 'flags' => API_REQUIRED],

                'value' =>                      ['type' => API_STRING_UTF8],

                'operator' =>                   ['type' => API_INT32, 'in' => implode(',', [TAG_OPERATOR_LIKE, TAG_OPERATOR_EQUAL, TAG_OPERATOR_NOT_LIKE, TAG_OPERATOR_NOT_EQUAL, TAG_OPERATOR_EXISTS, TAG_OPERATOR_NOT_EXISTS])]

            ]],

            'serviceids' =>                 ['type' => API_IDS, 'flags' => API_ALLOW_NULL | API_NORMALIZE, 'default' => null],

            'filter' =>                     ['type' => API_FILTER, 'flags' => API_ALLOW_NULL, 'default' => null, 'fields' => ['slaid', 'name', 'period', 'slo', 'effective_date', 'timezone', 'status']],

            'search' =>                     ['type' => API_FILTER, 'flags' => API_ALLOW_NULL, 'default' => null, 'fields' => ['name', 'timezone', 'description']],

            'searchByAny' =>                ['type' => API_BOOLEAN, 'default' => false],

            'startSearch' =>                ['type' => API_FLAG, 'default' => false],

            'excludeSearch' =>              ['type' => API_FLAG, 'default' => false],

            'searchWildcardsEnabled' =>     ['type' => API_BOOLEAN, 'default' => false],

            // output

            'output' =>                     ['type' => API_OUTPUT, 'in' => implode(',', ['slaid', 'name', 'period', 'slo', 'effective_date', 'timezone', 'status', 'description']), 'default' => API_OUTPUT_EXTEND],

            'countOutput' =>                ['type' => API_FLAG, 'default' => false],

            'selectServiceTags' =>          ['type' => API_OUTPUT, 'flags' => API_ALLOW_NULL | API_ALLOW_COUNT, 'in' => implode(',', ['tag', 'operator', 'value']), 'default' => null],

            'selectSchedule' =>             ['type' => API_OUTPUT, 'flags' => API_ALLOW_NULL | API_ALLOW_COUNT, 'in' => implode(',', ['period_from', 'period_to']), 'default' => null],

            'selectExcludedDowntimes' =>    ['type' => API_OUTPUT, 'flags' => API_ALLOW_NULL | API_ALLOW_COUNT, 'in' => implode(',', ['name', 'period_from', 'period_to']), 'default' => null],

            // sort and limit

            'sortfield' =>                  ['type' => API_STRINGS_UTF8, 'flags' => API_NORMALIZE, 'in' => implode(',', ['slaid', 'name', 'period', 'slo', 'effective_date', 'timezone', 'status', 'description']), 'uniq' => true, 'default' => []],

            'sortorder' =>                  ['type' => API_SORTORDER, 'default' => []],

            'limit' =>                      ['type' => API_INT32, 'flags' => API_ALLOW_NULL, 'in' => '1:'.ZBX_MAX_INT32, 'default' => null],

            // flags

            'editable' =>                   ['type' => API_BOOLEAN, 'default' => false],

            'preservekeys' =>               ['type' => API_BOOLEAN, 'default' => false]

        ]];

​

        if (!CApiInputValidator::validate($api_input_rules, $options, '/', $error)) {

            self::exception(ZBX_API_ERROR_PARAMETERS, $error);

        }

​

        $accessible_slaids = self::getAccessibleSlaids($options['slaids'], $options['serviceids']);

​

        $count_output = $options['countOutput'];

​

        if ($count_output) {

            $options['output'] = ['slaid'];

            $options['countOutput'] = false;

        }

​

        $resource = DBselect($this->createSelectQuery('sla', $options));

​

        $db_slas = [];

​

        while (($options['limit'] === null || count($db_slas) < $options['limit']) && $row = DBfetch($resource)) {

            if ($accessible_slaids !== null && !array_key_exists($row['slaid'], $accessible_slaids)) {