From d666102916b7db9a93491930b3e039f2756305b3 Mon Sep 17 00:00:00 2001
From: hdl <hdl>
Date: Fri, 14 Oct 2005 09:34:16 +0000
Subject: [PATCH] Adding borrowers branchcode management

---
 reports/issues_by_borrower_category.plugin | 8 +++++---
 1 file changed, 5 insertions(+), 3 deletions(-)

diff --git a/reports/issues_by_borrower_category.plugin b/reports/issues_by_borrower_category.plugin
index c767bb833e..80cd0a30a2 100644
--- a/reports/issues_by_borrower_category.plugin
+++ b/reports/issues_by_borrower_category.plugin
@@ -100,13 +100,15 @@ sub calculate {
 		$itemtypes{$itemtype}->{total} = 0;
 	}
 # now, parse each category. Before filling the result array, fill it with 0 to have every itemtype column.
-	my $sth = $dbh->prepare("SELECT itemtype, count( * )
+	my $strsth="SELECT itemtype, count( * )
 				FROM issues, borrowers, biblioitems, items
 				WHERE issues.borrowernumber = borrowers.borrowernumber 
 					AND items.itemnumber = issues.itemnumber 
 					AND biblioitems.biblionumber = items.biblionumber 
-					AND borrowers.categorycode = ?
-				GROUP BY biblioitems.itemtype");
+					AND borrowers.categorycode = ?";
+	$strsth.= " AND borrowers.branchcode = ".$dbh->quote($branch) if ($branch);
+	$strsth .= " GROUP BY biblioitems.itemtype";
+	my $sth = $dbh->prepare($strsth);
 	my $sthcategories = $dbh->prepare("select categorycode,description from categories");
 	$sthcategories->execute;
 	my %borrowertype;
-- 
2.39.5