@@ -, +, @@ - Create orders for different basket and using different funds - Receive some of them - Hit the ordered and spent pages (from the acqui home page) --- acqui/ordered.pl | 8 +++++++- acqui/spent.pl | 14 +++++++++++++- 2 files changed, 20 insertions(+), 2 deletions(-) --- a/acqui/ordered.pl +++ a/acqui/ordered.pl @@ -74,7 +74,13 @@ WHERE (datecancellationprinted IS NULL OR datecancellationprinted='0000-00-00') AND (quantity > quantityreceived OR quantityreceived IS NULL) - GROUP BY aqorders.ordernumber + GROUP BY aqorders.biblionumber, aqorders.basketno, aqorders.ordernumber, + tleft, + ecost, budgetdate, entrydate, + aqbasket.booksellerid, + aqbooksellers.name, + itype, + title EOQ my $sth = $dbh->prepare($query); --- a/acqui/spent.pl +++ a/acqui/spent.pl @@ -83,7 +83,19 @@ WHERE (datecancellationprinted IS NULL OR datecancellationprinted='0000-00-00') AND datereceived IS NOT NULL - GROUP BY aqorders.ordernumber + GROUP BY aqorders.biblionumber, aqorders.basketno, aqorders.ordernumber, + tleft, + ecost, budgetdate, entrydate, + aqbasket.booksellerid, + itype, + title, + aqorders.invoiceid, + aqinvoices.invoicenumber, + quantityreceived, + unitprice, + datereceived, + aqbooksellers.name + EOQ my $sth = $dbh->prepare($query); $sth->execute($bookfund); --