companyresponsiblegroup.php

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

<?php
 
namespace Bitrix\Sale\Internals;
 
use Bitrix\Main;
 

class CompanyResponsibleGroupTable extends Main\Entity\DataManager
{
    public static function getTableName()
    {
        return 'b_sale_company_resp_grp';
    }
 
    public static function getMap()
    {
        return [
            'ID' => [
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true,
            ],
            'COMPANY_ID' => [
                'data_type' => 'integer',
            ],
            'GROUP_ID' => [
                'data_type' => 'integer',
                'required' => true
            ],
        ];
    }
 
    public static function deleteByCompanyId($id)
    {
        $id = intval($id);
        if ($id <= 0)
        {
            throw new Main\ArgumentNullException('id');
        }
 
        $itemsList = static::getList(
            array(
                'filter' => array('COMPANY_ID' => $id),
                'select' => array('ID')
            )
        );
        while ($item = $itemsList->fetch())
        {
            static::delete($item['ID']);
        }
    }
 
 
    public static function getCompanyGroups($id)
    {
        $list = [];
        $res = static::getList([
            'filter' => [
                '=COMPANY_ID' => $id
            ],
            'select' => ['GROUP_ID'],
        ]);
        while($data = $res->fetch())
        {
            $list[] = $data['GROUP_ID'];
        }
 
        return $list;
    }
}