Bug 38700 - Add items table field to record transfer status
Summary: Add items table field to record transfer status
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-12-13 15:42 UTC by Andrew Fuerste-Henry
Modified: 2024-12-16 17:51 UTC (History)
1 user (show)

See Also:
GIT URL:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.