ilBasicSkillTreeDBRepository Class Reference

Inheritance diagram for ilBasicSkillTreeDBRepository:

Collaboration diagram for ilBasicSkillTreeDBRepository:

Public Member Functions
	__construct (ilDBInterface $db=null)
	getCommonSkillIdForImportId (ilSkillTree $tree, 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...
	getCommonSkillIdForImportId (ilSkillTree $tree, 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...

Protected Attributes
	$db

Detailed Description

Definition at line 3 of file class.ilBasicSkillTreeDBRepository.php.

Constructor & Destructor Documentation

__construct()

ilBasicSkillTreeDBRepository::__construct

(

ilDBInterface

$db = null

)

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

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

References $db, and $DIC.

Member Function Documentation

getCommonSkillIdForImportId()

ilBasicSkillTreeDBRepository::getCommonSkillIdForImportId	(	ilSkillTree	$tree,
		int	$a_source_inst_id,
		int	$a_skill_import_id,
		int	$a_tref_import_id = 0
	)

@inheritDoc

Implements ilBasicSkillTreeRepository.

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

      : array {
        $ilDB = $this->db;
 
        $template_ids = array();
        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_" . ((int) $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] = $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_" . ((int) $a_source_inst_id) . "_" . $skill_node_type . "_" . $a_skill_import_id,
                "text") .
            " ORDER BY n.creation_date DESC ");
        $results = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $matching_trefs = array();
            if ($a_tref_import_id > 0) {
                $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" => $rec["obj_id"],
                                   "tref_id" => $t,
                                   "creation_date" => $rec["creation_date"]
                );
            }
        }
        return $results;
    }

getLevelIdForImportId()

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

@inheritDoc

Implements ilBasicSkillTreeRepository.

Definition at line 80 of file class.ilBasicSkillTreeDBRepository.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_" . ((int) $a_source_inst_id) . "_sklv_" . $a_level_import_id,
                "text") .
            " ORDER BY l.creation_date DESC ");
        $results = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $results[] = array("level_id" => $rec["id"], "creation_date" => $rec["creation_date"]);
        }
        return $results;
    }

References $ilDB, and $results.

Field Documentation

$db

ilBasicSkillTreeDBRepository::$db

protected

Definition at line 8 of file class.ilBasicSkillTreeDBRepository.php.

Referenced by __construct().

---

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

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