advanced date filters

[cjohnsonuk]

My schema for storing document information contains a "review date".
I can show all documents with no review date using:

---- struct table ----
schema: datainventory
cols: %pageid%, name, description, purpose,lastaudit
filter:lastaudit=
----

I'd like to be able to show a table of all documents that are overdue for a review and this seems to work

---- struct table ----
schema: datainventory
cols: %pageid%, name, description, purpose,lastaudit
filter:lastaudit<$TODAY$
----

I'd like to be able to show a table of all documents with an review date in the next month. Something like:

---- struct table ----
schema: datainventory
cols: %pageid%, name, description, purpose,lastaudit
filter:lastaudit<dateadd($TODAY$, 30 days)
----

Although I'd be happy with being able to define new variables like $TODAY$ called
$TOMORROW$, $IN7DAYS$, $IN30DAYS$ etc

[cjohnsonuk]

OK! I think I've found a way...
Editing
lib/plugins/struct/meta/SearchConfig.php

I changed the protected function applyFilterVars to be :

 protected function applyFilterVars($filter) {
        global $INFO;

        // apply inexpensive filters first
       $filter = str_replace(
            array(
                '$ID$',
                '$NS$',
                '$PAGE$',
                '$USER$',
                '$TODAY$',

                '$TOMORROW$',
                '$NEXTWEEK$',
                '$ENDOFWEEK$',
                '$NEXTMONTH$',
                '$ENDOFMONTH$',
                '$NEXTYEAR$',
                '$ENDOFYEAR$',

                '$YESTERDAY$',
                '$LASTWEEK$',
                '$ENDOFLASTWEEK$',
                '$LASTMONTH$',
                '$LASTYEAR$'

            ),
            array(
                $INFO['id'],
                getNS($INFO['id']),
                noNS($INFO['id']),
                isset($_SERVER['REMOTE_USER']) ? $_SERVER['REMOTE_USER'] : '',
                date('Y-m-d'),

                date('Y-m-d',mktime(0, 0, 0, date("m")  , date("d")+1, date("Y"))),
                date('Y-m-d',mktime(0, 0, 0, date("m")  , date("d")+7, date("Y"))),
                date('Y-m-d',strtotime('next saturday',strtotime(date('Y-m-d')))),
                date('Y-m-d',mktime(0, 0, 0, date("m")+1  , date("d"), date("Y"))),
                date('Y-m-d',mktime(0, 0, 0, date("m")+1, "1",   date("Y"))),
                date('Y-m-d',mktime(0, 0, 0, date("m"),   date("d"),   date("Y")+1)),
                date('Y-m-d',mktime(0, 0, 0, "12",   "31",   date("Y"))),

                date('Y-m-d',mktime(0, 0, 0, date("m")  , date("d")-1, date("Y"))),
                date('Y-m-d',mktime(0, 0, 0, date("m")  , date("d")-7, date("Y"))),
                date('Y-m-d',strtotime('last saturday',strtotime(date('Y-m-d')))),
                date('Y-m-d',mktime(0, 0, 0, date("m"), "1",   date("Y"))),
                date('Y-m-d',mktime(0, 0, 0, date("m"),   date("d"),   date("Y")+1)),
                date('Y-m-d',mktime(0, 0, 0, "1",   "1",   date("Y")))

            ),

          $filter
        );

which, although the dates might not be completely accurate is enough for me at the moment. I'm sure that someone would be able to make this code a little nicer and the date limits work better (eg end of month I've actually put as first of next month to save working out if the month has 28,29,30 or 31 days)
It also assumes that Saturday is the end of the week.

[splitbrain]

I like the idea, but precalculating all those dates and assigning them to variables seems weird. I think it would make more sense to natively support strtotime strings for date comparisons.

Then you could use filter: lastaudit < "+30 days" or filter: lastaudit < "next Thursday" .

[cjohnsonuk]

My coding stretches as far as adding additional variables but not as far as accepting, validating and executing strtotime strings. I agree that your solution would be preferable. I seem to remember looking for this in the plugin to show tasks overdue by more than [7days] or tasks due in the next [7days] rather than just upcoming and overdue.