protected function Newsletter::query71 in Simplenews 3.x

Same name and namespace in other branches

1. 8.2 src/Plugin/migrate/source/d7/Newsletter.php \Drupal\simplenews\Plugin\migrate\source\d7\Newsletter::query71()
2. 8 src/Plugin/migrate/source/d7/Newsletter.php \Drupal\simplenews\Plugin\migrate\source\d7\Newsletter::query71()

Get query for Simplenews module version 7.x-1.x.

1 call to Newsletter::query71()

Newsletter::query in src/Plugin/migrate/source/d7/Newsletter.php

File

src/Plugin/migrate/source/d7/Newsletter.php, line 68

Class

Newsletter

Migration source for Newsletter entities in D7.

Namespace

Drupal\simplenews\Plugin\migrate\source\d7

Code

protected function query71() {
  $q = $this
    ->select('simplenews_category', 'c');
  $q
    ->innerJoin('taxonomy_term_data', 't', 't.tid = c.tid');
  $q
    ->fields('c', [
    'tid',
    'format',
    'priority',
    'receipt',
    'from_name',
    'email_subject',
    'from_address',
    'hyperlinks',
    'new_account',
    'access',
    'block',
  ]);
  $q
    ->fields('t', [
    'name',
    'description',
    'weight',
  ]);
  $q
    ->orderBy('c.tid');
  return $q;
}