package br.com.elotech.social.scripts;

import br.com.elotech.social.model.filters.ReciboBolsaAuxilioFilter;

public class ReciboBolsaAuxilioScript {

    public static String getSql() {

      StringBuilder sb = new StringBuilder()
        .append("SELECT asbdi.asbdi_qtd AS qtd,")
        .append("       asbdi.asbdi_valor AS valor,")
        .append("       asbdi.asbdi_referencia AS referencia,")
        .append("       asbd.asbd_dtcadastro AS dataConcessaoBeneficio,")
        .append("       usu.usu_nome AS nome,")
        .append("       conf.conf_valor_string AS lei,")
        .append("       ben.beneficio AS beneficio,")
        .append("       usu.usu_cpf AS cpf")
        .append("  FROM as_beneficios_dados asbd ")
        .append("  JOIN as_beneficios_dados_itens asbdi ON asbd.asbd_codigo = asbdi.asbd_codigo")
        .append("  JOIN usuario usu ON asbd.usu_codigo = usu.usu_codigo")
        .append("  JOIN as_beneficios_tipo asbt ON asbdi.asbt_codigo = asbt.asbt_codigo")
        .append("  JOIN beneficios ben ON asbdi.cod_ben = ben.cod_ben")
        .append("  JOIN config conf ON conf.conf_chave = 'LEI_ENQUADRAMENTO_BOLSA_AUXILIO'")
        .append("   AND asbd.asbd_codigo = :asbdCodigo")
        .append("   AND asbt_num in (7)");

        return sb.toString();
    }
}