View source
<?php
namespace Drupal\menu_link_content\Plugin\migrate\source;
use Drupal\Component\Utility\Unicode;
use Drupal\migrate_drupal\Plugin\migrate\source\DrupalSqlBase;
use Drupal\migrate\Row;
class MenuLink extends DrupalSqlBase {
public function query() {
$query = $this
->select('menu_links', 'ml')
->fields('ml');
$and = $query
->andConditionGroup()
->condition('ml.module', 'menu')
->condition('ml.router_path', [
'admin/build/menu-customize/%',
'admin/structure/menu/manage/%',
], 'NOT IN');
$condition = $query
->orConditionGroup()
->condition('ml.customized', 1)
->condition($and);
$query
->condition($condition);
if (isset($this->configuration['menu_name'])) {
$query
->condition('ml.menu_name', (array) $this->configuration['menu_name'], 'IN');
}
$query
->leftJoin('menu_links', 'pl', '[ml].[plid] = [pl].[mlid]');
$query
->addField('pl', 'link_path', 'parent_link_path');
$query
->orderBy('ml.depth');
$query
->orderby('ml.mlid');
return $query;
}
public function fields() {
$fields = [
'menu_name' => t("The menu name. All links with the same menu name (such as 'navigation') are part of the same menu."),
'mlid' => t('The menu link ID (mlid) is the integer primary key.'),
'plid' => t('The parent link ID (plid) is the mlid of the link above in the hierarchy, or zero if the link is at the top level in its menu.'),
'link_path' => t('The Drupal path or external path this link points to.'),
'router_path' => t('For links corresponding to a Drupal path (external = 0), this connects the link to a {menu_router}.path for joins.'),
'link_title' => t('The text displayed for the link, which may be modified by a title callback stored in {menu_router}.'),
'options' => t('A serialized array of options to set on the URL, such as a query string or HTML attributes.'),
'module' => t('The name of the module that generated this link.'),
'hidden' => t('A flag for whether the link should be rendered in menus. (1 = a disabled menu link that may be shown on admin screens, -1 = a menu callback, 0 = a normal, visible link)'),
'external' => t('A flag to indicate if the link points to a full URL starting with a protocol, like http:// (1 = external, 0 = internal).'),
'has_children' => t('Flag indicating whether any links have this link as a parent (1 = children exist, 0 = no children).'),
'expanded' => t('Flag for whether this link should be rendered as expanded in menus - expanded links always have their child links displayed, instead of only when the link is in the active trail (1 = expanded, 0 = not expanded)'),
'weight' => t('Link weight among links in the same menu at the same depth.'),
'depth' => t('The depth relative to the top level. A link with plid == 0 will have depth == 1.'),
'customized' => t('A flag to indicate that the user has manually created or edited the link (1 = customized, 0 = not customized).'),
'p1' => t('The first mlid in the materialized path. If N = depth, then pN must equal the mlid. If depth > 1 then p(N-1) must equal the plid. All pX where X > depth must equal zero. The columns p1 .. p9 are also called the parents.'),
'p2' => t('The second mlid in the materialized path. See p1.'),
'p3' => t('The third mlid in the materialized path. See p1.'),
'p4' => t('The fourth mlid in the materialized path. See p1.'),
'p5' => t('The fifth mlid in the materialized path. See p1.'),
'p6' => t('The sixth mlid in the materialized path. See p1.'),
'p7' => t('The seventh mlid in the materialized path. See p1.'),
'p8' => t('The eighth mlid in the materialized path. See p1.'),
'p9' => t('The ninth mlid in the materialized path. See p1.'),
'updated' => t('Flag that indicates that this link was generated during the update from Drupal 5.'),
];
$schema = $this
->getDatabase()
->schema();
if ($schema
->fieldExists('menu_links', 'language')) {
$fields['language'] = $this
->t("Menu link language code.");
}
if ($schema
->fieldExists('menu_links', 'i18n_tsid')) {
$fields['i18n_tsid'] = $this
->t("Translation set id.");
}
return $fields;
}
public function prepareRow(Row $row) {
if ($row
->hasSourceProperty('language') && $row
->getSourceProperty('language') == 'und' && $this
->hasTranslation($row
->getSourceProperty('mlid'))) {
$default_language = $this
->variableGet('language_default', (object) [
'language' => 'und',
]);
$default_language = $default_language->language;
$row
->setSourceProperty('language', $default_language);
}
$row
->setSourceProperty('skip_translation', TRUE);
if ($row
->hasSourceProperty('i18n_tsid') && $row
->getSourceProperty('i18n_tsid') != 0) {
$source_mlid = $this
->select('menu_links', 'ml')
->fields('ml', [
'mlid',
])
->condition('i18n_tsid', $row
->getSourceProperty('i18n_tsid'))
->orderBy('mlid')
->range(0, 1)
->execute()
->fetchField();
if ($source_mlid !== $row
->getSourceProperty('mlid')) {
$row
->setSourceProperty('skip_translation', FALSE);
}
}
$row
->setSourceProperty('is_localized', NULL);
$default_language = $this
->variableGet('language_default', (object) [
'language' => 'und',
]);
$default_language = $default_language->language;
$options = unserialize($row
->getSourceProperty('options'));
if (isset($options['langcode'])) {
if ($options['langcode'] != $default_language) {
$row
->setSourceProperty('language', $options['langcode']);
$row
->setSourceProperty('is_localized', 'localized');
}
}
$row
->setSourceProperty('options', unserialize($row
->getSourceProperty('options')));
$row
->setSourceProperty('enabled', !$row
->getSourceProperty('hidden'));
$description = $row
->getSourceProperty('options/attributes/title');
if ($description !== NULL) {
$row
->setSourceProperty('description', Unicode::truncate($description, 255));
}
return parent::prepareRow($row);
}
public function hasTranslation($mlid) {
if ($this
->getDatabase()
->schema()
->tableExists('i18n_string')) {
$results = $this
->select('i18n_string', 'i18n')
->fields('i18n')
->condition('textgroup', 'menu')
->condition('type', 'item')
->condition('objectid', $mlid)
->execute()
->fetchAll();
if ($results) {
return TRUE;
}
}
return FALSE;
}
public function getIds() {
$ids['mlid']['type'] = 'integer';
$ids['mlid']['alias'] = 'ml';
return $ids;
}
}
