Package org.hibernate.criterion

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

789
790
791
792
793
794
795
796
797
798
799
  @SuppressWarnings("unchecked")
  private List<Mutuo> getMutuiEstintiDf(Date dataRiferimento, List<Integer> codiciStatoPerOrDf, List<String> prodotti) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Mutuo.class);
    applicaCriteriComuniMutuiEstintiEsOrDf(criteria, prodotti, codiciStatoPerOrDf);
    criteria.createCriteria("gruppoDatiFinanziari").add(Restrictions.isNull("dataFineValidita"))
        .add(Restrictions.le("dataScadenzaUltimaRata", dataRiferimento));
    List<Mutuo> list = (List<Mutuo>) getHibernateTemplate().findByCriteria(criteria);
    for (Mutuo mutuo : list) {
      getHibernateTemplate().initialize(mutuo.getGruppoDatiFinanziari());
    }
View Full Code Here
202
203
204
205
206
207
208
209
210
211
212
    public DetachedCriteria getCriteriaForCount() {              
        DetachedCriteria criteria = null;       
        if (showHistory) {
            criteria = DetachedCriteria.forClass(History.class);          
            // apply restrictions to parent, this is an inner join =============
            parent = criteria.createCriteria("parent");
            if(space == null) {
                parent.add(Restrictions.in("space", getSelectedSpaces()));
            } else {
                parent.add(Restrictions.eq("space", space));
            }
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
                new String[] {AccessLevel.READ.name(), AccessLevel.WRITE.name(), AccessLevel.GRANT.name()}));
        if (!authorizer.isAuthorized(user, Function.BYPASS_PASSWORD_PERMISSIONS.name()))
        {
            DetachedCriteria groupQuery = DetachedCriteria.forClass(Group.class);
            groupQuery.setProjection(Projections.id());
            groupQuery.createCriteria("users", "u").add(Restrictions.eq("u.id", user.getId()));
            crit.add(Restrictions.or(Restrictions.eq("pm.subject", user), Subqueries.propertyIn("pm.subject", groupQuery)));
        }
        crit.addOrder(Order.asc("name"));
        crit.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
        return crit.list();
View Full Code Here
228
229
230
231
232
233
234
235
236
237
238
   
    DetachedCriteria subselect = DetachedCriteria.forClass(Course.class);
    subselect.add(Restrictions.like("description","test",MatchMode.START)).setProjection(Projections.property("courseCode"));

    DetachedCriteria mainselect = DetachedCriteria.forClass(Enrolment.class);
    mainselect.createCriteria("student").add(Subqueries.in("preferredCourse",subselect));

   
    Session session = openSession();
    Transaction t = session.beginTransaction();
   
View Full Code Here
493
494
495
496
497
498
499
500
501
502
503
            if (filter.getCreators() != null && !filter.getCreators().isEmpty()) {
                criteria = criteria.add(Restrictions.in("creator", filter.getCreators()));
            }

            if (filter.getUpdatedAfter() != null) {
                criteria = criteria
                        .createCriteria("processLogs")
                        .add(Restrictions.gt("entryDate", filter.getUpdatedAfterCalendar()));
            }

            if (filter.getNotUpdatedAfter() != null) {
View Full Code Here
143
144
145
146
147
148
149
150
151
152
153
      DetachedCriteria q = DetachedCriteria.forClass(Element.class, "pve_"+key).
        add(Restrictions.eqProperty("pve_"+key+".id", "e.id")).
        setProjection(org.hibernate.criterion.Property.forName("pve_"+key+".id"));

      DetachedCriteria propCriteria = q.createCriteria("properties");
      propCriteria.createCriteria("type").add(Restrictions.eq("name", key));
      DetachedCriteria pvlCriteria = propCriteria.createCriteria("valuelist").
          add(Restrictions.eq("nextRevision",Modification.MaxRevision)).
          createAlias("values", "v").
          add(Restrictions.like("v.svalue", value).ignoreCase());  
      crit.add(Subqueries.exists(q));
View Full Code Here
158
159
160
161
162
163
164
165
166
167
168
            .add(Restrictions.eqProperty("pve_" + key + ".id", "e.id"))
            .setProjection(
                org.hibernate.criterion.Property.forName("pve_" + key + ".id"));

        DetachedCriteria propCriteria = q.createCriteria("properties");
        propCriteria.createCriteria("type").add(Restrictions.eq("name", key));
        DetachedCriteria pvlCriteria = propCriteria.createCriteria("valuelist")
            .add(Restrictions.eq("nextRevision", Modification.MaxRevision))
            .createAlias("values", "v")
            .add(Restrictions.like("v.svalue", value).ignoreCase());
        crit.add(Subqueries.exists(q));
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
    private DetachedCriteria getIncludedContractsIdsCriteria(
            Collection<User> includedParticipants) {
        DetachedCriteria contractsIncludedCriteria = DetachedCriteria.forClass(Contract.class);
        DetachedCriteria resourcesCriteria = contractsIncludedCriteria.
            createCriteria(Contract.FIELD_RESOURCES);
        resourcesCriteria.createCriteria(Resource.FIELD_SUPPLIES, "_supplies", Criteria.LEFT_JOIN);
        resourcesCriteria.createCriteria(Resource.FIELD_NEEDS, "_needs", Criteria.LEFT_JOIN);
        contractsIncludedCriteria.add(Restrictions.or(
                Restrictions.in(
                "_supplies." + ResourceTender.FIELD_USER, includedParticipants),
                Restrictions.in(
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
            Collection<User> includedParticipants) {
        DetachedCriteria contractsIncludedCriteria = DetachedCriteria.forClass(Contract.class);
        DetachedCriteria resourcesCriteria = contractsIncludedCriteria.
            createCriteria(Contract.FIELD_RESOURCES);
        resourcesCriteria.createCriteria(Resource.FIELD_SUPPLIES, "_supplies", Criteria.LEFT_JOIN);
        resourcesCriteria.createCriteria(Resource.FIELD_NEEDS, "_needs", Criteria.LEFT_JOIN);
        contractsIncludedCriteria.add(Restrictions.or(
                Restrictions.in(
                "_supplies." + ResourceTender.FIELD_USER, includedParticipants),
                Restrictions.in(
                        "_needs." + ResourceTender.FIELD_USER, includedParticipants))
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
                    invitationsCriteria.setProjection(Projections.distinct(
                            Projections.property(Invitation.FIELD_CONTRACT + "." + Contract.FIELD_ID())));
                   
                    //Effective users criteria
                    DetachedCriteria effectiveCriteria = DetachedCriteria.forClass(Contract.class);
                    effectiveCriteria.createCriteria(Contract.FIELD_EFFECTIVE_USERS).add(
                            Restrictions.eq(User.FIELD_ID(), viewer.getId()));//TODO?
                    effectiveCriteria.setProjection(Projections.distinct(
                            Projections.property(Contract.FIELD_ID())));
                   
                    //Main 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.