Attachment 88727 Details for Bug 11573 – Bug 11573: Update existing accountlines for 'Rent'

[patch] Bug 11573: Update existing accountlines for 'Rent'

Bug-11573-Update-existing-accountlines-for-Rent.patch (text/plain), 1.31 KB, created by Martin Renvoize (ashimema) on 2019-04-25 09:15:22 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2019-04-25 09:15:22 UTC

Size: 1.31 KB

patch

obsolete

>From b48a916747b694755046902c6b1935d94048592d Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Wed, 24 Apr 2019 09:05:33 +0100
>Subject: [PATCH] Bug 11573: Update existing accountlines for 'Rent'
>
>Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>---
> .../data/mysql/atomicupdate/bug_11573.perl    | 26 +++++++++++++++++++
> 1 file changed, 26 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_11573.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_11573.perl b/installer/data/mysql/atomicupdate/bug_11573.perl
>new file mode 100644
>index 0000000000..93a002dca4
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_11573.perl
>@@ -0,0 +1,26 @@
>+$DBversion = 'XXX';    # will be replaced by the RM
>+if ( CheckVersion($DBversion) ) {
>+
>+    $dbh->do(qq{
>+        UPDATE
>+          accountlines
>+        SET
>+          accounttype = 'RENT_RENEW'
>+        WHERE
>+          accounttype = 'Rent'
>+        AND
>+          description LIKE 'Renewal of Rental Item%';
>+    });
>+
>+    $dbh->do(qq{
>+        UPDATE
>+          accountlines
>+        SET
>+          accounttype = 'RENT'
>+        WHERE
>+          accounttype = 'Rent';
>+    });
>+
>+    SetVersion($DBversion);
>+    print "Upgrade to $DBversion done (Bug 11573 - Fix accounttypes for 'Rent')\n";
>+}
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 11573: 24473 | 24485 | 24486 | 25715 | 27822 | 27823 | 27824 | 47236 | 47237 | 47238 | 47239 | 47240 | 47241 | 47242 | 47288 | 47289 | 47290 | 47291 | 88549 | 88600 | 88601 | 88602 | 88603 | 88604 | 88605 | 88606 | 88726 | 88727 | 88728 | 88729 | 90231 | 90232 | 90233 | 90234 | 90246 | 90256 | 90313 | 90314 | 90315 | 90316 | 91529 | 91530 | 91531 | 91532 | 91800 | 91801 | 91802 | 91803 | 91804 | 91805 | 91806