chamilo / chamilo-lms

    /**

     * @return array

     */

    public static function get_groups()

    {

        $table_group = Database :: get_course_table(TABLE_GROUP);

        $course_id = api_get_course_int_id();

        $sql = "SELECT * FROM $table_group WHERE c_id = $course_id ";

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

        return Database::store_result($result, 'ASSOC');

    }

    /**

     * Get list of groups for current course.

     * Get the total number of groups for the current course.

     * @return int The number of groups for the current course.

     */

    public static function get_number_of_groups()

    {

        $course_id = api_get_course_int_id();

        $table_group = Database :: get_course_table(TABLE_GROUP);

        $sql = "SELECT COUNT(id) AS number_of_groups

                FROM $table_group

                WHERE c_id = $course_id ";

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

        $obj = Database::fetch_object($res);

        return $obj->number_of_groups;

    }

    /**

     * Get all categories