workflowtemplatesettingstable.php

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

<?php
 
namespace Bitrix\Bizproc\Workflow\Template;
 
use Bitrix\Main\ORM;
use Bitrix\Main\ORM\Data\DataManager;
use Bitrix\Main\ORM\Fields\StringField;
use Bitrix\Main\ORM\Fields\Validators\LengthValidator;

class WorkflowTemplateSettingsTable extends DataManager
{
    const SHOW_CATEGORY_PREFIX = 'SHOW_CATEGORY_ID_';
 
    public static function getTableName(): string
    {
        return 'b_bp_workflow_template_settings';
    }
 
    public static function getMap(): array
    {
        return [
            (new ORM\Fields\IntegerField('ID'))
                ->configurePrimary()
                ->configureAutocomplete()
            ,
            (new ORM\Fields\IntegerField('TEMPLATE_ID'))
                ->configureRequired()
            ,
            (new ORM\Fields\StringField('NAME'))
                ->configureRequired()
                ->addValidator(new LengthValidator(null, 255))
            ,
            (new ORM\Fields\StringField('VALUE')),
            new ORM\Fields\Relations\Reference(
                'TEMPLATE',
                Entity\WorkflowTemplateTable::class,
                ORM\Query\Join::on('this.TEMPLATE_ID', 'ref.ID')
            ),
        ];
    }
 
    public static function deleteSettingsByFilter(array $filter): void
    {
        $result = static::getList([
            'filter' => $filter,
            'select' => ['ID']
        ]);
        while ($row = $result->fetch())
        {
            static::delete($row['ID']);
        }
    }
 
    public static function addMultiSettings(array $rows): void
    {
        if (!empty($rows))
        {
            static::addMulti($rows, true);
        }
    }
}