- Модуль: 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;
}