Inheritance diagram for ilObjTestAccess:

Collaboration diagram for ilObjTestAccess:

Public Member Functions
	_checkAccess ($a_cmd, $a_permission, $a_ref_id, $a_obj_id, $a_user_id="")
	Checks wether a user may invoke a command or not (this method is called by ilAccessHandler::checkAccess) More...

	_getMaxPointsForTestPass ($random, $user_id, $test_id, $pass)
	Returns the maximum number of points available for a test pass. More...

	_getCommands ()
	get commands More...

	_lookupCreationComplete ($a_obj_id)
	checks wether all necessary parts of the test are given More...

	_getTestIDFromObjectID ($object_id)
	Returns the ILIAS test id for a given object id. More...

&	_getTestQuestions ($active_id, $pass=NULL)

	_isComplete ($a_obj_id)
	Returns true, if a test is complete for use. More...

&	_getTestData ($test_id)
	Returns the database content of a test with a given id. More...

	_lookupObjIdForTestId ($a_test_id)
	Lookup object id for test id. More...

	_getRandomTestsForQuestionPool ($qpl_id)
	Get all tests using a question pool for random selection. More...

	_lookupOnlineTestAccess ($a_test_id, $a_user_id)
	Checks if a user is allowd to run an online exam. More...

	_getParticipantData ($active_id)
	Retrieves a participant name from active id. More...

	_getParticipantId ($active_id)
	Get user id for active id. More...

&	_getPassedUsers ($a_obj_id)
	Returns an array containing the users who passed the test. More...

	_checkGoto ($a_target)
	check whether goto script will succeed More...

Public Member Functions inherited from ilObjectAccess
	_checkAccess ($a_cmd, $a_permission, $a_ref_id, $a_obj_id, $a_user_id="")
	Checks wether a user may invoke a command or not (this method is called by ilAccessHandler::checkAccess) More...

	_checkCondition ($a_obj_id, $a_operator, $a_value, $a_usr_id)
	check condition More...

	_getCommands ()
	get commands More...

	_checkGoto ($a_target)
	check whether goto script will succeed More...

	_preloadData ($a_obj_ids, $a_ref_ids)
	Preload data. More...

Static Public Member Functions
static	_isPassed ($user_id, $a_obj_id)
	Returns TRUE if the user with the user id $user_id passed the test with the object id $a_obj_id. More...

static	isFailed ($user_id, $a_obj_id)
	Returns TRUE if the user with the user id $user_id failed the test with the object id $a_obj_id. More...

static	getConditionOperators ()
	Get possible conditions operators. More...

static	checkCondition ($a_obj_id, $a_operator, $a_value, $a_usr_id)
	check condition More...

static	hasFinished ($a_user_id, $a_obj_id)
	Returns (request cached) information if a specific user has finished at least one test pass. More...

static	_isOffline ($a_obj_id)
	returns the objects's OFFline status More...

static	_isOnline ($a_obj_id)
	returns the objects's ONline status More...

static	visibleUserResultExists ($testObjId, $userId)

static	_isOffline ($a_obj_id)
	Type-specific implementation of general status, has to be overwritten. More...

static	getConditionOperators ()
	Returns an array with valid operators for the specific object type. More...

static	checkCondition ($a_trigger_obj_id, $a_operator, $a_value, $a_usr_id)
	check condition for a specific user and object More...

Protected Member Functions
	updateTestResultCache ($a_user_id, $a_obj_id)
	Update test result cache. More...

Static Private Attributes
static	$hasFinishedCache = array()

Detailed Description

Class ilObjTestAccess.

This class contains methods that check object specific conditions for accessing test objects.

Author: Helmut Schottmueller helmu.nosp@m.t.sc.nosp@m.hottm.nosp@m.uell.nosp@m.er@ma.nosp@m.c.co.nosp@m.m; Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e

Version: $Id$

Definition at line 20 of file class.ilObjTestAccess.php.

Member Function Documentation

◆ _checkAccess()

ilObjTestAccess::_checkAccess	(	$a_cmd,
		$a_permission,
		$a_ref_id,
		$a_obj_id,
		$a_user_id = `""`
	)

Checks wether a user may invoke a command or not (this method is called by ilAccessHandler::checkAccess)

Please do not check any preconditions handled by ilConditionHandler here.

Parameters

string	$a_cmd	command (not permission!)
string	$a_permission	permission
int	$a_ref_id	reference id
int	$a_obj_id	object id
int	$a_user_id	user id (if not provided, current user is taken)

Returns: boolean true, if everything is ok

Reimplemented from ilObjectAccess.

Definition at line 37 of file class.ilObjTestAccess.php.

        {
                global $ilUser, $lng, $rbacsystem, $ilAccess;
                
                if ($a_user_id == "")
                {
                        $a_user_id = $ilUser->getId();
                }
                
                $is_admin = $rbacsystem->checkAccessOfUser($a_user_id,'write',$a_ref_id);               
                
                // check "global" online switch
                if(!self::_isOnline($a_obj_id) && !$is_admin)
                {
                        $ilAccess->addInfoItem(IL_NO_OBJECT_ACCESS, $lng->txt("offline"));
                        return false;
                }
 
                switch ($a_permission)
                {                       
                        case "visible":         
                        case "read":            
                                if (!ilObjTestAccess::_lookupCreationComplete($a_obj_id) &&
                                        !$is_admin)
                                {
                                        $ilAccess->addInfoItem(IL_NO_OBJECT_ACCESS, $lng->txt("tst_warning_test_not_complete"));
                                        return false;
                                }                                                                                               
                                break;
                }
                
                switch ($a_cmd)
                {
                        case "eval_a":
                        case "eval_stat":
                                if (!ilObjTestAccess::_lookupCreationComplete($a_obj_id))
                                {
                                        $ilAccess->addInfoItem(IL_NO_OBJECT_ACCESS, $lng->txt("tst_warning_test_not_complete"));
                                        return false;
                                }
                                break;
 
                }
 
                return true;
        }

References $ilUser, $lng, _lookupCreationComplete(), and IL_NO_OBJECT_ACCESS.

Here is the call graph for this function:

◆ _checkGoto()

ilObjTestAccess::_checkGoto ( $a_target )

check whether goto script will succeed

Reimplemented from ilObjectAccess.

Definition at line 890 of file class.ilObjTestAccess.php.

        {
                global $ilAccess;
                
                $t_arr = explode("_", $a_target);
 
                if ($t_arr[0] != "tst" || ((int) $t_arr[1]) <= 0)
                {
                        return false;
                }
 
                if ($ilAccess->checkAccess("read", "", $t_arr[1]))
                {
                        return true;
                }
                return false;
        }

◆ _getCommands()

ilObjTestAccess::_getCommands ( )

get commands

this method returns an array of all possible commands/permission combinations

example:
$commands = array ( array("permission" => "read", "cmd" => "view", "lang_var" => "show"), array("permission" => "write", "cmd" => "edit", "lang_var" => "edit"), );

Reimplemented from ilObjectAccess.

Definition at line 410 of file class.ilObjTestAccess.php.

        {
                $commands = array
                (
            array("permission" => "write", "cmd" => "questionsTabGateway", "lang_var" => "tst_edit_questions"),
                        array("permission" => "write", "cmd" => "ilObjTestSettingsGeneralGUI::showForm", "lang_var" => "settings"),
                        array("permission" => "read", "cmd" => "infoScreen", "lang_var" => "tst_run",
                                "default" => true),
                        //array("permission" => "write", "cmd" => "", "lang_var" => "edit"),
                        array("permission" => "tst_statistics", "cmd" => "outEvaluation", "lang_var" => "tst_statistical_evaluation"),
                        array("permission" => "read", "cmd" => "userResultsGateway", "lang_var" => "tst_test_results")
                );
                
                return $commands;
        }

Referenced by ilObjTestListGUI\init().

Here is the caller graph for this function:

◆ _getMaxPointsForTestPass()

ilObjTestAccess::_getMaxPointsForTestPass	(	$random,
		$user_id,
		$test_id,
		$pass
	)

Returns the maximum number of points available for a test pass.

Parameters

boolean	$random	TRUE if the test is a random test, otherwise FALSE
int	$test_id	The test id
int	$pass	The test pass

Returns: int The available points for the test pass

Definition at line 92 of file class.ilObjTestAccess.php.

        {
                global $ilDB;
                $max = 0;
                if ($random)
                {
                        $result = $ilDB->queryF("SELECT SUM(qpl_questions.points) maxpoints FROM tst_test_rnd_qst, qpl_questions, tst_active WHERE tst_active.active_id = tst_test_rnd_qst.active_fi AND tst_test_rnd_qst.question_fi = qpl_questions.question_id AND tst_active.test_fi = %s AND tst_test_rnd_qst.pass = %s AND tst_active.user_fi = %s",
                                array('integer','integer','integer'),
                                array($test_id, $pass, $user_id)
                        );
                        if ($result->numRows())
                        {
                                $row = $ilDB->fetchAssoc($result);
                                $max = $row["maxpoints"];
                        }
                }
                else
                {
                        $result = $ilDB->queryF("SELECT SUM(qpl_questions.points) maxpoints FROM tst_test_question, qpl_questions WHERE tst_test_question.question_fi = qpl_questions.question_id AND tst_test_question.test_fi = %s",
                                array('integer'),
                                array($test_id)
                        );
                        if ($result->numRows())
                        {
                                $row = $ilDB->fetchAssoc($result);
                                $max = $row["maxpoints"];
                        }
                }
                return $max;
        }

References $ilDB, $pass, $result, and $row.

◆ _getParticipantData()

ilObjTestAccess::_getParticipantData ( $active_id )

Retrieves a participant name from active id.

Parameters

integer $active_id Active ID of the participant

Returns: string The output name of the user @access public

Definition at line 737 of file class.ilObjTestAccess.php.

        {
                global $lng, $ilDB;
 
                $result = $ilDB->queryF("SELECT * FROM tst_active WHERE active_id = %s",
                        array("integer"),
                        array($active_id)
                );
                $row = $ilDB->fetchAssoc($result);
                $user_id = $row["user_fi"];
                $test_id = $row["test_fi"];
                $importname = $row['importname'];
 
                $result = $ilDB->queryF("SELECT obj_fi FROM tst_tests WHERE test_id = %s",
                        array("integer"),
                        array($test_id)
                );
                $row = $ilDB->fetchAssoc($result);
                $obj_id = $row["obj_fi"];
                
                include_once "./Modules/Test/classes/class.ilObjTest.php";
                $is_anonymous = ilObjTest::_lookupAnonymity($obj_id);
                
                include_once './Services/User/classes/class.ilObjUser.php';
                $uname = ilObjUser::_lookupName($user_id);
 
                $name = "";
                if (strlen($importname))
                {
                        $name = $importname . ' (' . $lng->txt('imported') . ')';
                }
                else if (strlen($uname["firstname"].$uname["lastname"]) == 0)
                {
                        $name = $lng->txt("deleted_user");
                }
                else
                {
                        if ($user_id == ANONYMOUS_USER_ID)
                        {
                                $name = $lastname;
                        }
                        else
                        {
                                $name = trim($uname["lastname"] . ", " . $uname["firstname"] . " " .  $uname["title"]);
                        }
                        if ($is_anonymous)
                        {
                                $name = $lng->txt("anonymous");
                        }
                }
                return $name;
        }

References $ilDB, $lng, $result, $row, ilObjTest\_lookupAnonymity(), and ilObjUser\_lookupName().

Referenced by assQuestion\_setReachedPoints(), ilTestResultsToXML\exportActiveIDs(), and ilObjTestGUI\participantsObject().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _getParticipantId()

ilObjTestAccess::_getParticipantId ( $active_id )

Get user id for active id.

Parameters

int	active ID of the participant

Returns: int user id

Definition at line 796 of file class.ilObjTestAccess.php.

        {
                global $lng, $ilDB;
 
                $result = $ilDB->queryF("SELECT user_fi FROM tst_active WHERE active_id = %s",
                        array("integer"),
                        array($active_id)
                );
                $row = $ilDB->fetchAssoc($result);
                return $row["user_fi"];
        }

References $ilDB, $lng, $result, and $row.

Referenced by assFileUpload\handleSubmission(), ilTestSession\increaseTestPass(), ilTestScoringGUI\saveManScoringParticipantScreen(), ilTestSession\saveToDb(), and ilTestSessionDynamicQuestionSet\saveToDb().

Here is the caller graph for this function:

◆ _getPassedUsers()

& ilObjTestAccess::_getPassedUsers ( $a_obj_id )

Returns an array containing the users who passed the test.

Returns: array An array containing the users who passed the test. Format of the values of the resulting array: array( "user_id" => user ID, "max_points" => maximum available points in the test "reached_points" => maximum reached points of the user "mark_short" => short text of the passed mark "mark_official" => official text of the passed mark ) @access public

Definition at line 823 of file class.ilObjTestAccess.php.

        {
                global $ilDB;
 
                $passed_users = array();
                // Maybe SELECT DISTINCT(tst_active.user_fi)... ?
                $userresult = $ilDB->queryF("
                        SELECT tst_active.active_id, COUNT(tst_sequence.active_fi) sequences
                        FROM tst_tests
                        INNER JOIN tst_active
                        ON tst_active.test_fi = tst_tests.test_id
                        LEFT JOIN tst_sequence
                        ON tst_sequence.active_fi = tst_active.active_id
                        WHERE tst_tests.obj_fi = %s
                        GROUP BY tst_active.active_id
                        ",
                        array('integer'), array($a_obj_id)
                );
                $all_participants = array();
                $notAttempted = array();
                while ($row = $ilDB->fetchAssoc($userresult))
                {
                        if($row['sequences'] == 0)
                        {
                                $notAttempted[$row['active_id']] = $row['active_id'];
                        }
 
                        $all_participants[$row['active_id']] = $row['active_id'];
                }
                
                $result = $ilDB->query("SELECT tst_result_cache.*, tst_active.user_fi FROM tst_result_cache, tst_active WHERE tst_active.active_id = tst_result_cache.active_fi AND " . $ilDB->in('active_fi', $all_participants, false, 'integer'));
                $found_all = ($result->numRows() == count($all_participants)) ? true : false;
                if (!$found_all)
                {
                        // if the result cache entries do not exist, create them
                        $found_participants = array();
                        while ($data = $ilDB->fetchAssoc($result))
                        {
                                array_push($found_participants, $data['active_fi']);
                        }
                        foreach ($all_participants as $active_id)
                        {
                                if (!in_array($active_id, $found_participants))
                                {
                                        include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                                        assQuestion::_updateTestResultCache($active_id);
                                }
                        }
                        $result = $ilDB->query("SELECT tst_result_cache.*, tst_active.user_fi FROM tst_result_cache, tst_active WHERE tst_active.active_id = tst_result_cache.active_fi AND " . $ilDB->in('active_fi', $all_participants, false, 'integer'));
                }
                while ($data = $ilDB->fetchAssoc($result))
                {
                        if( isset($notAttempted[$data['active_fi']]) )
                        {
                                $data['failed'] = 0;
                                $data['passed'] = 0;
                        }
 
                        $data['user_id'] = $data['user_fi'];
                        array_push($passed_users, $data);
                }
                return $passed_users;
        }

References $data, $ilDB, $result, $row, and assQuestion\_updateTestResultCache().

Referenced by ilLPStatusTestPassed\_getStatusInfo().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _getRandomTestsForQuestionPool()

ilObjTestAccess::_getRandomTestsForQuestionPool ( $qpl_id )

Get all tests using a question pool for random selection.

Parameters

int	question pool id

Returns: array list if test obj ids @access public

Definition at line 645 of file class.ilObjTestAccess.php.

        {
                global $ilDB;
        
                $query = "
                        SELECT DISTINCT t.obj_fi
                        FROM tst_tests t
                        INNER JOIN tst_rnd_quest_set_qpls r
                        ON t.test_id = r.test_fi
                        WHERE r.pool_fi = %s
                ";
        
                $result = $ilDB->queryF($query, array('integer'), array($qpl_id));
        
                $tests = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                    $tests[] = $row['obj_fi'];
                }
        
                return $tests;
        }

References $ilDB, $query, $result, $row, and $tests.

Referenced by ilObjMediaObjectAccess\checkAccessTestQuestion().

Here is the caller graph for this function:

◆ _getTestData()

& ilObjTestAccess::_getTestData ( $test_id )

Returns the database content of a test with a given id.

Parameters

int $test_id Database id of the test

Returns: array An associative array with the contents of the tst_tests database row @access public

Definition at line 605 of file class.ilObjTestAccess.php.

        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT * FROM tst_tests WHERE test_id = %s",
                        array('integer'),
                        array($test_id)
                );
                if (!$result->numRows())
                {
                        return 0;
                }
                return $ilDB->fetchAssoc($result);
        }

References $ilDB, and $result.

◆ _getTestIDFromObjectID()

ilObjTestAccess::_getTestIDFromObjectID ( $object_id )

Returns the ILIAS test id for a given object id.

Parameters

integer $object_id The object id

Returns: mixed The ILIAS test id or FALSE if the query was not successful @access public

Definition at line 501 of file class.ilObjTestAccess.php.

        {
                global $ilDB;
                $test_id = FALSE;
                $result = $ilDB->queryF("SELECT test_id FROM tst_tests WHERE obj_fi = %s",
                        array('integer'),
                        array($object_id)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        $test_id = $row["test_id"];
                }
                return $test_id;
        }

References $ilDB, $result, and $row.

Referenced by ilLPStatusTestFinished\getParticipants().

Here is the caller graph for this function:

◆ _getTestQuestions()

& ilObjTestAccess::_getTestQuestions	(	$active_id,
		$pass = `NULL`
	)

Definition at line 517 of file class.ilObjTestAccess.php.

        {
                if (is_null($pass))
                {
                        $pass = 0;
                }
                $questions = array();
                
                global $ilDB;
                $result = $ilDB->queryF("SELECT test_fi FROM tst_active WHERE active_id = %s",
                        array('integer'),
                        array($active_id)
                );
                $test_id = "";
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        $test_id = $row["test_fi"];
                }
                else
                {
                        return $questions;
                }
                $result = $ilDB->queryF("SELECT qpl_questions.question_id, qpl_questions.points FROM qpl_questions, tst_test_question WHERE tst_test_question.question_fi = qpl_questions.question_id AND tst_test_question.test_fi = %s ORDER BY tst_test_question.sequence",
                        array('integer'),
                        array($test_id)
                );
                if ($result->numRows())
                {
                        // standard test
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                array_push($questions, $row);
                        }
                }
                else
                {
                        // random test
                        $result = $ilDB->queryF("SELECT qpl_questions.question_id, qpl_questions.points FROM qpl_questions, tst_test_rnd_qst WHERE tst_test_rnd_qst.question_fi = qpl_questions.question_id AND tst_test_rnd_qst.active_fi = %s AND tst_test_rnd_qst.pass = %s ORDER BY tst_test_rnd_qst.sequence",
                                array('integer','integer'),
                                array($active_id, $pass)
                        );
                        if ($result->numRows())
                        {
                                while ($row = $ilDB->fetchAssoc($result))
                                {
                                        array_push($questions, $row);
                                }
                        }
                }
                return $questions;
        }

References $ilDB, $pass, $result, and $row.

◆ _isComplete()

ilObjTestAccess::_isComplete ( $a_obj_id )

Returns true, if a test is complete for use.

Returns: boolean True, if the test is complete for use, otherwise false @access public

Definition at line 576 of file class.ilObjTestAccess.php.

        {
                global $ilDB;
                
                $query = "
                        SELECT tst_tests.complete
                        FROM object_data
                        INNER JOIN tst_tests
                        ON tst_tests.obj_fi = object_data.obj_id
                        WHERE object_data.obj_id = %s
                ";
 
                $res = $ilDB->queryF($query, array('integer'), array($a_obj_id));
 
                while( $row = $ilDB->fetchAssoc($res) )
                {
                        return (bool)$row['complete'];
                }
 
                return false;
        }

References $ilDB, $query, $res, and $row.

◆ _isOffline()

static ilObjTestAccess::_isOffline ( $a_obj_id )

static

returns the objects's OFFline status

Used in ListGUI and Learning Progress

Parameters

int $a_obj_id

Returns: bool

Reimplemented from ilObjectAccess.

Definition at line 916 of file class.ilObjTestAccess.php.

        {
//              global $ilUser;
//              return (self::_lookupOnlineTestAccess($a_obj_id, $ilUser->getId()) !== true) ||
//                      (!ilObjTestAccess::_lookupCreationComplete($a_obj_id));
                return !self::_isOnline($a_obj_id);
        }

References _isOnline().

Here is the call graph for this function:

◆ _isOnline()

static ilObjTestAccess::_isOnline ( $a_obj_id )

static

returns the objects's ONline status

Parameters

integer $a_obj_id

Returns: boolean $online

Definition at line 930 of file class.ilObjTestAccess.php.

        {
                global $ilDB;
 
                $query = "
                        SELECT          test_id
                        FROM            tst_tests
                        WHERE           obj_fi = %s
                        AND                     online_status = 1
                ";
 
                $result = $ilDB->queryF( $query, array('integer'), array($a_obj_id) );
 
                return $result->numRows() == 1;
        }

References $ilDB, $query, and $result.

Referenced by _isOffline(), ilLOEditorStatus\checkTestOnline(), and ilObjTestListGUI\getProperties().

Here is the caller graph for this function:

◆ _isPassed()

static ilObjTestAccess::_isPassed	(	$user_id,
		$a_obj_id
	)

static

Returns TRUE if the user with the user id $user_id passed the test with the object id $a_obj_id.

Parameters

int	$user_id	The user id
int	$a_obj_id	The object id

Returns: boolean TRUE if the user passed the test, FALSE otherwise

Definition at line 130 of file class.ilObjTestAccess.php.

        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT tst_result_cache.* FROM tst_result_cache, tst_active, tst_tests WHERE tst_active.test_fi = tst_tests.test_id AND tst_active.user_fi = %s AND tst_tests.obj_fi = %s AND tst_result_cache.active_fi = tst_active.active_id",
                        array('integer','integer'),
                        array($user_id, $a_obj_id)
                );
                if (!$result->numRows())
                {
                        $result = $ilDB->queryF("SELECT tst_active.active_id FROM tst_active, tst_tests WHERE tst_active.test_fi = tst_tests.test_id AND tst_active.user_fi = %s AND tst_tests.obj_fi = %s",
                                array('integer','integer'),
                                array($user_id, $a_obj_id)
                        );
                        $row = $ilDB->fetchAssoc($result);
                        if ($row['active_id'] > 0)
                        {
                                include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                                assQuestion::_updateTestResultCache($row['active_id']);
                        }
                        else
                        {
                                return false;
                        }
                }
                $result = $ilDB->queryF("SELECT tst_result_cache.* FROM tst_result_cache, tst_active, tst_tests WHERE tst_active.test_fi = tst_tests.test_id AND tst_active.user_fi = %s AND tst_tests.obj_fi = %s AND tst_result_cache.active_fi = tst_active.active_id",
                        array('integer','integer'),
                        array($user_id, $a_obj_id)
                );
                if (!$result->numRows())
                {
                        $result = $ilDB->queryF("SELECT tst_pass_result.*, tst_tests.pass_scoring, tst_tests.random_test, tst_tests.test_id FROM tst_pass_result, tst_active, tst_tests WHERE tst_active.test_fi = tst_tests.test_id AND tst_active.user_fi = %s AND tst_tests.obj_fi = %s AND tst_pass_result.active_fi = tst_active.active_id ORDER BY tst_pass_result.pass",
                                array('integer','integer'),
                                array($user_id, $a_obj_id)
                        );
                        $points = array();
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                array_push($points, $row);
                        }
                        $reached = 0;
                        $max = 0;
                        if ($points[0]["pass_scoring"] == 0)
                        {
                                $reached = $points[count($points)-1]["points"];
                                $max = $points[count($points)-1]["maxpoints"];
                                if (!$max)
                                {
                                        $active_id = $points[count($points)-1]["active_fi"];
                                        $pass = $points[count($points)-1]["pass"];
                                        if (strlen($active_id) && strlen($pass))
                                        {
                                                include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                                                $res = assQuestion::_updateTestPassResults($active_id, $pass, null, $a_obj_id);
                                                $max = $res['maxpoints'];
                                                $reached = $res['points'];
                                        }
                                }
                        }
                        else
                        {
                                foreach ($points as $row)
                                {
                                        if ($row["points"] > $reached) 
                                        {
                                                $reached = $row["points"];
                                                $max = $row["maxpoints"];
                                                if (!$max)
                                                {
                                                        $active_id = $row["active_fi"];
                                                        $pass = $row["pass"];
                                                        if (strlen($active_id) && strlen($pass))
                                                        {
                                                                include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                                                                $res = assQuestion::_updateTestPassResults($active_id, $pass, null, $a_obj_id);
                                                                $max = $res['maxpoints'];
                                                                $reached = $res['points'];
                                                        }
                                                }
                                        }
                                }
                        }
                        include_once "./Modules/Test/classes/class.assMarkSchema.php";
                        $percentage = (!$max) ? 0 : ($reached / $max) * 100.0;
                        $mark = ASS_MarkSchema::_getMatchingMarkFromObjId($a_obj_id, $percentage);
                        return ($mark["passed"]) ? TRUE : FALSE;
                }
                else
                {
                        $row = $ilDB->fetchAssoc($result);
                        return ($row['passed']) ? true : false;
                }
        }

References $ilDB, $pass, $res, $result, $row, ASS_MarkSchema\_getMatchingMarkFromObjId(), and assQuestion\_updateTestResultCache().

Referenced by checkCondition(), and ilLPStatusTestPassed\determineStatus().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _lookupCreationComplete()

ilObjTestAccess::_lookupCreationComplete ( $a_obj_id )

checks wether all necessary parts of the test are given

Definition at line 433 of file class.ilObjTestAccess.php.

        {
                global $ilDB;
 
                $result = $ilDB->queryF("SELECT complete FROM tst_tests WHERE obj_fi=%s",
                        array('integer'),
                        array($a_obj_id)
                );
                if ($result->numRows() == 1)
                {
                        $row = $ilDB->fetchAssoc($result);
                }
 
                return ($row['complete']) ? true : false;
        }

References $ilDB, $result, and $row.

Referenced by _checkAccess().

Here is the caller graph for this function:

◆ _lookupObjIdForTestId()

ilObjTestAccess::_lookupObjIdForTestId ( $a_test_id )

Lookup object id for test id.

Parameters

int test id

Returns: int object id

Definition at line 625 of file class.ilObjTestAccess.php.

        {
                global $ilDB;
 
                $result = $ilDB->queryF("SELECT obj_fi FROM tst_tests WHERE test_id = %s",
                        array('integer'),
                        array($a_test_id)
                );
 
                $row = $ilDB->fetchAssoc($result);
                return $row["obj_fi"];
        }

References $ilDB, $result, and $row.

Referenced by ilTestSession\increaseTestPass(), ilTestSession\saveToDb(), and ilTestSessionDynamicQuestionSet\saveToDb().

Here is the caller graph for this function:

◆ _lookupOnlineTestAccess()

ilObjTestAccess::_lookupOnlineTestAccess	(	$a_test_id,
		$a_user_id
	)

Checks if a user is allowd to run an online exam.

Returns: mixed true if the user is allowed to run the online exam or if the test isn't an online exam, an alert message if the test is an online exam and the user is not allowed to run it @access public

Definition at line 675 of file class.ilObjTestAccess.php.

        {
                global $ilDB, $lng;
                
                $result = $ilDB->queryF("SELECT tst_tests.* FROM tst_tests WHERE tst_tests.obj_fi = %s",
                        array('integer'),
                        array($a_test_id)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        if ($row["fixed_participants"])
                        {
                                $result = $ilDB->queryF("SELECT * FROM tst_invited_user WHERE test_fi = %s AND user_fi = %s",
                                        array('integer','integer'),
                                        array($row["test_id"], $a_user_id)
                                );
                                if ($result->numRows())
                                {
                                        $row = $ilDB->fetchAssoc($result);
                                        if (trim($row['clientip']) != "")
                                        {
                                                $row['clientip'] = preg_replace("/[^0-9.?*,:]+/","",$row['clientip']);
                                                $row['clientip'] = str_replace(".","\\.",$row['clientip']);
                                                $row['clientip'] = str_replace(Array("?","*",","), Array("[0-9]","[0-9]*","|"), $row['clientip']);
                                                if (!preg_match("/^".$row['clientip']."$/", $_SERVER["REMOTE_ADDR"])) 
                                                {
                                                        return $lng->txt("tst_user_wrong_clientip");
                                                }
                                                else
                                                {
                                                        return true;
                                                }       
                                        }
                                        else
                                        {
                                                return true;
                                        }
                                }
                                else
                                {
                                        return $lng->txt("tst_user_not_invited");
                                }
                        }
                        else
                        {
                                return true;
                        }
                }
                else
                {
                        return true;
                }
        }

References $_SERVER, $ilDB, $lng, $result, and $row.

Referenced by ilObjTestGUI\buildPageViewToolbar(), ilObjTestListGUI\getProperties(), and ilObjTestGUI\questionsObject().

Here is the caller graph for this function:

◆ checkCondition()

static ilObjTestAccess::checkCondition	(	$a_obj_id,
		$a_operator,
		$a_value,
		$a_usr_id
	)

static

check condition

this method is called by ilConditionHandler

Implements ilConditionHandling.

Definition at line 373 of file class.ilObjTestAccess.php.

        {
                include_once './Services/AccessControl/classes/class.ilConditionHandler.php';
                
                switch($a_operator)
                {
                        case ilConditionHandler::OPERATOR_PASSED:
                                return ilObjTestAccess::_isPassed($a_usr_id, $a_obj_id);
                                break;
                        
                        case ilConditionHandler::OPERATOR_FAILED:
                                return ilObjTestAccess::isFailed($a_usr_id, $a_obj_id);
 
                        case ilConditionHandler::OPERATOR_FINISHED:
                                return ilObjTestAccess::hasFinished($a_usr_id,$a_obj_id);
 
                        case ilConditionHandler::OPERATOR_NOT_FINISHED:
                                return !ilObjTestAccess::hasFinished($a_usr_id,$a_obj_id);
 
                        default:
                                return true;
                }
                return true;
        }

References _isPassed(), hasFinished(), isFailed(), ilConditionHandler\OPERATOR_FAILED, ilConditionHandler\OPERATOR_FINISHED, ilConditionHandler\OPERATOR_NOT_FINISHED, and ilConditionHandler\OPERATOR_PASSED.

Referenced by ilContainerObjectiveGUI\getMainContent(), ilContainerStartObjects\isFullfilled(), ilCourseStart\isFullfilled(), and ilContainerObjectiveGUI\renderObjective().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getConditionOperators()

static ilObjTestAccess::getConditionOperators ( )

static

Get possible conditions operators.

Implements ilConditionHandling.

Definition at line 356 of file class.ilObjTestAccess.php.

        {
                include_once './Services/AccessControl/classes/class.ilConditionHandler.php';
                return array(
                        ilConditionHandler::OPERATOR_PASSED,
                        ilConditionHandler::OPERATOR_FAILED,
                        ilConditionHandler::OPERATOR_FINISHED,
                        ilConditionHandler::OPERATOR_NOT_FINISHED
                );
        }

References ilConditionHandler\OPERATOR_FAILED, ilConditionHandler\OPERATOR_FINISHED, ilConditionHandler\OPERATOR_NOT_FINISHED, and ilConditionHandler\OPERATOR_PASSED.

◆ hasFinished()

static ilObjTestAccess::hasFinished	(	$a_user_id,
		$a_obj_id
	)

static

Returns (request cached) information if a specific user has finished at least one test pass.

Parameters

integer	$user_id	obj_id of the user
integer	$a_obj_id	obj_id of the test

Returns: bool

Definition at line 463 of file class.ilObjTestAccess.php.

        {
                if( !isset(self::$hasFinishedCache["{$a_user_id}:{$a_obj_id}"]) )
                {
                        require_once 'Modules/Test/classes/class.ilTestParticipantData.php';
                        require_once 'Modules/Test/classes/class.ilTestSessionFactory.php';
                        require_once 'Modules/Test/classes/class.ilTestPassesSelector.php';
                        
                        global $ilDB, $lng;
                        
                        $testOBJ = ilObjectFactory::getInstanceByObjId($a_obj_id);
                        
                        $partData = new ilTestParticipantData($ilDB, $lng);
                        $partData->setUserIds(array($a_user_id));
                        $partData->load($testOBJ->getTestId());
                        
                        $activeId = $partData->getActiveIdByUserId($a_user_id);
 
                        $testSessionFactory = new ilTestSessionFactory($testOBJ);
                        $testSession = $testSessionFactory->getSession($activeId);
                        
                        $testPassesSelector = new ilTestPassesSelector($ilDB, $testOBJ);
                        $testPassesSelector->setActiveId($activeId);
                        $testPassesSelector->setLastFinishedPass($testSession->getLastFinishedPass());
                        
                        self::$hasFinishedCache["{$a_user_id}:{$a_obj_id}"] = count($testPassesSelector->getClosedPasses());
                }
                
                return self::$hasFinishedCache["{$a_user_id}:{$a_obj_id}"];
        }

References $ilDB, $lng, and ilObjectFactory\getInstanceByObjId().

Referenced by checkCondition().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ isFailed()

static ilObjTestAccess::isFailed	(	$user_id,
		$a_obj_id
	)

static

Returns TRUE if the user with the user id $user_id failed the test with the object id $a_obj_id.

Parameters

int	$user_id	The user id
int	$a_obj_id	The object id

Returns: boolean TRUE if the user failed the test, FALSE otherwise

Definition at line 230 of file class.ilObjTestAccess.php.

        {
                global $ilDB;
                
                $ret = self::updateTestResultCache($user_id, $a_obj_id);
 
                if(!$ret)
                {
                        return false;
                }
                
                $result = $ilDB->queryF("SELECT tst_result_cache.* FROM tst_result_cache, tst_active, tst_tests WHERE tst_active.test_fi = tst_tests.test_id AND tst_active.user_fi = %s AND tst_tests.obj_fi = %s AND tst_result_cache.active_fi = tst_active.active_id",
                        array('integer','integer'),
                        array($user_id, $a_obj_id)
                );
 
                if (!$result->numRows())
                {
                        $result = $ilDB->queryF("SELECT tst_pass_result.*, tst_tests.pass_scoring, tst_tests.random_test, tst_tests.test_id FROM tst_pass_result, tst_active, tst_tests WHERE tst_active.test_fi = tst_tests.test_id AND tst_active.user_fi = %s AND tst_tests.obj_fi = %s AND tst_pass_result.active_fi = tst_active.active_id ORDER BY tst_pass_result.pass",
                                array('integer','integer'),
                                array($user_id, $a_obj_id)
                        );
 
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                array_push($points, $row);
                        }
                        $reached = 0;
                        $max = 0;
                        if ($points[0]["pass_scoring"] == 0)
                        {
                                $reached = $points[count($points)-1]["points"];
                                $max = $points[count($points)-1]["maxpoints"];
                                if (!$max)
                                {
                                        $active_id = $points[count($points)-1]["active_fi"];
                                        $pass = $points[count($points)-1]["pass"];
                                        if (strlen($active_id) && strlen($pass))
                                        {
                                                include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                                                $res = assQuestion::_updateTestPassResults($active_id, $pass, null, $a_obj_id);
                                                $max = $res['maxpoints'];
                                                $reached = $res['points'];
                                        }
                                }
                        }
                        else
                        {
                                foreach ($points as $row)
                                {
                                        if ($row["points"] > $reached) 
                                        {
                                                $reached = $row["points"];
                                                $max = $row["maxpoints"];
                                                if (!$max)
                                                {
                                                        $active_id = $row["active_fi"];
                                                        $pass = $row["pass"];
                                                        if (strlen($active_id) && strlen($pass))
                                                        {
                                                                include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                                                                $res = assQuestion::_updateTestPassResults($active_id, $pass, null, $a_obj_id);
                                                                $max = $res['maxpoints'];
                                                                $reached = $res['points'];
                                                        }
                                                }
                                        }
                                }
                        }
                        include_once "./Modules/Test/classes/class.assMarkSchema.php";
                        $percentage = (!$max) ? 0 : ($reached / $max) * 100.0;
                        $mark = ASS_MarkSchema::_getMatchingMarkFromObjId($a_obj_id, $percentage);
                        return ($mark["failed"]) ? TRUE : FALSE;
                }
                else
                {
                        $row = $ilDB->fetchAssoc($result);
                        return ($row['failed']) ? TRUE : FALSE;
                }
        }

References $ilDB, $pass, $res, $result, $ret, $row, ASS_MarkSchema\_getMatchingMarkFromObjId(), and updateTestResultCache().

Referenced by checkCondition().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ updateTestResultCache()

ilObjTestAccess::updateTestResultCache	(	$a_user_id,
		$a_obj_id
	)

protected

Update test result cache.

Parameters

type	$a_user_id
type	$a_obj_id

Definition at line 316 of file class.ilObjTestAccess.php.

        {
                global $ilDB;
                
                $result = $ilDB->queryF(
                                "SELECT tst_result_cache.* FROM tst_result_cache, tst_active, tst_tests ".
                                "WHERE tst_active.test_fi = tst_tests.test_id AND tst_active.user_fi = %s ".
                                "AND tst_tests.obj_fi = %s AND tst_result_cache.active_fi = tst_active.active_id",
                        array('integer','integer'),
                        array($a_user_id, $a_obj_id)
                );
                if (!$result->numRows())
                {
                        $result = $ilDB->queryF("SELECT tst_active.active_id FROM tst_active, tst_tests WHERE tst_active.test_fi = tst_tests.test_id AND tst_active.user_fi = %s AND tst_tests.obj_fi = %s",
                                array('integer','integer'),
                                array($a_user_id, $a_obj_id)
                        );
                        $row = $ilDB->fetchAssoc($result);
                        if ($row['active_id'] > 0)
                        {
                                include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                                assQuestion::_updateTestResultCache($row['active_id']);
                                return true;
                        }
                        else
                        {
                                return false;
                        }
 
                }
                else
                {
                        return true;
                }
        }

References $ilDB, $result, $row, and assQuestion\_updateTestResultCache().

Referenced by isFailed().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ visibleUserResultExists()

static ilObjTestAccess::visibleUserResultExists	(	$testObjId,
		$userId
	)

static

Definition at line 946 of file class.ilObjTestAccess.php.

        {
                $testOBJ = ilObjectFactory::getInstanceByObjId($testObjId, false);
 
                if( !($testOBJ instanceof ilObjTest) )
                {
                        return false;
                }
 
                require_once 'Modules/Test/classes/class.ilTestSessionFactory.php';
                $testSessionFactory = new ilTestSessionFactory($testOBJ);
                $testSession = $testSessionFactory->getSessionByUserId($userId);
 
                return $testOBJ->canShowTestResults($testSession);
        }

References ilObjectFactory\getInstanceByObjId().

Referenced by ilLOUtils\getTestResultLinkForUser(), and ilObjTestListGUI\handleUserResultsCommand().

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

◆ $hasFinishedCache

ilObjTestAccess::$hasFinishedCache = array()

staticprivate

Definition at line 454 of file class.ilObjTestAccess.php.

The documentation for this class was generated from the following file:

Modules/Test/classes/class.ilObjTestAccess.php

Public Member Functions

Static Public Member Functions

Protected Member Functions

Static Private Attributes

Detailed Description

Member Function Documentation

◆ _checkAccess()

◆ _checkGoto()

◆ _getCommands()

◆ _getMaxPointsForTestPass()

◆ _getParticipantData()

◆ _getParticipantId()

◆ _getPassedUsers()

◆ _getRandomTestsForQuestionPool()

◆ _getTestData()

◆ _getTestIDFromObjectID()

◆ _getTestQuestions()

◆ _isComplete()

◆ _isOffline()

◆ _isOnline()

◆ _isPassed()

◆ _lookupCreationComplete()

◆ _lookupObjIdForTestId()

◆ _lookupOnlineTestAccess()

◆ checkCondition()

◆ getConditionOperators()

◆ hasFinished()

◆ isFailed()

◆ updateTestResultCache()

◆ visibleUserResultExists()

Field Documentation

◆ $hasFinishedCache