From b984d663c72fd635bb138ca9743b865c7448017a Mon Sep 17 00:00:00 2001
From: Chris Sharp <csharp@georgialibraries.org>
Date: Tue, 14 May 2019 15:14:39 -0400
Subject: [PATCH] LP#1630271: Add a field, change a label.

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
---
 Open-ILS/examples/fm_IDL.xml                       | 9 +++++----
 Open-ILS/src/sql/Pg/example.reporter-extension.sql | 6 ++++--
 2 files changed, 9 insertions(+), 6 deletions(-)

diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index 8fa30f70ef..248d1db0f7 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -10428,7 +10428,7 @@ SELECT  usr,
 		<fields oils_persist:primary="inv_id">
 			<field reporter:label="Internal Invoice ID" name="inv_id" reporter:datatype="link"/>
 			<field reporter:label="Vendor Invoice ID" name="inv_vendor_ident" reporter:datatype="text"/>
-			<field reporter:label="Receive Date/Time" name="recv_date" reporter:datatype="timestamp"/>
+			<field reporter:label="Invoice Date/Time" name="recv_date" reporter:datatype="timestamp"/>
 			<field reporter:label="Provider ID" name="provider_id" reporter:datatype="link"/>
 			<field reporter:label="Provider Name" name="provider_name" reporter:datatype="text"/>
 			<field reporter:label="Provider Code" name="provider_code" reporter:datatype="text"/>
@@ -10443,14 +10443,15 @@ SELECT  usr,
 			<field reporter:label="Total Cost Billed" name="total_cost_billed" reporter:datatype="money"/>
 			<field reporter:label="Total Actual Cost" name="total_actual_cost" reporter:datatype="money"/>
 			<field reporter:label="Total Amount Paid" name="total_amount_paid" reporter:datatype="money"/>
-            <field reporter:label="Close Date" name="close_date" reporter:datatype="timestamp"/>
-            <field reporter:label="Closed By" name="closed_by" reporter:datatype="link"/>
+			<field reporter:label="Close Date" name="close_date" reporter:datatype="timestamp"/>
+			<field reporter:label="Closing Staff Member (Link)" name="closed_by" reporter:datatype="link"/>
+			<field reporter:label="Closing Staff Member Username" name="closed_by_usrname" reporter:datatype="text"/>
 		</fields>
 		<links>
 			<link field="inv_id" reltype="has_a" key="id" map="" class="acqinv"/>
 			<link field="provider_id" reltype="has_a" key="id" map="" class="acqpro"/>
 			<link field="shipper_id" reltype="might_have" key="id" map="" class="acqpro"/>
-            <link field="closed_by" reltype="might_have" key="id" map="" class="au"/>
+			<link field="closed_by" reltype="might_have" key="id" map="" class="au"/>
 		</links>
 	</class>
 	<class id="raposv" controller="open-ils.reporter-store" oils_obj:fieldmapper="reporter::acq_purchase_order_summary_view" oils_persist:tablename="reporter.acq_purchase_order_summary_view" reporter:label="Acquisitions Purchase Order Summary">
diff --git a/Open-ILS/src/sql/Pg/example.reporter-extension.sql b/Open-ILS/src/sql/Pg/example.reporter-extension.sql
index cac69f0996..15fe4c5a7c 100644
--- a/Open-ILS/src/sql/Pg/example.reporter-extension.sql
+++ b/Open-ILS/src/sql/Pg/example.reporter-extension.sql
@@ -379,14 +379,16 @@ CREATE OR REPLACE VIEW reporter.acq_invoice_summary_view AS
            raitac.total_actual_cost AS total_actual_cost,
            raitap.total_amount_paid AS total_amount_paid,
            invoice.close_date,
-           invoice.closed_by
+           invoice.closed_by,
+           closer.usrname AS closed_by_usrname
    FROM    acq.invoice invoice
            JOIN reporter.acq_invoice_total_cost_billed raitcb ON (raitcb.invoice = invoice.id)
            JOIN reporter.acq_invoice_total_actual_cost raitac ON (raitac.invoice = invoice.id)
            JOIN reporter.acq_invoice_total_amount_paid raitap ON (raitap.invoice = invoice.id)
            JOIN acq.provider provider ON (invoice.provider = provider.id)
            LEFT OUTER JOIN acq.provider shipper ON (invoice.shipper = shipper.id)
-           LEFT OUTER JOIN actor.org_unit receiver ON (invoice.receiver = receiver.id);
+           LEFT OUTER JOIN actor.org_unit receiver ON (invoice.receiver = receiver.id)
+           LEFT OUTER JOIN actor.usr closer ON (invoice.closed_by = closer.id);
 
 CREATE VIEW reporter.acq_purchase_order_summary_view AS
 SELECT  po.id,
-- 
2.11.0