'../session/index.php','name' => get_lang('PlatformAdmin'));
$interbreadcrumb[] = array('url' => '../session/session_list.php','name' => get_lang('SessionList'));
$interbreadcrumb[] = array('url' => '../session/resume_session.php?id_session='.api_get_session_id(), 'name' => get_lang('SessionOverview'));
}
$view = (isset($_REQUEST['view']) ? $_REQUEST['view'] : '');
$nameTools = get_lang('Tracking');
// Display the header.
Display::display_header($nameTools, 'Tracking');
// getting all the students of the course
if (empty($session_id)) {
// Registered students in a course outside session.
$a_students = CourseManager :: get_student_list_from_course_code(api_get_course_int_id(), false, 0, api_get_group_id());
} else {
// Registered students in session.
$a_students = CourseManager :: get_student_list_from_course_code(api_get_course_int_id(), true, api_get_session_id());
}
$nbStudents = count($a_students);
/* MAIN CODE */
echo '';
echo Display::url(Display::return_icon('user.png', get_lang('StudentsTracking'), array(), 32), 'courseLog.php?'.api_get_cidreq());
if (empty($group_id)) {
echo Display::url(Display::return_icon('group.png', get_lang('GroupReporting'), array(), 32), 'course_log_groups.php?'.api_get_cidreq());
echo Display::url(Display::return_icon('course_na.png', get_lang('CourseTracking'), array(), 32), '#');
} else {
echo Display::url(Display::return_icon('group_na.png', get_lang('GroupReporting'), array(), 32), '#');
echo Display::url(Display::return_icon('course.png', get_lang('CourseTracking'), array(), 32), 'course_log_tools.php?'.api_get_cidreq(true, false).'&gidReq=0');
}
echo Display::url(Display::return_icon('tools.png', get_lang('ResourcesTracking'), array(), 32), 'course_log_resources.php?'.api_get_cidreq());
echo '
';
echo ''.Display::return_icon('printer.png', get_lang('Print'),'',ICON_SIZE_MEDIUM).'';
echo '
'.Display::return_icon('export_csv.png', get_lang('ExportAsCSV'),'',ICON_SIZE_MEDIUM).'';
echo '';
echo '
'.Display::page_subheader2(Display::return_icon('scorms.gif',get_lang('AverageProgressInLearnpath')).get_lang('AverageProgressInLearnpath')).'
';
if ($export_csv) {
$temp = array(get_lang('AverageProgressInLearnpath', ''), '');
$csv_content[] = array('', '');
$csv_content[] = $temp;
}
foreach ($flat_list as $lp_id => $lp) {
$lp_avg_progress = 0;
foreach ($a_students as $student_id => $student) {
// get the progress in learning pathes
$lp_avg_progress += Tracking::get_avg_student_progress($student_id, $courseId, array($lp_id), $session_id);
}
if ($nbStudents > 0) {
$lp_avg_progress = $lp_avg_progress / $nbStudents;
} else {
$lp_avg_progress = null;
}
// Separated presentation logic.
if (is_null($lp_avg_progress)) {
$lp_avg_progress = '0%';
} else {
$lp_avg_progress = round($lp_avg_progress, 1).'%';
}
echo '| '.$lp['lp_name'].' | '.$lp_avg_progress.' |
';
if ($export_csv) {
$temp = array($lp['lp_name'], $lp_avg_progress);
$csv_content[] = $temp;
}
}
echo '
'.Display::page_subheader2(Display::return_icon('quiz.gif',get_lang('AverageResultsToTheExercices')).get_lang('AverageResultsToTheExercices')).'
';
$course_id = api_get_course_int_id();
//@todo user $exercise = new Exercise($course_id);
$sql = "SELECT id, title FROM $TABLEQUIZ
WHERE c_id = $course_id AND active <> -1 AND session_id = $session_id";
$rs = Database::query($sql);
if ($export_csv) {
$temp = array(get_lang('AverageProgressInLearnpath'), '');
$csv_content[] = array('', '');
$csv_content[] = $temp;
}
$course_path_params = '&cidReq='.$course_code.'&id_session='.$session_id;
if (Database::num_rows($rs) > 0) {
$student_ids = array_keys($a_students);
$count_students = count($student_ids);
while ($quiz = Database::fetch_array($rs)) {
$quiz_avg_score = 0;
if ($count_students > 0) {
foreach ($student_ids as $student_id) {
$avg_student_score = Tracking::get_avg_student_exercise_score($student_id, $course_id, $quiz['id'], $session_id);
$quiz_avg_score += $avg_student_score;
}
}
$count_students = ($count_students == 0 || is_null($count_students) || $count_students == '') ? 1 : $count_students;
$quiz_avg_score = round(($quiz_avg_score / $count_students), 2).'%';
$url = api_get_path(WEB_CODE_PATH).'exercice/overview.php?exerciseId='.$quiz['id'].$course_path_params;
echo '| '.Display::url($quiz['title'], $url).' | '.$quiz_avg_score.' |
';
if ($export_csv) {
$temp = array($quiz['title'], $quiz_avg_score);
$csv_content[] = $temp;
}
}
} else {
echo '| '.get_lang('NoExercises').' |
';
if ($export_csv) {
$temp = array(get_lang('NoExercises', ''), '');
$csv_content[] = $temp;
}
}
echo '
'.Display::page_subheader2(Display::return_icon('forum.gif', get_lang('Forum')).get_lang('Forum').' -
'.get_lang('SeeDetail').'').
'
';
$filter_by_users = array();
if (!empty($group_id)) {
$filter_by_users = $student_ids;
}
$count_number_of_posts_by_course = Tracking :: count_number_of_posts_by_course($course_code, $session_id, $filter_by_users);
$count_number_of_forums_by_course = 0;
if (empty($group_id)) {
$count_number_of_forums_by_course = Tracking :: count_number_of_forums_by_course($course_code, $session_id, $filter_by_users);
}
$count_number_of_threads_by_course = Tracking :: count_number_of_threads_by_course($course_code, $session_id, $filter_by_users);
if ($export_csv) {
$csv_content[] = array(get_lang('Forum'), '');
if (empty($group_id)) {
$csv_content[] = array(get_lang('ForumForumsNumber', ''), $count_number_of_forums_by_course);
}
$csv_content[] = array(get_lang('ForumThreadsNumber', ''), $count_number_of_threads_by_course);
$csv_content[] = array(get_lang('ForumPostsNumber', ''), $count_number_of_posts_by_course);
}
if (empty($group_id)) {
echo '| '.get_lang('ForumForumsNumber').' | '.$count_number_of_forums_by_course.' |
';
}
echo '| '.get_lang('ForumThreadsNumber').' | '.$count_number_of_threads_by_course.' |
';
echo '| '.get_lang('ForumPostsNumber').' | '.$count_number_of_posts_by_course.' |
';
echo '
'.Display::page_subheader2(Display::return_icon('chat.gif',get_lang('Chat')).get_lang('Chat')).'
';
$chat_connections_during_last_x_days_by_course = Tracking::chat_connections_during_last_x_days_by_course($courseId, 7, $session_id, $filter_by_users);
if ($export_csv) {
$csv_content[] = array(get_lang('Chat', ''), '');
$csv_content[] = array(sprintf(get_lang('ChatConnectionsDuringLastXDays', ''), '7'), $chat_connections_during_last_x_days_by_course);
}
echo '| '.sprintf(get_lang('ChatConnectionsDuringLastXDays'), '7').' | '.$chat_connections_during_last_x_days_by_course.' |
';
echo '
'.Display::page_subheader2(Display::return_icon('acces_tool.gif', get_lang('ToolsMostUsed')).get_lang('ToolsMostUsed')).'
';
$tools_most_used = Tracking::get_tools_most_used_by_course($courseId, $session_id, $filter_by_users);
if ($export_csv) {
$temp = array(get_lang('ToolsMostUsed'), '');
$csv_content[] = $temp;
}
if (!empty($tools_most_used)) {
foreach ($tools_most_used as $row) {
echo '
| '.get_lang(ucfirst($row['access_tool'])).' |
'.$row['count_access_tool'].' '.get_lang('Clicks').' |
';
if ($export_csv) {
$temp = array(get_lang(ucfirst($row['access_tool']), ''), $row['count_access_tool'].' '.get_lang('Clicks', ''));
$csv_content[] = $temp;
}
}
}
echo '
'.Display::page_subheader2(Display::return_icon('documents.gif',get_lang('DocumentsMostDownloaded')).' '.get_lang('DocumentsMostDownloaded').$link).'
';
//No group id
$documents_most_downloaded = Tracking::get_documents_most_downloaded_by_course($courseId, $session_id, $num, $filter_by_users);
if ($export_csv) {
$temp = array(get_lang('DocumentsMostDownloaded', ''), '');
$csv_content[] = array('', '');
$csv_content[] = $temp;
}
if (!empty($documents_most_downloaded)) {
foreach ($documents_most_downloaded as $row) {
echo '
| '.Display::url($row['down_doc_path'], api_get_path(WEB_CODE_PATH).'document/show_content.php?file='.$row['down_doc_path'].$course_path_params).' |
'.$row['count_down'].' '.get_lang('Clicks').' |
';
if ($export_csv) {
$temp = array($row['down_doc_path'], $row['count_down'].' '.get_lang('Clicks', ''));
$csv_content[] = $temp;
}
}
} else {
echo '| '.get_lang('NoDocumentDownloaded').' |
';
if ($export_csv) {
$temp = array(get_lang('NoDocumentDownloaded', ''), '');
$csv_content[] = $temp;
}
}
echo '
'.Display::page_subheader2(Display::return_icon('link.gif',get_lang('LinksMostClicked')).' '.get_lang('LinksMostClicked')).'
';
$links_most_visited = Tracking::get_links_most_visited_by_course($courseId, $session_id, $filter_by_users);
if ($export_csv) {
$temp = array(get_lang('LinksMostClicked'), '');
$csv_content[] = array('', '');
$csv_content[] = $temp;
}
if (!empty($links_most_visited)) {
foreach ($links_most_visited as $row) {
echo '
| '.Display::url($row['title'].' ('.$row['url'].')', $row['url']).' |
'.$row['count_visits'].' '.get_lang('Clicks').' |
';
if ($export_csv){
$temp = array($row['title'], $row['count_visits'].' '.get_lang('Clicks', ''));
$csv_content[] = $temp;
}
}
} else {
echo '| '.get_lang('NoLinkVisited').' |
';
if ($export_csv) {
$temp = array(get_lang('NoLinkVisited'), '');
$csv_content[] = $temp;
}
}
echo '