class.ilSurveySkillThresholds.php

Go to the documentation of this file.

<?php

/* Copyright (c) 1998-2012 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilSurveySkillThresholds
{
        
        function __construct(ilObjSurvey $a_survey)
        {
                $this->survey = $a_survey;
                $this->read();
        }
        
        function read()
        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT * FROM svy_skill_threshold ".
                        " WHERE survey_id = ".$ilDB->quote($this->survey->getId(), "integer")
                        );
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        $this->threshold[$rec['level_id']][$rec['tref_id']] =
                                $rec['threshold'];
                }
        }

        function getThresholds()
        {
                return $this->threshold;
        }
        
        function writeThreshold($a_base_skill_id, $a_tref_id, $a_level_id, $a_threshold)
        {
                global $ilDB;
                
                $ilDB->replace("svy_skill_threshold",
                        array("survey_id" => array("integer", $this->survey->getId()),
                                "base_skill_id" => array("integer", (int) $a_base_skill_id),
                                "tref_id" => array("integer", (int) $a_tref_id),
                                "level_id" => array("integer", (int) $a_level_id)
                                ),
                        array("threshold" => array("integer", (int) $a_threshold))
                        );
        }
        
}

?>