[Top][All Lists]
[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;
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Koha-cvs] CVS: koha/reports issues_stats.pl,1.7.2.2,1.7.2.3,
Henri-Damien LAURENT <=
- Prev by Date:
[Koha-cvs] CVS: koha/koha-tmpl/intranet-tmpl/default/en/reports issues_stats.tmpl,1.4.2.1,1.4.2.2
- Next by Date:
[Koha-cvs] CVS: koha/members memberentry.pl,1.5.2.6,1.5.2.7 member.pl,1.2.2.4,1.2.2.5
- Previous by thread:
[Koha-cvs] CVS: koha/koha-tmpl/intranet-tmpl/default/en/reports issues_stats.tmpl,1.4.2.1,1.4.2.2
- Next by thread:
[Koha-cvs] CVS: koha/members memberentry.pl,1.5.2.6,1.5.2.7 member.pl,1.2.2.4,1.2.2.5
- Index(es):