user_export.php 5.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * @package chamilo.admin
  5. */
  6. $cidReset = true;
  7. require_once __DIR__.'/../inc/global.inc.php';
  8. $this_section = SECTION_PLATFORM_ADMIN;
  9. api_protect_admin_script();
  10. // Database table definitions
  11. $course_table = Database:: get_main_table(TABLE_MAIN_COURSE);
  12. $user_table = Database:: get_main_table(TABLE_MAIN_USER);
  13. $course_user_table = Database:: get_main_table(TABLE_MAIN_COURSE_USER);
  14. $session_course_user_table = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  15. $tool_name = get_lang('ExportUserListXMLCSV');
  16. $interbreadcrumb[] = array("url" => 'index.php', "name" => get_lang('PlatformAdmin'));
  17. set_time_limit(0);
  18. $coursesSessions = [];
  19. $coursesSessions[''] = '--';
  20. $allCoursesFromSessions = SessionManager::getAllCoursesFromAllSessions();
  21. $coursesSessions = array_merge($coursesSessions, $allCoursesFromSessions);
  22. $courses = array ();
  23. $courses[''] = '--';
  24. $sql = "SELECT code,visual_code,title FROM $course_table ORDER BY visual_code";
  25. global $_configuration;
  26. if (api_is_multiple_url_enabled()) {
  27. $tbl_course_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);
  28. $access_url_id = api_get_current_access_url_id();
  29. if ($access_url_id != -1){
  30. $sql = "SELECT code,visual_code,title
  31. FROM $course_table as c
  32. INNER JOIN $tbl_course_rel_access_url as course_rel_url
  33. ON (c.id = course_rel_url.c_id)
  34. WHERE access_url_id = $access_url_id
  35. ORDER BY visual_code";
  36. }
  37. }
  38. $result = Database::query($sql);
  39. while ($course = Database::fetch_object($result)) {
  40. $courses[$course->code] = $course->visual_code.' - '.$course->title;
  41. }
  42. $form = new FormValidator('export_users');
  43. $form->addElement('header', $tool_name);
  44. $form->addElement('radio', 'file_type', get_lang('OutputFileType'), 'XML','xml');
  45. $form->addElement('radio', 'file_type', null, 'CSV', 'csv');
  46. $form->addElement('radio', 'file_type', null, 'XLS', 'xls');
  47. $form->addElement('checkbox', 'addcsvheader', get_lang('AddCSVHeader'), get_lang('YesAddCSVHeader'),'1');
  48. $form->addElement('select', 'course_code', get_lang('OnlyUsersFromCourse'), $courses);
  49. $form->addElement('select', 'course_session', get_lang('OnlyUsersFromCourseSession'), $coursesSessions);
  50. $form->addButtonExport(get_lang('Export'));
  51. $form->setDefaults(array('file_type' => 'csv'));
  52. if ($form->validate()) {
  53. $export = $form->exportValues();
  54. $file_type = $export['file_type'];
  55. $course_code = Database::escape_string($export['course_code']);
  56. $courseInfo = api_get_course_info($course_code);
  57. $courseId = $courseInfo['real_id'];
  58. $courseSessionValue = explode(':', $export['course_session']);
  59. $courseSessionCode = '';
  60. $sessionId = 0;
  61. $courseSessionId = 0;
  62. $sessionInfo = [];
  63. if (is_array($courseSessionValue) && isset($courseSessionValue[1])) {
  64. $courseSessionCode = $courseSessionValue[0];
  65. $sessionId = $courseSessionValue[1];
  66. $courseSessionInfo= api_get_course_info($courseSessionCode);
  67. $courseSessionId = $courseSessionInfo['real_id'];
  68. $sessionInfo = api_get_session_info($sessionId);
  69. }
  70. $sql = "SELECT
  71. u.user_id AS UserId,
  72. u.lastname AS LastName,
  73. u.firstname AS FirstName,
  74. u.email AS Email,
  75. u.username AS UserName,
  76. ".(($_configuration['password_encryption']!='none')?" ":"u.password AS Password, ")."
  77. u.auth_source AS AuthSource,
  78. u.status AS Status,
  79. u.official_code AS OfficialCode,
  80. u.phone AS Phone";
  81. if (strlen($course_code) > 0) {
  82. $sql .= " FROM $user_table u, $course_user_table cu
  83. WHERE
  84. u.user_id = cu.user_id AND
  85. cu.c_id = $courseId AND
  86. cu.relation_type<>".COURSE_RELATION_TYPE_RRHH."
  87. ORDER BY lastname,firstname";
  88. $filename = 'export_users_'.$course_code.'_'.api_get_local_time();
  89. } else if (strlen($courseSessionCode) > 0) {
  90. $sql .= " FROM $user_table u, $session_course_user_table scu
  91. WHERE
  92. u.user_id = scu.user_id AND
  93. scu.c_id = $courseSessionId AND
  94. scu.session_id = $sessionId
  95. ORDER BY lastname,firstname";
  96. $filename = 'export_users_'.$courseSessionCode.'_'.$sessionInfo['name'].'_'.api_get_local_time();
  97. } else {
  98. if (api_is_multiple_url_enabled()) {
  99. $tbl_user_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
  100. $access_url_id = api_get_current_access_url_id();
  101. if ($access_url_id != -1) {
  102. $sql.= " FROM $user_table u
  103. INNER JOIN $tbl_user_rel_access_url as user_rel_url
  104. ON (u.user_id= user_rel_url.user_id)
  105. WHERE access_url_id = $access_url_id
  106. ORDER BY lastname,firstname";
  107. }
  108. } else {
  109. $sql .= " FROM $user_table u ORDER BY lastname,firstname";
  110. }
  111. $filename = 'export_users_'.api_get_local_time();
  112. }
  113. $data = array();
  114. $extra_fields = UserManager::get_extra_fields(0, 0, 5, 'ASC',false);
  115. if ($export['addcsvheader']=='1' AND $export['file_type']=='csv') {
  116. if ($_configuration['password_encryption'] != 'none') {
  117. $data[] = array(
  118. 'UserId',
  119. 'LastName',
  120. 'FirstName',
  121. 'Email',
  122. 'UserName',
  123. 'AuthSource',
  124. 'Status',
  125. 'OfficialCode',
  126. 'PhoneNumber',
  127. );
  128. } else {
  129. $data[] = array(
  130. 'UserId',
  131. 'LastName',
  132. 'FirstName',
  133. 'Email',
  134. 'UserName',
  135. 'Password',
  136. 'AuthSource',
  137. 'Status',
  138. 'OfficialCode',
  139. 'PhoneNumber',
  140. );
  141. }
  142. foreach($extra_fields as $extra) {
  143. $data[0][]=$extra[1];
  144. }
  145. }
  146. $res = Database::query($sql);
  147. while($user = Database::fetch_array($res,'ASSOC')) {
  148. $student_data = UserManager:: get_extra_user_data(
  149. $user['UserId'],
  150. true,
  151. false
  152. );
  153. foreach($student_data as $key=>$value) {
  154. $key = substr($key, 6);
  155. if (is_array($value)) {
  156. $user[$key] = $value[$key];
  157. } else {
  158. $user[$key] = $value;
  159. }
  160. }
  161. $data[] = $user ;
  162. }
  163. switch ($file_type) {
  164. case 'xml':
  165. Export::arrayToXml($data, $filename, 'Contact', 'Contacts');
  166. exit;
  167. break;
  168. case 'csv':
  169. Export::arrayToCsv($data, $filename);
  170. exit;
  171. case 'xls':
  172. Export::arrayToXls($data, $filename);
  173. exit;
  174. break;
  175. }
  176. }
  177. Display :: display_header($tool_name);
  178. $form->display();
  179. Display :: display_footer();