@@ -, +, @@ 1) Log into staff client 2) Acquisitions 3) Click 'Search' in the 'Manage orders' box. 4) Click '+ New basket' beside a vendor name. 5) Type 'Test Basket' into basket name. 6) Click 'Save' 7) Click 'Add to basket' 8) Click 'From an external source' 9) Type 'Green Eggs and Ham' into the Title text box. 'Accounting details' box. basket group. between the number and the currency. (e.g. Total: 0USD) NOTE: The space issue is fixed in Bug 9654. This can be applied separately from that bug. --- C4/Acquisition.pm | 16 ++++++++++++---- 1 file changed, 12 insertions(+), 4 deletions(-) --- a/C4/Acquisition.pm +++ a/C4/Acquisition.pm @@ -815,10 +815,18 @@ Returns a reference to all baskets that belong to basketgroup $basketgroupid. sub GetBasketsByBasketgroup { my $basketgroupid = shift; my $query = qq{ - SELECT *, aqbasket.booksellerid as booksellerid - FROM aqbasket - LEFT JOIN aqcontract USING(contractnumber) WHERE basketgroupid=? - }; + SELECT aqbasket.*, aqcontract.contractnumber, + aqcontract.contractstartdate, + aqcontract.contractenddate, + aqcontract.contractname, + aqcontract.contractdescription, + aqbooksellers.invoiceprice + FROM aqbasket + LEFT JOIN aqbooksellers + ON aqbasket.booksellerid=aqbooksellers.id + LEFT JOIN aqcontract USING(contractnumber) + WHERE basketgroupid=? + }; my $dbh = C4::Context->dbh; my $sth = $dbh->prepare($query); $sth->execute($basketgroupid); --