• Модуль: crm
  • Путь к файлу: ~/bitrix/modules/crm/lib/integration/report/handler/order/responsiblegrid.php
  • Класс: Bitrix\Crm\Integration\Report\Handler\Order\ResponsibleGrid
  • Вызов: ResponsibleGrid::prepareQuery
public function prepareQuery(Query $query): Query
{
	$query = parent::prepareQuery($query);

	$query->addSelect('STATUS_ID');
	$query->addSelect('RESPONSIBLE_ID');
	$query->addSelect(Query::expr()->sum('PRICE'), 'SUM');
	$query->addSelect(Query::expr()->count('STATUS_ID'), 'ORDER_COUNT');
	$query->setGroup(['CURRENCY', 'STATUS_ID', 'RESPONSIBLE_ID']);

	return $query;
}