Test results import parser. More...

Inheritance diagram for ilTestResultsImportParser:

Collaboration diagram for ilTestResultsImportParser:

Public Member Functions
	__construct ($a_xml_file, &$test_object)
	Constructor. More...

	getQuestionIdMapping ()

	setQuestionIdMapping ($question_id_mapping)

	getSrcPoolDefIdMapping ()

	setSrcPoolDefIdMapping ($src_pool_def_id_mapping)

	setHandlers ($a_xml_parser)
	set event handler should be overwritten by inherited class private More...

	handlerBeginTag ($a_xml_parser, $a_name, $a_attribs)
	handler for begin of element parser More...

	handlerEndTag ($a_xml_parser, $a_name)
	handler for end of element More...

	handlerParseCharacterData ($a_xml_parser, $a_data)
	handler for character data More...

Public Member Functions inherited from ilSaxParser
	__construct ($a_xml_file='', $throwException=false)
	Constructor setup ILIAS global object public. More...

	setXMLContent ($a_xml_content)

	getXMLContent ()

	getInputType ()

	startParsing ()
	stores xml data in array More...

	createParser ()
	create parser More...

	setOptions ($a_xml_parser)
	set parser options More...

	setHandlers ($a_xml_parser)
	set event handler should be overwritten by inherited class private More...

	openXMLFile ()
	open xml file More...

	parse ($a_xml_parser, $a_fp=null)
	parse xml file More...

	freeParser ($a_xml_parser)
	free xml parser handle More...

	setThrowException ($throwException)
	set error handling More...

Public Member Functions inherited from PEAR
	__construct ($error_class=null)
	Constructor. More...

	_PEAR ()
	Destructor (the emulated type of...). More...

	registerShutdownFunc ($func, $args=array())
	Use this function to register a shutdown method for static classes. More...

	isError ($data, $code=null)
	Tell whether a value is a PEAR error. More...

	expectError ($code=' *')
	This method is used to tell which errors you expect to get. More...

	popExpect ()
	This method pops one element off the expected error codes stack. More...

	_checkDelExpect ($error_code)
	This method checks unsets an error code if available. More...

	delExpect ($error_code)
	This method deletes all occurences of the specified element from the expected error codes stack. More...

&	raiseError ($message=null, $code=null, $mode=null, $options=null, $userinfo=null, $error_class=null, $skipmsg=false)
	This method is a wrapper that returns an instance of the configured error class with this object's default error handling applied. More...

&	throwError ($message=null, $code=null, $userinfo=null)
	Simpler form of raiseError with fewer options. More...

	staticPushErrorHandling ($mode, $options=null)

	staticPopErrorHandling ()

	pushErrorHandling ($mode, $options=null)
	Push a new error handler on top of the error handler options stack. More...

	popErrorHandling ()
	Pop the last error handler used. More...

	loadExtension ($ext)
	OS independant PHP extension load. More...

Protected Attributes
	$src_pool_def_id_mapping

Private Member Functions
	fetchAttribute ($attributes, $name)

	fetchLastFinishedPass ($attribs)

	fetchLastStartedPass ($attribs)

Private Attributes
	$tst_obj

	$table

	$active_id_mapping

	$question_id_mapping

	$user_criteria_field

	$user_criteria_type

	$user_criteria_checked = false

Additional Inherited Members
Static Public Member Functions inherited from PEAR
static &	getStaticProperty ($class, $var)
	If you have a class that's mostly/entirely static, and you need static properties, you can use this method to simulate them. More...

static	setErrorHandling ($mode=null, $options=null)
	Sets how errors generated by this object should be handled. More...

Data Fields inherited from ilSaxParser
	$input_type = null

	$xml_content = ''

	$ilias

	$lng

	$xml_file

	$throwException = false

Data Fields inherited from PEAR
	$_debug = false

	$_default_error_mode = null

	$_default_error_options = null

	$_default_error_handler = ''

	$_error_class = 'PEAR_Error'

	$_expected_errors = array()

Protected Member Functions inherited from ilSaxParser
	handleError ($message, $code)
	use given error handler to handle error message or internal ilias error message handle More...

Detailed Description

Test results import parser.

Author: Helmut Schottmüller ilias.nosp@m.@aur.nosp@m.ealis.nosp@m..de

Version: $Id$

Definition at line 13 of file class.ilTestResultsImportParser.php.

Constructor & Destructor Documentation

◆ __construct()

ilTestResultsImportParser::__construct	(		$a_xml_file,
		&	$test_object
	)

Constructor.

Definition at line 28 of file class.ilTestResultsImportParser.php.

References array.

     {
         parent::__construct($a_xml_file, true);
         $this->tst_obj = &$test_object;
         $this->table = '';
         $this->active_id_mapping = array();
         $this->question_id_mapping = array();
         $this->user_criteria_checked = false;
         $this->src_pool_def_id_mapping = array();
     }

Member Function Documentation

◆ fetchAttribute()

ilTestResultsImportParser::fetchAttribute	(	$attributes,
		$name
	)

private

Definition at line 282 of file class.ilTestResultsImportParser.php.

References $attributes, and $name.

Referenced by handlerBeginTag().

     {
         if (isset($attributes[$name])) {
             return $attributes[$name];
         }
         
         return null;
     }

Here is the caller graph for this function:

◆ fetchLastFinishedPass()

ilTestResultsImportParser::fetchLastFinishedPass ( $attribs )

private

Definition at line 291 of file class.ilTestResultsImportParser.php.

Referenced by handlerBeginTag().

     {
         if (isset($attribs['last_finished_pass'])) {
             return $attribs['last_finished_pass'];
         }
         
         if ($attribs['tries'] > 0) {
             return $attribs['tries'] - 1;
         }
         
         return null;
     }

Here is the caller graph for this function:

◆ fetchLastStartedPass()

ilTestResultsImportParser::fetchLastStartedPass ( $attribs )

private

Definition at line 304 of file class.ilTestResultsImportParser.php.

Referenced by handlerBeginTag().

     {
         if (isset($attribs['last_started_pass'])) {
             return $attribs['last_started_pass'];
         }
         
         if ($attribs['tries'] > 0) {
             return $attribs['tries'] - 1;
         }
         
         return null;
     }

Here is the caller graph for this function:

◆ getQuestionIdMapping()

ilTestResultsImportParser::getQuestionIdMapping ( )

Returns: array

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

References $question_id_mapping.

     {
         return $this->question_id_mapping;
     }

◆ getSrcPoolDefIdMapping()

ilTestResultsImportParser::getSrcPoolDefIdMapping ( )

Returns: array

Definition at line 58 of file class.ilTestResultsImportParser.php.

References $src_pool_def_id_mapping.

     {
         return $this->src_pool_def_id_mapping;
     }

◆ handlerBeginTag()

ilTestResultsImportParser::handlerBeginTag	(	$a_xml_parser,
		$a_name,
		$a_attribs
	)

handler for begin of element parser

Definition at line 86 of file class.ilTestResultsImportParser.php.

References $ilDB, $info, $result, $row, array, fetchAttribute(), fetchLastFinishedPass(), and fetchLastStartedPass().

     {
         global $ilDB;
         
         $this->sametag = false;
         $this->characterbuffer = "";
         $this->depth[$a_xml_parser]++;
         $this->path[$this->depth[$a_xml_parser]] = strtolower($a_name);
         $this->qti_element = $a_name;
         
         switch (strtolower($a_name)) {
             case "results":
                 break;
             case "row":
                 switch ($this->table) {
                     case 'tst_active':
                         if (!$this->user_criteria_checked) {
                             $this->user_criteria_checked = true;
                             if ($ilDB->tableColumnExists('usr_data', $a_attribs['user_criteria'])) {
                                 include_once './Services/Database/classes/class.ilDBAnalyzer.php';
                                 $analyzer = new ilDBAnalyzer();
                                 $info = $analyzer->getFieldInformation('usr_data');
                                 $this->user_criteria_field = $a_attribs['user_criteria'];
                                 $this->user_criteria_type = $info[$a_attribs['user_criteria']]['type'];
                             }
                         }
                         $usr_id = ANONYMOUS_USER_ID;
                         if (strlen($this->user_criteria_field)) {
                             $result = $ilDB->queryF(
                                 "SELECT usr_id FROM usr_data WHERE " . $this->user_criteria_field . " =  %s",
                                 array($this->user_criteria_type),
                                 array($a_attribs[$this->user_criteria_field])
                             );
                             if ($result->numRows()) {
                                 $row = $ilDB->fetchAssoc($result);
                                 $usr_id = $row['usr_id'];
                             }
                         }
                         $next_id = $ilDB->nextId('tst_active');
                         
                         $ilDB->insert('tst_active', array(
                             'active_id' => array('integer', $next_id),
                             'user_fi' => array('integer', $usr_id),
                             'anonymous_id' => array('text', strlen($a_attribs['anonymous_id']) ? $a_attribs['anonymous_id'] : null),
                             'test_fi' => array('integer', $this->tst_obj->getTestId()),
                             'lastindex' => array('integer', $a_attribs['lastindex']),
                             'tries' => array('integer', $a_attribs['tries']),
                             'submitted' => array('integer', $a_attribs['submitted']),
                             'submittimestamp' => array('timestamp', strlen($a_attribs['submittimestamp']) ? $a_attribs['submittimestamp'] : null),
                             'tstamp' => array('integer', $a_attribs['tstamp']),
                             'importname' => array('text', $a_attribs['fullname']),
                             'last_finished_pass' => array('integer', $this->fetchLastFinishedPass($a_attribs)),
                             'last_started_pass' => array('integer', $this->fetchLastStartedPass($a_attribs)),
                             'answerstatusfilter' => array('integer', $this->fetchAttribute($a_attribs, 'answer_status_filter')),
                             'objective_container' => array('integer', $this->fetchAttribute($a_attribs, 'objective_container'))
                         ));
                         $this->active_id_mapping[$a_attribs['active_id']] = $next_id;
                         break;
                     case 'tst_test_rnd_qst':
                         $nextId = $ilDB->nextId('tst_test_rnd_qst');
                         $newActiveId = $this->active_id_mapping[$a_attribs['active_fi']];
                         $newQuestionId = $this->question_id_mapping[$a_attribs['question_fi']];
                         $newSrcPoolDefId = $this->src_pool_def_id_mapping[$a_attribs['src_pool_def_fi']];
                         $ilDB->insert('tst_test_rnd_qst', array(
                             'test_random_question_id' => array('integer', $nextId),
                             'active_fi' => array('integer', $newActiveId),
                             'question_fi' => array('integer', $newQuestionId),
                             'sequence' => array('integer', $a_attribs['sequence']),
                             'pass' => array('integer', $a_attribs['pass']),
                             'tstamp' => array('integer', $a_attribs['tstamp']),
                             'src_pool_def_fi' => array('integer', $newSrcPoolDefId)
                         ));
                         break;
                     case 'tst_pass_result':
                         $affectedRows = $ilDB->manipulateF(
                             "INSERT INTO tst_pass_result (active_fi, pass, points, maxpoints, questioncount, answeredquestions, workingtime, tstamp) VALUES (%s,%s,%s,%s,%s,%s,%s,%s)",
                             array(
                                 'integer',
                                 'integer',
                                 'float',
                                 'float',
                                 'integer',
                                 'integer',
                                 'integer',
                                 'integer'
                             ),
                             array(
                                 $this->active_id_mapping[$a_attribs['active_fi']],
                                 strlen($a_attribs['pass']) ? $a_attribs['pass'] : 0,
                                 ($a_attribs["points"]) ? $a_attribs["points"] : 0,
                                 ($a_attribs["maxpoints"]) ? $a_attribs["maxpoints"] : 0,
                                 $a_attribs["questioncount"],
                                 $a_attribs["answeredquestions"],
                                 ($a_attribs["workingtime"]) ? $a_attribs["workingtime"] : 0,
                                 $a_attribs["tstamp"]
                             )
                         );
                         break;
                     case 'tst_result_cache':
                         $affectedRows = $ilDB->manipulateF(
                             "INSERT INTO tst_result_cache (active_fi, pass, max_points, reached_points, mark_short, mark_official, passed, failed, tstamp) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s)",
                             array(
                                 'integer',
                                 'integer',
                                 'float',
                                 'float',
                                 'text',
                                 'text',
                                 'integer',
                                 'integer',
                                 'integer'
                             ),
                             array(
                                 $this->active_id_mapping[$a_attribs['active_fi']],
                                 strlen($a_attribs['pass']) ? $a_attribs['pass'] : 0,
                                 ($a_attribs["max_points"]) ? $a_attribs["max_points"] : 0,
                                 ($a_attribs["reached_points"]) ? $a_attribs["reached_points"] : 0,
                                 strlen($a_attribs["mark_short"]) ? $a_attribs["mark_short"] : " ",
                                 strlen($a_attribs["mark_official"]) ? $a_attribs["mark_official"] : " ",
                                 ($a_attribs["passed"]) ? 1 : 0,
                                 ($a_attribs["failed"]) ? 1 : 0,
                                 $a_attribs["tstamp"]
                             )
                         );
                         break;
                     case 'tst_sequence':
                         $affectedRows = $ilDB->insert("tst_sequence", array(
                             "active_fi" => array("integer", $this->active_id_mapping[$a_attribs['active_fi']]),
                             "pass" => array("integer", $a_attribs['pass']),
                             "sequence" => array("clob", $a_attribs['sequence']),
                             "postponed" => array("text", (strlen($a_attribs['postponed'])) ? $a_attribs['postponed'] : null),
                             "hidden" => array("text", (strlen($a_attribs['hidden'])) ? $a_attribs['hidden'] : null),
                             "tstamp" => array("integer", $a_attribs['tstamp'])
                         ));
                         break;
                     case 'tst_solutions':
                         $next_id = $ilDB->nextId('tst_solutions');
                         $affectedRows = $ilDB->insert("tst_solutions", array(
                             "solution_id" => array("integer", $next_id),
                             "active_fi" => array("integer", $this->active_id_mapping[$a_attribs['active_fi']]),
                             "question_fi" => array("integer", $this->question_id_mapping[$a_attribs['question_fi']]),
                             "value1" => array("clob", (strlen($a_attribs['value1'])) ? $a_attribs['value1'] : null),
                             "value2" => array("clob", (strlen($a_attribs['value2'])) ? $a_attribs['value2'] : null),
                             "pass" => array("integer", $a_attribs['pass']),
                             "tstamp" => array("integer", $a_attribs['tstamp'])
                         ));
                         break;
                     case 'tst_test_result':
                         $next_id = $ilDB->nextId('tst_test_result');
                         $affectedRows = $ilDB->manipulateF(
                             "INSERT INTO tst_test_result (test_result_id, active_fi, question_fi, points, pass, manual, tstamp) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                             array('integer', 'integer','integer', 'float', 'integer', 'integer','integer'),
                             array($next_id, $this->active_id_mapping[$a_attribs['active_fi']], $this->question_id_mapping[$a_attribs['question_fi']], $a_attribs['points'], $a_attribs['pass'], (strlen($a_attribs['manual'])) ? $a_attribs['manual'] : 0, $a_attribs['tstamp'])
                         );
                         break;
                     case 'tst_times':
                         $next_id = $ilDB->nextId('tst_times');
                         $affectedRows = $ilDB->manipulateF(
                             "INSERT INTO tst_times (times_id, active_fi, started, finished, pass, tstamp) VALUES (%s, %s, %s, %s, %s, %s)",
                             array('integer', 'integer', 'timestamp', 'timestamp', 'integer', 'integer'),
                             array($next_id, $this->active_id_mapping[$a_attribs['active_fi']], $a_attribs['started'], $a_attribs['finished'], $a_attribs['pass'], $a_attribs['tstamp'])
                         );
                         break;
                 }
                 break;
             default:
                 $this->table = $a_name;
                 break;
         }
     }

Here is the call graph for this function:

◆ handlerEndTag()

ilTestResultsImportParser::handlerEndTag	(	$a_xml_parser,
		$a_name
	)

handler for end of element

Definition at line 260 of file class.ilTestResultsImportParser.php.

References $ilLog.

     {
         switch (strtolower($a_name)) {
             case "tst_active":
                 global $ilLog;
                 $ilLog->write("active id mapping: " . print_r($this->active_id_mapping, true));
                 break;
             case "tst_test_question":
                 global $ilLog;
                 $ilLog->write("question id mapping: " . print_r($this->question_id_mapping, true));
                 break;
         }
     }

◆ handlerParseCharacterData()

ilTestResultsImportParser::handlerParseCharacterData	(	$a_xml_parser,
		$a_data
	)

handler for character data

Definition at line 277 of file class.ilTestResultsImportParser.php.

     {
         // do nothing
     }

◆ setHandlers()

ilTestResultsImportParser::setHandlers ( $a_xml_parser )

set event handler should be overwritten by inherited class private

Definition at line 76 of file class.ilTestResultsImportParser.php.

     {
         xml_set_object($a_xml_parser, $this);
         xml_set_element_handler($a_xml_parser, 'handlerBeginTag', 'handlerEndTag');
         xml_set_character_data_handler($a_xml_parser, 'handlerParseCharacterData');
     }

◆ setQuestionIdMapping()

ilTestResultsImportParser::setQuestionIdMapping ( $question_id_mapping )

Parameters

array $question_id_mapping

Definition at line 50 of file class.ilTestResultsImportParser.php.

References $question_id_mapping.

     {
         $this->question_id_mapping = $question_id_mapping;
     }

◆ setSrcPoolDefIdMapping()

ilTestResultsImportParser::setSrcPoolDefIdMapping ( $src_pool_def_id_mapping )

Parameters

array $src_pool_def_id_mapping

Definition at line 66 of file class.ilTestResultsImportParser.php.

References $src_pool_def_id_mapping.

     {
         $this->src_pool_def_id_mapping = $src_pool_def_id_mapping;
     }

Field Documentation

◆ $active_id_mapping

ilTestResultsImportParser::$active_id_mapping

private

Definition at line 17 of file class.ilTestResultsImportParser.php.

◆ $question_id_mapping

ilTestResultsImportParser::$question_id_mapping

private

Definition at line 18 of file class.ilTestResultsImportParser.php.

Referenced by getQuestionIdMapping(), and setQuestionIdMapping().

◆ $src_pool_def_id_mapping

ilTestResultsImportParser::$src_pool_def_id_mapping

protected

Definition at line 23 of file class.ilTestResultsImportParser.php.

Referenced by getSrcPoolDefIdMapping(), and setSrcPoolDefIdMapping().

◆ $table

ilTestResultsImportParser::$table

private

Definition at line 16 of file class.ilTestResultsImportParser.php.

◆ $tst_obj

ilTestResultsImportParser::$tst_obj

private

Definition at line 15 of file class.ilTestResultsImportParser.php.

◆ $user_criteria_checked

ilTestResultsImportParser::$user_criteria_checked = false

private

Definition at line 21 of file class.ilTestResultsImportParser.php.

◆ $user_criteria_field

ilTestResultsImportParser::$user_criteria_field

private

Definition at line 19 of file class.ilTestResultsImportParser.php.

◆ $user_criteria_type

ilTestResultsImportParser::$user_criteria_type

private

Definition at line 20 of file class.ilTestResultsImportParser.php.

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

Modules/Test/classes/class.ilTestResultsImportParser.php

Public Member Functions

Protected Attributes

Private Member Functions

Private Attributes

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ fetchAttribute()

◆ fetchLastFinishedPass()

◆ fetchLastStartedPass()

◆ getQuestionIdMapping()

◆ getSrcPoolDefIdMapping()

◆ handlerBeginTag()

◆ handlerEndTag()

◆ handlerParseCharacterData()

◆ setHandlers()

◆ setQuestionIdMapping()

◆ setSrcPoolDefIdMapping()

Field Documentation

◆ $active_id_mapping

◆ $question_id_mapping

◆ $src_pool_def_id_mapping

◆ $table

◆ $tst_obj

◆ $user_criteria_checked

◆ $user_criteria_field

◆ $user_criteria_type