koha-cvs
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Koha-cvs] CVS: koha/reports issues_stats.pl,1.7.2.2,1.7.2.3


From: Henri-Damien LAURENT
Subject: [Koha-cvs] CVS: koha/reports issues_stats.pl,1.7.2.2,1.7.2.3
Date: Fri, 09 Sep 2005 01:50:24 -0700

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;




reply via email to

[Prev in Thread] Current Thread [Next in Thread]