Bugzilla – Attachment 187166 Details for
Bug 20253
Optionally use buyer's purchase order number from EDIFACT quote in basket name
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 20253: Add po_is_basketname field to vendor_edi_accounts table
Bug-20253-Add-poisbasketname-field-to-vendorediacc.patch (text/plain), 2.61 KB, created by
Martin Renvoize (ashimema)
on 2025-10-01 11:09:31 UTC
(
hide
)
Description:
Bug 20253: Add po_is_basketname field to vendor_edi_accounts table
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2025-10-01 11:09:31 UTC
Size:
2.61 KB
patch
obsolete
>From ce6ab10c4890443a7531072ea67c77c1aa59337c Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@openfifth.co.uk> >Date: Tue, 8 Jul 2025 14:43:55 +0100 >Subject: [PATCH] Bug 20253: Add po_is_basketname field to vendor_edi_accounts > table > >This patch adds a new boolean field 'po_is_basketname' to the vendor_edi_accounts >table to allow configuration of how basket names are used in EDIFACT. > >Changes: >- Added atomicupdate for existing installations >- Updated kohastructure.sql for new installations > >Signed-off-by: Hannah Dunne-Howrie <hdunne-howrie@westminster.gov.uk> >Sponsored-by: Westminster City Council <https://www.westminster.gov.uk/> >Sponsored-by: Royal Borough of Kensington and Chelsea <https://www.rbkc.gov.uk/> >Sponsored-by: OpenFifth <https://openfifth.co.uk/> >--- > .../bug_20253_basket_name_source.pl | 22 +++++++++++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 23 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_20253_basket_name_source.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_20253_basket_name_source.pl b/installer/data/mysql/atomicupdate/bug_20253_basket_name_source.pl >new file mode 100755 >index 00000000000..3820f8ff3da >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_20253_basket_name_source.pl >@@ -0,0 +1,22 @@ >+use Modern::Perl; >+use Koha::Installer::Output qw(say_warning say_success say_info); >+ >+return { >+ bug_number => "20253", >+ description => "Add purchase order number configuration option to vendor_edi_accounts", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ unless ( column_exists( 'vendor_edi_accounts', 'po_is_basketname' ) ) { >+ $dbh->do( >+ q{ >+ ALTER TABLE vendor_edi_accounts >+ ADD COLUMN `po_is_basketname` tinyint(1) NOT NULL DEFAULT 0 >+ AFTER `plugin` >+ } >+ ); >+ say_success( $out, "Added column 'vendor_edi_accounts.po_is_basketname'" ); >+ } >+ }, >+}; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 2496a95d6bf..7a7f810c9d9 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -6712,6 +6712,7 @@ CREATE TABLE `vendor_edi_accounts` ( > `shipment_budget` int(11) DEFAULT NULL, > `plugin` varchar(256) NOT NULL DEFAULT '', > `file_transport_id` int(11) DEFAULT NULL, >+ `po_is_basketname` tinyint(1) NOT NULL DEFAULT 0, > PRIMARY KEY (`id`), > KEY `vendorid` (`vendor_id`), > KEY `shipmentbudget` (`shipment_budget`), >-- >2.51.0
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 20253
:
183859
|
183860
|
183861
|
183862
|
183953
|
183954
|
183955
|
183956
|
183957
|
183958
|
184000
|
184001
|
184002
|
184003
|
184004
|
184005
|
184006
|
184007
|
185221
|
185222
|
185223
|
185224
|
185225
|
185226
|
185227
|
185228
|
186860
|
186861
|
186862
|
186863
|
186864
|
186865
|
186866
|
186867
|
186868
|
186869
|
186870
|
186871
|
186872
|
186873
|
186874
|
186875
|
187165
| 187166 |
187167
|
187168
|
187169
|
187170
|
187171
|
187172
|
187173