answer.php

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

<?php
namespace Bitrix\Vote;
use \Bitrix\Main\Entity;
use \Bitrix\Main\Localization\Loc;
use Bitrix\Main\ORM\Fields\BooleanField;
use Bitrix\Main\ORM\Fields\EnumField;
use Bitrix\Main\ORM\Fields\IntegerField;
use Bitrix\Main\ORM\Fields\DatetimeField;
use Bitrix\Main\ORM\Fields\Relations\Reference;
use Bitrix\Main\ORM\Fields\StringField;
use Bitrix\Main\ORM\Fields\TextField;
use Bitrix\Main\ORM\Query\Join;
use Bitrix\Main\Text\Emoji;
 
Loc::loadMessages(__FILE__);

class AnswerTable extends Entity\DataManager
{
    public const REACTION_MAX_LENGTH = 50;

    public static function getTableName()
    {
        return 'b_vote_answer';
    }

    public static function getMap()
    {
        return [
            (new IntegerField('ID'))
                ->configurePrimary(true)
                ->configureAutocomplete(true),
            (new BooleanField('ACTIVE'))
                ->configureValues('N', 'Y')
                ->configureDefaultValue('Y'),
            (new DatetimeField('TIMESTAMP_X')),
            (new IntegerField('QUESTION_ID')),
            (new IntegerField('C_SORT')),
            (new IntegerField('IMAGE_ID')),
            (new Reference('IMAGE',
                \Bitrix\Main\FileTable::class,
                Join::on('this.IMAGE_ID', 'ref.ID')
            )),
            (new TextField('MESSAGE'))
                ->addSaveDataModifier(fn($value) => Emoji::encode($value))
                ->addFetchDataModifier(fn($value) => Emoji::decode($value))
            ,
            (new EnumField('MESSAGE_TYPE', ['values' => ['text', 'html']]))
                ->configureDefaultValue('text'),
            (new IntegerField('COUNTER')),
            (new IntegerField('FIELD_TYPE')),
            (new IntegerField('FIELD_WIDTH')),
            (new IntegerField('FIELD_HEIGHT')),
            (new StringField('FIELD_PARAM'))
                ->configureSize(255),
            (new StringField('COLOR'))
                ->configureSize(6),
            (new StringField('REACTION'))
                ->configureSize(self::REACTION_MAX_LENGTH)
                ->configureNullable()
                ->addSaveDataModifier(fn($value) => Emoji::encode($value))
                ->addFetchDataModifier(fn($value) => Emoji::decode($value))
            ,
        ];
    }

    public static function setCounter(array $id, $increment = true)
    {
        $id = implode(", ", array_map('intval', $id));
        if (empty($id))
            return;
        $connection = \Bitrix\Main\Application::getInstance()->getConnection();
 
        $sql = intval($increment);
        if ($increment === true)
            $sql = "COUNTER+1";
        else if ($increment === false)
            $sql = "COUNTER-1";
        $connection->queryExecute("UPDATE ".self::getTableName()." SET COUNTER=".$sql." WHERE ID IN (".$id.")");
    }
}
 
class Answer
{
    public static $storage = array();
}