NEWSS 2.0 » Pre-Development

Initial structure done. Pending ws

- fix org profile modify button does nothing
- move usePrompt hook to own file
- re-organise org profile + user role code

https://dev.silverlakemobility.com/gitlab/mleb-solution-domain/smesd100/mleb-iam/-/commit/b3c05da00efe3b92cf2c23f8f4134dfdcd251bb2

DB View #1:

create or replace view mleb_iam.view_mleb_system_function as
    select null as pk, 0 as level, null as parent, 'ROOT' as child, 'Root' as name,  'A' as status
    union all
    select distinct null as pk, 1 as level, 'ROOT' as parent, 'MS-' || ms.system_code as child, ms.system_name as name, ms.status
    from mleb_iam.mleb_system ms
    union all
    select distinct null as pk, 2 as level, 'MS-' || mf.system_code as parent, 'MFG-' || mfg.group_code as child, mfg.group_name, mfg.status
    from mleb_iam.mleb_function_group mfg inner join mleb_iam.mleb_function mf on mfg.group_code = mf.group_code
    union all
    select mf.function_code as pk, 3 as level, 'MFG-' || mf.group_code as parent, 'MF-' || mf.function_code as child, mf.function_name, mf.status
    from mleb_iam.mleb_function_group mfg inner join mleb_iam.mleb_function mf on mfg.group_code = mf.group_code;

DB View #2

create or replace view mleb_iam.view_mleb_system_function_hierarchy_by_root as
with recursive recur as (
    select vmsf.*, 0 as depth, array[vmsf.seq] as path
    from (select row_number() over (order by qvmsf.level, qvmsf.child) seq, qvmsf.* from mleb_iam.view_mleb_system_function qvmsf) vmsf
    where 1=1 and child = 'ROOT'

    union

    select vmsf_main.*, recur.depth+1, recur.path || vmsf_main.seq
    from (select row_number() over (order by qvmsf.level, qvmsf.child) seq, qvmsf.* from mleb_iam.view_mleb_system_function qvmsf) vmsf_main
        inner join recur on vmsf_main.parent =  recur.child
    where 1=1 )
select recur.*
from recur
order by recur.path;

Finished integration with API

fix temp action req body (ORF + URF page)
https://dev.silverlakemobility.com/gitlab/mleb-solution-domain/smesd100/mleb-iam/-/commit/3499414baea4a4cf7dfdb7617074c2bf63ca0179