$table->set_header(6, get_lang('Student_publication'), false);
$table->set_header(7, get_lang('Messages'), false);
$table->set_header(8, get_lang('FirstLogin'), false, 'align="center"');
$table->set_header(9, get_lang('LatestLogin'), false, 'align="center"');
$table->set_header(10, get_lang('Details'), false);
if ($export_csv) {
$csv_content[] = array();
}
$all_datas = array();
$course_code = $_course['id'];
foreach ($a_students as $student_id => $student) {
$student_datas = UserManager::get_user_info_by_id($student_id);
$avg_time_spent = $avg_student_score = $avg_student_progress = $total_assignments = $total_messages = 0;
$nb_courses_student = 0;
$avg_time_spent = Tracking::get_time_spent_on_the_course($student_id, $course_code);
$avg_student_score = Tracking::get_average_test_scorm_and_lp($student_id, $course_code);
$avg_student_progress = Tracking::get_avg_student_progress($student_id, $course_code);
$total_assignments = Tracking::count_student_assignments($student_id, $course_code);
$total_messages = Tracking::count_student_messages($student_id, $course_code);
$row = array();
$row[] = $student_datas['official_code'];
$row[] = $student_datas['lastname'];
$row[] = $student_datas['firstname'];
$row[] = api_time_to_hms($avg_time_spent);
if (is_null($avg_student_score)) {
$avg_student_score = 0;
}
if (is_null($avg_student_progress)) {
$avg_student_progress = 0;
}
$row[] = $avg_student_progress . ' %';
$a_courses[$row['course_code']] = $row['course_code'];
}
// get the list of sessions where the user is subscribed as student
$sql = 'SELECT DISTINCT course_code FROM ' . Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER) . ' WHERE id_user='******'user_id']);
$rs = api_sql_query($sql, __FILE__, __LINE__);
while ($row = Database::fetch_array($rs)) {
$a_courses[$row['course_code']] = $row['course_code'];
}
$course_id = Security::remove_XSS($_GET['course']);
if (!CourseManager::is_user_subscribed_in_course($a_infosUser['user_id'], $course_id, true)) {
unset($a_courses[$key]);
} else {
$nb_courses++;
$avg_student_progress = Tracking::get_avg_student_progress($a_infosUser['user_id'], $course_id);
//the score inside the Reporting table
$avg_student_score = Tracking::get_average_test_scorm_and_lp($a_infosUser['user_id'], $course_id);
}
$avg_student_progress = round($avg_student_progress, 2);
$avg_student_score = round($avg_student_score, 2);
$first_connection_date = Tracking::get_first_connection_date($a_infosUser['user_id']);
if ($first_connection_date == '') {
$first_connection_date = get_lang('NoConnexion');
}
$last_connection_date = Tracking::get_last_connection_date($a_infosUser['user_id'], true);
if ($last_connection_date == '') {
$last_connection_date = get_lang('NoConnexion');
}
$time_spent_on_the_course = api_time_to_hms(Tracking::get_time_spent_on_the_course($a_infosUser['user_id'], $course_id));
// cvs informations
$csv_content[] = array(get_lang('Informations'));
$csv_content[] = array(get_lang('Name'), get_lang('Email'), get_lang('Tel'));
