access.php

<?php
 
namespace Bitrix\Sender\Internals\Model\Role;
 
use Bitrix\Main\ArgumentException;
use Bitrix\Main\Application;
use Bitrix\Main\Entity;
 
class AccessTable extends Entity\DataManager
{
    public static function getTableName()
    {
        return 'b_sender_role_access';
    }
 
    public static function getMap()
    {
        return array(
            'ID' => new Entity\IntegerField('ID', array(
                'primary' => true,
                'autocomplete' => true,
            )),
            'ROLE_ID' => new Entity\IntegerField('ROLE_ID', array(
                'required' => true,
            )),
            'ACCESS_CODE' => new Entity\StringField('ACCESS_CODE', array(
                'required' => true,
            )),
            'ROLE' => new Entity\ReferenceField(
                'ROLE', 'Bitrix\Sender\Access\Role\Role',
                array('=this.ROLE_ID' => 'ref.ID'),
                array('join_type' => 'INNER')
            )
        );
    }
 
    public static function truncate()
    {
        $sql = "TRUNCATE TABLE " . self::getTableName();
        Application::getConnection()->queryExecute($sql);
 
        $result = new Entity\DeleteResult();
        return $result;
    }
 
    public static function deleteByRoleId($roleId)
    {
        $roleId = (int) $roleId;
        if($roleId <= 0)
        {
            throw new ArgumentException('Role id should be greater than zero', 'roleId');
        }
 
        $sql = "DELETE FROM " . self::getTableName() . " WHERE ROLE_ID = " . $roleId;
        Application::getConnection()->queryExecute($sql);
 
        $result = new Entity\DeleteResult();
        return $result;
    }
}