Event::saveQuestionAttempt()

Complexity

Conditions	24
Paths	> 20000

Size

Total Lines	182
Code Lines	110

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public static function saveQuestionAttempt(
        $score,
        $answer,
        $question_id,
        $exe_id,
        $position,
        $exercise_id = 0,
        $updateResults = false,
        $questionDuration = 0,
        $fileName = null,
        $user_id = null,
        $course_id = null,
        $session_id = null,
        $learnpath_id = null,
        $learnpath_item_id = null
    ) {
        global $debug;
        $questionDuration = (int) $questionDuration;
        $question_id = (int) $question_id;
        $exe_id = (int) $exe_id;
        $position = (int) $position;
        $course_id = (int) $course_id;
        $now = api_get_utc_datetime();
        $recording = api_get_configuration_value('quiz_answer_extra_recording');

        // check user_id or get from context
        if (empty($user_id)) {
            $user_id = api_get_user_id();
            // anonymous
            if (empty($user_id)) {
                $user_id = api_get_anonymous_id();
            }
        }
        // check course_id or get from context
        if (empty($course_id)) {
            $course_id = api_get_course_int_id();
        }
        // check session_id or get from context
        $session_id = (int) $session_id;
        if (empty($session_id)) {
            $session_id = api_get_session_id();
        }
        // check learnpath_id or get from context
        if (empty($learnpath_id)) {
            global $learnpath_id;
        }
        // check learnpath_item_id or get from context
        if (empty($learnpath_item_id)) {
            global $learnpath_item_id;
        }

        $TBL_TRACK_ATTEMPT = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ATTEMPT);

        if ($debug) {
            error_log("----- entering saveQuestionAttempt() function ------");
            error_log("answer: $answer");
            error_log("score: $score");
            error_log("question_id : $question_id");
            error_log("position: $position");
        }

        //Validation in case of fraud with active control time
        if (!ExerciseLib::exercise_time_control_is_valid($exercise_id, $learnpath_id, $learnpath_item_id)) {
            if ($debug) {
                error_log("exercise_time_control_is_valid is false");
            }
            $score = 0;
            $answer = 0;
        }

        if (empty($question_id) || empty($exe_id) || empty($user_id)) {
            return false;
        }

        if (is_null($answer)) {
            $answer = '';
        }

        if (is_null($score)) {
            $score = 0;
        }

        $attempt = [
            'user_id' => $user_id,
            'question_id' => $question_id,
            'answer' => $answer,
            'marks' => $score,
            'c_id' => $course_id,
            'session_id' => $session_id,
            'position' => $position,
            'tms' => $now,
            'filename' => !empty($fileName) ? basename($fileName) : $fileName,
            'teacher_comment' => '',
        ];

        if (api_get_configuration_value('allow_time_per_question')) {
            $attempt['seconds_spent'] = $questionDuration;
        }

        // Check if attempt exists.
        $sql = "SELECT exe_id FROM $TBL_TRACK_ATTEMPT
                WHERE
                    c_id = $course_id AND
                    session_id = $session_id AND
                    exe_id = $exe_id AND
                    user_id = $user_id AND
                    question_id = $question_id AND
                    position = $position";
        $result = Database::query($sql);
        $attemptData = [];
        if (Database::num_rows($result)) {
            $attemptData = Database::fetch_array($result, 'ASSOC');
            if ($updateResults == false) {
                // The attempt already exist do not update use  update_event_exercise() instead
                return false;
            }
        } else {
            $attempt['exe_id'] = $exe_id;
        }

        if ($debug) {
            error_log("updateResults : $updateResults");
            error_log("Saving question attempt: ");
            error_log($sql);
        }

        $recording_table = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ATTEMPT_RECORDING);
        if ($updateResults == false) {
            $attempt_id = Database::insert($TBL_TRACK_ATTEMPT, $attempt);
            if ($recording) {
                $attempt_recording = [
                    'exe_id' => $exe_id,
                    'question_id' => $question_id,
                    'answer' => $answer,
                    'marks' => $score,
                    'insert_date' => $now,
                    'session_id' => $session_id,
                ];
                Database::insert($recording_table, $attempt_recording);
            }
        } else {
            if (api_get_configuration_value('allow_time_per_question')) {
                $attempt['seconds_spent'] = $questionDuration + (int) $attemptData['seconds_spent'];
            }
            Database::update(
                $TBL_TRACK_ATTEMPT,
                $attempt,
                [
                    'exe_id = ? AND question_id = ? AND user_id = ? ' => [
                        $exe_id,
                        $question_id,
                        $user_id,
                    ],
                ]
            );

            if ($recording) {
                $attempt_recording = [
                    'exe_id' => $exe_id,
                    'question_id' => $question_id,
                    'answer' => $answer,
                    'marks' => $score,
                    'insert_date' => $now,
                    'session_id' => $session_id,
                ];

                Database::update(
                    $recording_table,
                    $attempt_recording,
                    [
                        'exe_id = ? AND question_id = ? AND session_id = ? ' => [
                            $exe_id,
                            $question_id,
                            $session_id,
                        ],
                    ]
                );
            }
            $attempt_id = $exe_id;
        }

        return $attempt_id;
    }