xref: /plugin/struct/admin/assignments.php (revision 40b81cab7fcfbaf421e6ee2e80edafd63f0ae2dd)

<?php
/**
 * DokuWiki Plugin struct (Admin Component)
 *
 * @license GPL 2 http://www.gnu.org/licenses/gpl-2.0.html
 * @author  Andreas Gohr, Michael Große <dokuwiki@cosmocode.de>
 */

// must be run within Dokuwiki
use dokuwiki\Form\Form;
use plugin\struct\meta\Schema;
use plugin\struct\meta\SchemaEditor;

if(!defined('DOKU_INC')) die();

class admin_plugin_struct_assignments extends DokuWiki_Admin_Plugin {

    /** @var helper_plugin_sqlite */
    protected $sqlite;

    /**
     * @return int sort number in admin menu
     */
    public function getMenuSort() {
        return 501;
    }

    /**
     * Return the text that is displayed at the main admin menu
     *
     * @param string $language language code
     * @return string menu string
     */
    public function getMenuText($language) {
        return $this->getLang('menu_assignments');
    }

    /**
     * @return bool true if only access for superuser, false is for superusers and moderators
     */
    public function forAdminOnly() {
        return true;
    }

    /**
     * Should carry out any processing required by the plugin.
     */
    public function handle() {
        global $INPUT;

        /** @var \helper_plugin_struct_db $helper */
        $helper = plugin_load('helper', 'struct_db');
        $this->sqlite = $helper->getDB();

        if($INPUT->str('action') && $INPUT->arr('assignment') && checkSecurityToken()) {
            $assignment = $INPUT->arr('assignment');
            if ($INPUT->str('action') === 'delete') {
                $sql = 'DELETE FROM schema_assignments WHERE assign = ? AND tbl = ?';
            }
            if ($INPUT->str('action') === 'add') {
                $sql = 'REPLACE INTO schema_assignments (assign, tbl) VALUES (?,?)';
            }
            $opts = array($assignment['assign'], $assignment['tbl']);
            if(empty($sql) || empty($assignment['assign']) || empty($assignment['tbl']) || !$this->sqlite->query($sql, $opts)) {
                msg('something went wrong while saving', -1);
            }
        }

    }

    /**
     * Render HTML output, e.g. helpful text and a form
     */
    public function html() {
        global $INPUT;

        echo $this->locale_xhtml('assignments_intro');

        $res = $this->sqlite->query('SELECT tbl FROM schemas GROUP BY tbl');
        $schemas = $this->sqlite->res2arr($res);
        $this->sqlite->res_close($res);

        $res = $this->sqlite->query('SELECT * FROM schema_assignments ORDER BY assign');
        $assignments = $this->sqlite->res2arr($res);
        $this->sqlite->res_close($res);

        echo '<ul>';
        foreach ($assignments as $assignment) {
            $schema = $assignment['tbl'];
            $assignee = $assignment['assign'];
            $form = new Form();
            $form->setHiddenField("assignment[assign]", $assignee);
            $form->setHiddenField("assignment[tbl]", $schema);
            $form->addHTML("<button type=\"submit\" name=\"action\" value=\"delete\">Delete</button>");
            $html = "<li class=\"level1\"><div class=\"li\">$assignee - $schema ";
            $html .= $form->toHTML();
            $html .= "</div></li>";
            echo $html;
        }
        $form = new Form();
        $form->addTextInput("assignment[assign]",'Page or Namespace: ');
        $form->addLabel('Schema','schemaSelect');
        $form->addHTML('<select id="schemaSelect" name="assignment[tbl]">');
        foreach ($schemas as $schema){
            $form->addHTML('<option value="'. $schema['tbl'] .'">'. $schema['tbl'] . '</option>');
        }
        $form->addHTML('</select>');
        $form->addHTML("<button type=\"submit\" name=\"action\" value=\"add\">Add</button>");
        $html = "<li class=\"level1\"><div class=\"li\">";
        $html .= $form->toHTML();
        $html .= "</div></li>";
        echo $html;
        echo '</ul>';


        $table = Schema::cleanTableName($INPUT->str('table'));
        if($table) {
            echo '<h2>'.sprintf($this->getLang('edithl'), hsc($table)).'</h2>';

            $editor = new SchemaEditor(new Schema($table));
            echo $editor->getEditor();
        } else {
            $this->html_newschema();
        }
    }

}

// vim:ts=4:sw=4:et: