class.ilAssQuestionHint.php

Go to the documentation of this file.

<?php
class ilAssQuestionHint
{
    public const PAGE_OBJECT_TYPE = 'qht';

    private $id = null;

    private $questionId = null;

    private $index = null;

    private $points = null;

    private $text = null;

    public function __construct()
    {
    }

    public function getId(): ?int
    {
        return $this->id;
    }

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

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

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

    public function getIndex(): ?int
    {
        return $this->index;
    }

    public function setIndex($index): void
    {
        $this->index = (int) $index;
    }

    public function getPoints(): ?float
    {
        return $this->points;
    }

    public function setPoints($points): void
    {
        $this->points = abs((float) $points);
    }

    public function getText(): ?string
    {
        return $this->text;
    }

    public function setText($text): void
    {
        if ($text !== null) {
            $this->text = $this->getHtmlQuestionContentPurifier()->purify($text);
        }
    }

    public function load($id): bool
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];

        $query = "
                        SELECT  qht_hint_id,
                                        qht_question_fi,
                                        qht_hint_index,
                                        qht_hint_points,
                                        qht_hint_text

                        FROM    qpl_hints

                        WHERE   qht_hint_id = %s
                ";

        $res = $ilDB->queryF(
            $query,
            ['integer'],
            [(int) $id]
        );

        while ($row = $ilDB->fetchAssoc($res)) {
            self::assignDbRow($this, $row);

            return true;
        }

        return false;
    }

    public function save(): bool
    {
        if ($this->getId()) {
            return $this->update();
        } else {
            return $this->insert();
        }
    }

    private function update(): bool
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];

        return $ilDB->update(
            'qpl_hints',
            [
                    'qht_question_fi' => ['integer', $this->getQuestionId()],
                    'qht_hint_index' => ['integer', $this->getIndex()],
                    'qht_hint_points' => ['float', $this->getPoints()],
                    'qht_hint_text' => ['clob', $this->getText()]
                ],
            [
                    'qht_hint_id' => ['integer', $this->getId()]
                ]
        );
    }

    private function insert(): bool
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];

        $this->setId($ilDB->nextId('qpl_hints'));

        return $ilDB->insert('qpl_hints', [
            'qht_hint_id' => ['integer', $this->getId()],
            'qht_question_fi' => ['integer', $this->getQuestionId()],
            'qht_hint_index' => ['integer', $this->getIndex()],
            'qht_hint_points' => ['float', $this->getPoints()],
            'qht_hint_text' => ['clob', $this->getText()]
        ]);
    }

    public function delete(): int
    {
        return self::deleteById($this->getId());
    }

    public static function assignDbRow(self $questionHint, $hintDbRow): void
    {
        foreach ($hintDbRow as $field => $value) {
            switch ($field) {
                case 'qht_hint_id':                     $questionHint->setId($value);
                    break;
                case 'qht_question_fi':         $questionHint->setQuestionId($value);
                    break;
                case 'qht_hint_index':          $questionHint->setIndex($value);
                    break;
                case 'qht_hint_points':         $questionHint->setPoints($value);
                    break;
                case 'qht_hint_text':           $questionHint->setText($value);
                    break;

                default:        throw new ilTestQuestionPoolException("invalid db field identifier ($field) given!");
            }
        }
    }

    public static function deleteById($hintId): int
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];

        $query = "
                        DELETE FROM             qpl_hints
                        WHERE                   qht_hint_id = %s
                ";

        return $ilDB->manipulateF(
            $query,
            ['integer'],
            [$hintId]
        );
    }

    public static function getInstanceById($hintId): ilAssQuestionHint
    {
        $questionHint = new self();
        $questionHint->load($hintId);
        return $questionHint;
    }

    public function getPageObjectType(): string
    {
        return self::PAGE_OBJECT_TYPE;
    }

    public static function getHintIndexLabel(ilLanguage $lng, $hintIndex): string
    {
        return sprintf($lng->txt('tst_question_hints_index_column_label'), $hintIndex);
    }

    protected function getHtmlQuestionContentPurifier(): ilAssHtmlUserSolutionPurifier
    {
        return ilHtmlPurifierFactory::getInstanceByType('qpl_usersolution');
    }
}