public function EntityReverse::query in Views (for Drupal 7) 8.3

Called to implement a relationship in a query.

Overrides RelationshipPluginBase::query

File

lib/Views/field/Plugin/views/relationship/EntityReverse.php, line 35

Definition of Views\field\Plugin\views\relationship\EntityReverse.

Class

EntityReverse

A relationship handlers which reverse entity references.

Namespace

Views\field\Plugin\views\relationship

Code

public function query() {
  $this
    ->ensureMyTable();

  // First, relate our base table to the current base table to the
  // field, using the base table's id field to the field's column.
  $views_data = views_fetch_data($this->table);
  $left_field = $views_data['table']['base']['field'];
  $first = array(
    'left_table' => $this->tableAlias,
    'left_field' => $left_field,
    'table' => $this->definition['field table'],
    'field' => $this->definition['field field'],
    'adjusted' => TRUE,
  );
  if (!empty($this->options['required'])) {
    $first['type'] = 'INNER';
  }
  if (!empty($this->definition['join_extra'])) {
    $first['extra'] = $this->definition['join_extra'];
  }
  if (!empty($def['join_id'])) {
    $id = $def['join_id'];
  }
  else {
    $id = 'standard';
  }
  $first_join = drupal_container()
    ->get('plugin.manager.views.join')
    ->createInstance($id, $first);
  $this->first_alias = $this->query
    ->add_table($this->definition['field table'], $this->relationship, $first_join);

  // Second, relate the field table to the entity specified using
  // the entity id on the field table and the entity's id field.
  $second = array(
    'left_table' => $this->first_alias,
    'left_field' => 'entity_id',
    'table' => $this->definition['base'],
    'field' => $this->definition['base field'],
    'adjusted' => TRUE,
  );
  if (!empty($this->options['required'])) {
    $second['type'] = 'INNER';
  }
  if (!empty($def['join_id'])) {
    $id = $def['join_id'];
  }
  else {
    $id = 'standard';
  }
  $second_join = drupal_container()
    ->get('plugin.manager.views.join')
    ->createInstance($id, $second);
  $second_join->adjusted = TRUE;

  // use a short alias for this:
  $alias = $this->definition['field_name'] . '_' . $this->table;
  $this->alias = $this->query
    ->add_relationship($alias, $second_join, $this->definition['base'], $this->relationship);
}