<th><?php
echo get_lang('AllAttempts');
?>
</th>
</tr>
<?php
$csv_content[] = array();
$csv_content[] = array(get_lang('Exercises'), get_lang('LearningPath'), get_lang('AvgCourseScore'), get_lang('Attempts'));
$t_quiz = Database::get_course_table(TABLE_QUIZ_TEST);
$sql = "SELECT quiz.title, id FROM " . $t_quiz . " AS quiz\n WHERE\n quiz.c_id = " . $info_course['real_id'] . " AND\n (quiz.session_id = {$sessionId} OR quiz.session_id = 0) AND\n active IN (0, 1)\n ORDER BY quiz.title ASC ";
$result_exercices = Database::query($sql);
$i = 0;
if (Database::num_rows($result_exercices) > 0) {
while ($exercices = Database::fetch_array($result_exercices)) {
$exercise_id = intval($exercices['id']);
$count_attempts = Tracking::count_student_exercise_attempts($student_id, $courseInfo['real_id'], $exercise_id, 0, 0, $sessionId, 2);
$score_percentage = Tracking::get_avg_student_exercise_score($student_id, $course_code, $exercise_id, $sessionId, 1, 0);
if (!isset($score_percentage) && $count_attempts > 0) {
$scores_lp = Tracking::get_avg_student_exercise_score($student_id, $course_code, $exercise_id, $sessionId, 2, 1);
$score_percentage = $scores_lp[0];
$lp_name = $scores_lp[1];
} else {
$lp_name = '-';
}
$lp_name = !empty($lp_name) ? $lp_name : get_lang('NoLearnpath');
if ($i % 2) {
$css_class = 'row_odd';
} else {
$css_class = 'row_even';
}
echo '<tr class="' . $css_class . '"><td>' . $exercices['title'] . '</td>';
<th><?php
echo get_lang('AllAttempts');
?>
</th>
</tr>
<?php
$csv_content[] = array();
$csv_content[] = array(get_lang('Exercices'), get_lang('Score'), get_lang('Attempts'));
$t_quiz = Database::get_course_table(TABLE_QUIZ_TEST);
$sql_exercices = "SELECT quiz.title, iid FROM " . $t_quiz . " AS quiz\n\t\t\t\t\t\t WHERE quiz.c_id = " . $courseId . " AND\n\t\t\t\t\t\t \t\tactive='1' AND\n\t\t\t\t\t\t\t\t(quiz.session_id = {$session_id} OR quiz.session_id = 0)\n ORDER BY quiz.title ASC ";
$result_exercices = Database::query($sql_exercices);
$i = 0;
if (Database::num_rows($result_exercices) > 0) {
while ($exercices = Database::fetch_array($result_exercices)) {
$exercise_id = intval($exercices['iid']);
$count_attempts = Tracking::count_student_exercise_attempts($student_id, $courseId, $exercise_id, 0, 0, $session_id);
$score_percentage = Tracking::get_avg_student_exercise_score($student_id, $courseId, $exercise_id, $session_id);
$csv_content[] = array($exercices['title'], $score_percentage . '%', $count_attempts);
if ($i % 2) {
$css_class = 'row_odd';
} else {
$css_class = 'row_even';
}
echo '<tr class="' . $css_class . '"><td>' . $exercices['title'] . '</td>';
echo '<td>';
if ($count_attempts > 0) {
echo $score_percentage . '%';
} else {
echo '-';
$score_percentage = 0;
}
