[Koha-cvs] Changes to koha/reports/issues_stats.pl [rel_2_2]
paul poulain
paul at koha-fr.org
Thu Dec 1 15:01:18 CET 2005
Index: koha/reports/issues_stats.pl
diff -u koha/reports/issues_stats.pl:1.7.2.6 koha/reports/issues_stats.pl:1.7.2.7
--- koha/reports/issues_stats.pl:1.7.2.6 Mon Nov 28 10:49:24 2005
+++ koha/reports/issues_stats.pl Thu Dec 1 14:01:17 2005
@@ -1,6 +1,6 @@
#!/usr/bin/perl
-# $Id: issues_stats.pl,v 1.7.2.6 2005/11/28 10:49:24 hdl Exp $
+# $Id: issues_stats.pl,v 1.7.2.7 2005/12/01 14:01:17 tipaul Exp $
# Copyright 2000-2002 Katipo Communications
#
@@ -455,7 +455,7 @@
my ($bookcount) = $rqbookcount->fetchrow;
$strcalc .= "100*(COUNT(DISTINCT issues.itemnumber))/ $bookcount " ;
}
- $strcalc .= "FROM statistics,borrowers,issues where (statistics.borrowernumber=borrowers.borrowernumber) and issues.borrowernumber=borrowers.borrowernumber and issues.itemnumber=statistics.itemnumber ";
+ $strcalc .= "FROM statistics,borrowers where (statistics.borrowernumber=borrowers.borrowernumber) ";
@$filters[0]=~ s/\*/%/g if (@$filters[0]);
$strcalc .= " AND statistics.datetime > '" . @$filters[0] ."'" if ( @$filters[0] );
More information about the Koha-cvs
mailing list