[Koha-cvs] koha/reports acquisitions_stats.pl [rel_2_2]

[Henri-Damien LAURENT]

CVSROOT:	/sources/koha
Module name:	koha
Branch:		rel_2_2
Changes by:	Henri-Damien LAURENT <hdl>	07/02/15 18:32:08

Modified files:
	reports        : acquisitions_stats.pl 

Log message:
	Adding quantities and not counting order lines any longer.

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/reports/acquisitions_stats.pl?cvsroot=koha&only_with_tag=rel_2_2&r1=1.4.2.7&r2=1.4.2.8

Patches:
Index: acquisitions_stats.pl
===================================================================
RCS file: /sources/koha/koha/reports/acquisitions_stats.pl,v
retrieving revision 1.4.2.7
retrieving revision 1.4.2.8
diff -u -b -r1.4.2.7 -r1.4.2.8
--- acquisitions_stats.pl	5 Feb 2006 21:59:21 -0000	1.4.2.7
+++ acquisitions_stats.pl	15 Feb 2007 18:32:07 -0000	1.4.2.8
@@ -1,6 +1,6 @@
 #!/usr/bin/perl
 
-# $Id: acquisitions_stats.pl,v 1.4.2.7 2006/02/05 21:59:21 kados Exp $
+# $Id: acquisitions_stats.pl,v 1.4.2.8 2007/02/15 18:32:07 hdl Exp $
 
 # Copyright 2000-2002 Katipo Communications
 #
@@ -438,7 +438,7 @@
 # preparing calculation
 	my $strcalc ;
 	$strcalc .= "SELECT $linefield, $colfield, ";
-	$strcalc .= "COUNT( aqorders.ordernumber ) " if ($process ==1);
+	$strcalc .= "SUM( aqorders.quantity ) " if ($process ==1);
 	$strcalc .= "SUM( aqorders.quantity * aqorders.listprice ) " if ($process ==2);
 	$strcalc .= "FROM aqorders, aqbasket,aqorderbreakdown left join aqorderdelivery on (aqorders.ordernumber =aqorderdelivery.ordernumber ) left join aqbooksellers on (aqbasket.booksellerid=aqbooksellers.id) where (aqorders.basketno=aqbasket.basketno) and (aqorderbreakdown.ordernumber=aqorders.ordernumber) ";