Bug 25223: Make join of aqbasket and aqorders explicit
authorNick Clemens <nick@bywatersolutions.com>
Mon, 20 Apr 2020 18:41:37 +0000 (18:41 +0000)
committerLucas Gass <lucas@bywatersolutions.com>
Thu, 14 May 2020 18:07:29 +0000 (18:07 +0000)
commit896f4bcf24b9f4ccc4aaeeb84eb86f2f84242352
tree83bb0164e14b9dbf00510e311606a7155f8429e1
parent79da96c9d204c62aaed3ea3df6a91577c382f649
Bug 25223: Make join of aqbasket and aqorders explicit

This is simply a SQL change that makes things a bit easier to read
and also prevents too much data being returned in a large system

To test:
1 - Have some orders in your system in the ordered status
2 - Click the 'Ordered' amount for your budget from Acquisitions home
3 - Note the view of orders, possibly screen shot
4 - Apply patch
5 - Restart all the things
6 - Reload the ordered page
7 - Confirm nothing has changed

Signed-off-by: David Nind <david@davidnind.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Joy Nelson <joy@bywatersolutions.com>
(cherry picked from commit 7d69c0f10c7cb6c8b11baf55f05256684cdb0966)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
acqui/ordered.pl