• Модуль: voximplant
  • Путь к файлу: ~/bitrix/modules/voximplant/lib/integration/report/handler/base.php
  • Класс: BitrixVoximplantIntegrationReportHandlerBase
  • Вызов: Base::prepareEntityListFilter
public function prepareEntityListFilter($requestParameters): Query
{
	$query = StatisticTable::query();
	$fields = StatisticTable::getEntity()->getFields();

	foreach ($fields as $field)
	{
		$query->addSelect($field->getName());
	}

	$sliderFilterParameters = $this->mergeRequestWithReportFilter($requestParameters->toArray());

	$this->addToQueryFilterCase($query, $sliderFilterParameters);

	$startDate = $requestParameters->get('START_DATE_from') ?: $sliderFilterParameters['TIME_PERIOD_from'];
	$finishDate = $requestParameters->get('START_DATE_to') ?: $sliderFilterParameters['TIME_PERIOD_to'];

	$query->whereBetween(
		'CALL_START_DATE',
		DateTime::createFromUserTime($startDate),
		DateTime::createFromUserTime($finishDate)
	);

	return $query;
}