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:com.cai310.lottery.service.lottery.keno.impl.KenoServiceImpl.java

/**
 * ??// w w w  .j  a  v a2s  .  co m
 * 
 * @param dateNow
 *            
 * @param beforeTime
 *            ???
 * @return ???
 */
@Transactional(readOnly = true)
public Integer getCanChaseIssueNum(Date dateNow, Integer beforeTime) {
    if (null == dateNow)
        return null;
    if (null == beforeTime)
        return null;
    Class<S> clazz = ReflectionUtils.getSuperClassGenricType(getClass(), 0);
    DetachedCriteria criteria = DetachedCriteria.forClass(clazz);
    criteria.add(Restrictions.not(Restrictions.eq("state", IssueState.ISSUE_SATE_FINISH)));
    criteria.add(Restrictions.gt("endedTime", DateUtils.addMinutes(dateNow, beforeTime)));
    criteria.addOrder(Order.asc("endedTime"));
    criteria.setProjection(Projections.rowCount());
    List<Integer> resultList = schemeDao.findByDetachedCriteria(criteria, true);
    if (resultList != null && resultList.size() > 0) {
        return resultList.get(0);
    } else {
        return 0;
    }
}

---

From source file:com.cai310.lottery.web.controller.lottery.keno.KenoController.java

/**
 * ?// ww w. ja  v a 2s  .c  om
 * 
 * @return
 */
public String note() {
    Class<I> cls = kenoService.getIssueDataClass();
    XDetachedCriteria criteria = new XDetachedCriteria(cls);
    if (period != null && !StringUtils.isBlank(period.getPeriodNumber())) {
        criteria.add(Restrictions.like("periodNumber", period.getPeriodNumber(), MatchMode.START));
    }
    criteria.add(Restrictions.gt("state", IssueState.ISSUE_SATE_RESULT));
    criteria.add(Restrictions.isNotNull("results"));
    // criteria.setMaxResults(count);
    criteria.addOrder(Order.desc("id"));
    // zhuhui motify by 2011-05-03 20 30 50  pagesize 20 30 50
    // ??
    if (count > 0) {
        pagination.setPageSize(count);
    }
    pagination = kenoService.findByCriteriaAndPagination(criteria, pagination);

    loadNewsList();

    return "note";
}

---

From source file:com.cai310.lottery.web.controller.lottery.keno.KenoController.java

/**
 * ?//from  w  w  w.j  a va  2  s.co m
 * 
 * @return
 */
public String result() {
    try {
        Class<I> cls = kenoService.getIssueDataClass();
        DetachedCriteria criteria = DetachedCriteria.forClass(cls);
        criteria.add(Restrictions.isNotNull("results"));
        if (StringUtils.isBlank(resultDate)) {
            resultDate = DateUtil.getTodaySixStr();
        }
        criteria.add(Restrictions.gt("prizeTime", DateUtil.getTodaySixDate(resultDate)));
        criteria.add(
                Restrictions.lt("prizeTime", DateUtil.getNextdaySixDate(DateUtil.getTodaySixDate(resultDate))));
        criteria.addOrder(Order.desc("id"));
        periods = kenoService.findKenoPeriodByCriteria(criteria, null);
        resultDates = DateUtil.getSixList();
        return "result-info";
    } catch (ServiceException e) {
        addActionMessage(e.getMessage());
    } catch (Exception e) {
        addActionMessage(e.getMessage());
        logger.warn(e.getMessage(), e);
    }

    return error();
}

---

From source file:com.cai310.lottery.web.controller.lottery.SchemeBaseController.java

/**
 * ?//ww w.j  a va  2s  .  c om
 */
protected XDetachedCriteria buildWonListQueryCriteria() {
    this.preparePeriodsOfList(10);
    String periodId = Struts2Utils.getParameter("periodId");
    if (StringUtils.isNotBlank(periodId)) {
        Period periodTemp = periodEntityManager.getPeriod(Long.valueOf(periodId));
        if (null != periodTemp)
            this.period = periodTemp;
    } else if (this.periods != null && !this.periods.isEmpty()) {
        this.period = this.periods.get(0);
    }

    XDetachedCriteria criteria = new XDetachedCriteria(this.schemeClass, "m");

    String sponsorNameOrSchemeNum = Struts2Utils.getParameter("sponsorNameOrSchemeNum");
    Lottery lotteryType = this.getLotteryType();
    if (StringUtils.isNotBlank(sponsorNameOrSchemeNum)
            && Lottery.isSchemeNumber(sponsorNameOrSchemeNum, lotteryType)) {
        Long schemeId = lotteryType.getSchemeId(sponsorNameOrSchemeNum);
        criteria.add(Restrictions.eq("m.id", schemeId));
    } else {
        if (StringUtils.isNotBlank(sponsorNameOrSchemeNum)) {
            criteria.add(Restrictions.eq("m.sponsorName", sponsorNameOrSchemeNum));
        }
        criteria.add(Restrictions.eq("m.periodId", this.period.getId()));

        Calendar c = Calendar.getInstance();
        c.add(Calendar.HOUR_OF_DAY, 0);
        c.add(Calendar.MINUTE, 0);
        c.add(Calendar.SECOND, 0);
        if (timeFrame != 7) {
            c.add(Calendar.DAY_OF_MONTH, -timeFrame);

            Date date = c.getTime();
            String dateStr = com.cai310.utils.DateUtil.dateToStr(date, "yyyy-MM-dd");
            Date startDate = com.cai310.utils.DateUtil.strToDate(dateStr + " 00:00");
            Date endDate = com.cai310.utils.DateUtil.strToDate(dateStr + " 23:59");

            criteria.add(Restrictions.gt("m.prizeSendTime", startDate));
            criteria.add(Restrictions.lt("m.prizeSendTime", endDate));
        }
        criteria.add(Restrictions.eq("m.prizeSended", true));
        criteria.addOrder(Order.desc("prizeSendTime"));
    }
    return criteria;
}

---

From source file:com.cai310.lottery.web.controller.lottery.SchemeBaseController.java

/**
 * ? ???//  www .  jav a  2s .co  m
 */
protected XDetachedCriteria buildFilterListDetachedCriteria() {
    XDetachedCriteria criteria = new XDetachedCriteria(this.schemeClass, "m");
    criteria.add(Restrictions.eq("m.periodId", this.period.getId()));

    criteria.add(Restrictions.eq("m.shareType", ShareType.TOGETHER));
    if (queryForm != null) {
        // ??
        if (queryForm != null && queryForm.getSecretType() != null) {
            if (queryForm.getSecretType() != SecretType.FULL_PUBLIC) {
                // 
                criteria.add(Restrictions.ne("m.secretType", SecretType.FULL_PUBLIC));
                Struts2Utils.setAttribute("flag", 1);
            }

        } else {
            Struts2Utils.setAttribute("flag", 0);
        }
        if (StringUtils.isNotBlank(queryForm.getSponsorName())) {
            ///?
            if (!"???".equals(queryForm.getSponsorName().trim())) {
                Long schemeId = this.period.getLotteryType().getSchemeId(queryForm.getSponsorName().trim());
                if (schemeId != null) {
                    criteria.add(Restrictions.eq("m.id", schemeId));
                } else {
                    criteria.add(Restrictions.eq("m.sponsorName", queryForm.getSponsorName().trim()));
                }
            }
        }
        if (null != queryForm.getCostType()) {
            queryForm.setMinMaxCost();
        }
        if (null != queryForm.getChooseType()) {
            if (Integer.valueOf(1).equals(queryForm.getChooseType())) {
                // ?
                criteria.add(Restrictions.eq("m.sendToPrint", true));
            } else if (Integer.valueOf(2).equals(queryForm.getChooseType())) {
                // 
                User user = this.getLoginUser();
                if (user != null) {
                    criteria.add(Restrictions.eq("m.sponsorId", user.getId()));
                }
            }
        }
        if (queryForm.getMinSchemeCost() != null)
            criteria.add(Restrictions.ge("m.schemeCost", queryForm.getMinSchemeCost()));

        if (queryForm.getMaxSchemeCost() != null)
            criteria.add(Restrictions.le("m.schemeCost", queryForm.getMaxSchemeCost()));

        if (queryForm.getSchemeState() != null) {
            criteria.add(Restrictions.eq("m.state", queryForm.getSchemeState()));
        }
    }
    if (queryForm != null && queryForm.getOrderType() != null) {
        switch (queryForm.getOrderType()) {
        case CREATE_TIME_DESC:
            criteria.addOrder(Order.desc("m.id"));
            break;
        case CREATE_TIME_ASC:
            criteria.addOrder(Order.asc("m.id"));
            break;
        case PROCESS_RATE_DESC:
            criteria.addOrder(Order.desc("m.progressRate"));
            break;
        case PROCESS_RATE_ASC:
            criteria.addOrder(Order.asc("m.progressRate"));
            break;
        case SCHEME_COST_DESC:
            criteria.addOrder(Order.desc("m.schemeCost"));
            break;
        case SCHEME_COST_ASC:
            criteria.addOrder(Order.asc("m.schemeCost"));
            break;
        }
    } else {
        criteria.addOrder(Order.desc("m.orderPriority"));
        criteria.addOrder(Order.asc("m.state"));
        criteria.addOrder(Order.desc("m.progressRate"));
    }

    Calendar c = Calendar.getInstance();
    c.add(Calendar.HOUR_OF_DAY, 0);
    c.add(Calendar.MINUTE, 0);
    c.add(Calendar.SECOND, 0);
    c.add(Calendar.DAY_OF_MONTH, -10);
    criteria.add(Restrictions.gt("m.createTime", c.getTime()));

    criteria.setMaxResults(50);
    criteria.addOrder(Order.desc("m.id"));
    return criteria;
}

---

From source file:com.cai310.lottery.web.controller.ticket.then.KenoController.java

public String resultList() {
    Map map = Maps.newHashMap();//from  ww w.j  a va2 s.  c  om
    JsonConfig jsonConfig = new JsonConfig();
    StringBuffer sb = new StringBuffer();
    try {
        // check();
        checkTicket();
        Lottery lotteryType = null;
        if (StringUtils.isNotBlank(wLotteryId)) {
            try {
                lotteryType = Lottery.values()[Integer.valueOf(wLotteryId.trim())];
            } catch (Exception e) {
                throw new WebDataException("12-?");
            }
            if (null == lotteryType) {
                throw new WebDataException("12-?");
            }
        }
        // if (StringUtils.isBlank(start)){
        // throw new WebDataException("9-");
        // }
        // try{
        // Integer.valueOf(start);
        // } catch (Exception e) {
        // throw new WebDataException("9-");
        // }
        // if (StringUtils.isBlank(count)){
        // throw new WebDataException("10-?");
        // }
        // try{
        // Integer.valueOf(count);
        // } catch (Exception e) {
        // throw new WebDataException("10-?");
        // }
        Class<I> cls = this.kenoService.getIssueDataClass();
        DetachedCriteria criteria = DetachedCriteria.forClass(cls);
        criteria.add(Restrictions.gt("state", IssueState.ISSUE_SATE_RESULT));
        if (!"".equals(periodNumber)) {
            criteria.add(Restrictions.eq("periodNumber", periodNumber));
        }
        criteria.add(Restrictions.isNotNull("results"));
        criteria.addOrder(Order.desc("id"));
        List<I> list = null;
        if ("".equals(periodNumber)) {
            list = queryService.findByDetachedCriteria(criteria, 0, 1);
        } else {
            list = queryService.findByDetachedCriteria(criteria);
        }
        List<PeriodDataDTO> resultList = Lists.newArrayList();
        if (null != list && !list.isEmpty()) {
            for (I kenoPeriod : list) {
                if (null != kenoPeriod) {
                    PeriodDataDTO periodDataDTO = new PeriodDataDTO();
                    periodDataDTO.setLotteryType(kenoPeriod.getLotteryType());
                    periodDataDTO.setPeriodId(kenoPeriod.getId());
                    periodDataDTO.setPeriodNumber(kenoPeriod.getPeriodNumber());
                    periodDataDTO.setPeriodTitle(kenoPeriod.getLotteryType().getTitle());
                    periodDataDTO
                            .setPrizeTime(DateUtil.dateToStr(kenoPeriod.getPrizeTime(), "yyyy-MM-dd HH:mm:ss"));
                    periodDataDTO.setResult(kenoPeriod.getResults());
                    resultList.add(periodDataDTO);
                }
            }
        }
        map.put("processId", "0");

        map.put("resultList", resultList);
    } catch (WebDataException e) {
        String processId = "7";
        if (null != e.getMessage() && e.getMessage().indexOf("-") != -1) {
            String temp = e.getMessage().split("-")[0];
            try {
                processId = "" + Integer.valueOf(temp);
            } catch (Exception ex) {
            } // /
            Struts2Utils.setAttribute("errorMsg", e.getMessage());
        } else {
            Struts2Utils.setAttribute("errorMsg", "");
        }
        map.put("processId", processId);

        map.put("errorMsg", e.getMessage());
    } catch (ServiceException e) {
        logger.warn(e.getMessage(), e);
        String processId = "7";
        if (null != e.getMessage() && e.getMessage().indexOf("-") != -1) {
            String temp = e.getMessage().split("-")[0];
            try {
                processId = "" + Integer.valueOf(temp);
            } catch (Exception ex) {
            } // /
            Struts2Utils.setAttribute("errorMsg", e.getMessage());
        } else {
            Struts2Utils.setAttribute("errorMsg", "");
        }
        map.put("processId", processId);

        map.put("errorMsg", e.getMessage());
    } catch (Exception e) {
        logger.warn(e.getMessage(), e);
        String processId = "7";
        if (null != e.getMessage() && e.getMessage().indexOf("-") != -1) {
            String temp = e.getMessage().split("-")[0];
            try {
                processId = "" + Integer.valueOf(temp);
            } catch (Exception ex) {
            } // /
            Struts2Utils.setAttribute("errorMsg", e.getMessage());
        } else {
            Struts2Utils.setAttribute("errorMsg", "");
        }
        map.put("processId", processId);

        map.put("errorMsg", e.getMessage());
    }
    renderJson(map, jsonConfig);
    return null;
}

---

From source file:com.cai310.lottery.web.controller.ticket.TicketBaseController.java

public String data() {
    ////*from   www  .ja  va 2  s  .c om*/
    List<Criterion> restrictions = Lists.newArrayList();
    restrictions.add(Restrictions.eq("sponsorId", 370L));
    restrictions.add(Restrictions.gt("createTime", DateUtil.strToDate("2013-11-07 00:00")));
    List<T> t = this.getSchemeEntityManager(this.getLottery()).findSchemeByCriterion(restrictions);
    for (T t2 : t) {
        TicketThen ticketThen = this.getSchemeEntityManager(this.getLottery())
                .findTicketThenByOrderId(t2.getOrderId());
        if (null == ticketThen) {
            DczcScheme scheme = (DczcScheme) t2;
            ticketThen = new TicketThen();
            ticketThen.setOutOrderNumber(t2.getOrderId());
            ticketThen.setOrderId(scheme.getOrderId());
            ticketThen.setOfficialEndTime(scheme.getCommitTime());
            ticketThen.setPlatformInfoId(250L);
            ticketThen.setUserId(370L);
            ticketThen.setLotteryType(scheme.getLotteryType());
            ticketThen.setPeriodNumber(scheme.getPeriodNumber());
            ticketThen.setSchemeNumber(scheme.getSchemeNumber());
            ticketThen.setUnits(scheme.getUnits());
            ticketThen.setMultiple(scheme.getMultiple());
            ticketThen.setSchemeCost(scheme.getSchemeCost());
            ticketThen.setState(TicketSchemeState.SUCCESS);
            ticketThen.setMode(scheme.getMode());
            ticketThen.setPlayType(scheme.getPlayTypeOrdinal());
            ticketThen = this.ticketThenEntityManager.saveTicketThen(ticketThen);
            TicketDatail ticketDatail = new TicketDatail();
            ticketDatail.setTicketId(ticketThen.getId());
            ticketDatail.setContent(scheme.getContentText());
            this.ticketThenEntityManager.saveTicketDatail(ticketDatail);
        }
    }
    return null;
}

---

From source file:com.codefupanda.persistor.util.HibernateUtil.java

License:Open Source License

private static Criterion convert(PropertyValueExpressionCriteria criteria) {
    Criterion criterion = null;//  w  w w .  j  av a2  s. c o  m
    String property = criteria.getProperty();
    Object value = criteria.getValue();

    if (criteria.getOp().equals("=")) {
        criterion = Restrictions.eq(property, value);
    } else if (criteria.getOp().equals(">")) {
        criterion = Restrictions.gt(property, value);
    } else if (criteria.getOp().equals("<")) {
        criterion = Restrictions.lt(property, value);
    } else if (criteria.getOp().equals(">=")) {
        criterion = Restrictions.ge(property, value);
    } else if (criteria.getOp().equals("<=")) {
        criterion = Restrictions.le(property, value);
    } else if (criteria.getOp().equals("in")) {
        criterion = Restrictions.in(property, (Object[]) value);
    } else if (criteria.getOp().equals("like")) {
        criterion = Restrictions.like(property, value);
    } else if (criteria.getOp().equals("ilike")) {
        criterion = Restrictions.ilike(property, value);
    }
    return criterion;
}

---

From source file:com.dalamar.model.LateTrainDaoImpl.java

public LateTrainDao withDelay(boolean delay) {
    Criterion delayExpression = Restrictions.gt("delay", 0);
    if (delay)//from ww  w. j av  a  2s .  c om
        expressions.add(delayExpression);
    return this;
}

---

From source file:com.dalamar.model.LateTrainDaoImpl.java

public LateTrainDao sumTotal(String field) {
    Projection sum = Projections.sum(field);
    projections.add(sum);//from w w  w  .j a v  a 2 s  .  c om
    expressions.add(Restrictions.gt("inSum", 0));
    return this;
}

---

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