class.ilAssQuestionSolutionComparisonExpressionList.php

Go to the documentation of this file.

<?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 = [];
    }
 
    public function load(): void
    {
        $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,
            ['integer', 'integer', 'integer'],
            [$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(): void
    {
        $this->delete();
 
        foreach ($this->expressions as $orderIndex => $expression) {
            /* @var ilAssQuestionSolutionComparisonExpression $expression */
 
            $expression->setQuestionId($this->getQuestionId());
            $expression->save();
        }
    }
 
    public function delete(): void
    {
        $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,
            ['integer', 'integer', 'integer'],
            [$this->getQuestionId(), $this->getSkillBaseId(), $this->getSkillTrefId()]
        );
    }
 
    public function add(ilAssQuestionSolutionComparisonExpression $expression): void
    {
        $expression->setDb($this->db);
        $expression->setQuestionId($this->getQuestionId());
        $expression->setSkillBaseId($this->getSkillBaseId());
        $expression->setSkillTrefId($this->getSkillTrefId());
 
        $this->expressions[$expression->getOrderIndex()] = $expression;
    }
 
    public function get(): array
    {
        return $this->expressions;
    }
 
    public function reset(): void
    {
        $this->expressions = [];
    }
 
    public function getQuestionId(): ?int
    {
        return $this->questionId;
    }
 
    public function setQuestionId($questionId): void
    {
        $this->questionId = $questionId;
    }
 
    public function getSkillBaseId(): ?int
    {
        return $this->skillBaseId;
    }
 
    public function setSkillBaseId($skillBaseId): void
    {
        $this->skillBaseId = $skillBaseId;
    }
 
    public function getSkillTrefId(): ?int
    {
        return $this->skillTrefId;
    }
 
    public function setSkillTrefId($skillTrefId): void
    {
        $this->skillTrefId = $skillTrefId;
    }
}