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