class.ilTestSkillLevelThresholdList.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2013 ILIAS open source, Extended GPL, see docs/LICENSE */
 
require_once 'Modules/Test/classes/class.ilTestSkillLevelThreshold.php';
 
class ilTestSkillLevelThresholdList
{
        private $db;
 
        private $testId;
 
        private $thresholds = array();
 
        public function __construct(ilDB $db)
        {
                $this->db = $db;
        }
 
        public function setTestId($testId)
        {
                $this->testId = $testId;
        }
 
        public function getTestId()
        {
                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);
 
                        $skillKey = $threshold->getSkillBaseId() . ':' . $threshold->getSkillTrefId();
 
                        $this->addThreshold($skillKey, $threshold->getSkillLevelId(), $threshold);
                }
        }
 
        private function addThreshold($skillKey, $skillLevelId, $threshold)
        {
                $this->thresholds[$skillKey][$skillLevelId] = $threshold;
        }
 
        private function buildSkillLevelThresholdByArray($data)
        {
                $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)
        {
                $skillKey = $skillBaseId . ':' . $skillTrefId;
 
                if( !isset($this->thresholds[$skillKey]) || !isset($this->thresholds[$skillKey][$skillLevelId]) )
                {
                        return null;
                }
 
                return $this->thresholds[$skillKey][$skillLevelId];
        }
        
        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());
                        }
                }
        }
}