class.SkillResourceDBRepository.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\Skill\Resource;

use ILIAS\Skill\Service;

class SkillResourceDBRepository
{
    protected \ilDBInterface $db;
    protected Service\SkillInternalFactoryService $factory_service;
    protected \ilTree $tree;

    public function __construct(
        \ilDBInterface $db = null,
        Service\SkillInternalFactoryService $factory_service = null,
        \ilTree $tree = null
    ) {
        global $DIC;

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

    public function getAll(int $skill_id, int $tref_id): 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;
    }

    protected function getSkillResourceFromRecord(array $rec): 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"]
        );
    }

    public function addOrUpdate(
        int $skill_id,
        int $tref_id,
        int $level_id,
        int $rep_ref_id,
        bool $imparting,
        bool $trigger
    ): 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]
            ]
        );
    }

    public function updateImparting(
        int $skill_id,
        int $tref_id,
        int $level_id,
        int $rep_ref_id,
        bool $imparting
    ): 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]
            ]
        );
    }

    public function updateTrigger(
        int $skill_id,
        int $tref_id,
        int $level_id,
        int $rep_ref_id,
        bool $trigger
    ): 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]
            ]
        );
    }

    public function remove(int $skill_id, int $tref_id, int $level_id, int $rep_ref_id): 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")
        );
    }

    public function removeForSkill(int $skill_node_id, bool $is_reference): 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")
            );
        }
    }

    public function getTriggerLevelsForRefId(int $rep_ref_id): 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;
    }

    protected function getSkillResourceLevelFromRecord(array $rec): 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"]
        );
    }
}