public function MerciReservation::query in MERCI (Manage Equipment Reservations, Checkout and Inventory) 8.2
Return value
\Drupal\Core\Database\Query\SelectInterface
Overrides SqlBase::query
File
- modules/
merci_migration/ src/ Plugin/ migrate/ source/ d7/ MerciReservation.php, line 59
Class
- MerciReservation
- Drupal 7 node source from database.
Namespace
Drupal\merci_migration\Plugin\migrate\source\d7Code
public function query() {
// Select node in its last revision.
$query = $this
->select('node_revision', 'nr')
->fields('n', [
'nid',
'type',
'language',
'status',
'created',
'changed',
'comment',
'promote',
'sticky',
'tnid',
'translate',
])
->fields('nr', [
'vid',
'title',
'log',
'timestamp',
]);
$query
->addField('n', 'uid', 'node_uid');
$query
->addField('nr', 'uid', 'revision_uid');
$query
->innerJoin('node', 'n', static::JOIN);
// If the content_translation module is enabled, get the source langcode
// to fill the content_translation_source field.
if ($this->moduleHandler
->moduleExists('content_translation')) {
$query
->leftJoin('node', 'nt', 'n.tnid = nt.nid');
$query
->addField('nt', 'language', 'source_langcode');
}
$this
->handleTranslations($query);
if (isset($this->configuration['node_type'])) {
$query
->condition('n.type', $this->configuration['node_type']);
}
return $query;
}