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

Introduction

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

Prototype

public int getStatus() 

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  .  j  a  v  a  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 int getCompanyEntriesCount(long companyId, Date displayDate,
        QueryDefinition<BlogsEntry> queryDefinition) {

    if (queryDefinition.isExcludeStatus()) {
        return blogsEntryPersistence.countByC_LtD_NotS(companyId, displayDate, queryDefinition.getStatus());
    } else {/* w  w w  .j a  v a  2 s .c  o m*/
        return blogsEntryPersistence.countByC_LtD_S(companyId, displayDate, queryDefinition.getStatus());
    }
}

---

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   w w  w  . ja va  2s.  co 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  www.  j  av a2 s . c  o m
        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 int getGroupEntriesCount(long groupId, Date displayDate, QueryDefinition<BlogsEntry> queryDefinition) {

    if (queryDefinition.isExcludeStatus()) {
        return blogsEntryPersistence.countByG_LtD_NotS(groupId, displayDate, queryDefinition.getStatus());
    } else {/*from w w  w.j  a v a2  s  .c  om*/
        return blogsEntryPersistence.countByG_LtD_S(groupId, displayDate, queryDefinition.getStatus());
    }
}

---

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

License:Open Source License

@Override
public int getGroupEntriesCount(long groupId, QueryDefinition<BlogsEntry> queryDefinition) {

    if (queryDefinition.isExcludeStatus()) {
        return blogsEntryPersistence.countByG_NotS(groupId, queryDefinition.getStatus());
    } else {/*from   www.j a v  a  2  s. c om*/
        return blogsEntryPersistence.countByG_S(groupId, queryDefinition.getStatus());
    }
}

---

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 {/*from  w  ww .  j  ava 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.BlogsEntryLocalServiceImpl.java

License:Open Source License

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

    if (queryDefinition.isExcludeStatus()) {
        return blogsEntryPersistence.countByG_U_LtD_NotS(groupId, userId, displayDate,
                queryDefinition.getStatus());
    } else {//  w ww. java  2 s.c o m
        return blogsEntryPersistence.countByG_U_LtD_S(groupId, userId, displayDate,
                queryDefinition.getStatus());
    }
}

---

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

License:Open Source License

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

    Timestamp displayDate_TS = CalendarUtil.getTimestamp(displayDate);

    Session session = null;//from www . j  a va 2  s.  c  om

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(getClass(), COUNT_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));

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

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

        Iterator<Long> itr = q.iterate();

        if (itr.hasNext()) {
            Long count = itr.next();

            if (count != null) {
                return count.intValue();
            }
        }

        return 0;
    } 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> findByGroupIds(long companyId, long groupId, Date displayDate,
        QueryDefinition<BlogsEntry> queryDefinition) {

    Session session = null;/*from  www.  j  av  a2s  .  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);
    }
}

---

• «
• 1
• 2
• 3
• »