ScheduleRepository::findByIdWithShifts

public function findByIdWithShifts($id)
{
	if (!($id > 0))
	{
		return null;
	}
	return $this->getActiveSchedulesQuery()
		->addSelect('*')
		->addSelect('SHIFTS')
		->where('ID', $id)
		->where(Query::filter()->logic('or')
			->where('SHIFTS.DELETED', ShiftTable::DELETED_NO)
			->whereNull('SHIFTS.DELETED')
		)
		->exec()
		->fetchObject();
}