public function autentica($login, $senha)
{
$conexao = new Conexao();
$tabelaLogin = "******";
$dbCon = $conexao->getConexao();
$sql = "select * from " . self::$tabela . " join {$tabelaLogin} on {$tabelaLogin}.id_login = "******"gestor.login " . "where {$tabelaLogin}.login = \$1 and " . "{$tabelaLogin}.senha = \$2";
$result = pg_query_params($dbCon, $sql, array($login, $senha));
if (pg_fetch_assoc($result)) {
$conexao->closeConexao();
return true;
} else {
$conexao->closeConexao();
return false;
}
}
function update($polo)
{
$conexao = new Conexao();
$dbCon = $conexao->getConexao();
$sql = "update " . self::$tabela . " set nome=\$1, cidade=\$2, uf=\$3 where id_polo=\$4";
$params = array($polo->getNome(), $polo->getCidade(), $polo->getEstado(), $polo->getId());
pg_query_params($dbCon, $sql, $params);
$conexao->closeConexao();
}
public function daoFetchAll($query, $params = 0)
{
$conexao = new Conexao();
$connection = $conexao->getConexao();
if ($params) {
$result = pg_query_params($connection, $query, $params);
} else {
$result = pg_query($connection, $query);
}
$conexao->closeConexao();
return pg_fetch_all($result);
}
function getTipos()
{
$conexao = new Conexao();
$dbCon = $conexao->getConexao();
$sql = "select * from sistutor.tipo_curso";
$result = pg_query($dbCon, $sql);
$tarefas = array();
while ($linha = pg_fetch_assoc($result)) {
array_push($tarefas, $linha);
}
$conexao->closeConexao();
return $tarefas;
}
function listByTutor($tutor)
{
$conexao = new Conexao();
$tutor_disciplina = "sistutor.tutor_disciplina";
$dbCon = $conexao->getConexao();
//criar join com curso
$sql = "select id_disciplina as disciplina from {$tutor_disciplina} where id_tutor=\$1";
$result = pg_query_params($dbCon, $sql, array($tutor->getTutorId()));
$disciplinas = array();
while ($linha = pg_fetch_assoc($result)) {
$id = $linha['disciplina'];
$disciplina = $this->getById($id);
array_push($disciplinas, $disciplina);
}
$conexao->closeConexao();
return $disciplinas;
}
function insere($tarefa)
{
$conexao = new Conexao();
$dbCon = $conexao->getConexao();
if ($tarefa->getDataHora() != "") {
$sql = "insert into tarefa(nome,descricao,data_hora, cor, imagem) values('" . $tarefa->getNome() . "','" . $tarefa->getDescricao() . "','" . $tarefa->getDataHora() . "','" . $tarefa->getCor() . "','" . $tarefa->getImagem() . "') ";
} else {
$sql = "insert into tarefa(nome,descricao, cor, imagem) values('" . $tarefa->getNome() . "','" . $tarefa->getDescricao() . "','" . $tarefa->getCor() . "','" . $tarefa->getImagem() . "') ";
}
pg_query($dbCon, $sql);
$conexao->closeConexao();
}
function addTutorDisciplina($id_tutor, $id_disciplina)
{
$conexao = new Conexao();
$tutor_disciplina = "sistutor.tutor_disciplina";
$dbCon = $conexao->getConexao();
$sql = "insert into {$tutor_disciplina} (id_tutor, id_disciplina, dt_inicio) values " . " (\$1, \$2, now())";
pg_query_params($dbCon, $sql, array($id_tutor, $id_disciplina));
$conexao->closeConexao();
}
