WorkingHoursByDateReport::createQuery

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

	$query->setSelect([
		'DATE_LOG',
		'USER_ID',
		'WORKING_HOURS',
		'DESKTOP_CODE',
	]);

	$query->registerRuntimeField(new ExpressionField(
		'WORKING_HOURS',
		'sum(%s)',
		'TIME_SPEND'
	));

	$query->addGroup('DATE_LOG');
	$query->addGroup('USER_ID');
	$query->addGroup('DESKTOP_CODE');

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

	if ($this->getOrder() !== null)
	{
		$query->setOrder($this->getOrder());
	}

	return $query;
}