group.php

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

<?php
 
namespace Bitrix\Catalog;
 
use Bitrix\Main;
use Bitrix\Main\ORM;
use Bitrix\Main\Localization\Loc;

 
class GroupTable extends ORM\Data\DataManager
{
    public static function getTableName(): string
    {
        return 'b_catalog_group';
    }

    public static function getMap(): array
    {
        return [
            'ID' => new ORM\Fields\IntegerField(
                'ID',
                [
                    'primary' => true,
                    'autocomplete' => true,
                    'title' => Loc::getMessage('GROUP_ENTITY_ID_FIELD'),
                ]
            ),
            'NAME' => new ORM\Fields\StringField(
                'NAME',
                [
                    'required' => true,
                    'validation' => function()
                    {
                        return [
                            new ORM\Fields\Validators\LengthValidator(null, 100),
                        ];
                    },
                    'title' => Loc::getMessage('GROUP_ENTITY_NAME_FIELD'),
                ]
            ),
            'BASE' => new ORM\Fields\BooleanField(
                'BASE',
                [
                    'values' => [
                        'N',
                        'Y',
                    ],
                    'title' => Loc::getMessage('GROUP_ENTITY_BASE_FIELD'),
                ]
            ),
            'SORT' => new ORM\Fields\IntegerField(
                'SORT',
                [
                    'title' => Loc::getMessage('GROUP_ENTITY_SORT_FIELD'),
                ]
            ),
            'XML_ID' => new ORM\Fields\StringField(
                'XML_ID',
                [
                    'validation' => function()
                    {
                        return [
                            new ORM\Fields\Validators\LengthValidator(null, 255),
                        ];
                    },
                    'title' => Loc::getMessage('GROUP_ENTITY_XML_ID_FIELD'),
                ]
            ),
            'TIMESTAMP_X' => new ORM\Fields\DatetimeField(
                'TIMESTAMP_X',
                [
                    'title' => Loc::getMessage('GROUP_ENTITY_TIMESTAMP_X_FIELD'),
                    'default_value' => function()
                    {
                        return new Main\Type\DateTime();
                    },
                ]
            ),
            'MODIFIED_BY' => new ORM\Fields\IntegerField(
                'MODIFIED_BY',
                [
                    'title' => Loc::getMessage('GROUP_ENTITY_MODIFIED_BY_FIELD'),
                ]
            ),
            'DATE_CREATE' => new ORM\Fields\DatetimeField(
                'DATE_CREATE',
                [
                    'title' => Loc::getMessage('GROUP_ENTITY_DATE_CREATE_FIELD'),
                    'default_value' => function()
                    {
                        return new Main\Type\DateTime();
                    },
                ]
            ),
            'CREATED_BY' => new ORM\Fields\IntegerField(
                'CREATED_BY',
                [
                    'title' => Loc::getMessage('GROUP_ENTITY_CREATED_BY_FIELD'),
                ]
            ),
            'CREATED_BY_USER' => new ORM\Fields\Relations\Reference(
                'CREATED_BY_USER',
                '\Bitrix\Main\User',
                ['=this.CREATED_BY' => 'ref.ID']
            ),
            'MODIFIED_BY_USER' => new ORM\Fields\Relations\Reference(
                'MODIFIED_BY_USER',
                '\Bitrix\Main\User',
                ['=this.MODIFIED_BY' => 'ref.ID']
            ),
            'LANG' => new ORM\Fields\Relations\Reference(
                'LANG',
                '\Bitrix\Catalog\GroupLang',
                ['=this.ID' => 'ref.CATALOG_GROUP_ID']
            ),
            'CURRENT_LANG' => new ORM\Fields\Relations\Reference(
                'CURRENT_LANG',
                '\Bitrix\Catalog\GroupLang',
                [
                    '=this.ID' => 'ref.CATALOG_GROUP_ID',
                    '=ref.LANG' => new Main\DB\SqlExpression('?', LANGUAGE_ID)
                ],
                ['join_type' => 'LEFT']
            )
        ];
    }

    public static function onAfterAdd(ORM\Event $event): void
    {
        Model\Price::clearSettings();
    }

    public static function onAfterUpdate(ORM\Event $event): void
    {
        Model\Price::clearSettings();
    }

    public static function onAfterDelete(ORM\Event $event): void
    {
        Model\Price::clearSettings();
    }

    public static function getBasePriceType(): ?array
    {
        $row = self::getRow([
            'select' => [
                'ID',
                'NAME',
                'BASE',
                'SORT',
                'XML_ID',
            ],
            'filter' => [
                '=BASE' => 'Y',
            ],
            'cache' => [
                'ttl' => 86400,
            ],
        ]);
        if ($row === null)
        {
            return null;
        }
 
        $row['NAME_LANG'] = null;
        $title = GroupLangTable::getRow([
            'select' => [
                'NAME',
            ],
            'filter' => [
                '=CATALOG_GROUP_ID' => $row['ID'],
                '=LANG' => LANGUAGE_ID,
            ],
            'cache' => [
                'ttl' => 86400,
            ],
        ]);
        if ($title !== null)
        {
            if ($title['NAME'] === '')
            {
                $title['NAME'] = null;
            }
            $row['NAME_LANG'] = $title['NAME'];
        }
 
        return $row;
    }

    public static function getBasePriceTypeId(): ?int
    {
        $row = self::getBasePriceType();
 
        return $row === null ? null : $row['ID'];
    }

    public static function getTypeList(): array
    {
        $result = [];
 
        $ids = [];
        $iterator = self::getList([
            'select' => [
                'ID',
                'NAME',
                'BASE',
                'SORT',
                'XML_ID',
            ],
            'order' => [
                'SORT' => 'ASC',
                'ID' => 'ASC',
            ],
            'cache' => [
                'ttl' => 86400,
            ],
        ]);
        while ($row = $iterator->fetch())
        {
            $row['ID'] = (int)$row['ID'];
            $row['SORT'] = (int)$row['SORT'];
            $row['NAME_LANG'] = null;
 
            $result[$row['ID']] = $row;
            $ids[] = $row['ID'];
        }
        unset($row, $groupIterator);
        if (empty($result))
        {
            return $result;
        }
 
        foreach (array_chunk($ids, CATALOG_PAGE_SIZE) as $pageIds)
        {
            $langIterator = GroupLangTable::getList([
                'select' => [
                    'CATALOG_GROUP_ID',
                    'NAME',
                ],
                'filter' => [
                    '@CATALOG_GROUP_ID' => $pageIds,
                    '=LANG' => LANGUAGE_ID,
                ],
                'cache' => [
                    'ttl' => 86400,
                ],
            ]);
            while ($row = $langIterator->fetch())
            {
                $id = (int)$row['CATALOG_GROUP_ID'];
                $result[$id]['NAME_LANG'] = $row['NAME'] === '' ? null : $row['NAME'];
            }
            unset(
                $row,
                $langIterator,
            );
        }
        unset(
            $pageIds,
            $ids,
        );
 
        return $result;
    }
}