package br.com.elotech.social.scripts;

public class AtaReuniaoScript {

    private static StringBuilder sb;

    public static String getSqlAtaReuniao(){
        sb = new StringBuilder("SELECT *,");
        sb.append(" uni.uni_desc")
          .append(" FROM as_reunioes AS asreu")
          .append(" INNER JOIN unidade AS uni ON asreu.uni_codigo = uni.uni_codigo")
          .append(" WHERE asreu_codigo =:asreuCodigo");
        return sb.toString();

    }

    public static String getSqlReuniaoParticipantes(){
        sb = new StringBuilder("SELECT *,");
        sb.append(" usr.usr_nome,")
          .append(" crg.crg_nome")
          .append(" FROM as_reunioes_participantes AS asreupar")
          .append(" INNER JOIN usuarios AS usr ON asreupar.usr_codigo = usr.usr_codigo")
          .append(" LEFT JOIN cargos AS crg ON (crg.crg_codigo = usr.crg_codigo AND crg.crg_status IS TRUE)")
          .append(" WHERE asreu_codigo =:asreuCodigo")
          .append(" ORDER BY usr.usr_nome");
        return sb.toString();
    }
}