https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41410
--- Comment #29 from Andrew Fuerste-Henry <[email protected]> --- Created attachment 200345 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=200345&action=edit Bug 41410: Add local_holdgroup_match column and exclusivity period syspref Adds groundwork for a time-bounded local holds exclusivity feature: - Adds a local_holdgroup_match flag (tinyint, default 0) to both hold_fill_targets (consulted by CheckReserves/_Findgroupreserve at checkin) and tmp_holdsqueue (so queue/pull-list reports can display it). The flag will be set by the queue builder when a local-group match is made. - Adds a new system preference LocalHoldsPriorityExclusivityPeriod (Integer, default 0 = disabled) specifying the number of days from hold creation during which only locally-targeted items may fill a hold with a local queue target. - Provides an atomicupdate that guards both ALTERs with column_exists and INSERT IGNOREs the new syspref. Test plan: 1. Apply atomicupdate: perl installer/data/mysql/updatedatabase.pl 2. Verify both columns exist: SHOW COLUMNS FROM hold_fill_targets LIKE 'local%'; SHOW COLUMNS FROM tmp_holdsqueue LIKE 'local%'; 3. Verify syspref row: SELECT variable, value FROM systempreferences WHERE variable = 'LocalHoldsPriorityExclusivityPeriod'; 4. Confirm default value is 0 and type is Integer. Sponsored-by: Main Library Alliance <https://www.mainlib.org/> Signed-off-by: Trevor Diamond <[email protected]> Signed-off-by: Andrew Fuerste Henry <[email protected]> -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] 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/
