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

public List getExpensesList(Calendar begin, Calendar end, WarehouseEntity warehouse, PartnerEntity partner,
        CurrencyEntity currency, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ExpensesEntity.class);
    c.add(Restrictions.between("date", begin, end));
    if (partner != null) {
        c.add(Restrictions.eq("partner", partner));
    }// w w w .ja  v a  2s. co  m
    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.InvoicePurchaseDao.java

public List getInvoicePurchaseList(Calendar begin, Calendar end, WarehouseEntity warehouse,
        PartnerEntity partner, CurrencyEntity currency, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(InvoicePurchaseEntity.class);
    c.add(Restrictions.between("date", begin, end));
    if (partner != null) {
        c.add(Restrictions.eq("partner", partner));
    }/*from  w  ww  . j a va2 s.c  o  m*/
    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.InvoiceSalesDao.java

public List getInvoiceSalesList(Calendar begin, Calendar end, WarehouseEntity warehouse, PartnerEntity partner,
        CurrencyEntity currency, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(InvoiceSalesEntity.class);
    c.add(Restrictions.between("date", begin, end));
    if (partner != null) {
        c.add(Restrictions.eq("partner", partner));
    }//  w w  w.java  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.ItemAdjustmentDao.java

public List<ItemAdjustmentEntity> getItemAdjustmentList(Calendar start, Calendar end, WarehouseEntity warehouse,
        boolean status) {
    Session session = this.sessionFactory.getCurrentSession();

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

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

public List<ItemDeliveryEntity> getItemDeliveryList(Calendar start, Calendar end, WarehouseEntity warehouse,
        boolean status) {
    Session session = this.sessionFactory.getCurrentSession();

    Criteria c = session.createCriteria(ItemDeliveryEntity.class, "itemdelivery");
    c.createAlias("itemdelivery.delivery", "delivery");
    c.add(Restrictions.between("delivery.date", start, end));
    c.add(Restrictions.eq("delivery.warehouse", warehouse));
    c.add(Restrictions.eq("delivery.status", status));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

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

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

    Criteria c = session.createCriteria(ItemExpensesEntity.class, "itemexpenses");
    c.createAlias("itemexpenses.expenses", "expenses");
    c.add(Restrictions.between("expenses.date", start, end));
    if (warehouse != null) {
        c.add(Restrictions.eq("expenses.warehouse", warehouse));
    }/*from www. j av  a  2  s .c o  m*/
    if (partner != null) {
        c.add(Restrictions.eq("expenses.partner", partner));
    }
    if (currency != null) {
        c.add(Restrictions.eq("expenses.currency", currency));
    }
    c.add(Restrictions.eq("expenses.status", status));
    c.addOrder(Order.asc("expenses.date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

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

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

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

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

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

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

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

public List<ItemInvoiceWarehouseInEntity> getItemInvoiceWarehouseInList(Calendar start, Calendar end,
        WarehouseEntity warehouse, WarehouseEntity origin, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();

    Criteria c = session.createCriteria(ItemInvoiceWarehouseInEntity.class, "iteminvoicewarehousein");
    c.createAlias("iteminvoicewarehousein.invoicewarehousein", "invoicewarehousein");
    c.add(Restrictions.between("invoicewarehousein.date", start, end));
    if (warehouse != null) {
        c.add(Restrictions.eq("invoicewarehousein.warehouse", warehouse));
    }//w  w w.  java 2  s .c  o  m
    if (origin != null) {
        c.add(Restrictions.eq("invoicewarehousein.origin", origin));
    }
    c.add(Restrictions.eq("invoicewarehousein.status", status));
    c.addOrder(Order.asc("invoicewarehousein.date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

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

public List<ItemInvoiceWarehouseOutEntity> getItemInvoiceWarehouseOutList(Calendar start, Calendar end,
        WarehouseEntity warehouse, WarehouseEntity destination, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();

    Criteria c = session.createCriteria(ItemInvoiceWarehouseOutEntity.class, "iteminvoicewarehouseout");
    c.createAlias("iteminvoicewarehouseout.invoicewarehouseout", "invoicewarehouseout");
    c.add(Restrictions.between("invoicewarehouseout.date", start, end));
    if (warehouse != null) {
        c.add(Restrictions.eq("invoicewarehouseout.warehouse", warehouse));
    }/*from   w ww.  j  ava  2  s  .  c  o m*/
    if (destination != null) {
        c.add(Restrictions.eq("invoicewarehouseout.destination", destination));
    }
    c.add(Restrictions.eq("invoicewarehouseout.status", status));
    c.addOrder(Order.asc("invoicewarehouseout.date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}