Attachment 40921 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.28 KB, created by Jonathan Druart on 2015-07-10 14:24:57 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2015-07-10 14:24:57 UTC

Size: 1.28 KB

patch

obsolete

>From 30ce47a436eed93870e9b4a396a8c134e1a423a8 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.
>---
> 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;
>-- 
>2.1.0

Actions: View | Diff | Splinter Review

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