예제 #1
0
파일: lib.php 프로젝트: jamesmcq/elis
 /**
  * Initialize internal customfield data - records, SELECT fragments, and additional joins.
  *
  * @return bool Success/Failure
  */
 protected function init_customfield_data()
 {
     global $DB;
     if (!empty($this->customfield_data)) {
         return true;
     }
     $fieldids = array();
     foreach ($this->enabled_fields as $field => $name) {
         if (strpos($field, 'field_') === 0) {
             $fieldid = substr($field, strlen('field_'));
             if (is_numeric($fieldid)) {
                 $fieldids[] = $fieldid;
             }
         }
     }
     if (!empty($fieldids)) {
         $select = 'id IN (' . implode(',', array_fill(0, count($fieldids), '?')) . ')';
         $this->customfield_data = $DB->get_records_select(field::TABLE, $select, $fieldids);
     }
     foreach ($this->customfield_data as $fieldid => $record) {
         $field = new field($record);
         $multivaluestatus = $this->init_multivalue_status_for_field($record->id, $record->multivalued);
         // Add joins and select entries, if field is enabled.
         if (isset($this->enabled_fields['field_' . $fieldid])) {
             if ($multivaluestatus === static::MULTIVALUE_NONE) {
                 // Extra columns we'll need to display profile field values.
                 $this->sql_select[] = "custom_data_{$field->id}.data AS custom_field_{$field->id}";
                 // Extra joins we'll need to display profile field values.
                 $field_data_table = "field_data_" . $field->data_type();
                 $this->sql_joins[] = "LEFT JOIN {" . $field_data_table::TABLE . "} custom_data_{$field->id}\n                                      ON custom_data_{$field->id}.fieldid = {$field->id}\n                                      AND " . static::FIELDSET_NAME . "_ctx.id = custom_data_{$field->id}.contextid\n                                      AND custom_data_{$field->id}.contextid IS NOT NULL";
             } else {
                 // Extra columns we'll need to display profile field values.
                 $this->sql_select[] = "'' AS custom_field_{$field->id}";
             }
         }
     }
     return true;
 }
예제 #2
0
 /**
  * Get custom fields
  *
  * This function returns an array of custom field names to labels, and has a few side effects
  * that set up data to use the custom fields later.  The side effects reduce the number of
  * database lookups required to generate the form.
  *
  * @param array $fields An array of db records representing custom fields
  * @return array Custom field names mapped to labels.
  */
 function get_custom_fields($group, $fields)
 {
     $yesno = array(1 => get_string('yes'), 0 => get_string('no'));
     // Array $xoptions to append to existing options['choices']
     $options = array();
     if (!$fields instanceof Iterator) {
         $fields = array();
     }
     foreach ($fields as $field) {
         $field = new field($field);
         if (!isset($field->owners['manual'])) {
             error_log("multifilter.php::get_custom_fields() - no field->owners['manual'] for {$field->name} ({$field_identifier})");
             continue;
         }
         $field_identifier = 'customfield-' . $field->id;
         $this->_fields[$group][$field_identifier] = $field;
         $this->record_short_field_name($field_identifier);
         $this->labels[$group][$field_identifier] = $field->name;
         $options[$field_identifier] = $field->name;
         $owner = new field_owner($field->owners['manual']);
         $params = unserialize($owner->params);
         //error_log("multifilter.php::get_custom_fields(): {$field_identifier} => {$params['control']} ({$this->datatypemap[$params['control']]})");
         $this->fieldtofiltermap[$group][$field_identifier] = $this->datatypemap[$params['control']];
         switch ($params['control']) {
             case 'datetime':
                 // TBD - options required for datetime fields?
                 $this->_choices[$field_identifier] = array('startyear' => $params['startyear'], 'stopyear' => $params['stopyear'], 'inctime' => isset($params['inctime']) ? $params['inctime'] : false);
                 break;
             case 'checkbox':
                 $this->_choices[$field_identifier] = $yesno;
                 break;
             case 'menu':
                 $choices = $owner->get_menu_options();
                 if (!empty($choices)) {
                     $this->_choices[$field_identifier] = array();
                     foreach ($choices as $key => $choice) {
                         $choice = trim($choice);
                         // preserve anyvalue key => ''
                         //$key = ($key === '') ? $key : $choice;
                         $this->_choices[$field_identifier][$key] = $choice;
                     }
                 } else {
                     error_log("multifilter::get_custom_fields() - empty menu options for fieldid = {$field->id} ... using: Yes, No");
                     $this->_choices[$field_identifier] = $yesno;
                 }
                 break;
             case 'text':
                 // fall-thru case!
             // fall-thru case!
             case 'textarea':
                 // no options required for text fields
                 break;
             default:
                 error_log("multifilter.php:: control = {$params['control']}, datatype = {$field->data_type()} not supported");
                 break;
         }
     }
     $this->sections[$group]['custom'] = $options;
 }
 /**
  * Validate that multivalue functionality is suppored for all data types when using the
  * "menu of choices" UI / input type
  *
  * @dataProvider data_type_provider
  * @param string $uitype The string value representing a data type
  * @param string $data The multi-valued custom field value to use as input
  * @param array $expected The values to expect in the databaes
  */
 public function test_multivalue_field_data_supports_all_data_types_for_menu_of_choices($datatype, $data, $expected)
 {
     global $CFG, $DB;
     require_once $CFG->dirroot . '/local/elisprogram/lib/setup.php';
     require_once elis::lib('data/customfield.class.php');
     require_once elispm::lib('data/user.class.php');
     // Set up the custom field, category, context association, and owner.
     // Use "expected" as list of available options.
     $fieldid = $this->create_test_field('user', $datatype, 'menu', true, $expected, null, null);
     // Reset the field list.
     $temp = new user();
     $temp->reset_custom_field_list();
     // Run the entity create action.
     $record = array('action' => 'create', 'idnumber' => 'testuseridnumber', 'username' => 'testuserusername', 'password' => 'testuserpassword', 'firstname' => 'testuserfirstname', 'lastname' => 'testuserlastname', 'email' => '*****@*****.**', 'city' => 'testusercity', 'country' => 'CA', 'testfieldshortname' => $data);
     $importplugin = rlip_dataplugin_factory::factory('dhimport_version1elis');
     $importplugin->fslogger = new silent_fslogger(null);
     $importplugin->process_record('user', (object) $record, 'bogus');
     // Validation.
     $instance = new field(array('datatype' => $datatype));
     $realtype = $instance->data_type();
     $realdataclass = "field_data_{$realtype}";
     $this->assert_field_values('user', user::TABLE, $realdataclass::TABLE, $fieldid, $expected);
 }