Text survey question. More...
Inheritance diagram for SurveyTextQuestion:
Collaboration diagram for SurveyTextQuestion:Public Member Functions | |
| SurveyTextQuestion ($title="", $description="", $author="", $questiontext="", $owner=-1) | |
| SurveyTextQuestion constructor. | |
| _getQuestionDataArray ($id) | |
| Returns the question data fields from the database. | |
| loadFromDb ($id) | |
| Loads a SurveyTextQuestion object from the database. | |
| isComplete () | |
| Returns true if the question is complete for use. | |
| setMaxChars ($maxchars=0) | |
| Sets the maximum number of allowed characters for the text answer. | |
| getMaxChars () | |
| Returns the maximum number of allowed characters for the text answer. | |
| saveToDb ($original_id="") | |
| Saves a SurveyTextQuestion object to a database. | |
| toXML ($a_include_header=TRUE, $obligatory_state="") | |
| Returns an xml representation of the question. | |
| insertXML (&$a_xml_writer, $a_include_header=TRUE, $obligatory_state="") | |
| Adds the question XML to a given XMLWriter object. | |
| syncWithOriginal () | |
| _getMaxChars ($question_id) | |
| Returns the maxium number of allowed characters for the text answer. | |
| getQuestionType () | |
| Returns the question type of the question. | |
| getAdditionalTableName () | |
| Returns the name of the additional question data table in the database. | |
| & | getWorkingDataFromUserInput ($post_data) |
| Creates the user data of the survey_answer table from the POST data. | |
| checkUserInput ($post_data, $survey_id) | |
| Checks the input of the active user for obligatory status and entered values. | |
| saveUserInput ($post_data, $active_id) | |
| & | getCumulatedResults ($survey_id, $nr_of_users) |
| setExportDetailsXLS (&$workbook, &$format_title, &$format_bold, &$eval_data) | |
| Creates an Excel worksheet for the detailed cumulated results of this question. | |
| addUserSpecificResultsData (&$a_array, &$resultset) | |
| Adds the values for the user specific results export for a given user. | |
| & | getUserAnswers ($survey_id) |
| Returns an array containing all answers to this question in a given survey. | |
| importResponses ($a_data) | |
| Import response data from the question import file. | |
| usableForPrecondition () | |
| Returns if the question is usable for preconditions. | |
| getTextWidth () | |
| Returns the width of the answer field. | |
| getTextHeight () | |
| Returns the height of the answer field. | |
| setTextWidth ($a_textwidth) | |
| Sets the width of the answer field. | |
| setTextHeight ($a_textheight) | |
| Sets the height of the answer field. | |
Data Fields | |
| $maxchars | |
| $textwidth | |
| $textheight | |
Text survey question.
The SurveyTextQuestion class defines and encapsulates basic methods and attributes for text survey question types.
Definition at line 38 of file class.SurveyTextQuestion.php.
| SurveyTextQuestion::_getMaxChars | ( | $ | question_id | ) |
Returns the maxium number of allowed characters for the text answer.
Returns the maxium number of allowed characters for the text answer
Definition at line 397 of file class.SurveyTextQuestion.php.
{
global $ilDB;
$query = sprintf("SELECT maxchars FROM survey_question WHERE question_id = %s",
$ilDB->quote($question_id . "")
);
$result = $ilDB->query($query);
if ($result->numRows())
{
$row = $result->fetchRow(DB_FETCHMODE_ASSOC);
return $row["maxchars"];
}
return 0;
}
| SurveyTextQuestion::_getQuestionDataArray | ( | $ | id | ) |
Returns the question data fields from the database.
Returns the question data fields from the database
| integer | $id The question ID from the database |
Reimplemented from SurveyQuestion.
Definition at line 79 of file class.SurveyTextQuestion.php.
References SurveyQuestion::$id.
{
global $ilDB;
$query = sprintf("SELECT survey_question.*, survey_question_text.* FROM survey_question, survey_question_text WHERE survey_question.question_id = %s AND survey_question.question_id = survey_question_text.question_fi",
$ilDB->quote($id)
);
$result = $ilDB->query($query);
if ($result->numRows() == 1)
{
return $result->fetchRow(DB_FETCHMODE_ASSOC);
}
else
{
return array();
}
}
| SurveyTextQuestion::addUserSpecificResultsData | ( | &$ | a_array, | |
| &$ | resultset | |||
| ) |
Adds the values for the user specific results export for a given user.
Adds the values for the user specific results export for a given user
| array | $a_array An array which is used to append the values | |
| array | $resultset The evaluation data for a given user public |
Reimplemented from SurveyQuestion.
Definition at line 579 of file class.SurveyTextQuestion.php.
References SurveyQuestion::getId().
{
if (count($resultset["answers"][$this->getId()]))
{
foreach ($resultset["answers"][$this->getId()] as $key => $answer)
{
array_push($a_array, $answer["textanswer"]);
}
}
else
{
array_push($a_array, $this->lng->txt("skipped"));
}
}
Here is the call graph for this function:| SurveyTextQuestion::checkUserInput | ( | $ | post_data, | |
| $ | survey_id | |||
| ) |
Checks the input of the active user for obligatory status and entered values.
Checks the input of the active user for obligatory status and entered values
| array | $post_data The contents of the $_POST array | |
| integer | $survey_id The database ID of the active survey |
Definition at line 468 of file class.SurveyTextQuestion.php.
References SurveyQuestion::$survey_id, SurveyQuestion::getId(), and SurveyQuestion::getObligatory().
{
$entered_value = $post_data[$this->getId() . "_text_question"];
if ((!$this->getObligatory($survey_id)) && (strlen($entered_value) == 0)) return "";
if (strlen($entered_value) == 0) return $this->lng->txt("text_question_not_filled_out");
return "";
}
Here is the call graph for this function:| SurveyTextQuestion::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
Definition at line 433 of file class.SurveyTextQuestion.php.
{
return "survey_question_text";
}
| & SurveyTextQuestion::getCumulatedResults | ( | $ | survey_id, | |
| $ | nr_of_users | |||
| ) |
Definition at line 501 of file class.SurveyTextQuestion.php.
References SurveyQuestion::$survey_id, and SurveyQuestion::getId().
{
global $ilDB;
$question_id = $this->getId();
$result_array = array();
$cumulated = array();
$textvalues = array();
$query = sprintf("SELECT survey_answer.* FROM survey_answer, survey_finished WHERE survey_answer.question_fi = %s AND survey_finished.survey_fi = %s AND survey_finished.finished_id = survey_answer.active_fi",
$ilDB->quote($question_id),
$ilDB->quote($survey_id)
);
$result = $ilDB->query($query);
while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT))
{
$cumulated["$row->value"]++;
array_push($textvalues, $row->textanswer);
}
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["QUESTION_TYPE"] = "SurveyTextQuestion";
$result_array["textvalues"] = $textvalues;
return $result_array;
}
Here is the call graph for this function:| SurveyTextQuestion::getMaxChars | ( | ) |
Returns the maximum number of allowed characters for the text answer.
Returns the maximum number of allowed characters for the text answer
public
Definition at line 177 of file class.SurveyTextQuestion.php.
Referenced by insertXML(), and saveUserInput().
{
return $this->maxchars;
}
Here is the caller graph for this function:| SurveyTextQuestion::getQuestionType | ( | ) |
Returns the question type of the question.
Returns the question type of the question
Reimplemented from SurveyQuestion.
Definition at line 420 of file class.SurveyTextQuestion.php.
{
return "SurveyTextQuestion";
}
| SurveyTextQuestion::getTextHeight | ( | ) |
Returns the height of the answer field.
Returns the height of the answer field
Definition at line 682 of file class.SurveyTextQuestion.php.
Referenced by insertXML(), and saveToDb().
{
return $this->textheight;
}
Here is the caller graph for this function:| SurveyTextQuestion::getTextWidth | ( | ) |
Returns the width of the answer field.
Returns the width of the answer field
Definition at line 669 of file class.SurveyTextQuestion.php.
Referenced by insertXML(), and saveToDb().
{
return $this->textwidth;
}
Here is the caller graph for this function:| & SurveyTextQuestion::getUserAnswers | ( | $ | survey_id | ) |
Returns an array containing all answers to this question in a given survey.
Returns an array containing all answers to this question in a given survey
| integer | $survey_id The database ID of the survey |
Reimplemented from SurveyQuestion.
Definition at line 603 of file class.SurveyTextQuestion.php.
References SurveyQuestion::$survey_id, and SurveyQuestion::getId().
{
global $ilDB;
$answers = array();
$query = sprintf("SELECT survey_answer.* FROM survey_answer, survey_finished WHERE survey_finished.survey_fi = %s AND survey_answer.question_fi = %s AND survey_finished.finished_id = survey_answer.active_fi",
$ilDB->quote($survey_id),
$ilDB->quote($this->getId())
);
$result = $ilDB->query($query);
while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
{
$answers[$row["active_fi"]] = $row["textanswer"];
}
return $answers;
}
Here is the call graph for this function:| & SurveyTextQuestion::getWorkingDataFromUserInput | ( | $ | post_data | ) |
Creates the user data of the survey_answer table from the POST data.
Creates the user data of the survey_answer table from the POST data
Reimplemented from SurveyQuestion.
Definition at line 446 of file class.SurveyTextQuestion.php.
References $data, and SurveyQuestion::getId().
{
$entered_value = $post_data[$this->getId() . "_text_question"];
if (strlen($entered_value))
{
$data = array("textanswer" => $entered_value);
}
return $data;
}
Here is the call graph for this function:| SurveyTextQuestion::importResponses | ( | $ | a_data | ) |
Import response data from the question import file.
Import response data from the question import file
Reimplemented from SurveyQuestion.
Definition at line 629 of file class.SurveyTextQuestion.php.
References $data, SurveyQuestion::$id, setMaxChars(), setTextHeight(), and setTextWidth().
{
foreach ($a_data as $id => $data)
{
if ($data["maxlength"] > 0)
{
$this->setMaxChars($data["maxlength"]);
}
if ($data["rows"] > 0)
{
$this->setTextHeight($data["rows"]);
}
if ($data["columns"] > 0)
{
$this->setTextWidth($data["columns"]);
}
}
}
Here is the call graph for this function:| SurveyTextQuestion::insertXML | ( | &$ | a_xml_writer, | |
| $ | a_include_header = TRUE, |
|||
| $ | obligatory_state = "" | |||
| ) |
Adds the question XML to a given XMLWriter object.
Adds the question XML to a given XMLWriter object
| object | $a_xml_writer The XMLWriter object | |
| boolean | $a_include_header Determines wheather or not the XML should be used | |
| string | $obligatory_state The value of the obligatory state public |
Definition at line 308 of file class.SurveyTextQuestion.php.
References SurveyQuestion::addMaterialTag(), SurveyQuestion::getAuthor(), SurveyQuestion::getDescription(), SurveyQuestion::getId(), getMaxChars(), SurveyQuestion::getObligatory(), SurveyQuestion::getQuestiontext(), getTextHeight(), getTextWidth(), and SurveyQuestion::getTitle().
Referenced by toXML().
{
$attrs = array(
"id" => $this->getId(),
"title" => $this->getTitle(),
"type" => $this->getQuestiontype(),
"obligatory" => $this->getObligatory()
);
$a_xml_writer->xmlStartTag("question", $attrs);
$a_xml_writer->xmlElement("description", NULL, $this->getDescription());
$a_xml_writer->xmlElement("author", NULL, $this->getAuthor());
$a_xml_writer->xmlStartTag("questiontext");
$this->addMaterialTag($a_xml_writer, $this->getQuestiontext());
$a_xml_writer->xmlEndTag("questiontext");
$a_xml_writer->xmlStartTag("responses");
$attrs = array(
"id" => "0",
"rows" => $this->getTextHeight(),
"columns" => $this->getTextWidth()
);
if ($this->getMaxChars() > 0)
{
$attrs["maxlength"] = $this->getMaxChars();
}
$a_xml_writer->xmlElement("response_text", $attrs);
$a_xml_writer->xmlEndTag("responses");
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");
}
}
$a_xml_writer->xmlEndTag("question");
}
Here is the call graph for this function:
Here is the caller graph for this function:| SurveyTextQuestion::isComplete | ( | ) |
Returns true if the question is complete for use.
Returns true if the question is complete for use
Reimplemented from SurveyQuestion.
Definition at line 146 of file class.SurveyTextQuestion.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:| SurveyTextQuestion::loadFromDb | ( | $ | id | ) |
Loads a SurveyTextQuestion object from the database.
Loads a SurveyTextQuestion object from the database
| integer | $id The database id of the text survey question public |
Reimplemented from SurveyQuestion.
Definition at line 105 of file class.SurveyTextQuestion.php.
References $data, SurveyQuestion::$id, ilRTE::_replaceMediaObjectImageSrc(), and SurveyQuestion::loadMaterialFromDb().
{
global $ilDB;
$query = sprintf("SELECT survey_question.*, survey_question_text.* FROM survey_question, survey_question_text WHERE survey_question.question_id = %s AND survey_question.question_id = survey_question_text.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->author = $data->author;
$this->obligatory = $data->obligatory;
$this->owner = $data->owner_fi;
$this->original_id = $data->original_id;
$this->maxchars = $data->maxchars;
$this->textwidth = $data->width;
$this->textheight = $data->height;
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);
}
parent::loadFromDb($id);
}
Here is the call graph for this function:| SurveyTextQuestion::saveToDb | ( | $ | original_id = "" |
) |
Saves a SurveyTextQuestion object to a database.
Saves a SurveyTextQuestion object to a database
public
Reimplemented from SurveyQuestion.
Definition at line 189 of file class.SurveyTextQuestion.php.
References $maxchars, ilRTE::_cleanupMediaObjectUsage(), ilRTE::_replaceMediaObjectImageSrc(), SurveyQuestion::getId(), getTextHeight(), getTextWidth(), isComplete(), and SurveyQuestion::saveMaterialsToDb().
{
global $ilDB;
$maxchars = "NULL";
if ($this->maxchars)
{
$maxchars = $ilDB->quote($this->maxchars . "");
}
$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->getQuestionTypeID() . ""),
$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_text (question_fi, maxchars, width, height) VALUES (%s, %s, %s, %s)",
$ilDB->quote($this->id . ""),
$maxchars,
$ilDB->quote($this->getTextWidth() . ""),
$ilDB->quote($this->getTextHeight() . ""),
$maxchars
);
$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_text SET maxchars = %s, width = %s, height = %s WHERE question_fi = %s",
$maxchars,
$ilDB->quote($this->getTextWidth() . ""),
$ilDB->quote($this->getTextHeight() . ""),
$ilDB->quote($this->id . "")
);
$result = $ilDB->query($query);
}
if ($result == DB_OK) {
// saving material uris in the database
$this->saveMaterialsToDb();
}
parent::saveToDb($original_id);
}
Here is the call graph for this function:| SurveyTextQuestion::saveUserInput | ( | $ | post_data, | |
| $ | active_id | |||
| ) |
Definition at line 479 of file class.SurveyTextQuestion.php.
References $maxchars, SurveyQuestion::getId(), getMaxChars(), and ilUtil::stripSlashes().
{
global $ilDB;
include_once "./Services/Utilities/classes/class.ilUtil.php";
$entered_value = ilUtil::stripSlashes($post_data[$this->getId() . "_text_question"]);
$maxchars = $this->getMaxChars();
if ($maxchars > 0)
{
$entered_value = substr($entered_value, 0, $maxchars);
}
if (strlen($entered_value) == 0) return;
$entered_value = $ilDB->quote($entered_value . "");
$query = sprintf("INSERT INTO survey_answer (answer_id, question_fi, active_fi, value, textanswer, TIMESTAMP) VALUES (NULL, %s, %s, %s, %s, NULL)",
$ilDB->quote($this->getId() . ""),
$ilDB->quote($active_id . ""),
"NULL",
$entered_value
);
$result = $ilDB->query($query);
}
Here is the call graph for this function:| SurveyTextQuestion::setExportDetailsXLS | ( | &$ | workbook, | |
| &$ | format_title, | |||
| &$ | format_bold, | |||
| &$ | eval_data | |||
| ) |
Creates an Excel worksheet for the detailed cumulated results of this question.
Creates an Excel worksheet for the detailed cumulated results of this question
| object | $workbook Reference to the parent excel workbook | |
| object | $format_title Excel title format | |
| object | $format_bold Excel bold format | |
| array | $eval_data Cumulated evaluation data public |
Reimplemented from SurveyQuestion.
Definition at line 543 of file class.SurveyTextQuestion.php.
References ilExcelUtils::_convert_text(), SurveyQuestion::getQuestiontext(), and SurveyQuestion::getTitle().
{
include_once ("./classes/class.ilExcelUtils.php");
$worksheet =& $workbook->addWorksheet();
$worksheet->writeString(0, 0, ilExcelUtils::_convert_text($this->lng->txt("title")), $format_bold);
$worksheet->writeString(0, 1, ilExcelUtils::_convert_text($this->getTitle()));
$worksheet->writeString(1, 0, ilExcelUtils::_convert_text($this->lng->txt("question")), $format_bold);
$worksheet->writeString(1, 1, ilExcelUtils::_convert_text($this->getQuestiontext()));
$worksheet->writeString(2, 0, ilExcelUtils::_convert_text($this->lng->txt("question_type")), $format_bold);
$worksheet->writeString(2, 1, ilExcelUtils::_convert_text($this->lng->txt($this->getQuestionType())));
$worksheet->writeString(3, 0, ilExcelUtils::_convert_text($this->lng->txt("users_answered")), $format_bold);
$worksheet->write(3, 1, $eval_data["USERS_ANSWERED"]);
$worksheet->writeString(4, 0, ilExcelUtils::_convert_text($this->lng->txt("users_skipped")), $format_bold);
$worksheet->write(4, 1, $eval_data["USERS_SKIPPED"]);
$rowcounter = 5;
$worksheet->write($rowcounter, 0, ilExcelUtils::_convert_text($this->lng->txt("given_answers")), $format_bold);
$textvalues = "";
if (is_array($eval_data["textvalues"]))
{
foreach ($eval_data["textvalues"] as $textvalue)
{
$worksheet->write($rowcounter++, 1, ilExcelUtils::_convert_text($textvalue));
}
}
}
Here is the call graph for this function:| SurveyTextQuestion::setMaxChars | ( | $ | maxchars = 0 |
) |
Sets the maximum number of allowed characters for the text answer.
Sets the maximum number of allowed characters for the text answer
public
Definition at line 165 of file class.SurveyTextQuestion.php.
References $maxchars.
Referenced by importResponses().
{
$this->maxchars = $maxchars;
}
Here is the caller graph for this function:| SurveyTextQuestion::setTextHeight | ( | $ | a_textheight | ) |
Sets the height of the answer field.
Sets the height of the answer field
| integer | $a_textheight The height of the answer field in characters public |
Definition at line 715 of file class.SurveyTextQuestion.php.
Referenced by importResponses().
{
if ($a_textheight < 1)
{
$this->textheight = 5;
}
else
{
$this->textheight = $a_textheight;
}
}
Here is the caller graph for this function:| SurveyTextQuestion::setTextWidth | ( | $ | a_textwidth | ) |
Sets the width of the answer field.
Sets the width of the answer field
| integer | $a_textwidth The width of the answer field in characters public |
Definition at line 695 of file class.SurveyTextQuestion.php.
Referenced by importResponses().
{
if ($a_textwidth < 1)
{
$this->textwidth = 50;
}
else
{
$this->textwidth = $a_textwidth;
}
}
Here is the caller graph for this function:| SurveyTextQuestion::SurveyTextQuestion | ( | $ | title = "", |
|
| $ | description = "", |
|||
| $ | author = "", |
|||
| $ | questiontext = "", |
|||
| $ | owner = -1 | |||
| ) |
SurveyTextQuestion constructor.
The constructor takes possible arguments an creates an instance of the SurveyTextQuestion object.
| 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 55 of file class.SurveyTextQuestion.php.
References SurveyQuestion::$author, SurveyQuestion::$description, SurveyQuestion::$owner, SurveyQuestion::$questiontext, SurveyQuestion::$title, and SurveyQuestion::SurveyQuestion().
{
$this->SurveyQuestion($title, $description, $author, $questiontext, $owner);
$this->maxchars = 0;
$this->textwidth = 50;
$this->textheight = 5;
}
Here is the call graph for this function:| SurveyTextQuestion::syncWithOriginal | ( | ) |
Reimplemented from SurveyQuestion.
Definition at line 358 of file class.SurveyTextQuestion.php.
References 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_text SET maxchars = %s, width = %s, height = %s WHERE question_fi = %s",
$ilDB->quote($this->getMaxChars() . ""),
$ilDB->quote($this->getTextWidth() . ""),
$ilDB->quote($this->getTextHeight() . ""),
$ilDB->quote($this->original_id . "")
);
$result = $ilDB->query($query);
}
parent::syncWithOriginal();
}
Here is the call graph for this function:| SurveyTextQuestion::toXML | ( | $ | a_include_header = TRUE, |
|
| $ | obligatory_state = "" | |||
| ) |
Returns an xml representation of the question.
Returns an xml representation of the question
Definition at line 283 of file class.SurveyTextQuestion.php.
References insertXML().
{
include_once("./classes/class.ilXmlWriter.php");
$a_xml_writer = new ilXmlWriter;
$a_xml_writer->xmlHeader();
$this->insertXML($a_xml_writer, $a_include_header, $obligatory_state);
$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:| SurveyTextQuestion::usableForPrecondition | ( | ) |
Returns if the question is usable for preconditions.
Returns if the question is usable for preconditions
Reimplemented from SurveyQuestion.
Definition at line 656 of file class.SurveyTextQuestion.php.
{
return FALSE;
}
| SurveyTextQuestion::$maxchars |
Definition at line 40 of file class.SurveyTextQuestion.php.
Referenced by saveToDb(), saveUserInput(), and setMaxChars().
| SurveyTextQuestion::$textheight |
Definition at line 42 of file class.SurveyTextQuestion.php.
| SurveyTextQuestion::$textwidth |
Definition at line 41 of file class.SurveyTextQuestion.php.
1.7.1