Example usage for org.hibernate.criterion Restrictions ilike

List of usage examples for org.hibernate.criterion Restrictions ilike

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. ilike

Introduction

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

Prototype

public static Criterion ilike(String propertyName, String value, MatchMode matchMode)

Source Link

Document

A case-insensitive "like" (similar to Postgres ilike operator) using the provided match mode

Usage

From source file:au.org.theark.core.dao.StudyDao.java

License:Open Source License

public List<ConsentStatus> getRecordableConsentStatus() {
    Criteria criteria = getSession().createCriteria(ConsentStatus.class);
    criteria.add(Restrictions.not(Restrictions.ilike("name", "Not Consented", MatchMode.ANYWHERE)));
    return criteria.list();
}

From source file:au.org.theark.core.dao.StudyDao.java

License:Open Source License

public List<Study> getStudiesForUser(ArkUser arkUser, Study study) {

    Criteria criteria = getSession().createCriteria(ArkUserRole.class);
    criteria.createAlias("arkStudy", "arkStudy");

    criteria.add(Restrictions.eq("arkUser", arkUser));// Represents the user
    // either who is
    // logged in or one
    // that is provided
    if (study.getId() != null) {
        criteria.add(Restrictions.eq("arkStudy.id", study.getId()));
    }/*from   w  w w  . j  a va  2 s  .  co m*/

    if (study.getName() != null) {
        criteria.add(Restrictions.ilike("arkStudy.name", study.getName(), MatchMode.ANYWHERE));
    }
    criteria.setProjection(Projections.distinct(Projections.property("study")));
    List<Study> studies = (List<Study>) criteria.list();
    return studies;

}

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

public List<Biospecimen> searchBiospecimen(Biospecimen biospecimen) throws ArkSystemException {
    Criteria criteria = getSession().createCriteria(Biospecimen.class);

    if (biospecimen.getId() != null)
        criteria.add(Restrictions.eq("id", biospecimen.getId()));

    if (biospecimen.getBiospecimenUid() != null)
        criteria.add(Restrictions.ilike("biospecimenUid", biospecimen.getBiospecimenUid(), MatchMode.ANYWHERE));

    if (biospecimen.getLinkSubjectStudy() != null)
        criteria.add(Restrictions.eq("linkSubjectStudy", biospecimen.getLinkSubjectStudy()));

    if (biospecimen.getStudy() != null)
        criteria.add(Restrictions.eq("study", biospecimen.getStudy()));

    if (biospecimen.getSampleType() != null)
        criteria.add(Restrictions.eq("sampleType", biospecimen.getSampleType()));

    if (biospecimen.getSampleDate() != null)
        criteria.add(Restrictions.eq("sampleDate", biospecimen.getSampleDate()));

    if (biospecimen.getQtyCollected() != null)
        criteria.add(Restrictions.eq("qtyCollected", biospecimen.getQtyCollected()));

    List<Biospecimen> list = criteria.list();
    return list;/*  ww  w  .  j  av  a2s  .c  om*/
}

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

protected Criteria buildBiospecimenCriteria(Biospecimen biospecimen) {
    Criteria criteria = getSession().createCriteria(Biospecimen.class);

    if (biospecimen.getId() != null)
        criteria.add(Restrictions.eq("id", biospecimen.getId()));

    if (biospecimen.getBiospecimenUid() != null)
        criteria.add(Restrictions.ilike("biospecimenUid", biospecimen.getBiospecimenUid(), MatchMode.ANYWHERE));

    if (biospecimen.getLinkSubjectStudy() != null)
        criteria.add(Restrictions.eq("linkSubjectStudy", biospecimen.getLinkSubjectStudy()));

    if (biospecimen.getStudy() != null)
        criteria.add(Restrictions.eq("study", biospecimen.getStudy()));

    if (biospecimen.getSampleType() != null)
        criteria.add(Restrictions.eq("sampleType", biospecimen.getSampleType()));

    if (biospecimen.getSampleDate() != null)
        criteria.add(Restrictions.eq("sampleDate", biospecimen.getSampleDate()));

    if (biospecimen.getQtyCollected() != null)
        criteria.add(Restrictions.eq("qtyCollected", biospecimen.getQtyCollected()));

    if (biospecimen.getParent() != null) {
        criteria.add(Restrictions.eq("parent", biospecimen.getParent()));
    } else {//from   w ww .  j  a  va  2s. co  m
        criteria.add(Restrictions.isNull("parent"));
    }

    return criteria;
}

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

protected Criteria buildBiospecimenCriteria(LimsVO limsVo) {
    Criteria criteria = getSession().createCriteria(Biospecimen.class);
    Biospecimen biospecimen = limsVo.getBiospecimen();

    criteria.createAlias("bioCollection", "bc");
    criteria.createAlias("linkSubjectStudy", "lss");

    // If study chosen, restrict otherwise restrict on users' studyList
    if (limsVo.getStudy() != null && limsVo.getStudy().getId() != null) {
        //if(limsVo.getStudy().isParentStudy()) {
        if (limsVo.getStudy().getParentStudy() != null && limsVo.getStudy().getParentStudy().getId() != null
                && limsVo.getStudy().getParentStudy().getId().equals(limsVo.getStudy().getId())) {
            // If parent study, show all children as well
            criteria.add(Restrictions.in("study", iStudyDao.getChildStudiesForStudy(limsVo.getStudy())));
        } else {// w w w . j  av a2s .co m
            criteria.add(Restrictions.eq("study", limsVo.getStudy()));
        }
    } else {
        criteria.add(Restrictions.in("study", limsVo.getStudyList()));
        criteria.createAlias("study", "st");
        criteria.addOrder(Order.asc("st.name"));
        criteria.addOrder(Order.asc("lss.subjectUID"));
        criteria.addOrder(Order.asc("bc.biocollectionUid"));
        criteria.addOrder(Order.asc("biospecimenUid"));
    }

    // Restrict on linkSubjectStudy in the LimsVO (or biospecimen)
    if (limsVo.getLinkSubjectStudy() != null && limsVo.getLinkSubjectStudy().getId() != null) {
        criteria.add(Restrictions.eq("linkSubjectStudy", limsVo.getLinkSubjectStudy()));
    } else if (biospecimen.getLinkSubjectStudy() != null) {
        criteria.add(Restrictions.eq("linkSubjectStudy", biospecimen.getLinkSubjectStudy()));
    }

    if (limsVo.getLinkSubjectStudy() != null) {
        if (limsVo.getLinkSubjectStudy().getSubjectUID() != null) {
            criteria.add(Restrictions.ilike("lss.subjectUID", limsVo.getLinkSubjectStudy().getSubjectUID(),
                    MatchMode.ANYWHERE));
        }
    }

    if (limsVo.getBioCollection() != null && limsVo.getBioCollection().getBiocollectionUid() != null) {
        criteria.add(Restrictions.ilike("bc.biocollectionUid", limsVo.getBioCollection().getBiocollectionUid(),
                MatchMode.ANYWHERE));
    }

    if (biospecimen.getId() != null) {
        criteria.add(Restrictions.eq("id", biospecimen.getId()));
    }

    if (biospecimen.getBiospecimenUid() != null) {
        criteria.add(Restrictions.ilike("biospecimenUid", biospecimen.getBiospecimenUid(), MatchMode.ANYWHERE));
    }

    if (biospecimen.getSampleType() != null) {
        criteria.add(Restrictions.eq("sampleType", biospecimen.getSampleType()));
    }

    if (biospecimen.getSampleDate() != null) {
        criteria.add(Restrictions.eq("sampleDate", biospecimen.getSampleDate()));
    }

    if (biospecimen.getQtyCollected() != null) {
        criteria.add(Restrictions.eq("qtyCollected", biospecimen.getQtyCollected()));
    }

    return criteria;
}

From source file:au.org.theark.lims.model.dao.LimsSubjectDao.java

License:Open Source License

private Criteria buildGeneralSubjectCriteria(LimsVO limsVo, List<Study> studyList) {
    Criteria criteria = getSession().createCriteria(LinkSubjectStudy.class);
    criteria.createAlias("person", "p");
    criteria.add(Restrictions.in("study", studyList));

    if (limsVo.getLinkSubjectStudy().getPerson() != null) {

        if (limsVo.getLinkSubjectStudy().getPerson().getId() != null) {
            criteria.add(Restrictions.eq("p.id", limsVo.getLinkSubjectStudy().getPerson().getId()));
        }// w w w .j  av a 2 s  .c om

        if (limsVo.getLinkSubjectStudy().getPerson().getFirstName() != null) {
            criteria.add(Restrictions.ilike("p.firstName",
                    limsVo.getLinkSubjectStudy().getPerson().getFirstName(), MatchMode.ANYWHERE));
        }

        if (limsVo.getLinkSubjectStudy().getPerson().getMiddleName() != null) {
            criteria.add(Restrictions.ilike("p.middleName",
                    limsVo.getLinkSubjectStudy().getPerson().getMiddleName(), MatchMode.ANYWHERE));
        }

        if (limsVo.getLinkSubjectStudy().getPerson().getLastName() != null) {
            criteria.add(Restrictions.ilike("p.lastName",
                    limsVo.getLinkSubjectStudy().getPerson().getLastName(), MatchMode.ANYWHERE));
        }

        if (limsVo.getLinkSubjectStudy().getPerson().getDateOfBirth() != null) {
            criteria.add(Restrictions.eq("p.dateOfBirth",
                    limsVo.getLinkSubjectStudy().getPerson().getDateOfBirth()));
        }

        if (limsVo.getLinkSubjectStudy().getPerson().getGenderType() != null) {
            criteria.add(Restrictions.eq("p.genderType.id",
                    limsVo.getLinkSubjectStudy().getPerson().getGenderType().getId()));
        }

        if (limsVo.getLinkSubjectStudy().getPerson().getVitalStatus() != null) {
            criteria.add(Restrictions.eq("p.vitalStatus.id",
                    limsVo.getLinkSubjectStudy().getPerson().getVitalStatus().getId()));
        }

    }

    if (limsVo.getLinkSubjectStudy().getSubjectUID() != null
            && limsVo.getLinkSubjectStudy().getSubjectUID().length() > 0) {
        criteria.add(Restrictions.ilike("subjectUID", limsVo.getLinkSubjectStudy().getSubjectUID(),
                MatchMode.ANYWHERE));
    }

    if (limsVo.getLinkSubjectStudy().getSubjectStatus() != null) {
        criteria.add(Restrictions.eq("subjectStatus", limsVo.getLinkSubjectStudy().getSubjectStatus()));
        SubjectStatus subjectStatus = getSubjectStatus("Archive");
        if (subjectStatus != null) {
            criteria.add(Restrictions.ne("subjectStatus", subjectStatus));
        }
    } else {
        SubjectStatus subjectStatus = getSubjectStatus("Archive");
        if (subjectStatus != null) {
            criteria.add(Restrictions.ne("subjectStatus", subjectStatus));
        }
    }

    criteria.addOrder(Order.asc("subjectUID"));
    return criteria;
}

From source file:au.org.theark.phenotypic.model.dao.PhenotypicDao.java

License:Open Source License

protected Criteria buildGeneralPhenoDataSetCategoryCritera(PhenoDataSetCategory phenoDataSetCategory) {
    Criteria criteria = getSession().createCriteria(PhenoDataSetCategory.class);

    // Must be constrained on study and function
    criteria.add(Restrictions.eq("study", phenoDataSetCategory.getStudy()));

    criteria.add(Restrictions.eq("arkFunction", phenoDataSetCategory.getArkFunction()));

    if (phenoDataSetCategory.getId() != null) {
        criteria.add(Restrictions.eq("id", phenoDataSetCategory.getId()));
    }/*from ww  w  .ja va 2  s.co m*/

    if (phenoDataSetCategory.getName() != null) {
        criteria.add(Restrictions.ilike("name", phenoDataSetCategory.getName(), MatchMode.ANYWHERE));
    }
    if (phenoDataSetCategory.getDescription() != null) {
        criteria.add(
                Restrictions.ilike("description", phenoDataSetCategory.getDescription(), MatchMode.ANYWHERE));
    }
    /*if (phenoDataSetCategory.getParentCategory() != null) {
       criteria.add(Restrictions.eq("parentCategory", phenoDataSetCategory.getParentCategory()));
    }
    if (phenoDataSetCategory.getOrderNumber() != null) {
       criteria.add(Restrictions.eq("orderNumber", phenoDataSetCategory.getOrderNumber()));
    }*/
    return criteria;
}

From source file:au.org.theark.phenotypic.model.dao.PhenotypicDao.java

License:Open Source License

/**
 * Search method to the  fileds./*  w  w  w  .j a va 2  s .c o m*/
 * @param phenoDataSet
 * @return
 */
protected Criteria buildGeneralPhenoFieldCritera(PhenoDataSetField phenoDataSetField) {
    Criteria criteria = getSession().createCriteria(PhenoDataSetField.class);

    criteria.add(Restrictions.eq("study", phenoDataSetField.getStudy()));
    criteria.add(Restrictions.eq("arkFunction", phenoDataSetField.getArkFunction()));

    if (phenoDataSetField.getFieldType() != null) {
        criteria.add(Restrictions.eq("fieldType", phenoDataSetField.getFieldType()));
    }
    if (phenoDataSetField.getId() != null) {
        criteria.add(Restrictions.eq("id", phenoDataSetField.getId()));
    }
    if (phenoDataSetField.getName() != null) {
        criteria.add(Restrictions.ilike("name", phenoDataSetField.getName(), MatchMode.ANYWHERE));
    }
    if (phenoDataSetField.getDescription() != null) {
        criteria.add(Restrictions.ilike("description", phenoDataSetField.getDescription(), MatchMode.ANYWHERE));
    }
    if (phenoDataSetField.getUnitType() != null && phenoDataSetField.getUnitType().getName() != null
            && phenoDataSetField.getUnitTypeInText() != null) {
        criteria.createAlias("unitType", "ut");
        criteria.add(
                Restrictions.ilike("ut.name", phenoDataSetField.getUnitType().getName(), MatchMode.ANYWHERE));
    }
    if (phenoDataSetField.getUnitTypeInText() != null) {
        criteria.add(Restrictions.ilike("unitTypeInText", phenoDataSetField.getUnitTypeInText(),
                MatchMode.ANYWHERE));
    }
    if (phenoDataSetField.getMinValue() != null) {
        criteria.add(Restrictions.ilike("minValue", phenoDataSetField.getMinValue(), MatchMode.ANYWHERE));
    }
    if (phenoDataSetField.getMaxValue() != null) {
        criteria.add(Restrictions.ilike("maxValue", phenoDataSetField.getMaxValue(), MatchMode.ANYWHERE));
    }
    return criteria;
}

From source file:au.org.theark.phenotypic.model.dao.PhenotypicDao.java

License:Open Source License

private Criteria buildGenericPhenoDataSetFieldGroupCriteria(PhenoDataSetGroup phenoDataSetGroup) {

    Criteria criteria = getSession().createCriteria(PhenoDataSetGroup.class);

    criteria.add(Restrictions.eq("study", phenoDataSetGroup.getStudy()));
    criteria.add(Restrictions.eq("arkFunction", phenoDataSetGroup.getArkFunction()));

    if (phenoDataSetGroup.getName() != null) {
        criteria.add(Restrictions.ilike("name", phenoDataSetGroup.getName(), MatchMode.ANYWHERE));
    }// w  ww . j  a  va2  s .c o  m

    if (phenoDataSetGroup.getPublished() != null) {
        criteria.add(Restrictions.eq("published", phenoDataSetGroup.getPublished()));
    }
    return criteria;

}

From source file:au.org.theark.phenotypic.model.dao.PhenotypicDao.java

License:Open Source License

private Criteria buildGenericPhenoFieldGroupCriteria(PhenoDataSetGroup phenoDataSetGroup) {

    Criteria criteria = getSession().createCriteria(PhenoDataSetGroup.class);

    criteria.add(Restrictions.eq("study", phenoDataSetGroup.getStudy()));
    criteria.add(Restrictions.eq("arkFunction", phenoDataSetGroup.getArkFunction()));

    if (phenoDataSetGroup.getName() != null) {
        criteria.add(Restrictions.ilike("name", phenoDataSetGroup.getName(), MatchMode.ANYWHERE));
    }// ww  w  .ja  va  2s.c  o m

    if (phenoDataSetGroup.getPublished() != null) {
        criteria.add(Restrictions.eq("published", phenoDataSetGroup.getPublished()));
    }
    return criteria;

}