Example usage for org.hibernate.criterion Restrictions ilike

Introduction

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

Prototype

public static Criterion ilike(String propertyName, Object value) 

Source Link

Document

A case-insensitive "like" (similar to Postgres ilike operator)

Usage

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

License:Open Source License

@SuppressWarnings("unchecked")
@Override//w w w  . j  a  v a 2  s.c  o m
public List<JourPaiement> rechercherJoursPaiementParCriteres(IdentifiantLibelleDto criteres) {
    final Criteria crit = createCriteria(JourPaiement.class);
    if (criteres != null) {
        if (criteres.getIdentifiant() != null) {
            crit.add(Restrictions.eq("id", criteres.getIdentifiant()));
        }
        if (criteres.getLibelle() != null) {
            crit.add(Restrictions.ilike("libelle", criteres.getLibelle() + "%"));
        }
    }
    crit.addOrder(Order.asc("ordre"));
    return (List<JourPaiement>) crit.list();
}

---

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

License:Open Source License

@SuppressWarnings("unchecked")
@Override//from   w w w.j  a v  a  2s.  co  m
public List<LienFamilial> rechercherLiensFamiliauxParCriteres(
        DimensionCriteresLienFamilialRechercheDto criteres) {

    final Criteria criteria = createCriteria(LienFamilial.class);

    // Critre sur le libelle
    if (criteres.getLibelle() != null && !criteres.getLibelle().equals("")) {
        criteria.add(Restrictions.ilike("libelle", criteres.getLibelle().toLowerCase() + "%"));
    }
    // les types autoriss
    if (criteres.getListeIds() != null && criteres.getListeIds().size() > 0) {
        criteria.add(Restrictions.in("id", criteres.getListeIds()));
    }
    // Ordonner les lments
    criteria.addOrder(Order.asc("libelle"));

    return criteria.list();
}

---

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

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public List<MotifDevis> getMotifsDevisByCriteres(String libelle) {
    final Criteria crit = createCriteria(MotifDevis.class);
    crit.add(Restrictions.ilike("libelle", libelle + "%"));
    crit.addOrder(Order.asc("ordre"));
    return (List<MotifDevis>) crit.list();
}

---

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

License:Open Source License

@SuppressWarnings("unchecked")
@Override//from   ww w . j a  v a 2  s.  c  o m
public List<MoyenPaiement> rechercherMoyensPaiementParCriteres(IdentifiantLibelleDto criteres) {
    final Criteria crit = createCriteria(MoyenPaiement.class);
    if (criteres != null) {
        if (criteres.getIdentifiant() != null) {
            crit.add(Restrictions.eq("id", criteres.getIdentifiant()));
        }
        if (criteres.getLibelle() != null) {
            crit.add(Restrictions.ilike("libelle", criteres.getLibelle() + "%"));
        }
    }
    crit.addOrder(Order.asc("ordre"));
    return (List<MoyenPaiement>) crit.list();
}

---

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

License:Open Source License

@SuppressWarnings("unchecked")
@Override//from   w w w. j a va2 s  .co  m
public List<PeriodicitePaiement> rechercherPeriodicitesPaiementParCriteres(IdentifiantLibelleDto criteres) {
    final Criteria crit = createCriteria(PeriodicitePaiement.class);
    if (criteres != null) {
        if (criteres.getIdentifiant() != null) {
            crit.add(Restrictions.eq("id", criteres.getIdentifiant()));
        }
        if (criteres.getLibelle() != null) {
            crit.add(Restrictions.ilike("libelle", criteres.getLibelle() + "%"));
        }
    }
    crit.addOrder(Order.asc("ordre"));
    return (List<PeriodicitePaiement>) crit.list();
}

---

From source file:com.thinkgem.jeesite.modules.issue.service.IssueProjectVersionService.java

License:Open Source License

public Page<IssueProjectVersion> findIssue(Page<IssueProjectVersion> page,
        IssueProjectVersion issueProjectVersion) {
    DetachedCriteria dc = projectVersionDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(issueProjectVersion.getVersionNo())) {
        dc.add(Restrictions.ilike("versionNo", "%" + issueProjectVersion.getVersionNo() + "%"));
    }//www .ja  v  a2s . c o m
    dc.add(Restrictions.eq(IssueProjectVersion.FIELD_DEL_FLAG, IssueProjectVersion.DEL_FLAG_NORMAL));
    return projectVersionDao.find(page, dc);
}

---

From source file:com.thinkgem.jeesite.modules.issue.service.IssueProjectVersionService.java

License:Open Source License

public List<IssueProjectVersion> findAll(IssueProject project, IssueProjectVersion version) {
    DetachedCriteria dc = projectVersionDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(project.getId())) {
        dc.createAlias("project", "project");
        dc.add(Restrictions.eq("project.id", project.getId()));
    }//from   w  ww .  j  a va  2s  .  co  m

    if (StringUtils.isNotEmpty(version.getStatus())) {
        dc.add(Restrictions.eq("status", version.getStatus()));
    }

    if (StringUtils.isNotEmpty(version.getVersionNo())) {
        dc.add(Restrictions.ilike("versionNo", "%" + version.getVersionNo() + "%"));
    }

    dc.add(Restrictions.eq(IssueProjectVersion.FIELD_DEL_FLAG, IssueProjectVersion.DEL_FLAG_NORMAL));
    dc.addOrder(Order.desc("createDate"));
    return projectVersionDao.find(dc);
}

---

From source file:com.thinkgem.jeesite.modules.issue.service.IssueService.java

License:Open Source License

public Page<IssueInfo> findIssue(Page<IssueInfo> page, IssueInfo issue) {
    DetachedCriteria dc = issueDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(issue.getIssueTitle())) {
        dc.add(Restrictions.ilike("issueTitle", "%" + issue.getIssueTitle() + "%"));
    }//ww  w  .  j  a v a  2  s . c o  m

    if (issue.getProject() != null && StringUtils.isNotEmpty(issue.getProject().getId())) {
        dc.add(Restrictions.eq("project.id", issue.getProject().getId()));
    }

    if ((issue.getCreateBy() != null && StringUtils.isNotEmpty(issue.getCreateBy().getId()))
            && !(issue.getUser() != null && StringUtils.isNotEmpty(issue.getUser().getId()))) {
        dc.add(Restrictions.eq("createBy.id", issue.getCreateBy().getId()));
    }

    if (issue.getUser() != null && StringUtils.isNotEmpty(issue.getUser().getId())
            && !(issue.getCreateBy() != null && StringUtils.isNotEmpty(issue.getCreateBy().getId()))) {
        dc.add(Restrictions.eq("user.id", issue.getUser().getId()));
    }

    if (issue.getUser() != null && StringUtils.isNotEmpty(issue.getUser().getId())
            && (issue.getCreateBy() != null && StringUtils.isNotEmpty(issue.getCreateBy().getId()))) {
        dc.add(Restrictions.or(Restrictions.eq("createBy.id", issue.getCreateBy().getId()),
                Restrictions.eq("user.id", issue.getUser().getId())));
    }

    if (StringUtils.isNotEmpty(issue.getStatus())) {
        dc.add(Restrictions.in("status", issue.getStatus().split(",")));
    }

    dc.add(Restrictions.eq(IssueInfo.FIELD_DEL_FLAG, IssueInfo.DEL_FLAG_NORMAL));
    return issueDao.find(page, dc);
}

---

From source file:com.usetheindexluke.JoinHibernate.java

License:Creative Commons License

public static void main(String[] args) {
    Session session = new Configuration().configure().buildSessionFactory().openSession();
    try {/*from   w  w  w.  ja  va 2s  .  c o  m*/
        String lastName = "Win%";
        Criteria criteria = session.createCriteria(Employees.class);
        criteria.add(Restrictions.ilike("lastName", lastName));

        /*
         * // Uncomment to fetch via join criteria.setFetchMode("sales",
         * FetchMode.JOIN);
         * criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
         */

        List<Employees> result = criteria.list();

        for (Employees e : result) {
            System.out.println("Id " + e.getEmployeeId() + " (" + e.getSubsidiaryId() + "): " + e.getFirstName()
                    + " " + e.getLastName());
            for (Sales s : e.getSales()) {
                System.out.println("   SalesId: " + s.getSaleId() + " date: " + s.getSaleDate() + " EUR value: "
                        + s.getEurValue());
            }
        }
    } finally {
        session.close();
    }
}

---

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

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

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

    /**/*  www  .  j  av a 2s.  c om*/
     *
     * TODO: contact iin outer join gerektiinden kapatld
     *
     *
            crit.createAlias("this.history", "history");
            crit.createAlias("contact", "contact");
                    
            crit.setProjection(Projections.projectionList()
        .add(Projections.groupProperty("this.id"), "id")
        .add(Projections.groupProperty("this.maturityDate"), "maturityDate")
        .add(Projections.groupProperty("this.referenceNo"), "referenceNo")
        .add(Projections.groupProperty("this.bankName"), "bankName")
        .add(Projections.groupProperty("this.bankBranch"), "bankBranch")
        .add(Projections.groupProperty("this.accountNo"), "accountNo")
        .add(Projections.groupProperty("this.chequeOwner"), "chequeOwner")
        .add(Projections.groupProperty("contact.id"), "contactId")
        .add(Projections.groupProperty("contact.name"), "contactName")
        .add(Projections.groupProperty("contact.code"), "contactCode")
        .add(Projections.groupProperty("this.lastStatus"), "lastStatus")
        .add(Projections.groupProperty("this.previousStatus"), "previousStatus")
        .add(Projections.groupProperty("this.info"), "info")
        .add(Projections.groupProperty("money.currency"), "moneyCurrency")
        .add(Projections.groupProperty("money.value"), "moneyValue")
        .add(Projections.groupProperty("this.serialNo"), "serialNo"));
                       
    crit.setResultTransformer(Transformers.aliasToBean(ChequeSumModelContact.class));
    */

    if (isNotEmpty(filterModel.getReferenceNo())) {
        //cheque number
        crit.add(Restrictions.ilike("this.referenceNo", filterModel.getReferenceNo() + "%"));
    }

    if (isNotEmpty(filterModel.getBankName())) {
        crit.add(Restrictions.ilike("this.bankName", filterModel.getBankName() + "%"));
    }

    if (isNotEmpty(filterModel.getBankBranch())) {
        crit.add(Restrictions.ilike("this.bankBranch", filterModel.getBankBranch() + "%"));
    }

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

    if (isNotEmpty(filterModel.getChequeOwner())) {
        crit.add(Restrictions.ilike("this.chequeOwner", filterModel.getChequeOwner() + "%"));
    }

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

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

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

    if (getIsClientCheque() != null) {
        crit.add(Restrictions.eq("this.clientCheque", getIsClientCheque()));
    }

    return crit;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• »