ILIAS\MyStaff\ListUsers\ilMStListUsers Class Reference

Class ilListUser. More...

Collaboration diagram for ILIAS\MyStaff\ListUsers\ilMStListUsers:

Public Member Functions
	__construct (Container $dic)
	ilMStListUsers constructor. More...
	getData (array $arr_usr_ids=array(), array $options=array())

Private Member Functions
	createWhereStatement (array $arr_usr_ids, array $arr_filter)
	Returns the WHERE Part for the Queries using parameter $user_ids AND local variable $filters. More...

Private Attributes
Container	$dic

Detailed Description

Class ilListUser.

Author

Martin Studer ms@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

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

Constructor & Destructor Documentation

__construct()

ILIAS\MyStaff\ListUsers\ilMStListUsers::__construct

(

Container

$dic

)

ilMStListUsers constructor.

Parameters

Container

$dic

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

    {
        $this->dic = $dic;
    }

References ILIAS\MyStaff\ListUsers\ilMStListUsers\$dic.

Member Function Documentation

createWhereStatement()

ILIAS\MyStaff\ListUsers\ilMStListUsers::createWhereStatement ( array  $arr_usr_ids, array  $arr_filter  )

private

Returns the WHERE Part for the Queries using parameter $user_ids AND local variable $filters.

Definition at line 123 of file class.ilMStListUsers.php.

                                                                                : string
    {
        $where = array();
 
        $where[] = $this->dic->database()->in('usr_data.usr_id', $arr_usr_ids, false, 'integer');
 
        if (!empty($arr_filter['user'])) {
            $where[] = "(" . $this->dic->database()
           ->like(
               "usr_data.login",
               "text",
               "%" . $arr_filter['user'] . "%"
           ) . " " . "OR " . $this->dic->database()
           ->like(
               "usr_data.firstname",
               "text",
               "%" . $arr_filter['user'] . "%"
           ) . " " . "OR " . $this->dic->database()
          ->like(
              "usr_data.lastname",
              "text",
              "%" . $arr_filter['user'] . "%"
          ) . " " . "OR " . $this->dic->database()
        ->like(
            "usr_data.email",
            "text",
            "%" . $arr_filter['user'] . "%"
        ) . " " . "OR " . $this->dic->database()
         ->like(
             "usr_data.second_email",
             "text",
             "%" . $arr_filter['user'] . "%"
         ) . ") ";
        }
 
        if (!empty($arr_filter['org_unit'])) {
            $where[] = 'usr_data.usr_id IN (SELECT user_id FROM il_orgu_ua WHERE orgu_id = ' . $this->dic->database()
                                                                                                         ->quote(
                                                                                                             $arr_filter['org_unit'],
                                                                                                             'integer'
                                                                                                         ) . ')';
        }
 
        if (!empty($arr_filter['lastname'])) {
            $where[] = '(lastname LIKE ' . $this->dic->database()->quote('%' . str_replace(
                '*',
                '%',
                $arr_filter['lastname']
            ) . '%', 'text') . ')';
        }
 
        if (!empty($arr_filter['firstname'])) {
            $where[] = '(firstname LIKE ' . $this->dic->database()->quote('%' . str_replace(
                '*',
                '%',
                $arr_filter['firstname']
            ) . '%', 'text') . ')';
        }
 
        if (!empty($arr_filter['email'])) {
            $where[] = '(email LIKE ' . $this->dic->database()->quote('%' . str_replace(
                '*',
                '%',
                $arr_filter['email']
            ) . '%', 'text') . ')';
        }
 
        if (!empty($arr_filter['second_email'])) {
            $where[] = '(second_email LIKE ' . $this->dic->database()->quote('%' . str_replace(
                '*',
                '%',
                $arr_filter['second_email']
            ) . '%', 'text') . ')';
        }
 
        if (!empty($arr_filter['title'])) {
            $where[] = '(title LIKE ' . $this->dic->database()->quote('%' . str_replace(
                '*',
                '%',
                $arr_filter['title']
            ) . '%', 'text') . ')';
        }
 
        if ($arr_filter['activation'] ?? false) {
            if ($arr_filter['activation'] == 'active') {
                $where[] = '(active = "1")';
            }
            if ($arr_filter['activation'] == 'inactive') {
                $where[] = '(active = "0")';
            }
        }
 
        if (!empty($where)) {
            return ' WHERE ' . implode(' AND ', $where) . ' ';
        } else {
            return '';
        }
    }

Referenced by ILIAS\MyStaff\ListUsers\ilMStListUsers\getData().

Here is the caller graph for this function:

getData()

ILIAS\MyStaff\ListUsers\ilMStListUsers::getData ( array  $arr_usr_ids = array(), array  $options = array()  )

final

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

                                                                                         : ListFetcherResult
    {
        //Permissions
        if (count($arr_usr_ids) == 0) {
            return new ListFetcherResult([], 0);
        }
 
        $_options = array(
            'filters' => array(),
            'sort' => array(),
            'limit' => array(),
            'count' => false,
        );
        $options = array_merge($_options, $options);
 
        $select = 'SELECT
                                   usr_id,
                                   login,
                                   gender,
                       firstname,
                       lastname,
                       title,
                       institution,
                       department,
                       street,
                       zipcode,
                       city,
                       country,
                       hobby,
                       email,
                       second_email,
                       matriculation,
                       active
                       FROM ' . $this->dic->database()->quoteIdentifier('usr_data') .
 
            self::createWhereStatement($arr_usr_ids, $options['filters']);
 
        $result = $this->dic->database()->query($select);
        $numRows = $this->dic->database()->numRows($result);
 
        if ($options['sort']) {
            $select .= " ORDER BY " . $options['sort']['field'] . " " . $options['sort']['direction'];
        }
 
        if (isset($options['limit']['start']) && isset($options['limit']['end'])) {
            $select .= " LIMIT " . $options['limit']['start'] . "," . $options['limit']['end'];
        }
 
        $result = $this->dic->database()->query($select);
        $user_data = array();
 
        while ($user = $this->dic->database()->fetchAssoc($result)) {
            $list_user = new ilMStListUser();
            $list_user->setUsrId(intval($user['usr_id']));
            $list_user->setGender($user['gender'] ?? "");
            $list_user->setTitle($user['title'] ?? "");
            $list_user->setInstitution($user['institution'] ?? "");
            $list_user->setDepartment($user['department'] ?? "");
            $list_user->setStreet($user['street'] ?? "");
            $list_user->setZipcode($user['zipcode'] ?? "");
            $list_user->setCity($user['city'] ?? "");
            $list_user->setCountry($user['country'] ?? "");
            $list_user->setHobby($user['hobby'] ?? "");
            $list_user->setMatriculation($user['matriculation'] ?? "");
            $list_user->setActive(intval($user['active']));
            $list_user->setLogin($user['login']);
            $list_user->setFirstname($user['firstname']);
            $list_user->setLastname($user['lastname']);
            $list_user->setEmail($user['email'] ?? "");
            $list_user->setSecondEmail($user['second_email'] ?? "");
 
            $user_data[] = $list_user;
        }
 
        return new ListFetcherResult($user_data, $numRows);
    }

References ILIAS\UI\Implementation\Component\Input\Field\$options, and ILIAS\MyStaff\ListUsers\ilMStListUsers\createWhereStatement().

Here is the call graph for this function:

Field Documentation

$dic

Container ILIAS\MyStaff\ListUsers\ilMStListUsers::$dic

private

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

Referenced by ILIAS\MyStaff\ListUsers\ilMStListUsers\__construct().

---

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

• components/ILIAS/MyStaff/classes/ListUsers/class.ilMStListUsers.php