class.ilTestPassesSelector.php

Go to the documentation of this file.

<?php
 
class ilTestPassesSelector
{
    protected $db;
 
    protected $testOBJ;
 
    private $activeId;
 
    private $lastFinishedPass = null;
 
    private $passes = null;
 
    private $testPassedOnceCache = array();
 
    public function __construct(ilDBInterface $db, ilObjTest $testOBJ)
    {
        $this->db = $db;
        $this->testOBJ = $testOBJ;
    }
 
    public function getActiveId()
    {
        return $this->activeId;
    }
 
    public function setActiveId($activeId)
    {
        $this->activeId = $activeId;
    }
 
    public function getLastFinishedPass()
    {
        return $this->lastFinishedPass;
    }
 
    public function setLastFinishedPass($lastFinishedPass)
    {
        $lastFinishedPass = $lastFinishedPass === null ? -1 : $lastFinishedPass;
        $this->lastFinishedPass = $lastFinishedPass;
    }
 
    private function passesLoaded(): bool
    {
        return is_array($this->passes);
    }
 
    private function ensureLoadedPasses()
    {
        if (!$this->passesLoaded()) {
            $this->loadPasses();
        }
    }
    private function loadPasses()
    {
        $query = "
                        SELECT DISTINCT tst_pass_result.* FROM tst_pass_result
                        LEFT JOIN tst_test_result
                        ON tst_pass_result.pass = tst_test_result.pass
                        AND tst_pass_result.active_fi = tst_test_result.active_fi
                        WHERE tst_pass_result.active_fi = %s
                        ORDER BY tst_pass_result.pass
                ";
 
        $res = $this->db->queryF(
            $query,
            array('integer'),
            array($this->getActiveId())
        );
 
        $this->passes = array();
 
        while ($row = $this->db->fetchAssoc($res)) {
            $this->passes[$row['pass']] = $row;
        }
    }
 
    private function getLazyLoadedPasses()
    {
        $this->ensureLoadedPasses();
        return $this->passes;
    }
 
    public function loadLastFinishedPass()
    {
        $query = "
                        SELECT last_finished_pass FROM tst_active WHERE active_id = %s
                ";
 
        $res = $this->db->queryF(
            $query,
            array('integer'),
            array($this->getActiveId())
        );
 
        while ($row = $this->db->fetchAssoc($res)) {
            $this->setLastFinishedPass($row['last_finished_pass']);
        }
    }
 
    public function getExistingPasses(): array
    {
        return array_keys($this->getLazyLoadedPasses());
    }
 
    public function hasExistingPasses(): bool
    {
        return (bool) count($this->getExistingPasses());
    }
 
    public function getNumExistingPasses(): int
    {
        return count($this->getExistingPasses());
    }
 
    public function openPassExists(): bool
    {
        return count($this->getExistingPasses()) > count($this->getClosedPasses());
    }
 
    public function getClosedPasses(): array
    {
        $existingPasses = $this->getExistingPasses();
        $closedPasses = $this->fetchClosedPasses($existingPasses);
 
        return $closedPasses;
    }
 
    public function getReportablePasses(): array
    {
        $existingPasses = $this->getExistingPasses();
 
        $reportablePasses = $this->fetchReportablePasses($existingPasses);
 
        return $reportablePasses;
    }
 
    public function hasReportablePasses(): bool
    {
        return (bool) count($this->getReportablePasses());
    }
 
    private function fetchReportablePasses($existingPasses): array
    {
        $lastPass = $this->fetchLastPass($existingPasses);
 
        $reportablePasses = array();
 
        foreach ($existingPasses as $pass) {
            if ($this->isReportablePass($lastPass, $pass)) {
                $reportablePasses[] = $pass;
            }
        }
 
        return $reportablePasses;
    }
 
    private function fetchClosedPasses($existingPasses): array
    {
        $closedPasses = array();
 
        foreach ($existingPasses as $pass) {
            if ($this->isClosedPass($pass)) {
                $closedPasses[] = $pass;
            }
        }
 
        return $closedPasses;
    }
 
    private function fetchLastPass($existingPasses)
    {
        $lastPass = null;
 
        foreach ($existingPasses as $pass) {
            if ($lastPass === null || $pass > $lastPass) {
                $lastPass = $pass;
            }
        }
 
        return $lastPass;
    }
 
    private function isReportablePass($lastPass, $pass): bool
    {
        switch ($this->testOBJ->getScoreReporting()) {
            case ilObjTest::SCORE_REPORTING_IMMIDIATLY:
 
                return true;
 
            case ilObjTest::SCORE_REPORTING_DATE:
 
                return $this->isReportingDateReached();
 
            case ilObjTest::SCORE_REPORTING_FINISHED:
 
                if ($pass < $lastPass) {
                    return true;
                }
 
                return $this->isClosedPass($pass);
 
            case ilObjTest::SCORE_REPORTING_AFTER_PASSED:
 
                if (!$this->hasTestPassedOnce($this->getActiveId())) {
                    return false;
                }
 
                return $this->isClosedPass($pass);
        }
 
        return false;
    }
 
    private function checkLastFinishedPassInitialised()
    {
        if ($this->getLastFinishedPass() === null) {
            throw new ilTestException('invalid object state: last finished pass was not set!');
        }
    }
 
    private function isClosedPass($pass): bool
    {
        $this->checkLastFinishedPassInitialised();
 
        if ($pass <= $this->getLastFinishedPass()) {
            return true;
        }
 
        if ($this->isProcessingTimeReached($pass)) {
            return true;
        }
 
        return false;
    }
 
    private function isReportingDateReached(): bool
    {
        $reporting_date = $this->testOBJ->getScoreSettings()->getResultSummarySettings()->getReportingDate();
        return $reporting_date <= new DateTimeImmutable('now', new DateTimeZone('UTC'));
    }
 
    private function isProcessingTimeReached($pass): bool
    {
        if (!$this->testOBJ->getEnableProcessingTime()) {
            return false;
        }
 
        $startingTime = $this->testOBJ->getStartingTimeOfUser($this->getActiveId(), $pass);
 
        if ($startingTime === false) {
            return false;
        }
 
        return $this->testOBJ->isMaxProcessingTimeReached($startingTime, $this->getActiveId());
    }
 
    public function getLastFinishedPassTimestamp(): ?int
    {
        $last_finished_pass = $this->getLastFinishedPass();
        if ($last_finished_pass === null || $last_finished_pass === -1) {
            return null;
        }
 
        $passes = $this->getLazyLoadedPasses();
        if (!isset($passes[$last_finished_pass])) {
            return null;
        }
        return $passes[$last_finished_pass]['tstamp'];
    }
 
    public function hasTestPassedOnce($activeId): bool
    {
        global $DIC; /* @var ILIAS\DI\Container $DIC */
 
        if (!isset($this->testPassedOnceCache[$activeId])) {
            $this->testPassedOnceCache[$activeId] = false;
 
            $res = $DIC->database()->queryF(
                "SELECT passed_once FROM tst_result_cache WHERE active_fi = %s",
                array('integer'),
                array($activeId)
            );
 
            while ($row = $DIC->database()->fetchAssoc($res)) {
                $this->testPassedOnceCache[$activeId] = (bool) $row['passed_once'];
            }
        }
 
        return $this->testPassedOnceCache[$activeId];
    }
}