it.cnr.contab.docamm00.consultazioni.comp.CdSDaConguagliareComponent Maven / Gradle / Ivy

Go to download
/*
 * Copyright (C) 2019  Consiglio Nazionale delle Ricerche
 *
 *     This program is free software: you can redistribute it and/or modify
 *     it under the terms of the GNU Affero General Public License as
 *     published by the Free Software Foundation, either version 3 of the
 *     License, or (at your option) any later version.
 *
 *     This program is distributed in the hope that it will be useful,
 *     but WITHOUT ANY WARRANTY; without even the implied warranty of
 *     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *     GNU Affero General Public License for more details.
 *
 *     You should have received a copy of the GNU Affero General Public License
 *     along with this program.  If not, see .
 */

package it.cnr.contab.docamm00.consultazioni.comp;
/**
 * Insert the type's description here.
 * Creation date: (08/10/2001 15:39:09)
 * @author: CNRADM
 */
import java.math.BigDecimal;
import java.math.BigInteger;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Calendar;
import java.util.Date;
import java.util.Enumeration;
import java.util.GregorianCalendar;
import java.util.List;


import it.cnr.contab.compensi00.docs.bulk.CompensoBulk;
import it.cnr.contab.compensi00.docs.bulk.CompensoHome;
import it.cnr.contab.docamm00.consultazioni.bulk.Monito_cococoBulk;
import it.cnr.contab.docamm00.consultazioni.bulk.Monito_cococoHome;
import it.cnr.contab.docamm00.consultazioni.bulk.V_terzi_da_conguagliareBulk;
import it.cnr.contab.docamm00.consultazioni.bulk.V_terzi_da_conguagliareHome;
import it.cnr.contab.utenze00.bp.CNRUserContext;
import it.cnr.jada.UserContext;
import it.cnr.jada.bulk.OggettoBulk;
import it.cnr.jada.comp.ApplicationException;
import it.cnr.jada.comp.CRUDComponent;
import it.cnr.jada.comp.ComponentException;
import it.cnr.jada.persistency.IntrospectionException;
import it.cnr.jada.persistency.PersistencyException;
import it.cnr.jada.persistency.Persistent;
import it.cnr.jada.persistency.sql.*;
import it.cnr.jada.util.DateUtils;
import it.cnr.jada.util.RemoteIterator;

/**
 * @author mspasiano
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class CdSDaConguagliareComponent extends CRUDComponent {

	@SuppressWarnings("unchecked")
	public List findTerzi(UserContext userContext, it.cnr.contab.config00.sto.bulk.CdsBulk cds) throws ComponentException{
		try {
			V_terzi_da_conguagliareHome home = (V_terzi_da_conguagliareHome) getHome(userContext, V_terzi_da_conguagliareBulk.class);
			SQLBuilder sql = home.createSQLBuilder();
			sql.addClause(FindClause.AND, "esercizio", SQLBuilder.EQUALS, CNRUserContext.getEsercizio(userContext));
			sql.addClause(FindClause.AND, "cd_cds", SQLBuilder.EQUALS, cds.getCd_unita_organizzativa());
			sql.addClause(FindClause.AND, "tipologia", SQLBuilder.NOT_EQUALS, V_terzi_da_conguagliareBulk.TIPO_B);
			return home.fetchAll(sql);
		} catch (PersistencyException e) {
			throw new ComponentException(e);
		}
	}
	@Override
	protected Query select(UserContext usercontext, CompoundFindClause compoundfindclause, OggettoBulk oggettobulk) throws ComponentException, PersistencyException {
		Query query = super.select(usercontext, compoundfindclause, oggettobulk);
		V_terzi_da_conguagliareHome home = (V_terzi_da_conguagliareHome) getHome(usercontext, V_terzi_da_conguagliareBulk.class);
		SQLBuilder sql = home.createSQLBuilder();
		sql.addSQLJoin("V_TERZI_DA_CONGUAGLIARE.CD_CDS","UNITA_ORGANIZZATIVA.CD_UNITA_ORGANIZZATIVA");
		sql.addClause(FindClause.AND, "esercizio", SQLBuilder.EQUALS, CNRUserContext.getEsercizio(usercontext));
		sql.addClause(FindClause.AND, "tipologia", SQLBuilder.NOT_EQUALS, V_terzi_da_conguagliareBulk.TIPO_B);
		((SQLBuilder)query).addSQLExistsClause(FindClause.AND, sql);
		return query;
	}	
}