37 $this->db =
$DIC->database();
38 $this->
user = $DIC->user();
39 $this->lng =
$DIC->language();
58 "SELECT svy_category.* FROM svy_category, svy_phrase_cat WHERE svy_phrase_cat.category_fi = svy_category.category_id AND svy_phrase_cat.phrase_fi = %s ORDER BY svy_phrase_cat.sequence",
63 if (($row[
"defaultvalue"] == 1) and ($row[
"owner_fi"] == 0)) {
64 $categories[$row[
"category_id"]] = $this->lng->txt($row[
"title"]);
84 "SELECT svy_category.* FROM svy_category, svy_phrase_cat WHERE svy_phrase_cat.category_fi = svy_category.category_id AND svy_phrase_cat.phrase_fi = %s AND (svy_category.owner_fi = 0 OR svy_category.owner_fi = %s) ORDER BY svy_phrase_cat.sequence",
85 array(
'integer',
'integer'),
86 array($phrase_id,
$ilUser->getId())
89 $neutral = $row[
"neutral"];
90 if (($row[
"defaultvalue"] == 1) and ($row[
"owner_fi"] == 0)) {
91 $this->categories->addCategory($this->lng->txt($row[
"title"]), 0, $neutral);
93 $this->categories->addCategory($row[
"title"], 0, $neutral);
140 $this->label =
$data[
'label'];
151 $this->categories->flushCategories();
153 "SELECT svy_variable.*, svy_category.title, svy_category.neutral FROM svy_variable, svy_category WHERE svy_variable.question_fi = %s AND svy_variable.category_fi = svy_category.category_id ORDER BY sequence ASC",
159 $this->categories->addCategory(
$data[
"title"],
$data[
"other"],
$data[
"neutral"],
null, (
$data[
'scale']) ?
$data[
'scale'] : (
$data[
'sequence'] + 1));
163 parent::loadFromDb(
$id);
178 $this->categories->getCategoryCount()
195 $affectedRows = parent::saveToDb($original_id);
196 if ($affectedRows == 1) {
197 $this->log->debug(
"Before save Category-> DELETE from svy_qst_sc WHERE question_fi = " . $this->
getId() .
" AND INSERT again the same id and orientation in svy_qst_sc");
198 $affectedRows =
$ilDB->manipulateF(
201 array($this->
getId())
203 $affectedRows =
$ilDB->manipulateF(
205 array(
'integer',
'text'),
221 $this->log->debug(
"DELETE from svy_variable before the INSERT into svy_variable. if scale > 0 we get scale value else we get null");
223 $affectedRows =
$ilDB->manipulateF(
224 "DELETE FROM svy_variable WHERE question_fi = %s",
226 array($this->
getId())
229 for (
$i = 0;
$i < $this->categories->getCategoryCount();
$i++) {
230 $cat = $this->categories->getCategory(
$i);
232 $next_id =
$ilDB->nextId(
'svy_variable');
233 $affectedRows =
$ilDB->manipulateF(
234 "INSERT INTO svy_variable (variable_id, category_fi, question_fi, value1, other, sequence, scale, tstamp) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
235 array(
'integer',
'integer',
'integer',
'float',
'integer',
'integer',
'integer',
'integer'),
236 array($next_id, $category_id, $this->
getId(), (
$i + 1), $cat->other,
$i, ($cat->scale > 0) ? $cat->scale :
null, time())
239 $debug_scale = ($cat->scale > 0) ? $cat->scale :
null;
240 $this->log->debug(
"INSERT INTO svy_variable category_fi= " . $category_id .
" question_fi= " . $this->getId() .
" value1= " . (
$i + 1) .
" other= " . $cat->other .
" sequence= " .
$i .
" scale =" . $debug_scale);
251 public function toXML($a_include_header =
true, $obligatory_state =
"")
255 $this->
insertXML($a_xml_writer, $a_include_header, $obligatory_state);
256 $xml = $a_xml_writer->xmlDumpMem(
false);
257 if (!$a_include_header) {
258 $pos = strpos(
$xml,
"?>");
271 public function insertXML(&$a_xml_writer, $a_include_header =
true)
274 "id" => $this->
getId(),
276 "type" => $this->getQuestiontype(),
279 $a_xml_writer->xmlStartTag(
"question", $attrs);
281 $a_xml_writer->xmlElement(
"description",
null, $this->
getDescription());
282 $a_xml_writer->xmlElement(
"author",
null, $this->
getAuthor());
283 if (strlen($this->label)) {
285 "label" => $this->label,
290 $a_xml_writer->xmlStartTag(
"questiontext", $attrs);
292 $a_xml_writer->xmlEndTag(
"questiontext");
294 $a_xml_writer->xmlStartTag(
"responses");
296 for (
$i = 0;
$i < $this->categories->getCategoryCount();
$i++) {
300 if (strlen($this->categories->getCategory(
$i)->other)) {
301 $attrs[
'other'] = $this->categories->getCategory(
$i)->other;
303 if (strlen($this->categories->getCategory(
$i)->neutral)) {
304 $attrs[
'neutral'] = $this->categories->getCategory(
$i)->neutral;
306 if (strlen($this->categories->getCategory(
$i)->label)) {
307 $attrs[
'label'] = $this->categories->getCategory(
$i)->label;
309 if (strlen($this->categories->getCategory(
$i)->scale)) {
310 $attrs[
'scale'] = $this->categories->getCategory(
$i)->scale;
312 $a_xml_writer->xmlStartTag(
"response_single", $attrs);
313 $this->
addMaterialTag($a_xml_writer, $this->categories->getCategory(
$i)->title);
314 $a_xml_writer->xmlEndTag(
"response_single");
317 $a_xml_writer->xmlEndTag(
"responses");
319 if (count($this->material)) {
320 if (preg_match(
"/il_(\d*?)_(\w+)_(\d+)/", $this->material[
"internal_link"], $matches)) {
322 "label" => $this->material[
"title"]
324 $a_xml_writer->xmlStartTag(
"material", $attrs);
325 $intlink =
"il_" .
IL_INST_ID .
"_" . $matches[2] .
"_" . $matches[3];
326 if (strcmp($matches[1],
"") != 0) {
327 $intlink = $this->material[
"internal_link"];
329 $a_xml_writer->xmlElement(
"mattext",
null, $intlink);
330 $a_xml_writer->xmlEndTag(
"material");
334 $a_xml_writer->xmlStartTag(
"metadata");
335 $a_xml_writer->xmlStartTag(
"metadatafield");
336 $a_xml_writer->xmlElement(
"fieldlabel",
null,
"orientation");
337 $a_xml_writer->xmlElement(
"fieldentry",
null, $this->
getOrientation());
338 $a_xml_writer->xmlEndTag(
"metadatafield");
339 $a_xml_writer->xmlEndTag(
"metadata");
341 $a_xml_writer->xmlEndTag(
"question");
354 foreach ($a_meta as $key => $value) {
355 switch ($value[
"label"]) {
372 for (
$i = $lower_limit;
$i <= $upper_limit;
$i++) {
373 $this->categories->addCategory(
$i);
389 $next_id =
$ilDB->nextId(
'svy_phrase');
390 $affectedRows =
$ilDB->manipulateF(
391 "INSERT INTO svy_phrase (phrase_id, title, defaultvalue, owner_fi, tstamp) VALUES (%s, %s, %s, %s, %s)",
392 array(
'integer',
'text',
'text',
'integer',
'integer'),
395 $phrase_id = $next_id;
399 $next_id =
$ilDB->nextId(
'svy_category');
400 $affectedRows =
$ilDB->manipulateF(
401 "INSERT INTO svy_category (category_id, title, defaultvalue, owner_fi, tstamp, neutral) VALUES (%s, %s, %s, %s, %s, %s)",
402 array(
'integer',
'text',
'text',
'integer',
'integer',
'text'),
405 $category_id = $next_id;
406 $next_id =
$ilDB->nextId(
'svy_phrase_cat');
407 $affectedRows =
$ilDB->manipulateF(
408 "INSERT INTO svy_phrase_cat (phrase_category_id, phrase_fi, category_fi, sequence, other, scale) VALUES (%s, %s, %s, %s, %s, %s)",
409 array(
'integer',
'integer',
'integer',
'integer',
'integer',
'integer'),
410 array($next_id, $phrase_id, $category_id, $counter, (
$data[
'other']) ? 1 : 0,
$data[
'scale'])
424 return "SurveySingleChoiceQuestion";
446 $entered_value = $post_data[$this->
getId() .
"_value"];
448 if (strlen($entered_value)) {
449 array_push(
$data, array(
"value" => $entered_value,
"textanswer" => $post_data[$this->
getId() .
'_' . $entered_value .
'_other']));
451 for (
$i = 0;
$i < $this->categories->getCategoryCount();
$i++) {
452 $cat = $this->categories->getCategory(
$i);
454 if (
$i != $entered_value) {
455 if (strlen($post_data[$this->
getId() .
"_" .
$i .
"_other"])) {
456 array_push(
$data, array(
"value" =>
$i,
"textanswer" => $post_data[$this->
getId() .
'_' .
$i .
'_other'],
"uncheck" =>
true));
475 $entered_value = $post_data[$this->
getId() .
"_value"];
477 $this->log->debug(
"Entered value = " . $entered_value);
483 if (strlen($entered_value) == 0) {
484 return $this->lng->txt(
"question_not_checked");
487 for (
$i = 0;
$i < $this->categories->getCategoryCount();
$i++) {
488 $cat = $this->categories->getCategory(
$i);
490 if (
$i == $entered_value) {
491 if (array_key_exists($this->
getId() .
"_" . $entered_value .
"_other", $post_data) && !strlen($post_data[$this->
getId() .
"_" . $entered_value .
"_other"])) {
492 return $this->lng->txt(
"question_mr_no_other_answer");
495 if (strlen($post_data[$this->
getId() .
"_" .
$i .
"_other"])) {
496 return $this->lng->txt(
"question_sr_no_other_answer_checked");
509 $entered_value = $post_data[$this->
getId() .
"_value"];
512 return array(array(
"value" => $entered_value,
513 "textanswer" => $post_data[$this->
getId() .
"_" . $entered_value .
"_other"]));
515 if (strlen($entered_value) == 0) {
519 $next_id =
$ilDB->nextId(
'svy_answer');
522 $fields[
'answer_id'] = array(
"integer", $next_id);
523 $fields[
'question_fi'] = array(
"integer", $this->
getId());
524 $fields[
'active_fi'] = array(
"integer", $active_id);
525 $fields[
'value'] = array(
"float", (strlen($entered_value)) ? $entered_value :
null);
526 $fields[
'textanswer'] = array(
"clob", ($post_data[$this->
getId() .
"_" . $entered_value .
"_other"]) ?
528 $fields[
'tstamp'] = array(
"integer", time());
530 $affectedRows =
$ilDB->insert(
"svy_answer", $fields);
532 $debug_value = (strlen($entered_value)) ? $entered_value :
"NULL";
533 $debug_answer = ($post_data[$this->
getId() .
"_" . $entered_value .
"_other"]) ? $post_data[$this->
getId() .
"_" . $entered_value .
"_other"] :
"NULL";
534 $this->log->debug(
"INSERT svy_answer answer_id=" . $next_id .
" question_fi=" . $this->
getId() .
" active_fi=" . $active_id .
" value=" . $debug_value .
" textanswer=" . $debug_answer);
550 $this->categories->addCategory(
553 strlen(
$data[
'neutral']) ?
$data[
'neutral'] : 0,
554 strlen(
$data[
'label']) ?
$data[
'label'] :
null,
555 strlen(
$data[
'scale']) ?
$data[
'scale'] :
null
579 return array(
"<",
"<=",
"=",
"<>",
">=",
">");
592 for (
$i = 0;
$i < $this->categories->getCategoryCount();
$i++) {
593 $category = $this->categories->getCategory(
$i);
594 $options[$category->scale - 1] = $category->scale .
" - " . $category->title;
609 $step3->setOptions($options);
610 $step3->setValue($default);
624 $category = $this->categories->getCategoryForScale($value + 1);
627 return $category->scale .
629 ((strlen($category->title)) ? $category->title : $this->lng->txt(
'other_answer'));
647 "SELECT SUM(max_sum_score) sum_sum_score FROM (SELECT MAX(scale) max_sum_score FROM svy_svy_qst sq " .
648 "JOIN svy_question q ON (sq.question_fi = q.question_id) " .
649 "JOIN svy_variable v ON (v.question_fi = q.question_id) " .
650 "WHERE sq.survey_fi = %s AND q.questiontype_fi = %s " .
651 "GROUP BY (q.question_id)) x",
652 [
"integer",
"integer"],
655 $rec =
$db->fetchAssoc($set);
656 return (
int) $rec[
"sum_sum_score"];
664 if ($nr_answer_records == 1) {
674 if ($q1->getOrientation() != 1 || $q2->getOrientation() != 1) {
677 if (self::getCompressCompareString($q1) == self::getCompressCompareString($q2)) {
686 for (
$i = 0;
$i < $q->categories->getCategoryCount();
$i++) {
687 $cat = $q->categories->getCategory(
$i);
688 $str .=
":" . $cat->scale .
":" . $cat->title;
An exception for terminatinating execution or to throw for unit testing.
Basic class for all survey question types.
setQuestiontext($questiontext="")
Sets the questiontext of the SurveyQuestion object.
setId($id=-1)
Sets the id of the SurveyQuestion object.
setAuthor($author="")
Sets the authors name of the SurveyQuestion object.
static _instanciateQuestion($question_id)
Creates an instance of a question with a given question id.
stripSlashesAddSpaceFallback($a_str)
Strip slashes with add space fallback, see https://mantis.ilias.de/view.php?id=19727 and https://mant...
getDescription()
Gets the description string of the SurveyQuestion object.
getId()
Gets the id of the SurveyQuestion object.
setDescription($description="")
Sets the description string of the SurveyQuestion object.
setObjId($obj_id=0)
Set the reference id of the container object.
getAuthor()
Gets the authors name of the SurveyQuestion object.
setOriginalId($original_id)
getQuestiontext()
Gets the questiontext of the SurveyQuestion object.
getObligatory($survey_id="")
Gets the obligatory state of the question.
setOrientation($orientation=0)
Sets the orientation of the question output.
saveCategoryToDb($categorytext, $neutral=0)
Saves a category to the database.
getTitle()
Gets the title string of the SurveyQuestion object.
setComplete($a_complete)
Sets the complete state of the question.
saveMaterial()
save material to db
setOwner($owner="")
Sets the creator/owner ID of the SurveyQuestion object.
setTitle($title="")
Sets the title string of the SurveyQuestion object.
saveCompletionStatus($original_id="")
Saves the complete flag to the database.
getOrientation()
Gets the orientation of the question output.
addMaterialTag(&$a_xml_writer, $a_material, $close_material_tag=true, $add_mobs=true, $a_attrs=null)
Creates an XML material tag from a plain text or xhtml text.
setObligatory($obligatory=1)
Sets the obligatory state of the question.
SingleChoice survey question.
static compressable($id1, $id2)
getPreconditionOptions()
Returns the options for preconditions.
getQuestionType()
Returns the question type of the question.
addPhrase($phrase_id)
Adds a phrase to the question.
__construct($title="", $description="", $author="", $questiontext="", $owner=-1, $orientation=1)
SurveySingleChoiceQuestion constructor.
isSumScoreValid(int $nr_answer_records)
@inheritDoc
isComplete()
Returns true if the question is complete for use.
savePhrase($title)
Saves a set of categories to a default phrase.
importAdditionalMetadata($a_meta)
Import additional meta data from the question import file.
checkUserInput($post_data, $survey_id)
Checks the input of the active user for obligatory status and entered values.
static getCompressCompareString($q)
saveUserInput($post_data, $active_id, $a_return=false)
importResponses($a_data)
Import response data from the question import file.
saveToDb($original_id="")
Saves a SurveySingleChoiceQuestion object to a database.
usableForPrecondition()
Returns if the question is usable for preconditions.
getAdditionalTableName()
Returns the name of the additional question data table in the database.
getPreconditionSelectValue($default="", $title, $variable)
Creates a form property for the precondition value.
& getWorkingDataFromUserInput($post_data)
Creates the user data of the svy_answer table from the POST data.
insertXML(&$a_xml_writer, $a_include_header=true)
Adds the question XML to a given XMLWriter object.
getAvailableRelations()
Returns the available relations for the question.
addStandardNumbers($lower_limit, $upper_limit)
Adds standard numbers as categories.
& getCategoriesForPhrase($phrase_id)
Gets the available categories for a given phrase.
toXML($a_include_header=true, $obligatory_state="")
Returns an xml representation of the question.
getQuestionDataArray($id)
Returns the question data fields from the database.
static getMaxSumScore(int $survey_id)
@inheritDoc
loadFromDb($id)
Loads a SurveySingleChoiceQuestion object from the database.
getPreconditionValueOutput($value)
Returns the output for a precondition value.
static _replaceMediaObjectImageSrc($a_text, $a_direction=0, $nic=IL_INST_ID)
Replaces image source from mob image urls with the mob id or replaces mob id with the correct image s...
xmlHeader()
Writes xml header @access public.
__construct(Container $dic, ilPlugin $plugin)
@inheritDoc