extra.php

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

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

 
class ExtraTable extends ORM\Data\DataManager
{
    public static function getTableName()
    {
        return 'b_catalog_extra';
    }

    public static function getMap()
    {
        return [
            'ID' => new ORM\Fields\IntegerField(
                'ID',
                [
                    'primary' => true,
                    'autocomplete' => true,
                    'title' => Loc::getMessage('EXTRA_ENTITY_ID_FIELD'),
                ]
            ),
            'NAME' => new ORM\Fields\StringField(
                'NAME',
                [
                    'required' => true,
                    'validation' =>  function()
                    {
                        return [
                            new ORM\Fields\Validators\LengthValidator(null, 50),
                        ];
                    },
                    'title' => Loc::getMessage('EXTRA_ENTITY_NAME_FIELD'),
                ]
            ),
            'PERCENTAGE' => new ORM\Fields\FloatField(
                'PERCENTAGE',
                [
                    'required' => true,
                    'title' => Loc::getMessage('EXTRA_ENTITY_PERCENTAGE_FIELD'),
                ]
            )
        ];
    }

    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 getExtraList(): array
    {
        $result = [];
 
        $iterator = self::getList([
            'select' => [
                'ID',
                'NAME',
                'PERCENTAGE',
            ],
            'order' => [
                'ID' => 'ASC',
            ],
            'cache' => [
                'ttl' => 86400,
            ],
        ]);
        while ($row = $iterator->fetch())
        {
            $row['ID'] = (int)$row['ID'];
            $row['PERCENTAGE'] = (float)$row['PERCENTAGE'];
 
            $result[$row['ID']] = $row;
        }
        unset($row, $iterator);
 
        return $result;
    }
}