public function ProductDisplay::query in Commerce Migrate 8.2
Same name and namespace in other branches
- 3.1.x modules/commerce/src/Plugin/migrate/source/commerce1/ProductDisplay.php \Drupal\commerce_migrate_commerce\Plugin\migrate\source\commerce1\ProductDisplay::query()
- 3.0.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\commerce1Code
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;
}