View source
<?php
namespace Drupal\field\Plugin\migrate\source\d7;
use Drupal\migrate\Row;
use Drupal\migrate_drupal\Plugin\migrate\source\DrupalSqlBase;
class FieldInstance extends DrupalSqlBase {
public function query() {
$query = $this
->select('field_config_instance', 'fci')
->fields('fci')
->fields('fc', [
'type',
'translatable',
])
->condition('fc.active', 1)
->condition('fc.storage_active', 1)
->condition('fc.deleted', 0)
->condition('fci.deleted', 0);
$query
->join('field_config', 'fc', '[fci].[field_id] = [fc].[id]');
if (isset($this->configuration['entity_type'])) {
$query
->condition('fci.entity_type', $this->configuration['entity_type']);
if (isset($this->configuration['bundle'])) {
$query
->condition('fci.bundle', $this->configuration['bundle']);
}
}
if ($this
->moduleExists('title')) {
$title_fields = [
'title_field',
'name_field',
'description_field',
'subject_field',
];
$query
->condition('fc.field_name', $title_fields, 'NOT IN');
}
return $query;
}
protected function initializeIterator() {
$results = $this
->prepareQuery()
->execute()
->fetchAll();
$instances = [];
foreach ($results as $result) {
$instances[$result['field_id']][] = $result;
}
$rows = [];
foreach ($results as $result) {
$result['instances'] = $instances[$result['field_id']];
$rows[] = $result;
}
return new \ArrayIterator($rows);
}
public function fields() {
return [
'id' => $this
->t('The field instance ID.'),
'field_id' => $this
->t('The field ID.'),
'field_name' => $this
->t('The field name.'),
'entity_type' => $this
->t('The entity type.'),
'bundle' => $this
->t('The entity bundle.'),
'data' => $this
->t('The field instance data.'),
'deleted' => $this
->t('Deleted'),
'type' => $this
->t('The field type'),
'instances' => $this
->t('The field instances.'),
'field_definition' => $this
->t('The field definition.'),
];
}
public function prepareRow(Row $row) {
foreach (unserialize($row
->getSourceProperty('data')) as $key => $value) {
$row
->setSourceProperty($key, $value);
}
$field_definition = $this
->select('field_config', 'fc')
->fields('fc')
->condition('id', $row
->getSourceProperty('field_id'))
->execute()
->fetch();
$row
->setSourceProperty('field_definition', $field_definition);
$translatable = FALSE;
if ($row
->getSourceProperty('entity_type') == 'node') {
$language_content_type_bundle = (int) $this
->variableGet('language_content_type_' . $row
->getSourceProperty('bundle'), 0);
if ($language_content_type_bundle === 2 || $language_content_type_bundle === 4 && $row
->getSourceProperty('translatable')) {
$translatable = TRUE;
}
}
else {
$field_data = unserialize($field_definition['data']);
$translatable = $field_data['translatable'];
}
$synchronized_fields = $this
->variableGet('i18n_sync_node_type_' . $row
->getSourceProperty('bundle'), NULL);
if ($synchronized_fields) {
if (in_array($row
->getSourceProperty('field_name'), $synchronized_fields)) {
$translatable = FALSE;
}
}
$row
->setSourceProperty('translatable', $translatable);
if ($row
->getSourceProperty('type') == 'taxonomy_term_reference') {
$vocabulary = [];
$data = unserialize($field_definition['data']);
foreach ($data['settings']['allowed_values'] as $allowed_value) {
$vocabulary[] = $allowed_value['vocabulary'];
}
$query = $this
->select('taxonomy_vocabulary', 'v')
->fields('v', [
'vid',
])
->condition('machine_name', $vocabulary, 'IN');
$allowed_vid = $query
->execute()
->fetchAllAssoc('vid');
$row
->setSourceProperty('allowed_vid', $allowed_vid);
if ($this
->getDatabase()
->schema()
->fieldExists('taxonomy_vocabulary', 'i18n_mode')) {
$query = $this
->select('taxonomy_vocabulary', 'v')
->fields('v', [
'i18n_mode',
])
->condition('machine_name', $vocabulary, 'IN');
$results = $query
->execute()
->fetchAllAssoc('i18n_mode');
$translatable = FALSE;
foreach ($results as $result) {
if ($result['i18n_mode'] == '2' || $result['i18n_mode'] == '4') {
$translatable = TRUE;
}
}
$row
->setSourceProperty('translatable', $translatable);
}
}
if ($row
->getSourceProperty('type') == 'user_reference') {
$data = unserialize($field_definition['data']);
if (!empty($data['settings']['referenceable_roles'])) {
$rid = $data['settings']['referenceable_roles'];
$query = $this
->select('role', 'r')
->fields('r')
->condition('rid', $rid, 'IN');
$results = $query
->execute()
->fetchAll();
$row
->setSourceProperty('roles', $results);
}
}
return parent::prepareRow($row);
}
public function getIds() {
return [
'entity_type' => [
'type' => 'string',
'alias' => 'fci',
],
'bundle' => [
'type' => 'string',
'alias' => 'fci',
],
'field_name' => [
'type' => 'string',
'alias' => 'fci',
],
];
}
protected function doCount() {
return $this
->initializeIterator()
->count();
}
}