Collaboration diagram for ilAssQuestionHintTracking:

Public Member Functions
	__construct ($questionId, $activeId, $pass)

	setActiveId ($activeId)

	getActiveId ()

	setPass ($pass)

	getPass ()

	setQuestionId ($questionId)

	getQuestionId ()

	requestsExist ()
	Returns the fact wether there exists hint requests for the given question relating to the given testactive and testpass or not. More...

	getNumExistingRequests ()
	Returns the number existing hint requests for the given question relating to the given testactive and testpass or not. More...

	requestsPossible ()
	Returns the fact wether (further) hint requests are possible for the given question relating to the given testactive and testpass or not. More...

	isRequested ($hintId)
	Returns the fact wether the hint for given id is requested for the given testactive and testpass. More...

	getNextRequestableHint ()
	Returns the next requestable hint for given question relating to given testactive and testpass. More...

	getRequestedHintsList ()
	Returns an object of class ilAssQuestionHintList containing objects of class ilAssQuestionHint for all allready requested hints relating to the given question, testactive and testpass. More...

	storeRequest (ilAssQuestionHint $questionHint)
	Tracks the given hint as requested for the given question, testactive and testpass. More...

	getRequestStatisticDataByQuestionAndTestpass ()
	Returns a question hint request statistic data container containing the statistics for all requests relating to given ... More...

	deleteRequestsByQuestionIds ($questionIds)
	Deletes all hint requests relating to a question included in given question ids. More...

	deleteRequestsByActiveIds ($activeIds)
	Deletes all hint requests relating to a testactive included in given active ids. More...

Private Attributes
	$questionId

	$activeId

	$pass

Detailed Description

Definition at line 14 of file class.ilAssQuestionHintTracking.php.

Constructor & Destructor Documentation

◆ __construct()

ilAssQuestionHintTracking::__construct	(	$questionId,
		$activeId,
		$pass
	)

Definition at line 22 of file class.ilAssQuestionHintTracking.php.

        {
                $this->questionId = $questionId;
                $this->activeId = $activeId;
                $this->pass = $pass;
        }

References $activeId, $pass, and $questionId.

Member Function Documentation

◆ deleteRequestsByActiveIds()

ilAssQuestionHintTracking::deleteRequestsByActiveIds ( $activeIds )

Deletes all hint requests relating to a testactive included in given active ids.

@access public @global ilDB $ilDB

Parameters

array[integer] $activeIds

Definition at line 376 of file class.ilAssQuestionHintTracking.php.

        {
                global $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);
        }

References $ilDB, and $query.

Referenced by ilObjTest\removeAllTestEditings(), ilObjTest\removeTestResultsByActiveIds(), and ilObjTest\removeTestResultsForUser().

Here is the caller graph for this function:

◆ deleteRequestsByQuestionIds()

ilAssQuestionHintTracking::deleteRequestsByQuestionIds ( $questionIds )

Deletes all hint requests relating to a question included in given question ids.

@access public @global ilDB $ilDB

Parameters

array[integer] $questionIds

Definition at line 355 of file class.ilAssQuestionHintTracking.php.

        {
                global $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);
        }

References $ilDB, and $query.

Referenced by assQuestion\delete(), and ilObjTest\removeAllTestEditings().

Here is the caller graph for this function:

◆ getActiveId()

ilAssQuestionHintTracking::getActiveId ( )

Definition at line 34 of file class.ilAssQuestionHintTracking.php.

        {
                return $this->activeId;
        }

References $activeId.

Referenced by getNextRequestableHint(), getNumExistingRequests(), getRequestedHintsList(), getRequestStatisticDataByQuestionAndTestpass(), isRequested(), requestsExist(), requestsPossible(), and storeRequest().

Here is the caller graph for this function:

◆ getNextRequestableHint()

ilAssQuestionHintTracking::getNextRequestableHint ( )

Returns the next requestable hint for given question relating to given testactive and testpass.

@access public @global ilDB $ilDB

Returns: ilAssQuestionHint $nextRequestableHint

Exceptions

ilTestException

Definition at line 196 of file class.ilAssQuestionHintTracking.php.

        {
                global $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;
                }
                
                throw new ilTestException(
                        "no next hint found for questionId={$this->getQuestionId()}, activeId={$this->getActiveId()}, pass={$this->getPass()}"
                );
        }

References $ilDB, $query, $res, $row, getActiveId(), ilAssQuestionHint\getInstanceById(), getPass(), and getQuestionId().

Here is the call graph for this function:

◆ getNumExistingRequests()

ilAssQuestionHintTracking::getNumExistingRequests ( )

Returns the number existing hint requests for the given question relating to the given testactive and testpass or not.

@access public @global ilDB $ilDB

Returns: integer $numExisingRequests

Definition at line 85 of file class.ilAssQuestionHintTracking.php.

        {
                global $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'];
        }

References $ilDB, $query, $res, $row, getActiveId(), getPass(), and getQuestionId().

Here is the call graph for this function:

◆ getPass()

ilAssQuestionHintTracking::getPass ( )

Definition at line 44 of file class.ilAssQuestionHintTracking.php.

        {
                return $this->pass;
        }

References $pass.

Referenced by getNextRequestableHint(), getNumExistingRequests(), getRequestedHintsList(), getRequestStatisticDataByQuestionAndTestpass(), isRequested(), requestsExist(), requestsPossible(), and storeRequest().

Here is the caller graph for this function:

◆ getQuestionId()

ilAssQuestionHintTracking::getQuestionId ( )

Definition at line 54 of file class.ilAssQuestionHintTracking.php.

        {
                return $this->questionId;
        }

References $questionId.

Referenced by getNextRequestableHint(), getNumExistingRequests(), getRequestedHintsList(), getRequestStatisticDataByQuestionAndTestpass(), requestsExist(), requestsPossible(), and storeRequest().

Here is the caller graph for this function:

◆ getRequestedHintsList()

ilAssQuestionHintTracking::getRequestedHintsList ( )

Returns an object of class ilAssQuestionHintList containing objects of class ilAssQuestionHint for all allready requested hints relating to the given question, testactive and testpass.

@access public @global ilDB $ilDB

Returns: ilAssQuestionHintList $requestedHintsList

Definition at line 244 of file class.ilAssQuestionHintTracking.php.

        {
                global $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;
        }

References $ilDB, $query, $res, $row, getActiveId(), ilAssQuestionHintList\getListByHintIds(), getPass(), and getQuestionId().

Here is the call graph for this function:

◆ getRequestStatisticDataByQuestionAndTestpass()

ilAssQuestionHintTracking::getRequestStatisticDataByQuestionAndTestpass ( )

Returns a question hint request statistic data container containing the statistics for all requests relating to given ...

question
testactive
testpass

@access public @global ilDB $ilDB

Returns: ilAssQuestionHintRequestStatisticData $requestsStatisticData

Definition at line 309 of file class.ilAssQuestionHintTracking.php.

        {
                global $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;
        }

References $ilDB, $query, $res, $row, getActiveId(), getPass(), and getQuestionId().

Here is the call graph for this function:

◆ isRequested()

ilAssQuestionHintTracking::isRequested ( $hintId )

Returns the fact wether the hint for given id is requested for the given testactive and testpass.

@access public @global ilDB $ilDB

Parameters

integer $hintId

Returns: boolean $isRequested

Definition at line 159 of file class.ilAssQuestionHintTracking.php.

        {
                global $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;
        }

References $ilDB, $query, $res, $row, getActiveId(), and getPass().

Here is the call graph for this function:

◆ requestsExist()

ilAssQuestionHintTracking::requestsExist ( )

Returns the fact wether there exists hint requests for the given question relating to the given testactive and testpass or not.

@access public @global ilDB $ilDB

Returns: boolean $requestsExist

Definition at line 67 of file class.ilAssQuestionHintTracking.php.

        {
                if( self::getNumExistingRequests($this->getQuestionId(), $this->getActiveId(), $this->getPass()) > 0 )
                {
                        return true;
                }
                
                return false;
        }

References getActiveId(), getPass(), and getQuestionId().

Here is the call graph for this function:

◆ requestsPossible()

ilAssQuestionHintTracking::requestsPossible ( )

Returns the fact wether (further) hint requests are possible for the given question relating to the given testactive and testpass or not.

@access public @global ilDB $ilDB

Returns: boolean $requestsPossible

Definition at line 117 of file class.ilAssQuestionHintTracking.php.

        {
                global $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;
        }

References $ilDB, $query, $res, $row, getActiveId(), getPass(), and getQuestionId().

Here is the call graph for this function:

◆ setActiveId()

ilAssQuestionHintTracking::setActiveId ( $activeId )

Definition at line 29 of file class.ilAssQuestionHintTracking.php.

        {
                $this->activeId = $activeId;
        }

References $activeId.

◆ setPass()

ilAssQuestionHintTracking::setPass ( $pass )

Definition at line 39 of file class.ilAssQuestionHintTracking.php.

        {
                $this->pass = $pass;
        }

References $pass.

◆ setQuestionId()

ilAssQuestionHintTracking::setQuestionId ( $questionId )

Definition at line 49 of file class.ilAssQuestionHintTracking.php.

        {
                $this->questionId = $questionId;
        }

References $questionId.

◆ storeRequest()

ilAssQuestionHintTracking::storeRequest ( ilAssQuestionHint $questionHint )

Tracks the given hint as requested for the given question, testactive and testpass.

@access public @global ilDB $ilDB

Parameters

ilAssQuestionHint $questionHint

Definition at line 283 of file class.ilAssQuestionHintTracking.php.

        {
                global $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()),
                ));
        }