public function listar($_prQuery = '', $_prStart = 0, $_prLimit = 0) { $sb = new StringBuilder(); $Sql = new Sql(); $Sql->limit($_prStart, $_prLimit); $sb->append("SELECT *,"); $sb->append("codigo_usr as codigo,"); $sb->append("nome_usr as descricao"); $sb->append("FROM " . T_USUARIO); if (trim($_prQuery) != '') { $_prQuery = strtoupper($_prQuery); $sb->append("WHERE (UPPER(nome_usr) like '%{$_prQuery}%'"); $sb->append("OR UPPER(login_usr) like '%{$_prQuery}%')"); } $sb->append("ORDER BY codigo_usr"); return $Sql->executaSQL($sb->toString()); }
public function listar($_prQuery = '', $_prStart = 0, $_prLimit = 0) { $sb = new StringBuilder(); $Sql = new Sql(); $Sql->limit($_prStart, $_prLimit); $sb->append("SELECT *,"); $sb->append("codigo_com as codigo,"); $sb->append("titulo_com as descricao"); $sb->append("FROM " . T_COM); if (trim($_prQuery) != '') { $_prQuery = strtoupper($_prQuery); $sb->append("WHERE (UPPER(titulo_com) like '%{$_prQuery}%'"); $sb->append("OR UPPER(comunicado_com) like '%{$_prQuery}%')"); } $sb->append("ORDER BY codigo_com"); return $Sql->executaSQL($sb->toString()); }
public function listar($_prQuery = '', $_prStart = 0, $_prLimit = 0) { $sb = new StringBuilder(); $Sql = new Sql(); $Sql->limit($_prStart, $_prLimit); $sb->append("SELECT *,"); $sb->append("codigo_emp as codigo,"); $sb->append("nome_emp as descricao"); $sb->append("FROM " . T_EMP); $sb->append("LEFT JOIN"); $sb->append(T_DEP); $sb->append("ON codigo_dpt = departamento_emp"); if (trim($_prQuery) != '') { $_prQuery = strtoupper($_prQuery); $sb->append("WHERE (UPPER(nome_emp) like '%{$_prQuery}%'"); $sb->append("OR UPPER(nome_dpt) like '%{$_prQuery}%')"); } $sb->append("ORDER BY codigo_emp"); return $Sql->executaSQL($sb->toString()); }