Inheritance diagram for ilLPStatusTestFinished:

Collaboration diagram for ilLPStatusTestFinished:

Public Member Functions
	determineStatus (int $a_obj_id, int $a_usr_id, object $a_obj=null)

Public Member Functions inherited from ilLPStatus
	__construct (int $a_obj_id)

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

	determinePercentage (int $a_obj_id, int $a_usr_id, ?object $a_obj=null)

	determineStatus (int $a_obj_id, int $a_usr_id, object $a_obj=null)

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

Static Public Member Functions
static	_getInProgress (int $a_obj_id)

static	_getCompleted (int $a_obj_id)

static	_getNotAttempted (int $a_obj_id)

static	getParticipants ($a_obj_id)

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

static	_getNotAttempted (int $a_obj_id)

static	_getCountInProgress (int $a_obj_id)

static	_getInProgress (int $a_obj_id)

static	_getCountCompleted (int $a_obj_id)

static	_getCompleted (int $a_obj_id)

static	_getFailed (int $a_obj_id)

static	_getCountFailed (int $a_obj_id)

static	_getStatusInfo (int $a_obj_id)

static	_getTypicalLearningTime (int $a_obj_id)

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

static	writeStatus (int $a_obj_id, int $a_user_id, int $a_status, int $a_percentage=0, bool $a_force_per=false, ?int &$a_old_status=self::LP_STATUS_NOT_ATTEMPTED_NUM)
	Write status for user and object. More...

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

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

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

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

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

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

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

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

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

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

static	preloadListGUIData (array $a_obj_ids)

static	getListGUIStatus (int $a_obj_id, bool $a_image_only=true)

static	hasListGUIStatus (int $a_obj_id)

Additional Inherited Members
Data Fields inherited from ilLPStatus
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 (int $a_obj_id, int $a_usr_id, int $a_status, int $a_old_status, int $a_percentage)

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

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

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

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

Protected Attributes inherited from ilLPStatus
int	$obj_id

ilDBInterface	$db

ilObjectDataCache	$ilObjDataCache

Detailed Description

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

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

Member Function Documentation

◆ _getCompleted()

static ilLPStatusTestFinished::_getCompleted ( int $a_obj_id )

static

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

References $DIC, $ilDB, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

                                                        : array
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         $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] = (int) $row->user_fi;
         }
         return array_values($user_ids);
     }

Here is the call graph for this function:

◆ _getInProgress()

static ilLPStatusTestFinished::_getInProgress ( int $a_obj_id )

static

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

References $DIC, $ilDB, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

                                                         : array
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $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] = (int) $row->user_fi;
         }
         return array_values($user_ids);
     }

Here is the call graph for this function:

◆ _getNotAttempted()

static ilLPStatusTestFinished::_getNotAttempted ( int $a_obj_id )

static

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

References $DIC, $ilDB, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

                                                           : array
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $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] = (int) $row->user_fi;
         }
 
         return array_values($user_ids);
     }

Here is the call graph for this function:

◆ determineStatus()

ilLPStatusTestFinished::determineStatus	(	int	$a_obj_id,
		int	$a_usr_id,
		object	$a_obj = `null`
	)

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

References $res.

      : int {
         $res = $this->db->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 = {$this->db->quote($a_usr_id, "integer")}
                         AND test_fi = {$this->db->quote(ilObjTestAccess::_getTestIDFromObjectID($a_obj_id), ilDBConstants::T_INTEGER)}
                         GROUP BY active_id, user_fi, tries
                 "
         );
 
         $status = self::LP_STATUS_NOT_ATTEMPTED_NUM;
 
         if ($rec = $this->db->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

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

References $DIC, $ilDB, $res, ilObjTestAccess\_getTestIDFromObjectID(), and ILIAS\Repository\int().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $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[] = (int) $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

Public Member Functions

Static Public Member Functions

Additional Inherited Members

Detailed Description

Member Function Documentation

◆ _getCompleted()

◆ _getInProgress()

◆ _getNotAttempted()

◆ determineStatus()

◆ getParticipants()