ILIAS  release_5-3 Revision v5.3.23-19-g915713cf615
ilUserQuery Class Reference

User query class. More...

+ Collaboration diagram for ilUserQuery:

Public Member Functions

 __construct ()
 Constructor. More...
 
 setUdfFilter ($a_val)
 Set udf filter. More...
 
 getUdfFilter ()
 Get udf filter. More...
 
 setOrderField ($a_order)
 Set order field (column in usr_data) Default order is 'login'. More...
 
 setOrderDirection ($a_dir)
 Set order direction 'asc' or 'desc' Default is 'asc'. More...
 
 setOffset ($a_offset)
 Set offset. More...
 
 setLimit ($a_limit)
 Set result limit Default is 50. More...
 
 setTextFilter ($a_filter)
 Text (like) filter in login, firstname, lastname or email. More...
 
 setActionFilter ($a_activation)
 Set activation filter 'active' or 'inactive' or empty. More...
 
 setLastLogin (ilDateTime $dt=null)
 Set last login filter. More...
 
 setLimitedAccessFilter ($a_status)
 Enable limited access filter. More...
 
 setNoCourseFilter ($a_no_course)
 Enable no course filter. More...
 
 setNoGroupFilter ($a_no_group)
 Enable no group filter. More...
 
 setCourseGroupFilter ($a_cg_id)
 Set course / group filter object_id of course or group. More...
 
 setRoleFilter ($a_role_id)
 Set role filter obj_id of role. More...
 
 setUserFolder ($a_fold_id)
 Set user folder filter reference id of user folder or category (local user administration) More...
 
 setAdditionalFields ($a_add)
 Set additional fields (columns in usr_data or 'online_time') More...
 
 setUserFilter ($a_filter)
 Array with user ids to query against. More...
 
 setFirstLetterLastname ($a_fll)
 set first letter lastname filter More...
 
 setAccessFilter ($a_access)
 set filter for user that are limited but has access More...
 
 setAuthenticationFilter ($a_authentication)
 Set authentication filter 'default', 'local' or 'lti'. More...
 
 query ()
 Query usr_data. More...
 

Static Public Member Functions

static getUserListData ( $a_order_field, $a_order_dir, $a_offset, $a_limit, $a_string_filter="", $a_activation_filter="", $a_last_login_filter=null, $a_limited_access_filter=false, $a_no_courses_filter=false, $a_course_group_filter=0, $a_role_filter=0, $a_user_folder_filter=null, $a_additional_fields='', $a_user_filter=null, $a_first_letter="", $a_authentication_filter=null)
 Get data for user administration list. More...
 

Data Fields

const DEFAULT_ORDER_FIELD = 'login'
 

Protected Attributes

 $udf_filter = array()
 

Private Attributes

 $logger = null
 
 $order_field = self::DEFAULT_ORDER_FIELD
 
 $order_dir = 'asc'
 
 $offset = 0
 
 $limit = 50
 
 $text_filter = ''
 
 $activation = ''
 
 $last_login = null
 
 $limited_access = false
 
 $no_courses = false
 
 $no_groups = false
 
 $crs_grp = 0
 
 $role = 0
 
 $user_folder = 0
 
 $additional_fields = array()
 
 $users = array()
 
 $first_letter = ''
 
 $has_access = false
 
 $authentication_method = ''
 
 $default_fields
 

Detailed Description

User query class.

Put any complex that queries for a set of users into this class and keep ilObjUser "small".

Author
Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e
Version
$Id$

Definition at line 12 of file class.ilUserQuery.php.

Constructor & Destructor Documentation

◆ __construct()

ilUserQuery::__construct ( )

Constructor.

Definition at line 62 of file class.ilUserQuery.php.

63 {
64 global $DIC;
65
66 $this->logger = $DIC->logger()->usr();
67 }
global $DIC
Definition: saml.php:7

References $DIC.

Member Function Documentation

◆ getUdfFilter()

ilUserQuery::getUdfFilter ( )

Get udf filter.

Returns
array udf filter array

Definition at line 84 of file class.ilUserQuery.php.

85 {
86 return $this->udf_filter;
87 }

References $udf_filter.

Referenced by query().

+ Here is the caller graph for this function:

◆ getUserListData()

static ilUserQuery::getUserListData (   $a_order_field,
  $a_order_dir,
  $a_offset,
  $a_limit,
  $a_string_filter = "",
  $a_activation_filter = "",
  $a_last_login_filter = null,
  $a_limited_access_filter = false,
  $a_no_courses_filter = false,
  $a_course_group_filter = 0,
  $a_role_filter = 0,
  $a_user_folder_filter = null,
  $a_additional_fields = '',
  $a_user_filter = null,
  $a_first_letter = "",
  $a_authentication_filter = null 
)
static

Get data for user administration list.

Deprecated:

Definition at line 571 of file class.ilUserQuery.php.

588 {
589 $query = new ilUserQuery();
590 $query->setOrderField($a_order_field);
591 $query->setOrderDirection($a_order_dir);
592 $query->setOffset($a_offset);
593 $query->setLimit($a_limit);
594 $query->setTextFilter($a_string_filter);
595 $query->setActionFilter($a_activation_filter);
596 $query->setLastLogin($a_last_login_filter);
597 $query->setLimitedAccessFilter($a_limited_access_filter);
598 $query->setNoCourseFilter($a_no_courses_filter);
599 $query->setCourseGroupFilter($a_course_group_filter);
600 $query->setRoleFilter($a_role_filter);
601 $query->setUserFolder($a_user_folder_filter);
602 $query->setAdditionalFields($a_additional_fields);
603 $query->setUserFilter($a_user_filter);
604 $query->setFirstLetterLastname($a_first_letter);
605 $query->setAuthenticationFilter($a_authentication_filter);
606 return $query->query();
607 }
User query class.
$query

References $query.

Referenced by ilAssignedUsersTableGUI\getItems(), ilUserLPTableGUI\getItems(), ilCourseParticipantsTableGUI\parse(), ilGroupParticipantsTableGUI\parse(), ilSubscriberTableGUI\readSubscriberData(), and ilWaitingListTableGUI\readUserData().

+ Here is the caller graph for this function:

◆ query()

ilUserQuery::query ( )

Query usr_data.

Returns
array ('cnt', 'set')

Definition at line 265 of file class.ilUserQuery.php.

266 {
267 global $ilDB;
268
269
270 $udf_fields = array();
271
272 $join = "";
273
274 if (is_array($this->additional_fields)) {
275 foreach ($this->additional_fields as $f) {
276 if (!in_array($f, $this->default_fields)) {
277 if ($f == "online_time") {
278 $this->default_fields[] = "ut_online.online_time";
279 $join = " LEFT JOIN ut_online ON (usr_data.usr_id = ut_online.usr_id) ";
280 } elseif (substr($f, 0, 4) == "udf_") {
281 $udf_fields[] = (int) substr($f, 4);
282 } else {
283 $this->default_fields[] = $f;
284 }
285 }
286 }
287 }
288
289 // if udf fields are involved we need the definitions
290 $udf_def = array();
291 if (count($udf_fields) > 0) {
292 include_once './Services/User/classes/class.ilUserDefinedFields.php';
293 $udf_def = ilUserDefinedFields::_getInstance()->getDefinitions();
294 }
295
296 // join udf table
297 foreach ($udf_fields as $id) {
298 $udf_table = ($udf_def[$id]["field_type"] != UDF_TYPE_WYSIWYG)
299 ? "udf_text"
300 : "udf_clob";
301 $join.= " LEFT JOIN " . $udf_table . " ud_" . $id . " ON (ud_" . $id . ".field_id=" . $ilDB->quote($id) . " AND ud_" . $id . ".usr_id = usr_data.usr_id) ";
302 }
303
304 // count query
305 $count_query = "SELECT count(usr_data.usr_id) cnt" .
306 " FROM usr_data";
307
308 $all_multi_fields = array("interests_general", "interests_help_offered", "interests_help_looking");
309 $multi_fields = array();
310
311 $sql_fields = array();
312 foreach ($this->default_fields as $idx => $field) {
313 if (!$field) {
314 continue;
315 }
316
317 if (in_array($field, $all_multi_fields)) {
318 $multi_fields[] = $field;
319 } elseif (!stristr($field, ".")) {
320 $sql_fields[] = "usr_data." . $field;
321 } else {
322 $sql_fields[] = $field;
323 }
324 }
325
326 // udf fields
327 foreach ($udf_fields as $id) {
328 $sql_fields[] = "ud_" . $id . ".value udf_" . $id;
329 }
330
331 // basic query
332 $query = "SELECT " . implode($sql_fields, ",") .
333 " FROM usr_data" .
334 $join;
335
336 $count_query = $count_query . " " .
337 $join;
338
339 // filter
340 $query.= " WHERE usr_data.usr_id <> " . $ilDB->quote(ANONYMOUS_USER_ID, "integer");
341
342 // User filter
343 $count_query.= " WHERE 1 = 1 ";
344 $count_user_filter = "usr_data.usr_id != " . $ilDB->quote(ANONYMOUS_USER_ID, "integer");
345 if ($this->users and is_array(($this->users))) {
346 $query .= ' AND ' . $ilDB->in('usr_data.usr_id', $this->users, false, 'integer');
347 $count_user_filter = $ilDB->in('usr_data.usr_id', $this->users, false, 'integer');
348 }
349
350 $count_query.= " AND " . $count_user_filter . " ";
351 $where = " AND";
352
353 if ($this->first_letter != "") {
354 $add = $where . " (" . $ilDB->upper($ilDB->substr("usr_data.lastname", 1, 1)) . " = " . $ilDB->upper($ilDB->quote($this->first_letter, "text")) . ") ";
355 $query.= $add;
356 $count_query.= $add;
357 $where = " AND";
358 }
359
360 if ($this->text_filter != "") { // email, name, login
361 $add = $where . " (" . $ilDB->like("usr_data.login", "text", "%" . $this->text_filter . "%") . " " .
362 "OR " . $ilDB->like("usr_data.firstname", "text", "%" . $this->text_filter . "%") . " " .
363 "OR " . $ilDB->like("usr_data.lastname", "text", "%" . $this->text_filter . "%") . " " .
364 "OR " . $ilDB->like("usr_data.second_email", "text", "%" . $this->text_filter . "%") . " " .
365 "OR " . $ilDB->like("usr_data.email", "text", "%" . $this->text_filter . "%") . ") ";
366 $query.= $add;
367 $count_query.= $add;
368 $where = " AND";
369 }
370
371 if ($this->activation != "") { // activation
372 if ($this->activation == "inactive") {
373 $add = $where . " usr_data.active = " . $ilDB->quote(0, "integer") . " ";
374 } else {
375 $add = $where . " usr_data.active = " . $ilDB->quote(1, "integer") . " ";
376 }
377 $query.= $add;
378 $count_query.= $add;
379 $where = " AND";
380 }
381
382 if ($this->last_login instanceof ilDateTime) { // last login
383 if (ilDateTime::_before($this->last_login, new ilDateTime(time(), IL_CAL_UNIX), IL_CAL_DAY)) {
384 $add = $where . " usr_data.last_login < " .
385 $ilDB->quote($this->last_login->get(IL_CAL_DATETIME), "timestamp");
386 $query.= $add;
387 $count_query.= $add;
388 $where = " AND";
389 }
390 }
391 if ($this->limited_access) { // limited access
392 $add = $where . " usr_data.time_limit_unlimited= " . $ilDB->quote(0, "integer");
393 $query.= $add;
394 $count_query.= $add;
395 $where = " AND";
396 }
397
398 // udf filter
399 foreach ($this->getUdfFilter() as $k => $f) {
400 if ($f != "") {
401 $udf_id = explode("_", $k)[1];
402 if ($udf_def[$udf_id]["field_type"] == UDF_TYPE_TEXT) {
403 $add = $where . " " . $ilDB->like("ud_" . $udf_id . ".value", "text", "%" . $f . "%");
404 } else {
405 $add = $where . " ud_" . $udf_id . ".value = " . $ilDB->quote($f, "text");
406 }
407 $query.= $add;
408 $count_query.= $add;
409 $where = " AND";
410 }
411 }
412
413 if ($this->has_access) { //user is limited but has access
414 $unlimited = "time_limit_unlimited = " . $ilDB->quote(1, 'integer');
415 $from = "time_limit_from < " . $ilDB->quote(time(), 'integer');
416 $until = "time_limit_until > " . $ilDB->quote(time(), 'integer');
417
418 $add = $where . ' (' . $unlimited . ' OR (' . $from . ' AND ' . $until . '))';
419 $query.= $add;
420 $count_query.= $add;
421 $where = " AND";
422 }
423 if ($this->no_courses) { // no courses assigned
424 $add = $where . " usr_data.usr_id NOT IN (" .
425 "SELECT DISTINCT ud.usr_id " .
426 "FROM usr_data ud join rbac_ua ON (ud.usr_id = rbac_ua.usr_id) " .
427 "JOIN object_data od ON (rbac_ua.rol_id = od.obj_id) " .
428 "WHERE od.title LIKE 'il_crs_%')";
429 $query.= $add;
430 $count_query.= $add;
431 $where = " AND";
432 }
433 if ($this->no_groups) { // no groups assigned
434 $add = $where . " usr_data.usr_id NOT IN (" .
435 "SELECT DISTINCT ud.usr_id " .
436 "FROM usr_data ud join rbac_ua ON (ud.usr_id = rbac_ua.usr_id) " .
437 "JOIN object_data od ON (rbac_ua.rol_id = od.obj_id) " .
438 "WHERE od.title LIKE 'il_grp_%')";
439 $query.= $add;
440 $count_query.= $add;
441 $where = " AND";
442 }
443 if ($this->crs_grp > 0) { // members of course/group
444 $cgtype = ilObject::_lookupType($this->crs_grp, true);
445 $add = $where . " usr_data.usr_id IN (" .
446 "SELECT DISTINCT ud.usr_id " .
447 "FROM usr_data ud join rbac_ua ON (ud.usr_id = rbac_ua.usr_id) " .
448 "JOIN object_data od ON (rbac_ua.rol_id = od.obj_id) " .
449 "WHERE od.title = " . $ilDB->quote("il_" . $cgtype . "_member_" . $this->crs_grp, "text") . ")";
450 $query.= $add;
451 $count_query.= $add;
452 $where = " AND";
453 }
454 if ($this->role > 0) { // global role
455 $add = $where . " usr_data.usr_id IN (" .
456 "SELECT DISTINCT ud.usr_id " .
457 "FROM usr_data ud join rbac_ua ON (ud.usr_id = rbac_ua.usr_id) " .
458 "WHERE rbac_ua.rol_id = " . $ilDB->quote($this->role, "integer") . ")";
459 $query.= $add;
460 $count_query.= $add;
461 $where = " AND";
462 }
463
464 if ($this->user_folder) {
465 $add = $where . " " . $ilDB->in('usr_data.time_limit_owner', $this->user_folder, false, 'integer');
466 $query.= $add;
467 $count_query.= $add;
468 $where = " AND";
469 }
470
471 if ($this->authentication_method != "") { // authentication
472 $add = $where . " usr_data.auth_mode = " . $ilDB->quote($this->authentication_method, "text") . " ";
473 $query.= $add;
474 $count_query.= $add;
475 $where = " AND";
476 }
477
478 // order by
479 switch ($this->order_field) {
480 case "access_until":
481 if ($this->order_dir == "desc") {
482 $query.= " ORDER BY usr_data.active DESC, usr_data.time_limit_unlimited DESC, usr_data.time_limit_until DESC";
483 } else {
484 $query.= " ORDER BY usr_data.active ASC, usr_data.time_limit_unlimited ASC, usr_data.time_limit_until ASC";
485 }
486 break;
487
488 case "online_time":
489 if ($this->order_dir == "desc") {
490 $query.= " ORDER BY ut_online.online_time DESC";
491 } else {
492 $query.= " ORDER BY ut_online.online_time ASC";
493 }
494 break;
495
496 default:
497 if ($this->order_dir != "asc" && $this->order_dir != "desc") {
498 $this->order_dir = "asc";
499 }
500 if (substr($this->order_field, 0, 4) == "udf_") {
501 // #25311 check if order field is in field list
502 if (is_array($this->getUdfFilter()) && array_key_exists($this->order_field, $this->getUdfFilter())) {
503 $query .= " ORDER BY ud_" . ((int) substr($this->order_field, 4)) . ".value " . strtoupper($this->order_dir);
504 } else {
505 $query .= ' ORDER BY ' . self::DEFAULT_ORDER_FIELD . ' ' . strtoupper($this->order_dir);
506 }
507 } else {
508 if (!in_array($this->order_field, $this->default_fields)) {
509 $this->order_field = "login";
510 }
511 $query .= " ORDER BY usr_data." . $this->order_field . " " . strtoupper($this->order_dir);
512 }
513 break;
514 }
515
516 // count query
517 $set = $ilDB->query($count_query);
518 $cnt = 0;
519 if ($rec = $ilDB->fetchAssoc($set)) {
520 $cnt = $rec["cnt"];
521 }
522
523 $offset = (int) $this->offset;
524 $limit = (int) $this->limit;
525
526 // #9866: validate offset against rowcount
527 if ($offset >= $cnt) {
528 $offset = 0;
529 }
530
531 $ilDB->setLimit($limit, $offset);
532
533 if (sizeof($multi_fields)) {
534 $usr_ids = array();
535 }
536
537 // set query
538 $set = $ilDB->query($query);
539 $result = array();
540 while ($rec = $ilDB->fetchAssoc($set)) {
541 $result[] = $rec;
542
543 if (sizeof($multi_fields)) {
544 $usr_ids[] = $rec["usr_id"];
545 }
546 }
547
548 // add multi-field-values to user-data
549 if (sizeof($multi_fields) && sizeof($usr_ids)) {
550 $usr_multi = array();
551 $set = $ilDB->query("SELECT * FROM usr_data_multi" .
552 " WHERE " . $ilDB->in("usr_id", $usr_ids, "", "integer"));
553 while ($row = $ilDB->fetchAssoc($set)) {
554 $usr_multi[$row["usr_id"]][$row["field_id"]][] = $row["value"];
555 }
556 foreach ($result as $idx => $item) {
557 if (isset($usr_multi[$item["usr_id"]])) {
558 $result[$idx] = array_merge($item, $usr_multi[$item["usr_id"]]);
559 }
560 }
561 }
562
563 return array("cnt" => $cnt, "set" => $result);
564 }
$result
const IL_CAL_UNIX
const IL_CAL_DATETIME
const IL_CAL_DAY
const UDF_TYPE_WYSIWYG
const UDF_TYPE_TEXT
@classDescription Date and time handling
static _before(ilDateTime $start, ilDateTime $end, $a_compare_field='', $a_tz='')
compare two dates and check start is before end This method does not consider tz offsets.
static _lookupType($a_id, $a_reference=false)
lookup object type
static _getInstance()
Get instance.
getUdfFilter()
Get udf filter.
if(!array_key_exists('StateId', $_REQUEST)) $id
global $ilDB
$from

References $from, $id, $ilDB, $limit, $offset, $query, $result, $row, ilDateTime\_before(), ilUserDefinedFields\_getInstance(), ilObject\_lookupType(), getUdfFilter(), IL_CAL_DATETIME, IL_CAL_DAY, IL_CAL_UNIX, UDF_TYPE_TEXT, and UDF_TYPE_WYSIWYG.

+ Here is the call graph for this function:

◆ setAccessFilter()

ilUserQuery::setAccessFilter (   $a_access)

set filter for user that are limited but has access

Parameters
$a_access

Definition at line 246 of file class.ilUserQuery.php.

247 {
248 $this->has_access = (bool) $a_access;
249 }

◆ setActionFilter()

ilUserQuery::setActionFilter (   $a_activation)

Set activation filter 'active' or 'inactive' or empty.

Parameters
string$a_activation

Definition at line 143 of file class.ilUserQuery.php.

144 {
145 $this->activation = $a_activation;
146 }

◆ setAdditionalFields()

ilUserQuery::setAdditionalFields (   $a_add)

Set additional fields (columns in usr_data or 'online_time')

Parameters
array$additional_fields

Definition at line 218 of file class.ilUserQuery.php.

219 {
220 $this->additional_fields = (array) $a_add;
221 }

◆ setAuthenticationFilter()

ilUserQuery::setAuthenticationFilter (   $a_authentication)

Set authentication filter 'default', 'local' or 'lti'.

Parameters
string$a_authentication

Definition at line 256 of file class.ilUserQuery.php.

257 {
258 $this->authentication_method = $a_authentication;
259 }

◆ setCourseGroupFilter()

ilUserQuery::setCourseGroupFilter (   $a_cg_id)

Set course / group filter object_id of course or group.

Parameters
int$a_cg_id

Definition at line 189 of file class.ilUserQuery.php.

190 {
191 $this->crs_grp = $a_cg_id;
192 }

◆ setFirstLetterLastname()

ilUserQuery::setFirstLetterLastname (   $a_fll)

set first letter lastname filter

Parameters
string$a_fll

Definition at line 236 of file class.ilUserQuery.php.

237 {
238 $this->first_letter = $a_fll;
239 }

◆ setLastLogin()

ilUserQuery::setLastLogin ( ilDateTime  $dt = null)

Set last login filter.

Parameters
ilDateTime$dt

Definition at line 152 of file class.ilUserQuery.php.

153 {
154 $this->last_login = $dt;
155 }

◆ setLimit()

ilUserQuery::setLimit (   $a_limit)

Set result limit Default is 50.

Parameters
int$a_limit

Definition at line 124 of file class.ilUserQuery.php.

125 {
126 $this->limit = $a_limit;
127 }

◆ setLimitedAccessFilter()

ilUserQuery::setLimitedAccessFilter (   $a_status)

Enable limited access filter.

Parameters
bool

Definition at line 161 of file class.ilUserQuery.php.

162 {
163 $this->limited_access = $a_status;
164 }

◆ setNoCourseFilter()

ilUserQuery::setNoCourseFilter (   $a_no_course)

Enable no course filter.

Parameters
bool$a_no_course

Definition at line 170 of file class.ilUserQuery.php.

171 {
172 $this->no_courses = $a_no_course;
173 }

◆ setNoGroupFilter()

ilUserQuery::setNoGroupFilter (   $a_no_group)

Enable no group filter.

Parameters
bool$a_no_group

Definition at line 179 of file class.ilUserQuery.php.

180 {
181 $this->no_groups = $a_no_group;
182 }

◆ setOffset()

ilUserQuery::setOffset (   $a_offset)

Set offset.

Parameters
int$a_offset

Definition at line 114 of file class.ilUserQuery.php.

115 {
116 $this->offset = $a_offset;
117 }

◆ setOrderDirection()

ilUserQuery::setOrderDirection (   $a_dir)

Set order direction 'asc' or 'desc' Default is 'asc'.

Parameters
string$a_dir

Definition at line 105 of file class.ilUserQuery.php.

106 {
107 $this->order_dir = $a_dir;
108 }

◆ setOrderField()

ilUserQuery::setOrderField (   $a_order)

Set order field (column in usr_data) Default order is 'login'.

Parameters
string

Definition at line 94 of file class.ilUserQuery.php.

95 {
96 $this->order_field = $a_order;
97 }

◆ setRoleFilter()

ilUserQuery::setRoleFilter (   $a_role_id)

Set role filter obj_id of role.

Parameters
int$a_role_id

Definition at line 199 of file class.ilUserQuery.php.

200 {
201 $this->role = $a_role_id;
202 }

◆ setTextFilter()

ilUserQuery::setTextFilter (   $a_filter)

Text (like) filter in login, firstname, lastname or email.

Parameters
stringfilter

Definition at line 133 of file class.ilUserQuery.php.

134 {
135 $this->text_filter = $a_filter;
136 }

◆ setUdfFilter()

ilUserQuery::setUdfFilter (   $a_val)

Set udf filter.

Parameters
array$a_valudf filter array

Definition at line 74 of file class.ilUserQuery.php.

75 {
76 $this->udf_filter = $a_val;
77 }

◆ setUserFilter()

ilUserQuery::setUserFilter (   $a_filter)

Array with user ids to query against.

Parameters
array$a_filter

Definition at line 227 of file class.ilUserQuery.php.

228 {
229 $this->users = $a_filter;
230 }

◆ setUserFolder()

ilUserQuery::setUserFolder (   $a_fold_id)

Set user folder filter reference id of user folder or category (local user administration)

Parameters
type$a_fold_id

Definition at line 209 of file class.ilUserQuery.php.

210 {
211 $this->user_folder = $a_fold_id;
212 }

Field Documentation

◆ $activation

ilUserQuery::$activation = ''
private

Definition at line 26 of file class.ilUserQuery.php.

◆ $additional_fields

ilUserQuery::$additional_fields = array()
private

Definition at line 34 of file class.ilUserQuery.php.

◆ $authentication_method

ilUserQuery::$authentication_method = ''
private

Definition at line 38 of file class.ilUserQuery.php.

◆ $crs_grp

ilUserQuery::$crs_grp = 0
private

Definition at line 31 of file class.ilUserQuery.php.

◆ $default_fields

ilUserQuery::$default_fields
private
Initial value:
= array(
"usr_id",
"login",
"firstname",
"lastname",
"email",
"second_email",
"time_limit_until",
"time_limit_unlimited",
"time_limit_owner",
"last_login",
"active"
)

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

◆ $first_letter

ilUserQuery::$first_letter = ''
private

Definition at line 36 of file class.ilUserQuery.php.

◆ $has_access

ilUserQuery::$has_access = false
private

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

◆ $last_login

ilUserQuery::$last_login = null
private

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

◆ $limit

ilUserQuery::$limit = 50
private

Definition at line 24 of file class.ilUserQuery.php.

Referenced by query().

◆ $limited_access

ilUserQuery::$limited_access = false
private

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

◆ $logger

ilUserQuery::$logger = null
private

Definition at line 19 of file class.ilUserQuery.php.

◆ $no_courses

ilUserQuery::$no_courses = false
private

Definition at line 29 of file class.ilUserQuery.php.

◆ $no_groups

ilUserQuery::$no_groups = false
private

Definition at line 30 of file class.ilUserQuery.php.

◆ $offset

ilUserQuery::$offset = 0
private

Definition at line 23 of file class.ilUserQuery.php.

Referenced by query().

◆ $order_dir

ilUserQuery::$order_dir = 'asc'
private

Definition at line 22 of file class.ilUserQuery.php.

◆ $order_field

ilUserQuery::$order_field = self::DEFAULT_ORDER_FIELD
private

Definition at line 21 of file class.ilUserQuery.php.

◆ $role

ilUserQuery::$role = 0
private

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

◆ $text_filter

ilUserQuery::$text_filter = ''
private

Definition at line 25 of file class.ilUserQuery.php.

◆ $udf_filter

ilUserQuery::$udf_filter = array()
protected

Definition at line 43 of file class.ilUserQuery.php.

Referenced by getUdfFilter().

◆ $user_folder

ilUserQuery::$user_folder = 0
private

Definition at line 33 of file class.ilUserQuery.php.

◆ $users

ilUserQuery::$users = array()
private

Definition at line 35 of file class.ilUserQuery.php.

◆ DEFAULT_ORDER_FIELD

const ilUserQuery::DEFAULT_ORDER_FIELD = 'login'

Definition at line 14 of file class.ilUserQuery.php.


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