. /** * @package tool * @subpackage xmldb * @copyright 2003 onwards Eloy Lafuente (stronk7) {@link http://stronk7.com} * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ /** * This class will provide the interface for all the edit field actions * * @package tool * @subpackage xmldb * @copyright 2003 onwards Eloy Lafuente (stronk7) {@link http://stronk7.com} * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ class edit_field extends XMLDBAction { /** * Init method, every subclass will have its own */ function init() { parent::init(); // Set own custom attributes $this->sesskey_protected = false; // This action doesn't need sesskey protection // Get needed strings $this->loadStrings(array( 'change' => 'tool_xmldb', 'float2numbernote' => 'tool_xmldb', 'vieworiginal' => 'tool_xmldb', 'viewedited' => 'tool_xmldb', 'yes' => '', 'no' => '', 'back' => 'tool_xmldb' )); } /** * Invoke method, every class will have its own * returns true/false on completion, setting both * errormsg and output as necessary */ function invoke() { parent::invoke(); $result = true; // Set own core attributes $this->does_generate = ACTION_GENERATE_HTML; // These are always here global $CFG, $XMLDB, $OUTPUT; // Do the job, setting result as needed // Get the dir containing the file $dirpath = required_param('dir', PARAM_PATH); $dirpath = $CFG->dirroot . $dirpath; // Get the correct dirs if (!empty($XMLDB->dbdirs)) { $dbdir =& $XMLDB->dbdirs[$dirpath]; } else { return false; } if (!empty($XMLDB->editeddirs)) { $editeddir =& $XMLDB->editeddirs[$dirpath]; $structure =& $editeddir->xml_file->getStructure(); } // Fetch request data $tableparam = required_param('table', PARAM_CLEAN); if (!$table =& $structure->getTable($tableparam)) { $this->errormsg = 'Wrong table specified: ' . $tableparam; return false; } $fieldparam = required_param('field', PARAM_CLEAN); if (!$field =& $table->getField($fieldparam)) { // Arriving here from a name change, looking for the new field name $fieldparam = required_param('name', PARAM_CLEAN); $field =& $table->getField($fieldparam); } $dbdir =& $XMLDB->dbdirs[$dirpath]; $origstructure =& $dbdir->xml_file->getStructure(); $o = ''; // Output starts // If field is XMLDB_TYPE_FLOAT, comment about to migrate it to XMLDB_TYPE_NUMBER if ($field->getType() == XMLDB_TYPE_FLOAT) { $o .= '

' . $this->str['float2numbernote'] . '

'; } // Add the main form $o.= '
'; $o.= '
'; $o.= ' '; $o.= ' '; $o.= ' '; $o.= ' '; $o.= ' '; $o.= ' '; $o.= ' '; // XMLDB field name // If the field has dependencies, we cannot change its name $disabled = ''; if ($structure->getFieldUses($table->getName(), $field->getName())) { $o.= ' '; $o.= ' '; } else { $o.= ' '; } // XMLDB field comment $o.= ' '; // xmldb_field Type $typeoptions = array (XMLDB_TYPE_INTEGER => $field->getXMLDBTypeName(XMLDB_TYPE_INTEGER), XMLDB_TYPE_NUMBER => $field->getXMLDBTypeName(XMLDB_TYPE_NUMBER), XMLDB_TYPE_FLOAT => $field->getXMLDBTypeName(XMLDB_TYPE_FLOAT), XMLDB_TYPE_DATETIME=> $field->getXMLDBTypeName(XMLDB_TYPE_DATETIME), XMLDB_TYPE_CHAR => $field->getXMLDBTypeName(XMLDB_TYPE_CHAR), XMLDB_TYPE_TEXT => $field->getXMLDBTypeName(XMLDB_TYPE_TEXT), XMLDB_TYPE_BINARY => $field->getXMLDBTypeName(XMLDB_TYPE_BINARY)); // If current field isnt float, delete such column type to avoid its creation from the interface // Note that float fields are supported completely but it's possible than in a next future // we delete them completely from Moodle DB, using, exlusively, number(x,y) types if ($field->getType() != XMLDB_TYPE_FLOAT) { unset ($typeoptions[XMLDB_TYPE_FLOAT]); } // Also we hide datetimes. Only edition of them is allowed (and retrofit) but not new creation if ($field->getType() != XMLDB_TYPE_DATETIME) { unset ($typeoptions[XMLDB_TYPE_DATETIME]); } $select = html_writer::select($typeoptions, 'type', $field->getType(), false); $o.= ' '; $o.= ' '; // xmldb_field Length $o.= ' '; $o.= ' '; // xmldb_field Decimals $o.= ' '; $o.= ' '; // xmldb_field Unsigned $unsignedoptions = array (0 => 'signed', 1 => 'unsigned'); $select = html_writer::select($unsignedoptions, 'unsigned', $field->getUnsigned(), false); $o.= ' '; $o.= ' '; // xmldb_field NotNull $notnulloptions = array (0 => 'null', 'not null'); $select = html_writer::select($notnulloptions, 'notnull', $field->getNotNull(), false); $o.= ' '; $o.= ' '; // xmldb_field Sequence $sequenceoptions = array (0 => $this->str['no'], 1 => 'auto-numbered'); $select = html_writer::select($sequenceoptions, 'sequence', $field->getSequence(), false); $o.= ' '; $o.= ' '; // xmldb_field Default $o.= ' '; $o.= ' '; // Change button $o.= ' '; $o.= '
Name:' . s($field->getName()) . '
' . $select . '
' . $select . '
' . $select . '
' . $select . '
 
'; $o.= '
'; // Calculate the buttons $b = '

'; // The view original XML button if ($table->getField($fieldparam)) { $b .= ' [' . $this->str['vieworiginal'] . ']'; } else { $b .= ' [' . $this->str['vieworiginal'] . ']'; } // The view edited XML button if ($field->hasChanged()) { $b .= ' [' . $this->str['viewedited'] . ']'; } else { $b .= ' [' . $this->str['viewedited'] . ']'; } // The back to edit table button $b .= ' [' . $this->str['back'] . ']'; $b .= '

'; $o .= $b; $this->output = $o; // Launch postaction if exists (leave this here!) if ($this->getPostAction() && $result) { return $this->launch($this->getPostAction()); } // Return ok if arrived here return $result; } }