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 */ 12d6d97f60SAnna Dabrowskaclass ConfigParser 13d6d97f60SAnna Dabrowska{ 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 */ 23d6d97f60SAnna Dabrowska public function __construct($lines) 24d6d97f60SAnna Dabrowska { 2529877279SMichael Große /** @var \helper_plugin_struct_config $helper */ 2629877279SMichael Große $helper = plugin_load('helper', 'struct_config'); 27d930c197SMichael Große $this->config = array( 285511bd5bSAndreas Gohr 'limit' => 0, 295511bd5bSAndreas Gohr 'dynfilters' => false, 305511bd5bSAndreas Gohr 'summarize' => false, 315511bd5bSAndreas Gohr 'rownumbers' => false, 325511bd5bSAndreas Gohr 'sepbyheaders' => false, 3385edf4f2SMichael Grosse 'target' => '', 349cda5805SAndreas Gohr 'align' => array(), 355511bd5bSAndreas Gohr 'headers' => array(), 36d93ddfc7SSzymon Olewniczak 'cols' => array(), 375511bd5bSAndreas Gohr 'widths' => array(), 385511bd5bSAndreas Gohr 'filter' => array(), 397051cfa1SMichael Große 'schemas' => array(), 407b240ca8SAndreas Gohr 'sort' => array(), 417b240ca8SAndreas Gohr 'csv' => true, 42*5bc00e11SAndreas Gohr 'nesting' => 0, 435511bd5bSAndreas Gohr ); 445511bd5bSAndreas Gohr // parse info 455511bd5bSAndreas Gohr foreach ($lines as $line) { 4642d332d7SAndreas Gohr list($key, $val) = $this->splitLine($line); 475511bd5bSAndreas Gohr if (!$key) continue; 485511bd5bSAndreas Gohr 495511bd5bSAndreas Gohr $logic = 'OR'; 505511bd5bSAndreas Gohr // handle line commands (we allow various aliases here) 515511bd5bSAndreas Gohr switch ($key) { 525511bd5bSAndreas Gohr case 'from': 535511bd5bSAndreas Gohr case 'schema': 545511bd5bSAndreas Gohr case 'tables': 555511bd5bSAndreas Gohr $this->config['schemas'] = array_merge($this->config['schemas'], $this->parseSchema($val)); 565511bd5bSAndreas Gohr break; 575511bd5bSAndreas Gohr case 'select': 585511bd5bSAndreas Gohr case 'cols': 595511bd5bSAndreas Gohr case 'field': 605511bd5bSAndreas Gohr case 'col': 615511bd5bSAndreas Gohr $this->config['cols'] = $this->parseValues($val); 625511bd5bSAndreas Gohr break; 63ea5ad12aSMichael Grosse case 'sepbyheaders': 64ea5ad12aSMichael Grosse $this->config['sepbyheaders'] = (bool)$val; 65ea5ad12aSMichael Grosse break; 665511bd5bSAndreas Gohr case 'head': 675511bd5bSAndreas Gohr case 'header': 685511bd5bSAndreas Gohr case 'headers': 695511bd5bSAndreas Gohr $this->config['headers'] = $this->parseValues($val); 705511bd5bSAndreas Gohr break; 715511bd5bSAndreas Gohr case 'align': 725511bd5bSAndreas Gohr $this->config['align'] = $this->parseAlignments($val); 735511bd5bSAndreas Gohr break; 74e0216289SAndreas Gohr case 'width': 755511bd5bSAndreas Gohr case 'widths': 76e0216289SAndreas Gohr $this->config['widths'] = $this->parseWidths($val); 775511bd5bSAndreas Gohr break; 785511bd5bSAndreas Gohr case 'min': 795511bd5bSAndreas Gohr $this->config['min'] = abs((int)$val); 805511bd5bSAndreas Gohr break; 815511bd5bSAndreas Gohr case 'limit': 825511bd5bSAndreas Gohr case 'max': 835511bd5bSAndreas Gohr $this->config['limit'] = abs((int)$val); 845511bd5bSAndreas Gohr break; 855511bd5bSAndreas Gohr case 'order': 865511bd5bSAndreas Gohr case 'sort': 876047d2b8SAndreas Gohr $sorts = $this->parseValues($val); 886047d2b8SAndreas Gohr $sorts = array_map(array($helper, 'parseSort'), $sorts); 896047d2b8SAndreas Gohr $this->config['sort'] = array_merge($this->config['sort'], $sorts); 905511bd5bSAndreas Gohr break; 915511bd5bSAndreas Gohr case 'where': 925511bd5bSAndreas Gohr case 'filter': 93748e747fSAnna Dabrowska case 'filterand': // phpcs:ignore PSR2.ControlStructures.SwitchDeclaration.TerminatingComment 945511bd5bSAndreas Gohr /** @noinspection PhpMissingBreakStatementInspection */ 95748e747fSAnna Dabrowska case 'and': // phpcs:ignore PSR2.ControlStructures.SwitchDeclaration.TerminatingComment 965511bd5bSAndreas Gohr $logic = 'AND'; 975511bd5bSAndreas Gohr case 'filteror': 985511bd5bSAndreas Gohr case 'or': 9929877279SMichael Große $flt = $helper->parseFilterLine($logic, $val); 1005511bd5bSAndreas Gohr if ($flt) { 1015511bd5bSAndreas Gohr $this->config['filter'][] = $flt; 1025511bd5bSAndreas Gohr } 1035511bd5bSAndreas Gohr break; 1045511bd5bSAndreas Gohr case 'dynfilters': 1055511bd5bSAndreas Gohr $this->config['dynfilters'] = (bool)$val; 1065511bd5bSAndreas Gohr break; 1075511bd5bSAndreas Gohr case 'rownumbers': 1085511bd5bSAndreas Gohr $this->config['rownumbers'] = (bool)$val; 1095511bd5bSAndreas Gohr break; 1105511bd5bSAndreas Gohr case 'summarize': 1115511bd5bSAndreas Gohr $this->config['summarize'] = (bool)$val; 1125511bd5bSAndreas Gohr break; 1137b240ca8SAndreas Gohr case 'csv': 1147b240ca8SAndreas Gohr $this->config['csv'] = (bool)$val; 1157b240ca8SAndreas Gohr break; 11685edf4f2SMichael Grosse case 'target': 11785edf4f2SMichael Grosse case 'page': 11885edf4f2SMichael Grosse $this->config['target'] = cleanID($val); 11985edf4f2SMichael Grosse break; 120*5bc00e11SAndreas Gohr case 'nesting': 121*5bc00e11SAndreas Gohr case 'nest': 122*5bc00e11SAndreas Gohr $this->config['nesting'] = (int) $val; 123*5bc00e11SAndreas Gohr break; 1245511bd5bSAndreas Gohr default: 12529a2b794SAndreas Gohr $data = array('config' => &$this->config, 'key' => $key, 'val' => $val); 12629a2b794SAndreas Gohr $ev = new \Doku_Event('PLUGIN_STRUCT_CONFIGPARSER_UNKNOWNKEY', $data); 12729a2b794SAndreas Gohr if ($ev->advise_before()) { 1287d88e7edSAndreas Gohr throw new StructException("unknown option '%s'", hsc($key)); 1295511bd5bSAndreas Gohr } 13029a2b794SAndreas Gohr $ev->advise_after(); 13129a2b794SAndreas Gohr } 1325511bd5bSAndreas Gohr } 13301dd90deSAndreas Gohr 13401dd90deSAndreas Gohr // fill up headers - a NULL signifies that the column label is wanted 1355511bd5bSAndreas Gohr $this->config['headers'] = (array)$this->config['headers']; 1365511bd5bSAndreas Gohr $cnth = count($this->config['headers']); 1375511bd5bSAndreas Gohr $cntf = count($this->config['cols']); 1385511bd5bSAndreas Gohr for ($i = $cnth; $i < $cntf; $i++) { 13901dd90deSAndreas Gohr $this->config['headers'][] = null; 1405511bd5bSAndreas Gohr } 14195eef580SAndreas Gohr // fill up alignments 14295eef580SAndreas Gohr $cnta = count($this->config['align']); 14395eef580SAndreas Gohr for ($i = $cnta; $i < $cntf; $i++) { 14495eef580SAndreas Gohr $this->config['align'][] = null; 14595eef580SAndreas Gohr } 1465511bd5bSAndreas Gohr } 1475511bd5bSAndreas Gohr 1485511bd5bSAndreas Gohr /** 1495511bd5bSAndreas Gohr * Get the parsed configuration 1505511bd5bSAndreas Gohr * 1515511bd5bSAndreas Gohr * @return array 1525511bd5bSAndreas Gohr */ 153d6d97f60SAnna Dabrowska public function getConfig() 154d6d97f60SAnna Dabrowska { 1555511bd5bSAndreas Gohr return $this->config; 1565511bd5bSAndreas Gohr } 1575511bd5bSAndreas Gohr 1585511bd5bSAndreas Gohr /** 1595511bd5bSAndreas Gohr * Splits the given line into key and value 1605511bd5bSAndreas Gohr * 1615511bd5bSAndreas Gohr * @param $line 16242d332d7SAndreas Gohr * @return array returns ['',''] if the line is empty 1635511bd5bSAndreas Gohr */ 164d6d97f60SAnna Dabrowska protected function splitLine($line) 165d6d97f60SAnna Dabrowska { 1665511bd5bSAndreas Gohr // ignore comments 1675511bd5bSAndreas Gohr $line = preg_replace('/(?<![&\\\\])#.*$/', '', $line); 1685511bd5bSAndreas Gohr $line = str_replace('\\#', '#', $line); 1695511bd5bSAndreas Gohr $line = trim($line); 17042d332d7SAndreas Gohr if (empty($line)) return ['', '']; 1715511bd5bSAndreas Gohr 1725511bd5bSAndreas Gohr $line = preg_split('/\s*:\s*/', $line, 2); 1735511bd5bSAndreas Gohr $line[0] = strtolower($line[0]); 17442d332d7SAndreas Gohr if (!isset($line[1])) $line[1] = ''; 1755511bd5bSAndreas Gohr 1765511bd5bSAndreas Gohr return $line; 1775511bd5bSAndreas Gohr } 1785511bd5bSAndreas Gohr 1795511bd5bSAndreas Gohr /** 1805511bd5bSAndreas Gohr * parses schema config and aliases 1815511bd5bSAndreas Gohr * 1825511bd5bSAndreas Gohr * @param $val 1835511bd5bSAndreas Gohr * @return array 1845511bd5bSAndreas Gohr */ 185d6d97f60SAnna Dabrowska protected function parseSchema($val) 186d6d97f60SAnna Dabrowska { 1875511bd5bSAndreas Gohr $schemas = array(); 1885511bd5bSAndreas Gohr $parts = explode(',', $val); 1895511bd5bSAndreas Gohr foreach ($parts as $part) { 19025ed0c0dSAndreas Gohr @list($table, $alias) = array_pad(explode(' ', trim($part)), 2, ''); 1915511bd5bSAndreas Gohr $table = trim($table); 1925511bd5bSAndreas Gohr $alias = trim($alias); 1935511bd5bSAndreas Gohr if (!$table) continue; 1945511bd5bSAndreas Gohr 19529877279SMichael Große $schemas[] = array($table, $alias,); 1965511bd5bSAndreas Gohr } 1975511bd5bSAndreas Gohr return $schemas; 1985511bd5bSAndreas Gohr } 1995511bd5bSAndreas Gohr 2005511bd5bSAndreas Gohr /** 2015511bd5bSAndreas Gohr * Parse alignment data 2025511bd5bSAndreas Gohr * 2035511bd5bSAndreas Gohr * @param string $val 2045511bd5bSAndreas Gohr * @return string[] 2055511bd5bSAndreas Gohr */ 206d6d97f60SAnna Dabrowska protected function parseAlignments($val) 207d6d97f60SAnna Dabrowska { 2085511bd5bSAndreas Gohr $cols = explode(',', $val); 2095511bd5bSAndreas Gohr $data = array(); 2105511bd5bSAndreas Gohr foreach ($cols as $col) { 2115511bd5bSAndreas Gohr $col = trim(strtolower($col)); 2125511bd5bSAndreas Gohr if ($col[0] == 'c') { 2135511bd5bSAndreas Gohr $align = 'center'; 2145511bd5bSAndreas Gohr } elseif ($col[0] == 'r') { 2155511bd5bSAndreas Gohr $align = 'right'; 2169cda5805SAndreas Gohr } elseif ($col[0] == 'l') { 2175511bd5bSAndreas Gohr $align = 'left'; 2189cda5805SAndreas Gohr } else { 2199cda5805SAndreas Gohr $align = null; 2205511bd5bSAndreas Gohr } 2215511bd5bSAndreas Gohr $data[] = $align; 2225511bd5bSAndreas Gohr } 2235511bd5bSAndreas Gohr 2245511bd5bSAndreas Gohr return $data; 2255511bd5bSAndreas Gohr } 2265511bd5bSAndreas Gohr 2275511bd5bSAndreas Gohr /** 228e0216289SAndreas Gohr * Parse width data 229e0216289SAndreas Gohr * 230e0216289SAndreas Gohr * @param $val 231e0216289SAndreas Gohr * @return array 232e0216289SAndreas Gohr */ 233d6d97f60SAnna Dabrowska protected function parseWidths($val) 234d6d97f60SAnna Dabrowska { 235e0216289SAndreas Gohr $vals = explode(',', $val); 236e0216289SAndreas Gohr $vals = array_map('trim', $vals); 237e0216289SAndreas Gohr $len = count($vals); 238e0216289SAndreas Gohr for ($i = 0; $i < $len; $i++) { 239e0216289SAndreas Gohr $val = trim(strtolower($vals[$i])); 240e0216289SAndreas Gohr 241e0216289SAndreas Gohr if (preg_match('/^\d+.?(\d+)?(px|em|ex|ch|rem|%|in|cm|mm|q|pt|pc)$/', $val)) { 242e0216289SAndreas Gohr // proper CSS unit? 243e0216289SAndreas Gohr $vals[$i] = $val; 244e0216289SAndreas Gohr } elseif (preg_match('/^\d+$/', $val)) { 245e0216289SAndreas Gohr // decimal only? 246e0216289SAndreas Gohr $vals[$i] = $val . 'px'; 247e0216289SAndreas Gohr } else { 248e0216289SAndreas Gohr // invalid 249e0216289SAndreas Gohr $vals[$i] = ''; 250e0216289SAndreas Gohr } 251e0216289SAndreas Gohr } 252e0216289SAndreas Gohr return $vals; 253e0216289SAndreas Gohr } 254e0216289SAndreas Gohr 255e0216289SAndreas Gohr /** 2565511bd5bSAndreas Gohr * Split values at the commas, 2575511bd5bSAndreas Gohr * - Wrap with quotes to escape comma, quotes escaped by two quotes 2585511bd5bSAndreas Gohr * - Within quotes spaces are stored. 2595511bd5bSAndreas Gohr * 2605511bd5bSAndreas Gohr * @param string $line 2615511bd5bSAndreas Gohr * @return array 2625511bd5bSAndreas Gohr */ 263d6d97f60SAnna Dabrowska protected function parseValues($line) 264d6d97f60SAnna Dabrowska { 2655511bd5bSAndreas Gohr $values = array(); 2665511bd5bSAndreas Gohr $inQuote = false; 2675511bd5bSAndreas Gohr $escapedQuote = false; 2685511bd5bSAndreas Gohr $value = ''; 2695511bd5bSAndreas Gohr $len = strlen($line); 2705511bd5bSAndreas Gohr for ($i = 0; $i < $len; $i++) { 271d982cb29SMichael Große if ($line[$i] == '"') { 2725511bd5bSAndreas Gohr if ($inQuote) { 2735511bd5bSAndreas Gohr if ($escapedQuote) { 2745511bd5bSAndreas Gohr $value .= '"'; 2755511bd5bSAndreas Gohr $escapedQuote = false; 2765511bd5bSAndreas Gohr continue; 2775511bd5bSAndreas Gohr } 278d982cb29SMichael Große if ($line[$i + 1] == '"') { 2795511bd5bSAndreas Gohr $escapedQuote = true; 2805511bd5bSAndreas Gohr continue; 2815511bd5bSAndreas Gohr } 2825511bd5bSAndreas Gohr array_push($values, $value); 2835511bd5bSAndreas Gohr $inQuote = false; 2845511bd5bSAndreas Gohr $value = ''; 2855511bd5bSAndreas Gohr continue; 2865511bd5bSAndreas Gohr } else { 2875511bd5bSAndreas Gohr $inQuote = true; 2885511bd5bSAndreas Gohr $value = ''; //don't store stuff before the opening quote 2895511bd5bSAndreas Gohr continue; 2905511bd5bSAndreas Gohr } 291d982cb29SMichael Große } elseif ($line[$i] == ',') { 2925511bd5bSAndreas Gohr if ($inQuote) { 2935511bd5bSAndreas Gohr $value .= ','; 2945511bd5bSAndreas Gohr continue; 2955511bd5bSAndreas Gohr } else { 2965511bd5bSAndreas Gohr if (strlen($value) < 1) { 2975511bd5bSAndreas Gohr continue; 2985511bd5bSAndreas Gohr } 2995511bd5bSAndreas Gohr array_push($values, trim($value)); 3005511bd5bSAndreas Gohr $value = ''; 3015511bd5bSAndreas Gohr continue; 3025511bd5bSAndreas Gohr } 3035511bd5bSAndreas Gohr } 304d982cb29SMichael Große $value .= $line[$i]; 3055511bd5bSAndreas Gohr } 3065511bd5bSAndreas Gohr if (strlen($value) > 0) { 3075511bd5bSAndreas Gohr array_push($values, trim($value)); 3085511bd5bSAndreas Gohr } 3095511bd5bSAndreas Gohr return $values; 3105511bd5bSAndreas Gohr } 3115511bd5bSAndreas Gohr} 312