import.lib.php 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144
  1. <?php
  2. /**
  3. * Validates imported data.
  4. */
  5. function validate_data($users) {
  6. global $defined_auth_sources;
  7. $errors = array ();
  8. $usernames = array ();
  9. foreach ($users as $index => $user) {
  10. // 1. Check whether mandatory fields have been set.
  11. $mandatory_fields = array ('LastName', 'FirstName');
  12. if (api_get_setting('registration', 'email') == 'true') {
  13. $mandatory_fields[] = 'Email';
  14. }
  15. foreach ($mandatory_fields as $key => $field) {
  16. if (!isset ($user[$field]) || strlen($user[$field]) == 0) {
  17. $user['error'] = get_lang($field.'Mandatory');
  18. $errors[] = $user;
  19. }
  20. }
  21. // 2. Check username.
  22. if (!UserManager::is_username_empty($username)) {
  23. // 2.1. Check whether username was used twice in the import file.
  24. if (isset($usernames[$user['UserName']])) {
  25. $user['error'] = get_lang('UserNameUsedTwice');
  26. $errors[] = $user;
  27. }
  28. $usernames[$user['UserName']] = 1;
  29. // 2.2. Check whether username is allready in use in database.
  30. if (!UserManager::is_username_available($user['UserName'])) {
  31. $user['error'] = get_lang('UserNameNotAvailable');
  32. $errors[] = $user;
  33. }
  34. // 2.3. Check whether username is too long.
  35. if (UserManager::is_username_too_long($user['UserName'])) {
  36. $user['error'] = get_lang('UserNameTooLong');
  37. $errors[] = $user;
  38. }
  39. }
  40. // 3. Check status.
  41. if (isset ($user['Status']) && !api_status_exists($user['Status'])) {
  42. $user['error'] = get_lang('WrongStatus');
  43. $errors[] = $user;
  44. }
  45. // 4. Check classname.
  46. if (isset ($user['ClassName']) && strlen($user['ClassName']) != 0) {
  47. if (!ClassManager :: class_name_exists($user['ClassName'])) {
  48. $user['error'] = get_lang('ClassNameNotAvailable');
  49. $errors[] = $user;
  50. }
  51. }
  52. // 5. Check authentication source.
  53. if (isset ($user['AuthSource']) && strlen($user['AuthSource']) != 0) {
  54. if (!in_array($user['AuthSource'], $defined_auth_sources)) {
  55. $user['error'] = get_lang('AuthSourceNotAvailable');
  56. $errors[] = $user;
  57. }
  58. }
  59. }
  60. return $errors;
  61. }
  62. /**
  63. * Adds missing user-information (which isn't required, like password, username, etc).
  64. */
  65. function complete_missing_data($user) {
  66. // 1. Create a username if necessary.
  67. if (UserManager::is_username_empty($user['UserName'])) {
  68. $user['UserName'] = UserManager::create_unique_username($user['FirstName'], $user['LastName']);
  69. }
  70. // 2. Generate a password if necessary.
  71. if (!isset ($user['Password']) || strlen($user['Password']) == 0) {
  72. $user['Password'] = api_generate_password();
  73. }
  74. // 3. set status if not allready set.
  75. if (!isset ($user['Status']) || strlen($user['Status']) == 0) {
  76. $user['Status'] = 'user';
  77. }
  78. // 4. Set authsource if not allready set.
  79. if (!isset ($user['AuthSource']) || strlen($user['AuthSource']) == 0) {
  80. $user['AuthSource'] = PLATFORM_AUTH_SOURCE;
  81. }
  82. return $user;
  83. }
  84. /**
  85. * Save the imported data
  86. */
  87. function save_data($users) {
  88. $user_table = Database :: get_main_table(TABLE_MAIN_USER);
  89. foreach ($users as $index => $user) {
  90. $user = complete_missing_data($user);
  91. $user['Status'] = api_status_key($user['Status']);
  92. $user_id = UserManager :: create_user($user['FirstName'], $user['LastName'], $user['Status'], $user['Email'], $user['UserName'], $user['Password'], $user['OfficialCode'], api_get_setting('PlatformLanguage'), $user['PhoneNumber'], '', $user['AuthSource']);
  93. foreach ($user['Courses'] as $index => $course) {
  94. if(CourseManager :: course_exists($course))
  95. CourseManager :: subscribe_user($user_id, $course,$user['Status']);
  96. }
  97. if (strlen($user['ClassName']) > 0) {
  98. $class_id = ClassManager :: get_class_id($user['ClassName']);
  99. ClassManager :: add_user($user_id, $class_id);
  100. }
  101. // TODO: Hard-coded French texts.
  102. // Qualite
  103. if (!empty($user['Qualite'])) {
  104. UserManager::update_extra_field_value($user_id, 'qualite', $user['Qualite']);
  105. }
  106. // Categorie
  107. if (!empty($user['Categorie'])) {
  108. UserManager::update_extra_field_value($user_id, 'categorie', $user['Categorie']);
  109. }
  110. // Etat
  111. if (!empty($user['Etat'])) {
  112. UserManager::update_extra_field_value($user_id, 'etat', $user['Etat']);
  113. }
  114. // Niveau
  115. if (!empty($user['Niveau'])) {
  116. UserManager::update_extra_field_value($user_id, 'niveau', $user['Niveau']);
  117. }
  118. }
  119. }
  120. /**
  121. * Reads the CSV-file.
  122. * @param string $file Path to the CSV-file
  123. * @return array All userinformation read from the file
  124. */
  125. function parse_csv_data($file) {
  126. $users = Import :: csv_to_array($file);
  127. foreach ($users as $index => $user) {
  128. if (isset ($user['Courses'])) {
  129. $user['Courses'] = explode('|', trim($user['Courses']));
  130. }
  131. $users[$index] = $user;
  132. }
  133. return $users;
  134. }