<!---initialising a variable for first time users --->
|
<!--- <cfparam name="Erl_graphType" default="0"> --->
|
<!--- Assigning all the cookie values --->
|
<cfif IsDefined("cookie.Erl_graphType")>
|
<cfcookie name="Erl_graphType" value="#Erl_graphType#" expires="never">
|
<cfelse>
|
<cfcookie name="Erl_graphType" value="area" expires="never">
|
</cfif>
|
<cfif IsDefined("cookie.view")>
|
<cfcookie name="view" value="#view#" expires="never">
|
<cfelse>
|
<cfcookie name="view" value="no" expires="never">
|
</cfif>
|
<cfif IsDefined("cookie.Erl_date")>
|
<cfcookie name="Erl_date" value="#Erl_date#" expires="never">
|
<cfelse>
|
<cfcookie name="Erl_date" value="Erlang_Today" expires="never">
|
</cfif>
|
<cfif IsDefined("cookie.Nwtype")>
|
<cfcookie name="nwtype" value="#nwtype#" expires="never">
|
<cfelse>
|
<cfcookie name="nwtype" value="nwtype_both" expires="never">
|
</cfif>
|
|
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
<html xmlns="http://www.w3.org/1999/xhtml">
|
<head>
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
<title>Erlang</title>
|
<link rel="stylesheet" type="text/css" href="../common/css/default.css">
|
|
<script language="javascript">
|
|
function show3D() {
|
return document.getElementById("cbShow3D").checked?"yes":"no";
|
}
|
function updateView() {
|
document.getElementById("ddlErlang").disabled = true;
|
document.getElementById("ddlGraphType").disabled = true;
|
document.getElementById("ddlNwtype").disabled = true;
|
document.getElementById("cbShow3D").disabled = true;
|
loc = "home_erlang.cfm?Erl_date=" + getDDLSelectedValue("ddlErlang") + "&Erl_graphType=" + getDDLSelectedValue("ddlGraphType")
|
+ "&view=" + show3D() + "&nwtype=" + getDDLSelectedValue("ddlNwtype");
|
document.location.href = loc;
|
}
|
|
function getDDLSelectedValue(ddl) {
|
if (document.getElementById(ddl).selectedIndex >= 0)
|
return document.getElementById(ddl).options[document.getElementById(ddl).selectedIndex].value;
|
}
|
|
</script>
|
|
</head>
|
|
<body>
|
|
<table width="100%">
|
<tr>
|
<td align="left">
|
<cftry>
|
|
|
<!--- Getting Erlang data of today from 0:00 to 23:00 (24 Hours) --->
|
<!--- Make the query to only query data after 30 minutes --->
|
<cfquery datasource="#application.dbconn#" name="Erlang_Today" cachedwithin="#CreateTimeSpan(0,0,15,0)#">
|
SELECT sdate,to_char(sdate,'hh24') AS time,round (TRUNC (SUM (erlang))) AS erlang
|
FROM webuser.ERLANG_TODAY
|
<cfif nwtype is not "nwtype_both">
|
WHERE nwtype = '#nwtype#'
|
</cfif>
|
group by sdate
|
order by sdate asc
|
</cfquery>
|
|
<cfset erlangTodayMaxValue = 0>
|
<cfloop query="Erlang_Today">
|
<cfif erlangTodayMaxValue lt erlang>
|
<cfset erlangTodayMaxValue = erlang>
|
</cfif>
|
</cfloop>
|
|
|
<!--- Getting Erlang data of yesterday from 0:00 to 23:00 (24 Hours) --->
|
<!--- Make the query to only query data after 6 hours --->
|
<cfquery name="Erlang_Yesterday" datasource="#application.dbconn#" cachedwithin="#CreateTimeSpan(0,6,0,0)#">
|
SELECT sdate,to_char(sdate,'hh24') AS time,round (TRUNC (SUM (erlang))) AS erlang
|
FROM webuser.ERLANG_YESTERDAY
|
<cfif nwtype is not "nwtype_both">
|
WHERE nwtype = '#nwtype#'
|
</cfif>
|
group by sdate
|
order by sdate
|
</cfquery>
|
|
|
<cfset erlangYestMaxValue = 0>
|
<cfloop query="Erlang_Yesterday">
|
<cfif erlangYestMaxValue lt erlang>
|
<cfset erlangYestMaxValue = erlang>
|
</cfif>
|
</cfloop>
|
|
<cfset erlangMaxValue = erlangTodayMaxValue>
|
|
<cfif cookie.Erl_date is "Erlang_Both">
|
<cfif erlangMaxValue lt erlangYestMaxValue>
|
<cfset erlangMaxValue = erlangYestMaxValue>
|
</cfif>
|
</cfif>
|
<cfif cookie.Erl_date is "Erlang_Yesterday">
|
<cfset erlangMaxValue = erlangYestMaxValue>
|
</cfif>
|
|
|
<cfset divideBy = 100>
|
<cfif erlangMaxValue gt 100>
|
<cfset divideBy = 1000>
|
</cfif>
|
|
<cfset erlangMaxValue = Round(erlangMaxValue / divideBy)>
|
|
<cfset erlangMaxValue = erlangMaxValue + 1>
|
<cfset erlangMaxValue = erlangMaxValue * divideBy>
|
|
|
<!--- Display both Yesterday and today's graph on the same chart --->
|
<cfif cookie.Erl_date is "Erlang_Both">
|
<p>
|
<strong>Erlang for <cfoutput query="Erlang_Today" maxrows="1">#DateFormat(sdate, 'DD MMMM YYYY')#</cfoutput> and <cfoutput query="Erlang_Yesterday" maxrows="1">#DateFormat(sdate, 'DD MMMM YYYY')#</cfoutput>
|
</strong>
|
<br />Erlang is a measurement of telephone traffic equivalent to 3600 seconds of telephone use. (i.e. one time slot used for a full hour)
|
</p>
|
<br>
|
<cfelse>
|
<p>
|
<strong>Erlang for <cfoutput query="#cookie.Erl_date#" maxrows="1">#DateFormat(sdate, 'DD MMMM YYYY')#</cfoutput></strong>
|
<br />
|
Erlang is a measurement of telephone traffic equivalent to 3600 seconds of telephone use. (i.e. one time slot used for a full hour)
|
</p>
|
</cfif>
|
|
|
<cfif cookie.Erl_date is "Erlang_Both">
|
<cfchart format="flash" gridlines="21" yaxistitle="Erlang traffic" xaxistitle="Time(Hours)" scaleto="#erlangMaxValue#" databackgroundcolor="##F3F3F3" show3d="#cookie.view#" chartheight="300" chartwidth="600" showmarkers="yes" foregroundcolor="##333399" markersize="1">
|
<cfchartseries paintstyle="light" serieslabel="Erlang Today" colorlist="##333399" type="#cookie.Erl_graphType#" itemcolumn="time" valuecolumn="Erlang" query="Erlang_Today" seriescolor="##00CC99"></cfchartseries>
|
<cfchartseries paintstyle="light" serieslabel="Erlang Yesterday" colorlist="##333399" type="#cookie.Erl_graphType#" itemcolumn="time" valuecolumn="Erlang" query="Erlang_Yesterday" seriescolor="##66CC00"></cfchartseries>
|
</cfchart>
|
<cfelse>
|
<!--- Display Yesterday or today's graph on the chart --->
|
<cfchart format="flash" gridlines="21" yaxistitle="Erlang traffic" xaxistitle="Time(Hours)" scaleto="#erlangMaxValue#" databackgroundcolor="##F3F3F3" show3d="#cookie.view#" chartheight="300" chartwidth="600" showmarkers="yes" foregroundcolor="##333399" markersize="1">
|
<cfchartseries paintstyle="light" serieslabel="#cookie.Erl_date#" colorlist="##66CC00" type="#cookie.Erl_graphType#" itemcolumn="time" valuecolumn="Erlang" query="#cookie.Erl_date#" seriescolor="##66CC00">
|
<!--- TO_CHAR(Time,'HH24') --->
|
</cfchartseries>
|
</cfchart>
|
</cfif>
|
|
<p>
|
Erlang:
|
<select name="ddlErlang" id="ddlErlang" class="form" onchange="javascript:updateView();">
|
<option value="Erlang_Both" <cfif Erl_date is "Erlang_Both">selected</cfif>>Both</option>
|
<option value="Erlang_Today" <cfif Erl_date is "Erlang_Today">selected</cfif>>Today</option>
|
<option value="Erlang_Yesterday" <cfif Erl_date is "Erlang_Yesterday">selected</cfif>>Yesterday</option>
|
</select>
|
|
|
Graph:
|
<select name="ddlGraphType" id="ddlGraphType" class="form" onchange="javascript:updateView();">
|
<option value="line" <cfif Erl_graphType is "line">selected</cfif>>Line</option>
|
<option value="bar" <cfif Erl_graphType is "bar">selected</cfif>>Bar</option>
|
<option value="area" <cfif Erl_graphType is "area">selected</cfif>>Area</option>
|
</select>
|
<input type="checkbox" id="cbShow3D" onchange="javascript:updateView();" <cfif view is "yes">checked</cfif>/>3D
|
|
|
Network:
|
<select name="ddlNwtype" id="ddlNwtype" class="form" onchange="javascript:updateView();">
|
<option value="nwtype_both" <cfif nwtype is "nwtype_both">selected</cfif>>Both</option>
|
<option value="2G" <cfif nwtype is "2G">selected</cfif>>2G</option>
|
<option value="3G" <cfif nwtype is "3G">selected</cfif>>3G</option>
|
</select><bR />
|
</p>
|
<cfcatch type="database">
|
<cfoutput>#cfcatch.Detail#</cfoutput>
|
</cfcatch>
|
</cftry>
|
</td>
|
</table>
|
|
|
|
<!---
|
|
<cfif #Erl_date# is 'Erlang_Today'>
|
<a href="home_erlang.cfm?Erl_date=Erlang_Both">Yesterday/Today</a> | <a href="home_erlang.cfm?Erl_date=Erlang_Yesterday">Yesterday</a> |
|
<!--- Setting Yesterday's option --->
|
<cfelseif #Erl_date# is 'Erlang_Yesterday'>
|
<a href="home_erlang.cfm?Erl_date=Erlang_Both">Yesterday/Today</a> | <a href="home_erlang.cfm?Erl_date=Erlang_Today">Today</a> |
|
<!--- setting Yesterday / today option --->
|
<cfelse>
|
<a href="home_erlang.cfm?Erl_date=Erlang_Today">Today</a> |
|
</cfif>
|
|
<a href="home_erlang.cfm?Erl_graphType=line&Erl_date=<cfoutput>#cookie.Erl_date#</cfoutput>">line</a> | <a href="home_erlang.cfm?Erl_graphType=bar&Erl_date=<cfoutput>#cookie.Erl_date#</cfoutput>">bar</a> | <a href="home_erlang.cfm?Erl_graphType=Area&Erl_date=<cfoutput>#cookie.Erl_date#</cfoutput>">Area</a> |
|
<cfif #cookie.view# is 'no'>
|
<a href="home_erlang.cfm?view=yes&Erl_graphType=<cfoutput>#cookie.Erl_graphType#&Erl_date=#Erl_date#</cfoutput>">3d graph</a>
|
<cfelse>
|
<a href="home_erlang.cfm?view=no&Erl_graphType=<cfoutput>#cookie.Erl_graphType#&Erl_date=#Erl_date#</cfoutput>">2d graph</a>
|
</cfif>
|
|
|
--->
|
|
</body>
|
</html>
|
