Package it.pdor.commonLayer.hibernate.searchutils

Examples of it.pdor.commonLayer.hibernate.searchutils.SearchCriteria

2855
2856
2857
2858
2859
2860
2861
2862
2863
2864
2865
2866
2867
2868
2869
2870
2871
2872
2873
2874
    query.append("and   CG01_ORG_UNIT = :ORG_UNIT ");
    query.append("group by CG01_NR_ARTICOLO ");

    List<SearchCriteria> criteria = new ArrayList<SearchCriteria>();

    SearchCriteria sc = new SearchCriteria("NR_ARTICOLO_CUSTOM", SearchOperators.equal);
    sc.setValore(numeroCustom);
    criteria.add(sc);

    sc = new SearchCriteria("LEGAL_ENTITY", SearchOperators.equal);
    sc.setValore(legalEntity);
    criteria.add(sc);

    sc = new SearchCriteria("ORG_UNIT", SearchOperators.equal);
    sc.setValore(organizationUnit);
    criteria.add(sc);

    try {
      List<?> list = this.getHibernateTemplate().executeFind(
          new ContabilitaHibernateBindCallback(query.toString(), criteria));
View Full Code Here
3130
3131
3132
3133
3134
3135
3136
3137
3138
3139
3140
3141
3142
3143
3144
3145
3146
3147
3148
    _log.debug("tipoMovimento:" + param.getTpMovimento().toUpperCase());
    _log.debug("flagModifica:" + param.getFlgModifica().toUpperCase());
    _log.debug("dataDal:" + param.getDallaData());
    _log.debug("dataAl:" + param.getAllaData());

    criteria.add(new SearchCriteria("tipoMovimento", param.getTpMovimento().toUpperCase()));
    criteria.add(new SearchCriteria("flagModifica", param.getFlgModifica().toUpperCase()));
    criteria.add(new SearchCriteria("dataDal", param.getDallaData()));
    criteria.add(new SearchCriteria("dataAl", param.getAllaData()));
    for (int i = 1; i <= users.size(); i++) {
      String nomeCampo = "user" + i;
      String valoreCampo = users.get(i - 1).toUpperCase();
      _log.debug(nomeCampo + ":" + valoreCampo);
      criteria.add(new SearchCriteria(nomeCampo, valoreCampo));
    }
    // criteria.add(new SearchCriteria("flagUser", param.getFlgUser()));

    HashMap<String, Type> mappingCampi = new HashMap<String, Type>();
    // mappingCampi.put("numerArticolo", Hibernate.LONG);
View Full Code Here
3254
3255
3256
3257
3258
3259
3260
3261
3262
3263
3264
3265
3266
3267
3268
3269
3270
3271
3272
3273
3274
3275
3276
3277
3278
3279
3280
3281
3282
3283
3284
3285
3286
3287
      query.append(" PARTITE.CG08_PGR_PARTITA ASC, ");
      query.append(" PARTITE.CG08_PGR_RIGA_PARTITA ASC ");

      List<SearchCriteria> criteria = new ArrayList<SearchCriteria>();

      SearchCriteria criteriatipoConto = new SearchCriteria("tipoConto", SearchOperators.equal);
      criteriatipoConto.setValore(input.getTipoConto());
      criteria.add(criteriatipoConto);

      if (input.getContoDa() != null) {
        SearchCriteria criteriaContoDa = new SearchCriteria("contoDa", SearchOperators.equal);
        criteriaContoDa.setValore(input.getContoDa());
        criteria.add(criteriaContoDa);

        SearchCriteria criteriaContoA = new SearchCriteria("contoA", SearchOperators.equal);
        criteriaContoA.setValore(input.getContoA());
        criteria.add(criteriaContoA);
      }

      SearchCriteria criteriaDataRiferimento = new SearchCriteria("dataRiferimento", SearchOperators.equal);
      criteriaDataRiferimento.setValore(input.getDataRiferimento());
      criteria.add(criteriaDataRiferimento);

      SearchCriteria criteriaLegalEntity = new SearchCriteria("legalEntity", SearchOperators.equal);
      criteriaLegalEntity.setValore(legalEntity);
      criteria.add(criteriaLegalEntity);

      SearchCriteria criteriaOrgUnit = new SearchCriteria("orgUnit", SearchOperators.equal);
      criteriaOrgUnit.setValore(organizationUnit);
      criteria.add(criteriaOrgUnit);

      List<?> list = null;

      try {
View Full Code Here
3450
3451
3452
3453
3454
3455
3456
3457
3458
3459
3460
3461
3462
3463
3464
3465
    query.append("    MOVCONT.CG01_NR_ARTICOLO ASC,");
    query.append("    MOVCONT.CG01_PGR_RIGA_ART ASC");

    List<SearchCriteria> criteria = new ArrayList<SearchCriteria>();

    criteria.add(new SearchCriteria("tipoMovimento", param.getTpMovimento()));
    criteria.add(new SearchCriteria("flagModifica", param.getFlgModifica()));
    criteria.add(new SearchCriteria("dataDal", param.getDallaData()));
    criteria.add(new SearchCriteria("dataAl", param.getAllaData()));
    criteria.add(new SearchCriteria("user", param.getUser()));
    criteria.add(new SearchCriteria("flagUser", param.getFlgUser()));

    List<RigaStampaPrimaNotaIvaOut> list;

    HashMap<String, Type> mappingCampi = new HashMap<String, Type>();
    mappingCampi.put("numerArticolo", Hibernate.LONG);
View Full Code Here
3633
3634
3635
3636
3637
3638
3639
3640
3641
3642
3643
3644
3645
3646
3647
3648
3649
    query.append("      ( P1.CG08_FLG_CALC_MORA = 'S' ) ) ) ");
    query.append(" order by  cg08_tp_pam ASC, cg08_nr_pam ASC, cg08_pgr_rata ASC, descrizione DESC, datarif ASC ");
    query.append(" ) ");

    List<SearchCriteria> criteria = new ArrayList<SearchCriteria>();
    criteria.add(new SearchCriteria("conto", conto));
    criteria.add(new SearchCriteria("tipoConto", tipoConto));
    criteria.add(new SearchCriteria("dataCalcolo", dataCalcolo));
    criteria.add(new SearchCriteria("codPartitaMora", codPartitaMora));
    criteria.add(new SearchCriteria("tipoPam", tipoPam));
    criteria.add(new SearchCriteria("numeroPam", numeroPam));
    criteria.add(new SearchCriteria("progressivoRata", progressivoRata));

    HashMap<String, Type> mappingCampi = new HashMap<String, Type>();
    mappingCampi.put("dataRiferimento", Hibernate.DATE);
    mappingCampi.put("descrizione", Hibernate.STRING);
    mappingCampi.put("importo", Hibernate.DOUBLE);
View Full Code Here
3710
3711
3712
3713
3714
3715
3716
3717
3718
3719
3720
3721
3722
3723
    query.append("         ( SUM( NVL(  MOVIVA.CG06_IMPONIBILE , 0 ) ) +");
    query.append("           SUM( NVL(  MOVIVA.CG06_IMPOSTA , 0 ) ) )");

    List<SearchCriteria> criteria = new ArrayList<SearchCriteria>();

    criteria.add(new SearchCriteria("dataAl", dataRegistrazioneAl));
    criteria.add(new SearchCriteria("dataDal", dataRegistrazioneDal));
    criteria.add(new SearchCriteria("legalEntity", legalEntity));
    criteria.add(new SearchCriteria("organizationUnit", organizationUnit));

    HashMap<String, Type> mappingCampi = new HashMap<String, Type>();
    mappingCampi.put("numArticolo", Hibernate.LONG);
    mappingCampi.put("progressivoRigaArticolo", Hibernate.LONG);
    mappingCampi.put("dataRegistrazione", Hibernate.DATE);
View Full Code Here
3775
3776
3777
3778
3779
3780
3781
3782
3783
3784
3785
3786
3787
3788
    query.append("          MOVCONT.CG01_DT_PROTOCOLLO ASC, ");
    query.append("          MOVCONT.CG01_NR_PROTOCOLLO ASC ");

    List<SearchCriteria> criteria = new ArrayList<SearchCriteria>();

    criteria.add(new SearchCriteria("dataAl", dataRegistrazioneAl));
    criteria.add(new SearchCriteria("dataDal", dataRegistrazioneDal));
    criteria.add(new SearchCriteria("legalEntity", legalEntity));
    criteria.add(new SearchCriteria("organizationUnit", organizationUnit));

    HashMap<String, Type> mappingCampi = new HashMap<String, Type>();

    mappingCampi.put("numeroArticolo", Hibernate.LONG);
    mappingCampi.put("progressivoRigaArticolo", Hibernate.LONG);
View Full Code Here
3910
3911
3912
3913
3914
3915
3916
3917
3918
3919
3920
3921
3922
    query.append(" ( MOVCONT.CG01_DT_REG <= :dataDal ) AND ");
    query.append(" ( MOVCONT.CG01_TP_MOVIMENTO NOT IN ('E','X') ) ");

    List<SearchCriteria> criteria = new ArrayList<SearchCriteria>();

    criteria.add(new SearchCriteria("flagPartitario", flagPartitario));
    criteria.add(new SearchCriteria("conto", conto));
    criteria.add(new SearchCriteria("dataDal", dataRiferimento));

    List<?> list;

    try {
      list = this.getHibernateTemplate().executeFind(
View Full Code Here
4057
4058
4059
4060
4061
4062
4063
4064
4065
4066
4067
4068
4069
    query.append(" ( MOVCONT.CG01_DT_REG <= :dataDal ) AND ");
    query.append(" ( MOVCONT.CG01_TP_MOVIMENTO NOT IN ('E','X') ) ");

    List<SearchCriteria> criteria = new ArrayList<SearchCriteria>();

    criteria.add(new SearchCriteria("flagPartitario", flagPartitario));
    criteria.add(new SearchCriteria("conto", conto));
    criteria.add(new SearchCriteria("dataDal", dataRiferimento));

    List<?> list;

    try {
      list = this.getHibernateTemplate().executeFind(
View Full Code Here
4452
4453
4454
4455
4456
4457
4458
4459
4460
4461
4462
4463
4464
4465
4466
4467
4468
4469
    mappingCampi.put("dataRegistrazione", Hibernate.DATE);
    mappingCampi.put("numeroArticolo", Hibernate.LONG);

    List<SearchCriteria> criteria = new ArrayList<SearchCriteria>();

    criteria.add(new SearchCriteria("codiceSocietaVeicolo", codiceSocietaVeicolo));
    criteria.add(new SearchCriteria("dataMinima", dataMinima));
    criteria.add(new SearchCriteria("dataMassima", dataMassima));
    criteria.add(new SearchCriteria("tipoBollato", tipoBollato));
    criteria.add(new SearchCriteria("tipoAttivita", codiceAttivita));
    criteria.add(new SearchCriteria("flagAttivita", flagAttivita));
    criteria.add(new SearchCriteria("legalEntity", legalEntity));
    criteria.add(new SearchCriteria("organizationUnit", organizationUnit));

    List<LibroIVA> list = null;
    try {
      list = this.getHibernateTemplate().executeFind(
          new ContabilitaHibernateCallbackWithMapping(q.toString(), criteria, mappingCampi, LibroIVA.class));
View Full Code Here
TOP

Related Classes of it.pdor.commonLayer.hibernate.searchutils.SearchCriteria

  • it.pdor.contabilita.dao.ContabilitaDaoHibernateImpl
  • it.pdor.contabilita.dao.ContabilitaDaoHibernateImplTransactionalTest
  • it.pdor.contabilita.dao.ContabilitaOracleDependDaoHibernateImpl
  • it.pdor.contabilita.service.ContabilitaServiceImplTest
  • it.pdor.webapp.contabilita.operazioniGiornaliere.partitario.RicercaContoPartitarioAction
  • it.pdor.webapp.contabilita.popupRicercaConto.RicercaContoBackingBean
  • it.pdor.webapp.contabilita.popupRicercaMastro.RicercaMastroBackingBean
    • 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.