search_coachs()

Complexity

Conditions	4
Paths	3

Size

Total Lines	35
Code Lines	20

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function search_coachs($needle)
{
    $tbl_user = Database::get_main_table(TABLE_MAIN_USER);
    $xajax_response = new xajaxResponse();
    $return = '';

    if (!empty($needle)) {
        $order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname, username' : ' ORDER BY lastname, firstname, username';

        // search users where username or firstname or lastname begins likes $needle
        $tbl_user_rel_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
        $access_url_id = api_get_current_access_url_id();
        $sql = 'SELECT username, lastname, firstname
            FROM '.$tbl_user.' user
            INNER JOIN '.$tbl_user_rel_access_url.' url_user
            ON (url_user.user_id=user.user_id)
            WHERE
                access_url_id = '.$access_url_id.'  AND
                (
                    username LIKE "'.$needle.'%" OR
                    firstname LIKE "'.$needle.'%" OR
                    lastname LIKE "'.$needle.'%"
                )
                AND status=1'.
            $order_clause.'
            LIMIT 10';

        $rs = Database::query($sql);
        while ($user = Database :: fetch_array($rs)) {
            $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 />';
        }
    }
    $xajax_response->addAssign('ajax_list_coachs', 'innerHTML', api_utf8_encode($return));

    return $xajax_response;
}