admin.php 4.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125
  1. <?php
  2. /* For licensing terms, see /dokeos_license.txt */
  3. /*
  4. * Created on 18 October 2006 by Elixir Interactive http://www.elixir-interactive.com
  5. */
  6. ob_start();
  7. // name of the language file that needs to be included
  8. $language_file = array ('registration', 'index', 'trad4all', 'tracking');
  9. $cidReset = true;
  10. require '../inc/global.inc.php';
  11. require_once api_get_path(SYS_CODE_PATH).'mySpace/myspace.lib.php';
  12. $this_section = "session_my_space";
  13. $nameTools = get_lang('Administrators');
  14. api_block_anonymous_users();
  15. $interbreadcrumb[] = array ("url" => "index.php", "name" => get_lang('MySpace'));
  16. Display :: display_header($nameTools);
  17. api_display_tool_title($nameTools);
  18. // Database Table Definitions
  19. $tbl_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  20. $tbl_user = Database :: get_main_table(TABLE_MAIN_USER);
  21. $tbl_session = Database :: get_main_table(TABLE_MAIN_SESSION);
  22. $tbl_session_course = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE);
  23. $tbl_session_rel_user = Database :: get_main_table(TABLE_MAIN_SESSION_USER);
  24. $tbl_admin = Database :: get_main_table(TABLE_MAIN_ADMIN);
  25. /**
  26. * MAIN PART
  27. */
  28. /*
  29. * liste nominative avec coordonnies et lien vers les cours et les stagiaires dont il est le responsable.
  30. */
  31. if (isset($_POST['export'])) {
  32. $order_clause = api_is_western_name_order(PERSON_NAME_DATA_EXPORT) ? ' ORDER BY firstname, lastname' : ' ORDER BY lastname, firstname';
  33. } else {
  34. $order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname' : ' ORDER BY lastname, firstname';
  35. }
  36. $sql_admins = "SELECT user.user_id,lastname,firstname,email
  37. FROM $tbl_user as user, $tbl_admin as admin
  38. WHERE admin.user_id=user.user_id".$order_clause;
  39. $result_admins = Database::query($sql_admins);
  40. if (api_is_western_name_order()) {
  41. echo '<table class="data_table"><tr><th>'.get_lang('FirstName').'</th><th>'.get_lang('LastName').'</th><th>'.get_lang('Email').'</th></tr>';
  42. } else {
  43. echo '<table class="data_table"><tr><th>'.get_lang('LastName').'</th><th>'.get_lang('FirstName').'</th><th>'.get_lang('Email').'</th></tr>';
  44. }
  45. if (api_is_western_name_order(PERSON_NAME_DATA_EXPORT)) {
  46. $header[] = get_lang('FirstName', '');
  47. $header[] = get_lang('LastName', '');
  48. } else {
  49. $header[] = get_lang('LastName', '');
  50. $header[] = get_lang('FirstName', '');
  51. }
  52. $header[] = get_lang('Email', '');
  53. if (Database::num_rows($result_admins) > 0) {
  54. while ($admins = Database::fetch_array($result_admins)) {
  55. $user_id = $admins["user_id"];
  56. $lastname = $admins["lastname"];
  57. $firstname = $admins["firstname"];
  58. $email = $admins["email"];
  59. if ($i % 2 == 0) {
  60. $css_class = "row_odd";
  61. if ($i % 20 == 0 && $i != 0) {
  62. if (api_is_western_name_order()) {
  63. echo '<tr><th>'.get_lang('FirstName').'</th><th>'.get_lang('LastName').'</th><th>'.get_lang('Email').'</th></tr>';
  64. } else {
  65. echo '<tr><th>'.get_lang('LastName').'</th><th>'.get_lang('FirstName').'</th><th>'.get_lang('Email').'</th></tr>';
  66. }
  67. }
  68. } else {
  69. $css_class = "row_even";
  70. }
  71. $i++;
  72. if (api_is_western_name_order()) {
  73. echo "<tr class=".$css_class."><td>$firstname</td><td>$lastname</td><td><a href='mailto:".$email."'>$email</a></td></tr>";
  74. } else {
  75. echo "<tr class=".$css_class."><td>$lastname</td><td>$firstname</td><td><a href='mailto:".$email."'>$email</a></td></tr>";
  76. }
  77. if (api_is_western_name_order(PERSON_NAME_DATA_EXPORT)) {
  78. $data[$user_id]["firstname"] = $firstname;
  79. $data[$user_id]["lastname"] = $lastname;
  80. } else {
  81. $data[$user_id]["lastname"] = $lastname;
  82. $data[$user_id]["firstname"] = $firstname;
  83. }
  84. $data[$user_id]["email"] = $email;
  85. }
  86. } else {
  87. // No results
  88. echo '<tr><td colspan="3" "align=center">'.get_lang('NoResults').'</td></tr>';
  89. }
  90. echo '</table>';
  91. if (isset($_POST['export'])) {
  92. export_csv($header, $data, 'administrators.csv');
  93. }
  94. echo "<br /><br />";
  95. echo "<form method='post' action='admin.php'><button type='submit' class='save' name='export' value='".get_lang('exportExcel')."'>".get_lang('exportExcel')."</button><form>";
  96. /*
  97. ==============================================================================
  98. FOOTER
  99. ==============================================================================
  100. */
  101. Display::display_footer();