WorktimeRepository::findAllForPeriod

public function findAllForPeriod(DateTime $fromDateTime, DateTime $toDateTime, Schedule $schedule, $userIds)
{
	return WorktimeRecordTable::query()
		->registerRuntimeField(new ExpressionField('DURATION', 'SUM(RECORDED_DURATION)'))
		->addSelect('USER_ID')
		->addSelect('DURATION')
		->where('RECORDED_START_TIMESTAMP', '>', $fromDateTime->getTimestamp())
		->where('RECORDED_START_TIMESTAMP', '<', $toDateTime->getTimestamp())
		->whereIn('USER_ID', $userIds)
		->where('SCHEDULE_ID', $schedule->getId())
		->addGroup('USER_ID')
		->exec()
		->fetchAll();
}