Attachment 10156 Details for Bug 7329 – [SIGNED-OFF] Bug 7329 [Followup] : when reverting an import, keep matching biblionumber in batch table, if items are not deleted beacause on loan.

[patch] [SIGNED-OFF] Bug 7329 [Followup] : when reverting an import, keep matching biblionumber in batch table, if items are not deleted beacause on loan.

SIGNED-OFF-Bug-7329-Followup--when-reverting-an-im.patch (text/plain), 1.23 KB, created by Katrin Fischer on 2012-06-11 08:58:19 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2012-06-11 08:58:19 UTC

Size: 1.23 KB

patch

obsolete

>From 661d347ccc40df04bad5f5d17285334764cb518a Mon Sep 17 00:00:00 2001
>From: Sophie Meynieux <sophie.meynieux@biblibre.com>
>Date: Sun, 10 Jun 2012 12:23:20 +0200
>Subject: [PATCH] [SIGNED-OFF] Bug 7329 [Followup] : when reverting an import,
> keep matching biblionumber in batch table, if items are not
> deleted beacause on loan.
>
>Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
>---
> C4/ImportBatch.pm |    2 +-
> 1 file changed, 1 insertion(+), 1 deletion(-)
>
>diff --git a/C4/ImportBatch.pm b/C4/ImportBatch.pm
>index 5dbf839..38d32a5 100644
>--- a/C4/ImportBatch.pm
>+++ b/C4/ImportBatch.pm
>@@ -687,7 +687,7 @@ sub BatchRevertBibRecords {
>             $num_items_deleted += BatchRevertItems($rowref->{'import_record_id'}, $rowref->{'matched_biblionumber'});
>             SetImportRecordStatus($rowref->{'import_record_id'}, 'reverted');
>         }
>-        my $sth2 = $dbh->prepare_cached("UPDATE import_biblios SET matched_biblionumber = NULL WHERE import_record_id = ?");
>+        my $sth2 = $dbh->prepare_cached("UPDATE import_biblios LEFT JOIN import_items USING (import_record_id) SET matched_biblionumber = NULL WHERE import_record_id = ? AND status != 'imported'" );
>         $sth2->execute($rowref->{'import_record_id'});
>     }
> 
>-- 
>1.7.9.5

Actions: View | Diff | Splinter Review

Attachments on bug 7329: 6635 | 6829 | 10070 | 10125 | 10155 | 10156 | 10157