ilLPStatusTestFinished Class Reference

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

)

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

References $ilDB.

    {
        global $ilDB;

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

Member Function Documentation

_getCompleted()

static ilLPStatusTestFinished::_getCompleted (   $a_obj_id )

static

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

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

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

_getInProgress()

static ilLPStatusTestFinished::_getInProgress (   $a_obj_id )

static

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

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

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

_getNotAttempted()

static ilLPStatusTestFinished::_getNotAttempted (   $a_obj_id )

static

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

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

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

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

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

References $ilDB, and $res.

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

getParticipants()

static ilLPStatusTestFinished::getParticipants (   $a_obj_id )

static

Get participants.

Parameters

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

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

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

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