contactlist.php

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

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

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

    public static function getMap()
    {
        return array(
            'CONTACT_ID' => array(
                'data_type' => 'integer',
                'primary' => true,
            ),
            'LIST_ID' => array(
                'data_type' => 'integer',
                'primary' => true,
            ),
            'LIST' => array(
                'data_type' => 'Bitrix\Sender\ListTable',
                'reference' => array('=this.LIST_ID' => 'ref.ID'),
            ),
            'CONTACT' => array(
                'data_type' => 'Bitrix\Sender\ContactTable',
                'reference' => array('=this.CONTACT_ID' => 'ref.ID'),
            ),
        );
    }

    public static function addIfNotExist($contactId, $listId)
    {
        $result = false;
        $arPrimary = array('CONTACT_ID' => $contactId, 'LIST_ID' => $listId);
        if( !($arList = static::getRowById($arPrimary) ))
        {
            $resultAdd = static::add($arPrimary);
            if ($resultAdd->isSuccess())
            {
                $result = true;
            }
        }
        else
        {
            $result = true;
        }
 
        return $result;
    }

    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;
    }
}