Attachment 97972 Details for Bug 24338 – Bug 24338: Add 'CASH' to default 'PAYMENT_TYPE' AV

[patch] Bug 24338: Add 'CASH' to default 'PAYMENT_TYPE' AV

Bug-24338-Add-CASH-to-default-PAYMENTTYPE-AV.patch (text/plain), 2.36 KB, created by Martin Renvoize (ashimema) on 2020-01-27 11:15:10 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2020-01-27 11:15:10 UTC

Size: 2.36 KB

patch

obsolete

>From 87b24762739d58fdb3a3b6056e105e1def5b95bd Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Mon, 27 Jan 2020 11:06:26 +0000
>Subject: [PATCH] Bug 24338: Add 'CASH' to default 'PAYMENT_TYPE' AV
>
>Bug 23321 adds cash registers to the koha accounts system and as part of
>that work introduces the 'CASH' payment type as a required option to
>allow requirment of a 'CASH_REGISTER' when making cash payments. The
>original patchset, however, forgot to add this new authorised value
>during installation and upgrade.
>---
> installer/data/mysql/atomicupdate/bug_24338.perl  | 12 ++++++++++++
> installer/data/mysql/en/mandatory/auth_values.sql |  1 +
> 2 files changed, 13 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_24338.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_24338.perl b/installer/data/mysql/atomicupdate/bug_24338.perl
>new file mode 100644
>index 0000000000..bf154169ae
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_24338.perl
>@@ -0,0 +1,12 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+    $dbh->do(qq{
>+        INSERT INTO
>+          authorised_values (category,authorised_value,lib, lib_opac)
>+        VALUES
>+          ('PAYMENT_TYPE','CASH','Cash','Cash')
>+    });
>+
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 24338 - Add 'CASH' to default 'PAYMENT_TYPE')\n";
>+}
>diff --git a/installer/data/mysql/en/mandatory/auth_values.sql b/installer/data/mysql/en/mandatory/auth_values.sql
>index 894b2b9b68..a7e5d7dec4 100644
>--- a/installer/data/mysql/en/mandatory/auth_values.sql
>+++ b/installer/data/mysql/en/mandatory/auth_values.sql
>@@ -3,4 +3,5 @@ INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('
> INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('PAYMENT_TYPE','SIP00','Cash via SIP2','Cash');
> INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('PAYMENT_TYPE','SIP01','Visa via SIP2','Visa');
> INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('PAYMENT_TYPE','SIP02','Creditcard via SIP2','Creditcard');
>+INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('PAYMENT_TYPE','CASH','Cash','Cash');
> INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week');
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 24338: 97972 | 98381 | 98388 | 98412 | 98413 | 98490 | 98491 | 98504 | 98505