access_url_edit_users_to_url_functions.lib.php 2.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * AccessUrlEditUsersToUrl class definition
  5. * Contains several functions dealing with displaying,
  6. * editing,... of a Access_url_edit_users_to_url_functions
  7. *
  8. * @version 1.0
  9. * @author Toon Keppens <toon@vi-host.net>
  10. * @author Julio Montoya - Cleaning code
  11. * @author Ricardo Rodriguez - Separated the function and code
  12. * @package chamilo.library
  13. */
  14. class AccessUrlEditUsersToUrl
  15. {
  16. /**
  17. * Search users by username, firstname or lastname, based on the given
  18. * search string
  19. * @param string Search string
  20. * @param int Deprecated param
  21. * @return xajaxResponse Xajax response block
  22. * @assert () === false
  23. */
  24. public static function search_users($needle, $id)
  25. {
  26. $tbl_user = Database::get_main_table(TABLE_MAIN_USER);
  27. $xajax_response = new xajaxResponse();
  28. $return = '';
  29. if (!empty($needle)) {
  30. // xajax send utf8 datas... datas in db can be non-utf8 datas
  31. $charset = api_get_system_encoding();
  32. $needle = api_convert_encoding($needle, $charset, 'utf-8');
  33. $needle = Database::escape_string($needle);
  34. // search users where username or firstname or lastname begins likes $needle
  35. $order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname, username' : ' ORDER BY lastname, firstname, username';
  36. $sql = 'SELECT u.user_id, username, lastname, firstname FROM '.$tbl_user.' u '.
  37. ' WHERE (username LIKE "'.$needle.'%" '.
  38. ' OR firstname LIKE "'.$needle.'%" '.
  39. ' OR lastname LIKE "'.$needle.'%") '.
  40. $order_clause.
  41. ' LIMIT 11';
  42. $rs = Database::query($sql);
  43. $i = 0;
  44. while ($user = Database::fetch_array($rs)) {
  45. $i++;
  46. if ($i <= 10) {
  47. $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 />';
  48. } else {
  49. $return .= '...<br />';
  50. }
  51. }
  52. }
  53. $xajax_response->addAssign(
  54. 'ajax_list_users',
  55. 'innerHTML',
  56. api_utf8_encode($return)
  57. );
  58. return $xajax_response;
  59. }
  60. }