function GroupwiseMax::query

Overrides RelationshipPluginBase::query

File

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

Class

GroupwiseMax

The relationship handler for groupwise maximum queries.

Namespace

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);
}