chamilo / chamilo-lms

     * @param $needle

     * @return xajaxResponse

     */

    public static function searchUserGroupAjax($needle)

    {

        $response = new xajaxResponse();

        $return = '';

        if (!empty($needle)) {

            // xajax send utf8 datas... datas in db can be non-utf8 datas

            $charset = api_get_system_encoding();

            $needle = api_convert_encoding($needle, $charset, 'utf-8');

            $needle = Database::escape_string($needle);

            // search courses where username or firstname or lastname begins likes $needle

            $sql = 'SELECT id, name FROM '.Database::get_main_table(TABLE_USERGROUP).' u

                    WHERE name LIKE "'.$needle.'%"

                    ORDER BY name

                    LIMIT 11';

            $result = Database::query($sql);

            $i = 0;

            while ($data = Database::fetch_array($result)) {

                $i++;

                if ($i <= 10) {

                    $return .= '<a

                    href="javascript: void(0);"

                    onclick="javascript: add_user_to_url(\''.addslashes($data['id']).'\',\''.addslashes($data['name']).' \')">'.$data['name'].' </a><br />';

                } else {

                    $return .= '...<br />';

                }

            }

        }

        $response->addAssign('ajax_list_courses','innerHTML', api_utf8_encode($return));

        return $response;

    }

    /**

     * Get user list by usergroup

     * @param string $needle

     * @return XajaxResponse

     */

    public static function searchCourseCategoryAjax($needle)

    {

        $response = new xajaxResponse();

        $return = '';

        if (!empty($needle)) {

            // xajax send utf8 datas... datas in db can be non-utf8 datas

            $charset = api_get_system_encoding();

            $needle = api_convert_encoding($needle, $charset, 'utf-8');

            $needle = Database::escape_string($needle);

            // search courses where username or firstname or lastname begins likes $needle

            $sql = 'SELECT id, name FROM '.Database::get_main_table(TABLE_MAIN_CATEGORY).' u

                    WHERE name LIKE "'.$needle.'%" AND (parent_id IS NULL or parent_id = 0)

                    ORDER BY name

                    LIMIT 11';

            $result = Database::query($sql);

            $i = 0;

            while ($data = Database::fetch_array($result)) {

                $i++;

                if ($i <= 10) {

                    $return .= '<a

                    href="javascript: void(0);"

                    onclick="javascript: add_user_to_url(\''.addslashes($data['id']).'\',\''.addslashes($data['name']).' \')">'.$data['name'].' </a><br />';

                } else {

                    $return .= '...<br />';

                }

            }

        }

        $response->addAssign('ajax_list_courses', 'innerHTML', api_utf8_encode($return));

        return $response;

    }

}