aboutsummaryrefslogtreecommitdiffstats
path: root/perllib/FixMyStreet/App/Controller/Reports.pm
diff options
context:
space:
mode:
authorMatthew Somerville <matthew@mysociety.org>2013-01-08 16:00:44 +0000
committerMatthew Somerville <matthew@mysociety.org>2013-01-08 16:16:02 +0000
commit4e8afc117eae6d315392fcd2d12bc38a8330bd14 (patch)
tree1924fa84607f32f7ac8751f60e4b27ae50fc0890 /perllib/FixMyStreet/App/Controller/Reports.pm
parentee8d80ddaa0cf1cd82db8741b45692091fed5544 (diff)
Update database fetching to fetch needed data for previous commit.
Diffstat (limited to 'perllib/FixMyStreet/App/Controller/Reports.pm')
-rw-r--r--perllib/FixMyStreet/App/Controller/Reports.pm4
1 files changed, 2 insertions, 2 deletions
diff --git a/perllib/FixMyStreet/App/Controller/Reports.pm b/perllib/FixMyStreet/App/Controller/Reports.pm
index bf65fe1d5..eab308054 100644
--- a/perllib/FixMyStreet/App/Controller/Reports.pm
+++ b/perllib/FixMyStreet/App/Controller/Reports.pm
@@ -374,7 +374,7 @@ sub load_and_group_problems : Private {
{ confirmed => { extract => 'epoch from confirmed' } },
{ whensent => { extract => 'epoch from whensent' } },
{ lastupdate => { extract => 'epoch from lastupdate' } },
- { photo => 'photo is not null' },
+ 'photo', 'extra',
],
order_by => { -desc => 'lastupdate' },
rows => $c->cobrand->reports_per_page,
@@ -384,7 +384,7 @@ sub load_and_group_problems : Private {
$problems = $problems->cursor; # Raw DB cursor for speed
my ( %problems, @pins );
- my @cols = ( 'id', 'bodies_str', 'state', 'areas', 'latitude', 'longitude', 'title', 'cobrand', 'confirmed', 'whensent', 'lastupdate', 'photo' );
+ my @cols = ( 'id', 'bodies_str', 'state', 'areas', 'latitude', 'longitude', 'title', 'cobrand', 'confirmed', 'whensent', 'lastupdate', 'photo', 'extra' );
while ( my @problem = $problems->next ) {
my %problem = zip @cols, @problem;
$problem{is_fixed} = FixMyStreet::DB::Result::Problem->fixed_states()->{$problem{state}};