Example usage for org.hibernate.criterion Restrictions le

Introduction

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

Prototype

public static SimpleExpression le(String propertyName, Object value) 

Source Link

Document

Apply a "less than or equal" constraint to the named property

Usage

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

License:Open Source License

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

    if (filter instanceof PasswordRequestFilter) {
        PasswordRequestFilter pf = (PasswordRequestFilter) filter;

        if (pf.getDateBefore() != null) {
            criteria.add(Restrictions.le("requested", pf.getDateBefore()));
        }/* w w w  .  ja v a 2  s  .c  om*/
        if (pf.getKey() != null) {
            criteria.add(Restrictions.eq("key", pf.getKey()));
        }
        if (pf.getUser() != null) {
            criteria.add(Restrictions.eq("user", pf.getUser()));
        }
    }

    return criteria;
}

---

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

License:Open Source License

@Override
protected Criteria createCriteria(SearchFilter<SenateElection> filter) {
    Criteria criteria = getSession().createCriteria(SenateElection.class);
    if (filter instanceof SenateElectionFilter) {
        SenateElectionFilter f = (SenateElectionFilter) filter;

        if (f.getStartAfter() != null) {
            criteria.add(Restrictions.ge("start", f.getStartAfter()));
        }//from   w  ww  . ja  v a  2s  .  com
        if (f.getStartBefore() != null) {
            criteria.add(Restrictions.le("start", f.getStartBefore()));
        }
    }

    return criteria;
}

---

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

License:Open Source License

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

    if (filter instanceof TruthsayerComplaintFilter) {
        TruthsayerComplaintFilter tsf = (TruthsayerComplaintFilter) filter;

        if (tsf.getMediated() != null) {
            criteria.add(Restrictions.eq("mediated", tsf.getMediated()));
        }/*from  w  ww  .j ava 2  s  . c om*/
        if (tsf.getStartBefore() != null) {
            criteria.add(Restrictions.le("start", tsf.getStartBefore()));
        }
    }

    return criteria;
}

---

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

License:Open Source License

/**
 * @see com.tysanclan.site.projectewok.entities.dao.UserDAO#getTrialMembersReadyForVote()
 *///from w  ww .  j  a  va 2  s  .  c  o  m
@SuppressWarnings("unchecked")
@Override
public List<User> getTrialMembersReadyForVote() {
    Criteria criteria = getSession().createCriteria(User.class);

    Calendar cal = DateUtil.getCalendarInstance();
    cal.add(Calendar.DAY_OF_YEAR, -14);

    criteria.add(Restrictions.eq("rank", Rank.TRIAL));
    criteria.add(Restrictions.le("joinDate", cal.getTime()));

    Criteria reverse = getSession().createCriteria(AcceptanceVote.class);
    reverse.createAlias("trialMember", "user");
    reverse.setProjection(Projections.property("user.id"));

    List<?> activeVotes = reverse.list();

    if (!activeVotes.isEmpty()) {
        criteria.add(Restrictions.not(Restrictions.in("id", activeVotes)));
    }

    return criteria.list();
}

---

From source file:com.ut.tekir.documents.DocumentBrowseBean.java

License:LGPL

@Override
public DetachedCriteria buildCriteria() {
    DetachedCriteria crit = DetachedCriteria.forClass(DocumentFile.class);

    if (filterModel.getFirstDate() != null) {

        crit.add(Restrictions.ge("updateDate", filterModel.getFirstDate()));
    }//from   w  ww. ja v a  2  s.  co  m

    if (filterModel.getSecondDate() != null) {

        crit.add(Restrictions.le("updateDate", filterModel.getSecondDate()));
    }

    if (filterModel.getName() != null && filterModel.getName().length() > 0) {
        crit.add(Restrictions.like("name", filterModel.getName() + "%"));
    }

    if (filterModel.getStatus() != DocumentFilterModel.Status.All) {

        if (filterModel.getStatus() == DocumentFilterModel.Status.Active) {
            crit.add(Restrictions.eq("active", true));
        } else {
            crit.add(Restrictions.eq("active", false));
        }
    }

    if (filterModel.getDocType() == DocumentFilterModel.DocType.Genel) {
        crit.add(Restrictions.eq("docType", DocumentFilterModel.DocType.Genel));
    }

    if (filterModel.getDocType() == DocumentFilterModel.DocType.Genelge) {
        crit.add(Restrictions.eq("docType", DocumentFilterModel.DocType.Genelge));
    }

    if (filterModel.getDocType() == DocumentFilterModel.DocType.Haber) {
        crit.add(Restrictions.eq("docType", DocumentFilterModel.DocType.Haber));
    }

    if (filterModel.getDocType() == DocumentFilterModel.DocType.Sozlesme) {
        crit.add(Restrictions.eq("docType", DocumentFilterModel.DocType.Sozlesme));
    }

    if (filterModel.getDocType() == DocumentFilterModel.DocType.Teblig) {
        crit.add(Restrictions.eq("docType", DocumentFilterModel.DocType.Teblig));
    }

    if (filterModel.getDocType() == DocumentFilterModel.DocType.Basvuru) {
        crit.add(Restrictions.eq("docType", DocumentFilterModel.DocType.Basvuru));
    } else if (filterModel.getDocType() != DocumentFilterModel.DocType.Hepsi) {
        crit.add(Restrictions.ne("docType", DocumentFilterModel.DocType.Basvuru));
    }

    crit.addOrder(Order.desc("updateDate"));

    return crit;
}

---

From source file:com.ut.tekir.finance.AccountCreditNoteBrowseBean.java

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

    DetachedCriteria crit = DetachedCriteria.forClass(AccountCreditNote.class);

    if (isNotEmpty(filterModel.getSerial())) {
        crit.add(Restrictions.ilike("this.serial", filterModel.getSerial(), MatchMode.START));
    }/*from w ww. j  a  va  2s .  c om*/

    if (isNotEmpty(filterModel.getReference())) {
        crit.add(Restrictions.ilike("this.reference", filterModel.getReference(), MatchMode.START));
    }

    if (isNotEmpty(filterModel.getCode())) {
        crit.add(Restrictions.ilike("this.code", filterModel.getCode(), MatchMode.START));
    }

    if (filterModel.getBeginDate() != null) {
        crit.add(Restrictions.ge("this.date", filterModel.getBeginDate()));
    }

    if (filterModel.getEndDate() != null) {
        crit.add(Restrictions.le("this.date", filterModel.getEndDate()));
    }

    if (filterModel.getAccount() != null) {
        crit.add(Restrictions.le("this.account", filterModel.getAccount()));
    }

    crit.addOrder(Order.desc("serial"));
    crit.addOrder(Order.desc("date"));

    return crit;
}

---

From source file:com.ut.tekir.finance.AccountToBankTransferBrowseBean.java

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

    DetachedCriteria crit = DetachedCriteria.forClass(BankToAccountTransfer.class);

    if (isNotEmpty(filterModel.getSerial())) {
        crit.add(Restrictions.ilike("serial", filterModel.getSerial(), MatchMode.START));
    }/*from w w  w.  j a v  a 2 s. co  m*/

    if (isNotEmpty(filterModel.getReference())) {
        crit.add(Restrictions.ilike("reference", filterModel.getReference(), MatchMode.START));
    }

    if (isNotEmpty(filterModel.getCode())) {
        crit.add(Restrictions.ilike("code", filterModel.getCode(), MatchMode.START));
    }

    if (filterModel.getBeginDate() != null) {
        crit.add(Restrictions.ge("date", filterModel.getBeginDate()));
    }

    if (filterModel.getEndDate() != null) {
        crit.add(Restrictions.le("date", filterModel.getEndDate()));
    }

    if (filterModel.getAccount() != null) {
        crit.add(Restrictions.eq("account", filterModel.getAccount()));
    }

    if (filterModel.getBank() != null) {
        crit.add(Restrictions.eq("this.bank", filterModel.getBank()));
    }

    if (filterModel.getBankBranch() != null) {
        crit.add(Restrictions.eq("this.bankBranch", filterModel.getBankBranch()));
    }

    if (filterModel.getBankAccount() != null) {
        crit.add(Restrictions.eq("this.bankAccount", filterModel.getBankAccount()));
    }

    if (filterModel.getWorkBunch() != null) {
        crit.add(Restrictions.eq("this.workBunch", filterModel.getWorkBunch()));
    }

    crit.add(Restrictions.eq("action", FinanceAction.Credit));
    crit.addOrder(Order.desc("date"));
    crit.addOrder(Order.desc("serial"));
    return crit;
}

---

From source file:com.ut.tekir.finance.BankToAccountTransferBrowseBean.java

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

    DetachedCriteria crit = DetachedCriteria.forClass(BankToAccountTransfer.class);

    if (isNotEmpty(filterModel.getSerial())) {
        crit.add(Restrictions.ilike("serial", filterModel.getSerial(), MatchMode.START));
    }//from w  ww.  j av  a 2s. c  o  m

    if (isNotEmpty(filterModel.getReference())) {
        crit.add(Restrictions.ilike("reference", filterModel.getReference(), MatchMode.START));
    }

    if (isNotEmpty(filterModel.getCode())) {
        crit.add(Restrictions.ilike("code", filterModel.getCode(), MatchMode.START));
    }

    if (filterModel.getBeginDate() != null) {
        crit.add(Restrictions.ge("date", filterModel.getBeginDate()));
    }

    if (filterModel.getEndDate() != null) {
        crit.add(Restrictions.le("date", filterModel.getEndDate()));
    }

    if (filterModel.getAccount() != null) {
        crit.add(Restrictions.eq("account", filterModel.getAccount()));
    }

    if (filterModel.getBank() != null) {
        crit.add(Restrictions.eq("bank", filterModel.getBank()));
    }

    if (filterModel.getBankBranch() != null) {
        crit.add(Restrictions.eq("bankBranch", filterModel.getBankBranch()));
    }

    if (filterModel.getBankAccount() != null) {
        crit.add(Restrictions.eq("bankAccount", filterModel.getBankAccount()));
    }

    if (filterModel.getProcessType() != null) {
        crit.add(Restrictions.eq("this.processType", filterModel.getProcessType()));
    }

    if (filterModel.getWorkBunch() != null) {
        crit.add(Restrictions.eq("this.workBunch", filterModel.getWorkBunch()));
    }

    crit.add(Restrictions.eq("action", FinanceAction.Debit));
    crit.addOrder(Order.desc("date"));
    crit.addOrder(Order.desc("serial"));
    return crit;
}

---

From source file:com.ut.tekir.finance.BankToBankTransferBrowseBean.java

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

    DetachedCriteria crit = DetachedCriteria.forClass(BankToBankTransfer.class);

    if (isNotEmpty(filterModel.getSerial())) {
        crit.add(Restrictions.ilike("serial", filterModel.getSerial(), MatchMode.START));
    }//from   w w w .j  a  v a2 s  .c o m

    if (isNotEmpty(filterModel.getReference())) {
        crit.add(Restrictions.ilike("reference", filterModel.getReference(), MatchMode.START));
    }

    if (isNotEmpty(filterModel.getCode())) {
        crit.add(Restrictions.ilike("code", filterModel.getCode(), MatchMode.START));
    }

    if (filterModel.getBeginDate() != null) {
        crit.add(Restrictions.ge("date", filterModel.getBeginDate()));
    }

    if (filterModel.getEndDate() != null) {
        crit.add(Restrictions.le("date", filterModel.getEndDate()));
    }

    if (filterModel.getFromBank() != null) {
        crit.add(Restrictions.eq("fromBank", filterModel.getFromBank()));
    }

    if (filterModel.getToBank() != null) {
        crit.add(Restrictions.eq("toBank", filterModel.getToBank()));
    }

    if (filterModel.getFromBankBranch() != null) {
        crit.add(Restrictions.eq("fromBankBranch", filterModel.getFromBankBranch()));
    }

    if (filterModel.getToBankBranch() != null) {
        crit.add(Restrictions.eq("toBankBranch", filterModel.getToBankBranch()));
    }

    if (filterModel.getFromBankAccount() != null) {
        crit.add(Restrictions.eq("fromBankAccount", filterModel.getFromBankAccount()));
    }

    if (filterModel.getToBankAccount() != null) {
        crit.add(Restrictions.eq("toBankAccount", filterModel.getToBankAccount()));
    }

    if (filterModel.getTransferType() != BankTransferType.Unknown) {
        crit.add(Restrictions.eq("transferType", filterModel.getTransferType()));
    }

    if (filterModel.getWorkBunch() != null) {
        crit.add(Restrictions.eq("this.workBunch", filterModel.getWorkBunch()));
    }

    crit.addOrder(Order.desc("this.date"));
    crit.addOrder(Order.desc("this.serial"));

    return crit;
}

---

From source file:com.ut.tekir.finance.BankToContactTransferBrowseBean.java

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

    DetachedCriteria crit = DetachedCriteria.forClass(BankToContactTransfer.class);

    crit.createAlias("contact", "contact");

    crit.setProjection(Projections.projectionList().add(Projections.property("id"), "id")
            .add(Projections.property("serial"), "serial").add(Projections.property("reference"), "reference")
            .add(Projections.property("code"), "code").add(Projections.property("bankAccount"), "bankAccount")
            .add(Projections.property("bankBranch"), "bankBranch").add(Projections.property("bank"), "bank")
            .add(Projections.property("contact.name"), "contactName")
            .add(Projections.property("contact.company"), "company")
            .add(Projections.property("contact.person"), "person")
            .add(Projections.property("contact.code"), "contactCode").add(Projections.property("date"), "date")
            .add(Projections.property("info"), "info")
            .add(Projections.property("this.amount.value"), "amountValue")
            .add(Projections.property("this.amount.currency"), "amountCurrency")
            .add(Projections.property("this.cost.value"), "costValue")
            .add(Projections.property("this.cost.currency"), "costCurrency"))
            .setResultTransformer(Transformers.aliasToBean(BankToContactTransferFilterModel.class));

    if (filterModel.getWorkBunch() != null) {
        crit.add(Restrictions.eq("this.workBunch", filterModel.getWorkBunch()));
    }//ww  w.  j a va2  s .  c o m

    if (isNotEmpty(filterModel.getSerial())) {
        crit.add(Restrictions.ilike("this.serial", filterModel.getSerial(), MatchMode.START));
    }

    if (isNotEmpty(filterModel.getReference())) {
        crit.add(Restrictions.ilike("this.reference", filterModel.getReference(), MatchMode.START));
    }

    if (isNotEmpty(filterModel.getCode())) {
        crit.add(Restrictions.ilike("this.code", filterModel.getCode(), MatchMode.START));
    }

    if (filterModel.getBeginDate() != null) {
        crit.add(Restrictions.ge("this.date", filterModel.getBeginDate()));
    }

    if (filterModel.getEndDate() != null) {
        crit.add(Restrictions.le("this.date", filterModel.getEndDate()));
    }

    if (isNotEmpty(filterModel.getContactCode())) {
        crit.add(Restrictions.ilike("contact.code", filterModel.getContactCode(), MatchMode.START));
    }

    if (isNotEmpty(filterModel.getContactName())) {
        crit.add(Restrictions.ilike("contact.name", filterModel.getContactName(), MatchMode.START));
    }

    if (filterModel.getBank() != null) {
        crit.add(Restrictions.eq("this.bank", filterModel.getBank()));
    }

    if (filterModel.getBankBranch() != null) {
        crit.add(Restrictions.eq("this.bankBranch", filterModel.getBankBranch()));
    }

    if (filterModel.getBankAccount() != null) {
        crit.add(Restrictions.eq("this.bankAccount", filterModel.getBankAccount()));
    }

    if (filterModel.getTransferType() != BankTransferType.Unknown) {
        crit.add(Restrictions.eq("this.transferType", filterModel.getTransferType()));
    }

    if (filterModel.getProcessType() != null) {
        crit.add(Restrictions.eq("this.processType", filterModel.getProcessType()));
    }

    crit.add(Restrictions.eq("action", FinanceAction.Debit));
    crit.addOrder(Order.desc("this.date"));
    crit.addOrder(Order.desc("this.serial"));

    return crit;
}

---

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