blob: e16bb32f91b6a85140e6d154e6f03134b1fed48a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
package org.onap.portal.service;
import java.util.List;
import javax.persistence.EntityManager;
import javax.transaction.Transactional;
import org.onap.portal.domain.dto.transport.LocalRole;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service
@Transactional
public class LocalRoleService {
private final EntityManager entityManager;
@Autowired
public LocalRoleService(EntityManager entityManager) {
this.entityManager = entityManager;
}
public List<LocalRole> getCurrentAppRoleFunctions(final long appId, final String functionCd){
final String query = "select distinct fr.role_id, fr.role_name from fn_role fr, ep_app_function ef, ep_app_role_function epr where fr.role_id = epr.role_id and epr.function_cd = ef.function_cd\n"
+ " and ef.function_cd =:functionCd and epr.app_id =:appId";
return entityManager.createNamedQuery(query).setParameter("appId", appId).setParameter("functionCd", functionCd).getResultList();
}
}
|