protected long addLayoutSet( long layoutSetId, long companyId, long groupId, long layoutSetPrototypeId, UserGroupTemplateInfo userGroupTemplateInfo) throws Exception { Connection con = null; PreparedStatement ps = null; ResultSet rs = null; try { con = DataAccess.getConnection(); StringBundler sb = new StringBundler(5); sb.append("insert into LayoutSet (layoutSetId, groupId, "); sb.append("companyId, privateLayout, logo, logoId, themeId, "); sb.append("colorSchemeId, wapThemeId, wapColorSchemeId, css, "); sb.append("pageCount, settings_, layoutSetPrototypeId) values "); sb.append("(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"); String sql = sb.toString(); ps = con.prepareStatement(sql); ps.setLong(1, layoutSetId); ps.setLong(2, groupId); ps.setLong(3, companyId); ps.setBoolean(4, userGroupTemplateInfo.isPrivateLayout()); ps.setShort(5, userGroupTemplateInfo.getLogo()); ps.setLong(6, userGroupTemplateInfo.getLogoId()); ps.setString(7, userGroupTemplateInfo.getThemeId()); ps.setString(8, userGroupTemplateInfo.getColorSchemeId()); ps.setString(9, userGroupTemplateInfo.getWapThemeId()); ps.setString(10, userGroupTemplateInfo.getWapColorSchemeId()); ps.setString(11, userGroupTemplateInfo.getCss()); ps.setLong(12, userGroupTemplateInfo.getPageCount()); ps.setString(13, userGroupTemplateInfo.getSettings()); ps.setLong(14, layoutSetPrototypeId); ps.execute(); return layoutSetId; } finally { DataAccess.cleanUp(con, ps, rs); } }
protected void updateUserGroup() throws Exception { Connection con = null; PreparedStatement ps = null; ResultSet rs = null; try { con = DataAccess.getConnection(); StringBundler sb = new StringBundler(17); sb.append("select UserGroup.userGroupId as userGroupId, "); sb.append("UserGroup.companyId as companyId, UserGroup.name as "); sb.append("userGroupName, Group_.groupId as groupId, "); sb.append("Group_.creatorUserId as creatorUserId, "); sb.append("LayoutSet.layoutSetId as layoutSetId, "); sb.append("LayoutSet.privateLayout as privateLayout, "); sb.append("LayoutSet.logo as logo, LayoutSet.logoId as logoId, "); sb.append("LayoutSet.themeId as themeId, LayoutSet.colorSchemeId "); sb.append("as colorSchemeId, LayoutSet.wapThemeId as wapThemeId, "); sb.append("LayoutSet.wapColorSchemeId as wapColorSchemeId, "); sb.append("LayoutSet.css as css, LayoutSet.pageCount as "); sb.append("pageCount, LayoutSet.settings_ as settings, "); sb.append("LayoutSet.layoutSetPrototypeId as "); sb.append("layoutSetPrototypeId from UserGroup inner join "); sb.append("Group_ on Group_.classPK = UserGroup.userGroupId "); sb.append("inner join LayoutSet on (LayoutSet.groupId = "); sb.append("Group_.groupId) and (LayoutSet.pageCount > 0)"); String sql = sb.toString(); ps = con.prepareStatement(sql); rs = ps.executeQuery(); while (rs.next()) { long userGroupId = rs.getLong("userGroupId"); long companyId = rs.getLong("companyId"); String userGroupName = rs.getString("userGroupName"); long groupId = rs.getLong("groupId"); long creatorUserId = rs.getLong("creatorUserId"); boolean privateLayout = rs.getBoolean("privateLayout"); long layoutSetPrototypeId = increment(); addLayoutSetPrototype(layoutSetPrototypeId, companyId, userGroupName); long layoutSetPrototypeGroupId = addGroup(companyId, creatorUserId, userGroupName, layoutSetPrototypeId); addPermissions(companyId, creatorUserId, layoutSetPrototypeId); UserGroupTemplateInfo privateUserGroupTemplateInfo = buildUserGroupsTemplatesInfo(rs); boolean oldPrivateLayout = privateUserGroupTemplateInfo.isPrivateLayout(); privateUserGroupTemplateInfo.setPrivateLayout(true); addLayoutSet( increment(), companyId, layoutSetPrototypeGroupId, layoutSetPrototypeId, privateUserGroupTemplateInfo); updateLayout(groupId, layoutSetPrototypeGroupId, oldPrivateLayout); UserGroupTemplateInfo publicUserGroupTemplateInfo = new UserGroupTemplateInfo(); publicUserGroupTemplateInfo.setPrivateLayout(false); addLayoutSet( increment(), companyId, layoutSetPrototypeGroupId, layoutSetPrototypeId, publicUserGroupTemplateInfo); updateUserGroup(userGroupId, privateLayout, layoutSetPrototypeId); } } finally { DataAccess.cleanUp(con, ps, rs); } }
protected UserGroupTemplateInfo buildUserGroupsTemplatesInfo(ResultSet rs) throws Exception { UserGroupTemplateInfo userGroupTemplateInfo = new UserGroupTemplateInfo(); userGroupTemplateInfo.setColorSchemeId(rs.getString("colorSchemeId")); userGroupTemplateInfo.setCompanyId(rs.getLong("companyId")); userGroupTemplateInfo.setCss(rs.getString("css")); userGroupTemplateInfo.setGroupId(rs.getLong("groupId")); userGroupTemplateInfo.setLayoutSetId(rs.getLong("layoutSetId")); userGroupTemplateInfo.setLayoutSetPrototypeId(rs.getLong("layoutSetPrototypeId")); userGroupTemplateInfo.setLogo(rs.getShort("logo")); userGroupTemplateInfo.setLogoId(rs.getLong("logoId")); userGroupTemplateInfo.setPageCount(rs.getLong("pageCount")); userGroupTemplateInfo.setPrivateLayout(rs.getBoolean("privateLayout")); userGroupTemplateInfo.setSettings(rs.getString("settings")); userGroupTemplateInfo.setThemeId(rs.getString("themeId")); userGroupTemplateInfo.setUserGroupId(rs.getLong("userGroupId")); userGroupTemplateInfo.setWapColorSchemeId(rs.getString("wapColorSchemeId")); userGroupTemplateInfo.setWapThemeId(rs.getString("wapThemeId")); return userGroupTemplateInfo; }