[Open311] Proper bodies check for sending updates.

Otherwise running on a site where one body ID is a substring
of another, comments can get processed for the wrong body.

1 files changed, 1 insertions, 3 deletions

diff --git a/perllib/Open311/PostServiceRequestUpdates.pm b/perllib/Open311/PostServiceRequestUpdates.pm
index e2172c028..c8ff2130f 100755
--- a/perllib/Open311/PostServiceRequestUpdates.pm
+++ b/perllib/Open311/PostServiceRequestUpdates.pm
@@ -52,18 +52,16 @@ sub process_body {
 
     my $o = Open311->new( $self->open311_params($body) );
 
-    my $comments = FixMyStreet::DB->resultset('Comment')->search( {
+    my $comments = FixMyStreet::DB->resultset('Comment')->to_body($body)->search( {
             'me.whensent' => undef,
             'me.external_id' => undef,
             'me.state' => 'confirmed',
             'me.confirmed' => { '!=' => undef },
             'problem.whensent' => { '!=' => undef },
             'problem.external_id' => { '!=' => undef },
-            'problem.bodies_str' => { -like => '%' . $body->id . '%' },
             'problem.send_method_used' => { -like => '%Open311%' },
         },
         {
-            join => 'problem',
             order_by => [ 'confirmed', 'id' ],
         }
     );