groupcounter.php

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

<?php
namespace Bitrix\Sender\Internals\Model;
 
use Bitrix\Main\Entity;
use Bitrix\Main\Localization\Loc;
use Bitrix\Main\ORM\Query\Query;
 
Loc::loadMessages(__FILE__);

class GroupCounterTable extends Entity\DataManager
{
    public static function getTableName()
    {
        return 'b_sender_group_counter';
    }

    public static function getMap()
    {
        return array(
            'GROUP_ID' => array(
                'data_type' => 'integer',
                'required' => true,
                'primary' => true,
            ),
            'TYPE_ID' => array(
                'data_type' => 'integer',
                'required' => true,
                'primary' => true,
            ),
 
            'CNT' => array(
                'data_type' => 'integer',
                'required' => true,
                'default_value' => 0,
            ),
            'GROUP' => array(
                'data_type' => 'Bitrix\Sender\GroupTable',
                'reference' => array('=this.GROUP_ID' => 'ref.ID'),
            ),
        );
    }

    public static function deleteByGroupId($groupId)
    {
        $items = static::getList([
            'select' => ['GROUP_ID', 'TYPE_ID'],
            'filter' => ['=GROUP_ID' => $groupId]
        ]);
        foreach ($items as $primary)
        {
            $result = static::delete($primary);
            if (!$result->isSuccess())
            {
                return false;
            }
        }
 
        return true;
    }

    public static function deleteList(array $filter)
    {
        $entity = static::getEntity();
        $connection = $entity->getConnection();
 
        \CTimeZone::disable();
        $sql = sprintf(
            'DELETE FROM %s WHERE %s',
            $connection->getSqlHelper()->quote($entity->getDbTableName()),
            Query::buildFilterSql($entity, $filter)
        );
        $res = $connection->query($sql);
        \CTimeZone::enable();
 
        return $res;
    }
}