function NodeComplete::query

Overrides Node::query

File

core/modules/node/src/Plugin/migrate/source/d7/NodeComplete.php, line 33

Class

NodeComplete

Drupal 7 all node revisions source, including translation revisions.

Namespace

Code

public function query() {
    $query = parent::query();
    $query->orderBy('nr.vid');
    // Get any entity translation revision data.
    if ($this->getDatabase()
        ->schema()
        ->tableExists('entity_translation_revision')) {
        $query->leftJoin('entity_translation_revision', 'etr', '[nr].[nid] = [etr].[entity_id] AND [nr].[vid] = [etr].[revision_id]');
        $query->fields('etr', [
            'entity_type',
            'entity_id',
            'revision_id',
            'source',
            'translate',
        ]);
        $conditions = $query->orConditionGroup();
        $conditions->condition('etr.entity_type', 'node');
        $conditions->isNull('etr.entity_type');
        $query->condition($conditions);
        $query->addExpression("COALESCE([etr].[language], [n].[language])", 'language');
        $query->addField('etr', 'uid', 'etr_uid');
        $query->addField('etr', 'status', 'etr_status');
        $query->addField('etr', 'created', 'etr_created');
        $query->addField('etr', 'changed', 'etr_changed');
        $query->orderBy('etr.revision_id');
        $query->orderBy('etr.language');
    }
    return $query;
}