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