From 7bd7c514e490e0034fcb7b272e5b49e2af231ed0 Mon Sep 17 00:00:00 2001
From: hdl <hdl>
Date: Tue, 26 Jul 2005 17:01:11 +0000
Subject: [PATCH] Adding branch Independancy support for searchsugestion.

---
 C4/Suggestions.pm | 18 +++++++++++++++---
 1 file changed, 15 insertions(+), 3 deletions(-)

diff --git a/C4/Suggestions.pm b/C4/Suggestions.pm
index 2664de97aa..06fc9973b6 100644
--- a/C4/Suggestions.pm
+++ b/C4/Suggestions.pm
@@ -108,6 +108,14 @@ sub searchsuggestion  {
 		push @sql_params,$status;
 		$query .= " and status=?";
 	}
+	
+	if (C4::Context->preference("IndependantBranches")) {
+		my $userenv = C4::Context->userenv;
+		unless ($userenv->{flags} == 1){
+			push @sql_params,$userenv->{branch};
+			$query .= " and (U1.branchcode = ? or U1.branchcode ='')";
+		}
+	}
 	if ($suggestedbyme) {
 		if ($suggestedbyme eq -1) {
 		} else {
@@ -168,9 +176,13 @@ sub countsuggestion {
 	my $sth;
 	if (C4::Context->preference("IndependantBranches")){
 		my $userenv = C4::Context->userenv;
-		warn "IndependantBranches : Count Suggestions : ".$userenv->{branch};
-		$sth = $dbh->prepare("select count(*) from suggestions,borrowers where status=? and borrowers.borrowernumber=suggestions.suggestedby and (borrowers.branchcode='' or borrowers.branchcode =?)");
-		$sth->execute($status,$userenv->{branch});
+		if ($userenv->{flags} == 1){
+			$sth = $dbh->prepare("select count(*) from suggestions where status=?");
+			$sth->execute($status);
+		} else {
+			$sth = $dbh->prepare("select count(*) from suggestions,borrowers where status=? and borrowers.borrowernumber=suggestions.suggestedby and (borrowers.branchcode='' or borrowers.branchcode =?)");
+			$sth->execute($status,$userenv->{branch});
+		}
 	} else {
 		$sth = $dbh->prepare("select count(*) from suggestions where status=?");
 		$sth->execute($status);
-- 
2.39.5