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.ar.dev.tierra.api.dao.impl.TransferenciaDAOImpl.java

@Override
public List<Transferencia> getDaily() {
    Criteria criteria = getSession().createCriteria(Transferencia.class);
    Calendar calendar = Calendar.getInstance();
    calendar.set(Calendar.HOUR_OF_DAY, 0);
    calendar.set(Calendar.MINUTE, 0);
    calendar.set(Calendar.SECOND, 0);
    Date fromDate = calendar.getTime();
    calendar.set(Calendar.HOUR_OF_DAY, 23);
    calendar.set(Calendar.MINUTE, 59);
    calendar.set(Calendar.SECOND, 59);
    Date toDate = calendar.getTime();
    criteria.add(Restrictions.between("fechaCreacion", fromDate, toDate));
    criteria.addOrder(Order.desc("idTransferencia"));
    List<Transferencia> list = criteria.list();
    return list;//from   ww w. j a va  2s  .c  o  m
}

From source file:com.ar.dev.tierra.api.dao.impl.TransferenciaDAOImpl.java

@Override
public List<Transferencia> getMonth() {
    Criteria criteria = getSession().createCriteria(Transferencia.class);
    Calendar calendar = Calendar.getInstance();
    Date toDate = calendar.getTime();
    calendar.add(Calendar.MONTH, -1);
    Date fromDate = calendar.getTime();
    criteria.add(Restrictions.between("fechaCreacion", fromDate, toDate));
    criteria.addOrder(Order.desc("idTransferencia"));
    List<Transferencia> list = criteria.list();
    return list;/* w  w w .j  av a  2 s . c o m*/
}

From source file:com.bakeryfactory.calendarioproducao.servidor.AgendaCompromissoDetalheAction.java

public Response listaCompromisso(Object inputPar, UserSessionParameters userSessionPars,
        HttpServletRequest request, HttpServletResponse response, HttpSession userSession,
        ServletContext context) {//w ww  .  j  a  v a2s  . c o  m
    Session session = null;
    Object[] pars = (Object[]) inputPar;
    AgendaCompromissoVO agendaCompromisso = (AgendaCompromissoVO) pars[1];

    try {
        session = HibernateUtil.getSessionFactory().openSession();

        Calendar dataInicial = Calendar.getInstance();
        dataInicial.setTime(agendaCompromisso.getDataCompromisso());
        dataInicial.add(Calendar.MONTH, -3);

        Calendar dataFinal = Calendar.getInstance();
        dataFinal.setTime(agendaCompromisso.getDataCompromisso());
        dataFinal.add(Calendar.MONTH, 3);

        Criteria criteria = session.createCriteria(AgendaCompromissoVO.class);
        criteria.add(Restrictions.eq("colaborador", agendaCompromisso.getColaborador()));
        criteria.add(Restrictions.between("dataCompromisso", dataInicial.getTime(), dataFinal.getTime()));
        criteria.addOrder(Order.asc("dataCompromisso"));

        List<AgendaCompromissoVO> listaCompromisso = criteria.list();

        return new VOListResponse(listaCompromisso, false, listaCompromisso.size());
    } catch (Exception ex) {
        ex.printStackTrace();
        return new ErrorResponse(ex.getMessage());
    } finally {
        try {
            session.close();
        } catch (Exception ex1) {
        }
    }
}

From source file:com.Bean.PostinfoHelper.java

public List<Post> searchByCriteria(PostSearcher postSearcher, int page) {

    List<Post> postList = new ArrayList<Post>();
    try {//  ww  w  .j  av a 2  s .c  o m
        Criteria c = session.createCriteria(Post.class);
        if (postSearcher.getTitle() != null) {
            c.add(Restrictions.like("title", "%" + postSearcher.getTitle() + "%"));
        }
        if ((postSearcher.getMinPrice() >= 0) && (postSearcher.getMaxPrice() >= 0)) {
            c.add(Restrictions.between("price", postSearcher.getMinPrice(), postSearcher.getMaxPrice()));
        } else if (postSearcher.getMinPrice() >= 0) {
            c.add(Restrictions.ge("price", postSearcher.getMinPrice()));
        } else if (postSearcher.getMaxPrice() >= 0) {
            c.add(Restrictions.le("price", postSearcher.getMaxPrice()));
        }
        if (postSearcher.getTypes() != null) {
            c.add(Restrictions.in("type", postSearcher.getTypes()));
        }
        maxPage = c.list().size() / itemsPerPage;
        c.setFirstResult(page * itemsPerPage);
        c.setMaxResults(itemsPerPage);
        postList = (List<Post>) c.list();
        return postList;
    } catch (HibernateException e) {
        System.err.println(e.getMessage());
    } catch (Exception e) {
        e.printStackTrace();
    }
    return null;
}

From source file:com.bean.SearchBean.java

public void init() {
    Dao dao = new Dao();

    long pMin = 0, pMax = 0, aMin = 0, aMax = 0;
    try {//from w  w  w  .j  a va2 s  .c  o  m
        pMin = Long.parseLong(this.priceMin);
    } catch (Exception ex) {

    }
    try {
        pMax = Long.parseLong(this.priceMax);
    } catch (Exception ex) {

    }
    try {
        aMin = Long.parseLong(this.areaMin);
    } catch (Exception ex) {

    }
    try {
        aMax = Long.parseLong(this.areaMax);
    } catch (Exception ex) {

    }

    LogicalExpression logic;
    Criterion district = null;
    Criterion province;
    Criterion propertyType = null;
    Criterion exchange = null;
    Criterion priceMin;
    Criterion priceMax;
    Criterion areaMin;
    Criterion areaMax;

    if (this.propertyType != 0) {
        PropertyType p = new PropertyType(this.propertyType);
        propertyType = Restrictions.eq("propertyType", p);
    } else {
        propertyType = Restrictions.isNotNull("propertyType");
    }

    if (this.exchangeType != 0) {
        ExchangeType e = new ExchangeType(this.exchangeType);
        exchange = Restrictions.eq("exchangeType", e);
    } else {
        exchange = Restrictions.isNotNull("exchangeType");
    }

    if (districtId != 0) {
        District d = new District(districtId);
        district = Restrictions.eq("district", d);
    } else {
        if (provinceId != 0) {
            Province p = (Province) dao.getById1(Province.class, provinceId);
            //Set<District> list = p.getDistricts();
            if (p != null && p.getDistricts().size() > 0) {
                district = Restrictions.in("district", p.getDistricts());
            } else {
                district = Restrictions.isNull("district");
            }
        }
    }
    Criterion cpub = Restrictions.eq("proPublish", true);
    Criterion stt = Restrictions.eq("proStatus", 0);
    logic = Restrictions.and(propertyType, exchange);
    logic = Restrictions.and(logic, stt);
    logic = Restrictions.and(logic, cpub);
    if (district != null) {
        logic = Restrictions.and(logic, district);
    }

    if (pMax > 0) {
        priceMax = Restrictions.between("proPrice", pMin, pMax);
        logic = Restrictions.and(logic, priceMax);
    } else {
        priceMin = Restrictions.gt("proPrice", pMin);
        logic = Restrictions.and(logic, priceMin);
    }

    if (aMax > 0) {
        areaMax = Restrictions.between("proArea", aMin, aMax);
        logic = Restrictions.and(logic, areaMax);
    } else {
        areaMin = Restrictions.gt("proArea", aMin);
        logic = Restrictions.and(logic, areaMin);
    }

    Order o = Order.desc("proPublishDate");

    listSearch = dao.getByCondition(Property.class, logic, o);

}

From source file:com.bean.StatisticBean.java

public CartesianChartModel getStatisticPostInYear() {
    CartesianChartModel multiAxisModel = new BarChartModel();

    BarChartSeries boys = new BarChartSeries();
    boys.setLabel("Count");
    Date now = new Date();
    int abc = now.getYear();
    int year = yearStatisticPostInYear == 0 ? now.getYear() : yearStatisticPostInYear;
    Dao dao = new Dao();
    //1//from  w  w w.  j a va  2  s  . co  m
    Date from1 = new Date(year, 0, 1);
    Date to1 = new Date(year, 0, 31);
    Criterion logic1 = Restrictions.between("proCreateDate", from1, to1);
    int count1 = dao.getByCondition(Property.class, logic1).size();
    //2
    Date from2 = new Date(year, 1, 1);
    Date to2 = new Date(year, 1, 28);
    Criterion logic2 = Restrictions.between("proCreateDate", from2, to2);
    int count2 = dao.getByCondition(Property.class, logic2).size();
    //3
    Date from3 = new Date(year, 2, 1);
    Date to3 = new Date(year, 2, 31);
    Criterion logic3 = Restrictions.between("proCreateDate", from3, to3);
    int count3 = dao.getByCondition(Property.class, logic3).size();
    //4
    Date from4 = new Date(year, 3, 1);
    Date to4 = new Date(year, 3, 30);
    Criterion logic4 = Restrictions.between("proCreateDate", from4, to4);
    int count4 = dao.getByCondition(Property.class, logic4).size();
    //5
    Date from5 = new Date(year, 4, 1);
    Date to5 = new Date(year, 4, 31);
    Criterion logic5 = Restrictions.between("proCreateDate", from5, to5);
    int count5 = dao.getByCondition(Property.class, logic5).size();
    //6
    Date from6 = new Date(year, 5, 1);
    Date to6 = new Date(year, 5, 30);
    Criterion logic6 = Restrictions.between("proCreateDate", from6, to6);
    int count6 = dao.getByCondition(Property.class, logic6).size();
    //7
    Date from7 = new Date(year, 6, 1);
    Date to7 = new Date(year, 6, 31);
    Criterion logic7 = Restrictions.between("proCreateDate", from7, to7);
    int count7 = dao.getByCondition(Property.class, logic7).size();
    //8
    Date from8 = new Date(year, 7, 1);
    Date to8 = new Date(year, 7, 31);
    Criterion logic8 = Restrictions.between("proCreateDate", from8, to8);
    int count8 = dao.getByCondition(Property.class, logic8).size();
    //9
    Date from9 = new Date(year, 8, 1);
    Date to9 = new Date(year, 8, 30);
    Criterion logic9 = Restrictions.between("proCreateDate", from9, to9);
    int count9 = dao.getByCondition(Property.class, logic9).size();
    //10
    Date from10 = new Date(year, 9, 1);
    Date to10 = new Date(year, 9, 31);
    Criterion logic10 = Restrictions.between("proCreateDate", from10, to10);
    int count10 = dao.getByCondition(Property.class, logic10).size();
    //11
    Date from11 = new Date(year, 10, 1);
    Date to11 = new Date(year, 10, 30);
    Criterion logic11 = Restrictions.between("proCreateDate", from11, to11);
    int count11 = dao.getByCondition(Property.class, logic11).size();
    //12
    Date from12 = new Date(year, 11, 1);
    Date to12 = new Date(year, 11, 31);
    Criterion logic12 = Restrictions.between("proCreateDate", from12, to12);
    int count12 = dao.getByCondition(Property.class, logic12).size();

    boys.set("01", count1);
    boys.set("02", count2);
    boys.set("03", count3);
    boys.set("04", count4);
    boys.set("05", count5);
    boys.set("06", count6);
    boys.set("07", count7);
    boys.set("08", count8);
    boys.set("09", count9);
    boys.set("10", count10);
    boys.set("11", count11);
    boys.set("12", count12);

    multiAxisModel.addSeries(boys);

    //multiAxisModel.setTitle("Statistic number of post in year");
    multiAxisModel.setMouseoverHighlight(false);
    multiAxisModel.setLegendPosition("ne");
    multiAxisModel.setMouseoverHighlight(false);
    multiAxisModel.setShowDatatip(false);
    multiAxisModel.setShowPointLabels(true);

    //        multiAxisModel.getAxes().put(AxisType.X, new CategoryAxis("Years"));
    //        multiAxisModel.getAxes().put(AxisType.X2, new CategoryAxis("Period"));
    Axis yAxis = multiAxisModel.getAxis(AxisType.Y);
    yAxis.setLabel("Count");
    yAxis.setMin(0);
    yAxis.setMax(200);
    return multiAxisModel;
}

From source file:com.bean.StatisticBean.java

public LineChartModel getStatisticViewInYear() {
    LineChartModel combinedModel = new LineChartModel();

    BarChartSeries boys = new BarChartSeries();
    boys.setLabel("Post");

    Date now = new Date();
    int year = yearStatisticViewInYear == 0 ? now.getYear() : yearStatisticViewInYear;
    Dao dao = new Dao();
    //1/*www.  ja  va  2  s.  c om*/
    Date from1 = new Date(year, 0, 1);
    Date to1 = new Date(year, 0, 31);
    Criterion logic1 = Restrictions.between("proCreateDate", from1, to1);
    int count1 = dao.getByCondition(Property.class, logic1).size();
    Criteria c = dao.createCriteria(Property.class);
    c.add(Restrictions.between("proCreateDate", from1, to1));
    c.setProjection(Projections.sum("proHit"));
    Object o = c.uniqueResult();
    long view1 = (long) (o == null ? 0L : o);
    //2
    Date from2 = new Date(year, 1, 1);
    Date to2 = new Date(year, 1, 28);
    Criterion logic2 = Restrictions.between("proCreateDate", from2, to2);
    int count2 = dao.getByCondition(Property.class, logic2).size();
    Criteria c2 = dao.createCriteria(Property.class);
    c2.add(Restrictions.between("proCreateDate", from2, to2));
    c2.setProjection(Projections.sum("proHit"));
    Object o2 = c2.uniqueResult();
    long view2 = (long) ((o2 == null) ? 0L : o2);
    //3
    Date from3 = new Date(year, 2, 1);
    Date to3 = new Date(year, 2, 31);
    Criterion logic3 = Restrictions.between("proCreateDate", from3, to3);
    int count3 = dao.getByCondition(Property.class, logic3).size();
    Criteria c3 = dao.createCriteria(Property.class);
    c3.add(Restrictions.between("proCreateDate", from3, to3));
    c3.setProjection(Projections.sum("proHit"));
    Object o3 = c3.uniqueResult();
    long view3 = (long) ((o3 == null) ? 0L : o3);
    //4
    Date from4 = new Date(year, 3, 1);
    Date to4 = new Date(year, 3, 30);
    Criterion logic4 = Restrictions.between("proCreateDate", from4, to4);
    int count4 = dao.getByCondition(Property.class, logic4).size();
    Criteria c4 = dao.createCriteria(Property.class);
    c4.add(Restrictions.between("proCreateDate", from4, to4));
    c4.setProjection(Projections.sum("proHit"));
    Object o4 = c4.uniqueResult();
    long view4 = (long) ((o4 == null) ? 0L : o4);
    //5
    Date from5 = new Date(year, 4, 1);
    Date to5 = new Date(year, 4, 31);
    Criterion logic5 = Restrictions.between("proCreateDate", from5, to5);
    int count5 = dao.getByCondition(Property.class, logic5).size();
    Criteria c5 = dao.createCriteria(Property.class);
    c5.add(Restrictions.between("proCreateDate", from5, to5));
    c5.setProjection(Projections.sum("proHit"));
    Object o5 = c5.uniqueResult();
    long view5 = (long) ((o5 == null) ? 0L : o5);
    //6
    Date from6 = new Date(year, 5, 1);
    Date to6 = new Date(year, 5, 30);
    Criterion logic6 = Restrictions.between("proCreateDate", from6, to6);
    int count6 = dao.getByCondition(Property.class, logic6).size();
    Criteria c6 = dao.createCriteria(Property.class);
    c6.add(Restrictions.between("proCreateDate", from6, to6));
    c6.setProjection(Projections.sum("proHit"));
    Object o6 = c6.uniqueResult();
    long view6 = (long) ((o6 == null) ? 0L : o6);
    //7
    Date from7 = new Date(year, 6, 1);
    Date to7 = new Date(year, 6, 31);
    Criterion logic7 = Restrictions.between("proCreateDate", from7, to7);
    int count7 = dao.getByCondition(Property.class, logic7).size();
    Criteria c7 = dao.createCriteria(Property.class);
    c7.add(Restrictions.between("proCreateDate", from7, to7));
    c7.setProjection(Projections.sum("proHit"));
    Object o7 = c7.uniqueResult();
    long view7 = (long) ((o7 == null) ? 0L : o7);
    //8
    Date from8 = new Date(year, 7, 1);
    Date to8 = new Date(year, 7, 31);
    Criterion logic8 = Restrictions.between("proCreateDate", from8, to8);
    int count8 = dao.getByCondition(Property.class, logic8).size();
    Criteria c8 = dao.createCriteria(Property.class);
    c8.add(Restrictions.between("proCreateDate", from8, to8));
    c8.setProjection(Projections.sum("proHit"));
    Object o8 = c8.uniqueResult();
    long view8 = (long) ((o8 == null) ? 0L : o8);
    //9
    Date from9 = new Date(year, 8, 1);
    Date to9 = new Date(year, 8, 30);
    Criterion logic9 = Restrictions.between("proCreateDate", from9, to9);
    int count9 = dao.getByCondition(Property.class, logic9).size();
    Criteria c9 = dao.createCriteria(Property.class);
    c9.add(Restrictions.between("proCreateDate", from9, to9));
    c9.setProjection(Projections.sum("proHit"));
    Object o9 = c9.uniqueResult();
    long view9 = (long) ((o9 == null) ? 0L : o9);
    //10
    Date from10 = new Date(year, 9, 1);
    Date to10 = new Date(year, 9, 31);
    Criterion logic10 = Restrictions.between("proCreateDate", from10, to10);
    int count10 = dao.getByCondition(Property.class, logic10).size();
    Criteria c10 = dao.createCriteria(Property.class);
    c10.add(Restrictions.between("proCreateDate", from10, to10));
    c10.setProjection(Projections.sum("proHit"));
    Object o10 = c10.uniqueResult();
    long view10 = (long) ((o10 == null) ? 0L : o10);
    //11
    Date from11 = new Date(year, 10, 1);
    Date to11 = new Date(year, 10, 30);
    Criterion logic11 = Restrictions.between("proCreateDate", from11, to11);
    int count11 = dao.getByCondition(Property.class, logic11).size();
    Criteria c11 = dao.createCriteria(Property.class);
    c11.add(Restrictions.between("proCreateDate", from11, to11));
    c11.setProjection(Projections.sum("proHit"));
    Object o11 = c11.uniqueResult();
    long view11 = (long) ((o11 == null) ? 0L : o11);
    //12
    Date from12 = new Date(year, 11, 1);
    Date to12 = new Date(year, 11, 31);
    Criterion logic12 = Restrictions.between("proCreateDate", from12, to12);
    int count12 = dao.getByCondition(Property.class, logic12).size();
    Criteria c12 = dao.createCriteria(Property.class);
    c12.add(Restrictions.between("proCreateDate", from12, to12));
    c12.setProjection(Projections.sum("proHit"));
    Object o12 = c12.uniqueResult();
    long view12 = (long) ((o12 == null) ? 0L : o12);

    boys.set("01", count1);
    boys.set("02", count2);
    boys.set("03", count3);
    boys.set("04", count4);
    boys.set("05", count5);
    boys.set("06", count6);
    boys.set("07", count7);
    boys.set("08", count8);
    boys.set("09", count9);
    boys.set("10", count10);
    boys.set("11", count11);
    boys.set("12", count12);

    LineChartSeries girls = new LineChartSeries();
    girls.setLabel("View");
    girls.setYaxis(AxisType.Y2);
    girls.set("01", view1);
    girls.set("02", view2);
    girls.set("03", view3);
    girls.set("04", view4);
    girls.set("05", view5);
    girls.set("06", view6);
    girls.set("07", view7);
    girls.set("08", view8);
    girls.set("09", view9);
    girls.set("10", view10);
    girls.set("11", view11);
    girls.set("12", view12);

    combinedModel.addSeries(boys);
    combinedModel.addSeries(girls);

    combinedModel.setTitle("Statistic view of post in year");
    combinedModel.setLegendPosition("ne");
    combinedModel.setMouseoverHighlight(true);
    combinedModel.setShowDatatip(true);
    combinedModel.setShowPointLabels(true);

    combinedModel.getAxes().put(AxisType.X, new CategoryAxis("Month"));
    combinedModel.getAxes().put(AxisType.X2, new CategoryAxis("Period"));

    Axis yAxis = combinedModel.getAxis(AxisType.Y);
    yAxis.setMin(0);
    yAxis.setMax(200);

    Axis y2Axis = new LinearAxis("Number");
    y2Axis.setMin(0);
    y2Axis.setMax(100000);

    combinedModel.getAxes().put(AxisType.Y2, y2Axis);

    return combinedModel;
}

From source file:com.bookselling.dao.SellingPostDaoImpl.java

private Object[] genericFilter(SellingPostFilterForm criteriaForm, int first, int items, int id) {
    Criteria criteria = getSession().createCriteria(SellingPost.class);

    //parse form/*from   ww w .  ja  v  a  2 s . com*/
    SellingPostFilterForm form = criteriaForm;

    //get form data
    String keyword = form.getKeyword();
    Double minPrice = form.getMinPrice();
    Double maxPrice = form.getMaxPrice();
    QuatityFilterType quatityStatus = form.getQuatityStatus();
    SellingPostFilterType searchBy = form.getSearchBy();
    SellingPostStatus sellingPostStatus[] = form.getSellingPostStatus();
    Set<Subject> subjects = form.getSubjects();
    Integer subjectIds[] = new Integer[subjects.size()];
    Subject subjectsArray[] = subjects.toArray(new Subject[subjectIds.length]);
    for (int i = 0; i < subjects.size(); i++)
        subjectIds[i] = subjectsArray[i].getId();

    //create criteria
    criteria.createAlias("purchasingSellingEntity", "bk").createAlias("bk.subjects", "sbj")
            .createAlias("bk.publisher", "pub").createAlias("seller", "sl").createAlias("sl.account", "acc");

    //search by keyword
    if (keyword != null && !keyword.isEmpty()) {
        keyword = "%" + keyword.trim() + "%";
        if (searchBy == SellingPostFilterType.HEADER)
            criteria.add(Restrictions.like("header", keyword));
        else if (searchBy == SellingPostFilterType.NAME) {
            criteria.add(Restrictions.like("bk.name", keyword)); //product
        } else if (searchBy == SellingPostFilterType.PUBLISHER) {
            criteria.add(Restrictions.like("pub.name", keyword));
        }
    }

    //search with price range        
    criteria.add(Restrictions.between("bk.sellingPrice", minPrice == null ? 0 : minPrice,
            maxPrice == null ? Integer.MAX_VALUE : maxPrice));

    //search with quatity status
    if (quatityStatus == QuatityFilterType.AVAILABLE)
        criteria.add(Restrictions.gt("bk.quatity", 0));
    else if (quatityStatus == QuatityFilterType.OUTOFSTOCK)
        criteria.add(Restrictions.eq("bk.quatity", 0));

    //search with selling post status
    if (sellingPostStatus.length != 0)
        criteria.add(Restrictions.in("status", sellingPostStatus));

    //search with subjects
    if (subjectIds.length != 0)
        criteria.add(Restrictions.in("sbj.id", subjectIds));

    //get data from form
    SortType sortType = form.getSortType();
    SellingPostOrderType sortByProperty = form.getSortByProperty();

    //Set up criteria
    String propertyName = null;
    if (sortByProperty == SellingPostOrderType.HEADER)
        propertyName = "header";
    else if (sortByProperty == SellingPostOrderType.NAME)
        propertyName = "bk.name";
    else if (sortByProperty == SellingPostOrderType.PUBLISHER)
        propertyName = "pub.name";
    else if (sortByProperty == SellingPostOrderType.CREATEDDATE)
        propertyName = "createdDate";
    else if (sortByProperty == SellingPostOrderType.PRICE)
        propertyName = "bk.sellingPrice";

    if (id != -1)
        criteria.add(Restrictions.eq("sl.id", id));

    //Ly s dng
    long rowCount = (long) criteria.setProjection(Projections.countDistinct("id")).uniqueResult();

    //Ly id
    criteria.setProjection(null).setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)
            .setProjection(Projections.distinct(Projections.id())).setFirstResult(first).setMaxResults(items)
            .addOrder(sortType == SortType.ASC ? Order.asc(propertyName) : Order.desc(propertyName));

    List<Integer> ids = new ArrayList<>();
    for (Iterator<Integer> temp = criteria.list().iterator(); temp.hasNext();)
        ids.add(temp.next());

    //Criteria ph
    Criteria subCriteria = getSession().createCriteria(SellingPost.class);
    subCriteria.createAlias("purchasingSellingEntity", "bk").createAlias("bk.subjects", "sbj")
            .createAlias("bk.publisher", "pub").createAlias("seller", "sl").createAlias("sl.account", "acc")
            .add(Restrictions.in("id", ids.size() > 0 ? ids : Arrays.asList(-1)))
            .addOrder(sortType == SortType.ASC ? Order.asc(propertyName) : Order.desc(propertyName));

    return new Object[] { subCriteria, rowCount };
}

From source file:com.certus.actions.orderFilterAction.java

@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    Session session = com.certus.connection.HibernateUtil.getSessionFactory().openSession();
    int pageIndex = 0;
    int totalNumberOfRecords = 0;
    int numberOfRecordsPerPage = 9;

    String sPageIndex = request.getParameter("pgIndex");
    pageIndex = sPageIndex == null ? 1 : Integer.parseInt(sPageIndex);
    int s = (pageIndex * numberOfRecordsPerPage) - numberOfRecordsPerPage;
    if (request.getParameter("startDate") != null) {
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        Date sDate = null;//from   w w  w  .j  av a  2s .c  om
        Date eDate = null;
        try {

            sDate = sdf.parse(request.getParameter("startDate"));
            eDate = sdf.parse(request.getParameter("endDate"));
        } catch (Exception e) {
        }
        List<Order> oList = session.createCriteria(Order.class, "ord")
                .add(Restrictions.between("ord.dateOrdered", sDate, eDate)).setFirstResult(s)
                .setMaxResults(numberOfRecordsPerPage).list();

        String s1 = "", s2 = "";
        for (Order order : oList) {
            s1 += "<tr>" + "<td>" + order.getInvoNum() + "</td>" + "<td>" + order.getName() + "</td>" + "<td>"
                    + order.getStatus() + "</td>" + "<td> Rs. " + order.getGrandTot() + "</td>"
                    + "<td><button type='button' class='btn btn-default'>"
                    + "<span class='glyphicon glyphicon-eye-open'></span></button>" + "</td>" + "<td>"
                    + "<a href='edit_order.jsp?oid=" + order.getId() + "'>"
                    + "<span class='glyphicon glyphicon-edit'></span>" + "</a>" + "</td>" + "</tr>";
        }
        Criteria criteriaCount = session.createCriteria(Order.class, "ord")
                .add(Restrictions.between("ord.dateOrdered", sDate, eDate));
        criteriaCount.setProjection(Projections.rowCount());
        totalNumberOfRecords = (int) (long) (Long) criteriaCount.uniqueResult();
        int noOfPages = totalNumberOfRecords / numberOfRecordsPerPage;
        if (totalNumberOfRecords > (noOfPages * numberOfRecordsPerPage)) {
            noOfPages = noOfPages + 1;
        }

        for (int j = 1; j <= noOfPages; j++) {
            if (noOfPages > 1) {
                String myurl = "orders.jsp?startDate=" + request.getParameter("startDate") + "&endDate="
                        + request.getParameter("endDate") + "&pgIndex=" + j;
                if (j == pageIndex) {
                    s2 += "<span class='current'>" + j + "</span>";
                } else {
                    s2 += "<a href='" + myurl + "'>" + j + "</a>";
                }

            }
        }

        session.close();
        response.setContentType("application/json");
        response.setCharacterEncoding("UTF-8");
        response.getWriter().write("[{\"d1\":\"" + s1 + "\",\"d2\":\"" + s2 + "\"}]");
    } else {
        List<Order> oList = session.createCriteria(Order.class).setFirstResult(s)
                .setMaxResults(numberOfRecordsPerPage).list();
        String s1 = "", s2 = "";
        for (Order order : oList) {
            s1 += "<tr>" + "<td>" + order.getInvoNum() + "</td>" + "<td>" + order.getName() + "</td>" + "<td>"
                    + order.getStatus() + "</td>" + "<td> Rs. " + order.getGrandTot() + "</td>"
                    + "<td><button type='button' class='btn btn-default'>"
                    + "<span class='glyphicon glyphicon-eye-open'></span></button>" + "</td>" + "<td>"
                    + "<a href='edit_order.jsp?oid=" + order.getId() + "'>"
                    + "<span class='glyphicon glyphicon-edit'></span>" + "</a>" + "</td>" + "</tr>";
        }
        Criteria criteriaCount = session.createCriteria(Order.class);
        criteriaCount.setProjection(Projections.rowCount());
        totalNumberOfRecords = (int) (long) (Long) criteriaCount.uniqueResult();
        int noOfPages = totalNumberOfRecords / numberOfRecordsPerPage;

        if (totalNumberOfRecords > (noOfPages * numberOfRecordsPerPage)) {
            noOfPages = noOfPages + 1;
        }

        for (int j = 1; j <= noOfPages; j++) {
            if (noOfPages > 1) {
                String myurl = "orders.jsp?pgIndex=" + j;
                if (j == pageIndex) {
                    s2 += "<span class='current'>" + j + "</span>";
                } else {
                    s2 += "<a href='" + myurl + "'>" + j + "</a>";
                }

            }
        }
        session.close();
        response.setContentType("application/json");
        response.setCharacterEncoding("UTF-8");
        response.getWriter().write("[{\"d1\":\"" + s1 + "\",\"d2\":\"" + s2 + "\"}]");
    }
}

From source file:com.certus.actions.salesFilterAction.java

@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    Session session = com.certus.connection.HibernateUtil.getSessionFactory().openSession();
    int pageIndex = 0;
    int totalNumberOfRecords = 0;
    int numberOfRecordsPerPage = 9;

    String sPageIndex = request.getParameter("pgIndex");
    pageIndex = sPageIndex == null ? 1 : Integer.parseInt(sPageIndex);
    int s = (pageIndex * numberOfRecordsPerPage) - numberOfRecordsPerPage;
    if (request.getParameter("startDate") != null) {
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        Date sDate = null;// w  w  w. ja va  2s  .  c  o m
        Date eDate = null;
        try {

            sDate = sdf.parse(request.getParameter("startDate"));
            eDate = sdf.parse(request.getParameter("endDate"));
        } catch (Exception e) {
        }
        List<Sales> sList = session.createCriteria(Sales.class, "sale")
                .add(Restrictions.between("sale.dateDone", sDate, eDate)).setFirstResult(s)
                .setMaxResults(numberOfRecordsPerPage).list();
        String s1 = "", s2 = "";
        for (Sales sale : sList) {
            s1 += "<tr>" + "<td>" + sale.getId() + "</td>" + "<td>" + sale.getOrder().getUser().getFName() + " "
                    + sale.getOrder().getUser().getLName() + "</td>" + "<td>" + sale.getStatus() + "</td>"
                    + "<td> Rs. " + sale.getGrandTotal() + "</td>" + "<td>" + sale.getDateDone() + "</td>"
                    + "<td>"
                    + "<button type='button' class='btn btn-default'><span class='glyphicon glyphicon-eye-open'></sapn></button>"
                    + "</td>" + "</tr>";
        }
        Criteria criteriaCount = session.createCriteria(Sales.class, "sale")
                .add(Restrictions.between("sale.dateDone", sDate, eDate));
        criteriaCount.setProjection(Projections.rowCount());
        totalNumberOfRecords = (int) (long) (Long) criteriaCount.uniqueResult();
        int noOfPages = totalNumberOfRecords / numberOfRecordsPerPage;
        if (totalNumberOfRecords > (noOfPages * numberOfRecordsPerPage)) {
            noOfPages = noOfPages + 1;
        }

        for (int j = 1; j <= noOfPages; j++) {
            if (noOfPages > 1) {
                String myurl = "sales.jsp?startDate=" + request.getParameter("startDate") + "&endDate="
                        + request.getParameter("endDate") + "&pgIndex=" + j;
                if (j == pageIndex) {
                    s2 += "<span class='current'>" + j + "</span>";
                } else {
                    s2 += "<a href='" + myurl + "'>" + j + "</a>";
                }

            }
        }
        session.close();

        response.setContentType("application/json");
        response.setCharacterEncoding("UTF-8");
        response.getWriter().write("[{\"d1\":\"" + s1 + "\",\"d2\":\"" + s2 + "\"}]");
    } else {
        List<Sales> sList = session.createCriteria(Sales.class).setFirstResult(s)
                .setMaxResults(numberOfRecordsPerPage).list();
        String s1 = "", s2 = "";
        for (Sales sale : sList) {
            s1 += "<tr>" + "<td>" + sale.getId() + "</td>" + "<td>" + sale.getOrder().getUser().getFName() + " "
                    + sale.getOrder().getUser().getLName() + "</td>" + "<td>" + sale.getStatus() + "</td>"
                    + "<td> Rs. " + sale.getGrandTotal() + "</td>" + "<td>" + sale.getDateDone() + "</td>"
                    + "<td>"
                    + "<button type='button' class='btn btn-default'><span class='glyphicon glyphicon-eye-open'></sapn></button>"
                    + "</td>" + "</tr>";
        }
        Criteria criteriaCount = session.createCriteria(Sales.class);
        criteriaCount.setProjection(Projections.rowCount());
        totalNumberOfRecords = (int) (long) (Long) criteriaCount.uniqueResult();
        int noOfPages = totalNumberOfRecords / numberOfRecordsPerPage;

        if (totalNumberOfRecords > (noOfPages * numberOfRecordsPerPage)) {
            noOfPages = noOfPages + 1;
        }

        for (int j = 1; j <= noOfPages; j++) {
            if (noOfPages > 1) {
                String myurl = "sales.jsp?pgIndex=" + j;
                if (j == pageIndex) {
                    s2 += "<span class='current'>" + j + "</span>";
                } else {
                    s2 += "<a href='" + myurl + "'>" + j + "</a>";
                }

            }
        }
        session.close();
        response.setContentType("application/json");
        response.setCharacterEncoding("UTF-8");
        response.getWriter().write("[{\"d1\":\"" + s1 + "\",\"d2\":\"" + s2 + "\"}]");
    }
}