Example usage for org.hibernate.criterion Restrictions gt

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions gt.

Prototype

public static SimpleExpression gt(String propertyName, Object value) 

Source Link

Document

Apply a "greater than" constraint to the named property

Usage

From source file:net.longfalcon.newsj.persistence.hibernate.ReleaseDAOImpl.java

License:Open Source License

@Override
@Transactional(readOnly = true, propagation = Propagation.SUPPORTS)
public List<Release> findByCategoriesMaxAgeAndGroup(Collection<Integer> categoryIds, Date maxAge,
        Collection<Integer> excludedCategoryIds, Long groupId, String orderByField, boolean descending,
        int offset, int pageSize) {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Release.class);
    if (!categoryIds.isEmpty()) {
        criteria.add(Restrictions.in("category.id", categoryIds));
    }//  ww w  .  j a  va2s.c om
    if (maxAge != null) {
        criteria.add(Restrictions.gt("postDate", maxAge));
    }
    if (excludedCategoryIds != null && !excludedCategoryIds.isEmpty()) {
        criteria.add(Restrictions.not(Restrictions.in("category.id", excludedCategoryIds)));
    }
    if (groupId != null) {
        criteria.add(Restrictions.eq("groupId", groupId));
    }
    if (descending) {
        criteria.addOrder(Order.desc(orderByField));
    } else {
        criteria.addOrder(Order.asc(orderByField));
    }
    criteria.setFetchMode("category", FetchMode.JOIN);
    criteria.setFirstResult(offset).setMaxResults(pageSize);

    return criteria.list();
}

---

From source file:net.longfalcon.newsj.persistence.hibernate.ReleaseDAOImpl.java

License:Open Source License

@Override
@Transactional(readOnly = true, propagation = Propagation.SUPPORTS)
public List<Long> getDistinctImdbIds(List<Integer> searchCategories, int maxAgeDays,
        List<Integer> userExCatIds) {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Release.class);
    if (searchCategories != null && !searchCategories.isEmpty()) {
        criteria.add(Restrictions.in("category.id", searchCategories));
    }//  w  w  w  . j av a  2  s  . c o m

    if (maxAgeDays > 0) {
        Date maxAge = new DateTime().minusDays(maxAgeDays).toDate();
        criteria.add(Restrictions.gt("postDate", maxAge));
    }

    if (!userExCatIds.isEmpty()) {
        criteria.add(Restrictions.not(Restrictions.in("category.id", userExCatIds)));
    }

    criteria.setProjection(Projections.distinct(Projections.property("imdbId")));

    return criteria.list();
}

---

From source file:net.longfalcon.newsj.persistence.hibernate.ReleaseDAOImpl.java

License:Open Source License

@Override
@Transactional(readOnly = true, propagation = Propagation.SUPPORTS)
public List<Release> searchByCategoriesMaxAgeAndGroup(String[] searchTokens, Collection<Integer> categoryIds,
        Date maxAge, Collection<Integer> excludedCategoryIds, Long groupId, String orderByField,
        boolean descending, int offset, int pageSize) {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Release.class);

    addSearchTokens(searchTokens, criteria);

    if (!categoryIds.isEmpty()) {
        criteria.add(Restrictions.in("category.id", categoryIds));
    }/*from  www.  j av a 2s . co  m*/
    if (maxAge != null) {
        criteria.add(Restrictions.gt("postDate", maxAge));
    }
    if (excludedCategoryIds != null && !excludedCategoryIds.isEmpty()) {
        criteria.add(Restrictions.not(Restrictions.in("category.id", excludedCategoryIds)));
    }
    if (groupId != null) {
        criteria.add(Restrictions.eq("groupId", groupId));
    }
    if (descending) {
        criteria.addOrder(Order.desc(orderByField));
    } else {
        criteria.addOrder(Order.asc(orderByField));
    }
    criteria.setFetchMode("category", FetchMode.JOIN);
    criteria.setFirstResult(offset).setMaxResults(pageSize);

    return criteria.list();
}

---

From source file:net.longfalcon.newsj.persistence.hibernate.ReleaseDAOImpl.java

License:Open Source License

@Override
@Transactional(readOnly = true, propagation = Propagation.SUPPORTS)
public Long searchCountByCategoriesMaxAgeAndGroup(String[] searchTokens, Collection<Integer> categoryIds,
        Date maxAge, Collection<Integer> excludedCategoryIds, Long groupId) {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Release.class);

    addSearchTokens(searchTokens, criteria);

    if (!categoryIds.isEmpty()) {
        criteria.add(Restrictions.in("category.id", categoryIds));
    }//from ww w .ja va  2  s.  c  o m
    if (maxAge != null) {
        criteria.add(Restrictions.gt("postDate", maxAge));
    }
    if (excludedCategoryIds != null && !excludedCategoryIds.isEmpty()) {
        criteria.add(Restrictions.not(Restrictions.in("category.id", excludedCategoryIds)));
    }
    if (groupId != null) {
        criteria.add(Restrictions.eq("groupId", groupId));
    }
    criteria.setProjection(Projections.rowCount());

    return (Long) criteria.uniqueResult();
}

---

From source file:net.longfalcon.newsj.persistence.hibernate.ReleaseDAOImpl.java

License:Open Source License

@Override
@Transactional(readOnly = true, propagation = Propagation.SUPPORTS)
public List<Release> searchByCategoriesMaxAgeAndGroup(String[] searchTokens, Long imdbId, Long rageId,
        String season, String episode, Collection<Integer> categoryIds, Date maxAge,
        Collection<Integer> excludedCategoryIds, Long groupId, String orderByField, boolean descending,
        int offset, int pageSize) {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Release.class);

    addSearchTokens(searchTokens, criteria);

    if (ValidatorUtil.isNotNull(imdbId)) {
        criteria.add(Restrictions.eq("imdbId", imdbId));
    }//w  ww  .  j a v a2 s.  c o  m

    if (ValidatorUtil.isNotNull(rageId)) {
        criteria.add(Restrictions.eq("rageId", rageId));
    }

    if (ValidatorUtil.isNotNull(season)) {
        criteria.add(Restrictions.eq("season", season));
    }

    if (ValidatorUtil.isNotNull(episode)) {
        criteria.add(Restrictions.eq("episode", episode));
    }

    if (!categoryIds.isEmpty()) {
        criteria.add(Restrictions.in("category.id", categoryIds));
    }
    if (maxAge != null) {
        criteria.add(Restrictions.gt("postDate", maxAge));
    }
    if (excludedCategoryIds != null && !excludedCategoryIds.isEmpty()) {
        criteria.add(Restrictions.not(Restrictions.in("category.id", excludedCategoryIds)));
    }
    if (groupId != null) {
        criteria.add(Restrictions.eq("groupId", groupId));
    }
    if (descending) {
        criteria.addOrder(Order.desc(orderByField));
    } else {
        criteria.addOrder(Order.asc(orderByField));
    }
    criteria.setFetchMode("category", FetchMode.JOIN);
    criteria.setFirstResult(offset).setMaxResults(pageSize);

    return criteria.list();
}

---

From source file:net.longfalcon.newsj.persistence.hibernate.ReleaseDAOImpl.java

License:Open Source License

@Override
@Transactional(readOnly = true, propagation = Propagation.SUPPORTS)
public Long searchCountByCategoriesMaxAgeAndGroup(String[] searchTokens, Long imdbId, Long rageId,
        String season, String episode, Collection<Integer> categoryIds, Date maxAge,
        Collection<Integer> excludedCategoryIds, Long groupId) {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Release.class);

    addSearchTokens(searchTokens, criteria);

    if (ValidatorUtil.isNotNull(imdbId)) {
        criteria.add(Restrictions.eq("imdbId", imdbId));
    }//from w  w w .  ja  v a2  s .c  o m

    if (ValidatorUtil.isNotNull(rageId)) {
        criteria.add(Restrictions.eq("rageId", rageId));
    }

    if (ValidatorUtil.isNotNull(season)) {
        criteria.add(Restrictions.eq("season", season));
    }

    if (ValidatorUtil.isNotNull(episode)) {
        criteria.add(Restrictions.eq("episode", episode));
    }

    if (!categoryIds.isEmpty()) {
        criteria.add(Restrictions.in("category.id", categoryIds));
    }
    if (maxAge != null) {
        criteria.add(Restrictions.gt("postDate", maxAge));
    }
    if (excludedCategoryIds != null && !excludedCategoryIds.isEmpty()) {
        criteria.add(Restrictions.not(Restrictions.in("category.id", excludedCategoryIds)));
    }
    if (groupId != null) {
        criteria.add(Restrictions.eq("groupId", groupId));
    }
    criteria.setProjection(Projections.rowCount());

    return (Long) criteria.uniqueResult();
}

---

From source file:net.purnama.pureff.dao.ExpensesDao.java

public List getUnpaidExpensesList(PartnerEntity partner, CurrencyEntity currency) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ExpensesEntity.class);
    c.add(Restrictions.eq("partner", partner));
    c.add(Restrictions.eq("currency", currency));
    c.add(Restrictions.eq("status", true));
    c.add(Restrictions.gt("remaining", 0.0));
    c.addOrder(Order.asc("date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    List ls = c.list();//w  ww . j  a v  a2  s. c  o  m
    return ls;
}

---

From source file:net.purnama.pureff.dao.InvoicePurchaseDao.java

public List getUnpaidInvoicePurchaseList(PartnerEntity partner, CurrencyEntity currency) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(InvoicePurchaseEntity.class);
    c.add(Restrictions.eq("partner", partner));
    c.add(Restrictions.eq("currency", currency));
    c.add(Restrictions.eq("status", true));
    c.add(Restrictions.gt("remaining", 0.0));
    c.addOrder(Order.asc("date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    List ls = c.list();/*from w w w .j a v  a  2 s.  co  m*/
    return ls;
}

---

From source file:net.purnama.pureff.dao.InvoiceSalesDao.java

public List getUnpaidInvoiceSalesList(PartnerEntity partner, CurrencyEntity currency) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(InvoiceSalesEntity.class);
    c.add(Restrictions.eq("partner", partner));
    c.add(Restrictions.eq("currency", currency));
    c.add(Restrictions.eq("status", true));
    c.add(Restrictions.gt("remaining", 0.0));
    c.addOrder(Order.asc("date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    List ls = c.list();//from www.  j a  v a 2 s .  c  o  m
    return ls;
}

---

From source file:net.purnama.pureff.dao.ReturnPurchaseDao.java

public List getUnpaidReturnPurchaseList(PartnerEntity partner, CurrencyEntity currency) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ReturnPurchaseEntity.class);
    c.add(Restrictions.eq("partner", partner));
    c.add(Restrictions.eq("currency", currency));
    c.add(Restrictions.eq("status", true));
    c.add(Restrictions.gt("remaining", 0.0));
    c.addOrder(Order.asc("date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    List ls = c.list();//from w  ww .  j a  v  a  2s.c o  m
    return ls;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »