From 37e31ad2b4def60f71de9d44f2f195edbf6bea89 Mon Sep 17 00:00:00 2001 From: atz Date: Mon, 16 Aug 2010 16:23:41 +0000 Subject: [PATCH] 0372 - acq.edi_message.vendacct Needed for some but not all vendors (separate from SAN). git-svn-id: svn://svn.open-ils.org/ILS/trunk@17227 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/examples/fm_IDL.xml | 1 + Open-ILS/src/edi_translator/data/brodart_001_edi.tst | 1 + Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- Open-ILS/src/sql/Pg/200.schema.acq.sql | 3 ++- Open-ILS/src/sql/Pg/upgrade/0372.schema.acq_edi_message.sql | 7 +++++++ Open-ILS/web/templates/default/conify/global/acq/edi_account.tt2 | 2 +- 6 files changed, 13 insertions(+), 3 deletions(-) create mode 100644 Open-ILS/src/edi_translator/data/brodart_001_edi.tst create mode 100644 Open-ILS/src/sql/Pg/upgrade/0372.schema.acq_edi_message.sql diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml index 180d168d7..d491ec978 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -6336,6 +6336,7 @@ SELECT usr, + diff --git a/Open-ILS/src/edi_translator/data/brodart_001_edi.tst b/Open-ILS/src/edi_translator/data/brodart_001_edi.tst new file mode 100644 index 000000000..16d93fe00 --- /dev/null +++ b/Open-ILS/src/edi_translator/data/brodart_001_edi.tst @@ -0,0 +1 @@ +UNA:+.? 'UNB+UNOB:3+9999867:31B+1697684:31B+100811:1927+1'UNH+1+ORDERS:D:96A:UN'BGM+220+15+9'DTM+137:20100811:102'NAD+BY+9999867::91'NAD+SU+1697684::31B'NAD+SU+7::92'CUX+2:USD:9'LIN+81++0743294394:IB'PIA+5+0743294394:IB+81:SA'IMD+F+BTI+:::206 BONES'IMD+F+BPU+:::Scribner'IMD+F+BPD+:::2009-08-01'QTY+21:4'PRI+AAB:0'RFF+LI:15/81'LIN+80++1598883275:IB'PIA+5+1598883275:IB+80:SA'IMD+F+BTI+:::COUNTY AND CITY EXTRA'IMD+F+BPU+:::Bernan Press'IMD+F+BPD+:::2009-07-01'QTY+21:4'PRI+AAB:0'RFF+LI:15/80'LIN+79++1590203097:IB'PIA+5+1590203097:IB+79:SA'IMD+F+BTI+:::2017'IMD+F+BPU+:::Overlook Pr'IMD+F+BPD+:::2010-03-01'QTY+21:4'PRI+AAB:0'RFF+LI:15/79'LIN+78++1598884093:IB'PIA+5+1598884093:IB+78:SA'IMD+F+BTI+:::COUNTY AND CITY EXTRA'IMD+F+BPU+:::Bernan Press'IMD+F+BPD+:::2010-07-01'QTY+21:4'PRI+AAB:0'RFF+LI:15/78'UNS+S'CNT+2:4'UNT+42+1'UNZ+1+1' diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 251d1185e..9a21c27f5 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -68,7 +68,7 @@ CREATE TABLE config.upgrade_log ( install_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); -INSERT INTO config.upgrade_log (version) VALUES ('0371'); -- senator +INSERT INTO config.upgrade_log (version) VALUES ('0372'); -- atz CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql index 18c0b65cc..5144ca561 100644 --- a/Open-ILS/src/sql/Pg/200.schema.acq.sql +++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql @@ -755,7 +755,8 @@ CREATE TABLE acq.fiscal_year ( CREATE TABLE acq.edi_account ( -- similar tables can extend remote_account for other parts of EG provider INT NOT NULL REFERENCES acq.provider (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, in_dir TEXT, -- incoming messages dir (probably different than config.remote_account.path, the outgoing dir) - vendcode TEXT + vendcode TEXT, + vendacct TEXT ) INHERITS (config.remote_account); -- We need a UNIQUE constraint here also, to support the FK from acq.provider.edi_default diff --git a/Open-ILS/src/sql/Pg/upgrade/0372.schema.acq_edi_message.sql b/Open-ILS/src/sql/Pg/upgrade/0372.schema.acq_edi_message.sql new file mode 100644 index 000000000..714e7173b --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/0372.schema.acq_edi_message.sql @@ -0,0 +1,7 @@ +BEGIN; + +INSERT INTO config.upgrade_log (version) VALUES ('0372'); -- atz + +ALTER TABLE acq.edi_account ADD COLUMN vendacct TEXT; + +COMMIT; diff --git a/Open-ILS/web/templates/default/conify/global/acq/edi_account.tt2 b/Open-ILS/web/templates/default/conify/global/acq/edi_account.tt2 index f851a7acb..af76e3bd2 100644 --- a/Open-ILS/web/templates/default/conify/global/acq/edi_account.tt2 +++ b/Open-ILS/web/templates/default/conify/global/acq/edi_account.tt2 @@ -48,7 +48,7 @@ function formatProvider(value) {