function MenuLink::query

Overrides SqlBase::query

File

core/modules/menu_link_content/src/Plugin/migrate/source/MenuLink.php, line 53

Class

MenuLink

Drupal 6/7 menu link source from database.

Namespace

Code

public function query() {
    $query = $this->select('menu_links', 'ml')
        ->fields('ml')
        ->condition('ml.menu_name', 'shortcut-set-%', 'NOT LIKE');
    $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;
}