Example usage for org.hibernate.criterion DetachedCriteria createAlias

Introduction

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

Prototype

@Deprecated
public DetachedCriteria createAlias(String associationPath, String alias, int joinType)

Source Link

Document

Deprecated!

Usage

From source file:com.ephesoft.dcma.da.dao.hibernate.PageTypeDaoImpl.java

License:Open Source License

/**
 * An API to fetch all Page types by document type name.
 * // www .j  av  a2 s. c o  m
 * @param docTypeName String
 * @return List<PageType>
 */
@Override
public List<PageType> getPageTypeByDocTypeName(String docTypeName) {
    DetachedCriteria criteria = criteria();
    criteria.createAlias(DOC_TYPE, DOC_TYPE, JoinFragment.INNER_JOIN);
    criteria.add(Restrictions.eq(DOC_TYPE_NAME, docTypeName));
    return find(criteria);
}

From source file:com.ephesoft.dcma.da.dao.hibernate.PageTypeDaoImpl.java

License:Open Source License

/**
 * An API to fetch all the page types for input document type ID.
 * //from w w w .ja va  2 s . c o m
 * @param documentTypeIdentifier String
 * @param startResult int
 * @param maxResult int
 * @return List<PageType>
 */
@Override
public List<PageType> getPageTypes(String documentTypeIdentifier, int startResult, int maxResult) {
    DetachedCriteria criteria = criteria();
    criteria.createAlias(DOC_TYPE, DOC_TYPE, JoinFragment.INNER_JOIN);
    criteria.add(Restrictions.eq(DOC_TYPE_IDENTIFIER, documentTypeIdentifier));
    return find(criteria, startResult, maxResult);
}

From source file:com.ephesoft.dcma.da.dao.hibernate.PluginDaoImpl.java

License:Open Source License

/**
 * API to get plugins.//from  w  w w  .j av  a2 s.c om
 * 
 * @param moduleId Long
 * @param startResult int
 * @param maxResult int
 * @return List<Plugin>
 */
@Override
public List<Plugin> getPlugins(Long moduleId, int startResult, int maxResult) {
    DetachedCriteria criteria = criteria(BatchClassPlugin.class);
    criteria.createAlias(BATCH_CLASS_MODULE, BATCH_CLASS_MODULE, JoinFragment.INNER_JOIN);
    criteria.createAlias(BATCH_CLASS_MODULE_MODULE, MODULE, JoinFragment.INNER_JOIN);
    criteria.add(Restrictions.eq(MODULE_ID, moduleId));
    criteria.setProjection(Projections.property(PLUGIN));
    return find(criteria, startResult, maxResult);
}

From source file:com.ephesoft.dcma.da.dao.hibernate.TableColumnsInfoDaoImpl.java

License:Open Source License

/**
 * An API to fetch all TableColumnsInfo by document type name and table name.
 * /*from   w ww  .  j a v  a 2  s .  co m*/
 * @param docTypeName String
 * @param tableName String
 * @return List<TableInfo>
 */
@Override
public List<TableColumnsInfo> getTableColumnsInfo(String docTypeName, String tableName) {

    LOGGER.info("docTypeName  : " + docTypeName);
    DetachedCriteria criteria = criteria();
    criteria.createAlias("tableInfo", "tableInfo", JoinFragment.INNER_JOIN);
    criteria.add(Restrictions.eq("tableInfo.name", tableName));
    criteria.createAlias("tableInfo.docType", "docType", JoinFragment.INNER_JOIN);
    criteria.add(Restrictions.eq("docType.name", docTypeName));

    return find(criteria);

}

From source file:com.ephesoft.dcma.da.dao.hibernate.TableInfoDaoImpl.java

License:Open Source License

/**
 * An API to fetch all TableInfo by document type name.
 * /* w w  w  . ja v a2 s .  c  om*/
 * @param docTypeName String
 * @param batchClassIdentifier String
 * @return List<TableInfo>
 */
@Override
public List<TableInfo> getTableInfoByDocTypeName(String docTypeName, String batchClassIdentifier) {

    LOGGER.info("Document type name : " + docTypeName);
    DetachedCriteria criteria = criteria();
    criteria.createAlias("docType", "docType", JoinFragment.INNER_JOIN);
    criteria.add(Restrictions.eq("docType.name", docTypeName));
    criteria.createAlias("docType.batchClass", "batchClass", JoinFragment.INNER_JOIN);
    criteria.add(Restrictions.eq("batchClass.identifier", batchClassIdentifier));

    return find(criteria);

}

From source file:com.ephesoft.dcma.da.dao.hibernate.TableRuleInfoDaoImpl.java

License:Open Source License

/**
 * API to fetch all TableRuleInfo by document type name and table name for a batch class.
 * //  www.  j  av a2 s .  c o m
 * @param batchClassIdentifer {@link String} batch class identifier
 * @param docTypeName {@link String} document type name
 * @param tableName {@link String} table name
 * @return List<TableRuleInfo> table rule info list
 */
@Override
public List<TableRuleInfo> getTableRulesInfo(final String batchClassIdentifer, final String docTypeName,
        final String tableName) {

    LOGGER.info("docTypeName  : " + docTypeName);
    DetachedCriteria criteria = criteria();
    criteria.createAlias("tableInfo", "tableInfo", JoinFragment.INNER_JOIN);
    criteria.add(Restrictions.eq("tableInfo.name", tableName));
    criteria.createAlias("tableInfo.docType", "docType", JoinFragment.INNER_JOIN);
    criteria.add(Restrictions.eq("docType.name", docTypeName));
    criteria.createAlias("docType.batchClass", "batchClass", JoinFragment.INNER_JOIN);
    criteria.add(Restrictions.eq("batchClass.identifier", batchClassIdentifer));
    return find(criteria);

}

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.sapienter.jbilling.server.metafields.db.MetaFieldDAS.java

License:Open Source License

public MetaField getFieldByNameTypeAndGroup(Integer entityId, EntityType[] entityType, String name,
        Integer groupId) {//  w w w.  ja  va  2s .c o  m
    DetachedCriteria query = DetachedCriteria.forClass(MetaField.class);
    query.add(Restrictions.eq("entityId", entityId));
    query.add(Restrictions.in("entityType", entityType));
    query.add(Restrictions.eq("name", name));
    query.createAlias("metaFieldGroups", "groups", CriteriaSpecification.LEFT_JOIN);
    query.add(Restrictions.eq("groups.id", groupId));
    query.add(Restrictions.eq("groups.entityType", EntityType.ACCOUNT_TYPE));
    query.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

    List<MetaField> fields = (List<MetaField>) getHibernateTemplate().findByCriteria(query);
    return !fields.isEmpty() ? fields.get(0) : null;
}

From source file:com.sapienter.jbilling.server.metafields.db.MetaFieldDAS.java

License:Open Source License

public MetaField getFieldByNameAndGroup(Integer entityId, String name, Integer groupId) {
    DetachedCriteria query = DetachedCriteria.forClass(MetaField.class);
    query.add(Restrictions.eq("entityId", entityId));
    query.add(Restrictions.eq("name", name));
    query.createAlias("metaFieldGroups", "groups", CriteriaSpecification.LEFT_JOIN);
    query.add(Restrictions.eq("groups.id", groupId));
    query.add(Restrictions.eq("groups.entityType", EntityType.ACCOUNT_TYPE));
    query.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

    List<MetaField> fields = (List<MetaField>) getHibernateTemplate().findByCriteria(query);
    return !fields.isEmpty() ? fields.get(0) : null;
}

From source file:com.sccl.attech.modules.sys.service.AreaService.java

License:Open Source License

/**
 * /*  w w w. ja  v  a  2s.  c o  m*/
 * @param page
 * @param area
 * @return
 */
public Page<Area> findArea(Page<Area> page, Area area) {
    DetachedCriteria dc = areaDao.createDetachedCriteria();

    if (StringUtils.isNotEmpty(area.getName())) {
        dc.add(Restrictions.like("name", "%" + area.getName() + "%"));
    }
    if (StringUtils.isNotEmpty(area.getType())) {
        dc.add(Restrictions.like("type", "%" + area.getType() + "%"));
    }
    dc.createAlias("officeList", "officeList", JoinType.LEFT_OUTER_JOIN);
    //dc.add(dataScopeFilter(UserUtils.getUser(), "officeList", "createBy"));
    dc.add(Restrictions.eq(Area.FIELD_DEL_FLAG, Area.DEL_FLAG_NORMAL));

    return areaDao.find(page, dc);
}