question.php

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

<?php
namespace Bitrix\Vote;
use \Bitrix\Main\Entity;
use \Bitrix\Main\Localization\Loc;
Loc::loadMessages(__FILE__);

class QuestionTable extends Entity\DataManager
{
    public static function getTableName()
    {
        return 'b_vote_question';
    }

    public static function getMap()
    {
        return array(
            'ID' => array(
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true,
                'title' => Loc::getMessage('V_TABLE_FIELD_ID'),
            ),
            'ACTIVE' => array(
                'data_type' => 'boolean',
                'values' => array('N', 'Y'),
                'default_value' => 'Y',
                'title' => Loc::getMessage('V_TABLE_FIELD_ACTIVE')
            ),
            'TIMESTAMP_X' => array(
                'data_type' => 'datetime',
                'title' => Loc::getMessage('V_TABLE_FIELD_TIMESTAMP_X'),
            ),
            'VOTE_ID' => array(
                'data_type' => 'integer',
                'title' => Loc::getMessage('V_TABLE_FIELD_VOTE_ID'),
            ),
            'C_SORT' => array(
                'data_type' => 'integer',
                'title' => Loc::getMessage('V_TABLE_FIELD_C_SORT'),
            ),
            'COUNTER' => array(
                'data_type' => 'integer',
                'title' => Loc::getMessage('V_TABLE_FIELD_COUNTER'),
            ),
            'QUESTION' => array(
                'data_type' => 'text',
                'title' => Loc::getMessage('V_TABLE_FIELD_QUESTION'),
                'save_data_modification' => array('\Bitrix\Main\Text\Emoji', 'getSaveModificator'),
                'fetch_data_modification' => array('\Bitrix\Main\Text\Emoji', 'getFetchModificator'),
            ),
            'QUESTION_TYPE' => array(
                'data_type' => 'enum',
                'values' => array("text", "html"),
                'default_value' => "text",
                'title' => Loc::getMessage('V_TABLE_FIELD_QUESTION_TYPE'),
            ),
            'IMAGE_ID' =>  array(
                'data_type' => 'integer',
                'title' => Loc::getMessage('V_TABLE_FIELD_IMAGE_ID'),
            ),
            'IMAGE' =>  array(
                'data_type' => '\Bitrix\Main\FileTable',
                'reference' => array(
                    '=this.IMAGE_ID' => 'ref.ID',
                ),
                'join_type' => 'LEFT',
                'title' => Loc::getMessage('V_TABLE_FIELD_IMAGE'),
            ),
            'DIAGRAM' => array(
                'data_type' => 'boolean',
                'values' => array('N', 'Y'),
                'default_value' => 'Y',
                'title' => Loc::getMessage('V_TABLE_FIELD_DIAGRAM')
            ),
            'DIAGRAM_TYPE' => array(
                'data_type' => 'enum',
                'values' => array("histogram", "circle"),
                'default_value' => "histogram",
                'title' => Loc::getMessage('V_TABLE_FIELD_DIAGRAM_TYPE'),
            ),
            'REQUIRED' => array(
                'data_type' => 'boolean',
                'values' => array('N', 'Y'),
                'default_value' => 'N',
                'title' => Loc::getMessage('V_TABLE_FIELD_REQUIRED')
            ),
            'FIELD_TYPE' => array(
                'data_type' => 'enum',
                'values' => \Bitrix\Vote\QuestionTypes::getValues(),
                'default_value' => '0',
                'title' => Loc::getMessage('V_TABLE_FIELD_FIELD_TYPE')
            ),
            'VOTE' => array(
                'data_type' => '\Bitrix\Vote\VoteTable',
                'reference' => array(
                    '=this.VOTE_ID' => 'ref.ID',
                ),
                'join_type' => 'RIGHT',
            ),
            'ANSWER' => array(
                'data_type' => '\Bitrix\Vote\AnswerTable',
                'reference' => array(
                    '=this.ID' => 'ref.QUESTION_ID',
                ),
                'join_type' => 'LEFT',
            )
        );
    }

    public static function setCounter(array $id, $increment = true)
    {
        $id = implode(", ", $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 Question
{
    public static $storage = array();
}