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

**/

​

​

/**

 * Container class for favorite value management.

 * Uses caching.

 */

class CFavorite {

​

    /**

     * Cache for favorite values.

     *

     * $cache[idx][]['value']

     * $cache[idx][]['source']

     */

    private static $cache = null;

​

    /**

     * Returns favorite values from db. Uses caching for performance.

     *

     * @param string $idx identifier of favorite value group

     *

     * @return array list of favorite values corresponding to $idx

     */

    public static function get($idx) {

        // return values if cached

        if (isset(self::$cache[$idx])) {

            return self::$cache[$idx];

        }

​

        $result = [];

        $db_profiles = DBselect(

            'SELECT p.value_id,p.source'.

            ' FROM profiles p'.

            ' WHERE p.userid='.CWebUser::$data['userid'].

                ' AND p.idx='.zbx_dbstr($idx).

            ' ORDER BY p.profileid'

        );

        while ($profile = DBfetch($db_profiles)) {

            $result[] = ['value' => $profile['value_id'], 'source' => $profile['source']];

        }

​

        // store db values in cache

        self::$cache[$idx] = $result;

​

        return $result;

    }

​

    /**

     * Adds favorite value to DB.