• Модуль: voximplant
  • Путь к файлу: ~/bitrix/modules/voximplant/lib/integration/report/handler/employeesworkload/employeesworkloadgraph.php
  • Класс: BitrixVoximplantIntegrationReportHandlerEmployeesWorkloadEmployeesWorkloadGraph
  • Вызов: EmployeesWorkloadGraph::getQueryForReport
protected function getQueryForReport($startDate, $finishDate, $previousStartDate, $previousFinishDate, $filterParameters): Query
{
	$subQuery = $this->getBaseQuery($previousStartDate, $previousFinishDate, $filterParameters);
	$query = $this->getBaseQuery($startDate, $finishDate, $filterParameters);

	$query->registerRuntimeField(new ReferenceField(
		'previous',
		Base::getInstanceByQuery($subQuery),
		Join::on('this.PORTAL_USER_ID', 'ref.PORTAL_USER_ID')
	));

	$this->addCallTypeCompareField($query, 'CALL_INCOMING');
	$this->addCallTypeCompareField($query, 'CALL_OUTGOING');
	$this->addCallTypeCompareField($query, 'CALL_MISSED');

	return $query;
}