Zabbix

<?php

/*

** 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/>.

**/

​

​

/**

 * Class containing methods for operations with value maps.

 */

class CValueMap extends CApiService {

​

    public const ACCESS_RULES = [

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

        'create' => ['min_user_type' => USER_TYPE_ZABBIX_ADMIN],

        'update' => ['min_user_type' => USER_TYPE_ZABBIX_ADMIN],

        'delete' => ['min_user_type' => USER_TYPE_ZABBIX_ADMIN]

    ];

​

    protected $tableName = 'valuemap';

    protected $tableAlias = 'vm';

    protected $sortColumns = ['valuemapid', 'name'];

​

    /**

     * Get value maps.

     *

     * @param array  $options

     *

     * @return array

     */

    public function get($options = []) {

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

            // filter

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

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

            'filter' =>                 ['type' => API_FILTER, 'flags' => API_ALLOW_NULL, 'default' => null, 'fields' => ['valuemapid', 'hostid', 'name']],

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

            '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(',', ['valuemapid', 'uuid', 'name', 'hostid']), 'default' => API_OUTPUT_EXTEND],

            'selectMappings' =>         ['type' => API_OUTPUT, 'flags' => API_ALLOW_NULL | API_ALLOW_COUNT, 'in' => implode(',', ['type', 'value', 'newvalue']), 'default' => null],

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

            // sort and limit

            'sortfield' =>              ['type' => API_STRINGS_UTF8, 'flags' => API_NORMALIZE, 'in' => implode(',', $this->sortColumns), '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);

        }

​

        $db_valuemaps = [];

        $sql_parts = $this->createSelectQueryParts($this->tableName(), $this->tableAlias(), $options);

​

        // Permission check.

        if (self::$userData['type'] != USER_TYPE_SUPER_ADMIN) {

            if (self::$userData['ugsetid'] == 0) {

                return $options['countOutput'] ? '0' : [];

            }

​

            $sql_parts['from'][] = 'host_hgset hh';

            $sql_parts['from'][] = 'permission p';

            $sql_parts['where'][] = 'vm.hostid=hh.hostid';

            $sql_parts['where'][] = 'hh.hgsetid=p.hgsetid';

            $sql_parts['where'][] = 'p.ugsetid='.self::$userData['ugsetid'];

​

            if ($options['editable']) {

                $sql_parts['where'][] = 'p.permission='.PERM_READ_WRITE;

            }

        }

​

        // hostids

        if ($options['hostids'] !== null) {

            $sql_parts['where']['hostid'] = dbConditionInt('vm.hostid', $options['hostids']);

        }

​