2 -- ============LICENSE_START==========================================
4 -- ===================================================================
5 -- Copyright (C) 2019 AT&T Intellectual Property. All rights reserved.
6 -- ===================================================================
7 -- Modifications Copyright (c) 2019 Samsung
8 -- ===================================================================
10 -- Unless otherwise specified, all software contained herein is licensed
11 -- under the Apache License, Version 2.0 (the "License");
12 -- you may not use this software except in compliance with the License.
13 -- You may obtain a copy of the License at
15 -- http://www.apache.org/licenses/LICENSE-2.0
17 -- Unless required by applicable law or agreed to in writing, software
18 -- distributed under the License is distributed on an "AS IS" BASIS,
19 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
20 -- See the License for the specific language governing permissions and
21 -- limitations under the License.
23 -- Unless otherwise specified, all documentation contained herein is licensed
24 -- under the Creative Commons License, Attribution 4.0 Intl. (the "License");
25 -- you may not use this documentation except in compliance with the License.
26 -- You may obtain a copy of the License at
28 -- https://creativecommons.org/licenses/by/4.0/
30 -- Unless required by applicable law or agreed to in writing, documentation
31 -- distributed under the License is distributed on an "AS IS" BASIS,
32 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
33 -- See the License for the specific language governing permissions and
34 -- limitations under the License.
36 -- ============LICENSE_END============================================
41 -- MySQL dump 10.17 Distrib 10.3.14-MariaDB, for debian-linux-gnu (x86_64)
43 -- Host: localhost Database: portal
44 -- ------------------------------------------------------
45 -- Server version 10.3.14-MariaDB-1:10.3.14+maria~bionic
47 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 (15,'Application Usage Report Wid','',1,'<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n<customReport pageSize=\"200\" reportType=\"Linear\">\n <reportName>Application Usage Report Wid</reportName>\n <reportDescr></reportDescr>\n <dbInfo>local</dbInfo>\n <dbType>mysql</dbType>\n <chartType>BarChart3D</chartType>\n <chartWidth>700</chartWidth>\n <chartHeight>500</chartHeight>\n <showChartTitle>false</showChartTitle>\n <public>false</public>\n <hideFormFieldAfterRun>false</hideFormFieldAfterRun>\n <createId>27</createId>\n <createDate>2017-01-28-05:00</createDate>\n <reportSQL>SELECT \n l.date audit_date, \n app_id app_id, \n IF(CHAR_LENGTH(l.app_name) >14, CONCAT(CONCAT(SUBSTR(l.app_name,1,7),\'...\'), SUBSTR(l.app_name, CHAR_LENGTH(l.app_name)-3,CHAR_LENGTH(l.app_name))) , l.app_name) app_name, \n IFNULL(r.ct,0) ct \nfrom\n(\n select a.Date, app_id, app_name\n from (\n select curdate() - INTERVAL (a.a + (10 * b.a) + (100 * c.a)) DAY as Date\n from (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as a\n cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as b\n cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as c\n ) a, \n (\n SELECT \n app_id, app_name\n from\n (\n select @rn := @rn+1 AS rowId, app_id, app_name from \n (\n select app_id, app_name, ct from \n (\n select affected_record_id, count(*) ct\n from fn_audit_log l\n where audit_date > date_add( curdate(), interval -6 day)\n and affected_record_id not in ( 1, -1)\n and activity_cd in (\'tab_access\', \'app_access\')\n and user_id = [USER_ID]\n group by affected_record_id\n ) a, fn_app f\n where a.affected_record_id = f.app_id\n order by ct desc \n ) b,\n (SELECT @rn := 0) t2\n ) mm where rowId <= 4\n )b\n where a.Date between date_add( curdate(), interval -6 day) and curdate()\n) l left outer join\n(\n select app_name, DATE(audit_date) audit_date_1 ,count(*) ct from fn_audit_log a, fn_app b\n where user_id = [USER_ID]\n and audit_date > date_add( curdate(), interval -6 day)\n and activity_cd in (\'tab_access\', \'app_access\')\n and a.affected_record_id = b.app_id\n and b.app_id <> 1\n and b.app_id in \n (\n SELECT \n app_id\n from\n (\n select @rn := @rn+1 AS rowId, app_id from \n (\n select app_id, ct from \n (\n select affected_record_id app_id, count(*) ct\n from fn_audit_log \n where audit_date > date_add( curdate(), interval -6 day)\n and affected_record_id not in ( 1, -1)\n and activity_cd in (\'tab_access\', \'app_access\')\n and user_id = [USER_ID]\n group by affected_record_id\n ) a\n order by ct desc \n ) b,\n (SELECT @rn := 0) t2\n ) mm \n )\n group by app_name, DATE(audit_date)\n) r\non l.Date = r.audit_date_1\nand l.app_name = r.app_name</reportSQL>\n <reportTitle></reportTitle>\n <reportSubTitle></reportSubTitle>\n <reportHeader></reportHeader>\n <frozenColumns>0</frozenColumns>\n <emptyMessage>Your Search didn\'t yield any results.</emptyMessage>\n <dataGridAlign>left</dataGridAlign>\n <reportFooter></reportFooter>\n <numFormCols>1</numFormCols>\n <displayOptions>NNNNNNN</displayOptions>\n <dataContainerHeight>100</dataContainerHeight>\n <dataContainerWidth>100</dataContainerWidth>\n <allowSchedule>N</allowSchedule>\n <multiGroupColumn>N</multiGroupColumn>\n <topDown>N</topDown>\n <sizedByContent>N</sizedByContent>\n <comment>N|</comment>\n <dataSourceList>\n <dataSource tableId=\"du0\">\n <tableName>DUAL</tableName>\n <tablePK></tablePK>\n <displayName>DUAL</displayName>\n <dataColumnList>\n <dataColumn colId=\"audit_date\">\n <tableId>du0</tableId>\n <dbColName>l.date</dbColName>\n <colName>l.date</colName>\n <displayName>audit_date_1</displayName>\n <displayWidth>10</displayWidth>\n <displayWidthInPxls>nullpxpx</displayWidthInPxls>\n <displayAlignment>Left</displayAlignment>\n <orderSeq>1</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupBreak>false</groupBreak>\n <colOnChart>LEGEND</colOnChart>\n <chartSeq>1</chartSeq>\n <chartColor></chartColor>\n <chartLineType></chartLineType>\n <chartSeries>false</chartSeries>\n <dbColType>VARCHAR2</dbColType>\n <chartGroup></chartGroup>\n <yAxis></yAxis>\n </dataColumn>\n <dataColumn colId=\"app_id\">\n <tableId>du0</tableId>\n <dbColName>app_id</dbColName>\n <colName>app_id</colName>\n <displayName>app_id</displayName>\n <displayWidth>10</displayWidth>\n <displayAlignment>Left</displayAlignment>\n <orderSeq>2</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupBreak>false</groupBreak>\n <dbColType>VARCHAR2</dbColType>\n </dataColumn>\n <dataColumn colId=\"app_name\">\n <tableId>du0</tableId>\n <dbColName>IF(CHAR_LENGTH(l.app_name) >14, CONCAT(CONCAT(SUBSTR(l.app_name,1,7),\'...\'), SUBSTR(l.app_name, CHAR_LENGTH(l.app_name)-3,CHAR_LENGTH(l.app_name))) , l.app_name)</dbColName>\n <colName>IF(CHAR_LENGTH(l.app_name) >14, CONCAT(CONCAT(SUBSTR(l.app_name,1,7),\'...\'), SUBSTR(l.app_name, CHAR_LENGTH(l.app_name)-3,CHAR_LENGTH(l.app_name))) , l.app_name)</colName>\n <displayName>app_name</displayName>\n <displayWidth>10</displayWidth>\n <displayWidthInPxls>nullpxpx</displayWidthInPxls>\n <displayAlignment>Left</displayAlignment>\n <orderSeq>3</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupBreak>false</groupBreak>\n <chartSeq>2</chartSeq>\n <chartColor></chartColor>\n <chartLineType></chartLineType>\n <chartSeries>true</chartSeries>\n <dbColType>VARCHAR2</dbColType>\n <chartGroup></chartGroup>\n <yAxis></yAxis>\n </dataColumn>\n <dataColumn colId=\"ct\">\n <tableId>du0</tableId>\n <dbColName>IFNULL(r.ct,0)</dbColName>\n <colName>IFNULL(r.ct,0)</colName>\n <displayName>ct</displayName>\n <displayWidth>10</displayWidth>\n <displayWidthInPxls>nullpxpx</displayWidthInPxls>\n <displayAlignment>Left</displayAlignment>\n <orderSeq>4</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupBreak>false</groupBreak>\n <colOnChart>0</colOnChart>\n <chartSeq>1</chartSeq>\n <chartColor></chartColor>\n <chartLineType></chartLineType>\n <chartSeries>false</chartSeries>\n <dbColType>VARCHAR2</dbColType>\n <chartGroup></chartGroup>\n <yAxis></yAxis>\n </dataColumn>\n </dataColumnList>\n </dataSource>\n </dataSourceList>\n <reportInNewWindow>false</reportInNewWindow>\n <displayFolderTree>false</displayFolderTree>\n <maxRowsInExcelDownload>500</maxRowsInExcelDownload>\n <chartAdditionalOptions>\n <chartOrientation>vertical</chartOrientation>\n <hidechartLegend>N</hidechartLegend>\n <legendPosition>bottom</legendPosition>\n <labelAngle>up90</labelAngle>\n <rangeAxisUpperLimit></rangeAxisUpperLimit>\n <rangeAxisLowerLimit></rangeAxisLowerLimit>\n <animate>true</animate>\n <animateAnimatedChart>true</animateAnimatedChart>\n <stacked>true</stacked>\n <barControls>false</barControls>\n <xAxisDateType>false</xAxisDateType>\n <lessXaxisTickers>false</lessXaxisTickers>\n <timeAxis>true</timeAxis>\n <logScale>false</logScale>\n <topMargin>30</topMargin>\n <bottomMargin>50</bottomMargin>\n <rightMargin>60</rightMargin>\n <leftMargin>100</leftMargin>\n </chartAdditionalOptions>\n <folderId>NULL</folderId>\n <isOneTimeScheduleAllowed>N</isOneTimeScheduleAllowed>\n <isHourlyScheduleAllowed>N</isHourlyScheduleAllowed>\n <isDailyScheduleAllowed>N</isDailyScheduleAllowed>\n <isDailyMFScheduleAllowed>N</isDailyMFScheduleAllowed>\n <isWeeklyScheduleAllowed>N</isWeeklyScheduleAllowed>\n <isMonthlyScheduleAllowed>N</isMonthlyScheduleAllowed>\n</customReport>\n',1,'2019-08-08 08:43:27',1,'2019-08-08 08:43:27','',0,1,NULL,0,0),(18,'Application Usage bar Wid','',1,'<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n<customReport pageSize=\"200\" reportType=\"Linear\">\n <reportName>Application Usage Line Wid</reportName>\n <reportDescr></reportDescr>\n <dbInfo>local</dbInfo>\n <dbType>mysql</dbType>\n <chartType>TimeSeriesChart</chartType>\n <chartMultiSeries>N</chartMultiSeries>\n <chartWidth>700</chartWidth>\n <chartHeight>300</chartHeight>\n <showChartTitle>false</showChartTitle>\n <public>false</public>\n <hideFormFieldAfterRun>false</hideFormFieldAfterRun>\n <createId>27</createId>\n <createDate>2017-01-28-05:00</createDate>\n <reportSQL>SELECT \n l.date audit_date, \n IF(CHAR_LENGTH(l.app_name) >14, CONCAT(CONCAT(SUBSTR(l.app_name,1,7),\'...\'), SUBSTR(l.app_name, CHAR_LENGTH(l.app_name)-3,CHAR_LENGTH(l.app_name))) , l.app_name) app_name, \n IFNULL(r.ct,0) ct \nfrom\n(\n select a.Date, app_id, app_name\n from (\n select curdate() - INTERVAL (a.a + (10 * b.a) + (100 * c.a)) DAY as Date\n from (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as a\n cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as b\n cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as c\n ) a, \n (\n SELECT \n app_id, app_name\n from\n (\n select @rn := @rn+1 AS rowId, app_id, app_name from \n (\n select app_id, app_name, ct from \n (\n select affected_record_id, count(*) ct\n from fn_audit_log l\n where audit_date > date_add( curdate(), interval -30 day)\n and affected_record_id not in ( 1, -1)\n and activity_cd in (\'tab_access\', \'app_access\')\n and user_id = [USER_ID]\n group by affected_record_id\n ) a, fn_app f\n where a.affected_record_id = f.app_id\n order by ct desc \n ) b,\n (SELECT @rn := 0) t2\n ) mm where rowId <= 4\n )b\n where a.Date between date_add( curdate(), interval -30 day) and curdate()\n) l left outer join\n(\n select app_name, DATE(audit_date) audit_date_1 ,count(*) ct from fn_audit_log a, fn_app b\n where user_id = [USER_ID]\n and audit_date > date_add( curdate(), interval -30 day)\n and activity_cd in (\'tab_access\', \'app_access\')\n and a.affected_record_id = b.app_id\n and b.app_id <> 1\n and b.app_id in \n (\n SELECT \n app_id\n from\n (\n select @rn := @rn+1 AS rowId, app_id from \n (\n select app_id, ct from \n (\n select affected_record_id app_id, count(*) ct\n from fn_audit_log \n where audit_date > date_add( curdate(), interval -30 day)\n and affected_record_id not in ( 1, -1)\n and activity_cd in (\'tab_access\', \'app_access\')\n and user_id = [USER_ID]\n group by affected_record_id\n ) a\n order by ct desc \n ) b,\n (SELECT @rn := 0) t2\n ) mm \n )\n group by app_name, DATE(audit_date)\n) r\non l.Date = r.audit_date_1\nand l.app_name = r.app_name</reportSQL>\n <reportTitle></reportTitle>\n <reportSubTitle></reportSubTitle>\n <reportHeader></reportHeader>\n <frozenColumns>0</frozenColumns>\n <emptyMessage>Your Search didn\'t yield any results.</emptyMessage>\n <dataGridAlign>left</dataGridAlign>\n <reportFooter></reportFooter>\n <numFormCols>1</numFormCols>\n <displayOptions>NNNNNNN</displayOptions>\n <dataContainerHeight>100</dataContainerHeight>\n <dataContainerWidth>100</dataContainerWidth>\n <allowSchedule>N</allowSchedule>\n <multiGroupColumn>N</multiGroupColumn>\n <topDown>N</topDown>\n <sizedByContent>N</sizedByContent>\n <comment>N|</comment>\n <dataSourceList>\n <dataSource tableId=\"du0\">\n <tableName>DUAL</tableName>\n <tablePK></tablePK>\n <displayName>DUAL</displayName>\n <dataColumnList>\n <dataColumn colId=\"audit_date\">\n <tableId>du0</tableId>\n <dbColName>l.date</dbColName>\n <colName>l.date</colName>\n <displayName>audit_date_1</displayName>\n <displayWidth>10</displayWidth>\n <displayWidthInPxls>nullpxpx</displayWidthInPxls>\n <displayAlignment>Left</displayAlignment>\n <orderSeq>1</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupBreak>false</groupBreak>\n <colOnChart>LEGEND</colOnChart>\n <chartSeq>1</chartSeq>\n <chartSeries>false</chartSeries>\n <isRangeAxisFilled>false</isRangeAxisFilled>\n <drillinPoPUp>false</drillinPoPUp>\n <dbColType>VARCHAR2</dbColType>\n <enhancedPagination>false</enhancedPagination>\n </dataColumn>\n <dataColumn colId=\"app_name\">\n <tableId>du0</tableId>\n <dbColName>IF(CHAR_LENGTH(l.app_name) >14, CONCAT(CONCAT(SUBSTR(l.app_name,1,7),\'...\'), SUBSTR(l.app_name, CHAR_LENGTH(l.app_name)-3,CHAR_LENGTH(l.app_name))) , l.app_name)</dbColName>\n <colName>IF(CHAR_LENGTH(l.app_name) >14, CONCAT(CONCAT(SUBSTR(l.app_name,1,7),\'...\'), SUBSTR(l.app_name, CHAR_LENGTH(l.app_name)-3,CHAR_LENGTH(l.app_name))) , l.app_name)</colName>\n <displayName>app_name</displayName>\n <displayWidth>10</displayWidth>\n <displayWidthInPxls>nullpxpx</displayWidthInPxls>\n <displayAlignment>Left</displayAlignment>\n <orderSeq>2</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupBreak>false</groupBreak>\n <colOnChart>0</colOnChart>\n <chartSeq>2</chartSeq>\n <chartColor></chartColor>\n <chartLineType></chartLineType>\n <chartSeries>true</chartSeries>\n <isRangeAxisFilled>false</isRangeAxisFilled>\n <drillinPoPUp>false</drillinPoPUp>\n <dbColType>VARCHAR2</dbColType>\n <chartGroup></chartGroup>\n <yAxis></yAxis>\n <enhancedPagination>false</enhancedPagination>\n </dataColumn>\n <dataColumn colId=\"ct\">\n <tableId>du0</tableId>\n <dbColName>IFNULL(r.ct,0)</dbColName>\n <colName>IFNULL(r.ct,0)</colName>\n <displayName>ct</displayName>\n <displayWidth>10</displayWidth>\n <displayWidthInPxls>nullpxpx</displayWidthInPxls>\n <displayAlignment>Left</displayAlignment>\n <orderSeq>3</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupBreak>false</groupBreak>\n <colOnChart>0</colOnChart>\n <chartSeq>1</chartSeq>\n <chartColor></chartColor>\n <chartLineType></chartLineType>\n <chartSeries>false</chartSeries>\n <isRangeAxisFilled>false</isRangeAxisFilled>\n <drillinPoPUp>false</drillinPoPUp>\n <dbColType>VARCHAR2</dbColType>\n <chartGroup></chartGroup>\n <yAxis></yAxis>\n <enhancedPagination>false</enhancedPagination>\n </dataColumn>\n </dataColumnList>\n </dataSource>\n </dataSourceList>\n <reportInNewWindow>false</reportInNewWindow>\n <displayFolderTree>false</displayFolderTree>\n <maxRowsInExcelDownload>500</maxRowsInExcelDownload>\n <chartAdditionalOptions>\n <chartOrientation>vertical</chartOrientation>\n <hidechartLegend>N</hidechartLegend>\n <legendPosition>bottom</legendPosition>\n <labelAngle>down45</labelAngle>\n <animate>true</animate>\n <animateAnimatedChart>true</animateAnimatedChart>\n <stacked>true</stacked>\n <barControls>false</barControls>\n <xAxisDateType>false</xAxisDateType>\n <lessXaxisTickers>false</lessXaxisTickers>\n <timeAxis>true</timeAxis>\n <timeSeriesRender>line</timeSeriesRender>\n <multiSeries>false</multiSeries>\n <showXAxisLabel>false</showXAxisLabel>\n <addXAxisTickers>false</addXAxisTickers>\n <topMargin>30</topMargin>\n <bottomMargin>50</bottomMargin>\n <rightMargin>60</rightMargin>\n <leftMargin>100</leftMargin>\n </chartAdditionalOptions>\n <folderId>NULL</folderId>\n <drillURLInPoPUpPresent>false</drillURLInPoPUpPresent>\n <isOneTimeScheduleAllowed>N</isOneTimeScheduleAllowed>\n <isHourlyScheduleAllowed>N</isHourlyScheduleAllowed>\n <isDailyScheduleAllowed>N</isDailyScheduleAllowed>\n <isDailyMFScheduleAllowed>N</isDailyMFScheduleAllowed>\n <isWeeklyScheduleAllowed>N</isWeeklyScheduleAllowed>\n <isMonthlyScheduleAllowed>N</isMonthlyScheduleAllowed>\n</customReport>\n',1,'2019-08-08 08:43:27',1,'2019-08-08 08:43:27','',0,1,NULL,0,0),(20,'Average time spend on portal','',1,'<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n<customReport pageSize=\"200\" reportType=\"Linear\">\n <reportName>Average time spend on portal</reportName>\n <reportDescr></reportDescr>\n <dbInfo>local</dbInfo>\n <dbType>mysql</dbType>\n <chartType>TimeSeriesChart</chartType>\n <chartMultiSeries>N</chartMultiSeries>\n <chartWidth>700</chartWidth>\n <chartHeight>300</chartHeight>\n <showChartTitle>false</showChartTitle>\n <public>true</public>\n <hideFormFieldAfterRun>false</hideFormFieldAfterRun>\n <createId>27</createId>\n <createDate>2017-01-28-05:00</createDate>\n <reportSQL>SELECT \n d.dat audit_date, \n \'# of Minutes\' app, \n coalesce(diff, null, 0) mins \nfrom\n(\n select * from\n (\n select curdate() - INTERVAL (a.a + (10 * b.a) + (100 * c.a)) DAY as dat\n from (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as a\n cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as b\n cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as c \n ) d where d.dat between date_add( curdate(), interval -30 day) and curdate()\n) d left outer join\n(\n select dat, mi, mx, TIMESTAMPDIFF(MINUTE, coalesce(mi, null, 0), coalesce(mx, null, 0)) + 30 diff\n from\n (\n select DATE(audit_date) dat, coalesce(min(audit_date), null, 0) mi, coalesce(max(audit_date), null, 0) mx\n from fn_audit_log \n where user_id = [USER_ID] and DATE(audit_date) between CURDATE()-300 and CURDATE()\n group by DATE(audit_date)\n ) a\n) a\non a.dat = d.dat\norder by 1</reportSQL>\n <reportTitle></reportTitle>\n <reportSubTitle></reportSubTitle>\n <reportHeader></reportHeader>\n <frozenColumns>0</frozenColumns>\n <emptyMessage>Your Search didn\'t yield any results.</emptyMessage>\n <dataGridAlign>left</dataGridAlign>\n <reportFooter></reportFooter>\n <numFormCols>1</numFormCols>\n <displayOptions>NNNNNNN</displayOptions>\n <dataContainerHeight>100</dataContainerHeight>\n <dataContainerWidth>100</dataContainerWidth>\n <allowSchedule>N</allowSchedule>\n <multiGroupColumn>N</multiGroupColumn>\n <topDown>N</topDown>\n <sizedByContent>N</sizedByContent>\n <comment>N|</comment>\n <dataSourceList>\n <dataSource tableId=\"du0\">\n <tableName>DUAL</tableName>\n <tablePK></tablePK>\n <displayName>DUAL</displayName>\n <dataColumnList>\n <dataColumn colId=\"audit_date\">\n <tableId>du0</tableId>\n <dbColName>d.dat</dbColName>\n <colName>d.dat</colName>\n <displayName>audit_date_1</displayName>\n <displayWidth>10</displayWidth>\n <displayWidthInPxls>nullpxpx</displayWidthInPxls>\n <displayAlignment>Left</displayAlignment>\n <orderSeq>1</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupBreak>false</groupBreak>\n <colOnChart>LEGEND</colOnChart>\n <chartSeq>1</chartSeq>\n <chartSeries>false</chartSeries>\n <isRangeAxisFilled>false</isRangeAxisFilled>\n <drillinPoPUp>false</drillinPoPUp>\n <dbColType>VARCHAR2</dbColType>\n <enhancedPagination>false</enhancedPagination>\n </dataColumn>\n <dataColumn colId=\"app\">\n <tableId>du0</tableId>\n <dbColName>\'# of Minutes\'</dbColName>\n <colName>\'# of Minutes\'</colName>\n <displayName>app</displayName>\n <displayWidth>10</displayWidth>\n <displayWidthInPxls>nullpxpx</displayWidthInPxls>\n <displayAlignment>Left</displayAlignment>\n <orderSeq>2</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupBreak>false</groupBreak>\n <chartSeries>true</chartSeries>\n <dbColType>VARCHAR2</dbColType>\n </dataColumn>\n <dataColumn colId=\"mins\">\n <tableId>du0</tableId>\n <dbColName>coalesce(diff, null, 0)</dbColName>\n <colName>coalesce(diff, null, 0)</colName>\n <displayName>mins</displayName>\n <displayWidth>10</displayWidth>\n <displayWidthInPxls>nullpxpx</displayWidthInPxls>\n <displayAlignment>Left</displayAlignment>\n <orderSeq>3</orderSeq>\n <visible>true</visible>\n <calculated>true</calculated>\n <colType>VARCHAR2</colType>\n <groupBreak>false</groupBreak>\n <colOnChart>0</colOnChart>\n <chartSeq>1</chartSeq>\n <chartColor></chartColor>\n <chartLineType></chartLineType>\n <chartSeries>false</chartSeries>\n <dbColType>VARCHAR2</dbColType>\n <chartGroup></chartGroup>\n <yAxis></yAxis>\n </dataColumn>\n </dataColumnList>\n </dataSource>\n </dataSourceList>\n <reportInNewWindow>false</reportInNewWindow>\n <displayFolderTree>false</displayFolderTree>\n <maxRowsInExcelDownload>500</maxRowsInExcelDownload>\n <chartAdditionalOptions>\n <chartOrientation>vertical</chartOrientation>\n <hidechartLegend>N</hidechartLegend>\n <legendPosition>bottom</legendPosition>\n <labelAngle>down45</labelAngle>\n <animate>true</animate>\n <animateAnimatedChart>true</animateAnimatedChart>\n <stacked>true</stacked>\n <barControls>false</barControls>\n <xAxisDateType>false</xAxisDateType>\n <lessXaxisTickers>false</lessXaxisTickers>\n <timeAxis>true</timeAxis>\n <timeSeriesRender>line</timeSeriesRender>\n <multiSeries>false</multiSeries>\n <showXAxisLabel>false</showXAxisLabel>\n <addXAxisTickers>false</addXAxisTickers>\n <topMargin>30</topMargin>\n <bottomMargin>50</bottomMargin>\n <rightMargin>60</rightMargin>\n <leftMargin>100</leftMargin>\n </chartAdditionalOptions>\n <folderId>NULL</folderId>\n <drillURLInPoPUpPresent>false</drillURLInPoPUpPresent>\n <isOneTimeScheduleAllowed>N</isOneTimeScheduleAllowed>\n <isHourlyScheduleAllowed>N</isHourlyScheduleAllowed>\n <isDailyScheduleAllowed>N</isDailyScheduleAllowed>\n <isDailyMFScheduleAllowed>N</isDailyMFScheduleAllowed>\n <isWeeklyScheduleAllowed>N</isWeeklyScheduleAllowed>\n <isMonthlyScheduleAllowed>N</isMonthlyScheduleAllowed>\n</customReport>\n',1,'2019-08-08 08:43:27',1,'2019-08-08 08:43:27','',0,1,NULL,0,0);
77 'assets/images/tmp/portal1.png',
78 'Some Default Description',
82 'http://localhost:8080/ecompportal',
86 'dR2NABMkxPaFbIbym87ZwQ==',
89 'm00468@portal.onap.org',
99 'images/cache/portal-222865671_37476.png',
102 'http://portal-sdk.simpledemo.onap.org:30212/ONAPPORTALSDK/welcome.htm',
104 'http://portal-sdk:8080/ONAPPORTALSDK/api/v3',
108 '2VxipM8Z3SETg32m3Gp0FvKS6zZ2uCbCw46WDyK6T5E=',
114 'ECOMP-PORTAL-OUTBOX',
121 'images/cache/portal944583064_80711.png',
124 'http://dmaap-bc.simpledemo.onap.org:/ECOMPDBCAPP/dbc#/dmaap',
126 'http://dmaap-bc:8989/ECOMPDBCAPP/api/v2',
130 'okYTaDrhzibcbGVq5mjkVQ==',
136 'ECOMP-PORTAL-OUTBOX',
143 'images/cache/portal956868231_53879.png',
146 'http://sdc.api.fe.simpledemo.onap.org:30206/sdc1/portal',
148 'http://sdc-be:8080/api/v3',
152 'j85yNhyIs7zKYbR1VlwEfNhS6b7Om4l0Gx5O8931sCI=',
158 'ECOMP-PORTAL-OUTBOX',
165 'images/cache/portal1470452815_67021.png',
168 'https://policy.api.simpledemo.onap.org:30219/onap/policy',
170 'https://pap:8443/onap/api/v3',
174 '2VxipM8Z3SETg32m3Gp0FvKS6zZ2uCbCw46WDyK6T5E=',
180 'ECOMP-PORTAL-OUTBOX',
186 'Virtual Infrastructure Deployment',
187 'images/cache/portal-345993588_92550.png',
190 'https://vid.api.simpledemo.onap.org:30200/vid/welcome.htm',
192 'https://vid:8443/vid/api/v3',
196 '2VxipM8Z3SETg32m3Gp0FvKS6zZ2uCbCw46WDyK6T5E=',
201 'S31PrbOzGgL4hg4owgtx47Da',
202 'ECOMP-PORTAL-OUTBOX-90',
209 'images/cache/portal-345993588_92550.png',
212 'https://aai.ui.simpledemo.onap.org:30220/services/aai/webapp/index.html#/viewInspect',
214 'https://aai-sparky-be.onap:8000/api/v2',
218 '4LK69amiIFtuzcl6Gsv97Tt7MLhzo03aoOx7dTvdjKQ=',
224 'ECOMP-PORTAL-OUTBOX',
231 'images/cache/portal-345993588_92550.png',
234 'http://cli.api.simpledemo.onap.org:30260/',
253 'images/cache/portal-345993588_92550.png',
256 'http://msb.api.simpledemo.onap.org:30280/iui/microservices/default.html',
275 'images/cache/portal-345993588_92550.png',
278 'http://so-monitoring:30224',
280 'http://so-monitoring:30224',
295 (11,'LF Acumos Marketplace','images/cache/portal_907838932_26954.png',NULL,NULL,'https://marketplace.acumos.org/#/home',
296 NULL,NULL,'','',NULL,'',1,1,'','','','',2,0,NULL);
300 -- Dumping data for table `ep_app_function`
303 INSERT INTO `ep_app_function` (`id`,`app_id`, `function_cd`, `function_name`) VALUES
304 (12, 1,'menu|menu_acc_admin|*','Admin Account Menu'),
305 (13, 1,'menu|menu_admin|*','Admin Menu'),
306 (14, 1,'menu|menu_home|*','Home Menu'),
307 (15, 1,'menu|menu_logout|*','Logout Menu'),
308 (16, 1,'menu|menu_web_analytics|*','Web Analytics'),
309 (17, 1,'url|addWebAnalyticsReport|*','Add Web Analytics Report'),
310 (18, 1,'url|appsFullList|*','Apps Full List'),
311 (19, 1,'url|centralizedApps|*','Centralized Apps'),
312 (20, 1,'url|edit_notification|*','User Notification'),
313 (21, 1,'url|functionalMenu|*','Functional Menu'),
314 (22, 1,'url|getAdminNotifications|*','Admin Notifications'),
315 (23, 1,'url|getAllWebAnalytics|*','Get All Web Analytics'),
316 (24, 1,'url|getFunctionalMenuRole|*','Get Functional Menu Role'),
317 (25, 1,'url|getNotificationAppRoles|*','Get Notification App Roles'),
318 (26, 1,'url|getUserAppsWebAnalytics|*','Get User Apps Web Analytics'),
319 (27, 1,'url|getUserJourneyAnalyticsReport|*','Get User Journey Report'),
320 (28, 1,'url|get_roles%2f%2a|*','getRolesOfApp'),
321 (29, 1,'url|get_role_functions%2f%2a|*','Get Role Functions'),
322 (30, 1,'url|login|*','Login'),
323 (31, 1,'url|notification_code|*','Notification Code'),
324 (32, 1,'url|role_function_list%2fsaveRoleFunction%2f%2a|*','Save Role Function'),
325 (33, 1,'url|saveNotification|*','publish notifications'),
326 (34, 1,'url|syncRoles|*','SyncRoles'),
327 (35, 1,'url|url_role.htm|*','role page'),
328 (36, 1,'url|url_welcome.htm|*','welcome page'),
329 (37, 1,'url|userAppRoles|*','userAppRoles'),
330 (38, 1,'url|userApps|*','User Apps');
333 -- Dumping data for table `fn_role`
336 INSERT INTO `fn_role` (`id`, `role_name`, `active_yn`, `priority`, `app_id`, `app_role_id`) VALUES
337 (1,'System_Administrator',1,1,NULL,NULL),
338 (16,'Standard_User',1,5,NULL,NULL),
339 (900,'Restricted_App_Role',1,1,NULL,NULL),
340 (950,'Portal_Notification_Admin',1,1,NULL,NULL),
341 (999,'Account_Administrator',1,1,NULL,NULL),
342 (1000,'System_Administrator',1,1,2,1),
343 (1001,'Standard_User',1,1,2,16),
344 (1002,'System_Administrator',1,1,3,1),
345 (1003,'Standard_User',1,1,3,16),
346 (1004,'ADMIN',1,1,4,0),
347 (1005,'TESTOR',1,1,4,1),
348 (1006,'System_Administrator',1,1,5,1),
349 (1007,'Standard_User',1,1,5,16),
350 (1008,'System_Administrator',1,1,6,1),
351 (1009,'Standard_User',1,1,6,16),
352 (1010,'Usage_Analyst',1,1,NULL,NULL),
353 (1011,'View',1,1,7,1),
354 (1012,'Standard_User',1,1,7,16),
355 (2115,'Portal_Usage_Analyst',1,6,NULL,NULL);
358 -- Dumping data for table `ep_app_role_function`
361 INSERT INTO `ep_app_role_function` (`id`, `app_id`, `role_id`, `function_cd`, `role_app_id`) VALUES
362 (1,1,1,'url|login|*',NULL),
363 (2,1,1,'menu|menu_admin|*',NULL),
364 (3,1,1,'menu|menu_home|*',NULL),
365 (4,1,1,'menu|menu_logout|*',NULL),
366 (5,1,16,'url|login|*',NULL),
367 (6,1,16,'menu|menu_home|*',NULL),
368 (7,1,16,'menu|menu_logout|*',NULL),
369 (8,1,950,'url|edit_notification|*',NULL),
370 (9,1,950,'url|getAdminNotifications|*',NULL),
371 (10,1,950,'url|saveNotification|*',NULL),
372 (11,1,999,'url|userAppRoles|*',NULL),
373 (12,1,999,'url|getAdminNotifications|*',NULL),
374 (13,1,999,'url|userApps|*',NULL),
375 (14,1,1010,'menu|menu_web_analytics|*',NULL),
376 (15,1,2115,'menu|menu_web_analytics|*',NULL),
377 (16,1,1,'menu|menu_acc_admin|*',NULL),
378 (17,1,999,'menu|menu_acc_admin|*',NULL),
379 (18,1,999,'url|centralizedApps|*',NULL),
380 (19,1,999,'url|getAllWebAnalytics|*',NULL),
381 (20,1,999,'url|getFunctionalMenuRole|*',NULL),
382 (21,1,999,'url|getNotificationAppRoles|*',NULL),
383 (22,1,999,'url|getUserAppsWebAnalytics|*',NULL),
384 (23,1,999,'url|getUserJourneyAnalyticsReport|*',NULL),
385 (24,1,999,'url|get_roles%2f%2a|*',NULL),
386 (25,1,999,'url|get_role_functions%2f%2a|*',NULL),
387 (26,1,999,'url|notification_code|*',NULL),
388 (27,1,999,'url|role_function_list%2fsaveRoleFunction%2f%2a|*',NULL),
389 (28,1,999,'url|syncRoles|*',NULL);
392 -- Dumping data for table `ep_basic_auth_account`
395 INSERT INTO `ep_basic_auth_account` (`id`, `ext_app_name`, `username`, `password`, `active_yn`) VALUES
396 (1,'JIRA','jira','6APqvG4AU2rfLgCvMdySwQ==',1);
399 -- Dumping data for table `ep_microservice`
402 INSERT INTO `ep_microservice` (`id`, `name`, `description`, `app_Id`, `endpoint_url`, `security_type`, `username`, `password`, `active`) VALUES
403 (1,'News Microservice','News',1,'http://portal-app:8989/ONAPPORTAL/commonWidgets','Basic Authentication','portal','6APqvG4AU2rfLgCvMdySwQ==',1),
404 (2,'Events Microservice','Events',1,'http://portal-app:8989/ONAPPORTAL/commonWidgets','Basic Authentication','portal','6APqvG4AU2rfLgCvMdySwQ==',1),
405 (3,'Resources Microservice','Resources',1,'http://portal-app:8989/ONAPPORTAL/commonWidgets','Basic Authentication','portal','6APqvG4AU2rfLgCvMdySwQ==',1),
406 (4,'Portal-Common-Scheduler Microservice','Portal-Common-Scheduler',1,'http://portal-app:8989/ONAPPORTAL/commonWidgets','Basic Authentication','portal','6APqvG4AU2rfLgCvMdySwQ==',1);
409 -- Dumping data for table `ep_microservice_parameter`
412 INSERT INTO `ep_microservice_parameter` (`id`, `service_id`, `para_key`, `para_value`) VALUES
413 (1,1,'resourceType','NEWS'),
414 (2,2,'resourceType','EVENTS'),
415 (3,3,'resourceType','IMPORTANTRESOURCES'),
416 (4,4,'resourceType',NULL);
419 -- Dumping data for table `ep_widget_catalog`
422 INSERT INTO `ep_widget_catalog` (`wdg_name`, `service_id`, `wdg_desc`, `wdg_file_loc`, `all_user_flag`) VALUES
423 ('News',1,'News','news-widget.zip',1),
424 ('Events',2,'Events','events-widget.zip',1),
425 ('Resources',3,'Resources','resources-widget.zip',1),
426 ('Portal-Common-Scheduler',4,'Portal-Common-Scheduler','portal-common-scheduler-widget.zip',1);
429 -- Dumping data for table `ep_widget_catalog_files`
432 INSERT INTO `ep_widget_catalog_files` (`file_id`, `widget_id`, `widget_name`, `framework_js`, `controller_js`, `markup_html`, `widget_css`) VALUES
433 (1,1,'News','var Portal1Widget = (function(window, undefined) {\n\n var Portal1Widget = Portal1Widget || {};\nfunction extractHostPortApp(src) {\n\nPortal1Widget.microserviceId = 1;\nPortal1Widget.pathArray = src.split( \'/\' );\n\n Portal1Widget.widgetName = 1;\n Portal1Widget.serviceSeperator = Portal1Widget.pathArray[Portal1Widget.pathArray.length - 4]; \n Portal1Widget.commonUrl = src.substring(0, src.lastIndexOf(\"/\" + Portal1Widget.pathArray[Portal1Widget.pathArray.length - 2])); \n \n Portal1Widget.recipientDivDataAttrib = \'data-\' + Portal1Widget.widgetName; \n Portal1Widget.controllerName = \'Portal1Ctrl\'; \n Portal1Widget.readyCssFlag = \'portal1-css-ready\'; \n Portal1Widget.readyCssFlagExpectedValue = \'#bada55\'; \n Portal1Widget.serviceURL = src.substring(0, src.lastIndexOf(\"/\" + Portal1Widget.serviceSeperator)) + \'/portalApi/microservice/proxy/parameter/\' + 1; \n } \n \n extractHostPortApp(document.getElementsByTagName(\'script\')[0].src);\n \n function loadStylesheet(url) { \n var link = document.createElement(\'link\'); \n link.rel = \'stylesheet\'; \n link.type = \'text/css\'; \n link.href = url; \n var entry = document.getElementsByTagName(\'script\')[0]; \n entry.parentNode.insertBefore(link, entry); \n } \n \n function isCssReady(callback) { \n var testElem = document.createElement(\'span\'); \n testElem.id = Portal1Widget.readyCssFlag; \n testElem.style = \'color: #fff\'; \n var entry = document.getElementsByTagName(\'script\')[0]; \n entry.parentNode.insertBefore(testElem, entry); \n \n (function poll() { \n var node = document.getElementById(\'css-ready\'); \n var value; \n if (window.getComputedStyle) { \n value = document.defaultView.getComputedStyle(testElem, null) \n .getPropertyValue(\'color\'); \n } \n else if (node.currentStyle) { \n value = node.currentStyle.color; \n } \n if (value && value === \'rgb(186, 218, 85)\' || value.toLowerCase() === Portal1Widget.readyCssFlagExpectedValue) { \n callback(); \n } else { \n setTimeout(poll, 500); \n } \n })(); \n } \n \n function injectCss(css) { \n var style = document.createElement(\'style\'); \n style.type = \'text/css\'; \n css = css.replace(/\\}/g, \"}\\n\"); \n \n if (style.styleSheet) { \n style.styleSheet.cssText = css; \n } else { \n style.appendChild(document.createTextNode(css)); \n } \n var entry = document.getElementsByTagName(\'script\')[0]; \n entry.parentNode.insertBefore(style, entry); \n } \n \n function loadScript(url, callback) { \n var script = document.createElement(\'script\'); \n script.src = url; \n \n var entry = document.getElementsByTagName(\'script\')[0]; \n entry.parentNode.insertBefore(script, entry); \n \n script.onload = script.onreadystatechange = function() { \n var rdyState = script.readyState; \n if (!rdyState || /complete|loaded/.test(script.readyState)) { \n callback(); \n script.onload = null; \n script.onreadystatechange = null; \n } \n }; \n } \n \n function loadSupportingFiles(callback) { \n callback(); \n } \n \n function getWidgetParams() { \n \n } \n \n function getWidgetData(widgetUrl, callback) { \n var responseData; \n try{ \n jQuery.ajax({ \n url: widgetUrl, \n method: \"GET\", \n xhrFields: { \n withCredentials: true \n }, \n crossDomain: true, \n success: function (result) { \n if (result.isOk == false){ \n \n }else{ \n callback(result); \n } \n } \n }); \n } \n catch(e){ \n \n } \n \n } \n \n function getMarkupContent(markupLocation, callback){ \n \n try{\n jQuery.ajax({ \n url: markupLocation,\n method: \"GET\", \n xhrFields: { \n withCredentials: true \n }, \n crossDomain: true, \n success: function (result) { \n if (result.isOk == false){ \n \n }else{ \n callback(result); \n } \n } \n }); \n }\n catch(e){\n \n }\n } \n \n function renderWidget(data, location, $controllerProvider) { \n var div = document.createElement(\'div\'); \n getMarkupContent(Portal1Widget.commonUrl + \"/markup/\" + Portal1Widget.widgetName, function(div){\n location.append(div); \n Portal1Widget.widgetData = data;\n app.controllerProvider.register(Portal1Widget.controllerName, Portal1Widget.controller); \n var mController = angular.element(document.getElementById(\"widgets\")); \n mController.scope().activateThis(location); \n });\n \n } \n \n function printAllArtifacts(moduleName, controllerName) { \n var queue = angular.module(moduleName)._invokeQueue; \n for(var i=0;i<queue.length;i++) { \n var call = queue[i]; \n console.log(i + \'. \' + call[0] + \' - \' + call[1] + \' - \' + call[2][0]); \n } \n } \n \n function get(name){ \n if(name=(new RegExp(\'[?&]\'+encodeURIComponent(name)+\'=([^&]*)\')).exec(location.search)) \n return decodeURIComponent(name[1]); \n } \n \n loadSupportingFiles(function() { \n loadStylesheet(Portal1Widget.commonUrl + \'/\' + Portal1Widget.widgetName + \'/style.css\'); \n loadScript(Portal1Widget.commonUrl + \'/\' + Portal1Widget.widgetName + \'/controller.js\', \n function() { \n $(\'[\'+ Portal1Widget.recipientDivDataAttrib + \']\').each(function() { \n var location = jQuery(this); \n location.removeAttr(Portal1Widget.recipientDivDataAttrib); \n var id = location.attr(Portal1Widget.recipientDivDataAttrib); \n getWidgetData(Portal1Widget.serviceURL, function(data) { \n isCssReady(function(){ \n renderWidget(data, location); \n }); \n }); \n }); \n } \n ); \n }); \n \n return Portal1Widget; \n})(window); \n ','Portal1Widget.controller = function Portal1Ctrl($rootScope, applicationsService , $log,\n $window, userProfileService, $scope, $cookies, $timeout, $interval,\n $uibModal, dashboardService, ngDialog) {Portal1Widget=Portal1Widget||{};var res = Portal1Widget.widgetData;\n \n var _this = this; \n\n //activate spinner\n this.isLoading = true;\n $scope.getUserAppsIsDone = false;\n this.userProfileService = userProfileService;\n $scope.demoNum = 1;\n $scope.event_content_show = false;\n $scope.widgetData = [];\n\n $scope.editWidgetModalPopup = function(availableData, resourceType) {\n\n $scope.editData = JSON.stringify(availableData);\n $scope.availableDataTemp = $scope.availableData;\n \n };\n \n /*Setting News data*/\n $scope.newsData = [];\n $scope.updateNews = function() {\n $scope.newsData.length=0;\n //dashboardService.getCommonWidgetData(\'NEWS\').then(function(res) {\n // $log.info(res.message);\n var newsDataJsonArray = res.response.items;\n for (var i = 0; i < newsDataJsonArray.length; i++) {\n $scope.newsData.push(newsDataJsonArray[i]);\n }\n //})[\'catch\'](function(err) {\n // $log.error(\'dashboard controller: failed to get news list\', err);\n // _this.isLoading = false;\n //});\n }\n $scope.updateNews();\n\n }\n\n;Portal1Widget.controller.$inject = [\'$rootScope\',\'applicationsService\',\'$log\',\'$window\',\'userProfileService\',\'$scope\',\'$cookies\',\'$timeout\',\'$interval\',\'$uibModal\',\'dashboardService\',\'ngDialog\'];','<div id=\"widget-news\" ng-controller=\"Portal1Ctrl\" class=\"widget-news-main\">\n <div att-gridster-item-body class=\"information-section-gridsterContent\">\n <div class=\"resources\">\n <ul ng-show=\"newsData.length!=0\">\n <li ng-repeat=\"item in newsData\"><a id=\"new-widget-{{item.id}}\"\n href=\"{{item.href}}\" target=\"_blank\" ng-bind=\"item.title\"></a></li>\n </ul>\n <div ng-hide=\"newsData.length!=0\">\n <div class=\"activity-error-container\"\n style=\"background: rgb(255, 255, 255); overflow: hidden !important; width: 100%;\">\n <div class=\"activity-error-block\">\n <i class=\"icon-information full-linear-icon-information\"\n style=\"margin-left: 125px; font-size: 90px\"></i> <br>\n <div class=\"activity-error-msg1\">There\'s currently no\n news available.</div>\n </div>\n </div>\n </div>\n </div>\n </div>\n</div>\n','\n.portal-widget-panel-container {\n margin-left:150px;\n width:1500px;\n}\n\n\n.portal-widget-panel-fixed-panel {\n min-height: 300px;\n max-height: 1300px;\n overflow: auto;\n}\n\n.portal-widget-panel-double-middle {\n min-height: 660px;\n max-height: 660px;\n overflow: auto;\n}\n\n.portal-widget-panel-row {\n margin-right: 0px;\n margin-left: 0px;\n width: 2800px;\n}\n\n/*Increases the width of the card/panel */\n.portal-widget-panel-panel-default {\n width:450px\n}\n\n/*Controls the spacing between the cards */\n.portal-widget-panel-col-sm-3 {\n width:20.5%\n}\n\n.portal-widget-panel-top {\n top: 15px;\n left: 15px;\n}\n\n#portal1-css-ready {\ncolor: #bada55 !important;\n}'),(2,2,'Events','var Portal2Widget = (function(window, undefined) { \n \n var Portal2Widget = Portal2Widget || {}; \n function extractHostPortApp(src) { \n \n Portal2Widget.microserviceId = 2; \n Portal2Widget.pathArray = src.split( \'/\' ); \n \n Portal2Widget.widgetName = 2;\n Portal2Widget.serviceSeperator = Portal2Widget.pathArray[Portal2Widget.pathArray.length - 4]; \n Portal2Widget.commonUrl = src.substring(0, src.lastIndexOf(\"/\" + Portal2Widget.pathArray[Portal2Widget.pathArray.length - 2])); \n \n Portal2Widget.recipientDivDataAttrib = \'data-\' + Portal2Widget.widgetName; \n Portal2Widget.controllerName = \'Portal2Ctrl\'; \n Portal2Widget.readyCssFlag = \'portal2-css-ready\'; \n Portal2Widget.readyCssFlagExpectedValue = \'#bada55\'; \n Portal2Widget.serviceURL = src.substring(0, src.lastIndexOf(\"/\" + Portal2Widget.serviceSeperator)) + \'/portalApi/microservice/proxy/parameter/\' + 2; \n } \n \n extractHostPortApp(document.getElementsByTagName(\'script\')[0].src);\n \n function loadStylesheet(url) { \n var link = document.createElement(\'link\'); \n link.rel = \'stylesheet\'; \n link.type = \'text/css\'; \n link.href = url; \n var entry = document.getElementsByTagName(\'script\')[0]; \n entry.parentNode.insertBefore(link, entry); \n } \n \n function isCssReady(callback) { \n var testElem = document.createElement(\'span\'); \n testElem.id = Portal2Widget.readyCssFlag; \n testElem.style = \'color: #fff\'; \n var entry = document.getElementsByTagName(\'script\')[0]; \n entry.parentNode.insertBefore(testElem, entry); \n \n (function poll() { \n var node = document.getElementById(\'css-ready\'); \n var value; \n if (window.getComputedStyle) { \n value = document.defaultView.getComputedStyle(testElem, null) \n .getPropertyValue(\'color\'); \n } \n else if (node.currentStyle) { \n value = node.currentStyle.color; \n } \n if (value && value === \'rgb(186, 218, 85)\' || value.toLowerCase() === Portal2Widget.readyCssFlagExpectedValue) { \n callback(); \n } else { \n setTimeout(poll, 500); \n } \n })(); \n } \n \n function injectCss(css) { \n var style = document.createElement(\'style\'); \n style.type = \'text/css\'; \n css = css.replace(/\\}/g, \"}\\n\"); \n \n if (style.styleSheet) { \n style.styleSheet.cssText = css; \n } else { \n style.appendChild(document.createTextNode(css)); \n } \n var entry = document.getElementsByTagName(\'script\')[0]; \n entry.parentNode.insertBefore(style, entry); \n } \n \n function loadScript(url, callback) { \n var script = document.createElement(\'script\'); \n script.src = url; \n \n var entry = document.getElementsByTagName(\'script\')[0]; \n entry.parentNode.insertBefore(script, entry); \n \n script.onload = script.onreadystatechange = function() { \n var rdyState = script.readyState; \n if (!rdyState || /complete|loaded/.test(script.readyState)) { \n callback(); \n script.onload = null; \n script.onreadystatechange = null; \n } \n }; \n } \n \n function loadSupportingFiles(callback) { \n callback(); \n } \n \n function getWidgetParams() { \n \n } \n \n function getWidgetData(widgetUrl, callback) { \n var responseData; \n try{ \n jQuery.ajax({ \n url: widgetUrl, \n method: \"GET\", \n xhrFields: { \n withCredentials: true \n }, \n crossDomain: true, \n success: function (result) { \n if (result.isOk == false){ \n \n }else{ \n callback(result); \n } \n } \n }); \n } \n catch(e){ \n \n } \n \n } \n \n function getMarkupContent(markupLocation, callback){ \n \n try{\n jQuery.ajax({ \n url: markupLocation,\n method: \"GET\", \n xhrFields: { \n withCredentials: true \n }, \n crossDomain: true, \n success: function (result) { \n if (result.isOk == false){ \n \n }else{ \n callback(result); \n } \n } \n }); \n }\n catch(e){\n \n }\n } \n \n function renderWidget(data, location, $controllerProvider) { \n var div = document.createElement(\'div\'); \n getMarkupContent(Portal2Widget.commonUrl + \"/markup/\" + Portal2Widget.widgetName, function(div){\n location.append(div); \n Portal2Widget.widgetData = data;\n app.controllerProvider.register(Portal2Widget.controllerName, Portal2Widget.controller); \n var mController = angular.element(document.getElementById(\"widgets\")); \n mController.scope().activateThis(location); \n });\n \n } \n \n function printAllArtifacts(moduleName, controllerName) { \n var queue = angular.module(moduleName)._invokeQueue; \n for(var i=0;i<queue.length;i++) { \n var call = queue[i]; \n console.log(i + \'. \' + call[0] + \' - \' + call[1] + \' - \' + call[2][0]); \n } \n } \n \n function get(name){ \n if(name=(new RegExp(\'[?&]\'+encodeURIComponent(name)+\'=([^&]*)\')).exec(location.search)) \n return decodeURIComponent(name[1]); \n } \n \n loadSupportingFiles(function() { \n loadStylesheet(Portal2Widget.commonUrl + \'/\' + Portal2Widget.widgetName + \'/style.css\'); \n loadScript(Portal2Widget.commonUrl + \'/\' + Portal2Widget.widgetName + \'/controller.js\', \n function() { \n $(\'[\'+ Portal2Widget.recipientDivDataAttrib + \']\').each(function() { \n var location = jQuery(this); \n location.removeAttr(Portal2Widget.recipientDivDataAttrib); \n var id = location.attr(Portal2Widget.recipientDivDataAttrib); \n getWidgetData(Portal2Widget.serviceURL, function(data) { \n isCssReady(function(){ \n renderWidget(data, location); \n }); \n }); \n }); \n } \n ); \n }); \n \n return Portal2Widget; \n})(window); \n ','Portal2Widget.controller = function Portal2Ctrl($rootScope, applicationsService , $log,\n $window, userProfileService, $scope, $cookies, $timeout, $interval,\n $uibModal, dashboardService, ngDialog) {Portal2Widget=Portal2Widget||{};var res = Portal2Widget.widgetData;\n var _this = this;\n\n //activate spinner\n this.isLoading = true;\n $scope.getUserAppsIsDone = false;\n this.userProfileService = userProfileService;\n $scope.demoNum = 1;\n $scope.event_content_show = false;\n $scope.widgetData = [];\n\n $scope.editWidgetModalPopup = function(availableData, resourceType) {\n\n $scope.editData = JSON.stringify(availableData);\n $scope.availableDataTemp = $scope.availableData;\n \n };\n /*Setting News data*/\n $scope.eventData = [];\n $scope.updateEvents = function() {\n\n $scope.eventData.length=0;\n //dashboardService.getCommonWidgetData(\'EVENTS\').then(function(res) {\n var eventDataJsonArray = res.response.items; \n for (var i = 0; i < eventDataJsonArray.length; i++) {\n if(eventDataJsonArray[i].eventDate !=null) {\n // yyyy-mm-dd\n eventDataJsonArray[i].year = eventDataJsonArray[i].eventDate.substring(2,4);\n eventDataJsonArray[i].mon = eventDataJsonArray[i].eventDate.substring(5,7);\n eventDataJsonArray[i].day = eventDataJsonArray[i].eventDate.substring(8,10);\n }\n $scope.eventData.push(eventDataJsonArray[i]);\n }\n //})[\'catch\'](function(err) {\n // $log.error(\'dashboard controller: failed to get Events list\', err);\n // _this.isLoading = false;\n //});\n }\n $scope.updateEvents();\n\n\n }\n;Portal2Widget.controller.$inject = [\'$rootScope\',\'applicationsService\',\'$log\',\'$window\',\'userProfileService\',\'$scope\',\'$cookies\',\'$timeout\',\'$interval\',\'$uibModal\',\'dashboardService\',\'ngDialog\'];','<div id=\"widget-events\" ng-controller=\"Portal2Ctrl\" class=\"widget-news-main\">\n <div att-gridster-item-body\n class=\"information-section-gridsterContent\">\n <div class=\"events\">\n <ul ng-show=\"eventData.length!=0\">\n <li ng-repeat=\"event in eventData\">\n <div ng-click=\"event_content_show=!event_content_show\">\n <div class=\"events-date\">{{event.mon}}/{{event.day}}/{{event.year}}\n </div>\n <div>\n <div class=\"event-title-div\">\n <p ng-bind=\"event.title\"></p>\n </div>\n <div>\n <span class=\"icon-chevron-up\" ng-if=\"event_content_show\"\n style=\"color: #888; font-size: 22px;\"></span> <span\n class=\"icon-chevron-down\" ng-if=\"!event_content_show\"\n style=\"color: #888; font-size: 22px;\"></span>\n\n </div>\n <div style=\"clear: both;\"></div>\n </div>\n </div>\n <div class=\"events-content\" ng-show=\"event_content_show\">\n <div class=\"events-content-body\">\n <a id=\"event-widget-{{event.id}}\" class=\"events-link\" ng-href=\"{{event.href}}\"\n target=\"_blank\"> <span ng-bind=\"event.content\"></span>\n </a>\n </div>\n <div></div>\n </div>\n </li>\n\n\n </ul>\n <div ng-hide=\"eventData.length!=0\">\n <div class=\"activity-error-container\"\n style=\"background: rgb(255, 255, 255); overflow: hidden !important; width: 100%;\">\n <div class=\"activity-error-block\">\n <i class=\"icon-information full-linear-icon-information\"\n style=\"margin-left: 125px; font-size: 90px\"></i> <br>\n <div class=\"activity-error-msg1\">There\'s currently no\n event available.</div>\n </div>\n </div>\n </div>\n </div>\n </div>\n</div>\n','\n.portal-widget-panel-container {\n margin-left:150px;\n width:1500px;\n}\n\n\n.portal-widget-panel-fixed-panel {\n min-height: 300px;\n max-height: 1300px;\n overflow: auto;\n}\n\n.portal-widget-panel-double-middle {\n min-height: 660px;\n max-height: 660px;\n overflow: auto;\n}\n\n.portal-widget-panel-row {\n margin-right: 0px;\n margin-left: 0px;\n width: 2800px;\n}\n\n/*Increases the width of the card/panel */\n.portal-widget-panel-panel-default {\n width:450px\n}\n\n/*Controls the spacing between the cards */\n.portal-widget-panel-col-sm-3 {\n width:20.5%\n}\n\n.portal-widget-panel-top {\n top: 15px;\n left: 15px;\n}\n\n#portal2-css-ready {\ncolor: #bada55 !important;\n}'),(3,3,'Resources','var Portal3Widget = (function(window, undefined) { \n \n var Portal3Widget = Portal3Widget || {}; \n function extractHostPortApp(src) { \n \n Portal3Widget.microserviceId = 3; \n Portal3Widget.pathArray = src.split( \'/\' ); \n \n Portal3Widget.widgetName = 3;\n Portal3Widget.serviceSeperator = Portal3Widget.pathArray[Portal3Widget.pathArray.length - 4]; \n Portal3Widget.commonUrl = src.substring(0, src.lastIndexOf(\"/\" + Portal3Widget.pathArray[Portal3Widget.pathArray.length - 2])); \n \n Portal3Widget.recipientDivDataAttrib = \'data-\' + Portal3Widget.widgetName; \n Portal3Widget.controllerName = \'Portal3Ctrl\'; \n Portal3Widget.readyCssFlag = \'portal3-css-ready\'; \n Portal3Widget.readyCssFlagExpectedValue = \'#bada55\'; \n Portal3Widget.serviceURL = src.substring(0, src.lastIndexOf(\"/\" + Portal3Widget.serviceSeperator)) + \'/portalApi/microservice/proxy/parameter/\' + 3; \n } \n \n extractHostPortApp(document.getElementsByTagName(\'script\')[0].src);\n \n function loadStylesheet(url) { \n var link = document.createElement(\'link\'); \n link.rel = \'stylesheet\'; \n link.type = \'text/css\'; \n link.href = url; \n var entry = document.getElementsByTagName(\'script\')[0]; \n entry.parentNode.insertBefore(link, entry); \n } \n \n function isCssReady(callback) { \n var testElem = document.createElement(\'span\'); \n testElem.id = Portal3Widget.readyCssFlag; \n testElem.style = \'color: #fff\'; \n var entry = document.getElementsByTagName(\'script\')[0]; \n entry.parentNode.insertBefore(testElem, entry); \n \n (function poll() { \n var node = document.getElementById(\'css-ready\'); \n var value; \n if (window.getComputedStyle) { \n value = document.defaultView.getComputedStyle(testElem, null) \n .getPropertyValue(\'color\'); \n } \n else if (node.currentStyle) { \n value = node.currentStyle.color; \n } \n if (value && value === \'rgb(186, 218, 85)\' || value.toLowerCase() === Portal3Widget.readyCssFlagExpectedValue) { \n callback(); \n } else { \n setTimeout(poll, 500); \n } \n })(); \n } \n \n function injectCss(css) { \n var style = document.createElement(\'style\'); \n style.type = \'text/css\'; \n css = css.replace(/\\}/g, \"}\\n\"); \n \n if (style.styleSheet) { \n style.styleSheet.cssText = css; \n } else { \n style.appendChild(document.createTextNode(css)); \n } \n var entry = document.getElementsByTagName(\'script\')[0]; \n entry.parentNode.insertBefore(style, entry); \n } \n \n function loadScript(url, callback) { \n var script = document.createElement(\'script\'); \n script.src = url; \n \n var entry = document.getElementsByTagName(\'script\')[0]; \n entry.parentNode.insertBefore(script, entry); \n \n script.onload = script.onreadystatechange = function() { \n var rdyState = script.readyState; \n if (!rdyState || /complete|loaded/.test(script.readyState)) { \n callback(); \n script.onload = null; \n script.onreadystatechange = null; \n } \n }; \n } \n \n function loadSupportingFiles(callback) { \n callback(); \n } \n \n function getWidgetParams() { \n \n } \n \n function getWidgetData(widgetUrl, callback) { \n var responseData; \n try{ \n jQuery.ajax({ \n url: widgetUrl, \n method: \"GET\", \n xhrFields: { \n withCredentials: true \n }, \n crossDomain: true, \n success: function (result) { \n if (result.isOk == false){ \n \n }else{ \n callback(result); \n } \n } \n }); \n } \n catch(e){ \n \n } \n \n } \n \n function getMarkupContent(markupLocation, callback){ \n \n try{\n jQuery.ajax({ \n url: markupLocation,\n method: \"GET\", \n xhrFields: { \n withCredentials: true \n }, \n crossDomain: true, \n success: function (result) { \n if (result.isOk == false){ \n \n }else{ \n callback(result); \n } \n } \n }); \n }\n catch(e){\n \n }\n } \n \n function renderWidget(data, location, $controllerProvider) { \n var div = document.createElement(\'div\'); \n getMarkupContent(Portal3Widget.commonUrl + \"/markup/\" + Portal3Widget.widgetName, function(div){\n location.append(div); \n Portal3Widget.widgetData = data;\n app.controllerProvider.register(Portal3Widget.controllerName, Portal3Widget.controller); \n var mController = angular.element(document.getElementById(\"widgets\")); \n mController.scope().activateThis(location); \n });\n \n } \n \n function printAllArtifacts(moduleName, controllerName) { \n var queue = angular.module(moduleName)._invokeQueue; \n for(var i=0;i<queue.length;i++) { \n var call = queue[i]; \n console.log(i + \'. \' + call[0] + \' - \' + call[1] + \' - \' + call[2][0]); \n } \n } \n \n function get(name){ \n if(name=(new RegExp(\'[?&]\'+encodeURIComponent(name)+\'=([^&]*)\')).exec(location.search)) \n return decodeURIComponent(name[1]); \n } \n \n loadSupportingFiles(function() { \n loadStylesheet(Portal3Widget.commonUrl + \'/\' + Portal3Widget.widgetName + \'/style.css\'); \n loadScript(Portal3Widget.commonUrl + \'/\' + Portal3Widget.widgetName + \'/controller.js\', \n function() { \n $(\'[\'+ Portal3Widget.recipientDivDataAttrib + \']\').each(function() { \n var location = jQuery(this); \n location.removeAttr(Portal3Widget.recipientDivDataAttrib); \n var id = location.attr(Portal3Widget.recipientDivDataAttrib); \n getWidgetData(Portal3Widget.serviceURL, function(data) { \n isCssReady(function(){ \n renderWidget(data, location); \n }); \n }); \n }); \n } \n ); \n }); \n \n return Portal3Widget; \n})(window); \n ','Portal3Widget.controller = function Portal3Ctrl($rootScope, applicationsService , $log,\n $window, userProfileService, $scope, $cookies, $timeout, $interval,\n $uibModal, dashboardService, ngDialog) {Portal3Widget=Portal3Widget||{};var res = Portal3Widget.widgetData;\n \n var _this = this; \n\n //activate spinner\n this.isLoading = true;\n $scope.getUserAppsIsDone = false;\n this.userProfileService = userProfileService;\n $scope.demoNum = 1;\n $scope.event_content_show = false;\n $scope.widgetData = [];\n\n $scope.editWidgetModalPopup = function(availableData, resourceType) {\n\n $scope.editData = JSON.stringify(availableData);\n $scope.availableDataTemp = $scope.availableData;\n \n };\n \n /*Setting News data*/\n $scope.newsData = [];\n $scope.updateNews = function() {\n $scope.newsData.length=0;\n //dashboardService.getCommonWidgetData(\'NEWS\').then(function(res) {\n // $log.info(res.message);\n var newsDataJsonArray = res.response.items;\n for (var i = 0; i < newsDataJsonArray.length; i++) {\n $scope.newsData.push(newsDataJsonArray[i]);\n }\n //})[\'catch\'](function(err) {\n // $log.error(\'dashboard controller: failed to get news list\', err);\n // _this.isLoading = false;\n //});\n }\n $scope.updateNews();\n\n }\n\n;Portal3Widget.controller.$inject = [\'$rootScope\',\'applicationsService\',\'$log\',\'$window\',\'userProfileService\',\'$scope\',\'$cookies\',\'$timeout\',\'$interval\',\'$uibModal\',\'dashboardService\',\'ngDialog\'];','<div id=\"widget-news\" ng-controller=\"Portal3Ctrl\" class=\"widget-news-main\">\n <div att-gridster-item-body class=\"information-section-gridsterContent\">\n <div class=\"resources\">\n <ul ng-show=\"newsData.length!=0\">\n <li ng-repeat=\"item in newsData\"><a id=\"resource-widget-{{item.id}}\"\n href=\"{{item.href}}\" target=\"_blank\" ng-bind=\"item.title\"></a></li>\n </ul>\n <div ng-hide=\"newsData.length!=0\">\n <div class=\"activity-error-container\"\n style=\"background: rgb(255, 255, 255); overflow: hidden !important; width: 100%;\">\n <div class=\"activity-error-block\">\n <i class=\"icon-information full-linear-icon-information\"\n style=\"margin-left: 125px; font-size: 90px\"></i> <br>\n <div class=\"activity-error-msg1\">There\'s currently no\n news available.</div>\n </div>\n </div>\n </div>\n </div>\n </div>\n</div>\n','\n.portal-widget-panel-container {\n margin-left:150px;\n width:1500px;\n}\n\n\n.portal-widget-panel-fixed-panel {\n min-height: 300px;\n max-height: 1300px;\n overflow: auto;\n}\n\n.portal-widget-panel-double-middle {\n min-height: 660px;\n max-height: 660px;\n overflow: auto;\n}\n\n.portal-widget-panel-row {\n margin-right: 0px;\n margin-left: 0px;\n width: 2800px;\n}\n\n/*Increases the width of the card/panel */\n.portal-widget-panel-panel-default {\n width:450px\n}\n\n/*Controls the spacing between the cards */\n.portal-widget-panel-col-sm-3 {\n width:20.5%\n}\n\n.portal-widget-panel-top {\n top: 15px;\n left: 15px;\n}\n\n#portal3-css-ready {\ncolor: #bada55 !important;\n}');
436 -- Dumping data for table `fn_app_contact_us`
439 INSERT INTO `fn_app_contact_us` (`app_id`, `contact_name`, `contact_email`, `url`, `active_yn`, `description`) VALUES
440 (2,'Portal SDK Team','portal@lists.onap.org','https://wiki.onap.org/display/DW/Approved+Projects',NULL,'xDemo Application'),
441 (3,'DBC Team','portal@lists.onap.org','https://wiki.onap.org/display/DW/Approved+Projects',NULL,'DBC.'),
442 (4,'SDC Team','sdc@lists.onap.org','https://wiki.onap.org/display/DW/Approved+Projects',NULL,'Service Design and Creation (SDC).'),
443 (5,'Policy Team','policy@lists.onap.org','https://wiki.onap.org/display/DW/Approved+Projects',NULL,'Policy.'),
444 (6,'VID Team','vid@lists.onap.org','https://wiki.onap.org/display/DW/Approved+Projects',NULL,'Virtual Infrastructure Design.'),
445 (7,'AAI UI Team','aaiui@lists.onap.org','https://wiki.onap.org/display/DW/Approved+Projects',NULL,'AAI UI Application'),
446 (8,'CLI Team','onap-discuss@lists.onap.org','https://wiki.onap.org/display/DW/Approved+Projects',NULL,'CLI Application'),
447 (10,'SO Team','so@lists.onap.org','https://wiki.onap.org/display/DW/Approved+Projects',NULL,'Service Orchestration (SO).');
450 -- Dumping data for table `fn_common_widget_data`
453 INSERT INTO `fn_common_widget_data` (`id`, `category`, `href`, `title`, `content`, `event_date`, `sort_order`) VALUES
454 (6,'NEWS','https://www.onap.org/announcement/2017/09/27/open-network-automation-platform-onap-project-continues-rapid-membership-growth','Open Network Automation Platform (ONAP) Project Continues Rapid Membership Growth',NULL,NULL,10),
455 (7,'NEWS','https://www.onap.org/announcement/2017/02/23/the-linux-foundation-announces-the-formation-of-a-new-project-to-help-accelerate-innovation-in-open-networking-automation','The Linux Foundation Announces Merger of Open Source ECOMP and OPEN-O to Form New Open Network Automation Platform (ONAP) Project',NULL,NULL,20),
456 (8,'NEWS','http://about.att.com/story/orange_testing_att_open_source_ecomp_platform.html','Orange Testing AT&Ts Open Source ECOMP Platform for Building Software-Defined Network Capabilities',NULL,NULL,30),
457 (9,'NEWS','http://about.att.com/innovationblog/linux_foundation','Opening up ECOMP: Our Network Operating System for SDN',NULL,NULL,40),
458 (10,'EVENTS','https://onapbeijing2017.sched.com/list/descriptions/','ONAP Beijing Release Developer Forum',NULL,'2017-12-11',1),
459 (11,'EVENTS','https://events.linuxfoundation.org/events/open-networking-summit-north-america-2018','Open Networking Summit',NULL,'2018-03-26',2),
460 (12,'IMPORTANTRESOURCES','http://onap.readthedocs.io/en/latest/guides/onap-developer/developing/index.html','Development Guides',NULL,NULL,1),
461 (13,'IMPORTANTRESOURCES','https://wiki.onap.org/','ONAP Wiki',NULL,NULL,2),
462 (14,'IMPORTANTRESOURCES','http://onap.readthedocs.io/en/latest/guides/onap-developer/developing/index.html#portal-platform','ONAP Portal Documentation',NULL,NULL,3),
463 (15,'IMPORTANTRESOURCES','http://onap.readthedocs.io/en/latest/guides/onap-developer/architecture/index.html#architecture','ONAP Architecture',NULL,NULL,4);
466 -- Dumping data for table `fn_display_text`
469 INSERT INTO `fn_display_text` (`id`, `language_id`, `text_id`, `text_label`) VALUES
471 (2,1,3,'Application Catalog'),
472 (3,1,4,'Widget Catalog'),
476 (7,1,8,'Portal Admins'),
477 (8,1,9,'Application Onboarding'),
478 (9,1,10,'Widget Onboarding'),
479 (10,1,11,'Edit Functional Menu'),
480 (11,1,12,'User Notifications'),
481 (12,1,13,'Microservice Onboarding'),
482 (13,1,15,'App Account Management'),
484 (15,2,3,'应用目录'),
485 (16,2,4,'部件目录'),
486 (17,2,5,'管ç
\90†å‘˜'),
489 (20,2,8,'门户管ç
\90†å‘˜'),
490 (21,2,9,'应用管ç
\90†'),
491 (22,2,10,'部件管ç
\90†'),
492 (23,2,11,'编辑功能è
\8fό
\8d•'),
493 (24,2,12,'用户通知'),
494 (25,2,13,'å¾®æœ
\8d务管ç
\90†'),
495 (26,2,15,'应用账户管ç
\90†');
498 -- Dumping data for table `fn_function`
501 INSERT INTO `fn_function` (`function_cd`, `function_name`) VALUES
502 ('edit_notification','User Notification'),
503 ('getAdminNotifications','Admin Notifications'),
505 ('menu_admin','Admin Menu'),
506 ('menu_ajax','Ajax Menu'),
507 ('menu_customer','Customer Menu'),
508 ('menu_customer_create','Customer Create'),
509 ('menu_feedback','Feedback Menu'),
510 ('menu_help','Help Menu'),
511 ('menu_home','Home Menu'),
512 ('menu_job','Job Menu'),
513 ('menu_job_create','Job Create'),
514 ('menu_job_designer','Process in Designer view'),
515 ('menu_logout','Logout Menu'),
516 ('menu_map','Map Menu'),
517 ('menu_notes','Notes Menu'),
518 ('menu_process','Process List'),
519 ('menu_profile','Profile Menu'),
520 ('menu_profile_create','Profile Create'),
521 ('menu_profile_import','Profile Import'),
522 ('menu_reports','Reports Menu'),
523 ('menu_sample','Sample Pages Menu'),
524 ('menu_tab','Sample Tab Menu'),
525 ('menu_task','Task Menu'),
526 ('menu_task_search','Task Search'),
527 ('menu_web_analytics','Web Analytics'),
528 ('saveNotification','publish notifications'),
529 ('view_reports','View Raptor reports');
532 -- Dumping data for table `fn_language`
535 INSERT INTO `fn_language` (`language_name`, `language_alias`) VALUES
537 ('简体ä¸æ–‡','CN');
540 -- Dumping data for table `fn_lu_activity`
543 INSERT INTO `fn_lu_activity` (`activity_cd`, `activity`) VALUES
544 ('add_child_role','add_child_role'),
545 ('add_role','add_role'),
546 ('add_role_function','add_role_function'),
547 ('add_user_role','add_user_role'),
548 ('apa','Add Portal Admin'),
549 ('app_access','App Access'),
550 ('dpa','Delete Portal Admin'),
551 ('eaaf','External auth add function'),
552 ('eaar','External auth add role'),
553 ('eadf','External auth delete function'),
554 ('eadr','External auth delete role'),
555 ('eauf','External auth update function'),
556 ('eaurf','External auth update role and function'),
557 ('functional_access','Functional Access'),
558 ('guest_login','Guest Login'),
559 ('left_menu_access','Left Menu Access'),
562 ('mobile_login','Mobile Login'),
563 ('mobile_logout','Mobile Logout'),
564 ('remove_child_role','remove_child_role'),
565 ('remove_role','remove_role'),
566 ('remove_role_function','remove_role_function'),
567 ('remove_user_role','remove_user_role'),
569 ('tab_access','Tab Access'),
570 ('uaa','Update Account Admin'),
571 ('uu','Update User');
574 -- Dumping data for table `fn_lu_alert_method`
577 INSERT INTO `fn_lu_alert_method` (`alert_method_cd`, `alert_method`) VALUES
585 -- Dumping data for table `fn_lu_menu_set`
588 INSERT INTO `fn_lu_menu_set` (`menu_set_cd`, `menu_set_name`) VALUES
589 ('APP','Application Menu');
592 -- Dumping data for table `fn_lu_priority`
595 INSERT INTO `fn_lu_priority` (`priority_id`, `priority`, `active_yn`, `sort_order`) VALUES
603 -- Dumping data for table `fn_lu_tab_set`
606 INSERT INTO `fn_lu_tab_set` (`tab_set_cd`, `tab_set_name`) VALUES
607 ('APP','Application Tabs');
610 -- Dumping data for table `fn_lu_timezone`
613 INSERT INTO `fn_lu_timezone` (`timezone_id`, `timezone_name`, `timezone_value`) VALUES
614 (10,'US/Eastern','US/Eastern'),
615 (20,'US/Central','US/Central'),
616 (30,'US/Mountain','US/Mountain'),
617 (40,'US/Arizona','America/Phoenix'),
618 (50,'US/Pacific','US/Pacific'),
619 (60,'US/Alaska','US/Alaska'),
620 (70,'US/Hawaii','US/Hawaii');
623 -- Dumping data for table `fn_menu`
626 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
627 (1,'root',NULL,10,NULL,'menu_home',0,NULL,NULL,NULL,NULL,'APP',0,NULL),
628 (2,'Home',1,10,'root.applicationsHome','menu_home',1,NULL,NULL,NULL,NULL,'APP',0,'icon-building-home'),
629 (3,'Application Catalog',1,15,'root.appCatalog','menu_home',1,NULL,NULL,NULL,NULL,'APP',0,'icon-retail-gallery'),
630 (4,'Widget Catalog',1,20,'root.widgetCatalog','menu_home',1,NULL,NULL,NULL,NULL,'APP',0,'icon-retail-gallery'),
631 (5,'Admins',1,40,'root.admins','menu_admin',1,NULL,NULL,NULL,NULL,'APP',0,'icon-content-star'),
632 (6,'Roles',1,45,'root.roles','menu_acc_admin',1,NULL,NULL,NULL,NULL,'APP',0,'icon-people-groupcollaboration'),
633 (7,'Users',1,50,'root.users','menu_acc_admin',1,NULL,NULL,NULL,NULL,'APP',0,'icon-people-groupcollaboration'),
634 (8,'Portal Admins',1,60,'root.portalAdmins','menu_admin',1,NULL,NULL,NULL,NULL,'APP',0,'icon-controls-settingsconnectedactivity'),
635 (9,'Application Onboarding',1,70,'root.applications','menu_admin',1,NULL,NULL,NULL,NULL,'APP',0,'icon-content-grid2'),
636 (10,'Widget Onboarding',1,80,'root.widgetOnboarding','menu_admin',1,NULL,NULL,NULL,NULL,'APP',0,'icon-content-grid2'),
637 (11,'Edit Functional Menu',1,90,'root.functionalMenu','menu_admin',1,NULL,NULL,NULL,NULL,'APP',0,'icon-misc-pen'),
638 (12,'User Notifications',1,100,'root.userNotifications','edit_notification',1,NULL,NULL,NULL,NULL,'APP',0,'icon-controls-settingsconnectedactivity'),
639 (13,'Microservice Onboarding',1,110,'root.microserviceOnboarding','menu_admin',1,NULL,NULL,NULL,NULL,'APP',0,'icon-content-grid2'),
640 (15,'App Account Management',1,130,'root.accountOnboarding','menu_admin',1,NULL,NULL,NULL,NULL,'App',0,'icon-content-grid2');
643 -- Dumping data for table `fn_menu_functional`
647 `fn_menu_functional` (
657 (175, 1, 'Manage', NULL, '', 1, NULL),
658 (178, 2, 'Support', NULL, '', 1, NULL),
659 (1, 2, 'Design', 175, '', 1, NULL),
660 (2, 8, 'ECOMP Platform Management', 175, '', 0, NULL),
661 (3, 5, 'Technology Insertion', 175, '', 1, NULL),
662 (5, 7, 'Performance Management', 175, '', 0, NULL),
663 (6, 6, 'Technology Management', 175, '', 1, NULL),
664 (7, 4, 'Capacity Planning', 175, '', 0, NULL),
665 (8, 3, 'Operations Planning', 175, '', 1, NULL),
666 (11, 1, 'Product Design', 1, '', 1, NULL),
667 (12, 2, 'Resource/Service Design & Onboarding', 1, '', 1, NULL),
668 (13, 3, 'Orchestration (recipe/Process) Design', 1, '', 0, NULL),
669 (14, 4, 'Service Graph visualizer', 1, '', 0, NULL),
670 (15, 5, 'Distribution', 1, '', 1, NULL),
671 (16, 6, 'Testing', 1, '', 1, NULL),
672 (17, 7, 'Simulation', 1, '', 0, NULL),
673 (18, 8, 'Certification', 1, '', 0, NULL),
674 (19, 9, 'Policy Creation/Management', 1, 'http://policy.api.simpledemo.onap.org:8443/onap/policy', 1, NULL),
675 (20, 10, 'Catalog Browser', 1, '', 1, NULL),
676 (24, 5, 'Create/Manage Policy', 12, 'http://policy.api.simpledemo.onap.org:8443/onap/policy', 1, NULL),
677 (56, 1, 'Policy Engineering', 8, 'http://policy.api.simpledemo.onap.org:8443/onap/policy', 1, NULL),
678 (115, 1, 'Test/Approve a Resource or Service', 16, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/dashboard', 1, NULL),
679 (130, 1, 'Favorites', 175, '', 1, NULL),
680 (139, 2, 'Approve a Service for distribution', 12, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/dashboard', 1,NULL),
681 (142, 3, 'Create a License model', 12, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/onboardVendor', 1, NULL),
682 (145, 1, 'Distribute a Service', 15, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/dashboard', 1, NULL),
683 (181, 1, 'Contact Us', 178, '', 1, NULL),
684 (184, 2, 'Get Access', 178, '', 1, NULL),
685 (301, 1, 'Create a Product', 11, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/dashboard', 1, NULL),
686 (304, 2, 'Create a Vendor Software Product', 11, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/onboardVendor', 1, NULL),
687 (307, 1, 'Manage a Resource/Service', 20, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/catalog', 1, NULL),
688 (310, 2, 'Manage a Product', 20, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/catalog', 1, NULL),
689 (313, 3, 'View a Resource/Service/Product', 20, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/catalog', 1, NULL),
690 (316, 11, 'Administration', 1, '', 1, NULL),
691 (148, 1, 'User Management / Category Management', 316, 'http://sdc.api.simpledemo.onap.org:8181/sdc1/portal#/adminDashboard', 1, NULL),
692 (317, 1, 'Message Bus Management', 6, 'http://portal.api.simpledemo.onap.org:8989/ECOMPDBCAPP/dbc#/dmaap', 1, NULL),
693 (318, 1, 'Infrastructure Provisioning', 3, '', 1, NULL),
694 (319, 1, 'Infrastructure VNF Provisioning', 318, 'https://vid.api.simpledemo.onap.org:8443/vid/welcome.htm', 1, NULL);
697 -- Dumping data for table `fn_menu_functional_ancestors`
700 INSERT INTO `fn_menu_functional_ancestors` (`id`, `menu_id`, `ancestor_menu_id`, `depth`) VALUES
815 -- Dumping data for table `fn_menu_functional_roles`
818 INSERT INTO `fn_menu_functional_roles` (`id`, `menu_id`, `app_id`, `role_id`) VALUES
851 -- Dumping data for table `fn_qz_job_details`
854 INSERT INTO `fn_qz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`, `DESCRIPTION`, `JOB_CLASS_NAME`, `IS_DURABLE`, `IS_NONCONCURRENT`, `IS_UPDATE_DATA`, `REQUESTS_RECOVERY`, `JOB_DATA`) VALUES
855 ('Scheduler_20190808_one','LogJob','AppGroup',NULL,'org.onap.portalapp.scheduler.LogJob','0','1','1','0','��\0
\ 5sr\0
\15org.quartz.JobDataMap���迩��
\ 2\0\0xr\0&org.quartz.utils.StringKeyDirtyFlagMap�
\b����](
\ 2\0
\ 1Z\0
\13allowsTransientDataxr\0
\1dorg.quartz.utils.DirtyFlagMap
\13�.�(v\n�
\ 2\0
\ 2Z\0
\ 5dirtyL\0
\ 3mapt\0
\ fLjava/util/Map;xp
\ 1sr\0
\11java.util.HashMap
\ 5\a���
\16`�
\ 3\0
\ 2F\0\nloadFactorI\0 thresholdxp?@\0\0\0\0\0
\fw
\b\0\0\0
\10\0\0\0
\ 1t\0
\ 5unitst\0
\ 5bytesx\0'),
856 ('Scheduler_20190808_one','PortalSessionTimeoutFeedJob','AppGroup',NULL,'org.onap.portalapp.service.sessionmgt.TimeoutHandler','0','1','1','0','��\0
\ 5sr\0
\15org.quartz.JobDataMap���迩��
\ 2\0\0xr\0&org.quartz.utils.StringKeyDirtyFlagMap�
\b����](
\ 2\0
\ 1Z\0
\13allowsTransientDataxr\0
\1dorg.quartz.utils.DirtyFlagMap
\13�.�(v\n�
\ 2\0
\ 2Z\0
\ 5dirtyL\0
\ 3mapt\0
\ fLjava/util/Map;xp\0sr\0
\11java.util.HashMap
\ 5\a���
\16`�
\ 3\0
\ 2F\0\nloadFactorI\0 thresholdxp?@\0\0\0\0\0
\10w
\b\0\0\0
\10\0\0\0\0x\0');
858 INSERT INTO `fn_qz_locks` (`SCHED_NAME`, `LOCK_NAME`) VALUES
859 ('Scheduler_20190808_one','STATE_ACCESS'),
860 ('Scheduler_20190808_one','TRIGGER_ACCESS');
863 -- Dumping data for table `fn_qz_scheduler_state`
866 INSERT INTO `fn_qz_scheduler_state` (`SCHED_NAME`, `INSTANCE_NAME`, `LAST_CHECKIN_TIME`, `CHECKIN_INTERVAL`) VALUES
867 ('Scheduler_20190808_one','portal-portal-app-76c9f7bfb5-s8rhd1565254283688',1565691615399,20000);
870 -- Dumping data for table `fn_qz_triggers`
873 INSERT INTO `fn_qz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`, `JOB_NAME`, `JOB_GROUP`, `DESCRIPTION`, `NEXT_FIRE_TIME`, `PREV_FIRE_TIME`, `PRIORITY`, `TRIGGER_STATE`, `TRIGGER_TYPE`, `START_TIME`, `END_TIME`, `CALENDAR_NAME`, `MISFIRE_INSTR`, `JOB_DATA`) VALUES
874 ('Scheduler_20190808_one','LogTrigger','AppGroup','LogJob','AppGroup',NULL,1565691660000,1565691600000,0,'WAITING','CRON',1565254275000,0,NULL,0,''),
875 ('Scheduler_20190808_one','PortalSessionTimeoutFeedTrigger','AppGroup','PortalSessionTimeoutFeedJob','AppGroup',NULL,1565691900000,1565691600000,0,'WAITING','CRON',1565254275000,0,NULL,0,'');
878 -- Dumping data for table `fn_qz_cron_triggers`
881 INSERT INTO `fn_qz_cron_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`, `CRON_EXPRESSION`, `TIME_ZONE_ID`) VALUES
882 ('Scheduler_20190808_one','LogTrigger','AppGroup','0 * * * * ? *','GMT'),
883 ('Scheduler_20190808_one','PortalSessionTimeoutFeedTrigger','AppGroup','0 0/5 * * * ? *','GMT');
886 -- Dumping data for table `fn_restricted_url`
889 INSERT INTO `fn_restricted_url` (`restricted_url`, `function_cd`) VALUES
890 ('async_test.htm','menu_home'),
891 ('attachment.htm','menu_admin'),
892 ('broadcast.htm','menu_admin'),
893 ('chatWindow.htm','menu_home'),
894 ('contact_list.htm','menu_home'),
895 ('customer_dynamic_list.htm','menu_home'),
896 ('event.htm','menu_home'),
897 ('event_list.htm','menu_home'),
898 ('file_upload.htm','menu_admin'),
899 ('gauge.htm','menu_tab'),
900 ('gmap_controller.htm','menu_tab'),
901 ('gmap_frame.htm','menu_tab'),
902 ('jbpm_designer.htm','menu_job_create'),
903 ('jbpm_drools.htm','menu_job_create'),
904 ('job.htm','menu_admin'),
905 ('map.htm','menu_tab'),
906 ('map_download.htm','menu_tab'),
907 ('map_grid_search.htm','menu_tab'),
908 ('mobile_welcome.htm','menu_home'),
909 ('process_job.htm','menu_job_create'),
910 ('profile.htm','menu_profile_create'),
911 ('raptor.htm','menu_reports'),
912 ('raptor.htm','view_reports'),
913 ('raptor2.htm','menu_reports'),
914 ('raptor_blob_extract.htm','menu_reports'),
915 ('raptor_blob_extract.htm','view_reports'),
916 ('raptor_email_attachment.htm','menu_reports'),
917 ('raptor_search.htm','menu_reports'),('report_list.htm','menu_reports'),
918 ('role.htm','menu_admin'),
919 ('role_function.htm','menu_admin'),
920 ('sample_animated_map.htm','menu_tab'),
921 ('sample_map.htm','menu_home'),
922 ('sample_map_2.htm','menu_tab'),
923 ('sample_map_3.htm','menu_tab'),
924 ('tab2_sub1.htm','menu_tab'),
925 ('tab2_sub2_link1.htm','menu_tab'),
926 ('tab2_sub2_link2.htm','menu_tab'),
927 ('tab2_sub3.htm','menu_tab'),
928 ('tab3.htm','menu_tab'),
929 ('tab4.htm','menu_tab'),
930 ('template.jsp','menu_home'),
931 ('test.htm','menu_admin');
934 -- Dumping data for table `fn_role_composite`
937 INSERT INTO `fn_role_composite` (`parent_role_id`, `child_role_id`) VALUES
941 -- Dumping data for table `fn_role_function`
944 INSERT INTO `fn_role_function` (`id`, `function_cd`) VALUES
949 (1,'menu_customer_create'),
954 (1,'menu_job_create'),
959 (1,'menu_profile_create'),
960 (1,'menu_profile_import'),
966 (16,'menu_customer'),
967 (16,'menu_customer_create'),
974 (950,'edit_notification'),
975 (950,'getAdminNotifications'),
976 (950,'saveNotification'),
977 (1010,'menu_web_analytics'),
978 (2115,'menu_web_analytics');
981 -- Dumping data for table `fn_shared_context`
984 INSERT INTO `fn_shared_context` (`id`, `create_time`, `context_id`, `ckey`, `cvalue`) VALUES
985 (1,'2019-08-08 10:11:18','b999771d~2d60~4638~a670~d47d17219157','USER_FIRST_NAME','Jimmy'),
986 (2,'2019-08-08 10:11:18','b999771d~2d60~4638~a670~d47d17219157','USER_LAST_NAME','Hendrix'),
987 (3,'2019-08-08 10:11:18','b999771d~2d60~4638~a670~d47d17219157','USER_EMAIL','admin@onap.org'),
988 (4,'2019-08-08 10:11:18','b999771d~2d60~4638~a670~d47d17219157','USER_ORG_USERID','jh0003'),
989 (5,'2019-08-08 10:17:47','29cc8f94~5a7d~41f8~b359~432bb903a718','USER_FIRST_NAME','Demo'),
990 (6,'2019-08-08 10:17:47','29cc8f94~5a7d~41f8~b359~432bb903a718','USER_LAST_NAME','User'),
991 (7,'2019-08-08 10:17:47','29cc8f94~5a7d~41f8~b359~432bb903a718','USER_EMAIL','demo@openecomp.org'),
992 (8,'2019-08-08 10:17:47','29cc8f94~5a7d~41f8~b359~432bb903a718','USER_ORG_USERID','demo'),
993 (9,'2019-08-08 11:01:02','7e3ced0a~52a3~492a~be53~2885d2df5a43','USER_FIRST_NAME','Demo'),
994 (10,'2019-08-08 11:01:02','7e3ced0a~52a3~492a~be53~2885d2df5a43','USER_LAST_NAME','User'),
995 (11,'2019-08-08 11:01:02','7e3ced0a~52a3~492a~be53~2885d2df5a43','USER_EMAIL','demo@openecomp.org'),
996 (12,'2019-08-08 11:01:02','7e3ced0a~52a3~492a~be53~2885d2df5a43','USER_ORG_USERID','demo');
999 -- Dumping data for table `fn_tab`
1002 INSERT INTO `fn_tab` (`tab_cd`, `tab_name`, `tab_descr`, `action`, `function_cd`, `active_yn`, `sort_order`, `parent_tab_cd`, `tab_set_cd`) VALUES
1003 ('TAB1','Tab 1','Tab 1 Information','tab1.htm','menu_tab',1,10,NULL,'APP'),
1004 ('TAB2','Tab 2','Tab 2 Information','tab2_sub1.htm','menu_tab',1,20,NULL,'APP'),
1005 ('TAB2_SUB1','Sub Tab 1','Sub Tab 1 Information','tab2_sub1.htm','menu_tab',1,10,'TAB2','APP'),
1006 ('TAB2_SUB1_S1','Left Tab 1','Sub - Sub Tab 1 Information','tab2_sub1.htm','menu_tab',1,10,'TAB2_SUB1','APP'),
1007 ('TAB2_SUB2','Sub Tab 2','Sub Tab 2 Information','tab2_sub2.htm','menu_tab',1,20,'TAB2','APP'),
1008 ('TAB2_SUB3','Sub Tab 3','Sub Tab 3 Information','tab2_sub3.htm','menu_tab',1,30,'TAB2','APP'),
1009 ('TAB3','Tab 3','Tab 3 Information','tab3.htm','menu_tab',1,30,NULL,'APP'),
1010 ('TAB4','Tab 4','Tab 4 Information','tab4.htm','menu_tab',1,40,NULL,'APP');
1013 -- Dumping data for table `fn_tab_selected`
1016 INSERT INTO `fn_tab_selected` (`selected_tab_cd`, `tab_uri`) VALUES
1017 ('TAB1','tab1'),('TAB2','tab2_sub1'),
1018 ('TAB2','tab2_sub2'),
1019 ('TAB2','tab2_sub3'),
1020 ('TAB2_SUB1','tab2_sub1'),
1021 ('TAB2_SUB1_S1','tab2_sub1'),
1022 ('TAB2_SUB2','tab2_sub2'),
1023 ('TAB2_SUB3','tab2_sub3'),
1028 -- Dumping data for table `fn_user`
1060 `org_manager_userid`,
1067 `business_unit_name`,
1082 'demo@openecomp.org',
1090 '2019-08-08 12:18:17',
1092 '2016-10-14 21:00:00',
1093 '2019-08-08 12:18:17',
1130 '2019-08-08 10:16:11',
1132 '2016-10-14 21:00:00',
1133 '2019-08-08 10:16:11',
1162 'designer@onap.org',
1170 '2016-10-20 15:11:16',
1172 '2016-10-14 21:00:00',
1173 '2016-10-20 15:11:16',
1210 '2016-10-20 15:11:16',
1212 '2016-10-14 21:00:00',
1213 '2016-10-20 15:11:16',
1250 '2016-10-20 15:11:16',
1252 '2016-10-14 21:00:00',
1253 '2016-10-20 15:11:16',
1282 'governor@onap.org',
1290 '2016-10-20 15:11:16',
1292 '2016-10-14 21:00:00',
1293 '2016-10-20 15:11:16',
1330 '2016-10-20 15:11:16',
1332 '2016-10-14 21:00:00',
1333 '2016-10-20 15:11:16',
1370 '2016-10-20 15:11:16',
1372 '2016-10-14 21:00:00',
1373 '2016-10-20 15:11:16',
1410 '2016-10-20 15:11:16',
1412 '2016-10-14 21:00:00',
1413 '2016-10-20 15:11:16',
1450 '2016-10-20 15:11:16',
1452 '2016-10-14 21:00:00',
1453 '2016-10-20 15:11:16',
1490 '2016-10-20 15:11:16',
1492 '2016-10-14 21:00:00',
1493 '2016-10-20 15:11:16',
1530 '2017-05-19 15:11:16',
1532 '2017-05-19 21:00:00',
1533 '2017-05-19 15:11:16',
1557 -- Dumping data for table `ep_pers_user_app_sort`
1560 INSERT INTO `ep_pers_user_app_sort` (`id`, `user_id`, `sort_pref`) VALUES
1564 -- Dumping data for table `fn_pers_user_app_sel`
1567 INSERT INTO `fn_pers_user_app_sel` (`id`, `user_id`, `app_id`, `status_cd`) VALUES
1574 -- Dumping data for table `fn_audit_log`
1577 INSERT INTO `fn_audit_log` (`log_id`, `user_id`, `activity_cd`, `audit_date`, `comments`, `affected_record_id_bk`, `affected_record_id`) VALUES
1578 (1,1,'app_access','2019-08-08 10:18:52','https://aai.ui.simpledemo.onap.org:30220/services/aai/webapp/index.html',NULL,'7'),
1579 (2,1,'tab_access','2019-08-08 10:18:52','https://aai.ui.simpledemo.onap.org:30220/services/aai/webapp/index.html?cc=1565259532115',NULL,'7'),
1580 (3,1,'tab_access','2019-08-08 10:18:56','Home',NULL,'1'),
1581 (4,1,'tab_access','2019-08-08 10:18:59','https://aai.ui.simpledemo.onap.org:30220/services/aai/webapp/index.html?cc=1565259538769',NULL,'7'),
1582 (5,1,'app_access','2019-08-08 10:18:59','https://aai.ui.simpledemo.onap.org:30220/services/aai/webapp/index.html',NULL,'7'),
1583 (6,1,'tab_access','2019-08-08 10:18:59','https://aai.ui.simpledemo.onap.org:30220/services/aai/webapp/index.html?cc=1565259538769',NULL,'7'),
1584 (7,1,'tab_access','2019-08-08 10:19:06','Home',NULL,'1');
1587 -- Dumping data for table `fn_user_role`
1590 INSERT INTO `fn_user_role` (`user_id`, `role_id`, `priority`, `app_id`)
1632 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1633 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1634 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1635 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1636 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1637 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1639 -- Dump completed on 2019-08-13 10:20:25