Example usage for org.hibernate.criterion Restrictions lt

Introduction

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

Prototype

public static SimpleExpression lt(String propertyName, Object value) 

Source Link

Document

Apply a "less than" constraint to the named property

Usage

From source file:com.sapienter.jbilling.server.invoice.db.InvoiceDAS.java

License:Open Source License

public List<Integer> findIdsOverdueForUser(Integer userId, Date date) {
    Criteria criteria = getSession().createCriteria(InvoiceDTO.class);
    addUserCriteria(criteria, userId);/*from  w  w  w .  j a  v a  2s  .  c  o m*/
    criteria.add(Restrictions.lt("dueDate", date)).createAlias("invoiceStatus", "s")
            .add(Restrictions.ne("s.id", Constants.INVOICE_STATUS_PAID)).add(Restrictions.eq("isReview", 0))
            .setProjection(Projections.id()).addOrder(Order.desc("id"));
    return criteria.list();
}

---

From source file:com.sapienter.jbilling.server.process.db.BillingProcessDAS.java

License:Open Source License

public ScrollableResults findUsersToProcess(int entityId) {
    Criteria criteria = getSession().createCriteria(UserDTO.class).add(Restrictions.eq("deleted", 0))
            .createAlias("company", "c").add(Restrictions.eq("c.id", entityId)).createAlias("userStatus", "us")
            .add(Restrictions.lt("us.id", UserDTOEx.STATUS_SUSPENDED)).setProjection(Projections.id())
            .setComment("BillingProcessDAS.findUsersToProcess " + entityId);
    return criteria.scroll();
}

---

From source file:com.sccl.attech.modules.sys.service.SystemService.java

License:Open Source License

/**
 * //from   w ww  . j  av a2 s.com
 * @param vote
 * @return
 */
public Page<Vote> find(Page<Vote> page, Vote vote, int type) {
    //System.out.println(page.getPageNo() + "---------------- ?count");
    //System.out.println(page.getPageSize() + "----------------?size");
    DetachedCriteria dc = voteDao.createDetachedCriteria();

    //      dc.createAlias("createBy.office", "office");
    //      dc.add(dataScopeFilter(user, "office", "createBy"));
    if (type == 0) {//
        if (StringUtils.isNotEmpty(vote.getVotingContent())) {
            dc.add(Restrictions.like("votingContent", "%" + vote.getVotingContent() + "%"));
        }
        dc.add(Restrictions.eq(Vote.FIELD_DEL_FLAG, Vote.DEL_FLAG_NORMAL));
        System.out.println("0");
    } else if (type == 1) {//
        dc.add(Restrictions.eq(Vote.SEL_ISEND, Vote.IS_END_NO));
        dc.add(Restrictions.ge(Vote.SEL_DEADLINE, Vote.SEl_DATE));
        System.out.println("1");
    } else if (type == 2) {//
        dc.add(Restrictions.eq(Vote.SEL_ISEND, Vote.IS_END_YES));
        System.out.println("2");
    } else if (type == 3) {//?
        dc.add(Restrictions.lt(Vote.SEL_DEADLINE, Vote.SEl_DATE));
        System.out.println("3");
    } else if (type == 4) {//?
        if (StringUtils.isNotEmpty(vote.getVotingContent())) {
            dc.add(Restrictions.like("votingContent", "%" + vote.getVotingContent() + "%"));
        }
        dc.add(Restrictions.eq(Vote.SEL_ISEND, Vote.IS_END_NO));
        dc.add(Restrictions.ge(Vote.SEL_DEADLINE, Vote.SEl_DATE));
        //??
        User user = UserUtils.getUser();
        DetachedCriteria dc2 = userVoteDao.createDetachedCriteria();
        dc2.add(Restrictions.eq(UserVote.USER_VOTE_USER_ID, user.getId()));
        List<UserVote> list = userVoteDao.find(dc2);
        //?
        for (UserVote ut : list) {
            dc.add(Restrictions.ne(Vote.VOTE_ID, ut.getVoteId()));
        }
    } else if (type == 5) {//??
        if (StringUtils.isNotEmpty(vote.getVotingContent())) {
            dc.add(Restrictions.like("votingContent", "%" + vote.getVotingContent() + "%"));
        }
        User user = UserUtils.getUser();
        DetachedCriteria dc2 = userVoteDao.createDetachedCriteria();
        dc2.add(Restrictions.eq(UserVote.USER_VOTE_USER_ID, user.getId()));
        List<UserVote> list = userVoteDao.find(dc2);
        List<String> list1 = new ArrayList();
        for (UserVote uVote : list) {
            list1.add(uVote.getVoteId());
        }
        dc.add(Restrictions.in(Vote.VOTE_ID, list1));
    }
    dc.addOrder(Order.desc("createDate"));
    return voteDao.find(page, dc);
}

---

From source file:com.square.tarificateur.noyau.dao.implementations.OpportuniteDaoImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//w ww  .ja  v  a  2  s. co m
public List<Opportunite> rechercherOpportunitesByCritere(CriteresRechercheOpportuniteDto criteres) {
    final Criteria crit = createCriteria(Opportunite.class);
    if (criteres.getListeEids() != null && criteres.getListeEids().size() > 0) {
        crit.add(Restrictions.in("eidOpportunite", criteres.getListeEids()));
    }
    if (criteres.getIdFinalite() != null) {
        crit.add(Restrictions.eq("finalite.id", criteres.getIdFinalite()));
    }
    if (criteres.getDebutDateCloture() != null) {
        crit.add(Restrictions.ge("dateCloture", criteres.getDebutDateCloture()));
    }
    if (criteres.getFinDateCloture() != null) {
        crit.add(Restrictions.lt("dateCloture", criteres.getFinDateCloture()));
    }
    if (criteres.getListeEidsNaturePersonneExclure() != null
            && criteres.getListeEidsNaturePersonneExclure().size() > 0) {
        crit.add(Restrictions.or(Restrictions.isNull("eidNaturePersonne"), Restrictions
                .not(Restrictions.in("eidNaturePersonne", criteres.getListeEidsNaturePersonneExclure()))));
    }
    return (List<Opportunite>) crit.list();
}

---

From source file:com.thinkmore.framework.orm.hibernate.HibernateDao.java

License:Apache License

/**
 * ??Criterion,.//  w  w w .j  a v a  2  s.  c o  m
 */
protected Criterion buildPropertyFilterCriterion(final String propertyName, final Object propertyValue,
        final MatchType matchType) {
    Assert.hasText(propertyName, "propertyName?");
    Criterion criterion = null;
    try {
        // ?MatchTypecriterion
        if (MatchType.EQ.equals(matchType)) {
            criterion = Restrictions.eq(propertyName, propertyValue);
        } else if (MatchType.LIKE.equals(matchType)) {
            criterion = Restrictions.like(propertyName, (String) propertyValue, MatchMode.ANYWHERE);
        } else if (MatchType.LE.equals(matchType)) {
            criterion = Restrictions.le(propertyName, propertyValue);
        } else if (MatchType.LT.equals(matchType)) {
            criterion = Restrictions.lt(propertyName, propertyValue);
        } else if (MatchType.GE.equals(matchType)) {
            criterion = Restrictions.ge(propertyName, propertyValue);
        } else if (MatchType.GT.equals(matchType)) {
            criterion = Restrictions.gt(propertyName, propertyValue);
        }
    } catch (Exception e) {
        throw ReflectionUtil.convertReflectionExceptionToUnchecked(e);
    }
    return criterion;
}

---

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.ElectionDAOImpl.java

License:Open Source License

/**
 * @see com.tysanclan.site.projectewok.dataaccess.EwokHibernateDAO#createCriteria(com.tysanclan.site.projectewok.dataaccess.SearchFilter)
 *///from  w  w w .  ja  va  2 s  .  com
@Override
protected Criteria createCriteria(SearchFilter<Election> filter) {
    Criteria criteria = getSession().createCriteria(Election.class);

    if (filter instanceof ElectionFilter) {
        ElectionFilter ef = (ElectionFilter) filter;

        if (ef.getStartBefore() != null) {
            criteria.add(Restrictions.lt("start", ef.getStartBefore()));
        }
        if (ef.getStartAfter() != null) {
            criteria.add(Restrictions.gt("start", ef.getStartBefore()));
        }
    }

    return criteria;
}

---

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.EmailChangeConfirmationDAOImpl.java

License:Open Source License

@Override
protected Criteria createCriteria(SearchFilter<EmailChangeConfirmation> filter) {
    Criteria criteria = getSession().createCriteria(EmailChangeConfirmation.class);

    if (filter instanceof EmailChangeConfirmationFilter) {
        EmailChangeConfirmationFilter eccf = (EmailChangeConfirmationFilter) filter;

        if (eccf.getDateBefore() != null) {
            criteria.add(Restrictions.lt("initialized", eccf.getDateBefore()));
        }//from   www . j a  v a  2  s  .c om
        if (eccf.getUser() != null) {
            criteria.add(Restrictions.eq("user", eccf.getUser()));
        }
    }

    return criteria;
}

---

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.JoinApplicationDAOImpl.java

License:Open Source License

@Override
protected Criteria createCriteria(SearchFilter<JoinApplication> filter) {
    Criteria criteria = getSession().createCriteria(JoinApplication.class);

    if (filter instanceof JoinApplicationFilter) {
        JoinApplicationFilter jaf = (JoinApplicationFilter) filter;

        if (jaf.getApplicant() != null) {
            criteria.add(Restrictions.eq("applicant", jaf.getApplicant()));
        }/*from w w w . j a v  a 2s.  c o  m*/
        if (jaf.getMentor() != null) {
            criteria.add(Restrictions.eq("mentor", jaf.getMentor()));
        }
        if (jaf.getJoinThread() != null) {
            criteria.add(Restrictions.eq("joinThread", jaf.getJoinThread()));
        }

        if (jaf.getDateBefore() != null) {
            criteria.add(Restrictions.lt("startDate", jaf.getDateBefore()));
        }
    }

    return criteria;
}

---

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.RegulationChangeDAOImpl.java

License:Open Source License

@Override
protected Criteria createCriteria(SearchFilter<RegulationChange> filter) {
    Criteria criteria = getSession().createCriteria(RegulationChange.class);

    if (filter instanceof RegulationChangeFilter) {
        RegulationChangeFilter cf = (RegulationChangeFilter) filter;
        if (cf.getStartBefore() != null) {
            criteria.add(Restrictions.lt("start", cf.getStartBefore()));
        }/*ww w  .  j  ava 2  s.co  m*/
        if (cf.getUser() != null) {
            criteria.add(Restrictions.eq("proposer", cf.getUser()));
        }
    }

    return criteria;
}

---

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.RestTokenDAOImpl.java

License:Open Source License

@Override
protected Criteria createCriteria(SearchFilter<RestToken> filter) {
    Criteria criteria = getSession().createCriteria(RestToken.class);

    if (filter instanceof RestTokenFilter) {
        RestTokenFilter rtf = (RestTokenFilter) filter;

        if (rtf.getExpired() != null) {
            boolean expired = rtf.getExpired().booleanValue();

            if (expired) {
                criteria.add(Restrictions.lt("expires", System.currentTimeMillis()));
            } else {
                criteria.add(Restrictions.gt("expires", System.currentTimeMillis()));
            }// ww w.ja  v  a2s  .c  om
        }

        if (rtf.getUser() != null) {
            criteria.add(Restrictions.eq("user", rtf.getUser()));
        }

        if (rtf.getHash() != null) {
            criteria.add(Restrictions.eq("hash", rtf.getHash()));
        }
    }

    return criteria;
}

---

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