class.ilObjSurvey.php

Go to the documentation of this file.

<?php
 
/* Copyright (c) 1998-2010 ILIAS open source, Extended GPL, see docs/LICENSE */
 
use \ILIAS\Survey\Participants;
 
class ilObjSurvey extends ilObject
{
    protected $user;
 
    protected $access;
 
    protected $plugin_admin;
 
    const EVALUATION_ACCESS_OFF = 0;
    const EVALUATION_ACCESS_ALL = 1;
    const EVALUATION_ACCESS_PARTICIPANTS = 2;
    
 
    const ANONYMIZE_OFF = 0; // personalized, no codes
    const ANONYMIZE_ON = 1; // anonymized, codes
    const ANONYMIZE_FREEACCESS = 2; // anonymized, no codes
    const ANONYMIZE_CODE_ALL = 3; // personalized, codes
    
    const QUESTIONTITLES_HIDDEN = 0;
    const QUESTIONTITLES_VISIBLE = 1;
 
    // constants to define the print view values.
    const PRINT_HIDE_LABELS = 1; // Show only the titles in "print" and "PDF Export"
    const PRINT_SHOW_LABELS = 3; // Show titles and labels in "print" and "PDF Export"
    
    public $survey_id;
 
    public $author;
 
    public $introduction;
 
    public $outro;
 
 
    public $evaluation_access;
 
    public $start_date;
 
    public $end_date;
 
    public $questions;
 
 
    public $anonymize;
 
    public $display_question_titles;
 
    public $surveyCodeSecurity;
    
    public $mailnotification;
    public $mailaddresses;
    public $mailparticipantdata;
    public $template_id;
    public $pool_usage;
 
    protected $log;
    
    protected $activation_visibility;
    protected $activation_starting_time;
    protected $activation_ending_time;
    
    // 360°
    protected $mode_360_self_eval; // [bool]
    protected $mode_360_self_appr; // [bool]
    protected $mode_360_self_rate; // [bool]
    protected $mode_360_results; // [int]
    protected $mode_skill_service; // [bool]
    
    const RESULTS_360_NONE = 0;
    const RESULTS_360_OWN = 1;
    const RESULTS_360_ALL = 2;
    
    // reminder/notification
    protected $reminder_status; // [bool]
    protected $reminder_start; // [ilDate]
    protected $reminder_end; // [ilDate]
    protected $reminder_frequency; // [int]
    protected $reminder_target; // [int]
    protected $reminder_last_sent; // [bool]
    protected $reminder_tmpl; // [int]
    protected $tutor_ntf_status; // [bool]
    protected $tutor_ntf_recipients; // [array]
    protected $tutor_ntf_target; // [int]
    protected $tutor_res_status; // [bool]
    protected $tutor_res_recipients; // [array]
    
    protected $view_own_results; // [bool]
    protected $mail_own_results; // [bool]
    protected $mail_confirmation; // [bool]
    
    protected $anon_user_list; // [bool]
    
    const NOTIFICATION_PARENT_COURSE = 1;
    const NOTIFICATION_INVITED_USERS = 2;
    const NOTIFICATION_APPRAISEES = 3;
    const NOTIFICATION_RATERS = 4;
    const NOTIFICATION_APPRAISEES_AND_RATERS = 5;
 
    protected $mode; //[int]
    protected $mode_self_eval_results; //[int]
 
    //MODE TYPES
    const MODE_STANDARD = 0;
    const MODE_360 = 1;
    const MODE_SELF_EVAL = 2;
 
    //self evaluation only access to results
    const RESULTS_SELF_EVAL_NONE = 0;
    const RESULTS_SELF_EVAL_OWN = 1;
    const RESULTS_SELF_EVAL_ALL = 2;
 
 
    protected $invitation_manager;
 
    public function __construct($a_id = 0, $a_call_by_reference = true)
    {
        global $DIC;
 
        $this->user = $DIC->user();
        $this->lng = $DIC->language();
        $this->db = $DIC->database();
        $this->access = $DIC->access();
        $this->log = $DIC["ilLog"];
        $this->plugin_admin = $DIC["ilPluginAdmin"];
        $this->tree = $DIC->repositoryTree();
        $ilUser = $DIC->user();
        $lng = $DIC->language();
        
        $this->type = "svy";
        $this->survey_id = -1;
        $this->introduction = "";
        $this->outro = $lng->txt("survey_finished");
        $this->author = $ilUser->getFullname();
        $this->evaluation_access = self::EVALUATION_ACCESS_OFF;
        $this->questions = array();
        $this->anonymize = self::ANONYMIZE_OFF;
        $this->display_question_titles = self::QUESTIONTITLES_VISIBLE;
        $this->surveyCodeSecurity = true;
        $this->template_id = null;
        $this->pool_usage = true;
        $this->log = ilLoggerFactory::getLogger("svy");
        $this->mode = self::MODE_STANDARD;
        $this->mode_self_eval_results = self::RESULTS_SELF_EVAL_OWN;
 
        $this->invitation_manager = new Participants\InvitationsManager();
 
        parent::__construct($a_id, $a_call_by_reference);
    }
 
    public function create($a_upload = false)
    {
        parent::create();
        if (!$a_upload) {
            $this->createMetaData();
        }
        $this->setOfflineStatus(true);
        $this->update($a_upload);
    }
 
    public function createMetaData()
    {
        parent::createMetaData();
        $this->saveAuthorToMetadata();
    }
 
    public function update($a_upload = false)
    {
        if (!$a_upload) {
            $this->updateMetaData();
        }
 
        if (!parent::update()) {
            return false;
        }
 
        // put here object specific stuff
        
        return true;
    }
 
    public function createReference()
    {
        $result = parent::createReference();
        $this->saveToDb();
        return $result;
    }
 
    public function read()
    {
        parent::read();
        $this->loadFromDb();
    }
    
    public function addQuestion($question_id)
    {
        array_push($this->questions, $question_id);
    }
    
    public function delete()
    {
        if ($this->countReferences() == 1) {
            $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());
        }
 
        $remove = parent::delete();
 
        // always call parent delete function first!!
        if (!$remove) {
            return false;
        }
        return true;
    }
    
    public function deleteSurveyRecord()
    {
        $ilDB = $this->db;
        
        $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(false);
 
        $affectedRows = $ilDB->manipulateF(
            "DELETE FROM svy_anonymous WHERE survey_fi = %s",
            array('integer'),
            array($this->getSurveyId())
        );
        
        // delete export files
        $svy_data_dir = ilUtil::getDataDir() . "/svy_data";
        $directory = $svy_data_dir . "/svy_" . $this->getId();
        if (is_dir($directory)) {
            ilUtil::delDir($directory);
        }
 
        $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();
        }
    }
 
    public function deleteAllUserData($reset_LP = true)
    {
        $ilDB = $this->db;
        
        $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)
            );
        }
 
        if ($reset_LP) {
            $lp_obj = ilObjectLP::getInstance($this->getId());
            $lp_obj->resetLPDataForCompleteObject();
        }
    }
    
    public function removeSelectedSurveyResults($finished_ids)
    {
        $ilDB = $this->db;
        
        $user_ids[] = array();
        
        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);
            
            if ($row["user_fi"]) {
                $user_ids[] = $row["user_fi"];
            }
 
            $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"])
            );
        }
        
        if (sizeof($user_ids)) {
            $lp_obj = ilObjectLP::getInstance($this->getId());
            $lp_obj->resetLPDataForUserIds($user_ids);
        }
    }
    
    public function &getSurveyParticipants($finished_ids = null, $force_non_anonymous = false, $include_invites = false)
    {
        $ilDB = $this->db;
        
        $sql = "SELECT * FROM svy_finished" .
            " WHERE survey_fi = " . $ilDB->quote($this->getSurveyId(), "integer");
        if ($finished_ids) {
            $sql .= " AND " . $ilDB->in("finished_id", $finished_ids, "", "integer");
        }
        
        $result = $ilDB->query($sql);
        $participants = array();
        if ($result->numRows() > 0) {
            while ($row = $ilDB->fetchAssoc($result)) {
                $userdata = $this->getUserDataFromActiveId($row["finished_id"], $force_non_anonymous);
                $userdata["finished"] = (bool) $row["state"];
                $userdata["finished_tstamp"] = $row["tstamp"];
                $participants[$userdata["sortname"] . $userdata["active_id"]] = $userdata;
            }
        }
        $participant_ids = array_column($participants, "usr_id");
        if ($include_invites) {
            foreach ($this->invitation_manager->getAllForSurvey($this->getSurveyId()) as $usr_id) {
                if (!in_array($usr_id, $participant_ids)) {
                    $name = ilObjUser::_lookupName($usr_id);
                    $participants[$name["lastname"] . "," . $name["firstname"] . $usr_id] = [
                        "fullname" => ilObjUser::_lookupFullname($usr_id),
                        "sortname" => $name["lastname"] . "," . $name["firstname"],
                        "fistname" => $name["firstname"],
                        "lastname" => $name["lastname"],
                        "login" => $name["login"],
                        "gender" => "",
                        "usr_id" => $usr_id,
                        "finished" => false,
                        "finished_tstamp" => 0,
                        "invited" => true
                    ];
                }
            }
        }
 
        return $participants;
    }
 
    public function isComplete()
    {
        if (($this->getTitle()) and (count($this->questions))) {
            return 1;
        } else {
            return 0;
        }
    }
 
    public function saveCompletionStatus()
    {
        $ilDB = $this->db;
        
        $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())
            );
        }
    }
 
    public function duplicateQuestionForSurvey($question_id, $a_force = false)
    {
        $ilUser = $this->user;
        
        $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, "", "", "", $this->getId());
        return $duplicate_id;
    }
 
    public function insertQuestion($question_id)
    {
        $ilDB = $this->db;
 
        $this->log->debug("insert question, id:" . $question_id);
 
        if (!SurveyQuestion::_isComplete($question_id)) {
            $this->log->debug("question is not complete");
            return false;
        } else {
            // get maximum sequence index in test
            // @todo: refactor this
            $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);
            $this->log->debug("duplicate, id: " . $question_id . ", duplicate id: " . $duplicate_id);
 
            // check if question is not already in the survey, see #22018
            if ($this->isQuestionInSurvey($duplicate_id)) {
                return false;
            }
 
            $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->log->debug("added entry to svy_svy_qst, id: " . $next_id . ", question id: " . $duplicate_id . ", sequence: " . $sequence);
 
            $this->loadQuestionsFromDb();
            return true;
        }
    }
 
    public function isQuestionInSurvey($a_question_fi)
    {
        global $DIC;
        //return false;
        $ilDB = $DIC->database();
 
        $set = $ilDB->query("SELECT * FROM svy_svy_qst " .
            " WHERE survey_fi = " . $ilDB->quote($this->getSurveyId(), "integer") .
            " AND question_fi = " . $ilDB->quote($a_question_fi, "integer"));
        if ($rec = $ilDB->fetchAssoc($set)) {
            return true;
        }
        return false;
    }
 
 
 
    public function insertQuestionblock($questionblock_id)
    {
        $ilDB = $this->db;
        $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);
    }
    
    public function saveUserSettings($usr_id, $key, $title, $value)
    {
        $ilDB = $this->db;
        
        $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)
    {
        $ilDB = $this->db;
        
        $affectedRows = $ilDB->manipulateF(
            "DELETE FROM svy_settings WHERE settings_id = %s",
            array('integer'),
            array($id)
        );
        return $affectedRows;
    }
    
    public function getUserSettings($usr_id, $key)
    {
        $ilDB = $this->db;
 
        $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;
    }
 
    public function saveToDb()
    {
        $ilDB = $this->db;
 
        // date handling
        $rmd_start = $this->getReminderStart();
        if (is_object($rmd_start)) {
            $rmd_start = $rmd_start->get(IL_CAL_DATE);
        }
        $rmd_end = $this->getReminderEnd();
        if (is_object($rmd_end)) {
            $rmd_end = $rmd_end->get(IL_CAL_DATE);
        }
        
        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)),
                "startdate" => array("text", $this->getStartDate()),
                "enddate" => array("text", $this->getEndDate()),
                "evaluation_access" => array("text", $this->getEvaluationAccess()),
                "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()),
                // Mode type
                "mode" => array("integer", $this->getMode()),
                // 360°
                "mode_360_self_eval" => array("integer", $this->get360SelfEvaluation()),
                "mode_360_self_rate" => array("integer", $this->get360SelfRaters()),
                "mode_360_self_appr" => array("integer", $this->get360SelfAppraisee()),
                "mode_360_results" => array("integer", $this->get360Results()),
                // competences
                "mode_skill_service" => array("integer", (int) $this->getSkillService()),
                // Self Evaluation Only
                "mode_self_eval_results" => array("integer", ilObjSurvey::RESULTS_SELF_EVAL_OWN),
                // reminder/notification
                "reminder_status" => array("integer", (int) $this->getReminderStatus()),
                "reminder_start" => array("datetime", $rmd_start),
                "reminder_end" => array("datetime", $rmd_end),
                "reminder_frequency" => array("integer", (int) $this->getReminderFrequency()),
                "reminder_target" => array("integer", (int) $this->getReminderTarget()),
                "reminder_last_sent" => array("datetime", $this->getReminderLastSent()),
                "reminder_tmpl" => array("text", $this->getReminderTemplate(true)),
                "tutor_ntf_status" => array("integer", (int) $this->getTutorNotificationStatus()),
                "tutor_ntf_reci" => array("text", implode(";", (array) $this->getTutorNotificationRecipients())),
                "tutor_ntf_target" => array("integer", (int) $this->getTutorNotificationTarget()),
                "own_results_view" => array("integer", $this->hasViewOwnResults()),
                "own_results_mail" => array("integer", $this->hasMailOwnResults()),
                "tutor_res_status" => array("integer", (int) $this->getTutorResultsStatus()),
                "tutor_res_reci" => array("text", implode(";", (array) $this->getTutorResultsRecipients())),
                "confirmation_mail" => array("integer", $this->hasMailConfirmation()),
                "anon_user_list" => array("integer", $this->hasAnonymousUserList())
            ));
            $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)),
                "startdate" => array("text", $this->getStartDate()),
                "enddate" => array("text", $this->getEndDate()),
                "evaluation_access" => array("text", $this->getEvaluationAccess()),
                "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()),
                //MODE TYPE
                "mode" => array("integer", $this->getMode()),
                // 360°
                "mode_360_self_eval" => array("integer", $this->get360SelfEvaluation()),
                "mode_360_self_rate" => array("integer", $this->get360SelfRaters()),
                "mode_360_self_appr" => array("integer", $this->get360SelfAppraisee()),
                "mode_360_results" => array("integer", $this->get360Results()),
                // Competences
                "mode_skill_service" => array("integer", (int) $this->getSkillService()),
                // Self Evaluation Only
                "mode_self_eval_results" => array("integer", $this->getSelfEvaluationResults()),
                // reminder/notification
                "reminder_status" => array("integer", $this->getReminderStatus()),
                "reminder_start" => array("datetime", $rmd_start),
                "reminder_end" => array("datetime", $rmd_end),
                "reminder_frequency" => array("integer", $this->getReminderFrequency()),
                "reminder_target" => array("integer", $this->getReminderTarget()),
                "reminder_last_sent" => array("datetime", $this->getReminderLastSent()),
                "reminder_tmpl" => array("text", $this->getReminderTemplate()),
                "tutor_ntf_status" => array("integer", $this->getTutorNotificationStatus()),
                "tutor_ntf_reci" => array("text", implode(";", (array) $this->getTutorNotificationRecipients())),
                "tutor_ntf_target" => array("integer", $this->getTutorNotificationTarget()),
                "own_results_view" => array("integer", $this->hasViewOwnResults()),
                "own_results_mail" => array("integer", $this->hasMailOwnResults()),
                "tutor_res_status" => array("integer", (int) $this->getTutorResultsStatus()),
                "tutor_res_reci" => array("text", implode(";", (array) $this->getTutorResultsRecipients())),
                "confirmation_mail" => array("integer", $this->hasMailConfirmation()),
                "anon_user_list" => array("integer", $this->hasAnonymousUserList())
            ), array(
            "survey_id" => array("integer", $this->getSurveyId())
            ));
        }
        if ($affectedRows) {
            // save questions to db
            $this->saveQuestionsToDb();
        }
        
        // moved activation to ilObjectActivation
        if ($this->ref_id) {
            ilObjectActivation::getItem($this->ref_id);
            
            $item = new ilObjectActivation;
            if (!$this->isActivationLimited()) {
                $item->setTimingType(ilObjectActivation::TIMINGS_DEACTIVATED);
            } else {
                $item->setTimingType(ilObjectActivation::TIMINGS_ACTIVATION);
                $item->setTimingStart($this->getActivationStartDate());
                $item->setTimingEnd($this->getActivationEndDate());
                $item->toggleVisible($this->getActivationVisibility());
            }
            
            $item->update($this->ref_id);
        }
    }
 
    public function saveQuestionsToDb()
    {
        $ilDB = $this->db;
 
        $this->log->debug("save questions");
 
        // gather old questions state
        $old_questions = array();
        $result = $ilDB->queryF(
            "SELECT survey_question_id,question_fi,sequence" .
            " FROM svy_svy_qst WHERE survey_fi = %s",
            array('integer'),
            array($this->getSurveyId())
        );
        while ($row = $ilDB->fetchAssoc($result)) {
            $old_questions[$row["question_fi"]] = $row;         // problem, as soon as duplicates exist, they will be hidden here
        }
        
        // #15231 - diff with current questions state
        $insert = $update = $delete = array();
        foreach ($this->questions as $seq => $fi) {
            if (!array_key_exists($fi, $old_questions)) {               // really new fi IDs
                $insert[] = $fi;                                                        // this should be ok, should not create duplicates here
            } elseif ($old_questions[$fi]["sequence"] != $seq) {                                // we are updating one of the duplicates (if any)
                $update[$fi] = $old_questions[$fi]["survey_question_id"];
            }
            // keep track of still relevant questions
            unset($old_questions[$fi]);                                         // deleting old question, if they are not in current array
        }
        
        // delete obsolete question relations
        if (sizeof($old_questions)) {
            $del_ids = array();
            foreach ($old_questions as $fi => $old) {
                $del_ids[] = $old["survey_question_id"];
            }
            $ilDB->manipulate($q = "DELETE FROM svy_svy_qst" .
                " WHERE " . $ilDB->in("survey_question_id", $del_ids, "", "integer"));
            $this->log->debug("delete: " . $q);
        }
        unset($old_questions);
        
        // create/update question relations
        foreach ($this->questions as $seq => $fi) {
            if (in_array($fi, $insert)) {
                // check if question is not already in the survey, see #22018
                if (!$this->isQuestionInSurvey($fi)) {
                    $next_id = $ilDB->nextId('svy_svy_qst');
                    $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(), $fi, null, $seq, time())
                    );
                    $this->log->debug("insert svy_svy_qst, id:" . $next_id . ", fi: " . $fi . ", seq:" . $seq);
                }
            } elseif (array_key_exists($fi, $update)) {
                $ilDB->manipulate("UPDATE svy_svy_qst" .
                    " SET sequence = " . $ilDB->quote($seq, "integer") .
                    ", tstamp = " . $ilDB->quote(time(), "integer") .
                    " WHERE survey_question_id = " . $ilDB->quote($update[$fi], "integer"));
                $this->log->debug("update svy_svy_qst, id:" . $update[$fi] . ", fi: " . $fi . ", seq:" . $seq);
            }
        }
    }
 
    public function getAnonymousId($id)
    {
        $ilDB = $this->db;
        $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 "";
        }
    }
 
    public function getQuestionGUI($questiontype, $question_id)
    {
        return SurveyQuestionGUI::_getQuestionGUI($questiontype, $question_id);
    }
    
    public function getQuestionType($question_id)
    {
        $ilDB = $this->db;
        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 "";
        }
    }
 
    public function getSurveyId()
    {
        return $this->survey_id;
    }
    
    public function setAnonymize($a_anonymize)
    {
        switch ($a_anonymize) {
            case self::ANONYMIZE_OFF:
            case self::ANONYMIZE_ON:
            case self::ANONYMIZE_FREEACCESS:
            case self::ANONYMIZE_CODE_ALL:
                $this->anonymize = $a_anonymize;
                break;
            default:
                $this->anonymize = self::ANONYMIZE_OFF;
                break;
        }
    }
 
    public function getAnonymize()
    {
        return ($this->anonymize) ? $this->anonymize : 0;
    }
    
    public function isAccessibleWithoutCode()
    {
        return ($this->getAnonymize() == self::ANONYMIZE_OFF ||
            $this->getAnonymize() == self::ANONYMIZE_FREEACCESS);
    }
    
    public function hasAnonymizedResults()
    {
        return ($this->getAnonymize() == self::ANONYMIZE_ON ||
            $this->getAnonymize() == self::ANONYMIZE_FREEACCESS);
    }
 
    public function loadFromDb()
    {
        $ilDB = $this->db;
        $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"]);
            $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->setShowQuestionTitles($data["show_question_titles"]);
            $this->setStartDate($data["startdate"]);
            $this->setEndDate($data["enddate"]);
            $this->setAnonymize($data["anonymize"]);
            $this->setEvaluationAccess($data["evaluation_access"]);
            $this->loadQuestionsFromDb();
            $this->setMailNotification($data['mailnotification']);
            $this->setMailAddresses($data['mailaddresses']);
            $this->setMailParticipantData($data['mailparticipantdata']);
            $this->setTemplate($data['template_id']);
            $this->setPoolUsage($data['pool_usage']);
            // Mode
            $this->setMode($data['mode']);
            // 360°
            $this->set360SelfEvaluation($data['mode_360_self_eval']);
            $this->set360SelfRaters($data['mode_360_self_rate']);
            $this->set360SelfAppraisee($data['mode_360_self_appr']);
            $this->set360Results($data['mode_360_results']);
            // Mode self evaluated
            $this->setSelfEvaluationResults($data['mode_self_eval_results']);
            // Competences
            $this->setSkillService($data['mode_skill_service']);
            // reminder/notification
            $this->setReminderStatus($data["reminder_status"]);
            $this->setReminderStart($data["reminder_start"] ? new ilDate($data["reminder_start"], IL_CAL_DATE) : null);
            $this->setReminderEnd($data["reminder_end"] ? new ilDate($data["reminder_end"], IL_CAL_DATE) : null);
            $this->setReminderFrequency($data["reminder_frequency"]);
            $this->setReminderTarget($data["reminder_target"]);
            $this->setReminderLastSent($data["reminder_last_sent"]);
            $this->setReminderTemplate($data["reminder_tmpl"]);
            $this->setTutorNotificationStatus($data["tutor_ntf_status"]);
            $this->setTutorNotificationRecipients(explode(";", $data["tutor_ntf_reci"]));
            $this->setTutorNotificationTarget($data["tutor_ntf_target"]);
            $this->setTutorResultsStatus($data["tutor_res_status"]);
            $this->setTutorResultsRecipients(explode(";", $data["tutor_res_reci"]));
            
            $this->setViewOwnResults($data["own_results_view"]);
            $this->setMailOwnResults($data["own_results_mail"]);
            $this->setMailConfirmation($data["confirmation_mail"]);
            
            $this->setAnonymousUserList($data["anon_user_list"]);
        }
        
        // moved activation to ilObjectActivation
        if ($this->ref_id) {
            $activation = ilObjectActivation::getItem($this->ref_id);
            switch ($activation["timing_type"]) {
                case ilObjectActivation::TIMINGS_ACTIVATION:
                    $this->setActivationLimited(true);
                    $this->setActivationStartDate($activation["timing_start"]);
                    $this->setActivationEndDate($activation["timing_end"]);
                    $this->setActivationVisibility($activation["visible"]);
                    break;
                
                default:
                    $this->setActivationLimited(false);
                    break;
            }
        }
    }
 
    public function loadQuestionsFromDb()
    {
        $ilDB = $this->db;
        $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"];
        }
    }
 
    public function fixSequenceStructure()
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        //return;
        // we keep all survey question ids with their lowest sequence
        $result = $ilDB->queryF(
            "SELECT * FROM svy_svy_qst WHERE survey_fi = %s ORDER BY sequence",
            array('integer'),
            array($this->getSurveyId())
        );
 
        // step 1: find duplicates -> $to_delete_ids
        $fis = array();
        $to_delete_ids = array();
        while ($data = $ilDB->fetchAssoc($result)) {
            if (in_array($data["question_fi"], $fis)) {         // found a duplicate
                $to_delete_ids[] = $data["survey_question_id"];
            } else {
                $fis[] = $data["question_fi"];
            }
        }
 
        // step 2: we delete the duplicates
        if (count($to_delete_ids) > 0) {
            $ilDB->manipulate($q = "DELETE FROM svy_svy_qst" .
                " WHERE " . $ilDB->in("survey_question_id", $to_delete_ids, false, "integer") .
                " AND survey_fi = " . $ilDB->quote($this->getSurveyId(), "integer"));
            $this->log->debug("delete: " . $q);
 
            $ilDB->manipulate($q = "DELETE FROM svy_qblk_qst " .
                " WHERE " . $ilDB->in("question_fi", $fis, true, "integer") .
                " AND survey_fi = " . $ilDB->quote($this->getSurveyId(), "integer"));
            $this->log->debug("delete: " . $q);
        }
 
        // step 3: we fix the sequence
        $set = $ilDB->query("SELECT * FROM svy_svy_qst " .
            " WHERE survey_fi = " . $ilDB->quote($this->getSurveyId(), "integer") . " ORDER BY sequence");
        $seq = 0;
        while ($rec = $ilDB->fetchAssoc($set)) {
            $ilDB->manipulate(
                $q = "UPDATE svy_svy_qst SET " .
                " sequence = " . $ilDB->quote($seq++, "integer") .
                " WHERE survey_question_id = " . $ilDB->quote($rec["survey_question_id"], "integer")
            );
            $this->log->debug("update: " . $q);
        }
    }
 
 
    public function setAuthor($author = "")
    {
        $this->author = $author;
    }
 
    public function saveAuthorToMetadata($a_author = "")
    {
        $md = new ilMD($this->getId(), 0, $this->getType());
        $md_life = &$md->getLifecycle();
        if (!$md_life) {
            if (strlen($a_author) == 0) {
                $ilUser = $this->user;
                $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();
        }
    }
    
    public function getAuthor()
    {
        $author = array();
        $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;
    }
 
    public function showQuestionTitles()
    {
        $this->display_question_titles = 1;
    }
 
    public function hideQuestionTitles()
    {
        $this->display_question_titles = 0;
    }
    
    public function setIntroduction($introduction = "")
    {
        $this->introduction = $introduction;
    }
 
    public function setOutro($outro = "")
    {
        $this->outro = $outro;
    }
 
 
    public function getStartDate()
    {
        return (strlen($this->start_date)) ? $this->start_date : null;
    }
 
    public function canStartSurvey($anonymous_id = null, $a_no_rbac = false)
    {
        $ilAccess = $this->access;
        
        $result = true;
        $messages = array();
        $edit_settings = false;
        // check start date
        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 = time();
            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 (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 = time();
            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->getOfflineStatus()) {
            array_push($messages, $this->lng->txt("survey_is_offline"));
            $result = false;
            $edit_settings = true;
        }
        // check rbac permissions
        if (!$a_no_rbac && !$ilAccess->checkAccess("read", "", $this->ref_id)) {
            array_push($messages, $this->lng->txt("cannot_participate_survey"));
            $result = false;
        }
        /*
        // 2. check previous access
        if (!$result["error"])
        {
        $ilUser = $this->user;
            $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
        );
    }
 
    public function setStartDate($start_date = "")
    {
        $this->start_date = $start_date;
    }
 
    public 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);
    }
 
    public function getEndDate()
    {
        return (strlen($this->end_date)) ? $this->end_date : null;
    }
 
    public function setEndDate($end_date = "")
    {
        $this->end_date = $end_date;
    }
 
    public 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);
    }
 
    public function getEvaluationAccess()
    {
        return ($this->evaluation_access) ? $this->evaluation_access : self::EVALUATION_ACCESS_OFF;
    }
 
    public function setEvaluationAccess($evaluation_access = self::EVALUATION_ACCESS_OFF)
    {
        $this->evaluation_access = ($evaluation_access) ? $evaluation_access : self::EVALUATION_ACCESS_OFF;
    }
    
    public function setActivationVisibility($a_value)
    {
        $this->activation_visibility = (bool) $a_value;
    }
    
    public function getActivationVisibility()
    {
        return $this->activation_visibility;
    }
    
    public function isActivationLimited()
    {
        return (bool) $this->activation_limited;
    }
    
    public function setActivationLimited($a_value)
    {
        $this->activation_limited = (bool) $a_value;
    }
 
    public function getIntroduction()
    {
        return (strlen($this->introduction)) ? $this->introduction : null;
    }
 
    public function getOutro()
    {
        return (strlen($this->outro)) ? $this->outro : null;
    }
 
    public function &getExistingQuestions()
    {
        $ilDB = $this->db;
        $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;
    }
 
    public function &getQuestionpoolTitles($could_be_offline = false, $showPath = false)
    {
        return ilObjSurveyQuestionPool::_getAvailableQuestionpools($use_object_id = true, $could_be_offline, $showPath);
    }
    
    public 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);
        } elseif ($insert_mode == 1) {
            $part1 = array_slice($this->questions, 0, $array_pos + 1);
            $part2 = array_slice($this->questions, $array_pos + 1);
        }
        $found = 0;
        foreach ($move_questions as $question_id) {
            if (!(array_search($question_id, $part1) === false)) {
                unset($part1[array_search($question_id, $part1)]);
                $found++;
            }
            if (!(array_search($question_id, $part2) === false)) {
                unset($part2[array_search($question_id, $part2)]);
                $found++;
            }
        }
        // sanity check: do not move questions if they have not be found in the array
        if ($found != count($move_questions)) {
            return;
        }
        $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();
    }
    
    public function removeQuestion($question_id)
    {
        $question = self::_instanciateQuestion($question_id);
        #20610 if no question found, do nothing.
        if ($question) {
            $question->delete($question_id);
            $this->removeConstraintsConcerningQuestion($question_id);
        }
    }
    
    public function removeConstraintsConcerningQuestion($question_id)
    {
        $ilDB = $this->db;
        $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)
                );
            }
        }
    }
        
    public function removeQuestions($remove_questions, $remove_questionblocks)
    {
        $ilDB = $this->db;
 
        $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);
            } elseif ($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();
    }
        
    public function unfoldQuestionblocks($questionblocks)
    {
        $ilDB = $this->db;
        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())
            );
        }
    }
 
    public function removeQuestionFromBlock($question_id, $questionblock_id)
    {
        $ilDB = $this->db;
        
        $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)
        );
    }
 
    public function addQuestionToBlock($question_id, $questionblock_id)
    {
        $ilDB = $this->db;
 
        // see #22018
        if (!$this->isQuestionInAnyBlock($question_id)) {
            $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)
            );
 
            $this->deleteConstraints($question_id); // #13713
        }
    }
 
    public function isQuestionInAnyBlock($a_question_fi)
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $set = $ilDB->query("SELECT * FROM svy_qblk_qst " .
            " WHERE survey_fi = " . $ilDB->quote($this->getSurveyId(), "integer") .
            " AND question_fi = " . $ilDB->quote($a_question_fi, "integer"));
        if ($rec = $ilDB->fetchAssoc($set)) {
            return true;
        }
        return false;
    }
 
 
    public function &getQuestionblockQuestions($questionblock_id)
    {
        $ilDB = $this->db;
        $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;
    }
    
    public function &getQuestionblockQuestionIds($questionblock_id)
    {
        $ilDB = $this->db;
 
        // we need a correct order here, see #22011
        $result = $ilDB->queryF(
            "SELECT a.question_fi FROM svy_qblk_qst a JOIN svy_svy_qst b ON (a.question_fi = b.question_fi) " .
            " WHERE a.questionblock_fi = %s ORDER BY b.sequence",
            array("integer"),
            array($questionblock_id)
        );
        $ids = array();
        if ($result->numRows()) {
            while ($data = $ilDB->fetchAssoc($result)) {
                if (!in_array($data['question_fi'], $ids)) {            // no duplicates, see #22018
                    array_push($ids, $data['question_fi']);
                }
            }
        }
 
        return $ids;
    }
    
    public static function _getQuestionblock($questionblock_id)
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $result = $ilDB->queryF(
            "SELECT * FROM svy_qblk WHERE questionblock_id = %s",
            array('integer'),
            array($questionblock_id)
        );
        $row = $ilDB->fetchAssoc($result);
        return $row;
    }
 
    public static function _addQuestionblock($title = "", $owner = 0, $show_questiontext = true, $show_blocktitle = false)
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $next_id = $ilDB->nextId('svy_qblk');
        $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','integer','integer','integer','integer'),
            array($next_id, $title, $show_questiontext, $show_blocktitle, $owner, time())
        );
        return $next_id;
    }
    
    public function createQuestionblock($title, $show_questiontext, $show_blocktitle, $questions)
    {
        $ilDB = $this->db;
        
        // 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
        $ilUser = $this->user;
        $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) {
                if (!$this->isQuestionInAnyBlock($index)) {
                    $next_id = $ilDB->nextId('svy_qblk_qst');   // #22018
                    $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);
                }
            }
        }
    }
    
    public function modifyQuestionblock($questionblock_id, $title, $show_questiontext, $show_blocktitle)
    {
        $ilDB = $this->db;
        $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)
        );
    }
    
    public function deleteConstraints($question_id)
    {
        $ilDB = $this->db;
        $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);
        }
    }
 
    public function deleteConstraint($constraint_id)
    {
        $ilDB = $this->db;
        $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)
    {
        $ilDB = $this->db;
        // 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())
        );
        while ($row = $ilDB->fetchAssoc($result)) {
            $add = true;
            if ($row["plugin"]) {
                if (!$this->isPluginActive($row["type_tag"])) {
                    $add = false;
                }
            }
            if ($add) {
                $question = self::_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();
            }
        }
        // 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;
    }
    
    public function setObligatoryStates($obligatory_questions)
    {
        $ilDB = $this->db;
        $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
        foreach ($obligatory_questions as $question_fi => $obligatory) {
            // #12420
            $ilDB->manipulate("UPDATE svy_question" .
                " SET obligatory = " . $ilDB->quote($obligatory, "integer") .
                " WHERE question_id = " . $ilDB->quote($question_fi, "integer"));
        }
    }
 
    public function &getSurveyPages()
    {
        $ilDB = $this->db;
        // 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) {
            $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;
    }
    
    public 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];
        }
    }
        
    public function &getAvailableQuestionpools($use_obj_id = false, $could_be_offline = false, $showPath = false, $permission = "read")
    {
        return ilObjSurveyQuestionPool::_getAvailableQuestionpools($use_obj_id, $could_be_offline, $showPath, $permission);
    }
    
    public function getPrecondition($id)
    {
        $ilDB = $this->db;
        
        $result_array = array();
        $result = $ilDB->queryF(
            "SELECT svy_constraint.*, svy_relation.*, svy_qst_constraint.question_fi ref_question_fi 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;
    }
    
    public function getConstraints($question_id)
    {
        $ilDB = $this->db;
        
        $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)) {
            $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;
    }
 
    public static function _getConstraints($survey_id)
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $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;
    }
 
 
    public function &getVariables($question_id)
    {
        $ilDB = $this->db;
        
        $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;
    }
    
    public function addConstraint($if_question_id, $relation, $value, $conjunction)
    {
        $ilDB = $this->db;
 
        $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)
    {
        $ilDB = $this->db;
        
        $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)
        );
    }
    
    public function updateConstraint($precondition_id, $if_question_id, $relation, $value, $conjunction)
    {
        $ilDB = $this->db;
        $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)
    {
        $ilDB = $this->db;
        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)
            );
        }
    }
 
    public function getAllRelations($short_as_key = false)
    {
        $ilDB = $this->db;
        
        // #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 deleteWorkingData($question_id, $active_id)
    {
        $ilDB = $this->db;
        
        $affectedRows = $ilDB->manipulateF(
            "DELETE FROM svy_answer WHERE question_fi = %s AND active_fi = %s",
            array('integer','integer'),
            array($question_id, $active_id)
        );
    }
    
    public function loadWorkingData($question_id, $active_id)
    {
        $ilDB = $this->db;
        $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;
        }
    }
    
    public function startSurvey($user_id, $anonymous_id, $appraisee_id)
    {
        $ilDB = $this->db;
        
        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, appr_id) " .
            "VALUES (%s, %s, %s, %s, %s, %s, %s)",
            array('integer','integer','integer','text','text','integer','integer'),
            array($next_id, $this->getSurveyId(), $user_id, $anonymous_id, 0, time(), $appraisee_id)
        );
        return $next_id;
    }
 
    public function finishSurvey($finished_id)
    {
        $ilDB = $this->db;
        
        $ilDB->manipulateF(
            "UPDATE svy_finished SET state = %s, tstamp = %s" .
            " WHERE survey_fi = %s AND finished_id = %s",
            array('text','integer','integer','integer'),
            array(1, time(), $this->getSurveyId(), $finished_id)
        );
 
        // self eval writes skills on finishing
        if ($this->getMode() == ilObjSurvey::MODE_SELF_EVAL) {
            $user = $this->getUserDataFromActiveId($finished_id);
            $sskill = new ilSurveySkill($this);
            $sskill->writeAndAddSelfEvalSkills($user['usr_id']);
        }
 
        $this->checkTutorNotification();
    }
 
    public function setPage($finished_id, $page_id)
    {
        $ilDB = $this->db;
 
        $affectedRows = $ilDB->manipulateF(
            "UPDATE svy_finished SET lastpage = %s WHERE finished_id = %s",
            array('integer','integer'),
            array(($page_id) ? $page_id : 0, $finished_id)
        );
    }
 
    public function sendNotificationMail($a_user_id, $a_anonymize_id, $a_appr_id)
    {
        // #12755
        $placeholders = array(
            "FIRST_NAME" => "firstname",
            "LAST_NAME" => "lastname",
            "LOGIN" => "login",
            // old style
            "firstname" => "firstname"
        );
 
        //mailaddresses is just text split by commas.
        //sendMail can send emails if it gets an user id or an email as first parameter.
        $recipients = preg_split('/,/', $this->mailaddresses);
        foreach ($recipients as $recipient) {
            // #11298
            $ntf = new ilSystemNotification();
            $ntf->setLangModules(array("survey"));
            $ntf->setRefId($this->getRefId());
            $ntf->setSubjectLangId('finished_mail_subject');
                                
            $messagetext = $this->mailparticipantdata;
            if (trim($messagetext)) {
                if (!$this->hasAnonymizedResults()) {
                    $data = ilObjUser::_getUserData(array($a_user_id));
                    $data = $data[0];
                }
                foreach ($placeholders as $key => $mapping) {
                    if ($this->hasAnonymizedResults()) { // #16480
                        $messagetext = str_replace('[' . $key . ']', '', $messagetext);
                    } else {
                        $messagetext = str_replace('[' . $key . ']', trim($data[$mapping]), $messagetext);
                    }
                }
                $ntf->setIntroductionDirect($messagetext);
            } else {
                $ntf->setIntroductionLangId('survey_notification_finished_introduction');
            }
                        
            // 360°? add appraisee data
            if ($a_appr_id) {
                $ntf->addAdditionalInfo(
                    'survey_360_appraisee',
                    ilUserUtil::getNamePresentation($a_appr_id)
                );
            }
            
            $active_id = $this->getActiveID($a_user_id, $a_anonymize_id, $a_appr_id);
            $ntf->addAdditionalInfo(
                'results',
                $this->getParticipantTextResults($active_id),
                true
            );
                                    
            $ntf->setGotoLangId('survey_notification_tutor_link');
            $ntf->setReasonLangId('survey_notification_finished_reason');
 
            if (is_numeric($recipient)) {
                $lng = $ntf->getUserLanguage($recipient);
                $ntf->sendMail(array($recipient), null, null);
            } else {
                $recipient = trim($recipient);
                $user_ids = ilObjUser::getUserIdsByEmail($recipient);
                if (empty($user_ids)) {
                    $ntf->sendMail(array($recipient), null, null);
                } else {
                    foreach ($user_ids as $user_id) {
                        $lng = $ntf->getUserLanguage($user_id);
                        $ntf->sendMail(array($user_id), null, null);
                    }
                }
            }
        }
    }
 
    protected function getParticipantTextResults($active_id)
    {
        $textresult = "";
        $userResults = &$this->getUserSpecificResults(array($active_id));
        $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 = self::getSurveySkippedValue();
            }
            $text = str_replace("<br />", "\n", $text);
            $textresult .= $text . "\n\n";
        }
        return $textresult;
    }
 
    public function isSurveyStarted($user_id, $anonymize_id, $appr_id = 0)
    {
        $ilDB = $this->db;
 
        // #15031 - should not matter if code was used by registered or anonymous (each code must be unique)
        if ($anonymize_id) {
            $result = $ilDB->queryF(
                "SELECT * FROM svy_finished" .
                " WHERE survey_fi = %s AND anonymous_id = %s AND appr_id = %s",
                array('integer','text','integer'),
                array($this->getSurveyId(), $anonymize_id, $appr_id)
            );
        } else {
            $result = $ilDB->queryF(
                "SELECT * FROM svy_finished" .
                " WHERE survey_fi = %s AND user_fi = %s AND appr_id = %s",
                array('integer','integer','integer'),
                array($this->getSurveyId(), $user_id, $appr_id)
            );
        }
        if ($result->numRows() == 0) {
            return false;
        } else {
            $row = $ilDB->fetchAssoc($result);
            // yes, we are doing it this way
            $_SESSION["finished_id"][$this->getId()] = $row["finished_id"];
            
            return (int) $row["state"];
        }
    }
 
    public function getActiveID($user_id, $anonymize_id, $appr_id)
    {
        $ilDB = $this->db;
 
        // see self::isSurveyStarted()
        
        // #15031 - should not matter if code was used by registered or anonymous (each code must be unique)
        if ($anonymize_id) {
            $result = $ilDB->queryF(
                "SELECT finished_id FROM svy_finished" .
                " WHERE survey_fi = %s AND anonymous_id = %s AND appr_id = %s",
                array('integer','text','integer'),
                array($this->getSurveyId(), $anonymize_id, $appr_id)
            );
        } else {
            $result = $ilDB->queryF(
                "SELECT finished_id FROM svy_finished" .
                " WHERE survey_fi = %s AND user_fi = %s AND appr_id = %s",
                array('integer','integer','integer'),
                array($this->getSurveyId(), $user_id, $appr_id)
            );
        }
        if ($result->numRows() == 0) {
            return false;
        } else {
            $row = $ilDB->fetchAssoc($result);
            return $row["finished_id"];
        }
    }
    
    public function getLastActivePage($active_id)
    {
        $ilDB = $this->db;
        $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"] : '';
        }
    }
 
    public function checkConstraint($constraint_data, $working_data)
    {
        if (!is_array($working_data) || 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;
    }
    
    public static function _hasDatasets($survey_id)
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        
        $result = $ilDB->queryF(
            "SELECT finished_id FROM svy_finished WHERE survey_fi = %s",
            array('integer'),
            array($survey_id)
        );
        return ($result->numRows()) ? true : false;
    }
 
    public function &getSurveyFinishedIds()
    {
        $ilDB = $this->db;
        $ilLog = $this->log;
        
        $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;
    }
    
    public function getUserSpecificResults($finished_ids)
    {
        $evaluation = array();
        
        foreach (array_keys($this->getSurveyQuestions()) as $question_id) {
            // get question instance
            $question_type = SurveyQuestion::_getQuestionType($question_id);
            SurveyQuestion::_includeClass($question_type);
            $question = new $question_type();
            $question->loadFromDb($question_id);
            
            $q_eval = SurveyQuestion::_instanciateQuestionEvaluation($question_id, $finished_ids);
            $q_res = $q_eval->getResults();
            
            $data = array();
            foreach ($finished_ids as $user_id) {
                $data[$user_id] = $q_eval->parseUserSpecificResults($q_res, $user_id);
            }
            
            $evaluation[$question_id] = $data;
        }
        
        return $evaluation;
    }
    
    public function getUserDataFromActiveId($active_id, $force_non_anonymous = false)
    {
        $ilDB = $this->db;
 
        $surveySetting = new ilSetting("survey");
        $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->hasAnonymizedResults() &&
                        !$this->get360Mode()) ||  // 360° uses ANONYMIZE_CODE_ALL which is wrong - see ilObjSurveyGUI::afterSave()
                    (bool) $force_non_anonymous)) {
                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['usr_id'] = $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;
    }
    
    public function &getEvaluationByUser($questions, $active_id)
    {
        $ilDB = $this->db;
        
        // 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"],
            "firstname" => $userdata["firstname"],
            "lastname" => $userdata["lastname"],
            "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;
    }
    
    public function getQuestionsTable($arrFilter)
    {
        $ilUser = $this->user;
        $ilDB = $this->db;
        $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');
        }
        
        $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;
    }
 
    public function getQuestionblocksTable($arrFilter)
    {
        $ilUser = $this->user;
        $ilDB = $this->db;
        
        $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;
    }
 
    public function toXML()
    {
        $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->getStartDate()) {
            $attrs = array("type" => "date");
            preg_match("/(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})/", $this->getStartDate(), $matches);
            $a_xml_writer->xmlElement("startingtime", $attrs, sprintf("%04d-%02d-%02dT%02d:%02d:00", $matches[1], $matches[2], $matches[3], $matches[4], $matches[5], $matches[6]));
        }
        if ($this->getEndDate()) {
            $attrs = array("type" => "date");
            preg_match("/(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})/", $this->getEndDate(), $matches);
            $a_xml_writer->xmlElement("endingtime", $attrs, sprintf("%04d-%02d-%02dT%02d:%02d:00", $matches[1], $matches[2], $matches[3], $matches[4], $matches[5], $matches[6]));
        }
        $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");
 
        $custom_properties = array();
        $custom_properties["evaluation_access"] = $this->getEvaluationAccess();
        $custom_properties["status"] = !$this->getOfflineStatus();
        $custom_properties["display_question_titles"] = $this->getShowQuestionTitles();
        $custom_properties["pool_usage"] = (int) $this->getPoolUsage();
        
        $custom_properties["own_results_view"] = (int) $this->hasViewOwnResults();
        $custom_properties["own_results_mail"] = (int) $this->hasMailOwnResults();
        $custom_properties["confirmation_mail"] = (int) $this->hasMailConfirmation();
        
        $custom_properties["anon_user_list"] = (int) $this->hasAnonymousUserList();
        $custom_properties["mode"] = (int) $this->getMode();
        $custom_properties["mode_360_self_eval"] = (int) $this->get360SelfEvaluation();
        $custom_properties["mode_360_self_rate"] = (int) $this->get360SelfRaters();
        $custom_properties["mode_360_self_appr"] = (int) $this->get360SelfAppraisee();
        $custom_properties["mode_360_results"] = $this->get360Results();
        $custom_properties["mode_skill_service"] = (int) $this->getSkillService();
        $custom_properties["mode_self_eval_results"] = (int) $this->getSelfEvaluationResults();
        
        
        // :TODO: skills?
                
        // reminder/tutor notification are (currently?) not exportable
        
        foreach ($custom_properties as $label => $value) {
            $a_xml_writer->xmlStartTag("metadatafield");
            $a_xml_writer->xmlElement("fieldlabel", null, $label);
            $a_xml_writer->xmlElement("fieldentry", null, $value);
            $a_xml_writer->xmlEndTag("metadatafield");
        }
 
        $a_xml_writer->xmlStartTag("metadatafield");
        $a_xml_writer->xmlElement("fieldlabel", null, "SCORM");
        $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
        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 = self::_instanciateQuestion($question["question_id"]);
                //questionObject contains all the fields from the database. (loadFromDb)
                //we don't need the value from svy_qst_oblig table, we already have the values from svy_question table.
                //if ($questionObject !== FALSE) $questionObject->insertXML($a_xml_writer, FALSE, $obligatory_states[$question["question_id"]]);
                if ($questionObject !== false) {
                    $questionObject->insertXML($a_xml_writer, false);
                }
            }
            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;
    }
 
    public static function _instanciateQuestion($question_id)
    {
        if ($question_id < 1) {
            return false;
        }
        $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;
    }
 
    public 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 != "..") &&
                    (preg_match("/^[0-9]{10}__[0-9]+__(svy_)*[0-9]+\.[A-Za-z]{1,3}$/", $file) ||
                        preg_match("/^[0-9]{10}__[0-9]+__(survey__)*[0-9]+\.[A-Za-z]{1,3}$/", $file))) {
                    // found xml file
                    $xmlFile = $importDirectory . "/" . $file;
                }
            }
        }
        return array("dir" => $importDirectory, "xml" => $xmlFile);
    }
 
    public 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)) {
            $this->log->debug("isXML");
            $isXml = true;
        }
        // too many different mime-types, so we use the suffix
        $suffix = pathinfo($file_info["name"]);
        if (strcmp(strtolower($suffix["extension"]), "zip") == 0) {
            $this->log->debug("isZip");
            $isZip = true;
        }
        if (!$isXml && !$isZip) {
            $error = $this->lng->txt("import_wrong_file_type");
            $this->log->debug("Survey: Import error. Filetype was \"" . $file_info["type"] . "\"");
        }
        if (strlen($error) == 0) {
            // import file as a survey
            $import_dir = $this->getImportDirectory();
            $import_subdir = "";
            $importfile = "";
            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);
            }
 
            $this->log->debug("Import file = $importfile");
            $this->log->debug("Import subdir = $import_subdir");
 
            $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")) {
                throw new ilInvalidSurveyImportFileException("Unsupported survey version (< 3.8) found.");
            } else {
                $this->log->debug("survey id = " . $this->getId());
                $this->log->debug("question pool id = " . $svy_qpl_id);
 
                $imp = new ilImport();
                $config = $imp->getConfig("Modules/Survey");
                $config->setQuestionPoolID($svy_qpl_id);
                $imp->getMapping()->addMapping("Modules/Survey", "svy", 0, $this->getId());
                $imp->importFromDirectory($import_subdir, "svy", "Modules/Survey");
                $this->log->debug("config(Modules/survey)->getQuestionPoolId =" . $config->getQuestionPoolID());
                return "";
 
                //old code
                $import = new SurveyImportParser($svy_qpl_id, "", true);
                $import->setSurveyObject($this);
                $import->setXMLContent($xml);
                $import->startParsing();
            }
 
            if (is_array($_SESSION["import_mob_xhtml"])) {
                foreach ($_SESSION["import_mob_xhtml"] as $mob) {
                    $importfile = $import_subdir . "/" . $mob["uri"];
                    if (file_exists($importfile)) {
                        if (!$mob["type"]) {
                            $mob["type"] = "svy:html";
                        }
                        
                        $media_object = ilObjMediaObject::_saveTempFileAsMediaObject(basename($importfile), $importfile, false);
                        
                        // survey mob
                        if ($mob["type"] == "svy:html") {
                            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()));
                        }
                        // question mob
                        elseif ($import->questions[$mob["id"]]) {
                            $new_qid = $import->questions[$mob["id"]];
                            ilObjMediaObject::_saveUsage($media_object->getId(), $mob["type"], $new_qid);
                            $new_question = SurveyQuestion::_instanciateQuestion($new_qid);
                            $qtext = $new_question->getQuestiontext();
                            $qtext = ilRTE::_replaceMediaObjectImageSrc($qtext, 0);
                            $qtext = str_replace("src=\"" . $mob["mob"] . "\"", "src=\"" . "il_" . IL_INST_ID . "_mob_" . $media_object->getId() . "\"", $qtext);
                            $qtext = ilRTE::_replaceMediaObjectImageSrc($qtext, 1);
                            $new_question->setQuestiontext($qtext);
                            $new_question->saveToDb();
                            
                            // also fix existing original in pool
                            if ($new_question->getOriginalId()) {
                                $pool_question = SurveyQuestion::_instanciateQuestion($new_question->getOriginalId());
                                $pool_question->setQuestiontext($qtext);
                                $pool_question->saveToDb();
                            }
                        }
                    } else {
                        $ilLog = $this->log;
                        $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, $a_omit_tree = false)
    {
        $ilDB = $this->db;
        
        $this->loadFromDb();
 
        //survey mode
        $svy_type = $this->getMode();
 
        // Copy settings
        $newObj = parent::cloneObject($a_target_id, $a_copy_id, $a_omit_tree);
        $this->cloneMetaData($newObj);
        $newObj->updateMetaData();
        
        $newObj->setAuthor($this->getAuthor());
        $newObj->setIntroduction($this->getIntroduction());
        $newObj->setOutro($this->getOutro());
        $newObj->setEvaluationAccess($this->getEvaluationAccess());
        $newObj->setStartDate($this->getStartDate());
        $newObj->setEndDate($this->getEndDate());
        $newObj->setAnonymize($this->getAnonymize());
        $newObj->setShowQuestionTitles($this->getShowQuestionTitles());
        $newObj->setTemplate($this->getTemplate());
        $newObj->setPoolUsage($this->getPoolUsage());
        $newObj->setViewOwnResults($this->hasViewOwnResults());
        $newObj->setMailOwnResults($this->hasMailOwnResults());
        $newObj->setMailConfirmation($this->hasMailConfirmation());
        $newObj->setAnonymousUserList($this->hasAnonymousUserList());
        
        // #12661
        if ($this->get360Mode()) {
            $newObj->setMode(ilObjSurvey::MODE_360);
            $newObj->set360SelfEvaluation($this->get360SelfEvaluation());
            $newObj->set360SelfAppraisee($this->get360SelfAppraisee());
            $newObj->set360SelfRaters($this->get360SelfRaters());
            $newObj->set360Results($this->get360Results());
            $newObj->setSkillService($this->getSkillService());
        }
        //svy mode self eval: skills + view results
        if ($svy_type == ilObjSurvey::MODE_SELF_EVAL) {
            $newObj->setMode(ilObjSurvey::MODE_SELF_EVAL);
            $newObj->setSkillService($this->getSkillService());
            $newObj->setSelfEvaluationResults($this->getSelfEvaluationResults());
        }
                
        // reminder/notification
        $newObj->setReminderStatus($this->getReminderStatus());
        $newObj->setReminderStart($this->getReminderStart());
        $newObj->setReminderEnd($this->getReminderEnd());
        $newObj->setReminderFrequency($this->getReminderFrequency());
        $newObj->setReminderTarget($this->getReminderTarget());
        $newObj->setReminderTemplate($this->getReminderTemplate());
        // reminder_last_sent must not be copied!
        $newObj->setTutorNotificationStatus($this->getTutorNotificationStatus());
        $newObj->setTutorNotificationRecipients($this->getTutorNotificationRecipients());
        $newObj->setTutorNotificationTarget($this->getTutorNotificationTarget());
        $newObj->setTutorResultsStatus($this->getTutorResultsStatus());
        $newObj->setTutorResultsRecipients($this->getTutorResultsRecipients());
 
        $newObj->setMailNotification($this->getMailNotification());
        $newObj->setMailAddresses($this->getMailAddresses());
        $newObj->setMailParticipantData($this->getMailParticipantData());
 
        $question_pointer = array();
        // clone the questions
        $mapping = array();
 
        foreach ($this->questions as $key => $question_id) {
            $question = self::_instanciateQuestion($question_id);
            if ($question) { // #10824
                $question->id = -1;
                $original_id = SurveyQuestion::_getOriginalId($question_id, false);
                $question->setObjId($newObj->getId());
                $question->saveToDb($original_id);
                $newObj->questions[$key] = $question->getId();
                $question_pointer[$question_id] = $question->getId();
                $mapping[$question_id] = $question->getId();
            }
        }
 
        //copy online status if object is not the root copy object
        $cp_options = ilCopyWizardOptions::_getInstance($a_copy_id);
 
        if (!$cp_options->isRootNode($this->getRefId())) {
            $newObj->setOfflineStatus($this->getOfflineStatus());
        }
 
        $newObj->saveToDb();
        $newObj->cloneTextblocks($mapping);
        
        // #14929
        if (($svy_type == ilObjSurvey::MODE_360 || $svy_type == ilObjSurvey::MODE_SELF_EVAL) &&
            $this->getSkillService()) {
            $src_skills = new ilSurveySkill($this);
            $tgt_skills = new ilSurveySkill($newObj);
            
            foreach ($mapping as $src_qst_id => $tgt_qst_id) {
                $qst_skill = $src_skills->getSkillForQuestion($src_qst_id);
                if ($qst_skill) {
                    $tgt_skills->addQuestionSkillAssignment($tgt_qst_id, $qst_skill["base_skill_id"], $qst_skill["tref_id"]);
                }
            }
        }
 
        // 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 = self::_getQuestionblock($key);
            $questionblock_id = self::_addQuestionblock($questionblock["title"], $questionblock["owner_fi"], $questionblock["show_questiontext"], $questionblock["show_blocktitle"]);
            $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 = self::_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']]);
            }
        }
 
        // #16210 - clone LP settings
        $obj_settings = new ilLPObjSettings($this->getId());
        $obj_settings->cloneSettings($newObj->getId());
        unset($obj_settings);
        
        return $newObj;
    }
    
    public function getTextblock($question_id)
    {
        $ilDB = $this->db;
        $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 "";
        }
    }
 
    public function cloneTextblocks($mapping)
    {
        foreach ($mapping as $original_id => $new_id) {
            $textblock = $this->getTextblock($original_id);
            $this->saveHeading(ilUtil::stripSlashes($textblock, true, ilObjAdvancedEditing::_getUsedHTMLTagsAsString("survey")), $new_id);
        }
    }
 
    public function createExportDirectory()
    {
        $svy_data_dir = ilUtil::getDataDir() . "/svy_data";
        ilUtil::makeDir($svy_data_dir);
        if (!is_writable($svy_data_dir)) {
            throw new ilSurveyException("Survey Data Directory (" . $svy_data_dir . ") not writeable.");
        }
        
        // 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)) {
            throw new ilSurveyException("Creation of Survey Directory failed.");
        }
        // create Export subdirectory (data_dir/lm_data/lm_<id>/Export)
        $export_dir = $svy_dir . "/export";
        ilUtil::makeDir($export_dir);
        if (!@is_dir($export_dir)) {
            throw new ilSurveyException("Creation of Export Directory failed.");
        }
    }
 
    public function getExportDirectory()
    {
        $export_dir = ilUtil::getDataDir() . "/svy_data" . "/svy_" . $this->getId() . "/export";
 
        return $export_dir;
    }
    
    public function createImportDirectory()
    {
        $svy_data_dir = ilUtil::getDataDir() . "/svy_data";
        ilUtil::makeDir($svy_data_dir);
        
        if (!is_writable($svy_data_dir)) {
            throw new ilSurveyException("Survey Data Directory (" . $svy_data_dir . ") not writeable.");
        }
 
        // 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)) {
            throw new ilSurveyException("Creation of Survey Directory failed.");
        }
 
        // create import subdirectory (data_dir/svy_data/svy_<id>/import)
        $import_dir = $svy_dir . "/import";
        ilUtil::makeDir($import_dir);
        if (!@is_dir($import_dir)) {
            throw new ilSurveyException("Creation of Import Directory failed.");
        }
    }
 
    public function getImportDirectory()
    {
        $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;
        }
    }
    
    public function saveHeading($heading = "", $insertbefore)
    {
        $ilDB = $this->db;
        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)
            );
        }
    }
 
    public function isAnonymousKey($key)
    {
        $ilDB = $this->db;
        
        $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;
    }
    
    public function bindSurveyCodeToUser($user_id, $code)
    {
        $ilDB = $this->db;
        
        if ($user_id == ANONYMOUS_USER_ID) {
            return;
        }
        
        if ($this->checkSurveyCode($code)) {
            $ilDB->manipulate("UPDATE svy_anonymous" .
                " SET user_key = " . $ilDB->quote(md5($user_id), "text") .
                " WHERE survey_key = " . $ilDB->quote($code, "text"));
        }
    }
    
    public function isAnonymizedParticipant($key)
    {
        $ilDB = $this->db;
        
        $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;
    }
    
    public function checkSurveyCode($code)
    {
        if ($this->isAnonymousKey($code)) {
            if ($this->isSurveyStarted("", $code) == 1) {
                return false;
            } else {
                return true;
            }
        } else {
            return false;
        }
    }
 
    public function getSurveyCodesForExport(array $a_codes = null, array $a_ids = null)
    {
        $ilDB = $this->db;
        $ilUser = $this->user;
        $lng = $this->lng;
        
        $sql = "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 = " . $ilDB->quote($this->getSurveyId(), "integer") .
            " AND svy_anonymous.user_key IS NULL";
        
        if ($a_codes) {
            $sql .= " AND " . $ilDB->in("svy_anonymous.survey_key", $a_codes, "", "text");
        } elseif ($a_ids) {
            $sql .= " AND " . $ilDB->in("svy_anonymous.anonymous_id", $a_ids, "", "text");
        }
        
        $export = array();
        
        // #14905
        $titles = array();
        $titles[] = '"' . $lng->txt("survey_code") . '"';
        $titles[] = '"' . $lng->txt("email") . '"';
        $titles[] = '"' . $lng->txt("lastname") . '"';
        $titles[] = '"' . $lng->txt("firstname") . '"';
        $titles[] = '"' . $lng->txt("create_date") . '"';
        $titles[] = '"' . $lng->txt("used") . '"';
        $titles[] = '"' . $lng->txt("mail_sent_short") . '"';
        $titles[] = '"' . $lng->txt("survey_code_url") . '"';
        $export[] = implode(";", $titles);
                
        $result = $ilDB->query($sql);
        $default_lang = $ilUser->getPref("survey_code_language");
        while ($row = $ilDB->fetchAssoc($result)) {
            $item = array();
            $item[] = $row["survey_key"];
            
            if ($row["externaldata"]) {
                $ext = unserialize($row["externaldata"]);
                $item[] = $ext["email"];
                $item[] = $ext["lastname"];
                $item[] = $ext["firstname"];
            } else {
                $item[] = "";
                $item[] = "";
                $item[] = "";
            }
                        
            // No relative (today, tomorrow...) dates in export.
            $date = new ilDateTime($row['tstamp'], IL_CAL_UNIX);
            $item[] = $date->get(IL_CAL_DATETIME);
            
            $item[] = ($this->isSurveyCodeUsed($row["survey_key"])) ? 1 : 0;
            $item[] = ($row["sent"]) ? 1 : 0;
            
            $params = array("accesscode" => $row["survey_key"]);
            if ($default_lang) {
                $params["lang"] = $default_lang;
            }
            $item[] = ilLink::_getLink($this->getRefId(), "svy", $params);
                
            $export[] = '"' . implode('";"', $item) . '"';
        }
        return implode("\n", $export);
    }
    
    public function getSurveyCodesTableData(array $ids = null, $lang = null)
    {
        $ilDB = $this->db;
        
        $codes = array();
 
        $sql = "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 = " . $ilDB->quote($this->getSurveyId(), "integer") /*.
            " AND svy_anonymous.user_key IS NULL" */; // #15860
        
        if ($ids) {
            $sql .= " AND " . $ilDB->in("svy_anonymous.anonymous_id", $ids, "", "integer");
        }
        
        $sql .= " ORDER BY tstamp, survey_key ASC";
        $result = $ilDB->query($sql);
        if ($result->numRows() > 0) {
            while ($row = $ilDB->fetchAssoc($result)) {
                $href = "";
                $used = false;
                if ($this->isSurveyCodeUsed($row["survey_key"])) {
                    $used = true;
                } else {
                    $params = array("accesscode" => $row["survey_key"]);
                    if ($lang) {
                        $params["lang"] = $lang;
                    }
                    $href = ilLink::_getLink($this->getRefId(), "svy", $params);
                }
                
                
                $item = array(
                    'id' => $row["anonymous_id"],
                    'code' => $row["survey_key"],
                    'date' => $row["tstamp"],
                    'used' => $used,
                    'sent' => $row['sent'],
                    'href' => $href,
                    'email' => '',
                    'last_name' => '',
                    'first_name' => ''
                );
                
                if ($row["externaldata"]) {
                    $ext = unserialize($row["externaldata"]);
                    $item['email'] = $ext['email'];
                    $item['last_name'] = $ext['lastname'];
                    $item['first_name'] = $ext['firstname'];
                }
                                                
                array_push($codes, $item);
            }
        }
        return $codes;
    }
 
    public function isSurveyCodeUsed($code)
    {
        $ilDB = $this->db;
        $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;
    }
    
    public function isSurveyCodeUnique($code)
    {
        $ilDB = $this->db;
        $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;
    }
    
    public function createSurveyCodes($nrOfCodes)
    {
        $ilDB = $this->db;
        
        $res = array();
        
        for ($i = 0; $i < $nrOfCodes; $i++) {
            $next_id = $ilDB->nextId('svy_anonymous');
            $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, $this->createNewAccessCode(), $this->getSurveyId(), time())
            );
            $res[] = $next_id;
        }
        
        return $res;
    }
    
    public function importSurveyCode($a_anonymize_key, $a_created, $a_data)
    {
        $ilDB = $this->db;
        
        $next_id = $ilDB->nextId('svy_anonymous');
        $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, $a_anonymize_key, $this->getSurveyId(), serialize($a_data), $a_created)
        );
    }
 
    public function createSurveyCodesForExternalData($data)
    {
        $ilDB = $this->db;
        
        $ids = array();
        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())
            );
            $ids[] = $next_id;
        }
        return $ids;
    }
 
    public function sendCodes($not_sent, $subject, $message, $lang)
    {
        global $DIC;
        /*
         * 0 = all
         * 1 = not sent
         * 2 = finished
         * 3 = not finished
         */
        $check_finished = ($not_sent > 1);
        
 
        $mail = new ilMail(ANONYMOUS_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 = ilLink::_getLink(
                        $this->getRefId(),
                        "svy",
                        array(
                            "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->enqueue(
                        $data['email'], // to
                        "", // cc
                        "", // bcc
                        $subject, // subject
                        $messagetext, // message
                        array() // attachments
                    );
                }
            }
        }
 
        $ilDB = $this->db;
        $ilDB->manipulateF(
            "UPDATE svy_anonymous SET sent = %s WHERE survey_fi = %s AND externaldata IS NOT NULL",
            array('integer','integer'),
            array(1, $this->getSurveyId())
        );
    }
 
    public function getExternalCodeRecipients($a_check_finished = false)
    {
        $ilDB = $this->db;
        $result = $ilDB->queryF(
            "SELECT survey_key code, externaldata, sent FROM svy_anonymous WHERE survey_fi = %s",
            array('integer'),
            array($this->getSurveyId())
        );
        $res = array();
        while ($row = $ilDB->fetchAssoc($result)) {
            if (!$row['externaldata']) {
                continue;
            }
            
            $externaldata = unserialize($row['externaldata']);
            if (!$externaldata['email']) {
                continue;
            }
            
            $externaldata['code'] = $row['code'];
            $externaldata['sent'] = $row['sent'];
            
            if ($a_check_finished) {
                #23294
                //$externaldata['finished'] =  $this->isSurveyCodeUsed($row['code']);
                $externaldata['finished'] = $this->isSurveyFinishedByCode($row['code']);
            }
            
            array_push($res, $externaldata);
        }
        return $res;
    }
 
    public function isSurveyFinishedByCode($a_code)
    {
        $result = $this->db->queryF(
            "SELECT state FROM svy_finished WHERE survey_fi = %s AND anonymous_id = %s",
            array('integer','text'),
            array($this->getSurveyId(), $a_code)
        );
 
        $row = $this->db->fetchAssoc($result);
 
        return $row['state'];
    }
    
    public function deleteSurveyCode($survey_code)
    {
        $ilDB = $this->db;
        
        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)
            );
        }
    }
    
    public function getUserAccessCode($user_id)
    {
        $ilDB = $this->db;
        $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;
    }
    
    public function saveUserAccessCode($user_id, $access_code)
    {
        $ilDB = $this->db;
        
        // not really sure what to do about ANONYMOUS_USER_ID
        
        $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())
        );
    }
    
    public 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;
    }
    
    public function getLastAccess($finished_id)
    {
        $ilDB = $this->db;
        
        $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 "";
    }
 
    public function prepareTextareaOutput($txt_output)
    {
        return ilUtil::prepareTextareaOutput($txt_output, $prepare_for_latex_output);
    }
 
    public function isHTML($a_text)
    {
        if (preg_match("/<[^>]*?>/", $a_text)) {
            return true;
        } else {
            return false;
        }
    }
 
    public function addMaterialTag(&$a_xml_writer, $a_material, $close_material_tag = true, $add_mobs = true, $attribs = null)
    {
        $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(),
                        "type" => "svy:html",
                        "id" => $this->getId()
                    );
                    $a_xml_writer->xmlElement("matimage", $imgattrs, null);
                }
            }
        }
        if ($close_material_tag) {
            $a_xml_writer->xmlEndTag("material");
        }
    }
 
    public function canExportSurveyCode()
    {
        if ($this->getAnonymize() != self::ANONYMIZE_OFF) {
            if ($this->surveyCodeSecurity == false) {
                return true;
            }
        }
        return false;
    }
 
    public function processPrintoutput2FO($print_output)
    {
        if (extension_loaded("tidy")) {
            $config = array(
                "indent" => false,
                "output-xml" => true,
                "numeric-entities" => true
            );
            $tidy = new tidy();
            $tidy->parseString($print_output, $config, 'utf8');
            $tidy->cleanRepair();
            $print_output = tidy_get_output($tidy);
            $print_output = preg_replace("/^.*?(<html)/", "\\1", $print_output);
        } else {
            $print_output = str_replace("&nbsp;", "&#160;", $print_output);
            $print_output = str_replace("&otimes;", "X", $print_output);
            
            // #17680 - metric questions use &#160; in print view
            $print_output = str_replace("&gt;", "~|gt|~", $print_output);               // see #21550
            $print_output = str_replace("&lt;", "~|lt|~", $print_output);
            $print_output = str_replace("&#160;", "~|nbsp|~", $print_output);
            $print_output = preg_replace('/&(?!amp)/', '&amp;', $print_output);
            $print_output = str_replace("~|nbsp|~", "&#160;", $print_output);
            $print_output = str_replace("~|gt|~", "&gt;", $print_output);
            $print_output = str_replace("~|lt|~", "&lt;", $print_output);
        }
        $xsl = file_get_contents("./Modules/Survey/xml/question2fo.xsl");
 
        // additional font support
        $xsl = str_replace(
            'font-family="Helvetica, unifont"',
            'font-family="' . $GLOBALS['ilSetting']->get('rpc_pdf_font', 'Helvetica, unifont') . '"',
            $xsl
        );
        $args = array( '/_xml' => $print_output, '/_xsl' => $xsl );
        $xh = xslt_create();
        $params = array();
        try {
            $output = xslt_process($xh, "arg:/_xml", "arg:/_xsl", null, $args, $params);
        } catch (Exception $e) {
            $this->log->error("Print XSLT failed:");
            $this->log->error("Content: " . $print_output);
            $this->log->error("Xsl: " . $xsl);
            throw ($e);
        }
        xslt_error($xh);
        xslt_free($xh);
 
        return $output;
    }
    
    public function deliverPDFfromFO($fo)
    {
        $ilLog = $this->log;
 
        $fo_file = ilUtil::ilTempnam() . ".fo";
        $fp = fopen($fo_file, "w");
        fwrite($fp, $fo);
        fclose($fp);
 
        try {
            $pdf_base64 = ilRpcClientFactory::factory('RPCTransformationHandler')->ilFO2PDF($fo);
            ilUtil::deliverData($pdf_base64->scalar, ilUtil::getASCIIFilename($this->getTitle()) . ".pdf", "application/pdf");
            return true;
        } catch (Exception $e) {
            $ilLog->write(__METHOD__ . ': ' . $e->getMessage());
            return false;
        }
    }
 
    public function isPluginActive($a_pname)
    {
        $ilPluginAdmin = $this->plugin_admin;
        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)
    {
        $ilDB = $this->db;
 
        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;
    }
 
    public function getMailNotification()
    {
        return $this->mailnotification;
    }
    
    public function setMailNotification($a_notification)
    {
        $this->mailnotification = ($a_notification) ? true : false;
    }
    
    public function getMailAddresses()
    {
        return $this->mailaddresses;
    }
    
    public function setMailAddresses($a_addresses)
    {
        $this->mailaddresses = $a_addresses;
    }
    
    public function getMailParticipantData()
    {
        return $this->mailparticipantdata;
    }
    
    public function setMailParticipantData($a_data)
    {
        $this->mailparticipantdata = $a_data;
    }
    
    public function setStartTime($finished_id, $first_question)
    {
        $ilDB = $this->db;
        $time = time();
        //primary for table svy_times
        $id = $ilDB->nextId('svy_times');
        $_SESSION['svy_entered_page'] = $time;
        $affectedRows = $ilDB->manipulateF(
            "INSERT INTO svy_times (id, finished_fi, entered_page, left_page, first_question) VALUES (%s, %s, %s, %s,%s)",
            array('integer','integer', 'integer', 'integer', 'integer'),
            array($id, $finished_id, $time, null, $first_question)
        );
    }
    
    public function setEndTime($finished_id)
    {
        $ilDB = $this->db;
        $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']);
    }
    
    public function getWorkingtimeForParticipant($finished_id)
    {
        $ilDB = $this->db;
 
        $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;
    }
 
    public function setTemplate($template_id)
    {
        $this->template_id = (int) $template_id;
    }
 
    public function getTemplate()
    {
        return $this->template_id;
    }
 
    public function updateOrder(array $a_order)
    {
        if (sizeof($this->questions) == sizeof($a_order)) {
            $this->questions = array_flip($a_order);
            $this->saveQuestionsToDB();
        }
    }
 
    public function getPoolUsage()
    {
        return $this->pool_usage;
    }
 
    public function setPoolUsage($a_value)
    {
        $this->pool_usage = (bool) $a_value;
    }
 
    public function isPoolActive()
    {
        $use_pool = (bool) $this->getPoolUsage();
        $template_settings = $this->getTemplate();
        if ($template_settings) {
            $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;
    }
    
    public function applySettingsTemplate($template_id)
    {
        if (!$template_id) {
            return;
        }
        
        $template = new ilSettingsTemplate($template_id);
        $template_settings = $template->getSettings();
        //ilUtil::dumpVar($template_settings); exit;
        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);
                }
            }
 
 
            /* see #0021719
            if($template_settings["anonymization_options"]["value"])
            {
                $anon_map = array('personalized' => self::ANONYMIZE_OFF,
                    'anonymize_with_code' => self::ANONYMIZE_ON,
                    'anonymize_without_code' => self::ANONYMIZE_FREEACCESS);
                $this->setAnonymize($anon_map[$template_settings["anonymization_options"]["value"]]);
            }*/
 
            // see #0021719 and ilObjectSurveyGUI::savePropertiesObject
            $this->setEvaluationAccess($template_settings["evaluation_access"]["value"]);
            $codes = (bool) $template_settings["acc_codes"]["value"];
            $anon = (bool) $template_settings["anonymization_options"]["value"];
            if (!$anon) {
                if (!$codes) {
                    $this->setAnonymize(ilObjSurvey::ANONYMIZE_OFF);
                } else {
                    $this->setAnonymize(ilObjSurvey::ANONYMIZE_CODE_ALL);
                }
            } else {
                if ($codes) {
                    $this->setAnonymize(ilObjSurvey::ANONYMIZE_ON);
                } else {
                    $this->setAnonymize(ilObjSurvey::ANONYMIZE_FREEACCESS);
                }
 
                $this->setAnonymousUserList($_POST["anon_list"]);
            }
 
 
 
            /* other settings: not needed here
             * - enabled_end_date
             * - enabled_start_date
             * - rte_switch
             */
        }
 
        $this->setTemplate($template_id);
        $this->saveToDb();
    }
    
    public function updateCode($a_id, $a_email, $a_last_name, $a_first_name, $a_sent)
    {
        $ilDB = $this->db;
        
        $a_email = trim($a_email);
 
        // :TODO:
        if (($a_email && !ilUtil::is_email($a_email)) || $a_email == "") {
            return false;
        }
        
        $data = array("email" => $a_email,
            "lastname" => trim($a_last_name),
            "firstname" => trim($a_first_name));
        
        $fields = array(
            "externaldata" => array("text", serialize($data)),
            "sent" => array("integer", $a_sent)
        );
        
        $ilDB->update(
            "svy_anonymous",
            $fields,
            array("anonymous_id" => array("integer", $a_id))
        );
 
        return true;
    }
    
    
    //
    // 360°
    //
 
    public function get360Mode()
    {
        if ($this->getMode() == ilObjSurvey::MODE_360) {
            return true;
        }
        return false;
    }
    
    public function set360SelfEvaluation($a_value)
    {
        $this->mode_360_self_eval = (bool) $a_value;
    }
    
    public function get360SelfEvaluation()
    {
        return (bool) $this->mode_360_self_eval;
    }
    
    public function set360SelfAppraisee($a_value)
    {
        $this->mode_360_self_appr = (bool) $a_value;
    }
    
    public function get360SelfAppraisee()
    {
        return (bool) $this->mode_360_self_appr;
    }
    
    public function set360SelfRaters($a_value)
    {
        $this->mode_360_self_rate = (bool) $a_value;
    }
    
    public function get360SelfRaters()
    {
        return (bool) $this->mode_360_self_rate;
    }
    
    public function set360Results($a_value)
    {
        $this->mode_360_results = (int) $a_value;
    }
    
    public function get360Results()
    {
        return (int) $this->mode_360_results;
    }
    
    public function addAppraisee($a_user_id)
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $access = $DIC->access();
        
        if (!$this->isAppraisee($a_user_id) &&
            $a_user_id != ANONYMOUS_USER_ID) {
            $fields = array(
                "obj_id" => array("integer", $this->getSurveyId()),
                "user_id" => array("integer", $a_user_id)
            );
            $ilDB->insert("svy_360_appr", $fields);
 
            // send notification and add to desktop
            if ($access->checkAccessOfUser($a_user_id, "read", "", $this->getRefId())) {
                $this->sendAppraiseeNotification($a_user_id);
            }
        }
    }
 
    public function sendAppraiseeNotification($a_user_id)
    {
        $ntf = new ilSystemNotification();
        $ntf->setLangModules(array("svy", "survey"));
        $ntf->setRefId($this->getRefId());
        $ntf->setGotoLangId('url');
 
        // user specific language
        $lng = $ntf->getUserLanguage($a_user_id);
 
        $ntf->setIntroductionLangId("svy_user_added_360_appraisee_mail");
        $subject = str_replace("%1", $this->getTitle(), $lng->txt("svy_user_added_360_appraisee"));
 
        // #10044
        $mail = new ilMail(ANONYMOUS_USER_ID);
        $mail->enqueue(
            ilObjUser::_lookupLogin($a_user_id),
            null,
            null,
            $subject,
            $ntf->composeAndGetMessage($a_user_id, null, "read", true),
            []
        );
    }
 
    public function sendAppraiseeCloseNotification($a_user_id)
    {
        $ntf = new ilSystemNotification();
        $ntf->setLangModules(array("svy", "survey"));
        $ntf->setRefId($this->getRefId());
        $ntf->setGotoLangId('url');
 
        // user specific language
        $lng = $ntf->getUserLanguage($a_user_id);
 
        $ntf->setIntroductionLangId("svy_user_added_360_appraisee_close_mail");
        $subject = str_replace("%1", $this->getTitle(), $lng->txt("svy_user_added_360_appraisee"));
 
        // #10044
        $mail = new ilMail(ANONYMOUS_USER_ID);
        $mail->enqueue(
            ilObjUser::_lookupLogin($a_user_id),
            null,
            null,
            $subject,
            $ntf->composeAndGetMessage($a_user_id, null, "read", true),
            []
        );
    }
 
    public function sendRaterNotification($a_user_id, $a_appraisee_id)
    {
        $ntf = new ilSystemNotification();
        $ntf->setLangModules(array("svy", "survey"));
        $ntf->setRefId($this->getRefId());
        $ntf->setGotoLangId('url');
 
        // user specific language
        $lng = $ntf->getUserLanguage($a_user_id);
 
        $ntf->setIntroductionLangId("svy_user_added_360_rater_mail");
        $subject = str_replace("%1", $this->getTitle(), $lng->txt("svy_user_added_360_rater"));
        $ntf->addAdditionalInfo("survey_360_appraisee", ilUserUtil::getNamePresentation($a_appraisee_id, false, false, "", true));
 
        // #10044
        $mail = new ilMail(ANONYMOUS_USER_ID);
        $mail->enqueue(
            ilObjUser::_lookupLogin($a_user_id),
            null,
            null,
            $subject,
            $ntf->composeAndGetMessage($a_user_id, null, "read", true),
            []
        );
    }
 
    public function isAppraisee($a_user_id)
    {
        $ilDB = $this->db;
        
        $set = $ilDB->query("SELECT user_id" .
            " FROM svy_360_appr" .
            " WHERE obj_id = " . $ilDB->quote($this->getSurveyId(), "integer") .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer"));
        return (bool) $ilDB->numRows($set);
    }
    
    public function isAppraiseeClosed($a_user_id)
    {
        $ilDB = $this->db;
        
        $set = $ilDB->query("SELECT has_closed" .
            " FROM svy_360_appr" .
            " WHERE obj_id = " . $ilDB->quote($this->getSurveyId(), "integer") .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer"));
        $row = $ilDB->fetchAssoc($set);
        return $row["has_closed"];
    }
    
    public function deleteAppraisee($a_user_id)
    {
        $ilDB = $this->db;
        
        $ilDB->manipulate("DELETE FROM svy_360_appr" .
            " WHERE obj_id = " . $ilDB->quote($this->getSurveyId(), "integer") .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer"));
                
        $set = $ilDB->query("SELECT user_id" .
            " FROM svy_360_rater" .
            " WHERE obj_id = " . $ilDB->quote($this->getSurveyId(), "integer") .
            " AND appr_id = " . $ilDB->quote($a_user_id, "integer"));
        while ($row = $ilDB->fetchAssoc($set)) {
            $this->deleteRater($a_user_id, $row["user_id"]);
        }
        // appraisee will not be part of raters table
        if ($this->get360SelfEvaluation()) {
            $this->deleteRater($a_user_id, $a_user_id);
        }
    }
    
    public function getAppraiseesData()
    {
        $ilDB = $this->db;
        
        $res = array();
        
        $set = $ilDB->query("SELECT * FROM svy_360_appr" .
            " WHERE obj_id = " . $ilDB->quote($this->getSurveyId(), "integer"));
        while ($row = $ilDB->fetchAssoc($set)) {
            $name = ilObjUser::_lookupName($row["user_id"]);
            $name["email"] = ilObjUser::_lookupEmail($row["user_id"]);
            $name["name"] = $name["lastname"] . ", " . $name["firstname"];
            $res[$row["user_id"]] = $name;
            
            $finished = 0;
            $raters = $this->getRatersData($row["user_id"]);
            foreach ($raters as $rater) {
                if ($rater["finished"]) {
                    $finished++;
                }
            }
            $res[$row["user_id"]]["finished"] = $finished . "/" . sizeof($raters);
            $res[$row["user_id"]]["closed"] = $row["has_closed"];
        }
        
        return $res;
    }
    
    public function addRater($a_appraisee_id, $a_user_id, $a_anonymous_id = 0)
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $access = $DIC->access();
        
        if ($this->isAppraisee($a_appraisee_id) &&
            !$this->isRater($a_appraisee_id, $a_user_id, $a_anonymous_id)) {
            $fields = array(
                "obj_id" => array("integer", $this->getSurveyId()),
                "appr_id" => array("integer", $a_appraisee_id),
                "user_id" => array("integer", $a_user_id),
                "anonymous_id" => array("integer", $a_anonymous_id)
            );
            $ilDB->insert("svy_360_rater", $fields);
 
            // send notification and add to desktop
            if ($access->checkAccessOfUser($a_user_id, "read", "", $this->getRefId())) {
                $this->sendRaterNotification($a_user_id, $a_appraisee_id);
            }
        }
    }
    
    public function isRater($a_appraisee_id, $a_user_id, $a_anonymous_id = 0)
    {
        $ilDB = $this->db;
        
        // user is rater if already appraisee and active self-evaluation
        if ($this->isAppraisee($a_user_id) &&
            $this->get360SelfEvaluation() &&
            (!$a_appraisee_id || $a_appraisee_id == $a_user_id)) {
            return true;
        }
                
        // :TODO: should we get rid of code as well?
        
        $sql = "SELECT user_id" .
            " FROM svy_360_rater" .
            " WHERE obj_id = " . $ilDB->quote($this->getSurveyId(), "integer") .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
            " AND anonymous_id = " . $ilDB->quote($a_anonymous_id, "integer");
        if ($a_appraisee_id) {
            $sql .= " AND appr_id = " . $ilDB->quote($a_appraisee_id, "integer");
        }
        $set = $ilDB->query($sql);
        return (bool) $ilDB->numRows($set);
    }
    
    public function deleteRater($a_appraisee_id, $a_user_id, $a_anonymous_id = 0)
    {
        $ilDB = $this->db;
        
        $finished_id = $this->getFinishedIdForAppraiseeIdAndRaterId($a_appraisee_id, $a_user_id);
        if ($finished_id) {
            $this->removeSelectedSurveyResults(array($finished_id));
        }
        
        $ilDB->manipulate("DELETE FROM svy_360_rater" .
            " WHERE obj_id = " . $ilDB->quote($this->getSurveyId(), "integer") .
            " AND appr_id = " . $ilDB->quote($a_appraisee_id, "integer") .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
            " AND anonymous_id = " . $ilDB->quote($a_anonymous_id, "integer"));
    }
    
    public function getRatersData($a_appraisee_id)
    {
        $ilDB = $this->db;
        
        $res = $anonymous_ids = array();
        
        $set = $ilDB->query("SELECT * FROM svy_360_rater" .
            " WHERE obj_id = " . $ilDB->quote($this->getSurveyId(), "integer") .
            " AND appr_id = " . $ilDB->quote($a_appraisee_id, "integer"));
        while ($row = $ilDB->fetchAssoc($set)) {
            if ($row["anonymous_id"]) {
                $res["a" . $row["anonymous_id"]] = array(
                    "lastname" => "unknown code " . $row["anonymous_id"],
                    "sent" => $row["mail_sent"],
                    "finished" => null
                );
                $anonymous_ids[] = $row["anonymous_id"];
            } else {
                $name = ilObjUser::_lookupName($row["user_id"]);
                $name["name"] = $name["lastname"] . ", " . $name["firstname"];
                $name["user_id"] = "u" . $name["user_id"];
                $name["email"] = ilObjUser::_lookupEmail($row["user_id"]);
                $name["sent"] = $row["mail_sent"];
                $name["finished"] = (bool) $this->is360SurveyStarted($a_appraisee_id, $row["user_id"]);
                $res["u" . $row["user_id"]] = $name;
            }
        }
        
        if (sizeof($anonymous_ids)) {
            $data = $this->getSurveyCodesTableData($anonymous_ids);
            foreach ($data as $item) {
                if (isset($res["a" . $item["id"]])) {
                    $res["a" . $item["id"]] = array(
                        "user_id" => "a" . $item["id"],
                        "lastname" => $item["last_name"],
                        "firstname" => $item["first_name"],
                        "name" => $item["last_name"] . ", " . $item["first_name"],
                        "login" => "",
                        "email" => $item["email"],
                        "code" => $item["code"],
                        "href" => $item["href"],
                        "sent" => $res["a" . $item["id"]]["sent"],
                        "finished" => (bool) $this->is360SurveyStarted($a_appraisee_id, null, $item["code"])
                    );
                }
            }
        }
        
        return $res;
    }
    
    public function getAppraiseesToRate($a_user_id, $a_anonymous_id = null)
    {
        $ilDB = $this->db;
    
        $res = array();
        
        $sql = "SELECT appr_id FROM svy_360_rater" .
            " WHERE obj_id = " . $ilDB->quote($this->getSurveyId(), "integer");
        
        if ($a_user_id) {
            $sql .= " AND user_id = " . $ilDB->quote($a_user_id, "integer");
        } else {
            $sql .= " AND anonymous_id = " . $ilDB->quote($a_anonymous_id, "integer");
        }
                
        $set = $ilDB->query($sql);
        while ($row = $ilDB->fetchAssoc($set)) {
            $res[] = $row["appr_id"];
        }
                
        // user may evaluate himself if already appraisee
        if ($this->get360SelfEvaluation() &&
            $this->isAppraisee($a_user_id) &&
            !in_array($a_user_id, $res)) {
            $res[] = $a_user_id;
        }
        
        return $res;
    }
    
    public function getAnonymousIdByCode($a_code)
    {
        $ilDB = $this->db;
        
        $set = $ilDB->query("SELECT anonymous_id FROM svy_anonymous" .
                " WHERE survey_fi = " . $ilDB->quote($this->getSurveyId(), "integer") .
                " AND survey_key = " . $ilDB->quote($a_code, "text"));
        $res = $ilDB->fetchAssoc($set);
        return $res["anonymous_id"];
    }
    
    public function is360SurveyStarted($appr_id, $user_id, $anonymous_code = null)
    {
        $ilDB = $this->db;
 
        $sql = "SELECT * FROM svy_finished" .
            " WHERE survey_fi =" . $ilDB->quote($this->getSurveyId(), "integer") .
            " AND appr_id = " . $ilDB->quote($appr_id, "integer");
        if ($user_id) {
            $sql .= " AND user_fi = " . $ilDB->quote($user_id, "integer");
        } else {
            $sql .= " AND anonymous_id = " . $ilDB->quote($anonymous_code, "text");
        }
        $result = $ilDB->query($sql);
        if ($result->numRows() == 0) {
            return false;
        } else {
            $row = $ilDB->fetchAssoc($result);
            return (int) $row["state"];
        }
    }
    
    public function getUserSurveyExecutionStatus($a_code = null)
    {
        $ilUser = $this->user;
        $ilDB = $this->db;
            
        $user_id = $ilUser->getId();
                
        // code is obligatory?
        if (!$this->isAccessibleWithoutCode()) {
            if (!$a_code) {
                // registered raters do not need code
                if ($this->get360Mode() &&
                    $user_id != ANONYMOUS_USER_ID &&
                    $this->isRater(0, $user_id)) {
                    // auto-generate code
                    $a_code = $this->createNewAccessCode();
                    $this->saveUserAccessCode($user_id, $a_code);
                } else {
                    return null;
                }
            }
        } elseif ($user_id == ANONYMOUS_USER_ID ||
            $this->getAnonymize() == self::ANONYMIZE_FREEACCESS) {
            if (!$a_code) {
                // auto-generate code
                $a_code = $this->createNewAccessCode();
                $this->saveUserAccessCode($user_id, $a_code);
            }
        } else {
            $a_code = null;
        }
            
        $res = array();
                                
        $sql = "SELECT * FROM svy_finished" .
            " WHERE survey_fi = " . $ilDB->quote($this->getSurveyId(), "integer");
        // if proper user id is given, use it or current code
        if ($user_id != ANONYMOUS_USER_ID) {
            $sql .= " AND (user_fi = " . $ilDB->quote($user_id, "integer") .
                " OR anonymous_id = " . $ilDB->quote($a_code, "text") . ")";
        }
        // use anonymous code to find finished id(s)
        else {
            $sql .= " AND anonymous_id = " . $ilDB->quote($a_code, "text");
        }
        $set = $ilDB->query($sql);
        while ($row = $ilDB->fetchAssoc($set)) {
            $res[$row["finished_id"]] = array("appr_id" => $row["appr_id"],
                "user_id" => $row["user_fi"],
                "code" => $row["anonymous_id"],
                "finished" => (bool) $row["state"]);
        }
        
        return array("code" => $a_code, "runs" => $res);
    }
    
    public function findCodeForUser($a_user_id)
    {
        $ilDB = $this->db;
        
        if ($a_user_id != ANONYMOUS_USER_ID) {
            $set = $ilDB->query("SELECT sf.anonymous_id FROM svy_finished sf" .
                " WHERE sf.survey_fi = " . $ilDB->quote($this->getSurveyId(), "integer") .
                " AND sf.user_fi = " . $ilDB->quote($a_user_id, "integer"));
            $a_code = $ilDB->fetchAssoc($set);
            return $a_code["anonymous_id"];
        }
    }
    
    public function isUnusedCode($a_code, $a_user_id)
    {
        $ilDB = $this->db;
        
        $set = $ilDB->query("SELECT user_fi FROM svy_finished" .
            " WHERE survey_fi = " . $ilDB->quote($this->getSurveyId(), "integer") .
            " AND anonymous_id = " . $ilDB->quote($a_code, "text"));
        $user_id = $ilDB->fetchAssoc($set);
        $user_id = $user_id["user_fi"];
        
        if ($user_id && ($user_id != $a_user_id || $user_id == ANONYMOUS_USER_ID)) {
            return false;
        }
        return true;
    }
    
    public function getFinishedIdsForAppraiseeId($a_appr_id, $a_exclude_appraisee = false)
    {
        $ilDB = $this->db;
        
        $res = array();
        
        $set = $ilDB->query("SELECT finished_id, user_fi FROM svy_finished" .
            " WHERE survey_fi = " . $ilDB->quote($this->getSurveyId(), "integer") .
            " AND appr_id = " . $ilDB->quote($a_appr_id, "integer"));
        while ($row = $ilDB->fetchAssoc($set)) {
            if ($a_exclude_appraisee && $row["user_fi"] == $a_appr_id) {
                continue;
            }
            $res[] = $row["finished_id"];
        }
        
        return $res;
    }
    
    public function getFinishedIdForAppraiseeIdAndRaterId($a_appr_id, $a_rat_id)
    {
        $ilDB = $this->db;
        
        $set = $ilDB->query("SELECT finished_id, user_fi FROM svy_finished" .
            " WHERE survey_fi = " . $ilDB->quote($this->getSurveyId(), "integer") .
            " AND appr_id = " . $ilDB->quote($a_appr_id, "integer") .
            " AND user_fi = " . $ilDB->quote($a_rat_id, "integer"));
        $row = $ilDB->fetchAssoc($set);
        return $row["finished_id"];
    }
    
    
    // 360° using competence/skill service
    
    public function setSkillService($a_val)
    {
        $this->mode_skill_service = $a_val;
    }
    
    public function getSkillService()
    {
        return $this->mode_skill_service;
    }
    
    public function set360RaterSent($a_appraisee_id, $a_user_id, $a_anonymous_id, $a_tstamp = null)
    {
        $ilDB = $this->db;
        
        if (!$a_tstamp) {
            $a_tstamp = time();
        }
        
        $ilDB->manipulate("UPDATE svy_360_rater" .
            " SET mail_sent = " . $ilDB->quote($a_tstamp, "integer") .
            " WHERE obj_id = " . $ilDB->quote($this->getSurveyId(), "integer") .
            " AND appr_id = " . $ilDB->quote($a_appraisee_id, "integer") .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
            " AND anonymous_id = " . $ilDB->quote($a_anonymous_id, "integer"));
    }
    
    public function closeAppraisee($a_user_id)
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $user = $DIC->user();
        
        // close the appraisee
        $ilDB->manipulate("UPDATE svy_360_appr" .
            " SET has_closed = " . $ilDB->quote(time(), "integer") .
            " WHERE obj_id = " . $ilDB->quote($this->getSurveyId(), "integer") .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer"));
        
        // write competences
        $skmg_set = new ilSkillManagementSettings();
        if ($this->getSkillService() && $skmg_set->isActivated()) {
            $sskill = new ilSurveySkill($this);
            $sskill->writeAndAddAppraiseeSkills($a_user_id);
        }
 
        // send notification
        if ($user->getId() != $a_user_id) {
            $this->sendAppraiseeCloseNotification($a_user_id);
        }
    }
    
    public function openAllAppraisees()
    {
        $ilDB = $this->db;
        
        $ilDB->manipulate("UPDATE svy_360_appr" .
            " SET has_closed = " . $ilDB->quote(null, "integer") .
            " WHERE obj_id = " . $ilDB->quote($this->getSurveyId(), "integer"));
    }
    
    public static function validateExternalRaterCode($a_ref_id, $a_code)
    {
        if (!isset($_SESSION["360_extrtr"][$a_ref_id])) {
            $svy = new self($a_ref_id);
            $svy->loadFromDB();
            
            if ($svy->canStartSurvey(null, true) &&
                $svy->get360Mode() &&
                $svy->isAnonymousKey($a_code)) {
                $anonymous_id = $svy->getAnonymousIdByCode($a_code);
                if ($anonymous_id) {
                    if (sizeof($svy->getAppraiseesToRate(null, $anonymous_id))) {
                        $_SESSION["360_extrtr"][$a_ref_id] = true;
                        return true;
                    }
                }
            }
 
            $_SESSION["360_extrtr"][$a_ref_id] = false;
            return false;
        }
        
        return $_SESSION["360_extrtr"][$a_ref_id];
    }
    
    
    //
    // reminder/notification
    //
    
    public function getReminderStatus()
    {
        return (bool) $this->reminder_status;
    }
    
    public function setReminderStatus($a_value)
    {
        $this->reminder_status = (bool) $a_value;
    }
    
    public function getReminderStart()
    {
        return $this->reminder_start;
    }
    
    public function setReminderStart(ilDate $a_value = null)
    {
        $this->reminder_start = $a_value;
    }
    
    public function getReminderEnd()
    {
        return $this->reminder_end;
    }
    
    public function setReminderEnd(ilDate $a_value = null)
    {
        $this->reminder_end = $a_value;
    }
    
    public function getReminderFrequency()
    {
        return $this->reminder_frequency;
    }
    
    public function setReminderFrequency($a_value)
    {
        $this->reminder_frequency = (int) $a_value;
    }
    
    public function getReminderTarget()
    {
        return $this->reminder_target;
    }
    
    public function setReminderTarget($a_value)
    {
        $this->reminder_target = (int) $a_value;
    }
    
    public function getReminderLastSent()
    {
        return $this->reminder_last_sent;
    }
    
    public function setReminderLastSent($a_value)
    {
        $this->reminder_last_sent = $a_value;
    }
 
    public function getReminderTemplate($selectDefault = false)
    {
        if ($selectDefault) {
            $defaultTemplateId = 0;
            $this->getReminderMailTemplates($defaultTemplateId);
 
            if ($defaultTemplateId > 0) {
                return $defaultTemplateId;
            }
        }
 
        return $this->reminder_tmpl;
    }
    
    public function setReminderTemplate($a_value)
    {
        $this->reminder_tmpl = $a_value;
    }
    
    public function getTutorNotificationStatus()
    {
        return (bool) $this->tutor_ntf_status;
    }
    
    public function setTutorNotificationStatus($a_value)
    {
        $this->tutor_ntf_status = (bool) $a_value;
    }
    
    public function getTutorNotificationRecipients()
    {
        return $this->tutor_ntf_recipients;
    }
    
    public function setTutorNotificationRecipients(array $a_value)
    {
        $this->tutor_ntf_recipients = $a_value;
    }
    
    public function getTutorNotificationTarget()
    {
        return $this->tutor_ntf_target;
    }
    
    public function setTutorNotificationTarget($a_value)
    {
        $this->tutor_ntf_target = (int) $a_value;
    }
    
    public function getTutorResultsStatus()
    {
        return (bool) $this->tutor_res_status;
    }
    
    public function setTutorResultsStatus($a_value)
    {
        $this->tutor_res_status = (bool) $a_value;
    }
    
    public function getTutorResultsRecipients()
    {
        return $this->tutor_res_recipients;
    }
    
    public function setTutorResultsRecipients(array $a_value)
    {
        $this->tutor_res_recipients = $a_value;
    }
    
    protected function checkTutorNotification()
    {
        $ilDB = $this->db;
        
        if ($this->getTutorNotificationStatus()) {
            $user_ids = $this->getNotificationTargetUserIds(($this->getTutorNotificationTarget() == self::NOTIFICATION_INVITED_USERS));
            if ($user_ids) {
                $set = $ilDB->query("SELECT COUNT(*) numall FROM svy_finished" .
                    " WHERE survey_fi = " . $ilDB->quote($this->getSurveyId(), "integer") .
                    " AND state = " . $ilDB->quote(1, "integer") .
                    " AND " . $ilDB->in("user_fi", $user_ids, "", "integer"));
                $row = $ilDB->fetchAssoc($set);
                if ($row["numall"] == sizeof($user_ids)) {
                    $this->sendTutorNotification();
                }
            }
        }
    }
 
    public function sent360Reminders()
    {
        global $DIC;
 
        $access = $DIC->access();
 
        // collect all open ratings
        $rater_ids = array();
        foreach ($this->getAppraiseesData() as $app) {
            $this->log->debug("Handle appraisee " . $app['user_id']);
 
            if (!$this->isAppraiseeClosed($app['user_id'])) {
                $this->log->debug("Check self evaluation, self: " . $this->get360SelfAppraisee() . ", target: " . $this->getReminderTarget());
 
                // self evaluation?
                if ($this->get360SelfEvaluation() &&
                    in_array($this->getReminderTarget(), array(ilObjSurvey::NOTIFICATION_APPRAISEES, ilObjSurvey::NOTIFICATION_APPRAISEES_AND_RATERS))) {
                    $this->log->debug("...1");
                    // did user already finished self evaluation?
                    if (!$this->is360SurveyStarted($app['user_id'], $app['user_id'])) {
                        $this->log->debug("...2");
                        if (!is_array($rater_ids[$app['user_id']])) {
                            $rater_ids[$app['user_id']] = array();
                        }
                        if (!in_array($app["user_id"], $rater_ids[$app['user_id']])) {
                            $rater_ids[$app['user_id']][] = $app["user_id"];
                        }
                    }
                }
 
                $this->log->debug("Check raters.");
 
                // should raters be notified?
                if (in_array($this->getReminderTarget(), array(ilObjSurvey::NOTIFICATION_RATERS, ilObjSurvey::NOTIFICATION_APPRAISEES_AND_RATERS))) {
                    foreach ($this->getRatersData($app['user_id']) as $rater) {
                        // is rater not anonymous and did not rate yet?
                        if (!$rater["anonymous_id"] && !$rater["finished"]) {
                            if (!is_array($rater_ids[$rater["user_id"]])) {
                                $rater_ids[$rater["user_id"]] = array();
                            }
                            if (!in_array($app["user_id"], $rater_ids[$rater["user_id"]])) {
                                $rater_ids[$rater["user_id"]][] = $app["user_id"];
                            }
                        }
                    }
                }
            }
        }
 
        $this->log->debug("Found raters:" . count($rater_ids));
 
        foreach ($rater_ids as $id => $app) {
            if ($access->checkAccessOfUser($id, "read", "", $this->getRefId())) {
                $this->send360ReminderToUser($id, $app);
            }
        }
    }
 
    public function send360ReminderToUser($a_user_id, $a_appraisee_ids)
    {
        $this->log->debug("Send mail to:" . $a_user_id);
 
        $ntf = new ilSystemNotification();
        $ntf->setLangModules(array("svy", "survey"));
        $ntf->setRefId($this->getRefId());
        $ntf->setGotoLangId('url');
 
        // user specific language
        $lng = $ntf->getUserLanguage($a_user_id);
 
        $ntf->setIntroductionLangId("svy_user_added_360_rater_reminder_mail");
        $subject = str_replace("%1", $this->getTitle(), $lng->txt("svy_user_added_360_rater"));
 
        foreach ($a_appraisee_ids as $appraisee_id) {
            $ntf->addAdditionalInfo("survey_360_appraisee", ilUserUtil::getNamePresentation($appraisee_id, false, false, "", true));
        }
 
        // #10044
        $mail = new ilMail(ANONYMOUS_USER_ID);
        $mail->enqueue(
            ilObjUser::_lookupLogin($a_user_id),
            null,
            null,
            $subject,
            $ntf->composeAndGetMessage($a_user_id, null, "read", true),
            []
        );
    }
 
 
    public function getNotificationTargetUserIds($a_use_invited)
    {
        $tree = $this->tree;
 
        if ((bool) $a_use_invited) {
            $user_ids = $this->invitation_manager->getAllForSurvey($this->getSurveyId());
        } else {
            $parent_grp_ref_id = $tree->checkForParentType($this->getRefId(), "grp");
            if ($parent_grp_ref_id) {
                $part = new ilGroupParticipants(ilObject::_lookupObjId($parent_grp_ref_id));
                $user_ids = $part->getMembers();
            } else {
                $parent_crs_ref_id = $tree->checkForParentType($this->getRefId(), "crs");
                if ($parent_crs_ref_id) {
                    $part = new ilCourseParticipants(ilObject::_lookupObjId($parent_crs_ref_id));
                    $user_ids = $part->getMembers();
                }
            }
        }
        return $user_ids;
    }
    
    protected function sendTutorNotification()
    {
        $link = ilLink::_getStaticLink($this->getRefId(), "svy");
            
        foreach ($this->getTutorNotificationRecipients() as $user_id) {
            // use language of recipient to compose message
            $ulng = ilLanguageFactory::_getLanguageOfUser($user_id);
            $ulng->loadLanguageModule('survey');
 
            $subject = sprintf($ulng->txt('survey_notification_tutor_subject'), $this->getTitle());
            $message = sprintf($ulng->txt('survey_notification_tutor_salutation'), ilObjUser::_lookupFullname($user_id)) . "\n\n";
 
            $message .= $ulng->txt('survey_notification_tutor_body') . ":\n\n";
            $message .= $ulng->txt('obj_svy') . ": " . $this->getTitle() . "\n";
            $message .= "\n" . $ulng->txt('survey_notification_tutor_link') . ": " . $link;
 
            $mail_obj = new ilMail(ANONYMOUS_USER_ID);
            $mail_obj->appendInstallationSignature(true);
            $mail_obj->enqueue(
                ilObjUser::_lookupLogin($user_id),
                "",
                "",
                $subject,
                $message,
                array()
            );
        }
    }
    
    public function checkReminder()
    {
        $ilDB = $this->db;
        $ilAccess = $this->access;
        
        $now = time();
        $now_with_format = date("YmdHis", $now);
        $today = date("Y-m-d");
 
        $this->log->debug("Check status and dates.");
        
        // object settings / participation period
        if (
            $this->getOfflineStatus() ||
            !$this->getReminderStatus() ||
            ($this->getStartDate() && $now_with_format < $this->getStartDate()) ||
            ($this->getEndDate() && $now_with_format > $this->getEndDate())) {
            return false;
        }
                        
        // reminder period
        $start = $this->getReminderStart();
        if ($start) {
            $start = $start->get(IL_CAL_DATE);
        }
        $end = $this->getReminderEnd();
        if ($end) {
            $end = $end->get(IL_CAL_DATE);
        }
        if ($today < $start ||
            ($end && $today > $end)) {
            return false;
        }
 
        $this->log->debug("Check access period.");
 
        // object access period
        $item_data = ilObjectActivation::getItem($this->getRefId());
        if ($item_data["timing_type"] == ilObjectActivation::TIMINGS_ACTIVATION &&
            ($now < $item_data["timing_start"] ||
            $now > $item_data["timing_end"])) {
            return false;
        }
 
        $this->log->debug("Check frequency.");
 
        // check frequency
        $cut = new ilDate($today, IL_CAL_DATE);
        $cut->increment(IL_CAL_DAY, $this->getReminderFrequency() * -1);
        if (!$this->getReminderLastSent() ||
            $cut->get(IL_CAL_DATE) >= substr($this->getReminderLastSent(), 0, 10)) {
            $missing_ids = array();
 
            if (!$this->get360Mode()) {
                $this->log->debug("Entering survey mode.");
 
                // #16871
                $user_ids = $this->getNotificationTargetUserIds(($this->getReminderTarget() == self::NOTIFICATION_INVITED_USERS));
                if ($user_ids) {
                    // gather participants who already finished
                    $finished_ids = array();
                    $set = $ilDB->query("SELECT user_fi FROM svy_finished" .
                        " WHERE survey_fi = " . $ilDB->quote($this->getSurveyId(), "integer") .
                        " AND state = " . $ilDB->quote(1, "text") .
                        " AND " . $ilDB->in("user_fi", $user_ids, "", "integer"));
                    while ($row = $ilDB->fetchAssoc($set)) {
                        $finished_ids[] = $row["user_fi"];
                    }
 
                    // some users missing out?
                    $missing_ids = array_diff($user_ids, $finished_ids);
                    if ($missing_ids) {
                        foreach ($missing_ids as $idx => $user_id) {
                            // should be able to participate
                            if (!$ilAccess->checkAccessOfUser($user_id, "read", "", $this->getRefId(), "svy", $this->getId())) {
                                unset($missing_ids[$idx]);
                            }
                        }
                    }
                    if ($missing_ids) {
                        $this->sentReminder($missing_ids);
                    }
                }
            } else {
                $this->log->debug("Entering 360 mode.");
 
                $this->sent360Reminders();
            }
 
 
            $this->setReminderLastSent($today);
            $this->saveToDb();
 
            return sizeof($missing_ids);
        }
        
        return false;
    }
    
    protected function sentReminder(array $a_recipient_ids)
    {
        global $DIC;
 
        // use mail template
        if ($this->getReminderTemplate() &&
            array_key_exists($this->getReminderTemplate(), $this->getReminderMailTemplates())) {
            $templateService = $DIC['mail.texttemplates.service'];
            $tmpl = $templateService->loadTemplateForId((int) $this->getReminderTemplate());
 
            $tmpl_params = array(
                "ref_id" => $this->getRefId(),
                "ts" => time()
            );
        } else {
            $tmpl = null;
            $link = ilLink::_getStaticLink($this->getRefId(), "svy");
        }
            
        foreach ($a_recipient_ids as $user_id) {
            if ($tmpl) {
                $subject = $tmpl->getSubject();
                $message = $this->sentReminderPlaceholders($tmpl->getMessage(), $user_id, $tmpl_params);
            }
            // use lng
            else {
                // use language of recipient to compose message
                $ulng = ilLanguageFactory::_getLanguageOfUser($user_id);
                $ulng->loadLanguageModule('survey');
            
                $subject = sprintf($ulng->txt('survey_reminder_subject'), $this->getTitle());
                $message = sprintf($ulng->txt('survey_reminder_salutation'), ilObjUser::_lookupFullname($user_id)) . "\n\n";
 
                $message .= $ulng->txt('survey_reminder_body') . ":\n\n";
                $message .= $ulng->txt('obj_svy') . ": " . $this->getTitle() . "\n";
                $message .= "\n" . $ulng->txt('survey_reminder_link') . ": " . $link;
            }
 
            $mail_obj = new ilMail(ANONYMOUS_USER_ID);
            $mail_obj->appendInstallationSignature(true);
            $mail_obj->enqueue(
                ilObjUser::_lookupLogin($user_id),
                "",
                "",
                $subject,
                $message,
                array()
            );
        }
    }
    
    public function setActivationStartDate($starting_time = null)
    {
        $this->activation_starting_time = $starting_time;
    }
 
    public function setActivationEndDate($ending_time = null)
    {
        $this->activation_ending_time = $ending_time;
    }
    
    public function getActivationStartDate()
    {
        return (strlen($this->activation_starting_time)) ? $this->activation_starting_time : null;
    }
 
    public function getActivationEndDate()
    {
        return (strlen($this->activation_ending_time)) ? $this->activation_ending_time : null;
    }
    
    public function setViewOwnResults($a_value)
    {
        $this->view_own_results = (bool) $a_value;
    }
    
    public function hasViewOwnResults()
    {
        return $this->view_own_results;
    }
    
    public function setMailOwnResults($a_value)
    {
        $this->mail_own_results = (bool) $a_value;
    }
    
    public function hasMailOwnResults()
    {
        return $this->mail_own_results;
    }
    
    public function setMailConfirmation($a_value)
    {
        $this->mail_confirmation = (bool) $a_value;
    }
    
    public function hasMailConfirmation()
    {
        return $this->mail_confirmation;
    }
    
    public function setAnonymousUserList($a_value)
    {
        $this->anon_user_list = (bool) $a_value;
    }
    
    public function hasAnonymousUserList()
    {
        return $this->anon_user_list;
    }
    
    public static function getSurveySkippedValue()
    {
        global $DIC;
 
        $lng = $DIC->language();
        
        // #13541
        
        $surveySetting = new ilSetting("survey");
        if (!$surveySetting->get("skipped_is_custom", false)) {
            return $lng->txt("skipped");
        } else {
            return $surveySetting->get("skipped_custom_value", "");
        }
    }
    
    public function getReminderMailTemplates(&$defaultTemplateId = null)
    {
        global $DIC;
 
        $res = array();
 
        $templateService = $DIC['mail.texttemplates.service'];
        foreach ($templateService->loadTemplatesForContextId((string) ilSurveyMailTemplateReminderContext::ID) as $tmpl) {
            $res[$tmpl->getTplId()] = $tmpl->getTitle();
            if (null !== $defaultTemplateId && $tmpl->isDefault()) {
                $defaultTemplateId = $tmpl->getTplId();
            }
        }
 
        return $res;
    }
        
    protected function sentReminderPlaceholders($a_message, $a_user_id, array $a_context_params)
    {
        // see ilMail::replacePlaceholders()
        try {
            $context = \ilMailTemplateContextService::getTemplateContextById(ilSurveyMailTemplateReminderContext::ID);
 
            $user = new \ilObjUser($a_user_id);
 
            $processor = new \ilMailTemplatePlaceholderResolver($context, $a_message);
            $a_message = $processor->resolve($user, $a_context_params);
        } catch (\Exception $e) {
            ilLoggerFactory::getLogger('mail')->error(__METHOD__ . ' has been called with invalid context.');
        }
 
        return $a_message;
    }
 
    public function setMode($a_value)
    {
        $this->mode = $a_value;
    }
 
    public function getMode()
    {
        return $this->mode;
    }
 
    public function setSelfEvaluationResults($a_value)
    {
        $this->mode_self_eval_results = $a_value;
    }
 
    public function getSelfEvaluationResults()
    {
        return $this->mode_self_eval_results;
    }
    
    public static function getSurveysWithTutorResults()
    {
        global $ilDB;
        
        $res = array();
 
        $log = ilLoggerFactory::getLogger("svy");
 
 
        $q = "SELECT obj_fi FROM svy_svy" .
            " WHERE tutor_res_cron IS NULL" .
            " AND tutor_res_status = " . $ilDB->quote(1, "integer") .
            " AND enddate < " . $ilDB->quote(date("Ymd000000"), "text");
 
        if (DEVMODE) {
            $q = "SELECT obj_fi FROM svy_svy" .
                " WHERE tutor_res_status = " . $ilDB->quote(1, "integer") .
                " AND enddate < " . $ilDB->quote(date("Ymd000000"), "text");
        }
 
        $set = $ilDB->query($q);
 
        $log->debug($q);
 
        while ($row = $ilDB->fetchAssoc($set)) {
            $res[] = $row["obj_fi"];
        }
        
        return $res;
    }
    
    public function sendTutorResults()
    {
        global $ilCtrl, $ilDB;
 
        $log = ilLoggerFactory::getLogger("svy");
        
        include_once "./Services/Mail/classes/class.ilMail.php";
        include_once "./Services/User/classes/class.ilObjUser.php";
        include_once "./Services/Language/classes/class.ilLanguageFactory.php";
        include_once "./Services/User/classes/class.ilUserUtil.php";
        
        include_once "./Services/Link/classes/class.ilLink.php";
        $link = ilLink::_getStaticLink($this->getRefId(), "svy");
        
        // somehow needed in cron-calls
        //$ilCtrl->setTargetScript("ilias.php");
        //$ilCtrl->initBaseClass("ilobjsurveygui");
        
        // yeah, I know...
        $old_ref_id = $_GET["ref_id"];
        $old_base_class = $_GET["baseClass"];
        $_GET["ref_id"] = $this->getRefId();
        $ilCtrl->setTargetScript("ilias.php");
        $_GET["baseClass"] = "ilObjSurveyGUI";
 
        $ilCtrl->setParameterByClass("ilSurveyEvaluationGUI", "ref_id", $this->getRefId());
 
        try {
            $gui = new ilSurveyEvaluationGUI($this);
            $html = $gui->evaluation(1, true, true);
        } catch (Exception $exception) {
            $_GET["ref_id"] = $old_ref_id;
            $_GET["baseClass"] = $old_base_class;
            throw $exception;
        }
        $_GET["ref_id"] = $old_ref_id;
        $_GET["baseClass"] = $old_base_class;
 
        $html = preg_replace("/\?dummy\=[0-9]+/", "", $html);
        $html = preg_replace("/\?vers\=[0-9A-Za-z\-]+/", "", $html);
        $html = str_replace('.css$Id$', ".css", $html);
        $html = preg_replace("/src=\"\\.\\//ims", "src=\"" . ILIAS_HTTP_PATH . "/", $html);
        $html = preg_replace("/href=\"\\.\\//ims", "href=\"" . ILIAS_HTTP_PATH . "/", $html);
 
        $log->debug("--pdf start, ref id " . $this->getRefId());
        $log->debug("html length: " . strlen($html));
        $log->debug("html (first 1000 chars): " . substr($html, 0, 1000));
        //echo $html; exit;
        $pdf_factory = new ilHtmlToPdfTransformerFactory();
        $pdf = $pdf_factory->deliverPDFFromHTMLString($html, "survey.pdf", ilHtmlToPdfTransformerFactory::PDF_OUTPUT_FILE, "Survey", "Results");
        $log->debug("--pdf end");
 
        /*
        $log->debug("calling phantom for ref_id: " . $this->getRefId());
 
        $pdf = $gui->callPdfGeneration($url, "pdf", true, true);
 
        $log->debug("phantom called : " . $pdf);*/
        
        if (!$pdf ||
            !file_exists($pdf)) {
            return false;
        }
        
        // prepare mail attachment
        require_once 'Services/Mail/classes/class.ilFileDataMail.php';
        $att = "survey_" . $this->getRefId() . ".pdf";
        $mail_data = new ilFileDataMail(ANONYMOUS_USER_ID);
        $mail_data->copyAttachmentFile($pdf, $att);
            
        foreach ($this->getTutorResultsRecipients() as $user_id) {
            // use language of recipient to compose message
            $ulng = ilLanguageFactory::_getLanguageOfUser($user_id);
            $ulng->loadLanguageModule('survey');
 
            $subject = sprintf($ulng->txt('survey_results_tutor_subject'), $this->getTitle());
            $message = sprintf($ulng->txt('survey_notification_tutor_salutation'), ilObjUser::_lookupFullname($user_id)) . "\n\n";
 
            $message .= $ulng->txt('survey_results_tutor_body') . ":\n\n";
            $message .= $ulng->txt('obj_svy') . ": " . $this->getTitle() . "\n";
            $message .= "\n" . $ulng->txt('survey_notification_tutor_link') . ": " . $link;
            
            $mail_obj = new ilMail(ANONYMOUS_USER_ID);
            $mail_obj->appendInstallationSignature(true);
            $log->debug("send mail to user id: " . $user_id . ",login: " . ilObjUser::_lookupLogin($user_id));
            $mail_obj->enqueue(
                ilObjUser::_lookupLogin($user_id),
                "",
                "",
                $subject,
                $message,
                array($att)
            );
        }
        
        $ilDB->manipulate("UPDATE svy_svy" .
            " SET tutor_res_cron = " . $ilDB->quote(1, "integer") .
            " WHERE survey_id = " . $ilDB->quote($this->getSurveyId(), "integer"));
 
        return true;
    }
} // END class.ilObjSurvey