From b54df0ddd0c6a0372327c5aa3668e5a6458fcd64 Mon Sep 17 00:00:00 2001 From: st782s Date: Thu, 4 May 2017 07:48:42 -0400 Subject: [PORTAL-7] Rebase This rebasing includes common libraries and common overlays projects abstraction of components Change-Id: I9a24a338665c7cd058978e8636bc412d9e2fdce8 Signed-off-by: st782s --- .../webapp/WEB-INF/fusion/defs/definitions.xml | 203 +++ .../src/main/webapp/WEB-INF/fusion/jsp/.gitignore | 0 .../src/main/webapp/WEB-INF/fusion/orm/EP.hbm.xml | 1595 ++++++++++++++++++++ .../main/webapp/WEB-INF/fusion/orm/Fusion.hbm.xml | 335 ++++ .../webapp/WEB-INF/fusion/orm/Workflow.hbm.xml | 48 + 5 files changed, 2181 insertions(+) create mode 100644 ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/defs/definitions.xml create mode 100644 ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/jsp/.gitignore create mode 100644 ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/orm/EP.hbm.xml create mode 100644 ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/orm/Fusion.hbm.xml create mode 100644 ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/orm/Workflow.hbm.xml (limited to 'ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion') diff --git a/ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/defs/definitions.xml b/ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/defs/definitions.xml new file mode 100644 index 00000000..433fec8a --- /dev/null +++ b/ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/defs/definitions.xml @@ -0,0 +1,203 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/jsp/.gitignore b/ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/jsp/.gitignore new file mode 100644 index 00000000..e69de29b diff --git a/ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/orm/EP.hbm.xml b/ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/orm/EP.hbm.xml new file mode 100644 index 00000000..bda281c2 --- /dev/null +++ b/ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/orm/EP.hbm.xml @@ -0,0 +1,1595 @@ + + + + + + + + + + + + seq_fn_widget + + + + + + + + + + + + + + + + + + + + + + + + + seq_ep_endpoint + + + + + + + + + + + + seq_ep_endpoints_basic_auth_account + + + + + + + + + + + + + + seq_ep_widget_catalog_parameter + + + + + + + + + + + + + + + + + + + + + + seq_ep_basic_auth_account + + + + + + + + + + + + + + + + + + + + + seq_ep_user_notification + + + + + + + + + + + + + + seq_fn_user + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + seq_ep_microservice + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + seq_ep_microservice_parameter + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + seq_fn_app + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + seq_ep_usrappsrtprf + + + + + + + + + + + seq_ep_usrmanappsrtprf + + + + + + + + + + + seq_ep_usrwidgetsrtprf + + + + + + + + + + + + + + + seq_fn_role + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + app + + + + + + + + + + + + + + + + + seq_fn_pers_user_app_sel + + + + + + + + + + + seq_ep_pers_user_widget_sel + + + + + + + + + + + + seq_ep_user_role_request + + + + + + + + + + + + + + + + + + + seq_ep_user_role_request_det + + + + + + + + + + + + + + + + + + + 'Y' + and (upper(d.wdg_name) like upper(CONCAT('%', :searchQuery, '%')) or upper(d.wdg_desc) like upper(CONCAT('%', :searchQuery, '%'))) + ) + union + ( + select distinct 'Widget' CATEGORY, d.wdg_name NAME, + d.widget_id UUID, + d.wdg_desc TARGET + from ep_widget_catalog d + where d.all_user_flag='Y' + and (upper(d.wdg_name) like upper(CONCAT('%', :searchQuery, '%')) or upper(d.wdg_desc) like upper(CONCAT('%', :searchQuery, '%'))) + ) + union + ( + select distinct 'Widget' CATEGORY, d.wdg_name NAME, + d.widget_id UUID, + d.wdg_desc TARGET + from fn_user a, fn_user_role b, ep_widget_catalog d + where upper(a.org_user_id) = upper( :userId ) + and a.user_id = b.user_id + and b.role_id = 1 + and (upper(d.wdg_name) like upper(CONCAT('%', :searchQuery, '%')) or upper(d.wdg_desc) like upper(CONCAT('%', :searchQuery, '%'))) + ) + ) y + ) t, + (SELECT @rn /*'*/:=/*'*/ 0) t2 order by NAME + ; + + ]]> + + + + + + = start_time) + and a.is_for_all_roles = 'N' + ) a, + ( + select a.user_id, c.role_id, c.app_id, d.APP_NAME + from fn_user a, fn_user_role b, fn_role c, fn_app d + where a.user_id = b.user_id + and a.user_id = :user_id + and b.role_id = c.role_id + and c.app_id = d.app_id + and d.enabled='Y' + )b + where + ( + a.role_id = b.role_id||a.recv_user_id=:user_id + ) + union + ( + select :user_id user_id, notification_id, is_for_online_users, is_for_all_roles, msg_header, msg_description, msg_source,start_Time, end_time, priority, created_date, creator_ID,active_YN + from ep_notification a + where a.notification_id + and (end_time is null || SYSDATE() <= end_time ) + and (start_time is null || SYSDATE() >= start_time) + and a.is_for_all_roles = 'Y' + ) + ) a + where + active_YN = 'Y' + and + not exists + ( + select * from ep_user_notification m where user_id = :user_id and m.notification_id = a.notification_id and is_viewed = 'Y' + ) + order by priority desc, start_Time desc,created_date desc + + + ) t, + (SELECT @rn /*'*/:=/*'*/ 0) t2 + ; + ]]> + + + + + + + + + + + + + + + + + + + + 1) b +union +select fn_role.app_id,fn_app.app_name, fn_role.role_id ,fn_role.role_name +from fn_app, fn_role +where fn_role.app_id = fn_app.app_id and fn_app.enabled='Y' order by app_name + + + + ]]> + + + + + + = DATE_ADD(curdate(),INTERVAL-31 DAY)) + or + (start_time is not null and end_time is null and start_time >= DATE_ADD(curdate(),INTERVAL -31 DAY)) + or + (start_time is null and end_time is not null and end_time >= DATE_ADD(curdate(),INTERVAL -31 DAY)) + or + (start_time is not null and end_time is not null and end_time >= DATE_ADD(curdate(),INTERVAL -31 DAY)) + ) + ) a, + ( + select a.user_id, c.role_id, c.app_id, d.APP_NAME + from fn_user a, fn_user_role b, fn_role c, fn_app d + where a.user_id = b.user_id + and a.user_id = :user_id + and b.role_id = c.role_id + and c.app_id = d.app_id + and d.enabled='Y' + ) b + where + ( + a.role_id = b.role_id||a.recv_user_id=:user_id + ) + union + ( + select + :user_id user_id, b.login_id,notification_id, is_for_online_users, is_for_all_roles, + msg_header, msg_description,msg_source, start_Time, end_time, priority, a.created_date, + creator_ID, a.active_YN + from ep_notification a JOIN fn_user b on b.user_id=a.creator_ID + where a.notification_id + and a.is_for_all_roles = 'Y' + and ( + (start_time is null and end_time is null and a.created_date >= DATE_ADD(curdate(),INTERVAL-31 DAY)) + or + (start_time is not null and end_time is null and start_time >= DATE_ADD(curdate(),INTERVAL -31 DAY)) + or + (start_time is null and end_time is not null and end_time >= DATE_ADD(curdate(),INTERVAL -31 DAY)) + or + (start_time is not null and end_time is not null and end_time >= DATE_ADD(curdate(),INTERVAL -31 DAY)) + ) + ) + ) a left outer join ( + select m.notification_ID, m.is_viewed from ep_user_notification m where user_id = :user_id + ) m + on a.notification_id = m.notification_ID + where + active_YN = 'Y' + + order by start_Time desc,end_time desc + ) t, + (SELECT @rn /*'*/:=/*'*/ 0) t2 where startTime<=SYSDATE() + ]]> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + from CommonWidget where category = :cat order by + sortOrder, title + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/orm/Fusion.hbm.xml b/ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/orm/Fusion.hbm.xml new file mode 100644 index 00000000..f6d22a27 --- /dev/null +++ b/ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/orm/Fusion.hbm.xml @@ -0,0 +1,335 @@ + + + + + + + + + + + + + seq_fn_user + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + seq_fn_role + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + seq_fn_menu + + + + + + + + + + + + + + + + + + + + + + + seq_fn_menu + + + + + + + + + + + + + + + + + + + + + + + + + + + + seq_fn_broadcast_message + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + seq_fn_audit_log + + + + + + + + + + + + + + + + + + + + + + + + + select distinct functionCd from MenuData + + + + from MenuData where menuSetCode = :menu_set_cd and parentMenu is null + + + FROM UrlsAccessible A where upper(A.urlsAccessibleKey.url) = upper(:current_url) + + + + select firstName, lastName from User where id = :user_id + + + + select email from User where id = :user_id + + + + select id, firstName, lastName from User where active = true order by lastName, firstName + + + + select name from Role where id = :role_id + + + + select id, name from Role order by name + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/orm/Workflow.hbm.xml b/ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/orm/Workflow.hbm.xml new file mode 100644 index 00000000..9a853e7f --- /dev/null +++ b/ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/orm/Workflow.hbm.xml @@ -0,0 +1,48 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + -- cgit