[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) ";