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];
        }
}