/** * Get usage info * * @param * @return */ public static function getUsageInfo($a_cskill_ids, &$a_usages) { global $ilDB; include_once "./Services/Skill/classes/class.ilSkillUsage.php"; ilSkillUsage::getUsageInfoGeneric($a_cskill_ids, $a_usages, ilSkillUsage::USER_ASSIGNED, "skl_user_skill_level", "user_id"); }
/** * Get usage info * * @param * @return */ public static function getUsageInfo($a_cskill_ids, &$a_usages) { global $ilDB; include_once "./Services/Skill/classes/class.ilSkillUsage.php"; ilSkillUsage::getUsageInfoGeneric($a_cskill_ids, $a_usages, ilSkillUsage::PROFILE, "skl_profile_level", "profile_id", "base_skill_id"); }
/** * Get usage info * * @param * @return */ public static function getUsageInfo($a_cskill_ids, &$a_usages) { global $ilDB; include_once "./Services/Skill/classes/class.ilSkillUsage.php"; ilSkillUsage::getUsageInfoGeneric($a_cskill_ids, $a_usages, ilSkillUsage::RESOURCE, "skl_skill_resource", "rep_ref_id", "base_skill_id"); }
/** * Get usage info * * @param array $a_cskill_ids skill ids * @param array $a_usages usages array */ public static function getUsageInfo($a_cskill_ids, &$a_usages) { global $ilDB; // material include_once "./Services/Skill/classes/class.ilSkillUsage.php"; ilSkillUsage::getUsageInfoGeneric($a_cskill_ids, $a_usages, ilSkillUsage::USER_MATERIAL, "skl_assigned_material", "user_id"); // self evaluations ilSkillUsage::getUsageInfoGeneric($a_cskill_ids, $a_usages, ilSkillUsage::SELF_EVAL, "skl_self_eval_level", "user_id"); // users that use the skills as personal skills $pskill_ids = array(); $tref_ids = array(); foreach ($a_cskill_ids as $cs) { if ($cs["tref_id"] > 0) { include_once "./Services/Skill/classes/class.ilSkillTemplateReference.php"; if (ilSkillTemplateReference::_lookupTemplateId($cs["tref_id"]) == $cs["skill_id"]) { $pskill_ids[$cs["tref_id"]] = $cs["tref_id"]; $tref_ids[(int) $cs["tref_id"]] = $cs["skill_id"]; } } else { $pskill_ids[$cs["skill_id"]] = $cs["skill_id"]; } } $set = $ilDB->query("SELECT skill_node_id, user_id FROM skl_personal_skill " . " WHERE " . $ilDB->in("skill_node_id", $pskill_ids, false, "integer") . " GROUP BY skill_node_id, user_id"); while ($rec = $ilDB->fetchAssoc($set)) { if (isset($tref_ids[(int) $rec["skill_node_id"]])) { $a_usages[$tref_ids[$rec["skill_node_id"]] . ":" . $rec["skill_node_id"]][ilSkillUsage::PERSONAL_SKILL][] = array("key" => $rec["user_id"]); } else { $a_usages[$rec["skill_node_id"] . ":0"][ilSkillUsage::PERSONAL_SKILL][] = array("key" => $rec["user_id"]); } } }