Bugzilla – Attachment 132404 Details for
Bug 30130
Allow setting EDI type at the vendor level
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 30130: Add standard field to edi_account
Bug-30130-Add-standard-field-to-ediaccount.patch (text/plain), 2.26 KB, created by
Nick Clemens (kidclamp)
on 2022-03-29 12:07:29 UTC
(
hide
)
Description:
Bug 30130: Add standard field to edi_account
Filename:
MIME Type:
Creator:
Nick Clemens (kidclamp)
Created:
2022-03-29 12:07:29 UTC
Size:
2.26 KB
patch
obsolete
>From 168c246e8fd478612441d92d1d9f47b36c88421b Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Mon, 21 Feb 2022 16:25:44 +0000 >Subject: [PATCH] Bug 30130: Add standard field to edi_account > >This patch add a 'standard' field to the edifact account configuration >table to allow setting the message standard as either 'EDItEUR' or 'BiC'. > >Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> > >Signed-off-by: Nick Clemens <nick@bywatersolutions.com> >--- > .../data/mysql/atomicupdate/bug_30130.pl | 19 +++++++++++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 20 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_30130.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_30130.pl b/installer/data/mysql/atomicupdate/bug_30130.pl >new file mode 100644 >index 0000000000..7dfd3dce17 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_30130.pl >@@ -0,0 +1,19 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "30130", >+ description => "A standard to edi_account", >+ up => sub { >+ my ($args) = @_; >+ my ($dbh, $out) = @$args{qw(dbh out)}; >+ unless ( column_exists('vendor_edi_accounts', 'standard') ) { >+ $dbh->do(q{ >+ ALTER TABLE vendor_edi_accounts ADD standard varchar(3) DEFAULT 'EUR' AFTER san >+ }); >+ >+ $dbh->do(q{ >+ UPDATE vendor_edi_accounts SET standard = 'BIC' WHERE san IN ( '5013546025065', '9377779308820' ) >+ }); >+ } >+ }, >+}; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 69b3613963..ca0723b695 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -5263,6 +5263,7 @@ CREATE TABLE `vendor_edi_accounts` ( > `download_directory` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, > `upload_directory` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, > `san` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, >+ `standard` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT 'EUR', > `id_code_qualifier` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT '14', > `transport` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT 'FTP', > `quotes_enabled` tinyint(1) NOT NULL DEFAULT 0, >-- >2.30.2
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 30130
:
130852
|
130860
|
130960
|
130966
|
130967
|
130968
|
130969
|
130970
|
130991
|
130992
|
130993
|
130994
|
130995
|
130996
| 132404 |
132405
|
132406
|
132407
|
132408
|
132409
|
132410