Inheritance diagram for ilTestResultsImportParser:

Collaboration diagram for ilTestResultsImportParser:

Public Member Functions
	__construct (?string $a_xml_file, private ilObjTest $test_obj, private ilDBInterface $db, private TestLogger $log, private ResourceStorage $irss)
	Constructor. More...

	getQuestionIdMapping ()

	setQuestionIdMapping (array $question_id_mapping)

	getSrcPoolDefIdMapping ()

	setSrcPoolDefIdMapping (array $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 (?string $path_to_file='', ?bool $throw_exception=false)

	setXMLContent (string $a_xml_content)

	getXMLContent ()

	getInputType ()

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

	createParser ()

	setHandlers ($a_xml_parser)

	parse ($a_xml_parser, $a_fp=null)

Protected Attributes
	$src_pool_def_id_mapping

Protected Attributes inherited from ilSaxParser
ilLanguage	$lng = null

Private Member Functions
	fetchAttribute ($attributes, $name)

	fetchLastFinishedPass ($attribs)

	fetchLastStartedPass ($attribs)

	importParticipantsUploadedFiles (array $a_attribs)

	getFirstFileName (string $resource_directory)

Private Attributes
	$table

	$active_id_mapping

	$question_id_mapping

string	$user_criteria_field = ''

string	$user_criteria_type = ''

bool	$user_criteria_checked = false

string	$import_directory

Additional Inherited Members
Data Fields inherited from ilSaxParser
string	$xml_file

bool	$throw_exception = false

Protected Member Functions inherited from ilSaxParser
	openXMLFile ()

	handleError (string $message)

	setThrowException (bool $throw_exception)

Detailed Description

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

Constructor & Destructor Documentation

◆ __construct()

ilTestResultsImportParser::__construct	(	?string	$a_xml_file,
		private ilObjTest	$test_obj,
		private ilDBInterface	$db,
		private TestLogger	$log,
		private ResourceStorage	$irss
	)

Constructor.

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

References ILIAS\GlobalScreen\Provider\__construct().

       {
         parent::__construct($a_xml_file, true);
         $this->table = '';
         $this->active_id_mapping = [];
         $this->question_id_mapping = [];
         $this->src_pool_def_id_mapping = [];
         $this->import_directory = dirname($a_xml_file);
     }

Here is the call graph for this function:

Member Function Documentation

◆ fetchAttribute()

ilTestResultsImportParser::fetchAttribute	(	$attributes,
		$name
	)

private

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

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 299 of file class.ilTestResultsImportParser.php.

Referenced by handlerBeginTag().

                                                     : ?int
     {
         if (isset($attribs['last_finished_pass'])) {
             return (int) $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 312 of file class.ilTestResultsImportParser.php.

Referenced by handlerBeginTag().

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

Here is the caller graph for this function:

◆ getFirstFileName()

ilTestResultsImportParser::getFirstFileName ( string $resource_directory )

private

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

Referenced by importParticipantsUploadedFiles().

                                                                  : mixed
     {
         $entries = array_filter(
             scandir($resource_directory),
             static fn(string $entry): bool => is_file("$resource_directory/$entry") && !in_array($entry, ['.', '..']),
         );
         return array_shift($entries);
     }

Here is the caller graph for this function:

◆ getQuestionIdMapping()

ilTestResultsImportParser::getQuestionIdMapping ( )

Returns: array

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

References $question_id_mapping.

                                           : array
     {
         return $this->question_id_mapping;
     }

◆ getSrcPoolDefIdMapping()

ilTestResultsImportParser::getSrcPoolDefIdMapping ( )

Returns: array

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

References $src_pool_def_id_mapping.

                                             : array
     {
         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 103 of file class.ilTestResultsImportParser.php.

References ANONYMOUS_USER_ID, fetchAttribute(), fetchLastFinishedPass(), fetchLastStartedPass(), and importParticipantsUploadedFiles().

                                                                        : void
     {
         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 (isset($a_attribs['user_criteria'])
                                 && $this->db->tableColumnExists('usr_data', $a_attribs['user_criteria'])) {
                                 $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 ($this->user_criteria_field !== '') {
                             $result = $this->db->queryF(
                                 'SELECT usr_id FROM usr_data WHERE '
                                     . $this->user_criteria_field . ' =  %s',
                                 [$this->user_criteria_type],
                                 [$a_attribs[$this->user_criteria_field]]
                             );
                             if ($result->numRows()) {
                                 $row = $this->db->fetchAssoc($result);
                                 $usr_id = $row['usr_id'];
                             }
                         }
                         $next_id = $this->db->nextId('tst_active');
 
                         $this->db->insert('tst_active', [
                             'active_id' => ['integer', $next_id],
                             'user_fi' => ['integer', $usr_id],
                             'anonymous_id' => ['text', strlen($a_attribs['anonymous_id']) ? $a_attribs['anonymous_id'] : null],
                             'test_fi' => ['integer', $this->test_obj->getTestId()],
                             'lastindex' => ['integer', $a_attribs['lastindex']],
                             'tries' => ['integer', $a_attribs['tries']],
                             'submitted' => ['integer', $a_attribs['submitted']],
                             'submittimestamp' => ['timestamp', strlen($a_attribs['submittimestamp']) ? $a_attribs['submittimestamp'] : null],
                             'tstamp' => ['integer', $a_attribs['tstamp']],
                             'importname' => ['text', $a_attribs['fullname']],
                             'last_finished_pass' => ['integer', $this->fetchLastFinishedPass($a_attribs)],
                             'last_started_pass' => ['integer', $this->fetchLastStartedPass($a_attribs)],
                             'answerstatusfilter' => ['integer', $this->fetchAttribute($a_attribs, 'answer_status_filter')],
                             'objective_container' => ['integer', $this->fetchAttribute($a_attribs, 'objective_container')]
                         ]);
                         $this->active_id_mapping[$a_attribs['active_id']] = $next_id;
                         break;
                     case 'tst_test_rnd_qst':
                         $nextId = $this->db->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']];
                         $this->db->insert('tst_test_rnd_qst', [
                             'test_random_question_id' => ['integer', $nextId],
                             'active_fi' => ['integer', $newActiveId],
                             'question_fi' => ['integer', $newQuestionId],
                             'sequence' => ['integer', $a_attribs['sequence']],
                             'pass' => ['integer', $a_attribs['pass']],
                             'tstamp' => ['integer', $a_attribs['tstamp']],
                             'src_pool_def_fi' => ['integer', $newSrcPoolDefId]
                         ]);
                         break;
                     case 'tst_pass_result':
                         $affectedRows = $this->db->manipulateF(
                             "INSERT INTO tst_pass_result (active_fi, pass, points, maxpoints, questioncount, answeredquestions, workingtime, tstamp) VALUES (%s,%s,%s,%s,%s,%s,%s,%s)",
                             [
                                 'integer',
                                 'integer',
                                 'float',
                                 'float',
                                 'integer',
                                 'integer',
                                 'integer',
                                 'integer'
                             ],
                             [
                                 $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 = $this->db->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)",
                             [
                                 'integer',
                                 'integer',
                                 'float',
                                 'float',
                                 'text',
                                 'text',
                                 'integer',
                                 'integer',
                                 'integer'
                             ],
                             [
                                 $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 = $this->db->insert("tst_sequence", [
                             "active_fi" => ["integer", $this->active_id_mapping[$a_attribs['active_fi']]],
                             "pass" => ["integer", $a_attribs['pass']],
                             "sequence" => ["clob", $a_attribs['sequence']],
                             "postponed" => ["text", (strlen($a_attribs['postponed'])) ? $a_attribs['postponed'] : null],
                             "hidden" => ["text", (strlen($a_attribs['hidden'])) ? $a_attribs['hidden'] : null],
                             "tstamp" => ["integer", $a_attribs['tstamp']]
                         ]);
                         break;
                     case 'tst_solutions':
                         $next_id = $this->db->nextId('tst_solutions');
                         $affectedRows = $this->db->insert("tst_solutions", [
                             "solution_id" => ["integer", $next_id],
                             "active_fi" => ["integer", $this->active_id_mapping[$a_attribs['active_fi']]],
                             "question_fi" => ["integer", $this->question_id_mapping[$a_attribs['question_fi']]],
                             "value1" => ["clob", $this->importParticipantsUploadedFiles($a_attribs)],
                             "value2" => ["clob", (strlen($a_attribs['value2'])) ? $a_attribs['value2'] : null],
                             "pass" => ["integer", $a_attribs['pass']],
                             "tstamp" => ["integer", $a_attribs['tstamp']]
                         ]);
                         break;
                     case 'tst_test_result':
                         $next_id = $this->db->nextId('tst_test_result');
                         $affectedRows = $this->db->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)",
                             ['integer', 'integer','integer', 'float', 'integer', 'integer','integer'],
                             [$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 = $this->db->nextId('tst_times');
                         $affectedRows = $this->db->manipulateF(
                             "INSERT INTO tst_times (times_id, active_fi, started, finished, pass, tstamp) VALUES (%s, %s, %s, %s, %s, %s)",
                             ['integer', 'integer', 'timestamp', 'timestamp', 'integer', 'integer'],
                             [$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 270 of file class.ilTestResultsImportParser.php.

                                                          : void
     {
         switch (strtolower($a_name)) {
             case 'tst_active':
                 $this->log->info('active id mapping: ' . print_r($this->active_id_mapping, true));
                 break;
             case 'tst_test_question':
                 $this->log->info('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 285 of file class.ilTestResultsImportParser.php.

                                                                      : void
     {
         // do nothing
     }

◆ importParticipantsUploadedFiles()

ilTestResultsImportParser::importParticipantsUploadedFiles ( array $a_attribs )

private

Parameters

array{value1 ?string, value2: ?string} $a_attribs

Returns: ?string

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

References getFirstFileName().

Referenced by handlerBeginTag().

                                                                       : ?string
     {
         ['value1' => $value1, 'value2' => $value2] = $a_attribs;
 
         if ($value2 !== 'rid') {
             return $value1 !== '' ? $value1 : null;
         }
 
         $resource_directory = "$this->import_directory/objects/resources/$value1";
         $file_name = $this->getFirstFileName($resource_directory);
         if (!is_string($file_name)) {
             return $value1 !== '' ? $value1 : null;
         }
 
         $file_path = "$resource_directory/$file_name";
         $new_rid = $this->irss->manage()->stream(
             new Stream(fopen($file_path, 'rwb')),
             new assFileUploadStakeholder(),
             basename($file_path),
         );
         return $new_rid->serialize();
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ setHandlers()

ilTestResultsImportParser::setHandlers ( $a_xml_parser )

set event handler should be overwritten by inherited class private

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

                                               : void
     {
         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 ( array $question_id_mapping )

Parameters

array $question_id_mapping

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

References $question_id_mapping.

                                                                     : void
     {
         $this->question_id_mapping = $question_id_mapping;
     }

◆ setSrcPoolDefIdMapping()

ilTestResultsImportParser::setSrcPoolDefIdMapping ( array $src_pool_def_id_mapping )

Parameters

array $src_pool_def_id_mapping

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

References $src_pool_def_id_mapping.

                                                                           : void
     {
         $this->src_pool_def_id_mapping = $src_pool_def_id_mapping;
     }