Example usage for org.hibernate.criterion Restrictions ge

Introduction

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

Prototype

public static SimpleExpression ge(String propertyName, Object value) 

Source Link

Document

Apply a "greater than or equal" constraint to the named property

Usage

From source file:com.salesmanager.core.service.order.impl.dao.OrderDao.java

License:Open Source License

@SuppressWarnings("unchecked")
public Collection<Order> findInvoicesByCustomerAndStartDate(long customerId, Date startDate) {
    Criteria criteria = super.getSession().createCriteria(Order.class)
            .add(Restrictions.eq("customerId", customerId))
            .add(Restrictions.eq("channel", OrderConstants.INVOICE_CHANNEL))
            .add(Restrictions.ge("datePurchased", startDate))
            .addOrder(org.hibernate.criterion.Order.desc("orderId"));

    return criteria.list();

}

---

From source file:com.salesmanager.core.service.order.impl.dao.OrderDao.java

License:Open Source License

public SearchOrderResponse searchInvoice(SearchOrdersCriteria searchCriteria) {

    Criteria criteria = super.getSession().createCriteria(Order.class)
            .add(Restrictions.eq("merchantId", searchCriteria.getMerchantId()))
            .add(Restrictions.eq("channel", OrderConstants.INVOICE_CHANNEL))
            .add(Restrictions.eq("orderStatus", OrderConstants.STATUSINVOICED))
            .addOrder(org.hibernate.criterion.Order.desc("orderId"))
            .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);

    StringBuffer q = new StringBuffer();

    q.append(" select o from Order o where o.merchantId=:mId");
    q.append(" and channel=:channel and orderStatus=:status");

    if (searchCriteria != null) {

        if (!StringUtils.isBlank(searchCriteria.getCustomerName())) {
            q.append(" and o.customerName like %:cName%");
        }/*from  ww  w . j  ava  2 s .  c  om*/

        if (searchCriteria.getOrderId() != -1) {
            q.append(" and o.orderId=:oId");
        }

        if (searchCriteria.getEdate() != null || searchCriteria.getSdate() != null) {
            if (searchCriteria.getSdate() != null) {
                q.append(" and o.datePurchased > :sDate");
            } else {
                q.append(" and o.datePurchased > :sDate");
            }
            if (searchCriteria.getEdate() != null) {
                q.append(" and o.datePurchased < :eDate");
            } else {
                q.append(" and o.datePurchased < :eDate");
            }
        }
    }
    q.append(" order by o.orderId desc");

    Query c = super.getSession().createQuery(q.toString());
    c.setInteger("channel", OrderConstants.INVOICE_CHANNEL);
    c.setInteger("status", OrderConstants.STATUSINVOICED);
    c.setInteger("mId", searchCriteria.getMerchantId());

    if (searchCriteria != null) {

        if (!StringUtils.isBlank(searchCriteria.getCustomerName())) {
            criteria.add(Restrictions.like("customerName", "%" + searchCriteria.getCustomerName() + "%"));
            c.setString("cName", "%" + searchCriteria.getCustomerName() + "%");
        }

        if (searchCriteria.getOrderId() != -1) {
            criteria.add(Restrictions.eq("orderId", searchCriteria.getOrderId()));
            c.setLong("oId", searchCriteria.getOrderId());
        }

        if (searchCriteria.getEdate() != null || searchCriteria.getSdate() != null) {
            if (searchCriteria.getSdate() != null) {
                criteria.add(Restrictions.ge("datePurchased", searchCriteria.getSdate()));
                c.setDate("sDate", searchCriteria.getSdate());
            } else {
                criteria.add(Restrictions.ge("datePurchased", DateUtils.addDays(new Date(), -1)));
                c.setDate("sDate", DateUtils.addDays(new Date(), -1));
            }
            if (searchCriteria.getEdate() != null) {
                criteria.add(Restrictions.le("datePurchased", searchCriteria.getEdate()));
                c.setDate("eDate", searchCriteria.getEdate());
            } else {
                criteria.add(Restrictions.ge("datePurchased", DateUtils.addDays(new Date(), +1)));
                c.setDate("eDate", DateUtils.addDays(new Date(), +1));
            }
        }
    }

    criteria.setProjection(Projections.rowCount());
    Integer count = (Integer) criteria.uniqueResult();

    criteria.setProjection(null);

    int max = searchCriteria.getQuantity();

    List list = null;
    if (max != -1 && count > 0) {
        list = c.setMaxResults(searchCriteria.getUpperLimit(count))
                .setFirstResult(searchCriteria.getLowerLimit()).list();
    } else {
        list = c.list();
    }

    SearchOrderResponse response = new SearchOrderResponse();
    response.setCount(count);
    response.setOrders(list);

    return response;

}

---

From source file:com.salesmanager.core.service.order.impl.dao.OrderDao.java

License:Open Source License

public SearchOrderResponse searchOrder(SearchOrdersCriteria searchCriteria) {

    Criteria criteria = super.getSession().createCriteria(Order.class)
            .add(Restrictions.eq("merchantId", searchCriteria.getMerchantId()))
            .add(Restrictions.eq("channel", OrderConstants.ONLINE_CHANNEL))
            .addOrder(org.hibernate.criterion.Order.desc("orderId"))
            .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);

    StringBuffer q = new StringBuffer();

    q.append(" select o from Order o where o.merchantId=:mId");
    q.append(" and channel=:channel");

    if (searchCriteria != null) {

        if (!StringUtils.isBlank(searchCriteria.getCustomerName())) {
            q.append(" and o.customerName like :cName");
        }/*from  w w  w.ja  va  2s.c  om*/

        if (searchCriteria.getOrderId() != -1) {
            q.append(" and o.orderId= :oId");
        }

        if (searchCriteria.getEdate() != null || searchCriteria.getSdate() != null) {
            if (searchCriteria.getSdate() != null) {
                q.append(" and o.datePurchased > :sDate");
            } else {
                q.append(" and o.datePurchased > :sDate");
            }
            if (searchCriteria.getEdate() != null) {
                q.append(" and o.datePurchased < :eDate");
            } else {
                q.append(" and o.datePurchased < :eDate");
            }
        }
    }
    q.append(" order by o.orderId desc");

    Query c = super.getSession().createQuery(q.toString());
    c.setInteger("channel", OrderConstants.ONLINE_CHANNEL);
    c.setInteger("mId", searchCriteria.getMerchantId());

    if (searchCriteria != null) {

        if (!StringUtils.isBlank(searchCriteria.getCustomerName())) {
            criteria.add(Restrictions.like("customerName", "%" + searchCriteria.getCustomerName() + "%"));
            c.setString("cName", "%" + searchCriteria.getCustomerName() + "%");
        }

        if (searchCriteria.getOrderId() != -1) {
            criteria.add(Restrictions.eq("orderId", searchCriteria.getOrderId()));
            c.setLong("oId", searchCriteria.getOrderId());
        }

        if (searchCriteria.getEdate() != null || searchCriteria.getSdate() != null) {
            if (searchCriteria.getSdate() != null) {
                criteria.add(Restrictions.ge("datePurchased", searchCriteria.getSdate()));
                c.setDate("sDate", searchCriteria.getSdate());
            } else {
                criteria.add(Restrictions.ge("datePurchased", DateUtils.addDays(new Date(), -1)));
                c.setDate("sDate", DateUtils.addDays(new Date(), -1));
            }
            if (searchCriteria.getEdate() != null) {
                criteria.add(Restrictions.le("datePurchased", searchCriteria.getEdate()));
                c.setDate("eDate", searchCriteria.getEdate());
            } else {
                criteria.add(Restrictions.ge("datePurchased", DateUtils.addDays(new Date(), +1)));
                c.setDate("eDate", DateUtils.addDays(new Date(), +1));
            }
        }
    }

    criteria.setProjection(Projections.rowCount());
    Integer count = (Integer) criteria.uniqueResult();

    criteria.setProjection(null);

    int max = searchCriteria.getQuantity();

    List list = null;
    if (max != -1 && count > 0) {
        c.setMaxResults(searchCriteria.getUpperLimit(count));
        c.setFirstResult(searchCriteria.getLowerLimit());
        list = c.list();
    } else {
        list = c.list();
    }

    SearchOrderResponse response = new SearchOrderResponse();
    response.setCount(count);
    response.setOrders(list);

    return response;

}

---

From source file:com.sapienter.jbilling.server.invoice.db.InvoiceDAS.java

License:Open Source License

private void addPeriodCriteria(Criteria criteria, Date start, Date end) {
    criteria.add(Restrictions.ge("createDatetime", start)).add(Restrictions.lt("createDatetime", end));
}

---

From source file:com.sapienter.jbilling.server.payment.db.PaymentAuthorizationDAS.java

License:Open Source License

public Collection<PaymentAuthorizationDTO> findByDateAndCode(String approvalCode, Date createDatetime,
        String dateTimeComparator, Integer entityId) {
    /*TODO should add some form of restriction maybe for entities and/or users?
     * /*from ww w  .ja  va 2s.co  m*/
     */
    Criteria criteria = getSession().createCriteria(PaymentAuthorizationDTO.class);
    criteria.add(Restrictions.eq("approvalCode", approvalCode));
    if (dateTimeComparator.equalsIgnoreCase(">=")) {
        criteria.add(Restrictions.ge("createDate", createDatetime));
    } else if (dateTimeComparator.equalsIgnoreCase("<=")) {
        criteria.add(Restrictions.le("createDate", createDatetime));
    }

    return criteria.list();
}

---

From source file:com.sapienter.jbilling.server.payment.db.PaymentDAS.java

License:Open Source License

/**
 * * query="SELECT OBJECT(p) FROM payment p WHERE p.userId = ?1 AND
 * p.balance >= 0.01 AND p.isRefund = 0 AND p.isPreauth = 0 AND p.deleted =
 * 0"/*from ww  w  .ja  va2 s . c  o m*/
 * 
 * @param userId
 * @return
 */
public Collection findWithBalance(Integer userId) {

    UserDTO user = new UserDAS().find(userId);

    Criteria criteria = getSession().createCriteria(PaymentDTO.class);
    criteria.add(Restrictions.eq("baseUser", user));
    criteria.add(Restrictions.ge("balance", Constants.BIGDECIMAL_ONE_CENT));
    criteria.add(Restrictions.eq("isRefund", 0));
    criteria.add(Restrictions.eq("isPreauth", 0));
    criteria.add(Restrictions.eq("deleted", 0));

    return criteria.list();
}

---

From source file:com.sapienter.jbilling.server.payment.db.PaymentDAS.java

License:Open Source License

/**
 * //from ww w. j a  va2 s .com
 * query="SELECT OBJECT(p) FROM payment p WHERE 
 * p.userId = ?1 AND 
 * p.balance >= 0.01 AND 
 * p.isRefund = 0 AND 
 * p.isPreauth = 1 AND 
 * p.deleted = 0"
 * 
 * @param userId
 * @return
 */
public Collection<PaymentDTO> findPreauth(Integer userId) {

    UserDTO user = new UserDAS().find(userId);

    Criteria criteria = getSession().createCriteria(PaymentDTO.class);
    criteria.add(Restrictions.eq("baseUser", user));
    criteria.add(Restrictions.ge("balance", Constants.BIGDECIMAL_ONE_CENT));
    criteria.add(Restrictions.eq("isRefund", 0));
    criteria.add(Restrictions.eq("isPreauth", 1));
    criteria.add(Restrictions.eq("deleted", 0));

    return criteria.list();

}

---

From source file:com.sccl.attech.modules.sys.service.SystemService.java

License:Open Source License

/**
 * /*from   w  ww .j a v a2s . c  om*/
 * @param vote
 * @return
 */
public Page<Vote> find(Page<Vote> page, Vote vote, int type) {
    //System.out.println(page.getPageNo() + "---------------- ?count");
    //System.out.println(page.getPageSize() + "----------------?size");
    DetachedCriteria dc = voteDao.createDetachedCriteria();

    //      dc.createAlias("createBy.office", "office");
    //      dc.add(dataScopeFilter(user, "office", "createBy"));
    if (type == 0) {//
        if (StringUtils.isNotEmpty(vote.getVotingContent())) {
            dc.add(Restrictions.like("votingContent", "%" + vote.getVotingContent() + "%"));
        }
        dc.add(Restrictions.eq(Vote.FIELD_DEL_FLAG, Vote.DEL_FLAG_NORMAL));
        System.out.println("0");
    } else if (type == 1) {//
        dc.add(Restrictions.eq(Vote.SEL_ISEND, Vote.IS_END_NO));
        dc.add(Restrictions.ge(Vote.SEL_DEADLINE, Vote.SEl_DATE));
        System.out.println("1");
    } else if (type == 2) {//
        dc.add(Restrictions.eq(Vote.SEL_ISEND, Vote.IS_END_YES));
        System.out.println("2");
    } else if (type == 3) {//?
        dc.add(Restrictions.lt(Vote.SEL_DEADLINE, Vote.SEl_DATE));
        System.out.println("3");
    } else if (type == 4) {//?
        if (StringUtils.isNotEmpty(vote.getVotingContent())) {
            dc.add(Restrictions.like("votingContent", "%" + vote.getVotingContent() + "%"));
        }
        dc.add(Restrictions.eq(Vote.SEL_ISEND, Vote.IS_END_NO));
        dc.add(Restrictions.ge(Vote.SEL_DEADLINE, Vote.SEl_DATE));
        //??
        User user = UserUtils.getUser();
        DetachedCriteria dc2 = userVoteDao.createDetachedCriteria();
        dc2.add(Restrictions.eq(UserVote.USER_VOTE_USER_ID, user.getId()));
        List<UserVote> list = userVoteDao.find(dc2);
        //?
        for (UserVote ut : list) {
            dc.add(Restrictions.ne(Vote.VOTE_ID, ut.getVoteId()));
        }
    } else if (type == 5) {//??
        if (StringUtils.isNotEmpty(vote.getVotingContent())) {
            dc.add(Restrictions.like("votingContent", "%" + vote.getVotingContent() + "%"));
        }
        User user = UserUtils.getUser();
        DetachedCriteria dc2 = userVoteDao.createDetachedCriteria();
        dc2.add(Restrictions.eq(UserVote.USER_VOTE_USER_ID, user.getId()));
        List<UserVote> list = userVoteDao.find(dc2);
        List<String> list1 = new ArrayList();
        for (UserVote uVote : list) {
            list1.add(uVote.getVoteId());
        }
        dc.add(Restrictions.in(Vote.VOTE_ID, list1));
    }
    dc.addOrder(Order.desc("createDate"));
    return voteDao.find(page, dc);
}

---

From source file:com.sccl.attech.modules.sys.utils.CriteriaUtil.java

License:Open Source License

public static void createDateCond(DetachedCriteria dc, DataEntity<?> entity) {
    if (null == entity)
        return;/*from w ww .  ja v a 2s.  c  o  m*/
    if (null != entity.getUpdateDateStart())
        dc.add(Restrictions.ge("updateDate", entity.getUpdateDateStart()));
    if (null != entity.getUpdateDateEnd())
        dc.add(Restrictions.le("updateDate", entity.getUpdateDateEnd()));
}

---

From source file:com.scopix.periscope.extractionplanmanagement.dao.ExtractionPlanCustomizingDAOImpl.java

License:Open Source License

@Override
public List<EvidenceRequest> getEvidenceRequestList(EvidenceRequest evidenceRequest, Date init, Date end) {
    List<EvidenceRequest> list = null;
    Session session = this.getSession();
    try {// w w  w.j a v  a 2  s.  c  om
        Criteria criteria = session.createCriteria(EvidenceRequest.class);
        criteria.addOrder(Order.asc("id"));
        if (evidenceRequest != null) {
            if (init != null && end != null) {
                criteria.add(Restrictions.ge("evidenceTime", init));
                criteria.add(Restrictions.le("evidenceTime", end));
            } else if (init != null) {
                criteria.add(Restrictions.ge("evidenceTime", init));
            } else if (end != null) {
                criteria.add(Restrictions.le("evidenceTime", end));
            } else if (evidenceRequest.getEvidenceTime() != null) {
                criteria.add(Restrictions.eq("evidenceTime", evidenceRequest.getEvidenceTime()));
            }
            if (evidenceRequest.getType() != null) {
                criteria.add(Restrictions.eq("type", evidenceRequest.getType()));
            }
            if (evidenceRequest.getEvidenceProvider() != null
                    && evidenceRequest.getEvidenceProvider().getId() != null
                    && evidenceRequest.getEvidenceProvider().getId() > 0) {
                criteria.add(
                        Restrictions.eq("evidenceProvider.id", evidenceRequest.getEvidenceProvider().getId()));
            }

            ExtractionPlanMetric epm = evidenceRequest.getMetric().getExtractionPlanMetric();
            if (evidenceRequest.getMetric() != null && epm != null && epm.getExtractionPlanCustomizing() != null
                    && epm.getExtractionPlanCustomizing().isActive() != null) {
                criteria.createCriteria("metric").createCriteria("extractionPlanCustomizing")
                        .add(Restrictions.eq("active", epm.getExtractionPlanCustomizing().isActive()));
            }
        }
        list = criteria.list();
    } catch (HibernateException e) {
        log.error(e, e);
    } finally {
        this.releaseSession(session);
    }
    return list;
}

---

• «
• 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
• »