|
@@ 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 "; |