Modules/SurveyQuestionPool/classes/class.SurveyQuestion.php

Go to the documentation of this file.

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

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

class SurveyQuestion
{
  var $id;

  var $title;
  var $description;
  var $owner;

  var $author;

  var $materials;

  var $survey_id;

  var $obj_id;

  var $questiontext;

  var $obligatory;
        
  var $ilias;

  var $tpl;

  var $lng;

        var $orientation;
        
        var $material;

  function SurveyQuestion(
    $title = "",
    $description = "",
    $author = "",
                $questiontext = "",
    $owner = -1
  )

  {
                global $ilias;
    global $lng;
    global $tpl;

                $this->ilias =& $ilias;
    $this->lng =& $lng;
    $this->tpl =& $tpl;

    $this->title = $title;
    $this->description = $description;
                $this->questiontext = $questiontext;
    $this->author = $author;
    if (!$this->author) {
      $this->author = $this->ilias->account->fullname;
    }
    $this->owner = $owner;
    if ($this->owner == -1) {
      $this->owner = $this->ilias->account->id;
    }
    $this->id = -1;
    $this->survey_id = -1;
                $this->obligatory = 1;
                $this->orientation = 0;
                $this->materials = array();
                $this->material = array();
                register_shutdown_function(array(&$this, '_SurveyQuestion'));
        }

        function _SurveyQuestion()
        {
        }

        
        function isComplete()
        {
                return false;
        }

        function questionTitleExists($title, $questionpool_object = "") 
        {
                global $ilDB;
                
                $refwhere = "";
                if (strcmp($questionpool_object, "") != 0)
                {
                        $refwhere = sprintf(" AND obj_fi = %s",
                                $ilDB->quote($questionpool_object)
                        );
                }
                $query = sprintf("SELECT question_id FROM survey_question WHERE title = %s$refwhere",
                        $ilDB->quote($title)
                );
                $result = $ilDB->query($query);
                if (strcmp(strtolower(get_class($result)), db_result) == 0) 
                {
                        if ($result->numRows() == 1) 
                        {
                                return TRUE;
                        }
                }
                return FALSE;
        }

  function setTitle($title = "") 
        {
    $this->title = $title;
  }

  function setObligatory($obligatory = 1) 
        {
                if ($obligatory)
                {
            $this->obligatory = 1;
                }
                else
                {
            $this->obligatory = 0;
                }
  }

  function setOrientation($orientation = 0) 
        {
                if (strlen($orientation) == 0)
                {
                        $this->orientation = 0;
                }
                else
    {
                        $this->orientation = $orientation;
                }
  }

  function setId($id = -1) 
        {
    $this->id = $id;
  }

  function setSurveyId($id = -1) 
        {
    $this->survey_id = $id;
  }

  function setDescription($description = "") 
        {
    $this->description = $description;
  }


  function addMaterials($materials_file, $materials_name="") 
        {
        if(empty($materials_name)) 
                {
        $materials_name = $materials_file;
    }
    if ((!empty($materials_name))&&(!$this->keyInArray($materials_name, $this->materials))) 
                {
      $this->materials[$materials_name] = $materials_file;
    }

  }

  function keyInArray($searchkey, $array) 
        {
          if ($searchKey) 
                {
                   foreach ($array as $key => $value) 
                         {
                           if (strcmp($key, $searchkey)==0) 
                                 {
                                   return true;
                           }
                   }
           }
           return false;
  }

        function setMaterialsfile($materials_filename, $materials_tempfilename="", $materials_name="")
        {
                if (!empty($materials_filename))
                {
                        include_once "./Services/Utilities/classes/class.ilUtil.php";
                        $materialspath = $this->getMaterialsPath();
                        if (!file_exists($materialspath))
                        {
                                ilUtil::makeDirParents($materialspath);
                        }
                        //if (!move_uploaded_file($materials_tempfilename, $materialspath . $materials_filename))
                        if (ilUtil::moveUploadedFile($materials_tempfilename, $materials_filename,
                                $materialspath.$materials_filename))
                        {
                                print "image not uploaded!!!! ";
                        }
                        else
                        {
                                $this->addMaterials($materials_filename, $materials_name);
                        }
                }
        }

  function deleteMaterial($materials_name = "") 
        {
                foreach ($this->materials as $key => $value) 
                {
                        if (strcmp($key, $materials_name)==0) 
                        {
                                if (file_exists($this->getMaterialsPath().$value)) 
                                {
                                        unlink($this->getMaterialsPath().$value);
                                }
                                unset($this->materials[$key]);
                        }
                }
  }

  function flushMaterials() 
        {
    $this->materials = array();
  }

  function setAuthor($author = "") 
        {
    if (!$author) 
                {
      $author = $this->ilias->account->fullname;
    }
    $this->author = $author;
  }

  function setQuestiontext($questiontext = "") 
        {
    $this->questiontext = $questiontext;
  }

  function setOwner($owner = "") 
        {
    $this->owner = $owner;
  }

  function getTitle() 
        {
    return $this->title;
  }

  function getId() 
        {
    return $this->id;
  }

        function getObligatory($survey_id = "") 
        {
                if ($survey_id > 0)
                {
                        global $ilDB;
                        
                        $query = sprintf("SELECT * FROM survey_question_obligatory WHERE survey_fi = %s AND question_fi = %s",
                                $ilDB->quote($survey_id . ""),
                                $ilDB->quote($this->getId() . "")
                        );
                        $result = $ilDB->query($query);
                        if ($result->numRows())
                        {
                                $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
                                return $row["obligatory"];
                        }
                        else
                        {
                                return $this->obligatory;
                        }
                }
                else
                {
                        return $this->obligatory;
                }
  }

  function getSurveyId() 
        {
    return $this->survey_id;
  }

  function getOrientation() 
        {
                switch ($this->orientation)
                {
                        case 0:
                        case 1:
                        case 2:
                                break;
                        default:
                                $this->orientation = 0;
                                break;
                }
    return $this->orientation;
  }


  function getDescription() 
        {
    return $this->description;
  }

  function getAuthor() 
        {
    return $this->author;
  }

  function getOwner() 
        {
    return $this->owner;
  }

  function getQuestiontext() 
        {
    return $this->questiontext;
  }

  function getObjId() {
    return $this->obj_id;
  }

  function setObjId($obj_id = 0) {
    $this->obj_id = $obj_id;
  }

        function duplicate($for_survey = true, $title = "", $author = "", $owner = "")
        {
                if ($this->getId() <= 0)
                {
                        // The question has not been saved. It cannot be duplicated
                        return;
                }
                // duplicate the question in database
                $clone = $this;
                $original_id = $this->getId();
                $clone->setId(-1);
                if ($title)
                {
                        $clone->setTitle($title);
                }
                if ($author)
                {
                        $clone->setAuthor($author);
                }
                if ($owner)
                {
                        $clone->setOwner($owner);
                }
                if ($for_survey)
                {
                        $clone->saveToDb($original_id);
                }
                else
                {
                        $clone->saveToDb();
                }
                // duplicate the materials
                $clone->duplicateMaterials($original_id);
                // copy XHTML media objects
                $clone->copyXHTMLMediaObjectsOfQuestion($original_id);
                return $clone->getId();
        }

        function copyObject($target_questionpool, $title = "")
        {
                if ($this->getId() <= 0)
                {
                        // The question has not been saved. It cannot be copied
                        return;
                }
                $clone = $this;
                $original_id = SurveyQuestion::_getOriginalId($this->getId());
                $clone->setId(-1);
                $source_questionpool = $this->getObjId();
                $clone->setObjId($target_questionpool);
                if ($title)
                {
                        $clone->setTitle($title);
                }
                
                $clone->saveToDb();

                // duplicate the materials
                $clone->duplicateMaterials($original_id);
                // copy XHTML media objects
                $clone->copyXHTMLMediaObjectsOfQuestion($original_id);
                return $clone->getId();
        }
        
        function copyXHTMLMediaObjectsOfQuestion($a_q_id)
        {
                include_once("./Services/MediaObjects/classes/class.ilObjMediaObject.php");
                $mobs = ilObjMediaObject::_getMobsOfObject("spl:html", $a_q_id);
                foreach ($mobs as $mob)
                {
                        ilObjMediaObject::_saveUsage($mob, "spl:html", $this->getId());
                }
        }
        
        function duplicateMaterials($question_id)
        {
                foreach ($this->materials as $filename)
                {
                        $materialspath = $this->getMaterialsPath();
                        $materialspath_original = preg_replace("/([^\d])$this->id([^\d])/", "\${1}$question_id\${2}", $materialspath);
                        if (!file_exists($materialspath)) 
                        {
                                include_once "./Services/Utilities/classes/class.ilUtil.php";
                                ilUtil::makeDirParents($materialspath);
                        }
                        if (!copy($materialspath_original . $filename, $materialspath . $filename)) 
                        {
                                print "material could not be duplicated!!!! ";
                        }
                }
        }


        function loadFromDb($question_id)
        {
                $query = sprintf("SELECT * FROM survey_material WHERE question_fi = %s",
                        $this->ilias->db->quote($this->getId() . "")
                );
                $result = $this->ilias->db->query($query);
                $this->material = array();
                if ($result->numRows())
                {
                        while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                        {
                                $this->material = array(
                                        "internal_link" => $row["internal_link"],
                                        "import_id" => $row["import_id"],
                                        "title" => $row["material_title"]
                                );
                        }
                }
        }

        function _isComplete($question_id)
        {
                global $ilDB;

                $query = sprintf("SELECT complete FROM survey_question WHERE question_id = %s",
                        $ilDB->quote($question_id . "")
                );
                $result = $ilDB->query($query);
                if ($result->numRows())
                {
                        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
                        if ($row["complete"] == 1)
                        {
                                return TRUE;
                        }
                }
                return FALSE;
        }
        
        function saveCompletionStatus($original_id = "")
        {
                $question_id = $this->getId();
                if (strlen($original_id))
                {
                        $question_id = $original_id;
                }

                $complete = 0;
                if ($this->isComplete()) 
                {
                        $complete = 1;
                }
    if ($this->id > 0) 
                {
      // update existing dataset
      $query = sprintf("UPDATE survey_question SET complete = %s WHERE question_id = %s",
                                $this->ilias->db->quote("$complete"),
                                $this->ilias->db->quote($question_id . "")
      );
      $result = $this->ilias->db->query($query);
    }
        }

        function saveToDb($original_id = "")
        {
                include_once "./Services/COPage/classes/class.ilInternalLink.php";
                $query = sprintf("DELETE FROM survey_material WHERE question_fi = %s",
                        $this->ilias->db->quote($this->getId() . "")
                );
                $result = $this->ilias->db->query($query);
                ilInternalLink::_deleteAllLinksOfSource("sqst", $this->getId());
                if (count($this->material))
                {
                        $query = sprintf("INSERT INTO survey_material (material_id, question_fi, internal_link, import_id, material_title, TIMESTAMP) VALUES (NULL, %s, %s, %s, %s, NULL)",
                                $this->ilias->db->quote($this->getId() . ""),
                                $this->ilias->db->quote($this->material["internal_link"] . ""),
                                $this->ilias->db->quote($this->material["import_id"] . ""),
                                $this->ilias->db->quote($this->material["title"] . "")
                        );
                        $this->ilias->db->query($query);
                        if (preg_match("/il_(\d*?)_(\w+)_(\d+)/", $solution["internal_link"], $matches))
                        {
                                ilInternalLink::_saveLink("sqst", $this->getId(), $matches[2], $matches[3], $matches[1]);
                        }
                }
        }
        

  function saveWorkingData($limit_to = LIMIT_NO_LIMIT) 
        {
  }

        function getImagePath() 
        {
                return CLIENT_WEB_DIR . "/survey/$this->obj_id/$this->id/images/";
        }

        function getMaterialsPath() 
        {
                return CLIENT_WEB_DIR . "/survey/$this->obj_id/$this->id/materials/";
        }

        function getImagePathWeb() 
        {
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                $webdir = ilUtil::removeTrailingPathSeparators(CLIENT_WEB_DIR) . "/survey/$this->obj_id/$this->id/images/";
                return str_replace(ilUtil::removeTrailingPathSeparators(ILIAS_ABSOLUTE_PATH), ilUtil::removeTrailingPathSeparators(ILIAS_HTTP_PATH), $webdir);
        }

        function getMaterialsPathWeb() 
        {
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                $webdir = ilUtil::removeTrailingPathSeparators(CLIENT_WEB_DIR) . "/survey/$this->obj_id/$this->id/materials/";
                return str_replace(ilUtil::removeTrailingPathSeparators(ILIAS_ABSOLUTE_PATH), ilUtil::removeTrailingPathSeparators(ILIAS_HTTP_PATH), $webdir);
        }

  function saveMaterialsToDb()
  {
                if ($this->id > 0) 
                {
                        $query = sprintf("DELETE FROM survey_question_material WHERE question_fi = %s",
                                $this->ilias->db->quote($this->id)
                        );
                        $result = $this->ilias->db->query($query);
                        if (!empty($this->materials)) {
                                foreach ($this->materials as $key => $value) 
                                {
                                        $query = sprintf("INSERT INTO survey_question_material (question_fi, materials, materials_file) VALUES (%s, %s, %s)",
                                                $this->ilias->db->quote($this->id),
                                                $this->ilias->db->quote($key),
                                                $this->ilias->db->quote($value)
                                        );
                                        $result = $this->ilias->db->query($query);
                                }
                        }
                }
        }

  function loadMaterialFromDb($question_id)
  {
    $query = sprintf("SELECT * FROM survey_question_material WHERE question_fi = %s",
      $this->ilias->db->quote($question_id)
    );
    $result = $this->ilias->db->query($query);
    if (strcmp(strtolower(get_class($result)), db_result) == 0) 
                {
        $this->materials = array();
        while ($data = $result->fetchRow(DB_FETCHMODE_OBJECT)) 
                        {
                                $this->addMaterials($data->materials_file, $data->materials);
                        }
                }
        }

        function saveCategoryToDb($categorytext, $neutral = 0)
        {
                global $ilUser;
                
                $query = sprintf("SELECT title, category_id FROM survey_category WHERE title = %s AND neutral = %s AND owner_fi = %s",
                        $this->ilias->db->quote($categorytext . ""),
                        $this->ilias->db->quote($neutral . ""),
                        $this->ilias->db->quote($ilUser->getId() . "")
                );
    $result = $this->ilias->db->query($query);
                $insert = FALSE;
                $returnvalue = "";
                if ($result->numRows()) 
                {
                        $insert = TRUE;
                        while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT))
                        {
                                if (strcmp($row->title, $categorytext) == 0)
                                {
                                        $returnvalue = $row->category_id;
                                        $insert = FALSE;
                                }
                        }
                }
                else
                {
                        $insert = TRUE;
                }
                if ($insert)
                {
                        $query = sprintf("INSERT INTO survey_category (category_id, title, neutral, owner_fi, TIMESTAMP) VALUES (NULL, %s, %s, %s, NULL)",
                                $this->ilias->db->quote($categorytext . ""),
                                $this->ilias->db->quote($neutral . ""),
                                $this->ilias->db->quote($ilUser->getId() . "")
                        );
                        $result = $this->ilias->db->query($query);
                        $returnvalue = $this->ilias->db->getLastInsertId();
                }
                return $returnvalue;
        }

        function deleteAdditionalTableData($question_id)
        {
                global $ilDB;
                $additional_table_name = $this->getAdditionalTableName();
                $query = sprintf("DELETE FROM $additional_table_name WHERE question_fi = %s",
                        $ilDB->quote($question_id . "")
                );
                $result = $ilDB->query($query);
        }

  function delete($question_id) 
  {
    if ($question_id < 1)
      return;
      
                $query = sprintf("SELECT obj_fi FROM survey_question WHERE question_id = %s",
                        $this->ilias->db->quote($question_id)
                );
    $result = $this->ilias->db->query($query);
                if ($result->numRows() == 1)
                {
                        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
                        $obj_id = $row["obj_fi"];
                }
                else
                {
                        return;
                }
                
                $query = sprintf("DELETE FROM survey_answer WHERE question_fi = %s",
                        $this->ilias->db->quote($question_id)
                );
                $result = $this->ilias->db->query($query);

                $query = sprintf("SELECT constraint_id FROM survey_constraint WHERE question_fi = %s",
                        $this->ilias->db->quote($question_id)
                );
                $result = $this->ilias->db->query($query);
                while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $query = sprintf("DELETE FROM survey_question_constraint WHERE constraint_fi = %s",
                                $this->ilias->db->quote($row->constraint_id)
                        );
                        $delresult = $this->ilias->db->query($query);
                }
                
                $query = sprintf("DELETE FROM survey_constraint WHERE question_fi = %s",
                        $this->ilias->db->quote($question_id)
                );
                $result = $this->ilias->db->query($query);

                $query = sprintf("SELECT constraint_fi FROM survey_question_constraint WHERE question_fi = %s",
                        $this->ilias->db->quote($question_id)
                );
                $result = $this->ilias->db->query($query);
                while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $query = sprintf("DELETE FROM survey_constraint WHERE constraint_id = %s",
                                $this->ilias->db->quote($row->constraint_fi)
                        );
                        $delresult = $this->ilias->db->query($query);
                }
                $query = sprintf("DELETE FROM survey_question_constraint WHERE question_fi = %s",
                        $this->ilias->db->quote($question_id)
                );
                $result = $this->ilias->db->query($query);

                $query = sprintf("DELETE FROM survey_question_material WHERE question_fi = %s",
                        $this->ilias->db->quote($question_id)
                );
                $result = $this->ilias->db->query($query);

                $query = sprintf("DELETE FROM survey_questionblock_question WHERE question_fi = %s",
                        $this->ilias->db->quote($question_id)
                );
                $result = $this->ilias->db->query($query);

                $query = sprintf("DELETE FROM survey_question_obligatory WHERE question_fi = %s",
                        $this->ilias->db->quote($question_id)
                );
                $result = $this->ilias->db->query($query);

                $query = sprintf("DELETE FROM survey_survey_question WHERE question_fi = %s",
                        $this->ilias->db->quote($question_id)
                );
                $result = $this->ilias->db->query($query);

                $query = sprintf("DELETE FROM survey_variable WHERE question_fi = %s",
                        $this->ilias->db->quote($question_id)
                );
                $result = $this->ilias->db->query($query);

                $query = sprintf("DELETE FROM survey_question WHERE question_id = %s",
                        $this->ilias->db->quote($question_id)
                );
                $result = $this->ilias->db->query($query);

                $this->deleteAdditionalTableData($question_id);
                
                $query = sprintf("DELETE FROM survey_material WHERE question_fi = %s",
                        $this->ilias->db->quote($question_id)
                );
                $result = $this->ilias->db->query($query);
                include_once "./Services/COPage/classes/class.ilInternalLink.php";
                ilInternalLink::_deleteAllLinksOfSource("sqst", $question_id);

                $directory = CLIENT_WEB_DIR . "/survey/" . $obj_id . "/$question_id";
                if (preg_match("/\d+/", $obj_id) and preg_match("/\d+/", $question_id) and is_dir($directory))
                {
                        include_once "./Services/Utilities/classes/class.ilUtil.php";
                        ilUtil::delDir($directory);
                }

                include_once("./Services/MediaObjects/classes/class.ilObjMediaObject.php");
                $mobs = ilObjMediaObject::_getMobsOfObject("spl:html", $question_id);
                // 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, "spl:html", $question_id);
                        $mob_obj =& new ilObjMediaObject($mob);
                        $mob_obj->delete();
                }
        }

  function _getQuestionType($question_id) 
        {
                global $ilDB;

    if ($question_id < 1)
      return "";

    $query = sprintf("SELECT type_tag FROM survey_question, survey_questiontype WHERE survey_question.question_id = %s AND survey_question.questiontype_fi = survey_questiontype.questiontype_id",
      $ilDB->quote($question_id)
    );
    $result = $ilDB->query($query);
    if ($result->numRows() == 1) 
                {
      $data = $result->fetchRow(DB_FETCHMODE_OBJECT);
      return $data->type_tag;
    } 
                else 
                {
      return "";
    }
  }

  function _getTitle($question_id) 
        {
                global $ilDB;

    if ($question_id < 1) return "";

    $query = sprintf("SELECT title FROM survey_question WHERE survey_question.question_id = %s",
      $ilDB->quote($question_id)
    );
    $result = $ilDB->query($query);
    if ($result->numRows() == 1) 
                {
      $data = $result->fetchRow(DB_FETCHMODE_ASSOC);
      return $data["title"];
    } 
                else 
                {
      return "";
    }
  }

        function _getOriginalId($question_id)
        {
                global $ilDB;
                $query = sprintf("SELECT * FROM survey_question WHERE question_id = %s",
                        $ilDB->quote($question_id . "")
                );
                $result = $ilDB->query($query);
                if ($result->numRows() > 0)
                {
                        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
                        if ($row["original_id"] > 0)
                        {
                                return $row["original_id"];
                        }
                        else
                        {
                                return $row["question_id"];
                        }
                }
                else
                {
                        return "";
                }
        }
        
        function _getRefIdFromObjId($obj_id)
        {
                global $ilDB;
                
                $query = sprintf("SELECT ref_id FROM object_reference WHERE obj_id=%s",
                        $ilDB->quote($obj_id)
                        
                );
                $result = $ilDB->query($query);
                if ($result->numRows())
                {
                        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
                        return $row["ref_id"];
                }
                return 0;
        }
        
        function syncWithOriginal()
        {
                include_once "./Services/COPage/classes/class.ilInternalLink.php";
                $query = sprintf("DELETE FROM survey_material WHERE question_fi = %s",
                        $this->ilias->db->quote($this->original_id . "")
                );
                $result = $this->ilias->db->query($query);
                ilInternalLink::_deleteAllLinksOfSource("sqst", $this->original_id);
                if (strlen($this->material["internal_link"]))
                {
                        $query = sprintf("INSERT INTO survey_material (material_id, question_fi, internal_link, import_id, material_title, TIMESTAMP) VALUES (NULL, %s, %s, %s, %s, NULL)",
                                $this->ilias->db->quote($this->original_id . ""),
                                $this->ilias->db->quote($this->material["internal_link"] . ""),
                                $this->ilias->db->quote($this->material["import_id"] . ""),
                                $this->ilias->db->quote($this->material["title"] . "")
                        );
                        $this->ilias->db->query($query);
                        if (preg_match("/il_(\d*?)_(\w+)_(\d+)/", $this->material["internal_link"], $matches))
                        {
                                ilInternalLink::_saveLink("sqst", $this->original_id, $matches[2], $matches[3], $matches[1]);
                        }
                }
        }

        function getPhrase($phrase_id)
        {
                $query = sprintf("SELECT title FROM survey_phrase WHERE phrase_id = %s",
                        $this->ilias->db->quote($phrase_id)
                );
    $result = $this->ilias->db->query($query);
                if ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                {
                        return $row["title"];
                }
                return "";
        }

        function phraseExists($title)
        {
                global $ilUser;
                
                $query = sprintf("SELECT phrase_id FROM survey_phrase WHERE title = %s AND owner_fi = %s",
                        $this->ilias->db->quote($title),
                        $this->ilias->db->quote($ilUser->id)
                );
    $result = $this->ilias->db->query($query);
                if ($result->numRows() == 0)
                {
                        return false;
                }
                else
                {
                        return true;
                }
        }

        function _questionExists($question_id)
        {
                global $ilDB;

                if ($question_id < 1)
                {
                        return false;
                }
                
                $query = sprintf("SELECT question_id FROM survey_question WHERE question_id = %s",
                        $ilDB->quote($question_id)
                );
    $result = $ilDB->query($query);
                if ($result->numRows() == 1)
                {
                        return true;
                }
                else
                {
                        return false;
                }
        }

        function setMaterial($material_id = "", $is_import = false, $material_title = "")
        {
                if (strcmp($material_id, "") != 0)
                {
                        $import_id = "";
                        if ($is_import)
                        {
                                $import_id = $material_id;
                                $material_id = $this->_resolveInternalLink($import_id);
                        }
                        if (strcmp($material_title, "") == 0)
                        {
                                if (preg_match("/il__(\w+)_(\d+)/", $material_id, $matches))
                                {
                                        $type = $matches[1];
                                        $target_id = $matches[2];
                                        $material_title = $this->lng->txt("obj_$type") . ": ";
                                        switch ($type)
                                        {
                                                case "lm":
                                                        include_once("./Modules/LearningModule/classes/class.ilObjContentObjectGUI.php");
                                                        $cont_obj_gui =& new ilObjContentObjectGUI("", $target_id, true);
                                                        $cont_obj = $cont_obj_gui->object;
                                                        $material_title .= $cont_obj->getTitle();
                                                        break;
                                                case "pg":
                                                        include_once("./Modules/LearningModule/classes/class.ilLMPageObject.php");
                                                        include_once("./Modules/LearningModule/classes/class.ilLMObject.php");
                                                        $lm_id = ilLMObject::_lookupContObjID($target_id);
                                                        include_once("./Modules/LearningModule/classes/class.ilObjContentObjectGUI.php");
                                                        $cont_obj_gui =& new ilObjContentObjectGUI("", $lm_id, FALSE);
                                                        $cont_obj = $cont_obj_gui->object;
                                                        $pg_obj =& new ilLMPageObject($cont_obj, $target_id);
                                                        $material_title .= $pg_obj->getTitle();
                                                        break;
                                                case "st":
                                                        include_once("./Modules/LearningModule/classes/class.ilStructureObject.php");
                                                        include_once("./Modules/LearningModule/classes/class.ilLMObject.php");
                                                        $lm_id = ilLMObject::_lookupContObjID($target_id);
                                                        include_once("./Modules/LearningModule/classes/class.ilObjContentObjectGUI.php");
                                                        $cont_obj_gui =& new ilObjContentObjectGUI("", $lm_id, FALSE);
                                                        $cont_obj = $cont_obj_gui->object;
                                                        $st_obj =& new ilStructureObject($cont_obj, $target_id);
                                                        $material_title .= $st_obj->getTitle();
                                                        break;
                                                case "git":
                                                        include_once "./Modules/Glossary/classes/class.ilGlossaryTerm.php";
                                                        $material_title = $this->lng->txt("glossary_term") . ": " . ilGlossaryTerm::_lookGlossaryTerm($target_id);
                                                        break;
                                                case "mob":
                                                        break;
                                        }
                                }
                        }
                        $this->material = array(
                                "internal_link" => $material_id,
                                "import_id" => $import_id,
                                "title" => $material_title
                        );
                }
        }
        
        function _resolveInternalLink($internal_link)
        {
                if (preg_match("/il_(\d+)_(\w+)_(\d+)/", $internal_link, $matches))
                {
                        include_once "./Services/COPage/classes/class.ilInternalLink.php";
                        include_once "./Modules/LearningModule/classes/class.ilLMObject.php";
                        include_once "./Modules/Glossary/classes/class.ilGlossaryTerm.php";
                        switch ($matches[2])
                        {
                                case "lm":
                                        $resolved_link = ilLMObject::_getIdForImportId($internal_link);
                                        break;
                                case "pg":
                                        $resolved_link = ilInternalLink::_getIdForImportId("PageObject", $internal_link);
                                        break;
                                case "st":
                                        $resolved_link = ilInternalLink::_getIdForImportId("StructureObject", $internal_link);
                                        break;
                                case "git":
                                        $resolved_link = ilInternalLink::_getIdForImportId("GlossaryItem", $internal_link);
                                        break;
                                case "mob":
                                        $resolved_link = ilInternalLink::_getIdForImportId("MediaObject", $internal_link);
                                        break;
                        }
                        if (strcmp($resolved_link, "") == 0)
                        {
                                $resolved_link = $internal_link;
                        }
                }
                else
                {
                        $resolved_link = $internal_link;
                }
                return $resolved_link;
        }
        
        function _resolveIntLinks($question_id)
        {
                global $ilDB;
                $resolvedlinks = 0;
                $query = sprintf("SELECT * FROM survey_material WHERE question_fi = %s",
                        $ilDB->quote($question_id . "")
                );
                $result = $ilDB->query($query);
                if ($result->numRows())
                {
                        while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                        {
                                $internal_link = $row["internal_link"];
                                include_once "./Modules/SurveyQuestionPool/classes/class.SurveyQuestion.php";
                                $resolved_link = SurveyQuestion::_resolveInternalLink($internal_link);
                                if (strcmp($internal_link, $resolved_link) != 0)
                                {
                                        // internal link was resolved successfully
                                        $queryupdate = sprintf("UPDATE survey_material SET internal_link = %s WHERE material_id = %s",
                                                $ilDB->quote($resolved_link),
                                                $ilDB->quote($row["material_id"] . "")
                                        );
                                        $updateresult = $ilDB->query($queryupdate);
                                        $resolvedlinks++;
                                }
                        }
                }
                if ($resolvedlinks)
                {
                        // there are resolved links -> reenter theses links to the database

                        // delete all internal links from the database
                        include_once "./Services/COPage/classes/class.ilInternalLink.php";
                        ilInternalLink::_deleteAllLinksOfSource("sqst", $question_id);

                        $query = sprintf("SELECT * FROM survey_material WHERE question_fi = %s",
                                $ilDB->quote($question_id . "")
                        );
                        $result = $ilDB->query($query);
                        if ($result->numRows())
                        {
                                while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                                {
                                        if (preg_match("/il_(\d*?)_(\w+)_(\d+)/", $row["internal_link"], $matches))
                                        {
                                                ilInternalLink::_saveLink("sqst", $question_id, $matches[2], $matches[3], $matches[1]);
                                        }
                                }
                        }
                }
        }
        
        function _getInternalLinkHref($target = "")
        {
                global $ilDB;
                $linktypes = array(
                        "lm" => "LearningModule",
                        "pg" => "PageObject",
                        "st" => "StructureObject",
                        "git" => "GlossaryItem",
                        "mob" => "MediaObject"
                );
                $href = "";
                if (preg_match("/il__(\w+)_(\d+)/", $target, $matches))
                {
                        $type = $matches[1];
                        $target_id = $matches[2];
                        include_once "./Services/Utilities/classes/class.ilUtil.php";
                        switch($linktypes[$matches[1]])
                        {
                                case "LearningModule":
                                        $href = ilUtil::removeTrailingPathSeparators(ILIAS_HTTP_PATH) ."/goto.php?target=" . $type . "_" . $target_id;
                                        break;
                                case "PageObject":
                                case "StructureObject":
                                        $href = ilUtil::removeTrailingPathSeparators(ILIAS_HTTP_PATH) ."/goto.php?target=" . $type . "_" . $target_id;
                                        break;
                                case "GlossaryItem":
                                        $href = ilUtil::removeTrailingPathSeparators(ILIAS_HTTP_PATH) ."/goto.php?target=" . $type . "_" . $target_id;
                                        break;
                                case "MediaObject":
                                        $href = ilUtil::removeTrailingPathSeparators(ILIAS_HTTP_PATH) . "/ilias.php?baseClass=ilLMPresentationGUI&obj_type=" . $linktypes[$type] . "&cmd=media&ref_id=".$_GET["ref_id"]."&mob_id=".$target_id;
                                        break;
                        }
                }
                return $href;
        }
        
        function _isWriteable($question_id, $user_id)
        {
                global $ilDB;

                if (($question_id < 1) || ($user_id < 1))
                {
                        return false;
                }
                
                $query = sprintf("SELECT obj_fi FROM survey_question WHERE question_id = %s",
                        $ilDB->quote($question_id . "")
                );
    $result = $ilDB->query($query);
                if ($result->numRows() == 1)
                {
                        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
                        $qpl_object_id = $row["obj_fi"];
                        include_once "./Modules/SurveyQuestionPool/classes/class.ilObjSurveyQuestionPool.php";
                        return ilObjSurveyQuestionPool::_isWriteable($qpl_object_id, $user_id);
                }
                else
                {
                        return false;
                }
        }

        function getQuestionTypeID()
        {
                global $ilDB;
                $query = sprintf("SELECT questiontype_id FROM survey_questiontype WHERE type_tag = %s",
                        $ilDB->quote($this->getQuestionType())
                );
                $result = $ilDB->query($query);
                if ($result->numRows() == 1)
                {
                        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
                        return $row["questiontype_id"];
                }
                else
                {
                        return 0;
                }
        }

        function getQuestionType()
        {
                return "";
        }
        
  function &_instanciateQuestion($question_id) 
        {
                $question_type = SurveyQuestion::_getQuestionType($question_id);
                include_once "./Modules/SurveyQuestionPool/classes/class.$question_type.php";
                $question = new $question_type();
                $question->loadFromDb($question_id);
                return $question;
  }
        
        function isHTML($a_text)
        {
                if (preg_match("/<[^>]*?>/", $a_text))
                {
                        return TRUE;
                }
                else
                {
                        return FALSE; 
                }
        }
        
        function QTIMaterialToString($a_material)
        {
                $result = "";
                for ($i = 0; $i < $a_material->getMaterialCount(); $i++)
                {
                        $material = $a_material->getMaterial($i);
                        if (strcmp($material["type"], "mattext") == 0)
                        {
                                $result .= $material["material"]->getContent();
                        }
                        if (strcmp($material["type"], "matimage") == 0)
                        {
                                $matimage = $material["material"];
                                if (preg_match("/(il_([0-9]+)_mob_([0-9]+))/", $matimage->getLabel(), $matches))
                                {
                                        // import an mediaobject which was inserted using tiny mce
                                        if (!is_array($_SESSION["import_mob_xhtml"])) $_SESSION["import_mob_xhtml"] = array();
                                        array_push($_SESSION["import_mob_xhtml"], array("mob" => $matimage->getLabel(), "uri" => $matimage->getUri()));
                                }
                        }
                }
                return $result;
        }
        
        function addMaterialTag(&$a_xml_writer, $a_material, $close_material_tag = TRUE, $add_mobs = TRUE)
        {
                include_once "./Services/RTE/classes/class.ilRTE.php";
                include_once("./Services/MediaObjects/classes/class.ilObjMediaObject.php");

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

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

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

        function _getQuestionDataArray($id)
        {
                return array();
        }

        
        function addUserSpecificResultsExportTitles(&$a_array)
        {
                array_push($a_array, $this->getTitle());
        }

        function addUserSpecificResultsData(&$a_array, &$resultset)
        {
                // overwrite in inherited classes
        }

        function &getUserAnswers($survey_id)
        {
                // overwrite in inherited classes
                return array();
        }

        function &getWorkingDataFromUserInput($post_data)
        {
                // overwrite in inherited classes
                $data = array();
                return $data;
        }
        
        function importAdditionalMetadata($a_meta)
        {
                // overwrite in inherited classes
        }
        
        function importResponses($a_data)
        {
                // overwrite in inherited classes
        }

        function importAdjectives($a_data)
        {
                // overwrite in inherited classes
        }

        function importMatrix($a_data)
        {
                // overwrite in inherited classes
        }

        function setExportCumulatedXLS(&$worksheet, &$format_title, &$format_bold, &$eval_data, $row)
        {
                include_once ("./classes/class.ilExcelUtils.php");
                $worksheet->writeString($row, 0, ilExcelUtils::_convert_text($this->getTitle()));
                $worksheet->writeString($row, 1, ilExcelUtils::_convert_text($this->getQuestiontext()));
                $worksheet->writeString($row, 2, ilExcelUtils::_convert_text($this->lng->txt($eval_data["QUESTION_TYPE"])));
                $worksheet->write($row, 3, $eval_data["USERS_ANSWERED"]);
                $worksheet->write($row, 4, $eval_data["USERS_SKIPPED"]);
                $worksheet->write($row, 5, ilExcelUtils::_convert_text($eval_data["MODE_VALUE"]));
                $worksheet->write($row, 6, ilExcelUtils::_convert_text($eval_data["MODE"]));
                $worksheet->write($row, 7, $eval_data["MODE_NR_OF_SELECTIONS"]);
                $worksheet->write($row, 8, ilExcelUtils::_convert_text(str_replace("<br />", " ", $eval_data["MEDIAN"])));
                $worksheet->write($row, 9, $eval_data["ARITHMETIC_MEAN"]);
                return $row + 1;
        }
        
        function &setExportCumulatedCVS(&$eval_data)
        {
                $csvrow = array();
                array_push($csvrow, $this->getTitle());
                array_push($csvrow, $this->getQuestiontext());
                array_push($csvrow, $this->lng->txt($eval_data["QUESTION_TYPE"]));
                array_push($csvrow, $eval_data["USERS_ANSWERED"]);
                array_push($csvrow, $eval_data["USERS_SKIPPED"]);
                array_push($csvrow, $eval_data["MODE"]);
                array_push($csvrow, $eval_data["MODE_NR_OF_SELECTIONS"]);
                array_push($csvrow, $eval_data["MEDIAN"]);
                array_push($csvrow, $eval_data["ARITHMETIC_MEAN"]);
                $result = array();
                array_push($result, $csvrow);
                return $result;
        }
        
        function setExportDetailsXLS(&$workbook, &$format_title, &$format_bold, &$eval_data)
        {
                // overwrite in inherited classes
        }
        
        function usableForPrecondition()
        {
                // overwrite in inherited classes
                return FALSE;
        }

        function getAvailableRelations()
        {
                // overwrite in inherited classes
                return array();
        }

        function getPreconditionSelectValue($default = "")
        {
                // overwrite in inherited classes
        }
        
        function getPreconditionValueOutput($value)
        {
                // overwrite in inherited classes
                return $value;
        }

        function outChart($survey_id, $type = "")
        {
                // overwrite in inherited classes
        }
        
}
?>