Collaboration diagram for ILIAS\Skill\Resource\SkillResourceDBRepository:

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

	getAll (int $skill_id, int $tref_id)

	addOrUpdate (int $skill_id, int $tref_id, int $level_id, int $rep_ref_id, bool $imparting, bool $trigger)

	updateImparting (int $skill_id, int $tref_id, int $level_id, int $rep_ref_id, bool $imparting)

	updateTrigger (int $skill_id, int $tref_id, int $level_id, int $rep_ref_id, bool $trigger)

	remove (int $skill_id, int $tref_id, int $level_id, int $rep_ref_id)

	removeForSkill (int $skill_node_id, bool $is_reference)

	getTriggerLevelsForRefId (int $rep_ref_id)

Protected Member Functions
	getSkillResourceFromRecord (array $rec)

	getSkillResourceLevelFromRecord (array $rec)

Protected Attributes
ilDBInterface	$db

Service SkillInternalFactoryService	$factory_service

ilTree	$tree

Detailed Description

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

Definition at line 29 of file class.SkillResourceDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ILIAS\Skill\Resource\SkillResourceDBRepository::__construct	(	\ilDBInterface	$db = `null`,
		Service\SkillInternalFactoryService	$factory_service = `null`,
		\ilTree	$tree = `null`
	)

Definition at line 35 of file class.SkillResourceDBRepository.php.

References ILIAS\Skill\Resource\SkillResourceDBRepository\$db, $DIC, ILIAS\Skill\Resource\SkillResourceDBRepository\$factory_service, and ILIAS\Skill\Resource\SkillResourceDBRepository\$tree.

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

Member Function Documentation

◆ addOrUpdate()

ILIAS\Skill\Resource\SkillResourceDBRepository::addOrUpdate	(	int	$skill_id,
		int	$tref_id,
		int	$level_id,
		int	$rep_ref_id,
		bool	$imparting,
		bool	$trigger
	)

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

      : void {
         $this->db->replace(
             "skl_skill_resource",
             [
                 "base_skill_id" => ["integer", $skill_id],
                 "tref_id" => ["integer", $tref_id],
                 "level_id" => ["integer", $level_id],
                 "rep_ref_id" => ["integer", $rep_ref_id]
             ],
             [
                 "imparting" => ["integer", (int) $imparting],
                 "ltrigger" => ["integer", (int) $trigger]
             ]
         );
     }

◆ getAll()

ILIAS\Skill\Resource\SkillResourceDBRepository::getAll	(	int	$skill_id,
		int	$tref_id
	)

Returns: SkillResource[]

Definition at line 50 of file class.SkillResourceDBRepository.php.

References ILIAS\Skill\Resource\SkillResourceDBRepository\$db, $ilDB, $resources, ILIAS\Skill\Resource\SkillResourceDBRepository\$tree, ILIAS\Skill\Resource\SkillResourceDBRepository\getSkillResourceFromRecord(), and ILIAS\Repository\int().

                                                        : array
     {
         $ilDB = $this->db;
         $tree = $this->tree;
 
         $set = $ilDB->query(
             "SELECT * FROM skl_skill_resource " .
             " WHERE base_skill_id = " . $ilDB->quote($skill_id, "integer") .
             " AND tref_id = " . $ilDB->quote($tref_id, "integer") .
             " ORDER BY level_id"
         );
         $resources = [];
         while ($rec = $ilDB->fetchAssoc($set)) {
             if ($tree->isInTree((int) $rec["rep_ref_id"])) {
                 $resources[(int) $rec["level_id"]][] = $this->getSkillResourceFromRecord($rec);
             }
         }
 
         return $resources;
     }

Here is the call graph for this function:

◆ getSkillResourceFromRecord()

ILIAS\Skill\Resource\SkillResourceDBRepository::getSkillResourceFromRecord ( array $rec )

protected

Definition at line 71 of file class.SkillResourceDBRepository.php.

References ILIAS\Repository\int().

Referenced by ILIAS\Skill\Resource\SkillResourceDBRepository\getAll().

                                                              : SkillResource
     {
         $rec["base_skill_id"] = (int) $rec["base_skill_id"];
         $rec["tref_id"] = (int) $rec["tref_id"];
         $rec["level_id"] = (int) $rec["level_id"];
         $rec["rep_ref_id"] = (int) $rec["rep_ref_id"];
         $rec["imparting"] = (bool) $rec["imparting"];
         $rec["ltrigger"] = (bool) $rec["ltrigger"];
 
         return $this->factory_service->resource()->resource(
             $rec["base_skill_id"],
             $rec["tref_id"],
             $rec["level_id"],
             $rec["rep_ref_id"],
             $rec["imparting"],
             $rec["ltrigger"]
         );
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getSkillResourceLevelFromRecord()

ILIAS\Skill\Resource\SkillResourceDBRepository::getSkillResourceLevelFromRecord ( array $rec )

protected

Definition at line 197 of file class.SkillResourceDBRepository.php.

References ILIAS\Repository\int().

Referenced by ILIAS\Skill\Resource\SkillResourceDBRepository\getTriggerLevelsForRefId().

                                                                   : SkillResourceLevel
     {
         $rec["base_skill_id"] = (int) $rec["base_skill_id"];
         $rec["tref_id"] = (int) $rec["tref_id"];
         $rec["level_id"] = (int) $rec["level_id"];
 
         return $this->factory_service->resource()->resourceLevel(
             $rec["base_skill_id"],
             $rec["tref_id"],
             $rec["level_id"]
         );
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getTriggerLevelsForRefId()

ILIAS\Skill\Resource\SkillResourceDBRepository::getTriggerLevelsForRefId ( int $rep_ref_id )

Returns: SkillResourceLevel[]

Definition at line 184 of file class.SkillResourceDBRepository.php.

References ILIAS\Skill\Resource\SkillResourceDBRepository\getSkillResourceLevelFromRecord().

                                                              : array
     {
         $set = $this->db->query("SELECT * FROM skl_skill_resource " .
             " WHERE rep_ref_id = " . $this->db->quote($rep_ref_id, "integer") .
             " AND ltrigger = " . $this->db->quote(1, "integer"));
 
         $skill_levels = [];
         while ($rec = $this->db->fetchAssoc($set)) {
             $skill_levels[] = $this->getSkillResourceLevelFromRecord($rec);
         }
         return $skill_levels;
     }

Here is the call graph for this function:

◆ remove()

ILIAS\Skill\Resource\SkillResourceDBRepository::remove	(	int	$skill_id,
		int	$tref_id,
		int	$level_id,
		int	$rep_ref_id
	)

Definition at line 155 of file class.SkillResourceDBRepository.php.

                                                                                        : void
     {
         $this->db->manipulate(
             "DELETE FROM skl_skill_resource WHERE " .
             " base_skill_id = " . $this->db->quote($skill_id, "integer") .
             " AND tref_id = " . $this->db->quote($tref_id, "integer") .
             " AND level_id = " . $this->db->quote($level_id, "integer") .
             " AND rep_ref_id = " . $this->db->quote($rep_ref_id, "integer")
         );
     }

◆ removeForSkill()

ILIAS\Skill\Resource\SkillResourceDBRepository::removeForSkill	(	int	$skill_node_id,
		bool	$is_reference
	)

Definition at line 166 of file class.SkillResourceDBRepository.php.

                                                                           : void
     {
         if (!$is_reference) {
             $this->db->manipulate(
                 "DELETE FROM skl_skill_resource WHERE " .
                 " base_skill_id = " . $this->db->quote($skill_node_id, "integer")
             );
         } else {
             $this->db->manipulate(
                 "DELETE FROM skl_skill_resource WHERE " .
                 " tref_id = " . $this->db->quote($skill_node_id, "integer")
             );
         }
     }

◆ updateImparting()

ILIAS\Skill\Resource\SkillResourceDBRepository::updateImparting	(	int	$skill_id,
		int	$tref_id,
		int	$level_id,
		int	$rep_ref_id,
		bool	$imparting
	)

Definition at line 113 of file class.SkillResourceDBRepository.php.

      : void {
         $this->db->update(
             "skl_skill_resource",
             [
                 "imparting" => ["integer", (int) $imparting]
             ],
             [
                 "base_skill_id" => ["integer", $skill_id],
                 "tref_id" => ["integer", $tref_id],
                 "level_id" => ["integer", $level_id],
                 "rep_ref_id" => ["integer", $rep_ref_id]
             ]
         );
     }

◆ updateTrigger()

ILIAS\Skill\Resource\SkillResourceDBRepository::updateTrigger	(	int	$skill_id,
		int	$tref_id,
		int	$level_id,
		int	$rep_ref_id,
		bool	$trigger
	)

Definition at line 134 of file class.SkillResourceDBRepository.php.

      : void {
         $this->db->update(
             "skl_skill_resource",
             [
                 "ltrigger" => ["integer", (int) $trigger]
             ],
             [
                 "base_skill_id" => ["integer", $skill_id],
                 "tref_id" => ["integer", $tref_id],
                 "level_id" => ["integer", $level_id],
                 "rep_ref_id" => ["integer", $rep_ref_id]
             ]
         );
     }