orderround.php

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

<?php
namespace Bitrix\Sale\Internals;
 
use Bitrix\Main,
    Bitrix\Main\Localization\Loc;
Loc::loadMessages(__FILE__);

 
class OrderRoundTable extends Main\Entity\DataManager
{
    const ENTITY_TYPE_BASKET_ITEM = 0x0001;
    const ENTITY_TYPE_BASKET = self::ENTITY_TYPE_BASKET_ITEM;

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

    public static function getMap()
    {
        return array(
            'ID' => new Main\Entity\IntegerField('ID', array(
                'primary' => true,
                'autocomplete' => true,
                'title' => Loc::getMessage('ORDER_ROUND_ENTITY_ID_FIELD')
            )),
            'ORDER_ID' => new Main\Entity\IntegerField('ORDER_ID', array(
                'required' => true,
                'title' => Loc::getMessage('ORDER_ROUND_ENTITY_ORDER_ID_FIELD')
            )),
            'APPLY_BLOCK_COUNTER' => new Main\Entity\IntegerField('APPLY_BLOCK_COUNTER', array(
                'required' => true,
            )),
            'ORDER_ROUND' => new Main\Entity\BooleanField('ORDER_ROUND', array(
                'required' => true,
                'values' => array('N', 'Y'),
                'default_value' => 'Y',
                'title' => Loc::getMessage('ORDER_ROUND_ENTITY_ORDER_ROUND_FIELD')
            )),
            'ENTITY_TYPE' => new Main\Entity\EnumField('ENTITY_TYPE', array(
                'required' => true,
                'values' => array(self::ENTITY_TYPE_BASKET_ITEM),
                'title' => Loc::getMessage('ORDER_ROUND_ENTITY_ENTITY_TYPE_FIELD')
            )),
            'ENTITY_ID' => new Main\Entity\IntegerField('ENTITY_ID', array(
                'required' => true,
                'title' => Loc::getMessage('ORDER_ROUND_ENTITY_ENTITY_ID_FIELD')
            )),
            'ENTITY_VALUE' => new Main\Entity\StringField('ENTITY_VALUE', array(
                'validation' => array(__CLASS__, 'validateEntityValue'),
                'title' => Loc::getMessage('ORDER_ROUND_ENTITY_ENTITY_VALUE_FIELD')
            )),
            'APPLY' => new Main\Entity\BooleanField('APPLY', array(
                'required' => true,
                'values' => array('N', 'Y'),
                'title' => Loc::getMessage('ORDER_ROUND_ENTITY_APPLY_FIELD')
            )),
            'ROUND_RULE' => new Main\Entity\TextField('ROUND_RULE', array(
                'required' => true,
                'serialized' => true
            ))
        );
    }

    public static function validateEntityValue()
    {
        return array(
            new Main\Entity\Validator\Length(null, 255),
        );
    }

    public static function clearByOrder($order)
    {
        $order = (int)$order;
        if ($order <= 0)
            return false;
 
        $conn = Main\Application::getConnection();
        $helper = $conn->getSqlHelper();
        $conn->queryExecute('delete from '.$helper->quote(self::getTableName()).' where '.$helper->quote('ORDER_ID').' = '.$order);
        unset($helper, $conn);
 
        return true;
    }
}