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 (string $type, int $obj_id, int $sub_id=0)

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 25 of file class.ilLPStatusTestFinished.php.

Member Function Documentation

◆ _getCompleted()

static ilLPStatusTestFinished::_getCompleted ( int $a_obj_id )

static

Parameters

int $a_obj_id

Returns: int[]

Reimplemented from ilLPStatus.

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

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

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

Here is the call graph for this function:

◆ _getInProgress()

static ilLPStatusTestFinished::_getInProgress ( int $a_obj_id )

static

Reimplemented from ilLPStatus.

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

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

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

Here is the call graph for this function:

◆ _getNotAttempted()

static ilLPStatusTestFinished::_getNotAttempted ( int $a_obj_id )

static

Parameters

int $a_obj_id

Returns: int[]

Reimplemented from ilLPStatus.

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

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

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

Here is the call graph for this function:

◆ determineStatus()

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

Reimplemented from ilLPStatus.

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

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

References ilLPStatus\LP_STATUS_COMPLETED_NUM, and ilLPStatus\LP_STATUS_IN_PROGRESS_NUM.

◆ getParticipants()

static ilLPStatusTestFinished::getParticipants ( $a_obj_id )

static

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

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

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

Here is the call graph for this function:

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

components/ILIAS/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()