function MenuTreeStorage::getRootPathIds

Overrides MenuTreeStorageInterface::getRootPathIds

File

core/lib/Drupal/Core/Menu/MenuTreeStorage.php, line 780

Class

MenuTreeStorage

Provides a menu tree storage using the database.

Namespace

Code

public function getRootPathIds($id) {
    $subquery = $this->connection
        ->select($this->table, NULL, $this->options);
    // @todo Consider making this dynamic based on static::MAX_DEPTH or from the
    //   schema if that is generated using static::MAX_DEPTH.
    //   https://www.drupal.org/node/2302043
    $subquery->fields($this->table, [
        'p1',
        'p2',
        'p3',
        'p4',
        'p5',
        'p6',
        'p7',
        'p8',
        'p9',
    ]);
    $subquery->condition('id', $id);
    $result = current($subquery->execute()
        ->fetchAll(\PDO::FETCH_ASSOC));
    $ids = array_filter($result);
    if ($ids) {
        $query = $this->connection
            ->select($this->table, NULL, $this->options);
        $query->fields($this->table, [
            'id',
        ]);
        $query->orderBy('depth', 'DESC');
        $query->condition('mlid', $ids, 'IN');
        // @todo Cache this result in memory if we find it is being used more
        //   than once per page load. https://www.drupal.org/node/2302185
        return $this->safeExecuteSelect($query)
            ->fetchAllKeyed(0, 0);
    }
    return [];
}