Event::saveQuestionAttempt()

Complexity

Conditions	23
Paths	> 20000

Size

Total Lines	179
Code Lines	109

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public static function saveQuestionAttempt(
        Exercise $exercise,
        float $score,
        string $answer,
        int $question_id,
        int $exe_id,
        int $position,
        ?int $exercise_id = 0,
        ?bool $updateResults = false,
        ?int $questionDuration = 0,
        ?string $fileName = null,
        ?int $user_id = null,
        ?int $course_id = null,
        ?int $session_id = null,
        ?int $learnpath_id = null,
        ?int $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();
        $recordingLog = ('true' === api_get_setting('exercise.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, $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 (null === $answer) {
            $answer = '';
        }
        if (null === $score) {
            $score = 0;
        }

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

        // Check if attempt exists.
        $sql = "SELECT exe_id FROM $TBL_TRACK_ATTEMPT
                WHERE
                    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_assoc($result);
            if (!$updateResults) {
                //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);
        }

        $em = Database::getManager();
        if (!$updateResults) {
            $attempt_id = Database::insert($TBL_TRACK_ATTEMPT, $attempt);
            $trackExercise = $em->find(TrackEExercise::class, $exe_id);

            if ($recordingLog) {
                $recording = new TrackEAttemptQualify();
                $recording
                    ->setTrackExercise($trackExercise)
                    ->setQuestionId($question_id)
                    ->setAnswer($answer)
                    ->setMarks((int) $score)
                    ->setAuthor(api_get_user_id())
                    ->setSessionId($session_id)
                ;
                $em->persist($recording);
                $em->flush();
            }
        } else {
            if ('true' === api_get_setting('exercise.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 ($recordingLog) {
                $repoTrackQualify = $em->getRepository(TrackEAttemptQualify::class);
                $trackQualify = $repoTrackQualify->findBy(
                    [
                        'exeId' => $exe_id,
                        'questionId' => $question_id,
                        'sessionId' => $session_id,
                    ]
                );
                $trackExercise = $em->find(TrackEExercise::class, $exe_id);
                /** @var TrackEAttemptQualify $trackQualify */
                $trackQualify
                    ->setTrackExercise($trackExercise)
                    ->setQuestionId($question_id)
                    ->setAnswer($answer)
                    ->setMarks((int) $score)
                    ->setAuthor(api_get_user_id())
                    ->setSessionId($session_id)
                ;
                $em->persist($trackQualify);
                $em->flush();
            }
            $attempt_id = $exe_id;
        }

        return $attempt_id;
    }