Bugzilla – Attachment 141627 Details for
Bug 23012
Possibility to mark processing fee by default refund when item is found
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 23012: Database updates for PROCESSING_FOUND account credit type
Bug-23012-Database-updates-for-PROCESSINGFOUND-acc.patch (text/plain), 2.06 KB, created by
Aleisha Amohia
on 2022-10-12 04:24:34 UTC
(
hide
)
Description:
Bug 23012: Database updates for PROCESSING_FOUND account credit type
Filename:
MIME Type:
Creator:
Aleisha Amohia
Created:
2022-10-12 04:24:34 UTC
Size:
2.06 KB
patch
obsolete
>From 73b06f6997614b807cb270ce27679fc0445f264c Mon Sep 17 00:00:00 2001 >From: Aleisha Amohia <aleishaamohia@hotmail.com> >Date: Wed, 12 Oct 2022 04:01:20 +0000 >Subject: [PATCH] Bug 23012: Database updates for PROCESSING_FOUND account > credit type > >--- > ...-_add_PROCESSING_FOUND_to_account_credit_types.pl | 12 ++++++++++++ > .../data/mysql/mandatory/account_credit_types.sql | 3 ++- > 2 files changed, 14 insertions(+), 1 deletion(-) > create mode 100644 installer/data/mysql/atomicupdate/bug_23012_-_add_PROCESSING_FOUND_to_account_credit_types.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_23012_-_add_PROCESSING_FOUND_to_account_credit_types.pl b/installer/data/mysql/atomicupdate/bug_23012_-_add_PROCESSING_FOUND_to_account_credit_types.pl >new file mode 100644 >index 00000000000..269d96ae3c0 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_23012_-_add_PROCESSING_FOUND_to_account_credit_types.pl >@@ -0,0 +1,12 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "23012", >+ description => "Add PROCESSING_FOUND to account_credit_types", >+ up => sub { >+ my ($args) = @_; >+ my ($dbh, $out) = @$args{qw(dbh out)}; >+ >+ $dbh->do(q{INSERT IGNORE INTO account_credit_types ( code, description, can_be_added_manually, is_system ) VALUES ('PROCESSING_FOUND', 'Lost item processing fee refund', 0, 1) }); >+ }, >+}; >diff --git a/installer/data/mysql/mandatory/account_credit_types.sql b/installer/data/mysql/mandatory/account_credit_types.sql >index 105575b425d..c0b1516099e 100644 >--- a/installer/data/mysql/mandatory/account_credit_types.sql >+++ b/installer/data/mysql/mandatory/account_credit_types.sql >@@ -8,6 +8,7 @@ INSERT INTO account_credit_types ( code, description, can_be_added_manually, is_ > ('REFUND', 'Refund', 0, 1), > ('LOST_FOUND', 'Lost item fee refund', 0, 1), > ('PURCHASE', 'Purchase', 0, 1), >-('CANCELLATION', 'Cancellation', 0, 1); >+('CANCELLATION', 'Cancellation', 0, 1), >+('PROCESSING_FOUND', 'Lost item processing fee refund', 0, 1); > > INSERT INTO authorised_values (category,authorised_value,lib) VALUES ('PAYMENT_TYPE','CASH','Cash'); >-- >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 23012
:
141627
|
141628
|
141629
|
141630
|
142046
|
142047
|
142048
|
142049
|
142113
|
142123
|
142124
|
142125
|
142126
|
142481
|
142482
|
142483
|
142484
|
142485
|
142486
|
142487
|
142575
|
142652
|
142693
|
142736
|
142737