From 39b79e8bf7645c958f56130b8211187f1c197f0f Mon Sep 17 00:00:00 2001
From: rsoulliere <robert.soulliere@mohawkcollege.ca>
Date: Tue, 5 Apr 2011 10:11:44 -0400
Subject: [PATCH] Update sql for adding permissins from Ben Ostrowsky and based
 on http://open-ils.org/dokuwiki/doku.php?id=evergreen-admin:sip.

---
 1.6/admin/sip.xml | 26 ++++++++++++++++++++++----
 2.0/admin/sip.xml | 26 ++++++++++++++++++++++----
 2 files changed, 44 insertions(+), 8 deletions(-)

diff --git a/1.6/admin/sip.xml b/1.6/admin/sip.xml
index 7f670c9..b22021b 100644
--- a/1.6/admin/sip.xml
+++ b/1.6/admin/sip.xml
@@ -98,11 +98,29 @@ max_servers='25'
 					<para>OR use SQL like:</para>
 <screen>
 <userinput>
-INSERT INTO permission.grp_tree (id,name,parent,description,application_perm)
+INSERT INTO permission.grp_tree (id,name,parent,description,application_perm) 
 VALUES (8, 'SIP', 1, 'SIP2 Client Systems', 'group_application.user.sip_client');
-
-INSERT INTO permission.grp_perm_map (grp,perm,depth) 
-VALUES (8,15,0),(8,16,0),(8,17,0),(8,31,0),(8,32,0),(8,48,0),(8,54,0),(8,75,0),(8,82,0);
+ 
+INSERT INTO
+  permission.grp_perm_map (grp, perm, depth, grantable)
+SELECT
+  g.id, p.id, 0, FALSE
+FROM
+  permission.grp_tree g,
+  permission.perm_list p
+WHERE
+  g.name = 'SIP' AND
+  p.code IN (
+    'COPY_CHECKIN',
+    'COPY_CHECKOUT',
+    'RENEW_CIRC',
+    'VIEW_CIRCULATIONS',
+    'VIEW_COPY_CHECKOUT_HISTORY',
+    'VIEW_PERMIT_CHECKOUT',
+    'VIEW_USER',
+    'VIEW_USER_FINES_SUMMARY',
+    'VIEW_USER_TRANSACTIONS'
+);
 </userinput>
 </screen>
 					
diff --git a/2.0/admin/sip.xml b/2.0/admin/sip.xml
index 7f670c9..b22021b 100644
--- a/2.0/admin/sip.xml
+++ b/2.0/admin/sip.xml
@@ -98,11 +98,29 @@ max_servers='25'
 					<para>OR use SQL like:</para>
 <screen>
 <userinput>
-INSERT INTO permission.grp_tree (id,name,parent,description,application_perm)
+INSERT INTO permission.grp_tree (id,name,parent,description,application_perm) 
 VALUES (8, 'SIP', 1, 'SIP2 Client Systems', 'group_application.user.sip_client');
-
-INSERT INTO permission.grp_perm_map (grp,perm,depth) 
-VALUES (8,15,0),(8,16,0),(8,17,0),(8,31,0),(8,32,0),(8,48,0),(8,54,0),(8,75,0),(8,82,0);
+ 
+INSERT INTO
+  permission.grp_perm_map (grp, perm, depth, grantable)
+SELECT
+  g.id, p.id, 0, FALSE
+FROM
+  permission.grp_tree g,
+  permission.perm_list p
+WHERE
+  g.name = 'SIP' AND
+  p.code IN (
+    'COPY_CHECKIN',
+    'COPY_CHECKOUT',
+    'RENEW_CIRC',
+    'VIEW_CIRCULATIONS',
+    'VIEW_COPY_CHECKOUT_HISTORY',
+    'VIEW_PERMIT_CHECKOUT',
+    'VIEW_USER',
+    'VIEW_USER_FINES_SUMMARY',
+    'VIEW_USER_TRANSACTIONS'
+);
 </userinput>
 </screen>
 					
-- 
2.11.0