public function FieldablePanelsPaneEntityTranslation::query in Fieldable Panels Panes (FPP) 1.0.x

Return value

\Drupal\Core\Database\Query\SelectInterface

Overrides SqlBase::query

File

src/Plugin/migrate/source/d7/FieldablePanelsPaneEntityTranslation.php, line 21

Class

FieldablePanelsPaneEntityTranslation

Provides Drupal 7 node entity translations source plugin.

Namespace

Drupal\fieldable_panels_panes\Plugin\migrate\source\d7

Code

public function query() {
  $query = $this
    ->select('entity_translation', 'et')
    ->fields('et')
    ->fields('fpp', [
    'title',
    'bundle',
  ])
    ->fields('fppr', [
    'log',
    'timestamp',
  ])
    ->condition('et.entity_type', 'fieldable_panels_pane')
    ->condition('et.source', '', '<>');
  $query
    ->addField('fppr', 'uid', 'revision_uid');
  $query
    ->innerJoin('fieldable_panels_panes', 'fpp', 'fpp.fpid = et.entity_id');
  $query
    ->innerJoin('fieldable_panels_panes_revision', 'fppr', 'fppr.vid = et.revision_id');
  if (isset($this->configuration['bundle'])) {
    $query
      ->condition('fpp.bundle', $this->configuration['bundle']);
  }
  return $query;
}