Example usage for com.liferay.portal.kernel.dao.orm QueryDefinition getStart

List of usage examples for com.liferay.portal.kernel.dao.orm QueryDefinition getStart

  1. HOME
  2. Java
  3. com.liferay.portal
  4. com.liferay.portal.kernel.dao.orm.*
  5. QueryDefinition
  6. getStart

Introduction

In this page you can find the example usage for com.liferay.portal.kernel.dao.orm QueryDefinition getStart.

Prototype

public int getStart()

Source Link

Usage

From source file:com.liferay.blogs.service.impl.BlogsEntryLocalServiceImpl.java

License:Open Source License

@Override
public List<BlogsEntry> getCompanyEntries(long companyId, Date displayDate,
        QueryDefinition<BlogsEntry> queryDefinition) {

    if (queryDefinition.isExcludeStatus()) {
        return blogsEntryPersistence.findByC_LtD_NotS(companyId, displayDate, queryDefinition.getStatus(),
                queryDefinition.getStart(), queryDefinition.getEnd(), queryDefinition.getOrderByComparator());
    } else {//from   ww w .  j  a va  2 s .  c om
        return blogsEntryPersistence.findByC_LtD_S(companyId, displayDate, queryDefinition.getStatus(),
                queryDefinition.getStart(), queryDefinition.getEnd(), queryDefinition.getOrderByComparator());
    }
}

From source file:com.liferay.blogs.service.impl.BlogsEntryLocalServiceImpl.java

License:Open Source License

@Override
public List<BlogsEntry> getGroupEntries(long groupId, Date displayDate,
        QueryDefinition<BlogsEntry> queryDefinition) {

    if (queryDefinition.isExcludeStatus()) {
        return blogsEntryPersistence.findByG_LtD_NotS(groupId, displayDate, queryDefinition.getStatus(),
                queryDefinition.getStart(), queryDefinition.getEnd(), queryDefinition.getOrderByComparator());
    } else {/* www. j  a v  a 2s.  c  o m*/
        return blogsEntryPersistence.findByG_LtD_S(groupId, displayDate, queryDefinition.getStatus(),
                queryDefinition.getStart(), queryDefinition.getEnd(), queryDefinition.getOrderByComparator());
    }
}

From source file:com.liferay.blogs.service.impl.BlogsEntryLocalServiceImpl.java

License:Open Source License

@Override
public List<BlogsEntry> getGroupEntries(long groupId, QueryDefinition<BlogsEntry> queryDefinition) {

    if (queryDefinition.isExcludeStatus()) {
        return blogsEntryPersistence.findByG_NotS(groupId, queryDefinition.getStatus(),
                queryDefinition.getStart(), queryDefinition.getEnd(), queryDefinition.getOrderByComparator());
    } else {/*from   ww w  .  ja  v  a 2s  . c om*/
        return blogsEntryPersistence.findByG_S(groupId, queryDefinition.getStatus(), queryDefinition.getStart(),
                queryDefinition.getEnd(), queryDefinition.getOrderByComparator());
    }
}

From source file:com.liferay.blogs.service.impl.BlogsEntryLocalServiceImpl.java

License:Open Source License

@Override
public List<BlogsEntry> getGroupUserEntries(long groupId, long userId, Date displayDate,
        QueryDefinition<BlogsEntry> queryDefinition) {

    if (queryDefinition.isExcludeStatus()) {
        return blogsEntryPersistence.findByG_U_NotS(groupId, userId, queryDefinition.getStatus(),
                queryDefinition.getStart(), queryDefinition.getEnd(), queryDefinition.getOrderByComparator());
    } else {// w w  w  . j a  v a  2  s  .  c  o m
        return blogsEntryPersistence.findByG_U_S(groupId, userId, queryDefinition.getStatus(),
                queryDefinition.getStart(), queryDefinition.getEnd(), queryDefinition.getOrderByComparator());
    }
}

From source file:com.liferay.blogs.service.impl.BlogsEntryServiceImpl.java

License:Open Source License

@Override
public List<BlogsEntry> getCompanyEntries(long companyId, Date displayDate, int status, int max)
        throws PortalException {

    List<BlogsEntry> entries = new ArrayList<>();

    boolean listNotExhausted = true;

    QueryDefinition<BlogsEntry> queryDefinition = new QueryDefinition<>(status, false, 0, 0,
            new EntryDisplayDateComparator());

    if (status == WorkflowConstants.STATUS_ANY) {
        queryDefinition.setStatus(WorkflowConstants.STATUS_IN_TRASH, true);
    }//from  www.  ja v a  2  s . co  m

    while ((entries.size() < max) && listNotExhausted) {
        queryDefinition.setEnd(queryDefinition.getStart() + max);

        List<BlogsEntry> entryList = blogsEntryLocalService.getCompanyEntries(companyId, displayDate,
                queryDefinition);

        queryDefinition.setStart(queryDefinition.getStart() + max);

        listNotExhausted = (entryList.size() == max);

        for (BlogsEntry entry : entryList) {
            if (entries.size() >= max) {
                break;
            }

            if (BlogsEntryPermission.contains(getPermissionChecker(), entry, ActionKeys.VIEW)) {

                entries.add(entry);
            }
        }
    }

    return entries;
}

From source file:com.liferay.blogs.service.impl.BlogsEntryServiceImpl.java

License:Open Source License

@Override
public List<BlogsEntry> getGroupsEntries(long companyId, long groupId, Date displayDate, int status, int max)
        throws PortalException {

    List<BlogsEntry> entries = new ArrayList<>();

    boolean listNotExhausted = true;

    QueryDefinition<BlogsEntry> queryDefinition = new QueryDefinition<>(status, false, 0, 0,
            new EntryDisplayDateComparator());

    if (status == WorkflowConstants.STATUS_ANY) {
        queryDefinition.setStatus(WorkflowConstants.STATUS_IN_TRASH, true);
    }/*from  w  ww  .j a v a  2  s  . c o m*/

    while ((entries.size() < max) && listNotExhausted) {
        queryDefinition.setEnd(queryDefinition.getStart() + max);

        List<BlogsEntry> entryList = blogsEntryLocalService.getGroupsEntries(companyId, groupId, displayDate,
                queryDefinition);

        queryDefinition.setStart(queryDefinition.getStart() + max);

        listNotExhausted = (entryList.size() == max);

        for (BlogsEntry entry : entryList) {
            if (entries.size() >= max) {
                break;
            }

            if (BlogsEntryPermission.contains(getPermissionChecker(), entry, ActionKeys.VIEW)) {

                entries.add(entry);
            }
        }
    }

    return entries;
}

From source file:com.liferay.blogs.service.impl.BlogsEntryServiceImpl.java

License:Open Source License

@Override
public List<BlogsEntry> getOrganizationEntries(long organizationId, Date displayDate, int status, int max)
        throws PortalException {

    List<BlogsEntry> entries = new ArrayList<>();

    boolean listNotExhausted = true;

    QueryDefinition<BlogsEntry> queryDefinition = new QueryDefinition<>(status, false, 0, 0,
            new EntryDisplayDateComparator());

    if (status == WorkflowConstants.STATUS_ANY) {
        queryDefinition.setStatus(WorkflowConstants.STATUS_IN_TRASH, true);
    }/* ww  w . j a v  a2  s.  c  om*/

    while ((entries.size() < max) && listNotExhausted) {
        queryDefinition.setEnd(queryDefinition.getStart() + max);

        List<BlogsEntry> entryList = blogsEntryFinder.findByOrganizationId(organizationId, displayDate,
                queryDefinition);

        queryDefinition.setStart(queryDefinition.getStart() + max);

        listNotExhausted = (entryList.size() == max);

        for (BlogsEntry entry : entryList) {
            if (entries.size() >= max) {
                break;
            }

            if (BlogsEntryPermission.contains(getPermissionChecker(), entry, ActionKeys.VIEW)) {

                entries.add(entry);
            }
        }
    }

    return entries;
}

From source file:com.liferay.blogs.service.persistence.impl.BlogsEntryFinderImpl.java

License:Open Source License

@Override
public List<BlogsEntry> findByGroupIds(long companyId, long groupId, Date displayDate,
        QueryDefinition<BlogsEntry> queryDefinition) {

    Session session = null;/*www  .  j a v  a 2s  .  c  o  m*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(getClass(), FIND_BY_GROUP_IDS);

        if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) {
            if (queryDefinition.isExcludeStatus()) {
                sql = CustomSQLUtil.appendCriteria(sql, "AND (BlogsEntry.status != ?)");
            } else {
                sql = CustomSQLUtil.appendCriteria(sql, "AND (BlogsEntry.status = ?)");
            }
        }

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addEntity("BlogsEntry", BlogsEntryImpl.class);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(companyId);
        qPos.add(groupId);
        qPos.add(groupId);
        qPos.add(groupId);
        qPos.add(displayDate);

        if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) {
            qPos.add(queryDefinition.getStatus());
        }

        return (List<BlogsEntry>) QueryUtil.list(q, getDialect(), queryDefinition.getStart(),
                queryDefinition.getEnd());
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

From source file:com.liferay.blogs.service.persistence.impl.BlogsEntryFinderImpl.java

License:Open Source License

@Override
public List<BlogsEntry> findByOrganizationIds(List<Long> organizationIds, Date displayDate,
        QueryDefinition<BlogsEntry> queryDefinition) {

    Timestamp displayDate_TS = CalendarUtil.getTimestamp(displayDate);

    Session session = null;//w  w  w.j  a v a2 s. c  o m

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(getClass(), FIND_BY_ORGANIZATION_IDS);

        if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) {
            if (queryDefinition.isExcludeStatus()) {
                sql = CustomSQLUtil.appendCriteria(sql, "AND (BlogsEntry.status != ?)");
            } else {
                sql = CustomSQLUtil.appendCriteria(sql, "AND (BlogsEntry.status = ?)");
            }
        }

        sql = StringUtil.replace(sql, "[$ORGANIZATION_ID$]", getOrganizationIds(organizationIds));
        sql = CustomSQLUtil.replaceOrderBy(sql, queryDefinition.getOrderByComparator());

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addEntity("BlogsEntry", BlogsEntryImpl.class);

        QueryPos qPos = QueryPos.getInstance(q);

        for (Long organizationId : organizationIds) {
            qPos.add(organizationId);
        }

        qPos.add(displayDate_TS);

        if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) {
            qPos.add(queryDefinition.getStatus());
        }

        return (List<BlogsEntry>) QueryUtil.list(q, getDialect(), queryDefinition.getStart(),
                queryDefinition.getEnd());
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

From source file:com.liferay.bookmarks.service.persistence.impl.BookmarksFolderFinderImpl.java

License:Open Source License

protected List<Object> doFindF_E_ByG_F(long groupId, long folderId, QueryDefinition<?> queryDefinition,
        boolean inlineSQLHelper) {

    Session session = null;//from   w  w  w  .ja va2  s  .  c om

    try {
        session = openSession();

        StringBundler sb = new StringBundler(5);

        sb.append("SELECT * FROM (");

        String sql = null;

        if (queryDefinition.getStatus() == WorkflowConstants.STATUS_ANY) {
            sql = CustomSQLUtil.get(getClass(), FIND_F_BY_G_P);
        } else {
            sql = CustomSQLUtil.get(getClass(), FIND_F_BY_G_P_S);

            sql = replaceExcludeStatus(sql, queryDefinition);
        }

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql, BookmarksFolder.class.getName(),
                    "BookmarksFolder.folderId", groupId);
        }

        sb.append(sql);
        sb.append(" UNION ALL ");

        if (queryDefinition.getStatus() == WorkflowConstants.STATUS_ANY) {
            sql = CustomSQLUtil.get(getClass(), FIND_E_BY_G_F);
        } else {
            sql = CustomSQLUtil.get(getClass(), FIND_E_BY_G_F_S);

            sql = replaceExcludeStatus(sql, queryDefinition);
        }

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql, BookmarksEntry.class.getName(),
                    "BookmarksEntry.fileEntryId", groupId);
        }

        sb.append(sql);
        sb.append(") TEMP_TABLE ORDER BY modelName ASC");

        sql = sb.toString();

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar("modelId", Type.LONG);
        q.addScalar("modelName", Type.STRING);
        q.addScalar("modelFolder", Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);
        qPos.add(folderId);

        if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) {
            qPos.add(queryDefinition.getStatus());
        }

        qPos.add(groupId);
        qPos.add(folderId);

        if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) {
            qPos.add(queryDefinition.getStatus());
        }

        List<Object> models = new ArrayList<>();

        Iterator<Object[]> itr = (Iterator<Object[]>) QueryUtil.iterate(q, getDialect(),
                queryDefinition.getStart(), queryDefinition.getEnd());

        while (itr.hasNext()) {
            Object[] array = itr.next();

            long modelId = (Long) array[0];
            //String name = (String)array[1];
            long modelFolder = (Long) array[2];

            Object obj = null;

            if (modelFolder == 0) {
                obj = BookmarksFolderUtil.findByPrimaryKey(modelId);
            } else {
                obj = BookmarksEntryUtil.findByPrimaryKey(modelId);
            }

            models.add(obj);
        }

        return models;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}