ExerciseLib::get_number_students_answer_count()

Complexity

Conditions

18

Size

Total Lines	97
Code Lines	65

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public static function get_number_students_answer_count(
        $answer_id,
        $question_id,
        $exercise_id,
        $course_code,
        $session_id,
        $question_type = null,
        $correct_answer = null,
        $current_answer = null
    ) {
        $track_exercises = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);
        $track_attempt   = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ATTEMPT);
        $courseTable     = Database::get_main_table(TABLE_MAIN_COURSE);
        $courseUser      = Database::get_main_table(TABLE_MAIN_COURSE_USER);
        $courseUserSession = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);

        $question_id = (int) $question_id;
        $answer_id   = (int) $answer_id;
        $exercise_id = (int) $exercise_id;
        $courseId    = (int) api_get_course_int_id($course_code);
        $session_id  = (int) $session_id;

        switch ($question_type) {
            case FILL_IN_BLANKS:
            case FILL_IN_BLANKS_COMBINATION:
                $answer_condition = '';
                $select_condition = ' e.exe_id, answer ';
                break;
            case MATCHING:
            case MATCHING_COMBINATION:
            case MATCHING_DRAGGABLE:
            case MATCHING_DRAGGABLE_COMBINATION:
            default:
                $answer_condition = " answer = $answer_id AND ";
                $select_condition = ' DISTINCT exe_user_id ';
        }

        if (empty($session_id)) {
            $courseCondition = "
            INNER JOIN $courseUser cu
                ON cu.c_id = e.c_id AND cu.user_id = e.exe_user_id";
            $courseConditionWhere = " AND relation_type <> 2 AND cu.status = ".STUDENT;
        } else {
            $courseCondition = "
            INNER JOIN $courseUserSession cu
                ON (cu.c_id = e.c_id AND cu.user_id = e.exe_user_id AND e.session_id = cu.session_id)";
            $courseConditionWhere = ' AND cu.status = '.SessionEntity::STUDENT;
        }

        $sessionCondition = api_get_session_condition($session_id, true, false, 'e.session_id');
        $sql = "SELECT $select_condition
            FROM $track_exercises e
            INNER JOIN $track_attempt a
                ON (a.exe_id = e.exe_id AND a.c_id = e.c_id)
            INNER JOIN $courseTable c
                ON c.id = e.c_id
            $courseCondition
            WHERE
                exe_exo_id = $exercise_id AND
                e.c_id = $courseId AND
                $answer_condition
                question_id = $question_id AND
                e.status = ''
                $courseConditionWhere
                $sessionCondition
    ";

        $result = Database::query($sql);
        $return = 0;
        if ($result) {
            switch ($question_type) {
                case FILL_IN_BLANKS:
                case FILL_IN_BLANKS_COMBINATION:
                    $good_answers = 0;
                    while ($row = Database::fetch_assoc($result)) {
                        $fill_blank = self::check_fill_in_blanks(
                            $correct_answer,
                            $row['answer'],
                            $current_answer
                        );
                        if (isset($fill_blank[$current_answer]) && 1 == (int) $fill_blank[$current_answer]) {
                            $good_answers++;
                        }
                    }

                    return $good_answers;

                case MATCHING:
                case MATCHING_COMBINATION:
                case MATCHING_DRAGGABLE:
                case MATCHING_DRAGGABLE_COMBINATION:
                default:
                    $return = Database::num_rows($result);
            }
        }

        return $return;
    }