aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorStruan Donald <struan@exo.org.uk>2020-03-06 18:11:35 +0000
committerStruan Donald <struan@exo.org.uk>2020-03-09 11:37:43 +0000
commit630ad091519dff8aa9371502005fbb788d349632 (patch)
tree8f066e900f9128aadd739d2ed87283dd7601c2cd
parent07bcfacab98ce6167b54ff6f611e0ad75486f5e8 (diff)
order unsent reports in admin summary by confirmed
Make it a bit easier to see if any reports have been sitting unsent for some time
-rw-r--r--CHANGELOG.md2
-rw-r--r--perllib/FixMyStreet/App/Controller/Admin.pm3
2 files changed, 5 insertions, 0 deletions
diff --git a/CHANGELOG.md b/CHANGELOG.md
index 81977b14e..16b8a032b 100644
--- a/CHANGELOG.md
+++ b/CHANGELOG.md
@@ -1,6 +1,8 @@
## Releases
* Unreleased
+ - Admin improvements:
+ - order unsent reports by confirmed date
* v3.0 (4th March 2020)
- Security:
diff --git a/perllib/FixMyStreet/App/Controller/Admin.pm b/perllib/FixMyStreet/App/Controller/Admin.pm
index 047d15fe3..bd45ad55e 100644
--- a/perllib/FixMyStreet/App/Controller/Admin.pm
+++ b/perllib/FixMyStreet/App/Controller/Admin.pm
@@ -73,6 +73,9 @@ sub index : Path : Args(0) {
bodies_str => { '!=', undef },
# Ignore very recent ones that probably just haven't been sent yet
confirmed => { '<', \"current_timestamp - '5 minutes'::interval" },
+ },
+ {
+ order_by => 'confirmed',
} )->all;
$c->stash->{unsent_reports} = \@unsent;