teachers.php 4.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212
  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. {
  29. global $archiveDirName;
  30. $fileName = 'teachers.csv';
  31. $archivePath = api_get_path(SYS_PATH).$archiveDirName.'/';
  32. $archiveURL = api_get_path(WEB_CODE_PATH).'course_info/download.php?archive=';
  33. if(!$open = fopen($archivePath.$fileName,'w+'))
  34. {
  35. $message = get_lang('noOpen');
  36. }
  37. else
  38. {
  39. $info = '';
  40. foreach($a_header as $header)
  41. {
  42. $info .= $header.';';
  43. }
  44. $info .= "\r\n";
  45. foreach($a_data as $data)
  46. {
  47. foreach($data as $infos)
  48. {
  49. $info .= $infos.';';
  50. }
  51. $info .= "\r\n";
  52. }
  53. fwrite($open,$info);
  54. fclose($open);
  55. $perm = api_get_setting('permissions_for_new_files');
  56. $perm = octdec(!empty($perm)?$perm:'0660');
  57. chmod($fileName,$perm);
  58. header("Location:".$archiveURL.$fileName);
  59. }
  60. return $message;
  61. }
  62. /**
  63. * MAIN PART
  64. */
  65. if(isset($_GET["teacher_id"]) && $_GET["teacher_id"]!=0){
  66. $i_teacher_id=$_GET["teacher_id"];
  67. $sqlFormateurs = " SELECT user_id,lastname,firstname,email
  68. FROM $tbl_user
  69. WHERE user_id='$i_teacher_id'
  70. ORDER BY lastname ASC
  71. ";
  72. }
  73. else{
  74. $sqlFormateurs = " SELECT user_id,lastname,firstname,email
  75. FROM $tbl_user
  76. WHERE status = 1
  77. ORDER BY lastname ASC
  78. ";
  79. }
  80. $resultFormateurs = api_sql_query($sqlFormateurs);
  81. echo '<table class="data_table">
  82. <tr>
  83. <th>
  84. '.get_lang('FirstName').'
  85. </th>
  86. <th>
  87. '.get_lang('LastName').'
  88. </th>
  89. <th>
  90. '.get_lang('Email').'
  91. </th>
  92. <th>
  93. '.get_lang('AdminCourses').'
  94. </th>
  95. <th>
  96. '.get_lang('Students').'
  97. </th>
  98. </tr>
  99. ';
  100. $a_header[]=get_lang('FirstName');
  101. $a_header[]=get_lang('LastName');
  102. $a_header[]=get_lang('Email');
  103. $a_data=array();
  104. if(mysql_num_rows($resultFormateurs)>0){
  105. $i=1;
  106. while($a_formateurs=mysql_fetch_array($resultFormateurs)){
  107. $i_user_id=$a_formateurs["user_id"];
  108. $s_lastname=$a_formateurs["lastname"];
  109. $s_firstname=$a_formateurs["firstname"];
  110. $s_email=$a_formateurs["email"];
  111. if($i%2==0){
  112. $s_css_class="row_odd";
  113. if($i%20==0 && $i!=0){
  114. echo '<tr>
  115. <th>
  116. '.get_lang('FirstName').'
  117. </th>
  118. <th>
  119. '.get_lang('LastName').'
  120. </th>
  121. <th>
  122. '.get_lang('Email').'
  123. </th>
  124. <th>
  125. '.get_lang('AdminCourses').'
  126. </th>
  127. <th>
  128. '.get_lang('Students').'
  129. </th>
  130. </tr>';
  131. }
  132. }
  133. else{
  134. $s_css_class="row_even";
  135. }
  136. $i++;
  137. $a_data[$i_user_id]["firstname"]=$s_firstname;
  138. $a_data[$i_user_id]["lastname"]=$s_lastname;
  139. $a_data[$i_user_id]["email"]=$s_email;
  140. 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.'">-></a></td><td><a href="student.php?user_id='.$i_user_id.'">-></a></td></tr>';
  141. }
  142. }
  143. //No results
  144. else{
  145. echo '<tr><td colspan="5" "align=center">'.get_lang("NoResults").'</td></tr>';
  146. }
  147. echo '</table>';
  148. if(isset($_POST['export'])){
  149. exportCsv($a_header,$a_data);
  150. }
  151. echo "<br /><br />";
  152. echo "<form method='post' action='teachers.php'>
  153. <input type='submit' name='export' value='".get_lang('exportExcel')."'/>
  154. <form>";
  155. /*
  156. ==============================================================================
  157. FOOTER
  158. ==============================================================================
  159. */
  160. Display::display_footer();
  161. ?>