ilSkillTreeDBRepository Class Reference

Inheritance diagram for ilSkillTreeDBRepository:

Collaboration diagram for ilSkillTreeDBRepository:

Public Member Functions
	__construct (Tree\SkillTreeFactory $tree_factory, ilDBInterface $db=null)
	getCommonSkillIdForImportId (int $a_source_inst_id, int $a_skill_import_id, int $a_tref_import_id=0)
	@inheritDoc More...
	getLevelIdForImportId (int $a_source_inst_id, int $a_level_import_id)
	@inheritDoc More...
	isInAnyTree (int $node_id)
	getTreeIdForNodeId (int $node_id)
	getTreeForNodeId (int $node_id)
	getVirtualTreeForNodeId (int $node_id)
	getParentNodeIdForNodeId (int $node_id)
	getCommonSkillIdForImportId (int $a_source_inst_id, int $a_skill_import_id, int $a_tref_import_id=0)
	Get common skill ids for import IDs (newest first) More...
	getLevelIdForImportId (int $a_source_inst_id, int $a_level_import_id)
	Get level ids for import IDs (newest first) More...
	isInAnyTree (int $node_id)
	getTreeIdForNodeId (int $node_id)
	getTreeForNodeId (int $node_id)
	getVirtualTreeForNodeId (int $node_id)
	getParentNodeIdForNodeId (int $node_id)

Protected Attributes
ilDBInterface	$db
Tree SkillTreeFactory	$tree_factory

Detailed Description

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

Constructor & Destructor Documentation

__construct()

ilSkillTreeDBRepository::__construct	(	Tree\SkillTreeFactory	$tree_factory,
		ilDBInterface	$db = null
	)

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

    {
        global $DIC;
 
        $this->tree_factory = $tree_factory;
        $this->db = ($db)
            ?: $DIC->database();
    }

References $db, $DIC, and $tree_factory.

Member Function Documentation

getCommonSkillIdForImportId()

ilSkillTreeDBRepository::getCommonSkillIdForImportId	(	int	$a_source_inst_id,
		int	$a_skill_import_id,
		int	$a_tref_import_id = 0
	)

@inheritDoc

Implements ilSkillTreeRepository.

Definition at line 39 of file class.ilSkillTreeDBRepository.php.

     : array {
        $ilDB = $this->db;
 
        $template_ids = [];
        if ($a_tref_import_id > 0) {
            $skill_node_type = "sktp";
 
            // get all matching tref nodes
            $set = $ilDB->query("SELECT * FROM skl_tree_node n JOIN skl_tree t ON (n.obj_id = t.child) " .
                " WHERE n.import_id = " . $ilDB->quote(
                    "il_" . ($a_source_inst_id) . "_sktr_" . $a_tref_import_id,
                    "text"
                ) .
                " ORDER BY n.creation_date DESC ");
            while ($rec = $ilDB->fetchAssoc($set)) {
                if (($t = ilSkillTemplateReference::_lookupTemplateId($rec["obj_id"])) > 0) {
                    $template_ids[$t] = (int) $rec["obj_id"];
                }
            }
        } else {
            $skill_node_type = "skll";
        }
        $set = $ilDB->query("SELECT * FROM skl_tree_node n JOIN skl_tree t ON (n.obj_id = t.child) " .
            " WHERE n.import_id = " . $ilDB->quote(
                "il_" . ($a_source_inst_id) . "_" . $skill_node_type . "_" . $a_skill_import_id,
                "text"
            ) .
            " ORDER BY n.creation_date DESC ");
        $results = [];
        while ($rec = $ilDB->fetchAssoc($set)) {
            $matching_trefs = [];
            if ($a_tref_import_id > 0) {
                $tree = $this->tree_factory->getTreeById($rec["skl_tree_id"]);
                $skill_template_id = $tree->getTopParentNodeId($rec["obj_id"]);
 
                // check of skill is in template
                foreach ($template_ids as $templ => $tref) {
                    if ($skill_template_id == $templ) {
                        $matching_trefs[] = $tref;
                    }
                }
            } else {
                $matching_trefs = array(0);
            }
 
            foreach ($matching_trefs as $t) {
                $results[] = array("skill_id" => (int) $rec["obj_id"],
                                   "tref_id" => $t,
                                   "creation_date" => $rec["creation_date"]
                );
            }
        }
        return $results;
    }

References $ilDB, ilSkillTemplateReference\_lookupTemplateId(), and ILIAS\Repository\int().

Here is the call graph for this function:

getLevelIdForImportId()

ilSkillTreeDBRepository::getLevelIdForImportId	(	int	$a_source_inst_id,
		int	$a_level_import_id
	)

@inheritDoc

Implements ilSkillTreeRepository.

Definition at line 101 of file class.ilSkillTreeDBRepository.php.

                                                                                        : array
    {
        $ilDB = $this->db;
 
        $set = $ilDB->query("SELECT * FROM skl_level l JOIN skl_tree t ON (l.skill_id = t.child) " .
            " WHERE l.import_id = " . $ilDB->quote(
                "il_" . ($a_source_inst_id) . "_sklv_" . $a_level_import_id,
                "text"
            ) .
            " ORDER BY l.creation_date DESC ");
        $results = [];
        while ($rec = $ilDB->fetchAssoc($set)) {
            $results[] = array("level_id" => (int) $rec["id"], "creation_date" => $rec["creation_date"]);
        }
        return $results;
    }

References $ilDB, and $results.

getParentNodeIdForNodeId()

ilSkillTreeDBRepository::getParentNodeIdForNodeId

(

int

$node_id

)

Implements ilSkillTreeRepository.

Definition at line 153 of file class.ilSkillTreeDBRepository.php.

                                                          : int
    {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT * FROM skl_tree " .
            " WHERE child = %s ",
            ["integer"],
            [$node_id]
        );
        $rec = $db->fetchAssoc($set);
        return (int) ($rec["parent"] ?? 0);
    }

References ilDBInterface\fetchAssoc(), and ilDBInterface\queryF().

Here is the call graph for this function:

getTreeForNodeId()

ilSkillTreeDBRepository::getTreeForNodeId

(

int

$node_id

)

Implements ilSkillTreeRepository.

Definition at line 141 of file class.ilSkillTreeDBRepository.php.

                                                  : ilSkillTree
    {
        $tree_id = $this->getTreeIdForNodeId($node_id);
        return $this->tree_factory->getTreeById($tree_id);
    }

getTreeIdForNodeId()

ilSkillTreeDBRepository::getTreeIdForNodeId

(

int

$node_id

)

Implements ilSkillTreeRepository.

Definition at line 127 of file class.ilSkillTreeDBRepository.php.

                                                    : int
    {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT * FROM skl_tree " .
            " WHERE child = %s ",
            ["integer"],
            [$node_id]
        );
        $rec = $db->fetchAssoc($set);
        return (int) ($rec["skl_tree_id"] ?? 0);
    }

References ilDBInterface\fetchAssoc(), and ilDBInterface\queryF().

Here is the call graph for this function:

getVirtualTreeForNodeId()

ilSkillTreeDBRepository::getVirtualTreeForNodeId

(

int

$node_id

)

Implements ilSkillTreeRepository.

Definition at line 147 of file class.ilSkillTreeDBRepository.php.

                                                         : ilVirtualSkillTree
    {
        $tree_id = $this->getTreeIdForNodeId($node_id);
        return $this->tree_factory->getVirtualTreeById($tree_id);
    }

isInAnyTree()

ilSkillTreeDBRepository::isInAnyTree

(

int

$node_id

)

Implements ilSkillTreeRepository.

Definition at line 118 of file class.ilSkillTreeDBRepository.php.

                                             : bool
    {
        $tree_id = $this->getTreeIdForNodeId($node_id);
        if ($tree_id > 0) {
            return true;
        }
        return false;
    }

Field Documentation

$db

ilDBInterface ilSkillTreeDBRepository::$db

protected

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

Referenced by __construct().

$tree_factory

Tree SkillTreeFactory ilSkillTreeDBRepository::$tree_factory

protected

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

Referenced by __construct().

---

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

• Services/Skill/Tree/class.ilSkillTreeDBRepository.php