本文整理汇总了PHP中QueryBuilder::addJoin方法的典型用法代码示例。如果您正苦于以下问题:PHP QueryBuilder::addJoin方法的具体用法?PHP QueryBuilder::addJoin怎么用?PHP QueryBuilder::addJoin使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类QueryBuilder
的用法示例。
在下文中一共展示了QueryBuilder::addJoin方法的7个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: findAll
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;
}
示例2: findNotDeleted
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;
}
示例3: findAll
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;
}
示例4: findAll
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;
}
示例5: findAll
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;
}
示例6: findAll
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;
}
示例7: findAll
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;
}