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