diff options
| author | Struan Donald <struan@exo.org.uk> | 2011-06-07 17:34:08 +0100 |
|---|---|---|
| committer | Struan Donald <struan@exo.org.uk> | 2011-06-07 17:34:08 +0100 |
| commit | 5813d21b9ac8b358a557ab67722e8b54c769b663 (patch) | |
| tree | d8d81597e1abf13855d27dd1b3a5353ca2f3240c /perllib/FixMyStreet/DB/ResultSet/Problem.pm | |
| parent | 0f7de6563d4c96fa1ec9c429cca7e42259e25422 (diff) | |
move summary count fetching out to result sets
Diffstat (limited to 'perllib/FixMyStreet/DB/ResultSet/Problem.pm')
| -rw-r--r-- | perllib/FixMyStreet/DB/ResultSet/Problem.pm | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/perllib/FixMyStreet/DB/ResultSet/Problem.pm b/perllib/FixMyStreet/DB/ResultSet/Problem.pm index 8d798a7c1..835ab1b45 100644 --- a/perllib/FixMyStreet/DB/ResultSet/Problem.pm +++ b/perllib/FixMyStreet/DB/ResultSet/Problem.pm @@ -27,4 +27,17 @@ sub timeline { ); } +sub summary_count { + my ( $rs, $restriction ) = @_; + + return $rs->search( + $restriction, + { + group_by => ['state'], + select => [ 'state', { count => 'id' } ], + as => [qw/state state_count/] + } + ); +} + 1; |