Tracking::get_avg_student_exercise_score()

Complexity

Conditions	22
Paths	7705

Size

Total Lines	135
Code Lines	81

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public static function get_avg_student_exercise_score(
        $student_id,
        $course_code,
        $exercise_id = 0,
        $sessionId = null,
        $active_filter = 1,
        $into_lp = 0
    ) {
        $course_code = Database::escape_string($course_code);
        $course_info = api_get_course_info($course_code);
        if (!empty($course_info)) {
            // table definition
            $tbl_course_quiz = Database::get_course_table(TABLE_QUIZ_TEST);
            $tbl_stats_exercise = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);

            // Compose a filter based on optional exercise given
            $condition_quiz = '';
            if (!empty($exercise_id)) {
                $exercise_id = (int) $exercise_id;
                $condition_quiz = " AND iid = $exercise_id ";
            }

            // Compose a filter based on optional session id given
            $sessionCondition = '';
            $session = null;
            if ($sessionId !== null) {
                $session = api_get_session_entity($sessionId);
                $sessionCondition = api_get_session_condition($sessionId);
            }

            $condition_active = '';
            if (1 == $active_filter) {
                $condition_active = 'AND active <> -1';
            } elseif (0 == $active_filter) {
                $condition_active = 'AND active <> 0';
            }
            $condition_into_lp = '';
            $select_lp_id = '';
            if (0 == $into_lp) {
                $condition_into_lp = 'AND orig_lp_id = 0 AND orig_lp_item_id = 0';
            } else {
                $select_lp_id = ', orig_lp_id as lp_id ';
            }

            $quizRepo = Container::getQuizRepository();
            $course = api_get_course_entity($course_info['real_id']);
            $qb = $quizRepo->getResourcesByCourse($course, $session, null, null, false);
            $qb
                ->select('count(resource)')
                ->setMaxResults(1);
            $count_quiz = $qb->getQuery()->getSingleScalarResult();

            /*$sql = "SELECT count(iid)
    		        FROM $tbl_course_quiz
    				WHERE c_id = {$course_info['real_id']} $condition_active $condition_quiz ";
            $count_quiz = 0;
            $countQuizResult = Database::query($sql);
            if (!empty($countQuizResult)) {
                $count_quiz = Database::fetch_row($countQuizResult);
            }*/
            if (!empty($count_quiz) && !empty($student_id)) {
                if (is_array($student_id)) {
                    $student_id = array_map('intval', $student_id);
                    $condition_user = " AND exe_user_id IN (".implode(',', $student_id).") ";
                } else {
                    $student_id = (int) $student_id;
                    $condition_user = " AND exe_user_id = '$student_id' ";
                }

                if (empty($exercise_id)) {
                    $sql = "SELECT iid FROM $tbl_course_quiz
                            WHERE c_id = {$course_info['real_id']} $condition_active $condition_quiz";
                    $result = Database::query($sql);
                    $exercise_list = [];
                    $exercise_id = null;
                    if (!empty($result) && Database::num_rows($result)) {
                        while ($row = Database::fetch_array($result)) {
                            $exercise_list[] = $row['iid'];
                        }
                    }
                    if (!empty($exercise_list)) {
                        $exercise_id = implode("','", $exercise_list);
                    }
                }

                $sql = "SELECT
                        SUM(score/max_score*100) as avg_score,
                        COUNT(*) as num_attempts
                        $select_lp_id
                        FROM $tbl_stats_exercise
                        WHERE
                            exe_exo_id IN ('".$exercise_id."')
                            $condition_user AND
                            status = '' AND
                            c_id = {$course_info['real_id']}
                            $sessionCondition
                            $condition_into_lp
                        ORDER BY exe_date DESC";

                $res = Database::query($sql);
                $row = Database::fetch_array($res);
                $quiz_avg_score = null;

                if (!empty($row['avg_score'])) {
                    $quiz_avg_score = round($row['avg_score'], 2);
                }

                if (!empty($row['num_attempts'])) {
                    $quiz_avg_score = round($quiz_avg_score / $row['num_attempts'], 2);
                }
                if (is_array($student_id)) {
                    $quiz_avg_score = round($quiz_avg_score / count($student_id), 2);
                }
                if (0 == $into_lp) {
                    return $quiz_avg_score;
                } else {
                    if (!empty($row['lp_id'])) {
                        $tbl_lp = Database::get_course_table(TABLE_LP_MAIN);
                        $sql = "SELECT title FROM $tbl_lp WHERE iid = ".(int) $row['lp_id'];
                        $result = Database::query($sql);
                        $row_lp = Database::fetch_row($result);
                        $lp_name = null;
                        if ($row_lp && isset($row_lp[0])) {
                            $lp_name = $row_lp[0];
                        }

                        return [$quiz_avg_score, $lp_name];
                    }

                    return [$quiz_avg_score, null];
                }
            }
        }

        return null;
    }