Bugzilla – Attachment 130966 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.16 KB, created by
Martin Renvoize (ashimema)
on 2022-02-21 16:32:32 UTC
(
hide
)
Description:
Bug 30130: Add standard field to edi_account
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2022-02-21 16:32:32 UTC
Size:
2.16 KB
patch
obsolete
>From 69767c79de1d1382769c2346b5ba2fb6630068f4 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'. >--- > .../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..58669f6fbd >--- /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 4411ae7604..49f4ac8a60 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -5230,6 +5230,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.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 30130
:
130852
|
130860
|
130960
|
130966
|
130967
|
130968
|
130969
|
130970
|
130991
|
130992
|
130993
|
130994
|
130995
|
130996
|
132404
|
132405
|
132406
|
132407
|
132408
|
132409
|
132410