class.ilTestSkillLevelThresholdList.php

Go to the documentation of this file.

<?php

class ilTestSkillLevelThresholdList
{
    private $db;

    private $testId;

    private $thresholds = array();

    public function __construct(ilDBInterface $db)
    {
        $this->db = $db;
    }

    public function setTestId($testId)
    {
        $this->testId = $testId;
    }

    public function getTestId(): int
    {
        return $this->testId;
    }

    public function resetThresholds()
    {
        $this->thresholds = array();
    }

    public function loadFromDb()
    {
        $this->resetThresholds();

        $query = "
                        SELECT test_fi, skill_base_fi, skill_tref_fi, skill_level_fi, threshold
                        FROM tst_skl_thresholds
                        WHERE test_fi = %s
                ";

        $res = $this->db->queryF($query, array('integer'), array($this->getTestId()));

        while ($row = $this->db->fetchAssoc($res)) {
            $threshold = $this->buildSkillLevelThresholdByArray($row);
            $this->addThreshold($threshold);
        }
    }

    public function saveToDb()
    {
        foreach ($this->thresholds as $skillKey => $skillLevels) {
            foreach ($skillLevels as $levelThreshold) {
                /* @var ilTestSkillLevelThreshold $levelThreshold */
                $levelThreshold->saveToDb();
            }
        }
    }

    public function addThreshold($threshold)
    {
        $skillKey = $threshold->getSkillBaseId() . ':' . $threshold->getSkillTrefId();
        $this->thresholds[$skillKey][$threshold->getSkillLevelId()] = $threshold;
    }

    private function buildSkillLevelThresholdByArray($data): ilTestSkillLevelThreshold
    {
        $threshold = new ilTestSkillLevelThreshold($this->db);

        $threshold->setTestId($data['test_fi']);
        $threshold->setSkillBaseId($data['skill_base_fi']);
        $threshold->setSkillTrefId($data['skill_tref_fi']);
        $threshold->setSkillLevelId($data['skill_level_fi']);
        $threshold->setThreshold($data['threshold']);

        return $threshold;
    }

    public function getThreshold($skillBaseId, $skillTrefId, $skillLevelId, $forceObject = false): ?ilTestSkillLevelThreshold
    {
        $skillKey = $skillBaseId . ':' . $skillTrefId;

        if (isset($this->thresholds[$skillKey]) && isset($this->thresholds[$skillKey][$skillLevelId])) {
            return $this->thresholds[$skillKey][$skillLevelId];
        }

        if ($forceObject) {
            $threshold = new ilTestSkillLevelThreshold($this->db);

            $threshold->setTestId($this->getTestId());
            $threshold->setSkillBaseId($skillBaseId);
            $threshold->setSkillTrefId($skillTrefId);
            $threshold->setSkillLevelId($skillLevelId);

            return $threshold;
        }

        return null;
    }

    public function cloneListForTest($testId)
    {
        foreach ($this->thresholds as $skillKey => $data) {
            foreach ($data as $levelId => $threshold) {
                /* @var ilTestSkillLevelThreshold $threshold */

                $threshold->setTestId($testId);
                $threshold->saveToDb();

                $threshold->setTestId($this->getTestId());
            }
        }
    }
}