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:grails.orm.HibernateCriteriaBuilder.java

License:Apache License

/**
 * Creates a "between" Criterion based on the property name and specified lo and hi values
 * @param propertyName The property name
 * @param lo The low value// w  w w . j a  va2  s.  c  om
 * @param hi The high value
 * @return A Criterion instance
 */
public org.grails.datastore.mapping.query.api.Criteria between(String propertyName, Object lo, Object hi) {
    if (!validateSimpleExpression()) {
        throwRuntimeException(new IllegalArgumentException(
                "Call to [between] with propertyName [" + propertyName + "]  not allowed here."));
    }

    propertyName = calculatePropertyName(propertyName);
    addToCriteria(Restrictions.between(propertyName, lo, hi));
    return this;
}

From source file:helper.GelirHelper.java

public List<Siparis> listGelirRapor(Date startDate, Date endDate) throws Exception {

    List<Siparis> list = new ArrayList<>();
    Session session = null;/* w w w. j  a v a 2  s.  c om*/

    try {
        session = sessionFactory.openSession();
        list = session.createCriteria(Siparis.class, "siparis").createAlias("siparis.personel", "personel")
                .createAlias("personel.yetki", "yetki").createAlias("siparis.masa", "masa")
                .createAlias("masa.gelir", "gelir").createAlias("siparis.stok", "stok")
                .createAlias("stok.urun", "urun").createAlias("stok.firma", "firma")
                .createAlias("urun.urunTur", "urunTuru")
                .add(Restrictions.between("siparis.satisTarihi", startDate, endDate))
                .add(Restrictions.ne("siparis.isAktif", false)).add(Restrictions.ne("personel.isAktif", false))
                .add(Restrictions.ne("masa.isAktif", false)).add(Restrictions.ne("gelir.isAktif", false))
                .add(Restrictions.eq("siparis.isOdendi", true)).add(Restrictions.eq("masa.isOdendi", true))
                .add(Restrictions.ne("siparis.isIptal", true)).addOrder(Order.desc("siparis.satisTarihi"))
                .list();

    } catch (Exception e) {

        throw e;
    } finally {
        session.close();
    }

    return list;
}

From source file:helper.GiderHelper.java

public List<Gider> listStok(Date startDate, Date endDate) throws Exception {

    Session session = null;/*w  ww  . j a v  a2  s.  c  om*/
    List<Gider> list = new ArrayList<>();
    try {
        session = sessionFactory.openSession();

        list = session.createCriteria(Gider.class, "gider").createAlias("gider.giderTuru", "giderTuru")
                .createAlias("gider.stok", "stok").createAlias("stok.urun", "urun")
                .createAlias("stok.firma", "firma").createAlias("urun.urunTur", "urunTur")
                .add(Restrictions.ne("gider.isAktif", false)).add(Restrictions.ne("stok.isAktif", false))
                .add(Restrictions.ne("giderTuru.isAktif", false)).add(Restrictions.ne("urun.isAktif", false))
                .add(Restrictions.between("gider.alisTarihi", startDate, endDate))
                .addOrder(Order.desc("gider.alisTarihi")).list();
        System.out.println(list.size());

    } catch (Exception e) {
        System.out.println(e.toString());
        throw e;
    } finally {
        session.close();
    }
    return list;
}

From source file:helper.SiparisHelper.java

public List<Siparis> listReport(Date pStartDate, Date pEndDate) throws Exception { //Satilan rnlerin raporlar getiriliyor.

    Session session = null;//from w w w .  j  av a  2  s  .com
    List<Siparis> list = new ArrayList<>();

    try {
        session = sessionFactory.openSession();
        list = session.createCriteria(Siparis.class, "siparis").createAlias("siparis.masa", "masa")
                .createAlias("siparis.stok", "stok").createAlias("stok.urun", "urun")
                .add(Restrictions.ne("stok.isAktif", false)).add(Restrictions.ne("siparis.isAktif", false))
                .add(Restrictions.ne("masa.isAktif", false)).add(Restrictions.eq("masa.isOdendi", true))
                .add(Restrictions.eq("siparis.isOdendi", true))
                .add(Restrictions.between("siparis.satisTarihi", pStartDate, pEndDate))
                .addOrder(Order.desc("siparis.satisTarihi")).list();

    } catch (Exception e) {
        throw e;
    } finally {
        session.close();
    }

    return list;
}

From source file:helper.SiparisHelper.java

public List<Siparis> listPersonelRapor(Personel personel, Date startDate, Date endDate) throws Exception {

    List<Siparis> list = new ArrayList<>();
    Session session = null;/* ww  w .  java  2  s .co m*/

    System.out.println("Helper: " + personel.getPersonelId());
    try {
        session = sessionFactory.openSession();
        list = session.createCriteria(Siparis.class, "siparis").createAlias("siparis.personel", "personel")
                .createAlias("personel.yetki", "yetki").createAlias("siparis.masa", "masa")
                .createAlias("siparis.stok", "stok").createAlias("stok.urun", "urun")
                .add(Restrictions.eq("personel.personelId", personel.getPersonelId()))
                .add(Restrictions.between("siparis.satisTarihi", startDate, endDate))
                .add(Restrictions.ne("siparis.isAktif", false)).add(Restrictions.ne("personel.isAktif", false))
                .add(Restrictions.ne("masa.isAktif", false)).add(Restrictions.eq("siparis.isOdendi", true))
                .add(Restrictions.eq("masa.isOdendi", true)).add(Restrictions.ne("siparis.isIptal", true))
                .addOrder(Order.desc("siparis.satisTarihi")).list();

    } catch (Exception e) {

        throw e;
    } finally {
        session.close();
    }

    return list;
}

From source file:it.infn.ct.security.utilities.LDAPCleaner.java

License:Apache License

private void followingChecks(int days) {
    _log.info("Check users who have not extended yet");
    Calendar cal = GregorianCalendar.getInstance();
    cal.add(Calendar.DAY_OF_YEAR, days);
    cal.set(Calendar.HOUR_OF_DAY, 0);
    cal.set(Calendar.MINUTE, 0);/*from w  w w. ja  va  2s  .  co  m*/
    cal.set(Calendar.SECOND, 0);
    cal.set(Calendar.MILLISECOND, 0);

    Calendar calEnd = GregorianCalendar.getInstance();
    calEnd.setTime(cal.getTime());
    calEnd.add(Calendar.DAY_OF_YEAR, 1);

    Session ses = factory.openSession();

    List lstUserUpdates = ses.createCriteria(UserConfirmUpdate.class)
            .add(Restrictions.between("timelimit", cal.getTime(), calEnd.getTime()))
            .add(Restrictions.eq("updated", Boolean.FALSE)).list();

    for (UserConfirmUpdate ucu : (List<UserConfirmUpdate>) lstUserUpdates) {
        UserRequest ur = LDAPUtils.getUser(ucu.getUsername());

        sendUserRemainder(ur, days);
    }

    ses.close();

}

From source file:it.infn.ct.security.utilities.LDAPCleaner.java

License:Apache License

private void stopUsers() {
    _log.info("Disable users who do not confirm the account extension");
    Session session = factory.openSession();
    session.beginTransaction();//from w  w  w  .j  a v  a 2 s  .  c o m

    Calendar cal = GregorianCalendar.getInstance();
    cal.set(Calendar.HOUR_OF_DAY, 0);
    cal.set(Calendar.MINUTE, 0);
    cal.set(Calendar.SECOND, 0);
    cal.set(Calendar.MILLISECOND, 0);

    Calendar calEnd = GregorianCalendar.getInstance();
    calEnd.setTime(cal.getTime());
    calEnd.add(Calendar.DAY_OF_YEAR, 1);

    Session ses = factory.openSession();

    List lstUserUpdates = ses.createCriteria(UserConfirmUpdate.class)
            .add(Restrictions.between("timelimit", cal.getTime(), calEnd.getTime()))
            .add(Restrictions.eq("updated", Boolean.FALSE)).list();

    for (UserConfirmUpdate ucu : (List<UserConfirmUpdate>) lstUserUpdates) {
        UserRequest ur = LDAPUtils.getUser(ucu.getUsername());
        LDAPUtils.disableUser(ucu.getUsername());
        sendUserRemainder(ur, 0);
    }

    ses.close();

    session.getTransaction().commit();
    session.close();

}

From source file:ke.co.mspace.nonsmppmanager.service.SMSOutServiceImpl.java

@Override
public Map<String, Object> userSMSOutReport(String user, String startDate, String endDate) {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.getTransaction().begin();// w ww  .ja  v a  2  s  .  co  m
    Criteria criteria = session.createCriteria(SMSOut.class);
    criteria.add(Restrictions.eq("user", user));
    criteria.add(Restrictions.between("timeSubmitted", startDate, endDate));

    List<SMSOut> result = criteria.list();
    int noSMS = 0;
    for (SMSOut sms : result) {
        noSMS += sms.getSmsCount();
    }

    Map<String, Object> mapResult = new HashMap<>();
    mapResult.put("result", result);
    mapResult.put("noSMS", noSMS);

    System.out.println("No of SMS from Bean: " + noSMS);
    session.getTransaction().commit();
    return mapResult;
}

From source file:ke.co.mspace.nonsmppmanager.service.SMSOutServiceImpl.java

@Override
public Map<String, Object> smsOutGroupBy(String user, String startDate, String endDate) {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.getTransaction().begin();//  ww  w .j ava2  s  . c  om
    Criteria criteria = session.createCriteria(SMSOut.class);

    /*
     * This is where the report is going to come from
     * projectionList.add(Projections.sqlGroupProjection("YEAR(time_submitted) as yearSubmitted, MONTHNAME(STR_TO_DATE(MONTH(time_submitted), '%m')) as monthSubmitted, time_submitted as timeSubmitted", "timeSubmitted", new String[] { "monthSubmitted", "timeSubmitted", "yearSubmitted" }, new Type[] { StandardBasicTypes.STRING }));
     */
    ProjectionList projectionList = Projections.projectionList();
    projectionList.add(Projections.sqlGroupProjection(
            "YEAR(time_submitted) as yearSubmitted, MONTHNAME(STR_TO_DATE(MONTH(time_submitted), '%m')) as timeSubmitted",
            "yearSubmitted, timeSubmitted", new String[] { "yearSubmitted", "timeSubmitted" },
            new Type[] { StandardBasicTypes.LONG, StandardBasicTypes.STRING }));

    projectionList.add(Projections.rowCount());

    criteria.setProjection(projectionList); //This is added
    criteria.add(Restrictions.eq("user", user));
    criteria.addOrder(Order.asc("timeSubmitted"));
    criteria.add(Restrictions.between("timeSubmitted", startDate, endDate));

    List<Object[]> results = criteria.list();

    for (Object[] aResult : results) {
        System.out.println("the Object: " + Arrays.deepToString(aResult));
        System.out.println("Year : " + aResult[0] + " Month : " + aResult[1] + " No. Sent : " + aResult[2]);
    }

    Map<String, Object> mapResult = new HashMap<>();
    mapResult.put("result", results);
    mapResult.put("noSMS", 20);

    session.getTransaction().commit();
    return mapResult;
}

From source file:ke.co.mspace.nonsmppmanager.service.SMSOutServiceImpl.java

@Override
public Map<String, String> smsOutGroupByUser(String startDate, String endDate) {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.getTransaction().begin();/*ww  w .j a v a  2  s.  c o  m*/
    Criteria criteria = session.createCriteria(SMSOut.class);

    Calendar startAnotherDate = null;
    Calendar endAnotherDate = null;
    try {
        startAnotherDate = stringToCalendar(startDate);
        endAnotherDate = stringToCalendar(endDate);
    } catch (ParseException ex) {
        Logger.getLogger(SMSOutServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
    }

    /*
     * This is where the report is going to come from
     * projectionList.add(Projections.sqlGroupProjection("YEAR(time_submitted) as yearSubmitted, MONTHNAME(STR_TO_DATE(MONTH(time_submitted), '%m')) as monthSubmitted, time_submitted as timeSubmitted", "timeSubmitted", new String[] { "monthSubmitted", "timeSubmitted", "yearSubmitted" }, new Type[] { StandardBasicTypes.STRING }));
     */
    ProjectionList projectionList = Projections.projectionList();
    projectionList.add(Projections.sqlGroupProjection(
            "YEAR(time_submitted) as yearSubmitted, MONTHNAME(STR_TO_DATE(MONTH(time_submitted), '%m')) as timeSubmitted, user as userName",
            "yearSubmitted, timeSubmitted, userName",
            new String[] { "yearSubmitted", "timeSubmitted", "userName" },
            new Type[] { StandardBasicTypes.LONG, StandardBasicTypes.STRING, StandardBasicTypes.STRING }));
    projectionList.add(Projections.rowCount());
    criteria.setProjection(projectionList);
    criteria.addOrder(Order.asc("timeSubmitted"));
    criteria.add(Restrictions.between("timeSubmitted", startDate, endDate));

    List<Object[]> results = criteria.list();
    Map<String, Integer> json = new LinkedHashMap<>();
    Set<String> months = new LinkedHashSet<>();
    Set<String> users = new LinkedHashSet<>();

    while (startAnotherDate.before(endAnotherDate)) {
        String month = startAnotherDate.getDisplayName(Calendar.MONTH, Calendar.LONG, Locale.getDefault());
        int year = startAnotherDate.get(Calendar.YEAR);
        for (Object[] aResult : results) {
            json.put(year + "-" + month + "-" + aResult[2], 0);
            months.add(aResult[0] + "-" + aResult[1]);
            users.add(String.valueOf(aResult[2]));
        }

        startAnotherDate.add(Calendar.MONTH, 1);
    }

    String madeUp = null;
    for (String aString : json.keySet()) {
        for (Object[] aResult : results) {
            madeUp = aResult[0] + "-" + aResult[1] + "-" + aResult[2];
            if (aString.equals(madeUp)) {
                json.put(aString, Integer.parseInt(String.valueOf(aResult[3])));
            }
        }

    }
    StringBuilder builder = new StringBuilder();

    for (String aMonth : months) {
        builder.append("[");
        builder.append('"');
        builder.append(aMonth.substring(0, 8));
        builder.append('"');
        builder.append(',');
        for (String aString : json.keySet()) {
            if (aString.contains(aMonth)) {

                builder.append(json.get(aString));
                builder.append(",");
            }

        }
        builder.append("]");
        if (builder.length() > 0) {

            if (builder.charAt(builder.lastIndexOf("]") - 1) == ',') {
                builder.deleteCharAt(builder.lastIndexOf("]") - 1);
            }
        }
        builder.append(",");
    }
    if (builder.length() > 0) {

        builder.deleteCharAt(builder.lastIndexOf(","));

    }
    StringBuilder userBuilder = new StringBuilder();
    userBuilder.append("[");
    for (String aUser : users) {

        userBuilder.append('"');
        userBuilder.append(aUser);
        userBuilder.append('"');
        userBuilder.append(',');
    }
    userBuilder.append(']');
    if (userBuilder.length() > 0) {

        if (userBuilder.charAt(userBuilder.lastIndexOf("]") - 1) == ',') {
            userBuilder.deleteCharAt(userBuilder.lastIndexOf("]") - 1);
        }
    }

    System.out.println("A new builder : " + builder.toString());
    System.out.println("The Users : " + userBuilder.toString());

    Map<String, String> mapResult = new HashMap<>();
    mapResult.put("data", builder.toString());
    mapResult.put("users", userBuilder.toString());

    session.getTransaction().commit();
    return mapResult;
}