';
// Going through the items using the $items[] array instead of the database order ensures
// we get them in the same order as in the imsmanifest file, which is rather random when using
// the database table.
$TBL_LP_ITEM = Database::get_course_table(TABLE_LP_ITEM);
$TBL_LP_ITEM_VIEW = Database::get_course_table(TABLE_LP_ITEM_VIEW);
$TBL_LP_VIEW = Database::get_course_table(TABLE_LP_VIEW);
$tbl_quiz_questions = Database::get_course_table(TABLE_QUIZ_QUESTION);
$TBL_QUIZ = Database::get_course_table(TABLE_QUIZ_TEST);
$tbl_stats_exercices = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);
$tbl_stats_attempts = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ATTEMPT);
$sql = "SELECT max(view_count)
FROM $TBL_LP_VIEW
WHERE
c_id = $course_id AND
lp_id = $lp_id AND
user_id = $user_id
$session_condition";
$res = Database::query($sql);
$view = 0;
if (Database::num_rows($res) > 0) {
$myrow = Database::fetch_array($res);
$view = (int) $myrow[0];
}
$counter = 0;
$total_time = 0;
$h = get_lang('h');
if (!empty($export_csv)) {
$csvHeaders = [
get_lang('Learning object name'),
get_lang('Status'),
get_lang('Score'),
];
if ($hideTime === false) {
$csvHeaders[] = get_lang('Time');
}
$csv_content[] = $csvHeaders;
}
$result_disabled_ext_all = true;
$chapterTypes = learnpath::getChapterTypes();
$accessToPdfExport = api_is_allowed_to_edit(false, false, true);
$minimunAvailable = self::minimumTimeAvailable($session_id, $course_id);
$timeCourse = [];
if ($minimunAvailable) {
$timeCourse = self::getCalculateTime($user_id, $course_id, $session_id);
Session::write('trackTimeCourse', $timeCourse);
}
// Show lp items
if (is_array($list) && count($list) > 0) {
foreach ($list as $my_item_id) {
$extend_this = 0;
$order = 'DESC';
if ((!empty($extendId) && $extendId == $my_item_id) || $extend_all) {
$extend_this = 1;
$order = 'ASC';
}
// Prepare statement to go through each attempt.
$viewCondition = null;
if (!empty($view)) {
$viewCondition = " AND v.view_count = $view ";
}
$sql = "SELECT
iv.status as mystatus,
v.view_count as mycount,
iv.score as myscore,
iv.total_time as mytime,
i.iid as myid,
i.lp_id as mylpid,
iv.lp_view_id as mylpviewid,
i.title as mytitle,
i.max_score as mymaxscore,
iv.max_score as myviewmaxscore,
i.item_type as item_type,
iv.view_count as iv_view_count,
iv.id as iv_id,
path
FROM $TBL_LP_ITEM as i
INNER JOIN $TBL_LP_ITEM_VIEW as iv
ON (i.iid = iv.lp_item_id AND i.c_id = iv.c_id)
INNER JOIN $TBL_LP_VIEW as v
ON (iv.lp_view_id = v.id AND v.c_id = iv.c_id)
WHERE
v.c_id = $course_id AND
i.iid = $my_item_id AND
i.lp_id = $lp_id AND
v.user_id = $user_id AND
v.session_id = $session_id
$viewCondition
ORDER BY iv.view_count $order ";
$result = Database::query($sql);
$num = Database::num_rows($result);
$time_for_total = 0;
$attemptResult = 0;
if ($allowNewTracking && $timeCourse) {
if (isset($timeCourse['learnpath_detailed']) &&
isset($timeCourse['learnpath_detailed'][$lp_id]) &&
isset($timeCourse['learnpath_detailed'][$lp_id][$my_item_id])
) {
$attemptResult = $timeCourse['learnpath_detailed'][$lp_id][$my_item_id][$view];
}
}
// Extend all
if (($extend_this || $extend_all) && $num > 0) {
$row = Database::fetch_array($result);
$result_disabled_ext_all = false;
if ($row['item_type'] === 'quiz') {
// Check results_disabled in quiz table.
$my_path = Database::escape_string($row['path']);
$sql = "SELECT results_disabled
FROM $TBL_QUIZ
WHERE
c_id = $course_id AND
id ='".$my_path."'";
$res_result_disabled = Database::query($sql);
$row_result_disabled = Database::fetch_row($res_result_disabled);
if (Database::num_rows($res_result_disabled) > 0 &&
(int) $row_result_disabled[0] === 1
) {
$result_disabled_ext_all = true;
}
}
// If there are several attempts, and the link to extend has been clicked, show each attempt...
$oddclass = 'row_even';
if (($counter % 2) === 0) {
$oddclass = 'row_odd';
}
$extend_link = '';
if (!empty($inter_num)) {
$extend_link = Display::url(
Display::return_icon(
'visible.png',
get_lang('Hide attempt view')
),
api_get_self().'?action=stats&fold_id='.$my_item_id.$url_suffix
);
}
$title = $row['mytitle'];
if (empty($title)) {
$title = learnpath::rl_get_resource_name($courseInfo['code'], $lp_id, $row['myid']);
}
if (in_array($row['item_type'], $chapterTypes)) {
$title = " $title
";
}
$lesson_status = $row['mystatus'];
$title = Security::remove_XSS($title);
$counter++;
$action = null;
if ($type === 'classic') {
$action = ' | ';
}
if (in_array($row['item_type'], $chapterTypes)) {
$output .= '
| '.$extend_link.' |
'.$title.'
|
'.learnpathItem::humanize_status($lesson_status, true, $type).' |
|
|
'.$action.'
';
continue;
} else {
$output .= '
| '.$extend_link.' |
'.$title.' |
|
|
|
'.$action.'
';
}
$attemptCount = 1;
do {
// Check if there are interactions below.
$extend_attempt_link = '';
$extend_this_attempt = 0;
if ($allowNewTracking && $timeCourse) {
//$attemptResult = 0;
if (isset($timeCourse['learnpath_detailed']) &&
isset($timeCourse['learnpath_detailed'][$lp_id]) &&
isset($timeCourse['learnpath_detailed'][$lp_id][$my_item_id])
) {
$attemptResult = $timeCourse['learnpath_detailed'][$lp_id][$my_item_id][$row['iv_view_count']];
}
}
if ((
learnpath::get_interactions_count_from_db($row['iv_id'], $course_id) > 0 ||
learnpath::get_objectives_count_from_db($row['iv_id'], $course_id) > 0
) &&
!$extend_all
) {
if ($extendAttemptId == $row['iv_id']) {
// The extend button for this attempt has been clicked.
$extend_this_attempt = 1;
$extend_attempt_link = Display::url(
Display::return_icon('visible.png', get_lang('Hide attempt view')),
api_get_self().'?action=stats&extend_id='.$my_item_id.'&fold_attempt_id='.$row['iv_id'].$url_suffix
);
if ($accessToPdfExport) {
$extend_attempt_link .= ' '.
Display::url(
Display::return_icon('pdf.png', get_lang('Export to PDF')),
api_get_self(
).'?action=export_stats&extend_id='.$my_item_id.'&extend_attempt_id='.$row['iv_id'].$url_suffix
);
}
} else { // Same case if fold_attempt_id is set, so not implemented explicitly.
// The extend button for this attempt has not been clicked.
$extend_attempt_link = Display::url(
Display::return_icon('invisible.png', get_lang('Extend attempt view')),
api_get_self().'?action=stats&extend_id='.$my_item_id.'&extend_attempt_id='.$row['iv_id'].$url_suffix
);
if ($accessToPdfExport) {
$extend_attempt_link .= ' '.
Display::url(
Display::return_icon('pdf.png', get_lang('Export to PDF')),
api_get_self(
).'?action=export_stats&extend_id='.$my_item_id.'&extend_attempt_id='.$row['iv_id'].$url_suffix
);
}
}
}
$oddclass = 'row_even';
if (($counter % 2) == 0) {
$oddclass = 'row_odd';
}
$lesson_status = $row['mystatus'];
$score = $row['myscore'];
$time_for_total = $row['mytime'];
$attemptTime = $row['mytime'];
if ($minimunAvailable) {
$lp_time = $timeCourse[TOOL_LEARNPATH];
$lpTime = null;
if (isset($lp_time[$lp_id])) {
$lpTime = (int) $lp_time[$lp_id];
}
$time_for_total = $lpTime;
if ($allowNewTracking) {
$time_for_total = (int) $attemptResult;
$attemptTime = (int) $attemptResult;
}
}
$time = learnpathItem::getScormTimeFromParameter('js', $attemptTime);
if ($score == 0) {
$maxscore = $row['mymaxscore'];
} else {
if ($row['item_type'] === 'sco') {
if (!empty($row['myviewmaxscore']) && $row['myviewmaxscore'] > 0) {
$maxscore = $row['myviewmaxscore'];
} elseif ($row['myviewmaxscore'] === '') {
$maxscore = 0;
} else {
$maxscore = $row['mymaxscore'];
}
} else {
$maxscore = $row['mymaxscore'];
}
}
// Remove "NaN" if any (@todo: locate the source of these NaN)
$time = str_replace('NaN', '00'.$h.'00\'00"', $time);
if ($row['item_type'] !== 'dir') {
if (!$is_allowed_to_edit && $result_disabled_ext_all) {
$view_score = Display::return_icon(
'invisible.png',
get_lang('Results hidden by the exercise setting')
);
} else {
switch ($row['item_type']) {
case 'sco':
if ($maxscore == 0) {
$view_score = $score;
} else {
$view_score = ExerciseLib::show_score(
$score,
$maxscore,
false
);
}
break;
case 'document':
$view_score = ($score == 0 ? '/' : ExerciseLib::show_score($score, $maxscore, false));
break;
default:
$view_score = ExerciseLib::show_score(
$score,
$maxscore,
false
);
break;
}
}
$action = null;
if ($type == 'classic') {
$action = ' | ';
}
$timeRow = ''.$time.' | ';
if ($hideTime) {
$timeRow = '';
}
$output .= '
|
'.$extend_attempt_link.' |
'.get_lang('Attempt').' '.$attemptCount.' |
'.learnpathItem::humanize_status($lesson_status, true, $type).' |
'.$view_score.' |
'.$timeRow.'
'.$action.'
';
$attemptCount++;
if (!empty($export_csv)) {
$temp = [];
$temp[] = $title = Security::remove_XSS($title);
$temp[] = Security::remove_XSS(
learnpathItem::humanize_status($lesson_status, false, $type)
);
if ($row['item_type'] === 'quiz') {
if (!$is_allowed_to_edit && $result_disabled_ext_all) {
$temp[] = '/';
} else {
$temp[] = ($score == 0 ? '0/'.$maxscore : ($maxscore == 0 ? $score : $score.'/'.float_format($maxscore, 1)));
}
} else {
$temp[] = ($score == 0 ? '/' : ($maxscore == 0 ? $score : $score.'/'.float_format($maxscore, 1)));
}
if ($hideTime === false) {
$temp[] = $time;
}
$csv_content[] = $temp;
}
}
$counter++;
$action = null;
if ($type === 'classic') {
$action = ' | ';
}
if ($extend_this_attempt || $extend_all) {
$list1 = learnpath::get_iv_interactions_array($row['iv_id'], $course_id);
foreach ($list1 as $id => $interaction) {
$oddclass = 'row_even';
if (($counter % 2) == 0) {
$oddclass = 'row_odd';
}
$timeRow = ''.$interaction['time'].' | ';
if ($hideTime) {
$timeRow = '';
}
$output .= '
|
|
|
'.$interaction['order_id'].' |
'.$interaction['id'].' | ';
$output .= '
'.$interaction['type'].' |
'.$interaction['student_response_formatted'].' |
'.$interaction['result'].' |
'.$interaction['latency'].' |
'.$timeRow.'
'.$action.'
';
$counter++;
}
$list2 = learnpath::get_iv_objectives_array($row['iv_id'], $course_id);
foreach ($list2 as $id => $interaction) {
$oddclass = 'row_even';
if (($counter % 2) === 0) {
$oddclass = 'row_odd';
}
$output .= '
|
|
|
'.$interaction['order_id'].' |
'.$interaction['objective_id'].' |
'.$interaction['status'].' |
'.$interaction['score_raw'].' |
'.$interaction['score_max'].' |
'.$interaction['score_min'].' |
'.$action.'
';
$counter++;
}
}
} while ($row = Database::fetch_array($result));
} elseif ($num > 0) {
// Not extended.
$row = Database::fetch_array($result, 'ASSOC');
$my_id = $row['myid'];
$my_lp_id = $row['mylpid'];
$my_lp_view_id = $row['mylpviewid'];
$my_path = $row['path'];
$result_disabled_ext_all = false;
if ($row['item_type'] === 'quiz') {
// Check results_disabled in quiz table.
$my_path = Database::escape_string($my_path);
$sql = "SELECT results_disabled
FROM $TBL_QUIZ
WHERE c_id = $course_id AND id = '$my_path' ";
$res_result_disabled = Database::query($sql);
$row_result_disabled = Database::fetch_row($res_result_disabled);
if (Database::num_rows($res_result_disabled) > 0 &&
(int) $row_result_disabled[0] === 1
) {
$result_disabled_ext_all = true;
}
}
// Check if there are interactions below
$extend_this_attempt = 0;
$inter_num = learnpath::get_interactions_count_from_db($row['iv_id'], $course_id);
$objec_num = learnpath::get_objectives_count_from_db($row['iv_id'], $course_id);
$extend_attempt_link = '';
if ($inter_num > 0 || $objec_num > 0) {
if (!empty($extendAttemptId) && $extendAttemptId == $row['iv_id']) {
// The extend button for this attempt has been clicked.
$extend_this_attempt = 1;
$extend_attempt_link = Display::url(
Display::return_icon('visible.png', get_lang('Hide attempt view')),
api_get_self().'?action=stats&extend_id='.$my_item_id.'&fold_attempt_id='.$row['iv_id'].$url_suffix
);
} else {
// Same case if fold_attempt_id is set, so not implemented explicitly.
// The extend button for this attempt has not been clicked.
$extend_attempt_link = Display::url(
Display::return_icon('invisible.png', get_lang('Extend attempt view')),
api_get_self().'?action=stats&extend_id='.$my_item_id.'&extend_attempt_id='.$row['iv_id'].$url_suffix
);
}
}
$oddclass = 'row_even';
if (($counter % 2) == 0) {
$oddclass = 'row_odd';
}
$extend_link = '';
if ($inter_num > 1) {
$extend_link = Display::url(
Display::return_icon('invisible.png', get_lang('Extend attempt view')),
api_get_self().'?action=stats&extend_id='.$my_item_id.'&extend_attempt_id='.$row['iv_id'].$url_suffix
);
}
$lesson_status = $row['mystatus'];
$score = $row['myscore'];
$subtotal_time = $row['mytime'];
while ($tmp_row = Database::fetch_array($result)) {
$subtotal_time += $tmp_row['mytime'];
}
if ($allowNewTracking) {
$subtotal_time = $attemptResult;
}
$title = $row['mytitle'];
// Selecting the exe_id from stats attempts tables in order to look the max score value.
$sql = 'SELECT * FROM '.$tbl_stats_exercices.'
WHERE
exe_exo_id="'.$row['path'].'" AND
exe_user_id="'.$user_id.'" AND
orig_lp_id = "'.$lp_id.'" AND
orig_lp_item_id = "'.$row['myid'].'" AND
c_id = '.$course_id.' AND
status <> "incomplete" AND
session_id = '.$session_id.'
ORDER BY exe_date DESC
LIMIT 1';
$resultLastAttempt = Database::query($sql);
$num = Database::num_rows($resultLastAttempt);
$id_last_attempt = null;
if ($num > 0) {
while ($rowLA = Database::fetch_array($resultLastAttempt)) {
$id_last_attempt = $rowLA['exe_id'];
}
}
switch ($row['item_type']) {
case 'sco':
if (!empty($row['myviewmaxscore']) && $row['myviewmaxscore'] > 0) {
$maxscore = $row['myviewmaxscore'];
} elseif ($row['myviewmaxscore'] === '') {
$maxscore = 0;
} else {
$maxscore = $row['mymaxscore'];
}
break;
case 'quiz':
// Get score and total time from last attempt of a exercise en lp.
$sql = "SELECT iid, score
FROM $TBL_LP_ITEM_VIEW
WHERE
c_id = $course_id AND
lp_item_id = '".(int) $my_id."' AND
lp_view_id = '".(int) $my_lp_view_id."'
ORDER BY view_count DESC
LIMIT 1";
$res_score = Database::query($sql);
$row_score = Database::fetch_array($res_score);
$sql = "SELECT SUM(total_time) as total_time
FROM $TBL_LP_ITEM_VIEW
WHERE
c_id = $course_id AND
lp_item_id = '".(int) $my_id."' AND
lp_view_id = '".(int) $my_lp_view_id."'";
$res_time = Database::query($sql);
$row_time = Database::fetch_array($res_time);
$score = 0;
$subtotal_time = 0;
if (Database::num_rows($res_score) > 0 &&
Database::num_rows($res_time) > 0
) {
$score = (float) $row_score['score'];
$subtotal_time = (int) $row_time['total_time'];
}
// Selecting the max score from an attempt.
$sql = "SELECT SUM(t.ponderation) as maxscore
FROM (
SELECT DISTINCT
question_id, marks, ponderation
FROM $tbl_stats_attempts as at
INNER JOIN $tbl_quiz_questions as q
ON (q.id = at.question_id AND q.c_id = $course_id)
WHERE exe_id ='$id_last_attempt'
) as t";
$result = Database::query($sql);
$row_max_score = Database::fetch_array($result);
$maxscore = $row_max_score['maxscore'];
// Get duration time from track_e_exercises.exe_duration instead of lp_view_item.total_time
$sql = 'SELECT SUM(exe_duration) exe_duration
FROM '.$tbl_stats_exercices.'
WHERE
exe_exo_id="'.$row['path'].'" AND
exe_user_id="'.$user_id.'" AND
orig_lp_id = "'.$lp_id.'" AND
orig_lp_item_id = "'.$row['myid'].'" AND
c_id = '.$course_id.' AND
status <> "incomplete" AND
session_id = '.$session_id.'
ORDER BY exe_date DESC ';
$sumScoreResult = Database::query($sql);
$durationRow = Database::fetch_array($sumScoreResult, 'ASSOC');
if (!empty($durationRow['exe_duration'])) {
$exeDuration = $durationRow['exe_duration'];
if ($exeDuration != $subtotal_time &&
!empty($row_score['iid']) &&
!empty($exeDuration)
) {
$subtotal_time = $exeDuration;
// Update c_lp_item_view.total_time
$sqlUpdate = "UPDATE $TBL_LP_ITEM_VIEW SET total_time = '$exeDuration'
WHERE iid = ".$row_score['iid'];
Database::query($sqlUpdate);
}
}
break;
default:
$maxscore = $row['mymaxscore'];
break;
}
$time_for_total = $subtotal_time;
$time = learnpathItem::getScormTimeFromParameter('js', $subtotal_time);
if (empty($title)) {
$title = learnpath::rl_get_resource_name(
$courseInfo['code'],
$lp_id,
$row['myid']
);
}
$action = null;
if ($type == 'classic') {
$action = ' | ';
}
if (in_array($row['item_type'], $chapterTypes)) {
$title = Security::remove_XSS($title);
$output .= '
| '.$extend_link.' |
'.$title.'
|
'.learnpathitem::humanize_status($lesson_status).' |
|
|
'.$action.'
';
} else {
$correct_test_link = '-';
$showRowspan = false;
if ($row['item_type'] === 'quiz') {
$my_url_suffix = '&course='.$courseCode.'&student_id='.$user_id.'&lp_id='.intval($row['mylpid']).'&origin='.$origin;
$sql = 'SELECT * FROM '.$tbl_stats_exercices.'
WHERE
exe_exo_id="'.$row['path'].'" AND
exe_user_id="'.$user_id.'" AND
orig_lp_id = "'.$lp_id.'" AND
orig_lp_item_id = "'.$row['myid'].'" AND
c_id = '.$course_id.' AND
status <> "incomplete" AND
session_id = '.$session_id.'
ORDER BY exe_date DESC ';
$resultLastAttempt = Database::query($sql);
$num = Database::num_rows($resultLastAttempt);
$showRowspan = false;
if ($num > 0) {
$linkId = 'link_'.$my_id;
if ($extendedAttempt == 1 &&
$lp_id == $my_lp_id &&
$lp_item_id == $my_id
) {
$showRowspan = true;
$correct_test_link = Display::url(
Display::return_icon(
'view_less_stats.gif',
get_lang('Hide all attempts')
),
api_get_self().'?action=stats'.$my_url_suffix.'&session_id='.$session_id.'&lp_item_id='.$my_id.'#'.$linkId,
['id' => $linkId]
);
} else {
$correct_test_link = Display::url(
Display::return_icon(
'view_more_stats.gif',
get_lang(
'Show all attemptsByExercise'
)
),
api_get_self().'?action=stats&extend_attempt=1'.$my_url_suffix.'&session_id='.$session_id.'&lp_item_id='.$my_id.'#'.$linkId,
['id' => $linkId]
);
}
}
}
$title = Security::remove_XSS($title);
$action = null;
if ($type === 'classic') {
$action = ''.$correct_test_link.' | ';
}
if ($lp_id == $my_lp_id && false) {
$output .= '
| '.$extend_link.' |
'.$title.' |
|
|
|
'.$action.'
';
$output .= '';
} else {
if ($lp_id == $my_lp_id && $lp_item_id == $my_id) {
$output .= "";
} else {
$output .= "
";
}
$scoreItem = null;
if ($row['item_type'] == 'quiz') {
if (!$is_allowed_to_edit && $result_disabled_ext_all) {
$scoreItem .= Display::return_icon(
'invisible.png',
get_lang('Results hidden by the exercise setting')
);
} else {
$scoreItem .= ExerciseLib::show_score($score, $maxscore, false);
}
} else {
$scoreItem .= $score == 0 ? '/' : ($maxscore == 0 ? $score : $score.'/'.$maxscore);
}
$timeRow = '| '.$time.' | ';
if ($hideTime) {
$timeRow = '';
}
$output .= '
'.$extend_link.' |
'.$title.' |
'.learnpathitem::humanize_status($lesson_status).' |
'.$scoreItem.' |
'.$timeRow.'
'.$action.'
';
$output .= '
';
}
if (!empty($export_csv)) {
$temp = [];
$temp[] = api_html_entity_decode($title, ENT_QUOTES);
$temp[] = api_html_entity_decode($lesson_status, ENT_QUOTES);
if ($row['item_type'] === 'quiz') {
if (!$is_allowed_to_edit && $result_disabled_ext_all) {
$temp[] = '/';
} else {
$temp[] = ($score == 0 ? '0/'.$maxscore : ($maxscore == 0 ? $score : $score.'/'.float_format($maxscore, 1)));
}
} else {
$temp[] = ($score == 0 ? '/' : ($maxscore == 0 ? $score : $score.'/'.float_format($maxscore, 1)));
}
if ($hideTime === false) {
$temp[] = $time;
}
$csv_content[] = $temp;
}
}
$counter++;
$action = null;
if ($type === 'classic') {
$action = ' | ';
}
if ($extend_this_attempt || $extend_all) {
$list1 = learnpath::get_iv_interactions_array($row['iv_id'], $course_id);
foreach ($list1 as $id => $interaction) {
if (($counter % 2) == 0) {
$oddclass = 'row_odd';
} else {
$oddclass = 'row_even';
}
$timeRow = ''.$interaction['time'].' | ';
if ($hideTime) {
$timeRow = '';
}
$output .= '
|
|
|
'.$interaction['order_id'].' |
'.$interaction['id'].' |
'.$interaction['type'].' |
'.urldecode($interaction['student_response']).' |
'.$interaction['result'].' |
'.$interaction['latency'].' |
'.$timeRow.'
'.$action.'
';
$counter++;
}
$list2 = learnpath::get_iv_objectives_array($row['iv_id'], $course_id);
foreach ($list2 as $id => $interaction) {
if (($counter % 2) == 0) {
$oddclass = 'row_odd';
} else {
$oddclass = 'row_even';
}
$output .= '
|
|
|
'.$interaction['order_id'].' |
'.$interaction['objective_id'].' |
'.$interaction['status'].' |
'.$interaction['score_raw'].' |
'.$interaction['score_max'].' |
'.$interaction['score_min'].' |
'.$action.'
';
$counter++;
}
}
// Attempts listing by exercise.
if ($lp_id == $my_lp_id && $lp_item_id == $my_id && $extendedAttempt) {
// Get attempts of a exercise.
if (!empty($lp_id) &&
!empty($lp_item_id) &&
$row['item_type'] === 'quiz'
) {
$sql = "SELECT path FROM $TBL_LP_ITEM
WHERE
c_id = $course_id AND
iid = '$lp_item_id' AND
lp_id = '$lp_id'";
$res_path = Database::query($sql);
$row_path = Database::fetch_array($res_path);
if (Database::num_rows($res_path) > 0) {
$sql = 'SELECT * FROM '.$tbl_stats_exercices.'
WHERE
exe_exo_id="'.(int) $row_path['path'].'" AND
status <> "incomplete" AND
exe_user_id="'.$user_id.'" AND
orig_lp_id = "'.(int) $lp_id.'" AND
orig_lp_item_id = "'.(int) $lp_item_id.'" AND
c_id = '.$course_id.' AND
session_id = '.$session_id.'
ORDER BY exe_date';
$res_attempts = Database::query($sql);
$num_attempts = Database::num_rows($res_attempts);
if ($num_attempts > 0) {
$n = 1;
while ($row_attempts = Database::fetch_array($res_attempts)) {
$my_score = $row_attempts['score'];
$my_maxscore = $row_attempts['max_score'];
$my_exe_id = $row_attempts['exe_id'];
$mktime_start_date = api_strtotime($row_attempts['start_date'], 'UTC');
$mktime_exe_date = api_strtotime($row_attempts['exe_date'], 'UTC');
$time_attemp = ' - ';
if ($mktime_start_date && $mktime_exe_date) {
$time_attemp = api_format_time($row_attempts['exe_duration'], 'js');
}
if (!$is_allowed_to_edit && $result_disabled_ext_all) {
$view_score = Display::return_icon(
'invisible.png',
get_lang(
'Results hidden by the exercise setting'
)
);
} else {
// Show only float when need it
if ($my_score == 0) {
$view_score = ExerciseLib::show_score(
0,
$my_maxscore,
false
);
} else {
if ($my_maxscore == 0) {
$view_score = $my_score;
} else {
$view_score = ExerciseLib::show_score(
$my_score,
$my_maxscore,
false
);
}
}
}
$my_lesson_status = $row_attempts['status'];
if ($my_lesson_status == '') {
$my_lesson_status = learnpathitem::humanize_status('completed');
} elseif ($my_lesson_status == 'incomplete') {
$my_lesson_status = learnpathitem::humanize_status('incomplete');
}
$timeRow = ''.$time_attemp.' | ';
if ($hideTime) {
$timeRow = '';
}
$output .= '
|
'.$extend_attempt_link.' |
'.get_lang('Attempt').' '.$n.' |
'.$my_lesson_status.' |
'.$view_score.' |
'.$timeRow;
if ($action == 'classic') {
if ($origin != 'tracking') {
if (!$is_allowed_to_edit && $result_disabled_ext_all) {
$output .= '
.' "'.get_lang('Show attempt').'")
| ';
} else {
$output .= '
.' "'.get_lang('Show attempt').'")
| ';
}
} else {
if (!$is_allowed_to_edit && $result_disabled_ext_all) {
$output .= '
| ';
} else {
$output .= '
.' "'.get_lang('Show and grade attempt').'") | ';
}
}
}
$output .= '
';
$n++;
}
}
$output .= '| |
';
}
}
}
}
$total_time += $time_for_total;
// QUIZZ IN LP
$a_my_id = [];
if (!empty($my_lp_id)) {
$a_my_id[] = $my_lp_id;
}
}
}
// NOT Extend all "left green cross"
if (!empty($a_my_id)) {
if ($extendedAttempt) {
// "Right green cross" extended
$total_score = self::get_avg_student_score(
$user_id,
$course_id,
$a_my_id,
$session_id,
false,
false
);
} else {
// "Left green cross" extended
$total_score = self::get_avg_student_score(
$user_id,
$course_id,
$a_my_id,
$session_id,
false,
true
);
}
} else {
// Extend all "left green cross"
$total_score = self::get_avg_student_score(
$user_id,
$course_id,
[$lp_id],
$session_id,
false,
false
);
}
$total_time = learnpathItem::getScormTimeFromParameter('js', $total_time);
$total_time = str_replace('NaN', '00'.$h.'00\'00"', $total_time);
if (!$is_allowed_to_edit && $result_disabled_ext_all) {
$final_score = Display::return_icon('invisible.png', get_lang('Results hidden by the exercise setting'));
$finalScoreToCsv = get_lang('Results hidden by the exercise setting');
} else {
if (is_numeric($total_score)) {
$final_score = $total_score.'%';
} else {
$final_score = $total_score;
}
$finalScoreToCsv = $final_score;
}
$progress = learnpath::getProgress($lp_id, $user_id, $course_id, $session_id);
$oddclass = 'row_even';
if (($counter % 2) == 0) {
$oddclass = 'row_odd';
}
$action = null;
if ($type === 'classic') {
$action = ' | ';
}
$timeTotal = ''.$total_time.'';
if ($hideTime) {
$timeTotal = '';
}
$output .= ' |
|
'.get_lang('Total of completed learning objects').'
|
'.$progress.'% |
'.$final_score.' |
'.$timeTotal.'
'.$action.'
';
$output .= '