diff options
author | Chris Mytton <self@hecticjeff.net> | 2013-09-13 12:12:14 +0100 |
---|---|---|
committer | Chris Mytton <self@hecticjeff.net> | 2013-09-13 12:12:14 +0100 |
commit | b44f9edab53f59fb442e5ee4db28cb25408c652c (patch) | |
tree | e7cd62bd148a5332e1ec625dda6c3bc6b09ceb62 /perllib/FixMyStreet/App/Controller/JSON.pm | |
parent | 2099ac31a4410f2cf8e1c7d31dc35cdd9ac1e070 (diff) | |
parent | 94ac7786132a538a5742ba325eb7fe9eff89cfc9 (diff) |
Merge branch 'master' into oxfordshire-usability-recommendations
Diffstat (limited to 'perllib/FixMyStreet/App/Controller/JSON.pm')
-rw-r--r-- | perllib/FixMyStreet/App/Controller/JSON.pm | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/perllib/FixMyStreet/App/Controller/JSON.pm b/perllib/FixMyStreet/App/Controller/JSON.pm index 1a7c1915b..17507a84b 100644 --- a/perllib/FixMyStreet/App/Controller/JSON.pm +++ b/perllib/FixMyStreet/App/Controller/JSON.pm @@ -8,6 +8,7 @@ use JSON; use DateTime; use DateTime::Format::ISO8601; use List::MoreUtils 'uniq'; +use FixMyStreet::App; =head1 NAME @@ -80,11 +81,13 @@ sub problems : Local { $date_col = 'lastupdate'; } + my $dt_parser = FixMyStreet::App->model('DB')->schema->storage->datetime_parser; + my $one_day = DateTime::Duration->new( days => 1 ); my $query = { $date_col => { - '>=' => $start_dt, - '<=' => $end_dt + $one_day, + '>=' => $dt_parser->format_datetime($start_dt), + '<=' => $dt_parser->format_datetime($end_dt + $one_day), }, state => [ @state ], }; |