chamilo / chamilo-lms

     * @author isaac flores paz

     * @return array

     */

    public static function show_list_type_friends()

    {

        $friend_relation_list = array();

        $tbl_my_friend_relation_type = Database :: get_main_table(TABLE_MAIN_USER_FRIEND_RELATION_TYPE);

        $sql = 'SELECT id,title FROM '.$tbl_my_friend_relation_type.'

                WHERE id<>6 ORDER BY id ASC';

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

        while ($row = Database::fetch_array($result, 'ASSOC')) {

            $friend_relation_list[] = $row;

        }

        $count_list = count($friend_relation_list);

        if ($count_list == 0) {

            $friend_relation_list[] = get_lang('Unknown');

        } else {

            return $friend_relation_list;

        }

    }

    /**

     * Get relation type contact by name

     * @param string $userId

     * @return array containing all the titles of the user defined courses with the id as key of the array

     */

    public static function get_user_course_categories($userId = '')

    {

        if ($userId == '') {

            $realUserId = api_get_user_id();

        } else {

            $realUserId = $userId;

        }

        $output = array();

        $table_category = Database::get_main_table(TABLE_USER_COURSE_CATEGORY);

        $sql = "SELECT * FROM $table_category WHERE user_id = '".intval($realUserId)."'";

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

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

            $output[$row['id']] = $row['title'];

        }

        return $output;

    }

    /**

     * Return an array the user_category id and title for the course $courseId for user $userId

     * @param    int        Drh id

     * @return    array    Student list

     */

    public static function get_student_followed_by_drh($hr_dept_id)

    {

        $hr_dept_id = intval($hr_dept_id);

        $a_students = array();

        $tbl_user     = Database :: get_main_table(TABLE_MAIN_USER);

        $sql = 'SELECT DISTINCT user_id FROM '.$tbl_user.' as user

                WHERE hr_dept_id='.$hr_dept_id;

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

        while($user = Database :: fetch_array($rs)) {

            $a_students[$user['user_id']] = $user['user_id'];

        }

        return $a_students;

    }