From 2ed639cfb4a2bb57888fcbf3cd678d36d6a5325c 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>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Tomas Cohen Arazi <tomascohen@unc.edu.ar>
(cherry picked from commit c7a6745bc0e0241e5f39a12e2ff4e17678288b14)
Signed-off-by: Chris Cormack <chris@bigballofwax.co.nz>
(cherry picked from commit 74e6691cf84e51b20832b45cf7520aec85788771)
Signed-off-by: Liz Rea <wizzyrea@gmail.com>
---
 C4/Items.pm | 15 ++++++++-------
 1 file changed, 8 insertions(+), 7 deletions(-)

diff --git a/C4/Items.pm b/C4/Items.pm
index bf42277ddb..f3d492e1fb 100644
--- a/C4/Items.pm
+++ b/C4/Items.pm
@@ -2257,13 +2257,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.39.5