class.ilTestRandomQuestionSetSourcePoolDefinition.php

Go to the documentation of this file.

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

class ilTestRandomQuestionSetSourcePoolDefinition
{
        protected $db = null;
        
        protected $testOBJ = null;

    private $id = null;
        
        private $poolId = null;
        
        private $poolTitle = null;
        
        private $poolPath = null;
        
        private $poolQuestionCount = null;
        
        private $originalFilterTaxId = null;
        
        private $originalFilterTaxNodeId = null;

        private $mappedFilterTaxId = null;

        private $mappedFilterTaxNodeId = null;

        private $questionAmount = null;
        
        private $sequencePosition = null;
        
        public function __construct(ilDBInterface $db, ilObjTest $testOBJ)
        {
                $this->db = $db;
                $this->testOBJ = $testOBJ;
        }

    public function setId($id)
        {
                $this->id = $id;
        }

        public function getId()
        {
                return $this->id;
        }
        
        public function setPoolId($poolId)
        {
                $this->poolId = $poolId;
        }
        
        public function getPoolId()
        {
                return $this->poolId;
        }
        
        public function setPoolTitle($poolTitle)
        {
                $this->poolTitle = $poolTitle;
        }
        
        public function getPoolTitle()
        {
                return $this->poolTitle;
        }
        
        public function setPoolPath($poolPath)
        {
                $this->poolPath = $poolPath;
        }
        
        public function getPoolPath()
        {
                return $this->poolPath;
        }
        
        public function setPoolQuestionCount($poolQuestionCount)
        {
                $this->poolQuestionCount = $poolQuestionCount;
        }
        
        public function getPoolQuestionCount()
        {
                return $this->poolQuestionCount;
        }
        
        public function setOriginalFilterTaxId($originalFilterTaxId)
        {
                $this->originalFilterTaxId = $originalFilterTaxId;
        }
        
        public function getOriginalFilterTaxId()
        {
                return $this->originalFilterTaxId;
        }
        
        public function setOriginalFilterTaxNodeId($originalFilterNodeId)
        {
                $this->originalFilterTaxNodeId = $originalFilterNodeId;
        }
        
        public function getOriginalFilterTaxNodeId()
        {
                return $this->originalFilterTaxNodeId;
        }

        public function setMappedFilterTaxId($mappedFilterTaxId)
        {
                $this->mappedFilterTaxId = $mappedFilterTaxId;
        }

        public function getMappedFilterTaxId()
        {
                return $this->mappedFilterTaxId;
        }

        public function setMappedFilterTaxNodeId($mappedFilterTaxNodeId)
        {
                $this->mappedFilterTaxNodeId = $mappedFilterTaxNodeId;
        }

        public function getMappedFilterTaxNodeId()
        {
                return $this->mappedFilterTaxNodeId;
        }

        public function setQuestionAmount($questionAmount)
        {
                $this->questionAmount = $questionAmount;
        }
        
        public function getQuestionAmount()
        {
                return $this->questionAmount;
        }
        
        public function setSequencePosition($sequencePosition)
        {
                $this->sequencePosition = $sequencePosition;
        }
        
        public function getSequencePosition()
        {
                return $this->sequencePosition;
        }
        
        // -----------------------------------------------------------------------------------------------------------------
        
        public function initFromArray($dataArray)
        {
                foreach($dataArray as $field => $value)
                {
                        switch($field)
                        {
                                case 'def_id':                          $this->setId($value);                                           break;
                                case 'pool_fi':                         $this->setPoolId($value);                                       break;
                                case 'pool_title':                      $this->setPoolTitle($value);                            break;
                                case 'pool_path':                       $this->setPoolPath($value);                                     break;
                                case 'pool_quest_count':        $this->setPoolQuestionCount($value);            break;
                                case 'origin_tax_fi':           $this->setOriginalFilterTaxId($value);          break;
                                case 'origin_node_fi':          $this->setOriginalFilterTaxNodeId($value);      break;
                                case 'mapped_tax_fi':           $this->setMappedFilterTaxId($value);            break;
                                case 'mapped_node_fi':          $this->setMappedFilterTaxNodeId($value);        break;
                                case 'quest_amount':            $this->setQuestionAmount($value);                       break;
                                case 'sequence_pos':            $this->setSequencePosition($value);                     break;
                        }
                }
        }
        
        public function loadFromDb($id)
        {
                $res = $this->db->queryF(
                                "SELECT * FROM tst_rnd_quest_set_qpls WHERE def_id = %s", array('integer'), array($id)
                );
                
                while( $row = $this->db->fetchAssoc($res) )
                {
                        $this->initFromArray($row);
                        
                        return true;
                }
                
                return false;
        }

        public function saveToDb()
        {
                if( $this->getId() )
                {
                        $this->updateDbRecord($this->testOBJ->getTestId());
                }
                else
                {
                        $this->insertDbRecord($this->testOBJ->getTestId());
                }
        }

        public function cloneToDbForTestId($testId)
        {
                $this->insertDbRecord($testId);
        }

        public function deleteFromDb()
        {
                $this->db->manipulateF(
                                "DELETE FROM tst_rnd_quest_set_qpls WHERE def_id = %s", array('integer'), array($this->getId())
                );
        }

        private function updateDbRecord($testId)
        {
                $this->db->update('tst_rnd_quest_set_qpls',
                        array(
                                'test_fi' => array('integer', $testId),
                                'pool_fi' => array('integer', $this->getPoolId()),
                                'pool_title' => array('text', $this->getPoolTitle()),
                                'pool_path' => array('text', $this->getPoolPath()),
                                'pool_quest_count' => array('integer', $this->getPoolQuestionCount()),
                                'origin_tax_fi' => array('integer', $this->getOriginalFilterTaxId()),
                                'origin_node_fi' => array('integer', $this->getOriginalFilterTaxNodeId()),
                                'mapped_tax_fi' => array('integer', $this->getMappedFilterTaxId()),
                                'mapped_node_fi' => array('integer', $this->getMappedFilterTaxNodeId()),
                                'quest_amount' => array('integer', $this->getQuestionAmount()),
                                'sequence_pos' => array('integer', $this->getSequencePosition())
                        ),
                        array(
                                'def_id' => array('integer', $this->getId())
                        )
                );
        }

        private function insertDbRecord($testId)
        {
                $nextId = $this->db->nextId('tst_rnd_quest_set_qpls');

                $this->db->insert('tst_rnd_quest_set_qpls', array(
                                'def_id' => array('integer', $nextId),
                                'test_fi' => array('integer', $testId),
                                'pool_fi' => array('integer', $this->getPoolId()),
                                'pool_title' => array('text', $this->getPoolTitle()),
                                'pool_path' => array('text', $this->getPoolPath()),
                                'pool_quest_count' => array('integer', $this->getPoolQuestionCount()),
                                'origin_tax_fi' => array('integer', $this->getOriginalFilterTaxId()),
                                'origin_node_fi' => array('integer', $this->getOriginalFilterTaxNodeId()),
                                'mapped_tax_fi' => array('integer', $this->getMappedFilterTaxId()),
                                'mapped_node_fi' => array('integer', $this->getMappedFilterTaxNodeId()),
                                'quest_amount' => array('integer', $this->getQuestionAmount()),
                                'sequence_pos' => array('integer', $this->getSequencePosition())
                ));

                $this->setId($nextId);
        }
        
        // -----------------------------------------------------------------------------------------------------------------
        
        public function getPoolInfoLabel(ilLanguage $lng)
        {
                $poolInfoLabel = sprintf(
                        $lng->txt('tst_dynamic_question_set_source_questionpool_summary_string'),
                        $this->getPoolTitle(),
                        $this->getPoolPath(),
                        $this->getPoolQuestionCount()
                );
                
                return $poolInfoLabel;
        }

        // -----------------------------------------------------------------------------------------------------------------
}