posting.php

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

<?php
namespace Bitrix\Sender\Internals\Model;
 
use Bitrix\Main;
use Bitrix\Sender;

class PostingTable extends Main\Entity\DataManager
{
    const STATUS_NEW = 'N';
    const STATUS_PART = 'P';
    const STATUS_SENT = 'S';
    const STATUS_SENT_WITH_ERRORS = 'E';
    const STATUS_ABORT = 'A';

    public static function getTableName()
    {
        return 'b_sender_posting';
    }

    public static function getMap()
    {
        return array(
            'ID' => array(
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true,
            ),
            'CAMPAIGN_ID' => array(
                'data_type' => 'integer',
                'required' => true,
                'column_name' => 'MAILING_ID',
            ),
            'LETTER_ID' => array(
                'data_type' => 'integer',
                'required' => true,
                'column_name' => 'MAILING_CHAIN_ID',
            ),
            'DATE_CREATE' => array(
                'data_type' => 'datetime',
                'required' => true,
                'default_value' => new Main\Type\DateTime(),
            ),
            'DATE_UPDATE' => array(
                'data_type' => 'datetime',
                'required' => true,
                'default_value' => new Main\Type\DateTime(),
            ),
            'STATUS' => array(
                'data_type' => 'string',
                'required' => true,
                'default_value' => self::STATUS_NEW,
            ),
            'DATE_SEND' => array(
                'data_type' => 'datetime',
            ),
            'DATE_PAUSE' => array(
                'data_type' => 'datetime',
            ),
            'DATE_SENT' => array(
                'data_type' => 'datetime',
            ),
            'COUNT_READ' => array(
                'data_type' => 'integer',
                'default_value' => 0
            ),
            'COUNT_CLICK' => array(
                'data_type' => 'integer',
                'default_value' => 0
            ),
            'COUNT_UNSUB' => array(
                'data_type' => 'integer',
                'default_value' => 0
            ),
            'COUNT_SEND_ALL' => array(
                'data_type' => 'integer',
                'default_value' => 0
            ),
            'COUNT_SEND_NONE' => array(
                'data_type' => 'integer',
                'default_value' => 0
            ),
            'COUNT_SEND_ERROR' => array(
                'data_type' => 'integer',
                'default_value' => 0
            ),
            'COUNT_SEND_SUCCESS' => array(
                'data_type' => 'integer',
                'default_value' => 0
            ),
            'COUNT_SEND_DENY' => array(
                'data_type' => 'integer',
                'default_value' => 0
            ),
            'LETTER' => array(
                'data_type' => LetterTable::class,
                'reference' => array('=this.LETTER_ID' => 'ref.ID'),
            ),
            'MAILING' => array(
                'data_type' => Sender\MailingTable::class,
                'reference' => array('=this.CAMPAIGN_ID' => 'ref.ID'),
            ),
            'MAILING_CHAIN' => array(
                'data_type' => Sender\MailingChainTable::class,
                'reference' => array('=this.LETTER_ID' => 'ref.ID'),
            ),
            'POSTING_RECIPIENT' => array(
                'data_type' => Posting\RecipientTable::class,
                'reference' => array('=this.ID' => 'ref.POSTING_ID'),
            ),
            'POSTING_READ' => array(
                'data_type' => Posting\ReadTable::class,
                'reference' => array('=this.ID' => 'ref.POSTING_ID'),
            ),
            'POSTING_CLICK' => array(
                'data_type' => Posting\ClickTable::class,
                'reference' => array('=this.ID' => 'ref.POSTING_ID'),
            ),
            'POSTING_UNSUB' => array(
                'data_type' => Posting\UnsubTable::class,
                'reference' => array('=this.ID' => 'ref.POSTING_ID'),
            ),
        );
    }

    public static function onDelete(Main\Entity\Event $event)
    {
        $result = new Main\Entity\EventResult;
        $data = $event->getParameters();
 
 
        $listId = array();
        if(array_key_exists('ID', $data['primary']))
        {
            $listId[] = $data['primary']['ID'];
        }
        else
        {
            $filter = array();
            foreach($data['primary'] as $primKey => $primVal)
            {
                $filter[$primKey] = $primVal;
            }
 
            $tableDataList = static::getList(array(
                'select' => array('ID'),
                'filter' => $filter
            ));
            while($tableData = $tableDataList->fetch())
            {
                $listId[] = $tableData['ID'];
            }
 
        }
 
        foreach($listId as $primaryId)
        {
            $primary = array('POSTING_ID' => $primaryId);
            Sender\PostingReadTable::deleteList($primary);
            Sender\PostingClickTable::deleteList($primary);
            Sender\PostingUnsubTable::deleteList($primary);
            Sender\PostingRecipientTable::deleteList($primary);
        }
 
 
        return $result;
    }
}