class.AssignedMaterialDBRepository.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\Skill\Personal;
 
use ILIAS\Skill\Service;
 
class AssignedMaterialDBRepository
{
    protected \ilDBInterface $db;
    protected Service\SkillInternalFactoryService $factory_service;
 
    public function __construct(
        ?\ilDBInterface $db = null,
        ?Service\SkillInternalFactoryService $factory_service = null
    ) {
        global $DIC;
 
        $this->db = ($db) ?: $DIC->database();
        $this->factory_service = ($factory_service) ?: $DIC->skills()->internal()->factory();
    }
 
    public function assign(
        int $user_id,
        int $top_skill_id,
        int $tref_id,
        int $basic_skill_id,
        int $level_id,
        int $wsp_id
    ): void {
        $ilDB = $this->db;
 
        $set = $ilDB->query(
            "SELECT * FROM skl_assigned_material " .
            " WHERE user_id = " . $ilDB->quote($user_id, "integer") .
            " AND top_skill_id = " . $ilDB->quote($top_skill_id, "integer") .
            " AND tref_id = " . $ilDB->quote($tref_id, "integer") .
            " AND skill_id = " . $ilDB->quote($basic_skill_id, "integer") .
            " AND level_id = " . $ilDB->quote($level_id, "integer") .
            " AND wsp_id = " . $ilDB->quote($wsp_id, "integer")
        );
        if (!$ilDB->fetchAssoc($set)) {
            $ilDB->manipulate("INSERT INTO skl_assigned_material " .
                "(user_id, top_skill_id, tref_id, skill_id, level_id, wsp_id) VALUES (" .
                $ilDB->quote($user_id, "integer") . "," .
                $ilDB->quote($top_skill_id, "integer") . "," .
                $ilDB->quote($tref_id, "integer") . "," .
                $ilDB->quote($basic_skill_id, "integer") . "," .
                $ilDB->quote($level_id, "integer") . "," .
                $ilDB->quote($wsp_id, "integer") .
                ")");
        }
    }
 
    public function get(int $user_id, int $tref_id, int $level_id): array
    {
        $ilDB = $this->db;
 
        $set = $ilDB->query(
            "SELECT * FROM skl_assigned_material " .
            " WHERE level_id = " . $ilDB->quote($level_id, "integer") .
            " AND tref_id = " . $ilDB->quote($tref_id, "integer") .
            " AND user_id = " . $ilDB->quote($user_id, "integer")
        );
        $mat = [];
        while ($rec = $ilDB->fetchAssoc($set)) {
            $mat[] = $this->getFromRecord($rec);
        }
        return $mat;
    }
 
    public function getAll(int $user_id, int $skill_id, int $tref_id): array
    {
        $ilDB = $this->db;
 
        $set = $ilDB->query(
            "SELECT * FROM skl_assigned_material " .
            " WHERE skill_id = " . $ilDB->quote($skill_id, "integer") .
            " AND tref_id = " . $ilDB->quote($tref_id, "integer") .
            " AND user_id = " . $ilDB->quote($user_id, "integer")
        );
        $mat = [];
        while ($rec = $ilDB->fetchAssoc($set)) {
            $mat[] = $this->getFromRecord($rec);
        }
        return $mat;
    }
 
    protected function getFromRecord(array $rec): AssignedMaterial
    {
        $rec['user_id'] = (int) $rec['user_id'];
        $rec['top_skill_id'] = (int) $rec['top_skill_id'];
        $rec['skill_id'] = (int) $rec['skill_id'];
        $rec['level_id'] = (int) $rec['level_id'];
        $rec['wsp_id'] = (int) $rec['wsp_id'];
        $rec['tref_id'] = (int) $rec['tref_id'];
 
        return $this->factory_service->personal()->assignedMaterial(
            $rec['user_id'],
            $rec['top_skill_id'],
            $rec['skill_id'],
            $rec['level_id'],
            $rec['wsp_id'],
            $rec['tref_id']
        );
    }
 
    public function count(int $user_id, int $tref_id, int $level_id): int
    {
        $ilDB = $this->db;
 
        $set = $ilDB->query(
            "SELECT count(*) as cnt FROM skl_assigned_material " .
            " WHERE level_id = " . $ilDB->quote($level_id, "integer") .
            " AND tref_id = " . $ilDB->quote($tref_id, "integer") .
            " AND user_id = " . $ilDB->quote($user_id, "integer")
        );
        $rec = $ilDB->fetchAssoc($set);
        return (int) $rec["cnt"];
    }
 
    public function remove(int $user_id, int $tref_id, int $level_id, int $wsp_id): void
    {
        $ilDB = $this->db;
 
        $t = "DELETE FROM skl_assigned_material WHERE " .
            " user_id = " . $ilDB->quote($user_id, "integer") .
            " AND tref_id = " . $ilDB->quote($tref_id, "integer") .
            " AND level_id = " . $ilDB->quote($level_id, "integer") .
            " AND wsp_id = " . $ilDB->quote($wsp_id, "integer");
 
        $ilDB->manipulate($t);
    }
 
    public function removeAllForUser(int $user_id): void
    {
        $ilDB = $this->db;
 
        $t = "DELETE FROM skl_assigned_material WHERE " .
            " user_id = " . $ilDB->quote($user_id, "integer");
        $ilDB->manipulate($t);
    }
 
    public function removeAllForSkill(int $skill_node_id, bool $is_reference): void
    {
        $ilDB = $this->db;
 
        if (!$is_reference) {
            $t = "DELETE FROM skl_assigned_material WHERE " .
                " skill_id = " . $ilDB->quote($skill_node_id, "integer");
        } else {
            $t = "DELETE FROM skl_assigned_material WHERE " .
                " tref_id = " . $ilDB->quote($skill_node_id, "integer");
        }
        $ilDB->manipulate($t);
    }
}