- Модуль: crm
- Путь к файлу: ~/bitrix/modules/crm/lib/history/leadstatushistorywithsupposedentry.php
- Класс: Bitrix\Crm\History\LeadStatusHistoryWithSupposedEntry
- Вызов: LeadStatusHistoryWithSupposedEntry::getLeadNewHistoryModificationsById
static function getLeadNewHistoryModificationsById($leadId, $fromDate = null)
{
$leadHistoryQuery = LeadTable::query();
$leadHistoryQuery->addSelect('HISTORY.OWNER_ID', 'LEAD_ID');
$leadHistoryQuery->addSelect('HISTORY.STATUS_ID', 'STATUS_ID_FROM_HISTORY');
$leadHistoryQuery->addSelect('HISTORY.CREATED_TIME', 'HISTORY_CREATED_TIME');
$leadHistoryQuery->addSelect('HISTORY.CREATED_DATE', 'HISTORY_CREATED_DATE');
$leadHistoryQuery->addSelect('HISTORY.STATUS_SEMANTIC_ID', 'STATUS_SEMANTIC_ID_FROM_HISTORY');
$leadHistoryQuery->addSelect('STATUS_SEMANTIC_ID', 'LEAD_STATUS_SEMANTIC_ID');
$leadHistoryQuery->where('ID', $leadId);
if (!is_null($fromDate))
{
$leadHistoryQuery->where('HISTORY.CREATED_TIME', '>=', $fromDate);
$leadHistoryQuery->where('HISTORY.HAS_SUPPOSED_HISTORY_RECORD', '=', 0);
}
return $leadHistoryQuery->exec()->fetchAll();
}