Attachment 42441 Details for Bug 8723 – [PASSED QA] Bug 8723: Update hold_fill_targets, tmp_holdsqueue and linktracker tables

[patch] [PASSED QA] Bug 8723: Update hold_fill_targets, tmp_holdsqueue and linktracker tables

PASSED-QA-Bug-8723-Update-holdfilltargets-tmpholds.patch (text/plain), 1.40 KB, created by Katrin Fischer on 2015-09-07 20:26:16 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2015-09-07 20:26:16 UTC

Size: 1.40 KB

patch

obsolete

>From d8f0e7b79e78c4533bb82bc18bff8450ea815042 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Fri, 10 Jul 2015 15:18:48 +0100
>Subject: [PATCH] [PASSED QA] Bug 8723: Update hold_fill_targets,
> tmp_holdsqueue and linktracker tables
>
>Same as previous patch for 3 other tables.
>
>Test plan:
>Same as before but the hold should exist to the 3 tables before the
>move.
>
>Signed-off-by: Nick Clemens <nick@quecheelibrary.org>
>
>Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
>---
> C4/Items.pm | 15 ++++++++-------
> 1 file changed, 8 insertions(+), 7 deletions(-)
>
>diff --git a/C4/Items.pm b/C4/Items.pm
>index 3ce710c..0194787 100644
>--- a/C4/Items.pm
>+++ b/C4/Items.pm
>@@ -2278,13 +2278,14 @@ sub MoveItemFromBiblio {
> 	        C4::Acquisition::ModOrder($order);
> 	    }
> 
>-        # Update holds
>-        $dbh->do( q|
>-            UPDATE reserves
>-            SET biblionumber = ?
>-            WHERE itemnumber = ?
>-        |, undef, $tobiblio, $itemnumber );
>-
>+        # Update reserves, hold_fill_targets, tmp_holdsqueue and linktracker tables
>+        for my $table_name ( qw( reserves hold_fill_targets tmp_holdsqueue linktracker ) ) {
>+            $dbh->do( qq|
>+                UPDATE $table_name
>+                SET biblionumber = ?
>+                WHERE itemnumber = ?
>+            |, undef, $tobiblio, $itemnumber );
>+        }
>         return $tobiblio;
> 	}
>     return;
>-- 
>1.9.1

Actions: View | Diff | Splinter Review

Attachments on bug 8723: 40919 | 40920 | 40921 | 41078 | 41079 | 41080 | 42439 | 42440 | 42441