Home directory for Malawi's wwwroot
Duncan Ewan
2021-02-19 beae6e0bf7ffeba3d49691a847fab778e5296ce5
Removed ".old" files
1 files modified
3 files added
122 files deleted
6560 ■■■■ changed files
Application.cfm.tmp 6 ●●●●● patch | view | raw | blame | history
cf10_updates/hotfix_013.jar patch | view | raw | blame | history
cf10_updates/readme.txt 27 ●●●●● patch | view | raw | blame | history
cf10_updates/updates.xml 40 ●●●●● patch | view | raw | blame | history
cf10_updates/updates.xml.orig 189 ●●●●● patch | view | raw | blame | history
cf_test/timeout_test.cfm 19 ●●●●● patch | view | raw | blame | history
cf_test/timeout_test.cfm.1 1 ●●●● patch | view | raw | blame | history
common.old/Copy of header.cfm 17 ●●●●● patch | view | raw | blame | history
common.old/_mmServerScripts/Application.cfm 34 ●●●●● patch | view | raw | blame | history
common.old/_mmServerScripts/MMHTTPDB.cfm 99 ●●●●● patch | view | raw | blame | history
common.old/_mmServerScripts/MMSERVERINFO.cfm 122 ●●●●● patch | view | raw | blame | history
common.old/_mmServerScripts/SQLServer7.cfm 115 ●●●●● patch | view | raw | blame | history
common.old/_notes/dwsync.xml 13 ●●●●● patch | view | raw | blame | history
common.old/css/_notes/dwsync.xml 9 ●●●●● patch | view | raw | blame | history
common.old/css/default.css 386 ●●●●● patch | view | raw | blame | history
common.old/css/defaultold.css 318 ●●●●● patch | view | raw | blame | history
common.old/css/sortabletable.css 215 ●●●●● patch | view | raw | blame | history
common.old/footer.cfm 12 ●●●●● patch | view | raw | blame | history
common.old/footer.cfm.LCK 1 ●●●● patch | view | raw | blame | history
common.old/header.cfm 48 ●●●●● patch | view | raw | blame | history
common.old/header.cfm.LCK 1 ●●●● patch | view | raw | blame | history
common.old/header2.cfm 46 ●●●●● patch | view | raw | blame | history
common.old/home.cfm 56 ●●●●● patch | view | raw | blame | history
common.old/images/70x70.gif patch | view | raw | blame | history
common.old/images/Surizon-Tech-Logo-70_2.gif patch | view | raw | blame | history
common.old/images/SurizonTechLogo.jpg patch | view | raw | blame | history
common.old/images/SurizonTechLogo.jpg.LCK 1 ●●●● patch | view | raw | blame | history
common.old/images/Thumbs.db patch | view | raw | blame | history
common.old/images/_notes/blank.gif.mno 4 ●●●● patch | view | raw | blame | history
common.old/images/_notes/downsimple.gif.mno 4 ●●●● patch | view | raw | blame | history
common.old/images/_notes/dwsync.xml 18 ●●●●● patch | view | raw | blame | history
common.old/images/_notes/upsimple.gif.mno 4 ●●●● patch | view | raw | blame | history
common.old/images/blank.png patch | view | raw | blame | history
common.old/images/cal.gif patch | view | raw | blame | history
common.old/images/downsimple.png patch | view | raw | blame | history
common.old/images/fifalogo.gif patch | view | raw | blame | history
common.old/images/next.gif patch | view | raw | blame | history
common.old/images/prev.gif patch | view | raw | blame | history
common.old/images/sitelogo.gif patch | view | raw | blame | history
common.old/images/sitelogo.gif.old patch | view | raw | blame | history
common.old/images/sitelogo1.gif patch | view | raw | blame | history
common.old/images/upsimple.png patch | view | raw | blame | history
common.old/index.cfm 17 ●●●●● patch | view | raw | blame | history
common.old/js/_notes/dwsync.xml 10 ●●●●● patch | view | raw | blame | history
common.old/js/calendar.js 150 ●●●●● patch | view | raw | blame | history
common.old/js/hhmmsorttype.js 18 ●●●●● patch | view | raw | blame | history
common.old/js/numberksorttype.js 25 ●●●●● patch | view | raw | blame | history
common.old/js/selectbox.js 337 ●●●●● patch | view | raw | blame | history
common.old/js/sortabletable.js 455 ●●●●● patch | view | raw | blame | history
common.old/js/stringbuilder.js 79 ●●●●● patch | view | raw | blame | history
common/css/default.css 429 ●●●●● patch | view | raw | blame | history
components/getalarms.cfc 176 ●●●●● patch | view | raw | blame | history
home.old/_notes/dwsync.xml 7 ●●●●● patch | view | raw | blame | history
home.old/home_erlang.cfm 214 ●●●●● patch | view | raw | blame | history
home.old/home_erlang.cfm.LCK 1 ●●●● patch | view | raw | blame | history
home.old/js/_notes/dwsync.xml 5 ●●●●● patch | view | raw | blame | history
home.old/js/jquery-1.2.6.min.js 32 ●●●●● patch | view | raw | blame | history
home.old/js/jquery-1.2.6.min.js.LCK 1 ●●●● patch | view | raw | blame | history
home.old/marquee.cfm 170 ●●●●● patch | view | raw | blame | history
home.old/marquee.cfm.LCK 1 ●●●● patch | view | raw | blame | history
home/home_alarms.cfm 184 ●●●●● patch | view | raw | blame | history
index.cfm 21 ●●●●● patch | view | raw | blame | history
index_old.cfm 130 ●●●●● patch | view | raw | blame | history
jmxterm-1.0-alpha-4-uber.jar patch | view | raw | blame | history
templates.old/0261.txt 313 ●●●●● patch | view | raw | blame | history
templates.old/ApplicationSupportTemplate.dwt 116 ●●●●● patch | view | raw | blame | history
templates.old/Thumbs.db patch | view | raw | blame | history
templates.old/_notes/dwsync.xml 24 ●●●●● patch | view | raw | blame | history
templates.old/blank.gif patch | view | raw | blame | history
templates.old/blank.png patch | view | raw | blame | history
templates.old/closedfolder.gif patch | view | raw | blame | history
templates.old/css/_notes/dwsync.xml 5 ●●●●● patch | view | raw | blame | history
templates.old/css/default.css 223 ●●●●● patch | view | raw | blame | history
templates.old/css/sortabletable.css 46 ●●●●● patch | view | raw | blame | history
templates.old/demo2.html 268 ●●●●● patch | view | raw | blame | history
templates.old/doc.gif patch | view | raw | blame | history
templates.old/downsimple.png patch | view | raw | blame | history
templates.old/footer.cfm 16 ●●●●● patch | view | raw | blame | history
templates.old/fraudtest.htm 11 ●●●●● patch | view | raw | blame | history
templates.old/header.cfm 17 ●●●●● patch | view | raw | blame | history
templates.old/header.cfm.bk 17 ●●●●● patch | view | raw | blame | history
templates.old/headercs.cfm 21 ●●●●● patch | view | raw | blame | history
templates.old/images/70x70.gif patch | view | raw | blame | history
templates.old/images/BLUE_FOLDER.gif patch | view | raw | blame | history
templates.old/images/BLUE_FOLDER_OPEN.gif patch | view | raw | blame | history
templates.old/images/RED_FOLDER.gif patch | view | raw | blame | history
templates.old/images/RED_FOLDER_OPEN.gif patch | view | raw | blame | history
templates.old/images/SILVER_FOLDER.gif patch | view | raw | blame | history
templates.old/images/SILVER_FOLDER_OPEN.gif patch | view | raw | blame | history
templates.old/images/Surizon-Tech-Logo-70_2.gif patch | view | raw | blame | history
templates.old/images/YELLOW_FOLDER.gif patch | view | raw | blame | history
templates.old/images/YELLOW_FOLDER_OPEN.gif patch | view | raw | blame | history
templates.old/images/_notes/dwsync.xml 21 ●●●●● patch | view | raw | blame | history
templates.old/images/_vti_cnf/SILVER_FOLDER.gif 4 ●●●● patch | view | raw | blame | history
templates.old/images/_vti_cnf/_notes/dwsync.xml 5 ●●●●● patch | view | raw | blame | history
templates.old/images/_vti_cnf/yellow_FOLDER.gif 4 ●●●● patch | view | raw | blame | history
templates.old/images/blank.gif patch | view | raw | blame | history
templates.old/images/blank.png patch | view | raw | blame | history
templates.old/images/downsimple.gif patch | view | raw | blame | history
templates.old/images/downsimple.png patch | view | raw | blame | history
templates.old/images/irancell.bmp patch | view | raw | blame | history
templates.old/images/orang3.jpg patch | view | raw | blame | history
templates.old/images/upsimple.gif patch | view | raw | blame | history
templates.old/images/upsimple.png patch | view | raw | blame | history
templates.old/index.cfm 17 ●●●●● patch | view | raw | blame | history
templates.old/js/_notes/dwsync.xml 6 ●●●●● patch | view | raw | blame | history
templates.old/js/numberksorttype.js 25 ●●●●● patch | view | raw | blame | history
templates.old/js/sortabletable.js 455 ●●●●● patch | view | raw | blame | history
templates.old/js/stringbuilder.js 79 ●●●●● patch | view | raw | blame | history
templates.old/lastnode.gif patch | view | raw | blame | history
templates.old/link.gif patch | view | raw | blame | history
templates.old/local/_notes/dwsync.xml 10 ●●●●● patch | view | raw | blame | history
templates.old/local/helptip.css 38 ●●●●● patch | view | raw | blame | history
templates.old/local/helptip.js 215 ●●●●● patch | view | raw | blame | history
templates.old/local/title-background.png patch | view | raw | blame | history
templates.old/local/webfxapi.css 41 ●●●●● patch | view | raw | blame | history
templates.old/local/webfxapi.js 20 ●●●●● patch | view | raw | blame | history
templates.old/local/webfxlayout.css 1 ●●●● patch | view | raw | blame | history
templates.old/local/webfxlayout.js 111 ●●●●● patch | view | raw | blame | history
templates.old/main.html 23 ●●●●● patch | view | raw | blame | history
templates.old/menu.html 11 ●●●●● patch | view | raw | blame | history
templates.old/node.gif patch | view | raw | blame | history
templates.old/openfolder.gif patch | view | raw | blame | history
templates.old/upsimple.png patch | view | raw | blame | history
templates.old/vertline.gif patch | view | raw | blame | history
test.html 130 ●●●●● patch | view | raw | blame | history
Application.cfm.tmp
File was deleted
cf10_updates/hotfix_013.jar
Binary files differ
cf10_updates/readme.txt
File was deleted
cf10_updates/updates.xml
File was deleted
cf10_updates/updates.xml.orig
File was deleted
cf_test/timeout_test.cfm
File was deleted
cf_test/timeout_test.cfm.1
File was deleted
common.old/Copy of header.cfm
File was deleted
common.old/_mmServerScripts/Application.cfm
File was deleted
common.old/_mmServerScripts/MMHTTPDB.cfm
File was deleted
common.old/_mmServerScripts/MMSERVERINFO.cfm
File was deleted
common.old/_mmServerScripts/SQLServer7.cfm
File was deleted
common.old/_notes/dwsync.xml
File was deleted
common.old/css/_notes/dwsync.xml
File was deleted
common.old/css/default.css
File was deleted
common.old/css/defaultold.css
File was deleted
common.old/css/sortabletable.css
File was deleted
common.old/footer.cfm
File was deleted
common.old/footer.cfm.LCK
File was deleted
common.old/header.cfm
File was deleted
common.old/header.cfm.LCK
File was deleted
common.old/header2.cfm
File was deleted
common.old/home.cfm
File was deleted
common.old/images/70x70.gif
Binary files differ
common.old/images/Surizon-Tech-Logo-70_2.gif
Binary files differ
common.old/images/SurizonTechLogo.jpg
Binary files differ
common.old/images/SurizonTechLogo.jpg.LCK
File was deleted
common.old/images/Thumbs.db
Binary files differ
common.old/images/_notes/blank.gif.mno
File was deleted
common.old/images/_notes/downsimple.gif.mno
File was deleted
common.old/images/_notes/dwsync.xml
File was deleted
common.old/images/_notes/upsimple.gif.mno
File was deleted
common.old/images/blank.png
Binary files differ
common.old/images/cal.gif
Binary files differ
common.old/images/downsimple.png
Binary files differ
common.old/images/fifalogo.gif
Binary files differ
common.old/images/next.gif
Binary files differ
common.old/images/prev.gif
Binary files differ
common.old/images/sitelogo.gif
Binary files differ
common.old/images/sitelogo.gif.old
Binary files differ
common.old/images/sitelogo1.gif
Binary files differ
common.old/images/upsimple.png
Binary files differ
common.old/index.cfm
File was deleted
common.old/js/_notes/dwsync.xml
File was deleted
common.old/js/calendar.js
File was deleted
common.old/js/hhmmsorttype.js
File was deleted
common.old/js/numberksorttype.js
File was deleted
common.old/js/selectbox.js
File was deleted
common.old/js/sortabletable.js
File was deleted
common.old/js/stringbuilder.js
File was deleted
common/css/default.css
New file
@@ -0,0 +1,429 @@
body {
    font-size: 70%;
    margin: 0px;
    font-family: Arial, Helvetica, sans-serif;
    background-color: white;
    text-align: left;
}
.topheader-table {
    padding: 0px 0px 0px 0px;
    width: 100%;
    border-collapse: collapse;
    vertical-align: middle;
    height: 90x;
    background-color: #ffb300;
}
.bottomheader-table {
    padding: 0px 0px 0px 0px;
    width: 100%;
    border-collapse: collapse;
    vertical-align: middle;
    height: 1.75em;
    background-color: #ffc726;
}
.bottomheader-table td {
    border-right-color: #ffb300;
    border-right-width: thin;
    border-right-style: solid;
    border-left-color: #ffb300;
    border-left-width: thin;
    border-left-style: solid
}
.bottomheader-table a {
    text-align: center;
    padding: 0px 12px 0px 12px;
    vertical-align: middle;
    font-weight: bold;
    text-decoration: none;
    color: #272727;
    line-height: 1.7em;
    width: 100%;
}
.bottomheader-table a:hover {
    color: #ffffff;
}
.copysmall {
    FONT-SIZE: 0.9em;
    LINE-HEIGHT: 1.1em;
    text-align: right
}
.footer-table {
    width: 62.5em;
    padding: 0px 0px 0px 0px;
    border-collapse: collapse;
    text-align: center;
    margin-left: auto;
    margin-right: auto;
}
.footer-tableline {
    border-bottom: thin solid #ffc726;
}
a:hover {
    color: #000000;
}
a {
    color: #ffb300;
    font-weight: bold;
    text-decoration: none
}
.worklog {
    margin-left: 5px;
    margin-right: 5px
}
.data-help {
    cursor: help;
    color: #000000;
}
.legend-table {
    width: 95%;
    text-align: center;
    margin-left: auto;
    margin-right: auto;
    visibility: hidden;
    display: none;
    padding: 1px 1px 1px 1px;
    border-collapse: collapse;
    border: 1px Solid #ffb300;
}
.legend-table td {
    border: 1px solid;
    border-color: #ffb300;
}
.legend-label {
    background-color: #ffc726;
    font-weight: bold;
}
.heading1-table {
    width: 95%;
    text-align: center;
    margin-left: auto;
    margin-right: auto;
    padding: 0px 0px 0px 0px;
    border-collapse: collapse;
}
.heading1-table td {
    text-align: left;
}
.heading1 {
    font-weight: bold;
    font-size: medium;
}
.date-table {
    font: Arial;
    border: 1px Solid #ffb300;
    color: #000000;
    padding: 1px 1px;
    border-collapse: collapse;
    width: 95%;
    text-align: center;
    margin-left: auto;
    margin-right: auto;
}
.date-table thead {
    background: #ffc726;
}
.date-table td {
    border: 1px solid;
    border-color: #ffb300;
}
.date-table thead td {
    cursor: default;
    font-weight: bold;
    color: #000000;
}
.base-table {
    height: 80%;
    width: 95%;
    text-align: center;
    margin-left: auto;
    margin-right: auto;
    padding: 0px 0px 0px 0px;
    border-collapse: collapse;
}
.heading-2 {
    text-align: center;
    margin-left: auto;
    margin-right: auto;
    font-size: medium;
    font-family: Arial, Helvetica, sans-serif;
    font-weight: bold;
}
.inside-table {
    height: 100%;
    width: 100%;
    padding: 0px 0px 0px 0px;
    border-collapse: collapse;
}
.element-block {
    background-color: lime;
    padding: 0px 0px 0px 0px;
    border-collapse: collapse;
    border: 1px Solid black;
    text-align: center;
    margin-left: auto;
    margin-right: auto;
    font-size: medium;
    font-family: Arial, Helvetica, sans-serif;
    font-weight: bold;
    width: 200px;
    height: 100px;
}
.vconnect-block {
    background-color: lime;
    padding: 0px 0px 0px 0px;
    border-collapse: collapse;
    text-align: center;
    margin-left: auto;
    margin-right: auto;
    width: 50px;
    height: 50px;
    border-right: 1px Solid black;
    border-left: 1px Solid black;
}
.hconnect-block {
    background-color: lime;
    padding: 0px 0px 0px 0px;
    border-collapse: collapse;
    text-align: center;
    margin-left: auto;
    margin-right: auto;
    width: 50px;
    height: 50px;
    border-bottom: 1px Solid black;
    border-top: 1px Solid black;
}
.postilion-block {
    text-align: center;
    margin-left: auto;
    margin-right: auto;
    padding: 10px 10px 10px 10px;
    border-collapse: separate;
    border: 1px Solid black;
    font-size: medium;
    font-family: Arial, Helvetica, sans-serif;
    font-weight: bold;
    height: 50px;
}
/* resources table */
.resource-table {
    text-align: center;
    margin-left: auto;
    margin-right: auto;
    width: 30%;
}
.resource-table th {
    text-align: left;
}
.resource-input {
    width: 200px;
}
.resource-table td select {
    width: 200px;
}
.resource-table td textarea {
    width: 200px;
}
/* assignsites table */
.assignsites-table {
    text-align: center;
    margin-left: auto;
    margin-right: auto;
    width: 30%;
}
.assignsites-table th {
    text-align: left;
}
.assignsites-input {
    width: 200px;
}
.assignsites-table td select {
    width: 200px;
}
/* callout table */
.callout-table {
    text-align: center;
    margin-left: auto;
    margin-right: auto;
    width: 30%;
}
.callout-table th {
    text-align: left;
}
.callout-input {
    width: 275px;
    text-align: left;
}
.callout-table td {
    width: 300px;
}
.callout-table td select {
    width: 300px;
}
.callout-table td a {
    width: 30px;
}
.form {
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-size: 9px;
    text-decoration: none;
    color: #000000
}
.link {
    cursor: hand;
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-size: 9px;
    text-decoration: underline;
}
.body-vid {
    font-size: 100%;
    margin: 0px;
    font-family: Arial, Helvetica, sans-serif;
    background-color: black;
    text-align: left;
}
.legend-table-vid {
    width: 95%;
    font-size: 22px;
    text-align: center;
    margin-left: auto;
    margin-right: auto;
    padding: 1px 1px 1px 1px;
    border-collapse: collapse;
    border: 1px Solid #ffb300;
    color: lightgrey;
}
.legend-table-vid td {
    border: 1px solid;
    border-color: #FFFFFF;
    color: lightgrey;
}
.vid {
    background-color: steelblue;
    color: #000000;
    text-align: center;
    font-size: 22px;
}
.table-vid {
    background-color: black;
    width: 100%;
    border: 2px Solid #FFFFFF;
    border-collapse: collapse;
    padding: 1px 1px;
    color: white;
    font-size: 22px;
    margin-left: auto;
    margin-right: auto;
    color: lightgrey;
}
.table-vid thead {
    background: black;
    border: 2px Solid #FFFFFF;
}
.table-vid td {
    color: #ffff00;
    border: 2px Solid #FFFFFF;
}
.table-vid thead td {
    text-align: center;
    cursor: default;
    font-weight: bold;
    color: #CCCCCC;
    font-size: 50px;
}
.table-vid tbody td {
    text-align: center;
    cursor: default;
    font-weight: bold;
    color: #FFFF00;
    font-size: 50px;
}
.heading1-table-vid {
    border: 0px;
    width: 95%;
    text-align: center;
    margin-left: auto;
    margin-right: auto;
    padding: 0px 0px 0px 0px;
    border-collapse: collapse;
    font-size: 22px;
    color: steelblue;
}
.heading1-table-vid td {
    text-align: left;
    color: #ffff00;
    color: lightgrey;
}
.heading2-table-vid {
    border: 0px;
    text-align: center;
    margin-left: auto;
    margin-right: auto;
    padding: 0px 0px 0px 0px;
    border-collapse: collapse;
    font-size: 30px;
    color: lightgrey;
}
components/getalarms.cfc
New file
@@ -0,0 +1,176 @@
<cfcomponent>
  <cffunction access="public" name="getMaxListDate" output="false" returntype="query" hint="Returns the max date from the fm_alm_list table">
    <cfquery name="getMaxListDate" datasource="tnis" password="webuser" username="webuser">
    select to_char(max(event_date),'YYYY-MM-DD HH24:MI:SS') maxdate from acc_alarm_733_list where nwtype = 'WCDMA'
    </cfquery>
    <cfreturn getMaxListDate>
  </cffunction>
  <cffunction access="public" name="getCritAlarms" output="false" returntype="query" hint="Returns the critical network alarms">
    <cfquery name="getCritAlarms" datasource="tnis" password="webuser" username="webuser">
    select substr(ne,1,350) ne,substr(alarm,1,350) alarm,substr(ref,1,350) ref,substr(arsoutage,1,350) arsoutage,substr(tmosoutage,1,350) tmosoutage,substr(resource_group,1,350) resource_group,replace(replace(ptxt,chr(10),chr(13)),chr(34),' ') ptxt,substr(engineer,1,350) engineer,substr(phone,1,350) phone from v_fma_critical
    </cfquery>
    <cfreturn getCritAlarms>
  </cffunction>
  <cffunction access="public" name="getCellSupervision" output="false" returntype="query" hint="Returns A1 & A2 Cell Supervision Alarms">
    <cfargument name="bsc" type="string" required="no">
    <cfif IsDefined("bsc") and bsc neq "">
      <cfset session.bsc = "#Ucase(bsc)#">
      <cfset bscno = #ListLen(session.bsc)#>
      <cfelse>
      <cfset session.bsc = "">
    </cfif>
    <cfset yourTimeSpan = CreateTimeSpan(0,0,0,30)>
    <cfquery name="getCellSupervision" datasource="TNIS" username="NCC_REPORT" password="NCC_REPORT" cachedwithin="#yourTimeSpan#" >
    SELECT siteid, sitename, bsc, ref, fault_reason, isd_ref, status, outage, last_update, inception_time, severity, update_time_exp, tmn.getpriority_text (tmn.getpriority (siteid)) priority, tmn.getxalarms (siteid) xalarms, remedy.getplanned (siteid) planned, remedy.iscoallink (siteid) coallink, remedy.is_icc (siteid) specialevent, remedy.upd_time_expired (REF) updaterequired FROM tmn.v_fma_cellstatus
    <cfif #session.bsc# neq "" >
      WHERE
    </cfif>
    <cfif #session.bsc# neq "">
      <cfif bscno eq 1>
        bsc LIKE '%#bsc#%'
        <cfelse>
        bsc LIKE '%#ListFirst(session.bsc)#%'
        <cfloop from="2" to="#bscno#" index="Counter">
          or bsc LIKE '%#ListGetAt(session.bsc, Counter)#%'
        </cfloop>
      </cfif>
    </cfif>
    order by last_update,priority desc
    </cfquery>
    <cfreturn getCellSupervision>
  </cffunction>
  <cffunction access="public" name="getCommands" output="false" returntype="query" hint="Returns Commands send to network elements">
    <cfargument name="cmdtext" type="string" required="yes">
    <cfargument name="paratext" type="string" required="yes">
    <cfargument name="date1" type="string" required="yes">
    <cfargument name="date2" type="string" required="yes">
    <cfargument name="ne" type="string" required="no">
    <cfargument name="type" type="string" required="no">
    <cfquery name="getCommands" datasource="tnis" username="webuser" password="webuser">
    SELECT ne, substr(cmd,1,100)||'<br>'||substr(cmd,101,length(cmd)-100) cmd, to_char(datum,'YYYY-MM-DD HH24:MI:SS') datum, username, cmd_type FROM command.v_all_cmd WHERE SUBSTR (cmd, 1, 5) LIKE '#cmdtext#' AND SUBSTR (cmd, 6) LIKE '%#paratext#%' AND datum BETWEEN TO_DATE ('#date1#', 'yyyy-mm-dd HH24:MI:SS') AND TO_DATE ('#date2#', 'yyyy-mm-dd HH24:MI:SS')
    <cfif ne neq "">
      AND ne = '#ne#'
    </cfif>
    <cfif type neq "">
      AND cmd_type = '#type#'
    </cfif>
    ORDER by datum desc
    </cfquery>
    <cfreturn getCommands>
  </cffunction>
    <cffunction access="public" name="getNodeNames" output="false" returntype="query" hint="Returns the node names">
    <cfquery name="getNodeNames" datasource="tnis" password="webuser" username="webuser">
    select nodename from axe_node WHERE type not in ('SDP','BGW') order by nodename
    </cfquery>
    <cfreturn getNodeNames>
  </cffunction>
  <cffunction access="public" name="getARSWorkLog" output="false" returntype="query" hint="Returns ars worklog">
    <cfargument name="ref" type="string" required="yes">
    <cfquery name="getARSWorklog" datasource="tnis">
        select replace(fault_work_log,chr(13),'<br/>') fault_work_log
        from v_nwm_faultlog_all
        where ref = '#ref#'
    </cfquery>
    <cfreturn getARSWorklog>
  </cffunction>
  <cffunction access="public" name="getPlannedAnchorLog" output="false" returntype="query" hint="Returns ars planned anchor worklog">
    <cfargument name="siteid" type="string" required="yes">
    <cfquery name="getPlannedAnchorLog" datasource="tnis" username="tmn" password="rainydays">
        SELECT '<a href="worklog.cfm?value='||REF||'&setting=ref">'||REF||'</a><br/>' REF
          FROM mtn_eventlog
         WHERE status = 0
           AND (event LIKE '%PLANNED%' OR event_category LIKE '%PLANNED%')
           AND (t_number = '#siteid#')
    </cfquery>
    <cfreturn getPlannedAnchorLog>
  </cffunction>
  <cffunction access="public" name="getPlannedLogCount" output="false" returntype="query" hint="Returns ars planned worklog count">
    <cfargument name="siteid" type="string" required="yes">
    <cfquery name="getPlannedLogCount" datasource="tnis" username="tmn" password="rainydays">
        SELECT COUNT (*) COUNT
          FROM mtn_eventlog
         WHERE status = 0
           AND (event LIKE '%PLANNED%' OR event_category LIKE '%PLANNED%')
           AND (t_number = '#siteid#')
    </cfquery>
    <cfreturn getPlannedLogCount>
  </cffunction>
  <cffunction access="public" name="getPlannedLog" output="false" returntype="query" hint="Returns ars planned worklog">
    <cfargument name="siteid" type="string" required="yes">
    <cfquery name="getPlannedLog" datasource="tnis" username="tmn" password="rainydays">
        SELECT REF
          FROM mtn_eventlog
         WHERE status = 0
           AND (event LIKE '%PLANNED%' OR event_category LIKE '%PLANNED%')
           AND (t_number = '#siteid#')
    </cfquery>
    <cfreturn getPlannedLog>
  </cffunction>
    <cffunction name="getAlarmsBySeverityJSON" access="remote" returntype="struct" output="no" returnformat="json" >
        <!--- <cfset hasAdminRights = ListContainsNoCase(session.userRoles,"ACC_ADMINISTRATOR",",")> --->
        <cfset hasAdminRights = 1>
        <cfset hasRights = hasAdminRights or isAllowedUser or isAllowedAdmin>
        <cfif hasRights> <!--- START "hasRights" --->
            <cfset var NodeBytesSentStruct = StructNew()/>
            <cfset NodeBytesSentStruct.status = true />
            <cftry>
                <cfquery name="getNodeBytesSentQuery" datasource="accdb" result="getDomainCntQueryResult">
                SELECT
                    round(ksink.remedy_pkg.asnumdate(sdate), 0) sdate,
                    severity,
                    COUNT(*) AS events
                FROM
                    (
                        SELECT
                            trunc(event_time, 'HH24')        AS sdate,
                            upper(perceived_severity)     AS severity
                        FROM
                            acc_alarm_733_list
                        WHERE
                            event_time > sysdate - 2
                    ) a
                GROUP BY
                    sdate,
                    severity
                ORDER BY
                    sdate,
                    severity
                </cfquery>
                <cfset var NodeBytesSentRecord = arrayNew(1)/>
                <cfset var NodeBytesSentStruct = StructNew()/>
                <cfset NodeBytesSentStruct.status = true />
                <cfloop query="getNodeBytesSentQuery" > <!--- START Loop "getNodeBytesSentQuery"--->
                <cfset var NodeBytesSentTmp = arrayNew(1)/>
                    <cfset ArrayAppend(NodeBytesSentRecord, { sdate = getNodeBytesSentQuery.sdate, severity = getNodeBytesSentQuery.severity, events = getNodeBytesSentQuery.events })>
                </cfloop> <!--- END Loop "getNodeBytesSentQuery"--->
                <!--- <cfset DomainCntStruct.data = serializeJSON(NodeBytesSentRecord) /> --->
                <cfset DomainCntStruct.data = NodeBytesSentRecord />
                <cfcatch type="any">
                    <cfset DomainCntStruct.status = false />
                    <cfif isdefined('cfcatch.sql')>
                        <cflog text="insertConfigItems: #cfcatch.message#; #cfcatch.detail#; #cfcatch.sql#">
                        <cfset DomainCntStruct["SQL"] = cfcatch.sql />
                    <cfelse>
                        <cflog text="insertConfigItems: #cfcatch.message#; #cfcatch.detail#;">
                    </cfif>
                    <cfset DomainCntStruct["Result"] = "ERROR" />
                    <cfset DomainCntStruct["Message"] = cfcatch.message />
                    <cfset DomainCntStruct["Detail"] = cfcatch.detail />
                </cfcatch>
            </cftry>
        <cfelse> <!--- MIDDLE "hasRights" --->
            <cfset DomainCntStruct.status = false />
            <cfset DomainCntStruct.reason = 'You do not have the required permissions' />
        </cfif> <!--- END "hasRights" --->
        <cfreturn DomainCntStruct>
    </cffunction>
</cfcomponent>
home.old/_notes/dwsync.xml
File was deleted
home.old/home_erlang.cfm
File was deleted
home.old/home_erlang.cfm.LCK
File was deleted
home.old/js/_notes/dwsync.xml
File was deleted
home.old/js/jquery-1.2.6.min.js
File was deleted
home.old/js/jquery-1.2.6.min.js.LCK
File was deleted
home.old/marquee.cfm
File was deleted
home.old/marquee.cfm.LCK
File was deleted
home/home_alarms.cfm
New file
@@ -0,0 +1,184 @@
<!DOCTYPE HTML>
<html lang="en">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Alarms</title>
    <link rel="icon" href="favicon.png">
    <link rel="stylesheet" href="/common/css/default.css">
    <link rel="stylesheet" href="/acc/css/upd/all.min.css" />
    <style>
        table {
            margin: 0 auto;
            border: 0;
            width: 100%
        }
        .text-left {
            text-align: left;
        }
        .text-center {
            text-align: center;
        }
        .text-right {
            text-align: right;
        }
    </style>
</head>
<body>
    <table>
        <tr>
            <td class="text-left">
                <div id="container"> </div>
            </td>
        </tr>
    </table>
    <script src="/acc/js/upd/jquery.min.js"></script>
    <script src="/acc/js/upd/all.min.js"></script>
    <script src="/acc/js/upd/highcharts.js"></script>
    <script src="/acc/js/upd/highcharts-more.js"></script>
    <script>
        $(document).ready(function() {
            //       mainChart();
        });
        Highcharts.setOptions({
            time: {
                timezoneOffset: -2 * 60
            }
        });
        const chart_colurs = [
            '#FF0000',
            '#FFBB00',
            '#FFFF00',
            '#008B8B',
            '#8085e9',
            '#f15c80',
            '#e4d354',
            '#2b908f',
            '#f45b5b',
            '#91e8e1'
        ]
        Highcharts.setOptions({
            colors: Highcharts.map(chart_colurs, function(color) {
                return {
                    radialGradient: {
                        cx: 0.5,
                        cy: 0.3,
                        r: 0.7
                    },
                    stops: [
                        [0, color],
                        [1, Highcharts.color(color).brighten(-0.3).get('rgb')] // darken
                    ]
                }
            })
        })
        let options222 = {
            chart: {
                renderTo: 'container',
                zoomType: 'x',
                borderWidth: 0,
                plotBorderWidth: 0,
                type: 'area'
            },
            title: {
                text: 'Last 48 hours'
            },
            xAxis: {
                type: 'datetime',
                minRange: 1 * 3600000
            },
            yAxis: {
                title: {
                    text: 'Alarms by severity'
                },
                labels1: {
                    formatter: function() {
                        return this.value / 1000000;
                    },
                }
            },
            tooltip: {
                pointFormat: '<span style="color:{series.color}">{series.name}</span>: <b>{point.percentage:.1f}%</b> ({point.y:,.0f})<br/>',
                split: true
            },
            credits: {
                enabled: false
            },
            plotOptions: {
                area: {
                    stacking: 'percent',
                    lineColor: '#ffffff',
                    lineWidth: 1,
                    marker: {
                        lineWidth: 0.5,
                        lineColor: '#ffffff',
                        width: 8,
                        height: 8,
                        enabled: false
                    },
                    accessibility: {
                        pointDescriptionFormatter: function(point) {
                            function round(x) {
                                return Math.round(x * 100) / 100;
                            }
                            return (point.index + 1) + ', ' + point.category + ', ' +
                                point.y + ', ' + round(point.percentage) + '%, ' +
                                point.series.name;
                        }
                    }
                }
            },
            series: [{}]
        }
        $.getJSON("/components/getalarms.cfc?method=getAlarmsBySeverityJSON", function(data) {
            const chartSeries = convertObjKeysToLower(data.DATA);
            console.log(convertToHC(chartSeries));
            options222.series = convertToHC(chartSeries);
            const chart22 = new Highcharts.Chart(options222);
        });
        function convertObjKeysToLower(rawjson) {
            let upperJSON = JSON.stringify(rawjson);
            let lowerJSON = upperJSON.replace(/"([\w]+)":/g, function($0, $1) {
                return ('"' + $1.toLowerCase() + '":');
            });
            return JSON.parse(lowerJSON);
        }
        function convertToHC(data) {
            let fff = {};
            let datad = [];
            data.forEach(element => {
                if (fff[element.severity]) {} else {
                    fff[element.severity] = [];
                }
                let entry = [element.sdate * 1000, element.events];
                fff[element.severity].push(entry);
            });
            Object.keys(fff).forEach(function(key) {
                let stru = {
                    name: key,
                    data: fff[key]
                }
                datad.push(stru);
            });
            return datad;
        }
    </script>
</body>
</html>
index.cfm
@@ -1,8 +1,12 @@
<!DOCTYPE html>
<html>
<html lang="en">
<head>
    <title>NMS Home Page</title>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
    <meta charset="UTF-8" />
    <meta name="viewport" content="width=device-width,initial-scale=1" />
    <meta name="description" content="" />
    <link rel="icon" href="favicon.png">
    <link rel="stylesheet" type="text/css" href="/acc/css/styles.css"/>
    <cfinclude template="/acc/jquery-include-template.cfm">
    <link rel="stylesheet" href="/acc/css/font-awesome-4.0.3/css/font-awesome.min.css">
@@ -28,6 +32,7 @@
    </script>
</head>
<body>
<cfset title="NMS Home">
<cfset isShowUserLoginInformation = false>
<cfinclude template="/acc/template/thinTitlebar.cfm">
@@ -35,16 +40,11 @@
<cffunction name="showMenu">
    <cfargument name="position" type="string">
    <cfquery name="displayCatQry" dbtype="query">
        select distinct category_id, category_name, cat_icon from getNMSHomeItemsForHomePageQry where pos='#position#'
                order by category_name asc
        select distinct category_id, category_name, cat_icon from getNMSHomeItemsForHomePageQry where pos='#position#' order by category_name asc
    </cfquery>
    <!---<cfdump var="#displayCatQry#">--->
    <cfloop query="displayCatQry">
        <cfoutput>
        <div class="portlet" style="width:300px;background:#application.oddBackgroundColor#;">
            <div class="portlet-header"><cfif displayCatQry.cat_icon neq ""><i class="fa #displayCatQry.cat_icon#"></i>&nbsp;</cfif>#displayCatQry.category_name#</div>
@@ -62,12 +62,9 @@
        </div>
        </cfoutput>
    </cfloop>
</cffunction>
<cfinvoke component="acc.nms_home.components.nms_home"
          method="getNMSHomeItemsForHomePage"
          returnvariable="getNMSHomeItemsForHomePageQry" />
<cfinvoke component="acc.nms_home.components.nms_home" method="getNMSHomeItemsForHomePage" returnvariable="getNMSHomeItemsForHomePageQry" />
<table border="0" cellspacing="0" cellpadding="0">
    <tr>
index_old.cfm
File was deleted
jmxterm-1.0-alpha-4-uber.jar
Binary files differ
templates.old/0261.txt
File was deleted
templates.old/ApplicationSupportTemplate.dwt
File was deleted
templates.old/Thumbs.db
Binary files differ
templates.old/_notes/dwsync.xml
File was deleted
templates.old/blank.gif
Binary files differ
templates.old/blank.png
Binary files differ
templates.old/closedfolder.gif
Binary files differ
templates.old/css/_notes/dwsync.xml
File was deleted
templates.old/css/default.css
File was deleted
templates.old/css/sortabletable.css
File was deleted
templates.old/demo2.html
File was deleted
templates.old/doc.gif
Binary files differ
templates.old/downsimple.png
Binary files differ
templates.old/footer.cfm
File was deleted
templates.old/fraudtest.htm
File was deleted
templates.old/header.cfm
File was deleted
templates.old/header.cfm.bk
File was deleted
templates.old/headercs.cfm
File was deleted
templates.old/images/70x70.gif
Binary files differ
templates.old/images/BLUE_FOLDER.gif
Binary files differ
templates.old/images/BLUE_FOLDER_OPEN.gif
Binary files differ
templates.old/images/RED_FOLDER.gif
Binary files differ
templates.old/images/RED_FOLDER_OPEN.gif
Binary files differ
templates.old/images/SILVER_FOLDER.gif
Binary files differ
templates.old/images/SILVER_FOLDER_OPEN.gif
Binary files differ
templates.old/images/Surizon-Tech-Logo-70_2.gif
Binary files differ
templates.old/images/YELLOW_FOLDER.gif
Binary files differ
templates.old/images/YELLOW_FOLDER_OPEN.gif
Binary files differ
templates.old/images/_notes/dwsync.xml
File was deleted
templates.old/images/_vti_cnf/SILVER_FOLDER.gif
File was deleted
templates.old/images/_vti_cnf/_notes/dwsync.xml
File was deleted
templates.old/images/_vti_cnf/yellow_FOLDER.gif
File was deleted
templates.old/images/blank.gif
Binary files differ
templates.old/images/blank.png
Binary files differ
templates.old/images/downsimple.gif
Binary files differ
templates.old/images/downsimple.png
Binary files differ
templates.old/images/irancell.bmp
Binary files differ
templates.old/images/orang3.jpg
Binary files differ
templates.old/images/upsimple.gif
Binary files differ
templates.old/images/upsimple.png
Binary files differ
templates.old/index.cfm
File was deleted
templates.old/js/_notes/dwsync.xml
File was deleted
templates.old/js/numberksorttype.js
File was deleted
templates.old/js/sortabletable.js
File was deleted
templates.old/js/stringbuilder.js
File was deleted
templates.old/lastnode.gif
Binary files differ
templates.old/link.gif
Binary files differ
templates.old/local/_notes/dwsync.xml
File was deleted
templates.old/local/helptip.css
File was deleted
templates.old/local/helptip.js
File was deleted
templates.old/local/title-background.png
Binary files differ
templates.old/local/webfxapi.css
File was deleted
templates.old/local/webfxapi.js
File was deleted
templates.old/local/webfxlayout.css
File was deleted
templates.old/local/webfxlayout.js
File was deleted
templates.old/main.html
File was deleted
templates.old/menu.html
File was deleted
templates.old/node.gif
Binary files differ
templates.old/openfolder.gif
Binary files differ
templates.old/upsimple.png
Binary files differ
templates.old/vertline.gif
Binary files differ
test.html
File was deleted