ilSkillDataSet Class Reference

Skill Data set class. More...

Inheritance diagram for ilSkillDataSet:

Collaboration diagram for ilSkillDataSet:

Public Member Functions
	__construct ()
	setMode (string $a_val)
	getMode ()
	setSelectedNodes (array $a_val)
	getSelectedNodes ()
	setSelectedProfiles (array $a_val)
	getSelectedProfiles ()
	setSkillTreeId (int $skill_tree_id)
	getSkillTreeId ()
	getSupportedVersions ()
	readData (string $a_entity, string $a_version, array $a_ids)
	Read data from DB. More...
	importRecord (string $a_entity, array $a_types, array $a_rec, ilImportMapping $a_mapping, string $a_schema_version)
	Needs to be overwritten for import use case. More...
Public Member Functions inherited from ilDataSet
	__construct ()
	init (string $a_entity, string $a_schema_version)
	Init. More...
	getSupportedVersions ()
	readData (string $a_entity, string $a_version, array $a_ids)
	Read data from DB. More...
	setExportDirectories (string $a_relative, string $a_absolute)
	setImportDirectory (string $a_val)
	getImportDirectory ()
	setDSPrefix (string $a_val)
	getDSPrefix ()
	getDSPrefixString ()
	getDirectDataFromQuery (string $a_query, bool $a_convert_to_leading_upper=true, bool $a_set=true)
	Get data from query.This is a standard procedure, all db field names are directly mapped to abstract fields. More...
	convertToLeadingUpper (string $a_str)
	Make xyz_abc a XyzAbc string. More...
	getXmlRepresentation (string $a_entity, string $a_schema_version, ?array $a_ids, string $a_field="", bool $a_omit_header=false, bool $a_omit_types=false)
	Get xml representation <dataset install_id="123" install_url="..."> <types entity="table_name" version="4.0.1"> <ftype name="field_1" type="text" > <ftype name="field_2" type="date" > <ftype name="field_3" type="integer" > </types> <types ...> ... </types> <set entity="table_name"> <rec> <field_1>content</field_1> <field_2>my_date</field_2> <field_3>my_number</field_3> </rec> ... </set> </dataset> More...
	addRecordsXml (ilXmlWriter $a_writer, array $a_prefixes, string $a_entity, string $a_schema_version, array $a_ids, ?string $a_field="")
	afterXmlRecordWriting (string $a_entity, string $a_version, array $a_set)
	getNamespaces (array &$namespaces, string $a_entity, string $a_schema_version)
	getXmlRecord (string $a_entity, string $a_version, array $a_set)
	Get xml record for version. More...
	getXmlTypes (string $a_entity, string $a_version)
	Get xml types. More...
	getXMLEntityName (string $a_entity, string $a_version)
	Get entity name for xml (may be overwritten) More...
	getXMLEntityTag (string $a_entity, string $a_schema_version)
	Get entity tag. More...
	setImport (ilSurveyImporter $a_val)
	getImport ()
	setCurrentInstallationId (string $a_val)
	getCurrentInstallationId ()
	importRecord (string $a_entity, array $a_types, array $a_rec, ilImportMapping $a_mapping, string $a_schema_version)
	Needs to be overwritten for import use case. More...

Data Fields
const	MODE_SKILLS = ""
const	MODE_PROFILES = "prof"
Data Fields inherited from ilDataSet
const	EXPORT_NO_INST_ID = 1
const	EXPORT_ID_ILIAS_LOCAL = 2
const	EXPORT_ID_ILIAS_LOCAL_INVALID = 3
const	EXPORT_ID_ILIAS_REMOTE = 4
const	EXPORT_ID_ILIAS_REMOTE_INVALID = 5
const	EXPORT_ID = 6
const	EXPORT_ID_INVALID = 7
int	$dircnt = 0

Protected Member Functions
	getXmlNamespace (string $a_entity, string $a_schema_version)
	getTypes (string $a_entity, string $a_version)
	Get field types for entity. More...
	getDependencies (string $a_entity, string $a_version, ?array $a_rec=null, ?array $a_ids=null)
Protected Member Functions inherited from ilDataSet
	getTypes (string $a_entity, string $a_version)
	Get (abstract) types for (abstract) field names. More...
	getXmlNamespace (string $a_entity, string $a_schema_version)
	getDependencies (string $a_entity, string $a_version, ?array $a_rec=null, ?array $a_ids=null)
	createObjectExportId (string $a_type, string $a_id)
	Build ilias export id. More...
	parseObjectExportId (string $a_id, ?string $a_fallback_id=null)
	Parse export id. More...
	stripTags (array $rec, array $omit_keys=[])

Protected Attributes
ilSkillTreeRepository	$tree_repo
int	$skill_tree_id = 0
int	$skill_tree_root_id = 0
int	$init_top_order_nr = 0
int	$init_templ_top_order_nr = 0
array	$selected_nodes = []
array	$selected_profiles = []
string	$mode = ""
SkillInternalManagerService	$skill_manager
SkillTreeFactory	$skill_tree_factory
SkillInternalFactoryService	$skill_factory
Protected Attributes inherited from ilDataSet
string	$current_installation_id = ""
array	$data = []
ilDBInterface	$db
ilLogger	$ds_log
string	$import_directory = ""
string	$entity = ""
string	$schema_version = ""
string	$relative_export_dir = ""
string	$absolute_export_dir = ""
string	$ds_prefix = "ds"
string	$version = ""
ilSurveyImporter	$import

Detailed Description

Skill Data set class.

This class implements the following entities:

• skmg: Skill management top entity (no data, only dependecies)
• skee: Skill tree
• skl_subtree: Skill subtree (includes data of skl_tree, skl_tree_node and skl_templ_ref)
• skl_templ_subtree: Skill template subtree (includes data of skl_tree and skl_tree_node)
• skl_level: Skill levels
• skl_prof: skill profiles (different mode)

Author

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

Definition at line 38 of file class.ilSkillDataSet.php.

Constructor & Destructor Documentation

__construct()

ilSkillDataSet::__construct

(

)

Reimplemented from ilDataSet.

Definition at line 64 of file class.ilSkillDataSet.php.

    {
        global $DIC;
 
        $this->db = $DIC->database();
        parent::__construct();
 
        $this->skill_manager = $DIC->skills()->internal()->manager();
        $this->skill_tree_factory = $DIC->skills()->internal()->factory()->tree();
        $this->skill_factory = $DIC->skills()->internal()->factory();
        $this->tree_repo = $DIC->skills()->internal()->repo()->getTreeRepo();
    }

References $DIC, and ILIAS\GlobalScreen\Provider\__construct().

Here is the call graph for this function:

Member Function Documentation

getDependencies()

ilSkillDataSet::getDependencies ( string  $a_entity, string  $a_version, ?array  $a_rec = null, ?array  $a_ids = null  )

protected

Parameters

array{Id

int, Child: int, Type: string} $a_rec

Returns

array<string, array{ids: int[]}>

Reimplemented from ilDataSet.

Definition at line 515 of file class.ilSkillDataSet.php.

     : array {
        $ilDB = $this->db;
 
 
        switch ($a_entity) {
            case "skmg":
                $deps["skee"]["ids"] = $a_ids;
                return $deps;
 
            case "skee":
                if (!isset($a_rec["Id"]) || is_null($a_rec["Id"])) {
                    return [];
                }
                $skill_tree = $this->skill_tree_factory->getTreeById((int) $a_rec["Id"]);
 
                $deps = [];
                if ($this->getMode() == self::MODE_SKILLS) {
                    // determine top nodes of main tree to be exported and all referenced template nodes
                    $sel_nodes = $this->getSelectedNodes();
                    $exp_types = array("skll", "scat", "sctr", "sktr");
                    if (!isset($sel_nodes) || count($sel_nodes) === 0) {
                        $childs = $skill_tree->getChildsByTypeFilter($skill_tree->readRootId(), $exp_types);
                        $skl_subtree_deps = [];
                        foreach ($childs as $c) {
                            $skl_subtree_deps[] = (int) $c["child"];
                        }
                    } else {
                        $skl_subtree_deps = [];
                        foreach ($sel_nodes as $n) {
                            if (in_array(ilSkillTreeNode::_lookupType($n), $exp_types)) {
                                $skl_subtree_deps[] = $n;
                            }
                        }
                    }
 
                    // determine template subtrees
                    $ref_nodes = [];
                    if (is_array($skl_subtree_deps)) {
                        foreach ($skl_subtree_deps as $id) {
                            if (ilSkillTreeNode::_lookupType($id) == "sktr") {
                                $ref_nodes[$id] = $id;
                            } else {
                                $sub = $skill_tree->getSubTree($skill_tree->getNodeData($id), true, ["sktr"]);
                                foreach ($sub as $s) {
                                    $ref_nodes[$s["child"]] = $s["child"];
                                }
                            }
                        }
                    }
 
                    $set = $ilDB->query("SELECT DISTINCT(templ_id) FROM skl_templ_ref " .
                            " WHERE " . $ilDB->in("skl_node_id", $ref_nodes, false, "integer"));
                    while ($rec = $ilDB->fetchAssoc($set)) {
                        $deps["skl_templ_subtree"]["ids"][] = (int) $rec["templ_id"];
                    }
 
                    // export subtree after templates
                    $deps["skl_subtree"]["ids"] = $skl_subtree_deps;
                } elseif ($this->getMode() == self::MODE_PROFILES) {
                    foreach ($this->getSelectedProfiles() as $p_id) {
                        $deps["skl_prof"]["ids"][] = $p_id;
                    }
                }
                return $deps;
 
            case "skl_subtree":
            case "skl_templ_subtree":
                $deps = [];
                if (in_array($a_rec["Type"], array("skll", "sktp"))) {
                    $deps["skl_level"]["ids"][] = $a_rec["Child"];
                }
                return $deps;
 
            case "skl_prof":
            case "skl_local_prof":
                $deps["skl_prof_level"]["ids"][] = $a_rec["Id"] ?? null;
                return $deps;
        }
 
        return [];
    }

References $c, $id, $ilDB, ilSkillTreeNode\_lookupType(), getMode(), getSelectedNodes(), getSelectedProfiles(), and ILIAS\Repository\int().

Here is the call graph for this function:

getMode()

ilSkillDataSet::getMode

(

)

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

                             : string
    {
        return $this->mode;
    }

References $mode.

Referenced by getDependencies(), and readData().

Here is the caller graph for this function:

getSelectedNodes()

ilSkillDataSet::getSelectedNodes

(

)

Returns

int[]

Definition at line 98 of file class.ilSkillDataSet.php.

                                      : array
    {
        return $this->selected_nodes;
    }

References $selected_nodes.

Referenced by getDependencies().

Here is the caller graph for this function:

getSelectedProfiles()

ilSkillDataSet::getSelectedProfiles

(

)

Returns

int[] (profile ids)

Definition at line 114 of file class.ilSkillDataSet.php.

                                         : array
    {
        return $this->selected_profiles;
    }

References $selected_profiles.

Referenced by getDependencies().

Here is the caller graph for this function:

getSkillTreeId()

ilSkillDataSet::getSkillTreeId

(

)

Definition at line 124 of file class.ilSkillDataSet.php.

                                    : int
    {
        return $this->skill_tree_id;
    }

References $skill_tree_id.

Referenced by readData().

Here is the caller graph for this function:

getSupportedVersions()

ilSkillDataSet::getSupportedVersions

(

)

Returns

string[]

Reimplemented from ilDataSet.

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

                                          : array
    {
        return array("5.1.0", "7.0", "8.0");
    }

getTypes()

ilSkillDataSet::getTypes ( string  $a_entity, string  $a_version  )

protected

Get field types for entity.

Reimplemented from ilDataSet.

Definition at line 145 of file class.ilSkillDataSet.php.

                                                                    : array
    {
        if ($a_entity == "skmg") {
            switch ($a_version) {
                case "5.1.0":
                case "7.0":
                    return array(
                        "Mode" => "text"
                    );
                case "8.0":
                    return array(
                        "Id" => "integer"
                    );
            }
        }
        if ($a_entity == "skee") {
            switch ($a_version) {
                case "8.0":
                    return array(
                        "Id" => "integer",
                        "Mode" => "text"
                    );
            }
        }
        if ($a_entity == "skl_subtree") {
            switch ($a_version) {
                case "5.1.0":
                case "7.0":
                case "8.0":
                    return array(
                            "SklTreeId" => "integer",
                            "TopNode" => "integer",
                            "Child" => "integer",
                            "Parent" => "integer",
                            "Depth" => "integer",
                            "Type" => "text",
                            "Title" => "text",
                            "Description" => "text",
                            "SelfEval" => "integer",
                            "OrderNr" => "integer",
                            "Status" => "integer",
                            "TemplateId" => "integer"
                    );
            }
        }
        if ($a_entity == "skl_templ_subtree") {
            switch ($a_version) {
                case "5.1.0":
                case "7.0":
                case "8.0":
                    return array(
                            "SklTreeId" => "integer",
                            "TopNode" => "integer",
                            "Child" => "integer",
                            "Parent" => "integer",
                            "Depth" => "integer",
                            "Type" => "text",
                            "Title" => "text",
                            "Description" => "text",
                            "SelfEval" => "integer",
                            "OrderNr" => "integer",
                            "Status" => "integer"
                    );
            }
        }
        if ($a_entity == "skl_level") {
            switch ($a_version) {
                case "5.1.0":
                case "7.0":
                case "8.0":
                    return array(
                            "LevelId" => "integer",
                            "SkillId" => "integer",
                            "Nr" => "integer",
                            "Title" => "text",
                            "Description" => "text"
                    );
            }
        }
        if ($a_entity == "skl_prof") {
            switch ($a_version) {
                case "5.1.0":
                case "7.0":
                    return array(
                        "Id" => "integer",
                        "Title" => "text",
                        "Description" => "text"
                    );
                case "8.0":
                    return array(
                        "Id" => "integer",
                        "Title" => "text",
                        "Description" => "text",
                        "SkillTreeId" => "integer"
                    );
            }
        }
        if ($a_entity == "skl_local_prof") {
            switch ($a_version) {
                case "7.0":
                    return array(
                        "Id" => "integer",
                        "Title" => "text",
                        "Description" => "text",
                        "RefId" => "integer"
                    );
                case "8.0":
                    return array(
                            "Id" => "integer",
                            "Title" => "text",
                            "Description" => "text",
                            "RefId" => "integer",
                            "SkillTreeId" => "integer"
                    );
            }
        }
        if ($a_entity == "skl_prof_level") {
            switch ($a_version) {
                case "5.1.0":
                    return array(
                            "ProfileId" => "integer",
                            "BaseSkillId" => "integer",
                            "TrefId" => "integer",
                            "LevelId" => "integer"
                    );
                case "7.0":
                case "8.0":
                    return array(
                        "ProfileId" => "integer",
                        "BaseSkillId" => "integer",
                        "TrefId" => "integer",
                        "LevelId" => "integer",
                        "OrderNr" => "integer"
                    );
            }
        }
        return [];
    }

getXmlNamespace()

ilSkillDataSet::getXmlNamespace ( string  $a_entity, string  $a_schema_version  )

protected

Reimplemented from ilDataSet.

Definition at line 137 of file class.ilSkillDataSet.php.

                                                                                  : string
    {
        return "http://www.ilias.de/xml/Services/Skill/" . $a_entity;
    }

importRecord()

ilSkillDataSet::importRecord	(	string	$a_entity,
		array	$a_types,
		array	$a_rec,
		ilImportMapping	$a_mapping,
		string	$a_schema_version
	)

Needs to be overwritten for import use case.

Reimplemented from ilDataSet.

Definition at line 602 of file class.ilSkillDataSet.php.

     : void {
        $skill_tree = $this->skill_tree_factory->getTreeById($this->getSkillTreeId());
        $skill_tree_root_id = $skill_tree->readRootId();
        $tree_node_manager = $this->skill_manager->getTreeNodeManager($this->getSkillTreeId());
 
        $init_top_order_nr = $skill_tree->getMaxOrderNr($skill_tree_root_id);
        $init_templ_top_order_nr = $skill_tree->getMaxOrderNr($skill_tree_root_id, true);
 
        $source_inst_id = $a_mapping->getInstallId();
        switch ($a_entity) {
            case "skl_subtree":
                if ($a_rec["TopNode"] == 1) {
                    $parent = $skill_tree_root_id;
                    $status = ilSkillTreeNode::STATUS_DRAFT;
                    $order = (int) $a_rec["OrderNr"] + $init_top_order_nr;
                } else {
                    $parent = (int) $a_mapping->getMapping("Services/Skill", "skl_tree", $a_rec["Parent"]);
                    $status = (int) $a_rec["Status"];
                    $order = (int) $a_rec["OrderNr"];
                }
                switch ($a_rec["Type"]) {
                    case "scat":
                        $scat = new ilSkillCategory();
                        $scat->setTitle($a_rec["Title"]);
                        $scat->setDescription($a_rec["Description"] ?? "");
                        $scat->setImportId("il_" . $source_inst_id . "_scat_" . $a_rec["Child"]);
                        $scat->setSelfEvaluation((bool) $a_rec["SelfEval"]);
                        $scat->setOrderNr($order);
                        $scat->setStatus($status);
                        $scat->create();
                        $tree_node_manager->putIntoTree($scat, $parent);
                        $a_mapping->addMapping("Services/Skill", "skl_tree", $a_rec["Child"], $scat->getId());
                        break;
 
                    case "skll":
                        $skll = new ilBasicSkill();
                        $skll->setTitle($a_rec["Title"]);
                        $skll->setDescription($a_rec["Description"] ?? "");
                        $skll->setImportId("il_" . $source_inst_id . "_skll_" . $a_rec["Child"]);
                        $skll->setSelfEvaluation((bool) $a_rec["SelfEval"]);
                        $skll->setOrderNr($order);
                        $skll->setStatus($status);
                        $skll->create();
                        $tree_node_manager->putIntoTree($skll, $parent);
                        $a_mapping->addMapping("Services/Skill", "skl_tree", $a_rec["Child"], $skll->getId());
                        break;
 
                    case "sktr":
                        $template_id = (int) $a_mapping->getMapping("Services/Skill", "skl_tree", $a_rec["TemplateId"]);
                        // only create template references, if referenced template is found (template trees are imported first)
                        if ($template_id > 0) {
                            $sktr = new ilSkillTemplateReference();
                            $sktr->setTitle($a_rec["Title"]);
                            $sktr->setDescription($a_rec["Description"] ?? "");
                            $sktr->setImportId("il_" . $source_inst_id . "_sktr_" . $a_rec["Child"]);
                            $sktr->setSelfEvaluation((bool) $a_rec["SelfEval"]);
                            $sktr->setOrderNr($order);
                            $sktr->setSkillTemplateId($template_id);
                            $sktr->setStatus($status);
                            $sktr->create();
                            $tree_node_manager->putIntoTree($sktr, $parent);
                            $a_mapping->addMapping("Services/Skill", "skl_tree", $a_rec["Child"], $sktr->getId());
                        }
                        break;
 
                }
                break;
 
            case "skl_templ_subtree":
                if ($a_rec["TopNode"] == 1) {
                    $parent = $skill_tree_root_id;
                    $order = (int) $a_rec["OrderNr"] + $init_templ_top_order_nr;
                } else {
                    $parent = (int) $a_mapping->getMapping("Services/Skill", "skl_tree", $a_rec["Parent"]);
                    $order = (int) $a_rec["OrderNr"];
                }
                switch ($a_rec["Type"]) {
                    case "sctp":
                        $sctp = new ilSkillTemplateCategory();
                        $sctp->setTitle($a_rec["Title"]);
                        $sctp->setDescription($a_rec["Description"] ?? "");
                        $sctp->setImportId("il_" . $source_inst_id . "_sctp_" . $a_rec["Child"]);
                        $sctp->setOrderNr($order);
                        $sctp->create();
                        $tree_node_manager->putIntoTree($sctp, $parent);
                        $a_mapping->addMapping("Services/Skill", "skl_tree", $a_rec["Child"], $sctp->getId());
                        break;
 
                    case "sktp":
                        $sktp = new ilBasicSkillTemplate();
                        $sktp->setTitle($a_rec["Title"]);
                        $sktp->setDescription($a_rec["Description"] ?? "");
                        $sktp->setImportId("il_" . $source_inst_id . "_sktp_" . $a_rec["Child"]);
                        $sktp->setOrderNr($order);
                        $sktp->create();
                        $tree_node_manager->putIntoTree($sktp, $parent);
                        $a_mapping->addMapping("Services/Skill", "skl_tree", $a_rec["Child"], $sktp->getId());
                        break;
                }
                break;
 
            case "skl_level":
                $skill_id = (int) $a_mapping->getMapping("Services/Skill", "skl_tree", $a_rec["SkillId"]);
                $type = ilSkillTreeNode::_lookupType($skill_id);
                if (in_array($type, array("skll", "sktp"))) {
                    if ($type == "skll") {
                        $skill = new ilBasicSkill($skill_id);
                    } else {
                        $skill = new ilBasicSkillTemplate($skill_id);
                    }
                    $skill->addLevel($a_rec["Title"], $a_rec["Description"], "il_" . $source_inst_id . "_sklv_" . $a_rec["LevelId"]);
                    $skill->update();
                }
                break;
 
            case "skl_prof":
                $profile = $this->skill_factory->profile(
                    0,
                    $a_rec["Title"],
                    $a_rec["Description"] ?? "",
                    $this->getSkillTreeId()
                );
                $new_profile = $this->skill_manager->getProfileManager()->createProfile($profile);
 
                $a_mapping->addMapping("Services/Skill", "skl_prof", $a_rec["Id"], $new_profile->getId());
                break;
 
            case "skl_local_prof":
                $profile = $this->skill_factory->profile(
                    0,
                    $a_rec["Title"],
                    $a_rec["Description"] ?? "",
                    $this->getSkillTreeId(),
                    "",
                    $a_rec["RefId"]
                );
                $new_profile = $this->skill_manager->getProfileManager()->createProfile($profile);
 
                $a_mapping->addMapping("Services/Skill", "skl_local_prof", $a_rec["Id"], $new_profile->getId());
                break;
 
            case "skl_prof_level":
                $profile_id = (int) $a_mapping->getMapping("Services/Skill", "skl_prof", $a_rec["ProfileId"])
                    ? (int) $a_mapping->getMapping("Services/Skill", "skl_prof", $a_rec["ProfileId"])
                    : (int) $a_mapping->getMapping("Services/Skill", "skl_local_prof", $a_rec["ProfileId"]);
                if ($profile_id > 0) {
                    $prof = $this->skill_manager->getProfileManager()->getById($profile_id);
                    $level_id_data = ilBasicSkill::getLevelIdForImportId($this->getCurrentInstallationId(), $a_rec["LevelId"]);
                    $skill_data = ilBasicSkill::getCommonSkillIdForImportId($this->getCurrentInstallationId(), $a_rec["BaseSkillId"], $a_rec["TrefId"]);
                    $level_id = $tref_id = $base_skill = 0;
                    foreach ($level_id_data as $l) {
                        reset($skill_data);
                        foreach ($skill_data as $s) {
                            //          echo "<br>=".ilBasicSkill::lookupLevelSkillId($l["level_id"])."=".$s["skill_id"]."=";
 
                            if ($level_id == 0 && ilBasicSkill::lookupLevelSkillId($l["level_id"]) == $s["skill_id"]) {
                                $level_id = $l["level_id"];
                                $base_skill = $s["skill_id"];
                                $tref_id = $s["tref_id"];
                            }
                        }
                    }
                    if ($level_id > 0) {
                        $prof->addSkillLevel($base_skill, $tref_id, $level_id, $a_rec["OrderNr"]);
                    }
                    $this->skill_manager->getProfileManager()->updateProfile($prof);
                }
                break;
        }
    }

References $type, ilSkillTreeNode\_lookupType(), ilImportMapping\addMapping(), ilBasicSkill\getCommonSkillIdForImportId(), ilBasicSkill\getLevelIdForImportId(), ilImportMapping\getMapping(), ILIAS\Repository\int(), ilBasicSkill\lookupLevelSkillId(), and ilSkillTreeNode\STATUS_DRAFT.

Here is the call graph for this function:

readData()

ilSkillDataSet::readData	(	string	$a_entity,
		string	$a_version,
		array	$a_ids
	)

Read data from DB.

This should result in the abstract field structure of the version set in the constructor.

Reimplemented from ilDataSet.

Definition at line 284 of file class.ilSkillDataSet.php.

                                                                               : void
    {
        $ilDB = $this->db;
 
        $this->data = [];
 
        if (!is_array($a_ids)) {
            $a_ids = array($a_ids);
        }
        if ($a_entity == "skmg") {
            switch ($a_version) {
                case "5.1.0":
                case "7.0":
                    if ($this->getMode() == self::MODE_SKILLS) {
                        $this->data[] = array("Mode" => "Skills");
                    } elseif ($this->getMode() == self::MODE_PROFILES) {
                        $this->data[] = array("Mode" => "Profiles");
                    }
                    break;
                case "8.0":
                    $this->data[] = [
                        "Id" => $this->getSkillTreeId()
                    ];
                    break;
            }
        }
        if ($a_entity == "skee") {      // dummy node
            switch ($a_version) {
                case "8.0":
                foreach ($a_ids as $id) {
                    if ($this->getMode() == self::MODE_SKILLS) {
                        $this->data[] = array(
                            "Id" => $id,
                            "Mode" => "Skills"
                        );
                    } elseif ($this->getMode() == self::MODE_PROFILES) {
                        $this->data[] = array(
                            "Id" => $id,
                            "Mode" => "Profiles"
                        );
                    }
                }
                break;
 
            }
        }
        if ($a_entity == "skl_subtree") {       // get subtree for top node
            switch ($a_version) {
                case "5.1.0":
                case "7.0":
                case "8.0":
                    foreach ($a_ids as $id) {
                        $skill_tree = $this->tree_repo->getTreeForNodeId($id);
                        $sub = $skill_tree->getSubTree($skill_tree->getNodeData($id));
                        foreach ($sub as $s) {
                            $set = $ilDB->query(
                                "SELECT * FROM skl_templ_ref " .
                                " WHERE skl_node_id = " . $ilDB->quote($s["child"], "integer")
                            );
                            $rec = $ilDB->fetchAssoc($set);
 
                            $top_node = ($s["child"] == $id)
                                    ? 1
                                    : 0;
                            $this->data[] = array(
                                    "SklTreeId" => $s["skl_tree_id"],
                                    "TopNode" => $top_node,
                                    "Child" => $s["child"],
                                    "Parent" => $s["parent"],
                                    "Depth" => $s["depth"],
                                    "Type" => $s["type"],
                                    "Title" => $s["title"],
                                    "Description" => $s["description"],
                                    "SelfEval" => $s["self_eval"],
                                    "OrderNr" => $s["order_nr"],
                                    "Status" => $s["status"],
                                    "TemplateId" => (int) ($rec["templ_id"] ?? 0)
                                );
                        }
                    }
                    break;
 
            }
        }
 
        if ($a_entity == "skl_templ_subtree") { // get template subtree for template id
            switch ($a_version) {
                case "5.1.0":
                case "7.0":
                case "8.0":
                    foreach ($a_ids as $id) {
                        $skill_tree = $this->tree_repo->getTreeForNodeId($id);
                        $sub = $skill_tree->getSubTree($skill_tree->getNodeData($id));
                        foreach ($sub as $s) {
                            $top_node = ($s["child"] == $id)
                                    ? 1
                                    : 0;
                            $this->data[] = array(
                                    "SklTreeId" => $s["skl_tree_id"],
                                    "TopNode" => $top_node,
                                    "Child" => $s["child"],
                                    "Parent" => $s["parent"],
                                    "Depth" => $s["depth"],
                                    "Type" => $s["type"],
                                    "Title" => $s["title"],
                                    "Description" => $s["description"],
                                    "SelfEval" => $s["self_eval"],
                                    "OrderNr" => $s["order_nr"],
                                    "Status" => $s["status"]
                            );
                        }
                    }
                    break;
 
            }
        }
 
        if ($a_entity == "skl_level") {
            switch ($a_version) {
                case "5.1.0":
                case "7.0":
                case "8.0":
                    $this->getDirectDataFromQuery("SELECT id level_id, skill_id, nr, title, description" .
                            " FROM skl_level WHERE " .
                            $ilDB->in("skill_id", $a_ids, false, "integer") . " ORDER BY skill_id ASC, nr ASC");
                    break;
 
            }
        }
 
        if ($a_entity == "skl_prof") {
            switch ($a_version) {
                case "5.1.0":
                case "7.0":
                    $this->getDirectDataFromQuery("SELECT id, title, description" .
                            " FROM skl_profile WHERE " .
                            $ilDB->in("id", $a_ids, false, "integer"));
                    break;
                case "8.0":
                    $set = $ilDB->query(
                        "SELECT id, title, description FROM skl_profile " .
                        " WHERE " . $ilDB->in("id", $a_ids, false, "integer")
                    );
                    while ($rec = $ilDB->fetchAssoc($set)) {
                        $this->data[] = [
                            "Id" => $rec["id"],
                            "Title" => $rec["title"],
                            "Description" => $rec["description"],
                            "SkillTreeId" => $this->getSkillTreeId()
                        ];
                    }
                    break;
 
            }
        }
 
        if ($a_entity == "skl_local_prof") {
            switch ($a_version) {
                case "7.0":
                    foreach ($a_ids as $obj_id) {
                        $obj_ref_id = ilObject::_getAllReferences($obj_id);
                        $obj_ref_id = end($obj_ref_id);
                        $profiles = $this->skill_manager->getProfileManager()->getLocalProfilesForObject($obj_ref_id);
                        $profile_ids = [];
                        foreach ($profiles as $p) {
                            $profile_ids[] = $p["id"];
                        }
                        $set = $ilDB->query(
                            "SELECT * FROM skl_profile " .
                            " WHERE " . $ilDB->in("id", $profile_ids, false, "integer")
                        );
                        while ($rec = $ilDB->fetchAssoc($set)) {
                            $this->data[] = [
                                "Id" => $rec["id"],
                                "Title" => $rec["title"],
                                "Description" => $rec["description"],
                                "RefId" => $obj_ref_id
                            ];
                        }
                    }
                    break;
                case "8.0":
                    foreach ($a_ids as $obj_id) {
                        $obj_ref_id = ilObject::_getAllReferences((int)$obj_id);
                        $obj_ref_id = end($obj_ref_id);
                        $profiles = $this->skill_manager->getProfileManager()->getLocalProfilesForObject($obj_ref_id);
                        $profile_ids = [];
                        foreach ($profiles as $p) {
                            $profile_ids[] = $p["id"];
                        }
                        $set = $ilDB->query(
                            "SELECT * FROM skl_profile " .
                            " WHERE " . $ilDB->in("id", $profile_ids, false, "integer")
                        );
                        while ($rec = $ilDB->fetchAssoc($set)) {
                            $this->data[] = [
                                "Id" => $rec["id"],
                                "Title" => $rec["title"],
                                "Description" => $rec["description"],
                                "RefId" => $obj_ref_id,
                                "SkillTreeId" => $this->getSkillTreeId()
                            ];
                        }
                    }
                    break;
 
            }
        }
 
        if ($a_entity == "skl_prof_level") {
            switch ($a_version) {
                case "5.1.0":
                    $this->getDirectDataFromQuery("SELECT profile_id, base_skill_id, tref_id, level_id" .
                            " FROM skl_profile_level WHERE " .
                            $ilDB->in("profile_id", $a_ids, false, "integer"));
                    break;
                case "7.0":
                case "8.0":
                    $this->getDirectDataFromQuery("SELECT profile_id, base_skill_id, tref_id, level_id, order_nr" .
                        " FROM skl_profile_level WHERE " .
                        $ilDB->in("profile_id", $a_ids, false, "integer"));
                    break;
            }
        }
    }

References ilDataSet\$db, $id, $ilDB, ilObject\_getAllReferences(), ilDataSet\getDirectDataFromQuery(), getMode(), and getSkillTreeId().

Here is the call graph for this function:

setMode()

ilSkillDataSet::setMode

(

string

$a_val

)

Definition at line 77 of file class.ilSkillDataSet.php.

                                          : void
    {
        $this->mode = $a_val;
    }

setSelectedNodes()

ilSkillDataSet::setSelectedNodes

(

array

$a_val

)

Parameters

int[]

$a_val

Definition at line 90 of file class.ilSkillDataSet.php.

                                                  : void
    {
        $this->selected_nodes = $a_val;
    }

setSelectedProfiles()

ilSkillDataSet::setSelectedProfiles

(

array

$a_val

)

Parameters

int[]

$a_val

(profile ids)

Definition at line 106 of file class.ilSkillDataSet.php.

                                                     : void
    {
        $this->selected_profiles = $a_val;
    }

setSkillTreeId()

ilSkillDataSet::setSkillTreeId

(

int

$skill_tree_id

)

Definition at line 119 of file class.ilSkillDataSet.php.

                                                      : void
    {
        $this->skill_tree_id = $skill_tree_id;
    }

References $skill_tree_id.

Field Documentation

$init_templ_top_order_nr

int ilSkillDataSet::$init_templ_top_order_nr = 0

protected

Definition at line 47 of file class.ilSkillDataSet.php.

$init_top_order_nr

int ilSkillDataSet::$init_top_order_nr = 0

protected

Definition at line 46 of file class.ilSkillDataSet.php.

$mode

string ilSkillDataSet::$mode = ""

protected

Definition at line 58 of file class.ilSkillDataSet.php.

Referenced by getMode().

$selected_nodes

array ilSkillDataSet::$selected_nodes = []

protected

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

Referenced by getSelectedNodes().

$selected_profiles

array ilSkillDataSet::$selected_profiles = []

protected

Definition at line 57 of file class.ilSkillDataSet.php.

Referenced by getSelectedProfiles().

$skill_factory

SkillInternalFactoryService ilSkillDataSet::$skill_factory

protected

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

$skill_manager

SkillInternalManagerService ilSkillDataSet::$skill_manager

protected

Definition at line 60 of file class.ilSkillDataSet.php.

$skill_tree_factory

SkillTreeFactory ilSkillDataSet::$skill_tree_factory

protected

Definition at line 61 of file class.ilSkillDataSet.php.

$skill_tree_id

int ilSkillDataSet::$skill_tree_id = 0

protected

Definition at line 44 of file class.ilSkillDataSet.php.

Referenced by getSkillTreeId(), and setSkillTreeId().

$skill_tree_root_id

int ilSkillDataSet::$skill_tree_root_id = 0

protected

Definition at line 45 of file class.ilSkillDataSet.php.

$tree_repo

ilSkillTreeRepository ilSkillDataSet::$tree_repo

protected

Definition at line 42 of file class.ilSkillDataSet.php.

MODE_PROFILES

const ilSkillDataSet::MODE_PROFILES = "prof"

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

MODE_SKILLS

const ilSkillDataSet::MODE_SKILLS = ""

Definition at line 40 of file class.ilSkillDataSet.php.

---

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

• Services/Skill/Export/class.ilSkillDataSet.php