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.

References $DIC.

     {
         global $DIC;
 
         $this->logger = $DIC->logger()->usr();
     }

Member Function Documentation

◆ getUdfFilter()

ilUserQuery::getUdfFilter ( )

Get udf filter.

Returns: array udf filter array

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

References $udf_filter.

Referenced by query().

     {
         return $this->udf_filter;
     }

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.

References $query.

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

       {
         $query = new ilUserQuery();
         $query->setOrderField($a_order_field);
         $query->setOrderDirection($a_order_dir);
         $query->setOffset($a_offset);
         $query->setLimit($a_limit);
         $query->setTextFilter($a_string_filter);
         $query->setActionFilter($a_activation_filter);
         $query->setLastLogin($a_last_login_filter);
         $query->setLimitedAccessFilter($a_limited_access_filter);
         $query->setNoCourseFilter($a_no_courses_filter);
         $query->setCourseGroupFilter($a_course_group_filter);
         $query->setRoleFilter($a_role_filter);
         $query->setUserFolder($a_user_folder_filter);
         $query->setAdditionalFields($a_additional_fields);
         $query->setUserFilter($a_user_filter);
         $query->setFirstLetterLastname($a_first_letter);
         $query->setAuthenticationFilter($a_authentication_filter);
         return $query->query();
     }

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.

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

     {
         global $ilDB;
 
 
         $udf_fields = array();
 
         $join = "";
 
         if (is_array($this->additional_fields)) {
             foreach ($this->additional_fields as $f) {
                 if (!in_array($f, $this->default_fields)) {
                     if ($f == "online_time") {
                         $this->default_fields[] = "ut_online.online_time";
                         $join = " LEFT JOIN ut_online ON (usr_data.usr_id = ut_online.usr_id) ";
                     } elseif (substr($f, 0, 4) == "udf_") {
                         $udf_fields[] = (int) substr($f, 4);
                     } else {
                         $this->default_fields[] = $f;
                     }
                 }
             }
         }
 
         // if udf fields are involved we need the definitions
         $udf_def = array();
         if (count($udf_fields) > 0) {
             include_once './Services/User/classes/class.ilUserDefinedFields.php';
             $udf_def = ilUserDefinedFields::_getInstance()->getDefinitions();
         }
 
         // join udf table
         foreach ($udf_fields as $id) {
             $udf_table = ($udf_def[$id]["field_type"] != UDF_TYPE_WYSIWYG)
                 ? "udf_text"
                 : "udf_clob";
             $join.= " LEFT JOIN " . $udf_table . " ud_" . $id . " ON (ud_" . $id . ".field_id=" . $ilDB->quote($id) . " AND ud_" . $id . ".usr_id = usr_data.usr_id) ";
         }
 
         // count query
         $count_query = "SELECT count(usr_data.usr_id) cnt" .
             " FROM usr_data";
         
         $all_multi_fields = array("interests_general", "interests_help_offered", "interests_help_looking");
         $multi_fields = array();
         
         $sql_fields = array();
         foreach ($this->default_fields as $idx => $field) {
             if (!$field) {
                 continue;
             }
             
             if (in_array($field, $all_multi_fields)) {
                 $multi_fields[] = $field;
             } elseif (!stristr($field, ".")) {
                 $sql_fields[] = "usr_data." . $field;
             } else {
                 $sql_fields[] = $field;
             }
         }
 
         // udf fields
         foreach ($udf_fields as $id) {
             $sql_fields[] = "ud_" . $id . ".value udf_" . $id;
         }
 
         // basic query
         $query = "SELECT " . implode($sql_fields, ",") .
             " FROM usr_data" .
             $join;
 
         $count_query = $count_query . " " .
             $join;
 
         // filter
         $query.= " WHERE usr_data.usr_id <> " . $ilDB->quote(ANONYMOUS_USER_ID, "integer");
 
         // User filter
         $count_query.= " WHERE 1 = 1 ";
         $count_user_filter = "usr_data.usr_id != " . $ilDB->quote(ANONYMOUS_USER_ID, "integer");
         if ($this->users and is_array(($this->users))) {
             $query .= ' AND ' . $ilDB->in('usr_data.usr_id', $this->users, false, 'integer');
             $count_user_filter =  $ilDB->in('usr_data.usr_id', $this->users, false, 'integer');
         }
 
         $count_query.= " AND " . $count_user_filter . " ";
         $where = " AND";
 
         if ($this->first_letter != "") {
             $add = $where . " (" . $ilDB->upper($ilDB->substr("usr_data.lastname", 1, 1)) . " = " . $ilDB->upper($ilDB->quote($this->first_letter, "text")) . ") ";
             $query.= $add;
             $count_query.= $add;
             $where = " AND";
         }
         
         if ($this->text_filter != "") {         // email, name, login
             $add = $where . " (" . $ilDB->like("usr_data.login", "text", "%" . $this->text_filter . "%") . " " .
                 "OR " . $ilDB->like("usr_data.firstname", "text", "%" . $this->text_filter . "%") . " " .
                 "OR " . $ilDB->like("usr_data.lastname", "text", "%" . $this->text_filter . "%") . " " .
                 "OR " . $ilDB->like("usr_data.second_email", "text", "%" . $this->text_filter . "%") . " " .
                 "OR " . $ilDB->like("usr_data.email", "text", "%" . $this->text_filter . "%") . ") ";
             $query.= $add;
             $count_query.= $add;
             $where = " AND";
         }
         
         if ($this->activation != "") {          // activation
             if ($this->activation == "inactive") {
                 $add = $where . " usr_data.active = " . $ilDB->quote(0, "integer") . " ";
             } else {
                 $add = $where . " usr_data.active = " . $ilDB->quote(1, "integer") . " ";
             }
             $query.= $add;
             $count_query.= $add;
             $where = " AND";
         }
 
         if ($this->last_login instanceof ilDateTime) {  // last login
             if (ilDateTime::_before($this->last_login, new ilDateTime(time(), IL_CAL_UNIX), IL_CAL_DAY)) {
                 $add = $where . " usr_data.last_login < " .
                     $ilDB->quote($this->last_login->get(IL_CAL_DATETIME), "timestamp");
                 $query.= $add;
                 $count_query.= $add;
                 $where = " AND";
             }
         }
         if ($this->limited_access) {            // limited access
             $add = $where . " usr_data.time_limit_unlimited= " . $ilDB->quote(0, "integer");
             $query.= $add;
             $count_query.= $add;
             $where = " AND";
         }
 
         // udf filter
         foreach ($this->getUdfFilter() as $k => $f) {
             if ($f != "") {
                 $udf_id = explode("_", $k)[1];
                 if ($udf_def[$udf_id]["field_type"] == UDF_TYPE_TEXT) {
                     $add = $where . " " . $ilDB->like("ud_" . $udf_id . ".value", "text", "%" . $f . "%");
                 } else {
                     $add = $where . " ud_" . $udf_id . ".value = " . $ilDB->quote($f, "text");
                 }
                 $query.= $add;
                 $count_query.= $add;
                 $where = " AND";
             }
         }
 
         if ($this->has_access) { //user is limited but has access
             $unlimited = "time_limit_unlimited = " . $ilDB->quote(1, 'integer');
             $from = "time_limit_from < " . $ilDB->quote(time(), 'integer');
             $until = "time_limit_until > " . $ilDB->quote(time(), 'integer');
 
             $add = $where . ' (' . $unlimited . ' OR (' . $from . ' AND ' . $until . '))';
             $query.= $add;
             $count_query.= $add;
             $where = " AND";
         }
         if ($this->no_courses) {                // no courses assigned
             $add = $where . " usr_data.usr_id NOT IN (" .
                 "SELECT DISTINCT ud.usr_id " .
                 "FROM usr_data ud join rbac_ua ON (ud.usr_id = rbac_ua.usr_id) " .
                 "JOIN object_data od ON (rbac_ua.rol_id = od.obj_id) " .
                 "WHERE od.title LIKE 'il_crs_%')";
             $query.= $add;
             $count_query.= $add;
             $where = " AND";
         }
         if ($this->no_groups) {         // no groups assigned
             $add = $where . " usr_data.usr_id NOT IN (" .
                 "SELECT DISTINCT ud.usr_id " .
                 "FROM usr_data ud join rbac_ua ON (ud.usr_id = rbac_ua.usr_id) " .
                 "JOIN object_data od ON (rbac_ua.rol_id = od.obj_id) " .
                 "WHERE od.title LIKE 'il_grp_%')";
             $query.= $add;
             $count_query.= $add;
             $where = " AND";
         }
         if ($this->crs_grp > 0) {               // members of course/group
             $cgtype = ilObject::_lookupType($this->crs_grp, true);
             $add = $where . " usr_data.usr_id IN (" .
                 "SELECT DISTINCT ud.usr_id " .
                 "FROM usr_data ud join rbac_ua ON (ud.usr_id = rbac_ua.usr_id) " .
                 "JOIN object_data od ON (rbac_ua.rol_id = od.obj_id) " .
                 "WHERE od.title = " . $ilDB->quote("il_" . $cgtype . "_member_" . $this->crs_grp, "text") . ")";
             $query.= $add;
             $count_query.= $add;
             $where = " AND";
         }
         if ($this->role > 0) {          // global role
             $add = $where . " usr_data.usr_id IN (" .
                 "SELECT DISTINCT ud.usr_id " .
                 "FROM usr_data ud join rbac_ua ON (ud.usr_id = rbac_ua.usr_id) " .
                 "WHERE rbac_ua.rol_id = " . $ilDB->quote($this->role, "integer") . ")";
             $query.= $add;
             $count_query.= $add;
             $where = " AND";
         }
         
         if ($this->user_folder) {
             $add = $where . " " . $ilDB->in('usr_data.time_limit_owner', $this->user_folder, false, 'integer');
             $query.= $add;
             $count_query.= $add;
             $where = " AND";
         }
 
         if ($this->authentication_method != "") {               // authentication
             $add = $where . " usr_data.auth_mode = " . $ilDB->quote($this->authentication_method, "text") . " ";
             $query.= $add;
             $count_query.= $add;
             $where = " AND";
         }
 
         // order by
         switch ($this->order_field) {
             case  "access_until":
                 if ($this->order_dir == "desc") {
                     $query.= " ORDER BY usr_data.active DESC, usr_data.time_limit_unlimited DESC, usr_data.time_limit_until DESC";
                 } else {
                     $query.= " ORDER BY usr_data.active ASC, usr_data.time_limit_unlimited ASC, usr_data.time_limit_until ASC";
                 }
                 break;
                 
             case "online_time":
                 if ($this->order_dir == "desc") {
                     $query.= " ORDER BY ut_online.online_time DESC";
                 } else {
                     $query.= " ORDER BY ut_online.online_time ASC";
                 }
                 break;
                 
             default:
                 if ($this->order_dir != "asc" && $this->order_dir != "desc") {
                     $this->order_dir = "asc";
                 }
                 if (substr($this->order_field, 0, 4) == "udf_") {
                     // #25311 check if order field is in field list
                     if (is_array($this->getUdfFilter()) && array_key_exists($this->order_field, $this->getUdfFilter())) {
                         $query .= " ORDER BY ud_" . ((int) substr($this->order_field, 4)) . ".value " . strtoupper($this->order_dir);
                     } else {
                         $query .= ' ORDER BY ' . self::DEFAULT_ORDER_FIELD . ' ' . strtoupper($this->order_dir);
                     }
                 } else {
                     if (!in_array($this->order_field, $this->default_fields)) {
                         $this->order_field = "login";
                     }
                     $query .= " ORDER BY usr_data." . $this->order_field . " " . strtoupper($this->order_dir);
                 }
                 break;
         }
 
         // count query
         $set = $ilDB->query($count_query);
         $cnt = 0;
         if ($rec = $ilDB->fetchAssoc($set)) {
             $cnt = $rec["cnt"];
         }
         
         $offset = (int) $this->offset;
         $limit = (int) $this->limit;
         
         // #9866: validate offset against rowcount
         if ($offset >= $cnt) {
             $offset = 0;
         }
         
         $ilDB->setLimit($limit, $offset);
         
         if (sizeof($multi_fields)) {
             $usr_ids = array();
         }
         
         // set query
         $set = $ilDB->query($query);
         $result = array();
         while ($rec = $ilDB->fetchAssoc($set)) {
             $result[] = $rec;
             
             if (sizeof($multi_fields)) {
                 $usr_ids[] = $rec["usr_id"];
             }
         }
         
         // add multi-field-values to user-data
         if (sizeof($multi_fields) && sizeof($usr_ids)) {
             $usr_multi = array();
             $set = $ilDB->query("SELECT * FROM usr_data_multi" .
                 " WHERE " . $ilDB->in("usr_id", $usr_ids, "", "integer"));
             while ($row = $ilDB->fetchAssoc($set)) {
                 $usr_multi[$row["usr_id"]][$row["field_id"]][] = $row["value"];
             }
             foreach ($result as $idx => $item) {
                 if (isset($usr_multi[$item["usr_id"]])) {
                     $result[$idx] = array_merge($item, $usr_multi[$item["usr_id"]]);
                 }
             }
         }
         
         return array("cnt" => $cnt, "set" => $result);
     }

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.

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

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

     {
         $this->activation = $a_activation;
     }

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

References array.

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

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

     {
         $this->authentication_method = $a_authentication;
     }

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

     {
         $this->crs_grp = $a_cg_id;
     }

◆ setFirstLetterLastname()

ilUserQuery::setFirstLetterLastname ( $a_fll )

set first letter lastname filter

Parameters

string $a_fll

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

     {
         $this->first_letter = $a_fll;
     }

◆ setLastLogin()

ilUserQuery::setLastLogin ( ilDateTime $dt = null )

Set last login filter.

Parameters

ilDateTime $dt

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

     {
         $this->last_login = $dt;
     }

◆ setLimit()

ilUserQuery::setLimit ( $a_limit )

Set result limit Default is 50.

Parameters

int $a_limit

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

     {
         $this->limit = $a_limit;
     }

◆ setLimitedAccessFilter()

ilUserQuery::setLimitedAccessFilter ( $a_status )

Enable limited access filter.

Parameters

bool

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

     {
         $this->limited_access = $a_status;
     }

◆ setNoCourseFilter()

ilUserQuery::setNoCourseFilter ( $a_no_course )

Enable no course filter.

Parameters

bool $a_no_course

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

     {
         $this->no_courses = $a_no_course;
     }

◆ setNoGroupFilter()

ilUserQuery::setNoGroupFilter ( $a_no_group )

Enable no group filter.

Parameters

bool $a_no_group

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

     {
         $this->no_groups = $a_no_group;
     }

◆ setOffset()

ilUserQuery::setOffset ( $a_offset )

Set offset.

Parameters

int $a_offset

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

     {
         $this->offset = $a_offset;
     }

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

     {
         $this->order_dir = $a_dir;
     }

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

     {
         $this->order_field = $a_order;
     }

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

     {
         $this->role = $a_role_id;
     }

◆ setTextFilter()

ilUserQuery::setTextFilter ( $a_filter )

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

Parameters

string filter

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

     {
         $this->text_filter = $a_filter;
     }

◆ setUdfFilter()

ilUserQuery::setUdfFilter ( $a_val )

Set udf filter.

Parameters

array $a_val udf filter array

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

     {
         $this->udf_filter = $a_val;
     }

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

     {
         $this->users = $a_filter;
     }

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

     {
         $this->user_folder = $a_fold_id;
     }

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:

Services/User/classes/class.ilUserQuery.php

Public Member Functions

Static Public Member Functions

Data Fields

Protected Attributes

Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ getUdfFilter()

◆ getUserListData()

◆ query()

◆ setAccessFilter()

◆ setActionFilter()

◆ setAdditionalFields()

◆ setAuthenticationFilter()

◆ setCourseGroupFilter()

◆ setFirstLetterLastname()

◆ setLastLogin()

◆ setLimit()

◆ setLimitedAccessFilter()

◆ setNoCourseFilter()

◆ setNoGroupFilter()

◆ setOffset()

◆ setOrderDirection()

◆ setOrderField()

◆ setRoleFilter()

◆ setTextFilter()

◆ setUdfFilter()

◆ setUserFilter()

◆ setUserFolder()

Field Documentation

◆ $activation

◆ $additional_fields

◆ $authentication_method

◆ $crs_grp

◆ $default_fields

◆ $first_letter

◆ $has_access

◆ $last_login

◆ $limit

◆ $limited_access

◆ $logger

◆ $no_courses

◆ $no_groups

◆ $offset

◆ $order_dir

◆ $order_field

◆ $role

◆ $text_filter

◆ $udf_filter

◆ $user_folder

◆ $users

◆ DEFAULT_ORDER_FIELD