class.ilDBUpdate4963.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2015 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilDBUpdate4963
{
    private static $table_tree;
    private static $tree_id;
    private static $gap;

    public static function renumberBookmarkTree()
    {
        global $ilDB;

        self::$table_tree = "bookmark_tree";
        self::$gap = 0;

        $query = 'SELECT tree FROM ' . self::$table_tree .
            ' GROUP BY tree';
        $res = $ilDB->query($query);

        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            self::$tree_id = $row->tree;
            self::__renumber();
        }
    }

    // PRIVATE
    private static function __renumber($node_id = 1, $i = 1)
    {
        global $ilDB;

        $query = 'UPDATE ' . self::$table_tree . ' SET lft = %s WHERE child = %s AND tree = %s';
        $res = $ilDB->manipulateF($query, array('integer','integer','integer'), array(
            $i,
            $node_id,
            self::$tree_id));

        // to much dependencies
        //$childs = $this->getChilds($node_id);
        $childs = self::getChildIds($node_id);

        foreach ($childs as $child) {
            $i = self::__renumber($child, $i+1);
        }
        $i++;

        // Insert a gap at the end of node, if the node has children
        if (count($childs) > 0) {
            $i += self::$gap * 2;
        }


        $query = 'UPDATE ' . self::$table_tree . ' SET rgt = %s WHERE child = %s AND tree = %s';
        $res = $ilDB->manipulateF($query, array('integer','integer', 'integer'), array(
            $i,
            $node_id,
            self::$tree_id));
        return $i;
    }

    private static function getChildIds($a_node)
    {
        global $ilDB;

        $query = 'SELECT * FROM ' . self::$table_tree .
            ' WHERE parent = ' . $ilDB->quote($a_node, 'integer') . ' ' .
            'AND tree = ' . $ilDB->quote(self::$tree_id, 'integer');
        $res = $ilDB->query($query);

        $childs = array();
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $childs[] = $row->child;
        }
        return $childs;
    }
}