Пример файла содержащего класс описывающего таблицу для Bitrix

<?php
namespace Citfact\SiteCore\Tables;

use Bitrix\Main\Entity;
use Bitrix\Main\Localization\Loc;
use Site\Core\Portal\CacheDB\CacheDBConnection;

Loc::loadMessages(__FILE__);

class AliProductsTable extends Entity\DataManager
{
    public static function getConnectionName()
    {
        return DBConnection::GetActiveConnection();
    }

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

public static function getMap()
    {
        return array(
            new Entity\IntegerField('id', array(
                'primary' => true,
                'autocomplete' => true,
            )),
            new Entity\IntegerField('product_id', array(
                'required' => true,
                'title' => Loc::getMessage('ALI_PRODUCTS_FIELD_PRODUCT_ID')
            )),
            new Entity\IntegerField('ali_id', array(
                'required' => false,
                'title' => Loc::getMessage('ALI_PRODUCTS_FIELD_ALI_ID')
            )),
            new Entity\StringField('metall_color', array(
                'required' => false,
                'title' => Loc::getMessage('ALI_PRODUCTS_FIELD_METALL_COLOR')
            )),
            new Entity\StringField('base_stone', array(
                'required' => false,
                'title' => Loc::getMessage('ALI_PRODUCTS_FIELD_BASE_STONE')
            )),
            new Entity\StringField('articul', array(
                'required' => true,
                'title' => Loc::getMessage('ALI_PRODUCTS_FIELD_ARTICLE')
            )),
            new Entity\StringField('section', array(
                'required' => true,
                'title' => Loc::getMessage('ALI_PRODUCTS_FIELD_SECTION')
            )),
            new Entity\FloatField('old_price', array(
                'required' => false,
                'title' => Loc::getMessage('ALI_PRODUCTS_FIELD_OLD_PRICE')
            )),
            new Entity\FloatField('price', array(
                'required' => false,
                'title' => Loc::getMessage('ALI_PRODUCTS_FIELD_PRICE')
            )),
            new Entity\StringField('percent', array(
                'required' => false,
                'title' => Loc::getMessage('ALI_PRODUCTS_FIELD_PERCENT')
            )),
            new Entity\StringField('ids', array(
                'required' => false,
                'title' => Loc::getMessage('ALI_PRODUCTS_FIELD_IDS')
            )),
            new Entity\DatetimeField('date', array(
                'required' => false,
                'title' => Loc::getMessage('ALI_PRODUCTS_FIELD_DATE')
            )),
        );

}
}

Комментарии