iblocktype.php

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

<?php
 
use Bitrix\Iblock;
use Bitrix\Main\Localization\Loc;

class CIBlockType
{
    public string $LAST_ERROR = '';
    public static function GetList($arOrder = array("SORT" => "ASC"), $arFilter = array())
    {
        global $DB;
        global $CACHE_MANAGER;
        $bLang = false;
        $bNameSort = false;
        $strSqlSearch = "1=1\n";
 
        foreach ($arFilter as $key => $val)
        {
            if (!is_array($val) && $val == '')
                continue;
 
            switch(mb_strtoupper($key))
            {
                case "ID":
                    $strSqlSearch .= "AND UPPER(T.ID) LIKE UPPER('".$DB->ForSql($val)."')\n";
                    break;
 
                case "=ID":
                    if(is_array($val))
                    {
                        if(!empty($val))
                        {
                            $sqlVal = array_map(array($DB, 'ForSQL'), $val);
                            $strSqlSearch .= "AND T.ID in ('".implode("', '", $sqlVal)."')\n";
                        }
                    }
                    else
                    {
                        $strSqlSearch .= "AND T.ID = '".$DB->ForSql($val)."'\n";
                    }
                    break;
 
                case "NAME":
                    $strSqlSearch .= "AND UPPER(TL.NAME) LIKE UPPER('%".$DB->ForSql($val)."%')\n";
                    $bLang = true;
                    break;
                case "LANGUAGE_ID":
                    $strSqlSearch .= "AND TL.LID = '".$DB->ForSql($val)."'\n";
                    $bLang = true;
                    break;
            }
        }
 
        $strSqlOrder = '';
        foreach ($arOrder as $by => $order)
        {
            $by = mb_strtoupper($by);
            if ($by == "ID")
                $by = "T.ID";
            elseif ($by == "NAME")
            {
                $by = "TL.NAME";
                $bLang = true;
                $bNameSort = true;
            }
            else
                $by = "T.SORT";
 
            $order = mb_strtolower($order);
            if ($order != "desc")
                $order = "asc";
 
            if ($strSqlOrder == '')
                $strSqlOrder = " ORDER BY ";
            else
                $strSqlOrder .= ', ';
 
            $strSqlOrder .= $by." ".$order;
        }
 
        $strSql = "
            SELECT ".($bLang ? "DISTINCT" : "")." T.*".($bNameSort ? ",TL.NAME" : "")."
            FROM b_iblock_type T
            ".($bLang ? " LEFT JOIN b_iblock_type_lang TL ON TL.IBLOCK_TYPE_ID = T.ID " : "")."
            WHERE ".$strSqlSearch.$strSqlOrder;
 
        if (CACHED_b_iblock_type === false)
        {
            $res = $DB->Query($strSql);
        }
        else
        {
            if ($CACHE_MANAGER->Read(CACHED_b_iblock_type, $cache_id = "b_iblock_type".md5($strSql), "b_iblock_type"))
            {
                $arResult = $CACHE_MANAGER->Get($cache_id);
            }
            else
            {
                $arResult = array();
                $res = $DB->Query($strSql);
                while ($ar = $res->Fetch())
                    $arResult[] = $ar;
 
                $CACHE_MANAGER->Set($cache_id, $arResult);
            }
            $res = new CDBResult;
            $res->InitFromArray($arResult);
        }
        return $res;
    }

    protected static function _GetCache($ID)
    {
        global $DB;
        global $CACHE_MANAGER;
 
        $ID = trim((string)$ID);
        if ($ID === '')
        {
            return false;
        }
 
        if ($CACHE_MANAGER->Read(CACHED_b_iblock_type, "b_iblock_type", Iblock\TypeTable::getTableName()))
        {
            $arIBlocks = $CACHE_MANAGER->Get("b_iblock_type");
        }
        else
        {
            $arIBlocks = [];
            $rs = $DB->Query("SELECT * FROM b_iblock_type");
            while ($ar = $rs->GetNext())
            {
                $ar["_lang"] = [];
                $arIBlocks[$ar['ID']] = $ar;
            }
            $rs = $DB->Query("SELECT * FROM b_iblock_type_lang");
            while ($ar = $rs->GetNext())
            {
                if (array_key_exists($ar['IBLOCK_TYPE_ID'], $arIBlocks))
                {
                    $arIBlocks[$ar['IBLOCK_TYPE_ID']]["_lang"][$ar["LID"]] = $ar;
                }
            }
            $CACHE_MANAGER->Set("b_iblock_type", $arIBlocks);
        }
 
        return $arIBlocks[$ID] ?? false;
    }

    public static function GetByID($ID)
    {
        if (CACHED_b_iblock_type === false)
        {
            return CIBlockType::GetList(
                [],
                [
                    '=ID' => $ID,
                ]
            );
        }
        else
        {
            $arResult = CIBlockType::_GetCache($ID);
            $res = new CDBResult;
            if ($arResult !== false && isset($arResult["ID"]))
            {
                unset($arResult["_lang"]);
                $res->InitFromArray([$arResult]);
            }
            else
            {
                $res->InitFromArray([]);
            }
 
            return $res;
        }
    }

    public static function GetByIDLang($ID, $LID, $bFindAny = true)
    {
        global $DB;
        $LID = $DB->ForSQL($LID, 2);
 
        if (CACHED_b_iblock_type === false)
        {
            $strSql = "
                SELECT BTL.*, BT.*
                FROM b_iblock_type BT, b_iblock_type_lang BTL
                WHERE BTL.IBLOCK_TYPE_ID = '".$DB->ForSQL($ID)."'
                AND BTL.LID='".$LID."'
                AND BT.ID=BTL.IBLOCK_TYPE_ID
            ";
            $res = $DB->Query($strSql);
            if ($r = $res->GetNext())
                return $r;
        }
        else
        {
            $arResult = CIBlockType::_GetCache($ID);
            if ($arResult !== false && array_key_exists($LID, $arResult["_lang"]))
            {
                $res = $arResult["_lang"][$LID];
                unset($arResult["_lang"]);
                return array_merge($res, $arResult);
            }
        }
 
        if (!$bFindAny)
            return false;
 
        $strSql = "
            SELECT BTL.*, BT.*
            FROM b_iblock_type BT, b_iblock_type_lang BTL, b_language L
            WHERE BTL.IBLOCK_TYPE_ID = '".$DB->ForSQL($ID)."'
            AND BTL.LID = L.LID
            AND BT.ID=BTL.IBLOCK_TYPE_ID
            ORDER BY L.DEF DESC, L.SORT
        ";
        $res = $DB->Query($strSql);
        if ($r = $res->GetNext())
            return $r;
 
        return false;
    }

    public static function Delete($ID)
    {
        global $DB;
 
        Iblock\TypeTable::cleanCache();
 
        $iblocks = CIBlock::GetList(array(), array(
            "=TYPE" => $ID,
        ));
        while ($iblock = $iblocks->Fetch())
        {
            if (!CIBlock::Delete($iblock["ID"]))
            {
                return false;
            }
        }
 
        if (!$DB->Query("DELETE FROM b_iblock_type_lang WHERE IBLOCK_TYPE_ID='".$DB->ForSql($ID)."'", true))
        {
            return false;
        }
 
        return $DB->Query("DELETE FROM b_iblock_type WHERE ID='".$DB->ForSql($ID)."'", true);
    }

    public function CheckFields($arFields, $ID = false)
    {
        global $DB;
        $this->LAST_ERROR = '';
 
        if ($ID === false)
        {
            if (!isset($arFields["ID"]) || $arFields["ID"] == '')
            {
                $this->LAST_ERROR .= Loc::getMessage("IBLOCK_TYPE_BAD_ID")."<br>";
            }
            elseif (preg_match("/[^A-Za-z0-9_]/", $arFields["ID"]))
            {
                $this->LAST_ERROR .= Loc::getMessage("IBLOCK_TYPE_ID_HAS_WRONG_CHARS")."<br>";
            }
            else
            {
                $chk = $DB->Query("SELECT 'x' FROM b_iblock_type WHERE ID='".$DB->ForSQL($arFields["ID"])."'");
                if ($chk->Fetch())
                {
                    $this->LAST_ERROR .= Loc::getMessage("IBLOCK_TYPE_DUBL_ID")."<br>";
                    return false;
                }
            }
            if (empty($arFields["LANG"]) || !is_array($arFields["LANG"]))
            {
                $this->LAST_ERROR .= Loc::getMessage("IBLOCK_TYPE_EMPTY_NAMES")."<br>";
                return false;
            }
        }
 
        if (!empty($arFields['LANG']) && is_array($arFields['LANG']))
        {
            foreach ($arFields["LANG"] as $lid => $arFieldsLang)
            {
                if ($arFieldsLang["NAME"] == '')
                {
                    $this->LAST_ERROR .= Loc::getMessage("IBLOCK_TYPE_BAD_NAME")." ".$lid.".<br>";
                }
            }
        }
 
        return $this->LAST_ERROR === '';
    }

    public function Add($arFields)
    {
        global $DB;
 
        $arFields["SECTIONS"] = isset($arFields["SECTIONS"]) && $arFields["SECTIONS"] === "Y" ? "Y" : "N";
        $arFields["IN_RSS"] = isset($arFields["IN_RSS"]) && $arFields["IN_RSS"] === "Y" ? "Y" : "N";
 
        if (!$this->CheckFields($arFields))
        {
            return false;
        }
 
        $arInsert = $DB->PrepareInsert("b_iblock_type", $arFields);
        $DB->Query("INSERT INTO b_iblock_type(".$arInsert[0].") VALUES(".$arInsert[1].")");
 
        if (isset($arFields["LANG"]))
        {
            $this->SetLang($arFields["ID"], $arFields["LANG"]);
        }
 
        Iblock\TypeTable::cleanCache();
 
        return $arFields["ID"];
    }

    public function Update($ID, $arFields)
    {
        global $DB;
 
        $arFields["SECTIONS"] = $arFields["SECTIONS"] == "Y" ? "Y" : "N";
        $arFields["IN_RSS"] = $arFields["IN_RSS"] == "Y" ? "Y" : "N";
 
        if (!$this->CheckFields($arFields, $ID))
        {
            return false;
        }
 
        $str_update = $DB->PrepareUpdate("b_iblock_type", $arFields);
        $DB->Query("UPDATE b_iblock_type SET ".$str_update." WHERE ID='".$DB->ForSQL($ID)."'");
 
        if (isset($arFields["LANG"]))
        {
            $this->SetLang($ID, $arFields["LANG"]);
        }
 
        Iblock\TypeTable::cleanCache();
 
        return true;
    }

    protected static function SetLang($ID, $arLang)
    {
        global $DB;
 
        if (is_array($arLang))
        {
            $DB->Query("DELETE FROM b_iblock_type_lang WHERE IBLOCK_TYPE_ID='".$DB->ForSQL($ID)."'");
            foreach ($arLang as $lid => $arFieldsLang)
            {
                $name = (string)($arFieldsLang['NAME'] ?? '');
                $elementName = (string)($arFieldsLang['ELEMENT_NAME'] ?? '');
                $sectionName = (string)($arFieldsLang['SECTION_NAME'] ?? '');
                if ($name !== '' || $elementName !== '')
                {
                    $DB->Query("
                        INSERT INTO b_iblock_type_lang(IBLOCK_TYPE_ID, LID, NAME, SECTION_NAME, ELEMENT_NAME)
                        SELECT
                            BT.ID,
                            L.LID,
                            '".$DB->ForSql($name, 100)."',
                            '".$DB->ForSql($sectionName, 100)."',
                            '".$DB->ForSql($elementName, 100)."'
                        FROM
                            b_iblock_type BT,
                            b_language L
                        WHERE
                            BT.ID = '".$DB->ForSQL($ID)."'
                            AND L.LID = '".$DB->ForSQL($lid)."'
                    ");
                }
            }
        }
    }

    public function getLastError(): string
    {
        return $this->LAST_ERROR;
    }
}