ExerciseLib::getNumberStudentsAnswerHotspotCount()

Complexity

Conditions

3

Size

Total Lines	57
Code Lines	35

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public static function getNumberStudentsAnswerHotspotCount(
        int    $answerId,
        int    $questionId,
        int    $exerciseId,
        string $courseCode,
        int $sessionId
    ): int
    {
        $trackExercises = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);
        $trackHotspot = Database::get_main_table(TABLE_STATISTIC_TRACK_E_HOTSPOT);
        $courseUser = Database::get_main_table(TABLE_MAIN_COURSE_USER);
        $courseTable = Database::get_main_table(TABLE_MAIN_COURSE);
        $courseUserSession = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);

        $questionId = (int) $questionId;
        $answerId = (int) $answerId;
        $exerciseId = (int) $exerciseId;
        $courseId = api_get_course_int_id($courseCode);
        $sessionId = (int) $sessionId;

        if (empty($sessionId)) {
            $courseCondition = "
            INNER JOIN $courseUser cu
            ON cu.c_id = c.id AND cu.user_id  = exe_user_id";
            $courseConditionWhere = " AND relation_type <> 2 AND cu.status = ".STUDENT;
        } else {
            $courseCondition = "
            INNER JOIN $courseUserSession cu
            ON (cu.c_id = 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($sessionId, true, false, 'e.session_id');
        $sql = "SELECT DISTINCT exe_user_id
                FROM $trackExercises e
                INNER JOIN $trackHotspot a
                ON (a.hotspot_exe_id = e.exe_id)
                INNER JOIN $courseTable c
                ON (a.c_id = c.id)
                $courseCondition
                WHERE
                    exe_exo_id              = $exerciseId AND
                    a.c_id 	= $courseId AND
                    hotspot_answer_id       = $answerId AND
                    hotspot_question_id     = $questionId AND
                    hotspot_correct         =  1 AND
                    e.status                = ''
                    $courseConditionWhere
                    $sessionCondition
            ";
        $result = Database::query($sql);
        $return = 0;
        if ($result) {
            $return = Database::num_rows($result);
        }

        return $return;
    }