teachers.php 5.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136
  1. <?php
  2. /* For licensing terms, see /dokeos_license.txt */
  3. /*
  4. * Created on 18 October 2006 by Elixir Interactive http://www.elixir-interactive.com
  5. */
  6. ob_start();
  7. // names of the language file that needs to be included
  8. $language_file = array ('registration', 'index', 'trad4all', 'tracking', 'admin');
  9. $cidReset = true;
  10. require_once '../inc/global.inc.php';
  11. require_once api_get_path(SYS_CODE_PATH).'mySpace/myspace.lib.php';
  12. $this_section = "session_my_space";
  13. $nameTools = get_lang('Teachers');
  14. api_block_anonymous_users();
  15. $interbreadcrumb[] = array ("url" => "index.php", "name" => get_lang('MySpace'));
  16. Display :: display_header($nameTools);
  17. api_display_tool_title($nameTools);
  18. // Database Table Definitions
  19. $tbl_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  20. $tbl_user = Database :: get_main_table(TABLE_MAIN_USER);
  21. $tbl_session = Database :: get_main_table(TABLE_MAIN_SESSION);
  22. $tbl_session_course = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE);
  23. $tbl_session_rel_user = Database :: get_main_table(TABLE_MAIN_SESSION_USER);
  24. /**
  25. * MAIN PART
  26. */
  27. if (isset($_POST['export'])) {
  28. $is_western_name_order = api_is_western_name_order(PERSON_NAME_DATA_EXPORT);
  29. } else {
  30. $is_western_name_order = api_is_western_name_order();
  31. }
  32. $sort_by_first_name = api_sort_by_first_name();
  33. $order_clause = $sort_by_first_name ? ' ORDER BY firstname, lastname' : ' ORDER BY lastname, firstname';
  34. if (isset($_GET["teacher_id"]) && $_GET["teacher_id"] != 0) {
  35. $teacher_id = intval($_GET["teacher_id"]);
  36. $sql_formateurs = "SELECT user_id,lastname,firstname,email
  37. FROM $tbl_user
  38. WHERE user_id='$teacher_id'".$order_clause;
  39. } else {
  40. $sql_formateurs = "SELECT user_id,lastname,firstname,email
  41. FROM $tbl_user
  42. WHERE status = 1".$order_clause;
  43. }
  44. $result_formateurs = Database::query($sql_formateurs, __FILE__, __LINE__);
  45. if ($is_western_name_order) {
  46. echo '<table class="data_table"><tr><th>'.get_lang('FirstName').'</th><th>'.get_lang('LastName').'</th><th>'.get_lang('Email').'</th><th>'.get_lang('AdminCourses').'</th><th>'.get_lang('Students').'</th></tr>';
  47. } else {
  48. echo '<table class="data_table"><tr><th>'.get_lang('LastName').'</th><th>'.get_lang('FirstName').'</th><th>'.get_lang('Email').'</th><th>'.get_lang('AdminCourses').'</th><th>'.get_lang('Students').'</th></tr>';
  49. }
  50. if ($is_western_name_order) {
  51. $header[] = get_lang('FirstName', '');
  52. $header[] = get_lang('LastName', '');
  53. } else {
  54. $header[] = get_lang('LastName', '');
  55. $header[] = get_lang('FirstName', '');
  56. }
  57. $header[] = get_lang('Email', '');
  58. $data = array();
  59. if (Database::num_rows($result_formateurs) > 0) {
  60. $i = 1;
  61. while ($formateurs = Database::fetch_array($result_formateurs)) {
  62. $user_id = $formateurs["user_id"];
  63. $lastname = $formateurs["lastname"];
  64. $firstname = $formateurs["firstname"];
  65. $email = $formateurs["email"];
  66. if ($i % 2 == 0) {
  67. $css_class = "row_odd";
  68. if ($i % 20 == 0 && $i != 0) {
  69. if ($is_western_name_order) {
  70. echo '<tr><th>'.get_lang('FirstName').'</th><th>'.get_lang('LastName').'</th><th>'.get_lang('Email').'</th><th>'.get_lang('AdminCourses').'</th><th>'.get_lang('Students').'</th></tr>';
  71. } else {
  72. echo '<tr><th>'.get_lang('LastName').'</th><th>'.get_lang('FirstName').'</th><th>'.get_lang('Email').'</th><th>'.get_lang('AdminCourses').'</th><th>'.get_lang('Students').'</th></tr>';
  73. }
  74. }
  75. } else {
  76. $css_class = "row_even";
  77. }
  78. $i++;
  79. if ($is_western_name_order) {
  80. $data[$user_id]["firstname"] = $firstname;
  81. $data[$user_id]["lastname"] = $lastname;
  82. } else {
  83. $data[$user_id]["lastname"] = $lastname;
  84. $data[$user_id]["firstname"] = $firstname;
  85. }
  86. $data[$user_id]["email"] = $email;
  87. if ($is_western_name_order) {
  88. echo '<tr class="'.$css_class.'"><td>'.$firstname.'</td><td>'.$lastname.'</td><td><a href="mailto:'.$email.'">'.$email.'</a></td><td><a href="course.php?user_id='.$user_id.'"><img src="'.api_get_path(WEB_IMG_PATH).'2rightarrow.gif" border="0" /></a></td><td><a href="student.php?user_id='.$user_id.'"><img src="'.api_get_path(WEB_IMG_PATH).'2rightarrow.gif" border="0" /></a></td></tr>';
  89. } else {
  90. echo '<tr class="'.$css_class.'"><td>'.$lastname.'</td><td>'.$firstname.'</td><td><a href="mailto:'.$email.'">'.$email.'</a></td><td><a href="course.php?user_id='.$user_id.'"><img src="'.api_get_path(WEB_IMG_PATH).'2rightarrow.gif" border="0" /></a></td><td><a href="student.php?user_id='.$user_id.'"><img src="'.api_get_path(WEB_IMG_PATH).'2rightarrow.gif" border="0" /></a></td></tr>';
  91. }
  92. }
  93. } else {
  94. // No results
  95. echo '<tr><td colspan="5" "align=center">'.get_lang("NoResults").'</td></tr>';
  96. }
  97. echo '</table>';
  98. if (isset($_POST['export'])) {
  99. export_csv($header, $data, 'teachers.csv');
  100. }
  101. echo "<br /><br />";
  102. echo "<form method='post' action='teachers.php'><input type='submit' name='export' value='".get_lang('exportExcel')."'/><form>";
  103. /*
  104. ==============================================================================
  105. FOOTER
  106. ==============================================================================
  107. */
  108. Display::display_footer();