. /** * Profile field API library file. * * @package core_user * @copyright 2007 onwards Shane Elliot {@link http://pukunui.com} * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ define ('PROFILE_VISIBLE_ALL', '2'); // Only visible for users with moodle/user:update capability. define ('PROFILE_VISIBLE_PRIVATE', '1'); // Either we are viewing our own profile or we have moodle/user:update capability. define ('PROFILE_VISIBLE_NONE', '0'); // Only visible for moodle/user:update capability. /** * Base class for the customisable profile fields. * * @package core_user * @copyright 2007 onwards Shane Elliot {@link http://pukunui.com} * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ class profile_field_base { // These 2 variables are really what we're interested in. // Everything else can be extracted from them. /** @var int */ public $fieldid; /** @var int */ public $userid; /** @var stdClass */ public $field; /** @var string */ public $inputname; /** @var mixed */ public $data; /** @var string */ public $dataformat; /** * Constructor method. * @param int $fieldid id of the profile from the user_info_field table * @param int $userid id of the user for whom we are displaying data */ public function profile_field_base($fieldid=0, $userid=0) { global $USER; $this->set_fieldid($fieldid); $this->set_userid($userid); $this->load_data(); } /** * Abstract method: Adds the profile field to the moodle form class * @abstract The following methods must be overwritten by child classes * @param moodleform $mform instance of the moodleform class */ public function edit_field_add($mform) { print_error('mustbeoveride', 'debug', '', 'edit_field_add'); } /** * Display the data for this field * @return string */ public function display_data() { $options = new stdClass(); $options->para = false; return format_text($this->data, FORMAT_MOODLE, $options); } /** * Print out the form field in the edit profile page * @param moodleform $mform instance of the moodleform class * @return bool */ public function edit_field($mform) { if ($this->field->visible != PROFILE_VISIBLE_NONE or has_capability('moodle/user:update', context_system::instance())) { $this->edit_field_add($mform); $this->edit_field_set_default($mform); $this->edit_field_set_required($mform); return true; } return false; } /** * Tweaks the edit form * @param moodleform $mform instance of the moodleform class * @return bool */ public function edit_after_data($mform) { if ($this->field->visible != PROFILE_VISIBLE_NONE or has_capability('moodle/user:update', context_system::instance())) { $this->edit_field_set_locked($mform); return true; } return false; } /** * Saves the data coming from form * @param stdClass $usernew data coming from the form * @return mixed returns data id if success of db insert/update, false on fail, 0 if not permitted */ public function edit_save_data($usernew) { global $DB; if (!isset($usernew->{$this->inputname})) { // Field not present in form, probably locked and invisible - skip it. return; } $data = new stdClass(); $usernew->{$this->inputname} = $this->edit_save_data_preprocess($usernew->{$this->inputname}, $data); $data->userid = $usernew->id; $data->fieldid = $this->field->id; $data->data = $usernew->{$this->inputname}; if ($dataid = $DB->get_field('user_info_data', 'id', array('userid' => $data->userid, 'fieldid' => $data->fieldid))) { $data->id = $dataid; $DB->update_record('user_info_data', $data); } else { $DB->insert_record('user_info_data', $data); } } /** * Validate the form field from profile page * * @param stdClass $usernew * @return string contains error message otherwise null */ public function edit_validate_field($usernew) { global $DB; $errors = array(); // Get input value. if (isset($usernew->{$this->inputname})) { if (is_array($usernew->{$this->inputname}) && isset($usernew->{$this->inputname}['text'])) { $value = $usernew->{$this->inputname}['text']; } else { $value = $usernew->{$this->inputname}; } } else { $value = ''; } // Check for uniqueness of data if required. if ($this->is_unique() && (($value !== '') || $this->is_required())) { $data = $DB->get_records_sql(' SELECT id, userid FROM {user_info_data} WHERE fieldid = ? AND ' . $DB->sql_compare_text('data', 255) . ' = ' . $DB->sql_compare_text('?', 255), array($this->field->id, $value)); if ($data) { $existing = false; foreach ($data as $v) { if ($v->userid == $usernew->id) { $existing = true; break; } } if (!$existing) { $errors[$this->inputname] = get_string('valuealreadyused'); } } } return $errors; } /** * Sets the default data for the field in the form object * @param moodleform $mform instance of the moodleform class */ public function edit_field_set_default($mform) { if (!empty($default)) { $mform->setDefault($this->inputname, $this->field->defaultdata); } } /** * Sets the required flag for the field in the form object * * @param moodleform $mform instance of the moodleform class */ public function edit_field_set_required($mform) { global $USER; if ($this->is_required() && ($this->userid == $USER->id)) { $mform->addRule($this->inputname, get_string('required'), 'required', null, 'client'); } } /** * HardFreeze the field if locked. * @param moodleform $mform instance of the moodleform class */ public function edit_field_set_locked($mform) { if (!$mform->elementExists($this->inputname)) { return; } if ($this->is_locked() and !has_capability('moodle/user:update', context_system::instance())) { $mform->hardFreeze($this->inputname); $mform->setConstant($this->inputname, $this->data); } } /** * Hook for child classess to process the data before it gets saved in database * @param stdClass $data * @param stdClass $datarecord The object that will be used to save the record * @return mixed */ public function edit_save_data_preprocess($data, $datarecord) { return $data; } /** * Loads a user object with data for this field ready for the edit profile * form * @param stdClass $user a user object */ public function edit_load_user_data($user) { if ($this->data !== null) { $user->{$this->inputname} = $this->data; } } /** * Check if the field data should be loaded into the user object * By default it is, but for field types where the data may be potentially * large, the child class should override this and return false * @return bool */ public function is_user_object_data() { return true; } /** * Accessor method: set the userid for this instance * @internal This method should not generally be overwritten by child classes. * @param integer $userid id from the user table */ public function set_userid($userid) { $this->userid = $userid; } /** * Accessor method: set the fieldid for this instance * @internal This method should not generally be overwritten by child classes. * @param integer $fieldid id from the user_info_field table */ public function set_fieldid($fieldid) { $this->fieldid = $fieldid; } /** * Accessor method: Load the field record and user data associated with the * object's fieldid and userid * @internal This method should not generally be overwritten by child classes. */ public function load_data() { global $DB; // Load the field object. if (($this->fieldid == 0) or (!($field = $DB->get_record('user_info_field', array('id' => $this->fieldid))))) { $this->field = null; $this->inputname = ''; } else { $this->field = $field; $this->inputname = 'profile_field_'.$field->shortname; } if (!empty($this->field)) { $params = array('userid' => $this->userid, 'fieldid' => $this->fieldid); if ($data = $DB->get_record('user_info_data', $params, 'data, dataformat')) { $this->data = $data->data; $this->dataformat = $data->dataformat; } else { $this->data = $this->field->defaultdata; $this->dataformat = FORMAT_HTML; } } else { $this->data = null; } } /** * Check if the field data is visible to the current user * @internal This method should not generally be overwritten by child classes. * @return bool */ public function is_visible() { global $USER; switch ($this->field->visible) { case PROFILE_VISIBLE_ALL: return true; case PROFILE_VISIBLE_PRIVATE: if ($this->userid == $USER->id) { return true; } else { return has_capability('moodle/user:viewalldetails', context_user::instance($this->userid)); } default: return has_capability('moodle/user:viewalldetails', context_user::instance($this->userid)); } } /** * Check if the field data is considered empty * @internal This method should not generally be overwritten by child classes. * @return boolean */ public function is_empty() { return ( ($this->data != '0') and empty($this->data)); } /** * Check if the field is required on the edit profile page * @internal This method should not generally be overwritten by child classes. * @return bool */ public function is_required() { return (boolean)$this->field->required; } /** * Check if the field is locked on the edit profile page * @internal This method should not generally be overwritten by child classes. * @return bool */ public function is_locked() { return (boolean)$this->field->locked; } /** * Check if the field data should be unique * @internal This method should not generally be overwritten by child classes. * @return bool */ public function is_unique() { return (boolean)$this->field->forceunique; } /** * Check if the field should appear on the signup page * @internal This method should not generally be overwritten by child classes. * @return bool */ public function is_signup_field() { return (boolean)$this->field->signup; } } /** * Loads user profile field data into the user object. * @param stdClass $user */ function profile_load_data($user) { global $CFG, $DB; if ($fields = $DB->get_records('user_info_field')) { foreach ($fields as $field) { require_once($CFG->dirroot.'/user/profile/field/'.$field->datatype.'/field.class.php'); $newfield = 'profile_field_'.$field->datatype; $formfield = new $newfield($field->id, $user->id); $formfield->edit_load_user_data($user); } } } /** * Print out the customisable categories and fields for a users profile * * @param moodleform $mform instance of the moodleform class * @param int $userid id of user whose profile is being edited. */ function profile_definition($mform, $userid = 0) { global $CFG, $DB; // If user is "admin" fields are displayed regardless. $update = has_capability('moodle/user:update', context_system::instance()); if ($categories = $DB->get_records('user_info_category', null, 'sortorder ASC')) { foreach ($categories as $category) { if ($fields = $DB->get_records('user_info_field', array('categoryid' => $category->id), 'sortorder ASC')) { // Check first if *any* fields will be displayed. $display = false; foreach ($fields as $field) { if ($field->visible != PROFILE_VISIBLE_NONE) { $display = true; } } // Display the header and the fields. if ($display or $update) { $mform->addElement('header', 'category_'.$category->id, format_string($category->name)); foreach ($fields as $field) { require_once($CFG->dirroot.'/user/profile/field/'.$field->datatype.'/field.class.php'); $newfield = 'profile_field_'.$field->datatype; $formfield = new $newfield($field->id, $userid); $formfield->edit_field($mform); } } } } } } /** * Adds profile fields to user edit forms. * @param moodleform $mform * @param int $userid */ function profile_definition_after_data($mform, $userid) { global $CFG, $DB; $userid = ($userid < 0) ? 0 : (int)$userid; if ($fields = $DB->get_records('user_info_field')) { foreach ($fields as $field) { require_once($CFG->dirroot.'/user/profile/field/'.$field->datatype.'/field.class.php'); $newfield = 'profile_field_'.$field->datatype; $formfield = new $newfield($field->id, $userid); $formfield->edit_after_data($mform); } } } /** * Validates profile data. * @param stdClass $usernew * @param array $files * @return array */ function profile_validation($usernew, $files) { global $CFG, $DB; $err = array(); if ($fields = $DB->get_records('user_info_field')) { foreach ($fields as $field) { require_once($CFG->dirroot.'/user/profile/field/'.$field->datatype.'/field.class.php'); $newfield = 'profile_field_'.$field->datatype; $formfield = new $newfield($field->id, $usernew->id); $err += $formfield->edit_validate_field($usernew, $files); } } return $err; } /** * Saves profile data for a user. * @param stdClass $usernew */ function profile_save_data($usernew) { global $CFG, $DB; if ($fields = $DB->get_records('user_info_field')) { foreach ($fields as $field) { require_once($CFG->dirroot.'/user/profile/field/'.$field->datatype.'/field.class.php'); $newfield = 'profile_field_'.$field->datatype; $formfield = new $newfield($field->id, $usernew->id); $formfield->edit_save_data($usernew); } } } /** * Display profile fields. * @param int $userid */ function profile_display_fields($userid) { global $CFG, $USER, $DB; if ($categories = $DB->get_records('user_info_category', null, 'sortorder ASC')) { foreach ($categories as $category) { if ($fields = $DB->get_records('user_info_field', array('categoryid' => $category->id), 'sortorder ASC')) { foreach ($fields as $field) { require_once($CFG->dirroot.'/user/profile/field/'.$field->datatype.'/field.class.php'); $newfield = 'profile_field_'.$field->datatype; $formfield = new $newfield($field->id, $userid); if ($formfield->is_visible() and !$formfield->is_empty()) { echo html_writer::tag('dt', format_string($formfield->field->name)); echo html_writer::tag('dd', $formfield->display_data()); } } } } } } /** * Adds code snippet to a moodle form object for custom profile fields that * should appear on the signup page * @param moodleform $mform moodle form object */ function profile_signup_fields($mform) { global $CFG, $DB; // Only retrieve required custom fields (with category information) // results are sort by categories, then by fields. $sql = "SELECT uf.id as fieldid, ic.id as categoryid, ic.name as categoryname, uf.datatype FROM {user_info_field} uf JOIN {user_info_category} ic ON uf.categoryid = ic.id AND uf.signup = 1 AND uf.visible<>0 ORDER BY ic.sortorder ASC, uf.sortorder ASC"; if ( $fields = $DB->get_records_sql($sql)) { foreach ($fields as $field) { // Check if we change the categories. if (!isset($currentcat) || $currentcat != $field->categoryid) { $currentcat = $field->categoryid; $mform->addElement('header', 'category_'.$field->categoryid, format_string($field->categoryname)); } require_once($CFG->dirroot.'/user/profile/field/'.$field->datatype.'/field.class.php'); $newfield = 'profile_field_'.$field->datatype; $formfield = new $newfield($field->fieldid); $formfield->edit_field($mform); } } } /** * Returns an object with the custom profile fields set for the given user * @param integer $userid * @return stdClass */ function profile_user_record($userid) { global $CFG, $DB; $usercustomfields = new stdClass(); if ($fields = $DB->get_records('user_info_field')) { foreach ($fields as $field) { require_once($CFG->dirroot.'/user/profile/field/'.$field->datatype.'/field.class.php'); $newfield = 'profile_field_'.$field->datatype; $formfield = new $newfield($field->id, $userid); if ($formfield->is_user_object_data()) { $usercustomfields->{$field->shortname} = $formfield->data; } } } return $usercustomfields; } /** * Obtains a list of all available custom profile fields, indexed by id. * * Some profile fields are not included in the user object data (see * profile_user_record function above). Optionally, you can obtain only those * fields that are included in the user object. * * To be clear, this function returns the available fields, and does not * return the field values for a particular user. * * @param bool $onlyinuserobject True if you only want the ones in $USER * @return array Array of field objects from database (indexed by id) * @since Moodle 2.7.1 */ function profile_get_custom_fields($onlyinuserobject = false) { global $DB, $CFG; // Get all the fields. $fields = $DB->get_records('user_info_field', null, 'id ASC'); // If only doing the user object ones, unset the rest. if ($onlyinuserobject) { foreach ($fields as $id => $field) { require_once($CFG->dirroot . '/user/profile/field/' . $field->datatype . '/field.class.php'); $newfield = 'profile_field_' . $field->datatype; $formfield = new $newfield(); if (!$formfield->is_user_object_data()) { unset($fields[$id]); } } } return $fields; } /** * Load custom profile fields into user object * * Please note originally in 1.9 we were using the custom field names directly, * but it was causing unexpected collisions when adding new fields to user table, * so instead we now use 'profile_' prefix. * * @param stdClass $user user object */ function profile_load_custom_fields($user) { $user->profile = (array)profile_user_record($user->id); }