companygroup.php

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

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

class CompanyGroupTable extends Main\Entity\DataManager
{
    public static function getTableName()
    {
        return 'b_sale_company_group';
    }
 
    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(
            [
                'filter' => ['COMPANY_ID' => $id],
                'select' => ['ID'],
            ]
        );
        while ($item = $itemsList->fetch())
        {
            static::delete($item['ID']);
        }
    }
}