class.ilObjSurvey.php

Go to the documentation of this file.

<?php
/*
        +-----------------------------------------------------------------------------+
        | ILIAS open source                                                           |
        +-----------------------------------------------------------------------------+
        | Copyright (c) 1998-2006 ILIAS open source, University of Cologne            |
        |                                                                             |
        | This program is free software; you can redistribute it and/or               |
        | modify it under the terms of the GNU General Public License                 |
        | as published by the Free Software Foundation; either version 2              |
        | of the License, or (at your option) any later version.                      |
        |                                                                             |
        | This program is distributed in the hope that it will be useful,             |
        | but WITHOUT ANY WARRANTY; without even the implied warranty of              |
        | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the               |
        | GNU General Public License for more details.                                |
        |                                                                             |
        | You should have received a copy of the GNU General Public License           |
        | along with this program; if not, write to the Free Software                 |
        | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA. |
        +-----------------------------------------------------------------------------+
*/

include_once "./classes/class.ilObject.php";
include_once "./Modules/Survey/classes/inc.SurveyConstants.php";

class ilObjSurvey extends ilObject
{
  var $survey_id;

  var $author;

  var $introduction;

  var $outro;

  var $status;

  var $evaluation_access;

  var $start_date;

        var $startdate_enabled;

  var $end_date;

        var $enddate_enabled;

        var $questions;

        var $invitation;

        var $invitation_mode;
        
        var $anonymize;

        var $display_question_titles;

        var $surveyCodeSecurity;
        
        var $mailnotification;
        var $mailaddresses;
        var $mailparticipantdata;
        var $template_id;
        var $pool_usage;

        function ilObjSurvey($a_id = 0,$a_call_by_reference = true)
        {
                global $ilUser;
                $this->type = "svy";
                $this->ilObject($a_id,$a_call_by_reference);

                $this->survey_id = -1;
                $this->introduction = "";
                $this->outro = $this->lng->txt("survey_finished");
                $this->author = $ilUser->fullname;
                $this->status = STATUS_OFFLINE;
                $this->evaluation_access = EVALUATION_ACCESS_OFF;
                $this->startdate_enabled = 0;
                $this->enddate_enabled = 0;
                $this->questions = array();
                $this->invitation = INVITATION_OFF;
                $this->invitation_mode = MODE_PREDEFINED_USERS;
                $this->anonymize = ANONYMIZE_OFF;
                $this->display_question_titles = QUESTIONTITLES_VISIBLE;
                $this->surveyCodeSecurity = TRUE;
                $this->template_id = NULL;
                $this->pool_usage = true;
        }

        function create($a_upload = false)
        {
                parent::create();
                if(!$a_upload)
                {
                        $this->createMetaData();
                }
        }

        function createMetaData()
        {
                parent::createMetaData();
                $this->saveAuthorToMetadata();
        }

        function update()
        {
                $this->updateMetaData();

                if (!parent::update())
                {
                        return false;
                }

                // put here object specific stuff

                return true;
        }

        function createReference() 
        {
                $result = parent::createReference();
                $this->saveToDb();
                return $result;
        }

        function read($a_force_db = false)
        {
                parent::read($a_force_db);
                $this->loadFromDb();
        }
        
        function addQuestion($question_id)
        {
                array_push($this->questions, $question_id);
        }


        function delete()
        {
                $remove = parent::delete();
                // always call parent delete function first!!
                if (!$remove)
                {
                        return false;
                }

                $this->deleteMetaData();

                // Delete all survey questions, constraints and materials
                foreach ($this->questions as $question_id)
                {
                        $this->removeQuestion($question_id);
                }
                $this->deleteSurveyRecord();
                
                ilUtil::delDir($this->getImportDirectory());
                return true;
        }
        
        function deleteSurveyRecord()
        {
                global $ilDB;
                
                $affectedRows = $ilDB->manipulateF("DELETE FROM svy_svy WHERE survey_id = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );

                $result = $ilDB->queryF("SELECT questionblock_fi FROM svy_qblk_qst WHERE survey_fi = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );
                $questionblocks = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        array_push($questionblocks, $row["questionblock_fi"]);
                }
                if (count($questionblocks))
                {
                        $affectedRows = $ilDB->manipulate("DELETE FROM svy_qblk WHERE " . $ilDB->in('questionblock_id', $questionblocks, false, 'integer'));
                }
                $affectedRows = $ilDB->manipulateF("DELETE FROM svy_qblk_qst WHERE survey_fi = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );
                $this->deleteAllUserData();

                $affectedRows = $ilDB->manipulateF("DELETE FROM svy_anonymous WHERE survey_fi = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );
                
                // delete export files
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                $svy_data_dir = ilUtil::getDataDir()."/svy_data";
                $directory = $svy_data_dir."/svy_".$this->getId();
                if (is_dir($directory))
                {
                        include_once "./Services/Utilities/classes/class.ilUtil.php";
                        ilUtil::delDir($directory);
                }

                include_once("./Services/MediaObjects/classes/class.ilObjMediaObject.php");
                $mobs = ilObjMediaObject::_getMobsOfObject("svy:html", $this->getId());
                // remaining usages are not in text anymore -> delete them
                // and media objects (note: delete method of ilObjMediaObject
                // checks whether object is used in another context; if yes,
                // the object is not deleted!)
                foreach($mobs as $mob)
                {
                        ilObjMediaObject::_removeUsage($mob, "svy:html", $this->getId());
                        $mob_obj =& new ilObjMediaObject($mob);
                        $mob_obj->delete();
                }
        }
        
        function deleteAllUserData()
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT finished_id FROM svy_finished WHERE survey_fi = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );
                $active_array = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        array_push($active_array, $row["finished_id"]);
                }

                $affectedRows = $ilDB->manipulateF("DELETE FROM svy_finished WHERE survey_fi = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );

                foreach ($active_array as $active_fi)
                {
                        $affectedRows = $ilDB->manipulateF("DELETE FROM svy_answer WHERE active_fi = %s",
                                array('integer'),
                                array($active_fi)
                        );
                        $affectedRows = $ilDB->manipulateF("DELETE FROM svy_times WHERE finished_fi = %s",
                                array('integer'),
                                array($active_fi)
                        );
                }
        }
        
        function removeSelectedSurveyResults($finished_ids)
        {
                global $ilDB;
                
                foreach ($finished_ids as $finished_id)
                {
                        $result = $ilDB->queryF("SELECT finished_id FROM svy_finished WHERE finished_id = %s",
                                array('integer'),
                                array($finished_id)
                        );
                        $row = $ilDB->fetchAssoc($result);

                        $affectedRows = $ilDB->manipulateF("DELETE FROM svy_answer WHERE active_fi = %s",
                                array('integer'),
                                array($row["finished_id"])
                        );

                        $affectedRows = $ilDB->manipulateF("DELETE FROM svy_finished WHERE finished_id = %s",
                                array('integer'),
                                array($finished_id)
                        );

                        $affectedRows = $ilDB->manipulateF("DELETE FROM svy_times WHERE finished_fi = %s",
                                array('integer'),
                                array($row["finished_id"])
                        );
                }
        }
        
        function &getSurveyParticipants()
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT * FROM svy_finished WHERE survey_fi = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );
                $participants = array();
                if ($result->numRows() > 0)
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $userdata = $this->getUserDataFromActiveId($row["finished_id"]);
                                $participants[$userdata["sortname"] . $userdata["active_id"]] = $userdata;
                        }
                }
                return $participants;
        }

        function notify($a_event,$a_ref_id,$a_parent_non_rbac_id,$a_node_id,$a_params = 0)
        {
                global $tree;
                
                switch ($a_event)
                {
                        case "link":
                                
                                //var_dump("<pre>",$a_params,"</pre>");
                                //echo "Module name ".$this->getRefId()." triggered by link event. Objects linked into target object ref_id: ".$a_ref_id;
                                //exit;
                                break;
                        
                        case "cut":
                                
                                //echo "Module name ".$this->getRefId()." triggered by cut event. Objects are removed from target object ref_id: ".$a_ref_id;
                                //exit;
                                break;
                                
                        case "copy":
                        
                                //var_dump("<pre>",$a_params,"</pre>");
                                //echo "Module name ".$this->getRefId()." triggered by copy event. Objects are copied into target object ref_id: ".$a_ref_id;
                                //exit;
                                break;

                        case "paste":
                                
                                //echo "Module name ".$this->getRefId()." triggered by paste (cut) event. Objects are pasted into target object ref_id: ".$a_ref_id;
                                //exit;
                                break;
                        
                        case "new":
                                
                                //echo "Module name ".$this->getRefId()." triggered by paste (new) event. Objects are applied to target object ref_id: ".$a_ref_id;
                                //exit;
                                break;
                }
                
                // At the beginning of the recursive process it avoids second call of the notify function with the same parameter
                if ($a_node_id==$_GET["ref_id"])
                {       
                        $parent_obj =& $this->ilias->obj_factory->getInstanceByRefId($a_node_id);
                        $parent_type = $parent_obj->getType();
                        if($parent_type == $this->getType())
                        {
                                $a_node_id = (int) $tree->getParentId($a_node_id);
                        }
                }
                
                parent::notify($a_event,$a_ref_id,$a_parent_non_rbac_id,$a_node_id,$a_params);
        }

        function isComplete()
        {
                if (($this->getTitle()) and (count($this->questions)))
                {
                        return 1;
                } 
                        else 
                {
                        return 0;
                }
        }

        function _isComplete($obj_id)
        {
                $survey = new ilObjSurvey($obj_id, false);
                $survey->loadFromDb();
                if (($survey->getTitle()) and (count($survey->questions)))
                {
                        return 1;
                } 
                        else 
                {
                        return 0;
                }
        }

        function &_getGlobalSurveyData($obj_id)
        {
                $survey = new ilObjSurvey($obj_id, false);
                $survey->loadFromDb();
                $result = array();
                if (($survey->getTitle()) and ($survey->author) and (count($survey->questions)))
                {
                        $result["complete"] = true;
                } 
                        else 
                {
                        $result["complete"] = false;
                }
                $result["evaluation_access"] = $survey->getEvaluationAccess();
                return $result;
        }

        function saveCompletionStatus() 
        {
                global $ilDB;
                
                $complete = 0;
                if ($this->isComplete()) 
                {
                        $complete = 1;
                }
    if ($this->getSurveyId() > 0) 
                {
                        $affectedRows = $ilDB->manipulateF("UPDATE svy_svy SET complete = %s, tstamp = %s WHERE survey_id = %s",
                                array('text','integer','integer'),
                                array($this->isComplete(), time(), $this->getSurveyId())
                        );
                }
        }

        function duplicateQuestionForSurvey($question_id, $a_force = false)
        {
                global $ilUser;
                
                $questiontype = $this->getQuestionType($question_id);
                $question_gui = $this->getQuestionGUI($questiontype, $question_id);

                // check if question is a pool question at all, if not do nothing
                if($this->getId() == $question_gui->object->getObjId() &&  !$a_force)
                {
                        return $question_id;
                }

                $duplicate_id = $question_gui->object->duplicate(true);
                return $duplicate_id;
        }

        function insertQuestion($question_id) 
        {
                global $ilDB;
                
                include_once "./Modules/SurveyQuestionPool/classes/class.SurveyQuestion.php";
                if (!SurveyQuestion::_isComplete($question_id))
                {
                        return FALSE;
                }
                else
                {
                        // get maximum sequence index in test
                        $result = $ilDB->queryF("SELECT survey_question_id FROM svy_svy_qst WHERE survey_fi = %s",
                                array('integer'),
                                array($this->getSurveyId())
                        );
                        $sequence = $result->numRows();
                        $duplicate_id = $this->duplicateQuestionForSurvey($question_id);
                        $next_id = $ilDB->nextId('svy_svy_qst');
                        $affectedRows = $ilDB->manipulateF("INSERT INTO svy_svy_qst (survey_question_id, survey_fi, question_fi, sequence, tstamp) VALUES (%s, %s, %s, %s, %s)",
                                array('integer', 'integer', 'integer', 'integer', 'integer'),
                                array($next_id, $this->getSurveyId(), $duplicate_id, $sequence, time())
                        );
                        $this->loadQuestionsFromDb();
                        return TRUE;
                }
        }


        function insertQuestionblock($questionblock_id) 
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT svy_qblk.title, svy_qblk.show_questiontext, svy_qblk.show_blocktitle,".
                        " svy_qblk_qst.question_fi FROM svy_qblk, svy_qblk_qst, svy_svy_qst".
                        " WHERE svy_qblk.questionblock_id = svy_qblk_qst.questionblock_fi".
                        " AND svy_svy_qst.question_fi = svy_qblk_qst.question_fi".
                        " AND svy_qblk.questionblock_id = %s".
                        " ORDER BY svy_svy_qst.sequence",
                        array('integer'),
                        array($questionblock_id)
                );
                $questions = array();
                $show_questiontext = 0;
                $show_blocktitle = 0;
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $duplicate_id = $this->duplicateQuestionForSurvey($row["question_fi"]);
                        array_push($questions, $duplicate_id);
                        $title = $row["title"];
                        $show_questiontext = $row["show_questiontext"];
                        $show_blocktitle = $row["show_blocktitle"];
                }
                $this->createQuestionblock($title, $show_questiontext, $show_blocktitle, $questions);
        }
        
        function getAllRTEContent()
        {
                $result = array();
                array_push($result, $this->getIntroduction());
                array_push($result, $this->getOutro());
                return $result;
        }
        
        function cleanupMediaobjectUsage()
        {
                include_once("./Services/RTE/classes/class.ilRTE.php");
                $completecontent = "";
                foreach ($this->getAllRTEContent() as $content)
                {
                        $completecontent .= $content;
                }
                ilRTE::_cleanupMediaObjectUsage($completecontent, $this->getType() . ":html",
                        $this->getId());
        }
        
        public function saveUserSettings($usr_id, $key, $title, $value)
        {
                global $ilDB;
                
                $next_id = $ilDB->nextId('svy_settings');
                $affectedRows = $ilDB->insert("svy_settings", array(
                        "settings_id" => array("integer", $next_id),
                        "usr_id" => array("integer", $usr_id),
                        "keyword" => array("text", $key),
                        "title" => array("text", $title),
                        "value" => array("clob", $value)
                ));
        }
        
        public function deleteUserSettings($id)
        {
                global $ilDB;
                
                $affectedRows = $ilDB->manipulateF("DELETE FROM svy_settings WHERE settings_id = %s",
                        array('integer'),
                        array($id)
                );
                return $affectedRows;
        }
        
        public function getUserSettings($usr_id, $key)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT * FROM svy_settings WHERE usr_id = %s AND keyword = %s",
                        array('integer', 'text'),
                        array($usr_id, $key)
                );
                $found = array();
                if ($result->numRows())
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $found[$row['settings_id']] = $row;
                        }
                }
                return $found;
        }

        function saveToDb()
        {
                global $ilDB;
                
                include_once("./Services/RTE/classes/class.ilRTE.php");
                if ($this->getSurveyId() < 1)
                {
                        $next_id = $ilDB->nextId('svy_svy');
                        $affectedRows = $ilDB->insert("svy_svy", array(
                                "survey_id" => array("integer", $next_id),
                                "obj_fi" => array("integer", $this->getId()),
                                "author" => array("text", $this->getAuthor()),
                                "introduction" => array("clob", ilRTE::_replaceMediaObjectImageSrc($this->getIntroduction(), 0)),
                                "outro" => array("clob", ilRTE::_replaceMediaObjectImageSrc($this->getOutro(), 0)),
                                "status" => array("text", $this->getStatus()),
                                "startdate" => array("text", $this->getStartDate()),
                                "enddate" => array("text", $this->getEndDate()),
                                "evaluation_access" => array("text", $this->getEvaluationAccess()),
                                "invitation" => array("text", $this->getInvitation()),
                                "invitation_mode" => array("text", $this->getInvitationMode()),
                                "complete" => array("text", $this->isComplete()),
                                "created" => array("integer", time()),
                                "anonymize" => array("text", $this->getAnonymize()),
                                "show_question_titles" => array("text", $this->getShowQuestionTitles()),
                                "mailnotification" => array('integer', ($this->getMailNotification()) ? 1 : 0),
                                "mailaddresses" => array('text', strlen($this->getMailAddresses()) ? $this->getMailAddresses() : NULL),
                                "mailparticipantdata" => array('text', strlen($this->getMailParticipantData()) ? $this->getMailParticipantData() : NULL),
                                "tstamp" => array("integer", time()),
                                "template_id" => array("integer", $this->getTemplate()),
                                "pool_usage" => array("integer", $this->getPoolUsage())
                        ));
                        $this->setSurveyId($next_id);
                }
                else
                {
                        $affectedRows = $ilDB->update("svy_svy", array(
                                "author" => array("text", $this->getAuthor()),
                                "introduction" => array("clob", ilRTE::_replaceMediaObjectImageSrc($this->getIntroduction(), 0)),
                                "outro" => array("clob", ilRTE::_replaceMediaObjectImageSrc($this->getOutro(), 0)),
                                "status" => array("text", $this->getStatus()),
                                "startdate" => array("text", $this->getStartDate()),
                                "enddate" => array("text", $this->getEndDate()),
                                "evaluation_access" => array("text", $this->getEvaluationAccess()),
                                "invitation" => array("text", $this->getInvitation()),
                                "invitation_mode" => array("text", $this->getInvitationMode()),
                                "complete" => array("text", $this->isComplete()),
                                "anonymize" => array("text", $this->getAnonymize()),
                                "show_question_titles" => array("text", $this->getShowQuestionTitles()),
                                "mailnotification" => array('integer', ($this->getMailNotification()) ? 1 : 0),
                                "mailaddresses" => array('text', strlen($this->getMailAddresses()) ? $this->getMailAddresses() : NULL),
                                "mailparticipantdata" => array('text', strlen($this->getMailParticipantData()) ? $this->getMailParticipantData() : NULL),
                                "tstamp" => array("integer", time()),
                                "template_id" => array("integer", $this->getTemplate()),
                                "pool_usage" => array("integer", $this->getPoolUsage())
                        ), array(
                        "survey_id" => array("integer", $this->getSurveyId())
                        ));
                }
                if ($affectedRows)
                {
                        // save questions to db
                        $this->saveQuestionsToDb();
                }
        }

        function saveQuestionsToDb() 
        {
                global $ilDB;
                // save old questions state
                $old_questions = array();
                $result = $ilDB->queryF("SELECT * FROM svy_svy_qst WHERE survey_fi = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );
                if ($result->numRows())
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $old_questions[$row["question_fi"]] = $row;
                        }
                }
                
                // delete existing question relations
                $affectedRows = $ilDB->manipulateF("DELETE FROM svy_svy_qst WHERE survey_fi = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );
                // create new question relations
                foreach ($this->questions as $key => $value) 
                {
                        $next_id = $ilDB->nextId('svy_svy_qst');
                        $affectedRows = $ilDB->manipulateF("INSERT INTO svy_svy_qst (survey_question_id, survey_fi, question_fi, heading, sequence, tstamp) VALUES (%s, %s, %s, %s, %s, %s)",
                                array('integer','integer','integer','text','integer','integer'),
                                array($next_id, $this->getSurveyId(), $value, (strlen($old_questions[$value]["heading"])) ? $old_questions[$value]["heading"] : NULL, $key, time())
                        );
                }
        }

        function getAnonymousId($id)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT anonymous_id FROM svy_finished WHERE anonymous_id = %s",
                        array('text'),
                        array($id)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["anonymous_id"];
                }
                else
                {
                        return "";
                }
        }

        function getQuestionGUI($questiontype, $question_id)
        {
                include_once "./Modules/SurveyQuestionPool/classes/class.SurveyQuestionGUI.php";
                return SurveyQuestionGUI::_getQuestionGUI($questiontype, $question_id);
        }
        
        function getQuestionType($question_id) 
        {
                global $ilDB;
                if ($question_id < 1) return -1;
                $result = $ilDB->queryF("SELECT type_tag FROM svy_question, svy_qtype WHERE svy_question.question_id = %s AND " .
                        "svy_question.questiontype_fi = svy_qtype.questiontype_id",
                        array('integer'),
                        array($question_id)
                );
                if ($result->numRows() == 1) 
                {
                        $data = $ilDB->fetchAssoc($result);
                        return $data["type_tag"];
                } 
                else 
                {
                        return "";
                }
        }

        function getSurveyId()
        {
                return $this->survey_id;
        }
        
        function setAnonymize($a_anonymize)
        {
                switch ($a_anonymize)
                {
                        case ANONYMIZE_OFF:
                        case ANONYMIZE_ON:
                        case ANONYMIZE_FREEACCESS:
                        case ANONYMIZE_CODE_ALL:
                                $this->anonymize = $a_anonymize;
                                break;
                        default:
                                $this->anonymize = ANONYMIZE_OFF;
                                break;
                }
        }

        function getAnonymize()
        {
                return ($this->anonymize) ? $this->anonymize : 0;
        }
        
        function isAccessibleWithCodeForAll()
        {
                if ($this->getAnonymize() == ANONYMIZE_CODE_ALL)
                {
                        return true;
                }
                else
                {
                        return false;
                }
        }
        
        function isAccessibleWithoutCode()
        {
                if ($this->getAnonymize() == ANONYMIZE_FREEACCESS)
                {
                        return true;
                }
                else
                {
                        return false;
                }
        }

        function loadFromDb()
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT * FROM svy_svy WHERE obj_fi = %s",
                        array('integer'),
                        array($this->getId())
                );
                if ($result->numRows() == 1) 
                {
                        $data = $ilDB->fetchAssoc($result);
                        $this->setSurveyId($data["survey_id"]);
                        $this->setAuthor($data["author"]);
                        include_once("./Services/RTE/classes/class.ilRTE.php");
                        $this->setIntroduction(ilRTE::_replaceMediaObjectImageSrc($data["introduction"], 1));
                        if (strcmp($data["outro"], "survey_finished") == 0)
                        {
                                $this->setOutro($this->lng->txt("survey_finished"));
                        }
                        else
                        {
                                $this->setOutro(ilRTE::_replaceMediaObjectImageSrc($data["outro"], 1));
                        }
                        $this->setInvitation($data["invitation"]);
                        $this->setInvitationMode($data["invitation_mode"]);
                        $this->setShowQuestionTitles($data["show_question_titles"]);
                        $this->setStartDate($data["startdate"]);
                        $this->setStartDateEnabled(strlen($data["startdate"]));
                        $this->setEndDate($data["enddate"]);
                        $this->setEndDateEnabled(strlen($data["enddate"]));
                        $this->setAnonymize($data["anonymize"]);
                        $this->setEvaluationAccess($data["evaluation_access"]);
                        $this->loadQuestionsFromDb();
                        $this->setStatus($data["status"]);
                        $this->setMailNotification($data['mailnotification']);
                        $this->setMailAddresses($data['mailaddresses']);
                        $this->setMailParticipantData($data['mailparticipantdata']);
                        $this->setTemplate($data['template_id']);
                        $this->setPoolUsage($data['pool_usage']);
                }
        }

        function loadQuestionsFromDb() 
        {
                global $ilDB;
                $this->questions = array();
                $result = $ilDB->queryF("SELECT * FROM svy_svy_qst WHERE survey_fi = %s ORDER BY sequence",
                        array('integer'),
                        array($this->getSurveyId())
                );
                while ($data = $ilDB->fetchAssoc($result)) 
                {
                        $this->questions[$data["sequence"]] = $data["question_fi"];
                }
        }

        function setStartDateEnabled($enabled = false)
        {
                $this->startdate_enabled = ($enabled) ? $enabled : 0;
        }
        
        function getStartDateEnabled()
        {
                return ($this->startdate_enabled) ? $this->startdate_enabled : 0;
        }

        function setEndDateEnabled($enabled = false)
        {
                $this->enddate_enabled = ($enabled) ? $enabled : 0;
        }
        
        function getEndDateEnabled()
        {
                return ($this->enddate_enabled) ? $this->enddate_enabled : 0;
        }

        function setAuthor($author = "") 
        {
                $this->author = $author;
        }

        function saveAuthorToMetadata($a_author = "")
        {
                $md =& new ilMD($this->getId(), 0, $this->getType());
                $md_life =& $md->getLifecycle();
                if (!$md_life)
                {
                        if (strlen($a_author) == 0)
                        {
                                global $ilUser;
                                $a_author = $ilUser->getFullname();
                        }
                        
                        $md_life =& $md->addLifecycle();
                        $md_life->save();
                        $con =& $md_life->addContribute();
                        $con->setRole("Author");
                        $con->save();
                        $ent =& $con->addEntity();
                        $ent->setEntity($a_author);
                        $ent->save();
                }
        }
        
  function getAuthor() 
        {
                $author = array();
                include_once "./Services/MetaData/classes/class.ilMD.php";
                $md =& new ilMD($this->getId(), 0, $this->getType());
                $md_life =& $md->getLifecycle();
                if ($md_life)
                {
                        $ids =& $md_life->getContributeIds();
                        foreach ($ids as $id)
                        {
                                $md_cont =& $md_life->getContribute($id);
                                if (strcmp($md_cont->getRole(), "Author") == 0)
                                {
                                        $entids =& $md_cont->getEntityIds();
                                        foreach ($entids as $entid)
                                        {
                                                $md_ent =& $md_cont->getEntity($entid);
                                                array_push($author, $md_ent->getEntity());
                                        }
                                }
                        }
                }
                return join($author, ",");
  }

        public function getShowQuestionTitles() 
        {
                return ($this->display_question_titles) ? 1 : 0;
        }

        public function setShowQuestionTitles($a_show) 
        {
                $this->display_question_titles = ($a_show) ? 1 : 0;
        }

        function showQuestionTitles() 
        {
                $this->display_question_titles = 1;
        }

        function hideQuestionTitles() 
        {
                $this->display_question_titles = 0;
        }
        
        function setInvitation($invitation = 0) 
        {
                global $ilDB;
                global $ilAccess;
    $this->invitation = $invitation;
                if ($invitation == INVITATION_OFF)
                {
                        $this->disinviteAllUsers();
                }
                else if ($invitation == INVITATION_ON)
                {
                        if ($this->getInvitationMode() == MODE_UNLIMITED)
                        {
                                $result = $ilDB->query("SELECT usr_id FROM usr_data");
                                while ($row = $ilDB->fetchAssoc($result))
                                {
                                        if ($ilAccess->checkAccessOfUser($row["usr_id"], "read", "", $this->getRefId(), "svy", $this->getId()))
                                        {
                                                $this->inviteUser($row['usr_id']);
                                        }
                                }
                        }
                }
  }

  function setInvitationMode($invitation_mode = 0) 
        {
                $this->invitation_mode = $invitation_mode;
  }
        
        function setInvitationAndMode($invitation = 0, $invitation_mode = 0)
        {
                $this->invitation_mode = $invitation_mode;
                $this->setInvitation($invitation);
        }

        public function setIntroduction($introduction = "") 
        {
                $this->introduction = $introduction;
        }

        public function setOutro($outro = "") 
        {
                $this->outro = $outro;
        }

        function getInvitation() 
        {
                return ($this->invitation) ? $this->invitation : INVITATION_OFF;
        }

        function getInvitationMode() 
        {
                include_once "./Services/Administration/classes/class.ilSetting.php";
                $surveySetting = new ilSetting("survey");
                $unlimited_invitation = $surveySetting->get("unlimited_invitation");
                if (!$unlimited_invitation && $this->invitation_mode == MODE_UNLIMITED)
                {
                        return MODE_PREDEFINED_USERS;
                }
                else
                {
                        return ($this->invitation_mode) ? $this->invitation_mode : MODE_UNLIMITED;
                }
        }

        function getStatus() 
        {
                return ($this->status) ? $this->status : STATUS_OFFLINE;
        }

        function isOnline() 
        {
                return ($this->status == STATUS_ONLINE) ? true : false;
        }

        function isOffline() 
        {
                return ($this->status == STATUS_OFFLINE) ? true : false;
        }

        function setStatus($status = STATUS_OFFLINE) 
        {
                $result = "";
                if (($status == STATUS_ONLINE) && (count($this->questions) == 0))
                {
                        $this->status = STATUS_OFFLINE;
                        $result = $this->lng->txt("cannot_switch_to_online_no_questions");
                }
                else
                {
                        $this->status = $status;
                }
                return $result;
        }

        function getStartDate() 
        {
                return (strlen($this->start_date)) ? $this->start_date : NULL;
        }

        function canStartSurvey($anonymous_id = NULL)
        {
                global $ilAccess;
                
                $result = TRUE;
                $messages = array();
                $edit_settings = false;
                // check start date
                if ($this->getStartDateEnabled())
                {
                        if (preg_match("/(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})/", $this->getStartDate(), $matches))
                        {
                                $epoch_time = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                                $now = mktime();
                                if ($now < $epoch_time) 
                                {
                                        array_push($messages,$this->lng->txt('start_date_not_reached').' ('.
                                                ilDatePresentation::formatDate(new ilDateTime($this->getStartDate(), IL_CAL_TIMESTAMP)). ")");
                                        $result = FALSE;
                                        $edit_settings = true;
                                }
                        }
                }
                // check end date
                if ($this->getEndDateEnabled())
                {
                        if (preg_match("/(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})/", $this->getEndDate(), $matches))
                        {
                                $epoch_time = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                                $now = mktime();
                                if ($now > $epoch_time) 
                                {
                                        array_push($messages,$this->lng->txt('end_date_reached').' ('.
                                                ilDatePresentation::formatDate(new ilDateTime($this->getEndDate(), IL_CAL_TIMESTAMP)). ")");
                                        $result = FALSE;
                                        $edit_settings = true;
                                }
                        }
                }
                // check online status
                if ($this->getStatus() == STATUS_OFFLINE)
                {
                        array_push($messages, $this->lng->txt("survey_is_offline"));
                        $result = FALSE;
                        $edit_settings = true;
                }
                // check rbac permissions
                if (!$ilAccess->checkAccess("read", "", $this->ref_id))
                {
                        array_push($messages, $this->lng->txt("cannot_participate_survey"));
                        $result = FALSE;
                }
                // 2. check previous access
                if (!$result["error"])
                {
                        global $ilUser;
                        $survey_started = $this->isSurveyStarted($ilUser->getId(), $anonymous_id);
                        if ($survey_started === 1)
                        {
                                array_push($messages, $this->lng->txt("already_completed_survey"));
                                $result = FALSE;
                        }
                }
                return array(
                        "result" => $result,
                        "messages" => $messages,
                        "edit_settings" => $edit_settings
                );
        }

        function setStartDate($start_date = "") 
        {
                $this->start_date = $start_date;
        }

        function setStartDateAndTime($start_date = "", $start_time) 
        {
                $y = ''; $m = ''; $d = ''; $h = ''; $i = ''; $s = '';
                if (preg_match("/(\d{4})-(\d{2})-(\d{2})/", $start_date, $matches))
                {
                        $y = $matches[1];
                        $m = $matches[2];
                        $d = $matches[3];
                }
                if (preg_match("/(\d{2}):(\d{2}):(\d{2})/", $start_time, $matches))
                {
                        $h = $matches[1];
                        $i = $matches[2];
                        $s = $matches[3];
                }
                $this->start_date = sprintf('%04d%02d%02d%02d%02d%02d', $y, $m, $d, $h, $i, $s);
        }

        function getStartMonth() 
        {
                $dt = new ilDateTime($this->getStartDate(), IL_CAL_TIMESTAMP);
                return $dt->get(IL_CAL_FKT_DATE, 'm');
        }

        function getStartDay() 
        {
                $dt = new ilDateTime($this->getStartDate(), IL_CAL_TIMESTAMP);
                return $dt->get(IL_CAL_FKT_DATE, 'd');
        }

        function getStartYear() 
        {
                $dt = new ilDateTime($this->getStartDate(), IL_CAL_TIMESTAMP);
                return $dt->get(IL_CAL_FKT_DATE, 'Y');
        }

        function getStartHour() 
        {
                $dt = new ilDateTime($this->getStartDate(), IL_CAL_TIMESTAMP);
                return $dt->get(IL_CAL_FKT_DATE, 'H');
        }

        function getStartMinute() 
        {
                $dt = new ilDateTime($this->getStartDate(), IL_CAL_TIMESTAMP);
                return $dt->get(IL_CAL_FKT_DATE, 'i');
        }

        function getEndDate() 
        {
                return (strlen($this->end_date)) ? $this->end_date : NULL;
        }

        function setEndDate($end_date = "") 
        {
                $this->end_date = $end_date;
        }

        function setEndDateAndTime($end_date = "", $end_time) 
        {
                $y = ''; $m = ''; $d = ''; $h = ''; $i = ''; $s = '';
                if (preg_match("/(\d{4})-(\d{2})-(\d{2})/", $end_date, $matches))
                {
                        $y = $matches[1];
                        $m = $matches[2];
                        $d = $matches[3];
                }
                if (preg_match("/(\d{2}):(\d{2}):(\d{2})/", $end_time, $matches))
                {
                        $h = $matches[1];
                        $i = $matches[2];
                        $s = $matches[3];
                }
                $this->end_date = sprintf('%04d%02d%02d%02d%02d%02d', $y, $m, $d, $h, $i, $s);
        }

        function getEndMonth() 
        {
                $dt = new ilDateTime($this->getEndDate(), IL_CAL_TIMESTAMP);
                return $dt->get(IL_CAL_FKT_DATE, 'm');
        }

        function getEndDay() 
        {
                $dt = new ilDateTime($this->getEndDate(), IL_CAL_TIMESTAMP);
                return $dt->get(IL_CAL_FKT_DATE, 'd');
        }

        function getEndYear() 
        {
                $dt = new ilDateTime($this->getEndDate(), IL_CAL_TIMESTAMP);
                return $dt->get(IL_CAL_FKT_DATE, 'Y');
        }

        function getEndHour() 
        {
                $dt = new ilDateTime($this->getEndDate(), IL_CAL_TIMESTAMP);
                return $dt->get(IL_CAL_FKT_DATE, 'H');
        }

        function getEndMinute() 
        {
                $dt = new ilDateTime($this->getEndDate(), IL_CAL_TIMESTAMP);
                return $dt->get(IL_CAL_FKT_DATE, 'i');
        }

        function getEvaluationAccess() 
        {
                return ($this->evaluation_access) ? $this->evaluation_access : EVALUATION_ACCESS_OFF;
        }

        function setEvaluationAccess($evaluation_access = EVALUATION_ACCESS_OFF) 
        {
                $this->evaluation_access = ($evaluation_access) ? $evaluation_access : EVALUATION_ACCESS_OFF;
        }

        function getIntroduction() 
        {
                return (strlen($this->introduction)) ? $this->introduction : NULL;
        }

        function getOutro() 
        {
                return (strlen($this->outro)) ? $this->outro : NULL;
        }

        function &getExistingQuestions() 
        {
                global $ilDB;
                $existing_questions = array();
                $result = $ilDB->queryF("SELECT svy_question.original_id FROM svy_question, svy_svy_qst WHERE " .
                        "svy_svy_qst.survey_fi = %s AND svy_svy_qst.question_fi = svy_question.question_id",
                        array('integer'),
                        array($this->getSurveyId())
                );
                while ($data = $ilDB->fetchAssoc($result)) 
                {
                        if($data["original_id"])
                        {
                                array_push($existing_questions, $data["original_id"]);
                        }
                }
                return $existing_questions;
        }

        function &getQuestionpoolTitles($could_be_offline = FALSE, $showPath = FALSE) 
        {
                include_once "./Modules/SurveyQuestionPool/classes/class.ilObjSurveyQuestionPool.php";
                return ilObjSurveyQuestionPool::_getAvailableQuestionpools($use_object_id = TRUE, $could_be_offline, $showPath);
        }
        
        function moveUpQuestion($question_id)
        {
                $move_questions = array($question_id);
                $pages =& $this->getSurveyPages();
                $pageindex = -1;
                foreach ($pages as $idx => $page)
                {
                        if ($page[0]["question_id"] == $question_id)
                        {
                                $pageindex = $idx;
                        }
                }
                if ($pageindex > 0)
                {
                        $this->moveQuestions($move_questions, $pages[$pageindex-1][0]["question_id"], 0);
                }
                else
                {
                        // move up a question in a questionblock
                        $questions = $this->getSurveyQuestions();
                        $questions = array_keys($questions);
                        $index = array_search($question_id, $questions);
                        if (($index !== FALSE) && ($index > 0))
                        {
                                $this->moveQuestions($move_questions, $questions[$index-1], 0);
                        }
                }
        }
        
        public function moveDownQuestion($question_id)
        {
                $move_questions = array($question_id);
                $pages =& $this->getSurveyPages();
                $pageindex = -1;
                foreach ($pages as $idx => $page)
                {
                        if (($page[0]["question_id"] == $question_id) && (strcmp($page[0]["questionblock_id"], "") == 0))
                        {
                                $pageindex = $idx;
                        }
                }
                if (($pageindex < count($pages)-1) && ($pageindex >= 0))
                {
                        $this->moveQuestions($move_questions, $pages[$pageindex+1][count($pages[$pageindex+1])-1]["question_id"], 1);
                }
                else
                {
                        // move down a question in a questionblock
                        $questions = $this->getSurveyQuestions();
                        $questions = array_keys($questions);
                        $index = array_search($question_id, $questions);
                        if (($index !== FALSE) && ($index < count($questions)-1))
                        {
                                $this->moveQuestions($move_questions, $questions[$index+1], 1);
                        }
                }
        }
        
        function moveUpQuestionblock($questionblock_id)
        {
                $pages =& $this->getSurveyPages();
                $move_questions = array();
                $pageindex = -1;
                foreach ($pages as $idx => $page)
                {
                        if ($page[0]["questionblock_id"] == $questionblock_id)
                        {
                                foreach ($page as $pageidx => $question)
                                {
                                        array_push($move_questions, $question["question_id"]);
                                }
                                $pageindex = $idx;
                        }
                }
                if ($pageindex > 0)
                {
                        $this->moveQuestions($move_questions, $pages[$pageindex-1][0]["question_id"], 0);
                }
        }
        
        function moveDownQuestionblock($questionblock_id)
        {
                $pages =& $this->getSurveyPages();
                $move_questions = array();
                $pageindex = -1;
                foreach ($pages as $idx => $page)
                {
                        if ($page[0]["questionblock_id"] == $questionblock_id)
                        {
                                foreach ($page as $pageidx => $question)
                                {
                                        array_push($move_questions, $question["question_id"]);
                                }
                                $pageindex = $idx;
                        }
                }
                if ($pageindex < count($pages)-1)
                {
                        $this->moveQuestions($move_questions, $pages[$pageindex+1][count($pages[$pageindex+1])-1]["question_id"], 1);
                }
        }
        
        function moveQuestions($move_questions, $target_index, $insert_mode)
        {
                $array_pos = array_search($target_index, $this->questions);
                if ($insert_mode == 0)
                {
                        $part1 = array_slice($this->questions, 0, $array_pos);
                        $part2 = array_slice($this->questions, $array_pos);
                }
                else if ($insert_mode == 1)
                {
                        $part1 = array_slice($this->questions, 0, $array_pos + 1);
                        $part2 = array_slice($this->questions, $array_pos + 1);
                }
                foreach ($move_questions as $question_id)
                {
                        if (!(array_search($question_id, $part1) === FALSE))
                        {
                                unset($part1[array_search($question_id, $part1)]);
                        }
                        if (!(array_search($question_id, $part2) === FALSE))
                        {
                                unset($part2[array_search($question_id, $part2)]);
                        }
                }
                $part1 = array_values($part1);
                $part2 = array_values($part2);
                $this->questions = array_values(array_merge($part1, $move_questions, $part2));
                foreach ($move_questions as $question_id)
                {
                        $constraints = $this->getConstraints($question_id);
                        foreach ($constraints as $idx => $constraint)
                        {
                                foreach ($part2 as $next_question_id)
                                {
                                        if ($constraint["question"] == $next_question_id)
                                        {
                                                // constraint concerning a question that follows -> delete constraint
                                                $this->deleteConstraint($constraint["id"]);
                                        }
                                }
                        }
                }
                $this->saveQuestionsToDb();
        }
        
        function removeQuestion($question_id)
        {
                include_once "./Modules/SurveyQuestionPool/classes/class.SurveyQuestion.php";
                $question =& $this->_instanciateQuestion($question_id);
                $question->delete($question_id);
                $this->removeConstraintsConcerningQuestion($question_id);
        }
        
        function removeConstraintsConcerningQuestion($question_id)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT constraint_fi FROM svy_qst_constraint WHERE question_fi = %s AND survey_fi = %s",
                        array('integer','integer'),
                        array($question_id, $this->getSurveyId())
                );
                if ($result->numRows() > 0)
                {
                        $remove_constraints = array();
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                array_push($remove_constraints, $row["constraint_fi"]);
                        }
                        $affectedRows = $ilDB->manipulateF("DELETE FROM svy_qst_constraint WHERE question_fi = %s AND survey_fi = %s",
                                array('integer','integer'),
                                array($question_id, $this->getSurveyId())
                        );
                        foreach ($remove_constraints as $key => $constraint_id)
                        {
                                $affectedRows = $ilDB->manipulateF("DELETE FROM svy_constraint WHERE constraint_id = %s",
                                        array('integer'),
                                        array($constraint_id)
                                );
                        }
                }
        }
                
        function removeQuestions($remove_questions, $remove_questionblocks)
        {
                global $ilDB;

                $block_sizes = array();
                foreach ($this->getSurveyQuestions() as $question_id => $data)
                {
                        if (in_array($question_id, $remove_questions) or in_array($data["questionblock_id"], $remove_questionblocks))
                        {
                                unset($this->questions[array_search($question_id, $this->questions)]);
                            $this->removeQuestion($question_id);
                        }
                        else if($data["questionblock_id"])
                        {
                                $block_sizes[$data["questionblock_id"]]++;
                        }
                }
                
                // blocks with just 1 question need to be deleted
                foreach($block_sizes as $block_id => $size)
                {
                        if($size < 2)
                        {
                                $remove_questionblocks[] = $block_id;
                        }
                }

                foreach (array_unique($remove_questionblocks) as $questionblock_id)
                {
                        $affectedRows = $ilDB->manipulateF("DELETE FROM svy_qblk WHERE questionblock_id = %s",
                                array('integer'),
                                array($questionblock_id)
                        );
                        $affectedRows = $ilDB->manipulateF("DELETE FROM svy_qblk_qst WHERE questionblock_fi = %s AND survey_fi = %s",
                                array('integer','integer'),
                                array($questionblock_id, $this->getSurveyId())
                        );
                }
                
                $this->questions = array_values($this->questions);
                $this->saveQuestionsToDb();
        }
                
        function unfoldQuestionblocks($questionblocks)
        {
                global $ilDB;
                foreach ($questionblocks as $index)
                {
                        $affectedRows = $ilDB->manipulateF("DELETE FROM svy_qblk WHERE questionblock_id = %s",
                                array('integer'),
                                array($index)
                        );
                        $affectedRows = $ilDB->manipulateF("DELETE FROM svy_qblk_qst WHERE questionblock_fi = %s AND survey_fi = %s",
                                array('integer','integer'),
                                array($index, $this->getSurveyId())
                        );
                }
        }

        function removeQuestionFromBlock($question_id, $questionblock_id)
        {
                global $ilDB;
                
                $affectedRows = $ilDB->manipulateF("DELETE FROM svy_qblk_qst WHERE questionblock_fi = %s AND survey_fi = %s AND question_fi = %s",
                        array('integer','integer','integer'),
                        array($questionblock_id, $this->getSurveyId(), $question_id)
                );
        }

        function addQuestionToBlock($question_id, $questionblock_id)
        {
                global $ilDB;


                $next_id = $ilDB->nextId('svy_qblk_qst');
                $affectedRows = $ilDB->manipulateF("INSERT INTO svy_qblk_qst (qblk_qst_id, survey_fi, questionblock_fi, " .
                        "question_fi) VALUES (%s, %s, %s, %s)",
                        array('integer','integer','integer','integer'),
                        array($next_id, $this->getSurveyId(), $questionblock_id, $question_id)
                );
        }

        function &getQuestionblockQuestions($questionblock_id)
        {
                global $ilDB;
                $titles = array();
                $result = $ilDB->queryF("SELECT svy_question.title, svy_qblk_qst.question_fi, svy_qblk_qst.survey_fi FROM ".
                        "svy_qblk, svy_qblk_qst, svy_question WHERE svy_qblk.questionblock_id = svy_qblk_qst.questionblock_fi AND " .
                        "svy_question.question_id = svy_qblk_qst.question_fi AND svy_qblk.questionblock_id = %s",
                        array('integer'),
                        array($questionblock_id)
                );
                $survey_id = "";
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $titles[$row["question_fi"]] = $row["title"];
                        $survey_id = $row["survey_fi"];
                }
                $result = $ilDB->queryF("SELECT question_fi, sequence FROM svy_svy_qst WHERE survey_fi = %s ORDER BY sequence",
                        array('integer'),
                        array($survey_id)
                );
                $resultarray = array();
                $counter = 1;
                while ($row = $ilDB->fetchAssoc($result))
                {
                        if (array_key_exists($row["question_fi"], $titles))
                        {
                                $resultarray[$counter++] = $titles[$row["question_fi"]];
                        }
                }
                return $resultarray;
        }
        
        function &getQuestionblockQuestionIds($questionblock_id)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT question_fi FROM svy_qblk_qst WHERE questionblock_fi = %s",
                        array("integer"),
                        array($questionblock_id)
                );
                $ids = array();
                if ($result->numRows())
                {
                        while ($data = $ilDB->fetchAssoc($result))
                        {
                                array_push($ids, $data['question_fi']);
                        }
                }
                return $ids;
        }
        
        function getQuestionblock($questionblock_id)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT * FROM svy_qblk WHERE questionblock_id = %s",
                        array('integer'),
                        array($questionblock_id)
                );
                return $ilDB->fetchAssoc($result);
        }
        
        function _getQuestionblock($questionblock_id)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT * FROM svy_qblk WHERE questionblock_id = %s",
                        array('integer'),
                        array($questionblock_id)
                );
                $row = $ilDB->fetchAssoc($result);
                return $row;
        }

        function _addQuestionblock($title = "", $owner = 0)
        {
                global $ilDB;
                $next_id = $ilDB->nextId('svy_qblk');
                $affectedRows = $ilDB->manipulateF("INSERT INTO svy_qblk (questionblock_id, title, owner_fi, tstamp) " .
                        "VALUES (%s, %s, %s, %s)",
                        array('integer','text','integer','integer'),
                        array($next_id, $title, $owner, time())
                );
                return $next_id;
        }
        
        function createQuestionblock($title, $show_questiontext, $show_blocktitle, $questions)
        {
                global $ilDB;
                
                // if the selected questions are not in a continous selection, move all questions of the
                // questionblock at the position of the first selected question
                $this->moveQuestions($questions, $questions[0], 0);
                
                // now save the question block
                global $ilUser;
                $next_id = $ilDB->nextId('svy_qblk');
                $affectedRows = $ilDB->manipulateF("INSERT INTO svy_qblk (questionblock_id, title, show_questiontext,".
                        " show_blocktitle, owner_fi, tstamp) VALUES (%s, %s, %s, %s, %s, %s)",
                        array('integer','text','text','text','integer','integer'),
                        array($next_id, $title, $show_questiontext, $show_blocktitle, $ilUser->getId(), time())
                );
                if ($affectedRows)
                {
                        $questionblock_id = $next_id;
                        foreach ($questions as $index)
                        {
                                $next_id = $ilDB->nextId('svy_qblk_qst');
                                $affectedRows = $ilDB->manipulateF("INSERT INTO svy_qblk_qst (qblk_qst_id, survey_fi, questionblock_fi, " .
                                        "question_fi) VALUES (%s, %s, %s, %s)",
                                        array('integer','integer','integer','integer'),
                                        array($next_id, $this->getSurveyId(), $questionblock_id, $index)
                                );
                                $this->deleteConstraints($index);
                        }
                }
        }
        
        function modifyQuestionblock($questionblock_id, $title, $show_questiontext, $show_blocktitle)
        {
                global $ilDB;
                $affectedRows = $ilDB->manipulateF("UPDATE svy_qblk SET title = %s, show_questiontext = %s,".
                        " show_blocktitle = %s WHERE questionblock_id = %s",
                        array('text','text','text','integer'),
                        array($title, $show_questiontext, $show_blocktitle, $questionblock_id)
                );
        }
        
        function deleteConstraints($question_id)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT constraint_fi FROM svy_qst_constraint WHERE question_fi = %s AND survey_fi = %s",
                        array('integer','integer'),
                        array($question_id, $this->getSurveyId())
                );
                $constraints = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        array_push($constraints, $row["constraint_fi"]);
                }
                foreach ($constraints as $constraint_id)
                {
                        $this->deleteConstraint($constraint_id);
                }
        }

        function deleteConstraint($constraint_id)
        {
                global $ilDB;
                $affectedRows = $ilDB->manipulateF("DELETE FROM svy_constraint WHERE constraint_id = %s",
                        array('integer'),
                        array($constraint_id)
                );
                $affectedRows = $ilDB->manipulateF("DELETE FROM svy_qst_constraint WHERE constraint_fi = %s",
                        array('integer'),
                        array($constraint_id)
                );
        }

        public function &getSurveyQuestions($with_answers = false)
        {
                global $ilDB;
                $obligatory_states =& $this->getObligatoryStates();
                // get questionblocks
                $all_questions = array();
                $result = $ilDB->queryF("SELECT svy_qtype.type_tag, svy_qtype.plugin, svy_question.question_id, ".
                        "svy_svy_qst.heading FROM svy_qtype, svy_question, svy_svy_qst WHERE svy_svy_qst.survey_fi = %s AND " .
                        "svy_svy_qst.question_fi = svy_question.question_id AND svy_question.questiontype_fi = svy_qtype.questiontype_id " .
                        "ORDER BY svy_svy_qst.sequence",
                        array('integer'),
                        array($this->getSurveyId())
                );
                include_once "./Modules/SurveyQuestionPool/classes/class.SurveyQuestion.php";
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $add = true;
                        if ($row["plugin"])
                        {
                                if (!$this->isPluginActive($row["type_tag"]))
                                {
                                        $add = false;
                                }
                        }
                        if ($add)
                        {
                                $question =& $this->_instanciateQuestion($row["question_id"]);
                                $questionrow = $question->_getQuestionDataArray($row["question_id"]);
                                foreach ($row as $key => $value)
                                {
                                        $questionrow[$key] = $value;
                                }
                                $all_questions[$row["question_id"]] = $questionrow;
                                $all_questions[$row["question_id"]]["usableForPrecondition"] = $question->usableForPrecondition();
                                $all_questions[$row["question_id"]]["availableRelations"] = $question->getAvailableRelations();
                                if (array_key_exists($row["question_id"], $obligatory_states))
                                {
                                        $all_questions[$row["question_id"]]["obligatory"] = $obligatory_states[$row["question_id"]];
                                }
                        }
                }
                // get all questionblocks
                $questionblocks = array();
                if (count($all_questions))
                {
                        $result = $ilDB->queryF("SELECT svy_qblk.*, svy_qblk_qst.question_fi FROM svy_qblk, svy_qblk_qst WHERE " .
                                "svy_qblk.questionblock_id = svy_qblk_qst.questionblock_fi AND svy_qblk_qst.survey_fi = %s " .
                                "AND " . $ilDB->in('svy_qblk_qst.question_fi', array_keys($all_questions), false, 'integer'),
                                array('integer'),
                                array($this->getSurveyId())
                        );
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $questionblocks[$row['question_fi']] = $row;
                        }
                }
                
                foreach ($all_questions as $question_id => $row)
                {
                        $constraints = $this->getConstraints($question_id);
                        if (isset($questionblocks[$question_id]))
                        {
                                $all_questions[$question_id]["questionblock_title"] = $questionblocks[$question_id]['title'];
                                $all_questions[$question_id]["questionblock_id"] = $questionblocks[$question_id]['questionblock_id'];
                                $all_questions[$question_id]["constraints"] = $constraints;
                        }
                        else
                        {
                                $all_questions[$question_id]["questionblock_title"] = "";
                                $all_questions[$question_id]["questionblock_id"] = "";
                                $all_questions[$question_id]["constraints"] = $constraints;
                        }
                        if ($with_answers)
                        {
                                $answers = array();
                                $result = $ilDB->queryF("SELECT svy_variable.*, svy_category.title FROM svy_variable, svy_category " .
                                        "WHERE svy_variable.question_fi = %s AND svy_variable.category_fi = svy_category.category_id ".
                                        "ORDER BY sequence ASC",
                                        array('integer'),
                                        array($question_id)
                                );
                                if ($result->numRows() > 0) 
                                {
                                        while ($data = $ilDB->fetchAssoc($result)) 
                                        {
                                                array_push($answers, $data["title"]);
                                        }
                                }
                                $all_questions[$question_id]["answers"] = $answers;
                        }
                }
                return $all_questions;
        }
        
        function setObligatoryStates($obligatory_questions)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT * FROM svy_svy_qst WHERE survey_fi = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );
                if ($result->numRows())
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                if (!array_key_exists($row["question_fi"], $obligatory_questions))
                                {
                                        $obligatory_questions[$row["question_fi"]] = 0;
                                }
                        }
                }

          // set the obligatory states in the database
                $affectedRows = $ilDB->manipulateF("DELETE FROM svy_qst_oblig WHERE survey_fi = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );

          // set the obligatory states in the database
                foreach ($obligatory_questions as $question_fi => $obligatory)
                {
                        $next_id = $ilDB->nextId('svy_qst_oblig');
                        $affectedRows = $ilDB->manipulateF("INSERT INTO svy_qst_oblig (question_obligatory_id, survey_fi, question_fi, " .
                                "obligatory, tstamp) VALUES (%s, %s, %s, %s, %s)",
                                array('integer','integer','integer','text','integer'),
                                array($next_id, $this->getSurveyId(), $question_fi, (strlen($obligatory)) ? $obligatory : 0, time())
                        );
                        
                        // #12420
                        $ilDB->manipulate("UPDATE svy_question".
                                " SET obligatory = ".$ilDB->quote($obligatory, "integer").
                                " WHERE question_id = ".$ilDB->quote($question_fi, "integer"));
                }
        }
        
        function &getObligatoryStates()
        {
                global $ilDB;
                $obligatory_states = array();
                $result = $ilDB->queryF("SELECT * FROM svy_qst_oblig WHERE survey_fi = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );
                if ($result->numRows())
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $obligatory_states[$row["question_fi"]] = $row["obligatory"];
                        }
                }
                return $obligatory_states;
        }
        
        function &getSurveyPages()
        {
                global $ilDB;
                $obligatory_states =& $this->getObligatoryStates();
                // get questionblocks
                $all_questions = array();
                $result = $ilDB->queryF("SELECT svy_question.*, svy_qtype.type_tag, svy_svy_qst.heading FROM " . 
                        "svy_question, svy_qtype, svy_svy_qst WHERE svy_svy_qst.survey_fi = %s AND " .
                        "svy_svy_qst.question_fi = svy_question.question_id AND svy_question.questiontype_fi = svy_qtype.questiontype_id ".
                        "ORDER BY svy_svy_qst.sequence",
                        array('integer'),
                        array($this->getSurveyId())
                );
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $all_questions[$row["question_id"]] = $row;
                }
                // get all questionblocks
                $questionblocks = array();
                if (count($all_questions))
                {
                        $result = $ilDB->queryF("SELECT svy_qblk.*, svy_qblk_qst.question_fi FROM svy_qblk, svy_qblk_qst ".
                                "WHERE svy_qblk.questionblock_id = svy_qblk_qst.questionblock_fi AND svy_qblk_qst.survey_fi = %s ".
                                "AND " . $ilDB->in('svy_qblk_qst.question_fi', array_keys($all_questions), false, 'integer'),
                                array('integer'),
                                array($this->getSurveyId())
                        );
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $questionblocks[$row['question_fi']] = $row;
                        }
                }
                
                $all_pages = array();
                $pageindex = -1;
                $currentblock = "";
                foreach ($all_questions as $question_id => $row)
                {
                        if (array_key_exists($question_id, $obligatory_states))
                        {
                                $all_questions[$question_id]["obligatory"] = $obligatory_states[$question_id];
                        }
                        $constraints = array();
                        if (isset($questionblocks[$question_id]))
                        {
                                if (!$currentblock or ($currentblock != $questionblocks[$question_id]['questionblock_id']))
                                {
                                        $pageindex++;
                                }
                                $all_questions[$question_id]['page'] = $pageindex;
                                $all_questions[$question_id]["questionblock_title"] = $questionblocks[$question_id]['title'];
                                $all_questions[$question_id]["questionblock_id"] = $questionblocks[$question_id]['questionblock_id'];
                                $all_questions[$question_id]["questionblock_show_questiontext"] = $questionblocks[$question_id]['show_questiontext'];
                                $all_questions[$question_id]["questionblock_show_blocktitle"] = $questionblocks[$question_id]['show_blocktitle'];
                                $currentblock = $questionblocks[$question_id]['questionblock_id'];
                                $constraints = $this->getConstraints($question_id);
                                $all_questions[$question_id]["constraints"] = $constraints;
                        }
                        else
                        {
                                $pageindex++;
                                $all_questions[$question_id]['page'] = $pageindex;
                                $all_questions[$question_id]["questionblock_title"] = "";
                                $all_questions[$question_id]["questionblock_id"] = "";
                                $all_questions[$question_id]["questionblock_show_questiontext"] = 1;
                                $all_questions[$question_id]["questionblock_show_blocktitle"] = 1;
                                $currentblock = "";
                                $constraints = $this->getConstraints($question_id);
                                $all_questions[$question_id]["constraints"] = $constraints;
                        }
                        if (!isset($all_pages[$pageindex]))
                        {
                                $all_pages[$pageindex] = array();
                        }
                        array_push($all_pages[$pageindex], $all_questions[$question_id]);
                }
                // calculate position percentage for every page
                $max = count($all_pages);
                $counter = 1;
                foreach ($all_pages as $index => $block)
                {
                        foreach ($block as $blockindex => $question)
                        {
                                $all_pages[$index][$blockindex]["position"] = $counter / $max;
                        }
                        $counter++;
                }
                return $all_pages;
        }
        
        function getNextPage($active_page_question_id, $direction)
        {
                $foundpage = -1;
                $pages =& $this->getSurveyPages();
                if (strcmp($active_page_question_id, "") == 0)
                {
                        return $pages[0];
                }
                foreach ($pages as $key => $question_array)
                {
                        foreach ($question_array as $question)
                        {
                                if ($active_page_question_id == $question["question_id"])
                                {
                                        $foundpage = $key;
                                }
                        }
                }
                if ($foundpage == -1)
                {
                        // error: page not found
                }
                else
                {
                        $foundpage += $direction;
                        if ($foundpage < 0)
                        {
                                return 0;
                        }
                        if ($foundpage >= count($pages))
                        {
                                return 1;
                        }
                        return $pages[$foundpage];
                }
        }
                
        function &getAvailableQuestionpools($use_obj_id = false, $could_be_offline = false, $showPath = FALSE, $permission = "read")
        {
                include_once "./Modules/SurveyQuestionPool/classes/class.ilObjSurveyQuestionPool.php";
                return ilObjSurveyQuestionPool::_getAvailableQuestionpools($use_obj_id, $could_be_offline, $showPath, $permission);
        }
        
        function getPrecondition($id)
        {
                global $ilDB;
                
                $result_array = array();
                $result = $ilDB->queryF("SELECT svy_constraint.*, svy_relation.* FROM svy_qst_constraint, svy_constraint, ".
                        "svy_relation WHERE svy_constraint.relation_fi = svy_relation.relation_id AND ".
                        "svy_qst_constraint.constraint_fi = svy_constraint.constraint_id AND svy_constraint.constraint_id = %s",
                        array('integer'),
                        array($id)
                );
                $pc = array();
                if ($result->numRows())
                {
                        $pc = $ilDB->fetchAssoc($result);
                }
                return $pc;
        }
        
        function getConstraints($question_id)
        {
                global $ilDB;
                
                $result_array = array();
                $result = $ilDB->queryF("SELECT svy_constraint.*, svy_relation.* FROM svy_qst_constraint, svy_constraint, svy_relation ".
                        "WHERE svy_constraint.relation_fi = svy_relation.relation_id AND ".
                        "svy_qst_constraint.constraint_fi = svy_constraint.constraint_id AND svy_qst_constraint.question_fi = %s ".
                        "AND svy_qst_constraint.survey_fi = %s",
                        array('integer','integer'),
                        array($question_id, $this->getSurveyId())
                );
                while ($row = $ilDB->fetchAssoc($result))
                {       
                        include_once "./Modules/SurveyQuestionPool/classes/class.SurveyQuestion.php";
                        $question_type = SurveyQuestion::_getQuestionType($row["question_fi"]);
                        SurveyQuestion::_includeClass($question_type);
                        $question = new $question_type();
                        $question->loadFromDb($row["question_fi"]);
                        $valueoutput = $question->getPreconditionValueOutput($row["value"]);
                        array_push($result_array, array("id" => $row["constraint_id"], "question" => $row["question_fi"], "short" => $row["shortname"], "long" => $row["longname"], "value" => $row["value"], "conjunction" => $row["conjunction"], "valueoutput" => $valueoutput));
                }
                return $result_array;
        }

        function _getConstraints($survey_id)
        {
                global $ilDB;
                $result_array = array();
                $result = $ilDB->queryF("SELECT svy_qst_constraint.question_fi as for_question, svy_constraint.*, svy_relation.* ".
                        "FROM svy_qst_constraint, svy_constraint, svy_relation WHERE svy_constraint.relation_fi = svy_relation.relation_id ".
                        "AND svy_qst_constraint.constraint_fi = svy_constraint.constraint_id AND svy_qst_constraint.survey_fi = %s",
                        array('integer'),
                        array($survey_id)
                );
                while ($row = $ilDB->fetchAssoc($result))
                {               
                        array_push($result_array, array("id" => $row["constraint_id"], "for_question" => $row["for_question"], "question" => $row["question_fi"], "short" => $row["shortname"], "long" => $row["longname"], "relation_id" => $row["relation_id"], "value" => $row["value"], 'conjunction' => $row['conjunction']));
                }
                return $result_array;
        }


        function &getVariables($question_id)
        {
                global $ilDB;
                
                $result_array = array();
                $result = $ilDB->queryF("SELECT svy_variable.*, svy_category.title FROM svy_variable LEFT JOIN ".
                        "svy_category ON svy_variable.category_fi = svy_category.category_id WHERE svy_variable.question_fi = %s ".
                        "ORDER BY svy_variable.sequence",
                        array('integer'),
                        array($question_id)
                );
                while ($row = $ilDB->fetchObject($result))
                {
                        $result_array[$row->sequence] = $row;
                }
                return $result_array;
        }
        
        function addConstraint($if_question_id, $relation, $value, $conjunction)
        {
                global $ilDB;

                $next_id = $ilDB->nextId('svy_constraint');
                $affectedRows = $ilDB->manipulateF("INSERT INTO svy_constraint (constraint_id, question_fi, relation_fi, value, conjunction) VALUES ".
                        "(%s, %s, %s, %s, %s)",
                        array('integer','integer','integer','float', 'integer'),
                        array($next_id, $if_question_id, $relation, $value, $conjunction)
                );
                if ($affectedRows)
                {
                        return $next_id;
                }
                else
                {
                        return null;
                }
        }


        public function addConstraintToQuestion($to_question_id, $constraint_id)
        {
                global $ilDB;
                
                $next_id = $ilDB->nextId('svy_qst_constraint');
                $affectedRows = $ilDB->manipulateF("INSERT INTO svy_qst_constraint (question_constraint_id, survey_fi, question_fi, ".
                        "constraint_fi) VALUES (%s, %s, %s, %s)",
                        array('integer','integer','integer','integer'),
                        array($next_id, $this->getSurveyId(), $to_question_id, $constraint_id)
                );
        }
        
        function updateConstraint($precondition_id, $if_question_id, $relation, $value, $conjunction)
        {
                global $ilDB;
                $affectedRows = $ilDB->manipulateF("UPDATE svy_constraint SET question_fi = %s, relation_fi = %s, value = %s, conjunction = %s ".
                        "WHERE constraint_id = %s",
                        array('integer','integer','float','integer','integer'),
                        array($if_question_id, $relation, $value, $conjunction, $precondition_id)
                );
        }
                
        public function updateConjunctionForQuestions($questions, $conjunction)
        {
                global $ilDB;
                foreach ($questions as $question_id)
                {
                        $affectedRows = $ilDB->manipulateF("UPDATE svy_constraint SET conjunction = %s ".
                                "WHERE constraint_id IN (SELECT constraint_fi FROM svy_qst_constraint WHERE svy_qst_constraint.question_fi = %s)",
                                array('integer','integer'),
                                array($conjunction, $question_id)
                        );
                }
        }

        function getAllRelations($short_as_key = false)
        {
                global $ilDB;
                
                // #7987
                $custom_order = array("equal", "not_equal", "less", "less_or_equal", "more", "more_or_equal");
                $custom_order = array_flip($custom_order);
                
                $result_array = array();
                $result = $ilDB->query("SELECT * FROM svy_relation");
                while ($row = $ilDB->fetchAssoc($result))
                {
                        if ($short_as_key)
                        {
                                $result_array[$row["shortname"]] = array("short" => $row["shortname"], "long" => $row["longname"], "id" => $row["relation_id"], "order" => $custom_order[$row["longname"]]);
                        }
                        else
                        {
                                $result_array[$row["relation_id"]] = array("short" => $row["shortname"], "long" => $row["longname"], "order" => $custom_order[$row["longname"]]);
                        }
                }               
                
                $result_array = ilUtil::sortArray($result_array, "order", "ASC", true, true);
                foreach($result_array as $idx => $item)
                {
                        unset($result_array[$idx]["order"]);
                }
                
                return $result_array;
        }

        public function disinviteAllUsers()
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT user_fi FROM svy_inv_usr WHERE survey_fi = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $this->disinviteUser($row['user_fi']);
                }
        }

        public function disinviteUser($user_id)
        {
                global $ilDB;
                
                $affectedRows = $ilDB->manipulateF("DELETE FROM svy_inv_usr WHERE survey_fi = %s AND user_fi = %s",
                        array('integer','integer'),
                        array($this->getSurveyId(), $user_id)
                );
                include_once './Services/User/classes/class.ilObjUser.php';
                ilObjUser::_dropDesktopItem($user_id, $this->getRefId(), "svy");
        }

        function inviteUser($user_id)
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT user_fi FROM svy_inv_usr WHERE user_fi = %s AND survey_fi = %s",
                        array('integer','integer'),
                        array($user_id, $this->getSurveyId())
                );
                if ($result->numRows() < 1)
                {
                        $next_id = $ilDB->nextId('svy_inv_usr');
                        $affectedRows = $ilDB->manipulateF("INSERT INTO svy_inv_usr (invited_user_id, survey_fi, user_fi, tstamp) " .
                                "VALUES (%s, %s, %s, %s)",
                                array('integer','integer','integer','integer'),
                                array($next_id, $this->getSurveyId(), $user_id, time())
                        );
                }
                if ($this->getInvitation() == INVITATION_ON)
                {
                        include_once './Services/User/classes/class.ilObjUser.php';
                        ilObjUser::_addDesktopItem($user_id, $this->getRefId(), "svy");
                }
        }

                function inviteGroup($group_id)
                {
                        global $ilAccess;
                        $invited = 0;
                        include_once "./Modules/Group/classes/class.ilObjGroup.php";
                        $group = new ilObjGroup($group_id);
                        $members = $group->getGroupMemberIds();
                        foreach ($members as $user_id)
                        {
                                if ($ilAccess->checkAccessOfUser($user_id, "read", "", $this->getRefId(), "svy", $this->getId()))
                                {
                                        $this->inviteUser($user_id);
                                        if ($this->getInvitation() == INVITATION_ON)
                                        {
                                                include_once './Services/User/classes/class.ilObjUser.php';
                                                ilObjUser::_addDesktopItem($user_id, $this->getRefId(), "svy");
                                        }
                                }
                        }
                        return $invited;
                }

                function inviteRole($role_id)
                {
                        global $rbacreview;
                        global $ilAccess;
                        $invited = 0;
                        $members = $rbacreview->assignedUsers($role_id);
                        foreach ($members as $user_id)
                        {
                                if ($ilAccess->checkAccessOfUser($user_id, "read", "", $this->getRefId(), "svy", $this->getId()))
                                {
                                        $this->inviteUser($user_id);
                                        if ($this->getInvitation() == INVITATION_ON)
                                        {
                                                include_once './Services/User/classes/class.ilObjUser.php';
                                                ilObjUser::_addDesktopItem($user_id, $this->getRefId(), "svy");
                                        }
                                }
                        }
                        return $invited;
                }

        function &getInvitedUsers()
        {
                global $ilDB;
                
                $result_array = array();
                $result = $ilDB->queryF("SELECT user_fi FROM svy_inv_usr WHERE survey_fi = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );
                while ($row = $ilDB->fetchAssoc($result))
                {
                        array_push($result_array, $row["user_fi"]);
                }
                return $result_array;
        }

        function deleteWorkingData($question_id, $active_id)
        {
                global $ilDB;
                
                $affectedRows = $ilDB->manipulateF("DELETE FROM svy_answer WHERE question_fi = %s AND active_fi = %s",
                        array('integer','integer'),
                        array($question_id, $active_id)
                );
        }
        
        function loadWorkingData($question_id, $active_id)
        {
                global $ilDB;
                $result_array = array();
                $result = $ilDB->queryF("SELECT * FROM svy_answer WHERE question_fi = %s AND active_fi = %s",
                        array('integer','integer'),
                        array($question_id, $active_id)
                );
                if ($result->numRows() >= 1)
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                array_push($result_array, $row);
                        }
                        return $result_array;
                }
                else
                {
                        return $result_array;
                }
        }
        
        function fillSurveyForUser($user_id = ANONYMOUS_USER_ID)
        {
                global $ilDB;
                // create an anonymous key
                $anonymous_id = $this->createNewAccessCode();
                $this->saveUserAccessCode($user_id, $anonymous_id);
                // create the survey_finished dataset and set the survey finished already
                $active_id = $ilDB->nextId('svy_finished');
                $affectedRows = $ilDB->manipulateF("INSERT INTO svy_finished (finished_id, survey_fi, user_fi, anonymous_id, state, tstamp) ".
                        "VALUES (%s, %s, %s, %s, %s, %s)",
                        array('integer','integer','integer','text','text','integer'),
                        array($active_id, $this->getSurveyId(), $user_id, $anonymous_id, 1, time())
                );
                // fill the questions randomly
                $pages =& $this->getSurveyPages();
                foreach ($pages as $key => $question_array)
                {
                        foreach ($question_array as $question)
                        {
                                // instanciate question
                                require_once "./Modules/SurveyQuestionPool/classes/class.SurveyQuestion.php";
                                $question =& SurveyQuestion::_instanciateQuestion($question["question_id"]);
                                $question->saveRandomData($active_id);
                        }
                }               
        }

        function startSurvey($user_id, $anonymous_id)
        {
                global $ilUser;
                global $ilDB;
                
                if ($this->getAnonymize() && (strlen($anonymous_id) == 0)) return;

                if (strcmp($user_id, "") == 0)
                {
                        if ($user_id == ANONYMOUS_USER_ID)
                        {
                                $user_id = 0;
                        }
                }
                $next_id = $ilDB->nextId('svy_finished');
                $affectedRows = $ilDB->manipulateF("INSERT INTO svy_finished (finished_id, survey_fi, user_fi, anonymous_id, state, tstamp) ".
                        "VALUES (%s, %s, %s, %s, %s, %s)",
                        array('integer','integer','integer','text','text','integer'),
                        array($next_id, $this->getSurveyId(), $user_id, $anonymous_id, 0, time())
                );
                return $next_id;
        }

        function finishSurvey($user_id, $anonymize_id)
        {
                global $ilDB;
                
                if ($this->getAnonymize())
                {
                        $affectedRows = $ilDB->manipulateF("UPDATE svy_finished SET state = %s, user_fi = %s, tstamp = %s ".
                                "WHERE survey_fi = %s AND anonymous_id = %s",
                                array('text','integer','integer','integer','text'),
                                array(1, $user_id, time(), $this->getSurveyId(), $anonymize_id)
                        );
                }
                else
                {
                        $affectedRows = $ilDB->manipulateF("UPDATE svy_finished SET state = %s, tstamp = %s WHERE survey_fi = %s AND user_fi = %s",
                                array('text','integer','integer','integer'),
                                array(1, time(), $this->getSurveyId(), $user_id)
                        );
                }
                if ($this->getMailNotification())
                {
                        $this->sendNotificationMail($user_id, $anonymize_id);
                }
        }

        function setPage($finished_id, $page_id)
        {
                global $ilDB;

                $affectedRows = $ilDB->manipulateF("UPDATE svy_finished SET lastpage = %s WHERE finished_id = %s",
                        array('integer','integer'),
                        array(($page_id) ? $page_id : 0, $finished_id)
                );
        }

        function sendNotificationMail($user_id, $anonymize_id)
        {
                include_once "./Services/User/classes/class.ilObjUser.php";
                include_once "./Services/Mail/classes/class.ilMail.php";
                
                // #12755
                $placeholders = array(
                        "FIRST_NAME" => "firstname",
                        "LAST_NAME" => "lastname",              
                        "LOGIN" => "login",             
                        // old style
                        "firstname" => "firstname"
                );              
                
                $mail = new ilMail(ANONYMOUS_USER_ID);
                $recipients = preg_split('/,/', $this->mailaddresses);
                foreach ($recipients as $recipient)
                {
                        $messagetext = $this->mailparticipantdata;
                        $data = ilObjUser::_getUserData(array($user_id));
                        $data = $data[0];
                        foreach ($placeholders as $key => $mapping)
                        {               
                                if ($this->getAnonymize())
                                {
                                        $messagetext = str_replace('[' . $key . ']', '', $messagetext);
                                }
                                else
                                {
                                        $messagetext = str_replace('[' . $key . ']', trim($data[$mapping]), $messagetext);
                                }
                        }
                        $active_id = $this->getActiveID($user_id, $anonymize_id);
                        $messagetext .= ((strlen($messagetext)) ? "\n\n\n" : '') . $this->lng->txt('results') . "\n\n". $this->getParticipantTextResults($active_id);
                
                        $mail->sendMail(
                                $recipient, // to
                                "", // cc
                                "", // bcc
                                $this->lng->txt('finished_mail_subject') . ': ' . $this->getTitle(), // subject
                                $messagetext, // message
                                array(), // attachments
                                array('normal') // type
                        );                              
                }
        }

        protected function getParticipantTextResults($active_id)
        {
                $textresult = "";
                $userResults =& $this->getUserSpecificResults();
                $questions =& $this->getSurveyQuestions(true);
                $questioncounter = 1;
                foreach ($questions as $question_id => $question_data)
                {
                        $textresult .= $questioncounter++ . ". " . $question_data["title"] . "\n";
                        $found = $userResults[$question_id][$active_id];
                        $text = "";
                        if (is_array($found))
                        {
                                $text = implode("\n", $found);
                        }
                        else
                        {
                                $text = $found;
                        }
                        if (strlen($text) == 0) $text = $this->lng->txt("skipped");
                        $text = str_replace("<br />", "\n", $text);
                        $textresult .= $text . "\n\n";
                }
                return $textresult;
        }

        function getDetailedParticipantResultsAsText()
        {
                $counter = 0;
                $questions =& $this->getSurveyQuestions();
                $counter++;
                foreach ($questions as $data)
                {
                        include_once "./Modules/SurveyQuestionPool/classes/class.SurveyQuestion.php";
                        $question = SurveyQuestion::_instanciateQuestion($data["question_id"]);

                        $eval = $this->getCumulatedResults($question);
                }
        }
        
        function isAllowedToTakeMultipleSurveys($userid = "")
        {               
                // #7927: special users are deprecated
                return false;
                
                /*
                $result = FALSE;
                if ($this->getAnonymize())
                {
                        if ($this->isAccessibleWithoutCode())
                        {
                                if (strlen($username) == 0)
                                {
                                        global $ilUser;
                                        $userid = $ilUser->getId();
                                }
                                global $ilSetting;
                                $surveysetting = new ilSetting("survey");
                                $allowedUsers = strlen($surveysetting->get("multiple_survey_users")) ? explode(",",$surveysetting->get("multiple_survey_users")) : array();
                                if (in_array($userid, $allowedUsers))
                                {
                                        $result = TRUE;
                                }
                        }
                }
                return $result;          
                */
        }
        
        function isSurveyStarted($user_id, $anonymize_id)
        {
                global $ilDB;

                if ($this->getAnonymize())
                {
                        if ((($user_id != ANONYMOUS_USER_ID) && sizeof($anonymize_id)) && (!($this->isAccessibleWithoutCode() && $this->isAllowedToTakeMultipleSurveys())))
                        {
                                $result = $ilDB->queryF("SELECT * FROM svy_finished WHERE survey_fi = %s AND user_fi = %s",
                                        array('integer','integer'),
                                        array($this->getSurveyId(), $user_id)
                                );
                        }
                        else
                        {
                                $result = $ilDB->queryF("SELECT * FROM svy_finished WHERE survey_fi = %s AND anonymous_id = %s",
                                        array('integer','text'),
                                        array($this->getSurveyId(), $anonymize_id)
                                );
                        }
                }
                else
                {
                        $result = $ilDB->queryF("SELECT * FROM svy_finished WHERE survey_fi = %s AND user_fi = %s",
                                array('integer','integer'),
                                array($this->getSurveyId(), $user_id)
                        );
                }
                if ($result->numRows() == 0)
                {
                        return false;
                }                       
                else
                {
                        $row = $ilDB->fetchAssoc($result);
                        $_SESSION["finished_id"][$this->getId()] = $row["finished_id"];
                        return (int)$row["state"];
                }
        }

        function getActiveID($user_id, $anonymize_id)
        {
                global $ilDB;

                if ($this->getAnonymize())
                {
                        if ((($user_id != ANONYMOUS_USER_ID) && (strlen($anonymize_id) == 0)) && (!($this->isAccessibleWithoutCode() && $this->isAllowedToTakeMultipleSurveys())))
                        {
                                $result = $ilDB->queryF("SELECT finished_id FROM svy_finished WHERE survey_fi = %s AND user_fi = %s",
                                        array('integer','integer'),
                                        array($this->getSurveyId(), $user_id)
                                );
                        }
                        else
                        {
                                $result = $ilDB->queryF("SELECT finished_id FROM svy_finished WHERE survey_fi = %s AND anonymous_id = %s",
                                        array('integer','text'),
                                        array($this->getSurveyId(), $anonymize_id)
                                );
                        }
                }
                else
                {
                        $result = $ilDB->queryF("SELECT finished_id FROM svy_finished WHERE survey_fi = %s AND user_fi = %s",
                                array('integer','integer'),
                                array($this->getSurveyId(), $user_id)
                        );
                }
                if ($result->numRows() == 0)
                {
                        return false;
                }                       
                else
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["finished_id"];
                }
        }
        
        function getLastActivePage($active_id)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT lastpage FROM svy_finished WHERE finished_id = %s",
                        array('integer'),
                        array($active_id)
                );
                if ($result->numRows() == 0)
                {
                        return "";
                }
                else
                {
                        $row = $ilDB->fetchAssoc($result);
                        return ($row["lastpage"]) ? $row["lastpage"] : '';
                }
        }

        function checkConstraint($constraint_data, $working_data)
        {
                if (count($working_data) == 0)
                {
                        return 0;
                }
                
                if ((count($working_data) == 1) and (strcmp($working_data[0]["value"], "") == 0))
                {
                        return 0;
                }
                
                $found = false;
                foreach ($working_data as $data)
                {
                        switch ($constraint_data["short"])
                        {
                                case "<":
                                        if ($data["value"] < $constraint_data["value"])
                                        {
                                                $found = true;
                                        }
                                        break;
                                        
                                case "<=":
                                        if ($data["value"] <= $constraint_data["value"])
                                        {
                                                $found = true;
                                        }
                                        break;
                                
                                case "=":
                                        if ($data["value"] == $constraint_data["value"])
                                        {
                                                $found = true;
                                        }
                                        break;
                                                                                                                                                        
                                case "<>":
                                        if ($data["value"] <> $constraint_data["value"])
                                        {
                                                $found = true;
                                        }                                       
                                        break;
                                        
                                case ">=":                                      
                                        if ($data["value"] >= $constraint_data["value"])
                                        {
                                                $found = true;
                                        }                               
                                        break;
                                        
                                case ">":
                                        if ($data["value"] > $constraint_data["value"])
                                        {
                                                $found = true;
                                        }
                                        break;
                        }                                       
                        if ($found)
                        {
                                break;
                        }
                }
                
                return (int)$found;
        }
        
        function _hasDatasets($survey_id)
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT finished_id FROM svy_finished WHERE survey_fi = %s",
                        array('integer'),
                        array($survey_id)
                );
                return ($result->numRows()) ? true : false;
        }

        function &getSurveyFinishedIds()
        {
                global $ilDB, $ilLog;
                
                $users = array();
                $result = $ilDB->queryF("SELECT * FROM svy_finished WHERE survey_fi = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );
                if ($result->numRows())
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                array_push($users, $row["finished_id"]);
                        }
                }
                return $users;
        }
        
        function &getUserSpecificResults()
        {
                global $ilDB;
                
                $users = array();
                $result = $ilDB->queryF("SELECT * FROM svy_finished WHERE survey_fi = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );
                if ($result->numRows())
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                array_push($users, $row);
                        }
                }
                $evaluation = array();
                $questions =& $this->getSurveyQuestions();
                foreach ($questions as $question_id => $question_data)
                {
                        include_once "./Modules/SurveyQuestionPool/classes/class.SurveyQuestion.php";
                        $question_type = SurveyQuestion::_getQuestionType($question_id);
                        SurveyQuestion::_includeClass($question_type);
                        $question = new $question_type();
                        $question->loadFromDb($question_id);
                        $data =& $question->getUserAnswers($this->getSurveyId());
                        $evaluation[$question_id] = $data;
                }
                return $evaluation;
        }
        
        function getUserDataFromActiveId($active_id)
        {
                global $ilDB;

                $surveySetting = new ilSetting("survey");
                $use_anonymous_id = array_key_exists("use_anonymous_id", $_GET) ? $_GET["use_anonymous_id"] : $surveySetting->get("use_anonymous_id");
                $result = $ilDB->queryF("SELECT * FROM svy_finished WHERE finished_id = %s",
                        array('integer'),
                        array($active_id)
                );
                $row = array();
                $foundrows = $result->numRows();
                if ($foundrows)
                {
                        $row = $ilDB->fetchAssoc($result);
                }
                $name = ($use_anonymous_id) ? $row["anonymous_id"] : $this->lng->txt("anonymous");
                $userdata = array(
                        "fullname" => $name,
                        "sortname" => $name,
                        "firstname" => "",
                        "lastname" => "",
                        "login" => "",
                        "gender" => "",
                        "active_id" => "$active_id"
                );
                if ($foundrows)
                {
                        if (($row["user_fi"] > 0) && ($row["user_fi"] != ANONYMOUS_USER_ID) && ($this->getAnonymize() == 0))
                        {
                                include_once './Services/User/classes/class.ilObjUser.php';
                                if (strlen(ilObjUser::_lookupLogin($row["user_fi"])) == 0)
                                {
                                        $userdata["fullname"] = $userdata["sortname"] = $this->lng->txt("deleted_user");
                                }
                                else
                                {
                                        $user = new ilObjUser($row["user_fi"]);
                                        $userdata["fullname"] = $user->getFullname();
                                        $gender = $user->getGender();
                                        if (strlen($gender) == 1) $gender = $this->lng->txt("gender_$gender");
                                        $userdata["gender"] = $gender;
                                        $userdata["firstname"] = $user->getFirstname();
                                        $userdata["lastname"] = $user->getLastname();
                                        $userdata["sortname"] = $user->getLastname() . ", " . $user->getFirstname();
                                        $userdata["login"] = $user->getLogin();
                                }
                        }
                }
                return $userdata;
        }
        
        function &getEvaluationByUser($questions, $active_id)
        {
                global $ilDB;
                
                // collect all answers
                $answers = array();
                $result = $ilDB->queryF("SELECT * FROM svy_answer WHERE active_fi = %s",
                        array('integer'),
                        array($active_id)
                );
                while ($row = $ilDB->fetchAssoc($result))
                {
                        if (!is_array($answers[$row["question_fi"]]))
                        {
                                $answers[$row["question_fi"]] = array();
                        }
                        array_push($answers[$row["question_fi"]], $row);
                }
                $userdata = $this->getUserDataFromActiveId($active_id);
                $resultset = array(
                        "name" => $userdata["fullname"],
                        "login" => $userdata["login"],
                        "gender" => $userdata["gender"],
                        "answers" => array()
                );
                foreach ($questions as $key => $question)
                {
                        if (array_key_exists($key, $answers))
                        {
                                $resultset["answers"][$key] = $answers[$key];
                        }
                        else
                        {
                                $resultset["answers"][$key] = array();
                        }
                        sort($resultset["answers"][$key]);
                }
                return $resultset;
        }
        
        function getCumulatedResults(&$question)
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT finished_id FROM svy_finished WHERE survey_fi = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );
                $nr_of_users = $result->numRows();
                
                $result_array =& $question->getCumulatedResults($this->getSurveyId(), $nr_of_users);
                return $result_array;
        }

        function _getNrOfParticipants($survey_id)
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT finished_id FROM svy_finished WHERE survey_fi = %s",
                        array('integer'),
                        array($survey_id)
                );
                return $result->numRows();
        }

        function &getQuestions($question_ids)
        {
                global $ilDB;
                
                $result_array = array();
                $result = $ilDB->query("SELECT svy_question.*, svy_qtype.type_tag FROM svy_question, svy_qtype WHERE ".
                        "svy_question.questiontype_fi = svy_qtype.questiontype_id AND svy_question.tstamp > 0 AND ".
                        $ilDB->in('svy_question.question_id', $question_ids, false, 'integer'));
                while ($row = $ilDB->fetchAssoc($result))
                {
                        array_push($result_array, $row);
                }
                return $result_array;
        }
        
        function getQuestionsTable($arrFilter)
        {
                global $ilUser;
                global $ilDB;
                $where = "";
                if (is_array($arrFilter))
                {
                        if (array_key_exists('title', $arrFilter) && strlen($arrFilter['title']))
                        {
                                $where .= " AND " . $ilDB->like('svy_question.title', 'text', "%%" . $arrFilter['title'] . "%%");
                        }
                        if (array_key_exists('description', $arrFilter) && strlen($arrFilter['description']))
                        {
                                $where .= " AND " . $ilDB->like('svy_question.description', 'text', "%%" . $arrFilter['description'] . "%%");
                        }
                        if (array_key_exists('author', $arrFilter) && strlen($arrFilter['author']))
                        {
                                $where .= " AND " . $ilDB->like('svy_question.author', 'text', "%%" . $arrFilter['author'] . "%%");
                        }
                        if (array_key_exists('type', $arrFilter) && strlen($arrFilter['type']))
                        {
                                $where .= " AND svy_qtype.type_tag = " . $ilDB->quote($arrFilter['type'], 'text');
                        }
                        if (array_key_exists('spl', $arrFilter) && strlen($arrFilter['spl']))
                        {
                                $where .= " AND svy_question.obj_fi = " . $ilDB->quote($arrFilter['spl'], 'integer');
                        }               
                }
                
                $spls =& $this->getAvailableQuestionpools($use_obj_id = TRUE, $could_be_offline = FALSE, $showPath = FALSE);
                $forbidden = "";
                $forbidden = " AND " . $ilDB->in('svy_question.obj_fi', array_keys($spls), false, 'integer');
                $forbidden .= " AND svy_question.complete = " . $ilDB->quote("1", 'text');
                $existing = "";
                $existing_questions =& $this->getExistingQuestions();
                if (count($existing_questions))
                {
                        $existing = " AND " . $ilDB->in('svy_question.question_id', $existing_questions, true, 'integer');
                }
                
                include_once "./Modules/SurveyQuestionPool/classes/class.ilObjSurveyQuestionPool.php";
                $trans = ilObjSurveyQuestionPool::_getQuestionTypeTranslations();
                
                $query_result = $ilDB->query("SELECT svy_question.*, svy_qtype.type_tag, svy_qtype.plugin, object_reference.ref_id".
                        " FROM svy_question, svy_qtype, object_reference".
                        " WHERE svy_question.original_id IS NULL".$forbidden.$existing.
                        " AND svy_question.obj_fi = object_reference.obj_id AND svy_question.tstamp > 0".
                        " AND svy_question.questiontype_fi = svy_qtype.questiontype_id " . $where);

                $rows = array();
                if ($query_result->numRows())
                {
                        while ($row = $ilDB->fetchAssoc($query_result))
                        {
                                if (array_key_exists('spl_txt', $arrFilter) && strlen($arrFilter['spl_txt']))
                                {
                                        if(!stristr($spls[$row["obj_fi"]], $arrFilter['spl_txt']))
                                        {
                                                continue;
                                        }
                                }
                                
                                $row['ttype'] = $trans[$row['type_tag']];
                                if ($row["plugin"])
                                {
                                        if ($this->isPluginActive($row["type_tag"]))
                                        {
                                                array_push($rows, $row);
                                        }
                                }
                                else
                                {
                                        array_push($rows, $row);
                                }
                        }
                }
                return $rows;
        }

        function getQuestionblocksTable($arrFilter)
        {
                global $ilUser, $ilDB;
                
                $where = "";
                if (is_array($arrFilter))
                {
                        if (array_key_exists('title', $arrFilter) && strlen($arrFilter['title']))
                        {
                                $where .= " AND " . $ilDB->like('svy_qblk.title', 'text', "%%" . $arrFilter['title'] . "%%");
                        }
                }
  
                $query_result = $ilDB->query("SELECT svy_qblk.*, svy_svy.obj_fi FROM svy_qblk , svy_qblk_qst, svy_svy WHERE ".
                        "svy_qblk.questionblock_id = svy_qblk_qst.questionblock_fi AND svy_svy.survey_id = svy_qblk_qst.survey_fi ".
                        "$where GROUP BY svy_qblk.questionblock_id, svy_qblk.title, svy_qblk.show_questiontext,  svy_qblk.show_blocktitle, ".
                        "svy_qblk.owner_fi, svy_qblk.tstamp, svy_svy.obj_fi");
                $rows = array();
                if ($query_result->numRows())
                {
                        $survey_ref_ids = ilUtil::_getObjectsByOperations("svy", "write");
                        $surveytitles = array();
                        foreach ($survey_ref_ids as $survey_ref_id)
                        {
                                $survey_id = ilObject::_lookupObjId($survey_ref_id);
                                $surveytitles[$survey_id] = ilObject::_lookupTitle($survey_id);                         
                        }
                        while ($row = $ilDB->fetchAssoc($query_result))
                        {
                                $questions_array =& $this->getQuestionblockQuestions($row["questionblock_id"]);
                                $counter = 1;
                                foreach ($questions_array as $key => $value)
                                {
                                        $questions_array[$key] = "$counter. $value";
                                        $counter++;
                                }
                                if (strlen($surveytitles[$row["obj_fi"]])) // only questionpools which are not in trash
                                {
                                        $rows[$row["questionblock_id"]] = array(
                                                "questionblock_id" => $row["questionblock_id"],
                                                "title" => $row["title"], 
                                                "svy" => $surveytitles[$row["obj_fi"]], 
                                                "contains" => join($questions_array, ", "),
                                                "owner" => $row["owner_fi"]
                                        );
                                }
                        }
                }
                return $rows;
        }

        function toXML()
        {
                include_once("./Services/Xml/classes/class.ilXmlWriter.php");
                $a_xml_writer = new ilXmlWriter;
                // set xml header
                $a_xml_writer->xmlHeader();
                $attrs = array(
                        "xmlns:xsi" => "http://www.w3.org/2001/XMLSchema-instance",
                        "xsi:noNamespaceSchemaLocation" => "http://www.ilias.de/download/xsd/ilias_survey_4_2.xsd"
                );
                $a_xml_writer->xmlStartTag("surveyobject", $attrs);
                $attrs = array(
                        "id" => $this->getSurveyId(),
                        "title" => $this->getTitle()
                );
                $a_xml_writer->xmlStartTag("survey", $attrs);
                
                $a_xml_writer->xmlElement("description", NULL, $this->getDescription());
                $a_xml_writer->xmlElement("author", NULL, $this->getAuthor());
                $a_xml_writer->xmlStartTag("objectives");
                $attrs = array(
                        "label" => "introduction"
                );
                $this->addMaterialTag($a_xml_writer, $this->getIntroduction(), TRUE, TRUE, $attrs);
                $attrs = array(
                        "label" => "outro"
                );
                $this->addMaterialTag($a_xml_writer, $this->getOutro(), TRUE, TRUE, $attrs);
                $a_xml_writer->xmlEndTag("objectives");

                if ($this->getAnonymize())
                {
                        $attribs = array("enabled" => "1");
                }
                else
                {
                        $attribs = array("enabled" => "0");
                }
                $a_xml_writer->xmlElement("anonymisation", $attribs);
                $a_xml_writer->xmlStartTag("restrictions");
                if ($this->getAnonymize() == 2)
                {
                        $attribs = array("type" => "free");
                }
                else
                {
                        $attribs = array("type" => "restricted");
                }
                $a_xml_writer->xmlElement("access", $attribs);
                if ($this->getStartDateEnabled())
                {
                        $attrs = array("type" => "date");
                        $a_xml_writer->xmlElement("startingtime", $attrs, sprintf("%04d-%02d-%02dT%02d:%02d:00", $this->getStartYear(), $this->getStartMonth(), $this->getStartDay(), $this->getStartHour(), $this->getStartMinute()));
                }
                if ($this->getEndDateEnabled())
                {
                        $attrs = array("type" => "date");
                        $a_xml_writer->xmlElement("endingtime", $attrs, sprintf("%04d-%02d-%02dT%02d:%02d:00", $this->getEndYear(), $this->getEndMonth(), $this->getEndDay(), $this->getEndHour(), $this->getEndMinute()));
                }
                $a_xml_writer->xmlEndTag("restrictions");
                
                // constraints
                $pages =& $this->getSurveyPages();
                $hasconstraints = FALSE;
                foreach ($pages as $question_array)
                {
                        foreach ($question_array as $question)
                        {
                                if (count($question["constraints"]))
                                {
                                        $hasconstraints = TRUE;
                                }
                        }
                }
                
                if ($hasconstraints)
                {
                        $a_xml_writer->xmlStartTag("constraints");
                        foreach ($pages as $question_array)
                        {
                                foreach ($question_array as $question)
                                {
                                        if (count($question["constraints"]))
                                        {
                                                // found constraints
                                                foreach ($question["constraints"] as $constraint)
                                                {                                                       
                                                        $attribs = array(
                                                                "sourceref" => $question["question_id"],
                                                                "destref" => $constraint["question"],
                                                                "relation" => $constraint["short"],
                                                                "value" => $constraint["value"],
                                                                "conjunction" => $constraint["conjunction"]
                                                        );
                                                        $a_xml_writer->xmlElement("constraint", $attribs);
                                                }
                                        }
                                }
                        }
                        $a_xml_writer->xmlEndTag("constraints");
                }
                
                // add the rest of the preferences in qtimetadata tags, because there is no correspondent definition in QTI
                $a_xml_writer->xmlStartTag("metadata");

                $a_xml_writer->xmlStartTag("metadatafield");
                $a_xml_writer->xmlElement("fieldlabel", NULL, "evaluation_access");
                $a_xml_writer->xmlElement("fieldentry", NULL, $this->getEvaluationAccess());
                $a_xml_writer->xmlEndTag("metadatafield");

                $a_xml_writer->xmlStartTag("metadatafield");
                $a_xml_writer->xmlElement("fieldlabel", NULL, "status");
                $a_xml_writer->xmlElement("fieldentry", NULL, $this->getStatus());
                $a_xml_writer->xmlEndTag("metadatafield");

                $a_xml_writer->xmlStartTag("metadatafield");
                $a_xml_writer->xmlElement("fieldlabel", NULL, "display_question_titles");
                $a_xml_writer->xmlElement("fieldentry", NULL, $this->getShowQuestionTitles());
                $a_xml_writer->xmlEndTag("metadatafield");

                $a_xml_writer->xmlStartTag("metadatafield");
                $a_xml_writer->xmlElement("fieldlabel", NULL, "SCORM");
                include_once "./Services/MetaData/classes/class.ilMD.php";
                $md = new ilMD($this->getId(),0, $this->getType());
                $writer = new ilXmlWriter();
                $md->toXml($writer);
                $metadata = $writer->xmlDumpMem();
                $a_xml_writer->xmlElement("fieldentry", NULL, $metadata);
                $a_xml_writer->xmlEndTag("metadatafield");

                $a_xml_writer->xmlEndTag("metadata");
                $a_xml_writer->xmlEndTag("survey");

                $attribs = array("id" => $this->getId());
                $a_xml_writer->xmlStartTag("surveyquestions", $attribs);
                // add questionblock descriptions
                $obligatory_states =& $this->getObligatoryStates();
                foreach ($pages as $question_array)
                {
                        if (count($question_array) > 1)
                        {
                                $attribs = array("id" => $question_array[0]["question_id"]);
                                $attribs = array("showQuestiontext" => $question_array[0]["questionblock_show_questiontext"],
                                        "showBlocktitle" => $question_array[0]["questionblock_show_blocktitle"]);
                                $a_xml_writer->xmlStartTag("questionblock", $attribs);
                                if (strlen($question_array[0]["questionblock_title"]))
                                {
                                        $a_xml_writer->xmlElement("questionblocktitle", NULL, $question_array[0]["questionblock_title"]);
                                }
                        }
                        foreach ($question_array as $question)
                        {
                                if (strlen($question["heading"]))
                                {
                                        $a_xml_writer->xmlElement("textblock", NULL, $question["heading"]);
                                }
                                $questionObject =& $this->_instanciateQuestion($question["question_id"]);
                                if ($questionObject !== FALSE) $questionObject->insertXML($a_xml_writer, FALSE, $obligatory_states[$question["question_id"]]);
                        }
                        if (count($question_array) > 1)
                        {
                                $a_xml_writer->xmlEndTag("questionblock");
                        }
                }

                $a_xml_writer->xmlEndTag("surveyquestions");
                $a_xml_writer->xmlEndTag("surveyobject");
                $xml = $a_xml_writer->xmlDumpMem(FALSE);
                return $xml;
        }
        
  function &_instanciateQuestion($question_id) 
        {
                if ($question_id < 1) return FALSE;
                include_once "./Modules/SurveyQuestionPool/classes/class.SurveyQuestion.php";
                $question_type = SurveyQuestion::_getQuestionType($question_id);
                if (strlen($question_type) == 0) return FALSE;
                SurveyQuestion::_includeClass($question_type);
                $question = new $question_type();
                $question->loadFromDb($question_id);
                return $question;
  }

        function locateImportFiles($a_dir)
        {
                if (!is_dir($a_dir) || is_int(strpos($a_dir, "..")))
                {
                        return;
                }
                $importDirectory = "";
                $xmlFile = "";

                $current_dir = opendir($a_dir);
                $files = array();
                while($entryname = readdir($current_dir))
                {
                        $files[] = $entryname;
                }

                foreach($files as $file)
                {
                        if(is_dir($a_dir."/".$file) and ($file != "." and $file!=".."))
                        {
                                // found directory created by zip
                                $importDirectory = $a_dir."/".$file;
                        }
                }
                closedir($current_dir);
                if (strlen($importDirectory))
                {
                        // find the xml file
                        $current_dir = opendir($importDirectory);
                        $files = array();
                        while($entryname = readdir($current_dir))
                        {
                                $files[] = $entryname;
                        }
                        foreach($files as $file)
                        {
                                if(@is_file($importDirectory."/".$file) && ($file != "." && $file!="..") && (ereg("^[0-9]{10}_{2}[0-9]+_{2}(svy_)*[0-9]+\.[a-z]{1,3}\$", $file) || ereg("^[0-9]{10}_{2}[0-9]+_{2}(survey__)*[0-9]+\.[a-z]{1,3}\$", $file)))
                                {
                                        // found xml file
                                        $xmlFile = $importDirectory."/".$file;
                                }
                        }
                }
                return array("dir" => $importDirectory, "xml" => $xmlFile);
        }

        function importObject($file_info, $svy_qpl_id)
        {
                if ($svy_qpl_id < 1) $svy_qpl_id = -1;
                // check if file was uploaded
                $source = $file_info["tmp_name"];
                $error = "";
                if (($source == 'none') || (!$source) || $file_info["error"] > UPLOAD_ERR_OK)
                {
                        $error = $this->lng->txt("import_no_file_selected");
                }
                // check correct file type
                $isXml = FALSE;
                $isZip = FALSE;
                if ((strcmp($file_info["type"], "text/xml") == 0) || (strcmp($file_info["type"], "application/xml") == 0))
                {
                        $isXml = TRUE;
                }
                // too many different mime-types, so we use the suffix
                $suffix = pathinfo($file_info["name"]);
                if (strcmp(strtolower($suffix["extension"]), "zip") == 0)
                {
                        $isZip = TRUE;
                }
                if (!$isXml && !$isZip)
                {
                        $error = $this->lng->txt("import_wrong_file_type");
                        global $ilLog;
                        $ilLog->write("Survey: Import error. Filetype was \"" . $file_info["type"] ."\"");
                }
                if (strlen($error) == 0)
                {
                        // import file as a survey
                        $import_dir = $this->getImportDirectory();
                        $import_subdir = "";
                        $importfile = "";
                        include_once "./Services/Utilities/classes/class.ilUtil.php";
                        if ($isZip)
                        {
                                $importfile = $import_dir."/".$file_info["name"];
                                ilUtil::moveUploadedFile($source, $file_info["name"], $importfile);
                                ilUtil::unzip($importfile);
                                $found = $this->locateImportFiles($import_dir);
                                if (!((strlen($found["dir"]) > 0) && (strlen($found["xml"]) > 0)))
                                {
                                        $error = $this->lng->txt("wrong_import_file_structure");
                                        return $error;
                                }
                                $importfile = $found["xml"];
                                $import_subdir = $found["dir"];
                        }
                        else
                        {
                                $importfile = tempnam($import_dir, "survey_import");
                                ilUtil::moveUploadedFile($source, $file_info["name"], $importfile);
                        }
                        $fh = fopen($importfile, "r");
                        if (!$fh)
                        {
                                $error = $this->lng->txt("import_error_opening_file");
                                return $error;
                        }
                        $xml = fread($fh, filesize($importfile));
                        $result = fclose($fh);
                        if (!$result)
                        {
                                $error = $this->lng->txt("import_error_closing_file");
                                return $error;
                        }

                        unset($_SESSION["import_mob_xhtml"]);
                        if (strpos($xml, "questestinterop"))
                        {
                                include_once "./Services/Survey/classes/class.SurveyImportParserPre38.php";
                                $import = new SurveyImportParserPre38($svy_qpl_id, "", TRUE);
                                $import->setSurveyObject($this);
                                $import->setXMLContent($xml);
                                $import->startParsing();
                        }
                        else
                        {
                                include_once "./Services/Survey/classes/class.SurveyImportParser.php";
                                $import = new SurveyImportParser($svy_qpl_id, "", TRUE);
                                $import->setSurveyObject($this);
                                $import->setXMLContent($xml);
                                $import->startParsing();
                        }

                        if (is_array($_SESSION["import_mob_xhtml"]))
                        {
                                include_once "./Services/MediaObjects/classes/class.ilObjMediaObject.php";
                                include_once "./Services/RTE/classes/class.ilRTE.php";
                                include_once "./Modules/TestQuestionPool/classes/class.ilObjQuestionPool.php";
                                foreach ($_SESSION["import_mob_xhtml"] as $mob)
                                {
                                        $importfile = $import_subdir . "/" . $mob["uri"];
                                        if (file_exists($importfile))
                                        {
                                                $media_object =& ilObjMediaObject::_saveTempFileAsMediaObject(basename($importfile), $importfile, FALSE);
                                                ilObjMediaObject::_saveUsage($media_object->getId(), "svy:html", $this->getId());
                                                $this->setIntroduction(str_replace("src=\"" . $mob["mob"] . "\"", "src=\"" . "il_" . IL_INST_ID . "_mob_" . $media_object->getId() . "\"", $this->getIntroduction()));
                                                $this->setOutro(str_replace("src=\"" . $mob["mob"] . "\"", "src=\"" . "il_" . IL_INST_ID . "_mob_" . $media_object->getId() . "\"", $this->getOutro()));
                                        }
                                        else
                                        {
                                                global $ilLog;
                                                $ilLog->write("Error: Could not open XHTML mob file for test introduction during test import. File $importfile does not exist!");
                                        }
                                }
                                $this->setIntroduction(ilRTE::_replaceMediaObjectImageSrc($this->getIntroduction(), 1));
                                $this->setOutro(ilRTE::_replaceMediaObjectImageSrc($this->getOutro(), 1));
                                $this->saveToDb();
                        }

                        // delete import directory
                        ilUtil::delDir($this->getImportDirectory());
                }
                return $error;
        }

        public function cloneObject($a_target_id,$a_copy_id = 0)
        {
                global $ilDB;
                
                $this->loadFromDb();
                
                // Copy settings
                $newObj = parent::cloneObject($a_target_id,$a_copy_id);
                $this->cloneMetaData($newObj);
                $newObj->updateMetaData();              
                
                $newObj->setAuthor($this->getAuthor());
                $newObj->setIntroduction($this->getIntroduction());
                $newObj->setOutro($this->getOutro());
                $newObj->setStatus($this->getStatus());
                $newObj->setEvaluationAccess($this->getEvaluationAccess());
                $newObj->setStartDate($this->getStartDate());
                $newObj->setStartDateEnabled($this->getStartDateEnabled());
                $newObj->setEndDate($this->getEndDate());
                $newObj->setEndDateEnabled($this->getEndDateEnabled());
                $newObj->setInvitation($this->getInvitation());
                $newObj->setInvitationMode($this->getInvitationMode());
                $newObj->setAnonymize($this->getAnonymize());
                $newObj->setShowQuestionTitles($this->getShowQuestionTitles());
                $newObj->setTemplate($this->getTemplate());


                $question_pointer = array();
                // clone the questions
                $mapping = array();
                include_once "./Modules/SurveyQuestionPool/classes/class.SurveyQuestion.php";
                foreach ($this->questions as $key => $question_id)
                {
                        $question = ilObjSurvey::_instanciateQuestion($question_id);
                        if($question) // #10824
                        {
                                $question->id = -1;
                                $original_id = SurveyQuestion::_getOriginalId($question_id);
                                $question->saveToDb($original_id);
                                $newObj->questions[$key] = $question->getId();
                                $question_pointer[$question_id] = $question->getId();
                                $mapping[$question_id] = $question->getId();
                        }
                }

                $newObj->saveToDb();            
                $newObj->cloneTextblocks($mapping);

                // clone the questionblocks
                $questionblocks = array();
                $questionblock_questions = array();
                $result = $ilDB->queryF("SELECT * FROM svy_qblk_qst WHERE survey_fi = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );
                if ($result->numRows() > 0)
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                array_push($questionblock_questions, $row);
                                $questionblocks[$row["questionblock_fi"]] = $row["questionblock_fi"];
                        }
                }
                // create new questionblocks
                foreach ($questionblocks as $key => $value)
                {
                        $questionblock = ilObjSurvey::_getQuestionblock($key);
                        $questionblock_id = ilObjSurvey::_addQuestionblock($questionblock["title"], $questionblock["owner_fi"]);
                        $questionblocks[$key] = $questionblock_id;
                }
                // create new questionblock questions
                foreach ($questionblock_questions as $key => $value)
                {
                        if($questionblocks[$value["questionblock_fi"]] &&
                                $question_pointer[$value["question_fi"]])
                        {
                                $next_id = $ilDB->nextId('svy_qblk_qst');
                                $affectedRows = $ilDB->manipulateF("INSERT INTO svy_qblk_qst (qblk_qst_id, survey_fi, questionblock_fi, question_fi) ".
                                        "VALUES (%s, %s, %s, %s)",
                                        array('integer','integer','integer','integer'),
                                        array($next_id, $newObj->getSurveyId(), $questionblocks[$value["questionblock_fi"]], $question_pointer[$value["question_fi"]])
                                );
                        }
                }
                
                // clone the constraints
                $constraints = ilObjSurvey::_getConstraints($this->getSurveyId());
                $newConstraints = array();
                foreach ($constraints as $key => $constraint)
                {
                        if ($question_pointer[$constraint["for_question"]] &&
                                $question_pointer[$constraint["question"]])
                        {
                                if (!array_key_exists($constraint['id'], $newConstraints))
                                {
                                        $constraint_id = $newObj->addConstraint($question_pointer[$constraint["question"]], $constraint["relation_id"], $constraint["value"], $constraint['conjunction']);
                                        $newConstraints[$constraint['id']] = $constraint_id;
                                }
                                $newObj->addConstraintToQuestion($question_pointer[$constraint["for_question"]], $newConstraints[$constraint['id']]);
                        }
                }
                
                // clone the obligatory states
                $result = $ilDB->queryF("SELECT * FROM svy_qst_oblig WHERE survey_fi = %s",
                        array('integer'),
                        array($this->getSurveyId())
                );
                if ($result->numRows() > 0)
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                if($question_pointer[$row["question_fi"]])
                                {
                                        $next_id = $ilDB->nextId('svy_qst_oblig');
                                        $affectedRows = $ilDB->manipulateF("INSERT INTO svy_qst_oblig (question_obligatory_id, survey_fi, question_fi, ".
                                                "obligatory, tstamp) VALUES (%s, %s, %s, %s, %s)",
                                                array('integer','integer','integer','text','integer'),
                                                array($next_id, $newObj->getSurveyId(), $question_pointer[$row["question_fi"]], $row["obligatory"], time())
                                        );
                                }
                        }
                }
                return $newObj;
        }
        
        function getTextblock($question_id)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT * FROM svy_svy_qst WHERE question_fi = %s",
                        array('integer'),
                        array($question_id)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["heading"];
                }
                else
                {
                        return "";
                }
        }

        function cloneTextblocks($mapping)
        {
                foreach ($mapping as $original_id => $new_id)
                {
                        $textblock = $this->getTextblock($original_id);
                        include_once "./Services/AdvancedEditing/classes/class.ilObjAdvancedEditing.php";
                        $this->saveHeading(ilUtil::stripSlashes($textblock, TRUE, ilObjAdvancedEditing::_getUsedHTMLTagsAsString("survey")), $new_id);
                }
        }

        function createExportDirectory()
        {
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                $svy_data_dir = ilUtil::getDataDir()."/svy_data";
                ilUtil::makeDir($svy_data_dir);
                if(!is_writable($svy_data_dir))
                {
                        $this->ilias->raiseError("Survey Data Directory (".$svy_data_dir
                                .") not writeable.",$this->ilias->error_obj->FATAL);
                }
                
                // create learning module directory (data_dir/lm_data/lm_<id>)
                $svy_dir = $svy_data_dir."/svy_".$this->getId();
                ilUtil::makeDir($svy_dir);
                if(!@is_dir($svy_dir))
                {
                        $this->ilias->raiseError("Creation of Survey Directory failed.",$this->ilias->error_obj->FATAL);
                }
                // create Export subdirectory (data_dir/lm_data/lm_<id>/Export)
                $export_dir = $svy_dir."/export";
                ilUtil::makeDir($export_dir);
                if(!@is_dir($export_dir))
                {
                        $this->ilias->raiseError("Creation of Export Directory failed.",$this->ilias->error_obj->FATAL);
                }
        }

        function getExportDirectory()
        {
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                $export_dir = ilUtil::getDataDir()."/svy_data"."/svy_".$this->getId()."/export";

                return $export_dir;
        }
        
        function getExportFiles($dir)
        {
                // quit if import dir not available
                if (!@is_dir($dir) or
                        !is_writeable($dir))
                {
                        return array();
                }

                // open directory
                $dir = dir($dir);

                // initialize array
                $file = array();

                // get files and save the in the array
                while ($entry = $dir->read())
                {
                        if ($entry != "." && $entry != ".." && ereg("^[0-9]{10}_{2}[0-9]+_{2}(svy_)*[0-9]+\.[a-z]{1,3}\$", $entry))
                        {
                                $file[] = $entry;
                        }
                }

                // close import directory
                $dir->close();
                // sort files
                sort ($file);
                reset ($file);

                return $file;
        }

        function createImportDirectory()
        {
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                $svy_data_dir = ilUtil::getDataDir()."/svy_data";
                ilUtil::makeDir($svy_data_dir);
                
                if(!is_writable($svy_data_dir))
                {
                        $this->ilias->raiseError("Survey Data Directory (".$svy_data_dir
                                .") not writeable.",$this->ilias->error_obj->FATAL);
                }

                // create test directory (data_dir/svy_data/svy_<id>)
                $svy_dir = $svy_data_dir."/svy_".$this->getId();
                ilUtil::makeDir($svy_dir);
                if(!@is_dir($svy_dir))
                {
                        $this->ilias->raiseError("Creation of Survey Directory failed.",$this->ilias->error_obj->FATAL);
                }

                // create import subdirectory (data_dir/svy_data/svy_<id>/import)
                $import_dir = $svy_dir."/import";
                ilUtil::makeDir($import_dir);
                if(!@is_dir($import_dir))
                {
                        $this->ilias->raiseError("Creation of Import Directory failed.",$this->ilias->error_obj->FATAL);
                }
        }

        function getImportDirectory()
        {
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                $import_dir = ilUtil::getDataDir()."/svy_data".
                        "/svy_".$this->getId()."/import";
                if (!is_dir($import_dir))
                {
                        ilUtil::makeDirParents($import_dir);
                }
                if(@is_dir($import_dir))
                {
                        return $import_dir;
                }
                else
                {
                        return false;
                }
        }
        
        function saveHeading($heading = "", $insertbefore)
        {
                global $ilDB;
                if ($heading)
                {
                        $affectedRows = $ilDB->manipulateF("UPDATE svy_svy_qst SET heading=%s WHERE survey_fi=%s AND question_fi=%s",
                                array('text','integer','integer'),
                                array($heading, $this->getSurveyId(), $insertbefore)
                        );
                }
                else
                {
                        $affectedRows = $ilDB->manipulateF("UPDATE svy_svy_qst SET heading=%s WHERE survey_fi=%s AND question_fi=%s",
                                array('text','integer','integer'),
                                array(NULL, $this->getSurveyId(), $insertbefore)
                        );
                }
        }

        function isAnonymousKey($key)
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT anonymous_id FROM svy_anonymous WHERE survey_key = %s AND survey_fi = %s",
                        array('text','integer'),
                        array($key, $this->getSurveyId())
                );
                return ($result->numRows() == 1) ? true : false;
        }
        
        function getUserSurveyCode($user_id)
        {
                global $ilDB;
                
                if (($user_id == ANONYMOUS_USER_ID) || (($this->isAccessibleWithoutCode() && $this->isAllowedToTakeMultipleSurveys()))) return "";
                $result = $ilDB->queryF("SELECT anonymous_id FROM svy_finished WHERE survey_fi = %s AND user_fi = %s",
                        array('integer','integer'),
                        array($this->getSurveyId(), $user_id)
                );
                if ($result->numRows() == 1)
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["anonymous_id"];
                }
                else
                {
                        return "";
                }
        }
        
        function isAnonymizedParticipant($key)
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT finished_id FROM svy_finished WHERE anonymous_id = %s AND survey_fi = %s",
                        array('text','integer'),
                        array($key, $this->getSurveyId())
                );
                return ($result->numRows() == 1) ? true : false;
        }
        
        function checkSurveyCode($code)
        {
                if ($this->isAnonymousKey($code))
                {
                        if ($this->isSurveyStarted("", $code) == 1)
                        {
                                return false;
                        }
                        else
                        {
                                return true;
                        }
                }
                else
                {
                        return false;
                }
        }

        function getSurveyCodesCount()
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT anonymous_id FROM svy_anonymous WHERE survey_fi = %s AND user_key IS NULL",
                        array('integer'),
                        array($this->getSurveyId())
                );
                return $result->numRows();
        }
        
        function getSurveyCodesForExport($a_array)
        {
                global $ilDB, $ilUser;

                $result = $ilDB->queryF("SELECT svy_anonymous.*, svy_finished.state FROM svy_anonymous ".
                        "LEFT JOIN svy_finished ON svy_anonymous.survey_key = svy_finished.anonymous_id ".
                        "WHERE svy_anonymous.survey_fi = %s AND svy_anonymous.user_key IS NULL",
                        array('integer'),
                        array($this->getSurveyId())
                );
                $export = "";
                $default_lang = $ilUser->getPref("survey_code_language");
                $lang = (strlen($default_lang)) ? "&lang=" . $default_lang : "";
                while ($row = $ilDB->fetchAssoc($result))
                {
                        if (in_array($row["survey_key"], $a_array) || (count($a_array) == 0))
                        {
                                $export .= $row["survey_key"] . ",";
                                
                                // No relative (today, tomorrow...) dates in export.
                                $date = new ilDate($row['tstamp'],IL_CAL_UNIX);
                                $created = $date->get(IL_CAL_DATE);
                                $export .= "$created,";
                                if ($this->isSurveyCodeUsed($row["survey_key"]))
                                {
                                        $export .= "1,";
                                }
                                else
                                {
                                        $export .= "0,";
                                }
                                $url = ILIAS_HTTP_PATH."/goto.php?cmd=infoScreen&target=svy_".$this->getRefId() . "&client_id=" . CLIENT_ID . "&accesscode=".$row["survey_key"].$lang;
                                $export .= $url . "\n";
                        }
                }
                return $export;
        }
        
        public function &getSurveyCodesTableData($lang = "en")
        {
                global $ilDB;

                include_once "./classes/class.ilFormat.php";
                if (strlen($lang) == 0) $lang = "en";
                
                $order = "ORDER BY tstamp, survey_key ASC";
                $codes = array();
                $result = $ilDB->queryF("SELECT svy_anonymous.anonymous_id, svy_anonymous.survey_key, svy_anonymous.survey_fi, ".
                        "svy_anonymous.tstamp, svy_finished.state FROM svy_anonymous LEFT JOIN svy_finished ".
                        "ON svy_anonymous.survey_key = svy_finished.anonymous_id WHERE svy_anonymous.survey_fi = %s ".
                        "AND svy_anonymous.user_key IS NULL $order",
                        array('integer'),
                        array($this->getSurveyId())
                );
                if ($result->numRows() > 0)
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $created = ilDatePresentation::formatDate(new ilDateTime($row["tstamp"],IL_CAL_UNIX));
                                $url = "";
                                
                                $state = 0;
                                if ($this->isSurveyCodeUsed($row["survey_key"]))
                                {
                                        $state = 1;
                                }
                                else
                                {
                                        $addlang = "";
                                        if (strlen($lang))
                                        {
                                                $addlang = "&amp;lang=$lang";
                                        }
                                        $href = ILIAS_HTTP_PATH."/goto.php?cmd=infoScreen&target=svy_".$this->getRefId() . "&amp;client_id=" . CLIENT_ID . "&amp;accesscode=".$row["survey_key"].$addlang;
                                        $url = $this->lng->txt("survey_code_url_name");
                                }
                                array_push($codes, array('code' => $row["survey_key"], 'date' => $created, 'used' => $state, 'url' => $url, 'href' => $href));
                        }
                }
                return $codes;
        }

        function isSurveyCodeUsed($code)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT finished_id FROM svy_finished WHERE survey_fi = %s AND anonymous_id = %s",
                        array('integer','text'),
                        array($this->getSurveyId(), $code)
                );
                return ($result->numRows() > 0) ? true : false;
        }
        
        function isSurveyCodeUnique($code)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT anonymous_id FROM svy_anonymous WHERE survey_fi = %s AND survey_key = %s",
                        array('integer','text'),
                        array($this->getSurveyId(), $code)
                );
                return ($result->numRows() > 0) ? false : true;
        }
        
        function createSurveyCodes($nrOfCodes)
        {
                global $ilDB;
                for ($i = 0; $i < $nrOfCodes; $i++)
                {
                        $anonymize_key = $this->createNewAccessCode();
                        $next_id = $ilDB->nextId('svy_anonymous');
                        $affectedRows = $ilDB->manipulateF("INSERT INTO svy_anonymous (anonymous_id, survey_key, survey_fi, tstamp) ".
                                "VALUES (%s, %s, %s, %s)",
                                array('integer','text','integer','integer'),
                                array($next_id, $anonymize_key, $this->getSurveyId(), time())
                        );
                }
        }

        function createSurveyCodesForExternalData($data)
        {
                global $ilDB;
                foreach ($data as $dataset)
                {
                        $anonymize_key = $this->createNewAccessCode();
                        $next_id = $ilDB->nextId('svy_anonymous');
                        $affectedRows = $ilDB->manipulateF("INSERT INTO svy_anonymous (anonymous_id, survey_key, survey_fi, externaldata, tstamp) ".
                                "VALUES (%s, %s, %s, %s, %s)",
                                array('integer','text','integer','text','integer'),
                                array($next_id, $anonymize_key, $this->getSurveyId(), serialize($dataset), time())
                        );
                }
        }

        function sendCodes($not_sent, $subject, $message, $lang = "en")
        {
                /*
                 * 0 = all
                 * 1 = not sent
                 * 2 = finished
                 * 3 = not finished
                 */             
                $check_finished = ($not_sent > 1);
                
                include_once "./Services/Mail/classes/class.ilMail.php";
                $user_id = $this->getOwner();
                $mail = new ilMail($user_id);           
                $recipients = $this->getExternalCodeRecipients($check_finished);                        
                foreach ($recipients as $data)
                {                       
                        if($data['email'] && $data['code'])
                        {                               
                                $do_send = false;
                                switch ((int)$not_sent)
                                {
                                        case 1:
                                                $do_send = !(bool)$data['sent'];
                                                break;
                                        
                                        case 2:
                                                $do_send = $data['finished'];
                                                break;
                                        
                                        case 3:
                                                $do_send = !$data['finished'];
                                                break;
                                        
                                        default:
                                                $do_send = true;
                                                break;                                                                  
                                }                               
                                if ($do_send)
                                {
                                        // build text
                                        $messagetext = $message;
                                        $url = ILIAS_HTTP_PATH."/goto.php?cmd=infoScreen&target=svy_".$this->getRefId() . "&client_id=" . CLIENT_ID . "&accesscode=".$data["code"]."&lang=".$lang;
                                        $messagetext = str_replace('[url]', "<" . $url . ">", $messagetext);
                                        foreach ($data as $key => $value)
                                        {
                                                $messagetext = str_replace('[' . $key . ']', $value, $messagetext);
                                        }

                                        // send mail
                                        $mail->sendMail(
                                                $data['email'], // to
                                                "", // cc
                                                "", // bcc
                                                $subject, // subject
                                                $messagetext, // message
                                                array(), // attachments
                                                array('normal') // type
                                        );      
                                }
                        }
                }

                global $ilDB;
                $affectedRows = $ilDB->manipulateF("UPDATE svy_anonymous SET sent = %s WHERE survey_fi = %s AND externaldata IS NOT NULL",
                        array('integer','integer'),
                        array(1, $this->getSurveyId())
                );
        }

        function getExternalCodeRecipients($a_check_finished = false)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT survey_key code, externaldata, sent FROM svy_anonymous WHERE survey_fi = %s AND externaldata IS NOT NULL",
                        array('integer'),
                        array($this->getSurveyId())
                );
                $res = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $externaldata = unserialize($row['externaldata']);
                        $externaldata['code'] = $row['code'];
                        $externaldata['sent'] = $row['sent'];
                        
                        if($a_check_finished)
                        {                               
                                $externaldata['finished'] =  $this->isSurveyCodeUsed($row['code']);
                        }
                        
                        array_push($res, $externaldata);
                }
                return $res;
        }
        
        function deleteSurveyCode($survey_code)
        {
                global $ilDB;
                
                if (strlen($survey_code) > 0)
                {
                        $affectedRows = $ilDB->manipulateF("DELETE FROM svy_anonymous WHERE survey_fi = %s AND survey_key = %s",
                                array('integer', 'text'),
                                array($this->getSurveyId(), $survey_code)
                        );
                }
        }
        
        function getUserAccessCode($user_id)
        {
                global $ilDB;
                $access_code = "";
                $result = $ilDB->queryF("SELECT survey_key FROM svy_anonymous WHERE survey_fi = %s AND user_key = %s",
                        array('integer','text'),
                        array($this->getSurveyId(), md5($user_id))
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        $access_code = $row["survey_key"];
                }
                return $access_code;
        }
        
        function saveUserAccessCode($user_id, $access_code)
        {
                global $ilDB;
                $next_id = $ilDB->nextId('svy_anonymous');
                $affectedRows = $ilDB->manipulateF("INSERT INTO svy_anonymous (anonymous_id, survey_key, survey_fi, user_key, tstamp) ".
                        "VALUES (%s, %s, %s, %s, %s)",
                        array('integer','text', 'integer', 'text', 'integer'),
                        array($next_id, $access_code, $this->getSurveyId(), md5($user_id), time())
                );
        }
        
        function createNewAccessCode()
        {
                // create a 5 character code
                $codestring = "0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";
                mt_srand();
                $code = "";
                for ($i = 1; $i <=5; $i++)
                {
                        $index = mt_rand(0, strlen($codestring)-1);
                        $code .= substr($codestring, $index, 1);
                }
                // verify it against the database
                while (!$this->isSurveyCodeUnique($code))
                {
                        $code = $this->createNewAccessCode();
                }
                return $code;
        }
        

        function &processCSVRow($row, $quoteAll = FALSE, $separator = ";")
        {
                $resultarray = array();
                foreach ($row as $rowindex => $entry)
                {
                        if(is_array($entry))
                        {
                                $entry = implode("/", $entry);
                        }                       
                        $surround = FALSE;
                        if ($quoteAll)
                        {
                                $surround = TRUE;
                        }
                        if (strpos($entry, "\"") !== FALSE)
                        {
                                $entry = str_replace("\"", "\"\"", $entry);
                                $surround = TRUE;
                        }
                        if (strpos($entry, $separator) !== FALSE)
                        {
                                $surround = TRUE;
                        }
                        // replace all CR LF with LF (for Excel for Windows compatibility
                        $entry = str_replace(chr(13).chr(10), chr(10), $entry);
                        if ($surround)
                        {
                                $resultarray[$rowindex] = utf8_decode("\"" . $entry . "\"");
                        }
                        else
                        {
                                $resultarray[$rowindex] = utf8_decode($entry);
                        }
                }
                return $resultarray;
        }

        function _getLastAccess($finished_id)
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT tstamp FROM svy_answer WHERE active_fi = %s ORDER BY tstamp DESC",
                        array('integer'),
                        array($finished_id)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["tstamp"];
                }
                else
                {
                        $result = $ilDB->queryF("SELECT tstamp FROM svy_finished WHERE finished_id = %s",
                                array('integer'),
                                array($finished_id)
                        );
                        if ($result->numRows())
                        {
                                $row = $ilDB->fetchAssoc($result);
                                return $row["tstamp"];
                        }
                }
                return "";
        }

        function prepareTextareaOutput($txt_output)
        {
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                return ilUtil::prepareTextareaOutput($txt_output, $prepare_for_latex_output);
        }

        function isHTML($a_text)
        {
                if (preg_match("/<[^>]*?>/", $a_text))
                {
                        return TRUE;
                }
                else
                {
                        return FALSE; 
                }
        }

        function addMaterialTag(&$a_xml_writer, $a_material, $close_material_tag = TRUE, $add_mobs = TRUE, $attribs = NULL)
        {
                include_once "./Services/RTE/classes/class.ilRTE.php";
                include_once("./Services/MediaObjects/classes/class.ilObjMediaObject.php");

                $a_xml_writer->xmlStartTag("material", $attribs);
                $attrs = array(
                        "type" => "text/plain"
                );
                if ($this->isHTML($a_material))
                {
                        $attrs["type"] = "text/xhtml";
                }
                $mattext = ilRTE::_replaceMediaObjectImageSrc($a_material, 0);
                $a_xml_writer->xmlElement("mattext", $attrs, $mattext);

                if ($add_mobs)
                {
                        $mobs = ilObjMediaObject::_getMobsOfObject("svy:html", $this->getId());
                        foreach ($mobs as $mob)
                        {
                                $mob_id = "il_" . IL_INST_ID . "_mob_" . $mob;
                                if (strpos($mattext, $mob_id) !== FALSE)
                                {
                                        $mob_obj =& new ilObjMediaObject($mob);
                                        $imgattrs = array(
                                                "label" => $mob_id,
                                                "uri" => "objects/" . "il_" . IL_INST_ID . "_mob_" . $mob . "/" . $mob_obj->getTitle()
                                        );
                                        $a_xml_writer->xmlElement("matimage", $imgattrs, NULL);
                                }
                        }
                }               
                if ($close_material_tag) $a_xml_writer->xmlEndTag("material");
        }

        function canExportSurveyCode()
        {
                if ($this->getAnonymize() != ANONYMIZE_OFF)
                {
                        if ($this->surveyCodeSecurity == FALSE)
                        {
                                return TRUE;
                        }
                }
                return FALSE;
        }

        function processPrintoutput2FO($print_output)
        {
                $print_output = str_replace("&nbsp;", "&#160;", $print_output);
                $print_output = str_replace("&otimes;", "X", $print_output);
                $xsl = file_get_contents("./Modules/Survey/xml/question2fo.xsl");
                $args = array( '/_xml' => $print_output, '/_xsl' => $xsl );
                $xh = xslt_create();
                $params = array();
                $output = xslt_process($xh, "arg:/_xml", "arg:/_xsl", NULL, $args, $params);
                xslt_error($xh);
                xslt_free($xh);
                global $ilLog; $ilLog->write($output);
                return $output;
        }
        
        function deliverPDFfromFO($fo)
        {
                global $ilLog;

                include_once "./Services/Utilities/classes/class.ilUtil.php";
                $fo_file = ilUtil::ilTempnam() . ".fo";
                $fp = fopen($fo_file, "w"); fwrite($fp, $fo); fclose($fp);

                include_once './Services/WebServices/RPC/classes/class.ilRpcClientFactory.php';
                try
                {
                        $pdf_base64 = ilRpcClientFactory::factory('RPCTransformationHandler')->ilFO2PDF($fo);
                        ilUtil::deliverData($pdf_base64->scalar, ilUtil::getASCIIFilename($this->getTitle()) . ".pdf", "application/pdf");
                        return true;
                }
                catch(XML_RPC2_FaultException $e)
                {
                        $ilLog->write(__METHOD__.': '.$e->getMessage());
                        return false;
                }
                catch(Exception $e)
                {
                        $ilLog->write(__METHOD__.': '.$e->getMessage());
                        return false;
                }

                /*
                include_once "./Services/Transformation/classes/class.ilFO2PDF.php";
                $fo2pdf = new ilFO2PDF();
                $fo2pdf->setFOString($fo);
                $result = $fo2pdf->send();
                ilUtil::deliverData($result, ilUtil::getASCIIFilename($this->getTitle()) . ".pdf", "application/pdf");
                */
        }
        
        function _checkCondition($a_svy_id,$a_operator,$a_value,$a_usr_id = 0)
        {
                global $ilUser;
                
                $a_usr_id = $a_usr_id ? $a_usr_id : $ilUser->getId();

                switch($a_operator)
                {
                        case 'finished':
                                //if (ilExerciseMembers::_lookupStatus($a_exc_id, $ilias->account->getId()) == "passed")
                                include_once("./Modules/Survey/classes/class.ilObjSurveyAccess.php");
                                if (ilObjSurveyAccess::_lookupFinished($a_svy_id, $a_usr_id))
                                {
                                        return true;
                                }
                                else
                                {
                                        return false;
                                }
                                break;

                        default:
                                return true;
                }
                return true;
        }

        function isPluginActive($a_pname)
        {
                global $ilPluginAdmin;
                if ($ilPluginAdmin->isActive(IL_COMP_MODULE, "SurveyQuestionPool", "svyq", $a_pname))
                {
                        return TRUE;
                }
                else
                {
                        return FALSE;
                }
        }
        
        public function setSurveyId($survey_id)
        {
                $this->survey_id = $survey_id;
        }

        public function &getUserData($ids)
        {
                global $ilDB;

                if (!is_array($ids) || count($ids) ==0) return array();

                $result = $ilDB->query("SELECT usr_id, login, lastname, firstname FROM usr_data WHERE " . $ilDB->in('usr_id', $ids, false, 'integer') . " ORDER BY login");
                $result_array = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $result_array[$row["usr_id"]]= $row;
                }
                return $result_array;
        }

        function &getGroupData($ids)
        {
                if (!is_array($ids) || count($ids) ==0) return array();
                $result = array();
                foreach ($ids as $ref_id)
                {
                        $obj_id = ilObject::_lookupObjId($ref_id);
                        $result[$ref_id] = array("ref_id" => $ref_id, "title" => ilObject::_lookupTitle($obj_id), "description" => ilObject::_lookupDescription($obj_id));
                }
                return $result;
        }

        function &getRoleData($ids)
        {
                if (!is_array($ids) || count($ids) ==0) return array();
                $result = array();
                foreach ($ids as $obj_id)
                {
                        $result[$obj_id] = array("obj_id" => $obj_id, "title" => ilObject::_lookupTitle($obj_id), "description" => ilObject::_lookupDescription($obj_id));
                }
                return $result;
        }
        
        function getMailNotification()
        {
                return $this->mailnotification;
        }
        
        function setMailNotification($a_notification)
        {
                $this->mailnotification = ($a_notification) ? true : false;
        }
        
        function getMailAddresses()
        {
                return $this->mailaddresses;
        }
        
        function setMailAddresses($a_addresses)
        {
                $this->mailaddresses = $a_addresses;
        }
        
        function getMailParticipantData()
        {
                return $this->mailparticipantdata;
        }
        
        function setMailParticipantData($a_data)
        {
                $this->mailparticipantdata = $a_data;
        }
        
        public function getSurveyTimes()
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT * FROM svy_times, svy_finished WHERE svy_finished.survey_fi = %s",
                        array('integer'),
                        array($this->getId())
                );
                $times = array();;
                while ($row = $ilDB->fetchAssoc($result))
                {
                        if (strlen($row['left_page']) && strlen($row['entered_page']))
                                $times[$row['finished_fi']] += ($row['left_page']-$row['entered_page']);
                }
                return $times;
        }
        
        function setStartTime($finished_id, $first_question)
        {
                global $ilDB;
                $time = time();
                $_SESSION['svy_entered_page'] = $time;
                $affectedRows = $ilDB->manipulateF("INSERT INTO svy_times (finished_fi, entered_page, left_page, first_question) VALUES (%s, %s, %s, %s)",
                        array('integer', 'integer', 'integer', 'integer'),
                        array($finished_id, $time, NULL, $first_question)
                );
        }
        
        function setEndTime($finished_id)
        {
                global $ilDB;
                $time = time();
                $affectedRows = $ilDB->manipulateF("UPDATE svy_times SET left_page = %s WHERE finished_fi = %s AND entered_page = %s",
                        array('integer', 'integer', 'integer'),
                        array($time, $finished_id, $_SESSION['svy_entered_page'])
                );
                unset($_SESSION['svy_entered_page']);
        }
        
        function getWorkingtimeForParticipant($finished_id)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT * FROM svy_times WHERE finished_fi = %s",
                        array('integer'),
                        array($finished_id)
                );
                $total = 0;
                while ($row = $ilDB->fetchAssoc($result))
                {
                        if ($row['left_page'] > 0 && $row['entered_page'] > 0)
                                $total += $row['left_page'] - $row['entered_page'];
                }
                return $total;
        }

        function setTemplate($template_id)
        {
                $this->template_id = (int)$template_id;
        }

        function getTemplate()
        {
                return $this->template_id;
        }

        function updateOrder(array $a_order)
        {
                if(sizeof($this->questions) == sizeof($a_order))
                {
                        $this->questions = array_flip($a_order);
                        $this->saveQuestionsToDB();
                }               
        }

        function getPoolUsage()
        {
                return $this->pool_usage;
        }

        function setPoolUsage($a_value)
        {
                $this->pool_usage = (bool)$a_value;
        }

        function isPoolActive()
        {
                $use_pool = (bool)$this->getPoolUsage();
                $template_settings = $this->getTemplate();
                if($template_settings)
                {
                        include_once "Services/Administration/classes/class.ilSettingsTemplate.php";
                        $template_settings = new ilSettingsTemplate($template_settings);
                        $template_settings = $template_settings->getSettings();
                        $template_settings = $template_settings["use_pool"];
                        if($template_settings && $template_settings["hide"])
                        {
                                $use_pool = (bool)$template_settings["value"];
                        }
                }
                return $use_pool;
        }
        
        function applySettingsTemplate($template_id)
        {
                if(!$template_id)
                {
                        return;
                }
                
                include_once "Services/Administration/classes/class.ilSettingsTemplate.php";
                $template = new ilSettingsTemplate($template_id);
                $template_settings = $template->getSettings();
                if($template_settings)
                {
                        if($template_settings["show_question_titles"] !== NULL)
                        {
                                if($template_settings["show_question_titles"]["value"])
                                {
                                        $this->setShowQuestionTitles(true);
                                }
                                else
                                {
                                        $this->setShowQuestionTitles(false);
                                }
                        }

                        if($template_settings["use_pool"] !== NULL)
                        {
                                if($template_settings["use_pool"]["value"])
                                {
                                        $this->setPoolUsage(true);
                                }
                                else
                                {
                                        $this->setPoolUsage(false);
                                }
                        }

                        if($template_settings["anonymization_options"]["value"])
                        {
                                $anon_map = array('personalized' => ANONYMIZE_OFF,
                                        'anonymize_with_code' => ANONYMIZE_ON,
                                        'anonymize_without_code' => ANONYMIZE_FREEACCESS);
                                $this->setAnonymize($anon_map[$template_settings["anonymization_options"]["value"]]);
                        }

                        /* other settings: not needed here
                         * - enabled_end_date
                         * - enabled_start_date
                         * - rte_switch
                         */
                }

                $this->setTemplate($template_id);
                $this->saveToDb();
        }
        
} // END class.ilObjSurvey

?>