PHP Doctrine_Query::leftJoin方法代碼示例

 public function listPeriodeFiliereRegion(Doctrine_Query $q)
 {
     $rootAlias = $q->getRootAlias();
     $q->leftJoin($rootAlias . '.CopisimFiliere c');
     $q->leftJoin($rootAlias . '.CopisimRegion d');
     return $q;
 }

 public function addProductTranslationJoin(Doctrine_Query $q, $lang = false)
 {
     if (!$lang) {
         return $q->leftJoin($q->getRootAlias() . '.Translation trans');
     } else {
         return $q->leftJoin($q->getRootAlias() . '.Translation trans WITH trans.lang = ?', $lang);
     }
 }

 public function retrieveAdminChargeList(Doctrine_Query $q)
 {
     $rootAlias = $q->getRootAlias();
     $q->leftJoin($rootAlias . '.Category ct');
     $q->leftJoin($rootAlias . '.Vehicle v');
     $q->andWhere('v.is_archived = ?', false);
     return $q;
 }

 function buildQuery(Doctrine_Query $query)
 {
     $query->leftJoin('swBlogPost.Translation');
     $query->leftJoin('swBlogPost.swBlogPostTags t');
     $query->leftJoin('t.Translation tt');
     if (strlen($this->getValue('tag')) > 0) {
         $query->addWhere('tt.name = ? and tt.lang = ?', array($this->getValue('tag'), sfContext::getInstance()->getUser()->getCulture()));
     }
     if (!is_null($this->getValue('published'))) {
         $query->addWhere('swBlogPost.published = ?', $this->getValue('published'));
     }
     $query->orderBy('created_at DESC');
     return $query;
 }

 public function filterByEditable(Doctrine_Query $q, $user_id = null)
 {
     if (is_null($user_id)) {
         $user_id = sfContext::getInstance()->getUser()->getGuardUser()->getId();
         if (sfContext::getInstance()->getUser()->hasCredential('admin')) {
             return;
         }
     }
     $rootAlias = $q->getRootAlias();
     $q->leftJoin($rootAlias . '.Categories c');
     $q->leftJoin('c.Users u');
     $q->leftJoin($rootAlias . '.Editors e');
     $q->addWhere('author_id = ? OR u.id = ? OR e.id = ?', array($user_id, $user_id, $user_id));
 }

 /**
  * Set Doctrine Query.
  *
  * Set the Doctrine Query Object and expand configuration with it's information.
  *
  * @param Doctrine_Query $query  Doctrine Query Object.
  * @param array          $filter Filter object to be processed to enrich the Query.
  *
  * @return void
  */
 public function setDoctrineQuery(Doctrine_Query $query, $filter)
 {
     $this->resetColumns();
     $this->_doctrineQuery = $query;
     $tables = $this->_getTableInformation();
     $aliasMap = $this->_doctrineQuery->getTableAliasMap();
     $tables = $this->_enrichTablesWithAlias($tables, $aliasMap);
     // FIXME assumes any dynamic relation with first table found on FROM
     $from = $this->_doctrineQuery->getDQLPart('from');
     $main = explode(' ', $from[0]);
     $main = $main[1];
     // adds the external relation aliases
     // depending on the filter object to process
     $joins = array();
     $this->_getFilterRelations($joins, $filter);
     // stores the tables => dynaalias
     $t = array();
     $a = 'dynajoin1';
     foreach ($joins as $join) {
         $alias = substr($join, 0, strpos($join, ':'));
         $t[$alias] = $a;
         // add the dynamic left join
         $this->_doctrineQuery->leftJoin("{$main}.{$alias} {$a}");
         $a++;
     }
     $this->_setColumnsFromDoctrineTables($tables, $t);
 }

 public function retrieveAsso(Doctrine_Query $q)
 {
     $alias = $q->getRootAlias();
     $q->select("{$alias}.name, {$alias}.login, {$alias}.description, {$alias}.logo, {$alias}.salle, {$alias}.phone, {$alias}.facebook, p.id, p.asso_id, p.couleur");
     $q->leftJoin("{$alias}.Pole p");
     return $q->fetchOne();
 }

 public function retrieveFolderList(Doctrine_Query $q)
 {
     $alias = $q->getRootAlias();
     $q->leftJoin($alias . '.Assets a');
     $q->orderBy($alias . '.lft');
     return $q;
 }

 /**
  * Query for uuser list
  * @param Doctrine_Query $q
  * @return Doctrine_Query
  */
 public function retrieveBackendUuserList(Doctrine_Query $q)
 {
     $rootAlias = $q->getRootAlias();
     $q->leftJoin($rootAlias . '.BalanceUser bu');
     $q->andWhere($rootAlias . '.utype=?', 'uuser');
     $q->andWhere($rootAlias . '.password IS NOT NULL');
     return $q;
 }

 public function addCodeColumnQuery(Doctrine_Query $query, $field, $values)
 {
     if ($values != "") {
         $alias = $query->getRootAlias();
         $conn_MGR = Doctrine_Manager::connection();
         $query->leftJoin($alias . '.SpecimensCodes cod')->andWhere("cod.referenced_relation = ?", array('specimens'))->andWhere("cod.record_id = {$alias}.id")->andWhere("cod.full_code_indexed = fullToIndex(" . $conn_MGR->quote($values, 'string') . ") ");
     }
     return $query;
 }

 public function addKernbegripListColumnQuery(Doctrine_Query $query, $field, $values)
 {
     if (!is_array($values)) {
         $values = array($values);
     }
     if (!count($values)) {
         return;
     }
     $query->leftJoin('r.expertKernbegrip expertKernbegrip')->andWhereIn('expertKernbegrip.kernbegrip_id', $values);
 }

 public function addAccepterListColumnQuery(Doctrine_Query $query, $field, $values)
 {
     if (!is_array($values)) {
         $values = array($values);
     }
     if (!count($values)) {
         return;
     }
     $query->leftJoin($query->getRootAlias() . '.Friend Friend')->andWhereIn('Friend.accepter_id', $values);
 }

 public function addTrackListColumnQuery(Doctrine_Query $query, $field, $values)
 {
     if (!is_array($values)) {
         $values = array($values);
     }
     if (!count($values)) {
         return;
     }
     $query->leftJoin($query->getRootAlias() . '.userPlaylist userPlaylist')->andWhereIn('userPlaylist.track_id', $values);
 }

 public function addVehiclesListColumnQuery(Doctrine_Query $query, $field, $values)
 {
     if (!is_array($values)) {
         $values = array($values);
     }
     if (!count($values)) {
         return;
     }
     $query->leftJoin($query->getRootAlias() . '.ReportVehicle ReportVehicle')->andWhereIn('ReportVehicle.vehicle_id', $values);
 }

 public function addProceduresListColumnQuery(Doctrine_Query $query, $field, $values)
 {
     if (!is_array($values)) {
         $values = array($values);
     }
     if (!count($values)) {
         return;
     }
     $query->leftJoin('r.UserProcedure UserProcedure')->andWhereIn('UserProcedure.procedure_id', $values);
 }