From e9c1de5761544bd80ae1e526a92755572afb63b7 Mon Sep 17 00:00:00 2001
From: Bill Erickson <berickxx@gmail.com>
Date: Thu, 4 Jan 2018 17:40:28 -0500
Subject: [PATCH] LP#1635354 Invoice close date / close by WIP

Signed-off-by: Bill Erickson <berickxx@gmail.com>
---
 Open-ILS/examples/fm_IDL.xml                           |  3 +++
 .../upgrade/XXXX.schema.invoice-closed-date-user.sql   | 18 ++++++++++++++++++
 2 files changed, 21 insertions(+)
 create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.invoice-closed-date-user.sql

diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index 535cee6ae6..d37105a508 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -8146,6 +8146,8 @@ SELECT  usr,
 			<field reporter:label="Complete" name="complete" reporter:datatype="bool" />
 			<field reporter:label="Invoice Entries" name="entries" reporter:datatype="link" oils_persist:virtual="true"/>
 			<field reporter:label="Invoice Items" name="items" reporter:datatype="link" oils_persist:virtual="true"/>
+			<field reporter:label="Close Date" name="close_date" reporter:datatype="timestamp" />
+			<field reporter:label="Closed By" name="closed_by" reporter:datatype="link" />
 		</fields>
 		<links>
 			<link field="receiver" reltype="has_a" key="id" map="" class="aou"/>
@@ -8155,6 +8157,7 @@ SELECT  usr,
 			<link field="payment_method" reltype="has_a" key="code" map="" class="acqipm"/>
 			<link field="entries" reltype="has_many" key="invoice" map="" class="acqie"/>
 			<link field="items" reltype="has_many" key="invoice" map="" class="acqii"/>
+			<link field="closed_by" reltype="has_a" key="id" map="" class="au"/>
 		</links>
         <permacrud xmlns="http://open-ils.org/spec/opensrf/IDL/permacrud/v1">
             <actions>
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.invoice-closed-date-user.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.invoice-closed-date-user.sql
new file mode 100644
index 0000000000..d47a9fb2ff
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.invoice-closed-date-user.sql
@@ -0,0 +1,18 @@
+BEGIN;
+
+-- SELECT evergreen.upgrade_deps_block_check('XXX', :eg_version);
+
+ALTER TABLE acq.invoice
+    ADD COLUMN close_date TIMESTAMPTZ,
+    ADD COLUMN closed_by INTEGER REFERENCES actor.usr (id);
+
+-- Add new columns to auditor.acq_invoice_history 
+-- and auditor.acq_invoice_lifecycle;
+SELECT auditor.update_auditors();
+
+-- TODO: default values?
+UPDATE acq.invoice SET close_date = NOW(), closed_by = 1 WHERE complete;
+
+COMMIT;
+-- ROLLBACK;
+
-- 
2.11.0