[Koha-cvs] CVS: koha/reports itemtypes.plugin,1.2,1.3

[Chris Cormack]

Update of /cvsroot/koha/koha/reports
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv7864

Modified Files:
	itemtypes.plugin 
Log Message:
Fix for the counts being inaccruate


Index: itemtypes.plugin
===================================================================
RCS file: /cvsroot/koha/koha/reports/itemtypes.plugin,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** itemtypes.plugin	4 May 2005 09:02:40 -0000	1.2
--- itemtypes.plugin	30 Aug 2005 02:05:55 -0000	1.3
***************
*** 64,73 ****
  		$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.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->execute;
  	}
--- 64,74 ----
  		$sth = $dbh->prepare("select description, biblioitems.itemtype, count(*) as total from itemtypes, biblioitems, items 
  						where biblioitems.itemtype=itemtypes.itemtype 
! 							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,items where biblioitems.itemtype=itemtypes.itemtype 
!                                       and biblioitems.biblioitemnumber = items.biblioitemnumber group by biblioitems.itemtype");
  		$sth->execute;
  	}
***************
*** 97,99 ****
  }
  
! 1;
\ No newline at end of file
--- 98,100 ----
  }
  
! 1;