Package it.pdor.commonLayer.hibernate.searchutils

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


    StringBuffer q = new StringBuffer();

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

    criteria.add(new SearchCriteria("tipoBollato", tipoBollato));
    criteria.add(new SearchCriteria("dataUltimaStampaLibroIVA", dataUltimaStampaLibroIva));
    criteria.add(new SearchCriteria("legalEntity", legalEntity));
    criteria.add(new SearchCriteria("organizationUnit", organizationUnit));

    if (!dataLibroIVA.before(dataInizioEsCorr) && !dataLibroIVA.after(dataFineEsCorr)) {

      q.append(" SELECT MAX( MOVCONT.CG01_NR_PROTOCOLLO ) as numeroProtocollo ");
      q.append(" FROM   MOVCONT, ");
      q.append("     MOVIVA ");
      q.append(" WHERE   MOVCONT.CG01_NR_ARTICOLO = MOVIVA.CG06_NR_ARTICOLO ");
      q.append(" AND   MOVCONT.CG01_PGR_RIGA_ART = MOVIVA.CG06_PGR_RIGA_ART ");
      q.append(" AND   MOVIVA.CG06_TP_BOLLATO_IVA = :tipoBollato ");
      q.append(" AND   MOVCONT.CG01_DT_REG BETWEEN :dataInizioEsCorr  ");
      q.append(" AND  :dataUltimaStampaLibroIVA ");
      q.append(" AND   MOVCONT.CG01_COD_SOCIETA_VEICOLO = :codiceSocietaVeicolo ");
      q.append(" AND MOVCONT.CG01_LEGAL_ENTITY = :legalEntity ");
      q.append(" AND MOVCONT.CG01_ORG_UNIT = :organizationUnit ");
      q.append(" AND MOVCONT.CG01_LEGAL_ENTITY = MOVIVA.CG06_LEGAL_ENTITY ");
      q.append(" AND MOVCONT.CG01_ORG_UNIT = MOVIVA.CG06_ORG_UNIT ");

      criteria.add(new SearchCriteria("codiceSocietaVeicolo", codiceSocietaVeicolo));
      criteria.add(new SearchCriteria("dataInizioEsCorr", dataInizioEsCorr));

    } else if (!dataLibroIVA.before(dataInizioEsSucc) && !dataLibroIVA.after(dataFineEsSucc)) {

      q.append(" SELECT max(MOVCONT.CG01_NR_PROTOCOLLO) as numeroProtocollo ");
      q.append(" FROM MOVCONT, ");
      q.append(" MOVIVA  ");
      q.append(" WHERE MOVCONT.CG01_NR_ARTICOLO = MOVIVA.CG06_NR_ARTICOLO ");
      q.append(" AND   MOVCONT.CG01_PGR_RIGA_ART = MOVIVA.CG06_PGR_RIGA_ART ");
      q.append(" AND   MOVIVA.CG06_TP_BOLLATO_IVA = :tipoBollato ");
      q.append(" AND   MOVCONT.CG01_DT_REG BETWEEN :dataInizioEsSucc ");
      q.append(" AND  :dataUltimaStampaLibroIVA ");
      q.append(" AND MOVCONT.CG01_LEGAL_ENTITY = :legalEntity ");
      q.append(" AND MOVCONT.CG01_ORG_UNIT = :organizationUnit ");
      q.append(" AND MOVCONT.CG01_LEGAL_ENTITY = MOVIVA.CG06_LEGAL_ENTITY ");
      q.append(" AND MOVCONT.CG01_ORG_UNIT = MOVIVA.CG06_ORG_UNIT ");

      criteria.add(new SearchCriteria("dataInizioEsSucc", dataInizioEsSucc));

    }

    List<?> list;
    try {
      list = this.getHibernateTemplate()
          .executeFind(new ContabilitaHibernateBindCallback(q.toString(), criteria));
    } catch (DataAccessException e) {
      log("Impossibile leggere numero protocollo " + e);
      e.printStackTrace();
      throw new ImpossibileLeggereNumeroProtocolloException();
    }
    if (list != null && list.size() > 0) {
      for (int r = 0; r < list.size(); r++) {
        Object o;
        o = (Object) list.get(r);
        BigDecimal grup = (BigDecimal) o;
        if (grup != null)
          numeroProtocollo = new Long(grup.longValue());
      }
    }
    if (numeroProtocollo == null) {
      q = new StringBuffer();
      criteria = new ArrayList<SearchCriteria>();
      criteria.add(new SearchCriteria("tipoBollato", tipoBollato));
      criteria.add(new SearchCriteria("legalEntity", legalEntity));
      criteria.add(new SearchCriteria("organizationUnit", organizationUnit));

      q.append(" SELECT DISTINCT TAB_TIPI_PROTOCOLLO.CG14_NR_PROT_INIZIO_ANNO as numeroProtocollo ");
      q.append(" FROM  CAUS_OPER, ");
      q.append(" DET_CAUS_OPER ,   ");
      q.append(" TAB_TIPI_PROTOCOLLO  ");
View Full Code Here


    mappingCampi.put("iva", Hibernate.DOUBLE);
    mappingCampi.put("ivaNonDetraibile", Hibernate.DOUBLE);

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

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

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

    mappingCampi.put("numeroBollato", Hibernate.LONG);
    mappingCampi.put("dataRegistrazione", Hibernate.DATE);

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

    criteria.add(new SearchCriteria("codiceSocietaVeicolo", codiceSocietaVeicolo));
    criteria.add(new SearchCriteria("numeroBollatoDal", numeroBollatoDal));
    criteria.add(new SearchCriteria("dataInizioEsercizio", dataInizioEsercizio));
    criteria.add(new SearchCriteria("dataFinoAl", dataFinoAl));
    criteria.add(new SearchCriteria("legalEntity", legalEntity));
    criteria.add(new SearchCriteria("organizationUnit", organizationUnit));

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

      mappingCampi.put("errore", Hibernate.STRING);
      mappingCampi.put("legalEntity", Hibernate.STRING);
      mappingCampi.put("organizationUnit", Hibernate.STRING);

      List<SearchCriteria> criteria = new ArrayList<SearchCriteria>();
      criteria.add(new SearchCriteria("dataAl", dataAl));
      criteria.add(new SearchCriteria("flagTrasf", flagTrasf));
      criteria.add(new SearchCriteria("legalEntity", legalEntity));
      criteria.add(new SearchCriteria("organizationUnit", organizationUnit));

      list = this.getHibernateTemplate().executeFind(
          new ContabilitaHibernateCallbackWithMapping(q.toString(), criteria, mappingCampi,
              RaggruppamentoAntiMafia.class));
View Full Code Here

    query.append(" group by  MOVCONT.CG01_NR_ARTICOLO                                                ");
    query.append(" order by 1                                                                        ");

    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("dataRegistrazione", Hibernate.DATE);
    mappingCampi.put("numArticolo", Hibernate.LONG);
View Full Code Here

    query.append(" CONTI.CG05_DT_ULTVAR, ");
    query.append(" CONTI.CG05_UTENTE ");

    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("codGruppo", Hibernate.LONG);
    mappingCampi.put("codMastro", Hibernate.LONG);
View Full Code Here

    query.append("CG01_LEGAL_ENTITY = :legalEntity AND  ");
    query.append("CG01_ORG_UNIT = :organizationUnit ");

    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));

    List<?> list;
    try {
      list = this.getHibernateTemplate().executeFind(
          new ContabilitaHibernateBindCallback(query.toString(), criteria));
View Full Code Here

    query.append(" AND MUTUI_ERR.ORG_UNIT = MUTUO.CA01_ORG_UNIT ");
    query.append(" AND MUTUO.CA01_LEGAL_ENTITY = :legalEntity ");
    query.append(" AND MUTUO.CA01_ORG_UNIT = :organizationUnit ");

    List<SearchCriteria> criteria = new ArrayList<SearchCriteria>();
    criteria.add(new SearchCriteria("legalEntity", legalEntity));
    criteria.add(new SearchCriteria("organizationUnit", organizationUnit));

    HashMap<String, Type> mappingCampi = new HashMap<String, Type>();
    mappingCampi.put("numeroMutuo", Hibernate.LONG);
    mappingCampi.put("descrizioneMutuo", Hibernate.STRING);
View Full Code Here

    query.append(" CERTIFICAZIONI.CA36_LEGAL_ENTITY = MUTUO.CA01_LEGAL_ENTITY AND ");
    query.append(" CERTIFICAZIONI.CA36_ORG_UNIT = MUTUO.CA01_ORG_UNIT ");
    query.append(" ORDER BY MUTUO.CA01_DSC_MUTUO ");

    List<SearchCriteria> criteria = new ArrayList<SearchCriteria>();
    criteria.add(new SearchCriteria("anno", anno));
    criteria.add(new SearchCriteria("legalEntity", legalEntity));
    criteria.add(new SearchCriteria("organizationUnit", organizationUnit));

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

    mappingCampi.put("numeroMutuo", Hibernate.LONG);
    mappingCampi.put("descrizioneMutuo", Hibernate.STRING);
View Full Code Here

    GregorianCalendar dataInizio = new GregorianCalendar(anno, 0, 1);
    GregorianCalendar dataFine = new GregorianCalendar(anno, 11, 31);

    List<SearchCriteria> criteria = new ArrayList<SearchCriteria>();
    criteria.add(new SearchCriteria("dataInizio", dataInizio.getTime()));
    criteria.add(new SearchCriteria("dataFine", dataFine.getTime()));
    criteria.add(new SearchCriteria("numeroMutuo", numeroMutuo));
    criteria.add(new SearchCriteria("legalEntity", legalEntity));
    criteria.add(new SearchCriteria("organizationUnit", organizationUnit));

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

    mappingCampi.put("cognome", Hibernate.STRING);
    mappingCampi.put("nome", Hibernate.STRING);
View Full Code Here

TOP

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

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.