TimelineReport::createQuery

protected function createQuery(): Query
{
	$query = MonitorUserChartTable::query();

	$query->setSelect([
		'USER_ID',
		'TYPE' => 'GROUP_TYPE',
		'START' => 'TIME_START',
		'FINISH' => 'TIME_FINISH',
		'DATE_LOG',
		'DESKTOP_CODE',
	]);

	$query->addOrder('USER_ID');
	$query->addOrder('DATE_LOG', 'DESC');
	$query->addOrder('START');

	if ($this->getFilter() !== null)
	{
		$query->setFilter($this->getFilter());
	}

	return $query;
}