1b36f8833SAndreas Gohr<?php 2d6d97f60SAnna Dabrowska 3b36f8833SAndreas Gohr/** 4b36f8833SAndreas Gohr * DokuWiki Plugin struct (Helper Component) 5b36f8833SAndreas Gohr * 6b36f8833SAndreas Gohr * @license GPL 2 http://www.gnu.org/licenses/gpl-2.0.html 7b36f8833SAndreas Gohr * @author Andreas Gohr, Michael Große <dokuwiki@cosmocode.de> 8b36f8833SAndreas Gohr */ 9b36f8833SAndreas Gohr 10b36f8833SAndreas Gohr// must be run within Dokuwiki 117234bfb1Ssplitbrainuse dokuwiki\Extension\RemotePlugin; 127234bfb1Ssplitbrainuse dokuwiki\Remote\AccessDeniedException; 137234bfb1Ssplitbrainuse dokuwiki\plugin\struct\meta\Value; 14935a9fa3SMichael Großeuse dokuwiki\plugin\struct\meta\ConfigParser; 15935a9fa3SMichael Großeuse dokuwiki\plugin\struct\meta\SearchConfig; 16ba766201SAndreas Gohruse dokuwiki\plugin\struct\meta\StructException; 17b36f8833SAndreas Gohr 187234bfb1Ssplitbrainclass remote_plugin_struct extends RemotePlugin 19d6d97f60SAnna Dabrowska{ 20b36f8833SAndreas Gohr /** @var helper_plugin_struct hlp */ 21b36f8833SAndreas Gohr protected $hlp; 22b36f8833SAndreas Gohr 23b36f8833SAndreas Gohr /** 24b36f8833SAndreas Gohr * remote_plugin_struct constructor. 25b36f8833SAndreas Gohr */ 26d6d97f60SAnna Dabrowska public function __construct() 27d6d97f60SAnna Dabrowska { 28b36f8833SAndreas Gohr parent::__construct(); 29b36f8833SAndreas Gohr 30b36f8833SAndreas Gohr $this->hlp = plugin_load('helper', 'struct'); 31b36f8833SAndreas Gohr } 32b36f8833SAndreas Gohr 33b36f8833SAndreas Gohr /** 34b36f8833SAndreas Gohr * Get the structured data of a given page 35b36f8833SAndreas Gohr * 36b36f8833SAndreas Gohr * @param string $page The page to get data for 37b36f8833SAndreas Gohr * @param string $schema The schema to use empty for all 38b36f8833SAndreas Gohr * @param int $time A timestamp if you want historic data (0 for now) 39b36f8833SAndreas Gohr * @return array ('schema' => ( 'fieldlabel' => 'value', ...)) 40b36f8833SAndreas Gohr * @throws RemoteAccessDeniedException 41b36f8833SAndreas Gohr * @throws RemoteException 42b36f8833SAndreas Gohr */ 43d6d97f60SAnna Dabrowska public function getData($page, $schema, $time) 44d6d97f60SAnna Dabrowska { 45b36f8833SAndreas Gohr $page = cleanID($page); 46b36f8833SAndreas Gohr 4799d15ae8SEnno Lohmeier if (auth_quickaclcheck($page) < AUTH_READ) { 487234bfb1Ssplitbrain throw new AccessDeniedException('no permissions to access data of that page'); 49b36f8833SAndreas Gohr } 50b36f8833SAndreas Gohr 51b36f8833SAndreas Gohr if (!$schema) $schema = null; 52b36f8833SAndreas Gohr 53b36f8833SAndreas Gohr try { 54b36f8833SAndreas Gohr return $this->hlp->getData($page, $schema, $time); 55b36f8833SAndreas Gohr } catch (StructException $e) { 567234bfb1Ssplitbrain throw new \dokuwiki\Remote\RemoteException($e->getMessage(), 0, $e); 57b36f8833SAndreas Gohr } 58b36f8833SAndreas Gohr } 59b36f8833SAndreas Gohr 60b36f8833SAndreas Gohr 61b36f8833SAndreas Gohr /** 62b36f8833SAndreas Gohr * Saves data for a given page (creates a new revision) 63b36f8833SAndreas Gohr * 64b36f8833SAndreas Gohr * If this call succeeds you can assume your data has either been saved or it was 65b36f8833SAndreas Gohr * not necessary to save it because the data already existed in the wanted form or 66b36f8833SAndreas Gohr * the given schemas are no longer assigned to that page. 67b36f8833SAndreas Gohr * 68b36f8833SAndreas Gohr * @param string $page 69b36f8833SAndreas Gohr * @param array $data ('schema' => ( 'fieldlabel' => 'value', ...)) 70b36f8833SAndreas Gohr * @param string $summary 71178d3992SElan Ruusamäe * @param bool $minor 72b36f8833SAndreas Gohr * @return bool returns always true 73b36f8833SAndreas Gohr * @throws RemoteAccessDeniedException 74b36f8833SAndreas Gohr * @throws RemoteException 75b36f8833SAndreas Gohr */ 76d6d97f60SAnna Dabrowska public function saveData($page, $data, $summary, $minor = false) 77d6d97f60SAnna Dabrowska { 78b36f8833SAndreas Gohr $page = cleanID($page); 79b36f8833SAndreas Gohr 8099d15ae8SEnno Lohmeier if (auth_quickaclcheck($page) < AUTH_EDIT) { 817234bfb1Ssplitbrain throw new AccessDeniedException('no permissions to save data for that page'); 82b36f8833SAndreas Gohr } 83b36f8833SAndreas Gohr 84b36f8833SAndreas Gohr try { 85178d3992SElan Ruusamäe $this->hlp->saveData($page, $data, $summary, $minor); 86b36f8833SAndreas Gohr return true; 87b36f8833SAndreas Gohr } catch (StructException $e) { 887234bfb1Ssplitbrain throw new \dokuwiki\Remote\RemoteException($e->getMessage(), 0, $e); 89b36f8833SAndreas Gohr } 90b36f8833SAndreas Gohr } 91b36f8833SAndreas Gohr 92b36f8833SAndreas Gohr /** 93b36f8833SAndreas Gohr * Get info about existing schemas columns 94b36f8833SAndreas Gohr * 95b36f8833SAndreas Gohr * Returns only current, enabled columns 96b36f8833SAndreas Gohr * 97b36f8833SAndreas Gohr * @param string $schema the schema to query, empty for all 98b36f8833SAndreas Gohr * @return array 99b36f8833SAndreas Gohr * @throws RemoteAccessDeniedException 100b36f8833SAndreas Gohr * @throws RemoteException 101b36f8833SAndreas Gohr */ 102d6d97f60SAnna Dabrowska public function getSchema($schema = null) 103d6d97f60SAnna Dabrowska { 104b36f8833SAndreas Gohr if (!auth_ismanager()) { 1057234bfb1Ssplitbrain throw new AccessDeniedException('you need to be manager to access schema info'); 106b36f8833SAndreas Gohr } 107b36f8833SAndreas Gohr 108b36f8833SAndreas Gohr try { 1097234bfb1Ssplitbrain $result = []; 1106c9d1a10SAnna Dabrowska $schemas = $this->hlp::getSchema($schema ?: null); 111b36f8833SAndreas Gohr foreach ($schemas as $name => $schema) { 1127234bfb1Ssplitbrain $result[$name] = []; 113b36f8833SAndreas Gohr foreach ($schema->getColumns(false) as $column) { 114*7fe2cdf2SAndreas Gohr $class = explode('\\', get_class($column->getType())); 115*7fe2cdf2SAndreas Gohr $class = array_pop($class); 116*7fe2cdf2SAndreas Gohr $result[$name][] = [ 117*7fe2cdf2SAndreas Gohr 'name' => $column->getLabel(), 118*7fe2cdf2SAndreas Gohr 'type' => $class, 119*7fe2cdf2SAndreas Gohr 'ismulti' => $column->isMulti()]; 120b36f8833SAndreas Gohr } 121b36f8833SAndreas Gohr } 122b36f8833SAndreas Gohr return $result; 123b36f8833SAndreas Gohr } catch (StructException $e) { 1247234bfb1Ssplitbrain throw new \dokuwiki\Remote\RemoteException($e->getMessage(), 0, $e); 125b36f8833SAndreas Gohr } 126b36f8833SAndreas Gohr } 127935a9fa3SMichael Große 128935a9fa3SMichael Große /** 129935a9fa3SMichael Große * Get the data that would be shown in an aggregation 130935a9fa3SMichael Große * 131935a9fa3SMichael Große * @param array $schemas array of strings with the schema-names 132935a9fa3SMichael Große * @param array $cols array of strings with the columns 133935a9fa3SMichael Große * @param array $filter array of arrays with ['logic'=> 'and'|'or', 'condition' => 'your condition'] 134935a9fa3SMichael Große * @param string $sort string indicating the column to sort by 135935a9fa3SMichael Große * 136935a9fa3SMichael Große * @return array array of rows, each row is an array of the column values 137935a9fa3SMichael Große * @throws RemoteException 138935a9fa3SMichael Große */ 139d6d97f60SAnna Dabrowska public function getAggregationData(array $schemas, array $cols, array $filter = [], $sort = '') 140d6d97f60SAnna Dabrowska { 141935a9fa3SMichael Große $schemaLine = 'schema: ' . implode(', ', $schemas); 142935a9fa3SMichael Große $columnLine = 'cols: ' . implode(', ', $cols); 143935a9fa3SMichael Große $filterLines = array_map(function ($filter) { 144935a9fa3SMichael Große return 'filter' . $filter['logic'] . ': ' . $filter['condition']; 145935a9fa3SMichael Große }, $filter); 146935a9fa3SMichael Große $sortLine = 'sort: ' . $sort; 147935a9fa3SMichael Große // schemas, cols, REV?, filter, order 148935a9fa3SMichael Große 149935a9fa3SMichael Große try { 150935a9fa3SMichael Große $parser = new ConfigParser(array_merge([$schemaLine, $columnLine, $sortLine], $filterLines)); 151935a9fa3SMichael Große $config = $parser->getConfig(); 152935a9fa3SMichael Große $search = new SearchConfig($config); 153935a9fa3SMichael Große $results = $search->execute(); 154935a9fa3SMichael Große $data = []; 1557234bfb1Ssplitbrain /** @var Value[] $rowValues */ 156935a9fa3SMichael Große foreach ($results as $rowValues) { 157935a9fa3SMichael Große $row = []; 158935a9fa3SMichael Große foreach ($rowValues as $value) { 159935a9fa3SMichael Große $row[$value->getColumn()->getFullQualifiedLabel()] = $value->getDisplayValue(); 160935a9fa3SMichael Große } 161935a9fa3SMichael Große $data[] = $row; 162935a9fa3SMichael Große } 163935a9fa3SMichael Große return $data; 164935a9fa3SMichael Große } catch (StructException $e) { 1657234bfb1Ssplitbrain throw new \dokuwiki\Remote\RemoteException($e->getMessage(), 0, $e); 166935a9fa3SMichael Große } 167935a9fa3SMichael Große } 168b36f8833SAndreas Gohr} 169