myspace.lib.php 44 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090
  1. <?php
  2. require_once api_get_path(LIBRARY_PATH).'export.lib.inc.php';
  3. require_once api_get_path(LIBRARY_PATH).'tracking.lib.php';
  4. require_once api_get_path(LIBRARY_PATH).'usermanager.lib.php';
  5. require_once api_get_path(LIBRARY_PATH).'formvalidator/FormValidator.class.php';
  6. class MySpace {
  7. /* For licensing terms, see /dokeos_license.txt */
  8. /**
  9. * This function serves exporting data in CSV format.
  10. * @param array $header The header labels.
  11. * @param array $data The data array.
  12. * @param string $file_name The name of the file which contains exported data.
  13. * @return string mixed Returns a message (string) if an error occurred.
  14. */
  15. function export_csv($header, $data, $file_name = 'export.csv') {
  16. $archive_path = api_get_path(SYS_ARCHIVE_PATH);
  17. $archive_url = api_get_path(WEB_CODE_PATH).'course_info/download.php?archive=';
  18. if (!$open = fopen($archive_path.$file_name, 'w+')) {
  19. $message = get_lang('noOpen');
  20. } else {
  21. $info = '';
  22. foreach ($header as $value) {
  23. $info .= $value.';';
  24. }
  25. $info .= "\r\n";
  26. foreach ($data as $row) {
  27. foreach ($row as $value) {
  28. $info .= $value.';';
  29. }
  30. $info .= "\r\n";
  31. }
  32. fwrite($open, $info);
  33. fclose($open);
  34. @chmod($file_name, api_get_permissions_for_new_files());
  35. header("Location:".$archive_url.$file_name);
  36. }
  37. return $message;
  38. }
  39. /**
  40. * Gets the connections to a course as an array of login and logout time
  41. *
  42. * @param int User ud
  43. * @param string Course code
  44. * @param int Session id (optional, default = 0)
  45. * @return array Conections
  46. */
  47. function get_connections_to_course($user_id, $course_code, $session_id = 0) {
  48. // Database table definitions
  49. $tbl_track_course = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_COURSE_ACCESS);
  50. $tbl_main = Database :: get_main_table(TABLE_MAIN_COURSE);
  51. // protect data
  52. $user_id = intval($user_id);
  53. $course_code = Database::escape_string($course_code);
  54. $session_id = intval($session_id);
  55. $sql_query = 'SELECT visual_code as course_code FROM '.$tbl_main.' c WHERE code="'.$course_code.'";';
  56. $result = Database::query($sql_query);
  57. $row_query = Database::fetch_array($result, 'ASSOC');
  58. $course_true = isset($row_query['course_code']) ? $row_query['course_code']: $course_code;
  59. $sql = 'SELECT login_course_date, logout_course_date FROM ' . $tbl_track_course . '
  60. WHERE user_id = '.$user_id.'
  61. AND course_code="'.$course_true.'" AND session_id = '.$session_id.' ORDER BY login_course_date ASC';
  62. $rs = Database::query($sql);
  63. $connections = array();
  64. while ($row = Database::fetch_array($rs)) {
  65. $login_date = $row['login_course_date'];
  66. $logout_date = $row['logout_course_date'];
  67. $login_date = api_get_local_time($login_date, null, date_default_timezone_get());
  68. $logout_date = api_get_local_time($logout_date, null, date_default_timezone_get());
  69. $timestamp_login_date = api_strtotime($login_date);
  70. $timestamp_logout_date = api_strtotime($logout_date);
  71. $connections[] = array('login' => $timestamp_login_date, 'logout' => $timestamp_logout_date);
  72. }
  73. return $connections;
  74. }
  75. /**
  76. * TODO: Not used, to b deleted?
  77. * Enter description here...
  78. * @param int $user_id
  79. * @param string $course_code
  80. * @param date $year
  81. * @param date $month
  82. * @param date $day
  83. * @return unknown
  84. */
  85. function get_connections_to_course_by_time($user_id, $course_code, $year = '', $month = '', $day = '') {
  86. // Database table definitions
  87. $tbl_track_course = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_COURSE_ACCESS);
  88. $tbl_main = Database :: get_main_table(TABLE_MAIN_COURSE);
  89. $sql_query = 'SELECT visual_code as course_code FROM '.$tbl_main.' c WHERE code="'.Database :: escape_string($course_code).'";';
  90. $result = Database::query($sql_query);
  91. $row_query = Database::fetch_array($result,'ASSOC');
  92. $course_true = isset($row_query['course_code']) ? $row_query['course_code']: $course_code;
  93. $sql = 'SELECT login_course_date, logout_course_date FROM ' . $tbl_track_course . '
  94. WHERE user_id = ' . intval($user_id) . '
  95. AND course_code="' . Database::escape_string($course_true) . '"
  96. ORDER BY login_course_date DESC';
  97. $rs = Database::query($sql);
  98. $connections = array();
  99. while ($row = Database::fetch_array($rs)) {
  100. $login_date = $row['login_course_date'];
  101. $logout_date = $row['logout_course_date'];
  102. $timestamp_login_date = strtotime($login_date);
  103. $timestamp_logout_date = strtotime($logout_date);
  104. $connections[] = array('login' => $timestamp_login_date, 'logout' => $timestamp_logout_date);
  105. }
  106. return $connections;
  107. }
  108. /**
  109. * Creates a small table in the last column of the table with the user overview
  110. *
  111. * @param integer $user_id the id of the user
  112. * @param array $url_params additonal url parameters
  113. * @param array $row the row information (the other columns)
  114. * @return string html code
  115. */
  116. function course_info_tracking_filter($user_id, $url_params, $row) {
  117. // the table header
  118. $return .= '<table class="data_table" style="width: 100%;border:0;padding:0;border-collapse:collapse;table-layout: fixed">';
  119. /*$return .= ' <tr>';
  120. $return .= ' <th>'.get_lang('Course').'</th>';
  121. $return .= ' <th>'.get_lang('AvgTimeSpentInTheCourse').'</th>';
  122. $return .= ' <th>'.get_lang('AvgStudentsProgress').'</th>';
  123. $return .= ' <th>'.get_lang('AvgCourseScore').'</th>';
  124. $return .= ' <th>'.get_lang('AvgExercisesScore').'</th>';
  125. $return .= ' <th>'.get_lang('AvgMessages').'</th>';
  126. $return .= ' <th>'.get_lang('AvgAssignments').'</th>';
  127. $return .= ' <th>'.get_lang('TotalExercisesScoreObtained').'</th>';
  128. $return .= ' <th>'.get_lang('TotalExercisesScorePossible').'</th>';
  129. $return .= ' <th>'.get_lang('TotalExercisesAnswered').'</th>';
  130. $return .= ' <th>'.get_lang('TotalExercisesScorePercentage').'</th>';
  131. $return .= ' <th>'.get_lang('FirstLogin').'</th>';
  132. $return .= ' <th>'.get_lang('LatestLogin').'</th>';
  133. $return .= ' </tr>';*/
  134. // database table definition
  135. $tbl_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  136. // getting all the courses of the user
  137. $sql = "SELECT * FROM $tbl_course_user WHERE user_id = '".Database::escape_string($user_id)."' AND relation_type<>".COURSE_RELATION_TYPE_RRHH." ";
  138. $result = Database::query($sql);
  139. while ($row = Database::fetch_row($result)) {
  140. $return .= '<tr>';
  141. // course code
  142. $return .= ' <td width="157px" >'.cut($row[0], 20, true).'</td>';
  143. // time spent in the course
  144. $return .= ' <td><div>'.api_time_to_hms(Tracking :: get_time_spent_on_the_course($user_id, $row[0])).'</div></td>';
  145. // student progress in course
  146. $return .= ' <td><div>'.round(Tracking :: get_avg_student_progress($user_id, $row[0]), 2).'</div></td>';
  147. // student score
  148. $return .= ' <td><div>'.round(Tracking :: get_avg_student_score($user_id, $row[0]), 2).'</div></td>';
  149. // student tes score
  150. //$return .= ' <td><div style="width:40px">'.round(Tracking :: get_avg_student_exercise_score ($user_id, $row[0]),2).'%</div></td>';
  151. // student messages
  152. $return .= ' <td><div>'.Tracking :: count_student_messages($user_id, $row[0]).'</div></td>';
  153. // student assignments
  154. $return .= ' <td><div>'.Tracking :: count_student_assignments($user_id, $row[0]).'</div></td>';
  155. // student exercises results (obtained score, maximum score, number of exercises answered, score percentage)
  156. $exercises_results = MySpace::exercises_results($user_id, $row[0]);
  157. $return .= ' <td width="105px"><div>'.(is_null($exercises_results['percentage']) ? '' : $exercises_results['score_obtained'].'/'.$exercises_results['score_possible'].' ( '.$exercises_results['percentage'].'% )').'</div></td>';
  158. //$return .= ' <td><div>'.$exercises_results['score_possible'].'</div></td>';
  159. $return .= ' <td><div>'.$exercises_results['questions_answered'].'</div></td>';
  160. //$return .= ' <td><div>'.$exercises_results['percentage'].'% </div></td>';
  161. // first connection
  162. //$return .= ' <td width="60px">'.Tracking :: get_first_connection_date_on_the_course ($user_id, $row[0]).'</td>';
  163. // last connection
  164. $return .= ' <td><div>'.Tracking :: get_last_connection_date_on_the_course ($user_id, $row[0]).'</div></td>';
  165. $return .= '<tr>';
  166. }
  167. $return .= '</table>';
  168. return $return;
  169. }
  170. /**
  171. * Display a sortable table that contains an overview off all the reporting progress of all users and all courses the user is subscribed to
  172. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
  173. * @version Dokeos 1.8.6
  174. * @since October 2008
  175. */
  176. function display_tracking_user_overview() {
  177. MySpace::display_user_overview_export_options();
  178. $t_head .= ' <table style="width: 100%;border:0;padding:0;border-collapse:collapse;table-layout: fixed">';
  179. $t_head .= ' <caption>'.get_lang('CourseInformation').'</caption>';
  180. $t_head .= '<tr>';
  181. $t_head .= ' <th width="155px" style="border-left:0;border-bottom:0"><span>'.get_lang('Course').'</span></th>';
  182. $t_head .= ' <th style="padding:0;border-bottom:0"><span>'.cut(get_lang('AvgTimeSpentInTheCourse'), 6, true).'</span></th>';
  183. $t_head .= ' <th style="padding:0;border-bottom:0"><span>'.cut(get_lang('AvgStudentsProgress'), 6, true).'</span></th>';
  184. $t_head .= ' <th style="padding:0;border-bottom:0"><span>'.cut(get_lang('AvgCourseScore'), 6, true).'</span></th>';
  185. //$t_head .= ' <th><div style="width:40px">'.get_lang('AvgExercisesScore').'</div></th>';
  186. $t_head .= ' <th style="padding:0;border-bottom:0"><span>'.cut(get_lang('AvgMessages'), 6, true).'</span></th>';
  187. $t_head .= ' <th style="padding:0;border-bottom:0"><span>'.cut(get_lang('AvgAssignments'), 6, true).'</span></th>';
  188. $t_head .= ' <th width="105px" style="border-bottom:0"><span>'.get_lang('TotalExercisesScoreObtained').'</span></th>';
  189. //$t_head .= ' <th><div>'.get_lang('TotalExercisesScorePossible').'</div></th>';
  190. $t_head .= ' <th style="padding:0;border-bottom:0"><span>'.cut(get_lang('TotalExercisesAnswered'), 6, true).'</span></th>';
  191. //$t_head .= ' <th><div>'.get_lang('TotalExercisesScorePercentage').'</div></th>';
  192. //$t_head .= ' <th><div style="width:60px">'.get_lang('FirstLogin').'</div></th>';
  193. $t_head .= ' <th style="padding:0;border-bottom:0;border-right:0;"><span>'.get_lang('LatestLogin').'</span></th>';
  194. $t_head .= ' </tr></table>';
  195. $addparams = array('view' => 'admin', 'display' => 'useroverview');
  196. $table = new SortableTable('tracking_user_overview', array('MySpace','get_number_of_users_tracking_overview'), array('MySpace','get_user_data_tracking_overview'), 0);
  197. $table->additional_parameters = $addparams;
  198. $table->set_header(0, get_lang('OfficialCode'), true, array('style' => 'font-size:8pt'), array('style' => 'font-size:8pt'));
  199. if (api_is_western_name_order()) {
  200. $table->set_header(1, get_lang('FirstName'), true, array('style' => 'font-size:8pt'), array('style' => 'font-size:8pt'));
  201. $table->set_header(2, get_lang('LastName'), true, array('style' => 'font-size:8pt'), array('style' => 'font-size:8pt'));
  202. } else {
  203. $table->set_header(1, get_lang('LastName'), true, array('style' => 'font-size:8pt'), array('style' => 'font-size:8pt'));
  204. $table->set_header(2, get_lang('FirstName'), true, array('style' => 'font-size:8pt'), array('style' => 'font-size:8pt'));
  205. }
  206. $table->set_header(3, get_lang('LoginName'), true, array('style' => 'font-size:8pt'), array('style' => 'font-size:8pt'));
  207. $table->set_header(4, $t_head, false, array('style' => 'width:90%;border:0;padding:0;font-size:7.5pt;'), array('style' => 'width:90%;padding:0;font-size:7.5pt;'));
  208. $table->set_column_filter(4, array('MySpace','course_info_tracking_filter'));
  209. $table->display();
  210. }
  211. /**
  212. * Displays a form with all the additionally defined user fields of the profile
  213. * and give you the opportunity to include these in the CSV export
  214. *
  215. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
  216. * @version Dokeos 1.8.6
  217. * @since November 2008
  218. */
  219. function display_user_overview_export_options() {
  220. // include the user manager and formvalidator library
  221. if ($_GET['export'] == 'options') {
  222. // get all the defined extra fields
  223. $extrafields = UserManager::get_extra_fields(0, 50, 5, 'ASC', false);
  224. // creating the form with all the defined extra fields
  225. $form = new FormValidator('exportextrafields', 'post', api_get_self()."?view=".Security::remove_XSS($_GET['view']).'&display='.Security::remove_XSS($_GET['display']).'&export='.Security::remove_XSS($_GET['export']));
  226. if (is_array($extrafields) && count($extrafields) > 0) {
  227. foreach ($extrafields as $key => $extra) {
  228. $form->addElement('checkbox', 'extra_export_field'.$extra[0], '', $extra[3]);
  229. }
  230. $form->addElement('style_submit_button','submit', get_lang('Ok'),'class="save"' );
  231. // setting the default values for the form that contains all the extra fields
  232. if (is_array($_SESSION['additional_export_fields'])) {
  233. foreach ($_SESSION['additional_export_fields'] as $key => $value) {
  234. $defaults['extra_export_field'.$value] = 1;
  235. }
  236. }
  237. $form->setDefaults($defaults);
  238. } else {
  239. $form->addElement('html', Display::display_warning_message(get_lang('ThereAreNotExtrafieldsAvailable')));
  240. }
  241. if ($form->validate()) {
  242. // exporting the form values
  243. $values = $form->exportValues();
  244. // re-initialising the session that contains the additional fields that need to be exported
  245. $_SESSION['additional_export_fields'] = array();
  246. // adding the fields that are checked to the session
  247. $message = '';
  248. foreach ($values as $field_ids => $value) {
  249. if ($value == 1 && strstr($field_ids,'extra_export_field')) {
  250. $_SESSION['additional_export_fields'][] = str_replace('extra_export_field', '', $field_ids);
  251. }
  252. }
  253. // adding the fields that will be also exported to a message string
  254. if (is_array($_SESSION['additional_export_fields'])) {
  255. foreach ($_SESSION['additional_export_fields'] as $key => $extra_field_export) {
  256. $message .= '<li>'.$extrafields[$extra_field_export][3].'</li>';
  257. }
  258. }
  259. // Displaying a feedback message
  260. if (!empty($_SESSION['additional_export_fields'])) {
  261. Display::display_confirmation_message(get_lang('FollowingFieldsWillAlsoBeExported').': <br /><ul>'.$message.'</ul>', false);
  262. } else {
  263. Display::display_confirmation_message(get_lang('NoAdditionalFieldsWillBeExported'), false);
  264. }
  265. $message = '';
  266. } else {
  267. $form->display();
  268. }
  269. } else {
  270. if (!empty($_SESSION['additional_export_fields'])) {
  271. // get all the defined extra fields
  272. $extrafields = UserManager::get_extra_fields(0, 50, 5, 'ASC');
  273. foreach ($_SESSION['additional_export_fields'] as $key => $extra_field_export) {
  274. $message .= '<li>'.$extrafields[$extra_field_export][3].'</li>';
  275. }
  276. Display::display_normal_message(get_lang('FollowingFieldsWillAlsoBeExported').': <br /><ul>'.$message.'</ul>', false);
  277. $message = '';
  278. }
  279. }
  280. }
  281. /**
  282. * Get general information about the exercise performance of the user
  283. * the total obtained score (all the score on all the questions)
  284. * the maximum score that could be obtained
  285. * the number of questions answered
  286. * the success percentage
  287. * @param integer $user_id the id of the user
  288. * @param string $course_code the course code
  289. * @return array
  290. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
  291. * @version Dokeos 1.8.6
  292. * @since November 2008
  293. */
  294. function exercises_results($user_id, $course_code) {
  295. $questions_answered = 0;
  296. $sql = 'SELECT exe_result , exe_weighting
  297. FROM '.Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_EXERCICES)."
  298. WHERE exe_cours_id = '".Database::escape_string($course_code)."'
  299. AND exe_user_id = '".Database::escape_string($user_id)."'";
  300. $result = Database::query($sql);
  301. $score_obtained = 0;
  302. $score_possible = 0;
  303. $questions_answered = 0;
  304. while ($row = Database::fetch_array($result)) {
  305. $score_obtained += $row['exe_result'];
  306. $score_possible += $row['exe_weighting'];
  307. $questions_answered ++;
  308. }
  309. if ($score_possible != 0) {
  310. $percentage = round(($score_obtained / $score_possible * 100), 2);
  311. } else {
  312. $percentage = null;
  313. }
  314. return array('score_obtained' => $score_obtained, 'score_possible' => $score_possible, 'questions_answered' => $questions_answered, 'percentage' => $percentage);
  315. }
  316. /**
  317. * This function exports the table that we see in display_tracking_user_overview()
  318. *
  319. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
  320. * @version Dokeos 1.8.6
  321. * @since October 2008
  322. */
  323. function export_tracking_user_overview() {
  324. // database table definitions
  325. $tbl_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  326. $is_western_name_order = api_is_western_name_order(PERSON_NAME_DATA_EXPORT);
  327. $sort_by_first_name = api_sort_by_first_name();
  328. // the values of the sortable table
  329. if ($_GET['tracking_user_overview_page_nr']) {
  330. $from = $_GET['tracking_user_overview_page_nr'];
  331. } else {
  332. $from = 0;
  333. }
  334. if ($_GET['tracking_user_overview_column']) {
  335. $orderby = $_GET['tracking_user_overview_column'];
  336. } else {
  337. $orderby = 0;
  338. }
  339. if ($is_western_name_order != api_is_western_name_order() && ($orderby == 1 || $orderby == 2)) {
  340. // Swapping the sorting column if name order for export is different than the common name order.
  341. $orderby = 3 - $orderby;
  342. }
  343. if ($_GET['tracking_user_overview_direction']) {
  344. $direction = $_GET['tracking_user_overview_direction'];
  345. } else {
  346. $direction = 'ASC';
  347. }
  348. $user_data = MySpace::get_user_data_tracking_overview($from, 1000, $orderby, $direction);
  349. // the first line of the csv file with the column headers
  350. $csv_row = array();
  351. $csv_row[] = get_lang('OfficialCode');
  352. if ($is_western_name_order) {
  353. $csv_row[] = get_lang('FirstName', '');
  354. $csv_row[] = get_lang('LastName', '');
  355. } else {
  356. $csv_row[] = get_lang('LastName', '');
  357. $csv_row[] = get_lang('FirstName', '');
  358. }
  359. $csv_row[] = get_lang('LoginName');
  360. $csv_row[] = get_lang('CourseCode');
  361. // the additional user defined fields (only those that were selected to be exported)
  362. $fields = UserManager::get_extra_fields(0, 50, 5, 'ASC');
  363. if (is_array($_SESSION['additional_export_fields'])) {
  364. foreach ($_SESSION['additional_export_fields'] as $key => $extra_field_export) {
  365. $csv_row[] = $fields[$extra_field_export][3];
  366. $field_names_to_be_exported[] = 'extra_'.$fields[$extra_field_export][1];
  367. }
  368. }
  369. $csv_row[] = get_lang('AvgTimeSpentInTheCourse', '');
  370. $csv_row[] = get_lang('AvgStudentsProgress', '');
  371. $csv_row[] = get_lang('AvgCourseScore', '');
  372. $csv_row[] = get_lang('AvgExercisesScore', '');
  373. $csv_row[] = get_lang('AvgMessages', '');
  374. $csv_row[] = get_lang('AvgAssignments', '');
  375. $csv_row[] = get_lang('TotalExercisesScoreObtained', '');
  376. $csv_row[] = get_lang('TotalExercisesScorePossible', '');
  377. $csv_row[] = get_lang('TotalExercisesAnswered', '');
  378. $csv_row[] = get_lang('TotalExercisesScorePercentage', '');
  379. $csv_row[] = get_lang('FirstLogin', '');
  380. $csv_row[] = get_lang('LatestLogin', '');
  381. $csv_content[] = $csv_row;
  382. // the other lines (the data)
  383. foreach ($user_data as $key => $user) {
  384. // getting all the courses of the user
  385. $sql = "SELECT * FROM $tbl_course_user WHERE user_id = '".Database::escape_string($user[4])."' AND relation_type<>".COURSE_RELATION_TYPE_RRHH." ";
  386. $result = Database::query($sql);
  387. while ($row = Database::fetch_row($result)) {
  388. $csv_row = array();
  389. // user official code
  390. $csv_row[] = $user[0];
  391. // user first|last name
  392. $csv_row[] = $user[1];
  393. // user last|first name
  394. $csv_row[] = $user[2];
  395. // user login name
  396. $csv_row[] = $user[3];
  397. // course code
  398. $csv_row[] = $row[0];
  399. // the additional defined user fields
  400. $extra_fields = MySpace::get_user_overview_export_extra_fields($user[4]);
  401. if (is_array($field_names_to_be_exported)) {
  402. foreach ($field_names_to_be_exported as $key => $extra_field_export) {
  403. $csv_row[] = $extra_fields[$extra_field_export];
  404. }
  405. }
  406. // time spent in the course
  407. $csv_row[] = api_time_to_hms(Tracking :: get_time_spent_on_the_course ($user[4], $row[0]));
  408. // student progress in course
  409. $csv_row[] = round(Tracking :: get_avg_student_progress ($user[4], $row[0]), 2);
  410. // student score
  411. $csv_row[] = round(Tracking :: get_avg_student_score ($user[4], $row[0]), 2);
  412. // student tes score
  413. $csv_row[] = round(Tracking :: get_avg_student_exercise_score ($user[4], $row[0]), 2);
  414. // student messages
  415. $csv_row[] = Tracking :: count_student_messages ($user[4], $row[0]);
  416. // student assignments
  417. $csv_row[] = Tracking :: count_student_assignments ($user[4], $row[0]);
  418. // student exercises results
  419. $exercises_results = MySpace::exercises_results($user[4], $row[0]);
  420. $csv_row[] = $exercises_results['score_obtained'];
  421. $csv_row[] = $exercises_results['score_possible'];
  422. $csv_row[] = $exercises_results['questions_answered'];
  423. $csv_row[] = $exercises_results['percentage'];
  424. // first connection
  425. $csv_row[] = Tracking :: get_first_connection_date_on_the_course ($user[4], $row[0]);
  426. // last connection
  427. $csv_row[] = strip_tags(Tracking :: get_last_connection_date_on_the_course ($user[4], $row[0]));
  428. $csv_content[] = $csv_row;
  429. }
  430. }
  431. Export :: export_table_csv($csv_content, 'reporting_user_overview');
  432. exit;
  433. }
  434. /**
  435. * Get data for courses list in sortable with pagination
  436. * @return array
  437. */
  438. function get_course_data($from, $number_of_items, $column, $direction) {
  439. global $courses, $csv_content, $charset, $session_id;
  440. // definition database tables
  441. $tbl_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  442. $tbl_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  443. $tbl_session_course_user = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  444. $a_course_students = array();
  445. $course_data = array();
  446. $courses_code = array_keys($courses);
  447. foreach ($courses_code as &$code) {
  448. $code = "'$code'";
  449. }
  450. // get all courses with limit
  451. $sql = "SELECT course.code as col1, course.title as col2
  452. FROM $tbl_course course
  453. WHERE course.code IN (".implode(',',$courses_code).")";
  454. if (!in_array($direction, array('ASC','DESC'))) $direction = 'ASC';
  455. $column = intval($column);
  456. $from = intval($from);
  457. $number_of_items = intval($number_of_items);
  458. $sql .= " ORDER BY col$column $direction ";
  459. $sql .= " LIMIT $from,$number_of_items";
  460. $res = Database::query($sql);
  461. while ($row_course = Database::fetch_row($res)) {
  462. $course_code = $row_course[0];
  463. $course_info = api_get_course_info($course_code);
  464. $avg_assignments_in_course = $avg_messages_in_course = $nb_students_in_course = $avg_progress_in_course = $avg_score_in_course = $avg_time_spent_in_course = $avg_score_in_exercise = 0;
  465. // students directly subscribed to the course
  466. if (empty($session_id)) {
  467. $sql = "SELECT user_id FROM $tbl_course_user as course_rel_user WHERE course_rel_user.status='5' AND course_rel_user.course_code='$course_code'";
  468. } else {
  469. $sql = "SELECT id_user as user_id FROM $tbl_session_course_user srcu WHERE srcu. course_code='$course_code' AND id_session = '$session_id' AND srcu.status<>2";
  470. }
  471. $rs = Database::query($sql);
  472. $users = array();
  473. while ($row = Database::fetch_array($rs)) { $users[] = $row['user_id']; }
  474. if (count($users) > 0) {
  475. $nb_students_in_course = count($users);
  476. $avg_assignments_in_course = Tracking::count_student_assignments($users, $course_code, $session_id);
  477. $avg_messages_in_course = Tracking::count_student_messages($users, $course_code, $session_id);
  478. $avg_progress_in_course = Tracking::get_avg_student_progress($users, $course_code, array(), $session_id);
  479. $avg_score_in_course = Tracking :: get_avg_student_score($users, $course_code, array(), $session_id);
  480. $avg_score_in_exercise = Tracking::get_avg_student_exercise_score($users, $course_code, 0, $session_id);
  481. $avg_time_spent_in_course = Tracking::get_time_spent_on_the_course($users, $course_code, $session_id);
  482. $avg_progress_in_course = round($avg_progress_in_course / $nb_students_in_course, 2);
  483. $avg_score_in_course = round($avg_score_in_course / $nb_students_in_course, 2);
  484. $avg_score_in_exercise = round($avg_score_in_exercise / $nb_students_in_course, 2);
  485. $avg_time_spent_in_course = api_time_to_hms($avg_time_spent_in_course / $nb_students_in_course);
  486. } else {
  487. $avg_time_spent_in_course = null;
  488. $avg_progress_in_course = null;
  489. $avg_score_in_course = null;
  490. $avg_score_in_exercise = null;
  491. $avg_messages_in_course = null;
  492. $avg_assignments_in_course = null;
  493. }
  494. $table_row = array();
  495. $table_row[] = $row_course[1];
  496. $table_row[] = $nb_students_in_course;
  497. $table_row[] = $avg_time_spent_in_course;
  498. $table_row[] = is_null($avg_progress_in_course) ? '' : $avg_progress_in_course.'%';
  499. $table_row[] = is_null($avg_score_in_course) ? '' : $avg_score_in_course.'%';
  500. $table_row[] = is_null($avg_score_in_exercise) ? '' : $avg_score_in_exercise.'%';
  501. $table_row[] = $avg_messages_in_course;
  502. $table_row[] = $avg_assignments_in_course;
  503. //set the "from" value to know if I access the Reporting by the chamilo tab or the course link
  504. $table_row[] = '<center><a href="../tracking/courseLog.php?cidReq='.$course_code.'&studentlist=true&from=myspace&id_session='.$session_id.'"><img src="'.api_get_path(WEB_IMG_PATH).'2rightarrow.gif" border="0" /></a></center>';
  505. $csv_content[] = array(
  506. api_html_entity_decode($row_course[1], ENT_QUOTES, $charset),
  507. $nb_students_in_course,
  508. $avg_time_spent_in_course,
  509. is_null($avg_progress_in_course) ? null : $avg_progress_in_course.'%',
  510. is_null($avg_score_in_course) ? null : $avg_score_in_course.'%',
  511. is_null($avg_score_in_exercise) ? null : $avg_score_in_exercise.'%',
  512. $avg_messages_in_course,
  513. $avg_assignments_in_course,
  514. );
  515. $course_data[] = $table_row;
  516. }
  517. return $course_data;
  518. }
  519. /**
  520. * get the numer of users of the platform
  521. *
  522. * @return integer
  523. *
  524. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
  525. * @version Dokeos 1.8.6
  526. * @since October 2008
  527. */
  528. function get_number_of_users_tracking_overview() {
  529. // database table definition
  530. $main_user_table = Database :: get_main_table(TABLE_MAIN_USER);
  531. // query
  532. $sql = 'SELECT user_id FROM '.$main_user_table;
  533. $result = Database::query($sql);
  534. // return the number of results
  535. return Database::num_rows($result);
  536. }
  537. /**
  538. * get all the data for the sortable table of the reporting progress of all users and all the courses the user is subscribed to.
  539. *
  540. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
  541. * @version Dokeos 1.8.6
  542. * @since October 2008
  543. */
  544. function get_user_data_tracking_overview($from, $number_of_items, $column, $direction) {
  545. // database table definition
  546. $main_user_table = Database :: get_main_table(TABLE_MAIN_USER);
  547. global $export_csv;
  548. if ($export_csv) {
  549. $is_western_name_order = api_is_western_name_order(PERSON_NAME_DATA_EXPORT);
  550. } else {
  551. $is_western_name_order = api_is_western_name_order();
  552. }
  553. $sql = "SELECT
  554. official_code AS col0,
  555. ".($is_western_name_order ? "
  556. firstname AS col1,
  557. lastname AS col2,
  558. " : "
  559. lastname AS col1,
  560. firstname AS col2,
  561. ").
  562. "username AS col3,
  563. user_id AS col4
  564. FROM
  565. $main_user_table
  566. ";
  567. $sql .= " ORDER BY col$column $direction ";
  568. $sql .= " LIMIT $from,$number_of_items";
  569. $result = Database::query($sql);
  570. $return = array ();
  571. while ($user = Database::fetch_row($result)) {
  572. $return[] = $user;
  573. }
  574. return $return;
  575. }
  576. /**
  577. * Get all information that the user with user_id = $user_data has
  578. * entered in the additionally defined profile fields
  579. * @param integer $user_id the id of the user
  580. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
  581. * @version Dokeos 1.8.6
  582. * @since November 2008
  583. */
  584. function get_user_overview_export_extra_fields($user_id) {
  585. // include the user manager
  586. $extra_data = UserManager::get_extra_user_data($user_id, true);
  587. return $extra_data;
  588. }
  589. /**
  590. * Checks if a username exist in the DB otherwise it create a "double"
  591. * i.e. if we look into for jmontoya but the user's name already exist we create the user jmontoya2
  592. * the return array will be array(username=>'jmontoya', sufix='2')
  593. * @param string firstname
  594. * @param string lastname
  595. * @param string username
  596. * @return array with the username, the sufix
  597. * @author Julio Montoya Armas
  598. */
  599. function make_username($firstname, $lastname, $username, $language = null, $encoding = null) {
  600. $table_user = Database::get_main_table(TABLE_MAIN_USER);
  601. $tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  602. // if username exist
  603. if (!UserManager::is_username_available($username) || empty($username)) {
  604. $i = 0;
  605. while (1) {
  606. if ($i == 0) {
  607. $sufix = '';
  608. } else {
  609. $sufix = $i;
  610. }
  611. $desired_username = UserManager::create_username($firstname, $lastname, $language, $encoding);
  612. if (UserManager::is_username_available($desired_username.$sufix)) {
  613. break;
  614. } else {
  615. $i++;
  616. }
  617. }
  618. $username_array = array('username' => $desired_username , 'sufix' => $sufix);
  619. return $username_array;
  620. } else {
  621. $username_array = array('username' => $username, 'sufix' => '');
  622. return $username_array;
  623. }
  624. }
  625. /**
  626. * Checks if there are repeted users in a given array
  627. * @param array $usernames list of the usernames in the uploaded file
  628. * @param array $user_array['username'] and $user_array['sufix'] where sufix is the number part in a login i.e -> jmontoya2
  629. * @return array with the $usernames array and the $user_array array
  630. * @author Julio Montoya Armas
  631. */
  632. function check_user_in_array($usernames, $user_array) {
  633. $user_list = array_keys($usernames);
  634. $username = $user_array['username'].$user_array['sufix'];
  635. if (in_array($username, $user_list)) {
  636. $user_array['sufix'] += $usernames[$username];
  637. $usernames[$username]++;
  638. } else {
  639. $usernames[$username] = 1;
  640. }
  641. $result_array = array($usernames, $user_array);
  642. return $result_array;
  643. }
  644. /**
  645. * Checks whether a username has been already subscribed in a session.
  646. * @param string a given username
  647. * @param array the array with the course list codes
  648. * @param the session id
  649. * @return 0 if the user is not subscribed otherwise it returns the user_id of the given username
  650. * @author Julio Montoya Armas
  651. */
  652. function user_available_in_session($username, $course_list, $id_session) {
  653. $table_user = Database::get_main_table(TABLE_MAIN_USER);
  654. $tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  655. $id_session = intval($id_session);
  656. $username = Database::escape_string($username);
  657. foreach($course_list as $enreg_course) {
  658. $sql_select = " SELECT u.user_id FROM $tbl_session_rel_course_rel_user rel INNER JOIN $table_user u
  659. ON (rel.id_user=u.user_id)
  660. WHERE rel.id_session='$id_session' AND u.status='5' AND u.username ='$username' AND rel.course_code='$enreg_course'";
  661. $rs = Database::query($sql_select);
  662. if (Database::num_rows($rs) > 0) {
  663. return Database::result($rs, 0, 0);
  664. } else {
  665. return 0;
  666. }
  667. }
  668. }
  669. /**
  670. This function checks whether some users in the uploaded file repeated and creates unique usernames if necesary.
  671. A case: Within the file there is an user repeted twice (Julio Montoya / Julio Montoya) and the username fields are empty.
  672. Then, this function would create unique usernames based on the first and the last name. Two users wiould be created - jmontoya and jmontoya2.
  673. Of course, if in the database there is a user with the name jmontoya, the newly created two users registered would be jmontoya2 and jmontoya3.
  674. @param $users list of users
  675. @author Julio Montoya Armas
  676. */
  677. function check_all_usernames($users, $course_list, $id_session) {
  678. $table_user = Database::get_main_table(TABLE_MAIN_USER);
  679. $usernames = array();
  680. $new_users = array();
  681. foreach ($users as $index => $user) {
  682. $desired_username = array();
  683. if (empty($user['UserName'])) {
  684. $desired_username = MySpace::make_username($user['FirstName'], $user['LastName'], '');
  685. $pre_username = $desired_username['username'].$desired_username['sufix'];
  686. $user['UserName'] = $pre_username;
  687. $user['create'] = '1';
  688. } else {
  689. if (UserManager::is_username_available($user['UserName'])) {
  690. $desired_username = MySpace::make_username($user['FirstName'], $user['LastName'], $user['UserName']);
  691. $user['UserName'] = $desired_username['username'].$desired_username['sufix'];
  692. $user['create'] = '1';
  693. } else {
  694. $is_session_avail = MySpace::user_available_in_session($user['UserName'], $course_list, $id_session);
  695. if ($is_session_avail == 0) {
  696. $user_name = $user['UserName'];
  697. $sql_select = "SELECT user_id FROM $table_user WHERE username ='$user_name' ";
  698. $rs = Database::query($sql_select);
  699. $user['create'] = Database::result($rs, 0, 0); // This should be the ID because the user exists.
  700. } else {
  701. $user['create'] = $is_session_avail;
  702. }
  703. }
  704. }
  705. // Usernames is the current list of users in the file.
  706. $result_array = MySpace::check_user_in_array($usernames, $desired_username);
  707. $usernames = $result_array[0];
  708. $desired_username = $result_array[1];
  709. $user['UserName'] = $desired_username['username'].$desired_username['sufix'];
  710. $new_users[] = $user;
  711. }
  712. return $new_users;
  713. }
  714. /**
  715. * This functions checks whether there are users that are already registered in the DB by different creator than the current coach.
  716. * @param string a given username
  717. * @param array the array with the course list codes
  718. * @param the session id
  719. * @author Julio Montoya Armas
  720. */
  721. function get_user_creator($users, $course_list, $id_session) {
  722. $errors = array();
  723. foreach ($users as $index => $user) {
  724. // database table definition
  725. $table_user = Database::get_main_table(TABLE_MAIN_USER);
  726. $tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  727. $username = Database::escape_string($user['UserName']);
  728. //echo "<br>";
  729. $sql = "SELECT creator_id FROM $table_user WHERE username='$username' ";
  730. $rs = Database::query($sql);
  731. $creator_id = Database::result($rs, 0, 0);
  732. // check if we are the creators or not
  733. if ($creator_id != '') {
  734. if ($creator_id != api_get_user_id()) {
  735. $user['error'] = get_lang('UserAlreadyRegisteredByOtherCreator');
  736. $errors[] = $user;
  737. }
  738. }
  739. }
  740. return $errors;
  741. }
  742. /**
  743. * Validates imported data.
  744. * @param list of users
  745. */
  746. function validate_data($users, $id_session = null) {
  747. $errors = array();
  748. $usernames = array();
  749. $new_users = array();
  750. foreach ($users as $index => $user) {
  751. // 1. Check whether mandatory fields are set.
  752. $mandatory_fields = array('LastName', 'FirstName');
  753. if (api_get_setting('registration', 'email') == 'true') {
  754. $mandatory_fields[] = 'Email';
  755. }
  756. foreach ($mandatory_fields as $key => $field) {
  757. if (!isset ($user[$field]) || strlen($user[$field]) == 0) {
  758. $user['error'] = get_lang($field.'Mandatory');
  759. $errors[] = $user;
  760. }
  761. }
  762. // 2. Check whether the username is too long.
  763. if (UserManager::is_username_too_long($user['UserName'])) {
  764. $user['error'] = get_lang('UserNameTooLong');
  765. $errors[] = $user;
  766. }
  767. $user['UserName'] = trim($user['UserName']);
  768. if (empty($user['UserName'])) {
  769. $user['UserName'] = UserManager::create_username($user['FirstName'], $user['LastName']);
  770. }
  771. $new_users[] = $user;
  772. }
  773. $results = array('errors' => $errors, 'users' => $new_users);
  774. return $results;
  775. }
  776. /**
  777. * Adds missing user-information (which isn't required, like password, etc).
  778. */
  779. function complete_missing_data($user) {
  780. // 1. Generate a password if it is necessary.
  781. if (!isset ($user['Password']) || strlen($user['Password']) == 0) {
  782. $user['Password'] = api_generate_password();
  783. }
  784. return $user;
  785. }
  786. /**
  787. * Saves imported data.
  788. */
  789. function save_data($users, $course_list, $id_session) {
  790. $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
  791. $tbl_session_rel_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);
  792. $tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  793. $tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER);
  794. $id_session = intval($id_session);
  795. $sendMail = $_POST['sendMail'] ? 1 : 0;
  796. // Adding users to the platform.
  797. $new_users = array();
  798. foreach ($users as $index => $user) {
  799. $user = MySpace::complete_missing_data($user);
  800. // coach only will registered users
  801. $default_status = '5';
  802. if ($user['create'] == '1') {
  803. $user['id'] = UserManager :: create_user($user['FirstName'], $user['LastName'], $default_status, $user['Email'], $user['UserName'], $user['Password'], $user['OfficialCode'], api_get_setting('PlatformLanguage'), $user['PhoneNumber'], '');
  804. $user['added_at_platform'] = 1;
  805. } else {
  806. $user['id'] = $user['create'];
  807. $user['added_at_platform'] = 0;
  808. }
  809. $new_users[] = $user;
  810. }
  811. // Update user list.
  812. $users = $new_users;
  813. // Inserting users.
  814. $super_list = array();
  815. foreach ($course_list as $enreg_course) {
  816. $nbr_users = 0;
  817. $new_users = array();
  818. $enreg_course = Database::escape_string($enreg_course);
  819. foreach ($users as $index => $user) {
  820. $userid = intval($user['id']);
  821. $sql = "INSERT IGNORE INTO $tbl_session_rel_course_rel_user(id_session,course_code,id_user) VALUES('$id_session','$enreg_course','$userid')";
  822. $course_session = array('course' => $enreg_course, 'added' => 1);
  823. //$user['added_at_session'] = $course_session;
  824. Database::query($sql);
  825. if (Database::affected_rows()) {
  826. $nbr_users++;
  827. }
  828. $new_users[] = $user;
  829. }
  830. $super_list[] = $new_users;
  831. //update the nbr_users field
  832. $sql_select = "SELECT COUNT(id_user) as nbUsers FROM $tbl_session_rel_course_rel_user WHERE id_session='$id_session' AND course_code='$enreg_course'";
  833. $rs = Database::query($sql_select);
  834. list($nbr_users) = Database::fetch_array($rs);
  835. $sql_update = "UPDATE $tbl_session_rel_course SET nbr_users=$nbr_users WHERE id_session='$id_session' AND course_code='$enreg_course'";
  836. Database::query($sql_update);
  837. $sql_update = "UPDATE $tbl_session SET nbr_users= '$nbr_users' WHERE id='$id_session'";
  838. Database::query($sql_update);
  839. }
  840. // We don't delete the users (thoughts while dreaming)
  841. //$sql_delete = "DELETE FROM $tbl_session_rel_user WHERE id_session = '$id_session'";
  842. //Database::query($sql_delete);
  843. $new_users = array();
  844. foreach ($users as $index => $user) {
  845. $userid = $user['id'];
  846. $sql_insert = "INSERT IGNORE INTO $tbl_session_rel_user(id_session, id_user) VALUES('$id_session','$userid')";
  847. Database::query($sql_insert);
  848. $user['added_at_session'] = 1;
  849. $new_users[] = $user;
  850. }
  851. $users = $new_users;
  852. $registered_users = get_lang('FileImported').'<br /> Import file results : <br />';
  853. // Sending emails.
  854. $addedto = '';
  855. if ($sendMail) {
  856. $i = 0;
  857. foreach ($users as $index => $user) {
  858. $emailto = api_get_person_name($user['FirstName'], $user['LastName'], null, PERSON_NAME_EMAIL_ADDRESS).' <'.$user['Email'].'>';
  859. $emailsubject = '['.api_get_setting('siteName').'] '.get_lang('YourReg').' '.api_get_setting('siteName');
  860. $emailbody = get_lang('Dear').' '.api_get_person_name($user['FirstName'], $user['LastName']).",\n\n".get_lang('YouAreReg')." ".api_get_setting('siteName')." ".get_lang('WithTheFollowingSettings')."\n\n".get_lang('Username')." : $user[UserName]\n".get_lang('Pass')." : $user[Password]\n\n".get_lang('Address')." ".api_get_setting('siteName')." ".get_lang('Is')." : ".api_get_path('WEB_PATH')." \n\n".get_lang('Problem')."\n\n".get_lang('Formula').",\n\n".api_get_person_name(api_get_setting('administratorName'), api_get_setting('administratorSurname'))."\n".get_lang('Manager')." ".api_get_setting('siteName')."\nT. ".api_get_setting('administratorTelephone')."\n".get_lang('Email')." : ".api_get_setting('emailAdministrator')."";
  861. $emailheaders = 'From: '.api_get_person_name(api_get_setting('administratorName'), api_get_setting('administratorSurname'), null, PERSON_NAME_EMAIL_ADDRESS).' <'.api_get_setting('emailAdministrator').">\n";
  862. $emailheaders .= 'Reply-To: '.api_get_setting('emailAdministrator');
  863. @api_send_mail($emailto, $emailsubject, $emailbody, $emailheaders);
  864. if (($user['added_at_platform'] == 1 && $user['added_at_session'] == 1) || $user['added_at_session'] == 1) {
  865. if ($user['added_at_platform'] == 1) {
  866. $addedto = get_lang('UserCreatedPlatform');
  867. } else {
  868. $addedto = ' ';
  869. }
  870. if ($user['added_at_session'] == 1) {
  871. $addedto .= get_lang('UserInSession');
  872. }
  873. $registered_users .= "<a href=\"../user/userInfo.php?uInfo=".$user['id']."\">".api_get_person_name($user['FirstName'], $user['LastName'])."</a> - ".$addedto.'<br />';
  874. } else {
  875. $addedto = get_lang('UserNotAdded');
  876. $registered_users .= "<a href=\"../user/userInfo.php?uInfo=".$user['id']."\">".api_get_person_name($user['FirstName'], $user['LastName'])."</a> - ".$addedto.'<br />';
  877. }
  878. }
  879. } else {
  880. $i = 0;
  881. foreach ($users as $index => $user) {
  882. if (($user['added_at_platform'] == 1 && $user['added_at_session'] == 1) || $user['added_at_session'] == 1) {
  883. if ($user['added_at_platform'] == 1) {
  884. $addedto = get_lang('UserCreatedPlatform');
  885. } else {
  886. $addedto = ' ';
  887. }
  888. if ($user['added_at_session'] == 1) {
  889. $addedto .= ' '.get_lang('UserInSession');
  890. }
  891. $registered_users .= "<a href=\"../user/userInfo.php?uInfo=".$user['id']."\">".api_get_person_name($user['FirstName'], $user['LastName'])."</a> - ".$addedto.'<br />';
  892. } else {
  893. $addedto = get_lang('UserNotAdded');
  894. $registered_users .= "<a href=\"../user/userInfo.php?uInfo=".$user['id']."\">".api_get_person_name($user['FirstName'], $user['LastName'])."</a> - ".$addedto.'<br />';
  895. }
  896. }
  897. }
  898. header('Location: course.php?id_session='.$id_session.'&action=show_message&message='.urlencode($registered_users));
  899. exit ();
  900. //header('Location: resume_session.php?id_session='.$id_session);
  901. }
  902. /**
  903. * Reads CSV-file.
  904. * @param string $file Path to the CSV-file
  905. * @return array All userinformation read from the file
  906. */
  907. function parse_csv_data($file) {
  908. $users = Import :: csv_to_array($file);
  909. foreach ($users as $index => $user) {
  910. if (isset ($user['Courses'])) {
  911. $user['Courses'] = explode('|', trim($user['Courses']));
  912. }
  913. $users[$index] = $user;
  914. }
  915. return $users;
  916. }
  917. /**
  918. * XML-parser: the handler at the beginning of element.
  919. */
  920. function element_start($parser, $data) {
  921. $data = api_utf8_decode($data);
  922. global $user;
  923. global $current_tag;
  924. switch ($data) {
  925. case 'Contact' :
  926. $user = array ();
  927. break;
  928. default :
  929. $current_tag = $data;
  930. }
  931. }
  932. /**
  933. * XML-parser: the handler at the end of element.
  934. */
  935. function element_end($parser, $data) {
  936. $data = api_utf8_decode($data);
  937. global $user;
  938. global $users;
  939. global $current_value;
  940. global $purification_option_for_usernames;
  941. $user[$data] = $current_value;
  942. switch ($data) {
  943. case 'Contact' :
  944. $user['UserName'] = UserManager::purify_username($user['UserName'], $purification_option_for_usernames);
  945. $users[] = $user;
  946. break;
  947. default :
  948. $user[$data] = $current_value;
  949. break;
  950. }
  951. }
  952. /**
  953. * XML-parser: the handler for character data.
  954. */
  955. function character_data($parser, $data) {
  956. $data = trim(api_utf8_decode($data));
  957. global $current_value;
  958. $current_value = $data;
  959. }
  960. /**
  961. * Reads XML-file.
  962. * @param string $file Path to the XML-file
  963. * @return array All userinformation read from the file
  964. */
  965. function parse_xml_data($file) {
  966. global $current_tag;
  967. global $current_value;
  968. global $user;
  969. global $users;
  970. $users = array ();
  971. $parser = xml_parser_create('UTF-8');
  972. xml_set_element_handler($parser, array('MySpace','element_start'), array('MySpace','element_end'));
  973. xml_set_character_data_handler($parser, "character_data");
  974. xml_parser_set_option($parser, XML_OPTION_CASE_FOLDING, false);
  975. xml_parse($parser, api_utf8_encode_xml(file_get_contents($file)));
  976. xml_parser_free($parser);
  977. return $users;
  978. }
  979. }