adding sdk changes

adding sdk changes

Issue-ID: PORTAL-830
Signed-off-by: Muni Mohan Kunchi <munmohan@att.com>
Change-Id: I0c99d3ab15fcf4c3b34d84658b64114dadbe2577

1 files changed, 17 insertions, 56 deletions

diff --git a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_0_OS.sql b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_0_OS.sql
index a397f2d0..174a4af6 100644
--- a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_0_OS.sql
+++ b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_0_OS.sql
@@ -27,6 +27,23 @@ INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD,
 INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (150022, 'Menus', 10, 60, 'admin#/admin_menu_edit', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', NULL);
 INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (150038,'Notebook',5000,135,'samplePage#/notebook','menu_sample','Y',NULL,NULL,NULL,NULL,'APP','N',NULL);
 
+-- fn_menu - update menu icon
+UPDATE fn_menu SET `IMAGE_SRC`='icon ion-ios-home' WHERE  `LABEL`='Home';
+UPDATE fn_menu SET `IMAGE_SRC`='icon ion-md-pie' WHERE  `LABEL`='Reports';
+UPDATE fn_menu SET `IMAGE_SRC`='ion-md-person' WHERE  `LABEL`='Profile';
+UPDATE fn_menu SET `IMAGE_SRC`='icon ion-md-star' WHERE  `LABEL`='Admin';
+
+-- updating fn_menu ACTION url
+UPDATE fn_menu SET ACTION='v2/welcome' WHERE LABEL='Home';
+UPDATE fn_menu SET ACTION='v2/userProfile' WHERE LABEL='Search';
+UPDATE fn_menu SET ACTION='v2/userProfile/post_search' WHERE LABEL='Import from WEBPHONE';
+UPDATE fn_menu SET ACTION='v2/userProfile/self_profile' WHERE LABEL='Self';
+UPDATE fn_menu SET ACTION='v2/admin/admin' WHERE LABEL='Roles';
+UPDATE fn_menu SET ACTION='v2/admin/role_function_list' WHERE LABEL='Role Functions';
+UPDATE fn_menu SET ACTION='v2/admin/usage_list' WHERE LABEL='Usage';
+UPDATE fn_menu SET ACTION='v2/admin/cache_admin' WHERE LABEL='Cache Admin';
+UPDATE fn_menu SET ACTION='v2/admin/admin_menu_edit' WHERE LABEL='Menus';
+
 -- fn_user
 Insert into fn_user (USER_ID,ORG_ID,MANAGER_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME,PHONE,FAX,CELLULAR,EMAIL,ADDRESS_ID,ALERT_METHOD_CD,HRID,ORG_USER_ID,ORG_CODE,LOGIN_ID,LOGIN_PWD,LAST_LOGIN_DATE,ACTIVE_YN,CREATED_ID,CREATED_DATE,MODIFIED_ID,MODIFIED_DATE,IS_INTERNAL_YN,ADDRESS_LINE_1,ADDRESS_LINE_2,CITY,STATE_CD,ZIP_CODE,COUNTRY_CD,LOCATION_CLLI,ORG_MANAGER_USERID,COMPANY,DEPARTMENT_NAME,JOB_TITLE,TIMEZONE,DEPARTMENT,BUSINESS_UNIT,BUSINESS_UNIT_NAME,COST_CENTER,FIN_LOC_CODE,SILO_STATUS) values (1,null,null,'Demo',null,'User',null,null,null,'demo@email.com',null,null,null,'demo',null,'demo','demo',str_to_date('24-OCT-16','%d-%M-%Y'),'Y',null,str_to_date('17-OCT-16','%d-%M-%Y'),1,str_to_date('24-OCT-16','%d-%M-%Y'),'N',null,null,null,'NJ',null,'US',null,null,null,null,null,10,null,null,null,null,null,null);
 
@@ -36,60 +53,4 @@ Insert into fn_app (APP_ID,APP_NAME,APP_IMAGE_URL,APP_DESCRIPTION,APP_NOTES,APP_
 -- fn_user_role
 Insert into fn_user_role (USER_ID,ROLE_ID,PRIORITY,APP_ID) values (1,1,null,1);
 
-INSERT INTO CR_REPORT(REP_ID, TITLE, DESCR, PUBLIC_YN, REPORT_XML, CREATE_ID, CREATE_DATE, MAINT_ID, MAINT_DATE, MENU_ID, MENU_APPROVED_YN, OWNER_ID, FOLDER_ID, DASHBOARD_TYPE_YN, DASHBOARD_YN) VALUES
-(1, 'test report', 'test report', 'Y', '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
-<customReport pageSize="50" reportType="Linear">
-    <reportName>test report</reportName>
-    <reportDescr>test report</reportDescr>
-    <dbInfo>local</dbInfo>
-    <chartType></chartType>
-    <showChartTitle>false</showChartTitle>
-    <public>false</public>
-    <hideFormFieldAfterRun>false</hideFormFieldAfterRun>
-    <createId>1</createId>
-    <createDate>2019-09-11-04:00</createDate>
-    <reportSQL>SELECT 
-      first_name fi1 
-from fn_user</reportSQL>
-    <frozenColumns>0</frozenColumns>
-    <emptyMessage>Your Search didn''t yield any results.</emptyMessage>
-    <dataGridAlign>left</dataGridAlign>
-    <numFormCols>100</numFormCols>
-    <displayOptions>NNNNNNN</displayOptions>
-    <allowSchedule>N</allowSchedule>
-    <sizedByContent>N</sizedByContent>
-    <comment>N|</comment>
-    <dataSourceList>
-        <dataSource tableId="du0">
-            <tableName>DUAL</tableName>
-            <tablePK></tablePK>
-            <displayName>DUAL</displayName>
-            <dataColumnList>
-                <dataColumn colId="fi1">
-                    <tableId>du0</tableId>
-                    <dbColName>first_name</dbColName>
-                    <colName>first_name</colName>
-                    <displayName>first_name</displayName>
-                    <displayWidth>10</displayWidth>
-                    <displayAlignment>Left</displayAlignment>
-                    <orderSeq>1</orderSeq>
-                    <visible>true</visible>
-                    <calculated>true</calculated>
-                    <colType>VARCHAR2</colType>
-                    <groupBreak>false</groupBreak>
-                    <dbColType>VARCHAR2</dbColType>
-                </dataColumn>
-            </dataColumnList>
-        </dataSource>
-    </dataSourceList>
-    <maxRowsInExcelDownload>500</maxRowsInExcelDownload>
-    <isOneTimeScheduleAllowed>N</isOneTimeScheduleAllowed>
-    <isHourlyScheduleAllowed>N</isHourlyScheduleAllowed>
-    <isDailyScheduleAllowed>N</isDailyScheduleAllowed>
-    <isDailyMFScheduleAllowed>N</isDailyMFScheduleAllowed>
-    <isWeeklyScheduleAllowed>N</isWeeklyScheduleAllowed>
-    <isMonthlyScheduleAllowed>N</isMonthlyScheduleAllowed>
-</customReport>', 1, sysdate(), 1, sysdate(), 'HOME', 'N', 1, NULL, 'N', 'N');
-
-
 commit;
\ No newline at end of file