[Koha-cvs] CVS: koha/reports issues_stats.pl,1.7.2.2,1.7.2.3
Henri-Damien LAURENT
hdl at users.sourceforge.net
Fri Sep 9 10:50:24 CEST 2005
Update of /cvsroot/koha/koha/reports
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19126/reports
Modified Files:
Tag: rel_2_2
issues_stats.pl
Log Message:
Adding count items/Count borrowers to stats on issues for statistics.
Index: issues_stats.pl
===================================================================
RCS file: /cvsroot/koha/koha/reports/issues_stats.pl,v
retrieving revision 1.7.2.2
retrieving revision 1.7.2.3
diff -C2 -r1.7.2.2 -r1.7.2.3
*** issues_stats.pl 7 Apr 2005 12:18:43 -0000 1.7.2.2
--- issues_stats.pl 9 Sep 2005 08:50:21 -0000 1.7.2.3
***************
*** 444,448 ****
--- 444,454 ----
$strcalc .= "SELECT $linefield, $colfield, ";
$strcalc .= "COUNT( * ) " if ($process ==1);
+ if ($process ==2){
+ $strcalc .= "(COUNT(DISTINCT borrowers.borrowernumber))" ;
+ }
if ($process ==3){
+ $strcalc .= "(COUNT(DISTINCT itemnumber))" ;
+ }
+ if ($process ==4){
my $rqbookcount = $dbh->prepare("SELECT count(*) FROM items");
$rqbookcount->execute;
More information about the Koha-cvs
mailing list