teachers.php 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204
  1. <?php
  2. /*
  3. * Created on 18 October 2006 by Elixir Interactive http://www.elixir-interactive.com
  4. */
  5. ob_start();
  6. $langFile = array ('registration', 'index','trad4all', 'tracking', 'admin');
  7. $cidReset=true;
  8. require ('../inc/global.inc.php');
  9. $this_section = "session_my_space";
  10. $nameTools= get_lang('Teachers');
  11. api_block_anonymous_users();
  12. $interbreadcrumb[] = array ("url" => "index.php", "name" => get_lang('MySpace'));
  13. Display :: display_header($nameTools);
  14. api_display_tool_title($nameTools);
  15. $tbl_course = Database :: get_main_table(MAIN_COURSE_TABLE);
  16. $tbl_user = Database :: get_main_table(MAIN_USER_TABLE);
  17. $tbl_session = Database :: get_main_table(MAIN_SESSION_TABLE);
  18. $tbl_session_course = Database :: get_main_table(MAIN_SESSION_COURSE_TABLE);
  19. $tbl_session_rel_user = Database :: get_main_table(MAIN_SESSION_USER_TABLE);
  20. /*
  21. ===============================================================================
  22. FUNCTION
  23. ===============================================================================
  24. */
  25. function exportCsv($a_header,$a_data)
  26. {
  27. global $archiveDirName;
  28. $fileName = 'teachers.csv';
  29. $archivePath = api_get_path(SYS_PATH).$archiveDirName.'/';
  30. $archiveURL = api_get_path(WEB_CODE_PATH).'course_info/download.php?archive=';
  31. if(!$open = fopen($archivePath.$fileName,'w+'))
  32. {
  33. $message = get_lang('noOpen');
  34. }
  35. else
  36. {
  37. $info = '';
  38. foreach($a_header as $header)
  39. {
  40. $info .= $header.';';
  41. }
  42. $info .= "\r\n";
  43. foreach($a_data as $data)
  44. {
  45. foreach($data as $infos)
  46. {
  47. $info .= $infos.';';
  48. }
  49. $info .= "\r\n";
  50. }
  51. fwrite($open,$info);
  52. fclose($open);
  53. chmod($fileName,0777);
  54. header("Location:".$archiveURL.$fileName);
  55. }
  56. return $message;
  57. }
  58. /**
  59. * MAIN PART
  60. */
  61. /*
  62. * liste nominative avec coordonnées et lien vers les cours et
  63. les stagiaires dont il est le
  64. responsable.
  65. */
  66. $sqlFormateurs = " SELECT user_id,lastname,firstname,email
  67. FROM $tbl_user
  68. WHERE status = 1
  69. ORDER BY lastname ASC
  70. ";
  71. $resultFormateurs = api_sql_query($sqlFormateurs);
  72. echo '<table class="data_table">
  73. <tr>
  74. <th>
  75. '.get_lang('Lastname').'
  76. </th>
  77. <th>
  78. '.get_lang('Firstname').'
  79. </th>
  80. <th>
  81. '.get_lang('Email').'
  82. </th>
  83. <th>
  84. '.get_lang('AdminCourses').'
  85. </th>
  86. <th>
  87. '.get_lang('Students').'
  88. </th>
  89. </tr>
  90. ';
  91. $a_header[]=get_lang('Lastname');
  92. $a_header[]=get_lang('Firstname');
  93. $a_header[]=get_lang('Email');
  94. $a_data=array();
  95. if(mysql_num_rows($resultFormateurs)>0){
  96. $i=1;
  97. while($a_formateurs=mysql_fetch_array($resultFormateurs)){
  98. $i_user_id=$a_formateurs["user_id"];
  99. $s_lastname=$a_formateurs["lastname"];
  100. $s_firstname=$a_formateurs["firstname"];
  101. $s_email=$a_formateurs["email"];
  102. if($i%2==0){
  103. $s_css_class="row_odd";
  104. if($i%20==0 && $i!=0){
  105. echo '<tr>
  106. <th>
  107. '.get_lang('Lastname').'
  108. </th>
  109. <th>
  110. '.get_lang('Firstname').'
  111. </th>
  112. <th>
  113. '.get_lang('Email').'
  114. </th>
  115. <th>
  116. '.get_lang('AdminCourses').'
  117. </th>
  118. <th>
  119. '.get_lang('Students').'
  120. </th>
  121. </tr>';
  122. }
  123. }
  124. else{
  125. $s_css_class="row_even";
  126. }
  127. $i++;
  128. $a_data[$i_user_id]["lastname"]=$s_lastname;
  129. $a_data[$i_user_id]["firstname"]=$s_firstname;
  130. $a_data[$i_user_id]["email"]=$s_email;
  131. echo '<tr class="'.$s_css_class.'"><td>'.$s_lastname.'</td><td>'.$s_firstname.'</td><td><a href="mailto:'.$s_email.'">'.$s_email.'</a></td><td><a href="cours.php?user_id='.$i_user_id.'">-></a></td><td><a href="myStudents.php?user_id='.$i_user_id.'">-></a></td></tr>';
  132. }
  133. }
  134. //No results
  135. else{
  136. echo '<tr><td colspan="5" "align=center">'.get_lang("NoResults").'</td></tr>';
  137. }
  138. echo '</table>';
  139. if(isset($_POST['export'])){
  140. exportCsv($a_header,$a_data);
  141. }
  142. echo "<br /><br />";
  143. echo "<form method='post' action='teachers.php'>
  144. <input type='submit' name='export' value='".get_lang('exportExcel')."'/>
  145. <form>";
  146. /*
  147. ==============================================================================
  148. FOOTER
  149. ==============================================================================
  150. */
  151. Display::display_footer();
  152. ?>