lib/CrashTest/Controller/CrashGroups.pm
changeset 121 5a99941ed0ca
parent 102 396528bdb9ad
child 122 8692800ec9ba
--- a/lib/CrashTest/Controller/CrashGroups.pm	Sun Dec 04 01:16:39 2016 +0100
+++ b/lib/CrashTest/Controller/CrashGroups.pm	Sun Dec 18 20:14:31 2016 +0100
@@ -24,7 +24,13 @@
     $self->validation->required('page')->like(qr/^[0-9]+$/);
     $page = scalar $self->validation->param("page") if $self->validation->is_valid('page');
 
-    my ($results, $pager) = $self->crash_groups->index($page, $crashs_per_page, $self->req->param('search'));
+    my ($results, $pager, $err) = $self->crash_groups->index($page, $crashs_per_page, $self->req->param('search'));
+
+    if($err) {
+        $self->app->log->info($err);
+        $self->stash(error => "Syntax error in search string: $err");
+    }
+
 
     #$self->app->log->debug(dumper $results);
 
@@ -51,12 +57,17 @@
 
     my $search = $self->req->param('search');
     if(defined($search) && $search ne "") {
-        $search .= " AND " . "group_id=$group->{id}";
+        $search = "(" . $search . ") AND " . "group_id=$group->{id}";
     } else {
         $search = "group_id=$group->{id}";
     }
 
-    my ($results, $pager) = $self->crash_reports->index($page, $crashs_per_page, $search);
+    my ($results, $pager, $err) = $self->crash_reports->index($page, $crashs_per_page, $search);
+
+    if($err) {
+        $self->app->log->info($err);
+        $self->stash(warning => "Syntax error in search string: $err");
+    }
 
     #$self->app->log->debug(dumper $results);