• Модуль: voximplant
  • Путь к файлу: ~/bitrix/modules/voximplant/lib/integration/report/handler/calldynamics/calldynamicsgrid.php
  • Класс: BitrixVoximplantIntegrationReportHandlerCallDynamicsCallDynamicsGrid
  • Вызов: CallDynamicsGrid::getBaseQuery
protected function getBaseQuery($startDate, $finishDate, $filterParameters)
{
	$query = StatisticTable::query();
	$query->addSelect('PORTAL_USER_ID');

	$this->addToQueryFilterCase($query, $filterParameters);
	$this->addCallTypeField($query, CallType::INCOMING, 'CALL_INCOMING');
	$this->addCallTypeField($query, CallType::OUTGOING, 'CALL_OUTGOING');
	$this->addCallTypeField($query, CallType::MISSED, 'CALL_MISSED');
	$this->addCallTypeField($query, CallType::CALLBACK, 'CALL_CALLBACK');
	$this->addCallTypeField($query, CallType::ALL, 'CALL_COUNT');
	$query->whereBetween('CALL_START_DATE', $startDate, $finishDate);

	return $query;
}