[Ils-source] r1403 - trunk/sql

[scribe at crosswire.org]

Author: scribe
Date: 2016-03-02 10:46:19 -0700 (Wed, 02 Mar 2016)
New Revision: 1403

Modified:
   trunk/sql/importusers.properties
Log:
Added new column 15 to allow a user to set as manager of a group


Modified: trunk/sql/importusers.properties
===================================================================
--- trunk/sql/importusers.properties	2016-03-02 17:45:37 UTC (rev 1402)
+++ trunk/sql/importusers.properties	2016-03-02 17:46:19 UTC (rev 1403)
@@ -58,3 +58,9 @@
 ImportFile11=users.csv|INSERT INTO USERGROUP (COMPANYID, ILSGROUPID, USERPRID) select {CompanyID}, (select ilsgroupid from ilsgroup where companyid={CompanyID} and groupname='{14}' and grouptypeid=1), userprid from userprofile where companyid={CompanyID} and userprnum='{0}'
 SQL11=NA
 
+Heading12=Assign Managers
+ImportDupCheck12=SELECT 1 FROM MANAGERGROUP, USERPROFILE, ILSGROUP where MANAGERGROUP.COMPANYID={CompanyID} and USERPROFILE.COMPANYID={CompanyID} and ILSGROUP.COMPANYID={CompanyID} and USERPROFILE.USERPRID=USERGROUP.USERPRID AND ILSGROUP.ILSGROUPID=MANAGERGROUP.ILSGROUPID AND ILSGROUP.GROUPNAME='{15}' AND USERPROFILE.USERPRNUM='{0}' AND ILSGROUP.GROUPTYPEID=2 UNION SELECT 1 WHERE '{15}' = ''
+ImportFile12=users.csv|INSERT INTO MANAGERGROUP (COMPANYID, ILSGROUPID, USERPRID) select {CompanyID}, (select ilsgroupid from ilsgroup where companyid={CompanyID} and groupname='{15}' and grouptypeid=2), userprid from userprofile where companyid={CompanyID} and userprnum='{0}'
+SQL12=NA
+
+