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"));
        }
    }
}