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;
}
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);
}
$vars['codgrupo'] = $gr['CodGrup'];
$rel = new relaluno();
$rel->capa($vars);
}
}
} else {
//echo "<br> Entrou login";
//global $db;
$db = new avdb();
$db->Conn_av();
//obtém o código do curso
//if(isset($_GET['email'])) {
if (isset($_GET['identifier'])) {
include_once 'funcs.php';
//echo "\"Chave\" FROM cursos WHERE \"Nome\" = '".$_GET['curso']."'"."<br/'>";
$cur = $db->Select("\"Chave\" FROM cursos WHERE \"Nome\" = '" . $_GET['curso'] . "'");
//echo "<br> Cur=== $cur <br> SELECT \"Chave\" FROM cursos WHERE \"Nome\" = '".$_GET['curso']."'";
//verifica se o usuário é cadastrado.
//se sim, atualiza seus dados. se não, cadastra-o
$chusr = $db->Select("\"Chave\" FROM usuarios WHERE \"ID\" = '" . $_GET['identifier'] . "'");
if ($chusr >= 1) {
//edita o usuario
$db->runUpSQL("usuarios SET \"Nome\" = '" . $_GET['name'] . "' , \"Mail\" = '" . $_GET['email'] . "' WHERE \"Chave\" = {$chusr}");
} else {
$db->runINS("usuarios (\"Nome\", \"Mail\", \"ID\") VALUES('" . $_GET['name'] . "', '" . $_GET['email'] . "', '" . $_GET['identifier'] . "' )");
$chusr = $db->Select("\"Chave\" FROM usuarios WHERE \"ID\" = '" . $_GET['identifier'] . "'");
}
$fc = new funcs();
//$fc->setCurso($_GET['email'],$cur);
$fc->setCurso($chusr, $cur);
//$login = $_GET['email'];
