xref: /plugin/struct/action/entry.php (revision afbd4e60caccda640f005a3ee22bd3a03a80510d)
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