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 findNotDeleted($qbuilder) { @($dao = new DAO(Discipline)); if (!isset($qbuilder)) { $qbuilder = new QueryBuilder('discipline'); $qbuilder->addOrder("dsc_code", QueryBuilder::$ASC); $qbuilder->addOrder("dsc_name", QueryBuilder::$ASC); } $qbuilder->addJoin("user", "dsc_usr_id", "usr_id"); $qbuilder->addEqual("dsc_deleted", 0, 'discipline'); $disciplines = $dao->findByQuery($qbuilder); return $disciplines; }
public function findAll($qbuilder) { if (UserSession::getInstance()->getAccessLevel() < 3) { die("<h1>Forbidden resource for you.</h1>"); } @($dao = new DAO(Test)); if (!isset($qbuilder)) { $qbuilder = new QueryBuilder('test'); $qbuilder->addOrder("dsc_code", QueryBuilder::$ASC, 'discipline'); $qbuilder->addOrder("tst_title", QueryBuilder::$ASC); } $qbuilder->addJoin("discipline", "tst_dsc_id", "dsc_id"); $qbuilder->addLeftJoin("testproblems", "tst_id", "tpb_tst_id"); $qbuilder->addGroupBy("tst_id", "test"); $tests = $dao->findByQueryWithMetaFields($qbuilder); return $tests; }
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 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 findAll($qbuilder) { if (UserSession::getInstance()->getAccessLevel() < 3) { die("<h1>Forbidden resource for you.</h1>"); } @($dao = new DAO(Problem)); if (!isset($qbuilder)) { $qbuilder = new QueryBuilder('problem'); $qbuilder->addOrder("dsc_code", QueryBuilder::$ASC, 'discipline'); $qbuilder->addOrder("prb_difficultyLevel", QueryBuilder::$ASC); $qbuilder->addOrder("prb_title", QueryBuilder::$ASC); } $qbuilder->addJoin("discipline", "prb_dsc_id", "dsc_id"); $qbuilder->addLeftJoin("evaluationcase", "prb_id", "evc_prb_id"); $qbuilder->addGroupBy("prb_id", "problem"); $problems = $dao->findByQueryWithMetaFields($qbuilder); return $problems; }
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; }