Package org.hibernate.criterion

Examples of org.hibernate.criterion.DetachedCriteria.createAlias()

504
505
506
507
508
509
510
511
512
513
514
                    String innerClass = field.split("\\.")[0].trim();
                    String innerAttribute = field.split("\\.")[1].trim();
                    log.debug("Adicionando resultado da consulta por ordem do campo "+innerClass+"."+innerAttribute+" COM criação de alias");
                    if (sortOrder) {
                        log.debug("Ordenação adicionada: " + sortField + " ASC");
                        criteria.createAlias(innerClass, innerClass).addOrder(Order.asc(innerClass+"."+innerAttribute));
                    } else {
                        log.debug("Ordenação adicionada: " + sortField + " DESC");
                        criteria.createAlias(innerClass, innerClass).addOrder(Order.desc(innerClass+"."+innerAttribute));
                    }
                }
View Full Code Here
507
508
509
510
511
512
513
514
515
516
517
                    if (sortOrder) {
                        log.debug("Ordenação adicionada: " + sortField + " ASC");
                        criteria.createAlias(innerClass, innerClass).addOrder(Order.asc(innerClass+"."+innerAttribute));
                    } else {
                        log.debug("Ordenação adicionada: " + sortField + " DESC");
                        criteria.createAlias(innerClass, innerClass).addOrder(Order.desc(innerClass+"."+innerAttribute));
                    }
                }

            }
View Full Code Here
392
393
394
395
396
397
398
399
400
401
402
        return productSkus;
    }

    public List<ProductSku> findProductSkusNotInThisMasterCatalogCategoryId(final Long categoryId, Object... params) {
        DetachedCriteria subquery = DetachedCriteria.forClass(ProductSku.class);
        subquery.createAlias("catalogCategoryMasterProductSkuRels", "catalogCategoryProductSkuRel", JoinType.LEFT_OUTER_JOIN);
        subquery.add(Restrictions.eq("catalogCategoryProductSkuRel.pk.catalogCategoryMaster.id", categoryId));
        subquery.setProjection(Projections.property("id"));

        Criteria criteria = createDefaultCriteria(ProductSku.class);
        handleSpecificProductMarketingFetchMode(criteria, params);
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
  @Override
  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);
  }
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
  @Override
  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);
  }
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
  @Override
  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);

  }
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
  @SuppressWarnings("unchecked")
  @Override
  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));
  }
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
  @SuppressWarnings("unchecked")
  @Override
  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));
  }
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
  @SuppressWarnings("unchecked")
  @Override
  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);
  }
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
  @Override
  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);
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.