chamilo / chamilo-lms

     * @param int $user_id

     * @return array

     */

    public static function getAllGroupPerUserSubscription($user_id)

    {

        $table_group_user = Database::get_course_table(TABLE_GROUP_USER);

        $table_tutor_user = Database::get_course_table(TABLE_GROUP_TUTOR);

        $table_group = Database::get_course_table(TABLE_GROUP);

        $user_id = intval($user_id);

        $course_id = api_get_course_int_id();

        $sql = "SELECT DISTINCT g.*

               FROM $table_group g

               LEFT JOIN $table_group_user gu

               ON (gu.group_id = g.id AND g.c_id = gu.c_id)

               LEFT JOIN $table_tutor_user tu

               ON (tu.group_id = g.id AND g.c_id = tu.c_id)

               WHERE

                  g.c_id = $course_id AND

                  (gu.user_id = $user_id OR tu.user_id = $user_id) ";

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

        $groups = array();

        while ($group = Database::fetch_array($res, 'ASSOC')) {

            $groups[] = $group;

        }

        return $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>

	 * return total score for test exe_id for all question in the category $in_cat_id for user

	 * If no question for this category, return ""

	 */

	public static function getCatScoreForExeidForUserid($in_cat_id, $in_exe_id, $in_user_id)

	{

		$tbl_track_attempt		= Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_ATTEMPT);

		$tbl_question_rel_category = Database::get_course_table(TABLE_QUIZ_QUESTION_REL_CATEGORY);

		$in_cat_id = intval($in_cat_id);

		$in_exe_id = intval($in_exe_id);

		$in_user_id = intval($in_user_id);

		$query = "SELECT DISTINCT

		            marks, exe_id, user_id, ta.question_id, category_id

                  FROM $tbl_track_attempt ta , $tbl_question_rel_category qrc

                  WHERE

                    ta.question_id=qrc.question_id AND

                    qrc.category_id=$in_cat_id AND

                    exe_id=$in_exe_id AND user_id=$in_user_id";

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

		$totalcatscore = "";

		while ($data = Database::fetch_array($res)) {

			$totalcatscore += $data['marks'];

		}

		return $totalcatscore;

	}

	/**

     * return the number max of question in a category