• Модуль: crm
  • Путь к файлу: ~/bitrix/modules/crm/lib/widget/data/leadidle.php
  • Класс: Bitrix\Crm\Widget\Data\LeadIdle
  • Вызов: LeadIdle::prepareActivityQuery
static function prepareActivityQuery($startDate, $endDate, $ownerFieldReference = '%s', $postfix = '')
{
	$query = new Query(LeadActivityStatisticsTable::getEntity());
	if($postfix !== '')
	{
		$query->setTableAliasPostfix($postfix);
	}
	$query->addFilter('=IS_JUNK', false);
	$query->addFilter('>=DEADLINE_DATE', $startDate);
	$query->addFilter('<=DEADLINE_DATE', $endDate);
	$query->addFilter('=OWNER_ID', new SqlExpression($ownerFieldReference));
	if(!(Main\Application::getConnection() instanceof Main\DB\OracleConnection))
	{
		$query->setLimit(1);
	}

	return $query;
}