class.ilAssQuestionSolutionComparisonExpressionList.php

Go to the documentation of this file.

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

require_once 'Modules/TestQuestionPool/classes/class.ilAssQuestionSolutionComparisonExpression.php';

class ilAssQuestionSolutionComparisonExpressionList
{
        protected $db;

        private $questionId;

        private  $skillBaseId;

        private $skillTrefId;

        private $expressions;
        
        public function __construct(ilDBInterface $db)
        {
                $this->db = $db;
                
                $this->questionId = null;
                $this->skillBaseId = null;
                $this->skillTrefId = null;
                
                $this->expressions = array();
        }
        
        public function load()
        {
                $query = "
                        SELECT *
                        FROM qpl_qst_skl_sol_expr
                        WHERE question_fi = %s AND skill_base_fi = %s AND skill_tref_fi = %s
                ";

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

                while($row = $this->db->fetchAssoc($res) )
                {
                        $expression = new ilAssQuestionSolutionComparisonExpression();
                        $expression->setDb($this->db);
                        $expression->initInstanceFromArray($row);

                        $this->add($expression);
                }
        }
        
        public function save()
        {
                $this->delete();
                
                foreach($this->expressions as $orderIndex => $expression)
                {
                        /* @var ilAssQuestionSolutionComparisonExpression $expression */
                        
                        $expression->setQuestionId($this->getQuestionId());
                        $expression->save();
                }
        }
        
        public function delete()
        {
                $query = "
                        DELETE FROM qpl_qst_skl_sol_expr
                        WHERE question_fi = %s AND skill_base_fi = %s AND skill_tref_fi = %s
                ";
                
                $this->db->manipulateF($query, array('integer', 'integer', 'integer'),
                        array($this->getQuestionId(), $this->getSkillBaseId(), $this->getSkillTrefId())
                );
        }
        
        public function add(ilAssQuestionSolutionComparisonExpression $expression)
        {
                $expression->setDb($this->db);
                $expression->setQuestionId($this->getQuestionId());
                $expression->setSkillBaseId($this->getSkillBaseId());
                $expression->setSkillTrefId($this->getSkillTrefId());
                
                $this->expressions[$expression->getOrderIndex()] = $expression;
        }

        public function get()
        {
                return $this->expressions;
        }
        
        public function reset()
        {
                $this->expressions = array();
        }

        public function getQuestionId()
        {
                return $this->questionId;
        }

        public function setQuestionId($questionId)
        {
                $this->questionId = $questionId;
        }

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

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

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

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