discountrestriction.php

<?php
namespace Bitrix\Catalog;
 
use Bitrix\Main,
    Bitrix\Main\Localization\Loc;
 
Loc::loadMessages(__FILE__);
 
class DiscountRestrictionTable extends Main\Entity\DataManager
{
    public static function getTableName()
    {
        return 'b_catalog_discount_cond';
    }
 
    public static function getMap()
    {
        return array(
            'ID' => new Main\Entity\IntegerField('ID', array(
                'primary' => true,
                'autocomplete' => true,
                'title' => Loc::getMessage('DISCOUNT_RESTRICTIONS_ENTITY_ID_FIELD')
            )),
            'DISCOUNT_ID' => new Main\Entity\IntegerField('DISCOUNT_ID', array(
                'required' => true,
                'title' => Loc::getMessage('DISCOUNT_RESTRICTIONS_ENTITY_DISCOUNT_ID_FIELD')
            )),
            'ACTIVE' => new Main\Entity\BooleanField('ACTIVE', array(
                'values' => array('N', 'Y'),
                'title' => Loc::getMessage('DISCOUNT_RESTRICTIONS_ENTITY_ACTIVE_FIELD')
            )),
            'USER_GROUP_ID' => new Main\Entity\IntegerField('USER_GROUP_ID', array(
                'required' => true,
                'title' => Loc::getMessage('DISCOUNT_RESTRICTIONS_ENTITY_USER_GROUP_ID_FIELD')
            )),
            'PRICE_TYPE_ID' => new Main\Entity\IntegerField('PRICE_TYPE_ID', array(
                'required' => true,
                'title' => Loc::getMessage('DISCOUNT_RESTRICTIONS_ENTITY_PRICE_TYPE_ID_FIELD')
            )),
            'DISCOUNT' => new Main\Entity\ReferenceField(
                'DISCOUNT',
                '\Bitrix\Catalog\Discount',
                array('=this.DISCOUNT_ID' => 'ref.ID')
            )
        );
    }
 
    public static function changeActiveByDiscount($discount, $active)
    {
        $discount = (int)$discount;
        $active = (string)$active;
        if ($discount <= 0 || ($active != 'Y' && $active != 'N'))
            return;
        $conn = Main\Application::getConnection();
        $helper = $conn->getSqlHelper();
        $conn->queryExecute(
            'update '.$helper->quote(self::getTableName()).
            ' set '.$helper->quote('ACTIVE').' = \''.$active.'\' where '.
            $helper->quote('DISCOUNT_ID').' = '.$discount
        );
        unset($helper, $conn);
    }
 
    public static function deleteByDiscount($discount)
    {
        $discount = (int)$discount;
        if ($discount <= 0)
            return;
        $conn = Main\Application::getConnection();
        $helper = $conn->getSqlHelper();
        $conn->queryExecute(
            'delete from '.$helper->quote(self::getTableName()).' where '.$helper->quote('DISCOUNT_ID').' = '.$discount
        );
        unset($helper, $conn);
    }
}