ILIAS\Skill\Usage\SkillUsageDBRepository Class Reference

Collaboration diagram for ILIAS\Skill\Usage\SkillUsageDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db=null)
	add (int $obj_id, int $skill_id, int $tref_id)
	remove (int $obj_id, int $skill_id, int $tref_id)
	removeFromObject (int $obj_id)
	removeForSkill (int $node_id, bool $is_referenece=false)
	getUsages (int $skill_id, int $tref_id)
	getUsageInfoGeneric (array $cskill_ids, string $usage_type, string $table, string $key_field, string $skill_field="skill_id", string $tref_field="tref_id")
	Get standard usage query. More...

Protected Attributes
ilDBInterface	$db

Detailed Description

Definition at line 24 of file class.SkillUsageDBRepository.php.

Constructor & Destructor Documentation

__construct()

ILIAS\Skill\Usage\SkillUsageDBRepository::__construct

(

\ilDBInterface

$db = null

)

Definition at line 28 of file class.SkillUsageDBRepository.php.

References ILIAS\Skill\Usage\SkillUsageDBRepository\$db, and $DIC.

      {
        global $DIC;

        $this->db = ($db) ?: $DIC->database();
    }

Member Function Documentation

add()

ILIAS\Skill\Usage\SkillUsageDBRepository::add	(	int	$obj_id,
		int	$skill_id,
		int	$tref_id
	)

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

                                                                 : void
    {
        $this->db->replace(
            "skl_usage",
            [
                "obj_id" => ["integer", $obj_id],
                "skill_id" => ["integer", $skill_id],
                "tref_id" => ["integer", $tref_id]
            ],
            []
        );
    }

getUsageInfoGeneric()

ILIAS\Skill\Usage\SkillUsageDBRepository::getUsageInfoGeneric	(	array	$cskill_ids,
		string	$usage_type,
		string	$table,
		string	$key_field,
		string	$skill_field = "skill_id",
		string	$tref_field = "tref_id"
	)

Get standard usage query.

Parameters

array{skill_id

int, tref_id: int}[] $cskill_ids

Returns

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

Definition at line 106 of file class.SkillUsageDBRepository.php.

References $q.

     : array {
        $usages = [];

        $w = "WHERE";
        $q = "SELECT " . $key_field . ", " . $skill_field . ", " . $tref_field . " FROM " . $table . " ";
        foreach ($cskill_ids as $sk) {
            $q .= $w . " (" . $skill_field . " = " . $this->db->quote($sk["skill_id"], "integer") .
                " AND " . $tref_field . " = " . $this->db->quote($sk["tref_id"], "integer") . ") ";
            $w = "OR";
        }
        $q .= " GROUP BY " . $key_field . ", " . $skill_field . ", " . $tref_field;

        $set = $this->db->query($q);
        while ($rec = $this->db->fetchAssoc($set)) {
            $usages[$rec[$skill_field] . ":" . $rec[$tref_field]][$usage_type][] =
                array("key" => $rec[$key_field]);
        }

        return $usages;
    }

getUsages()

ILIAS\Skill\Usage\SkillUsageDBRepository::getUsages	(	int	$skill_id,
		int	$tref_id
	)

Returns

int[]

Definition at line 85 of file class.SkillUsageDBRepository.php.

References ILIAS\Repository\int().

                                                          : array
    {
        $set = $this->db->query(
            "SELECT obj_id FROM skl_usage " .
            " WHERE skill_id = " . $this->db->quote($skill_id, "integer") .
            " AND tref_id = " . $this->db->quote($tref_id, "integer")
        );
        $obj_ids = [];
        while ($rec = $this->db->fetchAssoc($set)) {
            $obj_ids[] = (int) $rec["obj_id"];
        }

        return $obj_ids;
    }

Here is the call graph for this function:

remove()

ILIAS\Skill\Usage\SkillUsageDBRepository::remove	(	int	$obj_id,
		int	$skill_id,
		int	$tref_id
	)

Definition at line 49 of file class.SkillUsageDBRepository.php.

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

removeForSkill()

ILIAS\Skill\Usage\SkillUsageDBRepository::removeForSkill	(	int	$node_id,
		bool	$is_referenece = false
	)

Definition at line 67 of file class.SkillUsageDBRepository.php.

                                                                             : void
    {
        if (!$is_referenece) {
            $this->db->manipulate(
                "DELETE FROM skl_usage WHERE " .
                " skill_id = " . $this->db->quote($node_id, "integer")
            );
        } else {
            $this->db->manipulate(
                "DELETE FROM skl_usage WHERE " .
                " tref_id = " . $this->db->quote($node_id, "integer")
            );
        }
    }

removeFromObject()

ILIAS\Skill\Usage\SkillUsageDBRepository::removeFromObject

(

int

$obj_id

)

Definition at line 59 of file class.SkillUsageDBRepository.php.

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

Field Documentation

$db

ilDBInterface ILIAS\Skill\Usage\SkillUsageDBRepository::$db

protected

Definition at line 26 of file class.SkillUsageDBRepository.php.

Referenced by ILIAS\Skill\Usage\SkillUsageDBRepository\__construct().

---

The documentation for this class was generated from the following file:

• Services/Skill/Usage/class.SkillUsageDBRepository.php