class.ilAssMultiOptionQuestionFeedback.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/feedback/class.ilAssQuestionFeedback.php';

abstract class ilAssMultiOptionQuestionFeedback extends ilAssQuestionFeedback
{
    const TABLE_NAME_SPECIFIC_FEEDBACK = 'qpl_fb_specific';
    
    public function getSpecificAnswerFeedbackTestPresentation($questionId, $answerIndex)
    {
        if ($this->questionOBJ->isAdditionalContentEditingModePageObject()) {
            $specificAnswerFeedbackTestPresentationHTML = $this->getPageObjectContent(
                $this->getSpecificAnswerFeedbackPageObjectType(),
                $this->getSpecificAnswerFeedbackPageObjectId($questionId, $answerIndex)
            );
        } else {
            $specificAnswerFeedbackTestPresentationHTML = $this->getSpecificAnswerFeedbackContent(
                $questionId,
                $answerIndex
            );
        }
                
        return $specificAnswerFeedbackTestPresentationHTML;
    }
    
    public function completeSpecificFormProperties(ilPropertyFormGUI $form)
    {
        if (!$this->questionOBJ->getSelfAssessmentEditingMode()) {
            $header = new ilFormSectionHeaderGUI();
            $header->setTitle($this->lng->txt('feedback_answers'));
            $form->addItem($header);
        
            foreach ($this->getAnswerOptionsByAnswerIndex() as $index => $answer) {
                $propertyLabel = $this->questionOBJ->prepareTextareaOutput(
                    $this->buildAnswerOptionLabel($index, $answer),
                    true
                );
                
                $propertyPostVar = "feedback_answer_$index";
                
                $form->addItem($this->buildFeedbackContentFormProperty(
                    $propertyLabel,
                    $propertyPostVar,
                    $this->questionOBJ->isAdditionalContentEditingModePageObject()
                ));
            }
        }
    }
    
    public function initSpecificFormProperties(ilPropertyFormGUI $form)
    {
        if (!$this->questionOBJ->getSelfAssessmentEditingMode()) {
            foreach ($this->getAnswerOptionsByAnswerIndex() as $index => $answer) {
                if ($this->questionOBJ->isAdditionalContentEditingModePageObject()) {
                    $value = $this->getPageObjectNonEditableValueHTML(
                        $this->getSpecificAnswerFeedbackPageObjectType(),
                        $this->getSpecificAnswerFeedbackPageObjectId($this->questionOBJ->getId(), $index)
                    );
                } else {
                    $value = $this->questionOBJ->prepareTextareaOutput(
                        $this->getSpecificAnswerFeedbackContent($this->questionOBJ->getId(), $index)
                    );
                }
                
                $form->getItemByPostVar("feedback_answer_$index")->setValue($value);
            }
        }
    }
    
    public function saveSpecificFormProperties(ilPropertyFormGUI $form)
    {
        if (!$this->questionOBJ->isAdditionalContentEditingModePageObject()) {
            foreach ($this->getAnswerOptionsByAnswerIndex() as $index => $answer) {
                $this->saveSpecificAnswerFeedbackContent(
                    $this->questionOBJ->getId(),
                    $index,
                    $form->getInput("feedback_answer_$index")
                );
            }
        }
    }

    public function getSpecificAnswerFeedbackContent($questionId, $answerIndex)
    {
        require_once 'Services/RTE/classes/class.ilRTE.php';
        
        $res = $this->db->queryF(
            "SELECT * FROM {$this->getSpecificFeedbackTableName()} WHERE question_fi = %s AND answer = %s",
            array('integer','integer'),
            array($questionId, $answerIndex)
        );
        
        while ($row = $this->db->fetchAssoc($res)) {
            $feedbackContent = ilRTE::_replaceMediaObjectImageSrc($row['feedback'], 1);
            break;
        }
        
        return $feedbackContent;
    }
    
    public function getAllSpecificAnswerFeedbackContents($questionId)
    {
        require_once 'Services/RTE/classes/class.ilRTE.php';
        
        $res = $this->db->queryF(
            "SELECT * FROM {$this->getSpecificFeedbackTableName()} WHERE question_fi = %s",
            array('integer'),
            array($questionId)
        );
        
        $allFeedbackContents = '';
        
        while ($row = $this->db->fetchAssoc($res)) {
            $allFeedbackContents .= ilRTE::_replaceMediaObjectImageSrc($row['feedback'], 1);
        }
        
        return $allFeedbackContents;
    }
    
    public function saveSpecificAnswerFeedbackContent($questionId, $answerIndex, $feedbackContent)
    {
        require_once 'Services/RTE/classes/class.ilRTE.php';
        
        if (strlen($feedbackContent)) {
            $feedbackContent = ilRTE::_replaceMediaObjectImageSrc($feedbackContent, 0);
        }
        
        $feedbackId = $this->getSpecificAnswerFeedbackId($questionId, $answerIndex);
        
        if ($feedbackId) {
            $this->db->update(
                $this->getSpecificFeedbackTableName(),
                array(
                    'feedback' => array('text', $feedbackContent),
                    'tstamp' => array('integer', time())
                ),
                array(
                    'feedback_id' => array('integer', $feedbackId),
                )
            );
        } else {
            $feedbackId = $this->db->nextId($this->getSpecificFeedbackTableName());
            
            $this->db->insert($this->getSpecificFeedbackTableName(), array(
                'feedback_id' => array('integer', $feedbackId),
                'question_fi' => array('integer', $questionId),
                'answer' => array('integer', $answerIndex),
                'feedback' => array('text', $feedbackContent),
                'tstamp' => array('integer', time())
            ));
        }
        
        return $feedbackId;
    }
        
    public function deleteSpecificAnswerFeedbacks($questionId, $isAdditionalContentEditingModePageObject)
    {
        if ($isAdditionalContentEditingModePageObject) {
            foreach ($this->getSpecificAnswerFeedbackIdByAnswerIndexMap($questionId) as $answerIndex => $pageObjectId) {
                $this->ensurePageObjectDeleted($this->getSpecificAnswerFeedbackPageObjectType(), $pageObjectId);
            }
        }
        
        $this->db->manipulateF(
            "DELETE FROM {$this->getSpecificFeedbackTableName()} WHERE question_fi = %s",
            array('integer'),
            array($questionId)
        );
    }
    protected function duplicateSpecificFeedback($originalQuestionId, $duplicateQuestionId)
    {
        $res = $this->db->queryF(
            "SELECT * FROM {$this->getSpecificFeedbackTableName()} WHERE question_fi = %s",
            array('integer'),
            array($originalQuestionId)
        );
        
        while ($row = $this->db->fetchAssoc($res)) {
            $nextId = $this->db->nextId($this->getSpecificFeedbackTableName());
            
            $this->db->insert($this->getSpecificFeedbackTableName(), array(
                'feedback_id' => array('integer', $nextId),
                'question_fi' => array('integer', $duplicateQuestionId),
                'answer' => array('integer', $row['answer']),
                'feedback' => array('text', $row['feedback']),
                'tstamp' => array('integer', time())
            ));
            
            if ($this->questionOBJ->isAdditionalContentEditingModePageObject()) {
                $pageObjectType = $this->getSpecificAnswerFeedbackPageObjectType();
                $this->duplicatePageObject($pageObjectType, $row['feedback_id'], $nextId, $duplicateQuestionId);
            }
        }
    }
    
    protected function syncSpecificFeedback($originalQuestionId, $duplicateQuestionId)
    {
        // delete specific feedback of the original
        $this->db->manipulateF(
            "DELETE FROM {$this->getSpecificFeedbackTableName()} WHERE question_fi = %s",
            array('integer'),
            array($originalQuestionId)
        );
            
        // get specific feedback of the actual question
        $res = $this->db->queryF(
            "SELECT * FROM {$this->getSpecificFeedbackTableName()} WHERE question_fi = %s",
            array('integer'),
            array($duplicateQuestionId)
        );

        // save specific feedback to the original
        while ($row = $this->db->fetchAssoc($res)) {
            $nextId = $this->db->nextId($this->getSpecificFeedbackTableName());
            
            $this->db->insert($this->getSpecificFeedbackTableName(), array(
                'feedback_id' => array('integer', $nextId),
                'question_fi' => array('integer', $originalQuestionId),
                'answer' => array('integer',$row['answer']),
                'feedback' => array('text',$row['feedback']),
                'tstamp' => array('integer',time())
            ));
        }
    }
    
    final protected function getSpecificAnswerFeedbackId($questionId, $answerIndex)
    {
        $res = $this->db->queryF(
            "SELECT feedback_id FROM {$this->getSpecificFeedbackTableName()} WHERE question_fi = %s AND answer = %s",
            array('integer','integer'),
            array($questionId, $answerIndex)
        );
        
        $feedbackId = null;
        
        while ($row = $this->db->fetchAssoc($res)) {
            $feedbackId = $row['feedback_id'];
            break;
        }
        
        return $feedbackId;
    }
    
    protected function isSpecificAnswerFeedbackId($feedbackId)
    {
        $row = $this->db->fetchAssoc($this->db->queryF(
            "SELECT COUNT(feedback_id) cnt FROM {$this->getSpecificFeedbackTableName()}
                                        WHERE question_fi = %s AND feedback_id = %s",
            array('integer', 'integer'),
            array($this->questionOBJ->getId(), $feedbackId)
        ));
        
        return (bool) $row['cnt'];
    }
    
    final protected function getSpecificAnswerFeedbackIdByAnswerIndexMap($questionId)
    {
        $res = $this->db->queryF(
            "SELECT feedback_id, answer FROM {$this->getSpecificFeedbackTableName()} WHERE question_fi = %s",
            array('integer'),
            array($questionId)
        );
        
        $feedbackIdByAnswerIndexMap = array();
        
        while ($row = $this->db->fetchAssoc($res)) {
            $feedbackIdByAnswerIndexMap[ $row['answer'] ] = $row['feedback_id'];
        }
        
        return $feedbackIdByAnswerIndexMap;
    }

    final protected function getSpecificFeedbackTableName()
    {
        return self::TABLE_NAME_SPECIFIC_FEEDBACK;
    }
    
    public function getAnswerOptionsByAnswerIndex()
    {
        return $this->questionOBJ->getAnswers();
    }
    
    protected function buildAnswerOptionLabel($index, $answer)
    {
        return $answer->getAnswertext();
    }
    
    final protected function getSpecificAnswerFeedbackPageObjectId($questionId, $answerIndex)
    {
        $pageObjectId = $this->getSpecificAnswerFeedbackId($questionId, $answerIndex);
        
        if (!$pageObjectId) {
            $pageObjectId = $this->saveSpecificAnswerFeedbackContent($questionId, $answerIndex, null);
        }
        
        return $pageObjectId;
    }
    
    public function getSpecificAnswerFeedbackExportPresentation($questionId, $answerIndex)
    {
        if ($this->questionOBJ->isAdditionalContentEditingModePageObject()) {
            $specificAnswerFeedbackExportPresentation = $this->getPageObjectXML(
                $this->getSpecificAnswerFeedbackPageObjectType(),
                $this->getSpecificAnswerFeedbackPageObjectId($questionId, $answerIndex)
            );
        } else {
            $specificAnswerFeedbackExportPresentation = $this->getSpecificAnswerFeedbackContent(
                $questionId,
                $answerIndex
            );
        }
                
        return $specificAnswerFeedbackExportPresentation;
    }
    
    public function importSpecificAnswerFeedback($questionId, $answerIndex, $feedbackContent)
    {
        if ($this->questionOBJ->isAdditionalContentEditingModePageObject()) {
            $pageObjectId = $this->getSpecificAnswerFeedbackPageObjectId($questionId, $answerIndex);
            $pageObjectType = $this->getSpecificAnswerFeedbackPageObjectType();
            
            $this->createPageObject($pageObjectType, $pageObjectId, $feedbackContent);
        } else {
            $this->saveSpecificAnswerFeedbackContent($questionId, $answerIndex, $feedbackContent);
        }
    }

    public function specificAnswerFeedbackExists($answerIndexes)
    {
        foreach ($answerIndexes as $answerIndex) {
            $fb = $this->getSpecificAnswerFeedbackExportPresentation($this->questionOBJ->getId(), $answerIndex);
            
            if (strlen($fb)) {
                return true;
            }
        }
        
        return false;
    }
}