ilLOTestRun Class Reference

Stores current objective, questions and max points. More...

Collaboration diagram for ilLOTestRun:

Public Member Functions
	__construct ($a_crs_id, $a_user_id, $a_test_id, $a_objective_id)
	getContainerId ()
	getUserId ()
	getTestId ()
	getObjectiveId ()
	getMaxPoints ()
	setMaxPoints ($a_points)
	getQuestions ()
	clearQuestions ()
	addQuestion ($a_id)
	questionExists ($a_question_id)
	setQuestionResult ($a_qst_id, $a_points)
	getResult ()
	Get result for objective run. More...
	delete ()
	Delete all entries type $ilDB. More...
	create ()
	update ()
	read ()
	type $ilDB More...

Static Public Member Functions
static	lookupRunExistsForObjective ($a_test_id, $a_objective_id, $a_user_id)
	type $ilDB More...
static	deleteRuns ($a_container_id, $a_user_id)
	Delete runs type $ilDB. More...
static	deleteRun ($a_container_id, $a_user_id, $a_test_id)
static	lookupObjectives ($a_container_id, $a_user_id, $a_test_id)
static	getRun ($a_container_id, $a_user_id, $a_test_id)

Protected Attributes
	$container_id = 0
	$user_id = 0
	$test_id = 0
	$objective_id = 0
	$max_points = 0
	$questions = array()

Private Attributes
	$logger = null

Detailed Description

Stores current objective, questions and max points.

Author

Stefan Meyer smeye.nosp@m.r.il.nosp@m.ias@g.nosp@m.mx.d.nosp@m.e

Version

$Id$

Definition at line 10 of file class.ilLOTestRun.php.

Constructor & Destructor Documentation

__construct()

ilLOTestRun::__construct	(		$a_crs_id,
			$a_user_id,
			$a_test_id,
			$a_objective_id
	)

Definition at line 26 of file class.ilLOTestRun.php.

References $DIC, and read().

    {
        global $DIC;

        $this->logger = $DIC->logger()->crs();

        $this->container_id = $a_crs_id;
        $this->user_id = $a_user_id;
        $this->test_id = $a_test_id;
        $this->objective_id = $a_objective_id;
        
        $this->read();
    }

Here is the call graph for this function:

Member Function Documentation

addQuestion()

ilLOTestRun::addQuestion

(

$a_id

)

Definition at line 179 of file class.ilLOTestRun.php.

    {
        $this->questions[$a_id] = 0;
    }

clearQuestions()

ilLOTestRun::clearQuestions

(

)

Definition at line 174 of file class.ilLOTestRun.php.

    {
        $this->questions = array();
    }

create()

ilLOTestRun::create

(

)

Definition at line 241 of file class.ilLOTestRun.php.

References $DIC, $ilDB, $query, getContainerId(), getMaxPoints(), getObjectiveId(), getQuestions(), getTestId(), and getUserId().

Referenced by ilLOTestQuestionAdapter\notifyTestStart().

    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $query = 'INSERT INTO loc_tst_run ' .
                '(container_id, user_id, test_id, objective_id,max_points,questions) ' .
                'VALUES( ' .
                $ilDB->quote($this->getContainerId(), 'integer') . ', ' .
                $ilDB->quote($this->getUserId(), 'integer') . ', ' .
                $ilDB->quote($this->getTestId(), 'integer') . ', ' .
                $ilDB->quote($this->getObjectiveId(), 'integer') . ', ' .
                $ilDB->quote($this->getMaxPoints(), 'integer') . ', ' .
                $ilDB->quote(serialize($this->getQuestions()), 'text') . ' ' .
                ')';
        $ilDB->manipulate($query);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

delete()

ilLOTestRun::delete

(

)

Delete all entries type $ilDB.

Definition at line 227 of file class.ilLOTestRun.php.

References $DIC, $ilDB, $query, getContainerId(), getObjectiveId(), getTestId(), and getUserId().

    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $query = 'DELETE FROM loc_tst_run ' .
                'WHERE container_id = ' . $ilDB->quote($this->getContainerId(), 'integer') . ' ' .
                'AND user_id = ' . $ilDB->quote($this->getUserId(), 'integer') . ' ' .
                'AND test_id = ' . $ilDB->quote($this->getTestId(), 'integer') . ' ' .
                'AND objective_id = ' . $ilDB->quote($this->getObjectiveId(), 'integer');
        $ilDB->manipulate($query);
    }

Here is the call graph for this function:

deleteRun()

static ilLOTestRun::deleteRun (   $a_container_id,   $a_user_id,   $a_test_id  )

static

Definition at line 84 of file class.ilLOTestRun.php.

References $DIC, $ilDB, and $query.

Referenced by ilLOTestQuestionAdapter\notifyTestStart().

    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $query = 'DELETE FROM loc_tst_run ' .
                'WHERE container_id = ' . $ilDB->quote($a_container_id, 'integer') . ' ' .
                'AND user_id = ' . $ilDB->quote($a_user_id, 'integer') . ' ' .
                'AND test_id = ' . $ilDB->quote($a_test_id, 'integer') . ' ';
        $ilDB->manipulate($query);
    }

Here is the caller graph for this function:

deleteRuns()

static ilLOTestRun::deleteRuns (   $a_container_id,   $a_user_id  )

static

Delete runs type $ilDB.

Parameters

type	$a_container_id
type	$a_user_id

Definition at line 72 of file class.ilLOTestRun.php.

References $DIC, $ilDB, and $query.

Referenced by ilObjCourseGUI\resetObject().

    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $query = 'DELETE FROM loc_tst_run ' .
                'WHERE container_id = ' . $ilDB->quote($a_container_id, 'integer') . ' ' .
                'AND user_id = ' . $ilDB->quote($a_user_id, 'integer') . ' ';
        $ilDB->manipulate($query);
    }

Here is the caller graph for this function:

getContainerId()

ilLOTestRun::getContainerId

(

)

Definition at line 139 of file class.ilLOTestRun.php.

References $container_id.

Referenced by create(), delete(), and read().

    {
        return $this->container_id;
    }

Here is the caller graph for this function:

getMaxPoints()

ilLOTestRun::getMaxPoints

(

)

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

References $max_points.

Referenced by create(), getResult(), and update().

    {
        return $this->max_points;
    }

Here is the caller graph for this function:

getObjectiveId()

ilLOTestRun::getObjectiveId

(

)

Definition at line 154 of file class.ilLOTestRun.php.

References $objective_id.

Referenced by create(), delete(), ilTestResultHeaderLabelBuilder\getObjectiveTitle(), read(), and update().

    {
        return $this->objective_id;
    }

Here is the caller graph for this function:

getQuestions()

ilLOTestRun::getQuestions

(

)

Definition at line 169 of file class.ilLOTestRun.php.

References $questions.

Referenced by create(), and update().

    {
        return (array) $this->questions;
    }

Here is the caller graph for this function:

getResult()

ilLOTestRun::getResult

(

)

Get result for objective run.

Definition at line 203 of file class.ilLOTestRun.php.

References getMaxPoints().

    {
        $sum_points = 0;
        foreach ($this->questions as $qid => $points) {
            $sum_points += $points;
        }
        
        $percentage =
            ($this->getMaxPoints() > 0) ?
            ($sum_points / $this->getMaxPoints() * 100) :
            100;
        
        return array(
            'max' => $this->getMaxPoints(),
            'reached' => $sum_points,
            'percentage' => $percentage
        );
    }

Here is the call graph for this function:

getRun()

static ilLOTestRun::getRun (   $a_container_id,   $a_user_id,   $a_test_id  )

static

Returns

ilLOTestRun[]

Definition at line 120 of file class.ilLOTestRun.php.

References $DIC, $ilDB, $query, $res, $row, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ilTestResultHeaderLabelBuilder\initObjectives(), and ilLOTestQuestionAdapter\initTestRun().

    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $query = 'SELECT objective_id FROM loc_tst_run ' .
                'WHERE container_id = ' . $ilDB->quote($a_container_id, 'integer') . ' ' .
                'AND user_id = ' . $ilDB->quote($a_user_id, 'integer') . ' ' .
                'AND test_id = ' . $ilDB->quote($a_test_id, 'integer') . ' ';
        $res = $ilDB->query($query);
        
        $run = array();
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $run[] = new ilLOTestRun($a_container_id, $a_user_id, $a_test_id, $row->objective_id);
        }
        return $run;
    }

Here is the caller graph for this function:

getTestId()

ilLOTestRun::getTestId

(

)

Definition at line 149 of file class.ilLOTestRun.php.

References $test_id.

Referenced by create(), delete(), read(), and update().

    {
        return $this->test_id;
    }

Here is the caller graph for this function:

getUserId()

ilLOTestRun::getUserId

(

)

Definition at line 144 of file class.ilLOTestRun.php.

References $user_id.

Referenced by create(), delete(), read(), and update().

    {
        return $this->user_id;
    }

Here is the caller graph for this function:

lookupObjectives()

static ilLOTestRun::lookupObjectives (   $a_container_id,   $a_user_id,   $a_test_id  )

static

Definition at line 97 of file class.ilLOTestRun.php.

References $DIC, $GLOBALS, $ilDB, $query, $res, $row, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ilLOUtils\hasActiveRun().

    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $query = 'SELECT objective_id FROM loc_tst_run ' .
                'WHERE container_id = ' . $ilDB->quote($a_container_id, 'integer') . ' ' .
                'AND user_id = ' . $ilDB->quote($a_user_id, 'integer') . ' ' .
                'AND test_id = ' . $ilDB->quote($a_test_id, 'integer');
        $GLOBALS['DIC']['ilLog']->write(__METHOD__ . ': ' . $query);
        $res = $ilDB->query($query);
        $objectives = array();
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $objectives[] = $row->objective_id;
        }
        return $objectives;
    }

Here is the caller graph for this function:

lookupRunExistsForObjective()

static ilLOTestRun::lookupRunExistsForObjective (   $a_test_id,   $a_objective_id,   $a_user_id  )

static

type $ilDB

Parameters

type	$a_test_obj_id
type	$a_objective_id
type	$a_user_id

Returns

boolean

Definition at line 48 of file class.ilLOTestRun.php.

References $DIC, $ilDB, $query, $res, $row, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ilContainerObjectiveGUI\updateResult().

    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $query = 'SELECT * FROM loc_tst_run ' .
                'WHERE test_id = ' . $ilDB->quote($a_test_id, 'integer') . ' ' .
                'AND objective_id = ' . $ilDB->quote($a_objective_id, 'integer') . ' ' .
                'AND user_id = ' . $ilDB->quote($a_user_id, 'integer');
        $res = $ilDB->query($query);
        
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return true;
        }
        return false;
    }

Here is the caller graph for this function:

questionExists()

ilLOTestRun::questionExists

(

$a_question_id

)

Definition at line 184 of file class.ilLOTestRun.php.

    {
        return array_key_exists($a_question_id, (array) $this->questions);
    }

read()

ilLOTestRun::read

(

)

type $ilDB

Definition at line 280 of file class.ilLOTestRun.php.

References $DIC, $ilDB, $query, $res, $row, ilDBConstants\FETCHMODE_OBJECT, getContainerId(), getObjectiveId(), getTestId(), and getUserId().

Referenced by __construct().

    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $query = 'SELECT * FROM loc_tst_run ' .
                'WHERE container_id = ' . $ilDB->quote($this->getContainerId(), 'integer') . ' ' .
                'AND user_id = ' . $ilDB->quote($this->getUserId(), 'integer') . ' ' .
                'AND test_id = ' . $ilDB->quote($this->getTestId(), 'integer') . ' ' .
                'AND objective_id = ' . $ilDB->quote($this->getObjectiveId(), 'integer');
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->max_points = $row->max_points;
            if ($row->questions) {
                $this->questions = unserialize($row->questions);
            }
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

setMaxPoints()

ilLOTestRun::setMaxPoints

(

$a_points

)

Definition at line 164 of file class.ilLOTestRun.php.

    {
        $this->max_points = $a_points;
    }

setQuestionResult()

ilLOTestRun::setQuestionResult	(		$a_qst_id,
			$a_points
	)

Parameters

int	$a_qst_id
int	$a_points

Definition at line 193 of file class.ilLOTestRun.php.

References ilLogLevel\DEBUG.

    {
        $this->logger->debug($a_qst_id . ' ' . $a_points);
        $this->questions[$a_qst_id] = $a_points;
        $this->logger->dump($this->questions, ilLogLevel::DEBUG);
    }

update()

ilLOTestRun::update

(

)

Definition at line 260 of file class.ilLOTestRun.php.

References $DIC, $ilDB, $query, getMaxPoints(), getObjectiveId(), getQuestions(), getTestId(), and getUserId().

    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $query = 'UPDATE loc_tst_run SET ' .
                'max_points = ' . $ilDB->quote($this->getMaxPoints(), 'integer') . ', ' .
                'questions = ' . $ilDB->quote(serialize($this->getQuestions()), 'text') . ' ' .
                'WHERE container_id = ' . $ilDB->quote($this->container_id, 'integer') . ' ' .
                'AND user_id = ' . $ilDB->quote($this->getUserId(), 'integer') . ' ' .
                'AND test_id = ' . $ilDB->quote($this->getTestId(), 'integer') . ' ' .
                'AND objective_id = ' . $ilDB->quote($this->getObjectiveId(), 'integer') . ' ';
        $ilDB->manipulate($query);
    }

Here is the call graph for this function:

Field Documentation

$container_id

ilLOTestRun::$container_id = 0

protected

Definition at line 12 of file class.ilLOTestRun.php.

Referenced by getContainerId().

$logger

ilLOTestRun::$logger = null

private

Definition at line 23 of file class.ilLOTestRun.php.

$max_points

ilLOTestRun::$max_points = 0

protected

Definition at line 17 of file class.ilLOTestRun.php.

Referenced by getMaxPoints().

$objective_id

ilLOTestRun::$objective_id = 0

protected

Definition at line 15 of file class.ilLOTestRun.php.

Referenced by getObjectiveId().

$questions

ilLOTestRun::$questions = array()

protected

Definition at line 18 of file class.ilLOTestRun.php.

Referenced by getQuestions().

$test_id

ilLOTestRun::$test_id = 0

protected

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

Referenced by getTestId().

$user_id

ilLOTestRun::$user_id = 0

protected

Definition at line 13 of file class.ilLOTestRun.php.

Referenced by getUserId().

---

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

• Modules/Course/classes/Objectives/class.ilLOTestRun.php