Allow bodies to span multiple area IDs, and areas can be covered by more than one body.

1 files changed, 17 insertions, 0 deletions

diff --git a/perllib/FixMyStreet/DB/ResultSet/Body.pm b/perllib/FixMyStreet/DB/ResultSet/Body.pm
new file mode 100644
index 000000000..6802ed604
--- /dev/null
+++ b/perllib/FixMyStreet/DB/ResultSet/Body.pm
@@ -0,0 +1,17 @@
+package FixMyStreet::DB::ResultSet::Body;
+use base 'DBIx::Class::ResultSet';
+
+use strict;
+use warnings;
+
+sub for_areas {
+    my ( $rs, @areas ) = @_;
+
+    my $result = $rs->search(
+        { 'body_areas.area_id' => \@areas },
+        { join => 'body_areas' }
+    );
+    return $result;
+}
+
+1;