Attachment 110280 Details for Bug 24446 – Bug 24446: Update branchtransfers.daterequested for stockrotation

[patch] Bug 24446: Update branchtransfers.daterequested for stockrotation

Bug-24446-Update-branchtransfersdaterequested-for-.patch (text/plain), 1.46 KB, created by Martin Renvoize (ashimema) on 2020-09-17 16:26:47 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2020-09-17 16:26:47 UTC

Size: 1.46 KB

patch

obsolete

>From 7be181ad9815238fb3e3283a9f95d149d6e7c29a Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Fri, 17 Jan 2020 15:18:24 +0000
>Subject: [PATCH] Bug 24446: Update branchtransfers.daterequested for
> stockrotation
>
>This database update catches existing stockrotation triggered
>branchtransfers and moves the datesent value into daterequested
>
>Signed-off-by: Kathleen Milne <kathleen.milne@cne-siar.gov.uk>
>---
> .../data/mysql/atomicupdate/bug_24446.perl    | 21 +++++++++++++++++++
> 1 file changed, 21 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_24446.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_24446.perl b/installer/data/mysql/atomicupdate/bug_24446.perl
>new file mode 100644
>index 0000000000..848f5caabc
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_24446.perl
>@@ -0,0 +1,21 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+
>+    # Update daterequested from datesent for stockrotation
>+    $dbh->do(
>+        qq{
>+            UPDATE
>+              `branchtransfers`
>+            SET
>+              `daterequested` = `datesent`,
>+              `datesent` = NULL
>+            WHERE
>+              `reason` LIKE 'Stockrotation%'
>+            AND
>+              `datearrived` IS NULL
>+          }
>+    );
>+
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 24446 - Update stockrotation 'daterequested' field in transfers table)\n";
>+}
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 24446: 105943 | 105944 | 105945 | 107246 | 107247 | 107248 | 107249 | 107250 | 107252 | 107253 | 107254 | 107255 | 107256 | 107301 | 107302 | 107303 | 107304 | 107305 | 110280 | 110281 | 110282 | 110283 | 110533 | 110534 | 110535 | 110536 | 110537 | 110538 | 110539 | 110540 | 110541 | 110542 | 111322 | 116557 | 116558 | 116559 | 116560 | 116561 | 116562 | 116563 | 116564 | 116565 | 116566 | 116567 | 116568 | 116569 | 116570 | 117589 | 117590 | 117591 | 117592 | 117593 | 117594 | 117595 | 117596 | 117597 | 117598 | 117599 | 117600 | 117601 | 117602 | 117603 | 117604 | 117605 | 117606 | 117607 | 120116