xref: /plugin/struct/action/entry.php (revision 016bf38258856475d69b0cb580f5acb575a07799)
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) {
4204641d56SMichael Große        if (act_clean($event->data) !== "save") return false;
4304641d56SMichael Große
4404641d56SMichael Große        /** @var \helper_plugin_struct_db $helper */
4504641d56SMichael Große        $helper = plugin_load('helper', 'struct_db');
4604641d56SMichael Große        $this->sqlite = $helper->getDB();
4704641d56SMichael Große
4804641d56SMichael Große        global $ID, $INPUT;
4904641d56SMichael Große
5004641d56SMichael Große        $res = $this->sqlite->query("SELECT tbl FROM schema_assignments WHERE assign = ?",array($ID,));
5104641d56SMichael Große        if (!$this->sqlite->res2count($res)) return false;
5204641d56SMichael Große
5304641d56SMichael Große        $tables = array_map(function ($value){return $value['tbl'];},$this->sqlite->res2arr($res));
5404641d56SMichael Große        $this->sqlite->res_close($res);
5504641d56SMichael Große
5604641d56SMichael Große        $structData = $INPUT->arr('Schema');
5704641d56SMichael Große        $timestamp = $INPUT->int('date');
5804641d56SMichael Große
5904641d56SMichael Große        foreach ($tables as $table) {
6004641d56SMichael Große            $schema = new SchemaData($table, $ID, $timestamp);
6104641d56SMichael Große            $schemaData = $structData[$table];
6204641d56SMichael Große            foreach ($schema->getColumns() as $col) {
6304641d56SMichael Große                if ($col->getType()->isMulti()) {
6404641d56SMichael Große                    $schemaData[$col->getType()->getLabel()] = explode(',',$schemaData[$col->getType()->getLabel()]);
6504641d56SMichael Große                    $schemaData[$col->getType()->getLabel()] = array_map(function($value){return trim($value);}, $schemaData[$col->getType()->getLabel()]);
6604641d56SMichael Große                }
6704641d56SMichael Große            }
6804641d56SMichael Große            $schema->saveData($schemaData);
6904641d56SMichael Große        }
7004641d56SMichael Große        return false;
7104641d56SMichael Große    }
7204641d56SMichael Große
73*016bf382SMichael Große    /*
74f36fda9dSAndreas Gohr     * Enhance the editing form with structural data editing
75549a0837SAndreas Gohr     *
76549a0837SAndreas Gohr     * @param Doku_Event $event  event object by reference
77549a0837SAndreas Gohr     * @param mixed      $param  [the parameters passed as fifth argument to register_hook() when this
78549a0837SAndreas Gohr     *                           handler was registered]
79c2fd0bf0SMichael Große     * @return bool
80549a0837SAndreas Gohr     */
81c07703d4SAndreas Gohr    public function handle_editform(Doku_Event $event, $param) {
8265598e4aSAndreas Gohr        global $ID;
83c2fd0bf0SMichael Große        /** @var \helper_plugin_struct_db $helper */
84c2fd0bf0SMichael Große        $helper = plugin_load('helper', 'struct_db');
85c2fd0bf0SMichael Große        $this->sqlite = $helper->getDB();
86c2fd0bf0SMichael Große
87c2fd0bf0SMichael Große        $res = $this->sqlite->query("SELECT tbl FROM schema_assignments WHERE assign = ?", array($ID,));
88c2fd0bf0SMichael Große        if(!$this->sqlite->res2count($res)) return false;
89c2fd0bf0SMichael Große
9065598e4aSAndreas Gohr        $tables = array_map(
9165598e4aSAndreas Gohr            function ($value) {
9265598e4aSAndreas Gohr                return $value['tbl'];
9365598e4aSAndreas Gohr            },
9465598e4aSAndreas Gohr            $this->sqlite->res2arr($res)
9565598e4aSAndreas Gohr        );
96c2fd0bf0SMichael Große
9765598e4aSAndreas Gohr        $html = '';
98c2fd0bf0SMichael Große        foreach($tables as $table) {
9965598e4aSAndreas Gohr            $html .= $this->createForm($table);
100c2fd0bf0SMichael Große        }
101c2fd0bf0SMichael Große
10265598e4aSAndreas Gohr        /** @var Doku_Form $form */
10365598e4aSAndreas Gohr        $form = $event->data;
10465598e4aSAndreas Gohr        $html = "<div class=\"struct\">$html</div>";
10565598e4aSAndreas Gohr        $pos = $form->findElementById('wiki__editbar'); // insert the form before the main buttons
10665598e4aSAndreas Gohr        $form->insertElement($pos, $html);
10765598e4aSAndreas Gohr
108c2fd0bf0SMichael Große        return true;
109c2fd0bf0SMichael Große    }
110c2fd0bf0SMichael Große
111c2fd0bf0SMichael Große    /**
11265598e4aSAndreas Gohr     * Create the form to edit schemadata
113f36fda9dSAndreas Gohr     *
114c2fd0bf0SMichael Große     * @param string $tablename
11565598e4aSAndreas Gohr     * @return string The HTML for this schema's form
116c2fd0bf0SMichael Große     */
11765598e4aSAndreas Gohr    protected function createForm($tablename) {
118c2fd0bf0SMichael Große        global $ID;
11983beda18SAndreas Gohr        global $REV;
12083beda18SAndreas Gohr        $schema = new SchemaData($tablename, $ID, $REV);
121c2fd0bf0SMichael Große        $schemadata = $schema->getData();
122c2fd0bf0SMichael Große
12365598e4aSAndreas Gohr        $html = "<h3>$tablename</h3>";
124750a393bSAndreas Gohr        $cols = $schema->getColumns(false);
125c2fd0bf0SMichael Große        foreach ($cols as $index => $col) {
126c2fd0bf0SMichael Große            $type = $col->getType();
127c2fd0bf0SMichael Große            $label = $type->getLabel();
128c2fd0bf0SMichael Große            $name = "Schema[$tablename][$label]";
129c2fd0bf0SMichael Große            $input = $type->valueEditor($name, $schemadata[$label]);
130c2fd0bf0SMichael Große            $element = "<label>$label $input</label><br />";
13165598e4aSAndreas Gohr            $html .= $element;
132c2fd0bf0SMichael Große        }
13365598e4aSAndreas Gohr
13465598e4aSAndreas Gohr        return $html;
135549a0837SAndreas Gohr    }
136549a0837SAndreas Gohr
137549a0837SAndreas Gohr}
138549a0837SAndreas Gohr
139549a0837SAndreas Gohr// vim:ts=4:sw=4:et:
140