. /** * @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 will move one index up/down * * @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 move_updown_index extends XMLDBAction { /** * Init method, every subclass will have its own */ function init() { parent::init(); // Set own custom attributes // Get needed strings $this->loadStrings(array( // 'key' => 'module', )); } /** * 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_NONE; //$this->does_generate = ACTION_GENERATE_HTML; // These are always here global $CFG, $XMLDB; // 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(); } $prev = NULL; $next = NULL; $tableparam = required_param('table', PARAM_CLEAN); $indexparam = required_param('index', PARAM_CLEAN); $direction = required_param('direction', PARAM_ALPHA); $tables =& $structure->getTables(); $table =& $structure->getTable($tableparam); $indexes =& $table->getIndexes(); if ($direction == 'down') { $index =& $table->getIndex($indexparam); $swap =& $table->getIndex($index->getNext()); } else { $swap =& $table->getIndex($indexparam); $index =& $table->getIndex($swap->getPrevious()); } // Change the index before the pair if ($index->getPrevious()) { $prev =& $table->getIndex($index->getPrevious()); $prev->setNext($swap->getName()); $swap->setPrevious($prev->getName()); $prev->setChanged(true); } else { $swap->setPrevious(NULL); } // Change the field after the pair if ($swap->getNext()) { $next =& $table->getIndex($swap->getNext()); $next->setPrevious($index->getName()); $index->setNext($next->getName()); $next->setChanged(true); } else { $index->setNext(NULL); } // Swap the indexes $index->setPrevious($swap->getName()); $swap->setNext($index->getName()); // Mark indexes as changed $index->setChanged(true); $swap->setChanged(true); // Table has changed $table->setChanged(true); // Reorder the indexes $table->orderIndexes($indexes); // Recalculate the hash $structure->calculateHash(true); // If the hash has changed from the original one, change the version // and mark the structure as changed $origstructure =& $dbdir->xml_file->getStructure(); if ($structure->getHash() != $origstructure->getHash()) { $structure->setVersion(userdate(time(), '%Y%m%d', 99, false)); $structure->setChanged(true); } // Launch postaction if exists (leave this here!) if ($this->getPostAction() && $result) { return $this->launch($this->getPostAction()); } // Return ok if arrived here return $result; } }