discountmodule.php

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

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

 
class DiscountModuleTable extends Main\Entity\DataManager
{
    public static function getTableName()
    {
        return 'b_sale_discount_module';
    }

    public static function getMap()
    {
        return array(
            'ID' => new Main\Entity\IntegerField('ID', array(
                'primary' => true,
                'autocomplete' => true,
                'title' => Loc::getMessage('DISCOUNT_MODULE_ENTITY_ID_FIELD')
            )),
            'DISCOUNT_ID' => new Main\Entity\IntegerField('DISCOUNT_ID', array(
                'required' => true,
                'title' => Loc::getMessage('DISCOUNT_MODULE_ENTITY_DISCOUNT_ID_FIELD')
            )),
            'MODULE_ID' => new Main\Entity\StringField('MODULE_ID', array(
                'required' => true,
                'validation' => array(__CLASS__, 'validateModuleId'),
                'title' => Loc::getMessage('DISCOUNT_MODULE_ENTITY_MODULE_ID_FIELD')
            )),
        );
    }

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

    public static function deleteByDiscount($discount)
    {
        $discount = (int)$discount;
        if ($discount <= 0)
            return;
        $conn = Application::getConnection();
        $helper = $conn->getSqlHelper();
        $conn->queryExecute(
            'delete from '.$helper->quote(self::getTableName()).' where '.$helper->quote('DISCOUNT_ID').' = '.$discount
        );
    }

    public static function updateByDiscount($discount, $moduleList, $clear)
    {
        $discount = (int)$discount;
        if ($discount <= 0)
            return false;
        $clear = ($clear === true);
        if ($clear)
        {
            self::deleteByDiscount($discount);
        }
        if (!empty($moduleList) && is_array($moduleList))
        {
            foreach ($moduleList as &$module)
            {
                $fields = array(
                    'DISCOUNT_ID' => $discount,
                    'MODULE_ID' => $module
                );
                $result = self::add($fields);
            }
            unset($module);
        }
        return true;
    }

    public static function getByDiscount($discountList, $filter = array())
    {
        $result = array();
        if (!empty($discountList) && is_array($discountList))
        {
            Main\Type\Collection::normalizeArrayValuesByInt($discountList);
            if (!empty($discountList))
            {
                if (!is_array($filter))
                    $filter = array();
 
                $discountRows = array_chunk($discountList, 500);
                foreach ($discountRows as &$row)
                {
                    $filter['@DISCOUNT_ID'] = $row;
 
                    $moduleIterator = self::getList(array(
                        'select' => array('DISCOUNT_ID', 'MODULE_ID'),
                        'filter' => $filter
                    ));
                    while ($module = $moduleIterator->fetch())
                    {
                        $module['DISCOUNT_ID'] = (int)$module['DISCOUNT_ID'];
                        if (!isset($result[$module['DISCOUNT_ID']]))
                            $result[$module['DISCOUNT_ID']] = array();
                        $result[$module['DISCOUNT_ID']][] = $module['MODULE_ID'];
                    }
                    unset($module, $moduleIterator);
                }
                unset($row, $discountRows);
            }
        }
        return $result;
    }
}