1 files changed, 171 insertions, 0 deletions
diff --git a/ecomp-sdk/epsdk-core/src/main/java/org/openecomp/portalsdk/core/service/RoleServiceImpl.java b/ecomp-sdk/epsdk-core/src/main/java/org/openecomp/portalsdk/core/service/RoleServiceImpl.java
new file mode 100644
index 00000000..2e780998
--- /dev/null
+++ b/ecomp-sdk/epsdk-core/src/main/java/org/openecomp/portalsdk/core/service/RoleServiceImpl.java
@@ -0,0 +1,171 @@
+/*-
+ * ================================================================================
+ * eCOMP Portal SDK
+ * ================================================================================
+ * Copyright (C) 2017 AT&T Intellectual Property
+ * ================================================================================
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ * 
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ * 
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ * ================================================================================
+ */
+package org.openecomp.portalsdk.core.service;
+
+import java.sql.Connection;
+import java.sql.SQLException;
+import java.sql.Statement;
+import java.util.Iterator;
+import java.util.List;
+import java.util.Set;
+import java.util.TreeSet;
+
+import javax.sql.DataSource;
+
+import org.openecomp.portalsdk.core.domain.Role;
+import org.openecomp.portalsdk.core.domain.RoleFunction;
+import org.openecomp.portalsdk.core.logging.logic.EELFLoggerDelegate;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+@Service("roleService")
+@Transactional
+public class RoleServiceImpl implements RoleService {
+
+	private EELFLoggerDelegate logger = EELFLoggerDelegate.getLogger(RoleServiceImpl.class);
+
+	@Autowired
+	private DataAccessService dataAccessService;
+
+	DataSource dataSource;
+
+	public DataSource getDataSource() {
+		return dataSource;
+	}
+
+	@Autowired
+	public void setDataSource(DataSource dataSource) {
+		this.dataSource = dataSource;
+	}
+
+	@SuppressWarnings("unchecked")
+	public List<RoleFunction> getRoleFunctions() {
+		// List msgDB = getDataAccessService().getList(Profile.class, null);
+		return getDataAccessService().getList(RoleFunction.class, null);
+	}
+
+	@SuppressWarnings("unchecked")
+	public List<Role> getAvailableChildRoles(Long roleId) {
+		List<Role> availableChildRoles = (List<Role>) getDataAccessService().getList(Role.class, null);
+		if (roleId == null || roleId == 0) {
+			return availableChildRoles;
+		}
+
+		Role currentRole = (Role) getDataAccessService().getDomainObject(Role.class, roleId, null);
+		Set<Role> allParentRoles = new TreeSet<Role>();
+		allParentRoles = getAllParentRolesAsList(currentRole, allParentRoles);
+
+		Iterator<Role> availableChildRolesIterator = availableChildRoles.iterator();
+		while (availableChildRolesIterator.hasNext()) {
+			Role role = availableChildRolesIterator.next();
+			if (!role.getActive() || allParentRoles.contains(role) || role.getId().equals(roleId)) {
+				availableChildRolesIterator.remove();
+			}
+		}
+		return availableChildRoles;
+	}
+
+	@SuppressWarnings("unchecked")
+	private Set<Role> getAllParentRolesAsList(Role role, Set<Role> allParentRoles) {
+		Set<Role> parentRoles = role.getParentRoles();
+		allParentRoles.addAll(parentRoles);
+		Iterator<Role> parentRolesIterator = parentRoles.iterator();
+		while (parentRolesIterator.hasNext()) {
+			getAllParentRolesAsList(parentRolesIterator.next(), allParentRoles);
+		}
+		return allParentRoles;
+	}
+
+	public RoleFunction getRoleFunction(String code) {
+		return (RoleFunction) getDataAccessService().getDomainObject(RoleFunction.class, code, null);
+	}
+
+	public void saveRoleFunction(RoleFunction domainRoleFunction) {
+		getDataAccessService().saveDomainObject(domainRoleFunction, null);
+	}
+
+	public void deleteRoleFunction(RoleFunction domainRoleFunction) {
+		getDataAccessService().deleteDomainObject(domainRoleFunction, null);
+	}
+
+	public Role getRole(Long id) {
+		return (Role) getDataAccessService().getDomainObject(Role.class, id, null);
+	}
+
+	public void saveRole(Role domainRole) {
+		getDataAccessService().saveDomainObject(domainRole, null);
+	}
+
+	public void deleteRole(Role domainRole) {
+		getDataAccessService().deleteDomainObject(domainRole, null);
+	}
+
+	@SuppressWarnings("unchecked")
+	public List<Role> getAvailableRoles() {
+		return getDataAccessService().getList(Role.class, null);
+	}
+
+	@SuppressWarnings("unchecked")
+	@Override
+	public List<Role> getActiveRoles() {
+		String filter = " where active_yn = 'Y' ";
+		return getDataAccessService().getList(Role.class, filter, null, null);
+	}
+
+	public DataAccessService getDataAccessService() {
+		return dataAccessService;
+	}
+
+	public void setDataAccessService(DataAccessService dataAccessService) {
+		this.dataAccessService = dataAccessService;
+	}
+
+	@Override
+	public void deleteDependcyRoleRecord(Long id) {
+		Connection conn = null;
+		Statement stmt = null;
+		try {
+			conn = getDataSource().getConnection();
+			stmt = conn.createStatement();
+			String sql = "delete from fn_user_role where role_id = '" + id + "'";
+			stmt.executeUpdate(sql);
+			stmt.close();
+			conn.close();
+		} catch (Exception e) {
+			logger.error(EELFLoggerDelegate.errorLogger, "deleteDependcyRoleRecord failed", e);
+		} finally {
+			try {
+				if (stmt != null)
+					stmt.close();
+			} catch (SQLException se2) {
+				logger.error(EELFLoggerDelegate.errorLogger, "deleteDependcyRoleRecord failed", se2);
+			}
+			try {
+				if (conn != null)
+					conn.close();
+			} catch (SQLException se) {
+				logger.error(EELFLoggerDelegate.errorLogger, "deleteDependcyRoleRecord failed", se);
+			}
+		}
+
+	}
+
+}