*/
require_once "../../app/setup.php";
require_once "../../core/data/grid.php";
/*
* Estancia a classe de conexao e abre
*/
$conn = new connection_factory($param_conn);
$grid = new grid();
$sql = '
SELECT
p.id as "Cód.",
p.nome as "Nome",
u.nome as "Usuário",
to_char(o.dt_ingresso,\'DD/MM/YYYY\') as "Data de entrada",
d.descricao as "Departamento"
' . $grid->options('p.id', 'alterar.php') . '
FROM
professores o LEFT OUTER JOIN usuario u
ON (u.ref_pessoa = o.ref_professor),
pessoas p, departamentos d
WHERE
o.ref_professor = p.id AND
d.id = o.ref_departamento
ORDER BY to_ascii(p.nome,\'LATIN1\')';
?>
<html>
<head>
<?php
echo $DOC_TYPE;
?>
<title>SA</title>