buttonsitetable.php

<?php
namespace Bitrix\B24connector;
 
use Bitrix\Main\ORM\Data\DataManager;
use Bitrix\Main\ORM\Fields\IntegerField;
use Bitrix\Main\ORM\Fields\StringField;
 
class ButtonSiteTable extends DataManager
{
    public static function getTableName()
    {
        return 'b_b24connector_button_site';
    }
 
    public static function getMap()
    {
        return [
            new IntegerField('ID', [
                'primary' => true,
                'autocomplete' => true,
            ]),
            new IntegerField('BUTTON_ID', [
                'required' => true,
            ]),
            new StringField('SITE_ID', [
                'required' => true,
            ]),
        ];
    }
 
    public static function getAllRestrictions()
    {
        $result = [];
        $rows = static::getList();
        while ($row = $rows->fetch())
        {
            $buttonId = $row['BUTTON_ID'];
            $siteId = $row['SITE_ID'];
 
            if (!isset($result[$buttonId]))
            {
                $result[$buttonId] = [];
            }
 
            $result[$buttonId][] = $siteId;
        }
        return $result;
    }
 
    public static function deleteByButtonId($buttonId)
    {
        $buttonId = (int)$buttonId;
        if ($buttonId <= 0)
        {
            return;
        }
 
        $rows = static::getList([
            'select' => ['ID'],
            'filter' => ['=BUTTON_ID' => $buttonId]
        ]);
        while ($row = $rows->fetch())
        {
            static::delete($row['ID']);
        }
    }
}