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

Same name and namespace in other branches

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

Return value

\Drupal\Core\Database\Query\SelectInterface

Overrides SqlBase::query

File

modules/commerce/src/Plugin/migrate/source/commerce1/ProductDisplayType.php, line 53

Class

ProductDisplayType

Gets Commerce 1 commerce_product_type data from database.

Namespace

Drupal\commerce_migrate_commerce\Plugin\migrate\source\commerce1

Code

public function query() {
  $query = $this
    ->select('field_config', 'fc');
  $query
    ->leftJoin('field_config_instance', 'fci', '(fci.field_id = fc.id)');
  $query
    ->leftJoin('node_type', 'nt', '(nt.type = fci.bundle)');
  $query
    ->condition('fc.type', 'commerce_product_reference')
    ->condition('fc.active', 1)
    ->condition('fci.entity_type', 'node')
    ->condition('nt.disabled', 0);
  $query
    ->fields('fc', [
    'field_name',
  ])
    ->fields('fci', [
    'data',
  ])
    ->fields('nt', [
    'type',
    'name',
    'description',
    'help',
  ]);
  return $query;
}