Zabbix

<?php

/*

** Zabbix

** Copyright (C) 2001-2022 Zabbix SIA

**

** This program is free software; you can redistribute it and/or modify

** it under the terms of the GNU General Public License as published by

** the Free Software Foundation; either version 2 of the License, or

** (at your option) any later version.

**

** 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 General Public License for more details.

**

** You should have received a copy of the GNU General Public License

** along with this program; if not, write to the Free Software

** Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.

**/

​

​

/**

 * 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_OBJECT, 'flags' => API_ALLOW_NULL, 'default' => null, 'fields' => [

                'valuemapid' =>             ['type' => API_IDS, 'flags' => API_ALLOW_NULL | API_NORMALIZE],

                'hostid' =>                 ['type' => API_IDS, 'flags' => API_ALLOW_NULL | API_NORMALIZE],

                'name' =>                   ['type' => API_STRINGS_UTF8, 'flags' => API_ALLOW_NULL | API_NORMALIZE]

            ]],

            'search' =>                 ['type' => API_OBJECT, 'flags' => API_ALLOW_NULL, 'default' => null, 'fields' => [

                'name' =>                   ['type' => API_STRINGS_UTF8, 'flags' => API_ALLOW_NULL | API_NORMALIZE]

            ]],

            '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) {

            $permission = $options['editable'] ? PERM_READ_WRITE : PERM_READ;

            $userGroups = getUserGroupsByUserId(self::$userData['userid']);

​

            $sql_parts['where'][] = 'EXISTS ('.

                'SELECT NULL'.

                ' FROM hosts_groups hgg'.

                    ' JOIN rights r'.

                        ' ON r.id=hgg.groupid'.

                            ' AND '.dbConditionInt('r.groupid', $userGroups).

                ' WHERE vm.hostid=hgg.hostid'.