class.assOrderingQuestion.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.assQuestion.php';
require_once './Modules/Test/classes/inc.AssessmentConstants.php';
require_once './Modules/TestQuestionPool/interfaces/interface.ilObjQuestionScoringAdjustable.php';
require_once './Modules/TestQuestionPool/interfaces/interface.ilObjAnswerScoringAdjustable.php';
require_once './Modules/TestQuestionPool/interfaces/interface.iQuestionCondition.php';
require_once './Modules/TestQuestionPool/classes/class.ilUserQuestionResult.php';

class assOrderingQuestion extends assQuestion implements ilObjQuestionScoringAdjustable, ilObjAnswerScoringAdjustable, iQuestionCondition
{
        var $answers;

        var $ordering_type;

        var $thumb_geometry = 100;

        var $element_height;

        public $old_ordering_depth = array();
        public $leveled_ordering = array();

        public function __construct(
                $title = "",
                $comment = "",
                $author = "",
                $owner = -1,
                $question = "",
                $ordering_type = OQ_TERMS
        )
        {
                parent::__construct($title, $comment, $author, $owner, $question);
                $this->answers = array();
                $this->ordering_type = $ordering_type;
        }

        public function isComplete()
        {
                if (
                        strlen($this->title) && 
                        $this->author && 
                        $this->question && 
                        count($this->answers) && 
                        $this->getMaximumPoints() > 0
                )
                {
                        return true;
                }
                return false;
        }

        public function saveToDb($original_id = "")
        {
                global $ilDB;

                $this->saveQuestionDataToDb($original_id);
                $this->saveAdditionalQuestionDataToDb();
                $this->saveAnswerSpecificDataToDb();
                parent::saveToDb($original_id);
        }
        
        function loadFromDb($question_id)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT qpl_questions.*, " . $this->getAdditionalTableName() . ".* FROM qpl_questions LEFT JOIN " . $this->getAdditionalTableName() . " ON " . $this->getAdditionalTableName() . ".question_fi = qpl_questions.question_id WHERE qpl_questions.question_id = %s",
                        array("integer"),
                        array($question_id)
                );
                if ($result->numRows() == 1)
                {
                        $data = $ilDB->fetchAssoc($result);
                        $this->setId($question_id);
                        $this->setObjId($data["obj_fi"]);
                        $this->setTitle($data["title"]);
                        $this->setComment($data["description"]);
                        $this->setOriginalId($data["original_id"]);
                        $this->setAuthor($data["author"]);
                        $this->setNrOfTries($data['nr_of_tries']);
                        $this->setPoints($data["points"]);
                        $this->setOwner($data["owner"]);
                        include_once("./Services/RTE/classes/class.ilRTE.php");
                        $this->setQuestion(ilRTE::_replaceMediaObjectImageSrc($data["question_text"], 1));
                        $this->ordering_type = strlen($data["ordering_type"]) ? $data["ordering_type"] : OQ_TERMS;
                        $this->thumb_geometry = $data["thumb_geometry"];
                        $this->element_height = $data["element_height"];
                        $this->setEstimatedWorkingTime(substr($data["working_time"], 0, 2), substr($data["working_time"], 3, 2), substr($data["working_time"], 6, 2));
                        
                        try
                        {
                                $this->setAdditionalContentEditingMode($data['add_cont_edit_mode']);
                        }
                        catch(ilTestQuestionPoolException $e)
                        {
                        }
                }

                $result = $ilDB->queryF("SELECT * FROM qpl_a_ordering WHERE question_fi = %s ORDER BY solution_order ASC",
                        array('integer'),
                        array($question_id)
                );

                include_once "./Modules/TestQuestionPool/classes/class.assAnswerOrdering.php";
                if ($result->numRows() > 0)
                {
                        while ($data = $ilDB->fetchAssoc($result))
                        {
                                include_once("./Services/RTE/classes/class.ilRTE.php");
                                $data["answertext"] = ilRTE::_replaceMediaObjectImageSrc($data["answertext"], 1);
                                array_push($this->answers, new ASS_AnswerOrdering($data["answertext"], $data["random_id"], $data['depth'] ? $data['depth'] : 0));
                        }
                }
                parent::loadFromDb($question_id);
        }
        
        function duplicate($for_test = true, $title = "", $author = "", $owner = "", $testObjId = null)
        {
                if ($this->id <= 0)
                {
                        // The question has not been saved. It cannot be duplicated
                        return;
                }
                // duplicate the question in database
                $this_id = $this->getId();
                $thisObjId = $this->getObjId();
                
                $clone = $this;
                include_once ("./Modules/TestQuestionPool/classes/class.assQuestion.php");
                $original_id = assQuestion::_getOriginalId($this->id);
                $clone->id = -1;
                
                if( (int)$testObjId > 0 )
                {
                        $clone->setObjId($testObjId);
                }
                
                if ($title)
                {
                        $clone->setTitle($title);
                }
                if ($author)
                {
                        $clone->setAuthor($author);
                }
                if ($owner)
                {
                        $clone->setOwner($owner);
                }
                if ($for_test)
                {
                        $clone->saveToDb($original_id);
                }
                else
                {
                        $clone->saveToDb();
                }

                // copy question page content
                $clone->copyPageOfQuestion($this_id);
                // copy XHTML media objects
                $clone->copyXHTMLMediaObjectsOfQuestion($this_id);
                // duplicate the image
                $clone->duplicateImages($this_id, $thisObjId, $clone->getId(), $testObjId);
                
                $clone->onDuplicate($thisObjId, $this_id, $clone->getObjId(), $clone->getId());
                
                return $clone->id;
        }

        function copyObject($target_questionpool_id, $title = "")
        {
                if ($this->id <= 0)
                {
                        // The question has not been saved. It cannot be duplicated
                        return;
                }
                // duplicate the question in database
                $clone = $this;
                include_once ("./Modules/TestQuestionPool/classes/class.assQuestion.php");
                $original_id = assQuestion::_getOriginalId($this->id);
                $clone->id = -1;
                $source_questionpool_id = $this->getObjId();
                $clone->setObjId($target_questionpool_id);
                if ($title)
                {
                        $clone->setTitle($title);
                }
                
                $clone->saveToDb();

                // copy question page content
                $clone->copyPageOfQuestion($original_id);
                // copy XHTML media objects
                $clone->copyXHTMLMediaObjectsOfQuestion($original_id);
                // duplicate the image
                $clone->copyImages($original_id, $source_questionpool_id);
                
                $clone->onCopy($source_questionpool_id, $original_id, $clone->getObjId(), $clone->getId());
                
                return $clone->id;
        }

        public function createNewOriginalFromThisDuplicate($targetParentId, $targetQuestionTitle = "")
        {
                if ($this->id <= 0)
                {
                        // The question has not been saved. It cannot be duplicated
                        return;
                }

                include_once ("./Modules/TestQuestionPool/classes/class.assQuestion.php");

                $sourceQuestionId = $this->id;
                $sourceParentId = $this->getObjId();

                // duplicate the question in database
                $clone = $this;
                $clone->id = -1;

                $clone->setObjId($targetParentId);

                if ($targetQuestionTitle)
                {
                        $clone->setTitle($targetQuestionTitle);
                }

                $clone->saveToDb();
                // copy question page content
                $clone->copyPageOfQuestion($sourceQuestionId);
                // copy XHTML media objects
                $clone->copyXHTMLMediaObjectsOfQuestion($sourceQuestionId);
                // duplicate the image
                $clone->copyImages($sourceQuestionId, $sourceParentId);

                $clone->onCopy($sourceParentId, $sourceQuestionId, $clone->getObjId(), $clone->getId());

                return $clone->id;
        }

        function duplicateImages($src_question_id, $src_object_id, $dest_question_id, $dest_object_id)
        {
                global $ilLog;
                if ($this->getOrderingType() == OQ_PICTURES || $this->getOrderingType() == OQ_NESTED_PICTURES)
                {
                        $imagepath_original = $this->getImagePath($src_question_id, $src_object_id);
                        $imagepath = $this->getImagePath($dest_question_id, $dest_object_id);

                        if (!file_exists($imagepath)) {
                                ilUtil::makeDirParents($imagepath);
                        }
                        foreach ($this->answers as $answer)
                        {
                                $filename = $answer->getAnswertext();
                                if (!@copy($imagepath_original . $filename, $imagepath . $filename)) 
                                {
                                        $ilLog->write("image could not be duplicated!!!!");
                                }
                                if (@file_exists($imagepath_original. $this->getThumbPrefix(). $filename))
                                {
                                        if (!@copy($imagepath_original . $this->getThumbPrefix() . $filename, $imagepath . $this->getThumbPrefix() . $filename)) 
                                        {
                                                $ilLog->write("image thumbnail could not be duplicated!!!!");
                                        }
                                }
                        }
                }
        }

        function copyImages($question_id, $source_questionpool)
        {
                global $ilLog;
                if ($this->getOrderingType() == OQ_PICTURES)
                {
                        $imagepath = $this->getImagePath();
                        $imagepath_original = str_replace("/$this->id/images", "/$question_id/images", $imagepath);
                        $imagepath_original = str_replace("/$this->obj_id/", "/$source_questionpool/", $imagepath_original);
                        if (!file_exists($imagepath)) {
                                ilUtil::makeDirParents($imagepath);
                        }
                        foreach ($this->answers as $answer)
                        {
                                $filename = $answer->getAnswertext();
                                if (!@copy($imagepath_original . $filename, $imagepath . $filename)) 
                                {
                                        $ilLog->write("Ordering Question image could not be copied: $imagepath_original$filename");
                                }
                                if (@file_exists($imagepath_original. $this->getThumbPrefix(). $filename))
                                {
                                        if (!@copy($imagepath_original . $this->getThumbPrefix() . $filename, $imagepath . $this->getThumbPrefix() . $filename)) 
                                        {
                                                $ilLog->write("Ordering Question image thumbnail could not be copied: $imagepath_original" . $this->getThumbPrefix() . $filename);
                                        }
                                }
                        }
                }
        }

        function setOrderingType($ordering_type = OQ_TERMS)
        {
                $this->ordering_type = $ordering_type;
        }
        
        function getOrderingType()
        {
                return $this->ordering_type;
        }

        function addAnswer($answertext = "", $solution_order = -1 ,$depth = 0)
        {
                include_once "./Modules/TestQuestionPool/classes/class.assAnswerOrdering.php";
                $answer = new ASS_AnswerOrdering($answertext, $this->getRandomID(), $depth);
                if (($solution_order >= 0) && ($solution_order < count($this->answers)))
                {
                        $part1 = array_slice($this->answers, 0, $solution_order);
                        $part2 = array_slice($this->answers, $solution_order);
                        $this->answers = array_merge($part1, array($answer), $part2);
                }
                else
                {
                        array_push($this->answers, $answer);
                }
        }
        
        public function moveAnswerUp($position)
        {
                if ($position > 0)
                {
                        $temp = $this->answers[$position-1];
                        $this->answers[$position-1] = $this->answers[$position];
                        $this->answers[$position] = $temp;
                }
        }
        
        public function moveAnswerDown($position)
        {
                if ($position < count($this->answers)-1)
                {
                        $temp = $this->answers[$position+1];
                        $this->answers[$position+1] = $this->answers[$position];
                        $this->answers[$position] = $temp;
                }
        }

        protected function getRandomID()
        {
                $random_number = mt_rand(1, 100000);
                $found = true;
                while ($found)
                {
                        $found = false;
                        foreach ($this->getAnswers() as $answer)
                        {
                                if ($answer->getRandomID() == $random_number)
                                {
                                        $found = true;
                                        $random_number++;
                                }
                        }
                }
                return $random_number;
        }

        function getAnswer($index = 0)
        {
                if ($index < 0) return NULL;
                if (count($this->answers) < 1) return NULL;
                if ($index >= count($this->answers)) return NULL;
                return $this->answers[$index];
        }

        function deleteAnswer($index = 0)
        {
                if ($index < 0)
                {
                        return;
                }
                if (count($this->answers) < 1)
                {
                        return;
                }
                if ($index >= count($this->answers))
                {
                        return;
                }
                unset($this->answers[$index]);
                $this->answers = array_values($this->answers);
                for ($i = 0; $i < count($this->answers); $i++)
                {
                        if ($this->answers[$i]->getOrder() > $index)
                        {
                                $this->answers[$i]->setOrder($i);
                        }
                }
        }

        function flushAnswers()
        {
                $this->answers = array();
        }

        function getAnswerCount()
        {
                return count($this->answers);
        }

        function getMaxSolutionOrder()
        {
                if (count($this->answers) == 0)
                {
                        $max = 0;
                }
                else
                {
                        $max = $this->answers[0]->getSolutionOrder();
                }
                foreach ($this->answers as $key => $value)
                {
                        if ($value->getSolutionOrder() > $max)
                        {
                                $max = $value->getSolutionOrder();
                        }
                }
                return $max;
        }

        public function calculateReachedPoints($active_id, $pass = NULL, $authorizedSolution = true, $returndetails = FALSE)
        {
                if( $returndetails )
                {
                        throw new ilTestException('return details not implemented for '.__METHOD__);
                }
                
                global $ilDB;
                
                $found_value1 = array();
                $found_value2 = array();
                if (is_null($pass))
                {
                        $pass = $this->getSolutionMaxPass($active_id);
                }
                $result = $this->getCurrentSolutionResultSet($active_id, $pass, $authorizedSolution);
                $user_order = array();
                $nested_solution = false;
                while ($data = $ilDB->fetchAssoc($result))
                {
                        if ((strcmp($data["value1"], "") != 0) && (strcmp($data["value2"], "") != 0))
                        {
                                if(strchr( $data['value2'],':') == true)
                                {
//                                      //i.e. "61463:0" = "random_id:depth" 
                                        $current_solution = explode(':', $data['value2']);

                                        $user_order[$current_solution[0]]['index'] =  $data["value1"];
                                        $user_order[$current_solution[0]]['depth'] = $current_solution[1];
                                        $user_order[$current_solution[0]]['random_id'] = $current_solution[0];

                                        $nested_solution = true;
                                }
                                else
                                {
                                        $user_order[$data["value2"]] = $data["value1"];
                                        $nested_solution = false;
                                }
                        }
                }

                $points = $this->calculateReachedPointsForSolution($user_order, $nested_solution);

                return $points;
        }
        
        public function calculateReachedPointsFromPreviewSession(ilAssQuestionPreviewSession $previewSession)
        {
                $user_order = array();
                $nested_solution = false;
                foreach($previewSession->getParticipantsSolution() as $val1 => $val2)
                {
                        if ((strcmp($val1, "") != 0) && (strcmp($val2, "") != 0))
                        {
                                if(strchr( $val2,':') == true)
                                {
                                        $current_solution = explode(':', $val2);

                                        $user_order[$current_solution[0]]['index'] =  $val1;
                                        $user_order[$current_solution[0]]['depth'] = $current_solution[1];
                                        $user_order[$current_solution[0]]['random_id'] = $current_solution[0];

                                        $nested_solution = true;
                                }
                                else
                                {
                                        $user_order[$val2] = $val1;
                                        $nested_solution = false;
                                }
                        }
                }
                
                return $this->calculateReachedPointsForSolution($user_order, $nested_solution);
        }

        public function getMaximumPoints()
        {
                return $this->getPoints();
        }

        /*
        * Returns the encrypted save filename of a matching picture
        * Images are saved with an encrypted filename to prevent users from
        * cheating by guessing the solution from the image filename
        * 
        * @param string $filename Original filename
        * @return string Encrypted filename
        */
        public function getEncryptedFilename($filename)
        {
                $extension = "";
                if (preg_match("/.*\\.(\\w+)$/", $filename, $matches))
                {
                        $extension = $matches[1];
                }
                return md5($filename) . "." . $extension;
        }
        
        protected function cleanImagefiles()
        {
                if ($this->getOrderingType() == OQ_PICTURES)
                {
                        if (@file_exists($this->getImagePath()))
                        {
                                $contents = ilUtil::getDir($this->getImagePath());
                                foreach ($contents as $f)
                                {
                                        if (strcmp($f['type'], 'file') == 0)
                                        {
                                                $found = false;
                                                foreach ($this->getAnswers() as $answer)
                                                {
                                                        if (strcmp($f['entry'], $answer->getAnswertext()) == 0) $found = true;
                                                        if (strcmp($f['entry'], $this->getThumbPrefix() . $answer->getAnswertext()) == 0) $found = true;
                                                }
                                                if (!$found)
                                                {
                                                        if (@file_exists($this->getImagePath() . $f['entry'])) @unlink($this->getImagePath() . $f['entry']);
                                                }
                                        }
                                }
                        }
                }
                else
                {
                        if (@file_exists($this->getImagePath()))
                        {
                                ilUtil::delDir($this->getImagePath());
                        }
                }
        }

        /*
        * Deletes an imagefile from the system if the file is deleted manually
        * 
        * @param string $filename Image file filename
        * @return boolean Success
        */
        public function deleteImagefile($filename)
        {
                $deletename = $$filename;
                $result = @unlink($this->getImagePath().$deletename);
                $result = $result & @unlink($this->getImagePath().$this->getThumbPrefix() . $deletename);
                return $result;
        }

        function setImageFile($image_tempfilename, $image_filename, $previous_filename)
        {
                $result = TRUE;
                if (strlen($image_tempfilename))
                {
                        $image_filename = str_replace(" ", "_", $image_filename);
                        $imagepath = $this->getImagePath();
                        if (!file_exists($imagepath))
                        {
                                ilUtil::makeDirParents($imagepath);
                        }
                        $savename = $image_filename;
                        if (!ilUtil::moveUploadedFile($image_tempfilename, $savename, $imagepath.$savename))
                        {
                                $result = FALSE;
                        }
                        else
                        {
                                // create thumbnail file
                                $thumbpath = $imagepath . $this->getThumbPrefix() . $savename;
                                ilUtil::convertImage($imagepath.$savename, $thumbpath, "JPEG", $this->getThumbGeometry());
                        }
                        if ($result && (strcmp($image_filename, $previous_filename) != 0) && (strlen($previous_filename)))
                        {
                                $this->deleteImagefile($previous_filename);
                        }
                }
                return $result;
        }

        function checkSaveData()
        {
                $result = true;
                if ($this->getOutputType() == OUTPUT_JAVASCRIPT)
                {
                        if (strlen($_POST["orderresult"]))
                        {
                                return $result;
                        }
                        else if(strlen($_POST['answers_ordering']))
                        {
                                $answers_ordering = $_POST['answers_ordering'];
                                $new_hierarchy = json_decode($answers_ordering);
                                $with_random_id = true;
                                $this->setLeveledOrdering($new_hierarchy, $with_random_id);
                        
                                //return value as "random_id:depth"
                                return serialize($this->leveled_ordering);
                        }
                }
                $order_values = array();
                foreach ($_POST as $key => $value)
                {
                        if (preg_match("/^order_(\d+)/", $key, $matches))
                        {
                                if (strcmp($value, "") != 0)
                                {
                                        array_push($order_values, $value);
                                }
                        }
                }
                $check_order = array_flip($order_values);
                if (count($check_order) != count($order_values))
                {
                        // duplicate order values!!!
                        $result = false;
                        ilUtil::sendInfo($this->lng->txt("duplicate_order_values_entered"), TRUE);
                }
                return $result;
        }

        public function saveWorkingData($active_id, $pass = NULL, $authorized = true)
        {
                $saveWorkingDataResult = $this->checkSaveData();
                if ($saveWorkingDataResult)
                {
                        if (is_null($pass))
                        {
                                include_once "./Modules/Test/classes/class.ilObjTest.php";
                                $pass = ilObjTest::_getPass($active_id);
                        }

                        $this->getProcessLocker()->requestUserSolutionUpdateLock();

                        $affectedRows = $this->removeCurrentSolution($active_id, $pass, $authorized);

                        $entered_values = 0;
                        foreach($this->getSolutionSubmit() as $val1 => $val2)
                        {
                                $this->saveCurrentSolution($active_id, $pass, $val1, trim($val2), $authorized);
                                $entered_values++;
                        }

                        $this->getProcessLocker()->releaseUserSolutionUpdateLock();
                }
                if ($entered_values)
                {
                        include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
                        if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                        {
                                $this->logAction($this->lng->txtlng("assessment", "log_user_entered_values", ilObjAssessmentFolder::_getLogLanguage()), $active_id, $this->getId());
                        }
                }
                else
                {
                        include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
                        if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                        {
                                $this->logAction($this->lng->txtlng("assessment", "log_user_not_entered_values", ilObjAssessmentFolder::_getLogLanguage()), $active_id, $this->getId());
                        }
                }

                return $saveWorkingDataResult;
        }
        
        protected function savePreviewData(ilAssQuestionPreviewSession $previewSession)
        {
                if( $this->checkSaveData() )
                {
                        $previewSession->setParticipantsSolution($this->getSolutionSubmit());
                }
        }

        public function saveAdditionalQuestionDataToDb()
        {
                global $ilDB;

                // save additional data
                $ilDB->manipulateF( "DELETE FROM " . $this->getAdditionalTableName() . " WHERE question_fi = %s",
                                                        array( "integer" ),
                                                        array( $this->getId() )
                );

                $ilDB->manipulateF( "INSERT INTO " . $this->getAdditionalTableName() . " (question_fi, ordering_type, thumb_geometry, element_height) 
                                                        VALUES (%s, %s, %s, %s)",
                                                        array( "integer", "text", "integer", "integer" ),
                                                        array(
                                                                $this->getId(),
                                                                $this->ordering_type,
                                                                $this->getThumbGeometry(),
                                                                ($this->getElementHeight() > 20) ? $this->getElementHeight() : NULL
                                                        )
                );
        }

        public function saveAnswerSpecificDataToDb()
        {
                global $ilDB;

                $ilDB->manipulateF( "DELETE FROM qpl_a_ordering WHERE question_fi = %s",
                                                        array( 'integer' ),
                                                        array( $this->getId() )
                );

                foreach ($this->answers as $key => $value)
                {
                        $answer_obj = $this->answers[$key];
                        $next_id    = $ilDB->nextId( 'qpl_a_ordering' );
                        $ilDB->insert( 'qpl_a_ordering',
                                                   array(
                                                           'answer_id'      => array( 'integer', $next_id ),
                                                           'question_fi'    => array( 'integer', $this->getId() ),
//                                                         'answertext'     => array( 'text', ilRTE::_replaceMediaObjectImageSrc( $answer_obj->getAnswertext(), 0 ) ),
                                                           'answertext'     => array( 'text', $answer_obj->getAnswertext()),
                                                           'solution_order' => array( 'integer', $key ),
                                                           'random_id'      => array( 'integer', $answer_obj->getRandomID() ),
                                                           'tstamp'         => array( 'integer', time() ),
                                                           'depth'          => array( 'integer', $answer_obj->getOrderingDepth() )
                                                   )
                        );
                }

                if ($this->getOrderingType() == OQ_PICTURES)
                {
                        $this->rebuildThumbnails();
                        $this->cleanImagefiles();
                }
        }

        protected function reworkWorkingData($active_id, $pass, $obligationsAnswered)
        {
                // nothing to rework!
        }

        function getQuestionType()
        {
                return "assOrderingQuestion";
        }

        function getAdditionalTableName()
        {
                return "qpl_qst_ordering";
        }

        function getAnswerTableName()
        {
                return "qpl_a_ordering";
        }

        function getRTETextWithMediaObjects()
        {
                $text = parent::getRTETextWithMediaObjects();
                foreach ($this->answers as $index => $answer)
                {
                        $answer_obj = $this->answers[$index];
                        $text .= $answer_obj->getAnswertext();
                }
                return $text;
        }
        
        function &getAnswers()
        {
                return $this->answers;
        }

        public function supportsJavascriptOutput()
        {
                return TRUE;
        }
        
        public function supportsNonJsOutput()
        {
                return false;
        }

        public function setExportDetailsXLS(&$worksheet, $startrow, $active_id, $pass, &$format_title, &$format_bold)
        {
                include_once ("./Services/Excel/classes/class.ilExcelUtils.php");
                $solutions = $this->getSolutionValues($active_id, $pass);
                $sol = array();
                foreach ($solutions as $solution)
                {
                        $sol[$solution["value1"]] = $solution["value2"];
                }
                asort($sol);
                $sol = array_keys($sol);
                $worksheet->writeString($startrow, 0, ilExcelUtils::_convert_text($this->lng->txt($this->getQuestionType())), $format_title);
                $worksheet->writeString($startrow, 1, ilExcelUtils::_convert_text($this->getTitle()), $format_title);
                $i = 1;
                $answers = $this->getAnswers();
                foreach ($sol as $idx)
                {
                        foreach ($solutions as $solution)
                        {
                                if ($solution["value1"] == $idx) $worksheet->writeString($startrow + $i, 0, ilExcelUtils::_convert_text($solution["value2"]));
                        }
                        $worksheet->writeString($startrow + $i, 1, ilExcelUtils::_convert_text($answers[$idx]->getAnswertext()));
                        $i++;
                }
                return $startrow + $i + 1;
        }

        /*
        * Get the thumbnail geometry
        *
        * @return integer Geometry
        */
        public function getThumbGeometry()
        {
                return $this->thumb_geometry;
        }
        
        public function getThumbSize()
        {
                return $this->getThumbGeometry();
        }

        /*
        * Set the thumbnail geometry
        *
        * @param integer $a_geometry Geometry
        */
        public function setThumbGeometry($a_geometry)
        {
                $this->thumb_geometry = ($a_geometry < 1) ? 100 : $a_geometry;
        }

        /*
        * Get the minimum element height
        *
        * @return integer Height
        */
        public function getElementHeight()
        {
                return $this->element_height;
        }
        
        /*
        * Set the minimum element height
        *
        * @param integer $a_height Height
        */
        public function setElementHeight($a_height)
        {
                $this->element_height = ($a_height < 20) ? "" : $a_height;
        }

        /*
        * Rebuild the thumbnail images with a new thumbnail size
        */
        public function rebuildThumbnails()
        {
                if ($this->getOrderingType() == OQ_PICTURES || $this->getOrderingType() == OQ_NESTED_PICTURES)
                {
                        foreach ($this->getAnswers() as $answer)
                        {
                                $this->generateThumbForFile($this->getImagePath(), $answer->getAnswertext());
                        }
                }
        }
        
        public function getThumbPrefix()
        {
                return "thumb.";
        }
        
        protected function generateThumbForFile($path, $file)
        {
                $filename = $path . $file;
                if (@file_exists($filename))
                {
                        $thumbpath = $path . $this->getThumbPrefix() . $file;
                        $path_info = @pathinfo($filename);
                        $ext = "";
                        switch (strtoupper($path_info['extension']))
                        {
                                case 'PNG':
                                        $ext = 'PNG';
                                        break;
                                case 'GIF':
                                        $ext = 'GIF';
                                        break;
                                default:
                                        $ext = 'JPEG';
                                        break;
                        }
                        ilUtil::convertImage($filename, $thumbpath, $ext, $this->getThumbGeometry());
                }
        }
        
        public function toJSON()
        {
                include_once("./Services/RTE/classes/class.ilRTE.php");
                $result = array();
                $result['id'] = (int) $this->getId();
                $result['type'] = (string) $this->getQuestionType();
                $result['title'] = (string) $this->getTitle();
                $result['question'] =  $this->formatSAQuestion($this->getQuestion());
                $result['nr_of_tries'] = (int) $this->getNrOfTries();
                $result['shuffle'] = (bool) true;
                $result['points'] =  $this->getPoints();
                $result['feedback'] = array(
                        'onenotcorrect' => $this->formatSAQuestion($this->feedbackOBJ->getGenericFeedbackTestPresentation($this->getId(), false)),
                        'allcorrect' => $this->formatSAQuestion($this->feedbackOBJ->getGenericFeedbackTestPresentation($this->getId(), true))
                );
                if ($this->getOrderingType() == OQ_PICTURES)
                {
                        $result['path'] = $this->getImagePathWeb();
                }
                
                $counter = 1;
                $answers = array();
                foreach ($this->getAnswers() as $answer_obj)
                {
                        $answers[$counter] = $answer_obj->getAnswertext();
                        $counter++;
                }
                $answers = $this->getShuffler()->shuffle($answers);
                $arr = array();
                foreach ($answers as $order => $answer)
                {
                        array_push($arr, array(
                                "answertext" => (string) $answer,
                                "order" => (int) $order
                        ));
                }
                $result['answers'] = $arr;

                $mobs = ilObjMediaObject::_getMobsOfObject("qpl:html", $this->getId());
                $result['mobs'] = $mobs;

                return json_encode($result);
        }

        public function removeAnswerImage($index)
        {
                $answer = $this->answers[$index];
                if (is_object($answer))
                {
                        $this->deleteImagefile($answer->getAnswertext());
                        $answer->setAnswertext('');
                }
        }
        protected function getSolutionSubmit()
        {
                $solutionSubmit = array();
                
                if(array_key_exists("orderresult", $_POST))
                {
                        $orderresult = $_POST["orderresult"];
                        if(strlen($orderresult))
                        {
                                $orderarray = explode(":", $orderresult);
                                $ordervalue = 1;
                                foreach($orderarray as $index)
                                {
                                        $idmatch = null;
                                        if(preg_match("/id_(\\d+)/", $index, $idmatch))
                                        {
                                                $randomid = $idmatch[1];
                                                foreach($this->getAnswers() as $answeridx => $answer)
                                                {
                                                        if($answer->getRandomID() == $randomid)
                                                        {
                                                                $solutionSubmit[$answeridx] = $ordervalue;
                                                                $ordervalue++;
                                                        }
                                                }
                                        }
                                }
                        }
                }
                else if($this->getOrderingType() == OQ_NESTED_TERMS || $this->getOrderingType() == OQ_NESTED_PICTURES)
                {
                        $answers_ordering = $_POST['answers_ordering__participant'];
                        $user_solution_hierarchy = json_decode($answers_ordering);
                        $with_random_id = true;
                        $this->setLeveledOrdering($user_solution_hierarchy, $with_random_id);
        
                        $index = 0;
                        foreach($this->leveled_ordering as $random_id => $depth)
                        {
                                $value_2 = implode(':', array($random_id, $depth));
                                $solutionSubmit[$index] = $value_2;
                                $index++;
                        }
                }
                else
                {
                        foreach($_POST as $key => $value)
                        {
                                $matches = null;
                                if(preg_match("/^order_(\d+)/", $key, $matches))
                                {
                                        if(!(preg_match("/initial_value_\d+/", $value)))
                                        {
                                                if(strlen($value))
                                                {
                                                        foreach($this->getAnswers() as $answeridx => $answer)
                                                        {
                                                                if($answer->getRandomID() == $matches[1])
                                                                {
                                                                        $solutionSubmit[$answeridx] = $value;
                                                                }
                                                        }
                                                }
                                        }
                                }
                        }
                }
                
                return $solutionSubmit;
        }

        protected function calculateReachedPointsForSolution($user_order, $nested_solution)
        {
                if($this->getOrderingType() != OQ_NESTED_PICTURES && $this->getOrderingType() != OQ_NESTED_TERMS)
                {
                        ksort($user_order);
                        $user_order = array_values($user_order);
                }

                $points = 0;
                $correctcount = 0;

                foreach($this->answers as $index => $answer)
                {
                        if($nested_solution == true)
                        {
                                $random_id = $answer->getRandomID();

                                if($random_id == $user_order[$random_id]['random_id'] && $answer->getOrderingDepth() == $user_order[$random_id]['depth'] && $index == $user_order[$random_id]['index'])
                                {
                                        $correctcount++;
                                }
                        } else
                        {
                                if($index == $user_order[$index])
                                {
                                        $correctcount++;
                                }
                        }
                }

                if($correctcount == count($this->answers))
                {
                        $points = $this->getPoints();
                        return $points;
                }
                return $points;
        }

        /***
         * @param object        $child
         * @param integer       $ordering_depth
         * @param bool          $with_random_id
         */
        private function getDepthRecursive($child, $ordering_depth, $with_random_id = false)
        {
                if($with_random_id == true)
                {
                        // for test ouput
                        if(is_array($child->children))
                        {
                                foreach($child->children as $grand_child)
                                {
                                        $ordering_depth++;
                                        $this->leveled_ordering[$child->id] = $ordering_depth;
                                        $this->getDepthRecursive($grand_child, $ordering_depth, true);
                                }
                        }
                        else
                        {
                                $ordering_depth++;
                                $this->leveled_ordering[$child->id] = $ordering_depth;
                        }
                }
                else
                {
                        if(is_array($child->children))
                        {
                                foreach($child->children as $grand_child)
                                {
                                        $ordering_depth++;
                                        $this->leveled_ordering[] = $ordering_depth;
                                        $this->getDepthRecursive($grand_child, $ordering_depth);
                                }
                        }
                        else
                        {
                                $ordering_depth++;
                                $this->leveled_ordering[] = $ordering_depth;
                        }               
                }
        }
        
        /***
         * @param array $new_hierarchy
         * @param bool  $with_random_id
         */
        public function setLeveledOrdering($new_hierarchy, $with_random_id = false)
        {
                if($with_random_id == true)
                {
                        //for test output
                        if(is_array($new_hierarchy))
                        {
                                foreach($new_hierarchy as $id)
                                {
                                        $ordering_depth                  = 0;
                                        $this->leveled_ordering[$id->id] = $ordering_depth;

                                        if(is_array($id->children))
                                        {
                                                foreach($id->children as $child)
                                                {
                                                        $this->getDepthRecursive($child, $ordering_depth, true);
                                                }
                                        }
                                }
                        }
                }       
                else
                {
                        if(is_array($new_hierarchy))
                        {
                                foreach($new_hierarchy as $id)
                                {
                                        $ordering_depth           = 0;
                                        $this->leveled_ordering[] = $ordering_depth;

                                        if(is_array($id->children))
                                        {
                                                foreach($id->children as $child)
                                                {
                                                        $this->getDepthRecursive($child, $ordering_depth, $with_random_id);
                                                }
                                        }
                                }
                        }
                }
        }
        public function getLeveledOrdering()
        {
                return $this->leveled_ordering;
        }

        public function getOldLeveledOrdering()
        {
                global $ilDB;

                $res = $ilDB->queryF('SELECT depth FROM qpl_a_ordering WHERE question_fi = %s ORDER BY solution_order ASC',
                        array('integer'), array($this->getId()));
                while($row = $ilDB->fetchAssoc($res))
                {
                        $this->old_ordering_depth[] = $row['depth'];
                }
                return $this->old_ordering_depth;
        }
        
        /***
         * @param integer $a_random_id
         * @return integer
         */
        public function lookupSolutionOrderByRandomid($a_random_id)
        {
                global $ilDB;
                
                $res = $ilDB->queryF('SELECT solution_order FROM qpl_a_ordering WHERE random_id = %s',
                array('integer'), array($a_random_id));
                $row = $ilDB->fetchAssoc($res);
                
                return $row['solution_order'];
        }
        
        /***
         * @param integer $a_random_id
         * @param integer $a_question_id
         * @return string
         */
        public function lookupAnswerTextByRandomId($a_random_id, $a_question_id)
        {
                global $ilDB;

                $res = $ilDB->queryF('SELECT answertext FROM qpl_a_ordering WHERE random_id = %s AND question_fi = %s',
                        array('integer', 'integer'), array($a_random_id, $a_question_id));
                $row = $ilDB->fetchAssoc($res);

                return $row['answertext'];
        }

        public function updateLeveledOrdering($a_index, $a_answer_text, $a_depth)
        {
                global $ilDB;
                
                $ilDB->update('qpl_a_ordering',
                array('solution_order'=> array('integer', $a_index),
                          'depth'               => array('integer', $a_depth)),
                array('answertext'      => array('text', $a_answer_text)));
                
                return true;
        }

        public function getOperators($expression)
        {
                require_once "./Modules/TestQuestionPool/classes/class.ilOperatorsExpressionMapping.php";
                return ilOperatorsExpressionMapping::getOperatorsByExpression($expression);
        }

        public function getExpressionTypes()
        {
                return array(
                        iQuestionCondition::PercentageResultExpression,
                        iQuestionCondition::NumericResultExpression,
                        iQuestionCondition::OrderingResultExpression,
                        iQuestionCondition::EmptyAnswerExpression,
                );
        }

        public function getUserQuestionResult($active_id, $pass)
        {
                global $ilDB;
                $result = new ilUserQuestionResult($this, $active_id, $pass);

                $maxStep = $this->lookupMaxStep($active_id, $pass);

                if( $maxStep !== null )
                {
                        $data = $ilDB->queryF(
                                "SELECT value1, value2 FROM tst_solutions WHERE active_fi = %s AND pass = %s AND question_fi = %s AND step = %s ORDER BY value1 ASC ",
                                array("integer", "integer", "integer","integer"),
                                array($active_id, $pass, $this->getId(), $maxStep)
                        );
                }
                else
                {
                        $data = $ilDB->queryF(
                                "SELECT value1, value2 FROM tst_solutions WHERE active_fi = %s AND pass = %s AND question_fi = %s ORDER BY value1 ASC ",
                                array("integer", "integer", "integer"),
                                array($active_id, $pass, $this->getId())
                        );
                }

                $elements = array();
                while($row = $ilDB->fetchAssoc($data))
                {

                        $newKey = explode(":", $row["value2"]);

                        foreach($this->getAnswers() as $key => $answer)
                        {
                                // Images nut supported
                                if($this->getOrderingType() == OQ_TERMS)
                                {
                                        if($key == $row["value1"])
                                        {
                                                $elements[$key] = $row["value2"];
                                                break;
                                        }
                                }
                                else
                                {
                                        if($answer->getRandomId() == $newKey[0])
                                        {
                                                $elements[$key] = $row["value1"];
                                                break;
                                        }
                                }
                        }
                }

                ksort($elements);

                foreach(array_values($elements) as $element)
                {
                        $result->addKeyValue($element, $element);
                }

                $points = $this->calculateReachedPoints($active_id, $pass);
                $max_points = $this->getMaximumPoints();

                $result->setReachedPercentage(($points/$max_points) * 100);

                return $result;
        }

        public function getAvailableAnswerOptions($index = null)
        {
                if($index !== null)
                {
                        return $this->getAnswer($index);
                }
                else
                {
                        return $this->getAnswers();
                }
        }

        protected function afterSyncWithOriginal($origQuestionId, $dupQuestionId, $origParentObjId, $dupParentObjId)
        {
                parent::afterSyncWithOriginal($origQuestionId, $dupQuestionId, $origParentObjId, $dupParentObjId);
                $this->duplicateImages($dupQuestionId, $dupParentObjId, $origQuestionId, $origParentObjId);
        }
}