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.hypersocket.repository.AbstractRepositoryImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Transactional(readOnly = true)//from www .j a  v  a2  s  .c  o  m
protected <T> List<T> allEntities(Class<T> cls, DetachedCriteriaConfiguration... configs) {
    DetachedCriteria criteria = createDetachedCriteria(cls);

    criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    criteria.add(Restrictions.eq("deleted", false));
    for (DetachedCriteriaConfiguration c : configs) {
        c.configure(criteria);
    }
    return (List<T>) hibernateTemplate.findByCriteria(criteria);
}

From source file:com.hypersocket.repository.AbstractRepositoryImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Transactional(readOnly = true)/*w  ww  .j a va 2s  .c om*/
protected <T> List<T> allDeletedEntities(Class<T> cls, DetachedCriteriaConfiguration... configs) {
    DetachedCriteria criteria = createDetachedCriteria(cls);
    criteria.add(Restrictions.eq("deleted", true));
    for (DetachedCriteriaConfiguration c : configs) {
        c.configure(criteria);
    }
    return (List<T>) hibernateTemplate.findByCriteria(criteria);
}

From source file:com.hypersocket.repository.DeletedDetachedCriteria.java

License:Open Source License

@Override
public void configure(DetachedCriteria criteria) {
    criteria.add(Restrictions.eq("deleted", deleted));

}

From source file:com.hypersocket.repository.HiddenCriteria.java

License:Open Source License

@Override
public void configure(DetachedCriteria criteria) {
    criteria.add(Restrictions.eq("hidden", hidden));

}

From source file:com.hypersocket.resource.HiddenFilter.java

License:Open Source License

@Override
public void configure(DetachedCriteria criteria) {
    if (!showHidden) {
        criteria.add(Restrictions.eq("hidden", false));
    }/*from ww w .ja va2s.c o m*/

}

From source file:com.hypersocket.resource.ResourceRestriction.java

License:Open Source License

@Override
public void configure(DetachedCriteria criteria) {
    if (resource == null) {
        criteria.add(Restrictions.isNull(column));
    } else {//from   www  . j a  v a 2s. c  o m
        criteria.add(Restrictions.eq(column, resource.getId()));
    }
}

From source file:com.inkubator.hrm.dao.impl.EmpDataDaoImpl.java

@Override
public List<EmpData> getAllDataNotExistInUserByParam(String param, int firstResult, int maxResults,
        Order order) {/*from w ww .ja va 2  s .c o  m*/
    DetachedCriteria subQuery = DetachedCriteria.forClass(HrmUser.class, "user")
            .setProjection(Projections.property("user.id"));
    subQuery.add(Property.forName("employee.id").eqProperty("user.empData.id"));

    Criteria criteria = getCurrentSession().createCriteria(getEntityClass(), "employee");
    criteria.add(Subqueries.notExists(subQuery));
    criteria = this.doSearchNotExistInUserByParam(param, criteria);

    criteria.setFirstResult(firstResult);
    criteria.setMaxResults(maxResults);
    criteria.addOrder(order);

    return criteria.list();
}

From source file:com.inkubator.hrm.dao.impl.EmpDataDaoImpl.java

@Override
public Long getTotalNotExistInUserByParam(String param) {
    DetachedCriteria subQuery = DetachedCriteria.forClass(HrmUser.class, "user")
            .setProjection(Projections.property("user.id"));
    subQuery.add(Property.forName("employee.id").eqProperty("user.empData.id"));

    Criteria criteria = getCurrentSession().createCriteria(getEntityClass(), "employee");
    criteria.add(Subqueries.notExists(subQuery));
    criteria = this.doSearchNotExistInUserByParam(param, criteria);

    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

From source file:com.inkubator.hrm.dao.impl.LoanNewTypeDaoImpl.java

@Override
public List<LoanNewType> getAllDataPayrollComponent(Long modelComponentId) {
    ProjectionList subProjection = Projections.projectionList();
    subProjection.add(Projections.groupProperty("modelReffernsil"));

    DetachedCriteria subQuery = DetachedCriteria.forClass(PaySalaryComponent.class);
    subQuery.createAlias("modelComponent", "modelComponent", JoinType.INNER_JOIN);
    subQuery.add(Restrictions.eq("modelComponent.id", modelComponentId));
    subQuery.setProjection(subProjection);

    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Property.forName("id").notIn(subQuery));
    return criteria.list();
}

From source file:com.isdemu.dao.impl.TBC_ClaseActivoDaoImpl.java

@Override
public List getAllidClasi(Serializable id) {

    DetachedCriteria dc = DetachedCriteria.forClass(TbcClaseActivo.class, "clase");

    dc.createAlias("clase.tbcClasificacionActivo", "clasi");
    dc.add(Restrictions.eq("clasi.idClasificacionActivo", id));

    return dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();
}