class.SurveySkillDBRepository.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\Survey\Skills;
 
class SurveySkillDBRepository
{
    protected \ilDBInterface $db;
 
    public function __construct(
        ?\ilDBInterface $db = null
    ) {
        global $DIC;
 
        $this->db = ($db) ?: $DIC->database();
    }
 
    public function removeForSkill(int $skill_node_id, bool $is_reference): void
    {
        if (!$is_reference) {
            $this->db->manipulate("DELETE FROM svy_quest_skill " .
                " WHERE base_skill_id = " . $this->db->quote($skill_node_id, "integer"));
            $this->db->manipulate("DELETE FROM svy_skill_threshold " .
                " WHERE base_skill_id = " . $this->db->quote($skill_node_id, "integer"));
        } else {
            $this->db->manipulate("DELETE FROM svy_quest_skill " .
                " WHERE tref_id = " . $this->db->quote($skill_node_id, "integer"));
            $this->db->manipulate("DELETE FROM svy_skill_threshold " .
                " WHERE tref_id = " . $this->db->quote($skill_node_id, "integer"));
        }
    }
}