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

public DetachedCriteria createAlias(String associationPath, String alias)

Source Link

Document

Creates an association path alias within this DetachedCriteria.

Usage

From source file:de.forsthaus.backend.dao.impl.OrderDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from   w  w w  . j  a  v a2  s .c o m*/
public List<Order> getOrdersByOffice(Office office) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Order.class);

    // Raussuchen bei welchen Auftraegen der zugehoerige Kunde bei der
    // angegebenen Filiale ist
    criteria.createAlias("customer", "cu");
    criteria.add(Restrictions.eq("cu.office", office));

    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:de.forsthaus.backend.dao.impl.SecGroupDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*  w  w w . j  ava2  s.c  o  m*/
public SecGroup getGroupByGroupRight(SecGroupright secGroupright) {
    DetachedCriteria criteria = DetachedCriteria.forClass(SecGroup.class);
    // Aliases are working only on properties
    criteria.createAlias("secGrouprights", "gr");
    criteria.add(Restrictions.eq("gr.id", Long.valueOf(secGroupright.getId())));

    return (SecGroup) DataAccessUtils.uniqueResult(getHibernateTemplate().findByCriteria(criteria));
}

From source file:de.forsthaus.backend.dao.impl.SecGroupDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//from   w  ww  .  j ava 2 s.  com
public SecGroup getGroupByRolegroup(SecRolegroup secRolegroup) {
    DetachedCriteria criteria = DetachedCriteria.forClass(SecGroup.class);
    // Aliases are working only on properties
    criteria.createAlias("secRolegroups", "rg");
    criteria.add(Restrictions.eq("rg.id", Long.valueOf(secRolegroup.getId())));

    return (SecGroup) DataAccessUtils.uniqueResult(getHibernateTemplate().findByCriteria(criteria));
}

From source file:de.forsthaus.backend.dao.impl.SecGroupDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//from w w w . ja v a 2s .  com
public List<SecGroup> getGroupsByUser(SecUser aUser) {
    DetachedCriteria criteria = DetachedCriteria.forClass(SecGroup.class);
    // Aliases are working only on properties
    criteria.createAlias("secRolegroups", "rg");
    criteria.createAlias("secRoles", "rol");
    criteria.add(Restrictions.eq("rg.rol.secUser", aUser));

    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:de.forsthaus.backend.dao.impl.SecGrouprightDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*w  w  w  .  j  a  v a2s .  c  o m*/
public List<SecRight> getRightsByGroup(SecGroup group) {

    DetachedCriteria criteria = DetachedCriteria.forClass(SecRight.class);
    // Aliases are working only on properties they build the JOINS
    criteria.createAlias("secGrouprights", "gr");
    criteria.add(Restrictions.eq("gr.secGroup", group));

    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:de.forsthaus.backend.dao.impl.SecGrouprightDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from w  w  w  . ja  va 2  s .com*/
public List<SecRight> getGroupRightsByGroup(SecGroup group) {

    DetachedCriteria criteria = DetachedCriteria.forClass(SecRight.class);
    // Aliases only for properties
    criteria.createAlias("secGrouprights", "gr");
    criteria.add(Restrictions.eq("gr.secGroup", group));

    return getHibernateTemplate().findByCriteria(criteria);

}

From source file:de.forsthaus.backend.dao.impl.SecRightDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//from  w ww  . j a v a  2  s  .  c  o  m
public List<SecRight> getRightsByGroupright(SecGroupright secGroupright) {

    final DetachedCriteria criteria = DetachedCriteria.forClass(SecRight.class);
    // Aliases only for properties
    criteria.createAlias("secGrouprights", "gr");
    criteria.add(Restrictions.eq("gr.id", Long.valueOf(secGroupright.getId())));

    return getHibernateTemplate().findByCriteria(criteria);

}

From source file:de.forsthaus.backend.dao.impl.SecRoleDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from w  w  w  . j a  va2  s.c om*/
public List<SecRole> getRolesByUser(SecUser aUser) {
    DetachedCriteria criteria = DetachedCriteria.forClass(SecRole.class);

    // Aliases are working only on properties
    criteria.createAlias("secUserroles", "rol");
    criteria.add(Restrictions.eq("rol.secUser", aUser));

    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:de.forsthaus.backend.dao.impl.SecRolegroupDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/* www.j  a v a2s.  co m*/
public List<SecGroup> getGroupsByRole(SecRole aRole) {

    DetachedCriteria criteria = DetachedCriteria.forClass(SecGroup.class);

    // Aliases are working only on properties
    criteria.createAlias("secRolegroups", "rg");
    criteria.add(Restrictions.eq("rg.secRole", aRole));

    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:de.iteratec.iteraplan.businesslogic.reports.query.node.AttributeLeafNode.java

License:Open Source License

/**
 * Creates the {@link DetachedCriteria} for the {@link Comparator#NO_ASSIGNMENT} comparator.
 * //from   w w  w  . j  a  v a  2  s  .co  m
 * @param criteria the criteria to add the restrictions for
 * @param criterion the additional criterion, can be {@code null}
 * @return the {@link DetachedCriteria} for the {@link Comparator#NO_ASSIGNMENT} comparator
 */
protected DetachedCriteria createNoAssignmentCriteria(DetachedCriteria criteria, Criterion criterion) {
    final DetachedCriteria numberAvs = DetachedCriteria.forClass(getAttributeValueClass(), "numberAV");
    numberAvs.createAlias("numberAV.attributeValueAssignments", "avas");
    numberAvs.add(Restrictions.eq("attributeType.id", Integer.valueOf(getAttributeId())));
    numberAvs.setProjection(Property.forName("avas.buildingBlock"));

    if (criterion != null) {
        numberAvs.add(criterion);
    }

    final String bbId = String.format("%s.%s", getResultTypeDBNameShortWithSuffix(), "id");
    criteria.add(Subqueries.propertyNotIn(bbId, numberAvs));

    return criteria;
}