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)

	getLevelIdForImportId (int $a_source_inst_id, int $a_level_import_id)

	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 24 of file class.ilSkillTreeDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

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

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

References $db, $DIC, and $tree_factory.

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

Member Function Documentation

◆ getCommonSkillIdForImportId()

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

Implements ilSkillTreeRepository.

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

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

      : 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((int) $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((int) $rec["skl_tree_id"]);
                 $skill_template_id = $tree->getTopParentNodeId((int) $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;
     }

Here is the call graph for this function:

◆ getLevelIdForImportId()

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

Implements ilSkillTreeRepository.

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

References $db, $ilDB, and $results.

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

◆ getParentNodeIdForNodeId()

ilSkillTreeDBRepository::getParentNodeIdForNodeId ( int $node_id )

Implements ilSkillTreeRepository.

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

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

                                                           : 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);
     }

Here is the call graph for this function:

◆ getTreeForNodeId()

ilSkillTreeDBRepository::getTreeForNodeId ( int $node_id )

Implements ilSkillTreeRepository.

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

References getTreeIdForNodeId().

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

Here is the call graph for this function:

◆ getTreeIdForNodeId()

ilSkillTreeDBRepository::getTreeIdForNodeId ( int $node_id )

Implements ilSkillTreeRepository.

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

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

Referenced by getTreeForNodeId(), getVirtualTreeForNodeId(), and isInAnyTree().

                                                     : 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);
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getVirtualTreeForNodeId()

ilSkillTreeDBRepository::getVirtualTreeForNodeId ( int $node_id )

Implements ilSkillTreeRepository.

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

References getTreeIdForNodeId().

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

Here is the call graph for this function:

◆ isInAnyTree()

ilSkillTreeDBRepository::isInAnyTree ( int $node_id )

Implements ilSkillTreeRepository.

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

References getTreeIdForNodeId().

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