<?php

namespace Divasoft\Connector;

class LastActionCrmContact extends \Bitrix\Sender\Connector {

    public function getName() {
        return 'Контакты - год минус месяц от даты участия';
    }

    public function getCode() {
        return "my_user_lastaction";
    }

    /** @return \CDBResult */
    public function getData() {
        $currentDate = new \Bitrix\Main\Type\Date();
        $currentDate->add('-3 year -1 month +2 day');
        $filter = array(
            "=UF_CRM_1603446153" => $currentDate,
        );

        $resultDb = \CCrmContact::GetList(array(), $filter);
        while ($arResult = $resultDb->fetch()) {
            $arResult['PHONES'] = $this->getFieldMulti('PHONE', $arResult['ID']);
            foreach ($arResult['PHONES'] as $phone) {
                $arResult['PHONE'][] = $phone['VALUE'];
            }
            $arResult['EMAILS'] = $this->getFieldMulti('EMAIL', $arResult['ID']);
            foreach ($arResult['EMAILS'] as $email) {
                $arResult['EMAIL'][] = $email['VALUE'];
            }

            $arr[] = ['PHONE'=>$arResult['PHONE'],'EMAIL'=>$arResult['EMAIL'],'NAME'=>$arResult['NAME']];  // 'ID'=>$arResult['ID'],
        }
        $rs = new \CDBResult;
        $rs->InitFromArray($arr);
        return $rs;
    }

    public function getForm() {
        return "Все Контакты, у которые принимали участие в мероприятиях год назад минут 1 месяц";
    }

    function getFieldMulti($TYPE_ID, $ELEMENT_ID) {
        $dbResult = \CCrmFieldMulti::GetList(
                        array(), array(
                    'ENTITY_ID' => 'CONTACT',
                    'CHECK_PERMISSIONS' => 'N',
                    'TYPE_ID' => $TYPE_ID,
                    'ELEMENT_ID' => $ELEMENT_ID
                        )
        );
        $ret = [];
        while ($arLead = $dbResult->GetNext()) {
            $ret['n' . count($ret)] = $arLead;
        }
        return $ret;
    }

}