• Модуль: voximplant
  • Путь к файлу: ~/bitrix/modules/voximplant/lib/integration/report/handler/callduration/callduration.php
  • Класс: BitrixVoximplantIntegrationReportHandlerCallDurationCallDuration
  • Вызов: CallDuration::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',
		BitrixMainEntityBase::getInstanceByQuery($subQuery),
		Join::on('this.PORTAL_USER_ID', 'ref.PORTAL_USER_ID')
	));

	$this->addCallDurationCompareField($query, 'INCOMING_DURATION');
	$this->addCallDurationCompareField($query, 'OUTGOING_DURATION');

	return $query;
}