Changes made to fix left menu routing

Changes made to fix left menu routing issue with ONAP-PORTAL

Issue-ID: PORTAL-795
Change-Id: I0278049c9d9e95b9a64674fa3f99aff0e9d24a06
Signed-off-by: Sudarshan Kumar <sudarshan.kumar@att.com>

2 files changed, 289 insertions, 0 deletions

diff --git a/ecomp-portal-DB-os/PortalMySql_3_1_Add_1.sql b/ecomp-portal-DB-os/PortalMySql_3_1_Add_1.sql
new file mode 100644
index 00000000..a2483f23
--- /dev/null
+++ b/ecomp-portal-DB-os/PortalMySql_3_1_Add_1.sql
@@ -0,0 +1,145 @@
+-- ---------------------------------------------------------------------------------------------------------------
+-- This is add script #1 for the 3_1 Version of Ecomp Portal database called portal.
+-- It upgrades the database from the 1911 version.
+-- note to database admin: must set the mysql system variable called lower_case_table_names.
+-- it can be set 3 different ways: 
+--                      command-line options (cmd-line), 
+--                      options valid in configuration files (option file), or 
+--                      server system variables (system var). 
+-- it needs to be set to 1, then table names are stored in lowercase on disk and comparisons are not case sensitive. 
+-- -----------------------------------------------------------------------------------------------------------------
+use portal;
+
+set foreign_key_checks=1;
+
+UPDATE
+   fn_menu 
+SET 
+   ACTION = 'applicationsHome', 
+   image_src = 'home'
+WHERE
+   active_yn = 'Y' AND label = 'Home';
+   
+   
+UPDATE
+   fn_menu 
+SET 
+   ACTION = 'appCatalog',
+   image_src= 'apps'
+WHERE
+   active_yn = 'Y' AND label = 'Application Catalog';
+   
+
+   UPDATE
+   fn_menu 
+SET 
+   ACTION = 'widgetCatalog',
+   image_src= 'apps'
+WHERE
+   active_yn = 'Y' AND label = 'Widget Catalog';
+   
+   UPDATE
+   fn_menu 
+SET 
+   ACTION = 'admins' ,
+   image_src= 'star'
+WHERE
+   active_yn = 'Y' AND label = 'Admins';
+   
+   UPDATE
+   fn_menu 
+SET 
+   ACTION = 'roles' ,
+   image_src= 'person'
+WHERE
+   active_yn = 'Y' AND label = 'Roles';
+   
+   
+   UPDATE
+   fn_menu 
+SET 
+   ACTION = 'users',
+   image_src= 'person'
+WHERE
+   active_yn = 'Y' AND label = 'Users';
+   
+   
+   UPDATE
+   fn_menu 
+SET 
+   ACTION = 'portalAdmins',
+   image_src= 'settings'
+WHERE
+   active_yn = 'Y' AND label = 'Portal Admins';
+   
+   
+   UPDATE
+   fn_menu 
+SET 
+   ACTION = 'applications',
+   image_src= 'filing'
+WHERE
+   active_yn = 'Y' AND label = 'Application Onboarding';
+   
+   UPDATE
+   fn_menu 
+SET 
+   ACTION = 'widgetOnboarding',
+   image_src= 'filing'
+WHERE
+   active_yn = 'Y' AND label = 'Widget Onboarding';
+   
+   UPDATE
+   fn_menu 
+SET 
+   ACTION = 'functionalMenu',
+   image_src= 'menu'
+WHERE
+   active_yn = 'Y' AND label = 'Edit Functional Menu';
+ 
+    
+    UPDATE
+   fn_menu 
+SET 
+   ACTION = 'userNotifications',
+   image_src= 'settings'
+WHERE
+   active_yn = 'Y' AND label = 'User Notifications';
+    
+    
+    UPDATE
+   fn_menu 
+SET 
+   ACTION = 'microserviceOnboarding',
+   image_src= 'filing'
+WHERE
+   active_yn = 'Y' AND label = 'Microservice Onboarding';
+
+    
+    
+    UPDATE
+   fn_menu 
+SET 
+   ACTION = 'webAnalytics',
+   image_src= 'pie'
+WHERE
+   active_yn = 'Y' AND label = 'Web Analytics';
+   
+   
+    UPDATE
+   fn_menu 
+SET 
+   ACTION = 'webAnlayticsSource',
+   image_src= 'pie'
+WHERE
+   active_yn = 'Y' AND label = 'Web Analytics Onboarding';
+   
+   UPDATE
+   fn_menu 
+SET 
+   ACTION = 'accountOnboarding',
+   image_src= 'filing'
+WHERE
+   active_yn = 'Y' AND label = 'App Account Management';
+   
+commit;
\ No newline at end of file
diff --git a/ecomp-portal-DB-os/PortalMySql_3_1_Rollback_1.sql b/ecomp-portal-DB-os/PortalMySql_3_1_Rollback_1.sql
new file mode 100644
index 00000000..98a06994
--- /dev/null
+++ b/ecomp-portal-DB-os/PortalMySql_3_1_Rollback_1.sql
@@ -0,0 +1,144 @@
+-- This is rollback script #1 for the 3_1 Version of Ecomp Portal database called portal.
+-- It upgrades the database from the 1911 version.
+-- note to database admin: must set the mysql system variable called lower_case_table_names.
+-- it can be set 3 different ways: 
+--                      command-line options (cmd-line), 
+--                      options valid in configuration files (option file), or 
+--                      server system variables (system var). 
+-- it needs to be set to 1, then table names are stored in lowercase on disk and comparisons are not case sensitive. 
+-- -----------------------------------------------------------------------------------------------------------------
+use portal;
+
+set foreign_key_checks=1;
+
+UPDATE
+   fn_menu 
+SET 
+   ACTION = 'root.applicationsHome', 
+   image_src = 'icon-building-home'
+WHERE
+   active_yn = 'Y' AND label = 'Home';
+   
+   
+UPDATE
+   fn_menu 
+SET 
+   ACTION = 'root.appCatalog',
+   image_src= 'icon-apps-marketplace'
+WHERE
+   active_yn = 'Y' AND label = 'Application Catalog';
+   
+
+   UPDATE
+   fn_menu 
+SET 
+   ACTION = 'root.widgetCatalog',
+   image_src= 'icon-apps-marketplace'
+WHERE
+   active_yn = 'Y' AND label = 'Widget Catalog';
+   
+   UPDATE
+   fn_menu 
+SET 
+   ACTION = 'root.admins' ,
+   image_src= 'icon-star'
+WHERE
+   active_yn = 'Y' AND label = 'Admins';
+   
+   UPDATE
+   fn_menu 
+SET 
+   ACTION = 'root.roles' ,
+   image_src= 'icon-user'
+WHERE
+   active_yn = 'Y' AND label = 'Roles';
+   
+   
+   UPDATE
+   fn_menu 
+SET 
+   ACTION = 'root.users',
+   image_src= 'icon-user'
+WHERE
+   active_yn = 'Y' AND label = 'Users';
+   
+   
+   UPDATE
+   fn_menu 
+SET 
+   ACTION = 'root.portalAdmins',
+   image_src= 'icon-settings'
+WHERE
+   active_yn = 'Y' AND label = 'Portal Admins';
+   
+   
+   UPDATE
+   fn_menu 
+SET 
+   ACTION = 'root.applications',
+   image_src= 'icon-add-widget'
+WHERE
+   active_yn = 'Y' AND label = 'Application Onboarding';
+   
+   UPDATE
+   fn_menu 
+SET 
+   ACTION = 'root.widgetOnboarding',
+   image_src= 'icon-add-widget'
+WHERE
+   active_yn = 'Y' AND label = 'Widget Onboarding';
+   
+   UPDATE
+   fn_menu 
+SET 
+   ACTION = 'root.functionalMenu',
+   image_src= 'icon-edit'
+WHERE
+   active_yn = 'Y' AND label = 'Edit Functional Menu';
+ 
+    
+    UPDATE
+   fn_menu 
+SET 
+   ACTION = 'root.userNotifications',
+   image_src= 'icon-settings'
+WHERE
+   active_yn = 'Y' AND label = 'User Notifications';
+    
+    
+    UPDATE
+   fn_menu 
+SET 
+   ACTION = 'root.microserviceOnboarding',
+   image_src= 'icon-add-widget'
+WHERE
+   active_yn = 'Y' AND label = 'Microservice Onboarding';
+
+    
+    
+    UPDATE
+   fn_menu 
+SET 
+   ACTION = 'root.webAnalytics',
+   image_src= 'icon-misc-piechart'
+WHERE
+   active_yn = 'Y' AND label = 'Web Analytics';
+   
+   
+    UPDATE
+   fn_menu 
+SET 
+   ACTION = 'root.webAnlayticsSource',
+   image_src= 'icon-misc-piechart'
+WHERE
+   active_yn = 'Y' AND label = 'Web Analytics Onboarding';
+   
+   UPDATE
+   fn_menu 
+SET 
+   ACTION = 'root.accountOnboarding',
+   image_src= 'icon-add-widget'
+WHERE
+   active_yn = 'Y' AND label = 'App Account Management';
+   
+ commit;
\ No newline at end of file