From c0532bfe5aba425f1541477d78ff1312d79d4d6f 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           |  5 ++++-
 .../src/sql/Pg/upgrade/XXXX.schema.acq-order-ident.sql | 18 ++++++++++++++++++
 4 files changed, 26 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 a7a765dbfb..0873ad3429 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -7795,6 +7795,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"/>
@@ -7837,6 +7838,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 e5f42eed02..09442ba971 100644
--- a/Open-ILS/src/sql/Pg/200.schema.acq.sql
+++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql
@@ -583,7 +583,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 88051810eb..2d6e58bd4f 100644
--- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql
+++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql
@@ -1573,7 +1573,10 @@ INSERT INTO permission.perm_list ( id, code, description ) VALUES
  ( 541, 'ADMIN_TOOLBAR_FOR_WORKSTATION', oils_i18n_gettext( 541,
         'Allows a user to create, edit, and delete custom toolbars for workstations', 'ppl', 'description')),
  ( 542, 'ADMIN_TOOLBAR_FOR_USER', oils_i18n_gettext( 542,
-        'Allows a user to create, edit, and delete custom toolbars for users', 'ppl', 'description'))
+        'Allows a user to create, edit, and delete custom toolbars for users', 'ppl', 'description')),
+ ( 543, 'ACQ_ADD_LINEITEM_IDENTIFIER', oils_i18n_gettext(543,
+        '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