Example usage for org.hibernate.criterion Restrictions between

List of usage examples for org.hibernate.criterion Restrictions between

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. 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:com.certus.controllers.ReportsController.java

public Map<String, Double> getSalesByWeek(Date startOfWeek, Date endOfWeek) {
    List<ChartsCriteria> wSale = new ArrayList<>();
    List<Sales> sList = s.createCriteria(Sales.class, "sale")
            .add(Restrictions.between("sale.dateDone", startOfWeek, endOfWeek))
            .addOrder(Order.asc("sale.dateDone")).list();
    addDatesToListWeek(wSale);//from  w w  w  . ja v a2  s. co m
    for (Sales sale : sList) {
        wSale.add(new ChartsCriteria(getDayByName(sale.getDateDone()), sale.getGrandTotal()));
    }

    return wSale.stream()
            .collect(Collectors.groupingBy(d -> d.getDay(), Collectors.summingDouble(a -> a.getAmount())));

}

From source file:com.certus.controllers.ReportsController.java

public Map<String, Double> getSalesByMonth(Date startOfMonth, Date endOfMonth) {
    List<ChartsCriteria> mSale = new ArrayList<>();
    List<Sales> sList = s.createCriteria(Sales.class, "sale")
            .add(Restrictions.between("sale.dateDone", startOfMonth, endOfMonth))
            .addOrder(Order.asc("sale.dateDone")).list();
    addDatesToListMonth(mSale);//from   ww w .  j  av a2  s .c om
    for (Sales sale : sList) {
        mSale.add(new ChartsCriteria(getDayByDay(sale.getDateDone()), sale.getGrandTotal()));
    }

    return mSale.stream()
            .collect(Collectors.groupingBy(d -> d.getDay(), Collectors.summingDouble(a -> a.getAmount())));

}

From source file:com.certus.controllers.ReportsController.java

public Map<String, Double> getSalesByYear(Date startOfYear, Date endOfYear) {
    List<ChartsCriteria> ySale = new ArrayList<>();
    List<Sales> sList = s.createCriteria(Sales.class, "sale")
            .add(Restrictions.between("sale.dateDone", startOfYear, endOfYear))
            .addOrder(Order.asc("sale.dateDone")).list();
    addMonthsToList(ySale);//from ww  w .j a  v  a2 s . c  o m
    for (Sales sale : sList) {
        ySale.add(new ChartsCriteria(getMonthByDate(sale.getDateDone()), sale.getGrandTotal()));
    }

    return ySale.stream()
            .collect(Collectors.groupingBy(d -> d.getDay(), Collectors.summingDouble(a -> a.getAmount())));

}

From source file:com.certus.controllers.ReportsController.java

public Map<String, Double> getOrdersByWeek(Date startOfWeek, Date endOfWeek) {
    List<ChartsCriteria> wOrder = new ArrayList<>();
    List<com.certus.dbmodel.Order> oList = s.createCriteria(com.certus.dbmodel.Order.class, "order")
            .add(Restrictions.between("order.dateOrdered", startOfWeek, endOfWeek))
            .addOrder(Order.asc("order.dateOrdered")).list();
    addDatesToListWeek(wOrder);/*from  www.  j a v  a2s  . c  om*/
    for (com.certus.dbmodel.Order order : oList) {
        wOrder.add(new ChartsCriteria(getDayByName(order.getDateOrdered()), order.getGrandTot()));
    }

    return wOrder.stream()
            .collect(Collectors.groupingBy(d -> d.getDay(), Collectors.summingDouble(a -> a.getAmount())));

}

From source file:com.certus.controllers.ReportsController.java

public Map<String, Double> getOrdersByMonth(Date startOfMonth, Date endOfMonth) {
    List<ChartsCriteria> mOrder = new ArrayList<>();
    List<com.certus.dbmodel.Order> oList = s.createCriteria(com.certus.dbmodel.Order.class, "order")
            .add(Restrictions.between("order.dateOrdered", startOfMonth, endOfMonth))
            .addOrder(Order.asc("order.dateOrdered")).list();
    addDatesToListMonth(mOrder);//from w ww . ja v a2 s.  c  o m
    for (com.certus.dbmodel.Order order : oList) {
        mOrder.add(new ChartsCriteria(getDayByDay(order.getDateOrdered()), order.getGrandTot()));
    }

    return mOrder.stream()
            .collect(Collectors.groupingBy(d -> d.getDay(), Collectors.summingDouble(a -> a.getAmount())));

}

From source file:com.certus.controllers.ReportsController.java

public Map<String, Double> getOrdersByYear(Date startOfYear, Date endOfYear) {
    List<ChartsCriteria> yOrder = new ArrayList<>();
    List<com.certus.dbmodel.Order> oList = s.createCriteria(com.certus.dbmodel.Order.class, "order")
            .add(Restrictions.between("order.dateOrdered", startOfYear, endOfYear))
            .addOrder(Order.asc("order.dateOrdered")).list();
    addMonthsToList(yOrder);/*from  ww w  .j a v a  2 s. com*/
    for (com.certus.dbmodel.Order order : oList) {
        yOrder.add(new ChartsCriteria(getMonthByDate(order.getDateOrdered()), order.getGrandTot()));
    }

    return yOrder.stream()
            .collect(Collectors.groupingBy(d -> d.getDay(), Collectors.summingDouble(a -> a.getAmount())));

}

From source file:com.certus.controllers.ReportsController.java

public Map<String, Double> getExpenesByWeek(Date startOfWeek, Date endOfWeek) {
    List<ChartsCriteria> wExpence = new ArrayList<>();
    List<Expences> eList = s.createCriteria(Expences.class, "exp")
            .add(Restrictions.between("exp.date", startOfWeek, endOfWeek)).addOrder(Order.asc("exp.date"))
            .list();/*from w ww.  ja va 2s  . c  o  m*/
    addDatesToListWeek(wExpence);
    for (Expences expence : eList) {
        wExpence.add(new ChartsCriteria(getDayByName(expence.getDate()), expence.getTotal()));
    }
    return wExpence.stream()
            .collect(Collectors.groupingBy(d -> d.getDay(), Collectors.summingDouble(a -> a.getAmount())));
}

From source file:com.certus.controllers.ReportsController.java

public Map<String, Double> getExpenesByMonth(Date startOfMonth, Date endOfMonth) {
    List<ChartsCriteria> mExpence = new ArrayList<>();
    List<Expences> eList = s.createCriteria(Expences.class, "exp")
            .add(Restrictions.between("exp.date", startOfMonth, endOfMonth)).addOrder(Order.asc("exp.date"))
            .list();/*from  ww w  .j  a v a 2  s.  c om*/
    addDatesToListMonth(mExpence);
    for (Expences expence : eList) {
        mExpence.add(new ChartsCriteria(getDayByDay(expence.getDate()), expence.getTotal()));
    }
    return mExpence.stream()
            .collect(Collectors.groupingBy(d -> d.getDay(), Collectors.summingDouble(a -> a.getAmount())));
}

From source file:com.certus.controllers.ReportsController.java

public Map<String, Double> getExpenesByYear(Date startOfYear, Date endOfYear) {
    List<ChartsCriteria> yExpence = new ArrayList<>();
    List<Expences> eList = s.createCriteria(Expences.class, "exp")
            .add(Restrictions.between("exp.date", startOfYear, endOfYear)).addOrder(Order.asc("exp.date"))
            .list();//  ww w .j  av a  2  s .  co  m
    addMonthsToList(yExpence);
    for (Expences expence : eList) {
        yExpence.add(new ChartsCriteria(getMonthByDate(expence.getDate()), expence.getTotal()));
    }
    return yExpence.stream()
            .collect(Collectors.groupingBy(d -> d.getDay(), Collectors.summingDouble(a -> a.getAmount())));
}

From source file:com.cimmyt.model.dao.impl.LogDAOImpl.java

License:Apache License

@Override
protected void buildCriteria(DetachedCriteria _criteria, Log filter, Integer id) {
    this.criteria = _criteria;
    try {//from w w  w  . ja  v  a2  s .  c om
        if (initDate != null && endDate != null) {
            criteria.add(Restrictions.between("operationDate", StrUtils.getDateStandarFromStr(initDate),
                    StrUtils.getDateStandarFromStr(endDate)));
        } else if (initDate != null && endDate == null) {
            criteria.add(Restrictions.ge("operationDate", StrUtils.getDateStandarFromStr(initDate)));
        } else if (endDate != null && initDate == null) {
            criteria.add(Restrictions.le("operationDate", StrUtils.getDateStandarFromStr(endDate)));
        }
    } catch (ParseException pEx) {
        pEx.printStackTrace();
    }

    switch (id) {
    case ConstantsDNA.ROLE_ADMINISTRATOR:
        validateRoleResearcher(filter);
        break;
    case ConstantsDNA.ROLE_DATA_MANAGER:
        addCriteriaNotAdministrator();
        validateRoleResearcher(filter);
        break;
    case ConstantsDNA.ROLE_RESEARCHER:
        addCriteriaNotAdministrator();
        criteria.add(Restrictions.sqlRestriction(
                "this_.user_version_id not in (Select  u.user_version_id from st_user_version u where u.idst_rol ="
                        + ConstantsDNA.ROLE_DATA_MANAGER + ")"));
        validateRoleResearcher(filter);
        break;
    }
    if (filter.getLogTyperOperation() != null && filter.getLogTyperOperation().getIdLogTypeOperation() != null)
        criteria.add(Restrictions.eq("logTyperOperation.idLogTypeOperation",
                filter.getLogTyperOperation().getIdLogTypeOperation()));
    criteria.addOrder(Order.asc("operationDate"));

}