From 609b8f698f3971af7f066ef41b86e9016c8ca3de Mon Sep 17 00:00:00 2001
From: Chris Sharp <csharp@georgialibraries.org>
Date: Thu, 8 Sep 2016 09:49:32 -0400
Subject: [PATCH] Adding link to provider source for great justice.

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
---
 Open-ILS/examples/fm_IDL.xml                                         | 2 ++
 Open-ILS/src/sql/Pg/example.reporter-extension.sql                   | 1 +
 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq_po_and_invoice_views.sql | 1 +
 3 files changed, 4 insertions(+)

diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index 999559693f..9469f23936 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -10864,6 +10864,7 @@ SELECT  usr,
 			<field reporter:label="Purchase Order ID" name="po_id" reporter:datatype="id"/>
 			<field reporter:label="Purchase Order Name" name="po_name" reporter:datatype="text"/>
 			<field reporter:label="Purchase Order Date/Time" name="po_order_date" reporter:datatype="timestamp"/>
+			<field reporter:label="Provider Link" name="provider_id" reporter:datatype="link"/>	
 			<field reporter:label="Provider Name" name="provider_name" reporter:datatype="text"/>
 			<field reporter:label="Provider Address Link" name="provider_address_id" reporter:datatype="link"/>
 			<field reporter:label="Ordering Agency Link" name="ordering_agency_id" reporter:datatype="link"/>
@@ -10894,6 +10895,7 @@ SELECT  usr,
 		</fields>
 		<links>
 			<link field="po_id" reltype="has_a" key="id" map="" class="acqpo"/>
+			<link field="provider_id" reltype="has_a" key="id" map="" class="acqpro"/>
 			<link field="provider_address_id" reltype="has_a" key="id" map="" class="acqpa"/>
 			<link field="ordering_agency_id" reltype="has_a" key="id" map="" class="aou"/>
 			<link field="ordering_agency_mailing_address" reltype="might_have" key="id" map="" class="aoa"/>
diff --git a/Open-ILS/src/sql/Pg/example.reporter-extension.sql b/Open-ILS/src/sql/Pg/example.reporter-extension.sql
index 949427f4cf..fa737c0568 100644
--- a/Open-ILS/src/sql/Pg/example.reporter-extension.sql
+++ b/Open-ILS/src/sql/Pg/example.reporter-extension.sql
@@ -320,6 +320,7 @@ CREATE OR REPLACE VIEW reporter.acq_purchase_order_view AS
  SELECT  po.id AS po_id,
         po.name AS po_name,
         po.order_date AS po_order_date,
+        provider.id AS provider_id,
         provider.name AS provider_name,
         provider_address.id AS provider_address_id,
         ord_agency.id AS ordering_agency_id,
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq_po_and_invoice_views.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq_po_and_invoice_views.sql
index 19cd830b1a..e906ad0da7 100644
--- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq_po_and_invoice_views.sql
+++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq_po_and_invoice_views.sql
@@ -4,6 +4,7 @@ CREATE OR REPLACE VIEW reporter.acq_purchase_order_view AS
  SELECT  po.id AS po_id,
         po.name AS po_name,
         po.order_date AS po_order_date,
+		provider.id AS provider_id,
         provider.name AS provider_name,
         provider_address.id AS provider_address_id,
         ord_agency.id AS ordering_agency_id,
-- 
2.11.0