package br.com.elotech.social.scripts;

public class CertidaoLiberatoriaScript {

    public static String getSqlCertidaoLiberatoria(){
      StringBuilder sb = new StringBuilder("SELECT *,");
        sb.append(" uni.uni_desc,")
          .append("uni.uni_cnpj,")
          .append(" usr.usr_nome,")
          .append(" crg.crg_nome")
          .append(" FROM as_certidao_liberatoria AS ascl")
          .append(" INNER JOIN unidade AS uni ON ascl.uni_codigo = uni.uni_codigo")
          .append(" INNER JOIN usuarios AS usr ON ascl.usr_codigo = usr.usr_codigo")
          .append(" LEFT JOIN cargos AS crg ON usr.crg_codigo = crg.crg_codigo")
          .append(" WHERE ascl_codigo =:asclCodigo");
        return sb.toString();

    }
}