Examples of SearchCriteria


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

  }

  public void testGetListaSaldiMutui() {
    List<SearchCriteriaLogicProduct> andCriteriaList = new ArrayList<SearchCriteriaLogicProduct>();
    Date dataSituazione = new Date();
    SearchCriteria sc = new SearchCriteria("numeroMutuo", SearchOperators.equal);
    sc.setValore(new Long(10000029));
    // SearchCriteria scDesc = new SearchCriteria("descrizioneMutuo",SearchOperators.like);
    // scDesc.setValore(new String("BARB*"));

    // SearchCriteria sc = new SearchCriteria("codiceProdotto",SearchOperators.equal);
    // sc.setValore(new String("TRAD"));
View Full Code Here

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

    try{
     
      List<SearchCriteriaLogicProduct> andCriteriaList = new ArrayList<SearchCriteriaLogicProduct>();
//      SearchCriteria sc = new SearchCriteria("numeroMutuo", SearchOperators.equal);
//      sc.setValore(new Long(202826));
      SearchCriteria sc = new SearchCriteria("anno", SearchOperators.equal);
      sc.setValore(new Integer(2009));
      if (andCriteriaList.size() == 0)
        andCriteriaList.add(new SearchCriteriaLogicProduct());
      for (SearchCriteriaLogicProduct searchCriteriaLogicProduct : andCriteriaList) {
        searchCriteriaLogicProduct.addSearchCriteria(sc);
      }
View Full Code Here

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

        q.append(" ORDER BY 1 ASC, 2 ASC, 3 ASC, 4 ASC, 7 ASC ");
      else
        q.append(" ORDER BY 1 ASC, 2 ASC, 3 ASC, 6 ASC, 7 ASC ");

      List<SearchCriteria> criteria = new ArrayList<SearchCriteria>();
      SearchCriteria criteriaDataInizioAnno = new SearchCriteria("dataInizioAnno", SearchOperators.equal);
      criteriaDataInizioAnno.setValore(calcolaDataInizioAnno(input.getDataDa()));
      criteria.add(criteriaDataInizioAnno);

      SearchCriteria criteriaDataDa = new SearchCriteria("dataDa", SearchOperators.equal);
      criteriaDataDa.setValore(input.getDataDa());
      criteria.add(criteriaDataDa);

      SearchCriteria criteriaDataA = new SearchCriteria("dataA", SearchOperators.equal);
      criteriaDataA.setValore(input.getDataA());
      criteria.add(criteriaDataA);

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

      if (input.getGruppoDa() != null) {
        SearchCriteria criteriaGruppoDa = new SearchCriteria("gruppoDa", SearchOperators.equal);
        criteriaGruppoDa.setValore(input.getGruppoDa());
        criteria.add(criteriaGruppoDa);

        SearchCriteria criteriaGruppoA = new SearchCriteria("gruppoA", SearchOperators.equal);
        criteriaGruppoA.setValore(input.getGruppoA());
        criteria.add(criteriaGruppoA);
      }

      if (input.getMastroDa() != null) {
        SearchCriteria criteriaMastroDa = new SearchCriteria("mastroDa", SearchOperators.equal);
        criteriaMastroDa.setValore(input.getMastroDa());
        criteria.add(criteriaMastroDa);

        SearchCriteria criteriaMastroA = new SearchCriteria("mastroA", SearchOperators.equal);
        criteriaMastroA.setValore(input.getMastroA());
        criteria.add(criteriaMastroA);
      }

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

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

      List<?> list = null;
View Full Code Here

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

    query.append("SELECT  CG01_NR_ARTICOLO_CUSTOM ");
    query.append("from MOVCONT ");
    query.append("where CG01_NR_ARTICOLO = :NR_ARTICOLO ");
    query.append("group by CG01_NR_ARTICOLO_CUSTOM  ");

    SearchCriteria sc = new SearchCriteria("NR_ARTICOLO", SearchOperators.equal);
    sc.setValore(numeroChiave);
    List<SearchCriteria> criteria = new ArrayList<SearchCriteria>();
    criteria.add(sc);

    try {
      List<?> list = this.getHibernateTemplate().executeFind(
View Full Code Here

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

    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

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

    _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

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

      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

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

    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

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

    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

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

    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
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.