Bug 38700

Summary: Add items table field to record transfer status
Product: Koha Reporter: Andrew Fuerste-Henry <andrew>
Component: DatabaseAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: hebah
Version: Main   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Andrew Fuerste-Henry 2024-12-13 15:42:14 UTC
Checking whether or not an item is currently in-transit using SQL is more complicated than one would like. We know an item is currently in-transit if there is a line in branchtransfers with that itemnumber, with a date sent, and without either a date cancelled or a date received.

I suggest we add a field to items that would work like items.onloan does for issues. We name the field items.intransit and when the transfer is sent we put something in the field (either the transfer ID or the branch to which the item is headed) and when the transfer is either completed or cancelled we null items.intransit.