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; }