From 4274a2f51dcf0e7ee0dfebc805036ddbc7f3e4fa Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Sun, 20 Oct 2019 10:16:51 +0200
Subject: [PATCH] Bug 18743: Correct number of pending suggestions (acq home
 page)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

This patch could be moved to its own bug report if we want to adjust
tests.

Sponsored-by: BULAC - http://www.bulac.fr/
Signed-off-by: Séverine QUEUNE <severine.queune@bulac.fr>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
---
 C4/Suggestions.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/C4/Suggestions.pm b/C4/Suggestions.pm
index 15b02c51fa..764c331752 100644
--- a/C4/Suggestions.pm
+++ b/C4/Suggestions.pm
@@ -414,7 +414,7 @@ sub CountSuggestion {
             FROM suggestions
                 LEFT JOIN borrowers ON borrowers.borrowernumber=suggestions.suggestedby
             WHERE STATUS=?
-                AND (borrowers.branchcode='' OR borrowers.branchcode=?)
+                AND (suggestions.branchcode='' OR suggestions.branchcode=?)
         };
         $sth = $dbh->prepare($query);
         $sth->execute( $status, $userenv->{branch} );
-- 
2.39.5