Inheritance diagram for ilLPStatusTestFinished:

Collaboration diagram for ilLPStatusTestFinished:

Public Member Functions
	__construct ($a_obj_id)

	determineStatus ($a_obj_id, $a_user_id, $a_obj=null)
	Determine status. More...

Public Member Functions inherited from ilLPStatus
	__construct ($a_obj_id)

	_updateStatus ($a_obj_id, $a_usr_id, $a_obj=null, $a_percentage=false, $a_force_raise=false)
	New status handling (st: status, nr: accesses, p: percentage, t: time spent, m: mark) More...

	determinePercentage ($a_obj_id, $a_usr_id, $a_obj=null)
	Determine percentage. More...

	determineStatus ($a_obj_id, $a_usr_id, $a_obj=null)
	Determine status. More...

	refreshStatus ($a_obj_id, $a_users=null)
	Refresh status. More...

Static Public Member Functions
static	_getInProgress ($a_obj_id)

static	_getCompleted ($a_obj_id)

static	_getNotAttempted ($a_obj_id)

static	getParticipants ($a_obj_id)
	Get participants. More...

Static Public Member Functions inherited from ilLPStatus
static	_getCountNotAttempted ($a_obj_id)

static	_getNotAttempted ($a_obj_id)

static	_getCountInProgress ($a_obj_id)

static	_getInProgress ($a_obj_id)

static	_getCountCompleted ($a_obj_id)

static	_getCompleted ($a_obj_id)

static	_getFailed ($a_obj_id)

static	_getCountFailed ()

static	_getStatusInfo ($a_obj_id)

static	_getTypicalLearningTime ($a_obj_id)

static	checkStatusForObject ($a_obj_id, $a_users=false)
	This function checks whether the status for a given number of users is dirty and must be recalculated. More...

static	writeStatus ($a_obj_id, $a_user_id, $a_status, $a_percentage=false, $a_force_per=false)
	Write status for user and object. More...

static	setInProgressIfNotAttempted ($a_obj_id, $a_user_id)
	This function shoudl be clalled for normal "read events". More...

static	setAllDirty ()
	Sets all status to dirty. More...

static	setDirty ($a_obj_id)
	Sets status of an object to dirty. More...

static	_lookupStatus ($a_obj_id, $a_user_id, $a_create=true)
	Lookup status. More...

static	_lookupPercentage ($a_obj_id, $a_user_id)
	Lookup percentage. More...

static	_hasUserCompleted ($a_obj_id, $a_user_id)
	Lookup user object completion. More...

static	_lookupStatusChanged ($a_obj_id, $a_user_id)
	Lookup status changed. More...

static	_lookupCompletedForObject ($a_obj_id, $a_user_ids=null)
	Get completed users for object. More...

static	_lookupFailedForObject ($a_obj_id, $a_user_ids=null)
	Get failed users for object. More...

static	_lookupInProgressForObject ($a_obj_id, $a_user_ids=null)
	Get in progress users for object. More...

static	preloadListGUIData ($a_obj_ids)

static	getListGUIStatus ($a_obj_id, $a_image_only=false)

Additional Inherited Members
Data Fields inherited from ilLPStatus
	$obj_id = null

	$db = null

const	LP_STATUS_NOT_ATTEMPTED = 'trac_no_attempted'

const	LP_STATUS_IN_PROGRESS = 'trac_in_progress'

const	LP_STATUS_COMPLETED = 'trac_completed'

const	LP_STATUS_FAILED = 'trac_failed'

const	LP_STATUS_NOT_ATTEMPTED_NUM = 0

const	LP_STATUS_IN_PROGRESS_NUM = 1

const	LP_STATUS_COMPLETED_NUM = 2

const	LP_STATUS_FAILED_NUM = 3

const	LP_STATUS_REGISTERED = 'trac_registered'

const	LP_STATUS_NOT_REGISTERED = 'trac_not_registered'

const	LP_STATUS_PARTICIPATED = 'trac_participated'

const	LP_STATUS_NOT_PARTICIPATED = 'trac_not_participated'

Static Public Attributes inherited from ilLPStatus
static	$list_gui_cache

Static Protected Member Functions inherited from ilLPStatus
static	raiseEvent ($a_obj_id, $a_usr_id, $a_status, $a_percentage)

static	_lookupStatusForObject ($a_obj_id, $a_status, $a_user_ids=null)
	Get users with given status for object. More...

static	validateLPForObjects ($a_user_id, $a_obj_ids, $a_parent_ref_id)
	Process given objects for lp-relevance. More...

static	checkLPModesForObjects ($a_obj_ids, array &$a_coll_obj_ids)
	Process lp modes for given objects. More...

static	getLPStatusForObjects ($a_user_id, $a_obj_ids)
	Get LP status for given objects (and user) More...

Detailed Description

Author: Stefan Meyer meyer.nosp@m.@lei.nosp@m.fos.c.nosp@m.om

Version: $Id$

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

Constructor & Destructor Documentation

◆ __construct()

ilLPStatusTestFinished::__construct ( $a_obj_id )

Reimplemented from ilLPStatus.

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

    {
        global $ilDB;
 
        parent::__construct($a_obj_id);
        $this->db = $ilDB;
    }

References $ilDB.

Member Function Documentation

◆ _getCompleted()

static ilLPStatusTestFinished::_getCompleted ( $a_obj_id )

static

Reimplemented from ilLPStatus.

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

    {
        global $ilDB;
 
        include_once './Modules/Test/classes/class.ilObjTestAccess.php';
 
        $query = "
                        SELECT active_id, user_fi, COUNT(tst_sequence.active_fi) sequences
                        FROM tst_active
                        LEFT JOIN tst_sequence
                        ON tst_sequence.active_fi = tst_active.active_id
                        WHERE tries > {$ilDB->quote(0, "integer")}
                        AND test_fi = {$ilDB->quote(ilObjTestAccess::_getTestIDFromObjectID($a_obj_id))}
                        GROUP BY active_id, user_fi
                        HAVING COUNT(tst_sequence.active_fi) > {$ilDB->quote(0, "integer")}
                ";
 
        $res = $ilDB->query($query);
 
        $user_ids = array();
 
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $user_ids[$row->user_fi] = $row->user_fi;
        }
 
        return array_values($user_ids);
    }

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

◆ _getInProgress()

static ilLPStatusTestFinished::_getInProgress ( $a_obj_id )

static

Reimplemented from ilLPStatus.

Definition at line 25 of file class.ilLPStatusTestFinished.php.

    {
        global $ilDB;
 
        include_once './Modules/Test/classes/class.ilObjTestAccess.php';
 
        $query = "
                        SELECT active_id, user_fi, COUNT(tst_sequence.active_fi) sequences
                        FROM tst_active
                        LEFT JOIN tst_sequence
                        ON tst_sequence.active_fi = tst_active.active_id
                        WHERE tries = {$ilDB->quote(0, "integer")}
                        AND test_fi = {$ilDB->quote(ilObjTestAccess::_getTestIDFromObjectID($a_obj_id), "integer")}
                        GROUP BY active_id, user_fi
                        HAVING COUNT(tst_sequence.active_fi) > {$ilDB->quote(0, "integer")}
                ";
 
        $res = $ilDB->query($query);
 
        $user_ids = array();
 
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $user_ids[$row->user_fi] = $row->user_fi;
        }
 
        return array_values($user_ids);
    }

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

◆ _getNotAttempted()

static ilLPStatusTestFinished::_getNotAttempted ( $a_obj_id )

static

Reimplemented from ilLPStatus.

Definition at line 82 of file class.ilLPStatusTestFinished.php.

    {
        global $ilDB;
 
        include_once './Modules/Test/classes/class.ilObjTestAccess.php';
 
        $query = "
                        SELECT active_id, user_fi, COUNT(tst_sequence.active_fi) sequences
                        FROM tst_active
                        LEFT JOIN tst_sequence
                        ON tst_sequence.active_fi = tst_active.active_id
                        WHERE test_fi = {$ilDB->quote(ilObjTestAccess::_getTestIDFromObjectID($a_obj_id))}
                        GROUP BY active_id, user_fi
                        HAVING COUNT(tst_sequence.active_fi) = {$ilDB->quote(0, "integer")}
                ";
 
        $res = $ilDB->query($query);
 
        $user_ids = array();
 
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $user_ids[$row->user_fi] = $row->user_fi;
        }
 
        return array_values($user_ids);
    }

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

◆ determineStatus()

ilLPStatusTestFinished::determineStatus	(	$a_obj_id,
		$a_user_id,
		$a_obj = `null`
	)

Determine status.

Parameters

integer	object id
integer	user id
object	object (optional depends on object type)

Returns: integer status

Reimplemented from ilLPStatus.

Definition at line 140 of file class.ilLPStatusTestFinished.php.

    {
        global $ilDB;
        
        include_once './Modules/Test/classes/class.ilObjTestAccess.php';
 
        $res = $ilDB->query("
                        SELECT active_id, user_fi, tries, COUNT(tst_sequence.active_fi) sequences
                        FROM tst_active
                        LEFT JOIN tst_sequence
                        ON tst_sequence.active_fi = tst_active.active_id
                        WHERE user_fi = {$ilDB->quote($a_user_id, "integer")}
                        AND test_fi = {$ilDB->quote(ilObjTestAccess::_getTestIDFromObjectID($a_obj_id))}
                        GROUP BY active_id, user_fi, tries
                ");
 
        $status = self::LP_STATUS_NOT_ATTEMPTED_NUM;
 
        if ($rec = $ilDB->fetchAssoc($res)) {
            if ($rec['sequences'] > 0) {
                $status = self::LP_STATUS_IN_PROGRESS_NUM;
                
                if ($rec['tries'] > 0) {
                    $status = self::LP_STATUS_COMPLETED_NUM;
                }
            }
        }
 
        return $status;
    }

References $ilDB, $res, ilLPStatus\LP_STATUS_COMPLETED_NUM, ilLPStatus\LP_STATUS_IN_PROGRESS_NUM, and ilLPStatus\LP_STATUS_NOT_ATTEMPTED_NUM.

◆ getParticipants()

static ilLPStatusTestFinished::getParticipants ( $a_obj_id )

static

Get participants.

Parameters

return

Definition at line 115 of file class.ilLPStatusTestFinished.php.

    {
        global $ilDB;
 
        include_once './Modules/Test/classes/class.ilObjTestAccess.php';
 
        $res = $ilDB->query("SELECT DISTINCT user_fi FROM tst_active" .
            " WHERE test_fi = " . $ilDB->quote(ilObjTestAccess::_getTestIDFromObjectID($a_obj_id)));
        $user_ids = array();
 
        while ($rec = $ilDB->fetchAssoc($res)) {
            $user_ids[] = $rec["user_fi"];
        }
        return $user_ids;
    }

References $ilDB, $res, and ilObjTestAccess\_getTestIDFromObjectID().

Here is the call graph for this function:

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

Services/Tracking/classes/status/class.ilLPStatusTestFinished.php

Public Member Functions

Static Public Member Functions

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ _getCompleted()

◆ _getInProgress()

◆ _getNotAttempted()

◆ determineStatus()

◆ getParticipants()