• Модуль: 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']
	));
}