package br.com.elotech.scripts;

/**
 * User: claiton.nazaret
 * Date: 14/03/2019
 * Time: 09:26
 */
public abstract class ScriptMembro {

  private static StringBuilder builder;

//  public static String getSqlPesquisaCidadao(){
//    builder = new StringBuilder();
//    builder.append("SELECT usu_codigo, usu_nome, usu_datanasc, usu_mae, usu_nis, usu_cpf FROM usuarios")
//           .append(" WHERE (usu_nis IS NOT NULL AND replace(regexp_replace(retira_acentos(lower(trim(usu_nis))), '[^0-9]', ''), ' ', '') = :usu_nis)")
//           .append("    OR (usu_cpf IS NOT NULL AND replace(regexp_replace(retira_acentos(lower(trim(usu_cpf))), '[^0-9]', ''), ' ', '') = :usu_cpf)")
//           .append("    OR (replace(regexp_replace(retira_acentos(lower(trim(usu_nome))), '[^a-z0-9]', ''), ' ', '') = :usu_nome")
//           .append("   AND replace(regexp_replace(retira_acentos(lower(trim(usu_mae))), '[^a-z0-9]', ''), ' ', '') = :usu_mae")
//           .append("   AND usu_datanasc = :dt_nasc)");
//    return builder.toString();
//  }

  public static String getSqlPesquisaCidadao(){
    builder = new StringBuilder();
    builder.append("SELECT usu_codigo, usu_nome, usu_datanasc, usu_mae, usu_nis, usu_cpf FROM usuario ORDER BY usu_codigo");
    return builder.toString();
  }
}