ilSkillTreeNode Class Reference

A node in the skill tree. More...

Inheritance diagram for ilSkillTreeNode:

Collaboration diagram for ilSkillTreeNode:

Public Member Functions
	__construct ($a_id=0)
	setTitle ($a_title)
	Set title. More...
	getTitle ()
	Get title. More...
	setDescription ($a_description)
	Set description. More...
	getDescription ()
	Get description. More...
	setType ($a_type)
	Set type. More...
	getType ()
	Get type. More...
	setId ($a_id)
	Set Node ID. More...
	getId ()
	Get Node ID. More...
	setSelfEvaluation ($a_val)
	Set self evaluation. More...
	getSelfEvaluation ()
	Get self evaluation. More...
	setOrderNr ($a_val)
	Set order nr. More...
	getOrderNr ()
	Get order nr. More...
	setImportId ($a_val)
	Set import id. More...
	getImportId ()
	Get import id. More...
	getCreationDate ()
	Get creation date. More...
	read ()
	Read Data of Node. More...
	setDataRecord ($a_record)
	this method should only be called by class ilSCORM2004NodeFactory More...
	setStatus ($a_val)
	Set status. More...
	getStatus ()
	Get status. More...
	create ()
	Create Node. More...
	update ()
	Update Node. More...
	delete ()
	Delete Node. More...

Static Public Member Functions
static	getAllStatus ()
	Get all status. More...
static	getStatusInfo ($a_status)
	Get status info. More...
static	_lookupTitle ($a_obj_id, $a_tref_id=0)
	Lookup Title. More...
static	_lookupDescription ($a_obj_id)
	Lookup Description. More...
static	_lookupSelfEvaluation ($a_obj_id)
	Lookup self evaluation. More...
static	_lookupStatus ($a_obj_id)
	Lookup Status. More...
static	_lookupType ($a_obj_id)
	Lookup Type. More...
static	_writeTitle ($a_obj_id, $a_title)
	Write Title. More...
static	_writeDescription ($a_obj_id, $a_description)
	Write Description. More...
static	_writeOrderNr ($a_obj_id, $a_nr)
	Write Order Nr. More...
static	putInTree ($a_obj, $a_parent_id="", $a_target_node_id="")
	Put this object into the skill tree. More...
static	getTree ($a_slm_obj_id)
	Get scorm module editing tree. More...
static	uniqueTypesCheck ($a_items)
	Check for unique types. More...
static	clipboardCut ($a_tree_id, $a_ids)
	Cut and copy a set of skills/skill categories into the clipboard. More...
static	clipboardCopy ($a_tree_id, $a_ids)
	Copy a set of skills/skill categories into the clipboard. More...
static	insertItemsFromClip ($a_type, $a_obj_id)
	Insert basic skills from clipboard. More...
static	clearClipboard ()
	Remove all skill items from clipboard. More...
static	pasteTree ( $a_item_id, $a_parent_id, $a_target, $a_insert_time, &$a_copied_nodes, $a_as_copy=false, $a_add_suffix=false)
	Paste item (tree) from clipboard to skill tree. More...
static	isInTree ($a_id)
	Is id in tree? More...
static	getAllSelfEvaluationNodes ()
	Get all self evaluation nodes. More...
static	getTopTemplates ()
	Get top skill templates and template categories. More...
static	getSelectableSkills ()
	Get selectable skills. More...
static	saveChildsOrder ($a_par_id, $a_childs_order, $a_templates=false)
	Save childs order. More...
static	getIconPath ($a_obj_id, $a_type, $a_size="", $a_status=0)
	Get icon path. More...
static	findSkills ($a_term)
	Find skills. More...
static	getAllCSkillIdsForNodeIds (array $a_node_ids)
	Get all possible common skill IDs for node IDs. More...

Data Fields
	$skill_tree
const	STATUS_PUBLISH = 0
const	STATUS_DRAFT = 1
const	STATUS_OUTDATED = 2
	$type
	$id
	$title
	$description

Protected Member Functions
	setCreationDate ($a_val)
	Set creation date. More...

Static Protected Member Functions
static	_lookup ($a_obj_id, $a_field)
	Lookup Title. More...

Protected Attributes
	$db

Detailed Description

A node in the skill tree.

Author

Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e

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

Constructor & Destructor Documentation

__construct()

ilSkillTreeNode::__construct

(

$a_id = 0

)

Parameters

int

node id

Definition at line 33 of file class.ilSkillTreeNode.php.

References $DIC, and read().

    {
        global $DIC;

        $this->db = $DIC->database();
        $this->id = $a_id;
        
        $this->skill_tree = new ilSkillTree();

        if ($a_id != 0) {
            $this->read();
        }
    }

Here is the call graph for this function:

Member Function Documentation

_lookup()

static ilSkillTreeNode::_lookup (   $a_obj_id,   $a_field  )

staticprotected

Lookup Title.

Parameters

int

Node ID

Returns

string Title

Definition at line 282 of file class.ilSkillTreeNode.php.

References $DIC, $ilDB, and $query.

    {
        global $DIC;

        $ilDB = $DIC->database();

        $query = "SELECT $a_field FROM skl_tree_node WHERE obj_id = " .
            $ilDB->quote($a_obj_id, "integer");
        $obj_set = $ilDB->query($query);
        $obj_rec = $ilDB->fetchAssoc($obj_set);

        return $obj_rec[$a_field];
    }

_lookupDescription()

static ilSkillTreeNode::_lookupDescription (   $a_obj_id )

static

Lookup Description.

Parameters

int

node ID

Returns

string description

Definition at line 316 of file class.ilSkillTreeNode.php.

References $DIC, and $ilDB.

Referenced by ilPersonalSkillsGUI\getSkillCategoryDescription(), and ilSkillTemplateReferenceGUI\initForm().

    {
        global $DIC;

        $ilDB = $DIC->database();

        return self::_lookup($a_obj_id, "description");
    }

Here is the caller graph for this function:

_lookupSelfEvaluation()

static ilSkillTreeNode::_lookupSelfEvaluation (   $a_obj_id )

static

Lookup self evaluation.

Parameters

int

node ID

Returns

boolean selectable? (self evaluation=

Definition at line 331 of file class.ilSkillTreeNode.php.

References $DIC, and $ilDB.

Referenced by ilPersonalSkillExplorerGUI\buildSelectableTree(), ilSkillTreeExplorerGUI\getNodeContent(), ilSkillTemplateTreeExplorerGUI\getNodeContent(), and ilPersonalSkillExplorerGUI\isNodeClickable().

    {
        global $DIC;

        $ilDB = $DIC->database();

        return self::_lookup($a_obj_id, "self_eval");
    }

Here is the caller graph for this function:

_lookupStatus()

static ilSkillTreeNode::_lookupStatus (   $a_obj_id )

static

Lookup Status.

Parameters

int

$a_obj_id

node ID

Returns

int status

Definition at line 346 of file class.ilSkillTreeNode.php.

References $DIC, and $ilDB.

Referenced by ilPersonalSkillExplorerGUI\buildSelectableTree(), ilSkillCatTableGUI\fillRow(), ilSkillTemplateTreeExplorerGUI\getChildsOfNode(), ilVirtualSkillTree\getChildsOfNode(), and ilSkillTreeNodeGUI\setTitleIcon().

    {
        global $DIC;

        $ilDB = $DIC->database();

        return self::_lookup($a_obj_id, "status");
    }

Here is the caller graph for this function:

_lookupTitle()

static ilSkillTreeNode::_lookupTitle (   $a_obj_id,   $a_tref_id = 0  )

static

Lookup Title.

Parameters

int

node ID

Returns

string title

Definition at line 302 of file class.ilSkillTreeNode.php.

References ilSkillTemplateReference\_lookupTemplateId().

Referenced by ilSurveySkillThresholdsTableGUI\__construct(), ilSkillUsageTableGUI\__construct(), ilPersonalSkillsGUI\assignMaterials(), clipboardCopy(), ilTestSkillLevelThresholdsTableGUI\completeCompetenceTitles(), ilSkillProfileGUI\confirmLevelAssignmentRemoval(), ilContSkillAdminGUI\confirmRemoveSelectedSkill(), ilSkillSelfEvaluationGUI\confirmSelfEvaluationDeletion(), ilPersonalSkillsGUI\confirmSkillRemove(), ilSelfEvaluationTableGUI\fillRow(), ilSurveySkillTableGUI\fillRow(), ilSurveySkillAssignmentTableGUI\fillRow(), ilContSkillMemberTableGUI\fillRow(), ilSurveySkill\getAllAssignedSkillsAsOptions(), ilSkillLearningHistoryProvider\getEntries(), ilTestSkillLevelThresholdImportFails\getFailedImportsMessage(), ilPersonalSkillsGUI\getGapAnalysisHTML(), ilSkillTreeExplorerGUI\getNodeContent(), ilSkillTemplateTreeExplorerGUI\getNodeContent(), ilContSkillCollector\getProfileSkills(), ilPersonalSkill\getSelectedUserSkills(), ilContSkillCollector\getSingleSkills(), ilSurveySkillTableGUI\getSkills(), ilContSkillAdminGUI\initCompetenceAssignmentForm(), ilObjPortfolioGUI\initCreatePortfolioFromTemplateForm(), ilAssQuestionSkillAssignment\loadAdditionalSkillData(), ilPersonalSkillsGUI\renderSkillHTML(), ilPortfolioPageGUI\renderSkillsTeaser(), ilPersonalSkillsGUI\selfEvaluation(), ilSkillNotifications\sendMail(), and ilSkillTemplateReferenceGUI\setTabs().

    {
        if ($a_tref_id > 0 && ilSkillTemplateReference::_lookupTemplateId($a_tref_id) == $a_obj_id) {
            return self::_lookup($a_tref_id, "title");
        }
        return self::_lookup($a_obj_id, "title");
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_lookupType()

static ilSkillTreeNode::_lookupType (   $a_obj_id )

static

Lookup Type.

Parameters

int

Node ID

Returns

string Type

Definition at line 361 of file class.ilSkillTreeNode.php.

References $DIC, $ilDB, and $query.

Referenced by ilSkillTreeNodeGUI\__construct(), ilVirtualSkillTree\__getSubTreeRec(), ilPersonalSkillsGUI\assignMaterials(), clipboardCopy(), ilCOPageHTMLExport\collectPageElements(), ilObjSkillManagementGUI\deleteNodes(), getAllCSkillIdsForNodeIds(), ilSkillDataSet\getDependencies(), getIconPath(), ilVirtualSkillTreeExplorerGUI\getNodeIcon(), ilVirtualSkillTree\getSubTreeForCSkillId(), ilSkillDataSet\importRecord(), ilSkillTemplateReferenceGUI\listItems(), ilSkillSelectorGUI\nodeHasAction(), pasteTree(), ilSkillCategoryGUI\redirectToParent(), ilSkillTreeNodeGUI\redirectToParent(), ilBasicSkillGUI\redirectToParent(), ilPersonalSkillsGUI\renderSkillHTML(), ilPersonalSkillsGUI\selfEvaluation(), ilSkillTemplateReferenceGUI\setTabs(), ilObjSkillManagementGUI\showTree(), and uniqueTypesCheck().

    {
        global $DIC;

        $ilDB = $DIC->database();

        $query = "SELECT * FROM skl_tree_node WHERE obj_id = " .
            $ilDB->quote($a_obj_id, "integer");
        $obj_set = $ilDB->query($query);
        $obj_rec = $ilDB->fetchAssoc($obj_set);

        return $obj_rec["type"];
    }

Here is the caller graph for this function:

_writeDescription()

static ilSkillTreeNode::_writeDescription (   $a_obj_id,   $a_description  )

static

Write Description.

Parameters

int	Node ID
string	Description

Definition at line 420 of file class.ilSkillTreeNode.php.

References $DIC, $ilDB, and $query.

    {
        global $DIC;

        $ilDB = $DIC->database();

        $query = "UPDATE skl_tree_node SET " .
            " description = " . $ilDB->quote($a_description, "clob") .
            " WHERE obj_id = " . $ilDB->quote($a_obj_id, "integer");

        $ilDB->manipulate($query);
    }

_writeOrderNr()

static ilSkillTreeNode::_writeOrderNr (   $a_obj_id,   $a_nr  )

static

Write Order Nr.

Parameters

int	Node ID
string	Order Nr

Definition at line 439 of file class.ilSkillTreeNode.php.

References $DIC, $ilDB, and $query.

Referenced by saveChildsOrder().

    {
        global $DIC;

        $ilDB = $DIC->database();

        $query = "UPDATE skl_tree_node SET " .
            " order_nr = " . $ilDB->quote($a_nr, "integer") .
            " WHERE obj_id = " . $ilDB->quote($a_obj_id, "integer");
        $ilDB->manipulate($query);
    }

Here is the caller graph for this function:

_writeTitle()

static ilSkillTreeNode::_writeTitle (   $a_obj_id,   $a_title  )

static

Write Title.

Parameters

int	Node ID
string	Title

Definition at line 401 of file class.ilSkillTreeNode.php.

References $DIC, $ilDB, and $query.

Referenced by ilObjSkillManagementGUI\saveAllTemplateTitles(), and ilObjSkillManagementGUI\saveAllTitles().

    {
        global $DIC;

        $ilDB = $DIC->database();

        $query = "UPDATE skl_tree_node SET " .
            " title = " . $ilDB->quote($a_title, "text") .
            " WHERE obj_id = " . $ilDB->quote($a_obj_id, "integer");

        $ilDB->manipulate($query);
    }

Here is the caller graph for this function:

clearClipboard()

static ilSkillTreeNode::clearClipboard ( )

static

Remove all skill items from clipboard.

Parameters

Definition at line 726 of file class.ilSkillTreeNode.php.

References $DIC, $ilUser, and ilEditClipboard\clear().

    {
        global $DIC;

        $ilUser = $DIC->user();
        
        $ilUser->clipboardDeleteObjectsOfType("skll");
        $ilUser->clipboardDeleteObjectsOfType("scat");
        $ilUser->clipboardDeleteObjectsOfType("sktr");
        $ilUser->clipboardDeleteObjectsOfType("sktp");
        $ilUser->clipboardDeleteObjectsOfType("sctp");
        ilEditClipboard::clear();
    }

Here is the call graph for this function:

clipboardCopy()

static ilSkillTreeNode::clipboardCopy (   $a_tree_id,   $a_ids  )

static

Copy a set of skills/skill categories into the clipboard.

Definition at line 629 of file class.ilSkillTreeNode.php.

References $DIC, $id, $ilUser, _lookupTitle(), and _lookupType().

Referenced by clipboardCut(), and ilSkillTreeNodeGUI\copyItems().

    {
        global $DIC;

        $ilUser = $DIC->user();
        
        self::clearClipboard();
        $tree = new ilSkillTree();
        
        // put them into the clipboard
        $time = date("Y-m-d H:i:s", time());
        foreach ($a_ids as $id) {
            $curnode = "";
            if ($tree->isInTree($id)) {
                $curnode = $tree->getNodeData($id);
                $subnodes = $tree->getSubTree($curnode);
                foreach ($subnodes as $subnode) {
                    if ($subnode["child"] != $id) {
                        $ilUser->addObjectToClipboard(
                            $subnode["child"],
                            $subnode["type"],
                            $subnode["title"],
                            $subnode["parent"],
                            $time,
                            $subnode["lft"]
                        );
                    }
                }
            }
            $order = ($curnode["lft"] > 0)
                ? $curnode["lft"]
                : (int) ($order + 1);
            $ilUser->addObjectToClipboard(
                $id,
                ilSkillTreeNode::_lookupType($id),
                ilSkillTreeNode::_lookupTitle($id),
                0,
                $time,
                $order
            );
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

clipboardCut()

static ilSkillTreeNode::clipboardCut (   $a_tree_id,   $a_ids  )

static

Cut and copy a set of skills/skill categories into the clipboard.

Definition at line 589 of file class.ilSkillTreeNode.php.

References $id, and clipboardCopy().

Referenced by ilSkillTreeNodeGUI\cutItems().

    {
        self::clearClipboard();
        $tree = new ilSkillTree();

        if (!is_array($a_ids)) {
            return false;
        } else {
            // get all "top" ids, i.e. remove ids, that have a selected parent
            foreach ($a_ids as $id) {
                $path = $tree->getPathId($id);
                $take = true;
                foreach ($path as $path_id) {
                    if ($path_id != $id && in_array($path_id, $a_ids)) {
                        $take = false;
                    }
                }
                if ($take) {
                    $cut_ids[] = $id;
                }
            }
        }

        ilSkillTreeNode::clipboardCopy($a_tree_id, $cut_ids);

        // remove the objects from the tree
        // note: we are getting skills/categories which are *not* in the tree
        // we do not delete any pages/chapters here
        foreach ($cut_ids as $id) {
            $curnode = $tree->getNodeData($id);
            if ($tree->isInTree($id)) {
                $tree->deleteTree($curnode);
            }
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

create()

ilSkillTreeNode::create

(

)

Create Node.

Parameters

boolean

Upload Mode

Definition at line 456 of file class.ilSkillTreeNode.php.

References $db, $id, $ilDB, $query, getDescription(), getImportId(), getOrderNr(), getSelfEvaluation(), getStatus(), getTitle(), getType(), and setId().

    {
        $ilDB = $this->db;

        // insert object data
        $id = $ilDB->nextId("skl_tree_node");
        $query = "INSERT INTO skl_tree_node (obj_id, title, description, type, create_date, self_eval, order_nr, status, creation_date, import_id) " .
            "VALUES (" .
            $ilDB->quote($id, "integer") . "," .
            $ilDB->quote($this->getTitle(), "text") . "," .
            $ilDB->quote($this->getDescription(), "clob") . "," .
            $ilDB->quote($this->getType(), "text") . ", " .
            $ilDB->now() . ", " .
            $ilDB->quote((int) $this->getSelfEvaluation(), "integer") . ", " .
            $ilDB->quote((int) $this->getOrderNr(), "integer") . ", " .
            $ilDB->quote((int) $this->getStatus(), "integer") . ", " .
            $ilDB->now() . ", " .
            $ilDB->quote($this->getImportId(), "text") .
            ")";
        $ilDB->manipulate($query);
        $this->setId($id);
    }

Here is the call graph for this function:

delete()

ilSkillTreeNode::delete

(

)

Delete Node.

Definition at line 501 of file class.ilSkillTreeNode.php.

References $db, $ilDB, $query, and getId().

    {
        $ilDB = $this->db;
        
        $query = "DELETE FROM skl_tree_node WHERE obj_id= " .
            $ilDB->quote($this->getId(), "integer");
        $ilDB->manipulate($query);
    }

Here is the call graph for this function:

findSkills()

static ilSkillTreeNode::findSkills (   $a_term )

static

Find skills.

Parameters

Definition at line 967 of file class.ilSkillTreeNode.php.

References $c, $DIC, $ilDB, $res, $skill_tree, ilSkillTemplateReference\_lookupTemplateId(), and ilSkillTemplateReference\_lookupTrefIdsForTopTemplateId().

Referenced by ilPublicUserProfileGUI\getAutocompleteResult().

    {
        global $DIC;

        $ilDB = $DIC->database();

        $res = array();
        $candidates = array();

        $skill_tree = new ilSkillTree();

        $sql = "SELECT * " .
            " FROM skl_tree_node" .
            " WHERE " . $ilDB->like("title", "text", "%" . $a_term . "%");
        $sql .= " ORDER BY title";
        $set = $ilDB->query($sql);
        while ($row = $ilDB->fetchAssoc($set)) {
            if (in_array($row["type"], array("sctp", "sktp"))) {
                // need to get "top template" first! (if it is already the top level, do not use it!)
                $path = $skill_tree->getSkillTreePath($row["obj_id"]);
                if ($path[1]["child"] != $row["obj_id"]) {
                    $trefs = ilSkillTemplateReference::_lookupTrefIdsForTopTemplateId($path[1]["child"]);
                    foreach ($trefs as $tref) {
                        $candidates[] = array("tref_id" => $tref, "skill_id" => $row["obj_id"], "title" => $row["title"]);
                    }
                }
            } elseif ($row["type"] == "sktr") {
                // works
                $candidates[] = array("tref_id" => $row["obj_id"], "skill_id" => ilSkillTemplateReference::_lookupTemplateId($row["obj_id"]), "title" => $row["title"]);
            } else {
                // works
                $candidates[] = array("tref_id" => 0, "skill_id" => $row["obj_id"], "title" => $row["title"]);
            }
        }

        foreach ($candidates as $c) {
            // if we get a path array, and the array has items try to use the data
            $path = $skill_tree->getSkillTreePath($c["skill_id"], $c["tref_id"]);
            $use = false;
            if (is_array($path) && count($path) > 0) {
                $use = true;
            }

            // if any inactive/outdated -> do not use the data
            if (is_array($path)) {
                foreach ($path as $p) {
                    if ($p["status"] > 0) {
                        $use = false;
                    }
                }
            }
            if ($use) {
                if (!in_array($c["title"], $res)) {
                    $res[] = $c["title"];
                }
            }
        }


        return $res;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getAllCSkillIdsForNodeIds()

static ilSkillTreeNode::getAllCSkillIdsForNodeIds ( array  $a_node_ids )

static

Get all possible common skill IDs for node IDs.

Parameters

array

$a_node_ids

array of node ids

Returns

array array of skill ids

Definition at line 1035 of file class.ilSkillTreeNode.php.

References $id, ilSkillTemplateReference\_lookupTemplateId(), ilSkillTemplateReference\_lookupTrefIdsForTemplateId(), and _lookupType().

Referenced by ilSkillTreeNodeGUI\isInUse().

    {
        $cskill_ids = array();
        foreach ($a_node_ids as $id) {
            if (in_array(self::_lookupType($id), array("skll", "scat", "sktr"))) {
                $skill_id = $id;
                $tref_id = 0;
                if (ilSkillTreeNode::_lookupType($id) == "sktr") {
                    $skill_id = ilSkillTemplateReference::_lookupTemplateId($id);
                    $tref_id = $id;
                }
                $cskill_ids[] = array("skill_id" => $skill_id, "tref_id" => $tref_id);
            }
            if (in_array(ilSkillTreeNode::_lookupType($id), array("sktp", "sctp"))) {
                foreach (ilSkillTemplateReference::_lookupTrefIdsForTemplateId($id) as $tref_id) {
                    $cskill_ids[] = array("skill_id" => $id, "tref_id" => $tref_id);
                }
            }
            // for cats, skills and template references, get "real" usages
            // for skill and category templates check usage in references
        }
        return $cskill_ids;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getAllSelfEvaluationNodes()

static ilSkillTreeNode::getAllSelfEvaluationNodes ( )

static

Get all self evaluation nodes.

Parameters

Definition at line 830 of file class.ilSkillTreeNode.php.

References $DIC, and $ilDB.

Referenced by ilSkillSelfEvaluationGUI\listSelfEvaluations().

    {
        global $DIC;

        $ilDB = $DIC->database();

        $set = $ilDB->query(
            "SELECT obj_id, title FROM skl_tree_node WHERE " .
            " self_eval = " . $ilDB->quote(true, "integer") . " ORDER BY TITLE "
            );
        $nodes = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $nodes[$rec["obj_id"]] = $rec["title"];
        }
        return $nodes;
    }

Here is the caller graph for this function:

getAllStatus()

static ilSkillTreeNode::getAllStatus ( )

static

Get all status.

Returns

array array of status, key is value, value is lang text

Definition at line 212 of file class.ilSkillTreeNode.php.

References $DIC, and $lng.

Referenced by ilSkillTreeNodeGUI\addStatusInput().

    {
        global $DIC;

        $lng = $DIC->language();

        return array(
            self::STATUS_DRAFT => $lng->txt("skmg_status_draft"),
            self::STATUS_PUBLISH => $lng->txt("skmg_status_publish"),
            self::STATUS_OUTDATED => $lng->txt("skmg_status_outdated")
        );
    }

Here is the caller graph for this function:

getCreationDate()

ilSkillTreeNode::getCreationDate

(

)

Get creation date.

Returns

string creation date

Definition at line 202 of file class.ilSkillTreeNode.php.

    {
        return $this->creation_date;
    }

getDescription()

ilSkillTreeNode::getDescription

(

)

Get description.

Returns

string description

Definition at line 82 of file class.ilSkillTreeNode.php.

References $description.

Referenced by ilBasicSkillTemplate\copy(), ilSkillTemplateCategory\copy(), ilSkillCategory\copy(), ilBasicSkill\copy(), ilSkillTemplateReference\copy(), create(), and update().

    {
        return $this->description;
    }

Here is the caller graph for this function:

getIconPath()

static ilSkillTreeNode::getIconPath (   $a_obj_id,   $a_type,   $a_size = "",   $a_status = 0  )

static

Get icon path.

Parameters

int	$a_obj_id	node id
string	$a_type	node type
string	$a_size	size
int	$a_status	status

Returns

string icon path

Definition at line 936 of file class.ilSkillTreeNode.php.

References $type, ilSkillTemplateReference\_lookupTemplateId(), _lookupType(), ilUtil\getImagePath(), and ILIAS_VERSION.

Referenced by ilSkillCatTableGUI\fillRow(), ilSkillTreeExplorerGUI\getNodeIcon(), ilSkillTemplateTreeExplorerGUI\getNodeIcon(), ilBasicSkillTemplateGUI\setLevelHead(), and ilSkillTreeNodeGUI\setTitleIcon().

    {
        if ($a_status == self::STATUS_DRAFT && $a_type == "sctp") {
            $a_type = "scat";
        }
        if ($a_status == self::STATUS_DRAFT && $a_type == "sktp") {
            $a_type = "skll";
        }
        
        $off = ($a_status == self::STATUS_DRAFT)
            ? "_off"
            : "";
            
        $a_name = "icon_" . $a_type . $a_size . $off . ".svg";
        if ($a_type == "sktr") {
            $tid = ilSkillTemplateReference::_lookupTemplateId($a_obj_id);
            $type = ilSkillTreeNode::_lookupType($tid);
            if ($type == "sctp") {
                $a_name = "icon_sctr" . $a_size . $off . ".svg";
            }
        }
        $vers = "vers=" . str_replace(array(".", " "), "-", ILIAS_VERSION);
        return ilUtil::getImagePath($a_name) . "?" . $vers;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getId()

ilSkillTreeNode::getId

(

)

Get Node ID.

Parameters

int

Node ID

Definition at line 122 of file class.ilSkillTreeNode.php.

References $id.

Referenced by ilBasicSkill\addLevel(), ilSkillTemplateCategory\delete(), ilSkillCategory\delete(), ilBasicSkillTemplate\delete(), ilBasicSkill\delete(), delete(), ilBasicSkill\fixLevelNumbering(), ilBasicSkill\getAllHistoricLevelEntriesOfUser(), ilBasicSkill\getAllLevelEntriesOfUser(), ilBasicSkill\getLastLevelPerObject(), ilBasicSkill\getLastUpdatePerObject(), ilBasicSkill\getLevelData(), ilBasicSkill\getMaxLevel(), ilBasicSkill\getMaxLevelPerObject(), ilBasicSkill\getMaxLevelPerType(), and update().

    {
        return $this->id;
    }

Here is the caller graph for this function:

getImportId()

ilSkillTreeNode::getImportId

(

)

Get import id.

Returns

string import id

Definition at line 182 of file class.ilSkillTreeNode.php.

Referenced by create(), and update().

    {
        return $this->import_id;
    }

Here is the caller graph for this function:

getOrderNr()

ilSkillTreeNode::getOrderNr

(

)

Get order nr.

Returns

int order nr

Definition at line 162 of file class.ilSkillTreeNode.php.

Referenced by ilBasicSkillTemplate\copy(), ilSkillTemplateCategory\copy(), ilSkillCategory\copy(), ilBasicSkill\copy(), ilSkillTemplateReference\copy(), create(), and update().

    {
        return $this->order_nr;
    }

Here is the caller graph for this function:

getSelectableSkills()

static ilSkillTreeNode::getSelectableSkills ( )

static

Get selectable skills.

Parameters

Definition at line 867 of file class.ilSkillTreeNode.php.

References $DIC, and $ilDB.

    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $set = $ilDB->query(
            "SELECT * FROM skl_tree_node " .
            " WHERE self_eval = " . $ilDB->quote(1, "integer")
            );
        
        $sel_skills = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $sel_skills[] = $rec;
        }
        
        return $sel_skills;
    }

getSelfEvaluation()

ilSkillTreeNode::getSelfEvaluation

(

)

Get self evaluation.

Returns

boolean self evaluation

Definition at line 142 of file class.ilSkillTreeNode.php.

Referenced by ilSkillCategory\copy(), ilBasicSkill\copy(), ilSkillTemplateReference\copy(), create(), and update().

    {
        return $this->self_eval;
    }

Here is the caller graph for this function:

getStatus()

ilSkillTreeNode::getStatus

(

)

Get status.

Returns

int status

Definition at line 390 of file class.ilSkillTreeNode.php.

Referenced by create(), and update().

    {
        return $this->status;
    }

Here is the caller graph for this function:

getStatusInfo()

static ilSkillTreeNode::getStatusInfo (   $a_status )

static

Get status info.

Parameters

int

$a_status

status

Returns

string info text

Definition at line 231 of file class.ilSkillTreeNode.php.

References $DIC, and $lng.

Referenced by ilSkillTreeNodeGUI\addStatusInput().

    {
        global $DIC;

        $lng = $DIC->language();

        switch ($a_status) {
            case self::STATUS_PUBLISH: return $lng->txt("skmg_status_publish_info");
            case self::STATUS_DRAFT: return $lng->txt("skmg_status_draft_info");
            case self::STATUS_OUTDATED: return $lng->txt("skmg_status_outdated_info");
        }
        return "";
    }

Here is the caller graph for this function:

getTitle()

ilSkillTreeNode::getTitle

(

)

Get title.

Returns

string title

Definition at line 62 of file class.ilSkillTreeNode.php.

References $title.

Referenced by ilBasicSkillTemplate\copy(), ilSkillTemplateCategory\copy(), ilSkillCategory\copy(), ilBasicSkill\copy(), ilSkillTemplateReference\copy(), create(), ilBasicSkill\getTitleForCertificate(), and update().

    {
        return $this->title;
    }

Here is the caller graph for this function:

getTopTemplates()

static ilSkillTreeNode::getTopTemplates ( )

static

Get top skill templates and template categories.

Parameters

Definition at line 853 of file class.ilSkillTreeNode.php.

Referenced by ilSkillTemplateReferenceGUI\initForm().

    {
        $tr = new ilSkillTree();
        $childs = $tr->getChildsByTypeFilter($tr->getRootId(), array("sktp", "sctp"));
        
        return $childs;
    }

Here is the caller graph for this function:

getTree()

static ilSkillTreeNode::getTree (   $a_slm_obj_id )

static

Get scorm module editing tree.

Parameters

int	scorm module object id

Returns

object tree object

Definition at line 560 of file class.ilSkillTreeNode.php.

    {
        $tree = new ilSkillTree();
        
        return $tree;
    }

getType()

ilSkillTreeNode::getType

(

)

Get type.

Returns

string Type

Definition at line 102 of file class.ilSkillTreeNode.php.

References $type.

Referenced by ilBasicSkillTemplate\copy(), ilSkillTemplateCategory\copy(), ilSkillCategory\copy(), ilBasicSkill\copy(), ilSkillTemplateReference\copy(), and create().

    {
        return $this->type;
    }

Here is the caller graph for this function:

insertItemsFromClip()

static ilSkillTreeNode::insertItemsFromClip (   $a_type,   $a_obj_id  )

static

Insert basic skills from clipboard.

Definition at line 676 of file class.ilSkillTreeNode.php.

References $DIC, $ilUser, ilEditClipboard\getAction(), IL_LAST_NODE, pasteTree(), and saveChildsOrder().

Referenced by ilSkillTreeNodeGUI\insertBasicSkillClip(), ilSkillTreeNodeGUI\insertSkillCategoryClip(), ilSkillTreeNodeGUI\insertSkillTemplateClip(), ilSkillTreeNodeGUI\insertTemplateCategoryClip(), and ilSkillTreeNodeGUI\insertTemplateReferenceClip().

    {
        global $DIC;

        $ilUser = $DIC->user();
        
        // @todo: move this to a service since it can be used here, too

        $parent_id = $a_obj_id;
        $target = IL_LAST_NODE;

        // cut and paste
        $skills = $ilUser->getClipboardObjects($a_type);  // this will get all skills _regardless_ of level
        $copied_nodes = array();
        foreach ($skills as $skill) {
            // if skill was already copied as part of tree - do not copy it again
            if (!in_array($skill["id"], array_keys($copied_nodes))) {
                $cid = ilSkillTreeNode::pasteTree(
                    $skill["id"],
                    $parent_id,
                    $target,
                    $skill["insert_time"],
                    $copied_nodes,
                    (ilEditClipboard::getAction() == "copy"),
                    true
                );
                //                              $target = $cid;
            }
        }

        //              if (ilEditClipboard::getAction() == "cut")
        //              {
        self::clearClipboard();
        //              }

        ilSkillTreeNode::saveChildsOrder(
            $a_obj_id,
            array(),
            in_array($a_type, array("sktp", "sctp"))
        );

        return $copied_nodes;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

isInTree()

static ilSkillTreeNode::isInTree (   $a_id )

static

Is id in tree?

Parameters

Definition at line 815 of file class.ilSkillTreeNode.php.

References $skill_tree.

Referenced by ilBasicSkillLevelDBRepository\getSkillForLevelId().

    {
        $skill_tree = new ilSkillTree();
        if ($skill_tree->isInTree($a_id)) {
            return true;
        }
        return false;
    }

Here is the caller graph for this function:

pasteTree()

static ilSkillTreeNode::pasteTree (   $a_item_id,   $a_parent_id,   $a_target,   $a_insert_time, &  $a_copied_nodes,   $a_as_copy = false,   $a_add_suffix = false  )

static

Paste item (tree) from clipboard to skill tree.

Definition at line 744 of file class.ilSkillTreeNode.php.

References $DIC, $ilUser, $lng, _lookupType(), IL_LAST_NODE, and putInTree().

Referenced by insertItemsFromClip().

      {
        global $DIC;

        $ilUser = $DIC->user();
        $ilLog = $DIC["ilLog"];
        $lng = $DIC->language();

        $item_type = ilSkillTreeNode::_lookupType($a_item_id);

        if ($item_type == "scat") {
            $item = new ilSkillCategory($a_item_id);
        } elseif ($item_type == "skll") {
            $item = new ilBasicSkill($a_item_id);
        } elseif ($item_type == "sktr") {
            $item = new ilSkillTemplateReference($a_item_id);
        } elseif ($item_type == "sktp") {
            $item = new ilBasicSkillTemplate($a_item_id);
        } elseif ($item_type == "sctp") {
            $item = new ilSkillTemplateCategory($a_item_id);
        }

        $ilLog->write("Getting from clipboard type " . $item_type . ", " .
            "Item ID: " . $a_item_id);

        if ($a_as_copy) {
            $target_item = $item->copy();
            if ($a_add_suffix) {
                $target_item->setTitle($target_item->getTitle() . " " . $lng->txt("copy_of_suffix"));
                $target_item->update();
            }
            $a_copied_nodes[$item->getId()] = $target_item->getId();
        } else {
            $target_item = $item;
        }
        
        $ilLog->write("Putting into skill tree type " . $target_item->getType() .
            "Item ID: " . $target_item->getId() . ", Parent: " . $a_parent_id . ", " .
            "Target: " . $a_target);
        
        ilSkillTreeNode::putInTree($target_item, $a_parent_id, $a_target);
        
        $childs = $ilUser->getClipboardChilds($item->getId(), $a_insert_time);

        foreach ($childs as $child) {
            ilSkillTreeNode::pasteTree(
                $child["id"],
                $target_item->getId(),
                IL_LAST_NODE,
                $a_insert_time,
                $a_copied_nodes,
                $a_as_copy
            );
        }
        
        return $target_item->getId();
    }

Here is the call graph for this function:

Here is the caller graph for this function:

putInTree()

static ilSkillTreeNode::putInTree (   $a_obj,   $a_parent_id = "",   $a_target_node_id = ""  )

static

Put this object into the skill tree.

Definition at line 513 of file class.ilSkillTreeNode.php.

References $skill_tree, and IL_FIRST_NODE.

Referenced by ilSkillDataSet\importRecord(), pasteTree(), ilBasicSkillGUI\saveItem(), ilSkillCategoryGUI\saveItem(), ilSkillTemplateReferenceGUI\saveItem(), ilBasicSkillTemplateGUI\saveItem(), and ilSkillTemplateCategoryGUI\saveItem().

    {
        $skill_tree = new ilSkillTree();

        // determine parent
        $parent_id = ($a_parent_id != "")
            ? $a_parent_id
            : $skill_tree->getRootId();

        // make a check, whether the type of object is allowed under
        // the parent
        $allowed = array(
            "skrt" => array("skll", "scat", "sktr", "sktp", "sctp"),
            "scat" => array("skll", "scat", "sktr"),
            "sctp" => array("sktp", "sctp"));
        $par_type = self::_lookupType($parent_id);
        if (!is_array($allowed[$par_type]) ||
            !in_array($a_obj->getType(), $allowed[$par_type])) {
            return;
        }
        
        // determine target
        if ($a_target_node_id != "") {
            $target = $a_target_node_id;
        } else {
            // determine last child that serves as predecessor
            $childs = $skill_tree->getChilds($parent_id);

            if (count($childs) == 0) {
                $target = IL_FIRST_NODE;
            } else {
                $target = $childs[count($childs) - 1]["obj_id"];
            }
        }

        if ($skill_tree->isInTree($parent_id) && !$skill_tree->isInTree($a_obj->getId())) {
            $skill_tree->insertNode($a_obj->getId(), $parent_id, $target);
        }
    }

Here is the caller graph for this function:

read()

ilSkillTreeNode::read

(

)

Read Data of Node.

Definition at line 248 of file class.ilSkillTreeNode.php.

References $db, $ilDB, $query, setCreationDate(), setDescription(), setImportId(), setOrderNr(), setSelfEvaluation(), setStatus(), setTitle(), and setType().

Referenced by __construct().

    {
        $ilDB = $this->db;

        if (!isset($this->data_record)) {
            $query = "SELECT * FROM skl_tree_node WHERE obj_id = " .
                $ilDB->quote($this->id, "integer");
            $obj_set = $ilDB->query($query);
            $this->data_record = $ilDB->fetchAssoc($obj_set);
        }
        $this->setType($this->data_record["type"]);
        $this->setTitle($this->data_record["title"]);
        $this->setDescription($this->data_record["description"]);
        $this->setOrderNr($this->data_record["order_nr"]);
        $this->setSelfEvaluation($this->data_record["self_eval"]);
        $this->setStatus($this->data_record["status"]);
        $this->setImportId($this->data_record["import_id"]);
        $this->setCreationDate($this->data_record["creation_date"]);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

saveChildsOrder()

static ilSkillTreeNode::saveChildsOrder (   $a_par_id,   $a_childs_order,   $a_templates = false  )

static

Save childs order.

Parameters

Definition at line 892 of file class.ilSkillTreeNode.php.

References $c, $skill_tree, _writeOrderNr(), and ilUtil\sortArray().

Referenced by ilSkillTreeNodeGUI\confirmedDelete(), ilSkillTreeNodeGUI\cutItems(), insertItemsFromClip(), ilSkillTreeNodeGUI\save(), and ilSkillTreeNodeGUI\saveOrder().

    {
        $skill_tree = new ilSkillTree();
        
        if ($a_par_id != $skill_tree->readRootId()) {
            $childs = $skill_tree->getChilds($a_par_id);
        } else {
            if ($a_templates) {
                $childs = $skill_tree->getChildsByTypeFilter(
                    $a_par_id,
                    array("skrt", "sktp", "sctp")
                );
            } else {
                $childs = $skill_tree->getChildsByTypeFilter(
                    $a_par_id,
                    array("skrt", "skll", "scat", "sktr")
                );
            }
        }
        
        foreach ($childs as $k => $c) {
            if (isset($a_childs_order[$c["child"]])) {
                $childs[$k]["order_nr"] = (int) $a_childs_order[$c["child"]];
            }
        }
        
        $childs = ilUtil::sortArray($childs, "order_nr", "asc", true);

        $cnt = 10;
        foreach ($childs as $c) {
            ilSkillTreeNode::_writeOrderNr($c["child"], $cnt);
            $cnt += 10;
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

setCreationDate()

ilSkillTreeNode::setCreationDate (   $a_val )

protected

Set creation date.

Parameters

string

$a_val

creation date

Definition at line 192 of file class.ilSkillTreeNode.php.

Referenced by read().

    {
        $this->creation_date = $a_val;
    }

Here is the caller graph for this function:

setDataRecord()

ilSkillTreeNode::setDataRecord

(

$a_record

)

this method should only be called by class ilSCORM2004NodeFactory

Definition at line 271 of file class.ilSkillTreeNode.php.

    {
        $this->data_record = $a_record;
    }

setDescription()

ilSkillTreeNode::setDescription

(

$a_description

)

Set description.

Parameters

string

$a_description

description

Definition at line 72 of file class.ilSkillTreeNode.php.

Referenced by read().

    {
        $this->description = $a_description;
    }

Here is the caller graph for this function:

setId()

ilSkillTreeNode::setId

(

$a_id

)

Set Node ID.

Parameters

int

Node ID

Definition at line 112 of file class.ilSkillTreeNode.php.

Referenced by create().

    {
        $this->id = $a_id;
    }

Here is the caller graph for this function:

setImportId()

ilSkillTreeNode::setImportId

(

$a_val

)

Set import id.

Parameters

string

$a_val

import id

Definition at line 172 of file class.ilSkillTreeNode.php.

Referenced by read().

    {
        $this->import_id = $a_val;
    }

Here is the caller graph for this function:

setOrderNr()

ilSkillTreeNode::setOrderNr

(

$a_val

)

Set order nr.

Parameters

int

$a_val

order nr

Definition at line 152 of file class.ilSkillTreeNode.php.

Referenced by read().

    {
        $this->order_nr = $a_val;
    }

Here is the caller graph for this function:

setSelfEvaluation()

ilSkillTreeNode::setSelfEvaluation

(

$a_val

)

Set self evaluation.

Parameters

boolean

self evaluation

Definition at line 132 of file class.ilSkillTreeNode.php.

Referenced by read().

    {
        $this->self_eval = $a_val;
    }

Here is the caller graph for this function:

setStatus()

ilSkillTreeNode::setStatus

(

$a_val

)

Set status.

Parameters

boolean

$a_val

status

Definition at line 380 of file class.ilSkillTreeNode.php.

Referenced by read().

    {
        $this->status = $a_val;
    }

Here is the caller graph for this function:

setTitle()

ilSkillTreeNode::setTitle

(

$a_title

)

Set title.

Parameters

string

$a_title

title

Definition at line 52 of file class.ilSkillTreeNode.php.

Referenced by read().

    {
        $this->title = $a_title;
    }

Here is the caller graph for this function:

setType()

ilSkillTreeNode::setType

(

$a_type

)

Set type.

Parameters

string

Type

Definition at line 92 of file class.ilSkillTreeNode.php.

Referenced by ilBasicSkillTemplate\__construct(), ilSkillRoot\__construct(), ilSkillTemplateCategory\__construct(), ilSkillCategory\__construct(), ilSkillTemplateReference\__construct(), ilBasicSkill\__construct(), and read().

    {
        $this->type = $a_type;
    }

Here is the caller graph for this function:

uniqueTypesCheck()

static ilSkillTreeNode::uniqueTypesCheck (   $a_items )

static

Check for unique types.

Definition at line 570 of file class.ilSkillTreeNode.php.

References $type, and _lookupType().

Referenced by ilSkillTreeNodeGUI\copyItems(), and ilSkillTreeNodeGUI\cutItems().

    {
        $types = array();
        if (is_array($a_items)) {
            foreach ($a_items as $item) {
                $type = ilSkillTreeNode::_lookupType($item);
                $types[$type] = $type;
            }
        }

        if (count($types) > 1) {
            return false;
        }
        return true;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

update()

ilSkillTreeNode::update

(

)

Update Node.

Definition at line 482 of file class.ilSkillTreeNode.php.

References $db, $ilDB, $query, getDescription(), getId(), getImportId(), getOrderNr(), getSelfEvaluation(), getStatus(), and getTitle().

    {
        $ilDB = $this->db;

        $query = "UPDATE skl_tree_node SET " .
            " title = " . $ilDB->quote($this->getTitle(), "text") .
            " ,description = " . $ilDB->quote($this->getDescription(), "clob") .
            " ,self_eval = " . $ilDB->quote((int) $this->getSelfEvaluation(), "integer") .
            " ,order_nr = " . $ilDB->quote((int) $this->getOrderNr(), "integer") .
            " ,status = " . $ilDB->quote((int) $this->getStatus(), "integer") .
            " ,import_id = " . $ilDB->quote($this->getImportId(), "text") .
            " WHERE obj_id = " . $ilDB->quote($this->getId(), "integer");

        $ilDB->manipulate($query);
    }

Here is the call graph for this function:

Field Documentation

$db

ilSkillTreeNode::$db

protected

Definition at line 15 of file class.ilSkillTreeNode.php.

Referenced by create(), ilSkillTemplateCategory\delete(), ilBasicSkillTemplate\delete(), delete(), read(), and update().

$description

ilSkillTreeNode::$description

Definition at line 28 of file class.ilSkillTreeNode.php.

Referenced by getDescription().

$id

ilSkillTreeNode::$id

Definition at line 26 of file class.ilSkillTreeNode.php.

Referenced by clipboardCopy(), clipboardCut(), create(), getAllCSkillIdsForNodeIds(), and getId().

$skill_tree

ilSkillTreeNode::$skill_tree

Definition at line 20 of file class.ilSkillTreeNode.php.

Referenced by findSkills(), isInTree(), putInTree(), and saveChildsOrder().

$title

ilSkillTreeNode::$title

Definition at line 27 of file class.ilSkillTreeNode.php.

Referenced by getTitle().

$type

ilSkillTreeNode::$type

Definition at line 25 of file class.ilSkillTreeNode.php.

Referenced by getIconPath(), getType(), and uniqueTypesCheck().

STATUS_DRAFT

const ilSkillTreeNode::STATUS_DRAFT = 1

Definition at line 23 of file class.ilSkillTreeNode.php.

Referenced by ilPersonalSkillExplorerGUI\buildSelectableTree(), ilSkillTemplateTreeExplorerGUI\getChildsOfNode(), ilVirtualSkillTree\getChildsOfNode(), ilPersonalSkillsGUI\getGapAnalysisHTML(), ilSkillDataSet\importRecord(), ilPersonalSkillsGUI\listSkills(), ilPersonalSkillsGUI\renderSkillHTML(), and ilSkillTreeNodeGUI\setTitleIcon().

STATUS_OUTDATED

const ilSkillTreeNode::STATUS_OUTDATED = 2

Definition at line 24 of file class.ilSkillTreeNode.php.

Referenced by ilPersonalSkillExplorerGUI\buildSelectableTree(), and ilVirtualSkillTree\getChildsOfNode().

STATUS_PUBLISH

const ilSkillTreeNode::STATUS_PUBLISH = 0

Definition at line 22 of file class.ilSkillTreeNode.php.

---

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

• Services/Skill/classes/class.ilSkillTreeNode.php