Bug 17672: Add damaged_on to items and deleteditems tables
authorNick Clemens <nick@bywatersolutions.com>
Wed, 19 Jul 2017 13:10:41 +0000 (13:10 +0000)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Sun, 18 Feb 2018 19:48:43 +0000 (16:48 -0300)
commit5d8155439eb91471400ad04a1f95da4e77d80dad
tree3f2e66be655cf52c1a9d5c08b8e5674c7f9dd6a0
parent90e0c0de5c127664177821ac9d05aca046e0d823
Bug 17672: Add damaged_on to items and deleteditems tables

This patchset adds a 'damaged_on' column to store the date an item is
marked damaged, analogous to withdrawn_on and itemlost_on

To test:
1 - Apply patch
2 - Mark an item damaged via moredetail.pl (Items tab on left in
        details)
3 - Note the damaged on date apears below
4 - Unmark the item, the date is removed
5 - Go to the edit items screen (from top bar 'Edit->edit items')
6 - Mark item damaged - check db or moredetails.pl to see damaged_on
date
7 - Unmark item damaged - confirm date is removed
8 - prove t/db_dependent/Items.t

Signed-off-by: Owen Leonard <oleonard@myacpl.org>
Signed-off-by: Charles Farmer <charles.farmer@inLibro.com>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
C4/Items.pm
admin/columns_settings.yml
installer/data/mysql/atomicupdate/bug17672_add_damaged_on_column_to_items.perl [new file with mode: 0644]
installer/data/mysql/kohastructure.sql
koha-tmpl/intranet-tmpl/prog/en/columns.def
koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/moredetail.tt
t/db_dependent/Items.t