teachers.php 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210
  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. chmod($fileName,0777);
  56. header("Location:".$archiveURL.$fileName);
  57. }
  58. return $message;
  59. }
  60. /**
  61. * MAIN PART
  62. */
  63. if(isset($_GET["teacher_id"]) && $_GET["teacher_id"]!=0){
  64. $i_teacher_id=$_GET["teacher_id"];
  65. $sqlFormateurs = " SELECT user_id,lastname,firstname,email
  66. FROM $tbl_user
  67. WHERE user_id='$i_teacher_id'
  68. ORDER BY lastname ASC
  69. ";
  70. }
  71. else{
  72. $sqlFormateurs = " SELECT user_id,lastname,firstname,email
  73. FROM $tbl_user
  74. WHERE status = 1
  75. ORDER BY lastname ASC
  76. ";
  77. }
  78. $resultFormateurs = api_sql_query($sqlFormateurs);
  79. echo '<table class="data_table">
  80. <tr>
  81. <th>
  82. '.get_lang('FirstName').'
  83. </th>
  84. <th>
  85. '.get_lang('LastName').'
  86. </th>
  87. <th>
  88. '.get_lang('Email').'
  89. </th>
  90. <th>
  91. '.get_lang('AdminCourses').'
  92. </th>
  93. <th>
  94. '.get_lang('Students').'
  95. </th>
  96. </tr>
  97. ';
  98. $a_header[]=get_lang('FirstName');
  99. $a_header[]=get_lang('LastName');
  100. $a_header[]=get_lang('Email');
  101. $a_data=array();
  102. if(mysql_num_rows($resultFormateurs)>0){
  103. $i=1;
  104. while($a_formateurs=mysql_fetch_array($resultFormateurs)){
  105. $i_user_id=$a_formateurs["user_id"];
  106. $s_lastname=$a_formateurs["lastname"];
  107. $s_firstname=$a_formateurs["firstname"];
  108. $s_email=$a_formateurs["email"];
  109. if($i%2==0){
  110. $s_css_class="row_odd";
  111. if($i%20==0 && $i!=0){
  112. echo '<tr>
  113. <th>
  114. '.get_lang('FirstName').'
  115. </th>
  116. <th>
  117. '.get_lang('LastName').'
  118. </th>
  119. <th>
  120. '.get_lang('Email').'
  121. </th>
  122. <th>
  123. '.get_lang('AdminCourses').'
  124. </th>
  125. <th>
  126. '.get_lang('Students').'
  127. </th>
  128. </tr>';
  129. }
  130. }
  131. else{
  132. $s_css_class="row_even";
  133. }
  134. $i++;
  135. $a_data[$i_user_id]["firstname"]=$s_firstname;
  136. $a_data[$i_user_id]["lastname"]=$s_lastname;
  137. $a_data[$i_user_id]["email"]=$s_email;
  138. 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>';
  139. }
  140. }
  141. //No results
  142. else{
  143. echo '<tr><td colspan="5" "align=center">'.get_lang("NoResults").'</td></tr>';
  144. }
  145. echo '</table>';
  146. if(isset($_POST['export'])){
  147. exportCsv($a_header,$a_data);
  148. }
  149. echo "<br /><br />";
  150. echo "<form method='post' action='teachers.php'>
  151. <input type='submit' name='export' value='".get_lang('exportExcel')."'/>
  152. <form>";
  153. /*
  154. ==============================================================================
  155. FOOTER
  156. ==============================================================================
  157. */
  158. Display::display_footer();
  159. ?>