3 namespace Drupal\user\Plugin\migrate\source\d7;
5 use Drupal\migrate\Row;
6 use Drupal\migrate_drupal\Plugin\migrate\source\d7\FieldableEntity;
9 * Drupal 7 user source from database.
13 * source_module = "user"
16 class User extends FieldableEntity {
21 public function query() {
22 return $this->select('users', 'u')
24 ->condition('u.uid', 0, '>');
30 public function fields() {
32 'uid' => $this->t('User ID'),
33 'name' => $this->t('Username'),
34 'pass' => $this->t('Password'),
35 'mail' => $this->t('Email address'),
36 'signature' => $this->t('Signature'),
37 'signature_format' => $this->t('Signature format'),
38 'created' => $this->t('Registered timestamp'),
39 'access' => $this->t('Last access timestamp'),
40 'login' => $this->t('Last login timestamp'),
41 'status' => $this->t('Status'),
42 'timezone' => $this->t('Timezone'),
43 'language' => $this->t('Language'),
44 'picture' => $this->t('Picture'),
45 'init' => $this->t('Init'),
46 'data' => $this->t('User data'),
47 'roles' => $this->t('Roles'),
51 if ($this->moduleExists('profile')) {
52 $fields += $this->select('profile_fields', 'pf')
53 ->fields('pf', ['name', 'title'])
64 public function prepareRow(Row $row) {
65 $uid = $row->getSourceProperty('uid');
67 $roles = $this->select('users_roles', 'ur')
68 ->fields('ur', ['rid'])
69 ->condition('ur.uid', $uid)
72 $row->setSourceProperty('roles', $roles);
74 $row->setSourceProperty('data', unserialize($row->getSourceProperty('data')));
76 // If this entity was translated using Entity Translation, we need to get
77 // its source language to get the field values in the right language.
78 // The translations will be migrated by the d7_user_entity_translation
80 $entity_translatable = $this->isEntityTranslatable('user');
81 $source_language = $this->getEntityTranslationSourceLanguage('user', $uid);
82 $language = $entity_translatable && $source_language ? $source_language : $row->getSourceProperty('language');
83 $row->setSourceProperty('entity_language', $language);
85 // Get Field API field values.
86 foreach ($this->getFields('user') as $field_name => $field) {
87 // Ensure we're using the right language if the entity and the field are
89 $field_language = $entity_translatable && $field['translatable'] ? $language : NULL;
90 $row->setSourceProperty($field_name, $this->getFieldValues('user', $field_name, $uid, NULL, $field_language));
93 // Get profile field values. This code is lifted directly from the D6
94 // ProfileFieldValues plugin.
95 if ($this->getDatabase()->schema()->tableExists('profile_value')) {
96 $query = $this->select('profile_value', 'pv')
97 ->fields('pv', ['fid', 'value']);
98 $query->leftJoin('profile_field', 'pf', 'pf.fid=pv.fid');
99 $query->fields('pf', ['name', 'type']);
100 $query->condition('uid', $row->getSourceProperty('uid'));
101 $results = $query->execute();
103 foreach ($results as $profile_value) {
104 if ($profile_value['type'] == 'date') {
105 $date = unserialize($profile_value['value']);
106 $date = date('Y-m-d', mktime(0, 0, 0, $date['month'], $date['day'], $date['year']));
107 $row->setSourceProperty($profile_value['name'], ['value' => $date]);
109 elseif ($profile_value['type'] == 'list') {
110 // Explode by newline and comma.
111 $row->setSourceProperty($profile_value['name'], preg_split("/[\r\n,]+/", $profile_value['value']));
114 $row->setSourceProperty($profile_value['name'], [$profile_value['value']]);
119 return parent::prepareRow($row);
125 public function getIds() {