storedocumentelementtable.php

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

<?php
namespace Bitrix\Catalog;
 
use Bitrix\Main\Application;
use Bitrix\Main\Localization\Loc;
use Bitrix\Main\ORM\Data\DataManager;
use Bitrix\Main\ORM\Fields\EnumField;
use Bitrix\Main\ORM\Fields\FloatField;
use Bitrix\Main\ORM\Fields\IntegerField;
use Bitrix\Main\ORM\Fields\Relations\Reference;
use Bitrix\Main\ORM\Fields\StringField;

 
class StoreDocumentElementTable extends DataManager
{
    public const EXTRA_RATE_PERCENTAGE = 1;
    public const EXTRA_RATE_MONETARY = 2;
    public static function getTableName()
    {
        return 'b_catalog_docs_element';
    }

    public static function getMap()
    {
        return [
            'ID' => new IntegerField(
                'ID',
                [
                    'primary' => true,
                    'autocomplete' => true,
                    'title' => Loc::getMessage('INVENTORY_DOCUMENT_ELEMENT_ENTITY_ID_FIELD'),
                ]
            ),
            'DOC_ID' => new IntegerField(
                'DOC_ID',
                [
                    'required' => true,
                    'title' => Loc::getMessage('INVENTORY_DOCUMENT_ELEMENT_ENTITY_DOC_ID_FIELD'),
                ]
            ),
            'STORE_FROM' => new IntegerField(
                'STORE_FROM',
                [
                    'title' => Loc::getMessage('INVENTORY_DOCUMENT_ELEMENT_ENTITY_STORE_FROM_FIELD'),
                ]
            ),
            'STORE_TO' => new IntegerField(
                'STORE_TO',
                [
                    'title' => Loc::getMessage('INVENTORY_DOCUMENT_ELEMENT_ENTITY_STORE_TO_FIELD'),
                ]
            ),
            'ELEMENT_ID' => new IntegerField(
                'ELEMENT_ID',
                [
                    'title' => Loc::getMessage('INVENTORY_DOCUMENT_ELEMENT_ENTITY_ELEMENT_ID_FIELD'),
                ]
            ),
            'AMOUNT' => new FloatField(
                'AMOUNT',
                [
                    'title' => Loc::getMessage('INVENTORY_DOCUMENT_ELEMENT_ENTITY_AMOUNT_FIELD'),
                ]
            ),
            'PURCHASING_PRICE' => new IntegerField(
                'PURCHASING_PRICE',
                [
                    'title' => Loc::getMessage('INVENTORY_DOCUMENT_ELEMENT_ENTITY_PURCHASING_PRICE_FIELD'),
                ]
            ),
            'BASE_PRICE' => new IntegerField(
                'BASE_PRICE',
                [
                    'title' => Loc::getMessage('INVENTORY_DOCUMENT_ELEMENT_ENTITY_BASE_PRICE_FIELD'),
                ]
            ),
            'BASE_PRICE_EXTRA' => new FloatField(
                'BASE_PRICE_EXTRA',
                [
                    'title' => Loc::getMessage('INVENTORY_DOCUMENT_ELEMENT_ENTITY_BASE_PRICE_EXTRA_FIELD'),
                ]
            ),
            'BASE_PRICE_EXTRA_RATE' => new EnumField(
                'BASE_PRICE_EXTRA_RATE',
                [
                    'title' => Loc::getMessage('INVENTORY_DOCUMENT_ELEMENT_ENTITY_BASE_PRICE_EXTRA_RATE_FIELD'),
                    'values' => [
                        self::EXTRA_RATE_PERCENTAGE, self::EXTRA_RATE_MONETARY
                    ],
                    'default_value' => self::EXTRA_RATE_PERCENTAGE,
                ]
            ),
            'COMMENT' => new StringField(
                'COMMENT',
                [
                    'title' => Loc::getMessage('INVENTORY_DOCUMENT_ELEMENT_ENTITY_COMMENT_FIELD'),
                ]
            ),
            'ELEMENT' => new Reference(
                'ELEMENT',
                '\Bitrix\Iblock\Element',
                ['=this.ELEMENT_ID' => 'ref.ID'],
                ['join_type' => 'LEFT']
            ),
            'PRODUCT' => new Reference(
                'PRODUCT',
                '\Bitrix\Catalog\Product',
                ['=this.ELEMENT_ID' => 'ref.ID'],
                ['join_type' => 'LEFT']
            ),
            'DOCUMENT' => new Reference(
                'DOCUMENT',
                '\Bitrix\Catalog\StoreDocument',
                ['=this.DOC_ID' => 'ref.ID'],
                ['join_type' => 'LEFT']
            ),
            'STORE_FROM_REF' => new Reference(
                'STORE_FROM_REF',
                '\Bitrix\Catalog\StoreTable',
                ['=this.STORE_FROM' => 'ref.ID'],
                ['join_type' => 'LEFT']
            ),
            'STORE_TO_REF' => new Reference(
                'STORE_TO_REF',
                '\Bitrix\Catalog\StoreTable',
                ['=this.STORE_TO' => 'ref.ID'],
                ['join_type' => 'LEFT']
            ),
        ];
    }

    public static function deleteByDocument(int $id): void
    {
        if ($id <= 0)
        {
            return;
        }
 
        $conn = Application::getConnection();
        $helper = $conn->getSqlHelper();
        $conn->queryExecute(
            'delete from ' . $helper->quote(self::getTableName())
            . ' where ' . $helper->quote('DOC_ID') . ' = ' . $id
        );
        unset($helper, $conn);
    }
}