session.php 4.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /*
  4. * Sessions reporting
  5. * @package chamilo.reporting
  6. */
  7. ob_start();
  8. $nameTools= 'Sessions';
  9. // name of the language file that needs to be included
  10. $language_file = array ('registration', 'index', 'trad4all', 'tracking', 'admin');
  11. $cidReset = true;
  12. require_once '../inc/global.inc.php';
  13. require_once api_get_path(LIBRARY_PATH).'export.lib.inc.php';
  14. api_block_anonymous_users();
  15. $this_section = SECTION_TRACKING;
  16. api_block_anonymous_users();
  17. $interbreadcrumb[] = array ("url" => "index.php", "name" => get_lang('MySpace'));
  18. Display :: display_header($nameTools);
  19. $export_csv = false;
  20. if (isset($_GET['export']) && $_GET['export'] == 'csv') {
  21. $export_csv = true;
  22. }
  23. /*
  24. FUNCTION
  25. */
  26. function count_sessions_coached() {
  27. global $nb_sessions;
  28. return $nb_sessions;
  29. }
  30. function sort_sessions($a, $b) {
  31. global $tracking_column;
  32. if ($a[$tracking_column] > $b[$tracking_column]) {
  33. return 1;
  34. } else {
  35. return -1;
  36. }
  37. }
  38. function rsort_sessions($a, $b) {
  39. global $tracking_column;
  40. if ($b[$tracking_column] > $a[$tracking_column]) {
  41. return 1;
  42. } else {
  43. return -1;
  44. }
  45. }
  46. /* MAIN CODE */
  47. if (isset($_GET['id_coach']) && $_GET['id_coach'] != '') {
  48. $id_coach = intval($_GET['id_coach']);
  49. } else {
  50. $id_coach = api_get_user_id();
  51. }
  52. if (api_is_drh() || api_is_session_admin() || api_is_platform_admin()) {
  53. $a_sessions = SessionManager :: get_sessions_coached_by_user(api_get_user_id());
  54. $a_sessions_drh = SessionManager::get_sessions_followed_by_drh(api_get_user_id());
  55. if (!empty($a_sessions_drh)) {
  56. $a_sessions = array_merge($a_sessions, $a_sessions_drh);
  57. }
  58. if (!api_is_session_admin()) {
  59. $menu_items[] = Display::url(Display::return_icon('stats.png', get_lang('MyStats'),'',ICON_SIZE_MEDIUM),api_get_path(WEB_CODE_PATH)."auth/my_progress.php" );
  60. $menu_items[] = Display::url(Display::return_icon('user.png', get_lang('Students'), array(), 32), "index.php?view=drh_students&amp;display=yourstudents");
  61. $menu_items[] = Display::url(Display::return_icon('teacher.png', get_lang('Trainers'), array(), 32), 'teachers.php');
  62. $menu_items[] = Display::url(Display::return_icon('course.png', get_lang('Courses'), array(), 32), 'course.php');
  63. $menu_items[] = Display::return_icon('session_na.png', get_lang('Sessions'), array(), 32);
  64. }
  65. echo '<div class="actions">';
  66. $nb_menu_items = count($menu_items);
  67. if ($nb_menu_items > 1) {
  68. foreach ($menu_items as $key => $item) {
  69. echo $item;
  70. }
  71. }
  72. if (count($a_sessions) > 0) {
  73. echo '<span style="float:right">';
  74. echo Display::url(Display::return_icon('printer.png', get_lang('Print'), array(), 32), 'javascript: void(0);', array('onclick'=>'javascript: window.print();'));
  75. echo Display::url(Display::return_icon('export_csv.png', get_lang('ExportAsCSV'), array(), 32), api_get_self().'?export=csv');
  76. echo '</span>';
  77. }
  78. echo '</div>';
  79. echo Display::page_header(get_lang('YourSessionsList'));
  80. } else {
  81. /*if (api_is_platform_admin()) {
  82. $a_sessions = SessionManager::get_sessions_list();
  83. } else {*/
  84. $a_sessions = SessionManager :: get_sessions_coached_by_user($id_coach);
  85. //}
  86. }
  87. $nb_sessions = count($a_sessions);
  88. if ($export_csv) {
  89. $csv_content = array();
  90. }
  91. if ($nb_sessions > 0) {
  92. $table = new SortableTable('tracking', 'count_sessions_coached');
  93. $table->set_header(0, get_lang('Title'));
  94. $table->set_header(1, get_lang('Date'));
  95. $table->set_header(2, get_lang('NbCoursesPerSession'));
  96. $table->set_header(3, get_lang('Details'), false);
  97. $all_data = array();
  98. foreach ($a_sessions as $session) {
  99. $row = array();
  100. $row[] = $session['name'];
  101. $row[] = SessionManager::parse_session_dates($session);
  102. $row[] = count(Tracking::get_courses_list_from_session($session['id']));
  103. if ($export_csv) {
  104. $csv_content[] = $row;
  105. }
  106. if (isset($_GET['id_coach']) && $_GET['id_coach'] != '') {
  107. $row[] = '<a href="student.php?id_session='.$session['id'].'&id_coach='.intval($_GET['id_coach']).'"><img src="'.api_get_path(WEB_IMG_PATH).'2rightarrow.gif" border="0" /></a>';
  108. } else {
  109. $row[] = '<a href="course.php?id_session='.$session['id'].'"><img src="'.api_get_path(WEB_IMG_PATH).'2rightarrow.gif" border="0" /></a>';
  110. }
  111. $all_data[] = $row;
  112. }
  113. if (!isset($tracking_column)) {
  114. $tracking_column = 0;
  115. }
  116. if ($_GET['tracking_direction'] == 'DESC') {
  117. usort($all_data, 'rsort_sessions');
  118. } else {
  119. usort($all_data, 'sort_sessions');
  120. }
  121. if ($export_csv) {
  122. usort($csv_content, 'sort_sessions');
  123. }
  124. foreach ($all_data as $row) {
  125. $table -> addRow($row);
  126. }
  127. //$table -> setColAttributes(2, array('align' => 'center'));
  128. $table -> display();
  129. if ($export_csv) {
  130. ob_end_clean();
  131. Export :: export_table_csv($csv_content, 'reporting_student_list');
  132. exit;
  133. }
  134. } else {
  135. echo get_lang('NoSession');
  136. }
  137. Display::display_footer();