option.php

См. документацию.

<?php
class CBitrixCloudOption
{
    private $name = '';
    private $value = /*.(array[string]string).*/ null;

    public function __construct($name)
    {
        $this->name = $name;
    }

    public static function getOption($name)
    {
        $ob = new CBitrixCloudOption($name);
        return $ob;
    }

    private function _read_db()
    {
        global $DB;
        $result = /*.(array[string]string).*/ [];
        $rs = $DB->Query("
            select PARAM_KEY, PARAM_VALUE
            from b_bitrixcloud_option
            where NAME = '" . $DB->ForSQL($this->name) . "'
            order by SORT
        ");
        while (is_array($ar = $rs->Fetch()))
        {
            $key = $ar['PARAM_KEY'];
            $result[$key] = $ar['PARAM_VALUE'];
        }
        return $result;
    }

    private function _read_all_db()
    {
        global $DB;
        $result = /*.(array[string][string]string).*/ [];
        $rs = $DB->Query('
            select NAME, PARAM_KEY, PARAM_VALUE
            from b_bitrixcloud_option
            order by NAME, SORT
        ');
        while (is_array($ar = $rs->Fetch()))
        {
            $name = $ar['NAME'];
            $key = $ar['PARAM_KEY'];
            $result[$name][$key] = $ar['PARAM_VALUE'];
        }
        return $result;
    }

    private function _delete_db()
    {
        global $DB;
        $DB->Query("
            delete
            from b_bitrixcloud_option
            where NAME = '" . $DB->ForSQL($this->name) . "'
        ");
    }

    private function _write_db($value)
    {
        global $DB;
        if (is_array($value))
        {
            $sort = 0;
            foreach ($value as $key => $val)
            {
                $DB->Add('b_bitrixcloud_option', [
                    'NAME' => $this->name,
                    'SORT' => (string)$sort,
                    'PARAM_KEY' => $key,
                    'PARAM_VALUE' => $val,
                ]);
                $sort++;
            }
        }
    }

    private function _update_db($value)
    {
        global $DB;
        if (!is_array($value))
        {
            $value = [];
        }
 
        reset($value);
        $rs = $DB->Query("
            select ID, SORT, PARAM_KEY, PARAM_VALUE
            from b_bitrixcloud_option
            where NAME = '" . $DB->ForSQL($this->name) . "'
            order by ID
        ");
 
        $sort = 0;
        foreach ($value as $key => $val)
        {
            if ($db_row = $rs->fetch())
            {
                if (
                    (string)$db_row['PARAM_VALUE'] !== (string)$val
                    || (string)$db_row['PARAM_KEY'] !== (string)$key
                    || (string)$db_row['SORT'] !== (string)$sort
                )
                {
                    $DB->Query("
                        UPDATE b_bitrixcloud_option SET
                            PARAM_KEY = '" . $DB->ForSql($key, 50) . "'
                            ,PARAM_VALUE = '" . $DB->ForSql($val, 200) . "'
                            ,SORT = " . $sort . '
                        WHERE ID = ' . $db_row['ID'] . '
                    ');
                }
            }
            else
            {
                $DB->Add('b_bitrixcloud_option', [
                    'NAME' => $this->name,
                    'SORT' => (string)$sort,
                    'PARAM_KEY' => $key,
                    'PARAM_VALUE' => $val,
                ]);
            }
            $sort++;
        }
 
        if ($db_row = $rs->fetch())
        {
            $DB->Query("
                DELETE FROM b_bitrixcloud_option
                WHERE NAME = '" . $DB->ForSql($this->name, 50) . "'
                AND ID >= " . $db_row['ID'] . '
            ');
        }
    }

    public function isExists()
    {
        return (count($this->_read_db()) > 0);
    }

    public function getArrayValue()
    {
        global $CACHE_MANAGER;
        if ($this->name === '')
        {
            return /*.(array[string]string).*/ [];
        }
 
        if (!isset($this->value))
        {
            if (CACHED_b_bitrixcloud_option <= 0)
            {
                $this->value = $this->_read_db();
            }
            else
            {
                if (!$CACHE_MANAGER->Read(CACHED_b_bitrixcloud_option, 'b_bitrixcloud_option'))
                {
                    $arOptions = $this->_read_all_db();
                    $CACHE_MANAGER->Set('b_bitrixcloud_option', $arOptions);
                }
                else
                {
                    $arOptions = $CACHE_MANAGER->Get('b_bitrixcloud_option');
                }
                if (array_key_exists($this->name, $arOptions))
                {
                    $this->value = $arOptions[$this->name];
                }
                else
                {
                    $this->value = /*.(array[string]string).*/ [];
                }
            }
        }
        return $this->value;
    }

    public function getStringValue()
    {
        $value = $this->getArrayValue();
        return (string)current($value);
    }

    public function getIntegerValue()
    {
        $value = $this->getArrayValue();
        return (integer)current($value);
    }

    public function setArrayValue($value)
    {
        global $CACHE_MANAGER;
        if ($this->name !== '')
        {
            $stored = $this->getArrayValue();
            if ($stored !== $value)
            {
                $this->value = null;
                $this->_update_db($value);
                if (CACHED_b_bitrixcloud_option !== false)
                {
                    $CACHE_MANAGER->Clean('b_bitrixcloud_option');
                }
            }
        }
    }

    public function setStringValue($value)
    {
        $this->setArrayValue([
            '0' => $value,
        ]);
    }

    public function delete()
    {
        $this->setArrayValue(/*.(array[string]string).*/ []);
    }
}