https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38387 --- Comment #1 from Julian Maurice <julian.maurice@biblibre.com> --- Created attachment 174116 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=174116&action=edit Bug 38387: Automatic item modification at checkin/checkout This replaces system preferences UpdateItemLocationOnCheckin and UpdateItemLocationOnCheckout by a new cataloguing tool The new tool allows to modify any `items` column, based on "rules". Each rule can have multiple conditions (or zero) and multiple substitutions. Conditions can be made on any `biblio`, `biblioitems` or `items` column. The new value can be a fixed string (as with UpdateItemLocationOn* sysprefs) or the value of another `items` column, using the syntax: $items.<column> (for instance: $items.permanent_location) The tool's UI is based on "automatic item modifications by age" so it should feel very similar. Test plan. 1. Set a value for UpdateItemLocationOnCheckin and UpdateItemLocationOnCheckout. They will be transferred to the new tool 2. Apply patch, run updatedatabase, update DBIC schema, restart 3. Go to "Cataloging > Item modifications by event" 4. Verify that UpdateItemLocationOn* sysprefs content has been transferred correctly: - If syspref content had a key '_ALL_', you should have only one rule with no conditions. Other keys are ignored. Otherwise, each key-value pair is transformed to a new rule with one condition ("items.location = <YAML key>") and one substitution ("items.location = <YAML value>") - The string '_BLANK_' is transformed to an empty string (''), whether it's a key or a value - The string '_PERM_' is transformed to '$items.permanent_location' when it's a value - For each created rule, another substitution is added ("items.permanent_location = <YAML value>") unless the value is 'PROC' or 'CART' This should match the current behavior. 5. Add other rules if needed, check out/check in some items and see your modifications applied. 6. prove t/db_dependent/Koha/Item/trigger_automatic_modifications_by_event.t -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38387 Julian Maurice <julian.maurice@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #174116|0 |1 is obsolete| | --- Comment #2 from Julian Maurice <julian.maurice@biblibre.com> --- Created attachment 174117 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=174117&action=edit Bug 38387: Automatic item modification at checkin/checkout This replaces system preferences UpdateItemLocationOnCheckin and UpdateItemLocationOnCheckout by a new cataloguing tool The new tool allows to modify any `items` column, based on "rules". Each rule can have multiple conditions (or zero) and multiple substitutions. Conditions can be made on any `biblio`, `biblioitems` or `items` column. The new value can be a fixed string (as with UpdateItemLocationOn* sysprefs) or the value of another `items` column, using the syntax: $items.<column> (for instance: $items.permanent_location) The tool's UI is based on "automatic item modifications by age" so it should feel very similar. Test plan. 1. Set a value for UpdateItemLocationOnCheckin and UpdateItemLocationOnCheckout. They will be transferred to the new tool 2. Apply patch, run updatedatabase, update DBIC schema, restart 3. Go to "Cataloging > Item modifications by event" 4. Verify that UpdateItemLocationOn* sysprefs content has been transferred correctly: - If syspref content had a key '_ALL_', you should have only one rule with no conditions. Other keys are ignored. Otherwise, each key-value pair is transformed to a new rule with one condition ("items.location = <YAML key>") and one substitution ("items.location = <YAML value>") - The string '_BLANK_' is transformed to an empty string (''), whether it's a key or a value - The string '_PERM_' is transformed to '$items.permanent_location' when it's a value - For each created rule, another substitution is added ("items.permanent_location = <YAML value>") unless the value is 'PROC' or 'CART' This should match the current behavior. 5. Add other rules if needed, check out/check in some items and see your modifications applied. 6. prove t/db_dependent/Koha/Item/trigger_automatic_modifications_by_event.t Sponsored-by: Médiathèques Valence Romans Agglo -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38387 Julian Maurice <julian.maurice@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Change sponsored?|--- |Sponsored -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38387 Lucas Gass (lukeg) <lucas@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |lucas@bywatersolutions.com Status|Needs Signoff |Patch doesn't apply -- You are receiving this mail because: You are watching all bug changes.