class.ilAssQuestionHintList.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.ilAssQuestionHint.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()
    {
        return key($this->questionHints) !== null;
    }
    
    public function __construct()
    {
    }
    
    public function addHint(ilAssQuestionHint $questionHint)
    {
        $this->questionHints[] = $questionHint;
    }
    
    public function getHint($hintId)
    {
        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)
    {
        foreach ($this as $questionHint) {
            /* @var $questionHint ilAssQuestionHint */

            if ($questionHint->getId() == $hintId) {
                return true;
            }
        }
        
        return false;
    }
    
    public function reIndex()
    {
        $counter = 0;
        
        foreach ($this as $questionHint) {
            /* @var $questionHint ilAssQuestionHint */
            
            $questionHint->setIndex(++$counter);
            $questionHint->save();
        }
    }
    
    public static function duplicateListForQuestion($originalQuestionId, $duplicateQuestionId)
    {
        $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()
    {
        $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)
    {
        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)
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        
        $qht_hint_id__IN__hintIds = $ilDB->in('qht_hint_id', $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)
    {
        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);
    }
}