Example usage for org.hibernate.criterion DetachedCriteria add

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria add.

Prototype

public DetachedCriteria add(Criterion criterion)

Source Link

Document

Add a restriction

Usage

From source file:com.cimmyt.model.dao.impl.ShipmentSetsDAOImpl.java

License:Apache License

@Override
protected void buildCriteria(DetachedCriteria criteria, ShipmentSet filter) {
    if (filter.getComments() != null) {
        criteria.add(Restrictions.like("comments", "%" + filter.getComments() + "%"));
    }/*from   w w w  .j  av a  2s  .  com*/
    if (filter.getStInvestigator() != null && filter.getStInvestigator().getInvest_name() != null
            && !filter.getStInvestigator().getInvest_name().isEmpty()) {
        criteria.createAlias("stInvestigator", "invest");
        criteria.add(Restrictions.like("invest.invest_name",
                "%" + filter.getStInvestigator().getInvest_name() + "%"));
    }
}

From source file:com.cimmyt.model.dao.impl.StatusDAOImpl.java

License:Apache License

/**
 * /*from  w w  w .j av a  2s .  c o  m*/
 * @param criteria
 * @param companyFilter
 */
protected void buildCriteria(DetachedCriteria criteria, Status statusFilter) {
    if (statusFilter.getIdStatus() != null) {
        criteria.add(Restrictions.eq("idStatus", statusFilter.getIdStatus()));
    }

    if (statusFilter.getStatusDescription() != null
            && statusFilter.getStatusDescription().trim().length() > 0) {
        criteria.add(Restrictions.like("name", "%" + statusFilter.getStatusDescription() + "%"));
    }
}

From source file:com.cimmyt.model.dao.impl.StorageLocationDAOImpl.java

License:Apache License

@Override
protected void buildCriteria(DetachedCriteria criteria, StorageLocation filter) {

    if (filter.getImslocid() != null) {
        criteria.add(Restrictions.eq("imslocidparent", filter.getImslocid()));
    } else if (filter.getImslocid() == null) {
        criteria.add(Restrictions.isNull("imslocidparent"));
    }/*from  w ww . ja  v a  2 s  .c  om*/

}

From source file:com.cimmyt.model.dao.impl.StudyTemplateDAOImpl.java

License:Apache License

@Override
protected void buildCriteria(DetachedCriteria criteria, StudyTemplate filter) {
    if (filter.getStudytemplateid() != null) {
        criteria.add(Restrictions.eq("studytemplateid", filter.getStudytemplateid()));
    }//from  w w w.j a  va 2 s  .  co m

    if (StrUtils.notEmpty(filter.getTemplatename())) {
        criteria.add(Restrictions.like("templatename", "%" + filter.getTemplatename() + "%"));
    }

}

From source file:com.cimmyt.model.dao.impl.TissueDAOImpl.java

License:Apache License

@Override
protected void buildCriteria(DetachedCriteria criteria, Tissue filter) {
    // TODO Auto-generated method stub
    if (filter.getIdtissue() != null) {
        criteria.add(Restrictions.eq("idtissue", filter.getIdtissue()));
    }//from w ww . ja  v  a  2 s.co  m

    if (filter.getTissueName() != null && !filter.getTissueName().isEmpty()) {
        criteria.add(Restrictions.like("tissuename", "%" + filter.getTissueName() + "%"));
    }
}

From source file:com.cimmyt.model.dao.impl.UserFunctionsDAOImpl.java

License:Apache License

@Override
protected void buildCriteria(DetachedCriteria criteria, UserFuntions filter) {
    if (filter.getStUserVersion() != null && filter.getStUserVersion().getIdUser() != null
            && filter.getStUserVersion().getIdUser().intValue() > 0) {
        criteria.add(Restrictions.eq("stUserVersion.idUser", filter.getStUserVersion().getIdUser()));
    }//from w w  w. j  a  va2 s .  c  om

}

From source file:com.codefupanda.persistor.util.HibernateUtil.java

License:Open Source License

/**
 * Convert the API specific criteria to Hibernate DerachedCriteria
 * //w w w  . java 2s.c  o  m
 * @param searchCriteria
 * @return
 */
public static DetachedCriteria convert(SearchCriteria searchCriteria) {
    DetachedCriteria hCriteria = DetachedCriteria.forClass(searchCriteria.getSearchClass());

    for (Criteria criteria : searchCriteria.getCriterias()) {
        hCriteria.add(convert(criteria));
    }
    return hCriteria;
}

From source file:com.digitnexus.autoid.dao.AssetAndVehicleDaoImpl.java

@Override
public void saveVehicle(Vehicle newVehicleRecord) {
    DetachedCriteria detVehicle = this.getDetachedCriteria(Vehicle.class);
    detVehicle.add(Restrictions.eq("typecode", newVehicleRecord.getTypecode()));
    detVehicle.addOrder(Order.asc("id"));
    // to fetch some basic information such as vin number , because the same type of vehicle have the same basic information
    List<Vehicle> vehicleList = this.findByCriteria(detVehicle, Vehicle.class, 0, 1);
    if (vehicleList != null && vehicleList.size() > 0) {
        Vehicle vehicle = vehicleList.get(0);
        newVehicleRecord.setAvailableInd(vehicle.getAvailableInd());
        newVehicleRecord.setClientID(vehicle.getClientID());
        newVehicleRecord.setLicenseNum(vehicle.getLicenseNum());
        newVehicleRecord.setRegistrationNum(vehicle.getRegistrationNum());
        newVehicleRecord.setDescription(vehicle.getDescription());
        newVehicleRecord.setRemark(vehicle.getRemark());
        newVehicleRecord.setVin(vehicle.getVin());
        this.save(newVehicleRecord);
    }//from   w  w  w.  j  a  v  a2  s  . c  o  m
}

From source file:com.digitnexus.autoid.dao.AssetAndVehicleDaoImpl.java

@Override
public List<Vehicle> getCurrentVehicle(long id) {
    DetachedCriteria detVehicle = this.getDetachedCriteria(Vehicle.class);
    if (id != 0) {
        detVehicle.add(Restrictions.ge("id", id));
    }/*w w  w  . j  a  va 2  s.  c om*/
    detVehicle.addOrder(Order.asc("id"));
    return this.findByCriteria(detVehicle, Vehicle.class);
}

From source file:com.emergya.persistenceGeo.dao.impl.AbstractGenericDaoHibernateImpl.java

License:Open Source License

/**
* Use this inside subclasses as a convenience method.
*//* w w w  .ja  v  a  2  s.  com*/
@SuppressWarnings("unchecked")
protected List<T> findByCriteria(Criterion... detachedCriterias) {
    DetachedCriteria crit = DetachedCriteria.forClass(persistentClass);
    for (Criterion c : detachedCriterias) {
        crit.add(c);
    }
    return getHibernateTemplate().findByCriteria(crit);
}