class.ilAssQuestionHintList.php

Go to the documentation of this file.

<?php
 
class ilAssQuestionHintList implements Iterator
{
    private $questionHints = array();
 
    public function current()
    {
        return current($this->questionHints);
    }
 
    public function rewind()
    {
        return reset($this->questionHints);
    }
 
    public function next()
    {
        return next($this->questionHints);
    }
 
    public function key()
    {
        return key($this->questionHints);
    }
 
    public function valid(): bool
    {
        return key($this->questionHints) !== null;
    }
 
    public function __construct()
    {
    }
 
    public function addHint(ilAssQuestionHint $questionHint): void
    {
        $this->questionHints[] = $questionHint;
    }
 
    public function getHint($hintId): ilAssQuestionHint
    {
        foreach ($this as $questionHint) {
            /* @var $questionHint ilAssQuestionHint */
 
            if ($questionHint->getId() == $hintId) {
                return $questionHint;
            }
        }
 
        require_once 'Modules/TestQuestionPool/exceptions/class.ilTestQuestionPoolException.php';
        throw new ilTestQuestionPoolException("hint with id $hintId does not exist in this list");
    }
 
    public function hintExists($hintId): bool
    {
        foreach ($this as $questionHint) {
            /* @var $questionHint ilAssQuestionHint */
 
            if ($questionHint->getId() == $hintId) {
                return true;
            }
        }
 
        return false;
    }
 
    public function reIndex(): void
    {
        $counter = 0;
 
        foreach ($this as $questionHint) {
            /* @var $questionHint ilAssQuestionHint */
 
            $questionHint->setIndex(++$counter);
            $questionHint->save();
        }
    }
 
    public static function duplicateListForQuestion($originalQuestionId, $duplicateQuestionId): array
    {
        $hintIds = array();
 
        $questionHintList = self::getListByQuestionId($originalQuestionId);
 
        foreach ($questionHintList as $questionHint) {
            /* @var $questionHint ilAssQuestionHint */
 
            $originalHintId = $questionHint->getId();
 
            $questionHint->setId(null);
            $questionHint->setQuestionId($duplicateQuestionId);
 
            $questionHint->save();
 
            $duplicateHintId = $questionHint->getId();
 
            $hintIds[$originalHintId] = $duplicateHintId;
        }
 
        return $hintIds;
    }
 
    public function getTableData(): array
    {
        $tableData = array();
 
        foreach ($this as $questionHint) {
            /* @var $questionHint ilAssQuestionHint */
 
            $tableData[] = array(
                'hint_id' => $questionHint->getId(),
                'hint_index' => $questionHint->getIndex(),
                'hint_points' => $questionHint->getPoints(),
                'hint_text' => $questionHint->getText()
            );
        }
 
        return $tableData;
    }
 
    public static function getListByQuestionId($questionId): ilAssQuestionHintList
    {
        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_question_fi = %s
                        
                        ORDER BY        qht_hint_index ASC
                ";
 
        $res = $ilDB->queryF(
            $query,
            array('integer'),
            array((int) $questionId)
        );
 
        $questionHintList = new self();
 
        while ($row = $ilDB->fetchAssoc($res)) {
            $questionHint = new ilAssQuestionHint();
 
            ilAssQuestionHint::assignDbRow($questionHint, $row);
 
            $questionHintList->addHint($questionHint);
        }
 
        return $questionHintList;
    }
 
    public static function getListByHintIds($hintIds): ilAssQuestionHintList
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $qht_hint_id__IN__hintIds = $ilDB->in('qht_hint_id', (array) $hintIds, false, 'integer');
 
        $query = "
                        SELECT          qht_hint_id,
                                                qht_question_fi,
                                                qht_hint_index,
                                                qht_hint_points,
                                                qht_hint_text
                                        
                        FROM            qpl_hints
                        
                        WHERE           $qht_hint_id__IN__hintIds
                        
                        ORDER BY        qht_hint_index ASC
                ";
 
        $res = $ilDB->query($query);
 
        $questionHintList = new self();
 
        while ($row = $ilDB->fetchAssoc($res)) {
            $questionHint = new ilAssQuestionHint();
 
            ilAssQuestionHint::assignDbRow($questionHint, $row);
 
            $questionHintList->addHint($questionHint);
        }
 
        return $questionHintList;
    }
 
    public static function getNextIndexByQuestionId($questionId): int
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $query = "
                        SELECT          1 + COALESCE( MAX(qht_hint_index), 0 ) next_index
                                        
                        FROM            qpl_hints
                        
                        WHERE           qht_question_fi = %s
                ";
 
        $res = $ilDB->queryF(
            $query,
            array('integer'),
            array((int) $questionId)
        );
 
        $row = $ilDB->fetchAssoc($res);
 
        return $row['next_index'];
    }
 
    public static function deleteHintsByQuestionIds($questionIds)
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $__qht_question_fi__IN__questionIds = $ilDB->in('qht_question_fi', $questionIds, false, 'integer');
 
        $query = "
                        DELETE FROM             qpl_hints
                        WHERE                   $__qht_question_fi__IN__questionIds
                ";
 
        return $ilDB->manipulate($query);
    }
}