public function ProductDisplay::query in Commerce Migrate 3.0.x

Same name and namespace in other branches

1. 8.2 modules/commerce/src/Plugin/migrate/source/commerce1/ProductDisplay.php \Drupal\commerce_migrate_commerce\Plugin\migrate\source\commerce1\ProductDisplay::query()
2. 3.1.x modules/commerce/src/Plugin/migrate/source/commerce1/ProductDisplay.php \Drupal\commerce_migrate_commerce\Plugin\migrate\source\commerce1\ProductDisplay::query()

Return value

\Drupal\Core\Database\Query\SelectInterface

Overrides SqlBase::query

File

modules/commerce/src/Plugin/migrate/source/commerce1/ProductDisplay.php, line 84

Class

ProductDisplay

DGets Commerce 1 commerce_line_item data from database.

Namespace

Drupal\commerce_migrate_commerce\Plugin\migrate\source\commerce1

Code

public function query() {
  $query = $this
    ->select('node', 'n');
  $query
    ->leftJoin('field_config_instance', 'fci', '(n.type = fci.bundle)');
  $query
    ->leftJoin('field_config', 'fc', '(fc.id = fci.field_id)');
  $query
    ->condition('fc.type', 'commerce_product_reference');
  $query
    ->fields('n', [
    'nid',
    'title',
    'type',
    'uid',
    'status',
    'created',
    'changed',
  ]);
  $query
    ->fields('fc', [
    'field_name',
  ]);
  if (isset($this->configuration['product_type'])) {
    $query
      ->condition('n.type', $this->configuration['product_type']);
  }
  return $query;
}