WorktimeRepository::buildOpenRecordsQuery

public function buildOpenRecordsQuery(Schedule $schedule, ShiftCollection $shiftCollection)
{
	$filter = Query::filter()
		->where('SCHEDULE_ID', $schedule->getId())
		->where('RECORDED_STOP_TIMESTAMP', 0)
		->where('RECORDED_START_TIMESTAMP', '>', TimeHelper::getInstance()->getUtcNowTimestamp() - (4 * TimeDictionary::SECONDS_PER_DAY));
	if ($shiftCollection->count() > 0)
	{
		$filter->whereIn('SHIFT_ID', $shiftCollection->getIdList());
	}
	return $filter;
}