From 87b24762739d58fdb3a3b6056e105e1def5b95bd Mon Sep 17 00:00:00 2001 From: Martin Renvoize 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