ilDBUpdate4963 Class Reference

Class ilDBUpdate4950. More...

Collaboration diagram for ilDBUpdate4963:

Static Public Member Functions
static	renumberBookmarkTree ()
	Wrapper for renumber. More...

Static Private Member Functions
static	__renumber ($node_id=1, $i=1)
	This method is private. More...
static	getChildIds ($a_node)
	Get node child ids type $ilDB. More...

Static Private Attributes
static	$table_tree
static	$tree_id
static	$gap

Detailed Description

Class ilDBUpdate4950.

Definition at line 7 of file class.ilDBUpdate4963.php.

Member Function Documentation

__renumber()

static ilDBUpdate4963::__renumber (   $node_id = 1,   $i = 1  )

staticprivate

This method is private.

Always call ilTree->renumber() since it locks the tree table renumber left/right values and close the gaps in numbers (recursive) private

Parameters

integer	node_id where to start (usually the root node)
integer	first left value of start node (usually 1)

Returns

integer current left value of recursive call

Definition at line 48 of file class.ilDBUpdate4963.php.

References $i, $ilDB, $query, $res, and array.

    {
        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;
    }

getChildIds()

static ilDBUpdate4963::getChildIds (   $a_node )

staticprivate

Get node child ids type $ilDB.

Parameters

type

$a_node

Returns

type

Definition at line 87 of file class.ilDBUpdate4963.php.

References $ilDB, $query, $res, $row, array, and ilDBConstants\FETCHMODE_OBJECT.

    {
        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;
    }

renumberBookmarkTree()

static ilDBUpdate4963::renumberBookmarkTree ( )

static

Wrapper for renumber.

This method locks the table tree (recursive) public

Parameters

integer	node_id where to start (usually the root node)
integer	first left value of start node (usually 1)

Returns

integer current left value of recursive call

Definition at line 21 of file class.ilDBUpdate4963.php.

References $ilDB, $query, $res, $row, and ilDBConstants\FETCHMODE_OBJECT.

    {
        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();
        }
    }

Field Documentation

$gap

ilDBUpdate4963::$gap

staticprivate

Definition at line 11 of file class.ilDBUpdate4963.php.

$table_tree

ilDBUpdate4963::$table_tree

staticprivate

Definition at line 9 of file class.ilDBUpdate4963.php.

$tree_id

ilDBUpdate4963::$tree_id

staticprivate

Definition at line 10 of file class.ilDBUpdate4963.php.

---

The documentation for this class was generated from the following file:

• Services/Migration/DBUpdate_4963/classes/class.ilDBUpdate4963.php