index.php 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682
  1. <?php
  2. /**
  3. * @todo use constant for $this_section
  4. */
  5. // name of the language file that needs to be included
  6. $language_file = array ('registration', 'index','tracking');
  7. $cidReset=true;
  8. require ('../inc/global.inc.php');
  9. require (api_get_path(LIBRARY_PATH).'tracking.lib.php');
  10. require_once(api_get_path(LIBRARY_PATH).'course.lib.php');
  11. require_once(api_get_path(LIBRARY_PATH).'export.lib.inc.php');
  12. ob_start();
  13. $export_csv = isset($_GET['export']) && $_GET['export'] == 'csv' ? true : false;
  14. $csv_content = array();
  15. $nameTools= get_lang("MySpace");
  16. $this_section = "session_my_space";
  17. api_block_anonymous_users();
  18. if(!$export_csv)
  19. {
  20. Display :: display_header($nameTools);
  21. }
  22. // Database table definitions
  23. $tbl_user = Database :: get_main_table(TABLE_MAIN_USER);
  24. $tbl_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  25. $tbl_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  26. $tbl_class = Database :: get_main_table(TABLE_MAIN_CLASS);
  27. $tbl_sessions = Database :: get_main_table(TABLE_MAIN_SESSION);
  28. $tbl_session_course = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE);
  29. $tbl_session_user = Database :: get_main_table(TABLE_MAIN_SESSION_USER);
  30. $tbl_session_course_user = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  31. $tbl_admin = Database :: get_main_table(TABLE_MAIN_ADMIN);
  32. /********************
  33. * FUNCTIONS
  34. ********************/
  35. function count_teacher_courses()
  36. {
  37. global $nb_teacher_courses;
  38. return $nb_teacher_courses;
  39. }
  40. function count_coaches()
  41. {
  42. global $total_no_coachs;
  43. return $total_no_coachs;
  44. }
  45. function sort_users($a,$b){
  46. $a = trim(strtolower($a[$_SESSION['tracking_column']]));
  47. $b = trim(strtolower($b[$_SESSION['tracking_column']]));
  48. if($_SESSION['tracking_direction'] == 'DESC')
  49. return strcmp($b, $a);
  50. else
  51. return strcmp($a, $b);
  52. }
  53. /**************************
  54. * MAIN CODE
  55. ***************************/
  56. $isCoach = api_is_coach();
  57. $isPlatformAdmin = api_is_platform_admin();
  58. $view = isset($_GET['view']) ? $_GET['view'] : 'teacher';
  59. $menu_items = array();
  60. if(api_is_allowed_to_create_course())
  61. {
  62. $sqlNbCours = " SELECT course_rel_user.course_code, course.title
  63. FROM $tbl_course_user as course_rel_user
  64. INNER JOIN $tbl_course as course
  65. ON course.code = course_rel_user.course_code
  66. WHERE course_rel_user.user_id='".$_user['user_id']."' AND course_rel_user.status='1'
  67. ORDER BY course.title";
  68. $resultNbCours = api_sql_query($sqlNbCours, __FILE__, __LINE__);
  69. $a_courses = api_store_result($resultNbCours);
  70. $nb_teacher_courses = count($a_courses);
  71. if($nb_teacher_courses)
  72. {
  73. if(!$isCoach && !api_is_platform_admin())
  74. {
  75. $view = 'teacher';
  76. }
  77. if($view=='teacher')
  78. {
  79. $menu_items[] = get_lang('TeacherInterface');
  80. $title = get_lang('YourCourseList');
  81. }
  82. else
  83. {
  84. $menu_items[] = '<a href="'.api_get_self().'?view=teacher">'.get_lang('TeacherInterface').'</a>';
  85. }
  86. }
  87. }
  88. if($isCoach)
  89. {
  90. if($nb_teacher_courses==0 && !api_is_platform_admin())
  91. {
  92. $view = 'coach';
  93. }
  94. if($view=='coach')
  95. {
  96. $menu_items[] = get_lang('CoachInterface');
  97. $title = get_lang('YourStatistics');
  98. }
  99. else
  100. {
  101. $menu_items[] = '<a href="'.api_get_self().'?view=coach">'.get_lang('CoachInterface').'</a>';
  102. }
  103. }
  104. if(api_is_platform_admin())
  105. {
  106. if(!$isCoach && $nb_teacher_courses==0)
  107. {
  108. $view = 'admin';
  109. }
  110. if($view=='admin')
  111. {
  112. $menu_items[] = get_lang('AdminInterface');
  113. $title = get_lang('CoachList');
  114. }
  115. else
  116. {
  117. $menu_items[] = '<a href="'.api_get_self().'?view=admin">'.get_lang('AdminInterface').'</a>';
  118. }
  119. }
  120. $nb_menu_items = count($menu_items);
  121. if($nb_menu_items>1)
  122. {
  123. foreach($menu_items as $key=> $item)
  124. {
  125. echo $item;
  126. if($key!=$nb_menu_items-1)
  127. {
  128. echo ' | ';
  129. }
  130. }
  131. echo '<br />';
  132. }
  133. echo '<div align="left" style="float:left"><h4>'.$title.'</h4></div>
  134. <div align="right">
  135. <a href="#" onclick="window.print()"><img align="absbottom" src="../img/printmgr.gif">&nbsp;'.get_lang('Print').'</a>
  136. <a href="'.api_get_self().'?export=csv&view='.$view.'"><img align="absbottom" src="../img/excel.gif">&nbsp;'.get_lang('ExportAsCSV').'</a>
  137. </div>
  138. <div class="clear"></div>';
  139. if($isCoach && $view=='coach')
  140. {
  141. /****************************************
  142. * Infos about students of the coach
  143. ****************************************/
  144. $a_students = Tracking :: get_student_followed_by_coach($_user['user_id']);
  145. $a_courses = Tracking :: get_courses_followed_by_coach($_user['user_id']);
  146. $nbStudents = count($a_students);
  147. $totalTimeSpent = 0;
  148. $totalCourses = 0;
  149. $avgTotalProgress = 0;
  150. $avgResultsToExercises = 0;
  151. $nb_inactive_students = 0;
  152. $nb_posts = $nb_assignments = 0;
  153. foreach($a_students as $student_id)
  154. {
  155. // inactive students
  156. if($last_connection_date = Tracking :: get_last_connection_date($student_id))
  157. {
  158. list($last_connection_date, $last_connection_hour) = explode(' ',$last_connection_date);
  159. $last_connection_date = explode('-',$last_connection_date);
  160. $last_connection_hour = explode(':',$last_connection_hour);
  161. $last_connection_time = mktime($last_connection_hour[0],$last_connection_hour[1],$last_connection_hour[2],$last_connection_date[1],$last_connection_date[2],$last_connection_date[0]);
  162. if(time()-(3600*24*7) > $last_connection_time)
  163. {
  164. $nb_inactive_students++;
  165. }
  166. }
  167. else
  168. {
  169. $nb_inactive_students++;
  170. }
  171. $totalTimeSpent += Tracking :: get_time_spent_on_the_platform($student_id);
  172. $totalCourses += Tracking :: count_course_per_student($student_id);
  173. $avgStudentProgress = $avgStudentScore = 0;
  174. $nb_courses_student = 0;
  175. foreach($a_courses as $course_code)
  176. {
  177. if(CourseManager :: is_user_subscribed_in_course($student_id, $course_code, true))
  178. {
  179. $nb_courses_student++;
  180. $nb_posts += Tracking :: count_student_messages($student_id,$course_code);
  181. $nb_assignments += Tracking :: count_student_assignments($student_id,$course_code);
  182. $avgStudentProgress += Tracking :: get_avg_student_progress($student_id,$course_code);
  183. $avgStudentScore += Tracking :: get_avg_student_score($student_id,$course_code);
  184. }
  185. }
  186. // average progress of the student
  187. $avgStudentProgress = $avgStudentProgress / $nb_courses_student;
  188. $avgTotalProgress += $avgStudentProgress;
  189. // average test results of the student
  190. $avgStudentScore = $avgStudentScore / $nb_courses_student;
  191. $avgResultsToExercises += $avgStudentScore;
  192. }
  193. // average progress
  194. $avgTotalProgress = $avgTotalProgress/$nbStudents;
  195. // average results to the tests
  196. $avgResultsToExercises = $avgResultsToExercises/$nbStudents;
  197. // average courses by student
  198. $avgCoursesPerStudent = round($totalCourses / $nbStudents,2);
  199. // average time spent on the platform
  200. $avgTimeSpent = $totalTimeSpent / $nbStudents;
  201. // average assignments
  202. $nb_assignments = $nb_assignments / $nbStudents;
  203. // average posts
  204. $nb_posts = $nb_posts / $nbStudents;
  205. //csv part
  206. if($export_csv)
  207. {
  208. $csv_content[] = array( get_lang('Probationers'));
  209. $csv_content[] = array( get_lang('InactivesStudents'),$nb_inactive_students );
  210. $csv_content[] = array( get_lang('AverageTimeSpentOnThePlatform'),$avgTimeSpent);
  211. $csv_content[] = array( get_lang('AverageCoursePerStudent'),$avgCoursesPerStudent);
  212. $csv_content[] = array( get_lang('AverageProgressInLearnpath'),$avgTotalProgress);
  213. $csv_content[] = array( get_lang('AverageResultsToTheExercices'),$avgResultsToExercises);
  214. $csv_content[] = array( get_lang('AveragePostsInForum'),$nb_posts);
  215. $csv_content[] = array( get_lang('AverageAssignments'),$nb_assignments);
  216. $csv_content[] = array();
  217. }
  218. // html part
  219. else
  220. {
  221. echo '
  222. <div class="admin_section">
  223. <h4>
  224. <a href="student.php"><img src="'.api_get_path(WEB_IMG_PATH).'students.gif">&nbsp;'.get_lang('Probationers').' ('.$nbStudents.')'.'</a>
  225. </h4>
  226. <table class="data_table">
  227. <tr>
  228. <td>
  229. '.get_lang('InactivesStudents').'
  230. </td>
  231. <td align="right">
  232. '.$nb_inactive_students.'
  233. </td>
  234. </tr>
  235. <tr>
  236. <td>
  237. '.get_lang('AverageTimeSpentOnThePlatform').'
  238. </td>
  239. <td align="right">
  240. '.api_time_to_hms($avgTimeSpent).'
  241. </td>
  242. </tr>
  243. <tr>
  244. <td>
  245. '.get_lang('AverageCoursePerStudent').'
  246. </td>
  247. <td align="right">
  248. '.$avgCoursesPerStudent.'
  249. </td>
  250. </tr>
  251. <tr>
  252. <td>
  253. '.get_lang('AverageProgressInLearnpath').'
  254. </td>
  255. <td align="right">
  256. '.round($avgTotalProgress,2).' %
  257. </td>
  258. </tr>
  259. <tr>
  260. <td>
  261. '.get_lang('AverageResultsToTheExercices').'
  262. </td>
  263. <td align="right">
  264. '.round($avgResultsToExercises,2).' %
  265. </td>
  266. </tr>
  267. <tr>
  268. <td>
  269. '.get_lang('AveragePostsInForum').'
  270. </td>
  271. <td align="right">
  272. '.round($nb_posts,2).'
  273. </td>
  274. </tr>
  275. <tr>
  276. <td>
  277. '.get_lang('AverageAssignments').'
  278. </td>
  279. <td align="right">
  280. '.round($nb_assignments,2).'
  281. </td>
  282. </tr>
  283. </table>
  284. <a href="student.php">'.get_lang('SeeStudentList').'</a>
  285. </div>';
  286. }
  287. /****************************************
  288. * Infos about sessions of the coach
  289. ****************************************/
  290. $a_sessions = Tracking :: get_sessions_coached_by_user($_user['user_id']);
  291. $nbSessions = count($a_sessions);
  292. $nb_sessions_past = $nb_sessions_future = $nb_sessions_current = 0;
  293. $a_courses = array();
  294. foreach($a_sessions as $a_session)
  295. {
  296. if($a_session['date_start'] == '0000-00-00')
  297. {
  298. $nb_sessions_current ++;
  299. }
  300. else
  301. {
  302. $date_start = explode('-',$a_session['date_start']);
  303. $time_start = mktime(0,0,0,$date_start[1],$date_start[2],$date_start[0]);
  304. $date_end = explode('-',$a_session['date_end']);
  305. $time_end = mktime(0,0,0,$date_end[1],$date_end[2],$date_end[0]);
  306. if($time_start < time() && time() < $time_end)
  307. {
  308. $nb_sessions_current++;
  309. }
  310. else if(time() < $time_start)
  311. {
  312. $nb_sessions_future++;
  313. }
  314. else if(time() > $time_end)
  315. {
  316. $nb_sessions_past++;
  317. }
  318. }
  319. $a_courses = array_merge($a_courses, Tracking::get_courses_list_from_session($a_session['id']));
  320. }
  321. $nb_courses_per_session = round(count($a_courses)/$nbSessions,2);
  322. //csv part
  323. if($export_csv)
  324. {
  325. $csv_content[] = array( get_lang('Sessions'));
  326. $csv_content[] = array( get_lang('NbActiveSessions').';'.$nb_sessions_current);
  327. $csv_content[] = array( get_lang('NbPastSessions').';'.$nb_sessions_past);
  328. $csv_content[] = array( get_lang('NbFutureSessions').';'.$nb_sessions_future);
  329. $csv_content[] = array( get_lang('NbStudentPerSession').';'.round($nbStudents/$nbSessions,2));
  330. $csv_content[] = array( get_lang('NbCoursesPerSession').';'.$nb_courses_per_session);
  331. $csv_content[] = array();
  332. }
  333. // html part
  334. else
  335. {
  336. echo '
  337. <div class="admin_section">
  338. <h4>
  339. <a href="session.php"><img src="'.api_get_path(WEB_IMG_PATH).'sessions.gif">&nbsp;'.get_lang('Sessions').' ('.$nbSessions.')'.'</a>
  340. </h4>
  341. <table class="data_table">
  342. <tr>
  343. <td>
  344. '.get_lang('NbActiveSessions').'
  345. </td>
  346. <td align="right">
  347. '.$nb_sessions_current.'
  348. </td>
  349. </tr>
  350. <tr>
  351. <td>
  352. '.get_lang('NbPastSessions').'
  353. </td>
  354. <td align="right">
  355. '.$nb_sessions_past.'
  356. </td>
  357. </tr>
  358. <tr>
  359. <td>
  360. '.get_lang('NbFutureSessions').'
  361. </td>
  362. <td align="right">
  363. '.$nb_sessions_future.'
  364. </td>
  365. </tr>
  366. <tr>
  367. <td>
  368. '.get_lang('NbStudentPerSession').'
  369. </td>
  370. <td align="right">
  371. '.round($nbStudents/$nbSessions,2).'
  372. </td>
  373. </tr>
  374. <tr>
  375. <td>
  376. '.get_lang('NbCoursesPerSession').'
  377. </td>
  378. <td align="right">
  379. '.$nb_courses_per_session.'
  380. </td>
  381. </tr>
  382. </table>
  383. <a href="session.php">'.get_lang('SeeSessionList').'</a>
  384. </div>';
  385. }
  386. }
  387. echo '<div class="clear">&nbsp;</div>';
  388. if(api_is_allowed_to_create_course() && $view=='teacher')
  389. {
  390. if($nb_teacher_courses)
  391. {
  392. $table = new SortableTable('tracking_list_course', 'count_teacher_courses');
  393. $parameters['view'] = 'teacher';
  394. $table->set_additional_parameters($parameters);
  395. $table -> set_header(0, get_lang('CourseTitle'), false, 'align="center"');
  396. $table -> set_header(1, get_lang('NbStudents'), false);
  397. $table -> set_header(2, get_lang('AvgTimeSpentInTheCourse'), false);
  398. $table -> set_header(3, get_lang('AvgStudentsProgress'), false);
  399. $table -> set_header(4, get_lang('AvgStudentsScore'), false);
  400. $table -> set_header(5, get_lang('AvgMessages'), false);
  401. $table -> set_header(6, get_lang('AvgAssignments'), false);
  402. $table -> set_header(7, get_lang('Details'), false);
  403. $csv_content[] = array(
  404. get_lang('CourseTitle'),
  405. get_lang('NbStudents'),
  406. get_lang('AvgTimeSpentInTheCourse'),
  407. get_lang('AvgStudentsProgress'),
  408. get_lang('AvgStudentsScore'),
  409. get_lang('AvgMessages'),
  410. get_lang('AvgAssignments')
  411. );
  412. $a_students = array();
  413. $a_course_students = array();
  414. foreach($a_courses as $course)
  415. {
  416. $course_code = $course['course_code'];
  417. $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 = 0;
  418. // students directly subscribed to the course
  419. $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'";
  420. $rs = api_sql_query($sql, __FILE__, __LINE__);
  421. while($row = mysql_fetch_array($rs))
  422. {
  423. $nb_students_in_course++;
  424. // tracking datas
  425. $avg_progress_in_course += Tracking :: get_avg_student_progress ($row['user_id'], $course_code);
  426. $avg_score_in_course += Tracking :: get_avg_student_score ($row['user_id'], $course_code);
  427. $avg_time_spent_in_course += Tracking :: get_time_spent_on_the_course ($row['user_id'], $course_code);
  428. $avg_messages_in_course += Tracking :: count_student_messages ($row['user_id'], $course_code);
  429. $avg_assignments_in_course += Tracking :: count_student_assignments ($row['user_id'], $course_code);
  430. $a_students[] = $row['user_id'];
  431. $a_course_students = $row['user_id'];
  432. }
  433. // students subscribed to the course throw a session
  434. if(api_get_setting('use_session_mode') == 'true')
  435. {
  436. $sql = 'SELECT id_user as user_id
  437. FROM '.$tbl_session_course_user.'
  438. WHERE course_code="'.addslashes($course_code).'" ORDER BY course_code';
  439. $rs = api_sql_query($sql, __FILE__, __LINE__);
  440. while($row = mysql_fetch_array($rs))
  441. {
  442. if(!in_array($row['user_id'], $a_course_students))
  443. {
  444. $nb_students_in_course++;
  445. // tracking datas
  446. $avg_progress_in_course += Tracking :: get_avg_student_progress ($row['user_id'], $course_code);
  447. $avg_score_in_course += Tracking :: get_avg_student_score ($row['user_id'], $course_code);
  448. $avg_time_spent_in_course += Tracking :: get_time_spent_on_the_course ($row['user_id'], $course_code);
  449. $avg_messages_in_course += Tracking :: count_student_messages ($row['user_id'], $course_code);
  450. $avg_assignments_in_course += Tracking :: count_student_assignments ($row['user_id'], $course_code);
  451. $a_students[] = $row['user_id'];
  452. $a_course_students = $row['user_id'];
  453. }
  454. }
  455. }
  456. if($nb_students_in_course>0)
  457. {
  458. $avg_time_spent_in_course = api_time_to_hms($avg_time_spent_in_course / $nb_students_in_course);
  459. $avg_progress_in_course = round($avg_progress_in_course / $nb_students_in_course,2).' %';
  460. $avg_score_in_course = round($avg_score_in_course / $nb_students_in_course,2).' %';
  461. $avg_messages_in_course = round($avg_messages_in_course / $nb_students_in_course,2);
  462. $avg_assignments_in_course = round($avg_assignments_in_course / $nb_students_in_course,2);
  463. }
  464. $table_row = array();
  465. $table_row[] = $course['title'];
  466. $table_row[] = $nb_students_in_course;
  467. $table_row[] = $avg_time_spent_in_course;
  468. $table_row[] = $avg_progress_in_course;
  469. $table_row[] = $avg_score_in_course;
  470. $table_row[] = $avg_messages_in_course;
  471. $table_row[] = $avg_assignments_in_course;
  472. $table_row[] = '<a href="../tracking/courseLog.php?cidReq='.$course_code.'&studentlist=true"><img src="'.api_get_path(WEB_IMG_PATH).'2rightarrow.gif" border="0" /></a>';
  473. $csv_content[] = array(
  474. $course['title'],
  475. $nb_students_in_course,
  476. $avg_time_spent_in_course,
  477. $avg_progress_in_course,
  478. $avg_score_in_course,
  479. $avg_messages_in_course,
  480. $avg_assignments_in_course,
  481. );
  482. $table -> addRow($table_row, 'align="right"');
  483. $a_course_students = array();
  484. }
  485. $table -> updateColAttributes(0,array('align'=>'left'));
  486. $table -> updateColAttributes(7,array('align'=>'center'));
  487. $table -> display();
  488. }
  489. }
  490. if(api_is_platform_admin() && $view=='admin'){
  491. $tracking_column = isset($_GET['tracking_list_coaches_column']) ? $_GET['tracking_list_coaches_column'] : 0;
  492. $tracking_direction = isset($_GET['tracking_list_coaches_direction']) ? $_GET['tracking_list_coaches_direction'] : 'DESC';
  493. //prepare array for column order - when impossible, use lastname
  494. $order = array(0=>'firstname',1=>'lastname',2=>'lastname',3=>'login_date',4=>'lastname',5=>'lastname');
  495. $table = new SortableTable('tracking_list_coaches', 'count_coaches');
  496. $parameters['view'] = 'admin';
  497. $table->set_additional_parameters($parameters);
  498. $table -> set_header(0, get_lang('FirstName'), true, 'align="center"');
  499. $table -> set_header(1, get_lang('LastName'), true, 'align="center"');
  500. $table -> set_header(2, get_lang('TimeSpentOnThePlatform'), false);
  501. $table -> set_header(3, get_lang('LastConnexion'), true, 'align="center"');
  502. $table -> set_header(4, get_lang('NbStudents'), false);
  503. $table -> set_header(5, get_lang('CountCours'), false);
  504. $table -> set_header(6, get_lang('NumberOfSessions'), false);
  505. $table -> set_header(7, get_lang('Sessions'), false,'align="center"');
  506. $csv_content[] = array(
  507. get_lang('FirstName'),
  508. get_lang('LastName'),
  509. get_lang('TimeSpentOnThePlatform'),
  510. get_lang('LastConnexion'),
  511. get_lang('NbStudents'),
  512. get_lang('CountCours'),
  513. get_lang('NumberOfSessions')
  514. );
  515. $tbl_track_login = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_LOGIN);
  516. $sqlCoachs = " SELECT DISTINCT id_coach, user_id, lastname, firstname, MAX(login_date) as login_date
  517. FROM $tbl_user, $tbl_session_course, $tbl_track_login
  518. WHERE id_coach=user_id AND login_user_id=user_id
  519. GROUP BY user_id " .
  520. // ORDER BY login_date ".$tracking_direction;
  521. "ORDER BY ".$order[$tracking_column]." ".$tracking_direction;
  522. $result_coaches=api_sql_query($sqlCoachs, __FILE__, __LINE__);
  523. $total_no_coachs = mysql_num_rows($result_coaches);
  524. $global_coachs=array();
  525. while($a_coach=mysql_fetch_array($result_coaches)){
  526. $global_coachs[$a_coach['user_id']] = $a_coach;
  527. }
  528. $sql_session_coach = 'SELECT session.id_coach, user_id, lastname, firstname, MAX(login_date) as login_date
  529. FROM '.$tbl_user.','.$tbl_sessions.' as session,'.$tbl_track_login.'
  530. WHERE id_coach=user_id AND login_user_id=user_id
  531. GROUP BY user_id
  532. ORDER BY login_date '.$tracking_direction;
  533. $result_sessions_coach=api_sql_query($sql_session_coach, __FILE__, __LINE__);
  534. $total_no_coachs += mysql_num_rows($result_sessions_coach);
  535. while($a_coach=mysql_fetch_array($result_sessions_coach)){
  536. $global_coachs[$a_coach['user_id']] = $a_coach;
  537. }
  538. $all_datas=array();
  539. foreach($global_coachs as $id_coach => $a_coachs){
  540. $time_on_platform = api_time_to_hms(Tracking :: get_time_spent_on_the_platform($a_coachs['user_id']));
  541. $last_connection = Tracking :: get_last_connection_date($a_coachs['user_id']);
  542. $nb_students = count(Tracking :: get_student_followed_by_coach($a_coachs['user_id']));
  543. $nb_courses = count(Tracking :: get_courses_followed_by_coach($a_coachs['user_id']));
  544. $nb_sessions = count(Tracking :: get_sessions_coached_by_user($a_coachs['user_id']));
  545. $table_row = array();
  546. $table_row[] = $a_coachs['firstname'];
  547. $table_row[] = $a_coachs['lastname'];
  548. $table_row[] = $time_on_platform;
  549. $table_row[] = $last_connection;
  550. $table_row[] = $nb_students;
  551. $table_row[] = $nb_courses;
  552. $table_row[] = $nb_sessions;
  553. $table_row[] = '<a href="session.php?id_coach='.$a_coachs['user_id'].'"><img src="'.api_get_path(WEB_IMG_PATH).'2rightarrow.gif" border="0" /></a>';
  554. $all_datas[] = $table_row;
  555. $csv_content[] = array(
  556. $a_coachs['firstname'],
  557. $a_coachs['lastname'],
  558. $time_on_platform,
  559. $last_connection,
  560. $nb_courses,
  561. $nb_sessions
  562. );
  563. }
  564. if($tracking_column != 3){
  565. usort($all_datas, 'sort_users');
  566. if($tracking_direction == 'DESC')
  567. rsort($all_datas);
  568. }
  569. if($export_csv && $tracking_column != 3)
  570. {
  571. usort($csv_content, 'sort_users');
  572. }
  573. foreach($all_datas as $row)
  574. {
  575. $table -> addRow($row,'align="right"');
  576. }
  577. $table -> updateColAttributes(0,array('align'=>'left'));
  578. $table -> updateColAttributes(1,array('align'=>'left'));
  579. $table -> updateColAttributes(3,array('align'=>'left'));
  580. $table -> updateColAttributes(7,array('align'=>'center'));
  581. $table -> display();
  582. }
  583. // send the csv file if asked
  584. if($export_csv)
  585. {
  586. ob_end_clean();
  587. Export :: export_table_csv($csv_content, 'reporting_index');
  588. }
  589. /*
  590. ==============================================================================
  591. FOOTER
  592. ==============================================================================
  593. */
  594. if(!$export_csv)
  595. {
  596. Display::display_footer();
  597. }
  598. ?>