+global\Tracking::get_avg_student_progress()

Complexity

Conditions	21
Paths	1546

Size

Total Lines	144
Code Lines	80

Duplication

Lines	6
Ratio	4.17 %

Importance

Changes

0

<?php
    public static function get_avg_student_progress(
        $studentId,
        $courseCode = null,
        $lpIdList = array(),
        $sessionId = null,
        $returnArray = false,
        $onlySeriousGame = false
    ) {
        // If there is at least one learning path and one student.
        if (empty($studentId)) {
            return false;
        }

        $sessionId = intval($sessionId);
        $courseInfo = api_get_course_info($courseCode);

        if (empty($courseInfo)) {
            return false;
        }

        $lPTable = Database::get_course_table(TABLE_LP_MAIN);
        $lpViewTable = Database::get_course_table(TABLE_LP_VIEW);
        $lpConditions = [];
        $lpConditions['c_id = ? '] = $courseInfo['real_id'];

        if ($sessionId > 0) {
            $lpConditions['AND (session_id = ? OR session_id = 0 OR session_id IS NULL)'] = $sessionId;
        } else {
            $lpConditions['AND session_id = ?'] = $sessionId;
        }

        if (is_array($lpIdList) && count($lpIdList) > 0) {
            $placeHolders = [];
            for ($i = 0; $i < count($lpIdList); $i++) {
                $placeHolders[] = '?';
            }
            $lpConditions['AND id IN(' . implode(', ', $placeHolders) . ') '] = $lpIdList;
        }

        if ($onlySeriousGame) {
            $lpConditions['AND seriousgame_mode = ? '] = true;
        }

        $resultLP = Database::select(
            'id',
            $lPTable,
            ['where' => $lpConditions]
        );
        $filteredLP = array_keys($resultLP);

        if (empty($filteredLP)) {
            return false;
        }

        $conditions = [
            " c_id = {$courseInfo['real_id']} ",
            " lp_view.lp_id IN(" . implode(', ', $filteredLP) . ") "
        ];

        $groupBy = 'GROUP BY lp_id';

        if (is_array($studentId)) {
            $studentId = array_map('intval', $studentId);
            $conditions[] = " lp_view.user_id IN (" . implode(',', $studentId) . ")  ";


        } else {
            $studentId = intval($studentId);
            $conditions[] = " lp_view.user_id = '$studentId' ";

            if (empty($lpIdList)) {
                $lpList = new LearnpathList($studentId, $courseCode, $sessionId);
                $lpList = $lpList->get_flat_list();
                if (!empty($lpList)) {
                    /** @var  $lp */
                    foreach ($lpList as $lpId => $lp) {
                        $lpIdList[] = $lpId;
                    }
                }
            }
        }

        if (!empty($sessionId)) {
            $conditions[] = " session_id = $sessionId ";
        }

        $conditionToString = implode('AND', $conditions);
        // Get last view for each student (in case of multi-attempt)
        // Also filter on LPs of this session
        /*$sql = " SELECT
                    MAX(view_count),
                    AVG(progress) average,
                    SUM(progress) sum_progress,
                    count(progress) count_progress
                FROM $lpViewTable lp_view
                WHERE
                  $conditionToString
                $groupBy";*/

        $sql = "
            SELECT lp_id, view_count, progress FROM $lpViewTable lp_view
            WHERE
                $conditionToString
                $groupBy
            ORDER BY view_count DESC
        ";

        $result = Database::query($sql);

        $progress = array();
        $viewCount = array();
        while ($row = Database::fetch_array($result, 'ASSOC')) {
            if (!isset($viewCount[$row['lp_id']])) {
                $progress[$row['lp_id']] = $row['progress'];
            }
            $viewCount[$row['lp_id']] = $row['view_count'];
        }

        // Fill with lp ids
        if (!empty($lpIdList)) {
            foreach ($lpIdList as $lpId) {
                if (!isset($progress[$lpId])) {
                    $progress[$lpId] = 0;
                }
            }
        }

        if (!empty($progress)) {
            $sum = array_sum($progress);
            $average = $sum / count($progress);
        } else {
            $average = 0;
            $sum = 0;
        }

        if ($returnArray) {
            return [
                $sum,
                count($progress)
            ];
        }

        return round($average, 1);
    }