- Модуль: voximplant
- Путь к файлу: ~/bitrix/modules/voximplant/lib/integration/report/handler/callduration/callduration.php
- Класс: BitrixVoximplantIntegrationReportHandlerCallDurationCallDuration
- Вызов: CallDuration::getBaseQuery
protected function getBaseQuery($startDate, $finishDate, $filterParameters): Query
{
$query = StatisticTable::query();
$query->addSelect('PORTAL_USER_ID');
$this->addToQueryFilterCase($query, $filterParameters);
$this->addCallDurationField($query, CallType::INCOMING, 'INCOMING_DURATION');
$this->addCallDurationField($query, CallType::OUTGOING, 'OUTGOING_DURATION');
$query->whereBetween('CALL_START_DATE', $startDate, $finishDate);
return $query;
}