courseLog.php 16 KB

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