class.ilLORandomTestQuestionPools.php

Go to the documentation of this file.

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


include_once './Modules/Course/classes/Objectives/class.ilLOSettings.php';

class ilLORandomTestQuestionPools
{
        protected $container_id = 0;
        protected $objective_id = 0;
        protected $test_type = 0;
        protected $test_id = 0;
        protected $qpl_seq = 0;
        protected $limit = 50;
        

        public function __construct($a_container_id, $a_objective_id, $a_test_type)
        {
                $this->container_id = $a_container_id;
                $this->objective_id = $a_objective_id;
                $this->test_type = $a_test_type;
                
                $this->read();
        }
        
        public static function lookupLimit($a_container_id, $a_objective_id, $a_test_type)
        {
                global $ilDB;
                
                $query = 'SELECT * FROM loc_rnd_qpl '.
                                'WHERE container_id = '.$ilDB->quote($a_container_id,'integer').' '.
                                'AND objective_id = '.$ilDB->quote($a_objective_id,'integer').' '.
                                'AND tst_type = '.$ilDB->quote($a_test_type,'integer');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        return $row->percentage;
                }
                return 0;
        }
        
        public static function lookupSequence($a_container_id, $a_objective_id, $a_test_id)
        {
                global $ilDB;
                
                $query = 'SELECT * FROM loc_rnd_qpl '.
                                'WHERE container_id = '.$ilDB->quote($a_container_id,'integer').' '.
                                'AND objective_id = '.$ilDB->quote($a_objective_id,'integer').' '.
                                'AND tst_id = '.$ilDB->quote($a_test_id,'integer');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        return $row->qp_seq;
                }
                return 0;
                
        }


        public function setContainerId($a_id)
        {
                $this->container_id = $a_id;
        }
        
        public function getContainerId()
        {
                return $this->container_id;
        }
        
        public function setObjectiveId($a_id)
        {
                $this->objective_id = $a_id;
        }
        
        public function getObjectiveId()
        {
                return $this->objective_id;
        }
        
        public function setTestType($a_type)
        {
                $this->test_type = $a_type;
        }
        
        public function getTestType()
        {
                return $this->test_type;
        }
        
        public function setTestId($a_id)
        {
                $this->test_id = $a_id;
        }
        
        public function getTestId()
        {
                return $this->test_id;
        }
        
        public function setQplSequence($a_id)
        {
                $this->qpl_seq = $a_id;
        }
        
        public function getQplSequence()
        {
                return $this->qpl_seq;
        }
        
        public function setLimit($a_id)
        {
                $this->limit = $a_id;
        }
        
        public function getLimit()
        {
                return $this->limit;
        }
        
        
        public function read()
        {
                global $ilDB;
                
                $query = 'SELECT * FROM loc_rnd_qpl '.
                                'WHERE container_id = '.$ilDB->quote($this->getContainerId(),'integer').' '.
                                'AND objective_id = '.$ilDB->quote($this->getObjectiveId(),'integer').' '.
                                'AND tst_type = '.$ilDB->quote($this->getTestType(),'integer');
                
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $this->setLimit($row->percentage);
                        $this->setTestId($row->tst_id);
                        $this->setQplSequence($row->qp_seq);
                }
                return true;
        }
        
        public function delete()
        {
                global $ilDB;

                $query = 'DELETE FROM loc_rnd_qpl '.
                                'WHERE container_id = '.$ilDB->quote($this->getContainerId(),'integer').' '.
                                'AND objective_id = '.$ilDB->quote($this->getObjectiveId(),'integer').' '.
                                'AND tst_type = '.$ilDB->quote($this->getTestType(),'integer');
                $ilDB->manipulate($query);
        }
        
        public function create()
        {
                global $ilDB;
                
                $query = 'INSERT INTO loc_rnd_qpl ' .
                                '(container_id, objective_id, tst_type, tst_id, qp_seq, percentage) '.
                                'VALUES ( '.
                                $ilDB->quote($this->getContainerId(),'integer').', '.
                                $ilDB->quote($this->getObjectiveId(),'integer').', '.
                                $ilDB->quote($this->getTestType(),'integer').', '.
                                $ilDB->quote($this->getTestId(),'integer').', '.
                                $ilDB->quote($this->getQplSequence(),'integer').', '.
                                $ilDB->quote($this->getLimit()).' '.
                                ')';
                $ilDB->manipulate($query);
        }
}
?>