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.DeliveryDao.java

public int countDeliveryList(String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(DeliveryEntity.class);
    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("number", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("warehouse_code", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("destination", "%" + keyword + "%"));

    c.add(disjunction);//from  www .  j a v a 2s  .c  o  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.ExpensesDao.java

public List getExpensesList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ExpensesEntity.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 .co 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.ExpensesDao.java

public int countExpensesList(String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ExpensesEntity.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  . jav  a2 s.  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.InvoicePurchaseDao.java

public List getInvoicePurchaseList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(InvoicePurchaseEntity.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  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.InvoicePurchaseDao.java

public int countInvoicePurchaseList(String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(InvoicePurchaseEntity.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  ava 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.InvoiceSalesDao.java

public List getInvoiceSalesList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(InvoiceSalesEntity.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  2  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.InvoiceSalesDao.java

public int countInvoiceSalesList(String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(InvoiceSalesEntity.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  va2 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.InvoiceWarehouseInDao.java

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

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

    c.add(disjunction);/*from   ww  w.  j  a v a  2  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.InvoiceWarehouseInDao.java

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

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

    c.add(disjunction);//from ww  w  .  j a  v  a  2 s  .c  o 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.InvoiceWarehouseOutDao.java

public List getInvoiceWarehouseOutList(int itemperpage, int page, String sort, 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);/*from   w  ww . ja  v  a  2 s. com*/

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

---

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