Public Member Functions | Data Fields

SurveyMetricQuestion Class Reference

Metric survey question. More...

Inheritance diagram for SurveyMetricQuestion:
Collaboration diagram for SurveyMetricQuestion:

Public Member Functions

 SurveyMetricQuestion ($title="", $description="", $author="", $questiontext="", $owner=-1, $subtype=SUBTYPE_NON_RATIO)
 SurveyMetricQuestion constructor.
 setSubtype ($subtype=SUBTYPE_NON_RATIO)
 Sets the question subtype.
 setMinimum ($minimum=0)
 Sets the minimum value.
 setMaximum ($maximum="")
 Sets the maximum value.
 getSubtype ()
 Gets the question subtype.
 getMinimum ()
 Returns the minimum value of the question.
 getMaximum ()
 Returns the maximum value of the question.
 _getQuestionDataArray ($id)
 Returns the question data fields from the database.
 loadFromDb ($id)
 Loads a SurveyMetricQuestion object from the database.
 isComplete ()
 Returns true if the question is complete for use.
 saveToDb ($original_id="")
 Saves a SurveyMetricQuestion object to a database.
 from_xml ($xml_text)
 Imports a question from XML.
 to_xml ($a_include_header=true, $obligatory_state="")
 Returns a QTI xml representation of the question.
 syncWithOriginal ()
 getQuestionType ()
 Returns the question type of the question.
 getAdditionalTableName ()
 Returns the name of the additional question data table in the database.
 checkUserInput ($post_data)
 saveUserInput ($post_data, $survey_id, $user_id, $anonymous_id)
getCumulatedResults ($survey_id, $nr_of_users)

Data Fields

 $subtype
 $minimum
 $maximum

Detailed Description

Metric survey question.

The SurveyMetricQuestion class defines and encapsulates basic methods and attributes for metric survey question types.

Author:
Helmut Schottmüller <helmut.schottmueller@mac.com>
Version:
Id:
class.SurveyMetricQuestion.php 13736 2007-04-27 14:01:51Z hschottm

class.SurveyMetricQuestion.php Survey

Definition at line 42 of file class.SurveyMetricQuestion.php.


Member Function Documentation

SurveyMetricQuestion::_getQuestionDataArray ( id  ) 

Returns the question data fields from the database.

Returns the question data fields from the database

Parameters:
integer $id The question ID from the database
Returns:
array Array containing the question fields and data from the database public

Reimplemented from SurveyQuestion.

Definition at line 195 of file class.SurveyMetricQuestion.php.

References SurveyQuestion::$id, $query, and $result.

        {
                global $ilDB;
                
    $query = sprintf("SELECT survey_question.*, survey_question_metric.* FROM survey_question, survey_question_metric WHERE survey_question.question_id = %s AND survey_question.question_id = survey_question_metric.question_fi",
      $ilDB->quote($id)
    );
    $result = $ilDB->query($query);
                if ($result->numRows() == 1)
                {
                        return $result->fetchRow(DB_FETCHMODE_ASSOC);
                }
                else
                {
                        return array();
                }
        }

SurveyMetricQuestion::checkUserInput ( post_data  ) 

Definition at line 732 of file class.SurveyMetricQuestion.php.

References SurveyQuestion::getId(), getMaximum(), getMinimum(), and SurveyQuestion::getObligatory().

        {
                $entered_value = $post_data[$this->getId() . "_metric_question"];
                // replace german notation with international notation
                $entered_value = str_replace(",", ".", $entered_value);
                
                if ((!$this->getObligatory()) && (strlen($entered_value) == 0)) return "";
                
                if (strlen($entered_value) == 0) return $this->lng->txt("survey_question_obligatory");
                
                if (strlen($this->getMinimum()))
                {
                        if ($entered_value < $this->getMinimum())
                        {
                                return $this->lng->txt("metric_question_out_of_bounds");
                        }
                }

                if (strlen($this->getMaximum()))
                {
                        if (($this->getMaximum() == 1) && ($this->getMaximum() < $this->getMinimum()))
                        {
                                // old &infty; values as maximum
                        }
                        else
                        {
                                if ($entered_value > $this->getMaximum())
                                {
                                        return $this->lng->txt("metric_question_out_of_bounds");
                                }
                        }
                }

                if (!is_numeric($entered_value))
                {
                        return $this->lng->txt("metric_question_not_a_value");
                }

                if (($this->getSubType() == SUBTYPE_RATIO_ABSOLUTE) && (intval($entered_value) != doubleval($entered_value)))
                {
                        return $this->lng->txt("metric_question_floating_point");
                }
                return "";
        }

Here is the call graph for this function:

SurveyMetricQuestion::from_xml ( xml_text  ) 

Imports a question from XML.

Sets the attributes of the question from the XML text passed as argument

Returns:
boolean True, if the import succeeds, false otherwise public

Definition at line 425 of file class.SurveyMetricQuestion.php.

References $idx, SurveyQuestion::$material, $result, domxml_open_mem(), SurveyQuestion::getId(), saveToDb(), SurveyQuestion::setAuthor(), SurveyQuestion::setDescription(), SurveyQuestion::setMaterial(), setMaximum(), setMinimum(), SurveyQuestion::setObligatory(), SurveyQuestion::setQuestiontext(), setSubtype(), and SurveyQuestion::setTitle().

        {
                $result = false;
                if (!empty($this->domxml))
                {
                        $this->domxml->free();
                }
                $xml_text = preg_replace("/>\s*?</", "><", $xml_text);
                $this->domxml = domxml_open_mem($xml_text);
                if (!empty($this->domxml))
                {
                        $root = $this->domxml->document_element();
                        $item = $root->first_child();
                        $this->setTitle($item->get_attribute("title"));
                        $this->gaps = array();
                        $itemnodes = $item->child_nodes();
                        foreach ($itemnodes as $index => $node)
                        {
                                switch ($node->node_name())
                                {
                                        case "qticomment":
                                                $comment = $node->get_content();
                                                if (strpos($comment, "ILIAS Version=") !== false)
                                                {
                                                }
                                                elseif (strpos($comment, "Questiontype=") !== false)
                                                {
                                                }
                                                elseif (strpos($comment, "Author=") !== false)
                                                {
                                                        $comment = str_replace("Author=", "", $comment);
                                                        $this->setAuthor($comment);
                                                }
                                                else
                                                {
                                                        $this->setDescription($comment);
                                                }
                                                break;
                                        case "itemmetadata":
                                                $qtimetadata = $node->first_child();
                                                $metadata_fields = $qtimetadata->child_nodes();
                                                foreach ($metadata_fields as $index => $metadata_field)
                                                {
                                                        $fieldlabel = $metadata_field->first_child();
                                                        $fieldentry = $fieldlabel->next_sibling();
                                                        switch ($fieldlabel->get_content())
                                                        {
                                                                case "obligatory":
                                                                        $this->setObligatory($fieldentry->get_content());
                                                                        break;
                                                                case "subtype":
                                                                        $this->setSubtype($fieldentry->get_content());
                                                                        break;
                                                        }
                                                }
                                                break;
                                        case "presentation":
                                                $flow = $node->first_child();
                                                $flownodes = $flow->child_nodes();
                                                foreach ($flownodes as $idx => $flownode)
                                                {
                                                        if (strcmp($flownode->node_name(), "material") == 0)
                                                        {
                                                                $mattext = $flownode->first_child();
                                                                $this->setQuestiontext($mattext->get_content());
                                                        }
                                                        elseif (strcmp($flownode->node_name(), "response_num") == 0)
                                                        {
                                                                $ident = $flownode->get_attribute("ident");
                                                                $shuffle = "";

                                                                $response_lid_nodes = $flownode->child_nodes();
                                                                foreach ($response_lid_nodes as $resp_lid_id => $resp_lid_node)
                                                                {
                                                                        switch ($resp_lid_node->node_name())
                                                                        {
                                                                                case "render_fib":
                                                                                        $render_choice = $resp_lid_node;
                                                                                        $minnumber = $render_choice->get_attribute("minnumber");
                                                                                        $this->setMinimum($minnumber);
                                                                                        $maxnumber = $render_choice->get_attribute("maxnumber");
                                                                                        $this->setMaximum($maxnumber);
                                                                                        break;
                                                                                case "material":
                                                                                        $matlabel = $resp_lid_node->get_attribute("label");
                                                                                        $mattype = $resp_lid_node->first_child();
                                                                                        if (strcmp($mattype->node_name(), "mattext") == 0)
                                                                                        {
                                                                                                $material = $mattype->get_content();
                                                                                                if ($material)
                                                                                                {
                                                                                                        if ($this->getId() < 1)
                                                                                                        {
                                                                                                                $this->saveToDb();
                                                                                                        }
                                                                                                        $this->setMaterial($material, true, $matlabel);
                                                                                                }
                                                                                        }
                                                                                        break;
                                                                        }
                                                                }
                                                        }
                                                }
                                                break;
                                }
                        }
                        $result = true;
                }
                return $result;
        }

Here is the call graph for this function:

SurveyMetricQuestion::getAdditionalTableName (  ) 

Returns the name of the additional question data table in the database.

Returns the name of the additional question data table in the database

Returns:
string The additional table name public

Definition at line 727 of file class.SurveyMetricQuestion.php.

        {
                return "survey_question_metric";
        }

& SurveyMetricQuestion::getCumulatedResults ( survey_id,
nr_of_users 
)

Definition at line 805 of file class.SurveyMetricQuestion.php.

References $counter, $key, $query, $result, $row, SurveyQuestion::$survey_id, $total, and SurveyQuestion::getId().

        {
                global $ilDB;
                
                $question_id = $this->getId();
                
                $result_array = array();
                $cumulated = array();

                $query = sprintf("SELECT * FROM survey_answer WHERE question_fi = %s AND survey_fi = %s",
                        $ilDB->quote($question_id),
                        $ilDB->quote($survey_id)
                );
                $result = $ilDB->query($query);
                
                while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $cumulated["$row->value"]++;
                }
                asort($cumulated, SORT_NUMERIC);
                end($cumulated);
                $numrows = $result->numRows();
                $result_array["USERS_ANSWERED"] = $result->numRows();
                $result_array["USERS_SKIPPED"] = $nr_of_users - $result->numRows();
                $result_array["MODE"] = key($cumulated);
                $result_array["MODE_VALUE"] = key($cumulated);
                $result_array["MODE_NR_OF_SELECTIONS"] = $cumulated[key($cumulated)];
                ksort($cumulated, SORT_NUMERIC);
                $counter = 0;
                foreach ($cumulated as $value => $nr_of_users)
                {
                        $percentage = 0;
                        if ($numrows > 0)
                        {
                                $percentage = (float)($nr_of_users/$numrows);
                        }
                        $result_array["values"][$counter++] = array("value" => $value, "selected" => (int)$nr_of_users, "percentage" => $percentage);
                }
                $median = array();
                $total = 0;
                $x_i = 0;
                $p_i = 1;
                $x_i_inv = 0;
                $sum_part_zero = false;
                foreach ($cumulated as $value => $key)
                {
                        $total += $key;
                        for ($i = 0; $i < $key; $i++)
                        {
                                array_push($median, $value);
                                $x_i += $value;
                                $p_i *= $value;
                                if ($value != 0)
                                {
                                        $sum_part_zero = true;
                                        $x_i_inv += 1/$value;
                                }
                        }
                }
                if ($total > 0)
                {
                        if (($total % 2) == 0)
                        {
                                $median_value = 0.5 * ($median[($total/2)-1] + $median[($total/2)]);
                        }
                        else
                        {
                                $median_value = $median[(($total+1)/2)-1];
                        }
                }
                else
                {
                        $median_value = "";
                }
                if ($total > 0)
                {
                        if (($x_i/$total) == (int)($x_i/$total))
                        {
                                $result_array["ARITHMETIC_MEAN"] = $x_i/$total;
                        }
                        else
                        {
                                $result_array["ARITHMETIC_MEAN"] = sprintf("%.2f", $x_i/$total);
                        }
                }
                else
                {
                        $result_array["ARITHMETIC_MEAN"] = "";
                }
                $result_array["MEDIAN"] = $median_value;
                $result_array["QUESTION_TYPE"] = "SurveyMetricQuestion";
                return $result_array;
        }

Here is the call graph for this function:

SurveyMetricQuestion::getMaximum (  ) 

Returns the maximum value of the question.

Returns the maximum value of the question

Returns:
double The maximum value of the question public
See also:
$maximum

Definition at line 181 of file class.SurveyMetricQuestion.php.

Referenced by checkUserInput(), and to_xml().

        {
                return $this->maximum;
        }

Here is the caller graph for this function:

SurveyMetricQuestion::getMinimum (  ) 

Returns the minimum value of the question.

Returns the minimum value of the question

Returns:
double The minimum value of the question public
See also:
$minimum

Definition at line 163 of file class.SurveyMetricQuestion.php.

References getSubtype().

Referenced by checkUserInput(), and to_xml().

        {
                if ((strlen($this->minimum) == 0) && ($this->getSubtype() > 3))
                {
                        $this->minimum = 0;
                }
                return $this->minimum;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

SurveyMetricQuestion::getQuestionType (  ) 

Returns the question type of the question.

Returns the question type of the question

Returns:
integer The question type of the question public

Reimplemented from SurveyQuestion.

Definition at line 714 of file class.SurveyMetricQuestion.php.

        {
                return 3;
        }

SurveyMetricQuestion::getSubtype (  ) 

Gets the question subtype.

Gets the question subtype

Returns:
integer The question subtype public
See also:
$subtype

Definition at line 149 of file class.SurveyMetricQuestion.php.

Referenced by getMinimum(), and to_xml().

        {
    return $this->subtype;
  }

Here is the caller graph for this function:

SurveyMetricQuestion::isComplete (  ) 

Returns true if the question is complete for use.

Returns true if the question is complete for use

Returns:
boolean True if the question is complete for use, otherwise false public

Reimplemented from SurveyQuestion.

Definition at line 280 of file class.SurveyMetricQuestion.php.

Referenced by saveToDb(), and syncWithOriginal().

        {
                if ($this->title and $this->author and $this->questiontext)
                {
                        return 1;
                }
                else
                {
                        return 0;
                }
        }

Here is the caller graph for this function:

SurveyMetricQuestion::loadFromDb ( id  ) 

Loads a SurveyMetricQuestion object from the database.

Loads a SurveyMetricQuestion object from the database

Parameters:
integer $id The database id of the metric survey question public

Reimplemented from SurveyQuestion.

Definition at line 221 of file class.SurveyMetricQuestion.php.

References $data, SurveyQuestion::$id, $query, $result, ilRTE::_replaceMediaObjectImageSrc(), and SurveyQuestion::loadMaterialFromDb().

        {
                global $ilDB;
    $query = sprintf("SELECT survey_question.*, survey_question_metric.* FROM survey_question, survey_question_metric WHERE survey_question.question_id = %s AND survey_question.question_id = survey_question_metric.question_fi",
      $ilDB->quote($id)
    );
    $result = $ilDB->query($query);
    if (strcmp(strtolower(get_class($result)), db_result) == 0) 
                {
      if ($result->numRows() == 1) 
                        {
        $data = $result->fetchRow(DB_FETCHMODE_OBJECT);
        $this->id = $data->question_id;
        $this->title = $data->title;
        $this->description = $data->description;
        $this->obj_id = $data->obj_fi;
                                $this->obligatory = $data->obligatory;
        $this->author = $data->author;
                                $this->subtype = $data->subtype;
                                $this->original_id = $data->original_id;
        $this->owner = $data->owner_fi;
                                include_once("./Services/RTE/classes/class.ilRTE.php");
                                $this->questiontext = ilRTE::_replaceMediaObjectImageSrc($data->questiontext, 1);
        $this->complete = $data->complete;
      }
      // loads materials uris from database
      $this->loadMaterialFromDb($id);

      $query = sprintf("SELECT survey_variable.* FROM survey_variable WHERE survey_variable.question_fi = %s",
        $ilDB->quote($id)
      );
      $result = $ilDB->query($query);
      if (strcmp(strtolower(get_class($result)), db_result) == 0) 
                        {
        if ($data = $result->fetchRow(DB_FETCHMODE_OBJECT)) 
                                {
          $this->minimum = $data->value1;
                                        if (($data->value2 < 0) or (strcmp($data->value2, "") == 0))
                                        {
                                                $this->maximum = "";
                                        }
                                        else
                                        {
                                                $this->maximum = $data->value2;
                                        }
        }
      }
    }
                parent::loadFromDb($id);
  }

Here is the call graph for this function:

SurveyMetricQuestion::saveToDb ( original_id = ""  ) 

Saves a SurveyMetricQuestion object to a database.

Saves a SurveyMetricQuestion object to a database

public

Reimplemented from SurveyQuestion.

Definition at line 299 of file class.SurveyMetricQuestion.php.

References $query, $result, ilRTE::_cleanupMediaObjectUsage(), ilRTE::_replaceMediaObjectImageSrc(), SurveyQuestion::getId(), isComplete(), and SurveyQuestion::saveMaterialsToDb().

Referenced by from_xml().

  {
                global $ilDB;
                $complete = 0;
                if ($this->isComplete()) 
                {
                        $complete = 1;
                }
                if ($original_id)
                {
                        $original_id = $ilDB->quote($original_id);
                }
                else
                {
                        $original_id = "NULL";
                }
                // cleanup RTE images which are not inserted into the question text
                include_once("./Services/RTE/classes/class.ilRTE.php");
                ilRTE::_cleanupMediaObjectUsage($this->questiontext, "spl:html",
                        $this->getId());

    if ($this->id == -1) 
                {
      // Write new dataset
      $now = getdate();
      $created = sprintf("%04d%02d%02d%02d%02d%02d", $now['year'], $now['mon'], $now['mday'], $now['hours'], $now['minutes'], $now['seconds']);
      $query = sprintf("INSERT INTO survey_question (question_id, questiontype_fi, obj_fi, owner_fi, title, description, author, questiontext, obligatory, complete, created, original_id, TIMESTAMP) VALUES (NULL, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, NULL)",
                                $ilDB->quote($this->getQuestionType()),
                                $ilDB->quote($this->obj_id),
                                $ilDB->quote($this->owner),
                                $ilDB->quote($this->title),
                                $ilDB->quote($this->description),
                                $ilDB->quote($this->author),
                                $ilDB->quote(ilRTE::_replaceMediaObjectImageSrc($this->questiontext, 0)),
                                $ilDB->quote(sprintf("%d", $this->obligatory)),
                                $ilDB->quote("$complete"),
                                $ilDB->quote($created),
                                $original_id
      );
      $result = $ilDB->query($query);
      if ($result == DB_OK) 
                        {
        $this->id = $ilDB->getLastInsertId();
                                $query = sprintf("INSERT INTO survey_question_metric (question_fi, subtype) VALUES (%s, %s)",
                                        $ilDB->quote($this->id . ""),
                                        $ilDB->quote($this->getSubType() . "")
                                );
                                $ilDB->query($query);
      }
    } 
                else 
                {
      // update existing dataset
      $query = sprintf("UPDATE survey_question SET title = %s, description = %s, author = %s, questiontext = %s, obligatory = %s, complete = %s WHERE question_id = %s",
                                $ilDB->quote($this->title),
                                $ilDB->quote($this->description),
                                $ilDB->quote($this->author),
                                $ilDB->quote(ilRTE::_replaceMediaObjectImageSrc($this->questiontext, 0)),
                                $ilDB->quote(sprintf("%d", $this->obligatory)),
                                $ilDB->quote("$complete"),
                                $ilDB->quote($this->id)
      );
      $result = $ilDB->query($query);
                        $query = sprintf("UPDATE survey_question_metric SET subtype = %s WHERE question_fi = %s",
                                $ilDB->quote($this->getSubType() . ""),
                                $ilDB->quote($this->id . "")
                        );
                        $result = $ilDB->query($query);
    }
    if ($result == DB_OK) 
                {
      // saving material uris in the database
      $this->saveMaterialsToDb();

      // save categories
                        
                        // delete existing category relations
      $query = sprintf("DELETE FROM survey_variable WHERE question_fi = %s",
        $ilDB->quote($this->id)
      );
      $result = $ilDB->query($query);
      // create new category relations
                        if (strcmp($this->minimum, "") == 0)
                        {
                                $min = "NULL";
                        }
                        else
                        {
                                $min = $ilDB->quote($this->minimum);
                        }
                        if (preg_match("/[\D]/", $this->maximum) or (strcmp($this->maximum, "&infin;") == 0))
                        {
                                $max = -1;
                        }
                        else
                        {
                                if (strcmp($this->maximum, "") == 0)
                                {
                                        $max = "NULL";
                                }
                                else
                                {
                                        $max = $ilDB->quote($this->maximum);
                                }
                        }
                        $query = sprintf("INSERT INTO survey_variable (variable_id, category_fi, question_fi, value1, value2, sequence, TIMESTAMP) VALUES (NULL, %s, %s, %s, %s, %s, NULL)",
                                $ilDB->quote(0),
                                $ilDB->quote($this->id),
                                $min,
                                $max,
                                $ilDB->quote(0)
                        );
                        $answer_result = $ilDB->query($query);
    }
                parent::saveToDb($original_id);
  }

Here is the call graph for this function:

Here is the caller graph for this function:

SurveyMetricQuestion::saveUserInput ( post_data,
survey_id,
user_id,
anonymous_id 
)

Definition at line 777 of file class.SurveyMetricQuestion.php.

References $query, $result, SurveyQuestion::$survey_id, $user_id, and SurveyQuestion::getId().

        {
                global $ilDB;
                
                $entered_value = $post_data[$this->getId() . "_metric_question"];
                if (strlen($entered_value) == 0) return;
                // replace german notation with international notation
                $entered_value = str_replace(",", ".", $entered_value);
                
                if (strlen($entered_value) == 0)
                {
                        $entered_value = "NULL";
                }
                else
                {
                        $entered_value = $ilDB->quote($entered_value . "");
                }
                $query = sprintf("INSERT INTO survey_answer (answer_id, survey_fi, question_fi, user_fi, anonymous_id, value, textanswer, TIMESTAMP) VALUES (NULL, %s, %s, %s, %s, %s, %s, NULL)",
                        $ilDB->quote($survey_id . ""),
                        $ilDB->quote($this->getId() . ""),
                        $ilDB->quote($user_id . ""),
                        $ilDB->quote($anonymous_id . ""),
                        $entered_value,
                        "NULL"
                );
                $result = $ilDB->query($query);
        }

Here is the call graph for this function:

SurveyMetricQuestion::setMaximum ( maximum = ""  ) 

Sets the maximum value.

Sets the maximum value

Parameters:
double $maximum The maximum value public
See also:
$maximum

Definition at line 135 of file class.SurveyMetricQuestion.php.

References $maximum.

Referenced by from_xml().

        {
    $this->maximum = $maximum;
  }

Here is the caller graph for this function:

SurveyMetricQuestion::setMinimum ( minimum = 0  ) 

Sets the minimum value.

Sets the minimum value

Parameters:
double $minimum The minimum value public
See also:
$minimum

Definition at line 121 of file class.SurveyMetricQuestion.php.

References $minimum.

Referenced by from_xml().

        {
    $this->minimum = $minimum;
  }

Here is the caller graph for this function:

SurveyMetricQuestion::setSubtype ( subtype = SUBTYPE_NON_RATIO  ) 

Sets the question subtype.

Sets the question subtype

Parameters:
integer $subtype The question subtype public
See also:
$subtype

Definition at line 107 of file class.SurveyMetricQuestion.php.

References $subtype.

Referenced by from_xml().

        {
    $this->subtype = $subtype;
  }

Here is the caller graph for this function:

SurveyMetricQuestion::SurveyMetricQuestion ( title = "",
description = "",
author = "",
questiontext = "",
owner = -1,
subtype = SUBTYPE_NON_RATIO 
)

SurveyMetricQuestion constructor.

The constructor takes possible arguments an creates an instance of the SurveyMetricQuestion object.

Parameters:
string $title A title string to describe the question
string $description A description string to describe the question
string $author A string containing the name of the questions author
integer $owner A numerical ID to identify the owner/creator public

Definition at line 82 of file class.SurveyMetricQuestion.php.

References SurveyQuestion::$author, SurveyQuestion::$description, SurveyQuestion::$owner, SurveyQuestion::$questiontext, $subtype, SurveyQuestion::$title, and SurveyQuestion::SurveyQuestion().

  {
                $this->SurveyQuestion($title, $description, $author, $questiontext, $owner);
                $this->subtype = $subtype;
                $this->minimum = "";
                $this->maximum = "";
        }

Here is the call graph for this function:

SurveyMetricQuestion::syncWithOriginal (  ) 

Reimplemented from SurveyQuestion.

Definition at line 635 of file class.SurveyMetricQuestion.php.

References $query, $result, and isComplete().

        {
                global $ilDB;
                if ($this->original_id)
                {
                        $complete = 0;
                        if ($this->isComplete()) 
                        {
                                $complete = 1;
                        }
                        $query = sprintf("UPDATE survey_question SET title = %s, description = %s, author = %s, questiontext = %s, obligatory = %s, complete = %s WHERE question_id = %s",
                                $ilDB->quote($this->title . ""),
                                $ilDB->quote($this->description . ""),
                                $ilDB->quote($this->author . ""),
                                $ilDB->quote($this->questiontext . ""),
                                $ilDB->quote(sprintf("%d", $this->obligatory) . ""),
                                $ilDB->quote($complete . ""),
                                $ilDB->quote($this->original_id . "")
                        );
                        $result = $ilDB->query($query);
                        $query = sprintf("UPDATE survey_question_metric SET subtype = %s WHERE question_fi = %s",
                                $ilDB->quote($this->getSubType() . ""),
                                $ilDB->quote($this->original_id . "")
                        );
                        $result = $ilDB->query($query);
                        if ($result == DB_OK) 
                        {
                                // save categories
                                
                                // delete existing category relations
                                $query = sprintf("DELETE FROM survey_variable WHERE question_fi = %s",
                                        $ilDB->quote($this->original_id)
                                );
                                $result = $ilDB->query($query);
                                // create new category relations
                                if (strcmp($this->minimum, "") == 0)
                                {
                                        $min = "NULL";
                                }
                                else
                                {
                                        $min = $ilDB->quote($this->minimum . "");
                                }
                                if (preg_match("/[\D]/", $this->maximum) or (strcmp($this->maximum, "&infin;") == 0))
                                {
                                        $max = -1;
                                }
                                else
                                {
                                        if (strcmp($this->maximum, "") == 0)
                                        {
                                                $max = "NULL";
                                        }
                                        else
                                        {
                                                $max = $ilDB->quote($this->maximum . "");
                                        }
                                }
                                $query = sprintf("INSERT INTO survey_variable (variable_id, category_fi, question_fi, value1, value2, sequence, TIMESTAMP) VALUES (NULL, %s, %s, %s, %s, %s, NULL)",
                                        $ilDB->quote("0"),
                                        $ilDB->quote($this->original_id . ""),
                                        $min,
                                        $max,
                                        $ilDB->quote("0")
                                );
                                $answer_result = $ilDB->query($query);
                        }
                }
                parent::syncWithOriginal();
        }

Here is the call graph for this function:

SurveyMetricQuestion::to_xml ( a_include_header = true,
obligatory_state = "" 
)

Returns a QTI xml representation of the question.

Returns a QTI xml representation of the question and sets the internal domxml variable with the DOM XML representation of the QTI xml representation

Returns:
string The QTI xml representation of the question public

Definition at line 545 of file class.SurveyMetricQuestion.php.

References $pos, SurveyQuestion::addQTIMaterial(), SurveyQuestion::getAuthor(), SurveyQuestion::getDescription(), SurveyQuestion::getId(), getMaximum(), getMinimum(), SurveyQuestion::getObligatory(), SurveyQuestion::getQuestiontext(), getSubtype(), SurveyQuestion::getTitle(), and SurveyQuestion::setObligatory().

        {
                include_once("./classes/class.ilXmlWriter.php");
                $a_xml_writer = new ilXmlWriter;
                // set xml header
                $a_xml_writer->xmlHeader();
                $a_xml_writer->xmlStartTag("questestinterop");
                $attrs = array(
                        "ident" => $this->getId(),
                        "title" => $this->getTitle()
                );
                $a_xml_writer->xmlStartTag("item", $attrs);
                // add question description
                $a_xml_writer->xmlElement("qticomment", NULL, $this->getDescription());
                $a_xml_writer->xmlElement("qticomment", NULL, "ILIAS Version=".$this->ilias->getSetting("ilias_version"));
                $a_xml_writer->xmlElement("qticomment", NULL, "Questiontype=".METRIC_QUESTION_IDENTIFIER);
                $a_xml_writer->xmlElement("qticomment", NULL, "Author=".$this->getAuthor());
                // add ILIAS specific metadata
                $a_xml_writer->xmlStartTag("itemmetadata");
                $a_xml_writer->xmlStartTag("qtimetadata");
                $a_xml_writer->xmlStartTag("qtimetadatafield");
                $a_xml_writer->xmlElement("fieldlabel", NULL, "obligatory");
                if (strcmp($obligatory_state, "") != 0)
                {
                        $this->setObligatory($obligatory_state);
                }
                $a_xml_writer->xmlElement("fieldentry", NULL, sprintf("%d", $this->getObligatory()));
                $a_xml_writer->xmlEndTag("qtimetadatafield");
                $a_xml_writer->xmlStartTag("qtimetadatafield");
                $a_xml_writer->xmlElement("fieldlabel", NULL, "subtype");
                $a_xml_writer->xmlElement("fieldentry", NULL, sprintf("%d", $this->getSubtype()));
                $a_xml_writer->xmlEndTag("qtimetadatafield");
                $a_xml_writer->xmlEndTag("qtimetadata");
                $a_xml_writer->xmlEndTag("itemmetadata");

                // PART I: qti presentation
                $attrs = array(
                        "label" => $this->getTitle()
                );
                $a_xml_writer->xmlStartTag("presentation", $attrs);
                // add flow to presentation
                $a_xml_writer->xmlStartTag("flow");
                // add material with question text to presentation
                $this->addQTIMaterial($a_xml_writer, $this->getQuestiontext());
                // add answers to presentation
                $attrs = array(
                        "ident" => "METRIC",
                        "rcardinality" => "Single"
                );
                $a_xml_writer->xmlStartTag("response_num", $attrs);
                
                if (count($this->material))
                {
                        if (preg_match("/il_(\d*?)_(\w+)_(\d+)/", $this->material["internal_link"], $matches))
                        {
                                $attrs = array(
                                        "label" => $this->material["title"]
                                );
                                $a_xml_writer->xmlStartTag("material", $attrs);
                                $intlink = "il_" . IL_INST_ID . "_" . $matches[2] . "_" . $matches[3];
                                if (strcmp($matches[1], "") != 0)
                                {
                                        $intlink = $this->material["internal_link"];
                                }
                                $a_xml_writer->xmlElement("mattext", NULL, $intlink);
                                $a_xml_writer->xmlEndTag("material");
                        }
                }

                $attrs = array(
                        "minnumber" => $this->getMinimum(),
                        "maxnumber" => $this->getMaximum()
                );
                $a_xml_writer->xmlStartTag("render_fib", $attrs);
                $a_xml_writer->xmlEndTag("render_fib");
                $a_xml_writer->xmlEndTag("response_num");
                $a_xml_writer->xmlEndTag("flow");
                $a_xml_writer->xmlEndTag("presentation");
                $a_xml_writer->xmlEndTag("item");
                $a_xml_writer->xmlEndTag("questestinterop");

                $xml = $a_xml_writer->xmlDumpMem(FALSE);
                if (!$a_include_header)
                {
                        $pos = strpos($xml, "?>");
                        $xml = substr($xml, $pos + 2);
                }
                return $xml;
        }

Here is the call graph for this function:


Field Documentation

SurveyMetricQuestion::$maximum

Definition at line 69 of file class.SurveyMetricQuestion.php.

Referenced by setMaximum().

SurveyMetricQuestion::$minimum

Definition at line 60 of file class.SurveyMetricQuestion.php.

Referenced by setMinimum().

SurveyMetricQuestion::$subtype

Definition at line 51 of file class.SurveyMetricQuestion.php.

Referenced by setSubtype(), and SurveyMetricQuestion().


The documentation for this class was generated from the following file: