teachers.php 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151
  1. <?php
  2. /*
  3. * Created on 18 October 2006 by Elixir Interactive http://www.elixir-interactive.com
  4. */
  5. ob_start();
  6. // names of the language file that needs to be included
  7. $language_file = array ('registration', 'index','trad4all', 'tracking', 'admin');
  8. $cidReset = true;
  9. require '../inc/global.inc.php';
  10. $this_section = "session_my_space";
  11. $nameTools= get_lang('Teachers');
  12. api_block_anonymous_users();
  13. $interbreadcrumb[] = array ("url" => "index.php", "name" => get_lang('MySpace'));
  14. Display :: display_header($nameTools);
  15. api_display_tool_title($nameTools);
  16. // Database Table Definitions
  17. $tbl_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  18. $tbl_user = Database :: get_main_table(TABLE_MAIN_USER);
  19. $tbl_session = Database :: get_main_table(TABLE_MAIN_SESSION);
  20. $tbl_session_course = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE);
  21. $tbl_session_rel_user = Database :: get_main_table(TABLE_MAIN_SESSION_USER);
  22. /*
  23. ===============================================================================
  24. FUNCTION
  25. ===============================================================================
  26. */
  27. function exportCsv($a_header, $a_data) {
  28. global $archiveDirName;
  29. $fileName = 'teachers.csv';
  30. $archivePath = api_get_path(SYS_ARCHIVE_PATH);
  31. $archiveURL = api_get_path(WEB_CODE_PATH).'course_info/download.php?archive=';
  32. if (!$open = fopen($archivePath.$fileName, 'w+')) {
  33. $message = get_lang('noOpen');
  34. } else {
  35. $info = '';
  36. foreach ($a_header as $header) {
  37. $info .= $header.';';
  38. }
  39. $info .= "\r\n";
  40. foreach ($a_data as $data) {
  41. foreach ($data as $infos) {
  42. $info .= $infos.';';
  43. }
  44. $info .= "\r\n";
  45. }
  46. fwrite($open,$info);
  47. fclose($open);
  48. $perm = api_get_setting('permissions_for_new_files');
  49. $perm = octdec(!empty($perm)?$perm:'0660');
  50. chmod($fileName,$perm);
  51. header("Location:".$archiveURL.$fileName);
  52. }
  53. return $message;
  54. }
  55. /**
  56. * MAIN PART
  57. */
  58. if (isset($_GET["teacher_id"]) && $_GET["teacher_id"] != 0) {
  59. $i_teacher_id=$_GET["teacher_id"];
  60. $sqlFormateurs = "SELECT user_id,lastname,firstname,email
  61. FROM $tbl_user
  62. WHERE user_id='$i_teacher_id'
  63. ORDER BY lastname ASC";
  64. } else {
  65. $sqlFormateurs = "SELECT user_id,lastname,firstname,email
  66. FROM $tbl_user
  67. WHERE status = 1
  68. ORDER BY lastname ASC";
  69. }
  70. $resultFormateurs = Database::query($sqlFormateurs, __FILE__, __LINE__);
  71. 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>';
  72. $a_header[] = get_lang('FirstName');
  73. $a_header[] = get_lang('LastName');
  74. $a_header[] = get_lang('Email');
  75. $a_data = array();
  76. if (Database::num_rows($resultFormateurs) > 0) {
  77. $i = 1;
  78. while ($a_formateurs = Database::fetch_array($resultFormateurs)) {
  79. $i_user_id = $a_formateurs["user_id"];
  80. $s_lastname = $a_formateurs["lastname"];
  81. $s_firstname = $a_formateurs["firstname"];
  82. $s_email = $a_formateurs["email"];
  83. if ($i%2 == 0) {
  84. $s_css_class = "row_odd";
  85. if ($i%20 == 0 && $i != 0){
  86. 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>';
  87. }
  88. } else {
  89. $s_css_class = "row_even";
  90. }
  91. $i++;
  92. $a_data[$i_user_id]["firstname"]=$s_firstname;
  93. $a_data[$i_user_id]["lastname"]=$s_lastname;
  94. $a_data[$i_user_id]["email"]=$s_email;
  95. echo '<tr class="'.$s_css_class.'"><td>'.$s_firstname.'</td><td>'.$s_lastname.'</td><td><a href="mailto:'.$s_email.'">'.$s_email.'</a></td><td><a href="course.php?user_id='.$i_user_id.'"><img src="'.api_get_path(WEB_IMG_PATH).'2rightarrow.gif" border="0" /></a></td><td><a href="student.php?user_id='.$i_user_id.'"><img src="'.api_get_path(WEB_IMG_PATH).'2rightarrow.gif" border="0" /></a></td></tr>';
  96. }
  97. }
  98. //No results
  99. else {
  100. echo '<tr><td colspan="5" "align=center">'.get_lang("NoResults").'</td></tr>';
  101. }
  102. echo '</table>';
  103. if (isset($_POST['export'])) {
  104. exportCsv($a_header,$a_data);
  105. }
  106. echo "<br /><br />";
  107. echo "<form method='post' action='teachers.php'><input type='submit' name='export' value='".get_lang('exportExcel')."'/><form>";
  108. /*
  109. ==============================================================================
  110. FOOTER
  111. ==============================================================================
  112. */
  113. Display::display_footer();