public function CiviCrmBridgeRelationshipBase::query in CiviCRM Entity 8.3

Add anything to the query that we might need to.

Overrides RelationshipPluginBase::query

File

src/Plugin/views/relationship/CiviCrmBridgeRelationshipBase.php, line 29

Class

CiviCrmBridgeRelationshipBase

Relationship for referencing two CiviCRM entities using a "bridge" table.

Namespace

Drupal\civicrm_entity\Plugin\views\relationship

Code

public function query() {
  $this
    ->ensureMyTable();
  $views_data = Views::viewsData()
    ->get($this->table);
  $left_field = $views_data['table']['base']['field'];
  $first = [
    'left_table' => $this->tableAlias,
    'left_field' => $left_field,
    'table' => $this->definition['table'],
    'field' => $this->definition['first field'],
    'adjusted' => TRUE,
  ];
  if (!empty($this->definition['extra'])) {
    $first['extra'] = $this->definition['extra'];
  }
  if (!empty($this->options['required'])) {
    $first['type'] = 'INNER';
  }
  $first_join = Views::pluginManager('join')
    ->createInstance('standard', $first);
  $first_alias = $this->query
    ->addTable($this->definition['table'], $this->relationship, $first_join);

  // Relate the first join to the base table defined.
  $second = [
    'left_table' => $first_alias,
    'left_field' => $this->definition['second field'],
    'table' => $this->definition['base'],
    'field' => $this->definition['base field'],
    'adjusted' => TRUE,
  ];
  if (!empty($this->options['required'])) {
    $second['type'] = 'INNER';
  }
  $second_join = Views::pluginManager('join')
    ->createInstance('standard', $second);
  $second_join->adjusted = TRUE;
  $alias = $this->definition['base'] . '_' . $this->definition['table'];
  $this->alias = $this->query
    ->addRelationship($alias, $second_join, $this->definition['base'], $this->relationship);
}