107993756SAndreas Gohr<?php 207993756SAndreas Gohr 307993756SAndreas Gohrnamespace plugin\struct\meta; 407993756SAndreas Gohr 5d60f71efSAndreas Gohr/** 6d60f71efSAndreas Gohr * Creates the table aggregation output 7d60f71efSAndreas Gohr * 8d60f71efSAndreas Gohr * @package plugin\struct\meta 9d60f71efSAndreas Gohr */ 1007993756SAndreas Gohrclass AggregationTable { 1107993756SAndreas Gohr 1207993756SAndreas Gohr /** 1307993756SAndreas Gohr * @var string the page id of the page this is rendered to 1407993756SAndreas Gohr */ 1507993756SAndreas Gohr protected $id; 1607993756SAndreas Gohr /** 1707993756SAndreas Gohr * @var string the Type of renderer used 1807993756SAndreas Gohr */ 1907993756SAndreas Gohr protected $mode; 2007993756SAndreas Gohr /** 2107993756SAndreas Gohr * @var \Doku_Renderer the DokuWiki renderer used to create the output 2207993756SAndreas Gohr */ 2307993756SAndreas Gohr protected $renderer; 2407993756SAndreas Gohr /** 2507993756SAndreas Gohr * @var SearchConfig the configured search - gives access to columns etc. 2607993756SAndreas Gohr */ 2707993756SAndreas Gohr protected $searchConfig; 2807993756SAndreas Gohr 2907993756SAndreas Gohr /** 3007993756SAndreas Gohr * @var Column[] the list of columns to be displayed 3107993756SAndreas Gohr */ 3207993756SAndreas Gohr protected $columns; 3307993756SAndreas Gohr 3407993756SAndreas Gohr /** 3507993756SAndreas Gohr * @var Value[][] the search result 3607993756SAndreas Gohr */ 3707993756SAndreas Gohr protected $result; 3807993756SAndreas Gohr 3907993756SAndreas Gohr /** 4007993756SAndreas Gohr * @var int number of all results 4107993756SAndreas Gohr */ 4207993756SAndreas Gohr protected $resultCount; 4307993756SAndreas Gohr 4407993756SAndreas Gohr /** 4507993756SAndreas Gohr * @var array for summing up columns 4607993756SAndreas Gohr */ 4707993756SAndreas Gohr protected $sums; 4807993756SAndreas Gohr 4907993756SAndreas Gohr /** 5007993756SAndreas Gohr * @todo we might be able to get rid of this helper and move this to SearchConfig 5107993756SAndreas Gohr * @var \helper_plugin_struct_config 5207993756SAndreas Gohr */ 5307993756SAndreas Gohr protected $helper; 5407993756SAndreas Gohr 5507993756SAndreas Gohr /** 5607993756SAndreas Gohr * Initialize the Aggregation renderer and executes the search 5707993756SAndreas Gohr * 5807993756SAndreas Gohr * You need to call @see render() on the resulting object. 5907993756SAndreas Gohr * 6007993756SAndreas Gohr * @param string $id 6107993756SAndreas Gohr * @param string $mode 6207993756SAndreas Gohr * @param \Doku_Renderer $renderer 6307993756SAndreas Gohr * @param SearchConfig $searchConfig 6407993756SAndreas Gohr */ 6507993756SAndreas Gohr public function __construct($id, $mode, \Doku_Renderer $renderer, SearchConfig $searchConfig) { 6607993756SAndreas Gohr $this->id = $id; 6707993756SAndreas Gohr $this->mode = $mode; 6807993756SAndreas Gohr $this->renderer = $renderer; 6907993756SAndreas Gohr $this->searchConfig = $searchConfig; 7007993756SAndreas Gohr $this->data = $searchConfig->getConf(); 7107993756SAndreas Gohr $this->columns = $searchConfig->getColumns(); 7207993756SAndreas Gohr 7307993756SAndreas Gohr $this->result = $this->searchConfig->execute(); 7407993756SAndreas Gohr $this->resultCount = $this->searchConfig->getCount(); 7507993756SAndreas Gohr $this->helper = plugin_load('helper', 'struct_config'); 7607993756SAndreas Gohr } 7707993756SAndreas Gohr 7807993756SAndreas Gohr /** 7907993756SAndreas Gohr * Create the table on the renderer 8007993756SAndreas Gohr */ 8107993756SAndreas Gohr public function render() { 8207993756SAndreas Gohr // table open 8307993756SAndreas Gohr $this->startScope(); 84986ab7e6SAndreas Gohr $this->renderActiveFilters(); 8507993756SAndreas Gohr $this->renderer->table_open(); 8607993756SAndreas Gohr 8707993756SAndreas Gohr // header 8807993756SAndreas Gohr $this->renderer->tablethead_open(); 89986ab7e6SAndreas Gohr $this->renderColumnHeaders(); 90986ab7e6SAndreas Gohr $this->renderDynamicFilters(); 9107993756SAndreas Gohr $this->renderer->tablethead_close(); 9207993756SAndreas Gohr 9307993756SAndreas Gohr if($this->resultCount) { 9407993756SAndreas Gohr // actual data 95986ab7e6SAndreas Gohr $this->renderResult(); 9607993756SAndreas Gohr 9707993756SAndreas Gohr // footer 98986ab7e6SAndreas Gohr $this->renderSums(); 99986ab7e6SAndreas Gohr $this->renderPagingControls(); 10007993756SAndreas Gohr } else { 10107993756SAndreas Gohr // nothing found 102986ab7e6SAndreas Gohr $this->renderEmptyResult(); 10307993756SAndreas Gohr } 10407993756SAndreas Gohr 10507993756SAndreas Gohr // table close 10607993756SAndreas Gohr $this->renderer->table_close(); 10707993756SAndreas Gohr $this->finishScope(); 10807993756SAndreas Gohr } 10907993756SAndreas Gohr 11007993756SAndreas Gohr /** 11107993756SAndreas Gohr * Adds additional info to document and renderer in XHTML mode 11207993756SAndreas Gohr * 11307993756SAndreas Gohr * @see finishScope() 11407993756SAndreas Gohr */ 11507993756SAndreas Gohr protected function startScope() { 11607993756SAndreas Gohr if($this->mode != 'xhtml') return; 11707993756SAndreas Gohr 11807993756SAndreas Gohr // wrapping div 11907993756SAndreas Gohr $this->renderer->doc .= "<div class=\"structaggregation\">"; 12007993756SAndreas Gohr 12107993756SAndreas Gohr // unique identifier for this aggregation 12207993756SAndreas Gohr $this->renderer->info['struct_table_hash'] = md5(var_export($this->data, true)); 12307993756SAndreas Gohr } 12407993756SAndreas Gohr 12507993756SAndreas Gohr /** 12607993756SAndreas Gohr * Closes the table and anything opened in startScope() 12707993756SAndreas Gohr * 12807993756SAndreas Gohr * @see startScope() 12907993756SAndreas Gohr */ 13007993756SAndreas Gohr protected function finishScope() { 13107993756SAndreas Gohr if($this->mode != 'xhtml') return; 13207993756SAndreas Gohr 13307993756SAndreas Gohr // wrapping div 13407993756SAndreas Gohr $this->renderer->doc .= '</div>'; 13507993756SAndreas Gohr 13607993756SAndreas Gohr // remove identifier from renderer again 13707993756SAndreas Gohr if(isset($this->renderer->info['struct_table_hash'])) { 13807993756SAndreas Gohr unset($this->renderer->info['struct_table_hash']); 13907993756SAndreas Gohr } 14007993756SAndreas Gohr } 14107993756SAndreas Gohr 14207993756SAndreas Gohr /** 14307993756SAndreas Gohr * Displays info about the currently applied filters 14407993756SAndreas Gohr */ 145986ab7e6SAndreas Gohr protected function renderActiveFilters() { 14607993756SAndreas Gohr if($this->mode != 'xhtml') return; 14707993756SAndreas Gohr $dynamic = $this->searchConfig->getDynamicParameters(); 14807993756SAndreas Gohr $filters = $dynamic->getFilters(); 14907993756SAndreas Gohr if(!$filters) return; 15007993756SAndreas Gohr 15107993756SAndreas Gohr $fltrs = array(); 15207993756SAndreas Gohr foreach($filters as $column => $filter) { 15307993756SAndreas Gohr list($comp, $value) = $filter; 15407993756SAndreas Gohr 15507993756SAndreas Gohr if(strpos($comp, '~') !== false) { 15607993756SAndreas Gohr if(strpos($comp, '!~') !== false) { 15707993756SAndreas Gohr $comparator_value = '!~' . str_replace('%', '*', $value); 15807993756SAndreas Gohr } else { 15907993756SAndreas Gohr $comparator_value = '~' . str_replace('%', '', $value); 16007993756SAndreas Gohr } 16107993756SAndreas Gohr $fltrs[] = $column . $comparator_value; 16207993756SAndreas Gohr } else { 16307993756SAndreas Gohr $fltrs[] = $column . $comp . $value; 16407993756SAndreas Gohr } 16507993756SAndreas Gohr } 16607993756SAndreas Gohr 16707993756SAndreas Gohr $this->renderer->doc .= '<div class="filter">'; 16807993756SAndreas Gohr $this->renderer->doc .= '<h4>' . sprintf($this->helper->getLang('tablefilteredby'), hsc(implode(' & ', $fltrs))) . '</h4>'; 16907993756SAndreas Gohr $this->renderer->doc .= '<div class="resetfilter">'; 17007993756SAndreas Gohr $this->renderer->internallink($this->id, $this->helper->getLang('tableresetfilter')); 17107993756SAndreas Gohr $this->renderer->doc .= '</div>'; 17207993756SAndreas Gohr $this->renderer->doc .= '</div>'; 17307993756SAndreas Gohr } 17407993756SAndreas Gohr 17507993756SAndreas Gohr /** 17607993756SAndreas Gohr * Shows the column headers with links to sort by column 17707993756SAndreas Gohr */ 178986ab7e6SAndreas Gohr protected function renderColumnHeaders() { 17907993756SAndreas Gohr $this->renderer->tablerow_open(); 18007993756SAndreas Gohr 18107993756SAndreas Gohr // additional column for row numbers 18207993756SAndreas Gohr if($this->data['rownumbers']) { 18307993756SAndreas Gohr $this->renderer->tableheader_open(); 18407993756SAndreas Gohr $this->renderer->cdata('#'); 18507993756SAndreas Gohr $this->renderer->tableheader_close(); 18607993756SAndreas Gohr } 18707993756SAndreas Gohr 18807993756SAndreas Gohr // show all headers 18907993756SAndreas Gohr foreach($this->data['headers'] as $num => $header) { 19007993756SAndreas Gohr $column = $this->columns[$num]; 19107993756SAndreas Gohr 19207993756SAndreas Gohr // use field label if no header was set 19307993756SAndreas Gohr if(blank($header)) { 19407993756SAndreas Gohr if(is_a($column, 'plugin\struct\meta\PageColumn')) { 19507993756SAndreas Gohr $header = $this->helper->getLang('pagelabel'); // @todo this could be part of PageColumn::getTranslatedLabel 19607993756SAndreas Gohr } else if(is_a($column, 'plugin\struct\meta\Column')) { 19707993756SAndreas Gohr $header = $column->getTranslatedLabel(); 19807993756SAndreas Gohr } else { 19907993756SAndreas Gohr $header = 'column ' . $num; // this should never happen 20007993756SAndreas Gohr } 20107993756SAndreas Gohr } 20207993756SAndreas Gohr 20307993756SAndreas Gohr // simple mode first 20407993756SAndreas Gohr if($this->mode != 'xhtml') { 20507993756SAndreas Gohr $this->renderer->tableheader_open(); 20607993756SAndreas Gohr $this->renderer->cdata($header); 20707993756SAndreas Gohr $this->renderer->tableheader_close(); 20807993756SAndreas Gohr continue; 20907993756SAndreas Gohr } 21007993756SAndreas Gohr 21107993756SAndreas Gohr // still here? create custom header for more flexibility 21207993756SAndreas Gohr 21307993756SAndreas Gohr // width setting 21407993756SAndreas Gohr $width = ''; 21507993756SAndreas Gohr if(isset($data['widths'][$num]) && $data['widths'][$num] != '-') { 21607993756SAndreas Gohr $width = ' style="width: ' . $data['widths'][$num] . ';"'; 21707993756SAndreas Gohr } 21807993756SAndreas Gohr 21907993756SAndreas Gohr // sort indicator and link 22007993756SAndreas Gohr $sortclass = ''; 22107993756SAndreas Gohr $sorts = $this->searchConfig->getSorts(); 22207993756SAndreas Gohr $dynamic = $this->searchConfig->getDynamicParameters(); 223*aa124708SAndreas Gohr $dynamic->setSort($column, true); 22407993756SAndreas Gohr if(isset($sorts[$column->getFullQualifiedLabel()])) { 225*aa124708SAndreas Gohr list(/*colname*/, $currentSort) = $sorts[$column->getFullQualifiedLabel()]; 226*aa124708SAndreas Gohr if($currentSort) { 22707993756SAndreas Gohr $sortclass = 'sort-down'; 22807993756SAndreas Gohr $dynamic->setSort($column, false); 22907993756SAndreas Gohr } else { 23007993756SAndreas Gohr $sortclass = 'sort-up'; 23107993756SAndreas Gohr } 23207993756SAndreas Gohr } 23307993756SAndreas Gohr $link = wl($this->id, $dynamic->getURLParameters()); 23407993756SAndreas Gohr 23507993756SAndreas Gohr // output XHTML header 23607993756SAndreas Gohr $this->renderer->doc .= "<th $width >"; 23707993756SAndreas Gohr $this->renderer->doc .= '<a href="' . $link . '" class="' . $sortclass . '" title="' . $this->helper->getLang('sort') . '">' . hsc($header) . '</a>'; 23807993756SAndreas Gohr $this->renderer->doc .= '</th>'; 23907993756SAndreas Gohr } 24007993756SAndreas Gohr 24107993756SAndreas Gohr $this->renderer->tablerow_close(); 24207993756SAndreas Gohr } 24307993756SAndreas Gohr 24407993756SAndreas Gohr /** 24507993756SAndreas Gohr * Add input fields for dynamic filtering 24607993756SAndreas Gohr */ 247986ab7e6SAndreas Gohr protected function renderDynamicFilters() { 24807993756SAndreas Gohr if($this->mode != 'xhtml') return; 24907993756SAndreas Gohr if(!$this->data['dynfilters']) return; 25076195677SAndreas Gohr global $conf; 25107993756SAndreas Gohr 25207993756SAndreas Gohr $this->renderer->doc .= '<tr class="dataflt">'; 25307993756SAndreas Gohr 25407993756SAndreas Gohr // add extra column for row numbers 25507993756SAndreas Gohr if($this->data['rownumbers']) { 25607993756SAndreas Gohr $this->renderer->doc .= '<th></th>'; 25707993756SAndreas Gohr } 25807993756SAndreas Gohr 25907993756SAndreas Gohr // each column gets a form 26007993756SAndreas Gohr foreach($this->columns as $column) { 26107993756SAndreas Gohr $this->renderer->doc .= '<th>'; 26207993756SAndreas Gohr { 26307993756SAndreas Gohr $form = new \Doku_Form(array('method' => 'GET', 'action' => wl($this->id))); 26476195677SAndreas Gohr unset($form->_hidden['sectok']); // we don't need it here 26576195677SAndreas Gohr if(!$conf['userewrite']) $form->addHidden('id', $this->id); 26607993756SAndreas Gohr 26707993756SAndreas Gohr // current value 26807993756SAndreas Gohr $dynamic = $this->searchConfig->getDynamicParameters(); 26907993756SAndreas Gohr $filters = $dynamic->getFilters(); 27007993756SAndreas Gohr if(isset($filters[$column->getFullQualifiedLabel()])) { 27107993756SAndreas Gohr list(, $current) = $filters[$column->getFullQualifiedLabel()]; 27207993756SAndreas Gohr $dynamic->removeFilter($column); 27307993756SAndreas Gohr } else { 27407993756SAndreas Gohr $current = ''; 27507993756SAndreas Gohr } 27607993756SAndreas Gohr 27707993756SAndreas Gohr // Add current request params 27807993756SAndreas Gohr $params = $dynamic->getURLParameters(); 27907993756SAndreas Gohr foreach($params as $key => $val) { 28007993756SAndreas Gohr $form->addHidden($key, $val); 28107993756SAndreas Gohr } 28207993756SAndreas Gohr 28307993756SAndreas Gohr // add input field 28407993756SAndreas Gohr $key = $column->getFullQualifiedLabel() . '*~'; 285d60f71efSAndreas Gohr $form->addElement(form_makeField('text', SearchConfigParameters::$PARAM_FILTER. '[' . $key . ']', $current, '')); 28607993756SAndreas Gohr $this->renderer->doc .= $form->getForm(); 28707993756SAndreas Gohr } 28807993756SAndreas Gohr $this->renderer->doc .= '</th>'; 28907993756SAndreas Gohr } 29007993756SAndreas Gohr $this->renderer->doc .= '</tr>'; 29107993756SAndreas Gohr 29207993756SAndreas Gohr } 29307993756SAndreas Gohr 29407993756SAndreas Gohr /** 29507993756SAndreas Gohr * Display the actual table data 29607993756SAndreas Gohr */ 297986ab7e6SAndreas Gohr protected function renderResult() { 29807993756SAndreas Gohr $this->renderer->tabletbody_open(); 29907993756SAndreas Gohr foreach($this->result as $rownum => $row) { 30007993756SAndreas Gohr $this->renderer->tablerow_open(); 30107993756SAndreas Gohr 30207993756SAndreas Gohr // row number column 30307993756SAndreas Gohr if($this->data['rownumbers']) { 30407993756SAndreas Gohr $this->renderer->tablecell_open(); 30507993756SAndreas Gohr $this->renderer->doc .= $rownum + 1; 30607993756SAndreas Gohr $this->renderer->tablecell_close(); 30707993756SAndreas Gohr } 30807993756SAndreas Gohr 30907993756SAndreas Gohr /** @var Value $value */ 31007993756SAndreas Gohr foreach($row as $colnum => $value) { 31107993756SAndreas Gohr $this->renderer->tablecell_open(); 31207993756SAndreas Gohr $value->render($this->renderer, $this->mode); 31307993756SAndreas Gohr $this->renderer->tablecell_close(); 31407993756SAndreas Gohr 31507993756SAndreas Gohr // summarize 31607993756SAndreas Gohr if($this->data['summarize'] && is_numeric($value->getValue())) { 31707993756SAndreas Gohr if(!isset($this->sums[$colnum])) { 31807993756SAndreas Gohr $this->sums[$colnum] = 0; 31907993756SAndreas Gohr } 32007993756SAndreas Gohr $this->sums[$colnum] += $value->getValue(); 32107993756SAndreas Gohr } 32207993756SAndreas Gohr } 32307993756SAndreas Gohr $this->renderer->tablerow_close(); 32407993756SAndreas Gohr } 32507993756SAndreas Gohr $this->renderer->tabletbody_close(); 32607993756SAndreas Gohr } 32707993756SAndreas Gohr 32807993756SAndreas Gohr /** 32907993756SAndreas Gohr * Renders an information row for when no results were found 33007993756SAndreas Gohr */ 331986ab7e6SAndreas Gohr protected function renderEmptyResult() { 33207993756SAndreas Gohr $this->renderer->tablerow_open(); 33307993756SAndreas Gohr $this->renderer->tablecell_open(count($this->data['cols']) + $this->data['rownumbers'], 'center'); 33407993756SAndreas Gohr $this->renderer->cdata($this->helper->getLang('none')); 33507993756SAndreas Gohr $this->renderer->tablecell_close(); 33607993756SAndreas Gohr $this->renderer->tablerow_close(); 33707993756SAndreas Gohr } 33807993756SAndreas Gohr 33907993756SAndreas Gohr /** 34007993756SAndreas Gohr * Add sums if wanted 34107993756SAndreas Gohr */ 342986ab7e6SAndreas Gohr protected function renderSums() { 34307993756SAndreas Gohr if($this->data['summarize']) return; 34407993756SAndreas Gohr 34507993756SAndreas Gohr $this->renderer->tablerow_open(); 34607993756SAndreas Gohr $len = count($this->data['cols']); 34707993756SAndreas Gohr 34807993756SAndreas Gohr if($this->data['rownumbers']) { 34907993756SAndreas Gohr $this->renderer->tablecell_open(); 35007993756SAndreas Gohr $this->renderer->tablecell_close(); 35107993756SAndreas Gohr } 35207993756SAndreas Gohr 35307993756SAndreas Gohr for($i = 0; $i < $len; $i++) { 35407993756SAndreas Gohr $this->renderer->tablecell_open(1, $this->data['align'][$i]); 35507993756SAndreas Gohr if(!empty($sums[$i])) { 35607993756SAndreas Gohr $this->renderer->cdata('∑ ' . $sums[$i]); 35707993756SAndreas Gohr } else { 35807993756SAndreas Gohr if($this->mode == 'xhtml') { 35907993756SAndreas Gohr $this->renderer->doc .= ' '; 36007993756SAndreas Gohr } 36107993756SAndreas Gohr } 36207993756SAndreas Gohr $this->renderer->tablecell_close(); 36307993756SAndreas Gohr } 36407993756SAndreas Gohr $this->renderer->tablerow_close(); 36507993756SAndreas Gohr } 36607993756SAndreas Gohr 36707993756SAndreas Gohr /** 368986ab7e6SAndreas Gohr * Adds paging controls to the table 36907993756SAndreas Gohr */ 370986ab7e6SAndreas Gohr protected function renderPagingControls() { 37107993756SAndreas Gohr if(empty($this->data['limit'])) return; 37207993756SAndreas Gohr if($this->mode != 'xhtml') ; 37307993756SAndreas Gohr 37407993756SAndreas Gohr $this->renderer->tablerow_open(); 37507993756SAndreas Gohr $this->renderer->tableheader_open((count($this->data['cols']) + ($this->data['rownumbers'] ? 1 : 0))); 37607993756SAndreas Gohr $offset = $this->data['offset']; 37707993756SAndreas Gohr 37807993756SAndreas Gohr // prev link 37907993756SAndreas Gohr if($offset) { 38007993756SAndreas Gohr $prev = $offset - $this->data['limit']; 38107993756SAndreas Gohr if($prev < 0) { 38207993756SAndreas Gohr $prev = 0; 38307993756SAndreas Gohr } 38407993756SAndreas Gohr 38507993756SAndreas Gohr $dynamic = $this->searchConfig->getDynamicParameters(); 38607993756SAndreas Gohr $dynamic->setOffset($prev); 38707993756SAndreas Gohr $link = wl($this->id, $dynamic->getURLParameters()); 38807993756SAndreas Gohr $this->renderer->doc .= '<a href="' . $link . '" class="prev">' . $this->helper->getLang('prev') . '</a>'; 38907993756SAndreas Gohr } 39007993756SAndreas Gohr 39107993756SAndreas Gohr // next link 39207993756SAndreas Gohr if($this->resultCount > $offset + $this->data['limit']) { 39307993756SAndreas Gohr $next = $offset + $this->data['limit']; 39407993756SAndreas Gohr $dynamic = $this->searchConfig->getDynamicParameters(); 39507993756SAndreas Gohr $dynamic->setOffset($next); 39607993756SAndreas Gohr $link = wl($this->id, $dynamic->getURLParameters()); 39707993756SAndreas Gohr $this->renderer->doc .= '<a href="' . $link . '" class="next">' . $this->helper->getLang('next') . '</a>'; 39807993756SAndreas Gohr } 39907993756SAndreas Gohr 40007993756SAndreas Gohr $this->renderer->tableheader_close(); 40107993756SAndreas Gohr $this->renderer->tablerow_close(); 40207993756SAndreas Gohr } 40307993756SAndreas Gohr} 404