ilTestExport Class Reference

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

Inheritance diagram for ilTestExport:

Collaboration diagram for ilTestExport:

Public Member Functions
	__construct (&$a_test_obj, $a_mode="xml")
	Constructor. More...
	isResultExportingEnabledForTestExport ()
	setResultExportingEnabledForTestExport ($resultExprtingEnabledForTestExport)
	getForcedAccessFilteredParticipantList ()
	setForcedAccessFilteredParticipantList (ilTestParticipantList $forcedAccessFilteredParticipantList)
	getAccessFilteredParticipantList ()
	getExtension ()
	getInstId ()
	buildExportFile ()
	build export file (complete zip file) More...
	buildExportResultFile ()
	build xml export file More...
	exportToExcel ($deliver=true, $filterby="", $filtertext="", $passedonly=false)
	Exports the evaluation data to the Microsoft Excel file format. More...
	exportToCSV ($deliver=true, $filterby="", $filtertext="", $passedonly=false)
	Exports the evaluation data to the CSV file format. More...
	buildExportFileXML ()
	build xml export file More...
	exportXHTMLMediaObjects ($a_export_dir)

Data Fields
	$err
	$db
	$ilias
	$test_obj
	$inst_id
	$mode

Protected Member Functions
	aggregatedResultsToExcel ($deliver=true)
	Exports the aggregated results to the Microsoft Excel file format. More...
	aggregatedResultsToCSV ($deliver=true)
	Exports the aggregated results to CSV. More...
	orderQuestions (array $questions)
	initXmlExport ()
	getQuestionIds ()
	populateQuestionSetConfigXml (ilXmlWriter $xmlWriter)
	getQtiXml ()
	getQuestionsQtiXml ()
	getQuestionQtiXml ($questionId)
	populateQuestionSkillAssignmentsXml (ilXmlWriter $a_xml_writer, ilAssQuestionSkillAssignmentList $assignmentList, $questions)
	populateSkillLevelThresholdsXml (ilXmlWriter $a_xml_writer, ilAssQuestionSkillAssignmentList $assignmentList)
	buildQuestionSkillAssignmentList ()

Protected Attributes
	$resultExportingEnabledForTestExport = false
	$forcedAccessFilteredParticipantList = null

Private Attributes
string	$export_dir
string	$subdir
string	$qti_filename
	$lng
	$resultsfile

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 Export class for tests

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

Maximilian Becker mbeck.nosp@m.er@d.nosp@m.ataba.nosp@m.y.de

Björn Heyser bheys.nosp@m.er@d.nosp@m.ataba.nosp@m.y.de

Version

$Id$

Definition at line 32 of file class.ilTestExport.php.

Constructor & Destructor Documentation

__construct()

ilTestExport::__construct	(	&	$a_test_obj,
			$a_mode = "xml"
	)

Constructor.

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

    {
        global $DIC;
        $ilErr = $DIC['ilErr'];
        $ilDB = $DIC['ilDB'];
        $ilias = $DIC['ilias'];
        $lng = $DIC['lng'];
 
        $this->test_obj = &$a_test_obj;
 
        $this->err = &$ilErr;
        $this->ilias = &$ilias;
        $this->db = &$ilDB;
        $this->mode = $a_mode;
        $this->lng = &$lng;
 
        $this->inst_id = IL_INST_ID;
 
        $date = time();
        $this->export_dir = $this->test_obj->getExportDirectory();
 
        switch ($this->mode) {
            case "results":
                $this->subdir = $date . "__" . $this->inst_id . "__" .
                    "tst__results_" . $this->test_obj->getId();
                break;
            case "aggregated":
                $this->subdir = $date . "__" . $this->inst_id . "__" .
                    "test__aggregated__results_" . $this->test_obj->getId();
                break;
            default:
                $this->subdir = $date . "__" . $this->inst_id . "__" .
                    "tst" . "_" . $this->test_obj->getId();
                $this->filename = $this->subdir . ".xml";
                $this->resultsfile = $date . "__" . $this->inst_id . "__" .
                    "results" . "_" . $this->test_obj->getId() . ".xml";
                $this->qti_filename = $date . "__" . $this->inst_id . "__" .
                    "qti" . "_" . $this->test_obj->getId() . ".xml";
                break;
        }
        $this->filename = $this->subdir . "." . $this->getExtension();
    }

References $DIC, $ilDB, $ilErr, $ilias, $lng, getExtension(), IL_INST_ID, and ILIAS\Repository\lng().

Here is the call graph for this function:

Member Function Documentation

aggregatedResultsToCSV()

ilTestExport::aggregatedResultsToCSV (   $deliver = true )

protected

Exports the aggregated results to CSV.

Parameters

boolean

$deliver

TRUE to directly deliver the file, FALSE to return the data

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

    {
        $data = $this->test_obj->getAggregatedResultsData();
        $rows = array();
        array_push($rows, array(
            $this->lng->txt("result"),
            $this->lng->txt("value")
        ));
        foreach ($data["overview"] as $key => $value) {
            array_push($rows, array(
                $key,
                $value
            ));
        }
        array_push($rows, array(
            $this->lng->txt("question_id"),
            $this->lng->txt("question_title"),
            $this->lng->txt("average_reached_points"),
            $this->lng->txt("points"),
            $this->lng->txt("percentage"),
            $this->lng->txt("number_of_answers")
        ));
        foreach ($data["questions"] as $key => $value) {
            array_push($rows, array(
                $key,
                $value[0],
                $value[4],
                $value[5],
                $value[6],
                $value[3]
            ));
        }
        $csv = "";
        $separator = ";";
        foreach ($rows as $evalrow) {
            $csvrow = &$this->test_obj->processCSVRow($evalrow, true, $separator);
            $csv .= join($separator, $csvrow) . "\n";
        }
        if ($deliver) {
            ilUtil::deliverData($csv, ilFileUtils::getASCIIFilename($this->test_obj->getTitle() . "_aggregated.csv"));
            exit;
        } else {
            return $csv;
        }
    }

References $data, ILIAS\LTI\ToolProvider\$key, $rows, ilUtil\deliverData(), exit, ilFileUtils\getASCIIFilename(), and ILIAS\Repository\lng().

Referenced by exportToCSV().

Here is the call graph for this function:

Here is the caller graph for this function:

aggregatedResultsToExcel()

ilTestExport::aggregatedResultsToExcel (   $deliver = true )

protected

Exports the aggregated results to the Microsoft Excel file format.

Parameters

boolean

$deliver

TRUE to directly deliver the file, FALSE to return the binary data

Definition at line 229 of file class.ilTestExport.php.

                                                                : string
    {
        $data = $this->test_obj->getAggregatedResultsData();
 
        require_once 'Modules/TestQuestionPool/classes/class.ilAssExcelFormatHelper.php';
        $worksheet = new ilAssExcelFormatHelper();
        $worksheet->addSheet($this->lng->txt('tst_results_aggregated'));
 
        $row = 1;
        $col = 0;
        $worksheet->setCell($row, $col++, $this->lng->txt('result'));
        $worksheet->setCell($row, $col++, $this->lng->txt('value'));
 
        $worksheet->setBold('A' . $row . ':' . $worksheet->getColumnCoord($col - 1) . $row);
 
        $row++;
        foreach ($data['overview'] as $key => $value) {
            $col = 0;
            $worksheet->setCell($row, $col++, $key);
            $worksheet->setCell($row, $col++, $value);
            $row++;
        }
 
        $row++;
        $col = 0;
 
        $worksheet->setCell($row, $col++, $this->lng->txt('question_id'));
        $worksheet->setCell($row, $col++, $this->lng->txt('question_title'));
        $worksheet->setCell($row, $col++, $this->lng->txt('average_reached_points'));
        $worksheet->setCell($row, $col++, $this->lng->txt('points'));
        $worksheet->setCell($row, $col++, $this->lng->txt('percentage'));
        $worksheet->setCell($row, $col++, $this->lng->txt('number_of_answers'));
 
        $worksheet->setBold('A' . $row . ':' . $worksheet->getColumnCoord($col - 1) . $row);
 
        $row++;
        foreach ($data['questions'] as $key => $value) {
            $col = 0;
            $worksheet->setCell($row, $col++, $key);
            $worksheet->setCell($row, $col++, $value[0]);
            $worksheet->setCell($row, $col++, $value[4]);
            $worksheet->setCell($row, $col++, $value[5]);
            $worksheet->setCell($row, $col++, $value[6]);
            $worksheet->setCell($row, $col++, $value[3]);
            $row++;
        }
 
        if ($deliver) {
            $worksheet->sendToClient(
                ilFileUtils::getASCIIFilename(preg_replace("/\s/", '_', $this->test_obj->getTitle() . '_aggregated')) . '.xlsx'
            );
        }
        $excelfile = ilFileUtils::ilTempnam();
        $worksheet->writeToFile($excelfile);
        return $excelfile . '.xlsx';
    }

References $data, ILIAS\LTI\ToolProvider\$key, ilFileUtils\getASCIIFilename(), ilFileUtils\ilTempnam(), and ILIAS\Repository\lng().

Referenced by exportToExcel().

Here is the call graph for this function:

Here is the caller graph for this function:

buildExportFile()

ilTestExport::buildExportFile

(

)

build export file (complete zip file)

@access public

Returns

Definition at line 176 of file class.ilTestExport.php.

                                     : string
    {
        switch ($this->mode) {
            case "results":
                return $this->buildExportResultFile();
                break;
            default:
                return $this->buildExportFileXML();
                break;
        }
    }

References buildExportFileXML(), and buildExportResultFile().

Here is the call graph for this function:

buildExportFileXML()

ilTestExport::buildExportFileXML

(

)

build xml export file

Definition at line 1110 of file class.ilTestExport.php.

                                        : string
    {
        global $DIC;
        $ilBench = $DIC['ilBench'];
 
        $ilBench->start("TestExport", "buildExportFile");
 
        $this->initXmlExport();
 
        include_once("./Services/Xml/classes/class.ilXmlWriter.php");
        $this->xml = new ilXmlWriter();
 
        // set dtd definition
        $this->xml->xmlSetDtdDef("<!DOCTYPE Test SYSTEM \"http://www.ilias.uni-koeln.de/download/dtd/ilias_co.dtd\">");
 
        // set generated comment
        $this->xml->xmlSetGenCmt("Export of ILIAS Test " .
            $this->test_obj->getId() . " of installation " . $this->inst_id . ".");
 
        // set xml header
        $this->xml->xmlHeader();
 
        $this->xml->xmlStartTag("ContentObject", array('Type' => 'Test'));
 
        // create directories
        $this->test_obj->createExportDirectory();
        include_once "./Services/Utilities/classes/class.ilUtil.php";
        ilFileUtils::makeDir($this->export_dir . "/" . $this->subdir);
        ilFileUtils::makeDir($this->export_dir . "/" . $this->subdir . "/objects");
 
        // get Log File
        $expDir = $this->test_obj->getExportDirectory();
        include_once "./Services/Logging/classes/class.ilLog.php";
        $expLog = new ilLog($expDir, "export.log");
        $expLog->delete();
        $expLog->setLogFormat("");
        $expLog->write(date("[y-m-d H:i:s] ") . "Start Export");
 
        // write qti file
        $qti_file = fopen($this->export_dir . "/" . $this->subdir . "/" . $this->qti_filename, "w");
        fwrite($qti_file, $this->getQtiXml());
        fclose($qti_file);
 
        // get xml content
        $ilBench->start("TestExport", "buildExportFile_getXML");
        $this->test_obj->exportPagesXML(
            $this->xml,
            $this->inst_id,
            $this->export_dir . "/" . $this->subdir,
            $expLog
        );
        $ilBench->stop("TestExport", "buildExportFile_getXML");
 
        $this->populateQuestionSetConfigXml($this->xml);
 
        $assignmentList = $this->buildQuestionSkillAssignmentList();
        $this->populateQuestionSkillAssignmentsXml($this->xml, $assignmentList, $this->getQuestionIds());
        $this->populateSkillLevelThresholdsXml($this->xml, $assignmentList);
 
        $this->xml->xmlEndTag("ContentObject");
 
        // dump xml document to screen (only for debugging reasons)
        /*
        echo "<PRE>";
        echo htmlentities($this->xml->xmlDumpMem($format));
        echo "</PRE>";
        */
 
        // dump xml document to file
        $ilBench->start("TestExport", "buildExportFile_dumpToFile");
        $this->xml->xmlDumpFile($this->export_dir . "/" . $this->subdir . "/" . $this->filename, false);
        $ilBench->stop("TestExport", "buildExportFile_dumpToFile");
 
        if ($this->isResultExportingEnabledForTestExport() && @file_exists("./Modules/Test/classes/class.ilTestResultsToXML.php")) {
            // dump results xml document to file
            include_once "./Modules/Test/classes/class.ilTestResultsToXML.php";
            $resultwriter = new ilTestResultsToXML($this->test_obj->getTestId(), $this->test_obj->getAnonymity());
            $resultwriter->setIncludeRandomTestQuestionsEnabled($this->test_obj->isRandomTest());
            $ilBench->start("TestExport", "buildExportFile_results");
            $resultwriter->xmlDumpFile($this->export_dir . "/" . $this->subdir . "/" . $this->resultsfile, false);
            $ilBench->stop("TestExport", "buildExportFile_results");
        }
 
        // add media objects which were added with tiny mce
        $ilBench->start("QuestionpoolExport", "buildExportFile_saveAdditionalMobs");
        $this->exportXHTMLMediaObjects($this->export_dir . "/" . $this->subdir);
        $ilBench->stop("QuestionpoolExport", "buildExportFile_saveAdditionalMobs");
 
        // zip the file
        $ilBench->start("TestExport", "buildExportFile_zipFile");
        ilFileUtils::zip(
            $this->export_dir . "/" . $this->subdir,
            $this->export_dir . "/" . $this->subdir . ".zip"
        );
        $ilBench->stop("TestExport", "buildExportFile_zipFile");
 
        // destroy writer object
        $this->xml = null;
 
        $expLog->write(date("[y-m-d H:i:s] ") . "Finished Export");
        $ilBench->stop("TestExport", "buildExportFile");
 
        return $this->export_dir . "/" . $this->subdir . ".zip";
    }

References $DIC, buildQuestionSkillAssignmentList(), exportXHTMLMediaObjects(), getQtiXml(), getQuestionIds(), initXmlExport(), isResultExportingEnabledForTestExport(), ilFileUtils\makeDir(), populateQuestionSetConfigXml(), populateQuestionSkillAssignmentsXml(), populateSkillLevelThresholdsXml(), and ilFileUtils\zip().

Referenced by buildExportFile().

Here is the call graph for this function:

Here is the caller graph for this function:

buildExportResultFile()

ilTestExport::buildExportResultFile

(

)

build xml export file

Definition at line 191 of file class.ilTestExport.php.

                                           : string
    {
        global $DIC;
        $ilBench = $DIC['ilBench'];
        $log = $DIC['log'];
 
        //get Log File
        $expDir = $this->test_obj->getExportDirectory();
 
        // make_directories
        $this->test_obj->createExportDirectory();
        include_once "./Services/Utilities/classes/class.ilUtil.php";
        ilFileUtils::makeDir($this->export_dir);
 
        include_once './Services/Logging/classes/class.ilLog.php';
        $expLog = new ilLog($expDir, "export.log");
        $expLog->delete();
        $expLog->setLogFormat("");
        $expLog->write(date("[y-m-d H:i:s] ") . "Start Export Of Results");
 
        $data = $this->exportToCSV($deliver = false);
        $file = fopen($this->export_dir . "/" . $this->filename, "w");
        fwrite($file, $data);
        fclose($file);
 
        $excelfile = $this->exportToExcel($deliver = false);
        @copy($excelfile, $this->export_dir . "/" . str_replace($this->getExtension(), "xlsx", $this->filename));
        @unlink($excelfile);
        // end
        $expLog->write(date("[y-m-d H:i:s] ") . "Finished Export of Results");
 
        return $this->export_dir . "/" . $this->filename;
    }

References $data, $DIC, $filename, $log, exportToCSV(), exportToExcel(), getExtension(), and ilFileUtils\makeDir().

Referenced by buildExportFile().

Here is the call graph for this function:

Here is the caller graph for this function:

buildQuestionSkillAssignmentList()

ilTestExport::buildQuestionSkillAssignmentList ( )

protected

Returns

ilAssQuestionSkillAssignmentList

Definition at line 1306 of file class.ilTestExport.php.

                                                         : ilAssQuestionSkillAssignmentList
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        require_once 'Modules/TestQuestionPool/classes/class.ilAssQuestionSkillAssignmentList.php';
        $assignmentList = new ilAssQuestionSkillAssignmentList($ilDB);
        $assignmentList->setParentObjId($this->test_obj->getId());
        $assignmentList->loadFromDb();
        $assignmentList->loadAdditionalSkillData();
 
        return $assignmentList;
    }

References $DIC, and $ilDB.

Referenced by buildExportFileXML().

Here is the caller graph for this function:

exportToCSV()

ilTestExport::exportToCSV	(		$deliver = true,
			$filterby = "",
			$filtertext = "",
			$passedonly = false
	)

Exports the evaluation data to the CSV file format.

Exports the evaluation data to the CSV file format

Parameters

string	$filtertext	Filter text for the user data
boolean	$passedonly	TRUE if only passed user datasets should be exported, FALSE otherwise @access public

Definition at line 873 of file class.ilTestExport.php.

    {
        $this->test_obj->setAccessFilteredParticipantList(
            $this->test_obj->buildStatisticsAccessFilteredParticipantList()
        );
 
        if (strcmp($this->mode, "aggregated") == 0) {
            return $this->aggregatedResultsToCSV($deliver);
        }
 
        $rows = array();
        $datarow = array();
        $col = 1;
        if ($this->test_obj->getAnonymity()) {
            array_push($datarow, $this->lng->txt("counter"));
            $col++;
        } else {
            array_push($datarow, $this->lng->txt("name"));
            $col++;
            array_push($datarow, $this->lng->txt("login"));
            $col++;
        }
        $additionalFields = $this->test_obj->getEvaluationAdditionalFields();
        if (count($additionalFields)) {
            foreach ($additionalFields as $fieldname) {
                if (strcmp($fieldname, "exam_id") == 0) {
                    array_push($datarow, $this->lng->txt('exam_id_label'));
                    $col++;
                    continue;
                }
                array_push($datarow, $this->lng->txt($fieldname));
                $col++;
            }
        }
        array_push($datarow, $this->lng->txt("tst_stat_result_resultspoints"));
        $col++;
        array_push($datarow, $this->lng->txt("maximum_points"));
        $col++;
        array_push($datarow, $this->lng->txt("tst_stat_result_resultsmarks"));
        $col++;
        if ($this->test_obj->getECTSOutput()) {
            array_push($datarow, $this->lng->txt("ects_grade"));
            $col++;
        }
        array_push($datarow, $this->lng->txt("tst_stat_result_qworkedthrough"));
        $col++;
        array_push($datarow, $this->lng->txt("tst_stat_result_qmax"));
        $col++;
        array_push($datarow, $this->lng->txt("tst_stat_result_pworkedthrough"));
        $col++;
        array_push($datarow, $this->lng->txt("tst_stat_result_timeofwork"));
        $col++;
        array_push($datarow, $this->lng->txt("tst_stat_result_atimeofwork"));
        $col++;
        array_push($datarow, $this->lng->txt("tst_stat_result_firstvisit"));
        $col++;
        array_push($datarow, $this->lng->txt("tst_stat_result_lastvisit"));
        $col++;
 
        array_push($datarow, $this->lng->txt("tst_stat_result_mark_median"));
        $col++;
        array_push($datarow, $this->lng->txt("tst_stat_result_rank_participant"));
        $col++;
        array_push($datarow, $this->lng->txt("tst_stat_result_rank_median"));
        $col++;
        array_push($datarow, $this->lng->txt("tst_stat_result_total_participants"));
        $col++;
        array_push($datarow, $this->lng->txt("tst_stat_result_median"));
        $col++;
        array_push($datarow, $this->lng->txt("tst_tbl_col_started_passes"));
        $col++;
        array_push($datarow, $this->lng->txt("tst_tbl_col_finished_passes"));
        $col++;
 
        array_push($datarow, $this->lng->txt("scored_pass"));
        $col++;
 
        array_push($datarow, $this->lng->txt("pass"));
        $col++;
 
        $data = &$this->test_obj->getCompleteEvaluationData(true, $filterby, $filtertext);
        $headerrow = $datarow;
        $counter = 1;
        foreach ($data->getParticipants() as $active_id => $userdata) {
            $datarow = $headerrow;
            $remove = false;
            if ($passedonly) {
                if ($data->getParticipant($active_id)->getPassed() == false) {
                    $remove = true;
                }
            }
            if (!$remove) {
                $datarow2 = array();
                if ($this->test_obj->getAnonymity()) {
                    array_push($datarow2, $counter);
                } else {
                    array_push($datarow2, $data->getParticipant($active_id)->getName());
                    array_push($datarow2, $data->getParticipant($active_id)->getLogin());
                }
                if (count($additionalFields)) {
                    $userfields = ilObjUser::_lookupFields($userdata->getUserID());
                    foreach ($additionalFields as $fieldname) {
                        if (strcmp($fieldname, "gender") == 0) {
                            array_push($datarow2, strlen($userfields[$fieldname]) ? $this->lng->txt('gender_' . $userfields[$fieldname]) : '');
                        } elseif (strcmp($fieldname, "exam_id") == 0) {
                            array_push($datarow2, $userdata->getExamIdFromScoredPass());
                        } else {
                            array_push($datarow2, $userfields[$fieldname]);
                        }
                    }
                }
                array_push($datarow2, $data->getParticipant($active_id)->getReached());
                array_push($datarow2, $data->getParticipant($active_id)->getMaxpoints());
                array_push($datarow2, $data->getParticipant($active_id)->getMark());
                if ($this->test_obj->getECTSOutput()) {
                    array_push($datarow2, $data->getParticipant($active_id)->getECTSMark());
                }
                array_push($datarow2, $data->getParticipant($active_id)->getQuestionsWorkedThrough());
                array_push($datarow2, $data->getParticipant($active_id)->getNumberOfQuestions());
                array_push($datarow2, $data->getParticipant($active_id)->getQuestionsWorkedThroughInPercent() / 100.0);
                $time = $data->getParticipant($active_id)->getTimeOfWork();
                $time_seconds = $time;
                $time_hours = floor($time_seconds / 3600);
                $time_seconds -= $time_hours * 3600;
                $time_minutes = floor($time_seconds / 60);
                $time_seconds -= $time_minutes * 60;
                array_push($datarow2, sprintf("%02d:%02d:%02d", $time_hours, $time_minutes, $time_seconds));
                $time = $data->getParticipant($active_id)->getQuestionsWorkedThrough() ? $data->getParticipant($active_id)->getTimeOfWork() / $data->getParticipant($active_id)->getQuestionsWorkedThrough() : 0;
                $time_seconds = $time;
                $time_hours = floor($time_seconds / 3600);
                $time_seconds -= $time_hours * 3600;
                $time_minutes = floor($time_seconds / 60);
                $time_seconds -= $time_minutes * 60;
                array_push($datarow2, sprintf("%02d:%02d:%02d", $time_hours, $time_minutes, $time_seconds));
 
                $fv = $data->getParticipant($active_id)->getFirstVisit();
                $lv = $data->getParticipant($active_id)->getLastVisit();
                foreach (array($fv, $lv) as $ts) {
                    if ($ts) {
                        $visit = ilDatePresentation::formatDate(new ilDateTime($ts, IL_CAL_UNIX));
                        array_push($datarow2, $visit);
                    } else {
                        array_push($datarow2, "");
                    }
                }
 
                $median = $data->getStatistics()->getStatistics()->median();
                $pct = $data->getParticipant($active_id)->getMaxpoints() ? $median / $data->getParticipant($active_id)->getMaxpoints() * 100.0 : 0;
                $mark = $this->test_obj->mark_schema->getMatchingMark($pct);
                $mark_short_name = "";
                if (is_object($mark)) {
                    $mark_short_name = $mark->getShortName();
                }
                array_push($datarow2, $mark_short_name);
                array_push($datarow2, $data->getStatistics()->getStatistics()->rank($data->getParticipant($active_id)->getReached()));
                array_push($datarow2, $data->getStatistics()->getStatistics()->rank_median());
                array_push($datarow2, $data->getStatistics()->getStatistics()->count());
                array_push($datarow2, $median);
 
                array_push($datarow2, $data->getParticipant($active_id)->getPassCount());
                array_push($datarow2, $data->getParticipant($active_id)->getFinishedPasses());
                if ($this->test_obj->getPassScoring() == SCORE_BEST_PASS) {
                    array_push($datarow2, $data->getParticipant($active_id)->getBestPass() + 1);
                } else {
                    array_push($datarow2, $data->getParticipant($active_id)->getLastPass() + 1);
                }
                for ($pass = 0; $pass <= $data->getParticipant($active_id)->getLastPass(); $pass++) {
                    $finishdate = ilObjTest::lookupPassResultsUpdateTimestamp($active_id, $pass);
                    if ($finishdate > 0) {
                        if ($pass > 0) {
                            for ($i = 1; $i < $col - 1; $i++) {
                                array_push($datarow2, "");
                                array_push($datarow, "");
                            }
                            array_push($datarow, "");
                        }
                        array_push($datarow2, $pass + 1);
                        if (is_object($data->getParticipant($active_id)) && is_array($evaluated_questions = $data->getParticipant($active_id)->getQuestions($pass))) {
                            $questions = $this->orderQuestions($evaluated_questions);
                            foreach ($questions as $question) {
                                $question_data = $data->getParticipant($active_id)->getPass($pass)->getAnsweredQuestionByQuestionId($question["id"]);
                                if (is_null($question_data)) {
                                    $question_data = ['reached' => 0];
                                }
                                array_push($datarow2, $question_data["reached"]);
                                array_push($datarow, preg_replace("/<.*?>/", "", $data->getQuestionTitle($question["id"])));
                            }
                        }
                        if ($this->test_obj->isRandomTest() ||
                            $counter == 1 && $pass == 0) {
                            array_push($rows, $datarow);
                        }
                        $datarow = array();
                        array_push($rows, $datarow2);
                        $datarow2 = array();
                    }
                }
                $counter++;
            }
        }
        $csv = "";
        $separator = ";";
        foreach ($rows as $evalrow) {
            $csvrow = &$this->test_obj->processCSVRow($evalrow, true, $separator);
            $csv .= join($separator, $csvrow) . "\n";
        }
        if ($deliver) {
            ilUtil::deliverData($csv, ilFileUtils::getASCIIFilename($this->test_obj->getTitle() . "_results.csv"));
            exit;
        } else {
            return $csv;
        }
    }

References $data, $i, $rows, ilObjUser\_lookupFields(), aggregatedResultsToCSV(), ilUtil\deliverData(), exit, ilDatePresentation\formatDate(), ilFileUtils\getASCIIFilename(), IL_CAL_UNIX, ILIAS\Repository\lng(), ilObjTest\lookupPassResultsUpdateTimestamp(), orderQuestions(), and SCORE_BEST_PASS.

Referenced by buildExportResultFile().

Here is the call graph for this function:

Here is the caller graph for this function:

exportToExcel()

ilTestExport::exportToExcel	(		$deliver = true,
			$filterby = "",
			$filtertext = "",
			$passedonly = false
	)

Exports the evaluation data to the Microsoft Excel file format.

Parameters

bool	$deliver
string	$filterby
string	$filtertext	Filter text for the user data
boolean	$passedonly	TRUE if only passed user datasets should be exported, FALSE otherwise

Definition at line 345 of file class.ilTestExport.php.

    {
        $this->test_obj->setAccessFilteredParticipantList($this->getAccessFilteredParticipantList());
 
        if (strcmp($this->mode, "aggregated") == 0) {
            return $this->aggregatedResultsToExcel($deliver);
        }
 
        require_once 'Modules/TestQuestionPool/classes/class.ilAssExcelFormatHelper.php';
 
        $worksheet = new ilAssExcelFormatHelper();
        $worksheet->addSheet($this->lng->txt('tst_results'));
 
        $additionalFields = $this->test_obj->getEvaluationAdditionalFields();
 
        $row = 1;
        $col = 0;
 
        if ($this->test_obj->getAnonymity()) {
            $worksheet->setFormattedExcelTitle($worksheet->getColumnCoord($col++) . $row, $this->lng->txt('counter'));
        } else {
            $worksheet->setFormattedExcelTitle($worksheet->getColumnCoord($col++) . $row, $this->lng->txt('name'));
            $worksheet->setFormattedExcelTitle($worksheet->getColumnCoord($col++) . $row, $this->lng->txt('login'));
        }
 
        if (count($additionalFields)) {
            foreach ($additionalFields as $fieldname) {
                if (strcmp($fieldname, "exam_id") == 0) {
                    $worksheet->setFormattedExcelTitle(
                        $worksheet->getColumnCoord($col++) . $row,
                        $this->lng->txt('exam_id_label')
                    );
                    continue;
                }
                $worksheet->setFormattedExcelTitle(
                    $worksheet->getColumnCoord($col++) . $row,
                    $this->lng->txt($fieldname)
                );
            }
        }
 
        $worksheet->setFormattedExcelTitle(
            $worksheet->getColumnCoord($col++) . $row,
            $this->lng->txt('tst_stat_result_resultspoints')
        );
        $worksheet->setFormattedExcelTitle(
            $worksheet->getColumnCoord($col++) . $row,
            $this->lng->txt('maximum_points')
        );
        $worksheet->setFormattedExcelTitle(
            $worksheet->getColumnCoord($col++) . $row,
            $this->lng->txt('tst_stat_result_resultsmarks')
        );
 
        if ($this->test_obj->getECTSOutput()) {
            $worksheet->setFormattedExcelTitle(
                $worksheet->getColumnCoord($col++) . $row,
                $this->lng->txt('ects_grade')
            );
        }
 
        $worksheet->setFormattedExcelTitle(
            $worksheet->getColumnCoord($col++) . $row,
            $this->lng->txt('tst_stat_result_qworkedthrough')
        );
        $worksheet->setFormattedExcelTitle(
            $worksheet->getColumnCoord($col++) . $row,
            $this->lng->txt('tst_stat_result_qmax')
        );
        $worksheet->setFormattedExcelTitle(
            $worksheet->getColumnCoord($col++) . $row,
            $this->lng->txt('tst_stat_result_pworkedthrough')
        );
        $worksheet->setFormattedExcelTitle(
            $worksheet->getColumnCoord($col++) . $row,
            $this->lng->txt('tst_stat_result_timeofwork')
        );
        $worksheet->setFormattedExcelTitle(
            $worksheet->getColumnCoord($col++) . $row,
            $this->lng->txt('tst_stat_result_atimeofwork')
        );
        $worksheet->setFormattedExcelTitle(
            $worksheet->getColumnCoord($col++) . $row,
            $this->lng->txt('tst_stat_result_firstvisit')
        );
        $worksheet->setFormattedExcelTitle(
            $worksheet->getColumnCoord($col++) . $row,
            $this->lng->txt('tst_stat_result_lastvisit')
        );
        $worksheet->setFormattedExcelTitle(
            $worksheet->getColumnCoord($col++) . $row,
            $this->lng->txt('tst_stat_result_mark_median')
        );
        $worksheet->setFormattedExcelTitle(
            $worksheet->getColumnCoord($col++) . $row,
            $this->lng->txt('tst_stat_result_rank_participant')
        );
        $worksheet->setFormattedExcelTitle(
            $worksheet->getColumnCoord($col++) . $row,
            $this->lng->txt('tst_stat_result_rank_median')
        );
        $worksheet->setFormattedExcelTitle(
            $worksheet->getColumnCoord($col++) . $row,
            $this->lng->txt('tst_stat_result_total_participants')
        );
        $worksheet->setFormattedExcelTitle(
            $worksheet->getColumnCoord($col++) . $row,
            $this->lng->txt('tst_stat_result_median')
        );
        $worksheet->setFormattedExcelTitle($worksheet->getColumnCoord($col++) . $row, $this->lng->txt('tst_tbl_col_started_passes'));
        $worksheet->setFormattedExcelTitle($worksheet->getColumnCoord($col++) . $row, $this->lng->txt('tst_tbl_col_finished_passes'));
        $worksheet->setFormattedExcelTitle($worksheet->getColumnCoord($col++) . $row, $this->lng->txt('tst_tbl_col_started_passes'));
        $worksheet->setFormattedExcelTitle($worksheet->getColumnCoord($col++) . $row, $this->lng->txt('tst_tbl_col_finished_passes'));
        $worksheet->setFormattedExcelTitle($worksheet->getColumnCoord($col++) . $row, $this->lng->txt('scored_pass'));
        $worksheet->setFormattedExcelTitle($worksheet->getColumnCoord($col++) . $row, $this->lng->txt('pass'));
 
        $worksheet->setBold('A' . $row . ':' . $worksheet->getColumnCoord($col - 1) . $row);
 
        $counter = 1;
        $data = $this->test_obj->getCompleteEvaluationData(true, $filterby, $filtertext);
        $firstrowwritten = false;
        foreach ($data->getParticipants() as $active_id => $userdata) {
            if ($passedonly && $data->getParticipant($active_id)->getPassed() == false) {
                continue;
            }
 
            $row++;
            $col = 0;
 
            // each participant gets an own row for question column headers
            if ($this->test_obj->isRandomTest() && $firstrowwritten) {
                $row++;
            }
 
            if ($this->test_obj->getAnonymity()) {
                $worksheet->setCell($row, $col++, $counter);
            } else {
                $worksheet->setCell($row, $col++, $data->getParticipant($active_id)->getName());
                $worksheet->setCell($row, $col++, $data->getParticipant($active_id)->getLogin());
            }
 
            if (count($additionalFields)) {
                $userfields = ilObjUser::_lookupFields($userdata->getUserId());
                foreach ($additionalFields as $fieldname) {
                    if (strcmp($fieldname, 'gender') == 0) {
                        $worksheet->setCell($row, $col++, strlen($userfields[$fieldname]) ? $this->lng->txt('gender_' . $userfields[$fieldname]) : '');
                    } elseif (strcmp($fieldname, "exam_id") == 0) {
                        $worksheet->setCell($row, $col++, $userdata->getExamIdFromScoredPass());
                    } else {
                        $worksheet->setCell($row, $col++, $userfields[$fieldname]);
                    }
                }
            }
 
            $worksheet->setCell($row, $col++, $data->getParticipant($active_id)->getReached());
            $worksheet->setCell($row, $col++, $data->getParticipant($active_id)->getMaxpoints());
            $worksheet->setCell($row, $col++, $data->getParticipant($active_id)->getMark());
 
            if ($this->test_obj->getECTSOutput()) {
                $worksheet->setCell($row, $col++, $data->getParticipant($active_id)->getECTSMark());
            }
 
            $worksheet->setCell($row, $col++, $data->getParticipant($active_id)->getQuestionsWorkedThrough());
            $worksheet->setCell($row, $col++, $data->getParticipant($active_id)->getNumberOfQuestions());
            $worksheet->setCell(
                $row,
                $col++,
                $data->getParticipant($active_id)->getQuestionsWorkedThroughInPercent() . '%'
            );
 
            $time = $data->getParticipant($active_id)->getTimeOfWork();
            $time_seconds = $time;
            $time_hours = floor($time_seconds / 3600);
            $time_seconds -= $time_hours * 3600;
            $time_minutes = floor($time_seconds / 60);
            $time_seconds -= $time_minutes * 60;
            $worksheet->setCell($row, $col++, sprintf("%02d:%02d:%02d", $time_hours, $time_minutes, $time_seconds));
            $time = $data->getParticipant($active_id)->getQuestionsWorkedThrough() ? $data->getParticipant($active_id)->getTimeOfWork() / $data->getParticipant($active_id)->getQuestionsWorkedThrough() : 0;
            $time_seconds = $time;
            $time_hours = floor($time_seconds / 3600);
            $time_seconds -= $time_hours * 3600;
            $time_minutes = floor($time_seconds / 60);
            $time_seconds -= $time_minutes * 60;
            $worksheet->setCell($row, $col++, sprintf("%02d:%02d:%02d", $time_hours, $time_minutes, $time_seconds));
            $worksheet->setCell(
                $row,
                $col++,
                new ilDateTime($data->getParticipant($active_id)->getFirstVisit(), IL_CAL_UNIX)
            );
            $worksheet->setCell(
                $row,
                $col++,
                new ilDateTime($data->getParticipant($active_id)->getLastVisit(), IL_CAL_UNIX)
            );
 
            $median = $data->getStatistics()->getStatistics()->median();
            $pct = $data->getParticipant($active_id)->getMaxpoints() ? $median / $data->getParticipant($active_id)->getMaxpoints() * 100.0 : 0;
            $mark = $this->test_obj->mark_schema->getMatchingMark($pct);
            $mark_short_name = "";
 
            if (is_object($mark)) {
                $mark_short_name = $mark->getShortName();
            }
 
            $worksheet->setCell($row, $col++, $mark_short_name);
            $worksheet->setCell(
                $row,
                $col++,
                $data->getStatistics()->getStatistics()->rank($data->getParticipant($active_id)->getReached())
            );
            $worksheet->setCell($row, $col++, $data->getStatistics()->getStatistics()->rank_median());
            $worksheet->setCell($row, $col++, $data->getStatistics()->getStatistics()->count());
            $worksheet->setCell($row, $col++, $median);
            $worksheet->setCell($row, $col++, $data->getParticipant($active_id)->getPassCount());
            $worksheet->setCell($row, $col++, $data->getParticipant($active_id)->getFinishedPasses());
            if ($this->test_obj->getPassScoring() == SCORE_BEST_PASS) {
                $worksheet->setCell($row, $col++, $data->getParticipant($active_id)->getBestPass() + 1);
            } else {
                $worksheet->setCell($row, $col++, $data->getParticipant($active_id)->getLastPass() + 1);
            }
 
            $startcol = $col;
 
            for ($pass = 0; $pass <= $data->getParticipant($active_id)->getLastPass(); $pass++) {
                $col = $startcol;
                $finishdate = ilObjTest::lookupPassResultsUpdateTimestamp($active_id, $pass);
                if ($finishdate > 0) {
                    if ($pass > 0) {
                        $row++;
                        if ($this->test_obj->isRandomTest()) {
                            $row++;
                        }
                    }
                    $worksheet->setCell($row, $col++, $pass + 1);
                    if (is_object($data->getParticipant($active_id)) && is_array($data->getParticipant($active_id)->getQuestions($pass))) {
                        $evaluated_questions = $data->getParticipant($active_id)->getQuestions($pass);
                        $questions = $this->orderQuestions($evaluated_questions);
 
                        foreach ($questions as $question) {
                            $question_data = $data->getParticipant($active_id)->getPass($pass)->getAnsweredQuestionByQuestionId($question["id"]);
                            if (is_null($question_data)) {
                                $question_data = ['reached' => 0];
                            }
                            $worksheet->setCell($row, $col, $question_data["reached"]);
                            if ($this->test_obj->isRandomTest()) {
                                // random test requires question headers for every participant
                                // and we allready skipped a row for that reason ( --> row - 1)
                                $worksheet->setFormattedExcelTitle(
                                    $worksheet->getColumnCoord($col) . ($row - 1),
                                    preg_replace("/<.*?>/", "", $data->getQuestionTitle($question["id"]))
                                );
                            } else {
                                if ($pass == 0 && !$firstrowwritten) {
                                    $worksheet->setFormattedExcelTitle(
                                        $worksheet->getColumnCoord($col) . 1,
                                        $data->getQuestionTitle($question["id"])
                                    );
                                }
                            }
                            $col++;
                        }
                        $firstrowwritten = true;
                    }
                }
            }
            $counter++;
        }
 
        if ($this->test_obj->getExportSettingsSingleChoiceShort() && !$this->test_obj->isRandomTest() && $this->test_obj->hasSingleChoiceQuestions()) {
            // special tab for single choice tests
            $titles = $this->test_obj->getQuestionTitlesAndIndexes();
            $positions = array();
            $pos = 0;
            $row = 1;
            foreach ($titles as $id => $title) {
                $positions[$id] = $pos;
                $pos++;
            }
 
            $usernames = array();
            $participantcount = count($data->getParticipants());
            $allusersheet = false;
            $pages = 0;
 
            $worksheet->addSheet($this->lng->txt('eval_all_users'));
 
            $col = 0;
            $worksheet->setFormattedExcelTitle($worksheet->getColumnCoord($col++) . $row, $this->lng->txt('name'));
            $worksheet->setFormattedExcelTitle($worksheet->getColumnCoord($col++) . $row, $this->lng->txt('login'));
            if (count($additionalFields)) {
                foreach ($additionalFields as $fieldname) {
                    if (strcmp($fieldname, "matriculation") == 0) {
                        $worksheet->setFormattedExcelTitle(
                            $worksheet->getColumnCoord($col++) . $row,
                            $this->lng->txt('matriculation')
                        );
                    }
                    if (strcmp($fieldname, "exam_id") == 0) {
                        $worksheet->setFormattedExcelTitle(
                            $worksheet->getColumnCoord($col++) . $row,
                            $this->lng->txt('exam_id_label')
                        );
                    }
                }
            }
            $worksheet->setFormattedExcelTitle($worksheet->getColumnCoord($col++) . $row, $this->lng->txt('test'));
            foreach ($titles as $title) {
                $worksheet->setFormattedExcelTitle($worksheet->getColumnCoord($col++) . $row, $title);
            }
            $worksheet->setBold('A' . $row . ':' . $worksheet->getColumnCoord($col - 1) . $row);
 
            $row++;
            foreach ($data->getParticipants() as $active_id => $userdata) {
                $username = (!is_null($userdata) && $userdata->getName()) ? $userdata->getName() : "ID $active_id";
                if (array_key_exists($username, $usernames)) {
                    $usernames[$username]++;
                    $username .= " ($usernames[$username])";
                } else {
                    $usernames[$username] = 1;
                }
                $col = 0;
                $worksheet->setCell($row, $col++, $username);
                $worksheet->setCell($row, $col++, $userdata->getLogin());
                if (count($additionalFields)) {
                    $userfields = ilObjUser::_lookupFields($userdata->getUserID());
                    foreach ($additionalFields as $fieldname) {
                        if (strcmp($fieldname, "matriculation") == 0) {
                            if (strlen($userfields[$fieldname])) {
                                $worksheet->setCell($row, $col++, $userfields[$fieldname]);
                            } else {
                                $col++;
                            }
                        }
                        if (strcmp($fieldname, "exam_id") == 0) {
                            if (strlen($userfields[$fieldname])) {
                                $worksheet->setCell($row, $col++, $userdata->getExamIdFromScoredPass());
                            } else {
                                $col++;
                            }
                        }
                    }
                }
                $worksheet->setCell($row, $col++, $this->test_obj->getTitle());
                $pass = $userdata->getScoredPass();
                if (is_object($userdata) && is_array($userdata->getQuestions($pass))) {
                    foreach ($userdata->getQuestions($pass) as $question) {
                        $objQuestion = assQuestion::_instantiateQuestion($question["id"]);
                        if (is_object($objQuestion) && strcmp(
                            $objQuestion->getQuestionType(),
                            'assSingleChoice'
                        ) == 0) {
                            $solution = $objQuestion->getSolutionValues($active_id, $pass);
                            $pos = $positions[$question["id"]];
                            $selectedanswer = "x";
                            foreach ($objQuestion->getAnswers() as $id => $answer) {
                                if (strlen($solution[0]["value1"]) && $id == $solution[0]["value1"]) {
                                    $selectedanswer = $answer->getAnswertext();
                                }
                            }
                            $worksheet->setCell($row, $col + $pos, $selectedanswer);
                        }
                    }
                }
                $row++;
            }
 
            if ($this->test_obj->isSingleChoiceTestWithoutShuffle()) {
                // special tab for single choice tests without shuffle option
                $pos = 0;
                $row = 1;
                $usernames = array();
                $allusersheet = false;
                $pages = 0;
 
                $worksheet->addSheet($this->lng->txt('eval_all_users') . ' (2)');
 
                $col = 0;
                $worksheet->setFormattedExcelTitle($worksheet->getColumnCoord($col++) . $row, $this->lng->txt('name'));
                $worksheet->setFormattedExcelTitle($worksheet->getColumnCoord($col++) . $row, $this->lng->txt('login'));
                if (count($additionalFields)) {
                    foreach ($additionalFields as $fieldname) {
                        if (strcmp($fieldname, "matriculation") == 0) {
                            $worksheet->setFormattedExcelTitle(
                                $worksheet->getColumnCoord($col++) . $row,
                                $this->lng->txt('matriculation')
                            );
                        }
                        if (strcmp($fieldname, "exam_id") == 0) {
                            $worksheet->setFormattedExcelTitle(
                                $worksheet->getColumnCoord($col++) . $row,
                                $this->lng->txt('exam_id_label')
                            );
                        }
                    }
                }
                $worksheet->setFormattedExcelTitle($worksheet->getColumnCoord($col++) . $row, $this->lng->txt('test'));
                foreach ($titles as $title) {
                    $worksheet->setFormattedExcelTitle($worksheet->getColumnCoord($col++) . $row, $title);
                }
                $worksheet->setBold('A' . $row . ':' . $worksheet->getColumnCoord($col - 1) . $row);
 
                $row++;
                foreach ($data->getParticipants() as $active_id => $userdata) {
                    $username = (!is_null($userdata) && $userdata->getName()) ? $userdata->getName() : "ID $active_id";
                    if (array_key_exists($username, $usernames)) {
                        $usernames[$username]++;
                        $username .= " ($usernames[$username])";
                    } else {
                        $usernames[$username] = 1;
                    }
                    $col = 0;
                    $worksheet->setCell($row, $col++, $username);
                    $worksheet->setCell($row, $col++, $userdata->getLogin());
                    if (count($additionalFields)) {
                        $userfields = ilObjUser::_lookupFields($userdata->getUserId());
                        foreach ($additionalFields as $fieldname) {
                            if (strcmp($fieldname, "matriculation") == 0) {
                                if (strlen($userfields[$fieldname])) {
                                    $worksheet->setCell($row, $col++, $userfields[$fieldname]);
                                } else {
                                    $col++;
                                }
                            }
                            if (strcmp($fieldname, "exam_id") == 0) {
                                if (strlen($userfields[$fieldname])) {
                                    $worksheet->setCell($row, $col++, $userdata->getExamIdFromScoredPass());
                                } else {
                                    $col++;
                                }
                            }
                        }
                    }
                    $worksheet->setCell($row, $col++, $this->test_obj->getTitle());
                    $pass = $userdata->getScoredPass();
                    if (is_object($userdata) && is_array($userdata->getQuestions($pass))) {
                        foreach ($userdata->getQuestions($pass) as $question) {
                            $objQuestion = ilObjTest::_instanciateQuestion($question["aid"]);
                            if (is_object($objQuestion) && strcmp(
                                $objQuestion->getQuestionType(),
                                'assSingleChoice'
                            ) == 0) {
                                $solution = $objQuestion->getSolutionValues($active_id, $pass);
                                $pos = $positions[$question["aid"]];
                                $selectedanswer = chr(65 + $solution[0]["value1"]);
                                $worksheet->setCell($row, $col + $pos, $selectedanswer);
                            }
                        }
                    }
                    $row++;
                }
            }
        } else {
            // test participant result export
            $usernames = array();
            $participantcount = count($data->getParticipants());
            $allusersheet = false;
            $pages = 0;
            foreach ($data->getParticipants() as $active_id => $userdata) {
                $username = (!is_null($userdata) && $userdata->getName())
                    ? $userdata->getName()
                    : "ID $active_id";
                $username = mb_substr($username, 0, 26);
                $username_to_lower = strtolower($username);
                if (array_key_exists($username_to_lower, $usernames)) {
                    $usernames[$username_to_lower]++;
                    $username .= " (" . $usernames[$username_to_lower] . ")";
                } else {
                    $usernames[$username_to_lower] = 0;
                }
 
                if ($participantcount > 250) {
                    if (!$allusersheet || ($pages - 1) < floor($row / 64000)) {
                        $worksheet->addSheet($this->lng->txt("eval_all_users") . (($pages > 0) ? " (" . ($pages + 1) . ")" : ""));
                        $allusersheet = true;
                        $row = 1;
                        $pages++;
                    }
                } else {
                    $resultsheet = $worksheet->addSheet($username);
                }
 
                $pass = $userdata->getScoredPass();
                $row = ($allusersheet) ? $row : 1;
                $worksheet->setCell(
                    $row,
                    0,
                    sprintf($this->lng->txt("tst_result_user_name_pass"), $pass + 1, $userdata->getName())
                );
                $worksheet->setBold($worksheet->getColumnCoord(0) . $row);
                $row += 2;
                if (is_object($userdata) && is_array($userdata->getQuestions($pass))) {
                    foreach ($userdata->getQuestions($pass) as $question) {
                        require_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                        $question = assQuestion::instantiateQuestion($question["id"]);
                        if (is_object($question)) {
                            $row = $question->setExportDetailsXLS($worksheet, $row, $active_id, $pass);
                        }
                    }
                }
            }
        }
 
        if ($deliver) {
            $testname = $this->test_obj->getTitle();
            switch ($this->mode) {
                case 'results':
                    $testname .= '_results';
                    break;
            }
            $testname = ilFileUtils::getASCIIFilename(preg_replace("/\s/", "_", $testname)) . '.xlsx';
            $worksheet->sendToClient($testname);
        }
        $excelfile = ilFileUtils::ilTempnam();
        $worksheet->writeToFile($excelfile);
        return $excelfile . '.xlsx';
    }

References $data, $id, ilObjTest\_instanciateQuestion(), assQuestion\_instantiateQuestion(), ilObjUser\_lookupFields(), aggregatedResultsToExcel(), getAccessFilteredParticipantList(), ilFileUtils\getASCIIFilename(), IL_CAL_UNIX, ilFileUtils\ilTempnam(), assQuestion\instantiateQuestion(), ILIAS\Repository\lng(), ilObjTest\lookupPassResultsUpdateTimestamp(), orderQuestions(), and SCORE_BEST_PASS.

Referenced by buildExportResultFile().

Here is the call graph for this function:

Here is the caller graph for this function:

exportXHTMLMediaObjects()

ilTestExport::exportXHTMLMediaObjects

(

$a_export_dir

)

Definition at line 1246 of file class.ilTestExport.php.

    {
        include_once("./Services/MediaObjects/classes/class.ilObjMediaObject.php");
 
        $mobs = ilObjMediaObject::_getMobsOfObject("tst:html", $this->test_obj->getId());
        foreach ($mobs as $mob) {
            if (ilObjMediaObject::_exists($mob)) {
                $mob_obj = new ilObjMediaObject($mob);
                $mob_obj->exportFiles($a_export_dir);
                unset($mob_obj);
            }
        }
        foreach ($this->getQuestionIds() as $question_id) {
            $mobs = ilObjMediaObject::_getMobsOfObject("qpl:html", $question_id);
            foreach ($mobs as $mob) {
                if (ilObjMediaObject::_exists($mob)) {
                    $mob_obj = new ilObjMediaObject($mob);
                    $mob_obj->exportFiles($a_export_dir);
                    unset($mob_obj);
                }
            }
        }
    }

References $mobs, ilObjMediaObject\_exists(), ilObjMediaObject\_getMobsOfObject(), and getQuestionIds().

Referenced by buildExportFileXML().

Here is the call graph for this function:

Here is the caller graph for this function:

getAccessFilteredParticipantList()

ilTestExport::getAccessFilteredParticipantList

(

)

Returns

ilTestParticipantList

Definition at line 145 of file class.ilTestExport.php.

                                                      : ?ilTestParticipantList
    {
        if ($this->getForcedAccessFilteredParticipantList() instanceof ilTestParticipantList) {
            return $this->getForcedAccessFilteredParticipantList();
        }
 
        return $this->test_obj->buildStatisticsAccessFilteredParticipantList();
    }

References getForcedAccessFilteredParticipantList().

Referenced by exportToExcel().

Here is the call graph for this function:

Here is the caller graph for this function:

getExtension()

ilTestExport::getExtension

(

)

Definition at line 154 of file class.ilTestExport.php.

                                  : string
    {
        switch ($this->mode) {
            case "results":
                return "csv"; break;
            default:
                return "xml"; break;
        }
    }

Referenced by __construct(), and buildExportResultFile().

Here is the caller graph for this function:

getForcedAccessFilteredParticipantList()

ilTestExport::getForcedAccessFilteredParticipantList

(

)

Returns

ilTestParticipantList

Definition at line 129 of file class.ilTestExport.php.

                                                            : ?ilTestParticipantList
    {
        return $this->forcedAccessFilteredParticipantList;
    }

References $forcedAccessFilteredParticipantList.

Referenced by getAccessFilteredParticipantList().

Here is the caller graph for this function:

getInstId()

ilTestExport::getInstId

(

)

Definition at line 164 of file class.ilTestExport.php.

    {
        return $this->inst_id;
    }

References $inst_id.

getQtiXml()

ilTestExport::getQtiXml ( )

protected

Definition at line 1217 of file class.ilTestExport.php.

    {
        $tstQtiXml = $this->test_obj->toXML();
        $qstQtiXml = $this->getQuestionsQtiXml();
 
        if (strpos($tstQtiXml, "</section>") !== false) {
            $qtiXml = str_replace("</section>", "$qstQtiXml</section>", $tstQtiXml);
        } else {
            $qtiXml = str_replace("<section ident=\"1\"/>", "<section ident=\"1\">\n$qstQtiXml</section>", $tstQtiXml);
        }
 
        return $qtiXml;
    }

References getQuestionsQtiXml().

Referenced by buildExportFileXML().

Here is the call graph for this function:

Here is the caller graph for this function:

getQuestionIds()

ilTestExport::getQuestionIds ( )

abstractprotected

Reimplemented in ilTestExportDynamicQuestionSet, ilTestExportFixedQuestionSet, and ilTestExportRandomQuestionSet.

Referenced by buildExportFileXML(), and exportXHTMLMediaObjects().

Here is the caller graph for this function:

getQuestionQtiXml()

ilTestExport::getQuestionQtiXml (   $questionId )

protected

Definition at line 1233 of file class.ilTestExport.php.

    {
        include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
        $questionOBJ = assQuestion::_instantiateQuestion($questionId);
        $xml = $questionOBJ->toXML(false);
 
        // still neccessary? there is an include header flag!?
        $xml = preg_replace("/<questestinterop>/", "", $xml);
        $xml = preg_replace("/<\/questestinterop>/", "", $xml);
 
        return $xml;
    }

References $xml, and assQuestion\_instantiateQuestion().

Referenced by ilTestExportFixedQuestionSet\getQuestionsQtiXml(), and ilTestExportRandomQuestionSet\getQuestionsQtiXml().

Here is the call graph for this function:

Here is the caller graph for this function:

getQuestionsQtiXml()

ilTestExport::getQuestionsQtiXml ( )

abstractprotected

Reimplemented in ilTestExportDynamicQuestionSet, ilTestExportFixedQuestionSet, and ilTestExportRandomQuestionSet.

Referenced by getQtiXml().

Here is the caller graph for this function:

initXmlExport()

ilTestExport::initXmlExport ( )

abstractprotected

Reimplemented in ilTestExportDynamicQuestionSet, ilTestExportFixedQuestionSet, and ilTestExportRandomQuestionSet.

Referenced by buildExportFileXML().

Here is the caller graph for this function:

isResultExportingEnabledForTestExport()

ilTestExport::isResultExportingEnabledForTestExport

(

)

Returns

boolean

Definition at line 113 of file class.ilTestExport.php.

                                                           : bool
    {
        return $this->resultExportingEnabledForTestExport;
    }

References $resultExportingEnabledForTestExport.

Referenced by buildExportFileXML().

Here is the caller graph for this function:

orderQuestions()

ilTestExport::orderQuestions ( array  $questions )

protected

Definition at line 1088 of file class.ilTestExport.php.

                                                       : array
    {
        $key = $this->test_obj->isRandomTest() ? 'qid' : 'sequence';
        usort(
            $questions,
            function ($a, $b) use ($key) {
                if (isset($a[$key], $b[$key]) && $a[$key] > $b[$key]) {
                    return 1;
                }
                return -1;
            }
        );
        return $questions;
    }

References Vendor\Package\$a, Vendor\Package\$b, and ILIAS\LTI\ToolProvider\$key.

Referenced by exportToCSV(), and exportToExcel().

Here is the caller graph for this function:

populateQuestionSetConfigXml()

ilTestExport::populateQuestionSetConfigXml ( ilXmlWriter  $xmlWriter )

abstractprotected

Reimplemented in ilTestExportDynamicQuestionSet, ilTestExportFixedQuestionSet, and ilTestExportRandomQuestionSet.

Referenced by buildExportFileXML().

Here is the caller graph for this function:

populateQuestionSkillAssignmentsXml()

ilTestExport::populateQuestionSkillAssignmentsXml ( ilXmlWriter  $a_xml_writer, ilAssQuestionSkillAssignmentList  $assignmentList,   $questions  )

protected

Parameters

ilXmlWriter	$a_xml_writer
ilAssQuestionSkillAssignmentList	$assignmentList
	$questions

Definition at line 1275 of file class.ilTestExport.php.

    {
        require_once 'Modules/TestQuestionPool/classes/questions/class.ilAssQuestionSkillAssignmentExporter.php';
        $skillQuestionAssignmentExporter = new ilAssQuestionSkillAssignmentExporter();
        $skillQuestionAssignmentExporter->setXmlWriter($a_xml_writer);
        $skillQuestionAssignmentExporter->setQuestionIds($questions);
        $skillQuestionAssignmentExporter->setAssignmentList($assignmentList);
        $skillQuestionAssignmentExporter->export();
    }

Referenced by buildExportFileXML().

Here is the caller graph for this function:

populateSkillLevelThresholdsXml()

ilTestExport::populateSkillLevelThresholdsXml ( ilXmlWriter  $a_xml_writer, ilAssQuestionSkillAssignmentList  $assignmentList  )

protected

Definition at line 1285 of file class.ilTestExport.php.

    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        require_once 'Modules/Test/classes/class.ilTestSkillLevelThresholdList.php';
        $thresholdList = new ilTestSkillLevelThresholdList($ilDB);
        $thresholdList->setTestId($this->test_obj->getTestId());
        $thresholdList->loadFromDb();
 
        require_once 'Modules/Test/classes/class.ilTestSkillLevelThresholdExporter.php';
        $skillLevelThresholdExporter = new ilTestSkillLevelThresholdExporter();
        $skillLevelThresholdExporter->setXmlWriter($a_xml_writer);
        $skillLevelThresholdExporter->setAssignmentList($assignmentList);
        $skillLevelThresholdExporter->setThresholdList($thresholdList);
        $skillLevelThresholdExporter->export();
    }

References $DIC, and $ilDB.

Referenced by buildExportFileXML().

Here is the caller graph for this function:

setForcedAccessFilteredParticipantList()

ilTestExport::setForcedAccessFilteredParticipantList

(

ilTestParticipantList

$forcedAccessFilteredParticipantList

)

Parameters

ilTestParticipantList

$forcedAccessFilteredParticipantList

Definition at line 137 of file class.ilTestExport.php.

    {
        $this->forcedAccessFilteredParticipantList = $forcedAccessFilteredParticipantList;
    }

References $forcedAccessFilteredParticipantList.

setResultExportingEnabledForTestExport()

ilTestExport::setResultExportingEnabledForTestExport

(

$resultExprtingEnabledForTestExport

)

Parameters

boolean

$resultExprtingEnabledForTestExport

Definition at line 121 of file class.ilTestExport.php.

    {
        $this->resultExportingEnabledForTestExport = $resultExprtingEnabledForTestExport;
    }

Field Documentation

$db

ilDBInterface ilTestExport::$db

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

$err

ilErrorHandling ilTestExport::$err

Definition at line 38 of file class.ilTestExport.php.

$export_dir

string ilTestExport::$export_dir

private

Definition at line 34 of file class.ilTestExport.php.

$forcedAccessFilteredParticipantList

ilTestExport::$forcedAccessFilteredParticipantList = null

protected

Definition at line 62 of file class.ilTestExport.php.

Referenced by getForcedAccessFilteredParticipantList(), and setForcedAccessFilteredParticipantList().

$ilias

ILIAS ilTestExport::$ilias

Definition at line 44 of file class.ilTestExport.php.

Referenced by __construct().

$inst_id

ilTestExport::$inst_id

Definition at line 49 of file class.ilTestExport.php.

Referenced by getInstId().

$lng

ilLanguage ilTestExport::$lng

private

Definition at line 53 of file class.ilTestExport.php.

Referenced by __construct().

$mode

ilTestExport::$mode

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

$qti_filename

string ilTestExport::$qti_filename

private

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

$resultExportingEnabledForTestExport

ilTestExport::$resultExportingEnabledForTestExport = false

protected

Definition at line 57 of file class.ilTestExport.php.

Referenced by isResultExportingEnabledForTestExport().

$resultsfile

ilTestExport::$resultsfile

private

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

$subdir

string ilTestExport::$subdir

private

Definition at line 35 of file class.ilTestExport.php.

$test_obj

ilObjTest ilTestExport::$test_obj

Definition at line 47 of file class.ilTestExport.php.

---

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

• Modules/Test/classes/class.ilTestExport.php