• Модуль: crm
  • Путь к файлу: ~/bitrix/modules/crm/lib/integration/report/handler/lead.php
  • Класс: Bitrix\Crm\Integration\Report\Handler\Lead
  • Вызов: Lead::getLeadAmountCountByResponsible
private function getLeadAmountCountByResponsible()
{
	$query = new Query(LeadTable::getEntity());
	$query->addSelect(new \Bitrix\Main\Entity\ExpressionField('COUNT', 'COUNT(DISTINCT %s)', 'FULL_HISTORY.OWNER_ID'));
	$query->addSelect('ASSIGNED_BY_ID');
	$query->addGroup('ASSIGNED_BY_ID');
	$this->addToQueryFilterCase($query);
	$this->addPermissionsCheck($query);
	$results = $query->exec()->fetchAll();

	$amountByResponsible = [];
	foreach ($results as $result)
	{
		$amountByResponsible[$result['ASSIGNED_BY_ID']] = $result['COUNT'];
	}
	return $amountByResponsible;
}