/** * Get self evaluation * * @param int $a_user_id user id * @param int $a_top_skill the "selectable" top skill * @param int $a_tref_id template reference id * @param int $a_basic_skill the basic skill the level belongs to * @return int level id */ static function getSelfEvaluation($a_user_id, $a_top_skill, $a_tref_id, $a_basic_skill) { global $ilDB; include_once "./Services/Skill/classes/class.ilBasicSkill.php"; $bs = new ilBasicSkill($a_basic_skill); return $bs->getLastLevelPerObject($a_tref_id, 0, $a_user_id, 1); $set = $ilDB->query("SELECT level_id FROM skl_self_eval_level " . " WHERE user_id = " . $ilDB->quote($a_user_id, "integer") . " AND top_skill_id = " . $ilDB->quote($a_top_skill, "integer") . " AND tref_id = " . $ilDB->quote((int) $a_tref_id, "integer") . " AND skill_id = " . $ilDB->quote($a_basic_skill, "integer")); $rec = $ilDB->fetchAssoc($set); return (int) $rec["level_id"]; }