Example usage for org.hibernate.criterion Restrictions gt

Introduction

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

Prototype

public static SimpleExpression gt(String propertyName, Object value) 

Source Link

Document

Apply a "greater than" constraint to the named property

Usage

From source file:outfox.dict.contest.dao.ContestDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
@Transactional//www. ja  va  2 s .com
public List<AwardEntity> getAwardList(int period) {
    Criteria c = sessionFactory.getCurrentSession().createCriteria(AwardEntity.class);
    c.add(Restrictions.eq("period", period));
    // ?0??
    c.add(Restrictions.or(Restrictions.gt("remainNum", 0), Restrictions.eq("remainNum", -1)));
    c.addOrder(Order.asc("id"));
    return c.list();
}

---

From source file:pe.gob.onpe.rae.dao.hibernate.ExpedientePadronDAOH.java

@Override
public List<ExpedientePadron> fetchByRangoInicialInd(Expediente expediente, int indicador, int desde) {

    Criteria criteria = this.getSession().createCriteria(ExpedientePadron.class);
    criteria.add(Restrictions.eq("expediente", expediente));
    criteria.add(Restrictions.not(Restrictions.in("estado",
            new Integer[] { Parametros.ESTADO_ELECTOR_ELIMINADO, Parametros.ESTADO_ELECTOR_RECHAZADO })));
    criteria.add(Restrictions.eq("indicador", indicador));
    criteria.add(Restrictions.gt("ordenRegistro", desde));
    criteria.addOrder(Order.asc("ordenRegistro"));
    return (List<ExpedientePadron>) criteria.list();
}

---

From source file:pe.gob.onpe.rae.dao.hibernate.ExpedientePadronDAOH.java

@Override
public List<ExpedientePadron> getByCompaginado(ExpedienteImpresion expImpresion) {
    Criteria criteria = this.getSession().createCriteria(ExpedientePadron.class);
    criteria.add(Restrictions.eq("expediente", expImpresion.getExpediente()));
    criteria.add(Restrictions.not(Restrictions.in("estado",
            new Integer[] { Parametros.ESTADO_ELECTOR_ELIMINADO, Parametros.ESTADO_ELECTOR_RECHAZADO })));
    criteria.add(Restrictions.eq("indicador", expImpresion.getIndicador()));
    criteria.add(Restrictions.gt("ordenRegistro", expImpresion.getRegistroInicial() - 1));
    criteria.add(Restrictions.lt("ordenRegistro", expImpresion.getResgitroFinal() + 1));
    criteria.addOrder(Order.asc("ordenRegistro"));
    return (List<ExpedientePadron>) criteria.list();
}

---

From source file:pkg.CriteriaProductCode.java

public void listProductCodes() {
    Session session = sessionFactory.openSession();
    Transaction tx = null;/*from   w w w  .j  av  a 2 s  .co  m*/
    try {
        tx = session.beginTransaction();
        Criteria cr = session.createCriteria(ProductCode.class);
        // Add restriction.
        cr.add(Restrictions.gt("discountCode", "2000"));
        List l = cr.list();

        for (Iterator iterator = l.iterator(); iterator.hasNext();) {
            ProductCode pc = (ProductCode) iterator.next();
            System.out.print("Product Code: " + pc.getProdCode() + "  Discount Code: " + pc.getDiscountCode());
            System.out.println("  Description: " + pc.getDescription());
        }
        tx.commit();
    } catch (HibernateException e) {
        if (tx != null) {
            tx.rollback();
        }
        e.printStackTrace();
    } finally {
        session.close();
    }
}

---

From source file:pl.umk.mat.zawodyweb.www.RequestBean.java

License:Open Source License

public List<Problems> getSubmittableProblems() {
    if (submittableProblems == null) {
        Criteria c = HibernateUtil.getSessionFactory().getCurrentSession().createCriteria(Problems.class);
        Criteria s = c.createCriteria("series");

        if (getCurrentContest() != null) {
            s.createCriteria("contests").add(Restrictions.eq("id", getCurrentContest().getId()));
        }//from ww w. j a v  a  2 s  . c om
        if (getCurrentContest() == null
                || rolesBean.canEditProblem(getCurrentContest().getId(), null) == false) {
            s.add(Restrictions.or(Restrictions.isNull("enddate"), Restrictions.gt("enddate", new Date())));
            s.add(Restrictions.le("startdate", new Date()));
        }
        s.addOrder(Order.desc("startdate"));
        s.addOrder(Order.desc("id"));
        c.addOrder(Order.asc("abbrev"));

        if (getCurrentContest() == null
                || rolesBean.canEditProblem(getCurrentContest().getId(), null) == false) {
            String clientIp = getClientIp();
            List<Problems> problems = c.list();
            submittableProblems = new ArrayList<Problems>();
            for (Problems problem : problems) {
                if (ELFunctions.isValidIP(problem.getSeries().getOpenips(), clientIp)) {
                    submittableProblems.add(problem);
                }
            }
        } else {
            submittableProblems = c.list();
        }
    }

    return submittableProblems;
}

---

From source file:py.una.pol.karaku.dao.helper.GtExpressionHelper.java

License:Open Source License

@Override
public Criterion getCriterion(@Nonnull Criteria criteria, @Nonnull Gt gt,
        @Nonnull Map<String, String> aliases) {

    String aliasWithProperty = configureAlias(criteria, gt.getPath(), aliases);
    return Restrictions.gt(aliasWithProperty, gt.getValue());

}

---

From source file:py.una.pol.karaku.dao.where.Gt.java

License:Open Source License

@Override
public Criterion getCriterion() {

    return Restrictions.gt(this.path, this.value);
}

---

From source file:ro.cs.ts.model.dao.impl.DaoRecordImpl.java

License:Open Source License

/**
 * Checks if exists a record for a person, for a specific project, activity, with the same work hours or overtime hours range
 * /*from   w  w  w.j ava2s . co m*/
 * @author Adelina
 * 
 * @param recordId
 * @param teamMemberDetailId
 * @param activityId
 * @param startTime
 * @param endTime
 * @param time
 * @param overTimeStartTime
 * @param overTimeEndTime
 * @param overtimeTime
 * @param personDetailId
 * @return
 */
public Record hasIdenticalRecordForPerson(Integer recordId, Integer teamMemberDetailId, Integer activityId,
        Date startTime, Date endTime, String time, Date overTimeStartTime, Date overTimeEndTime,
        String overtimeTime, Integer personDetailId) {
    logger.debug("hasIdenticalRecordForPerson - START");

    // if we have a startTime and an endTime
    if (startTime != null && endTime != null) {

        logger.debug("startTime = " + startTime);
        logger.debug("endTime = " + endTime);

        boolean existRecord = false;

        // else, find if there is another record with the same conditions
        DetachedCriteria dc1 = DetachedCriteria.forEntityName(IModelConstant.recordEntity);
        if (teamMemberDetailId != null) {
            dc1.add(Restrictions.eq("teamMemberDetailId", teamMemberDetailId));
        } else if (personDetailId != null) {
            dc1.add(Restrictions.eq("personDetailId", personDetailId));
        }

        dc1.add(Restrictions.ne("status", IConstant.NOM_RECORD_STATUS_DELETED));
        dc1.add(Restrictions.eq("activityId", activityId));

        if (recordId != null && recordId > 0) {
            dc1.add(Restrictions.ne("recordId", recordId));
        }

        dc1.add(Restrictions.or(
                Restrictions.or(
                        Restrictions.or(
                                Restrictions.and(Restrictions.ge("startTime", startTime),
                                        Restrictions.le("endTime", endTime)),
                                Restrictions.and(Restrictions.lt("startTime", startTime),
                                        Restrictions.gt("endTime", startTime))),
                        Restrictions.or(
                                Restrictions.and(Restrictions.lt("startTime", endTime),
                                        Restrictions.gt("endTime", endTime)),
                                Restrictions.and(Restrictions.le("startTime", startTime),
                                        Restrictions.gt("endTime", endTime)))),
                Restrictions.or(
                        Restrictions.or(
                                Restrictions.and(Restrictions.ge("overTimeStartTime", startTime),
                                        Restrictions.le("overTimeEndTime", endTime)),
                                Restrictions.and(Restrictions.lt("overTimeStartTime", startTime),
                                        Restrictions.gt("overTimeEndTime", startTime))),
                        Restrictions.or(
                                Restrictions.and(Restrictions.lt("overTimeStartTime", endTime),
                                        Restrictions.gt("overTimeEndTime", endTime)),
                                Restrictions.and(Restrictions.le("overTimeStartTime", startTime),
                                        Restrictions.gt("overTimeEndTime", endTime))))));

        List<Record> tempRecords = (List<Record>) getHibernateTemplate().findByCriteria(dc1);
        Record record = null;
        if (tempRecords != null && tempRecords.size() > 0) {
            logger.debug("tempRecords size = " + tempRecords.size() + ", " + tempRecords);
            for (Record rec : tempRecords) {
                logger.debug("record = " + rec);
                if (rec.getStartTime() != null && rec.getEndTime() != null) {
                    boolean hasOverlap = ControllerUtils.getInstance().hasOverlap(startTime, endTime, time,
                            rec.getStartTime(), rec.getEndTime(), rec.getTime());
                    logger.debug("hasOverlap = " + hasOverlap);
                    if (hasOverlap) {
                        existRecord = true;
                        record = rec;
                        break;
                    }
                }
                if (rec.getOverTimeStartTime() != null && rec.getOverTimeEndTime() != null) {
                    if (ControllerUtils.getInstance().hasOverlap(startTime, endTime, time,
                            rec.getOverTimeStartTime(), rec.getOverTimeEndTime(), rec.getOverTimeTime())) {
                        existRecord = true;
                        record = rec;
                        break;
                    }
                }
            }
        }

        // if we have also an overtimeStartTime and an overtimeEndTime
        if (overTimeStartTime != null && overTimeEndTime != null) {

            logger.debug("overTimeStartTime = " + overTimeStartTime);
            logger.debug("overTimeEndTime = " + overTimeEndTime);

            // if the range for the work hours is the same or is an interval from the overtime hours
            // we can't add or update the record
            if (((startTime.after(overTimeStartTime) || startTime.equals(overTimeStartTime))
                    && (endTime.before(overTimeEndTime) || endTime.equals(overTimeEndTime)))
                    || (startTime.before(overTimeStartTime) && endTime.after(overTimeStartTime))
                    || (startTime.before(overTimeEndTime) && endTime.after(overTimeEndTime))
                    || ((startTime.before(overTimeStartTime) || startTime.equals(overTimeStartTime))
                            && (endTime.after(overTimeEndTime) || endTime.equals(overTimeEndTime)))) {
                logger.debug("hasIdenticalRecordForPerson - END");
                if (ControllerUtils.getInstance().hasOverlap(startTime, endTime, time, overTimeStartTime,
                        overTimeEndTime, overtimeTime)) {
                    return new Record();
                } else {
                    return null;
                }
            } else {
                if (existRecord == true) {
                    logger.debug("hasIdenticalRecordForPerson - END, tempRecords = " + tempRecords + ", size = "
                            + tempRecords.size());
                    return record;
                }
            }
        } else {
            if (existRecord == true) {
                logger.debug("hasIdenticalRecordForPerson - END, tempRecords = " + tempRecords + ", size = "
                        + tempRecords.size());
                return record;
            }
        }
    }

    // also, for the overtime
    if (overTimeStartTime != null && overTimeEndTime != null) {

        logger.debug("overTimeStartTime = " + overTimeStartTime);
        logger.debug("overTimeEndTime = " + overTimeEndTime);

        DetachedCriteria dc = DetachedCriteria.forEntityName(IModelConstant.recordEntity);

        if (teamMemberDetailId != null) {
            dc.add(Restrictions.eq("teamMemberDetailId", teamMemberDetailId));
        } else if (personDetailId != null) {
            dc.add(Restrictions.eq("personDetailId", personDetailId));
        }
        dc.add(Restrictions.ne("status", IConstant.NOM_RECORD_STATUS_DELETED));
        dc.add(Restrictions.eq("activityId", activityId));
        if (recordId != null && recordId > 0) {
            dc.add(Restrictions.ne("recordId", recordId));
        }

        dc.add(Restrictions.or(
                Restrictions.or(
                        Restrictions.or(
                                Restrictions.and(Restrictions.ge("startTime", overTimeStartTime),
                                        Restrictions.le("endTime", overTimeEndTime)),
                                Restrictions.and(Restrictions.lt("startTime", overTimeStartTime),
                                        Restrictions.gt("endTime", overTimeStartTime))),
                        Restrictions.or(
                                Restrictions.and(Restrictions.lt("startTime", overTimeEndTime),
                                        Restrictions.gt("endTime", overTimeEndTime)),
                                Restrictions.and(Restrictions.le("startTime", overTimeStartTime),
                                        Restrictions.gt("endTime", overTimeEndTime)))),
                Restrictions.or(
                        Restrictions.or(
                                Restrictions.and(Restrictions.ge("overTimeStartTime", overTimeStartTime),
                                        Restrictions.le("overTimeEndTime", overTimeEndTime)),
                                Restrictions.and(Restrictions.lt("overTimeStartTime", overTimeStartTime),
                                        Restrictions.gt("overTimeEndTime", overTimeStartTime))),
                        Restrictions.or(
                                Restrictions.and(Restrictions.lt("overTimeStartTime", overTimeEndTime),
                                        Restrictions.gt("overTimeEndTime", overTimeEndTime)),
                                Restrictions.and(Restrictions.le("overTimeStartTime", overTimeStartTime),
                                        Restrictions.gt("overTimeEndTime", overTimeEndTime))))));

        List<Record> records = (List<Record>) getHibernateTemplate().findByCriteria(dc);

        logger.debug("hasIdenticalRecordForPerson - END, records = " + records + ", size = " + records.size());

        if (records != null && records.size() > 0) {
            for (Record rec : records) {
                logger.debug("rec = " + rec);
                if (rec.getStartTime() != null && rec.getEndTime() != null) {
                    if (ControllerUtils.getInstance().hasOverlap(overTimeStartTime, overTimeEndTime,
                            overtimeTime, rec.getStartTime(), rec.getEndTime(), rec.getTime())) {
                        return rec;
                    }
                } else if (rec.getOverTimeStartTime() != null && rec.getOverTimeEndTime() != null) {
                    if (ControllerUtils.getInstance().hasOverlap(overTimeStartTime, overTimeEndTime,
                            overtimeTime, rec.getOverTimeStartTime(), rec.getOverTimeEndTime(),
                            rec.getOverTimeTime())) {
                        return rec;
                    }
                }

            }
            return null;
        }
    }
    return null;
}

---

From source file:rocks.byivo.ecommercelite.dao.ItemDao.java

@Override
public List<Item> findSellableItems() {
    Session session = (Session) this.entityManager.getDelegate();
    Criteria cr = session.createCriteria(this.clazz);

    cr.add(Restrictions.gt("boughtPrice", 0.0));

    return cr.list();
}

---

From source file:services.Service.java

public List<T> findBy(String column, Serializable value, String operador) {
    Session s = getSession();/*w w  w  .  java 2 s  .c o  m*/
    synchronized (s) {
        try {

            Criteria c = s.createCriteria(classRef);

            for (int i = 0; i < operador.length(); i++) {
                char operador1 = operador.charAt(i);

                switch (operador1) {
                case '=':
                    c.add(Restrictions.eq(column, value));
                    break;
                case '>':
                    c.add(Restrictions.gt(column, value));
                    break;
                case '<':
                    c.add(Restrictions.lt(column, value));
                    break;
                }
            }
            return c.list();
            //                return s.createQuery("from " + classRef.getSimpleName() + " where " + column + " = ").list();
        } finally {
            autoClose(s);
        }
    }
    //        return getSession();
}

---

• «
• 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
• 50
• »