class.ilAssQuestionHintTracking.php

Go to the documentation of this file.

<?php
 
class ilAssQuestionHintTracking
{
    private $questionId;
 
    private $activeId;
 
    private $pass;
 
    public function __construct($questionId, $activeId, $pass)
    {
        $this->questionId = $questionId;
        $this->activeId = $activeId;
        $this->pass = $pass;
    }
 
    public function setActiveId($activeId): void
    {
        $this->activeId = $activeId;
    }
 
    public function getActiveId()
    {
        return $this->activeId;
    }
 
    public function setPass($pass): void
    {
        $this->pass = $pass;
    }
 
    public function getPass()
    {
        return $this->pass;
    }
 
    public function setQuestionId($questionId): void
    {
        $this->questionId = $questionId;
    }
 
    public function getQuestionId()
    {
        return $this->questionId;
    }
 
    public function requestsExist(): bool
    {
        if (self::getNumExistingRequests($this->getQuestionId(), $this->getActiveId(), $this->getPass()) > 0) {
            return true;
        }
 
        return false;
    }
 
    public function getNumExistingRequests(): int
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $query = "
                        SELECT          COUNT(qhtr_track_id) cnt
                        
                        FROM            qpl_hint_tracking
                        
                        WHERE           qhtr_question_fi = %s
                        AND                     qhtr_active_fi = %s
                        AND                     qhtr_pass = %s
                ";
 
        $res = $ilDB->queryF(
            $query,
            array('integer', 'integer', 'integer'),
            array($this->getQuestionId(), $this->getActiveId(), $this->getPass())
        );
 
        $row = $ilDB->fetchAssoc($res);
 
        return $row['cnt'];
    }
 
    public function requestsPossible(): bool
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $query = "
                        SELECT          COUNT(qht_hint_id) cnt_available,
                                                COUNT(qhtr_track_id) cnt_requested
                        
                        FROM            qpl_hints
                        
                        LEFT JOIN       qpl_hint_tracking
                        ON                      qhtr_hint_fi = qht_hint_id
                        AND                     qhtr_active_fi = %s
                        AND                     qhtr_pass = %s
                        
                        WHERE           qht_question_fi = %s
                ";
 
        $res = $ilDB->queryF(
            $query,
            array('integer', 'integer', 'integer'),
            array($this->getActiveId(), $this->getPass(), $this->getQuestionId())
        );
 
        $row = $ilDB->fetchAssoc($res);
 
        if ($row['cnt_available'] > $row['cnt_requested']) {
            return true;
        }
 
        return false;
    }
 
    public function isRequested($hintId): bool
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $query = "
                        SELECT          COUNT(qhtr_track_id) cnt
                        
                        FROM            qpl_hint_tracking
                        
                        WHERE           qhtr_hint_fi = %s
                        AND                     qhtr_active_fi = %s
                        AND                     qhtr_pass = %s
                ";
 
        $res = $ilDB->queryF(
            $query,
            array('integer', 'integer', 'integer'),
            array($hintId, $this->getActiveId(), $this->getPass())
        );
 
        $row = $ilDB->fetchAssoc($res);
 
        if ($row['cnt'] > 0) {
            return true;
        }
 
        return false;
    }
 
    public function getNextRequestableHint(): ilAssQuestionHint
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $query = "
                        SELECT          qht_hint_id
                        
                        FROM            qpl_hints
                        
                        LEFT JOIN       qpl_hint_tracking
                        ON                      qhtr_hint_fi = qht_hint_id
                        AND                     qhtr_active_fi = %s
                        AND                     qhtr_pass = %s
                        
                        WHERE           qht_question_fi = %s
                        AND                     qhtr_track_id IS NULL
                        
                        ORDER BY        qht_hint_index ASC
                ";
 
        $ilDB->setLimit(1);
 
        $res = $ilDB->queryF(
            $query,
            array('integer', 'integer', 'integer'),
            array($this->getActiveId(), $this->getPass(), $this->getQuestionId())
        );
 
        while ($row = $ilDB->fetchAssoc($res)) {
            $nextHint = ilAssQuestionHint::getInstanceById($row['qht_hint_id']);
 
            return $nextHint;
        }
 
        require_once 'Modules/Test/exceptions/class.ilTestNoNextRequestableHintExistsException.php';
 
        throw new ilTestNoNextRequestableHintExistsException(
            "no next hint found for questionId={$this->getQuestionId()}, activeId={$this->getActiveId()}, pass={$this->getPass()}"
        );
    }
 
    public function getRequestedHintsList(): ilAssQuestionHintList
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $query = "
                        SELECT          qhtr_hint_fi
                        
                        FROM            qpl_hint_tracking
                        
                        WHERE           qhtr_question_fi = %s
                        AND                     qhtr_active_fi = %s
                        AND                     qhtr_pass = %s
                ";
 
        $res = $ilDB->queryF(
            $query,
            array('integer', 'integer', 'integer'),
            array($this->getQuestionId(), $this->getActiveId(), $this->getPass())
        );
 
        $hintIds = array();
 
        while ($row = $ilDB->fetchAssoc($res)) {
            $hintIds[] = $row['qhtr_hint_fi'];
        }
 
        $requestedHintsList = ilAssQuestionHintList::getListByHintIds($hintIds);
 
        return $requestedHintsList;
    }
 
    public function storeRequest(ilAssQuestionHint $questionHint): void
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $trackId = $ilDB->nextId('qpl_hint_tracking');
 
        $ilDB->insert('qpl_hint_tracking', array(
            'qhtr_track_id' => array('integer', $trackId),
            'qhtr_active_fi' => array('integer', $this->getActiveId()),
            'qhtr_pass' => array('integer', $this->getPass()),
            'qhtr_question_fi' => array('integer', $this->getQuestionId()),
            'qhtr_hint_fi' => array('integer', $questionHint->getId()),
        ));
    }
 
    public function getRequestStatisticDataByQuestionAndTestpass(): ilAssQuestionHintRequestStatisticData
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $query = "
                        SELECT          COUNT(qhtr_track_id) requests_count,
                                                SUM(qht_hint_points) requests_points
                        
                        FROM            qpl_hint_tracking
                        
                        INNER JOIN      qpl_hints
                        ON                      qht_hint_id = qhtr_hint_fi
                        
                        WHERE           qhtr_question_fi = %s
                        AND                     qhtr_active_fi = %s
                        AND                     qhtr_pass = %s
                ";
 
        $res = $ilDB->queryF(
            $query,
            array('integer', 'integer', 'integer'),
            array($this->getQuestionId(), $this->getActiveId(), $this->getPass())
        );
 
        $row = $ilDB->fetchAssoc($res);
 
        if ($row['requests_points'] === null) {
            $row['requests_points'] = 0;
        }
 
        require_once 'Modules/TestQuestionPool/classes/class.ilAssQuestionHintRequestStatisticData.php';
 
        $requestsStatisticData = new ilAssQuestionHintRequestStatisticData();
        $requestsStatisticData->setRequestsCount($row['requests_count']);
        $requestsStatisticData->setRequestsPoints($row['requests_points']);
 
        return $requestsStatisticData;
    }
 
    public static function getRequestRequestStatisticDataRegisterByActiveId($activeId): ilAssQuestionHintRequestStatisticRegister
    {
        require_once 'Modules/TestQuestionPool/classes/class.ilAssQuestionHintRequestStatisticRegister.php';
        require_once 'Modules/TestQuestionPool/classes/class.ilAssQuestionHintRequestStatisticData.php';
 
        /* @var ILIAS\DI\Container $DIC */ global $DIC;
        $db = $DIC->database();
 
        $query = "
                        SELECT          qhtr_pass requests_pass,
                                                qhtr_question_fi requests_question,
                                                COUNT(qhtr_track_id) requests_count,
                                                SUM(qht_hint_points) requests_points
                        
                        FROM            qpl_hint_tracking
                        
                        INNER JOIN      qpl_hints
                        ON                      qht_hint_id = qhtr_hint_fi
                        
                        WHERE           qhtr_active_fi = %s
                        
                        GROUP BY        qhtr_pass, qhtr_question_fi
                ";
 
        $res = $db->queryF(
            $query,
            array('integer'),
            array($activeId)
        );
 
        $register = new ilAssQuestionHintRequestStatisticRegister();
 
        while ($row = $db->fetchAssoc($res)) {
            if ($row['requests_points'] === null) {
                $row['requests_points'] = 0;
            }
 
            $requestsStatisticData = new ilAssQuestionHintRequestStatisticData();
            $requestsStatisticData->setRequestsCount($row['requests_count']);
            $requestsStatisticData->setRequestsPoints($row['requests_points']);
 
            $register->addRequestByTestPassIndexAndQuestionId($row['requests_pass'], $row['requests_question'], $requestsStatisticData);
        }
 
        return $register;
    }
 
    public static function deleteRequestsByQuestionIds($questionIds): void
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $__question_fi__IN__questionIds = $ilDB->in('qhtr_question_fi', $questionIds, false, 'integer');
 
        $query = "
                        DELETE FROM     qpl_hint_tracking
                        WHERE           $__question_fi__IN__questionIds
                ";
 
        $ilDB->manipulate($query);
    }
 
    public static function deleteRequestsByActiveIds($activeIds): void
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $__active_fi__IN__activeIds = $ilDB->in('qhtr_active_fi', $activeIds, false, 'integer');
 
        $query = "
                        DELETE FROM     qpl_hint_tracking
                        WHERE           $__active_fi__IN__activeIds
                ";
 
        $ilDB->manipulate($query);
    }
}