Example usage for org.hibernate.criterion Restrictions disjunction

Introduction

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

Prototype

public static Disjunction disjunction() 

Source Link

Document

Group expressions together in a single disjunction (A or B or C...).

Usage

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

public int countInvoiceWarehouseOutList(String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(InvoiceWarehouseOutEntity.class);

    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("number", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("warehouse_code", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("destination_code", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("shipping_number", "%" + keyword + "%"));

    c.add(disjunction);/*w  w w.  j  a  va2 s  .c  om*/
    c.setProjection(Projections.rowCount());
    List result = c.list();
    int resultint = Integer.valueOf(result.get(0).toString());

    return resultint;
}

---

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

public List getPaymentInList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(PaymentInEntity.class);

    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("number", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("warehouse_code", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("partner_name", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("currency_code", "%" + keyword + "%"));

    c.add(disjunction);/*w w w .j  a v a2 s  .c o  m*/

    if (sort.contains("-")) {
        c.addOrder(Order.desc(sort.substring(1)));
    } else {
        c.addOrder(Order.asc(sort));
    }
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    c.setFirstResult(itemperpage * (page - 1));
    c.setMaxResults(itemperpage);

    return c.list();
}

---

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

public int countPaymentInList(String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(PaymentInEntity.class);

    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("number", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("warehouse_code", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("partner_name", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("currency_code", "%" + keyword + "%"));

    c.add(disjunction);// ww w  . j a  va 2 s .  co m

    c.setProjection(Projections.rowCount());
    List result = c.list();
    int resultint = Integer.valueOf(result.get(0).toString());

    return resultint;
}

---

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

public List getPaymentOutList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(PaymentOutEntity.class);

    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("number", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("warehouse_code", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("partner_name", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("currency_code", "%" + keyword + "%"));

    c.add(disjunction);/*from   w  ww. j  a  v a  2 s.c  om*/

    if (sort.contains("-")) {
        c.addOrder(Order.desc(sort.substring(1)));
    } else {
        c.addOrder(Order.asc(sort));
    }
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    c.setFirstResult(itemperpage * (page - 1));
    c.setMaxResults(itemperpage);

    return c.list();
}

---

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

public int countPaymentOutList(String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(PaymentOutEntity.class);

    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("number", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("warehouse_code", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("partner_name", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("currency_code", "%" + keyword + "%"));

    c.add(disjunction);/*from  w  ww  .  j  a va 2 s  .  c om*/

    c.setProjection(Projections.rowCount());
    List result = c.list();
    int resultint = Integer.valueOf(result.get(0).toString());

    return resultint;
}

---

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

public List getReturnPurchaseList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ReturnPurchaseEntity.class);

    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("number", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("warehouse_code", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("partner_name", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("currency_code", "%" + keyword + "%"));

    c.add(disjunction);//from w  ww  .  j av a 2s  .c o  m

    if (sort.contains("-")) {
        c.addOrder(Order.desc(sort.substring(1)));
    } else {
        c.addOrder(Order.asc(sort));
    }
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    c.setFirstResult(itemperpage * (page - 1));
    c.setMaxResults(itemperpage);

    return c.list();
}

---

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

public int countReturnPurchaseList(String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ReturnPurchaseEntity.class);

    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("number", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("warehouse_code", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("partner_name", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("currency_code", "%" + keyword + "%"));

    c.add(disjunction);/*  www. j  ava2s.com*/
    c.setProjection(Projections.rowCount());
    List result = c.list();
    int resultint = Integer.valueOf(result.get(0).toString());

    return resultint;
}

---

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

public List getReturnSalesList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ReturnSalesEntity.class);

    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("number", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("warehouse_code", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("partner_name", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("currency_code", "%" + keyword + "%"));

    c.add(disjunction);//from w w w .j  av a 2s  . c  om

    if (sort.contains("-")) {
        c.addOrder(Order.desc(sort.substring(1)));
    } else {
        c.addOrder(Order.asc(sort));
    }
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    c.setFirstResult(itemperpage * (page - 1));
    c.setMaxResults(itemperpage);

    List ls = c.list();
    return ls;
}

---

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

public int countReturnSalesList(String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ReturnSalesEntity.class);

    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("number", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("warehouse_code", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("partner_name", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("currency_code", "%" + keyword + "%"));

    c.add(disjunction);//from   w ww.  j a va  2 s . com
    c.setProjection(Projections.rowCount());
    List result = c.list();
    int resultint = Integer.valueOf(result.get(0).toString());

    return resultint;
}

---

From source file:net.umpay.mailbill.hql.orm.hibernate.HibernateDao.java

License:Apache License

/**
 * ?Criterion,.//from  w w w .ja  va2 s. c  om
 */
protected Criterion[] buildPropertyFilterCriterions(final List<PropertyFilter> filters) {
    List<Criterion> criterionList = new ArrayList<Criterion>();
    for (PropertyFilter filter : filters) {
        if (!filter.isMultiProperty()) { //??.
            Criterion criterion = buildPropertyFilterCriterion(filter.getPropertyName(),
                    filter.getPropertyValue(), filter.getMatchType());
            criterionList.add(criterion);
        } else {//??,or?.
            Disjunction disjunction = Restrictions.disjunction();
            for (String param : filter.getPropertyNames()) {
                Criterion criterion = buildPropertyFilterCriterion(param, filter.getPropertyValue(),
                        filter.getMatchType());
                disjunction.add(criterion);
            }
            criterionList.add(disjunction);
        }
    }
    return criterionList.toArray(new Criterion[criterionList.size()]);
}

---

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