[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