[Ils-source] r1434 - trunk/src/com/resolutions/ils/data

[scribe at crosswire.org]

Author: scribe
Date: 2016-04-06 17:26:08 -0700 (Wed, 06 Apr 2016)
New Revision: 1434

Modified:
   trunk/src/com/resolutions/ils/data/UserProfile.java
Log:
Fixed getWorkgroups by adding COMPANYID


Modified: trunk/src/com/resolutions/ils/data/UserProfile.java
===================================================================
--- trunk/src/com/resolutions/ils/data/UserProfile.java	2016-04-07 00:02:34 UTC (rev 1433)
+++ trunk/src/com/resolutions/ils/data/UserProfile.java	2016-04-07 00:26:08 UTC (rev 1434)
@@ -62,7 +62,7 @@
     	" WHERE MG.COMPANYID={COMPANYID} AND UG.COMPANYID={COMPANYID}" +
     	" AND MG.ILSGROUPID=UG.ILSGROUPID AND UG.USERPRID={USERPRID}";
     
-    static String LOOKUPBYEMAIL = "SELECT USERPRNUM, USERPRPASSWD FROM USERPROFILE WHERE COMPANYID={COMPANYID} AND USERPREMAIL={USERPREMAIL}";
+    static String LOOKUPBYEMAIL = "SELECT COMPANYID, USERPRNUM, USERPRPASSWD FROM USERPROFILE WHERE COMPANYID={COMPANYID} AND USERPREMAIL={USERPREMAIL}";
     static String DELETE[] = {
     	"DELETE FROM USERGROUP     WHERE USERPRID={USERPRID} AND COMPANYID={COMPANYID}",
     	"DELETE FROM COURSEATTEMPT WHERE USERPRID={USERPRID} AND COMPANYID={COMPANYID}",
@@ -304,7 +304,7 @@
 */
 
 	static String USERCOURSESUMMARY =
-	"SELECT U.USERPRID, U.USERPRLNAME, U.USERPRFNAME, U.USERPRNUM, U.USERPRADDR2, U.USERPRHIREDATE,  " +
+	"SELECT U.COMPANYID, U.USERPRID, U.USERPRLNAME, U.USERPRFNAME, U.USERPRNUM, U.USERPRADDR2, U.USERPRHIREDATE,  " +
 	" (SELECT MAX(GROUPNAME) FROM USERGROUP UG JOIN ILSGROUP IG ON UG.ILSGROUPID=IG.ILSGROUPID AND UG.USERPRID=U.USERPRID AND GROUPTYPEID=2) WORKGROUP, " +
 	" (SELECT MAX(GROUPNAME) FROM USERGROUP UG JOIN ILSGROUP IG ON UG.ILSGROUPID=IG.ILSGROUPID AND UG.USERPRID=U.USERPRID AND GROUPTYPEID=1) ROLE, " +
 	" SUM(COALESCE(CA.CRS_COMPLETED, 0)) COURSESCOMPLETED, " +
@@ -392,7 +392,7 @@
 		String sql = null;
         if (preloadCourseData) {
 			sql = "SELECT UP2.USERPRID FROM " + tables + " WHERE " + where;
-			sql = USERCOURSESUMMARY + " WHERE U.USERPRID IN ("+sql+") GROUP BY U.USERPRID, U.USERPRLNAME, U.USERPRFNAME, U.USERPRNUM, U.USERPRADDR2, U.USERPRHIREDATE OPTION (RECOMPILE)";
+			sql = USERCOURSESUMMARY + " WHERE U.USERPRID IN ("+sql+") GROUP BY U.COMPANYID, U.USERPRID, U.USERPRLNAME, U.USERPRFNAME, U.USERPRNUM, U.USERPRADDR2, U.USERPRHIREDATE OPTION (RECOMPILE)";
         }
         else sql = "SELECT UP2.COMPANYID, UP2.USERPRID, UP2.USERPRLNAME, UP2.USERPRFNAME, UP2.USERPRNUM, UP2.USERPRADDR2, UP2.USERPRHIREDATE, " +
                         " (SELECT MAX(GROUPNAME) FROM USERGROUP UG JOIN ILSGROUP IG ON UG.ILSGROUPID=IG.ILSGROUPID AND UG.USERPRID=UP2.USERPRID AND GROUPTYPEID=2) WORKGROUP," +