ILIAS  Release_3_10_x_branch Revision 61812
 All Data Structures Namespaces Files Functions Variables Groups Pages
Public Member Functions | Data Fields
assNumeric Class Reference
Modules/TestQuestionPool

Class for numeric questions. More...

+ Inheritance diagram for assNumeric:
+ Collaboration diagram for assNumeric:

Public Member Functions

 assNumeric ($title="", $comment="", $author="", $owner=-1, $question="")
 assNumeric constructor
 isComplete ()
 Returns true, if a numeric question is complete for use.
 saveToDb ($original_id="")
 Saves a assNumeric object to a database.
 loadFromDb ($question_id)
 Loads a assNumeric object from a database.
 addRange ($lowerlimit=0.0, $upperlimit=0.0, $points=0.0, $order=0)
 Adds a range to the numeric question.
 duplicate ($for_test=true, $title="", $author="", $owner="")
 Duplicates an assNumericQuestion.
 copyObject ($target_questionpool, $title="")
 Copies an assNumeric object.
 getRangeCount ()
 Returns the number of ranges.
 getRange ($index=0)
 Returns a range.
 deleteRange ($index=0)
 Deletes a range.
 flushRanges ()
 Deletes all ranges.
 getMaximumPoints ()
 Returns the maximum points, a learner can reach answering the question.
 getBestRange ()
 Returns the range with the maximum points, a learner can reach answering the question.
 calculateReachedPoints ($active_id, $pass=NULL)
 Returns the points, a learner has reached answering 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.
 getMaxChars ()
 Returns the maximum number of characters for the numeric input field.
 setMaxChars ($maxchars)
 Sets the maximum number of characters for the numeric input field.
 getAdditionalTableName ()
 Returns the name of the additional question data table in the database.
 getRTETextWithMediaObjects ()
 Collects all text in the question which could contain media objects which were created with the Rich Text Editor.
& getRanges ()
 Returns the ranges array.
 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
 getAnswerTableName ()
 Returns the name of the answer table in the database.
 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

 $ranges
 $maxchars
- 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 numeric questions.

assNumeric is a class for numeric questions. To solve a numeric question, a learner has to enter a numerical 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.assNumeric.php 20077 2009-05-26 08:53:38Z hschottm

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

Member Function Documentation

assNumeric::addRange (   $lowerlimit = 0.0,
  $upperlimit = 0.0,
  $points = 0.0,
  $order = 0 
)

Adds a range to the numeric question.

Adds a range to the numeric question. An assNumericRange object will be created and assigned to the array $this->ranges

Parameters
double$lowerlimitThe lower limit of the range
double$upperlimitThe upper limit of the range
double$pointsThe points for entering a number in the correct range
integer$orderThe display order of the range public
See Also
$ranges
assNumericalRange

Definition at line 297 of file class.assNumeric.php.

References assQuestion\$points.

{
$found = -1;
foreach ($this->ranges as $key => $range)
{
if ($range->getOrder() == $order)
{
$found = $order;
}
}
include_once "./Modules/TestQuestionPool/classes/class.assNumericRange.php";
if ($found >= 0)
{
// insert range
$range = new assNumericRange($lowerlimit, $upperlimit, $points, $found);
array_push($this->ranges, $range);
for ($i = $found + 1; $i < count($this->ranges); $i++)
{
$this->ranges[$i] = $this->ranges[$i-1];
}
$this->ranges[$found] = $range;
}
else
{
// append range
$range = new assNumericRange($lowerlimit, $upperlimit, $points, count($this->ranges));
array_push($this->ranges, $range);
}
}
assNumeric::assNumeric (   $title = "",
  $comment = "",
  $author = "",
  $owner = -1,
  $question = "" 
)

assNumeric constructor

The constructor takes possible arguments an creates an instance of the assNumeric 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 numerical ID to identify the owner/creator
string$questionThe question string of the numeric question public
See Also
assQuestion:assQuestion()

Definition at line 70 of file class.assNumeric.php.

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

{
$this->assQuestion($title, $comment, $author, $owner, $question);
$this->ranges = array();
$this->maxchars = 6;
}

+ Here is the call graph for this function:

assNumeric::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 550 of file class.assNumeric.php.

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

{
global $ilDB;
$found_values = array();
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);
$data = $result->fetchRow(MDB2_FETCHMODE_ASSOC);
$enteredvalue = $data["value1"];
//if (!is_numeric($enteredvalue)) return 0;
$points = 0;
foreach ($this->ranges as $key => $range)
{
if ($points == 0)
{
if ($range->contains($enteredvalue))
{
$points = $range->getPoints();
}
}
}
$points = parent::calculateReachedPoints($active_id, $pass = NULL, $points);
return $points;
}

+ Here is the call graph for this function:

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

Copies an assNumeric object.

Copies an assNumeric object

public

Definition at line 392 of file class.assNumeric.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");
$original_id = assQuestion::_getOriginalId($this->id);
$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:

assNumeric::deleteRange (   $index = 0)

Deletes a range.

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

Parameters
integer$indexA nonnegative index of the n-th range public
See Also
$ranges

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

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

Duplicates an assNumericQuestion.

Duplicates an assNumericQuestion

public

Definition at line 339 of file class.assNumeric.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");
$original_id = assQuestion::_getOriginalId($this->id);
$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:

assNumeric::flushRanges ( )

Deletes all ranges.

Deletes all ranges

public

See Also
$ranges

Definition at line 490 of file class.assNumeric.php.

{
$this->ranges = array();
}
assNumeric::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 727 of file class.assNumeric.php.

{
return "qpl_question_numeric";
}
assNumeric::getBestRange ( )

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

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

public

See Also
$points

Definition at line 524 of file class.assNumeric.php.

{
$max = 0;
$bestrange = NULL;
foreach ($this->ranges as $key => $range)
{
if ($range->getPoints() > $max)
{
$max = $range->getPoints();
$bestrange = $range;
}
}
return $bestrange;
}
assNumeric::getMaxChars ( )

Returns the maximum number of characters for the numeric input field.

Returns the maximum number of characters for the numeric input field

Returns
integer The maximum number of characters public

Definition at line 701 of file class.assNumeric.php.

References $maxchars.

Referenced by saveToDb().

{
return $this->maxchars;
}

+ Here is the caller graph for this function:

assNumeric::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 503 of file class.assNumeric.php.

Referenced by isComplete(), and saveToDb().

{
$max = 0;
foreach ($this->ranges as $key => $range)
{
if ($range->getPoints() > $max)
{
$max = $range->getPoints();
}
}
return $max;
}

+ Here is the caller graph for this function:

assNumeric::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 688 of file class.assNumeric.php.

{
return "assNumeric";
}
assNumeric::getRange (   $index = 0)

Returns a range.

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

Parameters
integer$indexA nonnegative index of the n-th range
Returns
object assNumericelRange-Object containing the range public
See Also
$ranges

Definition at line 447 of file class.assNumeric.php.

{
if ($index < 0) return NULL;
if (count($this->ranges) < 1) return NULL;
if ($index >= count($this->ranges)) return NULL;
return $this->ranges[$index];
}
assNumeric::getRangeCount ( )

Returns the number of ranges.

Returns the number of ranges

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

Definition at line 431 of file class.assNumeric.php.

{
return count($this->ranges);
}
& assNumeric::getRanges ( )

Returns the ranges array.

Definition at line 744 of file class.assNumeric.php.

References $ranges.

{
return $this->ranges;
}
assNumeric::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 736 of file class.assNumeric.php.

{
return parent::getRTETextWithMediaObjects();
}
assNumeric::isComplete ( )

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

Returns true, if a numeric question is complete for use

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

Reimplemented from assQuestion.

Definition at line 91 of file class.assNumeric.php.

References getMaximumPoints().

Referenced by saveToDb().

{
if (($this->title) and ($this->author) and ($this->question) and (count($this->ranges)) 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:

assNumeric::loadFromDb (   $question_id)

Loads a assNumeric object from a database.

Loads a assNumeric 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 240 of file class.assNumeric.php.

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

{
global $ilDB;
$query = sprintf("SELECT qpl_questions.*, qpl_question_numeric.* FROM qpl_questions, qpl_question_numeric WHERE question_id = %s AND qpl_questions.question_id = qpl_question_numeric.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->maxchars = $data->maxNumOfChars;
$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_numeric_range WHERE question_fi = %s ORDER BY aorder ASC",
$ilDB->quote($question_id)
);
$result = $ilDB->query($query);
include_once "./Modules/TestQuestionPool/classes/class.assNumericRange.php";
if ($result->numRows() > 0)
{
while ($data = $result->fetchRow(MDB2_FETCHMODE_ASSOC))
{
array_push($this->ranges, new assNumericRange($data["lowerlimit"], $data["upperlimit"], $data["points"], $data["aorder"]));
}
}
}
parent::loadFromDb($question_id);
}

+ Here is the call graph for this function:

assNumeric::saveToDb (   $original_id = "")

Saves a assNumeric object to a database.

Saves a assNumeric object to a database (experimental)

Parameters
object$dbA pear DB object public

Reimplemented from assQuestion.

Definition at line 111 of file class.assNumeric.php.

References assQuestion\$ilias, assQuestion\$original_id, $result, ilRTE\_replaceMediaObjectImageSrc(), assQuestion\createPageObject(), assQuestion\getEstimatedWorkingTime(), getMaxChars(), getMaximumPoints(), assQuestion\getQuestionTypeID(), assQuestion\getTestId(), 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']);
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");
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),
$original_id
);
$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_numeric (question_fi, maxNumOfChars) VALUES (%s, %s)",
$ilDB->quote($this->id . ""),
$ilDB->quote($this->getMaxChars() . "")
);
$ilDB->query($query);
// create page object of question
$this->createPageObject();
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_numeric SET maxNumOfChars = %s WHERE question_fi = %s",
$ilDB->quote($this->getMaxChars() . ""),
$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_numeric_range WHERE question_fi = %s",
$ilDB->quote($this->id)
);
$result = $ilDB->query($query);
// 2. write ranges
foreach ($this->ranges as $key => $range)
{
$query = sprintf("INSERT INTO qpl_numeric_range (range_id, question_fi, lowerlimit, upperlimit, points, aorder, lastchange) VALUES (NULL, %s, %s, %s, %s, %s, NULL)",
$ilDB->quote($this->id),
$ilDB->quote($range->getLowerLimit()),
$ilDB->quote($range->getUpperLimit() . ""),
$ilDB->quote($range->getPoints() . ""),
$ilDB->quote($range->getOrder() . "")
);
$answer_result = $ilDB->query($query);
}
}
parent::saveToDb($original_id);
}

+ Here is the call graph for this function:

assNumeric::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 595 of file class.assNumeric.php.

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

{
global $ilDB;
global $ilUser;
if (is_null($pass))
{
include_once "./Modules/Test/classes/class.ilObjTest.php";
$pass = ilObjTest::_getPass($active_id);
}
$entered_values = 0;
$numeric_result = str_replace(",",".",$_POST["numeric_result"]);
include_once "./Services/Math/classes/class.EvalMath.php";
$math = new EvalMath();
$math->suppress_errors = TRUE;
$result = $math->evaluate($numeric_result);
$returnvalue = true;
if ((($result === FALSE) || ($result === TRUE)) && (strlen($result) > 0))
{
ilUtil::sendInfo($this->lng->txt("err_no_numeric_value"), true);
$returnvalue = false;
}
$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);
$row = $result->fetchRow(MDB2_FETCHMODE_OBJECT);
$update = $row->solution_id;
if ($update)
{
if (strlen($numeric_result))
{
$query = sprintf("UPDATE tst_solutions SET value1 = %s WHERE solution_id = %s",
$ilDB->quote(trim($numeric_result)),
$ilDB->quote($update)
);
$result = $ilDB->query($query);
$entered_values++;
}
else
{
$query = sprintf("DELETE FROM tst_solutions WHERE solution_id = %s",
$ilDB->quote($update)
);
$result = $ilDB->query($query);
}
}
else
{
if (strlen($numeric_result))
{
$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($numeric_result)),
$ilDB->quote($pass . "")
);
$result = $ilDB->query($query);
$entered_values++;
}
}
if ($entered_values)
{
include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
if (ilObjAssessmentFolder::_enabledAssessmentLogging())
{
$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");
if (ilObjAssessmentFolder::_enabledAssessmentLogging())
{
$this->logAction($this->lng->txtlng("assessment", "log_user_not_entered_values", ilObjAssessmentFolder::_getLogLanguage()), $active_id, $this->getId());
}
}
parent::saveWorkingData($active_id, $pass);
return $returnvalue;
}

+ Here is the call graph for this function:

assNumeric::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 761 of file class.assNumeric.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;
$worksheet->writeString($startrow + $i, 0, ilExcelUtils::_convert_text($this->lng->txt("result")), $format_bold);
if (strlen($solutions[0]["value1"]))
{
$worksheet->write($startrow + $i, 1, ilExcelUtils::_convert_text($solutions[0]["value1"]));
}
$i++;
return $startrow + $i + 1;
}

+ Here is the call graph for this function:

assNumeric::setMaxChars (   $maxchars)

Sets the maximum number of characters for the numeric input field.

Sets the maximum number of characters for the numeric input field

Parameters
integer$maxcharsThe maximum number of characters public

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

References $maxchars.

{
$this->maxchars = $maxchars;
}

Field Documentation

assNumeric::$maxchars

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

Referenced by getMaxChars(), and setMaxChars().

assNumeric::$ranges

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

Referenced by getRanges().

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