ILIAS  trunk Revision v11.0_alpha-2662-g519ff7d528f
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

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

50  : array
51  {
52  return self::getParticipants($a_obj_id, true);
53  }

◆ _getInProgress()

static ilLPStatusSurveyFinished::_getInProgress ( int  $a_obj_id)
static

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

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

◆ _getNotAttempted()

static ilLPStatusSurveyFinished::_getNotAttempted ( int  $a_obj_id)
static

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

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

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 _getCompleted(int $a_obj_id)
Static function to read the users who have the status 'completed'.
static _getInProgress(int $a_obj_id)
Static function to read users who have the status 'in_progress'.
+ Here is the call graph for this function:

◆ determineStatus()

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

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

References ilObjSurveyAccess\_isSurveyParticipant(), ilObjSurveyAccess\_lookupFinished(), ilLPStatus\LP_STATUS_COMPLETED_NUM, ilLPStatus\LP_STATUS_IN_PROGRESS_NUM, and ilLPStatus\LP_STATUS_NOT_ATTEMPTED_NUM.

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
static _isSurveyParticipant(int $user_id, int $survey_id)
const LP_STATUS_IN_PROGRESS_NUM
static _lookupFinished(int $a_obj_id, int $a_user_id=0)
get finished status
const LP_STATUS_NOT_ATTEMPTED_NUM
+ Here is the call graph for this function:

◆ 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.

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

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  }
$res
Definition: ltiservices.php:66
quote($value, string $type)
global $DIC
Definition: shib_login.php:26
query(string $query)
Run a (read-only) Query on the database.
ilDBInterface $db
+ Here is the call 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.

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

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  }
$res
Definition: ltiservices.php:66
global $DIC
Definition: shib_login.php:26
+ Here is the call graph for this function:

◆ getSurveyId()

static ilLPStatusSurveyFinished::getSurveyId ( int  $a_obj_id)
staticprotected

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

References $DIC, and $ilDB.

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  }
global $DIC
Definition: shib_login.php:26

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