From 0706921a11b9cbe663e54a51f5974410f7b567fe Mon Sep 17 00:00:00 2001 From: Fridolyn SOMERS Date: Thu, 5 Dec 2013 15:34:44 +0100 Subject: [PATCH] Bug 6331 - 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 item has been 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 Signed-off-by: Kyle M Hall Patch set passes koha-qa.pl, works as advertised! --- C4/Items.pm | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diff --git a/C4/Items.pm b/C4/Items.pm index 068291b..4c1a4ad 100644 --- a/C4/Items.pm +++ b/C4/Items.pm @@ -2336,6 +2336,7 @@ sub _koha_delete_item { my $query = "INSERT INTO deleteditems SET "; my @bind = (); foreach my $key ( keys %$data ) { + next if ( $key eq 'timestamp' ); # timestamp will be set by db $query .= "$key = ?,"; push( @bind, $data->{$key} ); } -- 1.7.2.5