PHP SelectInterface::addJoin方法代码示例

 protected function addJoin($type, $table, $join_condition, $langcode)
 {
     $arguments = array();
     if ($langcode) {
         $placeholder = ':langcode' . $this->sqlQuery->nextPlaceholder();
         $join_condition .= ' AND %alias.langcode = ' . $placeholder;
         $arguments[$placeholder] = $langcode;
     }
     return $this->sqlQuery->addJoin($type, $table, NULL, $join_condition, $arguments);
 }

 protected function addJoin($type, $table, $join_condition, $langcode)
 {
     $arguments = array();
     if ($langcode) {
         $entity_type_id = $this->sqlQuery->getMetaData('entity_type');
         $entity_type = $this->entityManager->getDefinition($entity_type_id);
         // Only the data table follows the entity language key, dedicated field
         // tables have an hard-coded 'langcode' column.
         $langcode_key = $entity_type->getDataTable() == $table ? $entity_type->getKey('langcode') : 'langcode';
         $placeholder = ':langcode' . $this->sqlQuery->nextPlaceholder();
         $join_condition .= ' AND %alias.' . $langcode_key . ' = ' . $placeholder;
         $arguments[$placeholder] = $langcode;
     }
     return $this->sqlQuery->addJoin($type, $table, NULL, $join_condition, $arguments);
 }

 /**
  * Builds the SQL for the join this object represents.
  *
  * @param \Drupal\Core\Database\Query\SelectInterface $select_query
  *   The select query object.
  * @param string $table
  *   The base table to join.
  * @param \Drupal\views\Plugin\views\query\QueryPluginBase $view_query
  *   The source views query.
  */
 public function buildJoin($select_query, $table, $view_query)
 {
     if (empty($this->configuration['table formula'])) {
         $right_table = "{" . $this->table . "}";
     } else {
         $right_table = $this->configuration['table formula'];
     }
     // Add our join condition, using a subquery on the left instead of a field.
     $condition = "({$this->left_query}) = {$table['alias']}.{$this->field}";
     $arguments = array();
     // Tack on the extra.
     // This is just copied verbatim from the parent class, which itself has a
     //   bug: https://www.drupal.org/node/1118100.
     if (isset($this->extra)) {
         if (is_array($this->extra)) {
             $extras = array();
             foreach ($this->extra as $info) {
                 // Figure out the table name. Remember, only use aliases provided
                 // if at all possible.
                 $join_table = '';
                 if (!array_key_exists('table', $info)) {
                     $join_table = $table['alias'] . '.';
                 } elseif (isset($info['table'])) {
                     $join_table = $info['table'] . '.';
                 }
                 $placeholder = ':views_join_condition_' . $select_query->nextPlaceholder();
                 if (is_array($info['value'])) {
                     $operator = !empty($info['operator']) ? $info['operator'] : 'IN';
                     // Transform from IN() notation to = notation if just one value.
                     if (count($info['value']) == 1) {
                         $info['value'] = array_shift($info['value']);
                         $operator = $operator == 'NOT IN' ? '!=' : '=';
                     }
                 } else {
                     $operator = !empty($info['operator']) ? $info['operator'] : '=';
                 }
                 $extras[] = "{$join_table}{$info['field']} {$operator} {$placeholder}";
                 $arguments[$placeholder] = $info['value'];
             }
             if ($extras) {
                 if (count($extras) == 1) {
                     $condition .= ' AND ' . array_shift($extras);
                 } else {
                     $condition .= ' AND (' . implode(' ' . $this->extraOperator . ' ', $extras) . ')';
                 }
             }
         } elseif ($this->extra && is_string($this->extra)) {
             $condition .= " AND ({$this->extra})";
         }
     }
     $select_query->addJoin($this->type, $right_table, $table['alias'], $condition, $arguments);
 }

 public function addJoin($type, $table, $alias = NULL, $condition = NULL, $arguments = array())
 {
     return $this->query->addJoin($type, $table, $alias, $condition, $arguments);
 }