Attachment 41080 Details for Bug 8723 – Bug 8723: Update hold_fill_targets, tmp_holdsqueue and linktracker tables

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

Bug-8723-Update-holdfilltargets-tmpholdsqueue-and-.patch (text/plain), 1.34 KB, created by Nick Clemens (kidclamp) on 2015-07-18 14:10:19 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2015-07-18 14:10:19 UTC

Size: 1.34 KB

patch

obsolete

>From ee7ed92aa6283df70d1012006bd9252f00b388bd 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] 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>
>---
> C4/Items.pm | 15 ++++++++-------
> 1 file changed, 8 insertions(+), 7 deletions(-)
>
>diff --git a/C4/Items.pm b/C4/Items.pm
>index feed7b0..a1e3b05 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