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 = array();
    }

    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,
            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(): 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,
            array('integer', 'integer', 'integer'),
            array($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 = array();
    }

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