123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165 |
- <?php
- namespace Drupal\materio_migrate\Plugin\migrate\source;
- use Drupal\Core\Extension\ModuleHandlerInterface;
- use Drupal\migrate\Row;
- use Drupal\migrate_drupal\Plugin\migrate\source\d7\FieldableEntity;
- use Drupal\Core\Database\Query\SelectInterface;
- use Drupal\Core\Entity\EntityManagerInterface;
- use Drupal\Core\Extension\ModuleHandler;
- use Drupal\Core\State\StateInterface;
- use Drupal\migrate\Plugin\MigrationInterface;
- use Symfony\Component\DependencyInjection\ContainerInterface;
- /**
- * Drupal 7 node source from database.
- *
- * @MigrateSource(
- * id = "d7_simplenews_nodes",
- * source_module = "node"
- * )
- */
- class D7SimplenewsNodes extends FieldableEntity {
- /**
- * The module handler.
- *
- * @var \Drupal\Core\Extension\ModuleHandlerInterface
- */
- protected $moduleHandler;
- /**
- * {@inheritdoc}
- */
- public function __construct(array $configuration, $plugin_id, $plugin_definition, MigrationInterface $migration, StateInterface $state, EntityManagerInterface $entity_manager, ModuleHandlerInterface $module_handler) {
- parent::__construct($configuration, $plugin_id, $plugin_definition, $migration, $state, $entity_manager);
- $this->moduleHandler = $module_handler;
- }
- /**
- * {@inheritdoc}
- */
- public static function create(ContainerInterface $container, array $configuration, $plugin_id, $plugin_definition, MigrationInterface $migration = NULL) {
- return new static(
- $configuration,
- $plugin_id,
- $plugin_definition,
- $migration,
- $container->get('state'),
- $container->get('entity.manager'),
- $container->get('module_handler')
- );
- }
- /**
- * The join options between the node and the node_revisions table.
- */
- const JOIN = 'n.vid = nr.vid';
- /**
- * {@inheritdoc}
- */
- public function query() {
- // Select node in its last revision.
- $query = $this->select('node_revision', 'nr')
- ->fields('n', [
- 'nid',
- 'type',
- 'uid',
- 'language',
- 'status',
- 'created',
- 'changed',
- 'comment',
- 'promote',
- 'sticky',
- 'tnid',
- 'translate',
- ])
- ->fields('nr', [
- 'vid',
- 'title',
- 'log',
- 'timestamp',
- ])
- ->orderBy('changed');
- $query->innerJoin('node', 'n', static::JOIN);
- $query->addField('n', 'uid', 'node_uid');
- $query->addField('nr', 'uid', 'revision_uid');
- $query->innerJoin('simplenews_newsletter', 'snn', 'snn.nid = n.nid');
- $query->addField('snn', 'status', 'snn_status');
- $query->addField('snn', 'sent_subscriber_count', 'snn_sent_subscriber_count');
- if (isset($this->configuration['node_type'])) {
- $query->condition('n.type', $this->configuration['node_type']);
- }
- return $query;
- }
- /**
- * {@inheritdoc}
- */
- public function prepareRow(Row $row) {
- $nid = $row->getSourceProperty('nid');
- $vid = $row->getSourceProperty('vid');
- $type = $row->getSourceProperty('type');
- $title = $row->getSourceProperty('title');
- // drush_print('-- '.$nid."\t".$title);
- // Get Field API field values.
- foreach ($this->getFields('node', $type) as $field_name => $field) {
- $row->setSourceProperty($field_name, $this->getFieldValues('node', $field_name, $nid, $vid, 'und'));
- }
- // workflow
- $query = $this->select('workflow_node', 'wn');
- $query->fields('wn', ['sid']);
- $query->condition('wn.nid', $nid);
- $results = $query->execute()->fetchField();
- if(!$results){
- $results = 2;
- drush_print('WARNING: no workflow');
- }
- $row->setSourceProperty('workflow', $results);
- return parent::prepareRow($row);
- }
- /**
- * {@inheritdoc}
- */
- public function fields() {
- $fields = [
- 'nid' => $this->t('Node ID'),
- 'type' => $this->t('Type'),
- 'title' => $this->t('Title'),
- 'node_uid' => $this->t('Node authored by (uid)'),
- 'revision_uid' => $this->t('Revision authored by (uid)'),
- 'created' => $this->t('Created timestamp'),
- 'changed' => $this->t('Modified timestamp'),
- 'status' => $this->t('Published'),
- 'promote' => $this->t('Promoted to front page'),
- 'sticky' => $this->t('Sticky at top of lists'),
- 'revision' => $this->t('Create new revision'),
- 'language' => $this->t('Language (fr, en, ...)'),
- 'tnid' => $this->t('The translation set id for this node'),
- 'timestamp' => $this->t('The timestamp the latest revision of this node was created.'),
- ];
- return $fields;
- }
- /**
- * {@inheritdoc}
- */
- public function getIds() {
- $ids['nid']['type'] = 'integer';
- $ids['nid']['alias'] = 'n';
- return $ids;
- }
- }
|