xref: /plugin/struct/meta/ConfigParser.php (revision ea5ad12ac615a67b2c935ce7472ece1c00189ba7)
15511bd5bSAndreas Gohr<?php
25511bd5bSAndreas Gohr
3ba766201SAndreas Gohrnamespace dokuwiki\plugin\struct\meta;
45511bd5bSAndreas Gohr
55511bd5bSAndreas Gohr/**
65511bd5bSAndreas Gohr * Class ConfigParser
75511bd5bSAndreas Gohr *
85511bd5bSAndreas Gohr * Utilities to parse the configuration syntax into an array
95511bd5bSAndreas Gohr *
10ba766201SAndreas Gohr * @package dokuwiki\plugin\struct\meta
115511bd5bSAndreas Gohr */
125511bd5bSAndreas Gohrclass ConfigParser {
135511bd5bSAndreas Gohr
145511bd5bSAndreas Gohr    protected $config = array();
155511bd5bSAndreas Gohr
165511bd5bSAndreas Gohr    /**
175511bd5bSAndreas Gohr     * Parser constructor.
185511bd5bSAndreas Gohr     *
195511bd5bSAndreas Gohr     * parses the given configuration lines
205511bd5bSAndreas Gohr     *
215511bd5bSAndreas Gohr     * @param $lines
225511bd5bSAndreas Gohr     */
235511bd5bSAndreas Gohr    public function __construct($lines) {
2429877279SMichael Große        /** @var \helper_plugin_struct_config $helper */
2529877279SMichael Große        $helper = plugin_load('helper', 'struct_config');
26d930c197SMichael Große        $this->config = array(
275511bd5bSAndreas Gohr            'limit' => 0,
285511bd5bSAndreas Gohr            'dynfilters' => false,
295511bd5bSAndreas Gohr            'summarize' => false,
305511bd5bSAndreas Gohr            'rownumbers' => false,
315511bd5bSAndreas Gohr            'sepbyheaders' => false,
325511bd5bSAndreas Gohr            'headers' => array(),
335511bd5bSAndreas Gohr            'widths' => array(),
345511bd5bSAndreas Gohr            'filter' => array(),
357051cfa1SMichael Große            'schemas' => array(),
367b240ca8SAndreas Gohr            'sort' => array(),
377b240ca8SAndreas Gohr            'csv' => true,
385511bd5bSAndreas Gohr        );
395511bd5bSAndreas Gohr        // parse info
405511bd5bSAndreas Gohr        foreach($lines as $line) {
415511bd5bSAndreas Gohr            list($key, $val) = $this->splitLine($line);
425511bd5bSAndreas Gohr            if(!$key) continue;
435511bd5bSAndreas Gohr
445511bd5bSAndreas Gohr            $logic = 'OR';
455511bd5bSAndreas Gohr            // handle line commands (we allow various aliases here)
465511bd5bSAndreas Gohr            switch($key) {
475511bd5bSAndreas Gohr                case 'from':
485511bd5bSAndreas Gohr                case 'schema':
495511bd5bSAndreas Gohr                case 'tables':
505511bd5bSAndreas Gohr                    $this->config['schemas'] = array_merge($this->config['schemas'], $this->parseSchema($val));
515511bd5bSAndreas Gohr                    break;
525511bd5bSAndreas Gohr                case 'select':
535511bd5bSAndreas Gohr                case 'cols':
545511bd5bSAndreas Gohr                case 'field':
555511bd5bSAndreas Gohr                case 'col':
565511bd5bSAndreas Gohr                    $this->config['cols'] = $this->parseValues($val);
575511bd5bSAndreas Gohr                    break;
58*ea5ad12aSMichael Grosse                case 'sepbyheaders':
59*ea5ad12aSMichael Grosse                    $this->config['sepbyheaders'] = (bool) $val;
60*ea5ad12aSMichael Grosse                    break;
615511bd5bSAndreas Gohr                case 'head':
625511bd5bSAndreas Gohr                case 'header':
635511bd5bSAndreas Gohr                case 'headers':
645511bd5bSAndreas Gohr                    $this->config['headers'] = $this->parseValues($val);
655511bd5bSAndreas Gohr                    break;
665511bd5bSAndreas Gohr                case 'align':
675511bd5bSAndreas Gohr                    $this->config['align'] = $this->parseAlignments($val);
685511bd5bSAndreas Gohr                    break;
69e0216289SAndreas Gohr                case 'width':
705511bd5bSAndreas Gohr                case 'widths':
71e0216289SAndreas Gohr                    $this->config['widths'] = $this->parseWidths($val);
725511bd5bSAndreas Gohr                    break;
735511bd5bSAndreas Gohr                case 'min':
745511bd5bSAndreas Gohr                    $this->config['min'] = abs((int) $val);
755511bd5bSAndreas Gohr                    break;
765511bd5bSAndreas Gohr                case 'limit':
775511bd5bSAndreas Gohr                case 'max':
785511bd5bSAndreas Gohr                    $this->config['limit'] = abs((int) $val);
795511bd5bSAndreas Gohr                    break;
805511bd5bSAndreas Gohr                case 'order':
815511bd5bSAndreas Gohr                case 'sort':
826047d2b8SAndreas Gohr                    $sorts = $this->parseValues($val);
836047d2b8SAndreas Gohr                    $sorts = array_map(array($helper, 'parseSort'), $sorts);
846047d2b8SAndreas Gohr                    $this->config['sort'] = array_merge($this->config['sort'], $sorts);
855511bd5bSAndreas Gohr                    break;
865511bd5bSAndreas Gohr                case 'where':
875511bd5bSAndreas Gohr                case 'filter':
885511bd5bSAndreas Gohr                case 'filterand':
895511bd5bSAndreas Gohr                    /** @noinspection PhpMissingBreakStatementInspection */
905511bd5bSAndreas Gohr                case 'and':
915511bd5bSAndreas Gohr                    $logic = 'AND';
925511bd5bSAndreas Gohr                case 'filteror':
935511bd5bSAndreas Gohr                case 'or':
9429877279SMichael Große                    $flt = $helper->parseFilterLine($logic, $val);
955511bd5bSAndreas Gohr                    if($flt) {
965511bd5bSAndreas Gohr                        $this->config['filter'][] = $flt;
975511bd5bSAndreas Gohr                    }
985511bd5bSAndreas Gohr                    break;
995511bd5bSAndreas Gohr                case 'dynfilters':
1005511bd5bSAndreas Gohr                    $this->config['dynfilters'] = (bool) $val;
1015511bd5bSAndreas Gohr                    break;
1025511bd5bSAndreas Gohr                case 'rownumbers':
1035511bd5bSAndreas Gohr                    $this->config['rownumbers'] = (bool) $val;
1045511bd5bSAndreas Gohr                    break;
1055511bd5bSAndreas Gohr                case 'summarize':
1065511bd5bSAndreas Gohr                    $this->config['summarize'] = (bool) $val;
1075511bd5bSAndreas Gohr                    break;
1087b240ca8SAndreas Gohr                case 'csv':
1097b240ca8SAndreas Gohr                    $this->config['csv'] = (bool) $val;
1107b240ca8SAndreas Gohr                    break;
1115511bd5bSAndreas Gohr                default:
1127d88e7edSAndreas Gohr                    throw new StructException("unknown option '%s'", hsc($key));
1135511bd5bSAndreas Gohr            }
1145511bd5bSAndreas Gohr        }
11501dd90deSAndreas Gohr
11601dd90deSAndreas Gohr        // fill up headers - a NULL signifies that the column label is wanted
1175511bd5bSAndreas Gohr        $this->config['headers'] = (array) $this->config['headers'];
1185511bd5bSAndreas Gohr        $cnth = count($this->config['headers']);
1195511bd5bSAndreas Gohr        $cntf = count($this->config['cols']);
1205511bd5bSAndreas Gohr        for($i = $cnth; $i < $cntf; $i++) {
12101dd90deSAndreas Gohr            $this->config['headers'][] = null;
1225511bd5bSAndreas Gohr        }
1235511bd5bSAndreas Gohr    }
1245511bd5bSAndreas Gohr
1255511bd5bSAndreas Gohr    /**
1265511bd5bSAndreas Gohr     * Get the parsed configuration
1275511bd5bSAndreas Gohr     *
1285511bd5bSAndreas Gohr     * @return array
1295511bd5bSAndreas Gohr     */
1305511bd5bSAndreas Gohr    public function getConfig() {
1315511bd5bSAndreas Gohr        return $this->config;
1325511bd5bSAndreas Gohr    }
1335511bd5bSAndreas Gohr
1345511bd5bSAndreas Gohr    /**
1355511bd5bSAndreas Gohr     * Splits the given line into key and value
1365511bd5bSAndreas Gohr     *
1375511bd5bSAndreas Gohr     * @param $line
1385511bd5bSAndreas Gohr     * @return bool|array returns false for empty lines
1395511bd5bSAndreas Gohr     */
1405511bd5bSAndreas Gohr    protected function splitLine($line) {
1415511bd5bSAndreas Gohr        // ignore comments
1425511bd5bSAndreas Gohr        $line = preg_replace('/(?<![&\\\\])#.*$/', '', $line);
1435511bd5bSAndreas Gohr        $line = str_replace('\\#', '#', $line);
1445511bd5bSAndreas Gohr        $line = trim($line);
1455511bd5bSAndreas Gohr        if(empty($line)) return false;
1465511bd5bSAndreas Gohr
1475511bd5bSAndreas Gohr        $line = preg_split('/\s*:\s*/', $line, 2);
1485511bd5bSAndreas Gohr        $line[0] = strtolower($line[0]);
1495511bd5bSAndreas Gohr
1505511bd5bSAndreas Gohr        return $line;
1515511bd5bSAndreas Gohr    }
1525511bd5bSAndreas Gohr
1535511bd5bSAndreas Gohr    /**
1545511bd5bSAndreas Gohr     * parses schema config and aliases
1555511bd5bSAndreas Gohr     *
1565511bd5bSAndreas Gohr     * @param $val
1575511bd5bSAndreas Gohr     * @return array
1585511bd5bSAndreas Gohr     */
1595511bd5bSAndreas Gohr    protected function parseSchema($val) {
1605511bd5bSAndreas Gohr        $schemas = array();
1615511bd5bSAndreas Gohr        $parts = explode(',', $val);
1625511bd5bSAndreas Gohr        foreach($parts as $part) {
1634e7c197cSAndreas Gohr            list($table, $alias) = explode(' ', trim($part));
1645511bd5bSAndreas Gohr            $table = trim($table);
1655511bd5bSAndreas Gohr            $alias = trim($alias);
1665511bd5bSAndreas Gohr            if(!$table) continue;
1675511bd5bSAndreas Gohr
16829877279SMichael Große            $schemas[] = array($table, $alias,);
1695511bd5bSAndreas Gohr        }
1705511bd5bSAndreas Gohr        return $schemas;
1715511bd5bSAndreas Gohr    }
1725511bd5bSAndreas Gohr
1735511bd5bSAndreas Gohr    /**
1745511bd5bSAndreas Gohr     * Parse alignment data
1755511bd5bSAndreas Gohr     *
1765511bd5bSAndreas Gohr     * @param string $val
1775511bd5bSAndreas Gohr     * @return string[]
1785511bd5bSAndreas Gohr     */
1795511bd5bSAndreas Gohr    protected function parseAlignments($val) {
1805511bd5bSAndreas Gohr        $cols = explode(',', $val);
1815511bd5bSAndreas Gohr        $data = array();
1825511bd5bSAndreas Gohr        foreach($cols as $col) {
1835511bd5bSAndreas Gohr            $col = trim(strtolower($col));
1845511bd5bSAndreas Gohr            if($col[0] == 'c') {
1855511bd5bSAndreas Gohr                $align = 'center';
1865511bd5bSAndreas Gohr            } elseif($col[0] == 'r') {
1875511bd5bSAndreas Gohr                $align = 'right';
1885511bd5bSAndreas Gohr            } else {
1895511bd5bSAndreas Gohr                $align = 'left';
1905511bd5bSAndreas Gohr            }
1915511bd5bSAndreas Gohr            $data[] = $align;
1925511bd5bSAndreas Gohr        }
1935511bd5bSAndreas Gohr
1945511bd5bSAndreas Gohr        return $data;
1955511bd5bSAndreas Gohr    }
1965511bd5bSAndreas Gohr
1975511bd5bSAndreas Gohr    /**
198e0216289SAndreas Gohr     * Parse width data
199e0216289SAndreas Gohr     *
200e0216289SAndreas Gohr     * @param $val
201e0216289SAndreas Gohr     * @return array
202e0216289SAndreas Gohr     */
203e0216289SAndreas Gohr    protected function parseWidths($val) {
204e0216289SAndreas Gohr        $vals = explode(',', $val);
205e0216289SAndreas Gohr        $vals = array_map('trim', $vals);
206e0216289SAndreas Gohr        $len = count($vals);
207e0216289SAndreas Gohr        for($i = 0; $i < $len; $i++) {
208e0216289SAndreas Gohr            $val = trim(strtolower($vals[$i]));
209e0216289SAndreas Gohr
210e0216289SAndreas Gohr            if(preg_match('/^\d+.?(\d+)?(px|em|ex|ch|rem|%|in|cm|mm|q|pt|pc)$/', $val)) {
211e0216289SAndreas Gohr                // proper CSS unit?
212e0216289SAndreas Gohr                $vals[$i] = $val;
213e0216289SAndreas Gohr            } else if(preg_match('/^\d+$/', $val)) {
214e0216289SAndreas Gohr                // decimal only?
215e0216289SAndreas Gohr                $vals[$i] = $val . 'px';
216e0216289SAndreas Gohr            } else {
217e0216289SAndreas Gohr                // invalid
218e0216289SAndreas Gohr                $vals[$i] = '';
219e0216289SAndreas Gohr            }
220e0216289SAndreas Gohr        }
221e0216289SAndreas Gohr        return $vals;
222e0216289SAndreas Gohr    }
223e0216289SAndreas Gohr
224e0216289SAndreas Gohr    /**
2255511bd5bSAndreas Gohr     * Split values at the commas,
2265511bd5bSAndreas Gohr     * - Wrap with quotes to escape comma, quotes escaped by two quotes
2275511bd5bSAndreas Gohr     * - Within quotes spaces are stored.
2285511bd5bSAndreas Gohr     *
2295511bd5bSAndreas Gohr     * @param string $line
2305511bd5bSAndreas Gohr     * @return array
2315511bd5bSAndreas Gohr     */
2325511bd5bSAndreas Gohr    protected function parseValues($line) {
2335511bd5bSAndreas Gohr        $values = array();
2345511bd5bSAndreas Gohr        $inQuote = false;
2355511bd5bSAndreas Gohr        $escapedQuote = false;
2365511bd5bSAndreas Gohr        $value = '';
2375511bd5bSAndreas Gohr        $len = strlen($line);
2385511bd5bSAndreas Gohr        for($i = 0; $i < $len; $i++) {
2395511bd5bSAndreas Gohr            if($line{$i} == '"') {
2405511bd5bSAndreas Gohr                if($inQuote) {
2415511bd5bSAndreas Gohr                    if($escapedQuote) {
2425511bd5bSAndreas Gohr                        $value .= '"';
2435511bd5bSAndreas Gohr                        $escapedQuote = false;
2445511bd5bSAndreas Gohr                        continue;
2455511bd5bSAndreas Gohr                    }
2465511bd5bSAndreas Gohr                    if($line{$i + 1} == '"') {
2475511bd5bSAndreas Gohr                        $escapedQuote = true;
2485511bd5bSAndreas Gohr                        continue;
2495511bd5bSAndreas Gohr                    }
2505511bd5bSAndreas Gohr                    array_push($values, $value);
2515511bd5bSAndreas Gohr                    $inQuote = false;
2525511bd5bSAndreas Gohr                    $value = '';
2535511bd5bSAndreas Gohr                    continue;
2545511bd5bSAndreas Gohr                } else {
2555511bd5bSAndreas Gohr                    $inQuote = true;
2565511bd5bSAndreas Gohr                    $value = ''; //don't store stuff before the opening quote
2575511bd5bSAndreas Gohr                    continue;
2585511bd5bSAndreas Gohr                }
2595511bd5bSAndreas Gohr            } else if($line{$i} == ',') {
2605511bd5bSAndreas Gohr                if($inQuote) {
2615511bd5bSAndreas Gohr                    $value .= ',';
2625511bd5bSAndreas Gohr                    continue;
2635511bd5bSAndreas Gohr                } else {
2645511bd5bSAndreas Gohr                    if(strlen($value) < 1) {
2655511bd5bSAndreas Gohr                        continue;
2665511bd5bSAndreas Gohr                    }
2675511bd5bSAndreas Gohr                    array_push($values, trim($value));
2685511bd5bSAndreas Gohr                    $value = '';
2695511bd5bSAndreas Gohr                    continue;
2705511bd5bSAndreas Gohr                }
2715511bd5bSAndreas Gohr            }
2725511bd5bSAndreas Gohr            $value .= $line{$i};
2735511bd5bSAndreas Gohr        }
2745511bd5bSAndreas Gohr        if(strlen($value) > 0) {
2755511bd5bSAndreas Gohr            array_push($values, trim($value));
2765511bd5bSAndreas Gohr        }
2775511bd5bSAndreas Gohr        return $values;
2785511bd5bSAndreas Gohr    }
2795511bd5bSAndreas Gohr
2805511bd5bSAndreas Gohr}
281