12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061 |
- <?php
- require_once ('xajax/xajax.inc.php');
- class Accessurledituserstourl{
- function search_users($needle, $id)
- {
- global $tbl_user, $tbl_access_url_rel_user;
- $xajax_response = new XajaxResponse();
- $return = '';
- if(!empty($needle)) {
-
- $charset = api_get_system_encoding();
- $needle = api_convert_encoding($needle, $charset, 'utf-8');
- $needle = Database::escape_string($needle);
-
- $order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname, username' : ' ORDER BY lastname, firstname, username';
- $sql = 'SELECT u.user_id, username, lastname, firstname FROM '.$tbl_user.' u
- WHERE (username LIKE "'.$needle.'%"
- OR firstname LIKE "'.$needle.'%"
- OR lastname LIKE "'.$needle.'%")'.
- $order_clause.
- ' LIMIT 11';
- $rs = Database::query($sql);
- $i=0;
- while ($user = Database :: fetch_array($rs)) {
- $i++;
- if ($i<=10) {
- $return .= '<a href="javascript: void(0);" onclick="javascript: add_user_to_url(\''.addslashes($user['user_id']).'\',\''.api_get_person_name(addslashes($user['firstname']), addslashes($user['lastname'])).' ('.addslashes($user['username']).')'.'\')">'.api_get_person_name($user['firstname'], $user['lastname']).' ('.$user['username'].')</a><br />';
- } else {
- $return .= '...<br />';
- }
- }
- }
- $xajax_response -> addAssign('ajax_list_users','innerHTML',api_utf8_encode($return));
- return $xajax_response;
- }
- }
- ?>
|