class.ContainerSkillDBRepository.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\Container\Skills;

class ContainerSkillDBRepository
{
    protected \ilDBInterface $db;
    protected SkillInternalFactoryService $factory_service;

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

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

    public function add(int $cont_obj_id, int $skill_id, int $tref_id): void
    {
        $this->db->replace(
            "cont_skills",
            [
            "id" => ["integer", $cont_obj_id],
            "skill_id" => ["integer", $skill_id],
            "tref_id" => ["integer", $tref_id]
            ],
            []
        );
    }

    public function remove(int $cont_obj_id, int $skill_id, int $tref_id): void
    {
        $this->db->manipulate(
            "DELETE FROM cont_skills WHERE " .
            " id = " . $this->db->quote($cont_obj_id, "integer") .
            " AND skill_id = " . $this->db->quote($skill_id, "integer") .
            " AND tref_id = " . $this->db->quote($tref_id, "integer")
        );
    }

    public function removeForSkill(int $skill_node_id, bool $is_reference): void
    {
        if (!$is_reference) {
            $this->db->manipulate("DELETE FROM cont_skills " .
                " WHERE skill_id = " . $this->db->quote($skill_node_id, "integer"));
        } else {
            $this->db->manipulate("DELETE FROM cont_skills " .
                " WHERE tref_id = " . $this->db->quote($skill_node_id, "integer"));
        }
    }

    public function getAll(int $cont_obj_id): array
    {
        $skills = [];
        $set = $this->db->query(
            "SELECT * FROM cont_skills " .
            " WHERE id  = " . $this->db->quote($cont_obj_id, "integer")
        );

        while ($rec = $this->db->fetchAssoc($set)) {
            $skills[] = $this->getContainerSkillFromRecord($rec);
        }
        return $skills;
    }

    protected function getContainerSkillFromRecord(array $rec): ContainerSkill
    {
        $rec["skill_id"] = (int) $rec["skill_id"];
        $rec["tref_id"] = (int) $rec["tref_id"];
        $rec["id"] = (int) $rec["id"];

        return $this->factory_service->containerSkill()->skill(
            $rec["skill_id"],
            $rec["tref_id"],
            $rec["id"]
        );
    }
}