public function CourseType::query in Course 3.x

Return value

\Drupal\Core\Database\Query\SelectInterface

Overrides SqlBase::query

File

modules/course_migrate/src/Plugin/migrate/source/CourseType.php, line 21

Class

CourseType

Drupal 7 course source from database.

Namespace

Drupal\course_migrate\Plugin\migrate\source

Code

public function query() {
  $course_types = [];
  $query = $this
    ->select('node_type', 'nt')
    ->fields('nt', [
    'type',
    'name',
  ]);
  $result = $query
    ->execute();
  while ($row = $result
    ->fetch()) {
    if ($this
      ->variableGet("course_use_" . $row['type'], 0) == 1) {
      $course_types[] = $row['type'];
    }
  }
  $query = $this
    ->select('node_type', 'nt')
    ->fields('nt', [
    'type',
    'name',
  ]);
  $query
    ->condition('type', $course_types, 'in');
  return $query;
}