protected Task toUnwrappedModel(Task task) { if (task instanceof TaskImpl) { return task; } TaskImpl taskImpl = new TaskImpl(); taskImpl.setNew(task.isNew()); taskImpl.setPrimaryKey(task.getPrimaryKey()); taskImpl.setTaskId(task.getTaskId()); taskImpl.setUserId(task.getUserId()); taskImpl.setName(task.getName()); taskImpl.setDescription(task.getDescription()); taskImpl.setDate(task.getDate()); taskImpl.setCompleted(task.getCompleted()); taskImpl.setCalendarBookingId(task.getCalendarBookingId()); return taskImpl; }
/** * Returns an ordered range of all the tasks where userId = ?. * * <p>Useful when paginating results. Returns a maximum of <code>end - start</code> instances. * <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result * set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start * </code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} * will return the full result set. If <code>orderByComparator</code> is specified, then the query * will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and * pagination is required (<code>start</code> and <code>end</code> are not {@link * com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default * ORDER BY logic from {@link com.rivetlogic.portlet.todo.model.impl.TaskModelImpl}. If both * <code>orderByComparator</code> and pagination are absent, for performance reasons, the query * will not have an ORDER BY clause and the returned result set will be sorted on by the primary * key in an ascending order. * * @param userId the user ID * @param start the lower bound of the range of tasks * @param end the upper bound of the range of tasks (not inclusive) * @param orderByComparator the comparator to order the results by (optionally <code>null</code>) * @return the ordered range of matching tasks * @throws SystemException if a system exception occurred */ @Override public List<Task> findByuserId( long userId, int start, int end, OrderByComparator orderByComparator) throws SystemException { boolean pagination = true; FinderPath finderPath = null; Object[] finderArgs = null; if ((start == QueryUtil.ALL_POS) && (end == QueryUtil.ALL_POS) && (orderByComparator == null)) { pagination = false; finderPath = FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_USERID; finderArgs = new Object[] {userId}; } else { finderPath = FINDER_PATH_WITH_PAGINATION_FIND_BY_USERID; finderArgs = new Object[] {userId, start, end, orderByComparator}; } List<Task> list = (List<Task>) FinderCacheUtil.getResult(finderPath, finderArgs, this); if ((list != null) && !list.isEmpty()) { for (Task task : list) { if ((userId != task.getUserId())) { list = null; break; } } } if (list == null) { StringBundler query = null; if (orderByComparator != null) { query = new StringBundler(3 + (orderByComparator.getOrderByFields().length * 3)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_TASK_WHERE); query.append(_FINDER_COLUMN_USERID_USERID_2); if (orderByComparator != null) { appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, orderByComparator); } else if (pagination) { query.append(TaskModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Session session = null; try { session = openSession(); Query q = session.createQuery(sql); QueryPos qPos = QueryPos.getInstance(q); qPos.add(userId); if (!pagination) { list = (List<Task>) QueryUtil.list(q, getDialect(), start, end, false); Collections.sort(list); list = new UnmodifiableList<Task>(list); } else { list = (List<Task>) QueryUtil.list(q, getDialect(), start, end); } cacheResult(list); FinderCacheUtil.putResult(finderPath, finderArgs, list); } catch (Exception e) { FinderCacheUtil.removeResult(finderPath, finderArgs); throw processException(e); } finally { closeSession(session); } } return list; }