81         $dataau = array(
115                         $dataau['cols'][$column['key']] = $column;
119                     $dataau['title'] = $line[1];
125                     $dataau['headers'] = array_merge($dataau['headers'], $cols);
138                         $dataau['align'][] = $col;
145                         $dataau['widths'][] = $col;
149                     $dataau['min'] = abs((int) $line[1]);
153                     $dataau['limit'] = abs((int) $line[1]);
160                         $dataau['sort'] = array(substr($sort, 1), 'DESC');
162                         $dataau['sort'] = array($sort, 'ASC');
179                         $dataau['filter'][] = $flt;
184                     $dataau['page'] = cleanID($line[1]);
187                     $dataau['dynfilters'] = (bool) $line[1];
190                     $dataau['rownumbers'] = (bool) $line[1];
193                     $dataau['summarize'] = (bool) $line[1];
196                     $dataau['sepbyheaders'] = (bool) $line[1];
204         if(!is_array($dataau['cols']) || !count($dataau['cols'])) {
210         $dataau['headers'] = (array) $dataau['headers'];
211         $cnth = count($dataau['headers']);
212         $cntf = count($dataau['cols']);
214             $column = array_slice($dataau['cols'], $i, 1);
216             $dataau['headers'][] = $columnprops['title'];
219         $dataau['sql'] = $this->_buildSQL($dataau);
222         $dataau['cur_param'] = $this->dthlp->_get_current_param(false);
223         return $dataau;
236      * @param   array         $dataau   data created by handler()
239     function render($format, Doku_Renderer $R, $dataau) {  argument
243         if(is_null($dataau)) return false;
254             $this->updateSQLwithQuery($dataau); // handles request params
256         $this->dthlp->_replacePlaceholdersInSQL($dataau);
259         $clist = array_keys($dataau['cols']);
260         $res = $sqlite->query($dataau['sql']);
266             $this->nullList($dataau, $clist, $R);
270         if($dataau['limit'] && $cnt > $dataau['limit']) {
271             $rows = array_slice($rows, 0, $dataau['limit']);
278         if($dataau['rownumbers']) {
280             $classes[] = $dataau['align'][0] . 'align rownumbers';
283             $class = $dataau['align'][$index + $offset] . 'align';
289         $R->doc .= $this->preList($clist, $dataau);
295             if($dataau['rownumbers']) {
304 …       $R->doc .= sprintf($this->beforeVal($dataau, $num_rn), 'class="' . $classes[$num_rn] . '"');
306                     $dataau['cols'][$clist[$num]],
309                 $R->doc .= $this->afterVal($dataau, $num_rn);
318                 if($dataau['summarize'] && is_numeric($nval)) {
328         $R->doc .= $this->postList($dataau, $cnt);
336      * @param array $dataau  instructions by handler
340     protected function beforeVal(&$dataau, $colno) {  argument
351     protected function afterVal(&$dataau, $colno) {  argument
359      * @param array $dataau  instruction by handler
362     function preList($clist, $dataau) {  argument
395         $text .= '<table class="inline dataauplugin_table ' . $dataau['classes'] . '">';
399         if($dataau['rownumbers']) {
403         foreach($dataau['headers'] as $num => $head) {
407             if(isset($dataau['widths'][$num]) AND $dataau['widths'][$num] != '-') {
408                 $width = ' style="width: ' . $dataau['widths'][$num] . ';"';
413             if(isset($dataau['sort']) && $ckey == $dataau['sort'][0]) {
414                 if($dataau['sort'][1] == 'ASC') {
430         if($dataau['dynfilters']) {
433             if($dataau['rownumbers']) {
437             foreach($dataau['headers'] as $num => $head) {
445                 $key = 'dataflt[' . $dataau['cols'][$clist[$num]]['colname'] . '*~' . ']';
468      * @param array         $dataau  instruction by handler()
472     function nullList($dataau, $clist, $R) {  argument
473         $R->doc .= $this->preList($clist, $dataau);
485      * @param array $dataau   instruction by handler()
489     function postList($dataau, $rowcnt) {  argument
493         if($dataau['summarize']) {
495             $len = count($dataau['cols']);
497             if($dataau['rownumbers']) $text .= '<td></td>';
500                 $text .= '<td class="' . $dataau['align'][$i] . 'align">';
512         if($dataau['limit']) {
513 …  $text .= '<tr><th colspan="' . (count($dataau['cols']) + ($dataau['rownumbers'] ? 1 : 0)) . '">';
516                 $prev = $offset - $dataau['limit'];
535             if($rowcnt > $dataau['limit']) {
536                 $next = $offset + $dataau['limit'];
562     function _buildSQL(&$dataau) {  argument
575         foreach($dataau['cols'] as &$col) {
612         if(isset($dataau['sort'])) {
613             $col = $dataau['sort'][0];
616                 $order = 'ORDER BY pages.page ' . $dataau['sort'][1];
618                 $order = 'ORDER BY pages.class ' . $dataau['sort'][1];
620                 $order = 'ORDER BY pages.title ' . $dataau['sort'][1];
622                 $order = 'ORDER BY pages.lastmod ' . $dataau['sort'][1];
631                 $order = 'ORDER BY ' . $tables[$col] . '.value ' . $dataau['sort'][1];
642         if(is_array($dataau['filter']) && count($dataau['filter'])) {
644             foreach($dataau['filter'] as $filter) {
689         if($dataau['limit']) {
690             $sql .= ' LIMIT ' . ($dataau['limit'] + 1);
700      * @param array $dataau instruction by handler()
702     function updateSQLwithQuery(&$dataau) {  argument
706                     $dataau['sort'] = array(substr($_REQUEST['dataausrt'], 1), 'DESC');
708                     $dataau['sort'] = array($_REQUEST['dataausrt'], 'ASC');
713             $dataau['filter'] = array_merge($dataau['filter'], $this->dthlp->_get_filters());
716             $dataau['sql'] = $this->_buildSQL($dataau);
719         if($dataau['limit'] && (int) $_REQUEST['dataauofs']) {
720             $dataau['sql'] .= ' OFFSET ' . ((int) $_REQUEST['dataauofs']);