View source
<?php
namespace Drupal\block\Plugin\migrate\source\d7;
use Drupal\block\Plugin\migrate\source\Block;
class BlockTranslation extends Block {
public function query() {
parent::query();
$query = $this
->select('i18n_string', 'i18n')
->fields('i18n')
->fields('b', [
'bid',
'module',
'delta',
'theme',
'status',
'weight',
'region',
'custom',
'visibility',
'pages',
'title',
'cache',
'i18n_mode',
])
->fields('lt', [
'lid',
'translation',
'language',
'plid',
'plural',
])
->condition('i18n_mode', 1);
$query
->leftjoin($this->blockTable, 'b', '[b].[delta] = [i18n].[objectid]');
$query
->innerJoin('locales_target', 'lt', '[lt].[lid] = [i18n].[lid]');
if ($this
->getDatabase()
->schema()
->fieldExists('locales_target', 'status')) {
$query
->addField('lt', 'status', 'i18n_status');
}
if ($this
->getDatabase()
->schema()
->fieldExists('locales_target', 'i18n_status')) {
$query
->addField('lt', 'i18n_status', 'i18n_status');
}
return $query;
}
public function fields() {
return [
'bid' => $this
->t('The block numeric identifier.'),
'module' => $this
->t('The module providing the block.'),
'delta' => $this
->t("The block's delta."),
'theme' => $this
->t('Which theme the block is placed in.'),
'status' => $this
->t('Block enabled status'),
'weight' => $this
->t('Block weight within region'),
'region' => $this
->t('Theme region within which the block is set'),
'visibility' => $this
->t('Visibility'),
'pages' => $this
->t('Pages list.'),
'title' => $this
->t('Block title.'),
'cache' => $this
->t('Cache rule.'),
'i18n_mode' => $this
->t('Multilingual mode'),
'lid' => $this
->t('Language string ID'),
'textgroup' => $this
->t('A module defined group of translations'),
'context' => $this
->t('Full string ID for quick search: type:objectid:property.'),
'objectid' => $this
->t('Object ID'),
'type' => $this
->t('Object type for this string'),
'property' => $this
->t('Object property for this string'),
'objectindex' => $this
->t('Integer value of Object ID'),
'format' => $this
->t('The {filter_format}.format of the string'),
'translation' => $this
->t('Translation'),
'language' => $this
->t('Language code'),
'plid' => $this
->t('Parent lid'),
'plural' => $this
->t('Plural index number'),
'i18n_status' => $this
->t('Translation needs update'),
];
}
public function getIds() {
$ids['delta']['type'] = 'string';
$ids['delta']['alias'] = 'b';
$ids['language']['type'] = 'string';
return $ids;
}
}