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