user_export.php 5.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * @package chamilo.admin
  5. */
  6. /**
  7. * Code
  8. */
  9. // name of the language file that needs to be included
  10. $language_file = 'admin';
  11. $cidReset = true;
  12. include ('../inc/global.inc.php');
  13. $this_section = SECTION_PLATFORM_ADMIN;
  14. api_protect_admin_script();
  15. include (api_get_path(LIBRARY_PATH).'fileManage.lib.php');
  16. include (api_get_path(LIBRARY_PATH).'export.lib.inc.php');
  17. include (api_get_path(LIBRARY_PATH).'formvalidator/FormValidator.class.php');
  18. // Database table definitions
  19. $course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  20. $user_table = Database :: get_main_table(TABLE_MAIN_USER);
  21. $course_user_table = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  22. $tool_name = get_lang('ExportUserListXMLCSV');
  23. $interbreadcrumb[] = array ("url" => 'index.php', "name" => get_lang('PlatformAdmin'));
  24. set_time_limit(0);
  25. $courses = array ();
  26. $courses[''] = '--';
  27. $sql = "SELECT code,visual_code,title FROM $course_table ORDER BY visual_code";
  28. global $_configuration;
  29. if ($_configuration['multiple_access_urls']) {
  30. $tbl_course_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);
  31. $access_url_id = api_get_current_access_url_id();
  32. if ($access_url_id != -1){
  33. $sql = "SELECT code,visual_code,title FROM $course_table as c INNER JOIN $tbl_course_rel_access_url as course_rel_url
  34. ON (c.code = course_rel_url.course_code)
  35. WHERE access_url_id = $access_url_id
  36. ORDER BY visual_code";
  37. }
  38. }
  39. $result = Database::query($sql);
  40. while ($course = Database::fetch_object($result))
  41. {
  42. $courses[$course->code] = $course->visual_code.' - '.$course->title;
  43. }
  44. $form = new FormValidator('export_users');
  45. $form->addElement('header', '', $tool_name);
  46. $form->addElement('radio', 'file_type', get_lang('OutputFileType'), 'XML','xml');
  47. $form->addElement('radio', 'file_type', null, 'CSV','csv');
  48. $form->addElement('checkbox', 'addcsvheader', get_lang('AddCSVHeader'), get_lang('YesAddCSVHeader'),'1');
  49. $form->addElement('select', 'course_code', get_lang('OnlyUsersFromCourse'), $courses);
  50. $form->addElement('style_submit_button', 'submit',get_lang('Export'),'class="save"');
  51. $form->setDefaults(array('file_type'=>'csv'));
  52. if ($form->validate())
  53. {
  54. global $userPasswordCrypted;
  55. $export = $form->exportValues();
  56. $file_type = $export['file_type'];
  57. $course_code = $export['course_code'];
  58. $sql = "SELECT u.user_id AS UserId,
  59. u.lastname AS LastName,
  60. u.firstname AS FirstName,
  61. u.email AS Email,
  62. u.username AS UserName,
  63. ".(($userPasswordCrypted!='none')?" ":"u.password AS Password, ")."
  64. u.auth_source AS AuthSource,
  65. u.status AS Status,
  66. u.official_code AS OfficialCode,
  67. u.phone AS Phone";
  68. if (strlen($course_code) > 0) {
  69. $sql .= " FROM $user_table u, $course_user_table cu WHERE u.user_id = cu.user_id AND course_code = '$course_code' AND cu.relation_type<>".COURSE_RELATION_TYPE_RRHH." ORDER BY lastname,firstname";
  70. $filename = 'export_users_'.$course_code.'_'.date('Y-m-d_H-i-s');
  71. } else {
  72. global $_configuration;
  73. if ($_configuration['multiple_access_urls']) {
  74. $tbl_user_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
  75. $access_url_id = api_get_current_access_url_id();
  76. if ($access_url_id != -1) {
  77. $sql.= " FROM $user_table u INNER JOIN $tbl_user_rel_access_url as user_rel_url
  78. ON (u.user_id= user_rel_url.user_id)
  79. WHERE access_url_id = $access_url_id
  80. ORDER BY lastname,firstname";
  81. }
  82. } else {
  83. $sql .= " FROM $user_table u ORDER BY lastname,firstname";
  84. }
  85. $filename = 'export_users_'.date('Y-m-d_H-i-s');
  86. }
  87. require_once (api_get_path(LIBRARY_PATH).'usermanager.lib.php');
  88. $data = array();
  89. $extra_fields = Usermanager::get_extra_fields(0, 0, 5, 'ASC',false);
  90. if ($export['addcsvheader']=='1' AND $export['file_type']=='csv')
  91. {
  92. if($userPasswordCrypted!='none') {
  93. $data[] = array('UserId', 'LastName', 'FirstName', 'Email', 'UserName', 'AuthSource', 'Status', 'OfficialCode', 'PhoneNumber');
  94. } else {
  95. $data[] = array('UserId', 'LastName', 'FirstName', 'Email', 'UserName','Password', 'AuthSource', 'Status', 'OfficialCode', 'PhoneNumber');
  96. }
  97. foreach($extra_fields as $extra) {
  98. $data[0][]=$extra[1];
  99. }
  100. }
  101. $res = Database::query($sql);
  102. while($user = Database::fetch_array($res,'ASSOC')) {
  103. $student_data= UserManager :: get_extra_user_data($user['UserId'],true,false);
  104. foreach($student_data as $key=>$value) {
  105. $key= substr($key,6);
  106. if (is_array($value))
  107. $user[$key]= $value[$key];
  108. else {
  109. $user[$key]= $value;
  110. }
  111. }
  112. $data[] = $user ;
  113. }
  114. switch($file_type) {
  115. case 'xml':
  116. Export::export_table_xml($data,$filename,'Contact','Contacts');
  117. exit;
  118. break;
  119. case 'csv':
  120. Export::export_table_csv($data,$filename);
  121. exit;
  122. break;
  123. }
  124. }
  125. Display :: display_header($tool_name);
  126. //api_display_tool_title($tool_name);
  127. $form->display();
  128. /*
  129. ==============================================================================
  130. FOOTER
  131. ==============================================================================
  132. */
  133. Display :: display_footer();
  134. ?>