当前位置: 首页>>代码示例>>PHP>>正文


PHP QueryBuilder::addJoin方法代码示例

本文整理汇总了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;
 }
开发者ID:renatorroliveira,项目名称:algod,代码行数:18,代码来源:TestLogBS.php

示例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;
 }
开发者ID:renatorroliveira,项目名称:algod,代码行数:13,代码来源:DisciplineBS.php

示例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;
 }
开发者ID:renatorroliveira,项目名称:algod,代码行数:17,代码来源:TestBS.php

示例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;
 }
开发者ID:renatorroliveira,项目名称:algod,代码行数:19,代码来源:TestTrialBS.php

示例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;
 }
开发者ID:renatorroliveira,项目名称:algod,代码行数:17,代码来源:TestProblemsBS.php

示例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;
 }
开发者ID:renatorroliveira,项目名称:algod,代码行数:18,代码来源:ProblemBS.php

示例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;
 }
开发者ID:renatorroliveira,项目名称:algod,代码行数:15,代码来源:EvaluationCaseBS.php


注:本文中的QueryBuilder::addJoin方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。