usergrouprestriction.php

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

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

 
class UserGroupRestrictionTable extends Main\ORM\Data\DataManager
{
    const ENTITY_TYPE_SHIPMENT = 1;
    const ENTITY_TYPE_PAYMENT = 2;

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

    public static function getMap()
    {
        return [
            new Main\ORM\Fields\IntegerField('ID',[
                'primary' => true,
                'autocomplete' => true
            ]),
 
            new Main\ORM\Fields\IntegerField('ENTITY_ID', [
                'required' => true
            ]),
 
            new Main\ORM\Fields\IntegerField('ENTITY_TYPE_ID', [
                'required' => true
            ]),
 
            new Main\ORM\Fields\IntegerField('GROUP_ID', [
                'required' => true
            ])
        ];
    }
 
    public static function deleteByEntity($entityType, $entityId)
    {
        $conn = Main\Application::getConnection();
        $helper = $conn->getSqlHelper();
        $conn->queryExecute('DELETE FROM '.$helper->quote(self::getTableName()).' WHERE ENTITY_TYPE_ID='.(string)(int)$entityType.' AND ENTITY_ID='.(string)(int)$entityId);
    }
}