- Модуль: voximplant
- Путь к файлу: ~/bitrix/modules/voximplant/lib/integration/report/handler/base.php
- Класс: BitrixVoximplantIntegrationReportHandlerBase
- Вызов: Base::addIntervalByDatasel
protected function addIntervalByDatasel(Query $query, $timePeriodDatasel, string $dateDifference): void
{
switch ($timePeriodDatasel)
{
case DateType::YEAR:
case DateType::QUARTER:
case DateType::CURRENT_QUARTER:
$expression = "date_format(subdate(date(%s), interval -$dateDifference), '%%Y-%%m')";
break;
default:
$expression = "subdate(date(%s), interval -$dateDifference)";
break;
}
$query->registerRuntimeField(new ExpressionField(
'PREVIOUS_DATE',
$expression,
['CALL_START_DATE']
));
}