• Модуль: crm
  • Путь к файлу: ~/bitrix/modules/crm/lib/integration/report/handler/salesdynamics/conversion.php
  • Класс: Bitrix\Crm\Integration\Report\Handler\SalesDynamics\Conversion
  • Вызов: Conversion::prepareCountClosedQuery
public function prepareCountClosedQuery(Query $query, array $filterParameters)
{
	$this->addToQueryFilterCase($query, $filterParameters);
	$this->addPermissionsCheck($query);
	$this->addTimePeriodToCountClosedQuery($query, $filterParameters['TIME_PERIOD']);

	$query->addSelect(Query::expr()->count('ID'), 'CNT');
	$query->addSelect('ASSIGNED_BY_ID');
	$query->addSelect('STAGE_SEMANTIC_ID');
	$query->addSelect('IS_RETURN_CUSTOMER');

	$query->whereIn('STAGE_SEMANTIC_ID', [PhaseSemantics::SUCCESS, PhaseSemantics::FAILURE]);

	return $query;
}