ILIAS  Release_4_2_x_branch Revision 61807
 All Data Structures Namespaces Files Functions Variables Groups Pages
class.SurveyQuestion.php
Go to the documentation of this file.
1 <?php
2  /*
3  +----------------------------------------------------------------------------+
4  | ILIAS open source |
5  +----------------------------------------------------------------------------+
6  | Copyright (c) 1998-2001 ILIAS open source, University of Cologne |
7  | |
8  | This program is free software; you can redistribute it and/or |
9  | modify it under the terms of the GNU General Public License |
10  | as published by the Free Software Foundation; either version 2 |
11  | of the License, or (at your option) any later version. |
12  | |
13  | This program is distributed in the hope that it will be useful, |
14  | but WITHOUT ANY WARRANTY; without even the implied warranty of |
15  | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
16  | GNU General Public License for more details. |
17  | |
18  | You should have received a copy of the GNU General Public License |
19  | along with this program; if not, write to the Free Software |
20  | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
21  +----------------------------------------------------------------------------+
22 */
23 
24 include_once "./Modules/Survey/classes/inc.SurveyConstants.php";
25 
36 class SurveyQuestion
37 {
43  var $id;
44 
50  var $title;
56  var $description;
63  var $owner;
64 
71  var $author;
72 
78  var $materials;
79 
85  var $survey_id;
86 
92  var $obj_id;
93 
99  var $questiontext;
100 
106  var $obligatory;
107 
113  var $ilias;
114 
120  var $tpl;
121 
127  var $lng;
128 
134  var $orientation;
135 
136  var $material;
137  var $complete;
138 
142  protected $cumulated;
143 
147  private $arrData;
148 
159  function SurveyQuestion
160  (
161  $title = "",
162  $description = "",
163  $author = "",
164  $questiontext = "",
165  $owner = -1
166  )
167  {
168  global $ilias;
169  global $lng;
170  global $tpl;
171 
172  $this->ilias =& $ilias;
173  $this->lng =& $lng;
174  $this->tpl =& $tpl;
175  $this->complete =
176  $this->title = $title;
177  $this->description = $description;
178  $this->questiontext = $questiontext;
179  $this->author = $author;
180  $this->cumulated = array();
181  if (!$this->author)
182  {
183  $this->author = $this->ilias->account->fullname;
184  }
185  $this->owner = $owner;
186  if ($this->owner == -1)
187  {
188  $this->owner = $this->ilias->account->id;
189  }
190  $this->id = -1;
191  $this->survey_id = -1;
192  $this->obligatory = 1;
193  $this->orientation = 0;
194  $this->materials = array();
195  $this->material = array();
196  $this->arrData = array();
197  register_shutdown_function(array(&$this, '_SurveyQuestion'));
198  }
199 
200  function _SurveyQuestion()
201  {
202  }
203 
210  function setComplete($a_complete)
211  {
212  $this->complete = ($a_complete) ? 1 : 0;
213  }
214 
221  function isComplete()
222  {
223  return 0;
224  }
225 
234  function questionTitleExists($title, $questionpool_object = "")
235  {
236  global $ilDB;
237 
238  $refwhere = "";
239  if (strcmp($questionpool_object, "") != 0)
240  {
241  $refwhere = sprintf(" AND obj_fi = %s",
242  $ilDB->quote($questionpool_object, 'integer')
243  );
244  }
245  $result = $ilDB->queryF("SELECT question_id FROM svy_question WHERE title = %s$refwhere",
246  array('text'),
247  array($title)
248  );
249  return ($result->numRows() > 0) ? true : false;
250  }
251 
259  function setTitle($title = "")
260  {
261  $this->title = $title;
262  }
263 
271  function setObligatory($obligatory = 1)
272  {
273  $this->obligatory = ($obligatory) ? 1 : 0;
274  }
275 
283  function setOrientation($orientation = 0)
284  {
285  $this->orientation = ($orientation) ? $orientation : 0;
286  }
287 
295  function setId($id = -1)
296  {
297  $this->id = $id;
298  }
299 
307  function setSurveyId($id = -1)
308  {
309  $this->survey_id = $id;
310  }
311 
319  function setDescription($description = "")
320  {
321  $this->description = $description;
322  }
323 
324 
333  function addMaterials($materials_file, $materials_name="")
334  {
335  if (empty($materials_name))
336  {
337  $materials_name = $materials_file;
338  }
339  if ((!empty($materials_name))&&(!array_key_exists($materials_name, $this->materials)))
340  {
341  $this->materials[$materials_name] = $materials_file;
342  }
343  }
344 
352  function setMaterialsfile($materials_filename, $materials_tempfilename="", $materials_name="")
353  {
354  if (!empty($materials_filename))
355  {
356  include_once "./Services/Utilities/classes/class.ilUtil.php";
357  $materialspath = $this->getMaterialsPath();
358  if (!file_exists($materialspath))
359  {
360  ilUtil::makeDirParents($materialspath);
361  }
362  //if (!move_uploaded_file($materials_tempfilename, $materialspath . $materials_filename))
363  if (ilUtil::moveUploadedFile($materials_tempfilename, $materials_filename,
364  $materialspath.$materials_filename))
365  {
366  print "image not uploaded!!!! ";
367  }
368  else
369  {
370  $this->addMaterials($materials_filename, $materials_name);
371  }
372  }
373  }
374 
382  function deleteMaterial($materials_name = "")
383  {
384  foreach ($this->materials as $key => $value)
385  {
386  if (strcmp($key, $materials_name)==0)
387  {
388  if (file_exists($this->getMaterialsPath().$value))
389  {
390  unlink($this->getMaterialsPath().$value);
391  }
392  unset($this->materials[$key]);
393  }
394  }
395  }
396 
403  function flushMaterials()
404  {
405  $this->materials = array();
406  }
407 
415  function setAuthor($author = "")
416  {
417  if (!$author)
418  {
419  $author = $this->ilias->account->fullname;
420  }
421  $this->author = $author;
422  }
423 
431  function setQuestiontext($questiontext = "")
432  {
433  $this->questiontext = $questiontext;
434  }
435 
443  function setOwner($owner = "")
444  {
445  $this->owner = $owner;
446  }
447 
455  function getTitle()
456  {
457  return $this->title;
458  }
459 
467  function getId()
468  {
469  return $this->id;
470  }
471 
478  public function getObligatory($survey_id = "")
479  {
480  if ($survey_id > 0)
481  {
482  global $ilDB;
483 
484  $result = $ilDB->queryF("SELECT * FROM svy_qst_oblig WHERE survey_fi = %s AND question_fi = %s",
485  array('integer', 'integer'),
486  array($survey_id, $this->getId())
487  );
488  if ($result->numRows())
489  {
490  $row = $ilDB->fetchAssoc($result);
491  return ($row["obligatory"]) ? 1 : 0;
492  }
493  else
494  {
495  return ($this->obligatory) ? 1 : 0;
496  }
497  }
498  else
499  {
500  return ($this->obligatory) ? 1 : 0;
501  }
502  }
503 
511  function getSurveyId()
512  {
513  return $this->survey_id;
514  }
515 
523  function getOrientation()
524  {
525  switch ($this->orientation)
526  {
527  case 0:
528  case 1:
529  case 2:
530  break;
531  default:
532  $this->orientation = 0;
533  break;
534  }
535  return $this->orientation;
536  }
537 
538 
546  function getDescription()
547  {
548  return (strlen($this->description)) ? $this->description : NULL;
549  }
550 
558  function getAuthor()
559  {
560  return (strlen($this->author)) ? $this->author : NULL;
561  }
562 
570  function getOwner()
571  {
572  return $this->owner;
573  }
574 
582  function getQuestiontext()
583  {
584  return (strlen($this->questiontext)) ? $this->questiontext : NULL;
585  }
586 
594  function getObjId() {
595  return $this->obj_id;
596  }
597 
605  function setObjId($obj_id = 0)
606  {
607  $this->obj_id = $obj_id;
608  }
609 
615  function duplicate($for_survey = true, $title = "", $author = "", $owner = "")
616  {
617  if ($this->getId() <= 0)
618  {
619  // The question has not been saved. It cannot be duplicated
620  return;
621  }
622  // duplicate the question in database
623  $clone = $this;
624  $original_id = $this->getId();
625  $clone->setId(-1);
626  if ($title)
627  {
628  $clone->setTitle($title);
629  }
630  if ($author)
631  {
632  $clone->setAuthor($author);
633  }
634  if ($owner)
635  {
636  $clone->setOwner($owner);
637  }
638  if ($for_survey)
639  {
640  $clone->saveToDb($original_id);
641  }
642  else
643  {
644  $clone->saveToDb();
645  }
646  // duplicate the materials
647  $clone->duplicateMaterials($original_id);
648  // copy XHTML media objects
649  $clone->copyXHTMLMediaObjectsOfQuestion($original_id);
650  return $clone->getId();
651  }
652 
658  function copyObject($target_questionpool, $title = "")
659  {
660  if ($this->getId() <= 0)
661  {
662  // The question has not been saved. It cannot be copied
663  return;
664  }
665  $clone = $this;
666  $original_id = SurveyQuestion::_getOriginalId($this->getId());
667  $clone->setId(-1);
668  $source_questionpool = $this->getObjId();
669  $clone->setObjId($target_questionpool);
670  if ($title)
671  {
672  $clone->setTitle($title);
673  }
674 
675  $clone->saveToDb();
676 
677  // duplicate the materials
678  $clone->duplicateMaterials($original_id);
679  // copy XHTML media objects
680  $clone->copyXHTMLMediaObjectsOfQuestion($original_id);
681  return $clone->getId();
682  }
683 
690  function copyXHTMLMediaObjectsOfQuestion($a_q_id)
691  {
692  include_once("./Services/MediaObjects/classes/class.ilObjMediaObject.php");
693  $mobs = ilObjMediaObject::_getMobsOfObject("spl:html", $a_q_id);
694  foreach ($mobs as $mob)
695  {
696  ilObjMediaObject::_saveUsage($mob, "spl:html", $this->getId());
697  }
698  }
699 
706  function loadFromDb($question_id)
707  {
708  global $ilDB;
709 
710  $result = $ilDB->queryF("SELECT * FROM svy_material WHERE question_fi = %s",
711  array('integer'),
712  array($this->getId())
713  );
714  $this->material = array();
715  if ($result->numRows())
716  {
717  include_once "./Modules/SurveyQuestionPool/classes/class.ilSurveyMaterial.php";
718  while ($row = $ilDB->fetchAssoc($result))
719  {
720  $mat = new ilSurveyMaterial();
721  $mat->type = $row['material_type'];
722  $mat->internal_link = $row['internal_link'];
723  $mat->title = $row['material_title'];
724  $mat->import_id = $row['import_id'];
725  $mat->text_material = $row['text_material'];
726  $mat->external_link = $row['external_link'];
727  $mat->file_material = $row['file_material'];
728  array_push($this->material, $mat);
729  }
730  }
731  }
732 
739  function _isComplete($question_id)
740  {
741  global $ilDB;
742 
743  $result = $ilDB->queryF("SELECT complete FROM svy_question WHERE question_id = %s",
744  array('integer'),
745  array($question_id)
746  );
747  if ($result->numRows())
748  {
749  $row = $ilDB->fetchAssoc($result);
750  if ($row["complete"] == 1)
751  {
752  return TRUE;
753  }
754  }
755  return FALSE;
756  }
757 
763  function saveCompletionStatus($original_id = "")
764  {
765  global $ilDB;
766 
767  $question_id = $this->getId();
768  if (strlen($original_id))
769  {
770  $question_id = $original_id;
771  }
772 
773  if ($this->getId() > 0)
774  {
775  // update existing dataset
776  $affectedRows = $ilDB->manipulateF("UPDATE svy_question SET complete = %s, tstamp = %s WHERE question_id = %s",
777  array('text', 'integer', 'integer'),
778  array($this->isComplete(), time(), $question_id)
779  );
780  }
781  }
782 
789  function saveToDb($original_id = "")
790  {
791  global $ilDB;
792 
793  // cleanup RTE images which are not inserted into the question text
794  include_once("./Services/RTE/classes/class.ilRTE.php");
795  ilRTE::_cleanupMediaObjectUsage($this->getQuestiontext(), "spl:html", $this->getId());
796  $affectedRows = 0;
797  if ($this->getId() == -1)
798  {
799  // Write new dataset
800  $next_id = $ilDB->nextId('svy_question');
801  $affectedRows = $ilDB->insert("svy_question", array(
802  "question_id" => array("integer", $next_id),
803  "questiontype_fi" => array("integer", $this->getQuestionTypeID()),
804  "obj_fi" => array("integer", $this->getObjId()),
805  "owner_fi" => array("integer", $this->getOwner()),
806  "title" => array("text", $this->getTitle()),
807  "label" => array("text", (strlen($this->label)) ? $this->label : null),
808  "description" => array("text", $this->getDescription()),
809  "author" => array("text", $this->getAuthor()),
810  "questiontext" => array("clob", ilRTE::_replaceMediaObjectImageSrc($this->getQuestiontext(), 0)),
811  "obligatory" => array("text", $this->getObligatory()),
812  "complete" => array("text", $this->isComplete()),
813  "created" => array("integer", time()),
814  "original_id" => array("integer", ($original_id) ? $original_id : NULL),
815  "tstamp" => array("integer", time())
816  ));
817  $this->setId($next_id);
818  }
819  else
820  {
821  // update existing dataset
822  $affectedRows = $ilDB->update("svy_question", array(
823  "title" => array("text", $this->getTitle()),
824  "label" => array("text", (strlen($this->label)) ? $this->label : null),
825  "description" => array("text", $this->getDescription()),
826  "author" => array("text", $this->getAuthor()),
827  "questiontext" => array("clob", ilRTE::_replaceMediaObjectImageSrc($this->getQuestiontext(), 0)),
828  "obligatory" => array("text", $this->getObligatory()),
829  "complete" => array("text", $this->isComplete()),
830  "tstamp" => array("integer", time())
831  ), array(
832  "question_id" => array("integer", $this->getId())
833  ));
834  }
835 
836  // #12420
837  $set = $ilDB->query("SELECT survey_id FROM svy_svy".
838  " WHERE obj_fi = ".$ilDB->quote($this->getObjId(), "integer"));
839  $survey_fi = $ilDB->fetchAssoc($set);
840  $survey_fi = $survey_fi["survey_id"];
841 
842  // pool?
843  if($survey_fi)
844  {
845  $set = $ilDB->query("SELECT obligatory FROM svy_qst_oblig".
846  " WHERE survey_fi = ".$ilDB->quote($survey_fi, "integer").
847  " AND question_fi = ".$ilDB->quote($this->getId(), "integer"));
848  $has_obligatory_states_entry = (bool)$ilDB->numRows($set);
849  $is_obligatory = $ilDB->fetchAssoc($set);
850  $is_obligatory = (bool)$is_obligatory["obligatory"];
851 
852  if(!$this->getObligatory())
853  {
854  if($has_obligatory_states_entry)
855  {
856  $ilDB->manipulate("DELETE FROM svy_qst_oblig".
857  " WHERE survey_fi = ".$ilDB->quote($survey_fi, "integer").
858  " AND question_fi = ".$ilDB->quote($this->getId(), "integer"));
859  }
860  }
861  else if($this->getObligatory())
862  {
863  if(!$has_obligatory_states_entry)
864  {
865  // ilObjSurvey::setObligatoryStates()
866  $next_id = $ilDB->nextId('svy_qst_oblig');
867  $affectedRows = $ilDB->manipulateF("INSERT INTO svy_qst_oblig (question_obligatory_id, survey_fi, question_fi, " .
868  "obligatory, tstamp) VALUES (%s, %s, %s, %s, %s)",
869  array('integer','integer','integer','text','integer'),
870  array($next_id, $survey_fi, $this->getId(), 1, time())
871  );
872  }
873  else if(!$is_obligatory)
874  {
875  $ilDB->manipulate("UPDATE svy_qst_oblig".
876  " SET obligatory = ".$ilDB->quote(1, "integer").
877  " WHERE survey_fi = ".$ilDB->quote($survey_fi, "integer").
878  " AND question_fi = ".$ilDB->quote($this->getId(), "integer"));
879  }
880  }
881  }
882 
883  return $affectedRows;
884  }
885 
889  public function saveMaterial()
890  {
891  global $ilDB;
892 
893  include_once "./Services/COPage/classes/class.ilInternalLink.php";
894  $affectedRows = $ilDB->manipulateF("DELETE FROM svy_material WHERE question_fi = %s",
895  array('integer'),
896  array($this->getId())
897  );
898  ilInternalLink::_deleteAllLinksOfSource("sqst", $this->getId());
899 
900  foreach ($this->material as $material)
901  {
902  $next_id = $ilDB->nextId('svy_material');
903  $affectedRows = $ilDB->manipulateF("INSERT INTO svy_material " .
904  "(material_id, question_fi, internal_link, import_id, material_title, tstamp," .
905  "text_material, external_link, file_material, material_type) ".
906  "VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
907  array('integer','integer','text','text','text','integer','text','text','text','integer'),
908  array(
909  $next_id, $this->getId(), $material->internal_link, $material->import_id,
910  $material->title, time(), $material->text_material, $material->external_link,
911  $material->file_material, $material->type)
912  );
913  if (preg_match("/il_(\d*?)_(\w+)_(\d+)/", $material->internal_link, $matches))
914  {
915  ilInternalLink::_saveLink("sqst", $this->getId(), $matches[2], $matches[3], $matches[1]);
916  }
917  }
918  }
919 
926  public function createNewQuestion()
927  {
928  global $ilDB, $ilUser;
929 
930  $obj_id = ($this->getObjId() <= 0) ? (ilObject::_lookupObjId((strlen($_GET["ref_id"])) ? $_GET["ref_id"] : $_POST["sel_qpl"])) : $this->getObjId();
931  if ($obj_id > 0)
932  {
933  $next_id = $ilDB->nextId('svy_question');
934  $affectedRows = $ilDB->manipulateF("INSERT INTO svy_question (question_id, questiontype_fi, " .
935  "obj_fi, owner_fi, title, description, author, questiontext, obligatory, complete, " .
936  "created, original_id, tstamp) VALUES " .
937  "(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
938  array('integer', 'integer', 'integer', 'integer', 'text', 'text', 'text', 'text',
939  'text', 'text', 'integer', 'integer', 'integer'),
940  array(
941  $next_id,
942  $this->getQuestionTypeID(),
943  $obj_id,
944  $this->getOwner(),
945  NULL,
946  NULL,
947  $this->getAuthor(),
948  NULL,
949  "1",
950  "0",
951  time(),
952  NULL,
953  0
954  )
955  );
956  $this->setId($next_id);
957  }
958  return $this->getId();
959  }
960 
967  function saveWorkingData($limit_to = LIMIT_NO_LIMIT)
968  {
969  }
970 
977  function getImagePath()
978  {
979  return CLIENT_WEB_DIR . "/survey/$this->obj_id/$this->id/images/";
980  }
981 
988  function getMaterialsPath()
989  {
990  return CLIENT_WEB_DIR . "/survey/$this->obj_id/$this->id/materials/";
991  }
992 
999  function getImagePathWeb()
1000  {
1001  include_once "./Services/Utilities/classes/class.ilUtil.php";
1002  $webdir = ilUtil::removeTrailingPathSeparators(CLIENT_WEB_DIR) . "/survey/$this->obj_id/$this->id/images/";
1003  return str_replace(ilUtil::removeTrailingPathSeparators(ILIAS_ABSOLUTE_PATH), ilUtil::removeTrailingPathSeparators(ILIAS_HTTP_PATH), $webdir);
1004  }
1005 
1012  function getMaterialsPathWeb()
1013  {
1014  include_once "./Services/Utilities/classes/class.ilUtil.php";
1015  $webdir = ilUtil::removeTrailingPathSeparators(CLIENT_WEB_DIR) . "/survey/$this->obj_id/$this->id/materials/";
1016  return str_replace(ilUtil::removeTrailingPathSeparators(ILIAS_ABSOLUTE_PATH), ilUtil::removeTrailingPathSeparators(ILIAS_HTTP_PATH), $webdir);
1017  }
1018 
1027  function saveCategoryToDb($categorytext, $neutral = 0)
1028  {
1029  global $ilUser, $ilDB;
1030 
1031  $result = $ilDB->queryF("SELECT title, category_id FROM svy_category WHERE title = %s AND neutral = %s AND owner_fi = %s",
1032  array('text','text','integer'),
1033  array($categorytext, $neutral, $ilUser->getId())
1034  );
1035  $insert = FALSE;
1036  $returnvalue = "";
1037  if ($result->numRows())
1038  {
1039  $insert = TRUE;
1040  while ($row = $ilDB->fetchAssoc($result))
1041  {
1042  if (strcmp($row["title"], $categorytext) == 0)
1043  {
1044  $returnvalue = $row["category_id"];
1045  $insert = FALSE;
1046  }
1047  }
1048  }
1049  else
1050  {
1051  $insert = TRUE;
1052  }
1053  if ($insert)
1054  {
1055  $next_id = $ilDB->nextId('svy_category');
1056  $affectedRows = $ilDB->manipulateF("INSERT INTO svy_category (category_id, title, neutral, owner_fi, tstamp) VALUES (%s, %s, %s, %s, %s)",
1057  array('integer','text','text','integer','integer'),
1058  array($next_id, $categorytext, $neutral, $ilUser->getId(), time())
1059  );
1060  $returnvalue = $next_id;
1061  }
1062  return $returnvalue;
1063  }
1064 
1071  function deleteAdditionalTableData($question_id)
1072  {
1073  global $ilDB;
1074  $affectedRows = $ilDB->manipulateF("DELETE FROM " . $this->getAdditionalTableName() . " WHERE question_fi = %s",
1075  array('integer'),
1076  array($question_id)
1077  );
1078  }
1079 
1086  function delete($question_id)
1087  {
1088  global $ilDB;
1089 
1090  if ($question_id < 1) return;
1091 
1092  $result = $ilDB->queryF("SELECT obj_fi FROM svy_question WHERE question_id = %s",
1093  array('integer'),
1094  array($question_id)
1095  );
1096  if ($result->numRows() == 1)
1097  {
1098  $row = $ilDB->fetchAssoc($result);
1099  $obj_id = $row["obj_fi"];
1100  }
1101  else
1102  {
1103  return;
1104  }
1105 
1106  $affectedRows = $ilDB->manipulateF("DELETE FROM svy_answer WHERE question_fi = %s",
1107  array('integer'),
1108  array($question_id)
1109  );
1110 
1111  $affectedRows = $ilDB->manipulateF("DELETE FROM svy_constraint WHERE question_fi = %s",
1112  array('integer'),
1113  array($question_id)
1114  );
1115 
1116  $result = $ilDB->queryF("SELECT constraint_fi FROM svy_qst_constraint WHERE question_fi = %s",
1117  array('integer'),
1118  array($question_id)
1119  );
1120  while ($row = $ilDB->fetchObject($result))
1121  {
1122  $affectedRows = $ilDB->manipulateF("DELETE FROM svy_constraint WHERE constraint_id = %s",
1123  array('integer'),
1124  array($row->constraint_fi)
1125  );
1126  }
1127 
1128  $affectedRows = $ilDB->manipulateF("DELETE FROM svy_qst_constraint WHERE question_fi = %s",
1129  array('integer'),
1130  array($question_id)
1131  );
1132 
1133  $affectedRows = $ilDB->manipulateF("DELETE FROM svy_qblk_qst WHERE question_fi = %s",
1134  array('integer'),
1135  array($question_id)
1136  );
1137  $affectedRows = $ilDB->manipulateF("DELETE FROM svy_qst_oblig WHERE question_fi = %s",
1138  array('integer'),
1139  array($question_id)
1140  );
1141  $affectedRows = $ilDB->manipulateF("DELETE FROM svy_svy_qst WHERE question_fi = %s",
1142  array('integer'),
1143  array($question_id)
1144  );
1145  $affectedRows = $ilDB->manipulateF("DELETE FROM svy_variable WHERE question_fi = %s",
1146  array('integer'),
1147  array($question_id)
1148  );
1149  $affectedRows = $ilDB->manipulateF("DELETE FROM svy_question WHERE question_id = %s",
1150  array('integer'),
1151  array($question_id)
1152  );
1153 
1154  $this->deleteAdditionalTableData($question_id);
1155 
1156  $affectedRows = $ilDB->manipulateF("DELETE FROM svy_material WHERE question_fi = %s",
1157  array('integer'),
1158  array($question_id)
1159  );
1160  include_once "./Services/COPage/classes/class.ilInternalLink.php";
1161  ilInternalLink::_deleteAllLinksOfSource("sqst", $question_id);
1162 
1163  $directory = CLIENT_WEB_DIR . "/survey/" . $obj_id . "/$question_id";
1164  if (preg_match("/\d+/", $obj_id) and preg_match("/\d+/", $question_id) and is_dir($directory))
1165  {
1166  include_once "./Services/Utilities/classes/class.ilUtil.php";
1167  ilUtil::delDir($directory);
1168  }
1169 
1170  include_once("./Services/MediaObjects/classes/class.ilObjMediaObject.php");
1171  $mobs = ilObjMediaObject::_getMobsOfObject("spl:html", $question_id);
1172  // remaining usages are not in text anymore -> delete them
1173  // and media objects (note: delete method of ilObjMediaObject
1174  // checks whether object is used in another context; if yes,
1175  // the object is not deleted!)
1176  foreach($mobs as $mob)
1177  {
1178  ilObjMediaObject::_removeUsage($mob, "spl:html", $question_id);
1179  $mob_obj =& new ilObjMediaObject($mob);
1180  $mob_obj->delete();
1181  }
1182 
1183  // #12772 - untie question copies from pool question
1184  $ilDB->manipulate("UPDATE svy_question".
1185  " SET original_id = NULL".
1186  " WHERE original_id = ".$ilDB->quote($question_id, "integer"));
1187  }
1188 
1196  function _getQuestionType($question_id)
1197  {
1198  global $ilDB;
1199 
1200  if ($question_id < 1) return "";
1201 
1202  $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",
1203  array('integer'),
1204  array($question_id)
1205  );
1206  if ($result->numRows() == 1)
1207  {
1208  $data = $ilDB->fetchAssoc($result);
1209  return $data["type_tag"];
1210  }
1211  else
1212  {
1213  return "";
1214  }
1215  }
1216 
1224  function _getTitle($question_id)
1225  {
1226  global $ilDB;
1227 
1228  if ($question_id < 1) return "";
1229 
1230  $result = $ilDB->queryF("SELECT title FROM svy_question WHERE svy_question.question_id = %s",
1231  array('integer'),
1232  array($question_id)
1233  );
1234  if ($result->numRows() == 1)
1235  {
1236  $data = $ilDB->fetchAssoc($result);
1237  return $data["title"];
1238  }
1239  else
1240  {
1241  return "";
1242  }
1243  }
1244 
1252  function _getOriginalId($question_id)
1253  {
1254  global $ilDB;
1255  $result = $ilDB->queryF("SELECT * FROM svy_question WHERE question_id = %s",
1256  array('integer'),
1257  array($question_id)
1258  );
1259  if ($result->numRows() > 0)
1260  {
1261  $row = $ilDB->fetchAssoc($result);
1262  if ($row["original_id"] > 0)
1263  {
1264  return $row["original_id"];
1265  }
1266  else
1267  {
1268  return $row["question_id"];
1269  }
1270  }
1271  else
1272  {
1273  return "";
1274  }
1275  }
1276 
1277  function syncWithOriginal()
1278  {
1279  global $ilDB;
1280 
1281  if ($this->getOriginalId())
1282  {
1283  $id = $this->getId();
1284  $original = $this->getOriginalId();
1285 
1286  $this->setId($this->getOriginalId());
1287  $this->setOriginalId(NULL);
1288  $this->saveToDb();
1289 
1290  $this->setId($id);
1291  $this->setOriginalId($original);
1292 
1293  include_once "./Services/COPage/classes/class.ilInternalLink.php";
1294  $affectedRows = $ilDB->manipulateF("DELETE FROM svy_material WHERE question_fi = %s",
1295  array('integer'),
1296  array($this->getOriginalId())
1297  );
1298  ilInternalLink::_deleteAllLinksOfSource("sqst", $this->original_id);
1299  if (strlen($this->material["internal_link"]))
1300  {
1301  $next_id = $ilDB->nextId('svy_material');
1302  $affectedRows = $ilDB->manipulateF("INSERT INTO svy_material (material_id, question_fi, internal_link, import_id, material_title, tstamp) VALUES (%s, %s, %s, %s, %s, %s)",
1303  array('integer', 'integer', 'text', 'text', 'text', 'integer'),
1304  array($next_id, $this->getOriginalId(), $this->material["internal_link"], $this->material["import_id"], $this->material["title"], time())
1305  );
1306  if (preg_match("/il_(\d*?)_(\w+)_(\d+)/", $this->material["internal_link"], $matches))
1307  {
1308  ilInternalLink::_saveLink("sqst", $this->getOriginalId(), $matches[2], $matches[3], $matches[1]);
1309  }
1310  }
1311  }
1312  }
1313 
1320  function getPhrase($phrase_id)
1321  {
1322  global $ilDB;
1323 
1324  $result = $ilDB->queryF("SELECT title FROM svy_phrase WHERE phrase_id = %s",
1325  array('integer'),
1326  array($phrase_id)
1327  );
1328  if ($row = $ilDB->fetchAssoc($result))
1329  {
1330  return $row["title"];
1331  }
1332  return "";
1333  }
1334 
1342  function phraseExists($title)
1343  {
1344  global $ilUser, $ilDB;
1345 
1346  $result = $ilDB->queryF("SELECT phrase_id FROM svy_phrase WHERE title = %s AND owner_fi = %s",
1347  array('text', 'integer'),
1348  array($title, $ilUser->getId())
1349  );
1350  return ($result->numRows() == 0) ? false : true;
1351  }
1352 
1360  function _questionExists($question_id)
1361  {
1362  global $ilDB;
1363 
1364  if ($question_id < 1)
1365  {
1366  return false;
1367  }
1368 
1369  $result = $ilDB->queryF("SELECT question_id FROM svy_question WHERE question_id = %s",
1370  array('integer'),
1371  array($question_id)
1372  );
1373  return ($result->numRows() == 1) ? true : false;
1374  }
1375 
1376  function addInternalLink($material_id, $title = "")
1377  {
1378  if (strlen($material_id))
1379  {
1380  if (strcmp($material_title, "") == 0)
1381  {
1382  if (preg_match("/il__(\w+)_(\d+)/", $material_id, $matches))
1383  {
1384  $type = $matches[1];
1385  $target_id = $matches[2];
1386  $material_title = $this->lng->txt("obj_$type") . ": ";
1387  switch ($type)
1388  {
1389  case "lm":
1390  include_once("./Modules/LearningModule/classes/class.ilObjContentObjectGUI.php");
1391  $cont_obj_gui =& new ilObjContentObjectGUI("", $target_id, true);
1392  $cont_obj = $cont_obj_gui->object;
1393  $material_title .= $cont_obj->getTitle();
1394  break;
1395  case "pg":
1396  include_once("./Modules/LearningModule/classes/class.ilLMPageObject.php");
1397  include_once("./Modules/LearningModule/classes/class.ilLMObject.php");
1398  $lm_id = ilLMObject::_lookupContObjID($target_id);
1399  include_once("./Modules/LearningModule/classes/class.ilObjContentObjectGUI.php");
1400  $cont_obj_gui =& new ilObjContentObjectGUI("", $lm_id, FALSE);
1401  $cont_obj = $cont_obj_gui->object;
1402  $pg_obj =& new ilLMPageObject($cont_obj, $target_id);
1403  $material_title .= $pg_obj->getTitle();
1404  break;
1405  case "st":
1406  include_once("./Modules/LearningModule/classes/class.ilStructureObject.php");
1407  include_once("./Modules/LearningModule/classes/class.ilLMObject.php");
1408  $lm_id = ilLMObject::_lookupContObjID($target_id);
1409  include_once("./Modules/LearningModule/classes/class.ilObjContentObjectGUI.php");
1410  $cont_obj_gui =& new ilObjContentObjectGUI("", $lm_id, FALSE);
1411  $cont_obj = $cont_obj_gui->object;
1412  $st_obj =& new ilStructureObject($cont_obj, $target_id);
1413  $material_title .= $st_obj->getTitle();
1414  break;
1415  case "git":
1416  include_once "./Modules/Glossary/classes/class.ilGlossaryTerm.php";
1417  $material_title = $this->lng->txt("glossary_term") . ": " . ilGlossaryTerm::_lookGlossaryTerm($target_id);
1418  break;
1419  case "mob":
1420  break;
1421  }
1422  }
1423  }
1424  include_once "./Modules/SurveyQuestionPool/classes/class.ilSurveyMaterial.php";
1425  $mat = new ilSurveyMaterial();
1426  $mat->type = 0;
1427  $mat->internal_link = $material_id;
1428  $mat->title = $material_title;
1429  $this->addMaterial($mat);
1430  $this->saveMaterial();
1431  }
1432  }
1433 
1439  public function deleteMaterials($a_array)
1440  {
1441  foreach ($a_array as $idx)
1442  {
1443  unset($this->material[$idx]);
1444  }
1445  $this->material = array_values($this->material);
1446  $this->saveMaterial();
1447  }
1448 
1455  function duplicateMaterials($question_id)
1456  {
1457  foreach ($this->materials as $filename)
1458  {
1459  $materialspath = $this->getMaterialsPath();
1460  $materialspath_original = preg_replace("/([^\d])$this->id([^\d])/", "\${1}$question_id\${2}", $materialspath);
1461  if (!file_exists($materialspath))
1462  {
1463  include_once "./Services/Utilities/classes/class.ilUtil.php";
1464  ilUtil::makeDirParents($materialspath);
1465  }
1466  if (!copy($materialspath_original . $filename, $materialspath . $filename))
1467  {
1468  print "material could not be duplicated!!!! ";
1469  }
1470  }
1471  }
1472 
1473  public function addMaterial($obj_material)
1474  {
1475  array_push($this->material, $obj_material);
1476  }
1477 
1485  function setMaterial($material_id = "", $is_import = false, $material_title = "")
1486  {
1487  if (strcmp($material_id, "") != 0)
1488  {
1489  $import_id = "";
1490  if ($is_import)
1491  {
1492  $import_id = $material_id;
1493  $material_id = $this->_resolveInternalLink($import_id);
1494  }
1495  if (strcmp($material_title, "") == 0)
1496  {
1497  if (preg_match("/il__(\w+)_(\d+)/", $material_id, $matches))
1498  {
1499  $type = $matches[1];
1500  $target_id = $matches[2];
1501  $material_title = $this->lng->txt("obj_$type") . ": ";
1502  switch ($type)
1503  {
1504  case "lm":
1505  include_once("./Modules/LearningModule/classes/class.ilObjContentObjectGUI.php");
1506  $cont_obj_gui =& new ilObjContentObjectGUI("", $target_id, true);
1507  $cont_obj = $cont_obj_gui->object;
1508  $material_title .= $cont_obj->getTitle();
1509  break;
1510  case "pg":
1511  include_once("./Modules/LearningModule/classes/class.ilLMPageObject.php");
1512  include_once("./Modules/LearningModule/classes/class.ilLMObject.php");
1513  $lm_id = ilLMObject::_lookupContObjID($target_id);
1514  include_once("./Modules/LearningModule/classes/class.ilObjContentObjectGUI.php");
1515  $cont_obj_gui =& new ilObjContentObjectGUI("", $lm_id, FALSE);
1516  $cont_obj = $cont_obj_gui->object;
1517  $pg_obj =& new ilLMPageObject($cont_obj, $target_id);
1518  $material_title .= $pg_obj->getTitle();
1519  break;
1520  case "st":
1521  include_once("./Modules/LearningModule/classes/class.ilStructureObject.php");
1522  include_once("./Modules/LearningModule/classes/class.ilLMObject.php");
1523  $lm_id = ilLMObject::_lookupContObjID($target_id);
1524  include_once("./Modules/LearningModule/classes/class.ilObjContentObjectGUI.php");
1525  $cont_obj_gui =& new ilObjContentObjectGUI("", $lm_id, FALSE);
1526  $cont_obj = $cont_obj_gui->object;
1527  $st_obj =& new ilStructureObject($cont_obj, $target_id);
1528  $material_title .= $st_obj->getTitle();
1529  break;
1530  case "git":
1531  include_once "./Modules/Glossary/classes/class.ilGlossaryTerm.php";
1532  $material_title = $this->lng->txt("glossary_term") . ": " . ilGlossaryTerm::_lookGlossaryTerm($target_id);
1533  break;
1534  case "mob":
1535  break;
1536  }
1537  }
1538  }
1539  $this->material = array(
1540  "internal_link" => $material_id,
1541  "import_id" => $import_id,
1542  "title" => $material_title
1543  );
1544  }
1545  $this->saveMaterial();
1546  }
1547 
1548  function _resolveInternalLink($internal_link)
1549  {
1550  if (preg_match("/il_(\d+)_(\w+)_(\d+)/", $internal_link, $matches))
1551  {
1552  include_once "./Services/COPage/classes/class.ilInternalLink.php";
1553  include_once "./Modules/LearningModule/classes/class.ilLMObject.php";
1554  include_once "./Modules/Glossary/classes/class.ilGlossaryTerm.php";
1555  switch ($matches[2])
1556  {
1557  case "lm":
1558  $resolved_link = ilLMObject::_getIdForImportId($internal_link);
1559  break;
1560  case "pg":
1561  $resolved_link = ilInternalLink::_getIdForImportId("PageObject", $internal_link);
1562  break;
1563  case "st":
1564  $resolved_link = ilInternalLink::_getIdForImportId("StructureObject", $internal_link);
1565  break;
1566  case "git":
1567  $resolved_link = ilInternalLink::_getIdForImportId("GlossaryItem", $internal_link);
1568  break;
1569  case "mob":
1570  $resolved_link = ilInternalLink::_getIdForImportId("MediaObject", $internal_link);
1571  break;
1572  }
1573  if (strcmp($resolved_link, "") == 0)
1574  {
1575  $resolved_link = $internal_link;
1576  }
1577  }
1578  else
1579  {
1580  $resolved_link = $internal_link;
1581  }
1582  return $resolved_link;
1583  }
1584 
1585  function _resolveIntLinks($question_id)
1586  {
1587  global $ilDB;
1588  $resolvedlinks = 0;
1589  $result = $ilDB->queryF("SELECT * FROM svy_material WHERE question_fi = %s",
1590  array('integer'),
1591  array($question_id)
1592  );
1593  if ($result->numRows())
1594  {
1595  while ($row = $ilDB->fetchAssoc($result))
1596  {
1597  $internal_link = $row["internal_link"];
1598  include_once "./Modules/SurveyQuestionPool/classes/class.SurveyQuestion.php";
1599  $resolved_link = SurveyQuestion::_resolveInternalLink($internal_link);
1600  if (strcmp($internal_link, $resolved_link) != 0)
1601  {
1602  // internal link was resolved successfully
1603  $affectedRows = $ilDB->manipulateF("UPDATE svy_material SET internal_link = %s, tstamp = %s WHERE material_id = %s",
1604  array('text', 'integer', 'integer'),
1605  array($resolved_link, time(), $row["material_id"])
1606  );
1607  $resolvedlinks++;
1608  }
1609  }
1610  }
1611  if ($resolvedlinks)
1612  {
1613  // there are resolved links -> reenter theses links to the database
1614 
1615  // delete all internal links from the database
1616  include_once "./Services/COPage/classes/class.ilInternalLink.php";
1617  ilInternalLink::_deleteAllLinksOfSource("sqst", $question_id);
1618 
1619  $result = $ilDB->queryF("SELECT * FROM svy_material WHERE question_fi = %s",
1620  array('integer'),
1621  array($question_id)
1622  );
1623  if ($result->numRows())
1624  {
1625  while ($row = $ilDB->fetchAssoc($result))
1626  {
1627  if (preg_match("/il_(\d*?)_(\w+)_(\d+)/", $row["internal_link"], $matches))
1628  {
1629  ilInternalLink::_saveLink("sqst", $question_id, $matches[2], $matches[3], $matches[1]);
1630  }
1631  }
1632  }
1633  }
1634  }
1635 
1636  function _getInternalLinkHref($target = "")
1637  {
1638  global $ilDB;
1639  $linktypes = array(
1640  "lm" => "LearningModule",
1641  "pg" => "PageObject",
1642  "st" => "StructureObject",
1643  "git" => "GlossaryItem",
1644  "mob" => "MediaObject"
1645  );
1646  $href = "";
1647  if (preg_match("/il__(\w+)_(\d+)/", $target, $matches))
1648  {
1649  $type = $matches[1];
1650  $target_id = $matches[2];
1651  include_once "./Services/Utilities/classes/class.ilUtil.php";
1652  switch($linktypes[$matches[1]])
1653  {
1654  case "LearningModule":
1655  $href = ilUtil::removeTrailingPathSeparators(ILIAS_HTTP_PATH) ."/goto.php?target=" . $type . "_" . $target_id;
1656  break;
1657  case "PageObject":
1658  case "StructureObject":
1659  $href = ilUtil::removeTrailingPathSeparators(ILIAS_HTTP_PATH) ."/goto.php?target=" . $type . "_" . $target_id;
1660  break;
1661  case "GlossaryItem":
1662  $href = ilUtil::removeTrailingPathSeparators(ILIAS_HTTP_PATH) ."/goto.php?target=" . $type . "_" . $target_id;
1663  break;
1664  case "MediaObject":
1665  $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;
1666  break;
1667  }
1668  }
1669  return $href;
1670  }
1671 
1680  function _isWriteable($question_id, $user_id)
1681  {
1682  global $ilDB;
1683 
1684  if (($question_id < 1) || ($user_id < 1))
1685  {
1686  return false;
1687  }
1688 
1689  $result = $ilDB->queryF("SELECT obj_fi FROM svy_question WHERE question_id = %s",
1690  array('integer'),
1691  array($question_id)
1692  );
1693  if ($result->numRows() == 1)
1694  {
1695  $row = $ilDB->fetchAssoc($result);
1696  $qpl_object_id = $row["obj_fi"];
1697  include_once "./Modules/SurveyQuestionPool/classes/class.ilObjSurveyQuestionPool.php";
1698  return ilObjSurveyQuestionPool::_isWriteable($qpl_object_id, $user_id);
1699  }
1700  else
1701  {
1702  return false;
1703  }
1704  }
1705 
1712  function getQuestionTypeID()
1713  {
1714  global $ilDB;
1715  $result = $ilDB->queryF("SELECT questiontype_id FROM svy_qtype WHERE type_tag = %s",
1716  array('text'),
1717  array($this->getQuestionType())
1718  );
1719  if ($result->numRows() == 1)
1720  {
1721  $row = $ilDB->fetchAssoc($result);
1722  return $row["questiontype_id"];
1723  }
1724  else
1725  {
1726  return 0;
1727  }
1728  }
1729 
1736  function getQuestionType()
1737  {
1738  return "";
1739  }
1740 
1748  static function _includeClass($question_type, $gui = 0)
1749  {
1750  $type = $question_type;
1751  if ($gui) $type .= "GUI";
1752  if (file_exists("./Modules/SurveyQuestionPool/classes/class.".$type.".php"))
1753  {
1754  include_once "./Modules/SurveyQuestionPool/classes/class.".$type.".php";
1755  return true;
1756  }
1757  else
1758  {
1759  global $ilPluginAdmin;
1760  $pl_names = $ilPluginAdmin->getActivePluginsForSlot(IL_COMP_MODULE, "SurveyQuestionPool", "svyq");
1761  foreach ($pl_names as $pl_name)
1762  {
1763  $pl = ilPlugin::getPluginObject(IL_COMP_MODULE, "SurveyQuestionPool", "svyq", $pl_name);
1764  if (strcmp($pl->getQuestionType(), $question_type) == 0)
1765  {
1766  $pl->includeClass("class.".$type.".php");
1767  return true;
1768  }
1769  }
1770  }
1771  return false;
1772  }
1773 
1780  static function _getQuestionTypeName($type_tag)
1781  {
1782  if (file_exists("./Modules/SurveyQuestionPool/classes/class.".$type_tag.".php"))
1783  {
1784  global $lng;
1785  return $lng->txt($type_tag);
1786  }
1787  else
1788  {
1789  global $ilPluginAdmin;
1790  $pl_names = $ilPluginAdmin->getActivePluginsForSlot(IL_COMP_MODULE, "SurveyQuestionPool", "svyq");
1791  foreach ($pl_names as $pl_name)
1792  {
1793  $pl = ilPlugin::getPluginObject(IL_COMP_MODULE, "SurveyQuestionPool", "svyq", $pl_name);
1794  if (strcmp($pl->getQuestionType(), $type_tag) == 0)
1795  {
1796  return $pl->getQuestionTypeTranslation();
1797  }
1798  }
1799  }
1800  return "";
1801  }
1802 
1803 
1811  function &_instanciateQuestion($question_id)
1812  {
1813  $question_type = SurveyQuestion::_getQuestionType($question_id);
1814  SurveyQuestion::_includeClass($question_type);
1815  $question = new $question_type();
1816  $question->loadFromDb($question_id);
1817  return $question;
1818  }
1819 
1827  function &_instanciateQuestionGUI($question_id)
1828  {
1829  $question_type = SurveyQuestion::_getQuestionType($question_id);
1830  SurveyQuestion::_includeClass($question_type, 1);
1831  $guitype = $question_type . "GUI";
1832  $question = new $guitype($question_id);
1833  return $question;
1834  }
1835 
1844  function isHTML($a_text)
1845  {
1846  if (preg_match("/<[^>]*?>/", $a_text))
1847  {
1848  return TRUE;
1849  }
1850  else
1851  {
1852  return FALSE;
1853  }
1854  }
1855 
1863  function QTIMaterialToString($a_material)
1864  {
1865  $result = "";
1866  for ($i = 0; $i < $a_material->getMaterialCount(); $i++)
1867  {
1868  $material = $a_material->getMaterial($i);
1869  if (strcmp($material["type"], "mattext") == 0)
1870  {
1871  $result .= $material["material"]->getContent();
1872  }
1873  if (strcmp($material["type"], "matimage") == 0)
1874  {
1875  $matimage = $material["material"];
1876  if (preg_match("/(il_([0-9]+)_mob_([0-9]+))/", $matimage->getLabel(), $matches))
1877  {
1878  // import an mediaobject which was inserted using tiny mce
1879  if (!is_array($_SESSION["import_mob_xhtml"])) $_SESSION["import_mob_xhtml"] = array();
1880  array_push($_SESSION["import_mob_xhtml"], array("mob" => $matimage->getLabel(), "uri" => $matimage->getUri()));
1881  }
1882  }
1883  }
1884  return $result;
1885  }
1886 
1895  function addMaterialTag(&$a_xml_writer, $a_material, $close_material_tag = TRUE, $add_mobs = TRUE, $a_attrs = null)
1896  {
1897  include_once "./Services/RTE/classes/class.ilRTE.php";
1898  include_once("./Services/MediaObjects/classes/class.ilObjMediaObject.php");
1899 
1900  $a_xml_writer->xmlStartTag("material");
1901  $attrs = array(
1902  "type" => "text/plain"
1903  );
1904  if ($this->isHTML($a_material))
1905  {
1906  $attrs["type"] = "text/xhtml";
1907  }
1908  if (is_array($a_attrs))
1909  {
1910  $attrs = array_merge($attrs, $a_attrs);
1911  }
1912  $a_xml_writer->xmlElement("mattext", $attrs, ilRTE::_replaceMediaObjectImageSrc($a_material, 0));
1913 
1914  if ($add_mobs)
1915  {
1916  $mobs = ilObjMediaObject::_getMobsOfObject("spl:html", $this->getId());
1917  foreach ($mobs as $mob)
1918  {
1919  $mob_obj =& new ilObjMediaObject($mob);
1920  $imgattrs = array(
1921  "label" => "il_" . IL_INST_ID . "_mob_" . $mob,
1922  "uri" => "objects/" . "il_" . IL_INST_ID . "_mob_" . $mob . "/" . $mob_obj->getTitle()
1923  );
1924  $a_xml_writer->xmlElement("matimage", $imgattrs, NULL);
1925  }
1926  }
1927  if ($close_material_tag) $a_xml_writer->xmlEndTag("material");
1928  }
1929 
1936  function prepareTextareaOutput($txt_output, $prepare_for_latex_output = FALSE)
1937  {
1938  include_once "./Services/Utilities/classes/class.ilUtil.php";
1939  return ilUtil::prepareTextareaOutput($txt_output, $prepare_for_latex_output);
1940  }
1941 
1949  function _getQuestionDataArray($id)
1950  {
1951  return array();
1952  }
1953 
1960  function addUserSpecificResultsExportTitles(&$a_array, $a_export_label = "")
1961  {
1962  // get title by label option
1963  switch($a_export_label)
1964  {
1965  case "label_only":
1966  array_push($a_array, $this->label ? $this->label : $this->title);
1967  break;
1968 
1969  case "title_only":
1970  array_push($a_array, $this->title);
1971  break;
1972 
1973  default:
1974  array_push($a_array, $this->label ? $this->title.' - '.$this->label : $this->title);
1975  break;
1976  }
1977  }
1978 
1986  function addUserSpecificResultsData(&$a_array, &$resultset)
1987  {
1988  // overwrite in inherited classes
1989  }
1990 
1998  function &getUserAnswers($survey_id)
1999  {
2000  // overwrite in inherited classes
2001  return array();
2002  }
2003 
2010  function &getWorkingDataFromUserInput($post_data)
2011  {
2012  // overwrite in inherited classes
2013  $data = array();
2014  return $data;
2015  }
2016 
2025  function importAdditionalMetadata($a_meta)
2026  {
2027  // overwrite in inherited classes
2028  }
2029 
2036  function importResponses($a_data)
2037  {
2038  // overwrite in inherited classes
2039  }
2040 
2047  function importAdjectives($a_data)
2048  {
2049  // overwrite in inherited classes
2050  }
2051 
2058  function importMatrix($a_data)
2059  {
2060  // overwrite in inherited classes
2061  }
2062 
2074  function setExportCumulatedXLS(&$worksheet, &$format_title, &$format_bold, &$eval_data, $row, $export_label)
2075  {
2076  include_once ("./Services/Excel/classes/class.ilExcelUtils.php");
2077  $column = 0;
2078  switch ($export_label)
2079  {
2080  case 'label_only':
2081  $worksheet->writeString($row, $column, ilExcelUtils::_convert_text($this->label));
2082  break;
2083  case 'title_only':
2084  $worksheet->writeString($row, $column, ilExcelUtils::_convert_text($this->getTitle()));
2085  break;
2086  default:
2087  $worksheet->writeString($row, $column, ilExcelUtils::_convert_text($this->getTitle()));
2088  $column++;
2089  $worksheet->writeString($row, $column, ilExcelUtils::_convert_text($this->label));
2090  break;
2091  }
2092  $column++;
2093  $worksheet->writeString($row, $column, ilExcelUtils::_convert_text($this->getQuestiontext()));
2094  $column++;
2095  $worksheet->writeString($row, $column, ilExcelUtils::_convert_text($this->lng->txt($eval_data["QUESTION_TYPE"])));
2096  $column++;
2097  $worksheet->write($row, $column, $eval_data["USERS_ANSWERED"]);
2098  $column++;
2099  $worksheet->write($row, $column, $eval_data["USERS_SKIPPED"]);
2100  $column++;
2101  $worksheet->write($row, $column, ilExcelUtils::_convert_text($eval_data["MODE_VALUE"]));
2102  $column++;
2103  $worksheet->write($row, $column, ilExcelUtils::_convert_text($eval_data["MODE"]));
2104  $column++;
2105  $worksheet->write($row, $column, $eval_data["MODE_NR_OF_SELECTIONS"]);
2106  $column++;
2107  $worksheet->write($row, $column, ilExcelUtils::_convert_text(str_replace("<br />", " ", $eval_data["MEDIAN"])));
2108  $column++;
2109  $worksheet->write($row, $column, $eval_data["ARITHMETIC_MEAN"]);
2110  return $row + 1;
2111  }
2112 
2124  function &setExportCumulatedCVS(&$eval_data, $export_label)
2125  {
2126  $csvrow = array();
2127  switch ($export_label)
2128  {
2129  case 'label_only':
2130  array_push($csvrow, $this->label);
2131  break;
2132  case 'title_only':
2133  array_push($csvrow, $this->getTitle());
2134  break;
2135  default:
2136  array_push($csvrow, $this->getTitle());
2137  array_push($csvrow, $this->label);
2138  break;
2139  }
2140  array_push($csvrow, $this->getQuestiontext());
2141  array_push($csvrow, $this->lng->txt($eval_data["QUESTION_TYPE"]));
2142  array_push($csvrow, $eval_data["USERS_ANSWERED"]);
2143  array_push($csvrow, $eval_data["USERS_SKIPPED"]);
2144  array_push($csvrow, $eval_data["MODE"]);
2145  array_push($csvrow, $eval_data["MODE_NR_OF_SELECTIONS"]);
2146  array_push($csvrow, $eval_data["MEDIAN"]);
2147  array_push($csvrow, $eval_data["ARITHMETIC_MEAN"]);
2148  $result = array();
2149  array_push($result, $csvrow);
2150  return $result;
2151  }
2152 
2162  function setExportDetailsXLS(&$workbook, &$format_title, &$format_bold, &$eval_data, $export_label)
2163  {
2164  // overwrite in inherited classes
2165  }
2166 
2173  function usableForPrecondition()
2174  {
2175  // overwrite in inherited classes
2176  return FALSE;
2177  }
2178 
2185  function getAvailableRelations()
2186  {
2187  // overwrite in inherited classes
2188  return array();
2189  }
2190 
2196  public function getPreconditionOptions()
2197  {
2198  // overwrite in inherited classes
2199  }
2200 
2208  function getPreconditionValueOutput($value)
2209  {
2210  // overwrite in inherited classes
2211  return $value;
2212  }
2213 
2220  public function getPreconditionSelectValue($default = "", $title, $variable)
2221  {
2222  // overwrite in inherited classes
2223  return null;
2224  }
2225 
2234  function outChart($survey_id, $type = "")
2235  {
2236  // overwrite in inherited classes
2237  }
2238 
2239  function setOriginalId($original_id)
2240  {
2241  $this->original_id = $original_id;
2242  }
2243 
2244  function getOriginalId()
2245  {
2246  return $this->original_id;
2247  }
2248 
2254  public function saveRandomData($active_id)
2255  {
2256  // do nothing, overwrite in parent classes
2257  }
2258 
2259  public function getMaterial()
2260  {
2261  return $this->material;
2262  }
2263 
2264  public function setSubtype($a_subtype)
2265  {
2266  // do nothing
2267  }
2268 
2269  public function getSubtype()
2270  {
2271  // do nothing
2272  return null;
2273  }
2274 
2275  protected function &calculateCumulatedResults($survey_id)
2276  {
2277  if (count($this->cumulated) == 0)
2278  {
2279  include_once "./Modules/Survey/classes/class.ilObjSurvey.php";
2280  $nr_of_users = ilObjSurvey::_getNrOfParticipants($survey_id);
2281  $this->cumulated =& $this->getCumulatedResults($survey_id, $nr_of_users);
2282  }
2283  return $this->cumulated;
2284  }
2285 
2291  public function getCumulatedResultData($survey_id, $counter)
2292  {
2293  $cumulated =& $this->calculateCumulatedResults($survey_id);
2294  $questiontext = preg_replace("/<[^>]+?>/ims", "", $this->getQuestiontext());
2295 
2296  $maxlen = 75;
2297  include_once "./Services/Utilities/classes/class.ilStr.php";
2298  if (ilStr::strlen($questiontext) > $maxlen + 3)
2299  {
2300  $questiontext = ilStr::substr($questiontext, 0, $maxlen) . "...";
2301  }
2302 
2303  $result = array(
2304  'counter' => $counter,
2305  'title' => $this->getTitle(),
2306  'question' => $questiontext,
2307  'users_answered' => $cumulated['USERS_ANSWERED'],
2308  'users_skipped' => $cumulated['USERS_SKIPPED'],
2309  'question_type' => $this->lng->txt($cumulated["QUESTION_TYPE"]),
2310  'mode' => $cumulated["MODE"],
2311  'mode_nr_of_selections' => $cumulated["MODE_NR_OF_SELECTIONS"],
2312  'median' => $cumulated["MEDIAN"],
2313  'arithmetic_mean' => $cumulated["ARITHMETIC_MEAN"]
2314  );
2315  return $result;
2316  }
2317 
2321  public function __get($value)
2322  {
2323  switch ($value)
2324  {
2325  default:
2326  if (array_key_exists($value, $this->arrData))
2327  {
2328  return $this->arrData[$value];
2329  }
2330  else
2331  {
2332  return null;
2333  }
2334  break;
2335  }
2336  }
2337 
2341  public function __set($key, $value)
2342  {
2343  switch ($key)
2344  {
2345  default:
2346  $this->arrData[$key] = $value;
2347  break;
2348  }
2349  }
2350 
2358  public static function _changeOriginalId($a_question_id, $a_original_id, $a_object_id)
2359  {
2360  global $ilDB;
2361 
2362  $ilDB->manipulate("UPDATE svy_question".
2363  " SET original_id = ".$ilDB->quote($a_original_id, "integer").",".
2364  " obj_fi = ".$ilDB->quote($a_object_id, "integer").
2365  " WHERE question_id = ".$ilDB->quote($a_question_id, "integer"));
2366  }
2367 
2368  public function getCopyIds($a_group_by_survey = false)
2369  {
2370  global $ilDB;
2371 
2372  $set = $ilDB->query("SELECT q.question_id,s.obj_fi".
2373  " FROM svy_question q".
2374  " JOIN svy_svy_qst sq ON (sq.question_fi = q.question_id)".
2375  " JOIN svy_svy s ON (s.survey_id = sq.survey_fi)".
2376  " WHERE original_id = ".$ilDB->quote($this->getId(), "integer"));
2377  $res = array();
2378  while($row = $ilDB->fetchAssoc($set))
2379  {
2380  if(!$a_group_by_survey)
2381  {
2382  $res[] = $row["question_id"];
2383  }
2384  else
2385  {
2386  $res[$row["obj_fi"]][] = $row["question_id"];
2387  }
2388  }
2389  return $res;
2390  }
2391 
2392  public function hasCopies()
2393  {
2394  return (bool)sizeof($this->getCopyIds());
2395  }
2396 }
2397 ?>