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'));
 
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.
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.
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.
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.
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.
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