]> git.koha-community.org Git - koha.git/commit
Bug 6331: (follow-up) update timestamp when deleting items
authorFridolyn SOMERS <fridolyn.somers@biblibre.com>
Thu, 5 Dec 2013 14:34:44 +0000 (15:34 +0100)
committerFridolin SOMERS <fridolin.somers@biblibre.com>
Fri, 3 Jan 2014 08:48:57 +0000 (09:48 +0100)
commitd2c9c8837bcf4e1159ee75bdcdc8386d1f394ad7
treecedc483140fe76a94a446b1f53aa64be71e21ce3
parent574dc07e0dbed1d397d6a6439baee5737a4b127a
Bug 6331: (follow-up) update timestamp when deleting items

When item is transfered from items table to deleted items, all fields
must be copies but "timestamp".

This value must be updated to know when the item was deleted.

Test plan:
- Look a an item timestamp :
mysql> select timestamp from items where itemnumber = 2690;
+---------------------+
| timestamp           |
+---------------------+
| 2011-09-09 15:30:21 |
+---------------------+
1 row in set (0.00 sec)
- Delete this item in cataloguing module
- Check it is not in items table anymore :
mysql> select timestamp from items where itemnumber = 2690;
Empty set (0.00 sec)
- Look in deleteditems table :
mysql> select timestamp from deleteditems where itemnumber = 2690;
+---------------------+
| timestamp           |
+---------------------+
| 2013-12-05 15:33:20 |
+---------------------+
1 row in set (0.00 sec)
=> timestamp as been set to actual date/time

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Patch set passes koha-qa.pl, works as advertised!

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
(cherry picked from commit cada676ef3439d2567fa21da415d939f0fc22ee6)
Signed-off-by: Fridolin SOMERS <fridolin.somers@biblibre.com>
C4/Items.pm