ILIAS  Release_3_10_x_branch Revision 61812
 All Data Structures Namespaces Files Functions Variables Groups Pages
assTextSubset Class Reference

Class for TextSubset questions. More...

+ Inheritance diagram for assTextSubset:
+ Collaboration diagram for assTextSubset:

Public Member Functions

 assTextSubset ($title="", $comment="", $author="", $owner=-1, $question="")
 assTextSubset constructor
 isComplete ()
 Returns true, if a TextSubset question is complete for use.
 saveToDb ($original_id="")
 Saves a assTextSubset object to a database.
 loadFromDb ($question_id)
 Loads a assTextSubset object from a database.
 addAnswer ($answertext, $points, $answerorder)
 Adds an answer to the question.
 duplicate ($for_test=true, $title="", $author="", $owner="")
 Duplicates an assTextSubsetQuestion.
 copyObject ($target_questionpool, $title="")
 Copies an assTextSubset object.
 getAnswerCount ()
 Returns the number of answers.
 getAnswer ($index=0)
 Returns an answer.
 deleteAnswer ($index=0)
 Deletes an answer.
 flushAnswers ()
 Deletes all answers.
 getMaximumPoints ()
 Returns the maximum points, a learner can reach answering the question.
getAvailableAnswers ()
 Returns the available answers for the question.
 isAnswerCorrect ($answers, $answer)
 Determines wheather a given answer is correct or not.
 getTextRating ()
 Returns the rating option for text comparisons.
 setTextRating ($a_text_rating)
 Sets the rating option for text comparisons.
 calculateReachedPoints ($active_id, $pass=NULL)
 Returns the points, a learner has reached answering the question.
 setCorrectAnswers ($a_correct_answers)
 Sets the number of correct answers needed to solve the question.
 getCorrectAnswers ()
 Returns the number of correct answers needed to solve the question.
 saveWorkingData ($active_id, $pass=NULL)
 Saves the learners input of the question to the database.
 getQuestionType ()
 Returns the question type of the question.
joinAnswers ()
 Returns the answers of the question as a comma separated string.
 getMaxTextboxWidth ()
 Returns the maximum width needed for the answer textboxes.
 getAdditionalTableName ()
 Returns the name of the additional question data table in the database.
 getAnswerTableName ()
 Returns the name of the answer table in the database.
 getRTETextWithMediaObjects ()
 Collects all text in the question which could contain media objects which were created with the Rich Text Editor.
 setExportDetailsXLS (&$worksheet, $startrow, $active_id, $pass, &$format_title, &$format_bold)
 Creates an Excel worksheet for the detailed cumulated results of this question.
- Public Member Functions inherited from assQuestion
 assQuestion ($title="", $comment="", $author="", $owner=-1, $question="")
 assQuestion constructor
 _assQuestion ()
 fromXML (&$item, &$questionpool_id, &$tst_id, &$tst_object, &$question_counter, &$import_mapping)
 Creates a question from a QTI file.
 toXML ($a_include_header=true, $a_include_binary=true, $a_shuffle=false, $test_output=false, $force_image_references=false)
 Returns a QTI xml representation of the question.
 questionTitleExists ($questionpool_id, $title)
 Returns TRUE if the question title exists in the database.
 setTitle ($title="")
 Sets the title string.
 setId ($id=-1)
 Sets the id.
 setTestId ($id=-1)
 Sets the test id.
 setComment ($comment="")
 Sets the comment.
 setOutputType ($outputType=OUTPUT_HTML)
 Sets the output type.
 setShuffle ($shuffle=true)
 Sets the shuffle flag.
 setEstimatedWorkingTime ($hour=0, $min=0, $sec=0)
 Sets the estimated working time of a question.
 keyInArray ($searchkey, $array)
 returns TRUE if the key occurs in an array
 setAuthor ($author="")
 Sets the authors name.
 setOwner ($owner="")
 Sets the creator/owner.
 getTitle ()
 Gets the title string.
 getId ()
 Gets the id.
 getShuffle ()
 Gets the shuffle flag.
 getTestId ()
 Gets the test id.
 getComment ()
 Gets the comment.
 getOutputType ()
 Gets the output type.
 supportsJavascriptOutput ()
 Returns true if the question type supports JavaScript output.
 getEstimatedWorkingTime ()
 Gets the estimated working time of a question.
 getAuthor ()
 Gets the authors name.
 getOwner ()
 Gets the creator/owner.
 getObjId ()
 Get the object id of the container object.
 setObjId ($obj_id=0)
 Set the object id of the container object.
 createPageObject ()
 create page object of question
 insertIntoTest ($test_id)
 Insert the question into a test.
 _getMaximumPoints ($question_id)
 Returns the maximum points, a learner can reach answering the question.
_getQuestionInfo ($question_id)
 Returns question information from the database.
 _getSuggestedSolutionCount ($question_id)
 Returns the number of suggested solutions associated with a question.
_getSuggestedSolution ($question_id, $subquestion_index=0)
 Returns a suggested solution for a given subquestion index.
 _getReachedPoints ($active_id, $question_id, $pass=NULL)
 Returns the points, a learner has reached answering the question.
 getReachedPoints ($active_id, $pass=NULL)
 Returns the points, a learner has reached answering the question.
 _updateTestPassResults ($active_id, $pass)
 logAction ($logtext="", $active_id="", $question_id="")
 Logs an action into the Test&Assessment log.
 _logAction ($logtext="", $active_id="", $question_id="")
 Logs an action into the Test&Assessment log.
 moveUploadedMediaFile ($file, $name)
 Move an uploaded media file to an public accessible temp dir to present it.
 getJavaPath ()
 Returns the image path for web accessable images of a question.
 getImagePath ()
 Returns the image path for web accessable images of a question.
 getFlashPath ()
 Returns the image path for web accessable flash files of a question.
 getJavaPathWeb ()
 Returns the web image path for web accessable java applets of a question.
 getImagePathWeb ()
 Returns the web image path for web accessable images of a question.
 getFlashPathWeb ()
 Returns the web image path for web accessable flash applications of a question.
getSolutionValues ($active_id, $pass=NULL)
 Loads solutions of a given user from the database an returns it.
 isInUse ($question_id="")
 Checks whether the question is in use or not.
 isClone ($question_id="")
 Checks whether the question is a clone of another question or not.
 pcArrayShuffle ($array)
 Shuffles the values of a given array.
 getQuestionTypeFromDb ($question_id)
 get question type for question id
 deleteAnswers ($question_id)
 Deletes datasets from answers tables.
 deleteAdditionalTableData ($question_id)
 Deletes datasets from the additional question table in the database.
 delete ($question_id)
 Deletes a question and all materials from the database.
 getTotalAnswers ()
 get total number of answers
 _getTotalAnswers ($a_q_id)
 get number of answers for question id (static) note: do not use $this inside this method
 _getTotalRightAnswers ($a_q_id)
 get number of answers for question id (static) note: do not use $this inside this method
 _getTitle ($a_q_id)
 Returns the title of a question.
 copyXHTMLMediaObjectsOfQuestion ($a_q_id)
 syncXHTMLMediaObjectsOfQuestion ()
 copyPageOfQuestion ($a_q_id)
 getPageOfQuestion ()
 _getQuestionType ($question_id)
 Returns the question type of a question with a given id.
 _getQuestionTitle ($question_id)
 Returns the question title of a question with a given id.
 setOriginalId ($original_id)
 getOriginalId ()
 deleteSuggestedSolutions ()
 Deletes all suggestes solutions in the database.
 getSuggestedSolution ($subquestion_index=0)
 Returns a suggested solution for a given subquestion index.
 getSuggestedSolutionTitle ($subquestion_index=0)
 Returns the title of a suggested solution at a given subquestion_index.
 setSuggestedSolution ($solution_id="", $subquestion_index=0, $is_import=false)
 Sets a suggested solution for the question.
 saveSuggestedSolution ($solution_id="", $subquestion_index=0)
 Saves a suggested solution for the question.
 _resolveInternalLink ($internal_link)
 _resolveIntLinks ($question_id)
 _getInternalLinkHref ($target="")
 _getOriginalId ($question_id)
 Returns the original id of a question.
 syncWithOriginal ()
 createRandomSolution ($test_id, $user_id)
 _questionExists ($question_id)
 Returns true if the question already exists in the database.
_instanciateQuestion ($question_id)
 Creates an instance of a question with a given question id.
 getPoints ()
 Returns the maximum available points for the question.
 setPoints ($a_points)
 Sets the maximum available points for the question.
 getSolutionMaxPass ($active_id)
 Returns the maximum pass a users question solution.
 _getSolutionMaxPass ($question_id, $active_id)
 Returns the maximum pass a users question solution.
 _isWriteable ($question_id, $user_id)
 Returns true if the question is writeable by a certain user.
 _isUsedInRandomTest ($question_id="")
 Checks whether the question is used in a random test or not.
 calculateReachedPoints ($active_id, $pass=NULL, $points=0)
 Returns the points, a learner has reached answering the question.
 _isWorkedThrough ($active_id, $question_id, $pass=NULL)
 Returns true if the question was worked through in the given pass.
 getMultilineAnswerSetting ()
 setMultilineAnswerSetting ($a_setting=0)
 _areAnswered ($a_user_id, $a_question_ids)
 Checks if an array of question ids is answered by an user or not.
 isHTML ($a_text)
 Checks if a given string contains HTML or not.
 prepareTextareaOutput ($txt_output, $prepare_for_latex_output=FALSE)
 Prepares a string for a text area output in tests.
 QTIMaterialToString ($a_material)
 Reads an QTI material tag an creates a text string.
 addQTIMaterial (&$a_xml_writer, $a_material, $close_material_tag=TRUE, $add_mobs=TRUE)
 Creates a QTI material tag from a plain text or xhtml text.
 createNewImageFileName ($image_filename)
 _setReachedPoints ($active_id, $question_id, $points, $maxpoints, $pass=NULL)
 Sets the points, a learner has reached answering the question Additionally objective results are updated.
 getQuestion ()
 Gets the question text.
 setQuestion ($question="")
 Sets the question text.
 getQuestionTypeID ()
 Returns the question type of the question.
 saveFeedbackGeneric ($correctness, $feedback)
 Saves generic feedback to the database.
 getFeedbackGeneric ($correctness)
 Returns the generic feedback for a given question state.
 duplicateFeedbackGeneric ($original_id)
 Duplicates the generic feedback of a question.
 syncFeedbackGeneric ()
 cleanupMediaObjectUsage ()
 synchronises appearances of media objects in the question with media object usage table
getInstances ()
 Gets all instances of the question.
 _needsManualScoring ($question_id)
 getActiveUserData ($active_id)
 Returns the user id and the test id for a given active id.
_instanciateQuestionGUI ($question_id)
 Creates an instance of a question gui with a given question id.

Data Fields

 $answers
 $correctanswers
 $text_rating
- Data Fields inherited from assQuestion
 $id
 $title
 $comment
 $owner
 $author
 $question
 $points
 $est_working_time
 $shuffle
 $test_id
 $obj_id
 $ilias
 $tpl
 $lng
 $domxml
 $outputType
 $suggested_solutions
 $original_id

Additional Inherited Members

- Static Public Member Functions inherited from assQuestion
static _includeClass ($question_type, $gui=0)
 Include the php class file for a given question type.
static _getQuestionTypeName ($type_tag)
 Return the translation for a given question type tag.
- Protected Member Functions inherited from assQuestion
 deletePageOfQuestion ($question_id)
 Deletes the page object of a question with a given ID.

Detailed Description

Class for TextSubset questions.

assTextSubset is a class for TextSubset questions. To solve a TextSubset question, a learner has to enter a TextSubsetal value in a defined range

Author
Helmut Schottmüller helmu.nosp@m.t.sc.nosp@m.hottm.nosp@m.uell.nosp@m.er@ma.nosp@m.c.co.nosp@m.m
Nina Gharib nina@.nosp@m.wgse.nosp@m.rve.d.nosp@m.e
Version
Id:
class.assTextSubset.php 19616 2009-04-14 11:45:19Z hschottm

Definition at line 37 of file class.assTextSubset.php.

Member Function Documentation

assTextSubset::addAnswer (   $answertext,
  $points,
  $answerorder 
)

Adds an answer to the question.

Adds an answer to the question

public

Definition at line 302 of file class.assTextSubset.php.

References assQuestion\$points.

{
include_once "./Modules/TestQuestionPool/classes/class.assAnswerSimple.php";
array_push($this->answers, new ASS_AnswerSimple($answertext, $points, $answerorder));
}
assTextSubset::assTextSubset (   $title = "",
  $comment = "",
  $author = "",
  $owner = -1,
  $question = "" 
)

assTextSubset constructor

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

Parameters
string$titleA title string to describe the question
string$commentA comment string to describe the question
string$authorA string containing the name of the questions author
integer$ownerA TextSubsetal ID to identify the owner/creator
string$questionThe question string of the TextSubset question public
See Also
assQuestion:assQuestion()

Definition at line 79 of file class.assTextSubset.php.

References assQuestion\$author, assQuestion\$comment, assQuestion\$owner, assQuestion\$question, assQuestion\$title, and assQuestion\assQuestion().

{
$this->answers = array();
$this->correctanswers = 0;
}

+ Here is the call graph for this function:

assTextSubset::calculateReachedPoints (   $active_id,
  $pass = NULL 
)

Returns the points, a learner has reached answering the question.

Returns the points, a learner has reached answering the question The points are calculated from the given answers including checks for all special scoring options in the test container.

Parameters
integer$user_idThe database ID of the learner
integer$test_idThe database Id of the test containing the question public

Definition at line 616 of file class.assTextSubset.php.

References $data, $pass, assQuestion\$points, $result, getAvailableAnswers(), assQuestion\getId(), assQuestion\getSolutionMaxPass(), and isAnswerCorrect().

{
global $ilDB;
$available_answers =& $this->getAvailableAnswers();
$found_counter = 0;
if (is_null($pass))
{
$pass = $this->getSolutionMaxPass($active_id);
}
$query = sprintf("SELECT * FROM tst_solutions WHERE active_fi = %s AND question_fi = %s AND pass = %s",
$ilDB->quote($active_id . ""),
$ilDB->quote($this->getId() . ""),
$ilDB->quote($pass . "")
);
$result = $ilDB->query($query);
$points = 0;
while ($data = $result->fetchRow(MDB2_FETCHMODE_ASSOC))
{
$enteredtext = $data["value1"];
$index = $this->isAnswerCorrect($available_answers, $enteredtext);
if ($index !== FALSE)
{
unset($available_answers[$index]);
$points += $this->answers[$index]->getPoints();
}
}
return $points;
}

+ Here is the call graph for this function:

assTextSubset::copyObject (   $target_questionpool,
  $title = "" 
)

Copies an assTextSubset object.

Copies an assTextSubset object

public

Definition at line 368 of file class.assTextSubset.php.

References assQuestion\$original_id, assQuestion\$title, assQuestion\_getOriginalId(), and assQuestion\getObjId().

{
if ($this->id <= 0)
{
// The question has not been saved. It cannot be duplicated
return;
}
// duplicate the question in database
$clone = $this;
include_once ("./Modules/TestQuestionPool/classes/class.assQuestion.php");
$clone->id = -1;
$source_questionpool = $this->getObjId();
$clone->setObjId($target_questionpool);
if ($title)
{
$clone->setTitle($title);
}
$clone->saveToDb();
// copy question page content
$clone->copyPageOfQuestion($original_id);
// copy XHTML media objects
$clone->copyXHTMLMediaObjectsOfQuestion($original_id);
// duplicate the generic feedback
$clone->duplicateFeedbackGeneric($original_id);
return $clone->id;
}

+ Here is the call graph for this function:

assTextSubset::deleteAnswer (   $index = 0)

Deletes an answer.

Deletes an answer with a given index. The index of the first answer is 0, the index of the second answer is 1 and so on.

Parameters
integer$indexA nonnegative index of the n-th answer public
See Also
$answers

Definition at line 442 of file class.assTextSubset.php.

{
if ($index < 0) return;
if (count($this->answers) < 1) return;
if ($index >= count($this->answers)) return;
unset($this->answers[$index]);
$this->answers = array_values($this->answers);
for ($i = 0; $i < count($this->answers); $i++)
{
if ($this->answers[$i]->getOrder() > $index)
{
$this->answers[$i]->setOrder($i);
}
}
}
assTextSubset::duplicate (   $for_test = true,
  $title = "",
  $author = "",
  $owner = "" 
)

Duplicates an assTextSubsetQuestion.

Duplicates an assTextSubsetQuestion

public

Definition at line 315 of file class.assTextSubset.php.

References assQuestion\$author, assQuestion\$original_id, assQuestion\$owner, assQuestion\$title, assQuestion\_getOriginalId(), and assQuestion\getId().

{
if ($this->id <= 0)
{
// The question has not been saved. It cannot be duplicated
return;
}
// duplicate the question in database
$this_id = $this->getId();
$clone = $this;
include_once ("./Modules/TestQuestionPool/classes/class.assQuestion.php");
$clone->id = -1;
if ($title)
{
$clone->setTitle($title);
}
if ($author)
{
$clone->setAuthor($author);
}
if ($owner)
{
$clone->setOwner($owner);
}
if ($for_test)
{
$clone->saveToDb($original_id);
}
else
{
$clone->saveToDb();
}
// copy question page content
$clone->copyPageOfQuestion($this_id);
// copy XHTML media objects
$clone->copyXHTMLMediaObjectsOfQuestion($this_id);
// duplicate the generic feedback
$clone->duplicateFeedbackGeneric($this_id);
return $clone->id;
}

+ Here is the call graph for this function:

assTextSubset::flushAnswers ( )

Deletes all answers.

Deletes all answers

public

See Also
$answers

Definition at line 466 of file class.assTextSubset.php.

{
$this->answers = array();
}
assTextSubset::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

Reimplemented from assQuestion.

Definition at line 802 of file class.assTextSubset.php.

{
return "qpl_question_textsubset";
}
assTextSubset::getAnswer (   $index = 0)

Returns an answer.

Returns an answer with a given index. The index of the first answer is 0, the index of the second answer is 1 and so on.

Parameters
integer$indexA nonnegative index of the n-th answer
Returns
object ASS_AnswerSimple-Object containing the answer public
See Also
$answers

Definition at line 423 of file class.assTextSubset.php.

{
if ($index < 0) return NULL;
if (count($this->answers) < 1) return NULL;
if ($index >= count($this->answers)) return NULL;
return $this->answers[$index];
}
assTextSubset::getAnswerCount ( )

Returns the number of answers.

Returns the number of answers

Returns
integer The number of answers of the TextSubset question public
See Also
$ranges

Definition at line 407 of file class.assTextSubset.php.

{
return count($this->answers);
}
assTextSubset::getAnswerTableName ( )

Returns the name of the answer table in the database.

Returns the name of the answer table in the database

Returns
string The answer table name public

Reimplemented from assQuestion.

Definition at line 815 of file class.assTextSubset.php.

{
return "qpl_answer_textsubset";
}
& assTextSubset::getAvailableAnswers ( )

Returns the available answers for the question.

Returns the available answers for the question

private

See Also
$answers

Definition at line 506 of file class.assTextSubset.php.

Referenced by calculateReachedPoints().

{
$available_answers = array();
foreach ($this->answers as $answer)
{
array_push($available_answers, $answer->getAnswertext());
}
return $available_answers;
}

+ Here is the caller graph for this function:

assTextSubset::getCorrectAnswers ( )

Returns the number of correct answers needed to solve the question.

Returns the number of correct answers needed to solve the question

Returns
integer The number of correct answers public

Definition at line 670 of file class.assTextSubset.php.

References $correctanswers.

Referenced by getMaximumPoints(), and saveToDb().

{
}

+ Here is the caller graph for this function:

assTextSubset::getMaximumPoints ( )

Returns the maximum points, a learner can reach answering the question.

Returns the maximum points, a learner can reach answering the question

public

See Also
$points

Reimplemented from assQuestion.

Definition at line 479 of file class.assTextSubset.php.

References assQuestion\$points, and getCorrectAnswers().

Referenced by isComplete(), and saveToDb().

{
$points = array();
foreach ($this->answers as $answer)
{
if ($answer->getPoints() > 0)
{
array_push($points, $answer->getPoints());
}
}
rsort($points, SORT_NUMERIC);
$maxpoints = 0;
for ($counter = 0; $counter < $this->getCorrectAnswers(); $counter++)
{
$maxpoints += $points[$counter];
}
return $maxpoints;
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

assTextSubset::getMaxTextboxWidth ( )

Returns the maximum width needed for the answer textboxes.

Returns the maximum width needed for the answer textboxes

Returns
integer Maximum textbox width public

Definition at line 783 of file class.assTextSubset.php.

{
$maxwidth = 0;
foreach ($this->answers as $answer)
{
$len = strlen($answer->getAnswertext());
if ($len > $maxwidth) $maxwidth = $len;
}
return $maxwidth + 3;
}
assTextSubset::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 assQuestion.

Definition at line 748 of file class.assTextSubset.php.

{
return "assTextSubset";
}
assTextSubset::getRTETextWithMediaObjects ( )

Collects all text in the question which could contain media objects which were created with the Rich Text Editor.

Reimplemented from assQuestion.

Definition at line 824 of file class.assTextSubset.php.

assTextSubset::getTextRating ( )

Returns the rating option for text comparisons.

Returns the rating option for text comparisons

Returns
string The rating option for text comparisons
See Also
$text_rating Public

Definition at line 572 of file class.assTextSubset.php.

References $text_rating.

Referenced by isAnswerCorrect(), and saveToDb().

{
}

+ Here is the caller graph for this function:

assTextSubset::isAnswerCorrect (   $answers,
  $answer 
)

Determines wheather a given answer is correct or not.

Returns the index of the found answer, if the given answer is in the set of correct answers and matchess the matching options, otherwise FALSE is returned

Parameters
array$answersAn array containing the correct answers
string$answerThe text of the given answer
Returns
mixed The index of the correct answer, FALSE otherwise public

Definition at line 528 of file class.assTextSubset.php.

References $answers, $result, getTextRating(), ilStr\strToLower(), TEXTGAP_RATING_CASEINSENSITIVE, TEXTGAP_RATING_CASESENSITIVE, TEXTGAP_RATING_LEVENSHTEIN1, TEXTGAP_RATING_LEVENSHTEIN2, TEXTGAP_RATING_LEVENSHTEIN3, TEXTGAP_RATING_LEVENSHTEIN4, and TEXTGAP_RATING_LEVENSHTEIN5.

Referenced by calculateReachedPoints().

{
include_once "./Services/Utilities/classes/class.ilStr.php";
$result = 0;
$textrating = $this->getTextRating();
foreach ($answers as $key => $value)
{
switch ($textrating)
{
if (strcmp(ilStr::strToLower($value), ilStr::strToLower($answer)) == 0) return $key;
break;
if (strcmp($value, $answer) == 0) return $key;
break;
if (levenshtein($value, $answer) <= 1) return $key;
break;
if (levenshtein($value, $answer) <= 2) return $key;
break;
if (levenshtein($value, $answer) <= 3) return $key;
break;
if (levenshtein($value, $answer) <= 4) return $key;
break;
if (levenshtein($value, $answer) <= 5) return $key;
break;
}
}
return FALSE;
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

assTextSubset::isComplete ( )

Returns true, if a TextSubset question is complete for use.

Returns true, if a TextSubset question is complete for use

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

Reimplemented from assQuestion.

Definition at line 100 of file class.assTextSubset.php.

References getMaximumPoints().

Referenced by saveToDb().

{
if (($this->title) and ($this->author) and ($this->question) and (count($this->answers) >= $this->correctanswers) and ($this->getMaximumPoints() > 0))
{
return true;
}
else
{
return false;
}
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

& assTextSubset::joinAnswers ( )

Returns the answers of the question as a comma separated string.

Returns the answers of the question as a comma separated string

Returns
string The answer string public

Definition at line 761 of file class.assTextSubset.php.

{
$join = array();
foreach ($this->answers as $answer)
{
if (!is_array($join[$answer->getPoints() . ""]))
{
$join[$answer->getPoints() . ""] = array();
}
array_push($join[$answer->getPoints() . ""], $answer->getAnswertext());
}
return $join;
}
assTextSubset::loadFromDb (   $question_id)

Loads a assTextSubset object from a database.

Loads a assTextSubset object from a database (experimental)

Parameters
object$dbA pear DB object
integer$question_idA unique key which defines the multiple choice test in the database public

Reimplemented from assQuestion.

Definition at line 252 of file class.assTextSubset.php.

References $data, $result, ilRTE\_replaceMediaObjectImageSrc(), and assQuestion\setEstimatedWorkingTime().

{
global $ilDB;
$query = sprintf("SELECT qpl_questions.*, qpl_question_textsubset.* FROM qpl_questions, qpl_question_textsubset WHERE question_id = %s AND qpl_questions.question_id = qpl_question_textsubset.question_fi",
$ilDB->quote($question_id)
);
$result = $ilDB->query($query);
if ($result->numRows() == 1)
{
$data = $result->fetchRow(MDB2_FETCHMODE_OBJECT);
$this->id = $question_id;
$this->title = $data->title;
$this->comment = $data->comment;
$this->solution_hint = $data->solution_hint;
$this->original_id = $data->original_id;
$this->obj_id = $data->obj_fi;
$this->author = $data->author;
$this->owner = $data->owner;
$this->points = $data->points;
include_once("./Services/RTE/classes/class.ilRTE.php");
$this->question = ilRTE::_replaceMediaObjectImageSrc($data->question_text, 1);
$this->correctanswers = $data->correctanswers;
$this->text_rating = $data->textgap_rating;
$this->setEstimatedWorkingTime(substr($data->working_time, 0, 2), substr($data->working_time, 3, 2), substr($data->working_time, 6, 2));
$query = sprintf("SELECT * FROM qpl_answer_textsubset WHERE question_fi = %s ORDER BY aorder ASC",
$ilDB->quote($question_id)
);
$result = $ilDB->query($query);
include_once "./Modules/TestQuestionPool/classes/class.assAnswerSimple.php";
if ($result->numRows() > 0)
{
while ($data = $result->fetchRow(MDB2_FETCHMODE_ASSOC))
{
array_push($this->answers, new ASS_AnswerSimple($data["answertext"], $data["points"], $data["aorder"]));
}
}
}
parent::loadFromDb($question_id);
}

+ Here is the call graph for this function:

assTextSubset::saveToDb (   $original_id = "")

Saves a assTextSubset object to a database.

Saves a assTextSubset object to a database (experimental)

Parameters
object$dbA pear DB object public

Reimplemented from assQuestion.

Definition at line 120 of file class.assTextSubset.php.

References assQuestion\$ilias, assQuestion\$original_id, $result, ilRTE\_replaceMediaObjectImageSrc(), assQuestion\createPageObject(), getCorrectAnswers(), assQuestion\getEstimatedWorkingTime(), getMaximumPoints(), assQuestion\getQuestionTypeID(), assQuestion\getTestId(), getTextRating(), assQuestion\insertIntoTest(), and isComplete().

{
global $ilDB;
$complete = 0;
if ($this->isComplete())
{
$complete = 1;
}
$estw_time = $this->getEstimatedWorkingTime();
$estw_time = sprintf("%02d:%02d:%02d", $estw_time['h'], $estw_time['m'], $estw_time['s']);
{
$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");
if ($this->id == -1)
{
// Neuen Datensatz schreiben
$now = getdate();
$question_type = $this->getQuestionTypeID();
$created = sprintf("%04d%02d%02d%02d%02d%02d", $now['year'], $now['mon'], $now['mday'], $now['hours'], $now['minutes'], $now['seconds']);
$query = sprintf("INSERT INTO qpl_questions (question_id, question_type_fi, obj_fi, title, comment, author, owner, question_text, points, working_time, complete, created, original_id, TIMESTAMP) VALUES (NULL, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, NULL)",
$ilDB->quote($question_type),
$ilDB->quote($this->obj_id),
$ilDB->quote($this->title),
$ilDB->quote($this->comment),
$ilDB->quote($this->author),
$ilDB->quote($this->owner),
$ilDB->quote(ilRTE::_replaceMediaObjectImageSrc($this->question, 0)),
$ilDB->quote($this->getMaximumPoints() . ""),
$ilDB->quote($estw_time),
$ilDB->quote("$complete"),
$ilDB->quote($created),
);
$result = $ilDB->query($query);
if (PEAR::isError($result))
{
global $ilias;
$ilias->raiseError($result->getMessage());
}
else
{
$this->id = $ilDB->getLastInsertId();
$query = sprintf("INSERT INTO qpl_question_textsubset (question_fi, textgap_rating, correctanswers) VALUES (%s, %s, %s)",
$ilDB->quote($this->id . ""),
$ilDB->quote($this->getTextRating() . ""),
$ilDB->quote($this->getCorrectAnswers() . "")
);
$ilDB->query($query);
// create page object of question
$this->createPageObject();
// Falls die Frage in einen Test eingefügt werden soll, auch diese Verbindung erstellen
if ($this->getTestId() > 0)
{
$this->insertIntoTest($this->getTestId());
}
}
}
else
{
// Vorhandenen Datensatz aktualisieren
$query = sprintf("UPDATE qpl_questions SET obj_fi = %s, title = %s, comment = %s, author = %s, question_text = %s, points = %s, working_time=%s, complete = %s WHERE question_id = %s",
$ilDB->quote($this->obj_id. ""),
$ilDB->quote($this->title),
$ilDB->quote($this->comment),
$ilDB->quote($this->author),
$ilDB->quote(ilRTE::_replaceMediaObjectImageSrc($this->question, 0)),
$ilDB->quote($this->getMaximumPoints() . ""),
$ilDB->quote($estw_time),
$ilDB->quote("$complete"),
$ilDB->quote($this->id)
);
$result = $ilDB->query($query);
$query = sprintf("UPDATE qpl_question_textsubset SET textgap_rating = %s, correctanswers = %s WHERE question_fi = %s",
$ilDB->quote($this->getTextRating() . ""),
$ilDB->quote($this->getCorrectAnswers() . ""),
$ilDB->quote($this->id . "")
);
$result = $ilDB->query($query);
}
if (PEAR::isError($result))
{
global $ilias;
$ilias->raiseError($result->getMessage());
}
else
{
// Write Ranges to the database
// 1. delete old ranges
$query = sprintf("DELETE FROM qpl_answer_textsubset WHERE question_fi = %s",
$ilDB->quote($this->id)
);
$result = $ilDB->query($query);
// 2. write ranges
foreach ($this->answers as $key => $value)
{
$answer_obj = $this->answers[$key];
$query = sprintf("INSERT INTO qpl_answer_textsubset (answer_id, question_fi, answertext, points, aorder) VALUES (NULL, %s, %s, %s, %s)",
$ilDB->quote($this->id),
$ilDB->quote($answer_obj->getAnswertext()),
$ilDB->quote($answer_obj->getPoints() . ""),
$ilDB->quote($answer_obj->getOrder() . "")
);
$answer_result = $ilDB->query($query);
}
}
}

+ Here is the call graph for this function:

assTextSubset::saveWorkingData (   $active_id,
  $pass = NULL 
)

Saves the learners input of the question to the database.

  Saves the learners input of the question to the database

  @param integer $test_id The database id of the test containing this question
Returns
boolean Indicates the save status (true if saved successful, false otherwise) public
See Also
$ranges

Reimplemented from assQuestion.

Definition at line 685 of file class.assTextSubset.php.

References $pass, $result, ilObjAssessmentFolder\_enabledAssessmentLogging(), ilObjAssessmentFolder\_getLogLanguage(), ilObjTest\_getPass(), assQuestion\getId(), and assQuestion\logAction().

{
global $ilDB;
global $ilUser;
if (is_null($pass))
{
include_once "./Modules/Test/classes/class.ilObjTest.php";
$pass = ilObjTest::_getPass($active_id);
}
$entered_values = 0;
$query = sprintf("DELETE FROM tst_solutions WHERE active_fi = %s AND question_fi = %s AND pass = %s",
$ilDB->quote($active_id . ""),
$ilDB->quote($this->getId() . ""),
$ilDB->quote($pass . "")
);
$result = $ilDB->query($query);
foreach ($_POST as $key => $value)
{
if (preg_match("/^TEXTSUBSET_(\d+)/", $key, $matches))
{
if (strlen($value))
{
$query = sprintf("INSERT INTO tst_solutions (solution_id, active_fi, question_fi, value1, value2, pass, TIMESTAMP) VALUES (NULL, %s, %s, %s, NULL, %s, NULL)",
$ilDB->quote($active_id),
$ilDB->quote($this->getId()),
$ilDB->quote(trim($value)),
$ilDB->quote($pass . "")
);
$result = $ilDB->query($query);
$entered_values++;
}
}
}
if ($entered_values)
{
include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
{
$this->logAction($this->lng->txtlng("assessment", "log_user_entered_values", ilObjAssessmentFolder::_getLogLanguage()), $active_id, $this->getId());
}
}
else
{
include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
{
$this->logAction($this->lng->txtlng("assessment", "log_user_not_entered_values", ilObjAssessmentFolder::_getLogLanguage()), $active_id, $this->getId());
}
}
return true;
}

+ Here is the call graph for this function:

assTextSubset::setCorrectAnswers (   $a_correct_answers)

Sets the number of correct answers needed to solve the question.

Sets the number of correct answers needed to solve the question

Parameters
integer$a_correct_anwersThe number of correct answers public

Definition at line 657 of file class.assTextSubset.php.

{
$this->correctanswers = $a_correct_answers;
}
assTextSubset::setExportDetailsXLS ( $worksheet,
  $startrow,
  $active_id,
  $pass,
$format_title,
$format_bold 
)

Creates an Excel worksheet for the detailed cumulated results of this question.

Parameters
object$worksheetReference to the parent excel worksheet
object$startrowStartrow of the output in the excel worksheet
object$active_idActive id of the participant
object$passTest pass
object$format_titleExcel title format
object$format_boldExcel bold format
array$eval_dataCumulated evaluation data public

Reimplemented from assQuestion.

Definition at line 841 of file class.assTextSubset.php.

References $pass, ilExcelUtils\_convert_text(), assQuestion\getSolutionValues(), and assQuestion\getTitle().

{
include_once ("./classes/class.ilExcelUtils.php");
$solutions = $this->getSolutionValues($active_id, $pass);
$worksheet->writeString($startrow, 0, ilExcelUtils::_convert_text($this->lng->txt($this->getQuestionType())), $format_title);
$worksheet->writeString($startrow, 1, ilExcelUtils::_convert_text($this->getTitle()), $format_title);
$i = 1;
foreach ($solutions as $solution)
{
$worksheet->write($startrow + $i, 0, ilExcelUtils::_convert_text($solution["value1"]));
$i++;
}
return $startrow + $i + 1;
}

+ Here is the call graph for this function:

assTextSubset::setTextRating (   $a_text_rating)

Sets the rating option for text comparisons.

Sets the rating option for text comparisons

Parameters
string$a_textgap_ratingThe rating option for text comparisons
See Also
$textgap_rating Public

Definition at line 586 of file class.assTextSubset.php.

References TEXTGAP_RATING_CASEINSENSITIVE, TEXTGAP_RATING_CASESENSITIVE, TEXTGAP_RATING_LEVENSHTEIN1, TEXTGAP_RATING_LEVENSHTEIN2, TEXTGAP_RATING_LEVENSHTEIN3, TEXTGAP_RATING_LEVENSHTEIN4, and TEXTGAP_RATING_LEVENSHTEIN5.

{
switch ($a_text_rating)
{
$this->text_rating = $a_text_rating;
break;
default:
$this->text_rating = TEXTGAP_RATING_CASEINSENSITIVE;
break;
}
}

Field Documentation

assTextSubset::$answers

Definition at line 46 of file class.assTextSubset.php.

Referenced by isAnswerCorrect().

assTextSubset::$correctanswers

Definition at line 55 of file class.assTextSubset.php.

Referenced by getCorrectAnswers().

assTextSubset::$text_rating

Definition at line 64 of file class.assTextSubset.php.

Referenced by getTextRating().


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