public function EntityLegalDocumentVersion::query in Entity Legal 3.0.x

Same name and namespace in other branches

1. 8.2 src/Plugin/migrate/source/EntityLegalDocumentVersion.php \Drupal\entity_legal\Plugin\migrate\source\EntityLegalDocumentVersion::query()
2. 4.0.x src/Plugin/migrate/source/EntityLegalDocumentVersion.php \Drupal\entity_legal\Plugin\migrate\source\EntityLegalDocumentVersion::query()

Return value

\Drupal\Core\Database\Query\SelectInterface

Overrides SqlBase::query

File

src/Plugin/migrate/source/EntityLegalDocumentVersion.php, line 21

Class

EntityLegalDocumentVersion

Drupal entity legal document version migration source plugin.

Namespace

Drupal\entity_legal\Plugin\migrate\source

Code

public function query() {
  $query = $this
    ->select('entity_legal_document_version', 'v')
    ->fields('v');
  $query
    ->join('entity_legal_document', 'd', 'v.document_name = d.name');
  $query
    ->addExpression('IF(d.published_version = v.vid, 1, 0)', 'published');
  return $query;
}