public function recuperarTopico($id_topico){
$query ="SELECT tbl_topico.topico AS topico,
tbl_topico.disciplina AS disciplina,
tbl_topico.descricao AS descricao
FROM tbl_topico
WHERE tbl_topico.topico = $id_topico ";
$banco = $this->getBancoDados();
$topico = NULL;
$retorno = $banco->executaSQL($query);
if($retorno != NULL) {
if ($banco->numRows($retorno) == 0){
throw new Exception("Nenhuma topico encontrado.",0);
}
while($linha = $banco->fetchArray($retorno)) {
$sessionFacade = new SessionFacade($banco);
$obj_disciplina = $sessionFacade->recuperarDisciplina($linha["disciplina"]);
$topico = new Topico();
$topico->setId($linha['topico']);
$topico->setDisciplina($obj_disciplina);
$topico->setDescricao($linha["descricao"]);
}
return $topico;
} else {
throw new Exception("Erro ao recuperar Topico ($query)");
}
}
$fonte = addslashes(trim($_POST['fonte']));
$ativa = addslashes(trim($_POST['ativa']));
try {
$banco->iniciarTransacao();
$obj_tipo_pergunta = $sessionFacade->recuperarTipoPergunta($tipo_pergunta);
$obj_topico = $sessionFacade->recuperarTopico($topico);
$obj_curso = $sessionFacade->recuperarCurso($curso);
$obj_disciplina = $sessionFacade->recuperarDisciplina($disciplina);
if (strlen($topico_descricao)>0){
$obj_topico = new Topico();
$obj_topico->setDisciplina($obj_disciplina);
$obj_topico->setDescricao($topico_descricao);
$sessionFacade->gravarTopico($obj_topico);
}
$perg = new Pergunta();
$perg->setId($pergunta);
$perg->setTopico($obj_topico);
$perg->setTitulo($titulo_pergunta);
$perg->setTipoPergunta($obj_tipo_pergunta);
$perg->setDificuldade($dificuldade);
$perg->setFonte($fonte);
$perg->setAtiva($ativa);
$qtde_respostas = 0;
if (is_object($obj_tipo_pergunta)){
############## CADASTRAR / ALTERAR ##############
##############################################################################
if (isset($_POST['btn_acao']) AND strlen(trim($_POST['btn_acao']))>0) {
$topico = addslashes(trim($_POST['topico']));
$disciplina = addslashes(trim($_POST['disciplina']));
$descricao = addslashes(trim($_POST['descricao']));
try {
$obj_disciplina = $sessionFacade->recuperarDisciplina($disciplina);
$topic = new Topico();
$topic->setId($topico);
$topic->setDisciplina($obj_disciplina);
$topic->setDescricao($descricao);
$sessionFacade->gravarTopico($topic);
$banco->desconecta();
header("Location: cadastro.topico.php?topico=".$topic->getId()."&msg_codigo=1");
exit;
} catch(Exception $e) {
//header("location: cadastrarCliente.php?msg=".$e->getMessage());
array_push($msg_erro,$e->getMessage());
#exit;
}
}
##############################################################################
############## INCLUDES : CABECALHO ##############
##############################################################################
