course_information.php 7.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * This script gives information about a course
  5. * @author Bart Mollet
  6. * @package chamilo.admin
  7. */
  8. /**
  9. * INIT SECTION
  10. */
  11. // name of the language file that needs to be included
  12. $language_file = 'admin';
  13. $cidReset = true;
  14. require_once '../inc/global.inc.php';
  15. $this_section = SECTION_PLATFORM_ADMIN;
  16. api_protect_admin_script();
  17. /**
  18. *
  19. */
  20. function get_course_usage($course_code, $session_id = 0) {
  21. $table = Database::get_main_table(TABLE_MAIN_COURSE);
  22. $course_code = Database::escape_string($course_code);
  23. $sql = "SELECT * FROM $table WHERE code='".$course_code."'";
  24. $res = Database::query($sql);
  25. $course = Database::fetch_object($res);
  26. // Learnpaths
  27. $table = Database :: get_course_table(TABLE_LP_MAIN);
  28. $usage[] = array (get_lang(ucfirst(TOOL_LEARNPATH)), CourseManager::count_rows_course_table($table,$session_id, $course->id));
  29. // Forums
  30. $table = Database :: get_course_table(TABLE_FORUM);
  31. $usage[] = array (get_lang('Forums'), CourseManager::count_rows_course_table($table,$session_id, $course->id));
  32. // Quizzes
  33. $table = Database :: get_course_table(TABLE_QUIZ_TEST);
  34. $usage[] = array (get_lang(ucfirst(TOOL_QUIZ)), CourseManager::count_rows_course_table($table,$session_id, $course->id));
  35. // Documents
  36. $table = Database :: get_course_table(TABLE_DOCUMENT);
  37. $usage[] = array (get_lang(ucfirst(TOOL_DOCUMENT)), CourseManager::count_rows_course_table($table,$session_id, $course->id));
  38. // Groups
  39. $table = Database :: get_course_table(TABLE_GROUP);
  40. $usage[] = array (get_lang(ucfirst(TOOL_GROUP)), CourseManager::count_rows_course_table($table,$session_id, $course->id));
  41. // Calendar
  42. $table = Database :: get_course_table(TABLE_AGENDA);
  43. $usage[] = array (get_lang(ucfirst(TOOL_CALENDAR_EVENT)), CourseManager::count_rows_course_table($table,$session_id, $course->id));
  44. // Link
  45. $table = Database::get_course_table(TABLE_LINK);
  46. $usage[] = array(get_lang(ucfirst(TOOL_LINK)), CourseManager::count_rows_course_table($table,$session_id, $course->id));
  47. // Announcements
  48. $table = Database::get_course_table(TABLE_ANNOUNCEMENT);
  49. $usage[] = array(get_lang(ucfirst(TOOL_ANNOUNCEMENT)), CourseManager::count_rows_course_table($table,$session_id, $course->id));
  50. return $usage;
  51. }
  52. if (!isset ($_GET['code'])) {
  53. api_not_allowed();
  54. }
  55. $interbreadcrumb[] = array ("url" => 'index.php', "name" => get_lang('PlatformAdmin'));
  56. $interbreadcrumb[] = array ("url" => 'course_list.php', "name" => get_lang('Courses'));
  57. $table_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  58. $code = Database::escape_string($_GET['code']);
  59. $sql = "SELECT * FROM $table_course WHERE code = '".$code."'";
  60. $res = Database::query($sql);
  61. $course = Database::fetch_object($res);
  62. $tool_name = $course->title.' ('.$course->visual_code.')';
  63. Display::display_header($tool_name);
  64. /* <a href="course_create_content.php?course_code=<?php echo $course->code ?>"><?php echo get_lang('AddDummyContentToCourse') ?></a> */
  65. ?>
  66. <div class="actions">
  67. <a href="<?php echo api_get_path(WEB_COURSE_PATH).$course->directory; ?>"><?php Display::display_icon('home.png', get_lang('CourseHomepage'), array(), ICON_SIZE_MEDIUM); ?></a>
  68. </div>
  69. <?php
  70. echo Display::page_header(get_lang('CourseUsage'));
  71. $id_session = intval($_GET['id_session']);
  72. $table = new SortableTableFromArray(get_course_usage($course->code,$id_session),0,20,'usage_table');
  73. $table->set_additional_parameters(array ('code' => Security::remove_XSS($_GET['code'])));
  74. $table->set_other_tables(array('user_table','class_table'));
  75. $table->set_header(0,get_lang('Tool'), true);
  76. $table->set_header(1,get_lang('NumberOfItems'), true);
  77. $table->display();
  78. /**
  79. * Show all users subscribed in this course
  80. */
  81. echo Display::page_header(get_lang('Users'));
  82. $table_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  83. $table_user = Database :: get_main_table(TABLE_MAIN_USER);
  84. $sql = "SELECT *,cu.status as course_status FROM $table_course_user cu, $table_user u WHERE cu.user_id = u.user_id AND cu.course_code = '".$code."' AND cu.relation_type <> ".COURSE_RELATION_TYPE_RRHH." ";
  85. $res = Database::query($sql);
  86. $is_western_name_order = api_is_western_name_order();
  87. if (Database::num_rows($res) > 0) {
  88. $users = array ();
  89. while ($obj = Database::fetch_object($res)) {
  90. $user = array ();
  91. $user[] = $obj->official_code;
  92. if ($is_western_name_order) {
  93. $user[] = $obj->firstname;
  94. $user[] = $obj->lastname;
  95. } else {
  96. $user[] = $obj->lastname;
  97. $user[] = $obj->firstname;
  98. }
  99. $user[] = Display :: encrypted_mailto_link($obj->email, $obj->email);
  100. $user[] = $obj->course_status == 5 ? get_lang('Student') : get_lang('Teacher');
  101. $user[] = '<a href="user_information.php?user_id='.$obj->user_id.'">'.Display::return_icon('synthese_view.gif',get_lang('UserInfo')).'</a>';
  102. $users[] = $user;
  103. }
  104. $table = new SortableTableFromArray($users,0,20,'user_table');
  105. $table->set_additional_parameters(array ('code' => $code));
  106. $table->set_other_tables(array('usage_table','class_table'));
  107. $table->set_header(0,get_lang('OfficialCode'), true);
  108. if ($is_western_name_order) {
  109. $table->set_header(1,get_lang('FirstName'), true);
  110. $table->set_header(2,get_lang('LastName'), true);
  111. } else {
  112. $table->set_header(1,get_lang('LastName'), true);
  113. $table->set_header(2,get_lang('FirstName'), true);
  114. }
  115. $table->set_header(3,get_lang('Email'), true);
  116. $table->set_header(4,get_lang('Status'), true);
  117. $table->set_header(5,'', false);
  118. $table->display();
  119. } else {
  120. echo get_lang('NoUsersInCourse');
  121. }
  122. $session_list = SessionManager::get_session_by_course($course->code);
  123. $url = api_get_path(WEB_CODE_PATH);
  124. if (!empty($session_list)) {
  125. foreach($session_list as &$session) {
  126. $session[0] = Display::url($session[0], $url.'admin/resume_session.php?id_session='.$session['id'] );
  127. unset($session[1]);
  128. }
  129. echo Display::page_header(get_lang('Sessions'));
  130. $table = new SortableTableFromArray($session_list, 0, 20,'user_table');
  131. $table->display();
  132. }
  133. /*$group = new UserGroup();
  134. $usegroups = $group->get_usergroup_by_course($course->id);*/
  135. /*@todo This should be dissapear classes are a deprecated feature*/
  136. /*
  137. //Show all classes subscribed in this course
  138. $table_course_class = Database :: get_main_table(TABLE_MAIN_COURSE_CLASS);
  139. $table_class = Database :: get_main_table(TABLE_MAIN_CLASS);
  140. $sql = "SELECT * FROM $table_course_class cc, $table_class c WHERE cc.class_id = c.id AND cc.course_code = '".$code."'";
  141. $res = Database::query($sql);
  142. if (Database::num_rows($res) > 0) {
  143. $data = array ();
  144. while ($class = Database::fetch_object($res)) {
  145. $row = array ();
  146. $row[] = $class->name;
  147. $row[] = '<a href="class_information.php?id='.$class->id.'">'.Display::return_icon('synthese_view.gif', get_lang('Edit')).'</a>';
  148. $data[] = $row;
  149. }
  150. echo '<p><b>'.get_lang('AdminClasses').'</b></p>';
  151. echo '<blockquote>';
  152. $table = new SortableTableFromArray($data,0,20,'class_table');
  153. $table->set_additional_parameters(array ('code' => $_GET['code']));
  154. $table->set_other_tables(array('usage_table','user_table'));
  155. $table->set_header(0,get_lang('Title'));
  156. $table->set_header(1,'');
  157. $table->display();
  158. echo '</blockquote>';
  159. } else {
  160. echo '<p>'.get_lang('NoClassesForThisCourse').'</p>';
  161. }*/
  162. /* FOOTER */
  163. Display::display_footer();