From ace01e9ba0814f1022eee8acba07086437ffb04f Mon Sep 17 00:00:00 2001
From: Bill Erickson <berick@esilibrary.com>
Date: Fri, 18 Jan 2013 12:27:20 -0500
Subject: [PATCH] ACQ lineitem order identifier SQL/IDL

New 'order_ident' column on acq.lineitem_attr to represent which
attribute should be considered the order identifier for the item.

New permission ACQ_ADD_LINEITEM_IDENTIFIER is added for allowing staff
to update linked bib records when a order identifier is added to a
lineitem.

Signed-off-by: Bill Erickson <berick@esilibrary.com>
---
 Open-ILS/examples/fm_IDL.xml                           |  2 ++
 Open-ILS/src/sql/Pg/200.schema.acq.sql                 |  3 ++-
 Open-ILS/src/sql/Pg/950.data.seed-values.sql           |  4 +++-
 .../src/sql/Pg/upgrade/XXXX.schema.acq-order-ident.sql | 18 ++++++++++++++++++
 4 files changed, 25 insertions(+), 2 deletions(-)
 create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-order-ident.sql

diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index ce82deae92..75f0e328fc 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -7907,6 +7907,7 @@ SELECT  usr,
 			<field reporter:label="Code" name="code" reporter:datatype="text"/>
 			<field reporter:label="Description" name="description" reporter:datatype="text"/>
 			<field reporter:label="Owning Library" name="owning_lib" reporter:datatype="link"/>
+			<field reporter:label="Order Identifier" name="order_ident" reporter:datatype="bool"/>
 		</fields>
 		<links>
 			<link field="owning_lib" reltype="has_a" key="id" map="" class="aou"/>
@@ -7949,6 +7950,7 @@ SELECT  usr,
 			<field reporter:label="Name" name="attr_name" reporter:datatype="text" />
 			<field reporter:label="Value" name="attr_value" reporter:datatype="text" />
 			<field reporter:label="Definition" name="definition" reporter:datatype="text" />
+			<field reporter:label="Order Identifier" name="order_ident" reporter:datatype="bool" />
 		</fields>
 		<links>
 			<link field="lineitem" reltype="has_a" key="id" map="" class="jub"/>
diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql
index 21fc092aa2..126c44e20b 100644
--- a/Open-ILS/src/sql/Pg/200.schema.acq.sql
+++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql
@@ -584,7 +584,8 @@ CREATE TABLE acq.lineitem_attr (
 	lineitem	BIGINT		NOT NULL REFERENCES acq.lineitem (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
 	attr_type	TEXT		NOT NULL,
 	attr_name	TEXT		NOT NULL,
-	attr_value	TEXT		NOT NULL
+	attr_value	TEXT		NOT NULL,
+	order_ident	BOOLEAN		NOT NULL DEFAULT FALSE
 );
 
 CREATE INDEX li_attr_li_idx ON acq.lineitem_attr (lineitem);
diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql
index 3beb825d67..4df1cf3cae 100644
--- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql
+++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql
@@ -1584,7 +1584,9 @@ INSERT INTO permission.perm_list ( id, code, description ) VALUES
  ( 545, 'SAVED_FILTER_DIALOG_FILTERS', oils_i18n_gettext( 545,
     'Allows users to save and load sets of filters for filter dialogs, available in certain staff interfaces', 'ppl', 'description')),
  ( 546, 'ADMIN_HOLD_CAPTURE_SORT', oils_i18n_gettext( 546,
-        'Allows a user to make changes to best-hold selection sort order', 'ppl', 'description'))
+        'Allows a user to make changes to best-hold selection sort order', 'ppl', 'description')),
+ ( 547, 'ACQ_ADD_LINEITEM_IDENTIFIER', oils_i18n_gettext(547,
+        'When granted, newly added lineitem identifiers will propagate to linked bib records', 'ppl', 'description'))
 ;
 
 
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-order-ident.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-order-ident.sql
new file mode 100644
index 0000000000..533a89a1bd
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-order-ident.sql
@@ -0,0 +1,18 @@
+
+BEGIN;
+
+ALTER TABLE acq.lineitem_attr
+    ADD COLUMN order_ident BOOLEAN NOT NULL DEFAULT FALSE;
+
+INSERT INTO permission.perm_list ( id, code, description ) VALUES (
+    543, -- VERIFY
+    'ACQ_ADD_LINEITEM_IDENTIFIER',
+    oils_i18n_gettext(
+        543,-- VERIFY
+        'When granted, newly added lineitem identifiers will propagate to linked bib records',
+        'ppl',
+        'description'
+    )
+);
+
+COMMIT;
-- 
2.11.0