Example usage for org.hibernate.criterion Restrictions between

Introduction

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

Prototype

public static Criterion between(String propertyName, Object low, Object high) 

Source Link

Document

Apply a "between" constraint to the named property

Usage

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

public List<ItemReturnPurchaseEntity> getItemReturnPurchaseList(Calendar start, Calendar end,
        WarehouseEntity warehouse, PartnerEntity partner, CurrencyEntity currency, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();

    Criteria c = session.createCriteria(ItemReturnPurchaseEntity.class, "itemreturnpurchase");
    c.createAlias("itemreturnpurchase.returnpurchase", "returnpurchase");
    c.add(Restrictions.between("returnpurchase.date", start, end));
    if (warehouse != null) {
        c.add(Restrictions.eq("returnpurchase.warehouse", warehouse));
    }//from   www.  ja v  a  2 s. c om
    if (currency != null) {
        c.add(Restrictions.eq("returnpurchase.currency", currency));
    }
    if (partner != null) {
        c.add(Restrictions.eq("returnpurchase.partner", partner));
    }
    c.add(Restrictions.eq("returnpurchase.status", status));
    c.addOrder(Order.asc("returnpurchase.date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

---

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

public List<ItemReturnSalesEntity> getItemReturnSalesList(Calendar start, Calendar end,
        WarehouseEntity warehouse, PartnerEntity partner, CurrencyEntity currency, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();

    Criteria c = session.createCriteria(ItemReturnSalesEntity.class, "itemreturnsales");
    c.createAlias("itemreturnsales.returnsales", "returnsales");
    c.add(Restrictions.between("returnsales.date", start, end));
    if (warehouse != null) {
        c.add(Restrictions.eq("returnsales.warehouse", warehouse));
    }//w  w  w  .j av a  2s  .co m
    if (currency != null) {
        c.add(Restrictions.eq("returnsales.currency", currency));
    }
    if (partner != null) {
        c.add(Restrictions.eq("returnsales.partner", partner));
    }
    c.add(Restrictions.eq("returnsales.status", status));
    c.addOrder(Order.asc("returnsales.date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

---

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

public List getPaymentInList(Calendar begin, Calendar end, WarehouseEntity warehouse, PartnerEntity partner,
        CurrencyEntity currency, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(PaymentInEntity.class);
    c.add(Restrictions.between("date", begin, end));
    if (partner != null) {
        c.add(Restrictions.eq("partner", partner));
    }// www  .j a va  2  s.c  om
    if (warehouse != null) {
        c.add(Restrictions.eq("warehouse", warehouse));
    }
    if (currency != null) {
        c.add(Restrictions.eq("currency", currency));
    }
    c.add(Restrictions.eq("status", status));
    c.addOrder(Order.asc("date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    List ls = c.list();
    return ls;
}

---

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

public List getPaymentOutList(Calendar begin, Calendar end, WarehouseEntity warehouse, PartnerEntity partner,
        CurrencyEntity currency, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(PaymentOutEntity.class);
    c.add(Restrictions.between("date", begin, end));
    if (partner != null) {
        c.add(Restrictions.eq("partner", partner));
    }//from w ww.  j a v a 2s. com
    if (warehouse != null) {
        c.add(Restrictions.eq("warehouse", warehouse));
    }
    if (currency != null) {
        c.add(Restrictions.eq("currency", currency));
    }
    c.add(Restrictions.eq("status", status));
    c.addOrder(Order.asc("date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    List ls = c.list();
    return ls;
}

---

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

public List getPaymentTypeInList(int type, boolean accepted, boolean valid, Calendar begin, Calendar end) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(PaymentTypeInEntity.class);
    if (type < 4) {
        c.add(Restrictions.eq("type", type));
    }//from   ww w.j a v  a2  s.co  m
    c.add(Restrictions.eq("status", accepted));
    c.add(Restrictions.eq("valid", valid));
    c.add(Restrictions.between("duedate", begin, end));
    c.addOrder(Order.asc("duedate"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

---

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

public List<PaymentTypeInEntity> getPaymentTypeInList(Calendar start, Calendar end, WarehouseEntity warehouse,
        PartnerEntity partner, CurrencyEntity currency, int type, boolean valid, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();

    Criteria c = session.createCriteria(PaymentTypeInEntity.class, "paymenttypein");
    c.createAlias("paymenttypein.paymentin", "paymentin");
    c.add(Restrictions.between("paymentin.date", start, end));
    if (warehouse != null) {
        c.add(Restrictions.eq("paymentin.warehouse", warehouse));
    }//  w  ww.j ava2  s .c o m
    if (currency != null) {
        c.add(Restrictions.eq("paymentin.currency", currency));
    }
    if (partner != null) {
        c.add(Restrictions.eq("paymentin.partner", partner));
    }
    if (type < 4) {
        c.add(Restrictions.eq("type", type));
    }
    c.add(Restrictions.eq("paymenttypein.valid", valid));
    c.add(Restrictions.eq("paymenttypein.status", status));
    c.addOrder(Order.asc("paymentin.date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

---

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

public List<PaymentTypeInEntity> getPaymentTypeInList(Calendar start, Calendar end, WarehouseEntity warehouse,
        PartnerEntity partner, CurrencyEntity currency, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();

    Criteria c = session.createCriteria(PaymentTypeInEntity.class, "paymenttypein");
    c.createAlias("paymenttypein.paymentin", "paymentin");
    c.add(Restrictions.between("paymentin.date", start, end));
    if (warehouse != null) {
        c.add(Restrictions.eq("paymentin.warehouse", warehouse));
    }//  w w w  .j  a  v a  2s. c om
    if (currency != null) {
        c.add(Restrictions.eq("paymentin.currency", currency));
    }
    if (partner != null) {
        c.add(Restrictions.eq("paymentin.partner", partner));
    }
    c.add(Restrictions.eq("paymentin.status", status));
    c.addOrder(Order.asc("paymentin.date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

---

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

public List getPaymentTypeOutList(int type, boolean accepted, boolean valid, Calendar begin, Calendar end) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(PaymentTypeOutEntity.class);
    if (type < 4) {
        c.add(Restrictions.eq("type", type));
    }/* w w  w.  ja v  a2 s  .com*/
    c.add(Restrictions.eq("status", accepted));
    c.add(Restrictions.eq("valid", valid));
    c.add(Restrictions.between("duedate", begin, end));
    c.addOrder(Order.asc("duedate"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

---

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

public List<PaymentTypeOutEntity> getPaymentTypeOutList(Calendar start, Calendar end, WarehouseEntity warehouse,
        PartnerEntity partner, CurrencyEntity currency, int type, boolean valid, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();

    Criteria c = session.createCriteria(PaymentTypeOutEntity.class, "paymenttypeout");
    c.createAlias("paymenttypeout.paymentout", "paymentout");
    c.add(Restrictions.between("paymentout.date", start, end));
    if (warehouse != null) {
        c.add(Restrictions.eq("paymentout.warehouse", warehouse));
    }/* w w w . j av a 2  s  .co  m*/
    if (currency != null) {
        c.add(Restrictions.eq("paymentout.currency", currency));
    }
    if (partner != null) {
        c.add(Restrictions.eq("paymentout.partner", partner));
    }
    if (type < 4) {
        c.add(Restrictions.eq("type", type));
    }
    c.add(Restrictions.eq("paymenttypeout.valid", valid));
    c.add(Restrictions.eq("paymenttypeout.status", status));
    c.addOrder(Order.asc("paymentout.date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

---

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

public List<PaymentTypeOutEntity> getPaymentTypeOutList(Calendar start, Calendar end, WarehouseEntity warehouse,
        PartnerEntity partner, CurrencyEntity currency, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();

    Criteria c = session.createCriteria(PaymentTypeOutEntity.class, "paymenttypeout");
    c.createAlias("paymenttypeout.paymentout", "paymentout");
    c.add(Restrictions.between("paymentout.date", start, end));
    if (warehouse != null) {
        c.add(Restrictions.eq("paymentout.warehouse", warehouse));
    }//w  w w.ja  va 2  s  . com
    if (currency != null) {
        c.add(Restrictions.eq("paymentout.currency", currency));
    }
    if (partner != null) {
        c.add(Restrictions.eq("paymentout.partner", partner));
    }
    c.add(Restrictions.eq("paymentout.status", status));
    c.addOrder(Order.asc("paymentout.date"));

    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    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
• »