• Модуль: crm
  • Путь к файлу: ~/bitrix/modules/crm/lib/widget/data/leadnew.php
  • Класс: Bitrix\Crm\Widget\Data\LeadNew
  • Вызов: LeadNew::prepareEntityListFilter
public function prepareEntityListFilter(array $filterParams)
{
	$filter = self::internalizeFilter($filterParams);
	$query = new Query(LeadStatusHistoryTable::getEntity());
	$query->addSelect('OWNER_ID');
	$query->addGroup('OWNER_ID');

	$period = $filter->getPeriod();
	$periodStartDate = $period['START'];
	$periodEndDate = $period['END'];

	$query->addFilter('=TYPE_ID', HistoryEntryType::CREATION);
	$query->addFilter('>=CREATED_DATE', $periodStartDate);
	$query->addFilter('<=CREATED_DATE', $periodEndDate);

	$responsibleIDs = $filter->getResponsibleIDs();
	if(!empty($responsibleIDs))
	{
		$query->addFilter('@RESPONSIBLE_ID', $responsibleIDs);
	}

	return array(
		'__JOINS' => array(
				array(
					'TYPE' => 'INNER',
					'SQL' => 'INNER JOIN('.$query->getQuery().') LN ON LN.OWNER_ID = L.ID'
				)
			)
	);
}