storedocumentbarcodetable.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\IntegerField;
use Bitrix\Main\ORM\Fields\Relations\Reference;
use Bitrix\Main\ORM\Fields\StringField;
use Bitrix\Main\ORM\Fields\Validators\LengthValidator;

 
class StoreDocumentBarcodeTable extends DataManager
{
    public static function getTableName()
    {
        return 'b_catalog_docs_barcode';
    }

    public static function getMap()
    {
        return [
            'ID' => new IntegerField(
                'ID',
                [
                    'primary' => true,
                    'autocomplete' => true,
                    'title' => Loc::getMessage('INVENTORY_DOCUMENT_BARCODE_ENTITY_ID_FIELD'),
                ]
            ),
            'DOC_ID' => new IntegerField(
                'DOC_ID',
                [
                    'required' => true,
                    'title' => Loc::getMessage('INVENTORY_DOCUMENT_BARCODE_ENTITY_DOC_ID_FIELD'),
                ]
            ),
            'DOC_ELEMENT_ID' => new IntegerField(
                'DOC_ELEMENT_ID',
                [
                    'required' => true,
                    'title' => Loc::getMessage('INVENTORY_DOCUMENT_BARCODE_ENTITY_DOC_ELEMENT_ID_FIELD'),
                ]
            ),
            'BARCODE' => new StringField(
                'BARCODE',
                [
                    'required' => true,
                    'validation' => function()
                        {
                            return [
                                new LengthValidator(null, 100),
                            ];
                        },
                    'title' => Loc::getMessage('INVENTORY_DOCUMENT_BARCODE_ENTITY_BARCODE_FIELD'),
                ]
            ),
            'DOCUMENT' => new Reference(
                'DOCUMENT',
                '\Bitrix\Catalog\StoreDocument',
                ['=this.DOC_ID' => 'ref.ID'],
                ['join_type' => 'LEFT']
            ),
            'DOCUMENT_ELEMENT' => new Reference(
                'DOCUMENT_ELEMENT',
                '\Bitrix\Catalog\StoreDocumentElement',
                ['=this.DOC_ELEMENT_ID' => '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);
    }
}