public function capa($vars)
{
$db = new avdb();
$db->Conn_av();
$this->put_menu($vars);
$this->lista_alunos($vars);
}
public function Resultado_Teste($cod_Curso, $codAula, $user, $nomeuser)
{
$db = new avdb();
$db->Conn_av();
$this->put_menu($user, $nomeuser, 'Put_aulas');
$this->put_obs($cod_Curso, $codAula, $user);
$this->put_resultado($cod_Curso, $codAula, $user);
}
public function capa($vars)
{
$db = new avdb();
$db->Conn_av();
$this->put_menu($vars);
$this->lista_grupos($vars);
//var_dump($vars);
}
public function getLog($user)
{
include_once 'database.php';
$db = new avdb();
//$res = $db->runSEL("* FROM tblog WHERE Mail = '$email'");
$res = $db->Select("* FROM tblog WHERE \"user\" = {$user}");
$log['Email'] = $res[0][1];
$log['user'] = $res[0][2];
$log['nomeuser'] = $res[0][3];
$log['CodCurso'] = $res[0][4];
$log['CodAula'] = $res[0][5];
return $log;
}
`user` INT NULL ,
`nomeuser` VARCHAR( 255 ) NULL ,
`CodCurso` INT NULL ,
`CodAula` INT NULL ,
PRIMARY KEY ( `Chave` )
) ENGINE = MYISAM ;
</td>
</tr>
</table>
<?php
require 'database.php';
if (empty($_POST)) {
?>
<table>
<tr>
<td align="center">
<form name="exec" method="post">
<input type="button" name="Executa" valor="Executa"
</form>
</td>
</tr>
</table>
<?php
} else {
if ($_POST['Executa']) {
$db = new avdb();
$db->Conn_av();
mysql_query("ALTER TABLE aulas_avaliacoes CHANGE Tipo SET( 'MP', 'DS', 'SM' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'MP - Múltipla Escolha; DS - Discursiva, SM - Somatória'");
}
}
function Executa($Origem, $Destino, $nmAula, $DataLimite)
{
$db = new avdb();
$db->Conn_av();
if (strlen($DataLimite) == 10) {
$dia = substr($DataLimite, 0, 2);
$mes = substr($DataLimite, 3, 2);
$ano = substr($DataLimite, 6, 4);
$DataLimite = $ano . '-' . $mes . '-' . $dia;
//echo $DataLimite;
} else {
$DataLimite = NULL;
}
//obtem o MinimoMP de Origem
$MinimoMP = $db->Select("\"MinimoMP\" FROM aulas WHERE \"Chave\" = {$Origem}");
//insere a nova aula no curso de destino
//echo "<br>INSERT INTO aulas (\"CodCurso\", \"Nome\", \"DataLimite\") VALUES($Destino, '$nmAula', '$DataLimite')".$DataLimite;
if ($DataLimite != NULL) {
$sql = pg_query("INSERT INTO aulas (\"CodCurso\", \"Nome\", \"DataLimite\", \"MinimoMP\") VALUES({$Destino}, '{$nmAula}', '{$DataLimite}', {$MinimoMP})");
} else {
$sql = pg_query("INSERT INTO aulas (\"CodCurso\", \"Nome\", \"MinimoMP\") VALUES({$Destino}, '{$nmAula}', {$MinimoMP})");
}
//echo "INSERT INTO aulas CodCurso, Nome VALUES($Destino, '$nmAula')"."<br>";
//recupera a Chave da Nova criada
$sql = pg_query("SELECT \"Chave\" FROM aulas WHERE \"CodCurso\" = {$Destino} AND \"Nome\" = '{$nmAula}' ORDER BY \"Chave\" DESC ");
$res = pg_fetch_array($sql);
$NovaAula = $res[0];
//echo "SELECT * FROM aulas_avaliacoes WHERE (((CodAula)=$Origem)) ORDER BY IndexQuestao<br>";
$SQLorig = pg_query("SELECT * FROM aulas_avaliacoes WHERE (((\"CodAula\")={$Origem})) ORDER BY \"IndexQuestao\"");
// or die(mysql_errno());
//echo "SELECT * FROM aulas_avaliacoes WHERE (((CodAula)=$Origem)) ORDER BY IndexQuestao<br>";
$fields_orig = pg_query("SELECT column_name FROM information_schema.columns WHERE table_name = 'aulas_avaliacoes'");
$count = pg_num_fields($SQLorig);
//echo $count."<br>";
while ($orig = pg_fetch_array($SQLorig)) {
$str = "INSERT INTO aulas_avaliacoes (";
$i = 1;
pg_result_seek($fields_orig, 0);
while ($fields = pg_fetch_array($fields_orig)) {
if ($fields[0] != "Chave") {
$str .= "\"" . $fields[0] . "\"";
if ($i < $count) {
$str .= ", ";
}
}
$i++;
}
$str .= ") VALUES(";
$i = 1;
pg_result_seek($fields_orig, 0);
while ($fields = pg_fetch_array($fields_orig)) {
//prepara campos especiais
if ($orig['Tipo'] == '') {
$orig['Tipo'] = 'MP';
}
if (empty($orig['Min'])) {
$orig['Min'] = 'NULL';
}
if (empty($orig['Max'])) {
$orig['Max'] = 'NULL';
}
//prepara a clausula VALUES
switch ($fields[0]) {
case "CodCurso":
$str .= $Destino . ", ";
break;
case "CodAula":
$str .= $NovaAula . ", ";
break;
case "IndexQuestao":
$str .= $orig['IndexQuestao'] . ", ";
break;
case "Questao":
$str .= "'" . $orig['Questao'] . "', ";
break;
case "Peso":
$str .= $orig['Peso'];
break;
case "Tipo":
$str .= ", '" . $orig['Tipo'] . "', ";
break;
case "Min":
$str .= $orig['Min'] . ", ";
break;
case "Max":
$str .= $orig['Max'];
break;
}
$i++;
}
$str .= ")";
//echo "$str<br>";
//grava a nova questão
//echo "<br> $str";
$res = pg_query($str);
//insere as alternativas
$sql = pg_query("SELECT \"Chave\" FROM aulas_avaliacoes WHERE \"CodAula\" = {$NovaAula} AND \"IndexQuestao\" = " . $orig['IndexQuestao'] . " ORDER BY \"Chave\" DESC ");
$res = pg_fetch_array($sql);
$CodAvaliacao = $res[0];
$sqlAlts = pg_query("SELECT * FROM aulas_avaliacoes_alternativas WHERE \"CodAvaliacao\" = " . $orig['Chave']);
while ($alts = pg_fetch_array($sqlAlts)) {
$str = "INSERT INTO aulas_avaliacoes_alternativas (\"CodAula\", \"CodAvaliacao\", \"IndexAlternativa\", \"Alternativa\", \"Resposta\") VALUES({$NovaAula}, {$CodAvaliacao}, " . $alts['IndexAlternativa'] . ", '" . $alts['Alternativa'] . "', " . $alts['Resposta'] . ")";
//echo $str."<br>";
$res = pg_query($str);
}
}
$this->showNovaQuestao($Destino, $NovaAula, $nmAula);
}
function lista_aulas($cod_curso, $inicio)
{
$db = new avdb();
$db->Conn_av();
$this->titulo_new_aula($cod_curso);
?>
<div align="center">
<table class="tablemenuAdm">
<tr>
<td width="45" align="center" class="tdmenuAdm"><b>Id</b></td>
<td align="left" class="tdmenuAdm"><b>Aulas</b></td>
<td width="45" align="center" class="tdmenuAdm"><b>Questões</b></td>
<td align="center" width="20" class="tdmenuAdm"></td>
</tr>
</table>
</div>
<?php
//<!-- Tabela de dados -->
echo "<div align=\"center\">\r\n <table class=\"tabValores\">";
$c1 = "#FFFFFF";
$c2 = "#CCCCCC";
$c = 0;
if ($sql = pg_query("SELECT aulas.\"Chave\", aulas.\"Nome\", COUNT( aulas_avaliacoes.\"CodAula\" ) AS \"c_Aulas\"\r\n FROM aulas LEFT JOIN aulas_avaliacoes ON aulas.\"Chave\" = aulas_avaliacoes.\"CodAula\" \r\n WHERE aulas.\"CodCurso\" = {$cod_curso}\r\n GROUP BY aulas.\"Chave\", aulas.\"Nome\" ORDER BY aulas.\"Chave\" DESC")) {
// LIMIT $inicio , $inicio10
//echo "<br> SQL: $sql";
while ($r = pg_fetch_array($sql)) {
echo "<tr bgcolor=\"" . ($c++ & 1 ? $c1 : $c2) . "\"> \r\n\t\t\t<td width=\"45\" align=\"center\">" . $r['Chave'] . "</td>\r\n\t\t\t<td align=\"left\">" . $r['Nome'] . "</td>\r\n\t\t\t<td width=\"45\" align=\"center\">" . $r['c_Aulas'] . "</td>\r\n\t\t\t<form name=\"F_EditaAulas\"" . $r['Chave'] . "\" method=\"post\">\r\n <td align=\"center\" width=\"20\"> \r\n\t\t\t<input type=\"hidden\" name=\"EditaAula\" value=\"" . $r['Chave'] . "\">\r\n\t\t\t<input type=\"submit\" class=\"btnEdita\" name=\"btn\" title=\"Editar Aula\" alt=\"Editar\r\n Aula\" value=\"\">\r\n </td>\r\n </form>\r\n </tr>";
}
//while
}
//if
echo "</table>\r\n </div>";
echo "\r\n\t\t<!-- Botões nova aula e mais 10 -->\r\n\t\t<div align=\"center\">\r\n\t\t</table>\r\n\t\t<table class=\"tabTitle\">\r\n\t\t<tr>\r\n\t\t<td align=\"left\" width=\"45\">\r\n\t\t<form id=\"NovaAula\" name=\"NovaAula\" method=\"post\" action=\"\">\r\n\t\t<input name=\"NovaAula\" type=\"submit\" id=\"NovaAula\" value=\"NovaAula\" class=\"botaoAdm\" />\r\n\t\t</form>\r\n\t\t</td>\r\n\t\t<td align=\"left\">\r\n\t\t<!--\r\n\t\t<form id=\"ImportAulas\" name=\"ImportAulas\" method=\"post\" action=\"\">\r\n\t\t<input name=\"ImportAula\" type=\"submit\" id=\"ImportAula\" value=\"Importar Aulas\" class=\"botaoAdm\" />\r\n\t\t</form>\r\n\t\t-->\r\n\t\t</td>\r\n\t\t<td align=\"right\">\r\n\t\t<form id=\"MoreCursos\" name=\"Morecursos\" method=\"post\" action=\"\">\r\n\t\t<!--\r\n\t\t<input name=\"MoreCursos\" type=\"submit\" id=\"MoreCursos\" value=\"Mais 10\" class=\"botaoAdm\" />\r\n\t\t-->\r\n\t\t</form>\r\n\t\t</td>\r\n\t\t</tr>\t\r\n\t\t</table>\r\n\t\t<table class=\"tblinha\">\r\n\t\t<tr>\r\n\t\t<td> </td>\r\n\t\t</tr>\r\n\t\t</table>\r\n\t\t\t\r\n </div>";
//echo "<br> Listou aulas";
//*/
$db->close_conn_av();
}
public function Edita_Curso($codCurso, $NomeCurso, $nomeresponsavel, $msg, $find)
{
global $db;
$db = new avdb();
$db->Conn_av();
?>
<div align="center">
<!--
<table class="tablemenu">
<tr>
<td width="330" align="left" class="tdmenu"><b> Cadastro de Cursos </b></td>
<form id="voltar" name="voltar" method="post" action="">
<td width="70" align="center" valign="middle"><input name="OdimVoltar" type="submit" value="Voltar" class="botaoOdim"/> </td>
</form>
</tr>
</table>
-->
<table class="tblinha">
<tr> <td></td> </tr>
</table>
<table class="tbform">
<form id="novocurso" name="novocurso" method="post" onsubmit="gettopo();" >
<tr>
<td width="50" > </td>
<td align="left">Nome do Curso:<br>
<input type="text" name="NomeCurso" size="45" value="<?php
echo $NomeCurso;
?>
"></td>
<td width="50" > </td>
</tr>
<tr>
<td width="50" > </td>
<td align="left">Responsavel:<br>
<select size="1" name="nomeresponsavel">
<option value="0"> </option>
<?php
//insere os valores
//echo "<br> SELECT Chave, Nome FROM usuarios WHERE Nivel = 0 or Nivel=1";
if ($res = pg_query("SELECT \"Chave\", \"Nome\" FROM usuarios WHERE \"Nivel\" <= 1 ORDER BY \"Nome\"")) {
//echo "<br> SQL OK";
while ($r = pg_fetch_array($res)) {
//echo "<br> $r[1]";
if ($nomeresponsavel == $r[0]) {
echo "<option value=\"{$r['0']}\" selected>{$r['1']}</option>";
} else {
echo "<option value=\"{$r['0']}\">{$r['1']}</option>";
}
}
}
?>
</select> </td>
<td width="50"> </td>
</tr>
<tr>
<td width="50" >
<input type="hidden" name="codCurso" value="<?php
echo $codCurso;
?>
">
<input type="hidden" name="find" value="<?php
echo $find;
?>
">
</td>
<td align="right"><input type="submit" name="OdimUPDATECurso" value="Salvar"></td>
<td width="50" > </td>
</tr>
</form>
</table>
<table class="tblinha">
<tr>
<td><font color="#FF0000"><?php
echo $msg;
?>
</font> </td>
</tr>
</table>
<?php
}
