Package org.hibernate.criterion

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

743
744
745
746
747
748
749
750
751
752
753
  @SuppressWarnings("unchecked")
  @Override
  public List<TrancheMutuoSal> getTranchesMutuoSal(long mutuoId) {
    DetachedCriteria criteria = DetachedCriteria.forClass(TrancheMutuoSal.class);
    criteria.add(Restrictions.eq("numeroMutuo", mutuoId));
    criteria.addOrder(Order.asc("progressivoMovimento"));
    return getHibernateTemplate().findByCriteria(criteria);
  }

  /***************************** begin metodi per antiriciclaggio >> chiusura rapporti */
  public List<Mutuo> getMutuiEstinti(Date dataRiferimento, List<String> prodotti) {
View Full Code Here
879
880
881
882
883
884
885
886
887
888
889
  @SuppressWarnings("unchecked")
  @Override
  public List<GruppoDatiFinanziari> getTuttiDatiFinanziariConPam(long numeroMutuoUnivoco) {
    DetachedCriteria criteria = DetachedCriteria.forClass(GruppoDatiFinanziari.class);
    criteria.add(Restrictions.eq("mutuo.numeroMutuo", new Long(numeroMutuoUnivoco)));
    criteria.addOrder(Order.desc("dataFineValidita"));
    List<GruppoDatiFinanziari> listaDatiFin = getHibernateTemplate().findByCriteria(criteria);
    for (GruppoDatiFinanziari datiFin : listaDatiFin) {
      criteria = DetachedCriteria.forClass(PianoAmmortamento.class);
      criteria.add(Restrictions.eq("rataId.numeroPam", datiFin.getNumeroPam()));
      List<PianoAmmortamento> pam = getHibernateTemplate().findByCriteria(criteria);
View Full Code Here
2918
2919
2920
2921
2922
2923
2924
2925
2926
2927
2928
  public List<Mutuo> getMutuiByStato(int codiceStato){
    DetachedCriteria criteria = DetachedCriteria.forClass(Mutuo.class);
    criteria.add(Restrictions.eq("legalEntity", legalEntity));
    criteria.add(Restrictions.eq("organizationUnit", organizationUnit));
    criteria.add(Restrictions.eq("codiceStato", codiceStato));
    criteria.addOrder(Order.asc("numeroMutuoCustom"));
    List<Mutuo> list = (List<Mutuo>) getHibernateTemplate().findByCriteria(criteria);
    return list;
  }
 
  @SuppressWarnings("unchecked")
View Full Code Here
160
161
162
163
164
165
166
167
168
169
170
            if(showHistory) {
                // if showHistory: sort by item.id and then history.id
                if(sortDescending) {
                    if(space == null) {
                        DetachedCriteria parentSpace = parent.createCriteria("space");
                        parentSpace.addOrder(Order.desc("name"));                       
                    }                   
                    criteria.addOrder(Order.desc("parent.id"));
                    criteria.addOrder(Order.desc("id"));
                } else {
                    if(space == null) {
View Full Code Here
167
168
169
170
171
172
173
174
175
176
177
                    criteria.addOrder(Order.desc("parent.id"));
                    criteria.addOrder(Order.desc("id"));
                } else {
                    if(space == null) {
                        DetachedCriteria parentSpace = parent.createCriteria("space");
                        parentSpace.addOrder(Order.asc("name"));                       
                    }                  
                    criteria.addOrder(Order.asc("parent.id"));
                    criteria.addOrder(Order.asc("id"));               
                }
            } else {
View Full Code Here
176
177
178
179
180
181
182
183
184
185
186
                }
            } else {
                if (sortDescending) {
                    if(space == null) {
                        DetachedCriteria parentSpace = criteria.createCriteria("space");
                        parentSpace.addOrder(Order.desc("name"));
                    }
                    criteria.addOrder(Order.desc("id"));
                } else {
                    if(space == null) {
                        DetachedCriteria parentSpace = criteria.createCriteria("space");
View Full Code Here
182
183
184
185
186
187
188
189
190
191
192
                    }
                    criteria.addOrder(Order.desc("id"));
                } else {
                    if(space == null) {
                        DetachedCriteria parentSpace = criteria.createCriteria("space");
                        parentSpace.addOrder(Order.asc("name"));
                    }                   
                    criteria.addOrder(Order.asc("id"));
                }                
            }
        } else {       
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
            persist(menu);
        }

        DetachedCriteria query = DetachedCriteria.forClass(Menu.class);
        query.add(Property.forName("parentId").eq(1));
        query.addOrder(Order.asc("id"));
        List<Menu> firstLevelMenus = getHibernateTemplate().findByCriteria(query);
        Integer counter = 1;
        counter = rebuildBranch(firstLevelMenus, counter);
        //Get the ROOT
        List<Menu> menuFromId = getMenuWithThisPath("");
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
            if (isLeaf(menu)) {
                menu.setRgt(counter++);
            } else {
                DetachedCriteria query = DetachedCriteria.forClass(Menu.class);
                query.add(Property.forName("parentId").eq(menu.getId()));
                query.addOrder(Order.asc("id"));
                List<Menu> subMenu = getHibernateTemplate().findByCriteria(query);
                counter=rebuildBranch(subMenu, counter);
                menu.setRgt(counter++);

            }
View Full Code Here
453
454
455
456
457
458
459
460
461
462
463
                criteria.setProjection(Projections.id());//null).setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
                List ids = criteria.list();

                if (ids != null && !ids.isEmpty()) {
                    DetachedCriteria detachedCriteriaForData = DetachedCriteria.forClass(ProcessInstance.class, "data");
                    detachedCriteriaForData.addOrder(Order.desc("createDate"));
                    detachedCriteriaForData.add(Property.forName("id").in(ids));
                    detachedCriteriaForData.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
                   
                    Criteria criteria2 = detachedCriteriaForData.getExecutableCriteria(session);
                    criteria2.setFetchMode("definition",FetchMode.SELECT);
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.