public function GroupwiseMax::query in Drupal 8

Same name and namespace in other branches

1. 9 core/modules/views/src/Plugin/views/relationship/GroupwiseMax.php \Drupal\views\Plugin\views\relationship\GroupwiseMax::query()

Add anything to the query that we might need to.

Overrides RelationshipPluginBase::query

File

core/modules/views/src/Plugin/views/relationship/GroupwiseMax.php, line 338

Class

GroupwiseMax

Relationship handler that allows a groupwise maximum of the linked in table. For a definition, see: http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.... In lay terms, instead of joining to get all matching records in the…

Namespace

Drupal\views\Plugin\views\relationship

Code

public function query() {

  // Figure out what base table this relationship brings to the party.
  $table_data = Views::viewsData()
    ->get($this->definition['base']);
  $base_field = empty($this->definition['base field']) ? $table_data['table']['base']['field'] : $this->definition['base field'];
  $this
    ->ensureMyTable();
  $def = $this->definition;
  $def['table'] = $this->definition['base'];
  $def['field'] = $base_field;
  $def['left_table'] = $this->tableAlias;
  $def['left_field'] = $this->field;
  $def['adjusted'] = TRUE;
  if (!empty($this->options['required'])) {
    $def['type'] = 'INNER';
  }
  if ($this->options['subquery_regenerate']) {

    // For testing only, regenerate the subquery each time.
    $def['left_query'] = $this
      ->leftQuery($this->options);
  }
  else {

    // Get the stored subquery SQL string.
    $cid = 'views_relationship_groupwise_max:' . $this->view->storage
      ->id() . ':' . $this->view->current_display . ':' . $this->options['id'];
    $cache = \Drupal::cache('data')
      ->get($cid);
    if (isset($cache->data)) {
      $def['left_query'] = $cache->data;
    }
    else {
      $def['left_query'] = $this
        ->leftQuery($this->options);
      \Drupal::cache('data')
        ->set($cid, $def['left_query']);
    }
  }
  if (!empty($def['join_id'])) {
    $id = $def['join_id'];
  }
  else {
    $id = 'subquery';
  }
  $join = Views::pluginManager('join')
    ->createInstance($id, $def);

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