chamilo / chamilo-lms

     * @param int $user_id

     * @return int The number of groups the user is subscribed in.

     */

    public static function user_in_number_of_groups($user_id, $cat_id = null)

    {

        $table_group_user = Database::get_course_table(TABLE_GROUP_USER);

        $table_group = Database::get_course_table(TABLE_GROUP);

        $user_id = intval($user_id);

        $cat_id = intval($cat_id);

        $course_id = api_get_course_int_id();

        $cat_condition = '';

        if (!empty($cat_id)) {

            $cat_condition = " AND g.category_id =  $cat_id ";

        }

        $sql = "SELECT  COUNT(*) AS number_of_groups

                FROM $table_group_user gu, $table_group g

                WHERE

                    gu.c_id = $course_id AND

                    g.c_id = $course_id AND

                    gu.user_id = $user_id AND

                    g.iid = gu.group_id  

                    $cat_condition";

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

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

        return $db_object->number_of_groups;

    }

    /**

     * @param int $session_id

     * @return int

     */

    public static function get_number_students_finish_exercise(

        $exercise_id,

        $course_code,

        $session_id

    ) {

        $track_exercises = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);

        $track_attempt = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ATTEMPT);

        $exercise_id = intval($exercise_id);

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

        $session_id = intval($session_id);

        $sql = "SELECT DISTINCT exe_user_id

                FROM $track_exercises e

                INNER JOIN $track_attempt a 

                ON (a.exe_id = e.exe_id)

                WHERE

                    exe_exo_id 	 = $exercise_id AND

                    course_code  = '$course_code' AND

                    e.session_id = $session_id AND

                    status = ''";

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

        $return = 0;

        if ($result) {

            $return = Database::num_rows($result);

        }

        return $return;

    }

    /**

     * @param string $in_name is the name and the id of the <select>

     * @param string $in_default default value for option

     * @param string $in_onchange

     * @return string the html code of the <select>

     */