xref: /plugin/struct/meta/AggregationTable.php (revision f107f479f012223bf40b4635e52c57f37c706200)
107993756SAndreas Gohr<?php
207993756SAndreas Gohr
3ba766201SAndreas Gohrnamespace dokuwiki\plugin\struct\meta;
407993756SAndreas Gohr
5d60f71efSAndreas Gohr/**
6d60f71efSAndreas Gohr * Creates the table aggregation output
7d60f71efSAndreas Gohr *
8ba766201SAndreas Gohr * @package dokuwiki\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    /**
45d4b5a17cSAndreas Gohr     * @var string[] the result PIDs for each row
46d4b5a17cSAndreas Gohr     */
47d4b5a17cSAndreas Gohr    protected $resultPIDs;
48d4b5a17cSAndreas Gohr
49d4b5a17cSAndreas Gohr    /**
5007993756SAndreas Gohr     * @var array for summing up columns
5107993756SAndreas Gohr     */
5207993756SAndreas Gohr    protected $sums;
5307993756SAndreas Gohr
5407993756SAndreas Gohr    /**
556b5e52fdSAndreas Gohr     * @var bool skip full table when no results found
566b5e52fdSAndreas Gohr     */
576b5e52fdSAndreas Gohr    protected $simplenone = true;
586b5e52fdSAndreas Gohr
596b5e52fdSAndreas Gohr    /**
6007993756SAndreas Gohr     * @todo we might be able to get rid of this helper and move this to SearchConfig
6107993756SAndreas Gohr     * @var \helper_plugin_struct_config
6207993756SAndreas Gohr     */
6307993756SAndreas Gohr    protected $helper;
6407993756SAndreas Gohr
6507993756SAndreas Gohr    /**
6607993756SAndreas Gohr     * Initialize the Aggregation renderer and executes the search
6707993756SAndreas Gohr     *
6807993756SAndreas Gohr     * You need to call @see render() on the resulting object.
6907993756SAndreas Gohr     *
7007993756SAndreas Gohr     * @param string $id
7107993756SAndreas Gohr     * @param string $mode
7207993756SAndreas Gohr     * @param \Doku_Renderer $renderer
7307993756SAndreas Gohr     * @param SearchConfig $searchConfig
7407993756SAndreas Gohr     */
7507993756SAndreas Gohr    public function __construct($id, $mode, \Doku_Renderer $renderer, SearchConfig $searchConfig) {
7607993756SAndreas Gohr        $this->id = $id;
7707993756SAndreas Gohr        $this->mode = $mode;
7807993756SAndreas Gohr        $this->renderer = $renderer;
7907993756SAndreas Gohr        $this->searchConfig = $searchConfig;
8007993756SAndreas Gohr        $this->data = $searchConfig->getConf();
8107993756SAndreas Gohr        $this->columns = $searchConfig->getColumns();
8207993756SAndreas Gohr
8307993756SAndreas Gohr        $this->result = $this->searchConfig->execute();
8407993756SAndreas Gohr        $this->resultCount = $this->searchConfig->getCount();
85d4b5a17cSAndreas Gohr        $this->resultPIDs = $this->searchConfig->getPids();
8607993756SAndreas Gohr        $this->helper = plugin_load('helper', 'struct_config');
8707993756SAndreas Gohr    }
8807993756SAndreas Gohr
8907993756SAndreas Gohr    /**
9007993756SAndreas Gohr     * Create the table on the renderer
9107993756SAndreas Gohr     */
9207993756SAndreas Gohr    public function render() {
93b7e1d73bSAndreas Gohr
94b7e1d73bSAndreas Gohr        // abort early if there are no results at all (not filtered)
956b5e52fdSAndreas Gohr        if(!$this->resultCount && !$this->isDynamicallyFiltered() && $this->simplenone) {
96b7e1d73bSAndreas Gohr            $this->startScope();
97b7e1d73bSAndreas Gohr            $this->renderer->cdata($this->helper->getLang('none'));
98b7e1d73bSAndreas Gohr            $this->finishScope();
99b7e1d73bSAndreas Gohr            return;
100b7e1d73bSAndreas Gohr        }
101b7e1d73bSAndreas Gohr
10207993756SAndreas Gohr        // table open
10307993756SAndreas Gohr        $this->startScope();
104986ab7e6SAndreas Gohr        $this->renderActiveFilters();
10507993756SAndreas Gohr        $this->renderer->table_open();
10607993756SAndreas Gohr
10707993756SAndreas Gohr        // header
10807993756SAndreas Gohr        $this->renderer->tablethead_open();
109986ab7e6SAndreas Gohr        $this->renderColumnHeaders();
110986ab7e6SAndreas Gohr        $this->renderDynamicFilters();
11107993756SAndreas Gohr        $this->renderer->tablethead_close();
11207993756SAndreas Gohr
11307993756SAndreas Gohr        if($this->resultCount) {
11407993756SAndreas Gohr            // actual data
115986ab7e6SAndreas Gohr            $this->renderResult();
11607993756SAndreas Gohr
11707993756SAndreas Gohr            // footer
118986ab7e6SAndreas Gohr            $this->renderSums();
119986ab7e6SAndreas Gohr            $this->renderPagingControls();
12007993756SAndreas Gohr        } else {
12107993756SAndreas Gohr            // nothing found
122986ab7e6SAndreas Gohr            $this->renderEmptyResult();
12307993756SAndreas Gohr        }
12407993756SAndreas Gohr
12507993756SAndreas Gohr        // table close
12607993756SAndreas Gohr        $this->renderer->table_close();
12707993756SAndreas Gohr        $this->finishScope();
12807993756SAndreas Gohr    }
12907993756SAndreas Gohr
13007993756SAndreas Gohr    /**
13107993756SAndreas Gohr     * Adds additional info to document and renderer in XHTML mode
13207993756SAndreas Gohr     *
13307993756SAndreas Gohr     * @see finishScope()
13407993756SAndreas Gohr     */
13507993756SAndreas Gohr    protected function startScope() {
13607993756SAndreas Gohr        if($this->mode != 'xhtml') return;
13707993756SAndreas Gohr
13807993756SAndreas Gohr        // wrapping div
13907993756SAndreas Gohr        $this->renderer->doc .= "<div class=\"structaggregation\">";
14007993756SAndreas Gohr
14107993756SAndreas Gohr        // unique identifier for this aggregation
14207993756SAndreas Gohr        $this->renderer->info['struct_table_hash'] = md5(var_export($this->data, true));
14307993756SAndreas Gohr    }
14407993756SAndreas Gohr
14507993756SAndreas Gohr    /**
14607993756SAndreas Gohr     * Closes the table and anything opened in startScope()
14707993756SAndreas Gohr     *
14807993756SAndreas Gohr     * @see startScope()
14907993756SAndreas Gohr     */
15007993756SAndreas Gohr    protected function finishScope() {
15107993756SAndreas Gohr        if($this->mode != 'xhtml') return;
15207993756SAndreas Gohr
15307993756SAndreas Gohr        // wrapping div
15407993756SAndreas Gohr        $this->renderer->doc .= '</div>';
15507993756SAndreas Gohr
15607993756SAndreas Gohr        // remove identifier from renderer again
15707993756SAndreas Gohr        if(isset($this->renderer->info['struct_table_hash'])) {
15807993756SAndreas Gohr            unset($this->renderer->info['struct_table_hash']);
15907993756SAndreas Gohr        }
16007993756SAndreas Gohr    }
16107993756SAndreas Gohr
16207993756SAndreas Gohr    /**
16307993756SAndreas Gohr     * Displays info about the currently applied filters
16407993756SAndreas Gohr     */
165986ab7e6SAndreas Gohr    protected function renderActiveFilters() {
16607993756SAndreas Gohr        if($this->mode != 'xhtml') return;
16707993756SAndreas Gohr        $dynamic = $this->searchConfig->getDynamicParameters();
16807993756SAndreas Gohr        $filters = $dynamic->getFilters();
16907993756SAndreas Gohr        if(!$filters) return;
17007993756SAndreas Gohr
17107993756SAndreas Gohr        $fltrs = array();
17207993756SAndreas Gohr        foreach($filters as $column => $filter) {
17307993756SAndreas Gohr            list($comp, $value) = $filter;
174083109a1SAndreas Gohr            $fltrs[] = $column . ' ' . $comp . ' ' . $value;
17507993756SAndreas Gohr        }
17607993756SAndreas Gohr
17707993756SAndreas Gohr        $this->renderer->doc .= '<div class="filter">';
17807993756SAndreas Gohr        $this->renderer->doc .= '<h4>' . sprintf($this->helper->getLang('tablefilteredby'), hsc(implode(' & ', $fltrs))) . '</h4>';
17907993756SAndreas Gohr        $this->renderer->doc .= '<div class="resetfilter">';
18007993756SAndreas Gohr        $this->renderer->internallink($this->id, $this->helper->getLang('tableresetfilter'));
18107993756SAndreas Gohr        $this->renderer->doc .= '</div>';
18207993756SAndreas Gohr        $this->renderer->doc .= '</div>';
18307993756SAndreas Gohr    }
18407993756SAndreas Gohr
18507993756SAndreas Gohr    /**
18607993756SAndreas Gohr     * Shows the column headers with links to sort by column
18707993756SAndreas Gohr     */
188986ab7e6SAndreas Gohr    protected function renderColumnHeaders() {
18907993756SAndreas Gohr        $this->renderer->tablerow_open();
19007993756SAndreas Gohr
19107993756SAndreas Gohr        // additional column for row numbers
19207993756SAndreas Gohr        if($this->data['rownumbers']) {
19307993756SAndreas Gohr            $this->renderer->tableheader_open();
19407993756SAndreas Gohr            $this->renderer->cdata('#');
19507993756SAndreas Gohr            $this->renderer->tableheader_close();
19607993756SAndreas Gohr        }
19707993756SAndreas Gohr
19807993756SAndreas Gohr        // show all headers
1998c4ee9beSAndreas Gohr        foreach($this->columns as $num => $column) {
2008c4ee9beSAndreas Gohr            $header = '';
2018c4ee9beSAndreas Gohr            if(isset($this->data['headers'][$num])) {
2028c4ee9beSAndreas Gohr                $header = $this->data['headers'][$num];
2038c4ee9beSAndreas Gohr            }
20407993756SAndreas Gohr
20507993756SAndreas Gohr            // use field label if no header was set
20607993756SAndreas Gohr            if(blank($header)) {
20701f8b845SAndreas Gohr                if(is_a($column, 'dokuwiki\plugin\struct\meta\Column')) {
20807993756SAndreas Gohr                    $header = $column->getTranslatedLabel();
20907993756SAndreas Gohr                } else {
21007993756SAndreas Gohr                    $header = 'column ' . $num; // this should never happen
21107993756SAndreas Gohr                }
21207993756SAndreas Gohr            }
21307993756SAndreas Gohr
21407993756SAndreas Gohr            // simple mode first
21507993756SAndreas Gohr            if($this->mode != 'xhtml') {
21607993756SAndreas Gohr                $this->renderer->tableheader_open();
21707993756SAndreas Gohr                $this->renderer->cdata($header);
21807993756SAndreas Gohr                $this->renderer->tableheader_close();
21907993756SAndreas Gohr                continue;
22007993756SAndreas Gohr            }
22107993756SAndreas Gohr
22207993756SAndreas Gohr            // still here? create custom header for more flexibility
22307993756SAndreas Gohr
22407993756SAndreas Gohr            // width setting
22507993756SAndreas Gohr            $width = '';
22607993756SAndreas Gohr            if(isset($data['widths'][$num]) && $data['widths'][$num] != '-') {
227e0216289SAndreas Gohr                $width = ' style="width: ' . $data['widths'][$num] . ';"'; // widths are prevalidated, no escape needed
22807993756SAndreas Gohr            }
22907993756SAndreas Gohr
230d4b5a17cSAndreas Gohr            // prepare data attribute for inline edits
231d4b5a17cSAndreas Gohr            if(!is_a($column, '\dokuwiki\plugin\struct\meta\PageColumn') &&
232d4b5a17cSAndreas Gohr                !is_a($column, '\dokuwiki\plugin\struct\meta\RevisionColumn')
233d4b5a17cSAndreas Gohr            ) {
234d4b5a17cSAndreas Gohr                $data = 'data-field="' . hsc($column->getFullQualifiedLabel()) . '"';
235d4b5a17cSAndreas Gohr            } else {
236d4b5a17cSAndreas Gohr                $data = '';
237d4b5a17cSAndreas Gohr            }
238d4b5a17cSAndreas Gohr
23907993756SAndreas Gohr            // sort indicator and link
24007993756SAndreas Gohr            $sortclass = '';
24107993756SAndreas Gohr            $sorts = $this->searchConfig->getSorts();
24207993756SAndreas Gohr            $dynamic = $this->searchConfig->getDynamicParameters();
243aa124708SAndreas Gohr            $dynamic->setSort($column, true);
24407993756SAndreas Gohr            if(isset($sorts[$column->getFullQualifiedLabel()])) {
245aa124708SAndreas Gohr                list(/*colname*/, $currentSort) = $sorts[$column->getFullQualifiedLabel()];
246aa124708SAndreas Gohr                if($currentSort) {
24707993756SAndreas Gohr                    $sortclass = 'sort-down';
24807993756SAndreas Gohr                    $dynamic->setSort($column, false);
24907993756SAndreas Gohr                } else {
25007993756SAndreas Gohr                    $sortclass = 'sort-up';
25107993756SAndreas Gohr                }
25207993756SAndreas Gohr            }
25307993756SAndreas Gohr            $link = wl($this->id, $dynamic->getURLParameters());
25407993756SAndreas Gohr
25507993756SAndreas Gohr            // output XHTML header
256d4b5a17cSAndreas Gohr            $this->renderer->doc .= "<th $width $data>";
25707993756SAndreas Gohr            $this->renderer->doc .= '<a href="' . $link . '" class="' . $sortclass . '" title="' . $this->helper->getLang('sort') . '">' . hsc($header) . '</a>';
25807993756SAndreas Gohr            $this->renderer->doc .= '</th>';
25907993756SAndreas Gohr        }
26007993756SAndreas Gohr
26107993756SAndreas Gohr        $this->renderer->tablerow_close();
26207993756SAndreas Gohr    }
26307993756SAndreas Gohr
26407993756SAndreas Gohr    /**
265b7e1d73bSAndreas Gohr     * Is the result set currently dynamically filtered?
266b7e1d73bSAndreas Gohr     * @return bool
267b7e1d73bSAndreas Gohr     */
268b7e1d73bSAndreas Gohr    protected function isDynamicallyFiltered() {
269b7e1d73bSAndreas Gohr        if($this->mode != 'xhtml') return false;
270b7e1d73bSAndreas Gohr        if(!$this->data['dynfilters']) return false;
271b7e1d73bSAndreas Gohr
272b7e1d73bSAndreas Gohr        $dynamic = $this->searchConfig->getDynamicParameters();
273b7e1d73bSAndreas Gohr        return (bool) $dynamic->getFilters();
274b7e1d73bSAndreas Gohr    }
275b7e1d73bSAndreas Gohr
276b7e1d73bSAndreas Gohr    /**
27707993756SAndreas Gohr     * Add input fields for dynamic filtering
27807993756SAndreas Gohr     */
279986ab7e6SAndreas Gohr    protected function renderDynamicFilters() {
28007993756SAndreas Gohr        if($this->mode != 'xhtml') return;
28107993756SAndreas Gohr        if(!$this->data['dynfilters']) return;
28276195677SAndreas Gohr        global $conf;
28307993756SAndreas Gohr
28407993756SAndreas Gohr        $this->renderer->doc .= '<tr class="dataflt">';
28507993756SAndreas Gohr
28607993756SAndreas Gohr        // add extra column for row numbers
28707993756SAndreas Gohr        if($this->data['rownumbers']) {
28807993756SAndreas Gohr            $this->renderer->doc .= '<th></th>';
28907993756SAndreas Gohr        }
29007993756SAndreas Gohr
29107993756SAndreas Gohr        // each column gets a form
29207993756SAndreas Gohr        foreach($this->columns as $column) {
29307993756SAndreas Gohr            $this->renderer->doc .= '<th>';
29407993756SAndreas Gohr            {
29507993756SAndreas Gohr                $form = new \Doku_Form(array('method' => 'GET', 'action' => wl($this->id)));
29676195677SAndreas Gohr                unset($form->_hidden['sectok']); // we don't need it here
29776195677SAndreas Gohr                if(!$conf['userewrite']) $form->addHidden('id', $this->id);
29807993756SAndreas Gohr
29907993756SAndreas Gohr                // current value
30007993756SAndreas Gohr                $dynamic = $this->searchConfig->getDynamicParameters();
30107993756SAndreas Gohr                $filters = $dynamic->getFilters();
30207993756SAndreas Gohr                if(isset($filters[$column->getFullQualifiedLabel()])) {
30307993756SAndreas Gohr                    list(, $current) = $filters[$column->getFullQualifiedLabel()];
30407993756SAndreas Gohr                    $dynamic->removeFilter($column);
30507993756SAndreas Gohr                } else {
30607993756SAndreas Gohr                    $current = '';
30707993756SAndreas Gohr                }
30807993756SAndreas Gohr
30907993756SAndreas Gohr                // Add current request params
31007993756SAndreas Gohr                $params = $dynamic->getURLParameters();
31107993756SAndreas Gohr                foreach($params as $key => $val) {
31207993756SAndreas Gohr                    $form->addHidden($key, $val);
31307993756SAndreas Gohr                }
31407993756SAndreas Gohr
31507993756SAndreas Gohr                // add input field
31607993756SAndreas Gohr                $key = $column->getFullQualifiedLabel() . '*~';
317d60f71efSAndreas Gohr                $form->addElement(form_makeField('text', SearchConfigParameters::$PARAM_FILTER . '[' . $key . ']', $current, ''));
31807993756SAndreas Gohr                $this->renderer->doc .= $form->getForm();
31907993756SAndreas Gohr            }
32007993756SAndreas Gohr            $this->renderer->doc .= '</th>';
32107993756SAndreas Gohr        }
32207993756SAndreas Gohr        $this->renderer->doc .= '</tr>';
32307993756SAndreas Gohr
32407993756SAndreas Gohr    }
32507993756SAndreas Gohr
32607993756SAndreas Gohr    /**
32707993756SAndreas Gohr     * Display the actual table data
32807993756SAndreas Gohr     */
329986ab7e6SAndreas Gohr    protected function renderResult() {
33007993756SAndreas Gohr        $this->renderer->tabletbody_open();
33107993756SAndreas Gohr        foreach($this->result as $rownum => $row) {
332*f107f479SAndreas Gohr            $this->renderResultRow($rownum, $row);
333*f107f479SAndreas Gohr        }
334*f107f479SAndreas Gohr        $this->renderer->tabletbody_close();
335*f107f479SAndreas Gohr    }
336*f107f479SAndreas Gohr
337*f107f479SAndreas Gohr    /**
338*f107f479SAndreas Gohr     * Render a single result row
339*f107f479SAndreas Gohr     *
340*f107f479SAndreas Gohr     * @param int $rownum
341*f107f479SAndreas Gohr     * @param array $row
342*f107f479SAndreas Gohr     */
343*f107f479SAndreas Gohr    protected function renderResultRow($rownum, $row) {
34407993756SAndreas Gohr        $this->renderer->tablerow_open();
34507993756SAndreas Gohr
346d4b5a17cSAndreas Gohr        // add data attribute for inline edit
347d4b5a17cSAndreas Gohr        if($this->mode == 'xhtml') {
348d4b5a17cSAndreas Gohr            $pid = $this->resultPIDs[$rownum];
349d4b5a17cSAndreas Gohr            $this->renderer->doc = substr(rtrim($this->renderer->doc), 0, -1); // remove closing '>'
350d4b5a17cSAndreas Gohr            $this->renderer->doc .= ' data-pid="' . hsc($pid) . '">';
351d4b5a17cSAndreas Gohr        }
352d4b5a17cSAndreas Gohr
35307993756SAndreas Gohr        // row number column
35407993756SAndreas Gohr        if($this->data['rownumbers']) {
35507993756SAndreas Gohr            $this->renderer->tablecell_open();
35607993756SAndreas Gohr            $this->renderer->doc .= $rownum + 1;
35707993756SAndreas Gohr            $this->renderer->tablecell_close();
35807993756SAndreas Gohr        }
35907993756SAndreas Gohr
36007993756SAndreas Gohr        /** @var Value $value */
36107993756SAndreas Gohr        foreach($row as $colnum => $value) {
36207993756SAndreas Gohr            $this->renderer->tablecell_open();
36307993756SAndreas Gohr            $value->render($this->renderer, $this->mode);
36407993756SAndreas Gohr            $this->renderer->tablecell_close();
36507993756SAndreas Gohr
36607993756SAndreas Gohr            // summarize
36707993756SAndreas Gohr            if($this->data['summarize'] && is_numeric($value->getValue())) {
36807993756SAndreas Gohr                if(!isset($this->sums[$colnum])) {
36907993756SAndreas Gohr                    $this->sums[$colnum] = 0;
37007993756SAndreas Gohr                }
37107993756SAndreas Gohr                $this->sums[$colnum] += $value->getValue();
37207993756SAndreas Gohr            }
37307993756SAndreas Gohr        }
37407993756SAndreas Gohr        $this->renderer->tablerow_close();
37507993756SAndreas Gohr    }
37607993756SAndreas Gohr
37707993756SAndreas Gohr    /**
37807993756SAndreas Gohr     * Renders an information row for when no results were found
37907993756SAndreas Gohr     */
380986ab7e6SAndreas Gohr    protected function renderEmptyResult() {
38107993756SAndreas Gohr        $this->renderer->tablerow_open();
38270cf6339SAndreas Gohr        $this->renderer->tablecell_open(count($this->columns) + $this->data['rownumbers'], 'center');
38307993756SAndreas Gohr        $this->renderer->cdata($this->helper->getLang('none'));
38407993756SAndreas Gohr        $this->renderer->tablecell_close();
38507993756SAndreas Gohr        $this->renderer->tablerow_close();
38607993756SAndreas Gohr    }
38707993756SAndreas Gohr
38807993756SAndreas Gohr    /**
38907993756SAndreas Gohr     * Add sums if wanted
39007993756SAndreas Gohr     */
391986ab7e6SAndreas Gohr    protected function renderSums() {
392d18090e8SAndreas Gohr        if(empty($this->data['summarize'])) return;
39307993756SAndreas Gohr
39407993756SAndreas Gohr        $this->renderer->tablerow_open();
39507993756SAndreas Gohr
39607993756SAndreas Gohr        if($this->data['rownumbers']) {
39707993756SAndreas Gohr            $this->renderer->tablecell_open();
39807993756SAndreas Gohr            $this->renderer->tablecell_close();
39907993756SAndreas Gohr        }
40007993756SAndreas Gohr
401aee4116bSAndreas Gohr        $len = count($this->columns);
40207993756SAndreas Gohr        for($i = 0; $i < $len; $i++) {
40307993756SAndreas Gohr            $this->renderer->tablecell_open(1, $this->data['align'][$i]);
404aee4116bSAndreas Gohr            if(!empty($this->sums[$i])) {
4059b97e610SAndreas Gohr                $this->renderer->cdata('∑ ');
4069b97e610SAndreas Gohr                $this->columns[$i]->getType()->renderValue($this->sums[$i], $this->renderer, $this->mode);
40707993756SAndreas Gohr            } else {
40807993756SAndreas Gohr                if($this->mode == 'xhtml') {
40907993756SAndreas Gohr                    $this->renderer->doc .= '&nbsp;';
41007993756SAndreas Gohr                }
41107993756SAndreas Gohr            }
41207993756SAndreas Gohr            $this->renderer->tablecell_close();
41307993756SAndreas Gohr        }
41407993756SAndreas Gohr        $this->renderer->tablerow_close();
41507993756SAndreas Gohr    }
41607993756SAndreas Gohr
41707993756SAndreas Gohr    /**
418986ab7e6SAndreas Gohr     * Adds paging controls to the table
41907993756SAndreas Gohr     */
420986ab7e6SAndreas Gohr    protected function renderPagingControls() {
42107993756SAndreas Gohr        if(empty($this->data['limit'])) return;
42207993756SAndreas Gohr        if($this->mode != 'xhtml') ;
42307993756SAndreas Gohr
42407993756SAndreas Gohr        $this->renderer->tablerow_open();
42507993756SAndreas Gohr        $this->renderer->tableheader_open((count($this->data['cols']) + ($this->data['rownumbers'] ? 1 : 0)));
42607993756SAndreas Gohr        $offset = $this->data['offset'];
42707993756SAndreas Gohr
42807993756SAndreas Gohr        // prev link
42907993756SAndreas Gohr        if($offset) {
43007993756SAndreas Gohr            $prev = $offset - $this->data['limit'];
43107993756SAndreas Gohr            if($prev < 0) {
43207993756SAndreas Gohr                $prev = 0;
43307993756SAndreas Gohr            }
43407993756SAndreas Gohr
43507993756SAndreas Gohr            $dynamic = $this->searchConfig->getDynamicParameters();
43607993756SAndreas Gohr            $dynamic->setOffset($prev);
43707993756SAndreas Gohr            $link = wl($this->id, $dynamic->getURLParameters());
43807993756SAndreas Gohr            $this->renderer->doc .= '<a href="' . $link . '" class="prev">' . $this->helper->getLang('prev') . '</a>';
43907993756SAndreas Gohr        }
44007993756SAndreas Gohr
44107993756SAndreas Gohr        // next link
44207993756SAndreas Gohr        if($this->resultCount > $offset + $this->data['limit']) {
44307993756SAndreas Gohr            $next = $offset + $this->data['limit'];
44407993756SAndreas Gohr            $dynamic = $this->searchConfig->getDynamicParameters();
44507993756SAndreas Gohr            $dynamic->setOffset($next);
44607993756SAndreas Gohr            $link = wl($this->id, $dynamic->getURLParameters());
44707993756SAndreas Gohr            $this->renderer->doc .= '<a href="' . $link . '" class="next">' . $this->helper->getLang('next') . '</a>';
44807993756SAndreas Gohr        }
44907993756SAndreas Gohr
45007993756SAndreas Gohr        $this->renderer->tableheader_close();
45107993756SAndreas Gohr        $this->renderer->tablerow_close();
45207993756SAndreas Gohr    }
45307993756SAndreas Gohr}
454