https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38700
Bug ID: 38700
Summary: Add items table field to record transfer status
Change sponsored?: ---
Product: Koha
Version: Main
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Database
Assignee: koha-bugs@lists.koha-community.org
Reporter: and...@bywatersolutions.com
QA Contact: testo...@bugs.koha-community.org
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.
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
