portal-BE/src/main/resources/data2.sql

   1 --
   2 -- ============LICENSE_START==========================================
   3 -- ONAP Portal
   4 -- ===================================================================
   5 -- Copyright (C) 2019 AT&T Intellectual Property. All rights reserved.
   6 -- ===================================================================
   7 -- Modifications Copyright (c) 2019 Samsung
   8 -- ===================================================================
   9 --
  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
  14 --
  15 --             http://www.apache.org/licenses/LICENSE-2.0
  16 --
  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.
  22 --
  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
  27 --
  28 --             https://creativecommons.org/licenses/by/4.0/
  29 --
  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.
  35 --
  36 -- ============LICENSE_END============================================
  37 --
  38 --
  39
  40
  41 -- MySQL dump 10.17  Distrib 10.3.14-MariaDB, for debian-linux-gnu (x86_64)
  42 --
  43 -- Host: localhost    Database: portal
  44 -- ------------------------------------------------------
  45 -- Server version       10.3.14-MariaDB-1:10.3.14+maria~bionic
  46
  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);
  48
  49 INSERT INTO
  50   `fn_app` (
  51     `id`,
  52     `app_name`,
  53     `app_image_url`,
  54     `app_description`,
  55     `app_notes`,
  56     `app_url`,
  57     `app_alternate_url`,
  58     `app_rest_endpoint`,
  59     `ml_app_name`,
  60     `ml_app_admin_id`,
  61     `mots_id`,
  62     `app_password`,
  63     `_open`,
  64     `_enabled`,
  65     `app_username`,
  66     `ueb_key`,
  67     `ueb_secret`,
  68     `ueb_topic_name`,
  69     `app_type`,
  70     `auth_central`,
  71     `auth_namespace`
  72   )
  73 VALUES
  74   (
  75     1,
  76     'Default',
  77     'assets/images/tmp/portal1.png',
  78     'Some Default Description',
  79     'Some Default Note',
  80     'http://localhost',
  81     'http://localhost',
  82     'http://localhost:8080/ecompportal',
  83     'EcompPortal',
  84     '',
  85     NULL,
  86     'dR2NABMkxPaFbIbym87ZwQ==',
  87     0,
  88     0,
  89     'm00468@portal.onap.org',
  90     'EkrqsjQqZt4ZrPh6',
  91     NULL,
  92     NULL,
  93     1,
  94     1,
  95     'org.onap.portal'
  96   ),(
  97     2,
  98     'xDemo App',
  99     'images/cache/portal-222865671_37476.png',
 100     NULL,
 101     NULL,
 102     'http://portal-sdk.simpledemo.onap.org:30212/ONAPPORTALSDK/welcome.htm',
 103     NULL,
 104     'http://portal-sdk:8080/ONAPPORTALSDK/api/v3',
 105     '',
 106     '',
 107     NULL,
 108     '2VxipM8Z3SETg32m3Gp0FvKS6zZ2uCbCw46WDyK6T5E=',
 109     0,
 110     1,
 111     'Default',
 112     'ueb_key',
 113     'ueb_secret',
 114     'ECOMP-PORTAL-OUTBOX',
 115     1,
 116     0,
 117     NULL
 118   ),(
 119     3,
 120     'DMaaP Bus Ctrl',
 121     'images/cache/portal944583064_80711.png',
 122     NULL,
 123     NULL,
 124     'http://dmaap-bc.simpledemo.onap.org:/ECOMPDBCAPP/dbc#/dmaap',
 125     NULL,
 126     'http://dmaap-bc:8989/ECOMPDBCAPP/api/v2',
 127     '',
 128     '',
 129     NULL,
 130     'okYTaDrhzibcbGVq5mjkVQ==',
 131     0,
 132     0,
 133     'Default',
 134     'ueb_key',
 135     'ueb_secret',
 136     'ECOMP-PORTAL-OUTBOX',
 137     1,
 138     0,
 139     NULL
 140   ),(
 141     4,
 142     'SDC',
 143     'images/cache/portal956868231_53879.png',
 144     NULL,
 145     NULL,
 146     'http://sdc.api.fe.simpledemo.onap.org:30206/sdc1/portal',
 147     NULL,
 148     'http://sdc-be:8080/api/v3',
 149     '',
 150     '',
 151     NULL,
 152     'j85yNhyIs7zKYbR1VlwEfNhS6b7Om4l0Gx5O8931sCI=',
 153     0,
 154     1,
 155     'sdc',
 156     'ueb_key',
 157     'ueb_secret',
 158     'ECOMP-PORTAL-OUTBOX',
 159     1,
 160     1,
 161     'org.onap.sdc'
 162   ),(
 163     5,
 164     'Policy',
 165     'images/cache/portal1470452815_67021.png',
 166     NULL,
 167     NULL,
 168     'https://policy.api.simpledemo.onap.org:30219/onap/policy',
 169     NULL,
 170     'https://pap:8443/onap/api/v3',
 171     '',
 172     '',
 173     NULL,
 174     '2VxipM8Z3SETg32m3Gp0FvKS6zZ2uCbCw46WDyK6T5E=',
 175     0,
 176     1,
 177     'Default',
 178     'ueb_key_5',
 179     'ueb_secret',
 180     'ECOMP-PORTAL-OUTBOX',
 181     1,
 182     1,
 183     'org.onap.policy'
 184   ),(
 185     6,
 186     'Virtual Infrastructure Deployment',
 187     'images/cache/portal-345993588_92550.png',
 188     NULL,
 189     NULL,
 190     'https://vid.api.simpledemo.onap.org:30200/vid/welcome.htm',
 191     NULL,
 192     'https://vid:8443/vid/api/v3',
 193     '',
 194     '',
 195     NULL,
 196     '2VxipM8Z3SETg32m3Gp0FvKS6zZ2uCbCw46WDyK6T5E=',
 197     0,
 198     1,
 199     'Default',
 200     '2Re7Pvdkgw5aeAUD',
 201     'S31PrbOzGgL4hg4owgtx47Da',
 202     'ECOMP-PORTAL-OUTBOX-90',
 203     1,
 204     1,
 205     'org.onap.vid'
 206   ),(
 207     7,
 208     'A&AI UI',
 209     'images/cache/portal-345993588_92550.png',
 210     NULL,
 211     NULL,
 212     'https://aai.ui.simpledemo.onap.org:30220/services/aai/webapp/index.html#/viewInspect',
 213     NULL,
 214     'https://aai-sparky-be.onap:8000/api/v2',
 215     '',
 216     '',
 217     NULL,
 218     '4LK69amiIFtuzcl6Gsv97Tt7MLhzo03aoOx7dTvdjKQ=',
 219     0,
 220     1,
 221     'aaiui',
 222     'ueb_key_7',
 223     'ueb_secret',
 224     'ECOMP-PORTAL-OUTBOX',
 225     1,
 226     1,
 227     'org.onap.aai'
 228   ),(
 229     8,
 230     'CLI',
 231     'images/cache/portal-345993588_92550.png',
 232     NULL,
 233     NULL,
 234     'http://cli.api.simpledemo.onap.org:30260/',
 235     NULL,
 236     NULL,
 237     '',
 238     '',
 239     NULL,
 240     '',
 241     1,
 242     1,
 243     '',
 244     '',
 245     '',
 246     '',
 247     1,
 248     0,
 249     NULL
 250   ),(
 251     9,
 252     'MSB',
 253     'images/cache/portal-345993588_92550.png',
 254     NULL,
 255     NULL,
 256     'http://msb.api.simpledemo.onap.org:30280/iui/microservices/default.html',
 257     NULL,
 258     NULL,
 259     '',
 260     '',
 261     NULL,
 262     '',
 263     1,
 264     1,
 265     '',
 266     '',
 267     '',
 268     '',
 269     2,
 270     0,
 271     NULL
 272   ),(
 273     10,
 274     'SO-Monitoring',
 275     'images/cache/portal-345993588_92550.png',
 276     NULL,
 277     NULL,
 278     'http://so-monitoring:30224',
 279     NULL,
 280     'http://so-monitoring:30224',
 281     '',
 282     '',
 283     NULL,
 284     'password',
 285     1,
 286     1,
 287     'user',
 288     '',
 289     '',
 290     '',
 291     1,
 292     0,
 293     'SO-Monitoring'
 294   ),
 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);
 297
 298
 299 --
 300 -- Dumping data for table `ep_app_function`
 301 --
 302
 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');
 331
 332 --
 333 -- Dumping data for table `fn_role`
 334 --
 335
 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);
 356
 357 --
 358 -- Dumping data for table `ep_app_role_function`
 359 --
 360
 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);
 390
 391 --
 392 -- Dumping data for table `ep_basic_auth_account`
 393 --
 394
 395 INSERT INTO `ep_basic_auth_account` (`id`, `ext_app_name`, `username`, `password`, `active_yn`) VALUES
 396 (1,'JIRA','jira','6APqvG4AU2rfLgCvMdySwQ==',1);
 397
 398 --
 399 -- Dumping data for table `ep_microservice`
 400 --
 401
 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);
 407
 408 --
 409 -- Dumping data for table `ep_microservice_parameter`
 410 --
 411
 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);
 417
 418 --
 419 -- Dumping data for table `ep_widget_catalog`
 420 --
 421
 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);
 427
 428 --
 429 -- Dumping data for table `ep_widget_catalog_files`
 430 --
 431
 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}');
 434
 435 --
 436 -- Dumping data for table `fn_app_contact_us`
 437 --
 438
 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).');
 448
 449 --
 450 -- Dumping data for table `fn_common_widget_data`
 451 --
 452
 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);
 464
 465 --
 466 -- Dumping data for table `fn_display_text`
 467 --
 468
 469 INSERT INTO `fn_display_text` (`id`, `language_id`, `text_id`, `text_label`) VALUES
 470 (1,1,2,'Home'),
 471 (2,1,3,'Application Catalog'),
 472 (3,1,4,'Widget Catalog'),
 473 (4,1,5,'Admins'),
 474 (5,1,6,'Roles'),
 475 (6,1,7,'Users'),
 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'),
 483 (14,2,2,'ä¸»é¡µ'),
 484 (15,2,3,'åº”ç”¨ç›®å½•'),
 485 (16,2,4,'éƒ¨ä»¶ç›®å½•'),
 486 (17,2,5,'ç®¡ç\90†å‘˜'),
 487 (18,2,6,'è§’è‰²'),
 488 (19,2,7,'ç”¨æˆ·'),
 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†');
 496
 497 --
 498 -- Dumping data for table `fn_function`
 499 --
 500
 501 INSERT INTO `fn_function` (`function_cd`, `function_name`) VALUES
 502 ('edit_notification','User Notification'),
 503 ('getAdminNotifications','Admin Notifications'),
 504 ('login','Login'),
 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');
 530
 531 --
 532 -- Dumping data for table `fn_language`
 533 --
 534
 535 INSERT INTO `fn_language` (`language_name`, `language_alias`) VALUES
 536 ('English','EN'),
 537 ('ç®€ä½“ä¸æ–‡','CN');
 538
 539 --
 540 -- Dumping data for table `fn_lu_activity`
 541 --
 542
 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'),
 560 ('login','Login'),
 561 ('logout','Logout'),
 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'),
 568 ('search','Search'),
 569 ('tab_access','Tab Access'),
 570 ('uaa','Update Account Admin'),
 571 ('uu','Update User');
 572
 573 --
 574 -- Dumping data for table `fn_lu_alert_method`
 575 --
 576
 577 INSERT INTO `fn_lu_alert_method` (`alert_method_cd`, `alert_method`) VALUES
 578 ('EMAIL','Email'),
 579 ('FAX','Fax'),
 580 ('PAGER','Pager'),
 581 ('PHONE','Phone'),
 582 ('SMS','SMS');
 583
 584 --
 585 -- Dumping data for table `fn_lu_menu_set`
 586 --
 587
 588 INSERT INTO `fn_lu_menu_set` (`menu_set_cd`, `menu_set_name`) VALUES
 589 ('APP','Application Menu');
 590
 591 --
 592 -- Dumping data for table `fn_lu_priority`
 593 --
 594
 595 INSERT INTO `fn_lu_priority` (`priority_id`, `priority`, `active_yn`, `sort_order`) VALUES
 596 (10,'Low',1,10),
 597 (20,'Normal',1,20),
 598 (30,'High',1,30),
 599 (40,'Urgent',1,40),
 600 (50,'Fatal',1,50);
 601
 602 --
 603 -- Dumping data for table `fn_lu_tab_set`
 604 --
 605
 606 INSERT INTO `fn_lu_tab_set` (`tab_set_cd`, `tab_set_name`) VALUES
 607 ('APP','Application Tabs');
 608
 609 --
 610 -- Dumping data for table `fn_lu_timezone`
 611 --
 612
 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');
 621
 622 --
 623 -- Dumping data for table `fn_menu`
 624 --
 625
 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');
 641
 642 --
 643 -- Dumping data for table `fn_menu_functional`
 644 --
 645
 646 INSERT INTO
 647   `fn_menu_functional` (
 648     `menu_id`,
 649     `column_num`,
 650     `text`,
 651     `parent_menu_id`,
 652     `url`,
 653     `active_yn`,
 654     `image_src`
 655   )
 656 VALUES
 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);
 695
 696 --
 697 -- Dumping data for table `fn_menu_functional_ancestors`
 698 --
 699
 700 INSERT INTO `fn_menu_functional_ancestors` (`id`, `menu_id`, `ancestor_menu_id`, `depth`) VALUES
 701 (1,175,175,0),
 702 (2,178,178,0),
 703 (3,11,11,0),
 704 (4,12,12,0),
 705 (5,13,13,0),
 706 (6,14,14,0),
 707 (7,15,15,0),
 708 (8,16,16,0),
 709 (9,17,17,0),
 710 (10,18,18,0),
 711 (11,19,19,0),
 712 (12,20,20,0),
 713 (13,316,316,0),
 714 (14,318,318,0),
 715 (15,317,317,0),
 716 (16,56,56,0),
 717 (17,301,301,0),
 718 (18,304,304,0),
 719 (19,24,24,0),
 720 (20,139,139,0),
 721 (21,142,142,0),
 722 (22,145,145,0),
 723 (23,115,115,0),
 724 (24,307,307,0),
 725 (25,310,310,0),
 726 (26,313,313,0),
 727 (27,1,1,0),
 728 (28,2,2,0),
 729 (29,3,3,0),
 730 (30,5,5,0),
 731 (31,6,6,0),
 732 (32,7,7,0),
 733 (33,8,8,0),
 734 (34,130,130,0),
 735 (35,181,181,0),
 736 (36,184,184,0),
 737 (37,148,148,0),
 738 (38,319,319,0),
 739 (64,11,1,1),
 740 (65,12,1,1),
 741 (66,13,1,1),
 742 (67,14,1,1),
 743 (68,15,1,1),
 744 (69,16,1,1),
 745 (70,17,1,1),
 746 (71,18,1,1),
 747 (72,19,1,1),
 748 (73,20,1,1),
 749 (74,316,1,1),
 750 (75,318,3,1),
 751 (76,317,6,1),
 752 (77,56,8,1),
 753 (78,301,11,1),
 754 (79,304,11,1),
 755 (80,24,12,1),
 756 (81,139,12,1),
 757 (82,142,12,1),
 758 (83,145,15,1),
 759 (84,115,16,1),
 760 (85,307,20,1),
 761 (86,310,20,1),
 762 (87,313,20,1),
 763 (88,1,175,1),
 764 (89,2,175,1),
 765 (90,3,175,1),
 766 (91,5,175,1),
 767 (92,6,175,1),
 768 (93,7,175,1),
 769 (94,8,175,1),
 770 (95,130,175,1),
 771 (96,181,178,1),
 772 (97,184,178,1),
 773 (98,148,316,1),
 774 (99,319,318,1),
 775 (127,301,1,2),
 776 (128,304,1,2),
 777 (129,24,1,2),
 778 (130,139,1,2),
 779 (131,142,1,2),
 780 (132,145,1,2),
 781 (133,115,1,2),
 782 (134,307,1,2),
 783 (135,310,1,2),
 784 (136,313,1,2),
 785 (137,148,1,2),
 786 (138,319,3,2),
 787 (139,11,175,2),
 788 (140,12,175,2),
 789 (141,13,175,2),
 790 (142,14,175,2),
 791 (143,15,175,2),
 792 (144,16,175,2),
 793 (145,17,175,2),
 794 (146,18,175,2),
 795 (147,19,175,2),
 796 (148,20,175,2),
 797 (149,316,175,2),
 798 (150,318,175,2),
 799 (151,317,175,2),
 800 (152,56,175,2),
 801 (158,301,175,3),
 802 (159,304,175,3),
 803 (160,24,175,3),
 804 (161,139,175,3),
 805 (162,142,175,3),
 806 (163,145,175,3),
 807 (164,115,175,3),
 808 (165,307,175,3),
 809 (166,310,175,3),
 810 (167,313,175,3),
 811 (168,148,175,3),
 812 (169,319,175,3);
 813
 814 --
 815 -- Dumping data for table `fn_menu_functional_roles`
 816 --
 817
 818 INSERT INTO `fn_menu_functional_roles` (`id`, `menu_id`, `app_id`, `role_id`) VALUES
 819 (1,19,5,1007),
 820 (2,19,5,1006),
 821 (3,24,5,1007),
 822 (4,24,5,1006),
 823 (5,56,5,1007),
 824 (6,56,5,1006),
 825 (8,115,4,1004),
 826 (9,115,4,1005),
 827 (10,139,4,1004),
 828 (11,139,4,1005),
 829 (12,142,4,1004),
 830 (13,142,4,1005),
 831 (14,145,4,1004),
 832 (15,145,4,1005),
 833 (16,148,4,1004),
 834 (17,148,4,1005),
 835 (18,301,4,1004),
 836 (19,301,4,1005),
 837 (20,304,4,1004),
 838 (21,304,4,1005),
 839 (22,307,4,1004),
 840 (23,307,4,1005),
 841 (24,310,4,1004),
 842 (25,310,4,1005),
 843 (26,313,4,1004),
 844 (27,313,4,1005),
 845 (39,319,6,1009),
 846 (40,319,6,1008),
 847 (42,317,3,1003),
 848 (43,317,3,1002);
 849
 850 --
 851 -- Dumping data for table `fn_qz_job_details`
 852 --
 853
 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');
 857
 858 INSERT INTO `fn_qz_locks` (`SCHED_NAME`, `LOCK_NAME`) VALUES
 859 ('Scheduler_20190808_one','STATE_ACCESS'),
 860 ('Scheduler_20190808_one','TRIGGER_ACCESS');
 861
 862 --
 863 -- Dumping data for table `fn_qz_scheduler_state`
 864 --
 865
 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);
 868
 869 --
 870 -- Dumping data for table `fn_qz_triggers`
 871 --
 872
 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,'');
 876
 877 --
 878 -- Dumping data for table `fn_qz_cron_triggers`
 879 --
 880
 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');
 884
 885 --
 886 -- Dumping data for table `fn_restricted_url`
 887 --
 888
 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');
 932
 933 --
 934 -- Dumping data for table `fn_role_composite`
 935 --
 936
 937 INSERT INTO `fn_role_composite` (`parent_role_id`, `child_role_id`) VALUES
 938 (1,16);
 939
 940 --
 941 -- Dumping data for table `fn_role_function`
 942 --
 943
 944 INSERT INTO `fn_role_function` (`id`, `function_cd`) VALUES
 945 (1,'login'),
 946 (1,'menu_admin'),
 947 (1,'menu_ajax'),
 948 (1,'menu_customer'),
 949 (1,'menu_customer_create'),
 950 (1,'menu_feedback'),
 951 (1,'menu_help'),
 952 (1,'menu_home'),
 953 (1,'menu_job'),
 954 (1,'menu_job_create'),
 955 (1,'menu_logout'),
 956 (1,'menu_notes'),
 957 (1,'menu_process'),
 958 (1,'menu_profile'),
 959 (1,'menu_profile_create'),
 960 (1,'menu_profile_import'),
 961 (1,'menu_reports'),
 962 (1,'menu_sample'),
 963 (1,'menu_tab'),
 964 (16,'login'),
 965 (16,'menu_ajax'),
 966 (16,'menu_customer'),
 967 (16,'menu_customer_create'),
 968 (16,'menu_home'),
 969 (16,'menu_logout'),
 970 (16,'menu_map'),
 971 (16,'menu_profile'),
 972 (16,'menu_reports'),
 973 (16,'menu_tab'),
 974 (950,'edit_notification'),
 975 (950,'getAdminNotifications'),
 976 (950,'saveNotification'),
 977 (1010,'menu_web_analytics'),
 978 (2115,'menu_web_analytics');
 979
 980 --
 981 -- Dumping data for table `fn_shared_context`
 982 --
 983
 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');
 997
 998 --
 999 -- Dumping data for table `fn_tab`
1000 --
1001
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');
1011
1012 --
1013 -- Dumping data for table `fn_tab_selected`
1014 --
1015
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'),
1024 ('TAB3','tab3'),
1025 ('TAB4','tab4');
1026
1027 --
1028 -- Dumping data for table `fn_user`
1029 --
1030
1031 INSERT INTO
1032   `fn_user` (
1033     `org_id`,
1034     `first_name`,
1035     `middle_name`,
1036     `last_name`,
1037     `phone`,
1038     `fax`,
1039     `cellular`,
1040     `email`,
1041     `address_id`,
1042     `alert_method_cd`,
1043     `hrid`,
1044     `org_user_id`,
1045     `org_code`,
1046     `login_id`,
1047     `login_pwd`,
1048     `last_login_date`,
1049     `active_yn`,
1050     `created_date`,
1051     `modified_date`,
1052     `is_internal_yn`,
1053     `address_line_1`,
1054     `address_line_2`,
1055     `city`,
1056     `state_cd`,
1057     `zip_code`,
1058     `country_cd`,
1059     `location_clli`,
1060     `org_manager_userid`,
1061     `company`,
1062     `department_name`,
1063     `job_title`,
1064     `timezone`,
1065     `department`,
1066     `business_unit`,
1067     `business_unit_name`,
1068     `cost_center`,
1069     `fin_loc_code`,
1070     `silo_status`,
1071     `language_id`
1072   )
1073 VALUES
1074   (
1075     NULL,
1076     'Demo',
1077     NULL,
1078     'User',
1079     NULL,
1080     NULL,
1081     NULL,
1082     'demo@openecomp.org',
1083     NULL,
1084     NULL,
1085     NULL,
1086     'demo',
1087     NULL,
1088     'demo',
1089     'demo123',
1090     '2019-08-08 12:18:17',
1091     1,
1092     '2016-10-14 21:00:00',
1093     '2019-08-08 12:18:17',
1094     0,
1095     NULL,
1096     NULL,
1097     NULL,
1098     'NJ',
1099     NULL,
1100     'US',
1101     NULL,
1102     NULL,
1103     NULL,
1104     NULL,
1105     NULL,
1106     10,
1107     NULL,
1108     NULL,
1109     NULL,
1110     NULL,
1111     NULL,
1112     NULL,
1113     1
1114   ),(
1115     NULL,
1116     'Jimmy',
1117     NULL,
1118     'Hendrix',
1119     NULL,
1120     NULL,
1121     NULL,
1122     'admin@onap.org',
1123     NULL,
1124     NULL,
1125     NULL,
1126     'jh0003',
1127     NULL,
1128     'jh0003',
1129     'demo123',
1130     '2019-08-08 10:16:11',
1131     1,
1132     '2016-10-14 21:00:00',
1133     '2019-08-08 10:16:11',
1134     0,
1135     NULL,
1136     NULL,
1137     NULL,
1138     'NJ',
1139     NULL,
1140     'US',
1141     NULL,
1142     NULL,
1143     NULL,
1144     NULL,
1145     NULL,
1146     10,
1147     NULL,
1148     NULL,
1149     NULL,
1150     NULL,
1151     NULL,
1152     NULL,
1153     1
1154   ),(
1155     NULL,
1156     'Carlos',
1157     NULL,
1158     'Santana',
1159     NULL,
1160     NULL,
1161     NULL,
1162     'designer@onap.org',
1163     NULL,
1164     NULL,
1165     NULL,
1166     'cs0008',
1167     NULL,
1168     'cs0008',
1169     'demo123',
1170     '2016-10-20 15:11:16',
1171     1,
1172     '2016-10-14 21:00:00',
1173     '2016-10-20 15:11:16',
1174     0,
1175     NULL,
1176     NULL,
1177     NULL,
1178     'NJ',
1179     NULL,
1180     'US',
1181     NULL,
1182     NULL,
1183     NULL,
1184     NULL,
1185     NULL,
1186     10,
1187     NULL,
1188     NULL,
1189     NULL,
1190     NULL,
1191     NULL,
1192     NULL,
1193     1
1194   ),(
1195     NULL,
1196     'Joni',
1197     NULL,
1198     'Mitchell',
1199     NULL,
1200     NULL,
1201     NULL,
1202     'tester@onap.org',
1203     NULL,
1204     NULL,
1205     NULL,
1206     'jm0007',
1207     NULL,
1208     'jm0007',
1209     'demo123',
1210     '2016-10-20 15:11:16',
1211     1,
1212     '2016-10-14 21:00:00',
1213     '2016-10-20 15:11:16',
1214     0,
1215     NULL,
1216     NULL,
1217     NULL,
1218     'NJ',
1219     NULL,
1220     'US',
1221     NULL,
1222     NULL,
1223     NULL,
1224     NULL,
1225     NULL,
1226     10,
1227     NULL,
1228     NULL,
1229     NULL,
1230     NULL,
1231     NULL,
1232     NULL,
1233     1
1234   ),(
1235     NULL,
1236     'Steve',
1237     NULL,
1238     'Regev',
1239     NULL,
1240     NULL,
1241     NULL,
1242     'ops@onap.org',
1243     NULL,
1244     NULL,
1245     NULL,
1246     'op0001',
1247     NULL,
1248     'op0001',
1249     'demo123',
1250     '2016-10-20 15:11:16',
1251     1,
1252     '2016-10-14 21:00:00',
1253     '2016-10-20 15:11:16',
1254     0,
1255     NULL,
1256     NULL,
1257     NULL,
1258     'NJ',
1259     NULL,
1260     'US',
1261     NULL,
1262     NULL,
1263     NULL,
1264     NULL,
1265     NULL,
1266     10,
1267     NULL,
1268     NULL,
1269     NULL,
1270     NULL,
1271     NULL,
1272     NULL,
1273     1
1274   ),(
1275     NULL,
1276     'David',
1277     NULL,
1278     'Shadmi',
1279     NULL,
1280     NULL,
1281     NULL,
1282     'governor@onap.org',
1283     NULL,
1284     NULL,
1285     NULL,
1286     'gv0001',
1287     NULL,
1288     'gv0001',
1289     'demo123',
1290     '2016-10-20 15:11:16',
1291     1,
1292     '2016-10-14 21:00:00',
1293     '2016-10-20 15:11:16',
1294     0,
1295     NULL,
1296     NULL,
1297     NULL,
1298     'NJ',
1299     NULL,
1300     'US',
1301     NULL,
1302     NULL,
1303     NULL,
1304     NULL,
1305     NULL,
1306     10,
1307     NULL,
1308     NULL,
1309     NULL,
1310     NULL,
1311     NULL,
1312     NULL,
1313     1
1314   ),(
1315     NULL,
1316     'Teddy',
1317     NULL,
1318     'Isashar',
1319     NULL,
1320     NULL,
1321     NULL,
1322     'pm1@onap.org',
1323     NULL,
1324     NULL,
1325     NULL,
1326     'pm0001',
1327     NULL,
1328     'pm0001',
1329     'demo123',
1330     '2016-10-20 15:11:16',
1331     1,
1332     '2016-10-14 21:00:00',
1333     '2016-10-20 15:11:16',
1334     0,
1335     NULL,
1336     NULL,
1337     NULL,
1338     'NJ',
1339     NULL,
1340     'US',
1341     NULL,
1342     NULL,
1343     NULL,
1344     NULL,
1345     NULL,
1346     10,
1347     NULL,
1348     NULL,
1349     NULL,
1350     NULL,
1351     NULL,
1352     NULL,
1353     1
1354   ),(
1355     NULL,
1356     'Eden',
1357     NULL,
1358     'Rozin',
1359     NULL,
1360     NULL,
1361     NULL,
1362     'ps1@onap.org',
1363     NULL,
1364     NULL,
1365     NULL,
1366     'ps0001',
1367     NULL,
1368     'ps0001',
1369     'demo123',
1370     '2016-10-20 15:11:16',
1371     1,
1372     '2016-10-14 21:00:00',
1373     '2016-10-20 15:11:16',
1374     0,
1375     NULL,
1376     NULL,
1377     NULL,
1378     'NJ',
1379     NULL,
1380     'US',
1381     NULL,
1382     NULL,
1383     NULL,
1384     NULL,
1385     NULL,
1386     10,
1387     NULL,
1388     NULL,
1389     NULL,
1390     NULL,
1391     NULL,
1392     NULL,
1393     1
1394   ),(
1395     NULL,
1396     'vid1',
1397     NULL,
1398     'user',
1399     NULL,
1400     NULL,
1401     NULL,
1402     'vid1@onap.org',
1403     NULL,
1404     NULL,
1405     NULL,
1406     'vid1',
1407     NULL,
1408     'vid1',
1409     'demo123',
1410     '2016-10-20 15:11:16',
1411     1,
1412     '2016-10-14 21:00:00',
1413     '2016-10-20 15:11:16',
1414     0,
1415     NULL,
1416     NULL,
1417     NULL,
1418     'NJ',
1419     NULL,
1420     'US',
1421     NULL,
1422     NULL,
1423     NULL,
1424     NULL,
1425     NULL,
1426     10,
1427     NULL,
1428     NULL,
1429     NULL,
1430     NULL,
1431     NULL,
1432     NULL,
1433     1
1434   ),(
1435     NULL,
1436     'vid2',
1437     NULL,
1438     'user',
1439     NULL,
1440     NULL,
1441     NULL,
1442     'vid2@onap.org',
1443     NULL,
1444     NULL,
1445     NULL,
1446     'vid2',
1447     NULL,
1448     'vid2',
1449     'demo123',
1450     '2016-10-20 15:11:16',
1451     1,
1452     '2016-10-14 21:00:00',
1453     '2016-10-20 15:11:16',
1454     0,
1455     NULL,
1456     NULL,
1457     NULL,
1458     'NJ',
1459     NULL,
1460     'US',
1461     NULL,
1462     NULL,
1463     NULL,
1464     NULL,
1465     NULL,
1466     10,
1467     NULL,
1468     NULL,
1469     NULL,
1470     NULL,
1471     NULL,
1472     NULL,
1473     1
1474   ),(
1475     NULL,
1476     'vid3',
1477     NULL,
1478     'user',
1479     NULL,
1480     NULL,
1481     NULL,
1482     'vid3@onap.org',
1483     NULL,
1484     NULL,
1485     NULL,
1486     'vid3',
1487     NULL,
1488     'vid3',
1489     'demo123',
1490     '2016-10-20 15:11:16',
1491     1,
1492     '2016-10-14 21:00:00',
1493     '2016-10-20 15:11:16',
1494     0,
1495     NULL,
1496     NULL,
1497     NULL,
1498     'NJ',
1499     NULL,
1500     'US',
1501     NULL,
1502     NULL,
1503     NULL,
1504     NULL,
1505     NULL,
1506     10,
1507     NULL,
1508     NULL,
1509     NULL,
1510     NULL,
1511     NULL,
1512     NULL,
1513     1
1514   ),(
1515     NULL,
1516     'steve',
1517     NULL,
1518     'user',
1519     NULL,
1520     NULL,
1521     NULL,
1522     'steve@onap.org',
1523     NULL,
1524     NULL,
1525     NULL,
1526     'steve',
1527     NULL,
1528     'steve',
1529     'demo123',
1530     '2017-05-19 15:11:16',
1531     1,
1532     '2017-05-19 21:00:00',
1533     '2017-05-19 15:11:16',
1534     0,
1535     NULL,
1536     NULL,
1537     NULL,
1538     'NJ',
1539     NULL,
1540     'US',
1541     NULL,
1542     NULL,
1543     NULL,
1544     NULL,
1545     NULL,
1546     10,
1547     NULL,
1548     NULL,
1549     NULL,
1550     NULL,
1551     NULL,
1552     NULL,
1553     1
1554   );
1555
1556 --
1557 -- Dumping data for table `ep_pers_user_app_sort`
1558 --
1559
1560 INSERT INTO `ep_pers_user_app_sort` (`id`, `user_id`, `sort_pref`) VALUES
1561 (1,1,0);
1562
1563 --
1564 -- Dumping data for table `fn_pers_user_app_sel`
1565 --
1566
1567 INSERT INTO `fn_pers_user_app_sel` (`id`, `user_id`, `app_id`, `status_cd`) VALUES
1568 (1,1,7,'S'),
1569 (2,1,8,'S'),
1570 (10,1,10,'S'),
1571 (11,1,5,'S');
1572
1573 --
1574 -- Dumping data for table `fn_audit_log`
1575 --
1576
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');
1585
1586 --
1587 -- Dumping data for table `fn_user_role`
1588 --
1589
1590 INSERT INTO `fn_user_role` (`user_id`, `role_id`, `priority`, `app_id`)
1591  VALUES
1592 (1,1,1,1),
1593 (1,950,1,1),
1594 (1,999,1,1),
1595 (1,999,1,2),
1596 (1,999,1,3),
1597 (1,999,1,4),
1598 (1,999,1,5),
1599 (1,999,1,6),
1600 (1,999,1,7),
1601 (1,1000,1,2),
1602 (1,1001,1,2),
1603 (1,1002,1,3),
1604 (1,1004,1,4),
1605 (1,1006,1,5),
1606 (1,1008,1,6),
1607 (2,999,1,4),
1608 (2,1004,1,4),
1609 (3,16,NULL,4),
1610 (3,1005,NULL,4),
1611 (4,16,NULL,4),
1612 (4,1005,NULL,4),
1613 (5,16,NULL,4),
1614 (5,1005,NULL,4),
1615 (6,16,NULL,4),
1616 (6,1005,NULL,4),
1617 (7,16,NULL,4),
1618 (7,1005,NULL,4),
1619 (8,16,NULL,4),
1620 (8,1005,NULL,4),
1621 (9,16,NULL,6),
1622 (9,999,NULL,1),
1623 (9,1008,NULL,6),
1624 (10,16,NULL,6),
1625 (10,1008,NULL,6),
1626 (10,1009,NULL,6),
1627 (11,16,NULL,6),
1628 (12,16,NULL,7),
1629 (12,1011,NULL,7),
1630 (12,1012,NULL,7);
1631
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 */;
1638
1639 -- Dump completed on 2019-08-13 10:20:25