echo '<div class="report_section"> ' . Display::page_subheader2(Display::return_icon('chat.gif', get_lang('Chat')) . get_lang('Chat')) . ' <table class="data_table">'; $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 '<tr><td>' . sprintf(get_lang('ChatConnectionsDuringLastXDays'), '7') . '</td><td align="right">' . $chat_connections_during_last_x_days_by_course . '</td></tr>'; echo '</table></div>'; echo '<div class="clear"></div>'; // Tools tracking. echo '<div class="report_section"> ' . Display::page_subheader2(Display::return_icon('acces_tool.gif', get_lang('ToolsMostUsed')) . get_lang('ToolsMostUsed')) . ' <table class="data_table">'; $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 ' <tr> <td>' . get_lang(ucfirst($row['access_tool'])) . '</td> <td align="right">' . $row['count_access_tool'] . ' ' . get_lang('Clicks') . '</td> </tr>'; if ($export_csv) { $temp = array(get_lang(ucfirst($row['access_tool']), ''), $row['count_access_tool'] . ' ' . get_lang('Clicks', '')); $csv_content[] = $temp; } }
$tmp_students = CourseManager::get_student_list_from_course_code($course_code, false); //Cleaning students only REAL students $students = array(); foreach ($tmp_students as $student) { $user_info = api_get_user_info($student['user_id']); if ($user_info['status'] != STUDENT) { continue; } $students[] = $student['user_id']; } $t_lp = Database::get_course_table(TABLE_LP_MAIN); $sql_lp = "SELECT lp.name, lp.id FROM {$t_lp} lp WHERE c_id = {$course_id} AND lp.session_id = 0"; $rs_lp = Database::query($sql_lp); $t_lpi = Database::get_course_table(TABLE_LP_ITEM); $t_news = Database::get_course_table(TABLE_ANNOUNCEMENT); $total_tools_list = Tracking::get_tools_most_used_by_course($course_id, $session_id); $total_tools = 0; foreach ($total_tools_list as $tool) { $total_tools += $tool['count_access_tool']; } if (Database::num_rows($rs_lp) > 0) { while ($learnpath = Database::fetch_array($rs_lp)) { $lp_id = $learnpath['id']; $lp_items = $array[$i]['lp'] = '<a href="' . api_get_path(WEB_CODE_PATH) . 'newscorm/lp_controller.php?cidReq=' . $course_code . '&action=view&lp_id=' . $lp_id . '" target="_blank">' . $learnpath['name'] . '</a>'; $array[$i]['teachers'] = ''; if (!empty($teacher_list)) { $array[$i]['teachers'] = implode(', ', $teacher_list); } $array[$i]['course_name'] = $course['title']; $count_students_accessing = 0; $count_students_complete_all_activities = 0;
$chat_connections_during_last_x_days_by_course = Tracking::chat_connections_during_last_x_days_by_course($course_code, 7, $session_id); 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 '<tr><td>'.sprintf(get_lang('ChatConnectionsDuringLastXDays'), '7').'</td><td align="right">'.$chat_connections_during_last_x_days_by_course.'</td></tr>'; echo '</table></div>'; echo '<div class="clear"></div>'; // Tools tracking. echo '<div class="report_section"> '.Display::page_subheader(Display::return_icon('acces_tool.gif', get_lang('ToolsMostUsed')).get_lang('ToolsMostUsed')).' <table class="data_table">'; $tools_most_used = Tracking::get_tools_most_used_by_course($course_code, $session_id); if ($export_csv) { $temp = array(get_lang('ToolsMostUsed'), ''); $csv_content[] = $temp; } if (!empty($tools_most_used)) { foreach ($tools_most_used as $row) { echo ' <tr> <td>'.get_lang(ucfirst($row['access_tool'])).'</td> <td align="right">'.$row['count_access_tool'].' '.get_lang('Clicks').'</td> </tr>'; if ($export_csv) { $temp = array(get_lang(ucfirst($row['access_tool']), ''), $row['count_access_tool'].' '.get_lang('Clicks', '')); $csv_content[] = $temp;