class.ilTestParticipantList.php

Go to the documentation of this file.

<?php

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

require_once 'Modules/Test/classes/class.ilTestParticipant.php';

class ilTestParticipantList implements Iterator
{
    protected $participants = array();

    protected $testObj;

    public function __construct(ilObjTest $testObj)
    {
        $this->testObj = $testObj;
    }

    public function getTestObj()
    {
        return $this->testObj;
    }

    public function setTestObj($testObj)
    {
        $this->testObj = $testObj;
    }

    public function addParticipant(ilTestParticipant $participant)
    {
        $this->participants[] = $participant;
    }

    public function getParticipantByUsrId($usrId)
    {
        foreach ($this as $participant) {
            if ($participant->getUsrId() != $usrId) {
                continue;
            }

            return $participant;
        }
    }

    public function getParticipantByActiveId($activeId)
    {
        foreach ($this as $participant) {
            if ($participant->getActiveId() != $activeId) {
                continue;
            }

            return $participant;
        }
    }

    public function hasUnfinishedPasses()
    {
        foreach ($this as $participant) {
            if ($participant->hasUnfinishedPasses()) {
                return true;
            }
        }

        return false;
    }

    public function hasScorings()
    {
        foreach ($this as $participant) {
            if ($participant->getScoring() instanceof ilTestParticipantScoring) {
                return true;
            }
        }

        return false;
    }

    public function getAllUserIds()
    {
        $usrIds = array();

        foreach ($this as $participant) {
            $usrIds[] = $participant->getUsrId();
        }

        return $usrIds;
    }

    public function getAllActiveIds()
    {
        $activeIds = array();

        foreach ($this as $participant) {
            $activeIds[] = $participant->getActiveId();
        }

        return $activeIds;
    }

    public function isActiveIdInList($activeId)
    {
        foreach ($this as $participant) {
            if ($participant->getActiveId() == $activeId) {
                return true;
            }
        }

        return false;
    }

    public function getAccessFilteredList(callable $userAccessFilter)
    {
        $usrIds = call_user_func_array($userAccessFilter, [$this->getAllUserIds()]);

        $accessFilteredList = new self($this->getTestObj());

        foreach ($this as $participant) {
            if (in_array($participant->getUsrId(), $usrIds)) {
                $participant = clone $participant;
                $accessFilteredList->addParticipant($participant);
            }
        }

        return $accessFilteredList;
    }

    public function current()
    {
        return current($this->participants);
    }
    public function next()
    {
        return next($this->participants);
    }
    public function key()
    {
        return key($this->participants);
    }
    public function valid()
    {
        return key($this->participants) !== null;
    }
    public function rewind()
    {
        return reset($this->participants);
    }

    public function initializeFromDbRows($dbRows)
    {
        foreach ($dbRows as $rowKey => $rowData) {
            $participant = new ilTestParticipant();

            if ((int) $rowData['active_id']) {
                $participant->setActiveId((int) $rowData['active_id']);
            }

            $participant->setUsrId((int) $rowData['usr_id']);

            $participant->setLogin($rowData['login']);
            $participant->setLastname($rowData['lastname']);
            $participant->setFirstname($rowData['firstname']);
            $participant->setMatriculation($rowData['matriculation']);

            $participant->setActiveStatus((bool) $rowData['active']);

            if (isset($rowData['clientip'])) {
                $participant->setClientIp($rowData['clientip']);
            }

            $participant->setFinishedTries((int) $rowData['tries']);
            $participant->setTestFinished((bool) $rowData['test_finished']);
            $participant->setUnfinishedPasses((bool) $rowData['unfinished_passes']);

            $this->addParticipant($participant);
        }
    }

    public function getScoredParticipantList()
    {
        require_once 'Modules/Test/classes/class.ilTestParticipantScoring.php';

        $scoredParticipantList = new self($this->getTestObj());

        global $DIC; /* @var ILIAS\DI\Container $DIC */

        $res = $DIC->database()->query($this->buildScoringsQuery());

        while ($row = $DIC->database()->fetchAssoc($res)) {
            if (ilObjTest::_getResultPass($row['active_fi']) != $row['pass']) {
                assQuestion::_updateTestResultCache($row['active_fi']);
            }
        }

        $res = $DIC->database()->query($this->buildScoringsQuery());

        while ($row = $DIC->database()->fetchAssoc($res)) {
            $scoring = new ilTestParticipantScoring();

            $scoring->setActiveId((int) $row['active_fi']);
            $scoring->setScoredPass((int) $row['pass']);

            $scoring->setAnsweredQuestions((int) $row['answeredquestions']);
            $scoring->setTotalQuestions((int) $row['questioncount']);

            $scoring->setReachedPoints((float) $row['reached_points']);
            $scoring->setMaxPoints((float) $row['max_points']);

            $scoring->setPassed((bool) $row['passed']);
            $scoring->setFinalMark((string) $row['mark_short']);

            $this->getParticipantByActiveId($row['active_fi'])->setScoring($scoring);

            $scoredParticipantList->addParticipant(
                $this->getParticipantByActiveId($row['active_fi'])
            );
        }

        return $scoredParticipantList;
    }

    public function buildScoringsQuery()
    {
        global $DIC; /* @var ILIAS\DI\Container $DIC */

        $IN_activeIds = $DIC->database()->in(
            'tres.active_fi',
            $this->getAllActiveIds(),
            false,
            'integer'
        );

        if (false && !$this->getTestObj()->isDynamicTest()) { // BH: keep for the moment
            $closedScoringsOnly = "
                                INNER JOIN tst_active tact
                                ON tact.active_id = tres.active_fi
                                AND tact.last_finished_pass = tact.last_started_pass
                        ";
        } else {
            $closedScoringsOnly = '';
        }

        $query = "
                        SELECT * FROM tst_result_cache tres

                        INNER JOIN tst_pass_result pres
                        ON pres.active_fi = tres.active_fi
                        AND pres.pass = tres.pass

                        $closedScoringsOnly

                        WHERE $IN_activeIds
                ";

        return $query;
    }

    public function getParticipantsTableRows()
    {
        $rows = array();

        foreach ($this as $participant) {
            $row = array(
                'usr_id' => $participant->getUsrId(),
                'active_id' => $participant->getActiveId(),
                'login' => $participant->getLogin(),
                'clientip' => $participant->getClientIp(),
                'firstname' => $participant->getFirstname(),
                'lastname' => $participant->getLastname(),
                'name' => $this->buildFullname($participant),
                'started' => ($participant->getActiveId() > 0) ? 1 : 0,
                'unfinished' => $participant->hasUnfinishedPasses() ? 1 : 0,
                'finished' => $participant->isTestFinished() ? 1 : 0,
                'access' => $this->lookupLastAccess($participant->getActiveId()),
                'tries' => $this->lookupNrOfTries($participant->getActiveId())
            );

            $rows[] = $row;
        }

        return $rows;
    }

    public function getScoringsTableRows()
    {
        $rows = array();

        foreach ($this as $participant) {
            if (!$participant->hasScoring()) {
                continue;
            }

            $row = array(
                'usr_id' => $participant->getUsrId(),
                'active_id' => $participant->getActiveId(),
                'login' => $participant->getLogin(),
                'firstname' => $participant->getFirstname(),
                'lastname' => $participant->getLastname(),
                'name' => $this->buildFullname($participant)
            );

            if ($participant->getScoring()) {
                $row['scored_pass'] = $participant->getScoring()->getScoredPass();
                $row['answered_questions'] = $participant->getScoring()->getAnsweredQuestions();
                $row['total_questions'] = $participant->getScoring()->getTotalQuestions();
                $row['reached_points'] = $participant->getScoring()->getReachedPoints();
                $row['max_points'] = $participant->getScoring()->getMaxPoints();
                $row['percent_result'] = $participant->getScoring()->getPercentResult();
                $row['passed_status'] = $participant->getScoring()->isPassed();
                $row['final_mark'] = $participant->getScoring()->getFinalMark();
                $row['last_scored_access'] = ilObjTest::lookupLastTestPassAccess(
                    $participant->getActiveId(),
                    $participant->getScoring()->getScoredPass()
                );
                $row['finished_passes'] = $participant->getFinishedTries();
                $row['has_unfinished_passes'] = $participant->hasUnfinishedPasses();
            }

            $rows[] = $row;
        }

        return $rows;
    }

    public function lookupNrOfTries($activeId)
    {
        $maxPassIndex = ilObjTest::_getMaxPass($activeId);

        if ($maxPassIndex !== null) {
            $nrOfTries = $maxPassIndex + 1;
            return $nrOfTries;
        }

        return null;
    }

    protected function lookupLastAccess($activeId)
    {
        if (!$activeId) {
            return '';
        }

        return $this->getTestObj()->_getLastAccess($activeId);
    }

    protected function buildFullname(ilTestParticipant $participant)
    {
        if ($this->getTestObj()->getFixedParticipants() && !$participant->getActiveId()) {
            return $this->buildInviteeFullname($participant);
        }

        return $this->buildParticipantsFullname($participant);
    }

    protected function buildInviteeFullname(ilTestParticipant $participant)
    {
        global $DIC; /* @var ILIAS\DI\Container $DIC */

        if (strlen($participant->getFirstname() . $participant->getLastname()) == 0) {
            return $DIC->language()->txt("deleted_user");
        }

        if ($this->getTestObj()->getAnonymity()) {
            return $DIC->language()->txt('anonymous');
        }

        return trim($participant->getLastname() . ", " . $participant->getFirstname());
    }

    protected function buildParticipantsFullname(ilTestParticipant $participant)
    {
        require_once 'Modules/Test/classes/class.ilObjTestAccess.php';
        return ilObjTestAccess::_getParticipantData($participant->getActiveId());
    }
}