HistManualFuncaoDao.java

package br.com.centralit.citcorpore.rh.integracao;

import java.util.ArrayList;
import java.util.Collection;
import java.util.List;

import br.com.centralit.citcorpore.rh.bean.HistManualFuncaoDTO;
import br.com.centralit.citcorpore.rh.bean.ManualFuncaoDTO;
import br.com.citframework.dto.IDto;
import br.com.citframework.excecao.PersistenceException;
import br.com.citframework.integracao.CrudDaoDefaultImpl;
import br.com.citframework.integracao.Field;
import br.com.citframework.util.Constantes;

public class HistManualFuncaoDao extends CrudDaoDefaultImpl {

    public HistManualFuncaoDao() {
        super(Constantes.getValue("DATABASE_ALIAS"), null);
    }

    @Override
    public Collection<Field> getFields() {
        final Collection<Field> listFields = new ArrayList<>();
        listFields.add(new Field("idhistManualFuncao", "idhistManualFuncao", true, true, false, false));
        listFields.add(new Field("idManualFuncao", "idManualFuncao", false, false, false, false));
        listFields.add(new Field("tituloCargo", "tituloCargo", false, false, false, false));
        listFields.add(new Field("tituloFuncao", "tituloFuncao", false, false, false, false));
        listFields.add(new Field("resumoFuncao", "resumoFuncao", false, false, false, false));
        listFields.add(new Field("CBO", "codCBO", false, false, false, false));
        listFields.add(new Field("codigo", "codigo", false, false, false, false));
        listFields.add(new Field("idFormacaoRA", "idFormacaoRA", false, false, false, false));
        listFields.add(new Field("idIdiomaRA", "idIdiomaRA", false, false, false, false));
        listFields.add(new Field("idNivelEscritaRA", "idNivelEscritaRA", false, false, false, false));
        listFields.add(new Field("idNivelLeituraRA", "idNivelLeituraRA", false, false, false, false));
        listFields.add(new Field("idNivelConversaRA", "idNivelConversaRA", false, false, false, false));
        listFields.add(new Field("expAnteriorRA", "expAnteriorRA", false, false, false, false));
        listFields.add(new Field("idFormacaoRF", "idFormacaoRF", false, false, false, false));
        listFields.add(new Field("idIdiomaRF", "idIdiomaRF", false, false, false, false));
        listFields.add(new Field("idNivelEscritaRF", "idNivelEscritaRF", false, false, false, false));
        listFields.add(new Field("idNivelLeituraRF", "idNivelLeituraRF", false, false, false, false));
        listFields.add(new Field("idNivelConversaRF", "idNivelConversaRF", false, false, false, false));
        listFields.add(new Field("expAnteriorRF", "expAnteriorRF", false, false, false, false));
        listFields.add(new Field("pesoComplexidade", "pesoComplexidade", false, false, false, false));
        listFields.add(new Field("pesoTecnica", "pesoTecnica", false, false, false, false));
        listFields.add(new Field("pesoComportamental", "pesoComportamental", false, false, false, false));
        listFields.add(new Field("pesoResultados", "pesoResultados", false, false, false, false));
        listFields.add(new Field("dataAlteracao", "dataAlteracao", false, false, false, false));
        listFields.add(new Field("horaAlteracao", "horaAlteracao", false, false, false, false));
        listFields.add(new Field("idUsuarioAlteracao", "idUsuarioAlteracao", false, false, false, false));
        listFields.add(new Field("versao", "versao", false, false, false, false));
        return listFields;
    }

    @Override
    public String getTableName() {
        return this.getOwner() + "rh_histmanualFuncao";
    }

    @Override
    public Collection find(final IDto obj) throws PersistenceException {
        return null;
    }

    @Override
    public Collection list() throws PersistenceException {
        return null;
    }

    @Override
    public Class getBean() {
        return HistManualFuncaoDTO.class;
    }

    public Collection findByIdManualFuncao(final int idManualFuncal) throws PersistenceException {
        final List parametro = new ArrayList();
        final List listRetorno = new ArrayList();
        List list = new ArrayList();
        final StringBuilder sql = new StringBuilder();

        sql.append(" SELECT  idManualFuncao, tituloCargo, tituloFuncao, ");
        sql.append(" CBO, codigo, versao, idhistManualFuncao FROM RH_HISTMANUALFUNCAO ");
        sql.append(" where idManualFuncao = ? order by idhistManualFuncao desc");

        parametro.add(idManualFuncal);

        list = this.execSQL(sql.toString(), parametro.toArray());

        // listRetorno.add("idhistManualFuncao");
        listRetorno.add("idManualFuncao");
        listRetorno.add("tituloCargo");
        listRetorno.add("tituloFuncao");
        listRetorno.add("codCBO");
        listRetorno.add("codigo");
        listRetorno.add("versao");
        listRetorno.add("idhistManualFuncao");

        if (list != null && !list.isEmpty()) {
            return this.listConvertion(this.getBean(), list, listRetorno);
        }
        return null;
    }

    public HistManualFuncaoDTO maxIdHistorico(final ManualFuncaoDTO manualFuncao) throws PersistenceException {
        final List parametro = new ArrayList();
        final List listRetorno = new ArrayList();
        final StringBuilder sql = new StringBuilder();

        sql.append("SELECT MAX(idhistmanualfuncao) AS idhistmanualfuncao FROM " + this.getTableName() + " WHERE idmanualfuncao = ?");
        parametro.add(manualFuncao.getIdManualFuncao());
        final List resultado = this.execSQL(sql.toString(), parametro.toArray());
        listRetorno.add("idhistManualFuncao");
        final List result = this.listConvertion(HistManualFuncaoDTO.class, resultado, listRetorno);
        return (HistManualFuncaoDTO) result.get(0);
    }

}