course_information.php 7.3 KB

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