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 28 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 34 of file class.SkillResourceDBRepository.php.

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

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

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 89 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 49 of file class.SkillResourceDBRepository.php.

                                                       : 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;
    }

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

Here is the call graph for this function:

◆ getSkillResourceFromRecord()

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

protected

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

                                                             : 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"]
        );
    }

References ILIAS\Repository\int().

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

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 196 of file class.SkillResourceDBRepository.php.

                                                                  : 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"]
        );
    }

References ILIAS\Repository\int().

Here is the call graph for this function:

◆ getTriggerLevelsForRefId()

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

Returns: SkillResourceLevel[]

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

                                                             : 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;
    }

◆ remove()

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

Definition at line 154 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 165 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 112 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 133 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]
            ]
        );
    }