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 @global 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) @access 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 52 of file class.ilDBUpdate4963.php.

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

References $ilDB, $query, $res, __renumber(), and getChildIds().

Referenced by __renumber(), and renumberBookmarkTree().

Here is the call graph for this function:

Here is the caller graph for this function:

getChildIds()

static ilDBUpdate4963::getChildIds (   $a_node )

staticprivate

Get node child ids @global type $ilDB.

Parameters

type

$a_node

Returns

type

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

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

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

Referenced by __renumber().

Here is the caller graph for this function:

renumberBookmarkTree()

static ilDBUpdate4963::renumberBookmarkTree ( )

static

Wrapper for renumber.

This method locks the table tree (recursive) @access 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 22 of file class.ilDBUpdate4963.php.

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

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

Here is the call graph for this function:

Field Documentation

$gap

ilDBUpdate4963::$gap

staticprivate

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

$table_tree

ilDBUpdate4963::$table_tree

staticprivate

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

$tree_id

ilDBUpdate4963::$tree_id

staticprivate

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

---

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

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