This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Inheritance diagram for ilTestResultsImportParser:

Collaboration diagram for ilTestResultsImportParser:

Public Member Functions
	__construct (?string $a_xml_file, &$test_object)
	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 @access 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)

Private Attributes
	$tst_obj

	$table

	$active_id_mapping

	$question_id_mapping

	$user_criteria_field

	$user_criteria_type

bool	$user_criteria_checked = false

	$depth

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

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning

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

Constructor & Destructor Documentation

◆ __construct()

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

Constructor.

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

    {
        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();
    }

References ILIAS\GlobalScreen\Provider\__construct().

Here is the call graph for this function:

Member Function Documentation

◆ fetchAttribute()

ilTestResultsImportParser::fetchAttribute	(	$attributes,
		$name
	)

private

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

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

References $attributes, and $name.

Referenced by handlerBeginTag().

Here is the caller graph for this function:

◆ fetchLastFinishedPass()

ilTestResultsImportParser::fetchLastFinishedPass ( $attribs )

private

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

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

Referenced by handlerBeginTag().

Here is the caller graph for this function:

◆ fetchLastStartedPass()

ilTestResultsImportParser::fetchLastStartedPass ( $attribs )

private

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

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

Referenced by handlerBeginTag().

Here is the caller graph for this function:

◆ getQuestionIdMapping()

ilTestResultsImportParser::getQuestionIdMapping ( )

Returns: array

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

                                          : array
    {
        return $this->question_id_mapping;
    }

References $question_id_mapping.

◆ getSrcPoolDefIdMapping()

ilTestResultsImportParser::getSrcPoolDefIdMapping ( )

Returns: array

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

                                            : array
    {
        return $this->src_pool_def_id_mapping;
    }

References $src_pool_def_id_mapping.

◆ handlerBeginTag()

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

handler for begin of element parser

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

                                                                       : void
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        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']) && $ilDB->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 (isset($this->user_criteria_field) && $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']] ?? 0;
                        $newSrcPoolDefId = $this->src_pool_def_id_mapping[$a_attribs['src_pool_def_fi']] ?? 0;
                        $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;
        }
    }

References $DIC, $ilDB, ANONYMOUS_USER_ID, fetchAttribute(), fetchLastFinishedPass(), and fetchLastStartedPass().

Here is the call graph for this function:

◆ handlerEndTag()

ilTestResultsImportParser::handlerEndTag	(	$a_xml_parser,
		$a_name
	)

handler for end of element

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

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

References $DIC.

◆ handlerParseCharacterData()

ilTestResultsImportParser::handlerParseCharacterData	(	$a_xml_parser,
		$a_data
	)

handler for character data

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

                                                                     : void
    {
        // do nothing
    }

◆ setHandlers()

ilTestResultsImportParser::setHandlers ( $a_xml_parser )

set event handler should be overwritten by inherited class @access private

Reimplemented from ilSaxParser.

Definition at line 84 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 58 of file class.ilTestResultsImportParser.php.

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

References $question_id_mapping.

◆ setSrcPoolDefIdMapping()

ilTestResultsImportParser::setSrcPoolDefIdMapping ( array $src_pool_def_id_mapping )

Parameters

array $src_pool_def_id_mapping

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

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

References $src_pool_def_id_mapping.