class.ilTestSkillLevelThresholdList.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilTestSkillLevelThresholdList
{
    private $db;
 
    private $testId;
 
    private $thresholds = [];
 
    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 = [];
    }
 
    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, ['integer'], [$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(
        $skill_base_id,
        $skill_tref_id,
        $skill_level_id,
        $force_object = false
    ): ?ilTestSkillLevelThreshold {
        $skillKey = $skill_base_id . ':' . $skill_tref_id;
 
        if (isset($this->thresholds[$skillKey]) && isset($this->thresholds[$skillKey][$skill_level_id])) {
            return $this->thresholds[$skillKey][$skill_level_id];
        }
 
        if ($force_object) {
            $threshold = new ilTestSkillLevelThreshold($this->db);
 
            $threshold->setTestId($this->getTestId());
            $threshold->setSkillBaseId($skill_base_id);
            $threshold->setSkillTrefId($skill_tref_id);
            $threshold->setSkillLevelId($skill_level_id);
 
            return $threshold;
        }
 
        return null;
    }
 
    public function getThesholdsOfBaseAndTrefId(
        int $skill_base_id,
        int $skill_tref_id
    ): array {
        return $this->thresholds["{$skill_base_id}:{$skill_tref_id}"] ?? [];
    }
 
    public function cloneListForTest($testId)
    {
        foreach ($this->thresholds as $data) {
            foreach ($data as $threshold) {
                /* @var ilTestSkillLevelThreshold $threshold */
 
                $threshold->setTestId($testId);
                $threshold->saveToDb();
 
                $threshold->setTestId($this->getTestId());
            }
        }
    }
}