public function findAll($qbuilder)
{
if (UserSession::getInstance()->getAccessLevel() < 3) {
die("<h1>Forbidden resource for you.</h1>");
}
@($dao = new DAO(TestLog));
if (!isset($qbuilder)) {
$qbuilder = new QueryBuilder('testlog');
$qbuilder->addOrder("tsl_tst_id", QueryBuilder::$DESC);
$qbuilder->addOrder("usr_name", QueryBuilder::$ASC, 'user');
$qbuilder->addOrder("tsl_time", QueryBuilder::$DESC);
$qbuilder->addOrder("tsl_remoteAddr", QueryBuilder::$ASC);
}
$qbuilder->addJoin("user", "tsl_usr_id", "usr_id");
$qbuilder->addJoin("test", "tsl_tst_id", "tst_id");
$tlogs = $dao->findByQuery($qbuilder);
return $tlogs;
}
public function findAll($qbuilder)
{
if (UserSession::getInstance()->getAccessLevel() < 5) {
die("<h1>Forbidden resource for you.</h1>");
}
@($dao = new DAO(Discipline));
if (!isset($qbuilder)) {
$qbuilder = new QueryBuilder('discipline');
$qbuilder->addOrder("dsc_code", QueryBuilder::$ASC);
$qbuilder->addOrder("dsc_name", QueryBuilder::$ASC);
}
$disciplines = $dao->findByQuery($qbuilder);
return $disciplines;
}
public function retrieve()
{
@($dao = new DAO(Test));
$qbuilder = new QueryBuilder('test');
$qbuilder->addEqual('tst_id', $this->params['tst_id']);
$test = $dao->findByQuery($qbuilder);
return $test[0];
}
public function findAll($qbuilder)
{
if (UserSession::getInstance()->getAccessLevel() < 3) {
die("<h1>Forbidden resource for you.</h1>");
}
@($dao = new DAO(TestTrial));
if (!isset($qbuilder)) {
$qbuilder = new QueryBuilder('testtrial');
$qbuilder->addOrder("tst_title", QueryBuilder::$ASC, 'test');
$qbuilder->addOrder("prb_difficultyLevel", QueryBuilder::$ASC, 'problem');
$qbuilder->addOrder("prb_title", QueryBuilder::$ASC, 'problem');
$qbuilder->addOrder("ttl_score", QueryBuilder::$DESC);
}
$qbuilder->addJoin("user", "ttl_usr_id", "usr_id");
$qbuilder->addJoin("test", "ttl_tst_id", "tst_id");
$qbuilder->addJoin("problem", "ttl_prb_id", "prb_id");
$ttrials = $dao->findByQuery($qbuilder);
return $ttrials;
}
public function recovery($email)
{
@($dao = new DAO(User));
$query = new QueryBuilder('user');
$query->addEqual('usr_email', $email);
$users = $dao->findByQuery($query);
if (count($users) != 1) {
die("Usuário não encontrado.");
} else {
$user = $users[0];
$nome = $user->get('usr_name');
$passw = generatePassword(9, 8);
$password = sha1($passw);
$user->set('usr_password', $password);
$dao->update($user);
$mail = new PHPMailer();
// Charset para evitar erros de caracteres
$mail->Charset = 'UTF-8';
// Dados de quem est? enviando o email
$mail->From = '*****@*****.**';
$mail->FromName = 'Algod';
// Setando o conteudo
$mail->IsHTML(true);
$mail->Subject = 'Redefinicao de senha';
$mail->Body = 'Voce solicitou a redefinicao da sua senha. Sua senha temporaria e ' . $passw . '<br>Por favor faca login em sua conta e modifique-a';
$mail->AltBody = 'Voce solicitou a redefinicao da sua senha. Sua senha temporaria e ' . $passw . ' Por favor faca login em sua conta e modifique-a';
// Validando a autentica??o
$mail->IsSMTP();
$mail->SMTPAuth = true;
$mail->Host = "ssl://smtp.googlemail.com";
$mail->Port = 465;
$mail->Username = '******';
$mail->Password = '******';
// Setando o endere?o de recebimento
$mail->AddAddress($email, $nome);
$result = $mail->Send();
if ($result) {
return TRUE;
} else {
$error = $mail->ErrorInfo;
die($error);
//return FALSE;
}
}
}
public function findAll($qbuilder)
{
if (UserSession::getInstance()->getAccessLevel() < 3) {
die("<h1>Forbidden resource for you.</h1>");
}
@($dao = new DAO(TestProblems));
if (!isset($qbuilder)) {
$qbuilder = new QueryBuilder('testproblems');
$qbuilder->addOrder("tst_title", QueryBuilder::$ASC, 'test');
$qbuilder->addOrder("tpb_questionNumber", QueryBuilder::$ASC);
$qbuilder->addOrder("prb_title", QueryBuilder::$ASC, 'problem');
}
$qbuilder->addJoin("test", "tpb_tst_id", "tst_id");
$qbuilder->addJoin("problem", "tpb_prb_id", "prb_id");
$tproblems = $dao->findByQuery($qbuilder);
return $tproblems;
}
public function retrieve()
{
@($dao = new DAO(Problem));
$qbuilder = new QueryBuilder('problem');
$qbuilder->addEqual('prb_id', $this->params['prb_id']);
$problem = $dao->findByQuery($qbuilder);
return $problem[0];
}
public function findAll($qbuilder)
{
if (UserSession::getInstance()->getAccessLevel() < 3) {
die("<h1>Forbidden resource for you.</h1>");
}
@($dao = new DAO(EvaluationCase));
if (!isset($qbuilder)) {
$qbuilder = new QueryBuilder('evaluationcase');
$qbuilder->addOrder("prb_title", QueryBuilder::$ASC, 'discipline');
$qbuilder->addOrder("evc_id", QueryBuilder::$ASC);
}
$qbuilder->addJoin("problem", "evc_prb_id", "prb_id");
$ecases = $dao->findByQuery($qbuilder);
return $ecases;
}
