All Code:
<cfajaximport tags="cfwindow">
<!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>Navy Seasonal Influenzia Vaccine Dashboard</title>
<cfinclude template="qry_dashboard.cfm">
<script language="JavaScript" src="js/FusionCharts.js"></script>
<script src="SpryAssets/SpryAccordion.js" type="text/javascript"></script>
<script src="SpryAssets/SpryTabbedPanels.js" type="text/javascript"></script>
<script language="JavaScript">
function FC_Rendered(DOMId){
//remove Message
var divRef = document.getElementById("unableDiv");
divRef.style.display='none';
}
function cleanup() {
ColdFusion.Window.destroy('reqinfo',true);
}
function showWin(id) {
//do we have one?
try {
ColdFusion.Window.destroy('reqinfo',true);
} catch(e) { }
ColdFusion.Window.create('reqinfo','Vials Requestor Information', 'requestor_pop.cfm?id='+id,{center:true,modal:true,closable:true}); ob = ColdFusion.Window.getWindowObject('reqinfo')
ob.center();
ColdFusion.Window.onHide('reqinfo',cleanup);
}
</script>
<!--- Create Array to Hold Region Total Data --->
<cfset arrTotalRegion = ArrayNew(2) />
<cfloop from="1" to="#GetRegionTotals.recordcount#" index="i">
<cfset arrTotalRegion[1] = "0">
<cfset arrTotalRegion[2] = "0">
<cfset arrTotalRegion[3] = "0">
<cfset arrTotalRegion[4] = "0">
<cfset arrTotalRegion[5] = "0">
<cfset arrTotalRegion[6] = "0">
<cfset arrTotalRegion[7] = "0">
</cfloop>
<cfoutput query="GetRegionTotals">
<cfset arrTotalRegion[currentrow][1] = "#GetRegionTotals.region#">
<cfset arrTotalRegion[currentrow][2] = "#GetRegionTotals.NasalTotal#">
<cfset arrTotalRegion[currentrow][3] = "#GetRegionTotals.TF6MTHS#">
<cfset arrTotalRegion[currentrow][4] = "#GetRegionTotals.TF36MTHS#">
<cfset arrTotalRegion[currentrow][5] = "#GetRegionTotals.TF18#">
<cfset arrTotalRegion[currentrow][6] = "#GetRegionTotals.TA6MTHS#">
<cfset arrTotalRegion[currentrow][7] = "#GetRegionTotals.TA18#">
</cfoutput>
<!--- Create Array to Hold Fleet Total Data --->
<cfset arrTotalFleet = ArrayNew(2) />
<cfloop from="1" to="#GetFleetTotals.recordcount#" index="i">
<cfset arrTotalFleet[1] = "0">
<cfset arrTotalFleet[2] = "0">
<cfset arrTotalFleet[3] = "0">
<cfset arrTotalFleet[4] = "0">
<cfset arrTotalFleet[5] = "0">
<cfset arrTotalFleet[6] = "0">
<cfset arrTotalFleet[7] = "0">
</cfloop>
<cfoutput query="GetFleetTotals">
<cfset arrTotalFleet[currentrow][1] = "#GetFleetTotals.fleet#">
<cfset arrTotalFleet[currentrow][2] = "#GetFleetTotals.NasalTotal#">
<cfset arrTotalFleet[currentrow][3] = "#GetFleetTotals.TF6MTHS#">
<cfset arrTotalFleet[currentrow][4] = "#GetFleetTotals.TF36MTHS#">
<cfset arrTotalFleet[currentrow][5] = "#GetFleetTotals.TF18#">
<cfset arrTotalFleet[currentrow][6] = "#GetFleetTotals.TA6MTHS#">
<cfset arrTotalFleet[currentrow][7] = "#GetFleetTotals.TA18#">
</cfoutput>
<!--- Create Array to Hold Region Detail Total Data --->
<cfset arrRegionDetail = ArrayNew(2) />
<cfloop from="1" to="#GetRegionDetailTotals.recordcount#" index="i">
<cfset arrRegionDetail[1] = "0">
<cfset arrRegionDetail[2] = "0">
<cfset arrRegionDetail[3] = "0">
<cfset arrRegionDetail[4] = "0">
<cfset arrRegionDetail[5] = "0">
<cfset arrRegionDetail[6] = "0">
<cfset arrRegionDetail[7] = "0">
<cfset arrRegionDetail[8] = "0">
<cfset arrRegionDetail[9] = "0">
<cfset arrRegionDetail[10] = "0">
<cfset arrRegionDetail[11] = "0">
</cfloop>
<cfoutput query="GetRegionDetailTotals">
<cfset arrRegionDetail[currentrow][1] = "#GetRegionDetailTotals.region#">
<cfset arrRegionDetail[currentrow][2] = "#GetRegionDetailTotals.uic_id#">
<cfset arrRegionDetail[currentrow][3] = "#GetRegionDetailTotals.name#">
<cfset arrRegionDetail[currentrow][4] = "#GetRegionDetailTotals.uic_child_id#">
<cfset arrRegionDetail[currentrow][5] = "#GetRegionDetailTotals.child_name#">
<cfset arrRegionDetail[currentrow][6] = "#GetRegionDetailTotals.NasalTotal#">
<cfset arrRegionDetail[currentrow][7] = "#GetRegionDetailTotals.TF6MTHS#">
<cfset arrRegionDetail[currentrow][8] = "#GetRegionDetailTotals.TF36MTHS#">
<cfset arrRegionDetail[currentrow][9] = "#GetRegionDetailTotals.TF18#">
<cfset arrRegionDetail[currentrow][10] = "#GetRegionDetailTotals.TA6MTHS#">
<cfset arrRegionDetail[currentrow][11] = "#GetRegionDetailTotals.TA18#">
</cfoutput>
<!--- Create Array to Hold Fleet Detail Total Data --->
<cfset arrFleetDetail = ArrayNew(2) />
<cfloop from="1" to="#GetFleetDetailTotals.recordcount#" index="i">
<cfset arrFleetDetail[1] = "0">
<cfset arrFleetDetail[2] = "0">
<cfset arrFleetDetail[3] = "0">
<cfset arrFleetDetail[4] = "0">
<cfset arrFleetDetail[5] = "0">
<cfset arrFleetDetail[6] = "0">
<cfset arrFleetDetail[7] = "0">
<cfset arrFleetDetail[8] = "0">
<cfset arrFleetDetail[9] = "0">
<cfset arrFleetDetail[10] = "0">
<cfset arrFleetDetail[11] = "0">
</cfloop>
<cfoutput query="GetFleetDetailTotals">
<cfset arrRegionDetail[currentrow][1] = "#GetFleetDetailTotals.region#">
<cfset arrRegionDetail[currentrow][2] = "#GetFleetDetailTotals.uic_id#">
<cfset arrRegionDetail[currentrow][3] = "#GetFleetDetailTotals.name#">
<cfset arrRegionDetail[currentrow][4] = "#GetFleetDetailTotals.uic_child_id#">
<cfset arrRegionDetail[currentrow][5] = "#GetFleetDetailTotals.child_name#">
<cfset arrRegionDetail[currentrow][6] = "#GetFleetDetailTotals.NasalTotal#">
<cfset arrRegionDetail[currentrow][7] = "#GetFleetDetailTotals.TF6MTHS#">
<cfset arrRegionDetail[currentrow][8] = "#GetFleetDetailTotals.TF36MTHS#">
<cfset arrRegionDetail[currentrow][9] = "#GetFleetDetailTotals.TF18#">
<cfset arrRegionDetail[currentrow][10] = "#GetFleetDetailTotals.TA6MTHS#">
<cfset arrRegionDetail[currentrow][11] = "#GetFleetDetailTotals.TA18#">
</cfoutput>
<link href="vials.css" rel="stylesheet" type="text/css" />
<link href="SpryAssets/SpryAccordion.css" rel="stylesheet" type="text/css" />
<link href="SpryAssets/SpryTabbedPanels.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="35">
<div align="center" class="Header">
<img src="_images/nmlc_logo.jpg" width="30" height="30" align="absmiddle" />
2010-2011 Navy Seasonal Influenza Vaccine Dashboard
<img src="_images/nmlc_logo.jpg" alt="" width="30" height="30" align="absmiddle" /></div></td>
</tr>
<tr>
<td><hr /></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" align="center" class="SubHeading">Total Response Percentage</td>
<td><div align="center"><span class="SubHeading">Regional Response Percentage</span></div></td>
<td><div align="center"><span class="SubHeading">Fleet Response Percentage</span></div></td>
</tr>
<tr>
<td width="30%" align="center" valign="top">
<div id="chartdiv" align="center"></div>
<script type="text/javascript">
var myChart = new FusionCharts("Charts/AngularGauge.swf", "myChartId", "300", "300", "0", "0");
myChart.setDataURL("xml/guagedata.xml");
myChart.render("chartdiv");
myChart.setTransparent("true");
</script>
</td>
<td width="35%" align="center" valign="top">
<div id="chart1div">
<noscript>
<!-- START Code Block for Chart -->
<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0" name="RegionalData" width="400" height="165" id="RegionalData">
<param name="allowScriptAccess" value="always" />
<param name="movie" value="Charts/Bar2D.swf"/>
<param name="FlashVars" value="&chartWidth=400&chartHeight=165&debugMode=0&dataURL=../Gallery/Data/Bar2D1.xml" />
<param name="quality" value="high" />
<param name="wmode" value="transparent">
<embed src="Charts/Bar2D.swf" FlashVars="&chartWidth=400&chartHeight=165&debugMode=0&dataURL=../Gallery/Data/Bar2D1.xml" quality="high" width="400" height="165" name="RegionalData" allowScriptAccess="always" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />
</object>
<!-- END Code Block for Chart sampleChart -->
</noscript>
<p>FusionCharts needs Adobe Flash Player to run. If you're unable to see the chart here, it means that your browser does not seem to have the Flash Player Installed. You can downloaded it <a href="http://www.adobe.com/products/flashplayer/" target="_blank"><u>here</u></a> for free.</p>
</div>
<script type="text/javascript">
var chart1 = new FusionCharts("Charts/Bar2D.swf", "sampleChart", "400", "175", "0", "1");
chart1.setDataURL("xml/region.xml");
chart1.render("chart1div");
chart1.setTransparent("true");
</script>
<br />
<div class="SubHeading">Overall Regional Percentage Completed</div><br />
<div id="FG_AvgRevDiv" style="margin-top:10px"></div>
<script type="text/javascript" language="javascript">
//Instantiate the Chart
var chart_FG_AvgRev = new FusionCharts("Charts/AngularGauge.swf", "RegionGuage", "180", "115", "0", "1");
//Set the dataURL of the chart
chart_FG_AvgRev.setDataURL("xml/regionguage.xml");
//Finally, render the chart.
chart_FG_AvgRev.render("FG_AvgRevDiv");
chart_FG_AvgRev.setTransparent("true");
</script>
</td>
<td width="35%" align="center" valign="top">
<div id="chart2div">
<noscript>
<!-- START Code Block for Chart sampleChart -->
<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0" name="FleetData" width="400" height="250" id="FleetData">
<param name="allowScriptAccess" value="always" />
<param name="movie" value="Charts/Bar2D.swf"/>
<param name="FlashVars" value="&chartWidth=400&chartHeight=250&debugMode=0&dataURL=../Gallery/Data/Bar2D1.xml" />
<param name="quality" value="high" />
<param name="wmode" value="transparent">
<embed src="Charts/Bar2D.swf" FlashVars="&chartWidth=400&chartHeight=250&debugMode=0&dataURL=../Gallery/Data/Bar2D1.xml" quality="high" width="400" height="250" name="ShipData" allowScriptAccess="always" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />
</object>
<!-- END Code Block for Chart sampleChart -->
</noscript>
<p>FusionCharts needs Adobe Flash Player to run. If you're unable to see the chart here, it means that your browser does not seem to have the Flash Player Installed. You can downloaded it <a href="http://www.adobe.com/products/flashplayer/" target="_blank"><u>here</u></a> for free.</p>
</div>
<script type="text/javascript">
var chart1 = new FusionCharts("Charts/Bar2D.swf", "FleetData", "400", "175", "0", "1");
chart1.setDataURL("xml/fleet.xml");
chart1.render("chart2div");
</script><br />
<div class="SubHeading">Overall Fleet Percentage Completed</div><br />
<div id="Fleet_AvgRevDiv" style="margin-top:10px"></div>
<script type="text/javascript" language="javascript">
//Instantiate the Chart
var chart_fleet_AvgRev = new FusionCharts("Charts/AngularGauge.swf","FleetGuage", "180", "115", "0", "1");
//Set the dataURL of the chart
chart_fleet_AvgRev.setDataURL("xml/fleetguage.xml");
//Finally, render the chart.
chart_fleet_AvgRev.render("Fleet_AvgRevDiv");
</script>
</td>
</tr>
<tr>
<td align="center" valign="top"> </td>
<td colspan="2" align="center" valign="top"> </td>
</tr>
<tr>
<td colspan="3" align="center"><hr /></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<div id="TabbedPanels1" class="TabbedPanels">
<ul class="TabbedPanelsTabGroup">
<li class="TabbedPanelsTab" tabindex="0">REGIONAL DATA</li>
<li class="TabbedPanelsTab" tabindex="0">FLEET DATA</li>
<li class="TabbedPanelsTab" tabindex="0">REPORTS</li>
</ul>
<div class="TabbedPanelsContentGroup">
<div class="TabbedPanelsContent">
<!-- Regional Table Accordian -->
<div id="Accordion1" class="Accordion" tabindex="0">
<div class="AccordionPanel">
<div class="AccordionPanelTab">
<div style="margin-top:5px">REGION TOTALS</div>
</div>
<div class="AccordionPanelContent">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30"></td>
<td class="tableHeading">Nasal Spray<br />
2yrs - 49 yrs</td>
<td class="tableHeading">Thimerosal - Free<br />
6 mths - 35 mths</td>
<td class="tableHeading">Thimerosal - Free<br />
36 mths - 17 yrs</td>
<td class="tableHeading">Thimerosal - Free<br />
18 yrs and older</td>
<td class="tableHeading">Thimerosal - Alt.<br />
6 mths - 35 mths</td>
<td class="tableHeading">Thimerosal - Alt.<br />
18 yrs and older</td>
<td class="tableHeading"><div style="margin-right:20px; text-align:right">TOTALS</div></td>
</tr>
<!--- Output RegionTotal Array --->
<cfset total2 = 0>
<cfset total3 = 0>
<cfset total4 = 0>
<cfset total5 = 0>
<cfset total6 = 0>
<cfset total7 = 0>
<cfoutput>
<cfloop from="1" to="#arrayLen(arrTotalRegion)#" index="x">
<tr>
<td height="25" class="MTFHeading">
<div style="margin-left:8px">
#arrTotalRegion[x][1]#
</div>
</td>
<td class="MTFHeadingNum">#NumberFormat(arrTotalRegion[x][2], "," )#</td>
<td class="MTFHeadingNum">#NumberFormat(arrTotalRegion[x][3], "," )#</td>
<td class="MTFHeadingNum">#NumberFormat(arrTotalRegion[x][4], "," )#</td>
<td class="MTFHeadingNum">#NumberFormat(arrTotalRegion[x][5], "," )#</td>
<td class="MTFHeadingNum">#NumberFormat(arrTotalRegion[x][6], "," )#</td>
<td class="MTFHeadingNum">#NumberFormat(arrTotalRegion[x][7], "," )#</td>
<cfset Total = #arrTotalRegion[x][2]# + #arrTotalRegion[x][3]# + #arrTotalRegion[x][4]# +
#arrTotalRegion[x][5]# + #arrTotalRegion[x][6]# + #arrTotalRegion[x][7]#>
<td class="MTFHeadingNum"><div style="margin-right:20px; text-align:right">#NumberFormat(Total, "," )#</div></td>
</tr>
<cfset total2 = total2 + arrTotalRegion[x][2]>
<cfset total3 = total3 + arrTotalRegion[x][3]>
<cfset total4 = total4 + arrTotalRegion[x][4]>
<cfset total5 = total5 + arrTotalRegion[x][5]>
<cfset total6 = total6 + arrTotalRegion[x][6]>
<cfset total7 = total7 + arrTotalRegion[x][7]>
</cfloop>
<tr bgcolor="##99FFFF">
<td height="25" class="SubHeadingData"><div style="margin-left:2px">Grand Totals</div></td>
<td width="10%" class="tableHeadingNum">#NumberFormat(total2, "," )#</td>
<td width="11%" class="tableHeadingNum">#NumberFormat(total3, "," )#</td>
<td width="11%" class="tableHeadingNum">#NumberFormat(total4, "," )#</td>
<td width="11%" class="tableHeadingNum">#NumberFormat(total5, "," )#</td>
<td width="11%" class="tableHeadingNum">#NumberFormat(total6, "," )#</td>
<td width="11%" class="tableHeadingNum">#NumberFormat(total7, "," )#</td>
<cfset GrandTotal = #total2# + #total3# + #total4# + #total5# + #total6# + #total7#>
<td width="10%" class="tableHeadingNum"><div style="margin-right:20px; text-align:right">#NumberFormat(GrandTotal, "," )#</div></td>
</tr>
</cfoutput>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</div>
</div>
<!--- <cfloop index="x" from="1" to="#arrayLen(arrRegionDetail)#">
<cfoutput group="#arrRegionDetail[x][1]#">
#arrRegionDetail[x][1]#<br />
<cfoutput group="#arrRegionDetail[x][2]#">
#arrRegionDetail[x][3]# (#arrRegionDetail[x][2]#)<br />
</cfoutput>
</cfoutput>
</cfloop> --->
<!--- Display Region Data (Group 1) --->
<cfoutput query="GetRegionDetailTotals" group="region">
<div class="AccordionPanel">
<div class="AccordionPanelTab">
<div style="margin-top:5px">#region#</div>
</div>
<div class="AccordionPanelContent">
<div style="margin:5px">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="20"></td>
<td class="tableHeading">Nasal Spray<br />
2yrs - 49 yrs</td>
<td class="tableHeading">Thimerosal - Free<br />
6 mths - 35 mths</td>
<td class="tableHeading">Thimerosal - Free<br />
36 mths - 17 yrs</td>
<td class="tableHeading">Thimerosal - Free<br />
18 yrs and older</td>
<td class="tableHeading">Thimerosal - Alt.<br />
6 mths - 35 mths</td>
<td class="tableHeading">Thimerosal - Alt.<br />
18 yrs and older</td>
<td class="tableHeading"><div style="margin-right:20px; text-align:right">TOTALS</div></td>
</tr>
<!--- Display Parent Data (Group 2) --->
<cfoutput group="uic_id">
<tr>
<td height="20" class="MTFHeading"><div style="margin-left:8px">
#name# (#uic_id#)
</div></td>
<td class="MTFHeadingNum"></td>
<td class="MTFHeadingNum"></td>
<td class="MTFHeadingNum"></td>
<td class="MTFHeadingNum"></td>
<td class="MTFHeadingNum"></td>
<td class="MTFHeadingNum"></td>
<td class="MTFHeadingNum"></td>
</tr>
<!--- Display Child Data --->
<cfoutput>
<tr bgcolor="###iif(currentrow MOD 2,DE('ffffff'),DE('FAF8F5'))#">
<td height="20" class="MTFSubHeading"><div style="margin-left:15px">
<a href="##" onClick="javascript:showWin('#uic_child_id#')">
#child_name# (#uic_child_id#)
</a>
</div></td>
<td class="MTFSubHeadingNum">#NumberFormat(arrRegionDetail[currentrow][6], "," )#</td>
<td class="MTFSubHeadingNum">#NumberFormat(arrRegionDetail[currentrow][7], "," )#</td>
<td class="MTFSubHeadingNum">#NumberFormat(arrRegionDetail[currentrow][8], "," )#</td>
<td class="MTFSubHeadingNum">#NumberFormat(arrRegionDetail[currentrow][9], "," )#</td>
<td class="MTFSubHeadingNum">#NumberFormat(arrRegionDetail[currentrow][10], "," )#</td>
<td class="MTFSubHeadingNum">#NumberFormat(arrRegionDetail[currentrow][11], "," )#</td>
<cfset GrandDetailTotal = #arrRegionDetail[currentrow][6]# +
#arrRegionDetail[currentrow][7]# + #arrRegionDetail[currentrow][8]# +
#arrRegionDetail[currentrow][9]# + #arrRegionDetail[currentrow][10]# +
#arrRegionDetail[currentrow][11]#>
<td class="MTFSubHeadingNumTotal"><div style="margin-right:20px; text-align:right"> #NumberFormat(GrandDetailTotal, "," )#</div></td>
</tr>
</cfoutput></cfoutput>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<!--- <tr bgcolor="##99FFFF">
<td height="20" class="SubHeadingData"><div style="margin-left:2px">TOTALS</div></td>
<td width="10%" class="tableHeadingNum"></td>
<td width="11%" class="tableHeadingNum"></td>
<td width="11%" class="tableHeadingNum"></td>
<td width="11%" class="tableHeadingNum"></td>
<td width="11%" class="tableHeadingNum"></td>
<td width="11%" class="tableHeadingNum"></td>
<td width="10%" class="tableHeadingNum"></td>
</tr> --->
</table>
</div>
</div>
</div>
</cfoutput></div>
<!-- End Regional Accordian-->
</div>
<!--- Fleet Data Tab --->
<div class="TabbedPanelsContent">
<div id="Accordion2" class="Accordion" tabindex="0">
<div class="AccordionPanel">
<div class="AccordionPanelTab"><div style="margin-top:5px">FLEET TOTALS</div></div>
<div class="AccordionPanelContent">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" width="100"></td>
<td class="tableHeading">Nasal Spray<br />
2yrs - 49 yrs</td>
<td class="tableHeading">Thimerosal - Free<br />
6 mths - 35 mths</td>
<td class="tableHeading">Thimerosal - Free<br />
36 mths - 17 yrs</td>
<td class="tableHeading">Thimerosal - Free<br />
18 yrs and older</td>
<td class="tableHeading">Thimerosal - Alt.<br />
6 mths - 35 mths</td>
<td class="tableHeading">Thimerosal - Alt.<br />
18 yrs and older</td>
<td class="tableHeading"><div style="margin-right:20px; text-align:right">TOTALS</div></td>
</tr>
<!--- Output FleetTotal Array --->
<cfset total2 = 0>
<cfset total3 = 0>
<cfset total4 = 0>
<cfset total5 = 0>
<cfset total6 = 0>
<cfset total7 = 0>
<cfoutput>
<cfif arrayLen(arrTotalFleet) EQ 0>
<tr>
<td class="MTFHeading" height="25"><div style="margin-left:8px">No Data to Display</div>
</td>
<td class="MTFHeading" colspan="7" height="25"></td>
</tr>
<cfelse>
<cfloop from="1" to="#arrayLen(arrTotalFleet)#" index="x">
<tr>
<td height="25" class="MTFHeading"><div style="margin-left:8px">#arrTotalFleet[x][1]#</div></td>
<td class="MTFHeadingNum">#NumberFormat(arrTotalFleet[x][2], "," )#</td>
<td class="MTFHeadingNum">#NumberFormat(arrTotalFleet[x][3], "," )#</td>
<td class="MTFHeadingNum">#NumberFormat(arrTotalFleet[x][4], "," )#</td>
<td class="MTFHeadingNum">#NumberFormat(arrTotalFleet[x][5], "," )#</td>
<td class="MTFHeadingNum">#NumberFormat(arrTotalFleet[x][6], "," )#</td>
<td class="MTFHeadingNum">#NumberFormat(arrTotalFleet[x][7], "," )#</td>
<cfset Total = #arrTotalFleet[x][2]# + #arrTotalFleet[x][3]# + #arrTotalFleet[x][4]# +
#arrTotalFleet[x][5]# + #arrTotalFleet[x][6]# + #arrTotalFleet[x][7]#>
<td class="MTFHeadingNum"><div style="margin-right:20px; text-align:right">#NumberFormat(Total, "," )#</div></td>
</tr>
<cfset total2 = total2 + arrTotalFleet[x][2]>
<cfset total3 = total3 + arrTotalFleet[x][3]>
<cfset total4 = total4 + arrTotalFleet[x][4]>
<cfset total5 = total5 + arrTotalFleet[x][5]>
<cfset total6 = total6 + arrTotalFleet[x][6]>
<cfset total7 = total7 + arrTotalFleet[x][7]>
</cfloop>
<tr bgcolor="##99FFFF">
<td height="25" class="SubHeadingData"><div style="margin-left:2px">Grand Totals</div></td>
<td width="10%" class="tableHeadingNum">#NumberFormat(total2, "," )#</td>
<td width="11%" class="tableHeadingNum">#NumberFormat(total3, "," )#</td>
<td width="11%" class="tableHeadingNum">#NumberFormat(total4, "," )#</td>
<td width="11%" class="tableHeadingNum">#NumberFormat(total5, "," )#</td>
<td width="11%" class="tableHeadingNum">#NumberFormat(total6, "," )#</td>
<td width="11%" class="tableHeadingNum">#NumberFormat(total7, "," )#</td>
<cfset GrandTotal = #total2# + #total3# + #total4# + #total5# + #total6# + #total7#>
<td width="10%" class="tableHeadingNum"><div style="margin-right:20px; text-align:right">#NumberFormat(GrandTotal, "," )#</div></td>
</tr>
</cfif>
</cfoutput>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</div>
</div>
<!--- Loop Fleet Data Tab --->
<cfoutput query="GetFleetDetailTotals" group="fleet">
<div class="AccordionPanel">
<div class="AccordionPanelTab">#Fleet#</div>
<div class="AccordionPanelContent">
<div style="margin:5px">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="20"></td>
<td class="tableHeading">Nasal Spray<br />
2yrs - 49 yrs</td>
<td class="tableHeading">Thimerosal - Free<br />
6 mths - 35 mths</td>
<td class="tableHeading">Thimerosal - Free<br />
36 mths - 17 yrs</td>
<td class="tableHeading">Thimerosal - Free<br />
18 yrs and older</td>
<td class="tableHeading">Thimerosal - Alt.<br />
6 mths - 35 mths</td>
<td class="tableHeading">Thimerosal - Alt.<br />
18 yrs and older</td>
<td class="tableHeading"><div style="margin-right:20px; text-align:right">TOTALS</div></td>
</tr>
<!--- Display Parent Data (Group 2) --->
<cfoutput group="tycom_type">
<tr>
<td height="20" class="MTFHeading"><div style="margin-left:8px">#tycom_type#</div></td>
<td class="MTFHeadingNum"></td>
<td class="MTFHeadingNum"></td>
<td class="MTFHeadingNum"></td>
<td class="MTFHeadingNum"></td>
<td class="MTFHeadingNum"></td>
<td class="MTFHeadingNum"></td>
<td class="MTFHeadingNum"></td>
</tr>
<!--- Display Child Data --->
<cfoutput>
<tr bgcolor="###iif(currentrow MOD 2,DE('ffffff'),DE('FAF8F5'))#">
<td height="20" class="MTFSubHeading"><div style="margin-left:15px">#ship_name# (#uic_id#)</div></td>
<td class="MTFSubHeadingNum">#NumberFormat(arrFleetDetail[currentrow][6], "," )#</td>
<td class="MTFSubHeadingNum">#NumberFormat(arrFleetDetail[currentrow][7], "," )#</td>
<td class="MTFSubHeadingNum">#NumberFormat(arrFleetDetail[currentrow][8], "," )#</td>
<td class="MTFSubHeadingNum">#NumberFormat(arrFleetDetail[currentrow][9], "," )#</td>
<td class="MTFSubHeadingNum">#NumberFormat(arrFleetDetail[currentrow][10], "," )#</td>
<td class="MTFSubHeadingNum">#NumberFormat(arrFleetDetail[currentrow][11], "," )#</td>
<cfset GrandFleetDetailTotal = #arrFleetDetail[currentrow][6]# +
#arrFleetDetail[currentrow][7]# + #arrFleetDetail[currentrow][8]# +
#arrFleetDetail[currentrow][9]# + #arrFleetDetail[currentrow][10]# +
#arrFleetDetail[currentrow][11]#>
<td class="MTFSubHeadingNumTotal"><div style="margin-right:20px; text-align:right"> #NumberFormat(GrandFleetDetailTotal, "," )#</div></td>
</tr>
</cfoutput></cfoutput>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</div>
</div>
</cfoutput>
</div>
</div>
<!--- End Regional Accordian --->
<div class="TabbedPanelsContent">
<div style="margin-top:10px">
<table width="90%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="text">
<table width="90%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="4%" height="25"><div align="center">•</div></td>
<td width="20%"><a href="reports/mtfdata.cfm">MTF Report</a></td>
<td width="73%">(Displays all MTF location with Regions and UIC information)</td>
</tr>
<tr>
<td height="25"><div align="center">•</div></td>
<td><a href="reports/mtf_complete.cfm">MTF Completed Requests</a></td>
<td>(Displays MTF Report of who has or has not completed a Vaccine request)</td>
</tr>
<tr>
<td height="25"><div align="center">•</div></td>
<td><a href="reports/fleetdata.cfm">Fleet Report</a></td>
<td>(Active Fleet Data Dump)</td>
</tr>
</table></td>
</tr>
</table>
<br />
</div>
</div>
</div>
</div>
</td>
</tr>
<tr>
<td></td>
</tr>
</table>
<p> </p>
<!--- Regional Data Accordian--->
<!--- End Accordian --->
<script type="text/javascript">
<!--
var Accordion1 = new Spry.Widget.Accordion("Accordion1", { useFixedPanelHeights: false, defaultPanel: -1 });
var TabbedPanels1 = new Spry.Widget.TabbedPanels("TabbedPanels1");
var Accordion2 = new Spry.Widget.Accordion("Accordion2");
//-->
</script>
</body>
</html>
