class.ilTestSkillLevelThreshold.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2013 ILIAS open source, Extended GPL, see docs/LICENSE */


class ilTestSkillLevelThreshold
{
        private $db;

        private $testId;

        private $skillBaseId;

        private $skillTrefId;

        private $skillLevelId;

        private $threshold;

        public function __construct(ilDBInterface $db)
        {
                $this->db = $db;
        }

        public function loadFromDb()
        {
                $query = "
                        SELECT test_fi, skill_base_fi, skill_tref_fi, skill_level_fi, threshold
                        FROM tst_skl_thresholds
                        WHERE test_fi = %s
                        AND skill_base_fi = %s
                        AND skill_tref_fi = %s
                        AND skill_level_fi = %s
                ";

                $res = $this->db->queryF(
                        $query, array('integer', 'integer', 'integer', 'integer'),
                        array($this->getTestId(), $this->getSkillBaseId(), $this->getSkillTrefId(), $this->getSkillLevelId())
                );

                $row = $this->db->fetchAssoc($res);

                if( is_array($row) )
                {
                        $this->setThreshold($row['threshold']);
                }
        }

        public function saveToDb()
        {
                if( $this->dbRecordExists() )
                {
                        $this->db->update('tst_skl_thresholds', array(
                                        'threshold' => array('integer', $this->getThreshold())
                                ),
                                array(
                                        'test_fi' => array('integer', $this->getTestId()),
                                        'skill_base_fi' => array('integer', $this->getSkillBaseId()),
                                        'skill_tref_fi' => array('integer', $this->getSkillTrefId()),
                                        'skill_level_fi' => array('integer', $this->getSkillLevelId())
                                )
                        );
                }
                else
                {
                        $this->db->insert('tst_skl_thresholds', array(
                                'test_fi' => array('integer', $this->getTestId()),
                                'skill_base_fi' => array('integer', $this->getSkillBaseId()),
                                'skill_tref_fi' => array('integer', $this->getSkillTrefId()),
                                'skill_level_fi' => array('integer', $this->getSkillLevelId()),
                                'threshold' => array('integer', $this->getThreshold())
                        ));
                }
        }

        public function deleteFromDb()
        {
                $query = "
                        DELETE FROM tst_skl_thresholds
                        WHERE test_fi = %s
                        AND skill_base_fi = %s
                        AND skill_tref_fi = %s
                        AND skill_level_fi = %s
                ";

                $this->db->manipulateF(
                        $query, array('integer', 'integer', 'integer', 'integer'),
                        array($this->getTestId(), $this->getSkillBaseId(), $this->getSkillTrefId(), $this->getSkillLevelId())
                );
        }

        public function dbRecordExists()
        {
                $query = "
                        SELECT COUNT(*) cnt
                        FROM tst_skl_thresholds
                        WHERE test_fi = %s
                        AND skill_base_fi = %s
                        AND skill_tref_fi = %s
                        AND skill_level_fi = %s
                ";

                $res = $this->db->queryF(
                        $query, array('integer', 'integer', 'integer', 'integer'),
                        array($this->getTestId(), $this->getSkillBaseId(), $this->getSkillTrefId(), $this->getSkillLevelId())
                );

                $row = $this->db->fetchAssoc($res);

                return $row['cnt'] > 0;
        }

        public function setTestId($testId)
        {
                $this->testId = $testId;
        }

        public function getTestId()
        {
                return $this->testId;
        }

        public function setSkillBaseId($skillBaseId)
        {
                $this->skillBaseId = $skillBaseId;
        }

        public function getSkillBaseId()
        {
                return $this->skillBaseId;
        }

        public function setSkillTrefId($skillTrefId)
        {
                $this->skillTrefId = $skillTrefId;
        }

        public function getSkillTrefId()
        {
                return $this->skillTrefId;
        }

        public function setSkillLevelId($skillLevelId)
        {
                $this->skillLevelId = $skillLevelId;
        }

        public function getSkillLevelId()
        {
                return $this->skillLevelId;
        }

        public function setThreshold($threshold)
        {
                $this->threshold = $threshold;
        }

        public function getThreshold()
        {
                return $this->threshold;
        }
}