[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;