187fdbc6bSMichael Große<?php 287fdbc6bSMichael Große/** 387fdbc6bSMichael Große * DokuWiki Plugin struct (Admin Component) 487fdbc6bSMichael Große * 587fdbc6bSMichael Große * @license GPL 2 http://www.gnu.org/licenses/gpl-2.0.html 687fdbc6bSMichael Große * @author Andreas Gohr, Michael Große <dokuwiki@cosmocode.de> 787fdbc6bSMichael Große */ 887fdbc6bSMichael Große 987fdbc6bSMichael Große// must be run within Dokuwiki 1087fdbc6bSMichael Großeuse dokuwiki\Form\Form; 111a8d1235SAndreas Gohruse plugin\struct\meta\Assignments; 1287fdbc6bSMichael Großeuse plugin\struct\meta\Schema; 1387fdbc6bSMichael Großeuse plugin\struct\meta\SchemaEditor; 1487fdbc6bSMichael Große 1587fdbc6bSMichael Großeif(!defined('DOKU_INC')) die(); 1687fdbc6bSMichael Große 1787fdbc6bSMichael Großeclass admin_plugin_struct_assignments extends DokuWiki_Admin_Plugin { 1887fdbc6bSMichael Große 1987fdbc6bSMichael Große /** 2087fdbc6bSMichael Große * @return int sort number in admin menu 2187fdbc6bSMichael Große */ 2287fdbc6bSMichael Große public function getMenuSort() { 2387fdbc6bSMichael Große return 501; 2487fdbc6bSMichael Große } 2587fdbc6bSMichael Große 2640b81cabSAndreas Gohr /** 2740b81cabSAndreas Gohr * Return the text that is displayed at the main admin menu 2840b81cabSAndreas Gohr * 2940b81cabSAndreas Gohr * @param string $language language code 3040b81cabSAndreas Gohr * @return string menu string 3140b81cabSAndreas Gohr */ 3240b81cabSAndreas Gohr public function getMenuText($language) { 3340b81cabSAndreas Gohr return $this->getLang('menu_assignments'); 3487fdbc6bSMichael Große } 3587fdbc6bSMichael Große 3687fdbc6bSMichael Große /** 3787fdbc6bSMichael Große * @return bool true if only access for superuser, false is for superusers and moderators 3887fdbc6bSMichael Große */ 3987fdbc6bSMichael Große public function forAdminOnly() { 4087fdbc6bSMichael Große return true; 4187fdbc6bSMichael Große } 4287fdbc6bSMichael Große 4387fdbc6bSMichael Große /** 4487fdbc6bSMichael Große * Should carry out any processing required by the plugin. 4587fdbc6bSMichael Große */ 4687fdbc6bSMichael Große public function handle() { 4787fdbc6bSMichael Große global $INPUT; 4887fdbc6bSMichael Große 491a8d1235SAndreas Gohr $assignments = new Assignments(); 5087fdbc6bSMichael Große if($INPUT->str('action') && $INPUT->arr('assignment') && checkSecurityToken()) { 5187fdbc6bSMichael Große $assignment = $INPUT->arr('assignment'); 521a8d1235SAndreas Gohr $ok = false; 5387fdbc6bSMichael Große if ($INPUT->str('action') === 'delete') { 541a8d1235SAndreas Gohr $ok = $assignments->remove($assignment['assign'], $assignment['tbl']); 551a8d1235SAndreas Gohr } else if($INPUT->str('action') === 'add') { 561a8d1235SAndreas Gohr $ok = $assignments->add($assignment['assign'], $assignment['tbl']); 5787fdbc6bSMichael Große } 581a8d1235SAndreas Gohr if(empty($sql) || empty($assignment['assign']) || empty($assignment['tbl']) || !$ok) { 5987fdbc6bSMichael Große msg('something went wrong while saving', -1); 6087fdbc6bSMichael Große } 6187fdbc6bSMichael Große } 6287fdbc6bSMichael Große } 6387fdbc6bSMichael Große 6487fdbc6bSMichael Große /** 6587fdbc6bSMichael Große * Render HTML output, e.g. helpful text and a form 6687fdbc6bSMichael Große */ 6787fdbc6bSMichael Große public function html() { 68a3d1e459SAndreas Gohr global $ID; 69a3d1e459SAndreas Gohr 7087fdbc6bSMichael Große echo $this->locale_xhtml('assignments_intro'); 7187fdbc6bSMichael Große 72*5f803f49SAndreas Gohr //fixme listing schema tables should be moved to one of the meta classes 73*5f803f49SAndreas Gohr /** @var helper_plugin_struct_db $helper */ 74*5f803f49SAndreas Gohr $helper = plugin_load('helper', 'struct_db'); 75*5f803f49SAndreas Gohr $sqlite = $helper->getDB(); 76*5f803f49SAndreas Gohr $res = $sqlite->query('SELECT tbl FROM schemas GROUP BY tbl'); 77*5f803f49SAndreas Gohr $schemas = $sqlite->res2arr($res); 78*5f803f49SAndreas Gohr $sqlite->res_close($res); 7987fdbc6bSMichael Große 801a8d1235SAndreas Gohr $ass = new Assignments(); 811a8d1235SAndreas Gohr $assignments = $ass->getAll(); 8287fdbc6bSMichael Große 83a3d1e459SAndreas Gohr 84a3d1e459SAndreas Gohr 85a3d1e459SAndreas Gohr echo '<form action="'.wl($ID).'">'; 86a3d1e459SAndreas Gohr echo '<input type="hidden" name="do" value="admin" />'; 87a3d1e459SAndreas Gohr echo '<input type="hidden" name="page" value="struct_assignments" />'; 88a3d1e459SAndreas Gohr echo '<input type="hidden" name="sectok" value="'.getSecurityToken().'" />'; 89a3d1e459SAndreas Gohr echo '<table class="inline">'; 90a3d1e459SAndreas Gohr 91a3d1e459SAndreas Gohr // header 92a3d1e459SAndreas Gohr echo '<tr>'; 93a3d1e459SAndreas Gohr echo '<th>Page/Namespace</th>'; // FIXME localize 94a3d1e459SAndreas Gohr echo '<th>Schema</th>'; // FIXME localize 95a3d1e459SAndreas Gohr echo '<th></th>'; 96a3d1e459SAndreas Gohr echo '</tr>'; 97a3d1e459SAndreas Gohr 98a3d1e459SAndreas Gohr // existing assignments 9987fdbc6bSMichael Große foreach ($assignments as $assignment) { 10087fdbc6bSMichael Große $schema = $assignment['tbl']; 10187fdbc6bSMichael Große $assignee = $assignment['assign']; 102a3d1e459SAndreas Gohr 103a3d1e459SAndreas Gohr $link = wl($ID, array( 104a3d1e459SAndreas Gohr 'do' => 'admin', 105a3d1e459SAndreas Gohr 'page' => 'struct_assignments', 106a3d1e459SAndreas Gohr 'action' => 'delete', 107a3d1e459SAndreas Gohr 'sectok' => getSecurityToken(), 108a3d1e459SAndreas Gohr 'assignment[tbl]' => $schema, 109a3d1e459SAndreas Gohr 'assignment[assign]' => $assignee, 110a3d1e459SAndreas Gohr )); 111a3d1e459SAndreas Gohr 112a3d1e459SAndreas Gohr echo '<tr>'; 113a3d1e459SAndreas Gohr echo '<td>'.hsc($assignee).'</td>'; 114a3d1e459SAndreas Gohr echo '<td>'.hsc($schema).'</td>'; 115a3d1e459SAndreas Gohr echo '<td><a href="'.$link.'">Delete</a></td>'; //FIXME localize 116a3d1e459SAndreas Gohr echo '</tr>'; 11787fdbc6bSMichael Große } 118a3d1e459SAndreas Gohr 119a3d1e459SAndreas Gohr // new assignment form 120a3d1e459SAndreas Gohr echo '<tr>'; 121a3d1e459SAndreas Gohr echo '<td><input type="text" name="assignment[assign]" /></td>'; 122a3d1e459SAndreas Gohr echo '<td>'; 123a3d1e459SAndreas Gohr echo '<select name="assignment[tbl]">'; 12487fdbc6bSMichael Große foreach ($schemas as $schema){ 125a3d1e459SAndreas Gohr echo '<option value="'. hsc($schema['tbl']) .'">'. hsc($schema['tbl']) . '</option>'; 12687fdbc6bSMichael Große } 127a3d1e459SAndreas Gohr echo '</select>'; 128a3d1e459SAndreas Gohr echo '</td>'; 129a3d1e459SAndreas Gohr echo '<td><button type="submit" name="action" value="add">Add</button></td>'; // FIXME localize 130a3d1e459SAndreas Gohr echo '</tr>'; 131a3d1e459SAndreas Gohr 132a3d1e459SAndreas Gohr echo '</table>'; 13387fdbc6bSMichael Große } 134dbffe06eSAndreas Gohr 135dbffe06eSAndreas Gohr /** 136dbffe06eSAndreas Gohr * Copies the TOC from the Schema Editor 137dbffe06eSAndreas Gohr * 138dbffe06eSAndreas Gohr * @return array 139dbffe06eSAndreas Gohr */ 140dbffe06eSAndreas Gohr public function getTOC() { 141dbffe06eSAndreas Gohr /** @var admin_plugin_struct_schemas $plugin */ 142dbffe06eSAndreas Gohr $plugin = plugin_load('admin', 'struct_schemas'); 143dbffe06eSAndreas Gohr return $plugin->getTOC(); 14487fdbc6bSMichael Große } 14587fdbc6bSMichael Große 14687fdbc6bSMichael Große} 14787fdbc6bSMichael Große 14887fdbc6bSMichael Große// vim:ts=4:sw=4:et: 149