@@ 59-64 (lines=6) @@ | ||
56 | AND relation_type IN (".GROUP_USER_PERMISSION_ADMIN.",".GROUP_USER_PERMISSION_READER.",".GROUP_USER_PERMISSION_PENDING_INVITATION.",".GROUP_USER_PERMISSION_MODERATOR.", ".GROUP_USER_PERMISSION_HRM.") "; |
|
57 | $res = Database::query($sql); |
|
58 | $user_ids = array(); |
|
59 | if (Database::num_rows($res) > 0) { |
|
60 | while ($row = Database::fetch_row($res)) { |
|
61 | $user_ids[] = $row[0]; |
|
62 | } |
|
63 | $without_user_id = " AND user.user_id NOT IN(".implode(',', $user_ids).") "; |
|
64 | } |
|
65 | ||
66 | $condition_relation = " AND groups.relation_type = '$relation_type' "; |
|
67 | ||
@@ 304-309 (lines=6) @@ | ||
301 | AND relation_type IN (".GROUP_USER_PERMISSION_ADMIN.", ".GROUP_USER_PERMISSION_READER.",".GROUP_USER_PERMISSION_PENDING_INVITATION.",".GROUP_USER_PERMISSION_MODERATOR.", ".GROUP_USER_PERMISSION_HRM.") "; |
|
302 | $res = Database::query($sql); |
|
303 | $user_ids = array(); |
|
304 | if (Database::num_rows($res) > 0) { |
|
305 | while ($row = Database::fetch_row($res)) { |
|
306 | $user_ids[] = $row[0]; |
|
307 | } |
|
308 | $without_user_id = " AND user.user_id NOT IN(".implode(',', $user_ids).") "; |
|
309 | } |
|
310 | ||
311 | $sql = "SELECT user_id, username, lastname, firstname FROM $tbl_user user |
|
312 | WHERE ".(api_sort_by_first_name() ? 'firstname' : 'lastname')." LIKE '$needle%' AND user_id<>'$user_anonymous' $without_user_id $order_clause "; |