From e3c0f4caacb56198c089eb7caec097e3f3533d5d Mon Sep 17 00:00:00 2001
From: Chris Sharp <csharp@georgialibraries.org>
Date: Thu, 8 Sep 2016 09:55:22 -0400
Subject: [PATCH] Adding provider SAN.

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
---
 Open-ILS/examples/fm_IDL.xml                                         | 1 +
 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, 3 insertions(+)

diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index 9469f23936..96fd40d55f 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -10866,6 +10866,7 @@ SELECT  usr,
 			<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 SAN" name="provider_san" 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"/>
 			<field reporter:label="Ordering Agency Name" name="ordering_agency_name" reporter:datatype="text"/>
diff --git a/Open-ILS/src/sql/Pg/example.reporter-extension.sql b/Open-ILS/src/sql/Pg/example.reporter-extension.sql
index fa737c0568..2ac2f33d26 100644
--- a/Open-ILS/src/sql/Pg/example.reporter-extension.sql
+++ b/Open-ILS/src/sql/Pg/example.reporter-extension.sql
@@ -322,6 +322,7 @@ CREATE OR REPLACE VIEW reporter.acq_purchase_order_view AS
         po.order_date AS po_order_date,
         provider.id AS provider_id,
         provider.name AS provider_name,
+        provider.san AS provider_san,
         provider_address.id AS provider_address_id,
         ord_agency.id AS ordering_agency_id,
         ord_agency.name AS ordering_agency_name,
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 e906ad0da7..2609cfa22e 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
@@ -6,6 +6,7 @@ CREATE OR REPLACE VIEW reporter.acq_purchase_order_view AS
         po.order_date AS po_order_date,
 		provider.id AS provider_id,
         provider.name AS provider_name,
+		provider.san AS provider_san,
         provider_address.id AS provider_address_id,
         ord_agency.id AS ordering_agency_id,
         ord_agency.name AS ordering_agency_name,
-- 
2.11.0