sectionvalues.php

<?php
namespace Bitrix\Iblock\InheritedProperty;
 
class SectionValues extends BaseValues
{
    protected $sectionId = 0;
    protected $queue = null;
 
    public function __construct($iblockId, $sectionId)
    {
        parent::__construct($iblockId);
        $this->sectionId = (int)$sectionId;
        $this->queue->addElement($this->iblockId, $this->sectionId);
    }
 
    public function getValueTableName()
    {
        return "b_iblock_section_iprop";
    }
 
    public function getType()
    {
        return "S";
    }
 
    public function getId()
    {
        return $this->sectionId;
    }
 
    public function  createTemplateEntity()
    {
        return new \Bitrix\Iblock\Template\Entity\Section($this->sectionId);
    }
 
    public function getParents()
    {
        $parents = array();
        $sectionList = \Bitrix\Iblock\SectionTable::getList(array(
            "select" => array("IBLOCK_SECTION_ID"),
            "filter" => array("=ID" => $this->sectionId),
        ));
        $section = $sectionList->fetch();
        if ($section && $section["IBLOCK_SECTION_ID"] > 0)
            $parents[] = new SectionValues($this->iblockId, $section["IBLOCK_SECTION_ID"]);
        else
            $parents[] = new IblockValues($this->iblockId);
        return $parents;
    }
 
    public function queryValues()
    {
        $connection = \Bitrix\Main\Application::getConnection();
        $result = array();
        if ($this->hasTemplates())
        {
            if ($this->queue->getElement($this->iblockId, $this->sectionId) === false)
            {
                $ids = $this->queue->get($this->iblockId);
                $query = $connection->query("
                SELECT
                    P.ID
                    ,P.CODE
                    ,P.TEMPLATE
                    ,P.ENTITY_TYPE
                    ,P.ENTITY_ID
                    ,IP.VALUE
                    ,IP.SECTION_ID
                FROM
                    b_iblock_section_iprop IP
                    INNER JOIN b_iblock_iproperty P ON P.ID = IP.IPROP_ID
                WHERE
                    IP.IBLOCK_ID = ".$this->iblockId."
                    AND IP.SECTION_ID in (".implode(", ", $ids).")
                ");
                $result = array();
                while ($row = $query->fetch())
                {
                    $result[$row["SECTION_ID"]][$row["CODE"]] = $row;
                }
                $this->queue->set($this->iblockId, $result);
            }
            $result = $this->queue->getElement($this->iblockId, $this->sectionId);
 
            if (empty($result))
            {
                $sqlHelper = $connection->getSqlHelper();
                $fields = array(
                    "IBLOCK_ID",
                    "SECTION_ID",
                    "IPROP_ID",
                    "VALUE",
                );
                $rows = array();
                $result = parent::queryValues();
                foreach ($result as $row)
                {
                    $rows[] = array(
                        $this->iblockId,
                        $this->sectionId,
                        $row["ID"],
                        $sqlHelper->forSql($row["VALUE"]),
                    );
                }
                $this->insertValues("b_iblock_section_iprop", $fields, $rows);
            }
        }
        return $result;
    }
 
    function clearValues()
    {
        $connection = \Bitrix\Main\Application::getConnection();
        $sectionList = \Bitrix\Iblock\SectionTable::getList(array(
            "select" => array("LEFT_MARGIN", "RIGHT_MARGIN"),
            "filter" => array("=ID" => $this->sectionId),
        ));
        $section = $sectionList->fetch();
        if ($section)
        {
            $connection->query("
                DELETE FROM b_iblock_element_iprop
                WHERE IBLOCK_ID = ".$this->iblockId."
                AND ELEMENT_ID in (
                    SELECT BSE.IBLOCK_ELEMENT_ID
                    FROM b_iblock_section_element BSE
                    INNER JOIN b_iblock_section BS ON BSE.IBLOCK_SECTION_ID = BS.ID AND BSE.ADDITIONAL_PROPERTY_ID IS NULL
                    WHERE BS.IBLOCK_ID = ".$this->iblockId."
                    AND BS.LEFT_MARGIN <= ".$section["RIGHT_MARGIN"]."
                    AND BS.RIGHT_MARGIN >= ".$section["LEFT_MARGIN"]."
                )
            ");
            $connection->query("
                DELETE FROM b_iblock_section_iprop
                WHERE IBLOCK_ID = ".$this->iblockId."
                AND SECTION_ID in (
                    SELECT BS.ID
                    FROM b_iblock_section BS
                    WHERE BS.IBLOCK_ID = ".$this->iblockId."
                    AND BS.LEFT_MARGIN <= ".$section["RIGHT_MARGIN"]."
                    AND BS.RIGHT_MARGIN >= ".$section["LEFT_MARGIN"]."
                )
            ");
        }
        ValuesQueue::deleteAll();
    }
}