[Koha-patches] [PATCH] Bug 1953 [3/6]: refactoring to remove superfluous where clause.

[Galen Charlton]

From: Andrew Moore <andrew.moore at liblime.com>

refactored the SQL query to remove a confusing and superfluous 'WHERE 1' clause.

Signed-off-by: Galen Charlton <galen.charlton at liblime.com>
---
 C4/Koha.pm |   11 ++++++++---
 1 files changed, 8 insertions(+), 3 deletions(-)

diff --git a/C4/Koha.pm b/C4/Koha.pm
index 5a7fe4d..b5f6f91 100644
--- a/C4/Koha.pm
+++ b/C4/Koha.pm
@@ -891,17 +891,22 @@ sub displayServers {
     my ( $position, $type ) = @_;
     my $dbh    = C4::Context->dbh;
 
-    my $strsth = "SELECT * FROM z3950servers where 1";
+    my $strsth = 'SELECT * FROM z3950servers';
+    my @where_clauses;
     my @bind_params;
 
     if ( $position ) {
         push @bind_params, $position;
-        $strsth .= ' AND position = ? ';
+        push @where_clauses, ' position = ? ';
     }
 
     if ( $type ) {
         push @bind_params, $type;
-        $strsth .= ' AND type = ? ';
+        push @where_clauses, ' type = ? ';
+    }
+
+    if ( @where_clauses ) {
+        $strsth .= ' WHERE ' . join( ' AND ', @where_clauses );
     }
 
     my $rq = $dbh->prepare($strsth);
-- 
1.5.5.GIT