Collaboration diagram for ILIAS\Skill\Personal\PersonalSkillDBRepository:

Public Member Functions
	__construct (\ilSkillTreeRepository $tree_repo, \ilDBInterface $db=null, Service\SkillInternalFactoryService $factory_service=null)

	get (int $user_id)

	add (int $user_id, int $skill_node_id)

	remove (int $user_id, int $skill_node_id)

	removeAllForUser (int $user_id)

	removeAllForSkill (int $skill_node_id)

	getUsages (array $usages, array $pskill_ids, array $tref_ids)

Protected Member Functions
	getFromRecord (array $rec)

Protected Attributes
ilSkillTreeRepository	$tree_repo

ilDBInterface	$db

Service SkillInternalFactoryService	$factory_service

Detailed Description

Author: Thomas Famula famul.nosp@m.a@le.nosp@m.ifos..nosp@m.de

Definition at line 30 of file class.PersonalSkillDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ILIAS\Skill\Personal\PersonalSkillDBRepository::__construct	(	\ilSkillTreeRepository	$tree_repo,
		\ilDBInterface	$db = `null`,
		Service\SkillInternalFactoryService	$factory_service = `null`
	)

Definition at line 36 of file class.PersonalSkillDBRepository.php.

References ILIAS\Skill\Personal\PersonalSkillDBRepository\$db, $DIC, ILIAS\Skill\Personal\PersonalSkillDBRepository\$factory_service, and ILIAS\Skill\Personal\PersonalSkillDBRepository\$tree_repo.

       {
         global $DIC;
 
         $this->tree_repo = $tree_repo;
         $this->db = ($db) ?: $DIC->database();
         $this->factory_service = ($factory_service) ?: $DIC->skills()->internal()->factory();
     }

Member Function Documentation

◆ add()

ILIAS\Skill\Personal\PersonalSkillDBRepository::add	(	int	$user_id,
		int	$skill_node_id
	)

Definition at line 79 of file class.PersonalSkillDBRepository.php.

References ILIAS\Skill\Personal\PersonalSkillDBRepository\$db, and $ilDB.

                                                          : void
     {
         $ilDB = $this->db;
 
         $set = $ilDB->query(
             "SELECT * FROM skl_personal_skill " .
             " WHERE user_id = " . $ilDB->quote($user_id, "integer") .
             " AND skill_node_id = " . $ilDB->quote($skill_node_id, "integer")
         );
         if (!$ilDB->fetchAssoc($set)) {
             $ilDB->manipulate("INSERT INTO skl_personal_skill " .
                 "(user_id, skill_node_id) VALUES (" .
                 $ilDB->quote($user_id, "integer") . "," .
                 $ilDB->quote($skill_node_id, "integer") .
                 ")");
         }
     }

◆ get()

ILIAS\Skill\Personal\PersonalSkillDBRepository::get ( int $user_id )

Returns: array<int, SelectedUserSkill>

Definition at line 51 of file class.PersonalSkillDBRepository.php.

References ILIAS\Skill\Personal\PersonalSkillDBRepository\$db, $ilDB, $user_id, ILIAS\Skill\Personal\PersonalSkillDBRepository\getFromRecord(), and ILIAS\Repository\int().

                                      : array
     {
         $ilDB = $this->db;
 
         $set = $ilDB->query(
             "SELECT * FROM skl_personal_skill " .
             " WHERE user_id = " . $ilDB->quote($user_id, "integer")
         );
         $pskills = [];
         while ($rec = $ilDB->fetchAssoc($set)) {
             $skill_node_id = (int) $rec["skill_node_id"];
             if ($this->tree_repo->isInAnyTree($skill_node_id)) {
                 $pskills[$skill_node_id] = $this->getFromRecord($rec);
             }
         }
         return $pskills;
     }

Here is the call graph for this function:

◆ getFromRecord()

ILIAS\Skill\Personal\PersonalSkillDBRepository::getFromRecord ( array $rec )

protected

Definition at line 69 of file class.PersonalSkillDBRepository.php.

References ilSkillTreeNode\_lookupTitle(), and ILIAS\Repository\int().

Referenced by ILIAS\Skill\Personal\PersonalSkillDBRepository\get().

                                                 : SelectedUserSkill
     {
         $skill_node_id = (int) $rec["skill_node_id"];
 
         return $this->factory_service->personal()->selectedUserSkill(
             $skill_node_id,
             \ilSkillTreeNode::_lookupTitle($skill_node_id)
         );
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getUsages()

ILIAS\Skill\Personal\PersonalSkillDBRepository::getUsages	(	array	$usages,
		array	$pskill_ids,
		array	$tref_ids
	)

Parameters

array<string,array<string,array{key	string}[]>> $usages
int[]	$pskill_ids
int[]	$tref_ids

Returns: array<string, array<string, array{key: string}[]>>

Definition at line 135 of file class.PersonalSkillDBRepository.php.

References ILIAS\Skill\Personal\PersonalSkillDBRepository\$db, $ilDB, and ILIAS\Skill\Usage\SkillUsageManager\PERSONAL_SKILL.

Referenced by ILIAS\Skill\Personal\AssignedMaterialManager\getUsageInfo().

                                                                                 : array
     {
         $ilDB = $this->db;
 
         $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"]])) {
                 $usages[$tref_ids[$rec["skill_node_id"]] . ":" . $rec["skill_node_id"]][SkillUsageManager::PERSONAL_SKILL][] =
                     array("key" => $rec["user_id"]);
             } else {
                 $usages[$rec["skill_node_id"] . ":0"][SkillUsageManager::PERSONAL_SKILL][] =
                     array("key" => $rec["user_id"]);
             }
         }
 
         return $usages;
     }

Here is the caller graph for this function:

◆ remove()

ILIAS\Skill\Personal\PersonalSkillDBRepository::remove	(	int	$user_id,
		int	$skill_node_id
	)

Definition at line 97 of file class.PersonalSkillDBRepository.php.

References ILIAS\Skill\Personal\PersonalSkillDBRepository\$db, and $ilDB.

                                                             : void
     {
         $ilDB = $this->db;
 
         $ilDB->manipulate(
             "DELETE FROM skl_personal_skill WHERE " .
             " user_id = " . $ilDB->quote($user_id, "integer") .
             " AND skill_node_id = " . $ilDB->quote($skill_node_id, "integer")
         );
     }

◆ removeAllForSkill()

ILIAS\Skill\Personal\PersonalSkillDBRepository::removeAllForSkill ( int $skill_node_id )

Definition at line 118 of file class.PersonalSkillDBRepository.php.

References ILIAS\Skill\Personal\PersonalSkillDBRepository\$db, and $ilDB.

                                                          : void
     {
         $ilDB = $this->db;
 
         $ilDB->manipulate(
             "DELETE FROM skl_personal_skill WHERE " .
             " skill_node_id = " . $ilDB->quote($skill_node_id, "integer")
         );
     }

◆ removeAllForUser()

ILIAS\Skill\Personal\PersonalSkillDBRepository::removeAllForUser ( int $user_id )

Definition at line 108 of file class.PersonalSkillDBRepository.php.

References ILIAS\Skill\Personal\PersonalSkillDBRepository\$db, and $ilDB.

                                                   : void
     {
         $ilDB = $this->db;
 
         $ilDB->manipulate(
             "DELETE FROM skl_personal_skill WHERE " .
             " user_id = " . $ilDB->quote($user_id, "integer")
         );
     }