Bugzilla – Attachment 97211 Details for
Bug 23354
Add a 'Point of sale' screen to allow anonymous payments
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 23354: (follow-up) Ensure 'CASH' payment type is present
Bug-23354-follow-up-Ensure-CASH-payment-type-is-pr.patch (text/plain), 1.95 KB, created by
Martin Renvoize (ashimema)
on 2020-01-10 13:42:43 UTC
(
hide
)
Description:
Bug 23354: (follow-up) Ensure 'CASH' payment type is present
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2020-01-10 13:42:43 UTC
Size:
1.95 KB
patch
obsolete
>From df05ac5f5b6e7feb539795eef36ba4edd52399c6 Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Fri, 25 Oct 2019 14:37:34 +0100 >Subject: [PATCH] Bug 23354: (follow-up) Ensure 'CASH' payment type is present > >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >--- > installer/data/mysql/account_credit_types.sql | 2 ++ > installer/data/mysql/atomicupdate/bug_23354.perl | 11 +++++++++++ > 2 files changed, 13 insertions(+) > >diff --git a/installer/data/mysql/account_credit_types.sql b/installer/data/mysql/account_credit_types.sql >index 06fca15898..20e15ebbc7 100644 >--- a/installer/data/mysql/account_credit_types.sql >+++ b/installer/data/mysql/account_credit_types.sql >@@ -5,3 +5,5 @@ INSERT INTO account_credit_types ( code, description, can_be_added_manually, is_ > ('CREDIT', 'Credit', 1, 1), > ('REFUND', 'A refund applied to a patrons fine', 0, 1), > ('LOST_RETURN', 'Lost item fee refund', 0, 1); >+ >+INSERT INTO authorised_values (category,authorised_value,lib) VALUES ('PAYMENT_TYPE','CASH','Cash'); >diff --git a/installer/data/mysql/atomicupdate/bug_23354.perl b/installer/data/mysql/atomicupdate/bug_23354.perl >index 9e7d269303..2e920c459d 100644 >--- a/installer/data/mysql/atomicupdate/bug_23354.perl >+++ b/installer/data/mysql/atomicupdate/bug_23354.perl >@@ -5,6 +5,17 @@ if( CheckVersion( $DBversion ) ) { > INSERT IGNORE INTO account_offset_types ( type ) VALUES ( 'Purchase' ); > }); > >+ my $sth = $dbh->prepare(q{ >+ SELECT COUNT(*) FROM authorised_values WHERE category = 'PAYMENT_TYPE' AND authorised_value = 'CASH' >+ }); >+ $sth->execute; >+ my $already_exists = $sth->fetchrow; >+ if ( not $already_exists ) { >+ $dbh->do(q{ >+ INSERT INTO authorised_values (category,authorised_value,lib) VALUES ('PAYMENT_TYPE','CASH','Cash') >+ }); >+ } >+ > # Updating field in account_debit_types > unless ( column_exists('account_debit_types', 'can_be_invoiced') ) { > $dbh->do( >-- >2.20.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 23354
:
92066
|
92431
|
92432
|
92433
|
92502
|
92830
|
92831
|
92832
|
92833
|
92834
|
92873
|
92874
|
92875
|
92876
|
92877
|
92878
|
92890
|
92891
|
92892
|
92893
|
92894
|
92895
|
93116
|
93117
|
93118
|
93119
|
93120
|
93121
|
93122
|
93123
|
93124
|
93465
|
93466
|
93467
|
93468
|
93469
|
93470
|
93471
|
93472
|
93473
|
93604
|
93605
|
93606
|
93607
|
93608
|
93609
|
93610
|
93611
|
93612
|
94689
|
94690
|
94691
|
94692
|
94693
|
94694
|
94695
|
94696
|
94697
|
94698
|
94699
|
95678
|
95679
|
95680
|
95681
|
95682
|
95683
|
95684
|
95685
|
95686
|
95687
|
95688
|
95689
|
95690
|
95691
|
95692
|
95693
|
97013
|
97014
|
97015
|
97016
|
97017
|
97018
|
97019
|
97020
|
97021
|
97022
|
97023
|
97024
|
97025
|
97026
|
97027
|
97028
|
97029
|
97169
|
97170
|
97171
|
97188
|
97189
|
97200
|
97201
|
97202
|
97203
|
97204
|
97205
|
97206
|
97207
|
97208
|
97209
|
97210
|
97211
|
97212
|
97213
|
97214
|
97215
|
97216
|
97217
|
97218
|
97219
|
97271
|
97272
|
97273
|
97274
|
97275
|
97276
|
97277
|
97278
|
97279
|
97280
|
97281
|
97282
|
97283
|
97284
|
97285
|
97286
|
97287
|
97288
|
97289
|
97290
|
97291
|
97292
|
97725
|
97726
|
100167