View source
<?php
namespace Drupal\user\Plugin\migrate\source\d6;
use Drupal\migrate\Row;
use Drupal\migrate_drupal\Plugin\migrate\source\DrupalSqlBase;
class User extends DrupalSqlBase {
public function query() {
return $this
->select('users', 'u')
->fields('u', array_keys($this
->baseFields()))
->condition('uid', 0, '>');
}
public function fields() {
$fields = $this
->baseFields();
$fields['roles'] = $this
->t('Roles');
if ($this
->moduleExists('profile')) {
$fields += $this
->select('profile_fields', 'pf')
->fields('pf', array(
'name',
'title',
))
->execute()
->fetchAllKeyed();
}
return $fields;
}
public function prepareRow(Row $row) {
$roles = $this
->select('users_roles', 'ur')
->fields('ur', array(
'rid',
))
->condition('ur.uid', $row
->getSourceProperty('uid'))
->execute()
->fetchCol();
$row
->setSourceProperty('roles', $roles);
if ($row
->hasSourceProperty('timezone_id') && $row
->getSourceProperty('timezone_id')) {
if ($this
->getDatabase()
->schema()
->tableExists('event_timezones')) {
$event_timezone = $this
->select('event_timezones', 'e')
->fields('e', array(
'name',
))
->condition('e.timezone', $row
->getSourceProperty('timezone_id'))
->execute()
->fetchField();
if ($event_timezone) {
$row
->setSourceProperty('event_timezone', $event_timezone);
}
}
}
$row
->setSourceProperty('data', unserialize($row
->getSourceProperty('data')));
return parent::prepareRow($row);
}
public function getIds() {
return array(
'uid' => array(
'type' => 'integer',
'alias' => 'u',
),
);
}
protected function baseFields() {
$fields = array(
'uid' => $this
->t('User ID'),
'name' => $this
->t('Username'),
'pass' => $this
->t('Password'),
'mail' => $this
->t('Email address'),
'signature' => $this
->t('Signature'),
'signature_format' => $this
->t('Signature format'),
'created' => $this
->t('Registered timestamp'),
'access' => $this
->t('Last access timestamp'),
'login' => $this
->t('Last login timestamp'),
'status' => $this
->t('Status'),
'timezone' => $this
->t('Timezone'),
'language' => $this
->t('Language'),
'picture' => $this
->t('Picture'),
'init' => $this
->t('Init'),
'data' => $this
->t('User data'),
);
if ($this
->getDatabase()
->schema()
->fieldExists('users', 'timezone_name')) {
$fields['timezone_name'] = $this
->t('Timezone (Date)');
}
if ($this
->getDatabase()
->schema()
->fieldExists('users', 'timezone_id')) {
$fields['timezone_id'] = $this
->t('Timezone (Event)');
}
return $fields;
}
}