function Vid::titleQuery

Override the behavior of title(). Get the title of the revision.

Overrides NumericArgument::titleQuery

File

core/modules/node/src/Plugin/views/argument/Vid.php, line 68

Class

Vid

Argument handler to accept a node revision id.

Namespace

Code

public function titleQuery() {
    $titles = [];
    $results = $this->database
        ->query('SELECT nr.vid, nr.nid, npr.title FROM {node_revision} nr WHERE nr.vid IN ( :vids[] )', [
        ':vids[]' => $this->value,
    ])
        ->fetchAllAssoc('vid', PDO::FETCH_ASSOC);
    $nids = [];
    foreach ($results as $result) {
        $nids[] = $result['nid'];
    }
    $nodes = $this->nodeStorage
        ->loadMultiple(array_unique($nids));
    foreach ($results as $result) {
        $nodes[$result['nid']]->set('title', $result['title']);
        $titles[] = $nodes[$result['nid']]->label();
    }
    return $titles;
}