class.ilWorkspaceTree.php

Go to the documentation of this file.

<?php

/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */

include_once "Services/Tree/classes/class.ilTree.php";

class ilWorkspaceTree extends ilTree
{
    protected $db;

    public function __construct($a_tree_id, $a_root_id = 0)
    {
        global $DIC;

        $this->db = $DIC->database();
        parent::__construct($a_tree_id, $a_root_id);
        
        $this->setTableNames('tree_workspace', 'object_data', 'object_reference_ws');
        $this->setTreeTablePK('tree');
        $this->setObjectTablePK('obj_id');
        $this->setReferenceTablePK('wsp_id');

        // ilTree sets it to ROOT_FOLDER_ID if not given...
        if (!$a_root_id) {
            $this->readRootId();
        }
    }

    public function createReference($a_object_id)
    {
        $ilDB = $this->db;
        
        $next_id = $ilDB->nextId($this->table_obj_reference);

        $fields = array($this->ref_pk => array("integer", $next_id),
            $this->obj_pk => array("integer", $a_object_id));

        $ilDB->insert($this->table_obj_reference, $fields);
        
        return $next_id;
    }

    public function lookupObjectId($a_node_id)
    {
        $ilDB = $this->db;

        $set = $ilDB->query("SELECT " . $this->obj_pk .
            " FROM " . $this->table_obj_reference .
            " WHERE " . $this->ref_pk . " = " . $ilDB->quote($a_node_id, "integer"));
        $res = $ilDB->fetchAssoc($set);

        return $res[$this->obj_pk];
    }
    
    
    public function lookupNodeId($a_obj_id)
    {
        $ilDB = $this->db;
        
        $set = $ilDB->query("SELECT " . $this->ref_pk .
            " FROM " . $this->table_obj_reference .
            " WHERE " . $this->obj_pk . " = " . $ilDB->quote($a_obj_id, "integer"));
        $res = $ilDB->fetchAssoc($set);

        return (int) $res[$this->ref_pk];
    }
    
    public function lookupOwner($a_node_id)
    {
        $ilDB = $this->db;

        $set = $ilDB->query("SELECT tree" .
            " FROM " . $this->table_obj_reference .
            " JOIN " . $this->table_tree . " ON (" . $this->table_obj_reference . "." . $this->ref_pk . " = " . $this->table_tree . ".child)" .
            " WHERE " . $this->ref_pk . " = " . $ilDB->quote($a_node_id, "integer"));
        $res = $ilDB->fetchAssoc($set);

        return $res["tree"];
    }

    public function insertObject($a_parent_node_id, $a_object_id)
    {
        $node_id = $this->createReference($a_object_id);
        $this->insertNode($node_id, $a_parent_node_id);
        return $node_id;
    }

    public function deleteReference($a_node_id)
    {
        $ilDB = $this->db;

        $query = "DELETE FROM " . $this->table_obj_reference .
            " WHERE " . $this->ref_pk . " = " . $ilDB->quote($a_node_id, "integer");
        return $ilDB->manipulate($query);
    }
        
    public function cascadingDelete()
    {
        $root_id = $this->readRootId();
        if (!$root_id) {
            return;
        }
        
        $root = $this->getNodeData($root_id);
        
        include_once "Services/PersonalWorkspace/classes/class.ilWorkspaceAccessHandler.php";
        $access_handler = new ilWorkspaceAccessHandler($this);
        
        // delete node data
        $nodes = $this->getSubTree($root);
        foreach ($nodes as $node) {
            $access_handler->removePermission($node["wsp_id"]);

            $object = ilObjectFactory::getInstanceByObjId($node["obj_id"], false);
            if ($object) {
                $object->delete();
            }
        
            $this->deleteReference($node["wsp_id"]);
        }
        
        $this->deleteTree($root);
    }
    
    public function getObjectsFromType($a_type, $a_with_data = false)
    {
        return $this->getSubTree(
            $this->getNodeData($this->getRootId()),
            $a_with_data,
            $a_type
        );
    }
    
    public function createTreeForUser($a_user_id)
    {
        $root = ilObjectFactory::getClassByType("wsrt");
        $root = new $root(null);
        $root->create();

        $root_id = $this->createReference($root->getId());
        $this->addTree($a_user_id, $root_id);
        $this->setRootId($root_id);
    }
}