(bug #3080) fix the acqui/spent.pl
authorNahuel ANGELINETTI <nahuel.angelinetti@biblibre.com>
Wed, 1 Apr 2009 12:43:47 +0000 (14:43 +0200)
committerHenri-Damien LAURENT <henridamien.laurent@biblibre.com>
Tue, 26 May 2009 19:15:31 +0000 (21:15 +0200)
this patch fix the sql request used in spent.pl

acqui/spent.pl

index f73537b..af6f1ea 100755 (executable)
@@ -33,7 +33,7 @@ my $query =
     quantity-quantityreceived as tleft,
     aqorders.ordernumber
     as ordnum,entrydate,budgetdate,booksellerid,aqbasket.basketno
-    from aqorders,aqorderbreakdown,aqbasket 
+    from aqorderbreakdown,aqbasket,aqorders
     left join biblioitems on  biblioitems.biblioitemnumber=aqorders.biblioitemnumber 
     where bookfundid=? and
     aqorders.ordernumber=aqorderbreakdown.ordernumber and