From d9ec95012aa02a8b798ac192864ab63428ffc4c7 Mon Sep 17 00:00:00 2001
From: Terran McCanna <tmccanna@georgialibraries.org>
Date: Thu, 8 Jul 2021 16:44:36 -0400
Subject: [PATCH] LP1902939 Add Internet Access Level to School

Add new db column to school table and reference in interface.

Signed-off-by: Terran McCanna <tmccanna@georgialibraries.org>
---
 Open-ILS/examples/fm_IDL.xml                                  | 2 ++
 Open-ILS/src/eg2/src/app/staff/admin/server/routing.module.ts | 2 +-
 Open-ILS/src/sql/Pg/600.schema.student_card.sql               | 3 ++-
 3 files changed, 5 insertions(+), 2 deletions(-)

diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index e3337a223a..a5838941b1 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -15683,11 +15683,13 @@ SELECT  usr,
 			<field name="addr_post_code"    reporter:datatype="text"     reporter:label="School Address Postal Code"/>
 			<field name="eg_perm_group"     reporter:datatype="link"     reporter:label="Permission Profile" oils_obj:required="true"/>
 			<field name="home_ou"           reporter:datatype="link"     reporter:label="Home Library" oils_obj:required="true"/>
+            <field name="net_access"        reporter:datatype="link"     reporter:label="Internet Access Level"/>
 		</fields>
         <links>
             <link field="district_id" reltype="has_a" key="id" map="" class="scd"/>
             <link field="eg_perm_group" reltype="has_a" key="id" map="" class="pgt"/>
             <link field="home_ou" reltype="has_a" key="id" map="" class="aou"/>
+            <link field="net_access" reltype="has_a" key="id" map="" class="cnal"/>
         </links>
 		<permacrud xmlns="http://open-ils.org/spec/opensrf/IDL/permacrud/v1">
 			<actions>
diff --git a/Open-ILS/src/eg2/src/app/staff/admin/server/routing.module.ts b/Open-ILS/src/eg2/src/app/staff/admin/server/routing.module.ts
index 99a0303628..2f76675365 100644
--- a/Open-ILS/src/eg2/src/app/staff/admin/server/routing.module.ts
+++ b/Open-ILS/src/eg2/src/app/staff/admin/server/routing.module.ts
@@ -75,7 +75,7 @@ const routes: Routes = [{
     data: [{
         schema: 'student_card',
         table: 'district',
-        fieldOrder: 'id,active,name,code,contact_name,contact_email,file_dir,exceptions_dir,state_id'
+        fieldOrder: 'id,active,name,code,contact_name,contact_email,file_dir,exceptions_dir,state_id,net_access'
     }]
 }, {
     path: 'student_card/school',
diff --git a/Open-ILS/src/sql/Pg/600.schema.student_card.sql b/Open-ILS/src/sql/Pg/600.schema.student_card.sql
index 98f1a4a0e8..499f1409f2 100644
--- a/Open-ILS/src/sql/Pg/600.schema.student_card.sql
+++ b/Open-ILS/src/sql/Pg/600.schema.student_card.sql
@@ -29,7 +29,8 @@ CREATE TABLE student_card.school (
     addr_state          TEXT,
     addr_post_code      TEXT,
     eg_perm_group       INTEGER NOT NULL REFERENCES permission.grp_tree (id),
-    home_ou             INTEGER NOT NULL REFERENCES actor.org_unit (id)
+    home_ou             INTEGER NOT NULL REFERENCES actor.org_unit (id),
+    net_access          INTEGER NOT NULL REFERENCES config.net_access_level (id)
 );
 CREATE UNIQUE INDEX student_card_school_state_id_idx ON student_card.school (district_id, state_id);
 
-- 
2.11.0