[Koha-bugs] [Bug 35641] Reduce DB calls when performing inventory on a list of barcodes

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35641

--- Comment #1 from Nick Clemens <nick at bywatersolutions.com> ---
Created attachment 160241
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=160241&action=edit
Bug 35641: Reduce DB lookups when sending a list of barcodes to inventory

This patch does three things:
1 - Removes a specific query for withdrawn status of each item scanned - we can
use the withdrawn field
2 - Removes a specific query for checkouts on each item scanned - we can use
the onloan field
    a - additionally we don't need to fetch the checkout as we check it in to
the homebranch,
    this is likely incorrect - we should use the current branch, but I preserve
behavior for now
3 - Fetches the items ahead of time and builds a hash based on barcode, reduces
DB lookups, may raise memory usage

To test:
1 - Checkout some items
2 - Withdraw some items
3 - Generate a lsit of barcodes including some checked out items and some
withdrawn items
4 - Enter that list of barcodes into inventory tool
5 - Note your results
6 - Apply patch
7 - Issue the items again
8 - Repeat inventory
9 - Confirm results are the same as before patch

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.