[Koha-bugs] [Bug 21173] Add Hours as an age unit to auto item modifications by age for the items.damaged_on, items.itemlost_on and items.withdrawn_on age fields

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21173

Alex Buckley <alexbuckley at catalyst.net.nz> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Run auto item modifications |Add Hours as an age unit to
                   |by age every hour and set   |auto item modifications by
                   |the item age unit to hours  |age for the
                   |                            |items.damaged_on,
                   |                            |items.itemlost_on and
                   |                            |items.withdrawn_on age
                   |                            |fields
  Change sponsored?|---                         |Sponsored
         Version(s)|                            |If you create rules in the
        released in|                            |'Automatic item
                   |                            |modification by age' tool
                   |                            |on the age field(s)
                   |                            |'items.damaged_on,
                   |                            |items.itemlost_on, or
                   |                            |items.withdrawn_on' you can
                   |                            |now define an age unit of
                   |                            |'Hours', not just 'Days'.
                   |                            |
                   |                            |This means you can now
                   |                            |automatically modify items
                   |                            |based on the number of
                   |                            |hours since they were
                   |                            |marked damaged, lost, or
                   |                            |withdrawn.
                   |                            |
                   |                            |You will need
                   |                            |to ask your system
                   |                            |administrator to configure
                   |                            |the
                   |                            |automatic_item_modification
                   |                            |_by_age.pl cronjob to run
                   |                            |more than once a day if you
                   |                            |create rules with the age
                   |                            |unit of 'Hours'.
             Status|ASSIGNED                    |Needs Signoff

--- Comment #22 from Alex Buckley <alexbuckley at catalyst.net.nz> ---
Hi all, 

In the interests of upstreaming I have re-written this patchset.

This patchset now adds the ability to set a unit of 'Hours' for automatic item
modification by age rules on the three existing item datetime columns:
items.damaged_on, items.itemlost_on, items.withdrawn_on.

This is instead of trying to change existing items date columns to the datetime
datatype, or adding new datetime columns.

I think adding a new column such as 'created_on' with an automatic timestamp
(as Katrin noted in comment #15), could be added in a follow-up bug report, and
it's best to get a smaller part of this functionality upstreamed initially. 

Ready for testing again! 

Thanks,
Alex

-- 
You are receiving this mail because:
You are watching all bug changes.