function MenuTreeStorage::moveChildren

Re-parents a link's children when the link itself is moved.

Parameters

array $fields: The changed menu link.

array $original: The original menu link.

File

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

Class

MenuTreeStorage

Provides a menu tree storage using the database.

Namespace

Code

protected function moveChildren($fields, $original) {
    $query = $this->connection
        ->update($this->table, $this->options);
    $query->fields([
        'menu_name' => $fields['menu_name'],
    ]);
    $expressions = [];
    for ($i = 1; $i <= $fields['depth']; $i++) {
        $expressions[] = [
            "p{$i}",
            ":p_{$i}",
            [
                ":p_{$i}" => $fields["p{$i}"],
            ],
        ];
    }
    $j = $original['depth'] + 1;
    while ($i <= $this->maxDepth() && $j <= $this->maxDepth()) {
        $expressions[] = [
            'p' . $i++,
            'p' . $j++,
            [],
        ];
    }
    while ($i <= $this->maxDepth()) {
        $expressions[] = [
            'p' . $i++,
            0,
            [],
        ];
    }
    $shift = $fields['depth'] - $original['depth'];
    if ($shift > 0) {
        // The order of expressions must be reversed so the new values don't
        // overwrite the old ones before they can be used because "Single-table
        // UPDATE assignments are generally evaluated from left to right".
        // @see http://dev.mysql.com/doc/refman/5.0/en/update.html
        $expressions = array_reverse($expressions);
    }
    foreach ($expressions as $expression) {
        $query->expression($expression[0], $expression[1], $expression[2]);
    }
    $query->expression('depth', 'depth + :depth', [
        ':depth' => $shift,
    ]);
    $query->condition('menu_name', $original['menu_name']);
    for ($i = 1; $i <= $this->maxDepth() && $original["p{$i}"]; $i++) {
        $query->condition("p{$i}", $original["p{$i}"]);
    }
    $query->execute();
}