1549a0837SAndreas Gohr<?php 2549a0837SAndreas Gohr/** 3549a0837SAndreas Gohr * DokuWiki Plugin struct (Action Component) 4549a0837SAndreas Gohr * 5549a0837SAndreas Gohr * @license GPL 2 http://www.gnu.org/licenses/gpl-2.0.html 6549a0837SAndreas Gohr * @author Andreas Gohr, Michael Große <dokuwiki@cosmocode.de> 7549a0837SAndreas Gohr */ 8549a0837SAndreas Gohr 9549a0837SAndreas Gohr// must be run within Dokuwiki 10549a0837SAndreas Gohrif(!defined('DOKU_INC')) die(); 11549a0837SAndreas Gohr 12c2fd0bf0SMichael Großeuse plugin\struct\meta\SchemaData; 13c2fd0bf0SMichael Große 14549a0837SAndreas Gohrclass action_plugin_struct_entry extends DokuWiki_Action_Plugin { 15549a0837SAndreas Gohr 16c2fd0bf0SMichael Große 17c2fd0bf0SMichael Große /** @var helper_plugin_sqlite */ 18c2fd0bf0SMichael Große protected $sqlite; 19c2fd0bf0SMichael Große 20549a0837SAndreas Gohr /** 21549a0837SAndreas Gohr * Registers a callback function for a given event 22549a0837SAndreas Gohr * 23549a0837SAndreas Gohr * @param Doku_Event_Handler $controller DokuWiki's event controller object 24549a0837SAndreas Gohr * @return void 25549a0837SAndreas Gohr */ 26549a0837SAndreas Gohr public function register(Doku_Event_Handler $controller) { 27549a0837SAndreas Gohr 28c2fd0bf0SMichael Große $controller->register_hook('HTML_EDITFORM_OUTPUT', 'BEFORE', $this, 'handle_editform'); 2904641d56SMichael Große $controller->register_hook('ACTION_ACT_PREPROCESS', 'BEFORE', $this, 'handle_pagesave'); 30549a0837SAndreas Gohr 31549a0837SAndreas Gohr } 32549a0837SAndreas Gohr 33549a0837SAndreas Gohr /** 3404641d56SMichael Große * Save values of Schemas but do not interfere with saving the page. 3504641d56SMichael Große * 3604641d56SMichael Große * @param Doku_Event $event event object by reference 3704641d56SMichael Große * @param mixed $param [the parameters passed as fifth argument to register_hook() when this 3804641d56SMichael Große * handler was registered] 3904641d56SMichael Große * @return bool 4004641d56SMichael Große */ 4104641d56SMichael Große public function handle_pagesave(Doku_Event &$event, $param) { 423ece9074SMichael Große global $ID, $INPUT; 4304641d56SMichael Große if (act_clean($event->data) !== "save") return false; 4404641d56SMichael Große 4504641d56SMichael Große /** @var \helper_plugin_struct_db $helper */ 4604641d56SMichael Große $helper = plugin_load('helper', 'struct_db'); 4704641d56SMichael Große $this->sqlite = $helper->getDB(); 4804641d56SMichael Große 4904641d56SMichael Große $res = $this->sqlite->query("SELECT tbl FROM schema_assignments WHERE assign = ?",array($ID,)); 5004641d56SMichael Große if (!$this->sqlite->res2count($res)) return false; 5104641d56SMichael Große 523ece9074SMichael Große $tables = array_map( 533ece9074SMichael Große function ($value) { 543ece9074SMichael Große return $value['tbl']; 553ece9074SMichael Große }, 563ece9074SMichael Große $this->sqlite->res2arr($res) 573ece9074SMichael Große ); 5804641d56SMichael Große $this->sqlite->res_close($res); 5904641d56SMichael Große 6004641d56SMichael Große $structData = $INPUT->arr('Schema'); 6104641d56SMichael Große $timestamp = $INPUT->int('date'); 6204641d56SMichael Große 6304641d56SMichael Große foreach ($tables as $table) { 6404641d56SMichael Große $schema = new SchemaData($table, $ID, $timestamp); 6504641d56SMichael Große $schemaData = $structData[$table]; 6604641d56SMichael Große foreach ($schema->getColumns() as $col) { 67*afbd4e60SMichael Große $type = $col->getType(); 68*afbd4e60SMichael Große $label = $type->getLabel(); 69*afbd4e60SMichael Große if ($type->isMulti() && !is_array($schemaData[$label])) { 70*afbd4e60SMichael Große $schemaData[$label] = $type->splitValues($schemaData[$label]); 7104641d56SMichael Große } 7204641d56SMichael Große } 7304641d56SMichael Große $schema->saveData($schemaData); 7404641d56SMichael Große } 7504641d56SMichael Große return false; 7604641d56SMichael Große } 7704641d56SMichael Große 78016bf382SMichael Große /* 79f36fda9dSAndreas Gohr * Enhance the editing form with structural data editing 80549a0837SAndreas Gohr * 81549a0837SAndreas Gohr * @param Doku_Event $event event object by reference 82549a0837SAndreas Gohr * @param mixed $param [the parameters passed as fifth argument to register_hook() when this 83549a0837SAndreas Gohr * handler was registered] 84c2fd0bf0SMichael Große * @return bool 85549a0837SAndreas Gohr */ 86c07703d4SAndreas Gohr public function handle_editform(Doku_Event $event, $param) { 8765598e4aSAndreas Gohr global $ID; 88c2fd0bf0SMichael Große /** @var \helper_plugin_struct_db $helper */ 89c2fd0bf0SMichael Große $helper = plugin_load('helper', 'struct_db'); 90c2fd0bf0SMichael Große $this->sqlite = $helper->getDB(); 91c2fd0bf0SMichael Große 92c2fd0bf0SMichael Große $res = $this->sqlite->query("SELECT tbl FROM schema_assignments WHERE assign = ?", array($ID,)); 93c2fd0bf0SMichael Große if(!$this->sqlite->res2count($res)) return false; 94c2fd0bf0SMichael Große 9565598e4aSAndreas Gohr $tables = array_map( 9665598e4aSAndreas Gohr function ($value) { 9765598e4aSAndreas Gohr return $value['tbl']; 9865598e4aSAndreas Gohr }, 9965598e4aSAndreas Gohr $this->sqlite->res2arr($res) 10065598e4aSAndreas Gohr ); 1013ece9074SMichael Große $this->sqlite->res_close($res); 102c2fd0bf0SMichael Große 10365598e4aSAndreas Gohr $html = ''; 104c2fd0bf0SMichael Große foreach($tables as $table) { 10565598e4aSAndreas Gohr $html .= $this->createForm($table); 106c2fd0bf0SMichael Große } 107c2fd0bf0SMichael Große 10865598e4aSAndreas Gohr /** @var Doku_Form $form */ 10965598e4aSAndreas Gohr $form = $event->data; 11065598e4aSAndreas Gohr $html = "<div class=\"struct\">$html</div>"; 11165598e4aSAndreas Gohr $pos = $form->findElementById('wiki__editbar'); // insert the form before the main buttons 11265598e4aSAndreas Gohr $form->insertElement($pos, $html); 11365598e4aSAndreas Gohr 114c2fd0bf0SMichael Große return true; 115c2fd0bf0SMichael Große } 116c2fd0bf0SMichael Große 117c2fd0bf0SMichael Große /** 11865598e4aSAndreas Gohr * Create the form to edit schemadata 119f36fda9dSAndreas Gohr * 120c2fd0bf0SMichael Große * @param string $tablename 12165598e4aSAndreas Gohr * @return string The HTML for this schema's form 122c2fd0bf0SMichael Große */ 12365598e4aSAndreas Gohr protected function createForm($tablename) { 124c2fd0bf0SMichael Große global $ID; 12583beda18SAndreas Gohr global $REV; 12683beda18SAndreas Gohr $schema = new SchemaData($tablename, $ID, $REV); 127c2fd0bf0SMichael Große $schemadata = $schema->getData(); 128c2fd0bf0SMichael Große 12965598e4aSAndreas Gohr $html = "<h3>$tablename</h3>"; 130750a393bSAndreas Gohr $cols = $schema->getColumns(false); 131c2fd0bf0SMichael Große foreach ($cols as $index => $col) { 132c2fd0bf0SMichael Große $type = $col->getType(); 133c2fd0bf0SMichael Große $label = $type->getLabel(); 134c2fd0bf0SMichael Große $name = "Schema[$tablename][$label]"; 135899b86acSAndreas Gohr if($type->isMulti()) { 136899b86acSAndreas Gohr $input = $type->multiValueEditor($name, $schemadata[$label]); 137899b86acSAndreas Gohr } else { 138c2fd0bf0SMichael Große $input = $type->valueEditor($name, $schemadata[$label]); 139899b86acSAndreas Gohr } 140c2fd0bf0SMichael Große $element = "<label>$label $input</label><br />"; 14165598e4aSAndreas Gohr $html .= $element; 142c2fd0bf0SMichael Große } 14365598e4aSAndreas Gohr 14465598e4aSAndreas Gohr return $html; 145549a0837SAndreas Gohr } 146549a0837SAndreas Gohr 147549a0837SAndreas Gohr} 148549a0837SAndreas Gohr 149549a0837SAndreas Gohr// vim:ts=4:sw=4:et: 150