PHP Bitrix\Sender MailingTable::getChain 예제들

예제 #1

파일: mailing_trig_edit.php 프로젝트: DarneoStudio/bitrix

        $arTriggerSettingsTmp[] = $item;
    }
    $arTriggerSettings = $arTriggerSettingsTmp;
    // save chain
    $result = \Bitrix\Sender\MailingTable::updateChain($ID, $arTriggerSettings);
    $errorList = array_merge($errorList, $result->getErrorMessages());
    if (empty($errorList)) {
        if ($save != "") {
            LocalRedirect('/bitrix/admin/sender_mailing_trig_admin.php?lang=' . LANGUAGE_ID);
        } else {
            LocalRedirect('/bitrix/admin/sender_mailing_trig_edit.php?ID=' . $ID . '&lang=' . LANGUAGE_ID);
        }
    }
    $chainFieldsList = $arTriggerSettings;
} else {
    $chainFieldsList = \Bitrix\Sender\MailingTable::getChain($ID);
}
$numberChainItem = 0;
$chainFieldsListTmp = array();
foreach ($chainFieldsList as $chain) {
    $chain['ITEM_SORT'] = $numberChainItem++;
    $chainFieldsListTmp[] = $chain;
}
$chainFieldsList = $chainFieldsListTmp;
//Edit/Add part
ClearVars();
\CJSCore::Init(array("sender_admin"));
$APPLICATION->SetTitle(GetMessage("sender_chain_edit_title_edit") . ' "' . $mailing['NAME'] . '"');
require $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/main/include/prolog_admin_after.php";
$aMenu = array(array("TEXT" => GetMessage("sender_chain_edit_list"), "TITLE" => GetMessage("sender_chain_edit_list_title"), "LINK" => "/bitrix/admin/sender_mailing_trig_admin.php?MAILING_ID=" . $MAILING_ID . "&lang=" . LANG, "ICON" => "btn_list"));
if ($ID > 0 && $POST_RIGHT >= "W") {

예제 #2

파일: trig_statistics.php 프로젝트: Satariall/izurit

        if ($v !== 0 && empty($v)) {
            unset($arFilter[$k]);
        }
    }
}
$mailing = null;
if ($MAILING_ID > 0) {
    $mailingDb = \Bitrix\Sender\MailingTable::getList(array('filter' => array('ID' => $MAILING_ID, 'IS_TRIGGER' => 'Y')));
    if (!($mailing = $mailingDb->fetch())) {
        $MAILING_ID = 0;
    }
}
$statList = array();
if ($MAILING_ID > 0) {
    $i = 1;
    $chainList = \Bitrix\Sender\MailingTable::getChain($MAILING_ID);
    foreach ($chainList as $chain) {
        $stat = array('NAME' => GetMessage("sender_stat_trig_letter") . $i++, 'SUBJECT' => $chain['SUBJECT'], 'CNT' => array('SENT_SUCCESS' => 0, 'SENT_ERROR' => 0, 'READ' => 0, 'CLICK' => 0, 'UNSUB' => 0, 'GOAL' => 0, 'START' => 0));
        $statRawDb = \Bitrix\Sender\PostingRecipientTable::getList(array('select' => array('CNT', 'READ_CNT', 'CLICK_CNT', 'UNSUB_CNT'), 'filter' => array('=POSTING.MAILING_CHAIN_ID' => $chain['ID'], '=STATUS' => array(\Bitrix\Sender\PostingRecipientTable::SEND_RESULT_SUCCESS)), 'runtime' => array(new \Bitrix\Main\Entity\ExpressionField('CNT', 'COUNT(DISTINCT %s)', 'ID'), new \Bitrix\Main\Entity\ExpressionField('READ_CNT', 'COUNT(DISTINCT %s)', 'POSTING_READ.RECIPIENT_ID'), new \Bitrix\Main\Entity\ExpressionField('CLICK_CNT', 'COUNT(DISTINCT %s)', 'POSTING_CLICK.RECIPIENT_ID'), new \Bitrix\Main\Entity\ExpressionField('UNSUB_CNT', 'COUNT(DISTINCT %s)', 'POSTING_UNSUB.RECIPIENT_ID'))));
        while ($statRaw = $statRawDb->fetch()) {
            $stat['CNT']['SENT_SUCCESS'] += $statRaw['CNT'];
            $stat['CNT']['READ'] += $statRaw['READ_CNT'];
            $stat['CNT']['CLICK'] += $statRaw['CLICK_CNT'];
            $stat['CNT']['UNSUB'] += $statRaw['UNSUB_CNT'];
            $stat['CNT']['START'] += $statRaw['CNT'];
        }
        $statRawDb = \Bitrix\Sender\PostingRecipientTable::getList(array('select' => array('ID'), 'filter' => array('=POSTING.MAILING_CHAIN_ID' => $chain['ID'], '=STATUS' => array(\Bitrix\Sender\PostingRecipientTable::SEND_RESULT_SUCCESS, \Bitrix\Sender\PostingRecipientTable::SEND_RESULT_DENY), '!DATE_DENY' => null)));
        $stat['CNT']['GOAL'] = $statRawDb->getSelectedRowsCount();
        $statList['CHAIN'][] = $stat;
    }
}