Zabbix

<?php

/*

** Zabbix

** Copyright (C) 2001-2023 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.

**/

​

​

/**

 * 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;

​