admin.php 3.9 KB

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