@@ -31,27 +31,27 @@ discard block |
||
| 31 | 31 | function search_coachs($needle) |
| 32 | 32 | { |
| 33 | 33 | $tbl_user = Database::get_main_table(TABLE_MAIN_USER); |
| 34 | - $xajax_response = new xajaxResponse(); |
|
| 35 | - $return = ''; |
|
| 34 | + $xajax_response = new xajaxResponse(); |
|
| 35 | + $return = ''; |
|
| 36 | 36 | |
| 37 | - if (!empty($needle)) { |
|
| 38 | - $order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname, username' : ' ORDER BY lastname, firstname, username'; |
|
| 37 | + if (!empty($needle)) { |
|
| 38 | + $order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname, username' : ' ORDER BY lastname, firstname, username'; |
|
| 39 | 39 | |
| 40 | - // search users where username or firstname or lastname begins likes $needle |
|
| 41 | - $sql = 'SELECT username, lastname, firstname |
|
| 40 | + // search users where username or firstname or lastname begins likes $needle |
|
| 41 | + $sql = 'SELECT username, lastname, firstname |
|
| 42 | 42 | FROM '.$tbl_user.' user |
| 43 | 43 | WHERE (username LIKE "'.$needle.'%" |
| 44 | 44 | OR firstname LIKE "'.$needle.'%" |
| 45 | 45 | OR lastname LIKE "'.$needle.'%") |
| 46 | 46 | AND status=1'. |
| 47 | - $order_clause. |
|
| 48 | - ' LIMIT 10'; |
|
| 49 | - |
|
| 50 | - if (api_is_multiple_url_enabled()) { |
|
| 51 | - $tbl_user_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER); |
|
| 52 | - $access_url_id = api_get_current_access_url_id(); |
|
| 53 | - if ($access_url_id != -1) { |
|
| 54 | - $sql = 'SELECT username, lastname, firstname |
|
| 47 | + $order_clause. |
|
| 48 | + ' LIMIT 10'; |
|
| 49 | + |
|
| 50 | + if (api_is_multiple_url_enabled()) { |
|
| 51 | + $tbl_user_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER); |
|
| 52 | + $access_url_id = api_get_current_access_url_id(); |
|
| 53 | + if ($access_url_id != -1) { |
|
| 54 | + $sql = 'SELECT username, lastname, firstname |
|
| 55 | 55 | FROM '.$tbl_user.' user |
| 56 | 56 | INNER JOIN '.$tbl_user_rel_access_url.' url_user |
| 57 | 57 | ON (url_user.user_id=user.user_id) |
@@ -65,16 +65,16 @@ discard block |
||
| 65 | 65 | AND status=1'. |
| 66 | 66 | $order_clause.' |
| 67 | 67 | LIMIT 10'; |
| 68 | - } |
|
| 69 | - } |
|
| 70 | - |
|
| 71 | - $rs = Database::query($sql); |
|
| 72 | - while ($user = Database :: fetch_array($rs)) { |
|
| 73 | - $return .= '<a href="javascript: void(0);" onclick="javascript: fill_coach_field(\''.$user['username'].'\')">'.api_get_person_name($user['firstname'], $user['lastname']).' ('.$user['username'].')</a><br />'; |
|
| 74 | - } |
|
| 75 | - } |
|
| 76 | - $xajax_response -> addAssign('ajax_list_coachs','innerHTML', api_utf8_encode($return)); |
|
| 77 | - return $xajax_response; |
|
| 68 | + } |
|
| 69 | + } |
|
| 70 | + |
|
| 71 | + $rs = Database::query($sql); |
|
| 72 | + while ($user = Database :: fetch_array($rs)) { |
|
| 73 | + $return .= '<a href="javascript: void(0);" onclick="javascript: fill_coach_field(\''.$user['username'].'\')">'.api_get_person_name($user['firstname'], $user['lastname']).' ('.$user['username'].')</a><br />'; |
|
| 74 | + } |
|
| 75 | + } |
|
| 76 | + $xajax_response -> addAssign('ajax_list_coachs','innerHTML', api_utf8_encode($return)); |
|
| 77 | + return $xajax_response; |
|
| 78 | 78 | } |
| 79 | 79 | $xajax -> processRequests(); |
| 80 | 80 | |
@@ -117,7 +117,7 @@ discard block |
||
| 117 | 117 | </script>"; |
| 118 | 118 | |
| 119 | 119 | if (isset($_POST['formSent']) && $_POST['formSent']) { |
| 120 | - $formSent = 1; |
|
| 120 | + $formSent = 1; |
|
| 121 | 121 | } |
| 122 | 122 | |
| 123 | 123 | $tool_name = get_lang('AddSession'); |
@@ -209,7 +209,7 @@ discard block |
||
| 209 | 209 | Display::display_header($tool_name); |
| 210 | 210 | |
| 211 | 211 | if (!empty($return)) { |
| 212 | - Display::display_error_message($return, false); |
|
| 212 | + Display::display_error_message($return, false); |
|
| 213 | 213 | } |
| 214 | 214 | |
| 215 | 215 | echo '<div class="actions">'; |