usergroup_import.php 3.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * @package chamilo.admin
  5. */
  6. /**
  7. * Code
  8. * This tool allows platform admins to add classes by uploading a CSV file
  9. * @todo Add some langvars to DLTT
  10. */
  11. /**
  12. * Validates imported data.
  13. */
  14. function validate_data($classes) {
  15. $errors = array();
  16. $usergroup = new UserGroup();
  17. foreach ($classes as $index => $class) {
  18. // 1. Check wheter ClassName is available.
  19. if (!isset($class['name']) || strlen(trim($class['name'])) == 0) {
  20. $class['line'] = $index + 2;
  21. $class['error'] = get_lang('MissingClassName');
  22. $errors[] = $class;
  23. }
  24. // 2. Check whether class doesn't exist yet.
  25. else {
  26. if ($usergroup->usergroup_exists($class['name'])) {
  27. $class['line'] = $index + 2;
  28. $class['error'] = get_lang('ClassNameExists').' <strong>'.$class['ClassName'].'</strong>';
  29. $errors[] = $class;
  30. }
  31. }
  32. }
  33. return $errors;
  34. }
  35. /**
  36. * Save imported class data to database
  37. */
  38. function save_data($classes) {
  39. $number_of_added_classes = 0;
  40. $usergroup = new UserGroup();
  41. foreach ($classes as $index => $class) {
  42. $id = $usergroup->save($class);
  43. if ($id) {
  44. $number_of_added_classes++;
  45. }
  46. }
  47. return $number_of_added_classes;
  48. }
  49. // Language files that should be included.
  50. $language_file = array ('admin', 'registration');
  51. // Resetting the course id.
  52. $cidReset = true;
  53. // Setting the section (for the tabs).
  54. $this_section = SECTION_PLATFORM_ADMIN;
  55. // Access restrictions.
  56. api_protect_admin_script();
  57. // setting breadcrumbs
  58. $interbreadcrumb[] = array('url' => 'index.php', 'name' => get_lang('PlatformAdmin'));
  59. $interbreadcrumb[] = array('url' => 'usergroups.php', 'name' => get_lang('Classes'));
  60. // Database Table Definitions
  61. // Setting the name of the tool.
  62. $tool_name = get_lang('ImportClassListCSV');
  63. // Displaying the header.
  64. Display :: display_header($tool_name);
  65. set_time_limit(0);
  66. $form = new FormValidator('import_classes');
  67. $form->addElement('file', 'import_file', get_lang('ImportCSVFileLocation'));
  68. $group = array();
  69. $group[] = $form->createElement('radio', 'file_type', '', 'CSV (<a href="example_class.csv" target="_blank">'.get_lang('ExampleCSVFile').'</a>)', 'csv');
  70. $form->addGroup($group, '', get_lang('FileType'), '<br/>');
  71. $form->addElement('style_submit_button', 'submit', get_lang('Import'), 'class="save"');
  72. if ($form->validate()) {
  73. $classes = Import::csv_to_array($_FILES['import_file']['tmp_name']);
  74. $errors = validate_data($classes);
  75. if (count($errors) == 0) {
  76. $number_of_added_classes = save_data($classes);
  77. Display::display_normal_message($number_of_added_classes.' '.get_lang('Added'));
  78. } else {
  79. $error_message = get_lang('ErrorsWhenImportingFile');
  80. $error_message .= '<ul>';
  81. foreach ($errors as $index => $error_class) {
  82. $error_message .= '<li>'.$error_class['error'].' ('.get_lang('Line').' '.$error_class['line'].')';
  83. $error_message .= '</li>';
  84. }
  85. $error_message .= '</ul>';
  86. $error_message .= get_lang('Error');
  87. Display :: display_error_message($error_message, false);
  88. }
  89. }
  90. $form->display();
  91. ?>
  92. <p><?php echo get_lang('CSVMustLookLike').' ('.get_lang('MandatoryFields').')'; ?> :</p>
  93. <pre>
  94. <b>name;description</b>
  95. "User group 1";"Description"
  96. </pre>
  97. <?php
  98. // Displaying the footer.
  99. Display :: display_footer();