]> git.koha-community.org Git - koha.git/commit
Bug 33761: Alter query to remove items with active transfers from available list
authorNick Clemens <nick@bywatersolutions.com>
Thu, 18 May 2023 11:09:18 +0000 (11:09 +0000)
committerTomas Cohen Arazi <tomascohen@theke.io>
Thu, 18 May 2023 13:54:28 +0000 (10:54 -0300)
commitd95312328dc83aa98728ac77ef55104ea820adfd
tree9694a4c22f5f857f6927d194c8bed2b5379626db
parent67e9356deab73d52fd5b3256b8bbbcd92ec61a34
Bug 33761: Alter query to remove items with active transfers from available list

Current code removes all items without an active transfer, and any with completed transfers.

This patch moves the conditionals for transfers into the join, then adds a new
condition to remove items with active transfers.

To test:
1 - Apply unit test patch only
2 - prove -v t/db_dependent/HoldsQueue.t
3 - It fails
4 - Apply second patch
5 - prove -v t/db_dependent/HoldsQueue.t
6 - Success!

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
C4/HoldsQueue.pm