ILIAS  release_8 Revision v8.19-1-g4e8f2f9140c
All Data Structures Namespaces Files Functions Variables Modules Pages
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

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

37  : array
38  {
39  return self::getParticipants($a_obj_id, true);
40  }

◆ _getInProgress()

static ilLPStatusSurveyFinished::_getInProgress ( int  $a_obj_id)
static

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

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

◆ _getNotAttempted()

static ilLPStatusSurveyFinished::_getNotAttempted ( int  $a_obj_id)
static

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

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

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 _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 42 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.

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

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

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  }
$res
Definition: ltiservices.php:69
quote($value, string $type)
global $DIC
Definition: feed.php:28
query(string $query)
Run a (read-only) Query on the database.
$query
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 76 of file class.ilLPStatusSurveyFinished.php.

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

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

◆ getSurveyId()

static ilLPStatusSurveyFinished::getSurveyId ( int  $a_obj_id)
staticprotected

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

References $DIC, and $ilDB.

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

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