chamilo / chamilo-lms

     * @param int $group_id iid

     * @return int Maximum number of students in the given group.

     */

    public static function maximum_number_of_students($group_id)

    {

        $table_group = Database :: get_course_table(TABLE_GROUP);

        $group_id = intval($group_id);

        $course_id = api_get_course_int_id();

        $sql = "SELECT max_student FROM $table_group WHERE c_id = $course_id AND iid = $group_id";

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

        $db_object = Database::fetch_object($db_result);

        if ($db_object->max_student == 0) {

            return self::INFINITE;

        }

        return $db_object->max_student;

    }

    /**

     * Number of groups of a user

     * Get the total number of thematic inside current course and current session

     * @see SortableTable#get_total_number_of_items()

     */

    public function get_number_of_thematics()

    {

        $tbl_thematic = Database :: get_course_table(TABLE_THEMATIC);

        $condition_session = '';

        if (!api_get_session_id()) {

            $condition_session = api_get_session_condition(0);

        }

        $course_id = api_get_course_int_id();

        $sql = "SELECT COUNT(id) AS total_number_of_items

		        FROM $tbl_thematic

                WHERE c_id = $course_id AND active = 1 $condition_session ";

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

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

        return $obj->total_number_of_items;

    }

    /**

     * Get the thematics to display on the current page (fill the sortable-table)