ILIAS  release_8 Revision v8.24
ilLPStatusSurveyFinished Class Reference
+ Inheritance diagram for ilLPStatusSurveyFinished:
+ Collaboration diagram for ilLPStatusSurveyFinished:

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 _getNotAttempted (int $a_obj_id)
 
static _getInProgress (int $a_obj_id)
 
static _getCompleted (int $a_obj_id)
 
static getParticipants (int $a_obj_id, bool $a_only_finished=false)
 
static getInvitations (int $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)
 

Static Protected Member Functions

static getSurveyId (int $a_obj_id)
 
- 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...
 

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
 
- Protected Attributes inherited from ilLPStatus
int $obj_id
 
ilDBInterface $db
 
ilObjectDataCache $ilObjDataCache
 

Detailed Description

Member Function Documentation

◆ _getCompleted()

static ilLPStatusSurveyFinished::_getCompleted ( int  $a_obj_id)
static
Parameters
int$a_obj_id
Returns
int[]

Reimplemented from ilLPStatus.

Definition at line 37 of file class.ilLPStatusSurveyFinished.php.

37 : array
38 {
39 return self::getParticipants($a_obj_id, true);
40 }
static getParticipants(int $a_obj_id, bool $a_only_finished=false)

References getParticipants().

+ Here is the call graph for this function:

◆ _getInProgress()

static ilLPStatusSurveyFinished::_getInProgress ( int  $a_obj_id)
static

Reimplemented from ilLPStatus.

Definition at line 32 of file class.ilLPStatusSurveyFinished.php.

32 : array
33 {
34 return self::getParticipants($a_obj_id);
35 }

References getParticipants().

+ Here is the call graph for this function:

◆ _getNotAttempted()

static ilLPStatusSurveyFinished::_getNotAttempted ( int  $a_obj_id)
static
Parameters
int$a_obj_id
Returns
int[]

Reimplemented from ilLPStatus.

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

15 : array
16 {
17 $invited = self::getInvitations($a_obj_id);
18 if ($invited === []) {
19 return [];
20 }
21 $users = array_diff(
22 (array) $invited,
24 );
25 $users = array_diff(
26 $users,
28 );
29 return $users;
30 }
static _getInProgress(int $a_obj_id)
Static function to read users who have the status 'in_progress'.
static _getCompleted(int $a_obj_id)
Static function to read the users who have the status 'completed'.

References ilLPStatusWrapper\_getCompleted(), ilLPStatusWrapper\_getInProgress(), and getInvitations().

+ Here is the call graph for this function:

◆ determineStatus()

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

Reimplemented from ilLPStatus.

Definition at line 42 of file class.ilLPStatusSurveyFinished.php.

46 : int {
47 $survey_id = self::getSurveyId($a_obj_id);
48 if (!$survey_id) {
50 }
52
53 if (ilObjSurveyAccess::_isSurveyParticipant($a_usr_id, $survey_id)) {
55
56 if (ilObjSurveyAccess::_lookupFinished($a_obj_id, $a_usr_id)) {
58 }
59 }
60 return $status;
61 }
const LP_STATUS_COMPLETED_NUM
const LP_STATUS_IN_PROGRESS_NUM
const LP_STATUS_NOT_ATTEMPTED_NUM
static _lookupFinished(int $a_obj_id, int $a_user_id=0)
get finished status
static _isSurveyParticipant(int $user_id, int $survey_id)

References ilLPStatus\LP_STATUS_NOT_ATTEMPTED_NUM.

◆ getInvitations()

static ilLPStatusSurveyFinished::getInvitations ( int  $a_obj_id)
static
Parameters
int$a_obj_id
Returns
int[]

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

107 : array
108 {
109 global $DIC;
110
111 $db = $DIC->database();
112 $query = 'select user_id from svy_invitation si ' .
113 'join svy_svy ss on ss.survey_id = si.survey_id ' .
114 'where obj_fi = ' . $db->quote($a_obj_id, ilDBConstants::T_INTEGER);
115 $res = $db->query($query);
116 $invited = [];
117 while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
118 $invited[] = (int) $row->user_id;
119 }
120 return $invited;
121 }
ilDBInterface $db
global $DIC
Definition: feed.php:28
quote($value, string $type)
query(string $query)
Run a (read-only) Query on the database.
$res
Definition: ltiservices.php:69
$query

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

Referenced by _getNotAttempted().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ getParticipants()

static ilLPStatusSurveyFinished::getParticipants ( int  $a_obj_id,
bool  $a_only_finished = false 
)
static

Definition at line 76 of file class.ilLPStatusSurveyFinished.php.

79 : array {
80 global $DIC;
81
82 $ilDB = $DIC['ilDB'];
83 $res = array();
84 $survey_id = self::getSurveyId($a_obj_id);
85 if (!$survey_id) {
86 return $res;
87 }
88
89 $sql = "SELECT user_fi FROM svy_finished fin" .
90 " WHERE fin.survey_fi = " . $ilDB->quote($survey_id, "integer");
91
92 if ($a_only_finished) {
93 $sql .= " AND fin.state = " . $ilDB->quote(1, "integer");
94 }
95
96 $set = $ilDB->query($sql);
97 while ($row = $ilDB->fetchAssoc($set)) {
98 $res[] = (int) $row["user_fi"];
99 }
100 return $res;
101 }

Referenced by _getCompleted(), and _getInProgress().

+ Here is the caller graph for this function:

◆ getSurveyId()

static ilLPStatusSurveyFinished::getSurveyId ( int  $a_obj_id)
staticprotected

Definition at line 63 of file class.ilLPStatusSurveyFinished.php.

63 : int
64 {
65 global $DIC;
66
67 $ilDB = $DIC['ilDB'];
68 $set = $ilDB->query(
69 "SELECT survey_id FROM svy_svy" .
70 " WHERE obj_fi = " . $ilDB->quote($a_obj_id)
71 );
72 $row = $ilDB->fetchAssoc($set);
73 return (int) ($row["survey_id"] ?? 0);
74 }

References $DIC, and $ilDB.


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