NEWSS 2.0 » Pre-Development

GIT Repo: http://172.16.25.66/gitlab/mleb-solution-domain/smesd100/mleb-iam.git

Microservice: bd_iam

Reference UI:
Login into: https://dev.silverlakemobility.com/hlf/sg/cc_iam/loginModule/login.htm (sysuser/abc123)
And then go to this URL: https://dev.silverlakemobility.com/hlf/sg/cc_iam/mlebFunctionModule/listMLEBFunctionsByPage.htm?firstTime=Y

+*Requirements:*+
+Search Form+
Function code = FUNC_LIST_MLEB_FUNCTION

+Search Action Button:+
Function code = FUNC_LIST_MLEB_FUNCTION

+Count Search Result Action Button:+
Function code = FUNC_LIST_MLEB_FUNCTION

+Search criteria+
MLEB System = systemCode/systemName select item
Function Group = textbox (with standard search criteria)
Function name = textbox (with standard search criteria)
Role name = textbox (with standard search criteria)
Status = char/Status (standard status list)

+Search result+
* Function code
* System name (system code)
* Function Group
* Function Name (function code)
* Status

+SQL query template+

<pre>
select mf.function_code, mf.function_name || ' (' || mf.function_code || ')' , mf.status, mfg.group_name, ms.system_name || ' (' || ms.system_code || ')'
from mleb_iam.mleb_function mf
inner join mleb_iam.mleb_function_group mfg on mf.group_code = mfg.group_code
inner join mleb_iam.mleb_system ms on ms.system_code = mf.system_code
where 1=1
order by ms.system_name asc, mfg.group_name asc, mf.function_name asc
</pre>

(if user input role name in the search criteria)
add this into the SQL query above:
<pre>
inner join mleb_iam.user_role_function urf on urf.function_code = mf.function_code
inner join mleb_iam.user_role ur on ur.role_name = urf.role_name
</pre>

+SQL where clause and search criteria mapping+
* MLEB System -> ms.system_code in (:systemCodes)
* Function Group -> upper(mfg.group_name) = :groupName
* Function name -> upper(mf.function_name) = :functionName
* Role name -> upper(ur.role_name) = :roleName
* Status -> mf.status in (:statuses)

+Form+
Function code = FUNC_SAVE_MLEB_FUNCTION

(No Add Action Button)

+View Action Button:+
Function code = FUNC_GET_MLEB_FUNCTION

+Update Action Button:+
Function code = FUNC_SAVE_UPDATE_MLEB_FUNCTION

+Mandatory fields:+
* functionCode
* functionName
* systemCode
* status

+Duplicate check:+
* functionCode
* functionName