From 9c3b0e29ff2baed841e1745c235709eaa7e44094 Mon Sep 17 00:00:00 2001
From: rangi <rangi>
Date: Tue, 30 Aug 2005 02:05:55 +0000
Subject: [PATCH] Fix for the counts being inaccruate

---
 reports/itemtypes.plugin | 7 ++++---
 1 file changed, 4 insertions(+), 3 deletions(-)

diff --git a/reports/itemtypes.plugin b/reports/itemtypes.plugin
index 61f05df719..05f98a3c17 100644
--- a/reports/itemtypes.plugin
+++ b/reports/itemtypes.plugin
@@ -63,12 +63,13 @@ sub calculate {
 	if ($branch) {
 		$sth = $dbh->prepare("select description, biblioitems.itemtype, count(*) as total from itemtypes, biblioitems, items 
 						where biblioitems.itemtype=itemtypes.itemtype 
-							and items.biblionumber=biblioitems.biblionumber
+							and items.biblioitemnumber=biblioitems.biblioitemnumber
 							and items.holdingbranch=?
 						group by biblioitems.itemtype");
 		$sth->execute($branch);
 	} else {
-		$sth = $dbh->prepare("select description, biblioitems.itemtype, count(*) as total from itemtypes, biblioitems where biblioitems.itemtype=itemtypes.itemtype group by biblioitems.itemtype");
+		$sth = $dbh->prepare("select description, biblioitems.itemtype, count(*) as total from itemtypes, biblioitems,items where biblioitems.itemtype=itemtypes.itemtype 
+                                      and biblioitems.biblioitemnumber = items.biblioitemnumber group by biblioitems.itemtype");
 		$sth->execute;
 	}
 	my ($description,$biblioitems,$total);
@@ -96,4 +97,4 @@ sub calculate {
 	return \@mainloop;
 }
 
-1;
\ No newline at end of file
+1;
-- 
2.39.5