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

Introduction

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

Prototype

public boolean isExcludeStatus() 

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  www  .j av  a  2 s.com*/
        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  av a 2s. 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 {/* w ww .ja v  a2 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 {/* w w  w.  j av  a 2s . co  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 {// w  w w  .j  a  va 2s  .co  m
        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 {// w ww . 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 w  w  . java 2  s.  c om*/
        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  w w .ja  v  a  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  w w  w.j a  va 2  s . c o m*/

    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  w  w w  .j  ava  2  s . co  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);
    }
}

---

• «
• 1
• 2
• »