• Модуль: crm
  • Путь к файлу: ~/bitrix/modules/crm/lib/integration/report/handler/managers/rating.php
  • Класс: Bitrix\Crm\Integration\Report\Handler\Managers\Rating
  • Вызов: Rating::prepareEntityListFilter
public function prepareEntityListFilter($requestParameters)
{
	$filterParameters = $this->getFilterParameters();
	$query = DealTable::query();
	$query->addSelect('ID');

	$this->addToQueryFilterCase($query, $filterParameters);
	$this->addTimePeriodToQuery($query, $filterParameters['TIME_PERIOD']);
	foreach ($requestParameters as $parameter => $value)
	{
		switch ($parameter)
		{
			case 'STAGE_SEMANTIC_ID':
			case 'ASSIGNED_BY_ID':
				$query->where($parameter, $value);
				break;
		}
	}

	return [
		'__JOINS' => [
			[
				'TYPE' => 'INNER',
				'SQL' => 'INNER JOIN('.$query->getQuery().') REP ON REP.ID = L.ID'
			]
		]
	];
}