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;
    }
}