Package org.hibernate.criterion

Examples of org.hibernate.criterion.Disjunction

234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
        List<AbstractFamixEntity> entities = new ArrayList<AbstractFamixEntity>();

        try {
            Criteria query = getHibernateSession().createCriteria(AbstractFamixEntity.class);
            query.createAlias("sourceAnchor", "sa");
            Disjunction orClausel = Restrictions.disjunction();

            int countOPs = 0;
            for (String reducedUniqueName : sourceReferences.keySet()) {
                if (reducedUniqueName != "") {
                    orClausel.add(Restrictions.and(
                            Restrictions.like("uniqueName", reducedUniqueName + "(%)"),
                            Restrictions.eq("sa.start", sourceReferences.get(reducedUniqueName))
                    )
                    );
View Full Code Here
1913
1914
1915
1916
1917
1918
1919
1920
1921
1922
1923
1924
1925
    conj.add(Restrictions.eq("pianoDeiConti.codiceGruppo", pianoDeiConti.getCodiceGruppo()));
    conj.add(Restrictions.eq("pianoDeiConti.codiceMastro", pianoDeiConti.getCodiceMastro()));
    conj.add(Restrictions.eq("pianoDeiConti.codiceConto", pianoDeiConti.getCodiceConto()));
    conj.add(Restrictions.le("dataInizioValidita", dataRegistrazione));

    Disjunction disj = Restrictions.disjunction();
    disj.add(Restrictions.isNull("dataFineValidita"));
    disj.add(Restrictions.ge("dataFineValidita", dataRegistrazione));
    conj.add(disj);

    criteria.add(conj);
    try {
      return (List<Conto>) getHibernateTemplate().findByCriteria(criteria);
View Full Code Here
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
    DetachedCriteria criteria = DetachedCriteria.forClass(VariazioneParametroFinanziario.class);
    criteria.add(Restrictions.eq("codiceParametroFinanziario", codiceParametroFinanziario));
    criteria.add(Restrictions.le("dataInizioValidita", allaData));
    criteria.add(Restrictions.eq("legalEntity", legalEntity).ignoreCase());
    criteria.add(Restrictions.eq("organizationUnit", organizationUnit).ignoreCase());
    Disjunction or = Restrictions.disjunction();
    or.add(Restrictions.isNull("dataFineValidita"));
    or.add(Restrictions.gt("dataFineValidita", allaData));
    criteria.add(or);
    List<VariazioneParametroFinanziario> result = getHibernateTemplate().findByCriteria(criteria);
    return result != null && result.size() > 0 ? result.get(0).getValoreParametroFinanziario() : null;
  }
View Full Code Here
1369
1370
1371
1372
1373
1374
1375
1376
1377
1378
1379
1380
1381
1382
    conj.add(Restrictions.eq("codiceTipoTasso", tipoTasso));
    conj.add(Restrictions.lt("importoMin", importoRiferimento));
    conj.add(Restrictions.ge("importoMax", importoRiferimento));
    conj.add(Restrictions.le("dataInizioValidita", dataRiferimento));

    Disjunction orDataFineValidita = Restrictions.disjunction();
    orDataFineValidita = Restrictions.disjunction();
    orDataFineValidita.add(Restrictions.ge("dataFineValidita", dataRiferimento));
    orDataFineValidita.add(Restrictions.isNull("dataFineValidita"));
    conj.add(orDataFineValidita);

    criteria.add(conj);

    return (List<TassiRiferimento>) getHibernateTemplate().findByCriteria(criteria);
View Full Code Here
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404
1405
1406
1407
1408
1409
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
1429
1430
1431
1432
  private DetachedCriteria getTabellaFinanziariaCriteria(List<SearchCriteriaLogicProduct> andCriteriaList) {
    DetachedCriteria criteria = DetachedCriteria.forClass(TestataTabellaFinanziaria.class);
    criteria.add(Restrictions.eq("legalEntity", legalEntity).ignoreCase());
    criteria.add(Restrictions.eq("organizationUnit", organizationUnit).ignoreCase());

    Disjunction ors = Restrictions.disjunction();

    for (SearchCriteriaLogicProduct sclp : andCriteriaList) {
      DetachedCriteria agenteCriteria = null;
     
      Conjunction andsTestata = Restrictions.conjunction();

      for (SearchCriteria sc : sclp.getSearchCriteriaList()) {
        Conjunction andsAgente = null;
       
        SimpleExpression simpleExpression = sc.getSimpleExpression();
        if (sc.getValore() instanceof String)
          simpleExpression.ignoreCase();
        if (((SearchCriteriaWithEntity) sc).getEntity() == AgenteTabellaFinanziaria.class) {
          // Aggiungo condizioni di and alla subquery della testata
          if (agenteCriteria == null) {
            agenteCriteria = DetachedCriteria.forClass(AgenteTabellaFinanziaria.class);
            agenteCriteria.setProjection(Projections.property("testataTabellaFinanziaria.numeroTabellaFinanziaria"));
          }
          if (andsAgente == null) {
            andsAgente = Restrictions.conjunction();
          }
          andsAgente.add(simpleExpression);

        } else if (((SearchCriteriaWithEntity) sc).getEntity() == TestataTabellaFinanziaria.class) {
          // Aggiungo condizioni di and su testata tabella finanziaria
          if(sc.getCampo().equals("dataFineValidita")){
            Disjunction orsDataFine = Restrictions.disjunction();
            orsDataFine.add(simpleExpression);
            orsDataFine.add(Restrictions.isNull("dataFineValidita"));
            andsTestata.add(orsDataFine);
          }else{
            andsTestata.add(simpleExpression);
          }
         
View Full Code Here
3795
3796
3797
3798
3799
3800
3801
3802
3803
3804
3805
3806
3807
3808
3809
3810
3811
3812
    DetachedCriteria criteria = DetachedCriteria.forClass(VariazioneParametroFinanziario.class);
    criteria.add(Restrictions.eq("codiceParametroFinanziario", codiceParametroFinanziario));
    criteria.add(Restrictions.eq("legalEntity", legalEntity).ignoreCase());
    criteria.add(Restrictions.eq("organizationUnit", organizationUnit).ignoreCase());
   
    Disjunction or = Restrictions.disjunction();
    or.add(Restrictions.between("dataInizioValidita", dallaData, allaData));
   
    Conjunction and = Restrictions.conjunction();
    and.add(Restrictions.le("dataInizioValidita", dallaData));
    Disjunction orDt = Restrictions.disjunction();
    orDt.add(Restrictions.isNull("dataFineValidita"));
    orDt.add(Restrictions.gt("dataFineValidita", allaData));
    and.add(orDt);
    or.add(and);
    and = Restrictions.conjunction();
    and.add(Restrictions.le("dataInizioValidita", dallaData));
    and.add(Restrictions.ge("dataFineValidita", dallaData));
View Full Code Here
352
353
354
355
356
357
358
359
360
361
362
363
364
365
      conj.add(Restrictions.eq("anniIntestatario", anni));
    }

    conj.add(Restrictions.le("durataMinimaContratto", durata));

    Disjunction orDett = Restrictions.disjunction();
    orDett = Restrictions.disjunction();
    orDett.add(Restrictions.isNull("durataMassimaContratto"));
    orDett.add(Restrictions.ge("durataMassimaContratto", durata));
    conj.add(orDett);

    criteria.add(conj);
    List<Assicurazione> result = getHibernateTemplate().findByCriteria(criteria);
    if (result != null && result.size() > 0)
View Full Code Here
381
382
383
384
385
386
387
388
389
390
391
392
393
394
    conj.add(Restrictions.eq("tipoAssicurazione", tipoAssicurazione));
    conj.add(Restrictions.in("sessoIntestatario", sessi));
    conj.add(Restrictions.eq("anniIntestatario", anni));
    conj.add(Restrictions.le("durataMinimaContratto", durata));

    Disjunction orDett = Restrictions.disjunction();
    orDett = Restrictions.disjunction();
    orDett.add(Restrictions.isNull("durataMassimaContratto"));
    orDett.add(Restrictions.ge("durataMassimaContratto", durata));
    conj.add(orDett);

    criteria.add(conj);
    List<Assicurazione> result = getHibernateTemplate().findByCriteria(criteria);
    if (result != null && result.size() > 0)
View Full Code Here
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
      Long numeroTabellaFinanziaria) {
    DetachedCriteria criteriaDettaglio = DetachedCriteria.forClass(DettaglioTabellaFinanziaria.class);
    DetachedCriteria criteriaTestata = DetachedCriteria.forClass(TestataTabellaFinanziaria.class);

    Conjunction andDett = Restrictions.conjunction();
    Disjunction orDett = Restrictions.disjunction();
    orDett.add(Restrictions.isNull("massimoDurataContr"));
    orDett.add(Restrictions.ge("massimoDurataContr", durata));
    andDett.add(orDett);
    andDett.add(Restrictions.le("minimoDurataContr", durata));

    Conjunction andTestata = Restrictions.conjunction();
    Disjunction orTestata = Restrictions.disjunction();
    orTestata.add(Restrictions.isNull("dataFineValidita"));
    orTestata.add(Restrictions.gt("dataFineValidita", dataRichiesta));
    andTestata.add(orTestata);
    andTestata.add(Restrictions.eq("numeroTabellaFinanziaria", numeroTabellaFinanziaria));
    andTestata.add(Restrictions.eq("legalEntity", legalEntity).ignoreCase());
    andTestata.add(Restrictions.eq("organizationUnit", organizationUnit).ignoreCase());
View Full Code Here
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
    criteria.add(Restrictions.eq("legalEntity", legalEntity).ignoreCase());
    criteria.add(Restrictions.eq("organizationUnit", organizationUnit).ignoreCase());

    // DetachedCriteria criteria =
    // DetachedCriteria.forClass(GruppoDatiFinanziari.class);
    Disjunction ors = Restrictions.disjunction();

    for (SearchCriteriaLogicProduct sclp : andCriteriaList) {

      DetachedCriteria datifinCriteria = null;
      // DetachedCriteria mutuoCriteria = null;
      // Conjunction andsDatifin = Restrictions.conjunction();
      // Conjunction andsMutuo = null;
      Conjunction andsDatifin = null;
      Conjunction andsMutuo = Restrictions.conjunction();

      for (SearchCriteria sc : sclp.getSearchCriteriaList()) {

        SimpleExpression simpleExpression = sc.getSimpleExpression();
        if (sc.getValore() instanceof String)
          simpleExpression.ignoreCase();
        if (((SearchCriteriaWithEntity) sc).getEntity() == GruppoDatiFinanziari.class) {
          // Aggiungo condizioni di and alla subquery dei mutui
          if (datifinCriteria == null) {
            datifinCriteria = DetachedCriteria.forClass(GruppoDatiFinanziari.class);
            datifinCriteria.setProjection(Projections.property("mutuo"));
          }
          if (andsDatifin == null) {
            andsDatifin = Restrictions.conjunction();
          }
          andsDatifin.add(simpleExpression);

        } else if (((SearchCriteriaWithEntity) sc).getEntity() == Mutuo.class) {
          // Aggiungo condizioni di and sui Datifin
          andsMutuo.add(simpleExpression);
        }

        if (andsDatifin != null) {
          andsDatifin.add(Restrictions.isNull("dataFineValidita"));
          datifinCriteria.add(andsDatifin);
          andsMutuo.add(Subqueries.propertyIn("numeroMutuo", datifinCriteria));
        }

        ors.add(andsMutuo);
      }

      criteria.add(ors);

    }
View Full Code Here
TOP

Related Classes of org.hibernate.criterion.Disjunction

  • aim.dao.security.impl.LogDAOImpl
  • br.com.flexait.core.AbstractDao
  • com.abiquo.server.core.cloud.VirtualApplianceDAO
  • com.abiquo.server.core.cloud.VirtualDatacenterDAO
  • com.abiquo.server.core.common.persistence.DefaultDAOBase
  • com.abiquo.server.core.enterprise.EnterpriseDAO
  • com.abiquo.server.core.enterprise.RoleDAO
  • com.abiquo.server.core.enterprise.RoleLdapDAO
  • com.abiquo.server.core.enterprise.UserDAO
  • com.abiquo.server.core.infrastructure.MachineDAO
    • Copyright © 2018 www.massapicom. 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.