[Summary view]

Differences Between: [Versions 310 and 401]

   1  <?php
   2  // This file is part of Moodle - http://moodle.org/
   3  //
   4  // Moodle is free software: you can redistribute it and/or modify
   5  // it under the terms of the GNU General Public License as published by
   6  // the Free Software Foundation, either version 3 of the License, or
   7  // (at your option) any later version.
   8  //
   9  // Moodle is distributed in the hope that it will be useful,
  10  // but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  // GNU General Public License for more details.
  13  //
  14  // You should have received a copy of the GNU General Public License
  15  // along with Moodle.  If not, see <http://www.gnu.org/licenses/>.
  16  
  17  /**
  18   * Class preview
  19   *
  20   * @package     tool_uploaduser
  21   * @copyright   2020 Marina Glancy
  22   * @license     http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  23   */
  24  
  25  namespace tool_uploaduser;
  26  
  27  defined('MOODLE_INTERNAL') || die();
  28  
  29  use tool_uploaduser\local\field_value_validators;
  30  
  31  require_once($CFG->libdir.'/csvlib.class.php');
  32  require_once($CFG->dirroot.'/'.$CFG->admin.'/tool/uploaduser/locallib.php');
  33  
  34  /**
  35   * Display the preview of a CSV file
  36   *
  37   * @package     tool_uploaduser
  38   * @copyright   2020 Marina Glancy
  39   * @license     http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  40   */
  41  class preview extends \html_table {
  42  
  43      /** @var \csv_import_reader  */
  44      protected $cir;
  45      /** @var array */
  46      protected $filecolumns;
  47      /** @var int */
  48      protected $previewrows;
  49      /** @var bool */
  50      protected $noerror = true; // Keep status of any error.
  51  
  52      /**
  53       * preview constructor.
  54       *
  55       * @param \csv_import_reader $cir
  56       * @param array $filecolumns
  57       * @param int $previewrows
  58       * @throws \coding_exception
  59       */
  60      public function __construct(\csv_import_reader $cir, array $filecolumns, int $previewrows) {
  61          parent::__construct();
  62          $this->cir = $cir;
  63          $this->filecolumns = $filecolumns;
  64          $this->previewrows = $previewrows;
  65  
  66          $this->id = "uupreview";
  67          $this->attributes['class'] = 'generaltable';
  68          $this->tablealign = 'center';
  69          $this->summary = get_string('uploaduserspreview', 'tool_uploaduser');
  70          $this->head = array();
  71          $this->data = $this->read_data();
  72  
  73          $this->head[] = get_string('uucsvline', 'tool_uploaduser');
  74          foreach ($filecolumns as $column) {
  75              $this->head[] = $column;
  76          }
  77          $this->head[] = get_string('status');
  78  
  79      }
  80  
  81      /**
  82       * Read data
  83       *
  84       * @return array
  85       * @throws \coding_exception
  86       * @throws \dml_exception
  87       * @throws \moodle_exception
  88       */
  89      protected function read_data() {
  90          global $DB, $CFG;
  91  
  92          // Track whether values for profile fields defined as unique have already been used.
  93          $profilefieldvalues = [];
  94  
  95          $data = array();
  96          $this->cir->init();
  97          $linenum = 1; // Column header is first line.
  98          while ($linenum <= $this->previewrows and $fields = $this->cir->next()) {
  99              $linenum++;
 100              $rowcols = array();
 101              $rowcols['line'] = $linenum;
 102              foreach ($fields as $key => $field) {
 103                  $rowcols[$this->filecolumns[$key]] = s(trim($field));
 104              }
 105              $rowcols['status'] = array();
 106  
 107              if (isset($rowcols['username'])) {
 108                  $stdusername = \core_user::clean_field($rowcols['username'], 'username');
 109                  if ($rowcols['username'] !== $stdusername) {
 110                      $rowcols['status'][] = get_string('invalidusernameupload');
 111                  }
 112                  if ($userid = $DB->get_field('user', 'id',
 113                          ['username' => $stdusername, 'mnethostid' => $CFG->mnet_localhost_id])) {
 114                      $rowcols['username'] = \html_writer::link(
 115                          new \moodle_url('/user/profile.php', ['id' => $userid]), $rowcols['username']);
 116                  }
 117              } else {
 118                  $rowcols['status'][] = get_string('missingusername');
 119              }
 120  
 121              if (isset($rowcols['email'])) {
 122                  if (!validate_email($rowcols['email'])) {
 123                      $rowcols['status'][] = get_string('invalidemail');
 124                  }
 125  
 126                  $select = $DB->sql_like('email', ':email', false, true, false, '|');
 127                  $params = array('email' => $DB->sql_like_escape($rowcols['email'], '|'));
 128                  if ($DB->record_exists_select('user', $select , $params)) {
 129                      $rowcols['status'][] = get_string('useremailduplicate', 'error');
 130                  }
 131              }
 132  
 133              if (isset($rowcols['theme'])) {
 134                  list($status, $message) = field_value_validators::validate_theme($rowcols['theme']);
 135                  if ($status !== 'normal' && !empty($message)) {
 136                      $rowcols['status'][] = $message;
 137                  }
 138              }
 139  
 140              // Check if rowcols have custom profile field with correct data and update error state.
 141              $this->noerror = uu_check_custom_profile_data($rowcols, $profilefieldvalues) && $this->noerror;
 142              $rowcols['status'] = implode('<br />', $rowcols['status']);
 143              $data[] = $rowcols;
 144          }
 145          if ($fields = $this->cir->next()) {
 146              $data[] = array_fill(0, count($fields) + 2, '...');
 147          }
 148          $this->cir->close();
 149  
 150          return $data;
 151      }
 152  
 153      /**
 154       * Getter for noerror
 155       *
 156       * @return bool
 157       */
 158      public function get_no_error() {
 159          return $this->noerror;
 160      }
 161  }