chamilo / chamilo-lms

     * @return  array   with the results

     *

     */

    public static function get_all_exercise_results_by_user($user_id, $courseId, $session_id = 0)

    {

        $table_track_exercises = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);

        $table_track_attempt = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ATTEMPT);

        $courseId = intval($courseId);

        $session_id = intval($session_id);

        $user_id = intval($user_id);

        $sql = "SELECT * FROM $table_track_exercises

                WHERE

                    status = '' AND

                    exe_user_id = $user_id AND

                    c_id = '$courseId' AND

                    session_id = $session_id AND

                    orig_lp_id = 0 AND

                    orig_lp_item_id = 0

                ORDER by exe_id";

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

        $list = array();

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

            $list[$row['exe_id']] = $row;

            $sql = "SELECT * FROM $table_track_attempt WHERE exe_id = {$row['exe_id']}";

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

            while ($row_q = Database::fetch_array($res_question, 'ASSOC')) {

                $list[$row['exe_id']]['question_list'][$row_q['question_id']] = $row_q;

            }

        }

        return $list;

    }

    /**

     * Gets exercise results (NO Exercises in LPs) from a given exercise id, course, session

     * @param 	int		session id

     * @return 	array

     */

    public static function get_all_exercise_event_from_lp($exercise_id, $courseId, $session_id = 0)

    {

        $table_track_exercises = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);

        $table_track_attempt = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ATTEMPT);

        $courseId = intval($courseId);

        $exercise_id = intval($exercise_id);

        $session_id = intval($session_id);

        $sql = "SELECT * FROM $table_track_exercises

                WHERE

                    status = '' AND

                    c_id = $courseId AND

                    exe_exo_id = '$exercise_id' AND

                    session_id = $session_id AND

                    orig_lp_id !=0 AND

                    orig_lp_item_id != 0";

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

        $list = array();

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

            $list[$row['exe_id']] = $row;

            $sql = "SELECT * FROM $table_track_attempt WHERE exe_id = {$row['exe_id']}";

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

            while ($row_q = Database::fetch_array($res_question, 'ASSOC')) {

                $list[$row['exe_id']]['question_list'][$row_q['question_id']] = $row_q;

            }

        }

        return $list;

    }

    /**

     * @param int $lp_id