• Модуль: crm
  • Путь к файлу: ~/bitrix/modules/crm/lib/widget/data/leadinwork.php
  • Класс: Bitrix\Crm\Widget\Data\LeadInWork
  • Вызов: LeadInWork::prepareEntityListFilter
public function prepareEntityListFilter(array $filterParams)
{
	$filter = self::internalizeFilter($filterParams);

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

	$responsibleIDs = $filter->getResponsibleIDs();

	$queries = array(
		self::prepareHistoryQuery($periodStartDate, $periodEndDate, $responsibleIDs)->getQuery(),
		self::prepareActivityQuery($periodStartDate, $periodEndDate, $responsibleIDs)->getQuery()
	);

	return array(
		'__JOINS' => array(
			array(
				'TYPE' => 'INNER',
				'SQL' => 'INNER JOIN('.implode("\nUNION\n", $queries).') DS ON DS.OWNER_ID = L.ID'
			)
		)
	);
}