[Koha-cvs] Changes to koha/reports/issues_stats.pl [rel_2_2]

[Henri-Damien LAURENT]

Index: koha/reports/issues_stats.pl
diff -u koha/reports/issues_stats.pl:1.7.2.4 
koha/reports/issues_stats.pl:1.7.2.5
--- koha/reports/issues_stats.pl:1.7.2.4        Tue Sep 27 16:19:37 2005
+++ koha/reports/issues_stats.pl        Mon Nov 21 17:12:04 2005
@@ -1,6 +1,6 @@
 #!/usr/bin/perl
 
-# $Id: issues_stats.pl,v 1.7.2.4 2005/09/27 16:19:37 hdl Exp $
+# $Id: issues_stats.pl,v 1.7.2.5 2005/11/21 17:12:04 hdl Exp $
 
 # Copyright 2000-2002 Katipo Communications
 #
@@ -455,7 +455,7 @@
                my ($bookcount) = $rqbookcount->fetchrow;
                $strcalc .= "100*(COUNT(DISTINCT itemnumber))/ $bookcount " ;
        }
-       $strcalc .= "FROM statistics,borrowers where 
(statistics.borrowernumber=borrowers.borrowernumber) ";
+       $strcalc .= "FROM statistics,borrowers,issues where 
(statistics.borrowernumber=borrowers.borrowernumber) and 
issues.borrowernumber=borrowers.borrowernumber and 
issues.itemnumber=statistics.itemnumber ";
 
        @$filters[0]=~ s/\*/%/g if (@$filters[0]);
        $strcalc .= " AND statistics.datetime > '" . @$filters[0] ."'" if ( 
@$filters[0] );