class.ilTestEvaluationData.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2013 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilTestEvaluationData
{
        var $questionTitles;

        private $test;

        var $participants;

        var $statistics;

        var $arrFilter;

        var $datasets;

        public function __sleep()
        {
                return array('questionTitles', 'participants', 'statistics', 'arrFilter', 'datasets', 'test');
        }

        function ilTestEvaluationData(ilObjTest $test = null)
        {
                $this->participants = array();
                $this->questionTitles = array();
                if( $test !== null )
                {
                        $this->test = $test;
                        $this->generateOverview();
                }
        }
        
        function generateOverview()
        {
                global $ilDB;
                
                include_once "./Modules/Test/classes/class.ilTestEvaluationPassData.php";
                include_once "./Modules/Test/classes/class.ilTestEvaluationUserData.php";
                
                $this->participants = array();
                
                $query = "
                        SELECT                  usr_data.usr_id,
                                                        usr_data.firstname,
                                                        usr_data.lastname,
                                                        usr_data.title,
                                                        usr_data.login,
                                                        tst_pass_result.*
                        FROM                    tst_pass_result, tst_active
                        LEFT JOIN               usr_data
                        ON                              tst_active.user_fi = usr_data.usr_id
                        WHERE                   tst_active.active_id = tst_pass_result.active_fi
                        AND                             tst_active.test_fi = %s
                        ORDER BY                usr_data.lastname,
                                                        usr_data.firstname,
                                                        tst_pass_result.active_fi,
                                                        tst_pass_result.pass,
                                                        tst_pass_result.tstamp
                ";
                
                $result = $ilDB->queryF(
                        $query, array('integer'), array($this->getTest()->getTestId())
                );
                
                $pass = NULL;
                $checked = array();
                $thissets = 0;
                
                while( $row = $ilDB->fetchAssoc($result) )
                {
                        $thissets++;
                        
                        $remove = FALSE;
                        
                        if( !$this->participantExists($row["active_fi"]) )
                        {
                                $this->addParticipant($row["active_fi"], new ilTestEvaluationUserData($this->getTest()->getPassScoring()));
                                
                                $this->getParticipant($row["active_fi"])->setName(
                                                $this->getTest()->buildName($row["usr_id"], $row["firstname"], $row["lastname"], $row["title"])
                                );
                                
                                $this->getParticipant($row["active_fi"])->setLogin($row["login"]);
                                
                                $this->getParticipant($row["active_fi"])->setUserID($row["usr_id"]);
                        }
                        
                        if( !is_object($this->getParticipant($row["active_fi"])->getPass($row["pass"])) )
                        {
                                $pass = new ilTestEvaluationPassData();
                                $pass->setPass($row["pass"]);
                                $this->getParticipant($row["active_fi"])->addPass($row["pass"], $pass);
                        }
                        
                        $this->getParticipant($row["active_fi"])->getPass($row["pass"])->setReachedPoints($row["points"]);
                        $this->getParticipant($row["active_fi"])->getPass($row["pass"])->setObligationsAnswered($row["obligations_answered"]);
                        
                        if( $row["questioncount"] == 0 )
                        {
                                $data = ilObjTest::_getQuestionCountAndPointsForPassOfParticipant($row['active_fi'], $row['pass']);
                                $this->getParticipant($row["active_fi"])->getPass($row["pass"])->setMaxPoints($data['points']);
                                $this->getParticipant($row["active_fi"])->getPass($row["pass"])->setQuestionCount($data['count']);
                        }
                        else
                        {
                                $this->getParticipant($row["active_fi"])->getPass($row["pass"])->setMaxPoints($row["maxpoints"]);
                                $this->getParticipant($row["active_fi"])->getPass($row["pass"])->setQuestionCount($row["questioncount"]);
                        }
                        
                        $this->getParticipant($row["active_fi"])->getPass($row["pass"])->setNrOfAnsweredQuestions($row["answeredquestions"]);
                        $this->getParticipant($row["active_fi"])->getPass($row["pass"])->setWorkingTime($row["workingtime"]);

                        $this->getParticipant($row['active_fi'])->getPass($row['pass'])->setRequestedHintsCount($row['hint_count']);
                        $this->getParticipant($row['active_fi'])->getPass($row['pass'])->setDeductedHintPoints($row['hint_points']);
                }
        }
        
        function getTest()
        {
                return $this->test;
        }
        
        function setTest($test)
        {
                $this->test =& $test;
        }
        
        function setDatasets($datasets)
        {
                $this->datasets = $datasets;
        }
        
        function getDatasets()
        {
                return $this->datasets;
        }
        
        function addQuestionTitle($question_id, $question_title)
        {
                $this->questionTitles[$question_id] = $question_title;
        }
        
        function getQuestionTitles()
        {
                return $this->questionTitles;
        }
        
        function getQuestionTitle($question_id)
        {
                if (array_key_exists($question_id, $this->questionTitles))
                {
                        return $this->questionTitles[$question_id];
                }
                else
                {
                        return "";
                }
        }
        
        function calculateStatistics()
        {
                include_once "./Modules/Test/classes/class.ilTestStatistics.php";
                $this->statistics = new ilTestStatistics($this);
        }

        function getParticipants()
        {
                if (count($this->arrFilter))
                {
                        $filteredParticipants = array();
                        $courseids = array();
                        $groupids = array();
                        global $ilDB;
                        if (array_key_exists('group', $this->arrFilter))
                        {
                                $ids = ilObject::_getIdsForTitle($this->arrFilter['group'], 'grp', true);
                                $groupids = array_merge($groupids, $ids);
                        }
                        if (array_key_exists('course', $this->arrFilter))
                        {
                                $ids = ilObject::_getIdsForTitle($this->arrFilter['course'], 'crs', true);
                                $courseids = array_merge($courseids, $ids);
                        }
                        foreach ($this->participants as $active_id => $participant)
                        {
                                $remove = FALSE;
                                if (array_key_exists('name', $this->arrFilter))
                                {
                                        if (!(strpos(strtolower($participant->getName()), strtolower($this->arrFilter['name'])) !== FALSE)) $remove = TRUE;
                                }
                                if (!$remove)
                                {
                                        if (array_key_exists('group', $this->arrFilter))
                                        {
                                                include_once "./Services/Membership/classes/class.ilParticipants.php";
                                                $groups = ilParticipants::_getMembershipByType($participant->getUserID(), "grp");
                                                $foundfilter = FALSE;
                                                if (count(array_intersect($groupids, $groups))) $foundfilter = TRUE;
                                                if (!$foundfilter) $remove = TRUE;
                                        }
                                }
                                if (!$remove)
                                {
                                        if (array_key_exists('course', $this->arrFilter))
                                        {
                                                include_once "./Services/Membership/classes/class.ilParticipants.php";
                                                $courses = ilParticipants::_getMembershipByType($participant->getUserID(), "crs");
                                                $foundfilter = FALSE;
                                                if (count(array_intersect($courseids, $courses))) $foundfilter = TRUE;
                                                if (!$foundfilter) $remove = TRUE;
                                        }
                                }
                                if (!$remove)
                                {
                                        if (array_key_exists('active_id', $this->arrFilter))
                                        {
                                                if ($active_id != $this->arrFilter['active_id']) $remove = TRUE;
                                        }
                                }
                                if (!$remove) $filteredParticipants[$active_id] = $participant;
                        }
                        return $filteredParticipants;
                }
                else
                {
                        return $this->participants;
                }
        }
        
        function resetFilter()
        {
                $this->arrFilter = array();
        }
        
        /*
        * Set an output filter for getParticipants
        *
        * @param string $by name, course, group
        * @param string $text Filter text
        */
        function setFilter($by, $text)
        {
                $this->arrFilter = array($by => $text);
        }
        
        /*
        * Set an output filter for getParticipants
        *
        * @param array $arrFilter filter values
        */
        function setFilterArray($arrFilter)
        {
                $this->arrFilter = $arrFilter;
        }
        
        function addParticipant($active_id, $participant)
        {
                $this->participants[$active_id] = $participant;
        }
        
        function getParticipant($active_id)
        {
                return $this->participants[$active_id];
        }
        
        function participantExists($active_id)
        {
                return array_key_exists($active_id, $this->participants);
        }
        
        function removeParticipant($active_id)
        {
                unset($this->participants[$active_id]);
        }
        
        function getStatistics()
        {
                return $this->statistics;
        }

        function getParticipantIds()
        {
                return array_keys($this->participants);
        }
} // END ilTestEvaluationData