xref: /plugin/struct/meta/AggregationTable.php (revision aa1247084102774e3fd98ab7a6c053fcf402ff97)
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 .= '&nbsp;';
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