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