scriptqueue.php

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

<?php
 
namespace Bitrix\Bizproc\Script\Entity;
 
use Bitrix\Bizproc\Script\Queue\Status;
use Bitrix\Main;
use Bitrix\Main\ORM\Fields\ExpressionField;

class ScriptQueueTable extends Main\Entity\DataManager
{
    public static function getTableName()
    {
        return 'b_bp_script_queue';
    }

    public static function getMap()
    {
        return [
            'ID' => [
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true,
            ],
            'SCRIPT_ID' => [
                'data_type' => 'integer'
            ],
            'STARTED_DATE' => [
                'data_type' => 'datetime'
            ],
            'STARTED_BY' => [
                'data_type' => 'integer'
            ],
            'STARTED_USER' => [
                'data_type' => Main\UserTable::class,
                'reference' => [
                    '=this.STARTED_BY' => 'ref.ID'
                ],
                'join_type' => 'LEFT',
            ],
            'STATUS' => [
                'data_type' => 'integer'
            ],
            'MODIFIED_DATE' => [
                'data_type' => 'datetime'
            ],
            'MODIFIED_BY' => [
                'data_type' => 'integer',
                'default_value' => 0,
            ],
            new Main\ORM\Fields\ArrayField('WORKFLOW_PARAMETERS'),
        ];
    }

    public static function getDocumentCounters(int $queueId): array
    {
        $scriptQueueRows =
            ScriptQueueDocumentTable::query()
                ->addSelect('STATUS')
                ->addSelect(new ExpressionField('CNT', 'COUNT(1)'))
                ->where('QUEUE_ID', $queueId)
                ->setGroup('STATUS')
                ->exec()
                ->fetchAll();
        ;
 
        $all = 0;
        $queued = 0;
        foreach ($scriptQueueRows as $scriptGroupByStatus)
        {
            $all += (int)$scriptGroupByStatus['CNT'];
            if ((int)$scriptGroupByStatus['STATUS'] === Status::QUEUED)
            {
                $queued = (int)$scriptGroupByStatus['CNT'];
            }
        }
 
        return [
            'all' => $all,
            'queued' => $queued,
            'completed' => $all - $queued
        ];
    }
 
    public static function getNextQueuedDocument(int $queueId): ?EO_ScriptQueueDocument
    {
        $document = ScriptQueueDocumentTable::getList([
            'filter' => [
                '=QUEUE_ID' => $queueId,
                '=STATUS' => Status::QUEUED,
            ],
            'order' => ['ID' => 'ASC'],
            'limit' => 1
        ])->fetchObject();
 
        return $document;
    }
 
    public static function markTerminated(int $queueId, int $userId)
    {
        static::update(
            $queueId,
            [
                'STATUS' => Status::TERMINATED,
                'MODIFIED_BY' => $userId
            ]
        );
 
        $docResult = ScriptQueueDocumentTable::getList([
            'filter' => [
                '=QUEUE_ID' => $queueId,
                '=STATUS' => Status::QUEUED,
                ],
            'select' => ['ID']
        ]);
 
        $docIds = array_column($docResult->fetchAll(), 'ID');
 
        ScriptQueueDocumentTable::updateMulti($docIds, ['STATUS' => Status::TERMINATED], true);
    }
 
    public static function markExecuting(int $queueId)
    {
        static::update($queueId, ['STATUS' => Status::EXECUTING]);
    }
 
    public static function markCompleted(int $queueId)
    {
        static::update($queueId, ['STATUS' => Status::COMPLETED]);
    }
 
    public static function deleteByScript(int $scriptId)
    {
        $result = static::getList(['filter' => ['=SCRIPT_ID' => $scriptId], 'select' => ['ID']]);
 
        foreach ($result as $row)
        {
            static::delete($row['ID']);
            ScriptQueueDocumentTable::deleteByQueue($row['ID']);
        }
    }
 
    public static function onBeforeUpdate(Main\ORM\Event $event): Main\ORM\EventResult
    {
        $result = new Main\ORM\EventResult();
 
        $fields = $event->getParameter('fields');
        $modifyFields = ['MODIFIED_DATE' => new Main\Type\DateTime()];
 
        if(!isset($fields['MODIFIED_BY']))
        {
            $modifyFields['MODIFIED_BY'] = 0;
        }
 
        $result->modifyFields($modifyFields);
 
        return $result;
    }
}