courseLog.php 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * @package chamilo.tracking
  5. */
  6. /* INIT SECTION */
  7. $pathopen = isset($_REQUEST['pathopen']) ? $_REQUEST['pathopen'] : null;
  8. // Language files that need to be included.
  9. $language_file = array('admin', 'tracking', 'scorm', 'exercice');
  10. // Including the global initialization file
  11. require_once '../inc/global.inc.php';
  12. $current_course_tool = TOOL_TRACKING;
  13. $course_info = api_get_course_info(api_get_course_id());
  14. if (!empty($course_info)) {
  15. //api_protect_course_script();
  16. }
  17. $from_myspace = false;
  18. $from = isset($_GET['from']) ? $_GET['from'] : null;
  19. // Starting the output buffering when we are exporting the information.
  20. $export_csv = isset($_GET['export']) && $_GET['export'] == 'csv' ? true : false;
  21. $session_id = intval($_REQUEST['id_session']);
  22. if ($from == 'myspace') {
  23. $from_myspace = true;
  24. $this_section = "session_my_space";
  25. } else {
  26. $this_section = SECTION_COURSES;
  27. }
  28. // Access restrictions.
  29. $is_allowedToTrack = api_is_platform_admin() || api_is_allowed_to_create_course() || api_is_session_admin() || api_is_drh() || api_is_course_tutor();
  30. if (!$is_allowedToTrack) {
  31. api_not_allowed(true);
  32. exit;
  33. }
  34. if (api_is_drh()) {
  35. // Blocking course for drh
  36. if (api_drh_can_access_all_session_content()) {
  37. $coursesFromSession = SessionManager::getAllCoursesFromAllSessionFromDrh(api_get_user_id());
  38. $coursesFollowedList = CourseManager::get_courses_followed_by_drh(api_get_user_id());
  39. $coursesFollowedList = array_keys($coursesFollowedList);
  40. if (!in_array(api_get_course_id(), $coursesFollowedList)) {
  41. if (!in_array(api_get_course_id(), $coursesFromSession)) {
  42. api_not_allowed();
  43. }
  44. }
  45. } else {
  46. $coursesFollowedList = CourseManager::get_courses_followed_by_drh(api_get_user_id());
  47. $coursesFollowedList = array_keys($coursesFollowedList);
  48. if (!in_array(api_get_course_id(), $coursesFollowedList)) {
  49. api_not_allowed(true);
  50. exit;
  51. }
  52. }
  53. }
  54. // Including additional libraries.
  55. require_once api_get_path(SYS_CODE_PATH).'newscorm/learnpath.class.php';
  56. require_once api_get_path(SYS_CODE_PATH).'newscorm/learnpathItem.class.php';
  57. require_once api_get_path(SYS_CODE_PATH).'newscorm/learnpathList.class.php';
  58. require_once api_get_path(SYS_CODE_PATH).'newscorm/scorm.class.php';
  59. require_once api_get_path(SYS_CODE_PATH).'newscorm/scormItem.class.php';
  60. require_once api_get_path(LIBRARY_PATH).'export.lib.inc.php';
  61. require_once api_get_path(LIBRARY_PATH).'statsUtils.lib.inc.php';
  62. require_once api_get_path(SYS_CODE_PATH).'resourcelinker/resourcelinker.inc.php';
  63. require_once api_get_path(SYS_CODE_PATH).'survey/survey.lib.php';
  64. require_once api_get_path(SYS_CODE_PATH).'exercice/exercise.lib.php';
  65. if ($export_csv) {
  66. if (!empty($session_id)) {
  67. $_SESSION['id_session'] = $session_id;
  68. }
  69. ob_start();
  70. }
  71. $csv_content = array();
  72. // Scripts for reporting array hide/show columns
  73. $js = "<script>
  74. // hide column and display the button to unhide it
  75. function foldup(in_id) {
  76. $('#reporting_table .data_table tr td:nth-child('+in_id+')').fadeToggle();
  77. $('#reporting_table .data_table tr th:nth-child('+in_id+')').fadeToggle();
  78. $('div#unhideButtons span:nth-child('+in_id+')').fadeToggle();
  79. }
  80. // add the red cross on top of each column
  81. function init_hide() {
  82. $('div#reporting_table table tr th').each(
  83. function(index) {
  84. num_index = index + 1;
  85. // $(this).prepend('<div style=\"cursor:pointer\" onclick=\"foldup('+num_index+')\">".Display :: return_icon('visible.png', get_lang('HideColumn'), array('align' => 'absmiddle', 'hspace' => '3px'), 22)."</div>');
  86. }
  87. );
  88. }
  89. // hide some column at startup
  90. // be sure that these columns always exists
  91. // see tab_table_header = array(); // tab of header texts
  92. $(document).ready( function() {
  93. //init_hide();
  94. foldup(1);
  95. foldup(9);
  96. foldup(10);
  97. foldup(11);
  98. foldup(12);
  99. })
  100. </script>";
  101. $htmlHeadXtra[] = "<style type='text/css'>
  102. .secLine {background-color : #E6E6E6;}
  103. .content {padding-left : 15px;padding-right : 15px; }
  104. .specialLink{color : #0000FF;}
  105. /* Style for reporting array hide/show columns */
  106. .unhide_button {
  107. cursor : pointer;
  108. border:1px solid black;
  109. background-color: #FAFAFA;
  110. padding: 5px;
  111. border-radius : 3px;
  112. margin-right:3px;
  113. }
  114. div#reporting_table table th {
  115. vertical-align:top;
  116. }
  117. </style>";
  118. $htmlHeadXtra[] .= $js;
  119. // Database table definitions.
  120. //@todo remove this calls
  121. $TABLETRACK_ACCESS = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_LASTACCESS);
  122. $TABLETRACK_LINKS = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_LINKS);
  123. $TABLETRACK_DOWNLOADS = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_DOWNLOADS);
  124. $TABLETRACK_ACCESS_2 = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_ACCESS);
  125. $TABLETRACK_EXERCISES = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_EXERCICES);
  126. $TABLECOURSUSER = Database::get_main_table(TABLE_MAIN_COURSE_USER);
  127. $TABLECOURSE = Database::get_main_table(TABLE_MAIN_COURSE);
  128. $table_user = Database::get_main_table(TABLE_MAIN_USER);
  129. $TABLEQUIZ = Database::get_course_table(TABLE_QUIZ_TEST);
  130. // Breadcrumbs.
  131. if (isset($_GET['origin']) && $_GET['origin'] == 'resume_session') {
  132. $interbreadcrumb[] = array('url' => '../admin/index.php','name' => get_lang('PlatformAdmin'));
  133. $interbreadcrumb[] = array('url' => '../admin/session_list.php','name' => get_lang('SessionList'));
  134. $interbreadcrumb[] = array('url' => '../admin/resume_session.php?id_session='.api_get_session_id(), 'name' => get_lang('SessionOverview'));
  135. }
  136. $view = (isset($_REQUEST['view']) ? $_REQUEST['view'] : '');
  137. $nameTools = get_lang('Tracking');
  138. // Display the header.
  139. Display::display_header($nameTools, 'Tracking');
  140. // getting all the students of the course
  141. if (empty($session_id)) {
  142. // Registered students in a course outside session.
  143. $a_students = CourseManager :: get_student_list_from_course_code(api_get_course_id());
  144. } else {
  145. // Registered students in session.
  146. $a_students = CourseManager :: get_student_list_from_course_code(api_get_course_id(), true, api_get_session_id());
  147. }
  148. $nbStudents = count($a_students);
  149. // Getting all the additional information of an additional profile field.
  150. if (isset($_GET['additional_profile_field']) && is_numeric($_GET['additional_profile_field'])) {
  151. $user_array = array();
  152. foreach ($a_students as $key => $item) {
  153. $user_array[] = $key;
  154. }
  155. // Fetching only the user that are loaded NOT ALL user in the portal.
  156. $additional_user_profile_info = TrackingCourseLog::get_addtional_profile_information_of_field_by_user($_GET['additional_profile_field'],$user_array);
  157. $extra_info = UserManager::get_extra_field_information($_GET['additional_profile_field']);
  158. }
  159. /* MAIN CODE */
  160. echo '<div class="actions">';
  161. echo Display::return_icon('user_na.png', get_lang('StudentsTracking'), array(), 32);
  162. echo Display::url(Display::return_icon('course.png', get_lang('CourseTracking'), array(), 32), 'course_log_tools.php?'.api_get_cidreq());
  163. echo Display::url(Display::return_icon('tools.png', get_lang('ResourcesTracking'), array(), 32), 'course_log_resources.php?'.api_get_cidreq());
  164. echo Display::url(Display::return_icon('quiz.png', get_lang('ExamTracking'), array(), 32), api_get_path(WEB_CODE_PATH).'tracking/exams.php?'.api_get_cidreq());
  165. echo '<span style="float:right; padding-top:0px;">';
  166. echo '<a href="javascript: void(0);" onclick="javascript: window.print();">'.Display::return_icon('printer.png', get_lang('Print'),'',ICON_SIZE_MEDIUM).'</a>';
  167. $addional_param = '';
  168. if (isset($_GET['additional_profile_field'])) {
  169. $addional_param ='additional_profile_field='.intval($_GET['additional_profile_field']);
  170. }
  171. $users_tracking_per_page = '';
  172. if (isset($_GET['users_tracking_per_page'])) {
  173. $users_tracking_per_page= '&users_tracking_per_page='.intval($_GET['users_tracking_per_page']);
  174. }
  175. echo '<a href="'.api_get_self().'?'.api_get_cidreq().'&export=csv&'.$addional_param.$users_tracking_per_page.'">
  176. '.Display::return_icon('export_csv.png', get_lang('ExportAsCSV'),'',ICON_SIZE_MEDIUM).'</a>';
  177. echo '</span>';
  178. echo '</div>';
  179. echo '<div class="actions">';
  180. // Create a search-box.
  181. $form_search = new FormValidator('search_simple', 'GET', api_get_path(WEB_CODE_PATH).'tracking/courseLog.php?'.api_get_cidreq(), '', array('class' => 'form-search'), false);
  182. $renderer = $form_search->defaultRenderer();
  183. $renderer->setElementTemplate('<span>{element}</span>');
  184. $form_search->addElement('hidden', 'from', Security::remove_XSS($from));
  185. $form_search->addElement('hidden', 'session_id', api_get_session_id());
  186. $form_search->addElement('text', 'user_keyword');
  187. $form_search->addElement('style_submit_button', 'submit', get_lang('SearchUsers'), 'class="search"');
  188. $form_search->display();
  189. echo '</div>';
  190. // BEGIN : form to remind inactive users
  191. if (count($a_students) > 0) {
  192. $form = new FormValidator('reminder_form', 'get', api_get_path(REL_CODE_PATH).'announcements/announcements.php');
  193. $renderer = $form->defaultRenderer();
  194. $renderer->setElementTemplate('<span>{label} {element}</span>&nbsp;<button class="save" type="submit">'.get_lang('SendNotification').'</button>','since');
  195. $options = array (
  196. 2 => '2 '.get_lang('Days'),
  197. 3 => '3 '.get_lang('Days'),
  198. 4 => '4 '.get_lang('Days'),
  199. 5 => '5 '.get_lang('Days'),
  200. 6 => '6 '.get_lang('Days'),
  201. 7 => '7 '.get_lang('Days'),
  202. 15 => '15 '.get_lang('Days'),
  203. 30 => '30 '.get_lang('Days'),
  204. 'never' => get_lang('Never')
  205. );
  206. $el = $form -> addElement('select', 'since', '<img width="ICON_SIZE_SMALL" align="middle" src="'.api_get_path(WEB_IMG_PATH).'messagebox_warning.gif" border="0" />'.get_lang('RemindInactivesLearnersSince'), $options);
  207. $el -> setSelected(7);
  208. $form->addElement('hidden', 'action', 'add');
  209. $form->addElement('hidden', 'remindallinactives', 'true');
  210. $course_name = get_lang('Course').' '.$course_info['name'];
  211. if ($session_id) {
  212. echo Display::page_subheader(Display::return_icon('session.png', get_lang('Session'), array(), ICON_SIZE_SMALL).' '.api_get_session_name($session_id).' '.
  213. Display::return_icon('course.png', get_lang('Course'), array(), ICON_SIZE_SMALL).' '.$course_name);
  214. } else {
  215. echo Display::page_subheader(Display::return_icon('course.png', get_lang('Course'), array(), ICON_SIZE_SMALL).' '.$course_info['name']);
  216. }
  217. $extra_field_select = TrackingCourseLog::display_additional_profile_fields();
  218. if (!empty($extra_field_select)) {
  219. echo $extra_field_select;
  220. }
  221. $form->display();
  222. //PERSON_NAME_DATA_EXPORT is buggy
  223. $is_western_name_order = api_is_western_name_order();
  224. if ($export_csv) {
  225. $csv_content = array();
  226. //override the SortableTable "per page" limit if CSV
  227. $_GET['users_tracking_per_page'] = 1000000;
  228. }
  229. $all_datas = array();
  230. $course_code = $_course['id'];
  231. $user_ids = array_keys($a_students);
  232. $table = new SortableTable('users_tracking', array('TrackingCourseLog', 'get_number_of_users'), array('TrackingCourseLog', 'get_user_data'), (api_is_western_name_order() xor api_sort_by_first_name()) ? 3 : 2);
  233. $parameters['cidReq'] = Security::remove_XSS($_GET['cidReq']);
  234. $parameters['id_session'] = $session_id;
  235. $parameters['from'] = isset($_GET['myspace']) ? Security::remove_XSS($_GET['myspace']) : null;
  236. $table->set_additional_parameters($parameters);
  237. $tab_table_header = array(); // tab of header texts
  238. $table->set_header(0, get_lang('OfficialCode'), true);
  239. $tab_table_header[] = get_lang('OfficialCode');
  240. if ($is_western_name_order) {
  241. $table->set_header(1, get_lang('FirstName'), true);
  242. $tab_table_header[] = get_lang('FirstName');
  243. $table->set_header(2, get_lang('LastName'), true);
  244. $tab_table_header[] = get_lang('LastName');
  245. } else {
  246. $table->set_header(1, get_lang('LastName'), true);
  247. $tab_table_header[] = get_lang('LastName');
  248. $table->set_header(2, get_lang('FirstName'), true);
  249. $tab_table_header[] = get_lang('FirstName');
  250. }
  251. $table->set_header(3, get_lang('Login'), false);
  252. $tab_table_header[] = get_lang('Login');
  253. $table->set_header(4, get_lang('TrainingTime'), false);
  254. $tab_table_header[] = get_lang('TrainingTime');
  255. $table->set_header(5, get_lang('CourseProgress').'&nbsp;'.Display::return_icon('info3.gif', get_lang('ScormAndLPProgressTotalAverage'), array('align' => 'absmiddle', 'hspace' => '3px')), false, array('style' => 'width:110px;'));
  256. $tab_table_header[] = get_lang('CourseProgress');
  257. $table->set_header(6, get_lang('ExerciseProgress'), false);
  258. $tab_table_header[] = get_lang('ExerciseProgress');
  259. $table->set_header(7, get_lang('ExerciseAverage'), false);
  260. $tab_table_header[] = get_lang('ExerciseAverage');
  261. $table->set_header(8, get_lang('Score').'&nbsp;'.Display::return_icon('info3.gif', get_lang('ScormAndLPTestTotalAverage'), array('align' => 'absmiddle', 'hspace' => '3px')), false, array('style' => 'width:110px;'));
  262. $tab_table_header[] = get_lang('Score');
  263. $table->set_header(9, get_lang('Student_publication'), false);
  264. $tab_table_header[] = get_lang('Student_publication');
  265. $table->set_header(10, get_lang('Messages'), false);
  266. $tab_table_header[] = get_lang('Messages');
  267. if (empty($session_id)) {
  268. $table->set_header(11, get_lang('Survey'), false);
  269. $tab_table_header[] = get_lang('Survey');
  270. $table->set_header(12, get_lang('FirstLogin'), false);
  271. $tab_table_header[] = get_lang('FirstLogin');
  272. $table->set_header(13, get_lang('LatestLogin'), false);
  273. $tab_table_header[] = get_lang('LatestLogin');
  274. if (isset($_GET['additional_profile_field']) AND is_numeric($_GET['additional_profile_field'])) {
  275. $table->set_header(14, $extra_info['field_display_text'], false);
  276. $tab_table_header[] = $extra_info['field_display_text'];
  277. $table->set_header(15, get_lang('Details'), false);
  278. $tab_table_header[] = get_lang('Details');
  279. } else {
  280. $table->set_header(14, get_lang('Details'), false);
  281. $tab_table_header[] = get_lang('Details');
  282. }
  283. } else {
  284. $table->set_header(11, get_lang('FirstLogin'), false);
  285. $tab_table_header[] = get_lang('FirstLogin');
  286. $table->set_header(12, get_lang('LatestLogin'), false);
  287. $tab_table_header[] = get_lang('LatestLogin');
  288. if (isset($_GET['additional_profile_field']) AND is_numeric($_GET['additional_profile_field'])) {
  289. $table->set_header(13, $extra_info['field_display_text'], false);
  290. $tab_table_header[] = $extra_info['field_display_text'];
  291. $table->set_header(14, get_lang('Details'), false);
  292. $tab_table_header[] = get_lang('Details');
  293. } else {
  294. $table->set_header(13, get_lang('Details'), false);
  295. $tab_table_header[] = get_lang('Details');
  296. }
  297. }
  298. // display buttons to un hide hidden columns
  299. echo "<br/><br/><div id='unhideButtons'>";
  300. for ($i=0; $i < count($tab_table_header); $i++) {
  301. $index = $i + 1;
  302. echo "<span title='".get_lang('DisplayColumn')." ".$tab_table_header[$i]."' class='unhide_button hide' onclick='foldup($index)'>".Display :: return_icon('move.png', get_lang('DisplayColumn'), array('align'=>'absmiddle', 'hspace'=>'3px'), 16)." ".$tab_table_header[$i]."</span>";
  303. }
  304. echo "</div>";
  305. // display the table
  306. echo "<div id='reporting_table'>";
  307. $table->display();
  308. echo "</div>";
  309. } else {
  310. echo Display::display_warning_message(get_lang('NoUsersInCourse'));
  311. }
  312. // Send the csv file if asked.
  313. if ($export_csv) {
  314. $csv_headers = array();
  315. $csv_headers[] = get_lang('OfficialCode', '');
  316. if ($is_western_name_order) {
  317. $csv_headers[] = get_lang('FirstName', '');
  318. $csv_headers[] = get_lang('LastName', '');
  319. } else {
  320. $csv_headers[] = get_lang('LastName', '');
  321. $csv_headers[] = get_lang('FirstName', '');
  322. }
  323. $csv_headers[] = get_lang('Login', ''); //
  324. $csv_headers[] = get_lang('TrainingTime', '');
  325. $csv_headers[] = get_lang('CourseProgress', '');
  326. $csv_headers[] = get_lang('ExerciseProgress', '');
  327. $csv_headers[] = get_lang('ExerciseAverage', '');
  328. $csv_headers[] = get_lang('Score', '');
  329. $csv_headers[] = get_lang('Student_publication', '');
  330. $csv_headers[] = get_lang('Messages', '');
  331. if (empty($session_id)) {
  332. $csv_headers[] = get_lang('Survey');
  333. }
  334. $csv_headers[] = get_lang('FirstLogin', '');
  335. $csv_headers[] = get_lang('LatestLogin', '');
  336. if (isset($_GET['additional_profile_field']) AND is_numeric($_GET['additional_profile_field'])) {
  337. $csv_headers[] = $extra_info['field_display_text'];
  338. }
  339. ob_end_clean();
  340. array_unshift($csv_content, $csv_headers); // Adding headers before the content.
  341. Export::export_table_csv($csv_content, 'reporting_student_list');
  342. exit;
  343. }
  344. Display::display_footer();