xref: /plugin/todo/syntax/list.php (revision e1fc243e91d4375d19c6d4baacd18f347a58eab0)
1aa11d6a4Sleibler<?php
2aa11d6a4Sleibler/**
3aa11d6a4Sleibler * DokuWiki Plugin todo_list (Syntax Component)
4aa11d6a4Sleibler *
5aa11d6a4Sleibler * @license GPL 2 http://www.gnu.org/licenses/gpl-2.0.html
6aa11d6a4Sleibler */
7aa11d6a4Sleibler
8aa11d6a4Sleibler// must be run within Dokuwiki
9aa11d6a4Sleiblerif(!defined('DOKU_INC')) die();
10aa11d6a4Sleibler
11aa11d6a4Sleibler/**
12aa11d6a4Sleibler * Class syntax_plugin_todo_list
13aa11d6a4Sleibler */
14aa11d6a4Sleiblerclass syntax_plugin_todo_list extends syntax_plugin_todo_todo {
15aa11d6a4Sleibler
16aa11d6a4Sleibler    /**
17aa11d6a4Sleibler     * @return string Syntax mode type
18aa11d6a4Sleibler     */
19aa11d6a4Sleibler    public function getType() {
20aa11d6a4Sleibler        return 'substition';
21aa11d6a4Sleibler    }
22aa11d6a4Sleibler
23aa11d6a4Sleibler    /**
24aa11d6a4Sleibler     * @return string Paragraph type
25aa11d6a4Sleibler     */
26aa11d6a4Sleibler    public function getPType() {
27aa11d6a4Sleibler        return 'block';
28aa11d6a4Sleibler    }
29aa11d6a4Sleibler
30aa11d6a4Sleibler    /**
31aa11d6a4Sleibler     * @return int Sort order - Low numbers go before high numbers
32aa11d6a4Sleibler     */
33aa11d6a4Sleibler    public function getSort() {
34aa11d6a4Sleibler        return 250;
35aa11d6a4Sleibler    }
36aa11d6a4Sleibler
37aa11d6a4Sleibler    /**
38aa11d6a4Sleibler     * Connect lookup pattern to lexer.
39aa11d6a4Sleibler     *
40aa11d6a4Sleibler     * @param string $mode Parser mode
41aa11d6a4Sleibler     */
42aa11d6a4Sleibler    public function connectTo($mode) {
43aa11d6a4Sleibler        $this->Lexer->addSpecialPattern('~~TODOLIST[^~]*~~', $mode, 'plugin_todo_list');
44aa11d6a4Sleibler    }
45aa11d6a4Sleibler
46aa11d6a4Sleibler    /**
47aa11d6a4Sleibler     * Handle matches of the todolist syntax
48aa11d6a4Sleibler     *
49aa11d6a4Sleibler     * @param string $match The match of the syntax
50aa11d6a4Sleibler     * @param int $state The state of the handler
51aa11d6a4Sleibler     * @param int $pos The position in the document
52aa11d6a4Sleibler     * @param Doku_Handler $handler The handler
53aa11d6a4Sleibler     * @return array Data for the renderer
54aa11d6a4Sleibler     */
558038693eSAndreas Gohr    public function handle($match, $state, $pos, Doku_Handler $handler) {
56aa11d6a4Sleibler
57aa11d6a4Sleibler        $options = substr($match, 10, -2); // strip markup
58aa11d6a4Sleibler        $options = explode(' ', $options);
597eccb63fSrunout-at        $data = array(
6061e401ffSrunout-at            'header' => $this->getConf("Header"),
61aa11d6a4Sleibler            'completed' => 'all',
6296468fefSrunout-at            'assigned' => 'all',
633bd520d9Srunout-at            'completeduserlist' => 'all',
64f1a46b72SMax Westen            'ns' => 'all',
65819065edSrunout-at            'showdate' => $this->getConf("ShowdateList"),
6661e401ffSrunout-at            'checkbox' => $this->getConf("Checkbox"),
675a968c91Srunout-at            'username' => $this->getConf("Username"),
68d30f06ddSRobin Helgelin            'short' => false,
69aa11d6a4Sleibler        );
70aa11d6a4Sleibler        $allowedvalues = array('yes', 'no');
71aa11d6a4Sleibler        foreach($options as $option) {
72aa11d6a4Sleibler            @list($key, $value) = explode(':', $option, 2);
730e738436Srunout-at            switch($key) {
740e738436Srunout-at                case 'header': // how should the header be rendered?
7551046ae0Srunout-at                    if(in_array($value, array('id', 'firstheader', 'none'))) {
76bce03c8aSrunout-at                        $data['header'] = $value;
77bce03c8aSrunout-at                    }
78bce03c8aSrunout-at                    break;
79d30f06ddSRobin Helgelin                case 'short':
80d30f06ddSRobin Helgelin                    if(in_array($value, $allowedvalues)) {
81d30f06ddSRobin Helgelin                        $data['short'] = ($value == 'yes');
82d30f06ddSRobin Helgelin                    }
83d30f06ddSRobin Helgelin                    break;
84780010cdSrunout-at                case 'showdate':
85780010cdSrunout-at                    if(in_array($value, $allowedvalues)) {
86819065edSrunout-at                        $data['showdate'] = ($value == 'yes');
87780010cdSrunout-at                    }
88780010cdSrunout-at                    break;
8996468fefSrunout-at                case 'checkbox': // should checkbox be rendered?
9096468fefSrunout-at                    if(in_array($value, $allowedvalues)) {
9196468fefSrunout-at                        $data['checkbox'] = ($value == 'yes');
9296468fefSrunout-at                    }
9396468fefSrunout-at                    break;
94aa11d6a4Sleibler                case 'completed':
95aa11d6a4Sleibler                    if(in_array($value, $allowedvalues)) {
96aa11d6a4Sleibler                        $data['completed'] = ($value == 'yes');
97aa11d6a4Sleibler                    }
98aa11d6a4Sleibler                    break;
9996468fefSrunout-at                case 'username': // how should the username be rendered?
10096468fefSrunout-at                    if(in_array($value, array('user', 'real', 'none'))) {
10196468fefSrunout-at                        $data['username'] = $value;
10296468fefSrunout-at                    }
10396468fefSrunout-at                    break;
104aa11d6a4Sleibler                case 'assigned':
105aa11d6a4Sleibler                    if(in_array($value, $allowedvalues)) {
106aa11d6a4Sleibler                        $data['assigned'] = ($value == 'yes');
107aa11d6a4Sleibler                        break;
108aa11d6a4Sleibler                    }
109aa11d6a4Sleibler                    //assigned?
110aa11d6a4Sleibler                    $data['assigned'] = explode(',', $value);
111e0ec7364Sleibler                    // @date 20140317 le: if check for logged in user, also check for logged in user email address
112e0ec7364Sleibler                    if( in_array( '@@USER@@', $data['assigned'] ) ) {
11364d3f721Sleibler                        $data['assigned'][] = '@@MAIL@@';
114e0ec7364Sleibler                    }
115e1d9ed71Seinhirn                    $data['assigned'] = array_map( array($this,"__todolistTrimUser"), $data['assigned'] );
116aa11d6a4Sleibler                    break;
1173bd520d9Srunout-at                case 'completeduser':
1183bd520d9Srunout-at                    $data['completeduserlist'] = explode(',', $value);
1193bd520d9Srunout-at                                        // @date 20140317 le: if check for logged in user, also check for logged in user email address
1203bd520d9Srunout-at                                        if(in_array('@@USER@@', $data['completeduserlist'])) {
1213bd520d9Srunout-at                                                $data['completeduserlist'][] = '@@MAIL@@';
1223bd520d9Srunout-at                                        }
1233bd520d9Srunout-at                    $data['completeduserlist'] = array_map( array($this,"__todolistTrimUser"), $data['completeduserlist'] );
1243bd520d9Srunout-at                    break;
125f1a46b72SMax Westen                case 'ns':
126f1a46b72SMax Westen                    $data['ns'] = $value;
127f1a46b72SMax Westen                    break;
1281a73e155Srunout-at                case 'startbefore':
129a9e1335fSrunout-at                    list($data['startbefore'], $data['startignore']) = $this->analyseDate($value);
1301a73e155Srunout-at                    break;
1311a73e155Srunout-at                case 'startafter':
132a9e1335fSrunout-at                    list($data['startafter'], $data['startignore']) = $this->analyseDate($value);
1331a73e155Srunout-at                    break;
134653a88bcSLeonard                case 'startat':
135653a88bcSLeonard                    list($data['startat'], $data['startignore']) = $this->analyseDate($value);
136653a88bcSLeonard                    break;
1371a73e155Srunout-at                case 'duebefore':
138a9e1335fSrunout-at                    list($data['duebefore'], $data['dueignore']) = $this->analyseDate($value);
1391a73e155Srunout-at                    break;
1401a73e155Srunout-at                case 'dueafter':
141a9e1335fSrunout-at                    list($data['dueafter'], $data['dueignore']) = $this->analyseDate($value);
1421a73e155Srunout-at                    break;
143653a88bcSLeonard                case 'dueat':
144653a88bcSLeonard                    list($data['dueat'], $data['dueignore']) = $this->analyseDate($value);
145653a88bcSLeonard                    break;
146f8513d6bSrunout-at                case 'completedbefore':
147ed5eba0fSeinhirn                    list($data['completedbefore']) = $this->analyseDate($value);
148f8513d6bSrunout-at                    break;
149f8513d6bSrunout-at                case 'completedafter':
150ed5eba0fSeinhirn                    list($data['completedafter']) = $this->analyseDate($value);
151f8513d6bSrunout-at                    break;
152653a88bcSLeonard                case 'completedat':
153653a88bcSLeonard                    list($data['completedat']) = $this->analyseDate($value);
154653a88bcSLeonard                    break;
155aa11d6a4Sleibler             }
156aa11d6a4Sleibler        }
157aa11d6a4Sleibler        return $data;
158aa11d6a4Sleibler    }
159aa11d6a4Sleibler
160aa11d6a4Sleibler    /**
161aa11d6a4Sleibler     * Render xhtml output or metadata
162aa11d6a4Sleibler     *
163aa11d6a4Sleibler     * @param string $mode Renderer mode (supported modes: xhtml)
164aa11d6a4Sleibler     * @param Doku_Renderer $renderer The renderer
165aa11d6a4Sleibler     * @param array $data The data from the handler() function
166aa11d6a4Sleibler     * @return bool If rendering was successful.
167aa11d6a4Sleibler     */
1688038693eSAndreas Gohr    public function render($mode, Doku_Renderer $renderer, $data) {
169aa11d6a4Sleibler        global $conf;
170aa11d6a4Sleibler
171aa11d6a4Sleibler        if($mode != 'xhtml') return false;
172aa11d6a4Sleibler        /** @var Doku_Renderer_xhtml $renderer */
173aa11d6a4Sleibler
174aa11d6a4Sleibler        $opts['pattern'] = '/<todo([^>]*)>(.*)<\/todo[\W]*?>/'; //all todos in a wiki page
175e03fce31Srunout-at        $opts['ns'] = $data['ns'];
176aa11d6a4Sleibler        //TODO check if storing subpatterns doesn't cost too much resources
177aa11d6a4Sleibler
178aa11d6a4Sleibler        // search(&$data, $base,            $func,                       $opts,$dir='',$lvl=1,$sort='natural')
179aa11d6a4Sleibler        search($todopages, $conf['datadir'], array($this, 'search_todos'), $opts); //browse wiki pages with callback to search_pattern
180aa11d6a4Sleibler
181aa11d6a4Sleibler        $todopages = $this->filterpages($todopages, $data);
182*e1fc243eSBraintelligence
183*e1fc243eSBraintelligence        foreach($todopages as &$page) {
184*e1fc243eSBraintelligence			uasort($page['todos'], function($a, $b) {
185*e1fc243eSBraintelligence				if(isset($a['due']) && isset($b['due'])) {
186*e1fc243eSBraintelligence					return $a['due'] <=> $b['due'];
187*e1fc243eSBraintelligence				} else {
188*e1fc243eSBraintelligence					return 0;
189*e1fc243eSBraintelligence				}
190*e1fc243eSBraintelligence			});
191*e1fc243eSBraintelligence		}
192aa11d6a4Sleibler
193d30f06ddSRobin Helgelin        if($data['short']) {
194d30f06ddSRobin Helgelin            $this->htmlShort($renderer, $todopages, $data);
195d30f06ddSRobin Helgelin        } else {
19696468fefSrunout-at            $this->htmlTodoTable($renderer, $todopages, $data);
197d30f06ddSRobin Helgelin        }
198aa11d6a4Sleibler
199aa11d6a4Sleibler        return true;
200aa11d6a4Sleibler    }
201aa11d6a4Sleibler
202aa11d6a4Sleibler    /**
203aa11d6a4Sleibler     * Custom search callback
204aa11d6a4Sleibler     *
205aa11d6a4Sleibler     * This function is called for every found file or
206aa11d6a4Sleibler     * directory. When a directory is given to the function it has to
207aa11d6a4Sleibler     * decide if this directory should be traversed (true) or not (false).
208aa11d6a4Sleibler     * Return values for files are ignored
209aa11d6a4Sleibler     *
210aa11d6a4Sleibler     * All functions should check the ACL for document READ rights
211aa11d6a4Sleibler     * namespaces (directories) are NOT checked (when sneaky_index is 0) as this
212aa11d6a4Sleibler     * would break the recursion (You can have an nonreadable dir over a readable
213aa11d6a4Sleibler     * one deeper nested) also make sure to check the file type (for example
214aa11d6a4Sleibler     * in case of lockfiles).
215aa11d6a4Sleibler     *
216aa11d6a4Sleibler     * @param array &$data  - Reference to the result data structure
217aa11d6a4Sleibler     * @param string $base  - Base usually $conf['datadir']
218aa11d6a4Sleibler     * @param string $file  - current file or directory relative to $base
219aa11d6a4Sleibler     * @param string $type  - Type either 'd' for directory or 'f' for file
220aa11d6a4Sleibler     * @param int    $lvl   - Current recursion depht
221aa11d6a4Sleibler     * @param array  $opts  - option array as given to search()
222aa11d6a4Sleibler     * @return bool if this directory should be traversed (true) or not (false). Return values for files are ignored.
223aa11d6a4Sleibler     */
224aa11d6a4Sleibler    public function search_todos(&$data, $base, $file, $type, $lvl, $opts) {
225aa11d6a4Sleibler        $item['id'] = pathID($file); //get current file ID
226aa11d6a4Sleibler
227aa11d6a4Sleibler        //we do nothing with directories
228aa11d6a4Sleibler        if($type == 'd') return true;
229aa11d6a4Sleibler
230aa11d6a4Sleibler        //only search txt files
231aa11d6a4Sleibler        if(substr($file, -4) != '.txt') return true;
232aa11d6a4Sleibler
233aa11d6a4Sleibler        //check ACL
234aa11d6a4Sleibler        if(auth_quickaclcheck($item['id']) < AUTH_READ) return false;
235aa11d6a4Sleibler
236e03fce31Srunout-at        // filter namespaces
237e03fce31Srunout-at        if(!$this->filter_ns($item['id'], $opts['ns'])) return false;
238e03fce31Srunout-at
239aa11d6a4Sleibler        $wikitext = rawWiki($item['id']); //get wiki text
240aa11d6a4Sleibler
24105dcb4b4Srunout-at        // check if ~~NOTODO~~ is set on the page to skip this page
24205dcb4b4Srunout-at        if(1 == preg_match('/~~NOTODO~~/', $wikitext)) return false;
24305dcb4b4Srunout-at
244aa11d6a4Sleibler        $item['count'] = preg_match_all($opts['pattern'], $wikitext, $matches); //count how many times appears the pattern
245aa11d6a4Sleibler        if(!empty($item['count'])) { //if it appears at least once
246aa11d6a4Sleibler            $item['matches'] = $matches;
247aa11d6a4Sleibler            $data[] = $item;
248aa11d6a4Sleibler        }
249aa11d6a4Sleibler        return true;
250aa11d6a4Sleibler    }
251aa11d6a4Sleibler
252aa11d6a4Sleibler    /**
253e03fce31Srunout-at     * filter namespaces
254e03fce31Srunout-at     *
255e03fce31Srunout-at     * @param $todopages array pages with all todoitems
256e03fce31Srunout-at     * @param $item     string listing parameters
257e03fce31Srunout-at     * @return boolean if item id is in namespace
258e03fce31Srunout-at     */
259e03fce31Srunout-at    private function filter_ns($item, $ns) {
260e03fce31Srunout-at        global $ID;
261e03fce31Srunout-at        // check if we should accept currant namespace+subnamespaces or only subnamespaces
262e03fce31Srunout-at        $wildsubns = substr($ns, -2) == '.:';
263e03fce31Srunout-at        $onlysubns = !$wildsubns && (substr($ns, -1) == ':' || substr($ns, -2) == ':.');
264e03fce31Srunout-at//        $onlyns =  $onlysubns && substr($ns, -1) == '.';
265e03fce31Srunout-at
266e03fce31Srunout-at        // if first char of ns is '.'replace it with current ns
267e03fce31Srunout-at        if ($ns[0] == '.') {
268e03fce31Srunout-at            $ns = substr($ID, 0, strrpos($ID, ':')+1).ltrim($ns, '.:');
269e03fce31Srunout-at        }
270e03fce31Srunout-at        $ns = trim($ns, '.:');
271e03fce31Srunout-at        $len = strlen($ns);
272e03fce31Srunout-at        $parsepage = false;
273e03fce31Srunout-at
274e03fce31Srunout-at        if ($parsepage = $ns == 'all') {
275e03fce31Srunout-at            // Always return the todo pages
276e03fce31Srunout-at        } elseif ($ns == '/') {
277e03fce31Srunout-at            // Only return the todo page if it's in the root namespace
278e03fce31Srunout-at            $parsepage = strpos($item, ':') === FALSE;
279e03fce31Srunout-at        } elseif ($wildsubns) {
280e03fce31Srunout-at            $p = strpos($item.':', ':', $len+1);
281e03fce31Srunout-at            $x = substr($item, $len+1, $p-$len);
282e03fce31Srunout-at            $parsepage = 0 === strpos($item, rtrim($ns.':'.$x, ':').':');
283e03fce31Srunout-at        } elseif ($onlysubns) {
284e03fce31Srunout-at            $parsepage = 0 === strpos($item, $ns.':');
285e03fce31Srunout-at        } elseif ($parsepage = substr($item, 0, $len) == $ns) {
286e03fce31Srunout-at        }
287e03fce31Srunout-at        return $parsepage;
288e03fce31Srunout-at    }
289e03fce31Srunout-at
290e03fce31Srunout-at    /**
2910441172cSeinhirn     * Expand assignee-placeholders
2920441172cSeinhirn     *
2930441172cSeinhirn     * @param $user	String to be worked on
2940441172cSeinhirn     * @return	expanded string
2950441172cSeinhirn     */
2960441172cSeinhirn    private function __todolistExpandAssignees($user) {
2970441172cSeinhirn        global $USERINFO;
2980441172cSeinhirn        if($user == '@@USER@@' && !empty($_SERVER['REMOTE_USER'])) {  //$INPUT->server->str('REMOTE_USER')
2990441172cSeinhirn            return $_SERVER['REMOTE_USER'];
3000441172cSeinhirn        }
3010441172cSeinhirn        // @date 20140317 le: check for logged in user email address
3020441172cSeinhirn        if( $user == '@@MAIL@@' && isset( $USERINFO['mail'] ) ) {
3030441172cSeinhirn            return $USERINFO['mail'];
3040441172cSeinhirn        }
3050441172cSeinhirn        return  $user;
3060441172cSeinhirn    }
3070441172cSeinhirn
3080441172cSeinhirn    /**
309e1d9ed71Seinhirn     * Trim input if it's a user
310e1d9ed71Seinhirn     *
311e1d9ed71Seinhirn     * @param $user	String to be worked on
312e1d9ed71Seinhirn     * @return	trimmed string
313e1d9ed71Seinhirn     */
314e1d9ed71Seinhirn    private function __todolistTrimUser($user) {
315e1d9ed71Seinhirn        //placeholder (inspired by replacement-patterns - see https://www.dokuwiki.org/namespace_templates#replacement_patterns)
316e1d9ed71Seinhirn        if( $user == '@@USER@@' || $user == '@@MAIL@@' ) {
317e1d9ed71Seinhirn            return $user;
318e1d9ed71Seinhirn        }
319e1d9ed71Seinhirn        //user
320e1d9ed71Seinhirn        return trim(ltrim($user, '@'));
321e1d9ed71Seinhirn    }
322e1d9ed71Seinhirn
323e1d9ed71Seinhirn    /**
324aa11d6a4Sleibler     * filter the pages
325aa11d6a4Sleibler     *
326aa11d6a4Sleibler     * @param $todopages array pages with all todoitems
327aa11d6a4Sleibler     * @param $data      array listing parameters
328aa11d6a4Sleibler     * @return array filtered pages
329aa11d6a4Sleibler     */
330aa11d6a4Sleibler    private function filterpages($todopages, $data) {
331aa11d6a4Sleibler        $pages = array();
33239352042Srunout-at        if(count($todopages)>0) {
333dab15545Srunout-at            foreach($todopages as $page) {
334aa11d6a4Sleibler                $todos = array();
335aa11d6a4Sleibler                // contains 3 arrays: an array with complete matches and 2 arrays with subpatterns
336aa11d6a4Sleibler                foreach($page['matches'][1] as $todoindex => $todomatch) {
3379c3e92beSrunout-at                    $todo = array_merge(array('todotitle' => trim($page['matches'][2][$todoindex]),  'todoindex' => $todoindex), $this->parseTodoArgs($todomatch), $data);
338aa11d6a4Sleibler
3399c3e92beSrunout-at                    if($this->isRequestedTodo($todo)) { $todos[] = $todo; }
340aa11d6a4Sleibler                }
341aa11d6a4Sleibler                if(count($todos) > 0) {
342aa11d6a4Sleibler                    $pages[] = array('id' => $page['id'], 'todos' => $todos);
343aa11d6a4Sleibler                }
344aa11d6a4Sleibler            }
345aa11d6a4Sleibler            return $pages;
346aa11d6a4Sleibler        }
34739352042Srunout-at    return null;
34839352042Srunout-at    }
34939352042Srunout-at
350aa11d6a4Sleibler
351d30f06ddSRobin Helgelin    private function htmlShort($R, $todopages, $data) {
352d30f06ddSRobin Helgelin        $done = 0; $todo = 0;
353d30f06ddSRobin Helgelin        foreach($todopages as $page) {
354d30f06ddSRobin Helgelin            foreach($page['todos'] as $value) {
355d30f06ddSRobin Helgelin                $todo++;
356d30f06ddSRobin Helgelin                if ($value['checked']) {
357d30f06ddSRobin Helgelin                    $done++;
358d30f06ddSRobin Helgelin                }
359d30f06ddSRobin Helgelin            }
3602a2b0fb2Srunout-at            return $pages;
361d30f06ddSRobin Helgelin        }
362d30f06ddSRobin Helgelin
363d30f06ddSRobin Helgelin        $R->cdata("($done/$todo)");
364d30f06ddSRobin Helgelin    }
365d30f06ddSRobin Helgelin
366aa11d6a4Sleibler    /**
367aa11d6a4Sleibler     * Create html for table with todos
368aa11d6a4Sleibler     *
369aa11d6a4Sleibler     * @param Doku_Renderer_xhtml $R
370aa11d6a4Sleibler     * @param array $todopages
37196468fefSrunout-at     * @param array $data array with rendering options
372aa11d6a4Sleibler     */
37396468fefSrunout-at    private function htmlTodoTable($R, $todopages, $data) {
374aa11d6a4Sleibler        $R->table_open();
375aa11d6a4Sleibler        foreach($todopages as $page) {
376780e8f87Srunout-at       	    if ($data['header']!='none') {
377aa11d6a4Sleibler                $R->tablerow_open();
378aa11d6a4Sleibler                $R->tableheader_open();
379bce03c8aSrunout-at                $R->internallink($page['id'], ($data['header']=='firstheader' ? p_get_first_heading($page['id']) : $page['id']));
380aa11d6a4Sleibler                $R->tableheader_close();
381aa11d6a4Sleibler                $R->tablerow_close();
382780e8f87Srunout-at       	    }
383aa11d6a4Sleibler            foreach($page['todos'] as $todo) {
3849c3e92beSrunout-at//echo "<pre>";var_dump($todo);echo "</pre>";
385aa11d6a4Sleibler                $R->tablerow_open();
386aa11d6a4Sleibler                $R->tablecell_open();
3875a968c91Srunout-at                $R->doc .= $this->createTodoItem($R, $page['id'], array_merge($todo, $data));
388aa11d6a4Sleibler                $R->tablecell_close();
389aa11d6a4Sleibler                $R->tablerow_close();
390aa11d6a4Sleibler            }
391aa11d6a4Sleibler        }
392aa11d6a4Sleibler        $R->table_close();
393aa11d6a4Sleibler    }
394aa11d6a4Sleibler
395aa11d6a4Sleibler    /**
396aa11d6a4Sleibler     * Check the conditions for adding a todoitem
397aa11d6a4Sleibler     *
398aa11d6a4Sleibler     * @param $data     array the defined filters
399aa11d6a4Sleibler     * @param $checked  bool completion status of task; true: finished, false: open
400aa11d6a4Sleibler     * @param $todouser string user username of user
401aa11d6a4Sleibler     * @return bool if the todoitem should be listed
402aa11d6a4Sleibler     */
4039c3e92beSrunout-at    private function isRequestedTodo($data) {
404aa11d6a4Sleibler        //completion status
405aa11d6a4Sleibler        $condition1 = $data['completed'] === 'all' //all
4069c3e92beSrunout-at                      || $data['completed'] === $data['checked']; //yes or no
407aa11d6a4Sleibler
408aa11d6a4Sleibler        // resolve placeholder in assignees
409aa11d6a4Sleibler        $requestedassignees = array();
410aa11d6a4Sleibler        if(is_array($data['assigned'])) {
4110441172cSeinhirn            $requestedassignees = array_map( array($this,"__todolistExpandAssignees"), $data['assigned'] );
412aa11d6a4Sleibler        }
413aa11d6a4Sleibler        //assigned
4149c3e92beSrunout-at        $condition2 = $condition2
4159c3e92beSrunout-at                        || $data['assigned'] === 'all' //all
4169c3e92beSrunout-at                        || (is_bool($data['assigned']) && $data['assigned'] == $data['todouser']); //yes or no
4179c3e92beSrunout-at
4189c3e92beSrunout-at        if (!$condition2 && is_array($data['assigned']) && is_array($data['todousers']))
4199c3e92beSrunout-at            foreach($data['todousers'] as $todouser) {
4209c3e92beSrunout-at                if(in_array($todouser, $requestedassignees)) { $condition2 = true; break; }
4219c3e92beSrunout-at            }
422aa11d6a4Sleibler
4233bd520d9Srunout-at        //completed by
4243bd520d9Srunout-at        if($condition2 && is_array($data['completeduserlist']))
4253bd520d9Srunout-at            $condition2 = in_array($data['completeduser'], $data['completeduserlist']);
4263bd520d9Srunout-at
4271a73e155Srunout-at        //compare start/due dates
428a9e1335fSrunout-at        if($condition1 && $condition2) {
429a9e1335fSrunout-at            $condition3s = true; $condition3d = true;
430653a88bcSLeonard            if(isset($data['startbefore']) || isset($data['startafter']) || isset($data['startat'])) {
43164495bd0Srunout-at                if(is_object($data['start'])) {
43225916678Srunout-at                    if($data['startignore'] != '!') {
43325916678Srunout-at                        if(isset($data['startbefore'])) { $condition3s = $condition3s && new DateTime($data['startbefore']) > $data['start']; }
43425916678Srunout-at                        if(isset($data['startafter'])) { $condition3s = $condition3s && new DateTime($data['startafter']) < $data['start']; }
435653a88bcSLeonard                        if(isset($data['startat'])) { $condition3s = $condition3s && new DateTime($data['startat']) == $data['start']; }
43625916678Srunout-at                    }
43764495bd0Srunout-at                } else {
43864495bd0Srunout-at                    if(!$data['startignore'] == '*') { $condition3s = false; }
43964495bd0Srunout-at                    if($data['startignore'] == '!') { $condition3s = false; }
44064495bd0Srunout-at                }
441aa11d6a4Sleibler            }
442a9e1335fSrunout-at
443653a88bcSLeonard            if(isset($data['duebefore']) || isset($data['dueafter']) || isset($data['dueat'])) {
44464495bd0Srunout-at                if(is_object($data['due'])) {
44525916678Srunout-at                    if($data['dueignore'] != '!') {
44625916678Srunout-at                        if(isset($data['duebefore'])) { $condition3d = $condition3d && new DateTime($data['duebefore']) > $data['due']; }
44725916678Srunout-at                        if(isset($data['dueafter'])) { $condition3d = $condition3d && new DateTime($data['dueafter']) < $data['due']; }
448653a88bcSLeonard                        if(isset($data['dueat'])) { $condition3d = $condition3d && new DateTime($data['dueat']) == $data['due']; }
44925916678Srunout-at                    }
45064495bd0Srunout-at                 } else {
45164495bd0Srunout-at                    if(!$data['dueignore'] == '*') { $condition3d = false; }
45264495bd0Srunout-at                    if($data['dueignore'] == '!') { $condition3d = false; }
45364495bd0Srunout-at                }
454a9e1335fSrunout-at            }
4553c0225fbSrunout-at            $condition3 = $condition3s && $condition3d;
4563c0225fbSrunout-at        }
457a9e1335fSrunout-at
4583c0225fbSrunout-at        // compare completed date
459f8513d6bSrunout-at        $condition4 = true;
460f8513d6bSrunout-at        if(isset($data['completedbefore'])) {
461f8513d6bSrunout-at            $condition4 = $condition4 && new DateTime($data['completedbefore']) > $data['completeddate'];
462f8513d6bSrunout-at        }
463f8513d6bSrunout-at        if(isset($data['completedafter'])) {
464f8513d6bSrunout-at            $condition4 = $condition4 && new DateTime($data['completedafter']) < $data['completeddate'];
465a9e1335fSrunout-at        }
466653a88bcSLeonard        if(isset($data['completedat'])) {
467653a88bcSLeonard            $condition4 = $condition4 && new DateTime($data['completedat']) == $data['completeddate'];
468653a88bcSLeonard        }
469a9e1335fSrunout-at
470f8513d6bSrunout-at        return $condition1 AND $condition2 AND $condition3 AND $condition4;
471aa11d6a4Sleibler    }
4720d4a1053Srunout-at
47364495bd0Srunout-at
4741a73e155Srunout-at    /**
4751a73e155Srunout-at    * Analyse of relative/absolute Date and return an absolute date
4761a73e155Srunout-at    *
4771a73e155Srunout-at    * @param $date      string  absolute/relative value of the date to analyse
478a9e1335fSrunout-at    * @return           array   absolute date or actual date if $date is invalid
4791a73e155Srunout-at    */
4801a73e155Srunout-at    private function analyseDate($date) {
481a9e1335fSrunout-at        $result = array($date, '');
4821a73e155Srunout-at        if(is_string($date)) {
48364495bd0Srunout-at            if($date == '!') {
48464495bd0Srunout-at               $result = array('', '!');
48564495bd0Srunout-at            } elseif ($date =='*') {
48664495bd0Srunout-at               $result = array('', '*');
48764495bd0Srunout-at            } else {
48864495bd0Srunout-at                if(substr($date, -1) == '*') {
489a9e1335fSrunout-at                    $date = substr($date, 0, -1);
49064495bd0Srunout-at                    $result = array($date, '*');
491a9e1335fSrunout-at                }
49264495bd0Srunout-at
4931a73e155Srunout-at                if(date('Y-m-d', strtotime($date)) == $date) {
494a9e1335fSrunout-at                    $result[0] = $date;
4951a73e155Srunout-at                } elseif(preg_match('/^[\+\-]\d+$/', $date)) { // check if we have a valid relative value
4961a73e155Srunout-at                    $newdate = date_create(date('Y-m-d'));
4971a73e155Srunout-at                    date_modify($newdate, $date . ' day');
498a9e1335fSrunout-at                    $result[0] = date_format($newdate, 'Y-m-d');
4991a73e155Srunout-at                } else {
500a9e1335fSrunout-at                    $result[0] = date('Y-m-d');
5011a73e155Srunout-at                }
5021a73e155Srunout-at            }
50364495bd0Srunout-at        } else { $result[0] = date('Y-m-d'); }
50464495bd0Srunout-at
5051a73e155Srunout-at        return $result;
5061a73e155Srunout-at    }
507a9e1335fSrunout-at
50864495bd0Srunout-at
5091a73e155Srunout-at}
510