class.ContainerMemberSkillDBRepository.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\Container\Skills;
 
class ContainerMemberSkillDBRepository
{
    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 $user_id, int $skill_id, int $tref_id, int $level_id): void
    {
        $this->db->replace(
            "cont_member_skills",
            [
                "obj_id" => ["integer", $cont_obj_id],
                "user_id" => ["integer", $user_id],
                "skill_id" => ["integer", $skill_id],
                "tref_id" => ["integer", $tref_id]
            ],
            [
                "level_id" => ["integer", $level_id],
                "published" => ["integer", 0]
            ]
        );
    }
 
    public function remove(int $cont_obj_id, int $user_id, int $skill_id, int $tref_id): void
    {
        $this->db->manipulate("DELETE FROM cont_member_skills " .
            " WHERE obj_id = " . $this->db->quote($cont_obj_id, "integer") .
            " AND user_id = " . $this->db->quote($user_id, "integer") .
            " AND skill_id = " . $this->db->quote($skill_id, "integer") .
            " AND tref_id = " . $this->db->quote($tref_id, "integer"));
    }
 
    public function removeAll(int $cont_obj_id, int $user_id): void
    {
        $this->db->manipulate("DELETE FROM cont_member_skills " .
            " WHERE obj_id = " . $this->db->quote($cont_obj_id, "integer") .
            " AND user_id = " . $this->db->quote($user_id, "integer"));
    }
 
    public function removeForSkill(int $skill_node_id, bool $is_reference): void
    {
        if (!$is_reference) {
            $this->db->manipulate("DELETE FROM cont_member_skills " .
                " WHERE skill_id = " . $this->db->quote($skill_node_id, "integer"));
        } else {
            $this->db->manipulate("DELETE FROM cont_member_skills " .
                " WHERE tref_id = " . $this->db->quote($skill_node_id, "integer"));
        }
    }
 
    public function publish(int $cont_obj_id, int $user_id): void
    {
        $this->db->manipulate("UPDATE cont_member_skills SET " .
            " published = " . $this->db->quote(1, "integer") .
            " WHERE obj_id = " . $this->db->quote($cont_obj_id, "integer") .
            " AND user_id = " . $this->db->quote($user_id, "integer"));
    }
 
    public function getPublished(int $cont_obj_id, int $user_id): bool
    {
        $set = $this->db->query(
            "SELECT published FROM cont_member_skills " .
            " WHERE obj_id = " . $this->db->quote($cont_obj_id, "integer") .
            " AND user_id = " . $this->db->quote($user_id, "integer")
        );
        while ($rec = $this->db->fetchAssoc($set)) {
            if ((bool) $rec["published"] === true) { // this is a little weak, but the value should be the same for all save skills
                return true;
            }
        }
        return false;
    }
 
    public function getAll(int $cont_obj_id, int $user_id): array
    {
        $mem_skills = [];
        $set = $this->db->query(
            "SELECT * FROM cont_member_skills " .
            " WHERE obj_id = " . $this->db->quote($cont_obj_id, "integer") .
            " AND user_id = " . $this->db->quote($user_id, "integer")
        );
        while ($rec = $this->db->fetchAssoc($set)) {
            $mem_skills[] = $this->getContainerMemberSkillFromRecord($rec);
        }
        return $mem_skills;
    }
 
    public function getLevel(int $cont_obj_id, int $user_id, int $skill_id, int $tref_id): ?int
    {
        $set = $this->db->query(
            "SELECT * FROM cont_member_skills " .
            " WHERE obj_id = " . $this->db->quote($cont_obj_id, "integer") .
            " AND user_id = " . $this->db->quote($user_id, "integer") .
            " AND skill_id = " . $this->db->quote($skill_id, "integer") .
            " AND tref_id = " . $this->db->quote($tref_id, "integer")
        );
        if ($rec = $this->db->fetchAssoc($set)) {
            return (int) $rec["level_id"];
        }
        return null;
    }
 
    protected function getContainerMemberSkillFromRecord(array $rec): ContainerMemberSkill
    {
        $rec["obj_id"] = (int) $rec["obj_id"];
        $rec["user_id"] = (int) $rec["user_id"];
        $rec["skill_id"] = (int) $rec["skill_id"];
        $rec["tref_id"] = (int) $rec["tref_id"];
        $rec["level_id"] = (int) $rec["level_id"];
        $rec["published"] = (bool) $rec["published"];
 
        return $this->factory_service->containerSkill()->memberSkill(
            $rec["obj_id"],
            $rec["user_id"],
            $rec["skill_id"],
            $rec["tref_id"],
            $rec["level_id"],
            $rec["published"]
        );
    }
}