View source
<?php
namespace Drupal\user\Plugin\migrate\source\d7;
use Drupal\migrate\Row;
use Drupal\migrate_drupal\Plugin\migrate\source\d7\FieldableEntity;
class User extends FieldableEntity {
public function query() {
return $this
->select('users', 'u')
->fields('u')
->condition('u.uid', 0, '>');
}
public function fields() {
$fields = [
'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'),
'roles' => $this
->t('Roles'),
];
if ($this
->moduleExists('profile')) {
$fields += $this
->select('profile_fields', 'pf')
->fields('pf', [
'name',
'title',
])
->execute()
->fetchAllKeyed();
}
return $fields;
}
public function prepareRow(Row $row) {
$uid = $row
->getSourceProperty('uid');
$roles = $this
->select('users_roles', 'ur')
->fields('ur', [
'rid',
])
->condition('ur.uid', $uid)
->execute()
->fetchCol();
$row
->setSourceProperty('roles', $roles);
$row
->setSourceProperty('data', unserialize($row
->getSourceProperty('data') ?? ''));
$entity_translatable = $this
->isEntityTranslatable('user');
$source_language = $this
->getEntityTranslationSourceLanguage('user', $uid);
$language = $entity_translatable && $source_language ? $source_language : $row
->getSourceProperty('language');
$row
->setSourceProperty('entity_language', $language);
foreach ($this
->getFields('user') as $field_name => $field) {
$field_language = $entity_translatable && $field['translatable'] ? $language : NULL;
$row
->setSourceProperty($field_name, $this
->getFieldValues('user', $field_name, $uid, NULL, $field_language));
}
if ($this
->getDatabase()
->schema()
->tableExists('profile_value')) {
$query = $this
->select('profile_value', 'pv')
->fields('pv', [
'fid',
'value',
]);
$query
->leftJoin('profile_field', 'pf', '[pf].[fid] = [pv].[fid]');
$query
->fields('pf', [
'name',
'type',
]);
$query
->condition('uid', $row
->getSourceProperty('uid'));
$results = $query
->execute();
foreach ($results as $profile_value) {
if ($profile_value['type'] == 'date') {
$date = unserialize($profile_value['value']);
$date = date('Y-m-d', mktime(0, 0, 0, $date['month'], $date['day'], $date['year']));
$row
->setSourceProperty($profile_value['name'], [
'value' => $date,
]);
}
elseif ($profile_value['type'] == 'list') {
$row
->setSourceProperty($profile_value['name'], preg_split("/[\r\n,]+/", $profile_value['value']));
}
else {
$row
->setSourceProperty($profile_value['name'], [
$profile_value['value'],
]);
}
}
}
return parent::prepareRow($row);
}
public function getIds() {
return [
'uid' => [
'type' => 'integer',
'alias' => 'u',
],
];
}
}