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