Example usage for org.hibernate.criterion Restrictions eq

Introduction

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

Prototype

public static SimpleExpression eq(String propertyName, Object value)

Source Link

Document

Apply an "equal" constraint to the named property

Usage

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

License:Open Source License

public InvRack getRackByNameForFreezer(InvFreezer invFreezer, String rackName) {
    Criteria criteria = getSession().createCriteria(InvRack.class);
    if (invFreezer != null) {
        criteria.add(Restrictions.eq("invFreezer", invFreezer));
    }/*  ww  w.j  a v  a  2s. c o m*/
    if (rackName != null && !rackName.isEmpty()) {
        criteria.add(Restrictions.eq("name", rackName));
    }
    return (InvRack) criteria.uniqueResult();
}

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

License:Open Source License

/**
 * /*from   w ww  .ja v a2s.c o  m*/
 */
public InvBox getBoxByNameForRack(InvRack invRack, String boxName) {
    Criteria criteria = getSession().createCriteria(InvBox.class);
    if (invRack != null) {
        criteria.add(Restrictions.eq("invRack", invRack));
    }
    if (boxName != null && !boxName.isEmpty()) {
        criteria.add(Restrictions.eq("name", boxName));
    }
    return (InvBox) criteria.uniqueResult();
}

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()));
        }//from   w w w  .jav a 2s .com

        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.lims.model.dao.LimsSubjectDao.java

License:Open Source License

public String getPreviousLastname(Person person) {
    Criteria criteria = getSession().createCriteria(PersonLastnameHistory.class);

    if (person.getId() != null) {
        criteria.add(Restrictions.eq(Constants.PERSON_SURNAME_HISTORY_PERSON, person));
    }// w w  w  .j a  v a2  s  .com
    criteria.addOrder(Order.desc("id"));
    PersonLastnameHistory personLastameHistory = null;
    List<PersonLastnameHistory> results = criteria.list();

    if (!results.isEmpty()) {
        personLastameHistory = (PersonLastnameHistory) results.get(1);
    }

    return personLastameHistory.getLastName();
}

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

License:Open Source License

public java.util.Collection<PhenoDataSetCollection> getPhenoCollectionByStudy(Study study) {
    Criteria criteria = getSession().createCriteria(PhenoDataSetCollection.class);

    if (study != null) {
        criteria.add(Restrictions.eq(au.org.theark.phenotypic.web.Constants.PHENO_COLLECTION_STUDY, study));
    }//from   w  ww.ja  va 2  s  .c o  m
    criteria.addOrder(Order.asc("name"));

    java.util.List<PhenoDataSetCollection> collectionList = criteria.list();
    return collectionList;
}

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

License:Open Source License

public long getCountOfCollectionsInStudy(Study study) {
    int count = 0;

    if (study.getId() != null) {
        Criteria criteria = getSession().createCriteria(PhenoDataSetCollection.class);
        criteria.add(Restrictions.eq("study", study));

        java.util.Collection<PhenoDataSetCollection> phenoCollection = criteria.list();
        count = phenoCollection.size();//from  ww w.j ava 2s  .  co m
    }

    return count;
}

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

License:Open Source License

public long getCountOfCollectionsWithDataInStudy(Study study) {
    long count = 0;

    if (study.getId() != null) {
        Collection<PhenoDataSetCollection> phenoCollectionColn = getPhenoCollectionByStudy(study);

        for (Iterator iterator = phenoCollectionColn.iterator(); iterator.hasNext();) {
            PhenoDataSetCollection phenoCollection = (PhenoDataSetCollection) iterator.next();

            Criteria criteria = getSession().createCriteria(PhenoDataSetData.class);
            criteria.add(Restrictions.eq("phenCollection", phenoCollection));
            ProjectionList projList = Projections.projectionList();
            projList.add(Projections.countDistinct("collection"));
            criteria.setProjection(projList);
            List list = criteria.list();
            count = count + ((Long) list.get(0));
        }/*from  w  w w  . j  a v a 2s  . c o m*/
    }

    return count;
}

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

License:Open Source License

public boolean phenoCollectionHasData(PhenoDataSetCollection phenoCollection) {
    Criteria criteria = getSession().createCriteria(PhenoDataSetData.class);

    if (phenoCollection != null) {
        criteria.add(Restrictions.eq("phenoCollection", phenoCollection));
    }//from w ww .  j a v a  2  s.  c o m

    return criteria.list().size() > 0;
}

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

License:Open Source License

public String getDelimiterTypeByDelimiterChar(char delimiterCharacter) {
    String delimiterTypeName = null;
    Criteria criteria = getSession().createCriteria(DelimiterType.class);
    criteria.add(Restrictions.eq("delimiterCharacter", delimiterCharacter));

    if (criteria.list().size() > 0) {
        DelimiterType delimiterType = (DelimiterType) criteria.list().get(0);
        delimiterTypeName = delimiterType.getName();
    }/*from   w w  w .  j  a va  2s.  co m*/
    return delimiterTypeName;
}

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

License:Open Source License

public FileFormat getFileFormatByName(String name) {
    FileFormat fileFormat = null;/* w  w  w. j a  v  a2 s .  c o  m*/
    Criteria criteria = getSession().createCriteria(FileFormat.class);
    criteria.add(Restrictions.eq("name", name));

    if (criteria.list().size() > 0) {
        fileFormat = (FileFormat) criteria.list().get(0);
    }
    return fileFormat;
}