Examples of Disjunction

Examples of org.hibernate.criterion.Disjunction

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

Examples of org.hibernate.criterion.Disjunction

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

Examples of org.hibernate.criterion.Disjunction

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

Examples of org.hibernate.criterion.Disjunction

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

Examples of org.hibernate.criterion.Disjunction

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

Examples of org.hibernate.criterion.Disjunction

858
859
860
861
862
863
864
865
866
867
868
869
870
    DetachedCriteria criteria = DetachedCriteria.forClass(GruppoDatiFinanziari.class);
    criteria.add(Restrictions.eq("mutuo.numeroMutuo", new Long(numeroMutuoUnivoco)));
    criteria.add(Restrictions.le("dataInizioValidita", allaData));

    Disjunction orTestata = Restrictions.disjunction();
    orTestata.add(Restrictions.isNull("dataFineValidita"));
    orTestata.add(Restrictions.ge("dataFineValidita", allaData));

    criteria.add(orTestata);

    List<GruppoDatiFinanziari> result = getHibernateTemplate().findByCriteria(criteria);
View Full Code Here

Examples of org.hibernate.criterion.Disjunction

925
926
927
928
929
930
931
932
933
934
935
936
937
    DetachedCriteria criteria = DetachedCriteria.forClass(Penale.class);

    Conjunction and = Restrictions.conjunction();
    and.add(Restrictions.eq("mutuo.numeroMutuo", numeroMutuo));
    and.add(Restrictions.le("dataInizioValidita", dataMassima));
    Disjunction or = Restrictions.disjunction();
    or.add(Restrictions.isNull("dataFineValidita"));
    or.add(Restrictions.ge("dataFineValidita", dataMassima));
    and.add(or);
    criteria.add(and);
    List<Penale> result = new ArrayList<Penale>();
    result = (List<Penale>) getHibernateTemplate().findByCriteria(criteria);
    if (result != null && result.size() > 0) {
View Full Code Here

Examples of org.hibernate.criterion.Disjunction

964
965
966
967
968
969
970
971
972
973
974
975
976
  public List<Long> getPraticheLegateA(long numeroSoggetto) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Legame.class);
    Conjunction and = Restrictions.conjunction();
    and.add(Restrictions.eq("numeroSoggetto", numeroSoggetto));

    Disjunction or = Restrictions.disjunction();
    or.add(Restrictions.eq("codiceRapporto", CodiceRapporto.CODICE_RAPPORTO_MUTUATARIO.getValue()));
    or.add(Restrictions.eq("codiceRapporto", CodiceRapporto.CODICE_RAPPORTO_GARANTE.getValue()));
    and.add(or);

    criteria.add(and);

    List<Legame> listaMutui = getHibernateTemplate().findByCriteria(criteria);
View Full Code Here

Examples of org.hibernate.criterion.Disjunction

1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
  public ModalitaRimborso getModalitaRimborso(String codiceModalitaRimborso, String codiceProdotto,
      long codiceSegnalatore) {
    DetachedCriteria criteria = DetachedCriteria.forClass(ModalitaRimborso.class);
    criteria.add(Restrictions.eq("codiceModalitaRimborso", codiceModalitaRimborso));
    criteria.add(Restrictions.eq("codiceProdotto", codiceProdotto));
    Disjunction or = Restrictions.disjunction();
    Conjunction andSegnalatore = Restrictions.conjunction();
    andSegnalatore.add(Restrictions.eq("flagTabellaStandard", "S"));
    andSegnalatore.add(Restrictions.eq("codiceSegnalatore", codiceSegnalatore));
    or.add(andSegnalatore);
    Conjunction andSegnalatoreN = Restrictions.conjunction();
    andSegnalatoreN.add(Restrictions.eq("flagTabellaStandard", "N"));
    andSegnalatoreN.add(Restrictions.eq("codiceSegnalatore", new Long(0)));
    or.add(andSegnalatoreN);
    criteria.add(or);
    criteria.add(Restrictions.eq("legalEntity", legalEntity).ignoreCase());
    criteria.add(Restrictions.eq("organizationUnit", organizationUnit).ignoreCase());
    List<ModalitaRimborso> result = getHibernateTemplate().findByCriteria(criteria);
    return (result != null && result.size() > 0 ? result.get(0) : null);
View Full Code Here

Examples of org.hibernate.criterion.Disjunction

1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
  @Override
  public List<ModalitaRimborso> getModalitaRimborsoByProdottoCategoriaSegnalatore(
      String codiceProdotto, String codiceCategoria, long codiceSegnalatore) {
    DetachedCriteria criteria = DetachedCriteria.forClass(ModalitaRimborso.class);
   
    Disjunction orSegn = Restrictions.disjunction();
    orSegn.add(Restrictions.eq("codiceSegnalatore", 0l));
    orSegn.add(Restrictions.eq("codiceSegnalatore", codiceSegnalatore));
    criteria.add(orSegn);

    criteria.add(Restrictions.eq("codiceProdotto", codiceProdotto));

    Disjunction orCateg = Restrictions.disjunction();
    orCateg.add(Restrictions.isNull("codiceCategoria"));
    orCateg.add(Restrictions.eq("codiceCategoria", codiceCategoria));
    criteria.add(orCateg);

    criteria.add(Restrictions.eq("legalEntity", legalEntity).ignoreCase());
    criteria.add(Restrictions.eq("organizationUnit", organizationUnit).ignoreCase());
    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.