class.ilSurveySkillThresholds.php

Go to the documentation of this file.

<?php
 
class ilSurveySkillThresholds
{
    protected ilObjSurvey $survey;
    protected ilDBInterface $db;
    protected array $threshold = [];
 
    public function __construct(ilObjSurvey $a_survey)
    {
        global $DIC;
 
        $this->db = $DIC->database();
        $this->survey = $a_survey;
        $this->read();
    }
 
    public function read(): void
    {
        $ilDB = $this->db;
 
        $set = $ilDB->query(
            "SELECT * FROM svy_skill_threshold " .
            " WHERE survey_id = " . $ilDB->quote($this->survey->getId(), "integer")
        );
        while ($rec = $ilDB->fetchAssoc($set)) {
            $this->threshold[(int) $rec['level_id']][(int) $rec['tref_id']] = (int) $rec['threshold'];
        }
    }
 
    public function getThresholds(): array
    {
        return $this->threshold;
    }
 
    public function writeThreshold(
        int $a_base_skill_id,
        int $a_tref_id,
        int $a_level_id,
        int $a_threshold
    ): void {
        $ilDB = $this->db;
 
        $ilDB->replace(
            "svy_skill_threshold",
            array("survey_id" => array("integer", $this->survey->getId()),
                  "base_skill_id" => array("integer", $a_base_skill_id),
                  "tref_id" => array("integer", $a_tref_id),
                  "level_id" => array("integer", $a_level_id)
                ),
            array("threshold" => array("integer", $a_threshold))
        );
    }
 
    public function cloneTo(ilObjSurvey $target_survey, array $mapping): void
    {
        $target_thresholds = new self($target_survey);
        $set = $this->db->queryF(
            "SELECT * FROM svy_skill_threshold " .
            " WHERE survey_id = %s ",
            ["integer"],
            [$this->survey->getId()]
        );
        while ($rec = $this->db->fetchAssoc($set)) {
            $target_thresholds->writeThreshold(
                (int) $rec["base_skill_id"],
                (int) $rec["tref_id"],
                (int) $rec["level_id"],
                (int) $rec["threshold"]
            );
        }
    }
}