chamilo / chamilo-lms

     * @author isaac flores paz

     * @return array

     */

    public static function show_list_type_friends()

    {

        $friend_relation_list = array();

        $table = Database::get_main_table(TABLE_MAIN_USER_FRIEND_RELATION_TYPE);

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

                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;

        }

    }

    /**

     * @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;

    }