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

Introduction

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

Prototype

public int getEnd() 

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 {/* ww  w. jav a 2  s  .c  o  m*/
        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 {//from www. j ava2  s .  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.  j  a  v a  2 s .  com
        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  a2s .co  m
        return blogsEntryPersistence.findByG_U_S(groupId, userId, queryDefinition.getStatus(),
                queryDefinition.getStart(), queryDefinition.getEnd(), queryDefinition.getOrderByComparator());
    }
}

---

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;/* w w w .  j  av a  2 s .com*/

    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. ja v a2  s .c om*/

    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;//w  w w . ja v  a 2  s  .co m

    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);
    }
}

---

From source file:com.liferay.journal.service.persistence.impl.JournalArticleFinderImpl.java

License:Open Source License

protected List<JournalArticle> doFindByG_F(long groupId, List<Long> folderIds,
        QueryDefinition<JournalArticle> queryDefinition, boolean inlineSQLHelper) {

    Session session = null;// w  ww  .  java  2  s.com

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(getClass(), FIND_BY_G_F, queryDefinition, "JournalArticle");

        sql = replaceStatusJoin(sql, queryDefinition);

        sql = CustomSQLUtil.replaceOrderBy(sql, queryDefinition.getOrderByComparator("JournalArticle"));

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

        sql = StringUtil.replace(sql, "[$FOLDER_ID$]", getFolderIds(folderIds, JournalArticleImpl.TABLE_NAME));

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addEntity(JournalArticleImpl.TABLE_NAME, JournalArticleImpl.class);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);
        qPos.add(queryDefinition.getStatus());

        for (int i = 0; i < folderIds.size(); i++) {
            Long folderId = folderIds.get(i);

            qPos.add(folderId);
        }

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

---

From source file:com.liferay.journal.service.persistence.impl.JournalArticleFinderImpl.java

License:Open Source License

protected List<JournalArticle> doFindByG_C_S(long groupId, long classNameId, String[] ddmStructureKeys,
        QueryDefinition<JournalArticle> queryDefinition, boolean inlineSQLHelper) {

    Session session = null;//  www. j  ava 2 s  . c o m

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(getClass(), FIND_BY_G_C_S, queryDefinition, "JournalArticle");

        sql = replaceStatusJoin(sql, queryDefinition);

        sql = CustomSQLUtil.replaceOrderBy(sql, queryDefinition.getOrderByComparator("JournalArticle"));

        if (groupId <= 0) {
            sql = StringUtil.replace(sql, "(JournalArticle.groupId = ?) AND", StringPool.BLANK);
        }

        sql = StringUtil.replace(sql, "[$DDM_STRUCTURE_KEY$]",
                getDDMStructureKeys(ddmStructureKeys, JournalArticleImpl.TABLE_NAME));

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

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addEntity(JournalArticleImpl.TABLE_NAME, JournalArticleImpl.class);

        QueryPos qPos = QueryPos.getInstance(q);

        if (groupId > 0) {
            qPos.add(groupId);
        }

        qPos.add(classNameId);
        qPos.add(ddmStructureKeys);
        qPos.add(queryDefinition.getStatus());

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

---

From source file:com.liferay.journal.service.persistence.impl.JournalArticleFinderImpl.java

License:Open Source License

protected List<JournalArticle> doFindByG_F_C(long groupId, List<Long> folderIds, long classNameId,
        QueryDefinition<JournalArticle> queryDefinition, boolean inlineSQLHelper) {

    Session session = null;/*ww  w. j  av  a2  s. co  m*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(getClass(), FIND_BY_G_U_F_C, queryDefinition, "JournalArticle");

        sql = replaceStatusJoin(sql, queryDefinition);

        sql = CustomSQLUtil.replaceOrderBy(sql, queryDefinition.getOrderByComparator("JournalArticle"));

        if (folderIds.isEmpty()) {
            sql = StringUtil.replace(sql, "([$FOLDER_ID$]) AND", StringPool.BLANK);
        } else {
            sql = StringUtil.replace(sql, "[$FOLDER_ID$]",
                    getFolderIds(folderIds, JournalArticleImpl.TABLE_NAME));
        }

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

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addEntity(JournalArticleImpl.TABLE_NAME, JournalArticleImpl.class);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);
        qPos.add(classNameId);

        if (queryDefinition.getOwnerUserId() > 0) {
            qPos.add(queryDefinition.getOwnerUserId());

            if (queryDefinition.isIncludeOwner()) {
                qPos.add(WorkflowConstants.STATUS_IN_TRASH);
            }
        }

        for (long folderId : folderIds) {
            qPos.add(folderId);
        }

        qPos.add(queryDefinition.getStatus());

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

---

• «
• 1
• 2
• »