ILIAS  trunk Revision v11.0_alpha-3011-gc6b235a2e85
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 (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)
 

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 50 of file class.ilLPStatusSurveyFinished.php.

50 : array
51 {
52 return self::getParticipants($a_obj_id, true);
53 }
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 45 of file class.ilLPStatusSurveyFinished.php.

45 : array
46 {
47 return self::getParticipants($a_obj_id);
48 }

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 28 of file class.ilLPStatusSurveyFinished.php.

28 : array
29 {
30 $invited = self::getInvitations($a_obj_id);
31 if ($invited === []) {
32 return [];
33 }
34 $users = array_diff(
35 (array) $invited,
37 );
38 $users = array_diff(
39 $users,
41 );
42 return $users;
43 }
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 55 of file class.ilLPStatusSurveyFinished.php.

59 : int {
60 $survey_id = self::getSurveyId($a_obj_id);
61 if (!$survey_id) {
63 }
65
66 if (ilObjSurveyAccess::_isSurveyParticipant($a_usr_id, $survey_id)) {
68
69 if (ilObjSurveyAccess::_lookupFinished($a_obj_id, $a_usr_id)) {
71 }
72 }
73 return $status;
74 }
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 120 of file class.ilLPStatusSurveyFinished.php.

120 : array
121 {
122 global $DIC;
123
124 $db = $DIC->database();
125 $query = 'select user_id from svy_invitation si ' .
126 'join svy_svy ss on ss.survey_id = si.survey_id ' .
127 'where obj_fi = ' . $db->quote($a_obj_id, ilDBConstants::T_INTEGER);
128 $res = $db->query($query);
129 $invited = [];
130 while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
131 $invited[] = (int) $row->user_id;
132 }
133 return $invited;
134 }
ilDBInterface $db
quote($value, string $type)
query(string $query)
Run a (read-only) Query on the database.
$res
Definition: ltiservices.php:69
global $DIC
Definition: shib_login.php:26

References $DIC, $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 89 of file class.ilLPStatusSurveyFinished.php.

92 : array {
93 global $DIC;
94
95 $ilDB = $DIC['ilDB'];
96 $res = array();
97 $survey_id = self::getSurveyId($a_obj_id);
98 if (!$survey_id) {
99 return $res;
100 }
101
102 $sql = "SELECT user_fi FROM svy_finished fin" .
103 " WHERE fin.survey_fi = " . $ilDB->quote($survey_id, "integer");
104
105 if ($a_only_finished) {
106 $sql .= " AND fin.state = " . $ilDB->quote(1, "integer");
107 }
108
109 $set = $ilDB->query($sql);
110 while ($row = $ilDB->fetchAssoc($set)) {
111 $res[] = (int) $row["user_fi"];
112 }
113 return $res;
114 }

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 76 of file class.ilLPStatusSurveyFinished.php.

76 : int
77 {
78 global $DIC;
79
80 $ilDB = $DIC['ilDB'];
81 $set = $ilDB->query(
82 "SELECT survey_id FROM svy_svy" .
83 " WHERE obj_fi = " . $ilDB->quote($a_obj_id)
84 );
85 $row = $ilDB->fetchAssoc($set);
86 return (int) ($row["survey_id"] ?? 0);
87 }

References $DIC, and $ilDB.


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