[Koha-bugs] [Bug 27950] New: Add a script to automatically deprecate replacement costs based on age

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

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

            Bug ID: 27950
           Summary: Add a script to automatically deprecate replacement
                    costs based on age
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Command-line Utilities
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: andrew at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org
                CC: robin at catalyst.net.nz

It would be useful to have an automated process for adjusting items.replacement
price based on age -- some libraries do not wish to charge the full purchase
price for an item that's older.

At its simplest, this could be just

UPDATE items SET replacementprice=(replacementprice * X) WHERE
replacementpricedate < date_sub(curdate(),interval Y day);

With X and Y set in flags on a cronjob.

We could go one better and add a syspref to allow those values to be set within
the staff interface.

Or we could do better still and add a more complicated syspref to take some
YAML defining different X and Y values per itemtype.

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