See Release Notes
Long Term Support Release
<?php /////////////////////////////////////////////////////////////////////////// // // // NOTICE OF COPYRIGHT // // // // Moodle - Modular Object-Oriented Dynamic Learning Environment // // http://moodle.org // // // // Copyright (C) 1999-onwards Moodle Pty Ltd http://moodle.com // // // // This program is free software; you can redistribute it and/or modify // // it under the terms of the GNU General Public License as published by // // the Free Software Foundation; either version 2 of the License, or // // (at your option) any later version. // // // // This program is distributed in the hope that it will be useful, // // but WITHOUT ANY WARRANTY; without even the implied warranty of // // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the // // GNU General Public License for more details: // // // // http://www.gnu.org/copyleft/gpl.html // // // /////////////////////////////////////////////////////////////////////////// class data_field_multimenu extends data_field_base { var $type = 'multimenu'; /** * priority for globalsearch indexing * * @var int * */ protected static $priority = self::LOW_PRIORITY;> public function supports_preview(): bool { function display_add_field($recordid = 0, $formdata = null) { > return true; global $DB, $OUTPUT; > } > if ($formdata) { > public function get_data_content_preview(int $recordid): stdClass { $fieldname = 'field_' . $this->field->id; > $options = explode("\n", $this->field->param1); if (isset($formdata->$fieldname)) { > $options = array_map('trim', $options); $content = $formdata->$fieldname; > $selected = $options[$recordid % count($options)]; } else { > $selected .= '##' . $options[($recordid + 1) % count($options)]; $content = array(); > return (object)[ } > 'id' => 0, } else if ($recordid) { > 'fieldid' => $this->field->id, $content = $DB->get_field('data_content', 'content', array('fieldid'=>$this->field->id, 'recordid'=>$recordid)); > 'recordid' => $recordid, $content = explode('##', $content); > 'content' => $selected, } else { > 'content1' => null, $content = array(); > 'content2' => null, } > 'content3' => null, > 'content4' => null, $str = '<div title="'.s($this->field->description).'">'; > ]; $str .= '<input name="field_' . $this->field->id . '[xxx]" type="hidden" value="xxx"/>'; // hidden field - needed for empty selection > } >$str .= '<label for="field_' . $this->field->id . '">'; $str .= '<legend><span class="accesshide">' . $this->field->name; if ($this->field->required) { $str .= ' ' . get_string('requiredelement', 'form') . '</span></legend>'; $str .= '<div class="inline-req">'; $str .= $OUTPUT->pix_icon('req', get_string('requiredelement', 'form')); $str .= '</div>'; } else { $str .= '</span></legend>'; } $str .= '</label>'; $str .= '<select name="field_' . $this->field->id . '[]" id="field_' . $this->field->id . '"'; $str .= ' multiple="multiple" class="mod-data-input form-control">'; foreach (explode("\n", $this->field->param1) as $option) { $option = trim($option); $str .= '<option value="' . s($option) . '"'; if (in_array($option, $content)) { // Selected by user. $str .= ' selected = "selected"'; } $str .= '>'; $str .= $option . '</option>'; } $str .= '</select>'; $str .= '</div>'; return $str; } function display_search_field($value = '') { global $CFG, $DB; if (is_array($value)){ $content = $value['selected']; $allrequired = $value['allrequired'] ? true : false; } else { $content = array(); $allrequired = false; } static $c = 0; $str = '<label class="accesshide" for="f_' . $this->field->id . '">' . $this->field->name . '</label>'; $str .= '<select id="f_'.$this->field->id.'" name="f_'.$this->field->id.'[]" multiple="multiple" class="form-control">'; // display only used options $varcharcontent = $DB->sql_compare_text('content', 255); $sql = "SELECT DISTINCT $varcharcontent AS content FROM {data_content} WHERE fieldid=? AND content IS NOT NULL"; $usedoptions = array(); if ($used = $DB->get_records_sql($sql, array($this->field->id))) { foreach ($used as $data) { $valuestr = $data->content; if ($valuestr === '') { continue; } $values = explode('##', $valuestr); foreach ($values as $value) { $usedoptions[$value] = $value; } } } $found = false; foreach (explode("\n",$this->field->param1) as $option) { $option = trim($option); if (!isset($usedoptions[$option])) { continue; } $found = true; $str .= '<option value="' . s($option) . '"'; if (in_array($option, $content)) { // Selected by user. $str .= ' selected = "selected"'; } $str .= '>' . $option . '</option>'; } if (!$found) { // oh, nothing to search for return ''; } $str .= '</select>'; $str .= html_writer::checkbox('f_'.$this->field->id.'_allreq', null, $allrequired, get_string('selectedrequired', 'data'), array('class' => 'mr-1')); return $str; } public function parse_search_field($defaults = null) { $paramselected = 'f_'.$this->field->id; $paramallrequired = 'f_'.$this->field->id.'_allreq'; if (empty($defaults[$paramselected])) { // One empty means the other ones are empty too. $defaults = array($paramselected => array(), $paramallrequired => 0); } $selected = optional_param_array($paramselected, $defaults[$paramselected], PARAM_NOTAGS); $allrequired = optional_param($paramallrequired, $defaults[$paramallrequired], PARAM_BOOL); if (empty($selected)) { // no searching return ''; } return array('selected'=>$selected, 'allrequired'=>$allrequired); } function generate_sql($tablealias, $value) { global $DB; static $i=0; $i++; $name = "df_multimenu_{$i}_"; $params = array(); $varcharcontent = $DB->sql_compare_text("{$tablealias}.content", 255); $allrequired = $value['allrequired']; $selected = $value['selected']; if ($selected) { $conditions = array(); $j=0; foreach ($selected as $sel) { $j++; $xname = $name.$j; $likesel = str_replace('%', '\%', $sel); $likeselsel = str_replace('_', '\_', $likesel); $conditions[] = "({$tablealias}.fieldid = {$this->field->id} AND ({$varcharcontent} = :{$xname}a OR {$tablealias}.content LIKE :{$xname}b OR {$tablealias}.content LIKE :{$xname}c OR {$tablealias}.content LIKE :{$xname}d))"; $params[$xname.'a'] = $sel; $params[$xname.'b'] = "$likesel##%"; $params[$xname.'c'] = "%##$likesel"; $params[$xname.'d'] = "%##$likesel##%"; } if ($allrequired) { return array(" (".implode(" AND ", $conditions).") ", $params); } else { return array(" (".implode(" OR ", $conditions).") ", $params); } } else { return array(" ", array()); } } function update_content($recordid, $value, $name='') { global $DB; $content = new stdClass(); $content->fieldid = $this->field->id; $content->recordid = $recordid; $content->content = $this->format_data_field_multimenu_content($value); if ($oldcontent = $DB->get_record('data_content', array('fieldid'=>$this->field->id, 'recordid'=>$recordid))) { $content->id = $oldcontent->id; return $DB->update_record('data_content', $content); } else { return $DB->insert_record('data_content', $content); } } function format_data_field_multimenu_content($content) { if (!is_array($content)) { return NULL; } $options = explode("\n", $this->field->param1); $options = array_map('trim', $options); $vals = array(); foreach ($content as $key=>$val) { if ($key === 'xxx') { continue; } if (!in_array($val, $options)) { continue; } $vals[] = $val; } if (empty($vals)) { return NULL; } return implode('##', $vals); } function display_browse_field($recordid, $template) {< global $DB; < < if ($content = $DB->get_record('data_content', array('fieldid'=>$this->field->id, 'recordid'=>$recordid))) { < if (strval($content->content) === '') { < return false;> $content = $this->get_data_content($recordid); > if (!$content || empty($content->content)) { > return '';}<$options = explode("\n",$this->field->param1); $options = array_map('trim', $options);< $contentArr = explode('##', $content->content);> $contentarray = explode('##', $content->content);$str = '';< foreach ($contentArr as $line) {> foreach ($contentarray as $line) {if (!in_array($line, $options)) {< // hmm, looks like somebody edited the field definition> // Hmm, looks like somebody edited the field definition.continue; } $str .= $line . "<br />\n"; } return $str;< } < return false;} /** * Check if a field from an add form is empty * * @param mixed $value * @param mixed $name * @return bool */ function notemptyfield($value, $name) { unset($value['xxx']); return !empty($value); } /** * Returns the presentable string value for a field content. * * The returned string should be plain text. * * @param stdClass $content * @return string */ public static function get_content_value($content) { $arr = explode('##', $content->content); $strvalue = ''; foreach ($arr as $a) { $strvalue .= $a . ' '; } return trim($strvalue, "\r\n "); } /** * Return the plugin configs for external functions. * * @return array the list of config parameters * @since Moodle 3.3 */ public function get_config_for_external() { // Return all the config parameters. $configs = []; for ($i = 1; $i <= 10; $i++) { $configs["param$i"] = $this->field->{"param$i"}; } return $configs; } }