2
<%@ page import="java.sql.*,java.util.*" %>
3
<%@ page import="com.opensymphony.xwork.util.OgnlValueStack" %>
5
<%@ page session="true"%>
10
// For finding organisationunit name of selected Orgunit based on Orgunit id
14
// For finding start date of selected period based on period id
18
// For finding child orgunit ids and names based on selected orgunit id
22
// For finding child orgunit
27
String userName = "dhis";
29
String urlForConnection = "jdbc:mysql://localhost/jh_dhis2";
31
OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
33
String selectedId = (String) stack.findValue( "orgUnitId" );
34
int selectedOrgUnitID = Integer.parseInt( selectedId );
36
// String selectedPeriodId = (String) stack.findValue( "periodSelect" );
37
// int selectedDataPeriodID = Integer.parseInt( selectedPeriodId );
39
String startingDate = (String) stack.findValue( "startingPeriod" );
40
String endingDate = (String) stack.findValue( "endingPeriod" );
43
String monthlyPeriodId = (String) stack.findValue( "monthlyPeriodTypeId" );
44
int periodTypeID = Integer.parseInt( monthlyPeriodId );
47
String selectedOrgUnitName = "";
48
String selectedDataPeriodStartDate = "";
50
String monthNames[] = { "", "January", "February", "March", "April", "May", "June", "July", "August", "September","October", "November", "December" };
52
String monthlyDataElements[] = {
55
// Report upto Previous Month - Cases, Deaths
56
"KALA_DE1", "KALA_DE2",
58
// During the Month - Cases, Deaths
59
"KALA_DE1", "KALA_DE2",
61
// No. of Cases Reported - (0-1) Male, (0-1) Female
62
"KALA_DE4", "KALA_DE5",
64
// No. of Cases Reported - (1-5) Male, (1-5) Female
65
"KALA_DE6", "KALA_DE7",
67
// No. of Cases Reported - (6-8) Male, (6-8) Female
68
"KALA_DE8", "KALA_DE9",
70
// No. of Cases Reported - (9-14) Male, (9-14) Female
71
"KALA_DE10","KALA_DE11",
73
// No. of Cases Reported - Above 14 Male, Above 14 Female
74
"KALA_DE12","KALA_DE13",
76
// No. of Deaths Reported - (0-1) Male, (0-1) Female
77
"KALA_DE14","KALA_DE15",
79
// No. of Deaths Reported - (1-5) Male, (1-5) Female
80
"KALA_DE16","KALA_DE17",
82
// No. of Deaths Reported - (6-8) Male, (6-8) Female
83
"KALA_DE18","KALA_DE19",
85
// No. of Deaths Reported - (9-14) Male, (9-14) Female
86
"KALA_DE20","KALA_DE21",
88
// No. of Deaths Reported - Above 14 Male, Above 14 Female
89
"KALA_DE22","KALA_DE23"
92
List childOrgUnitIDs = new ArrayList();
93
List childOrgUnitNames = new ArrayList();
95
int childOrgUnitCount = 0;
98
int totPopulation = 0;
100
int tempval[] = new int[monthlyDataElements.length+5];
101
int total[] = new int[monthlyDataElements.length+5];
107
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
108
con = DriverManager.getConnection (urlForConnection, userName, password);
110
st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
111
st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
112
st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
113
st4=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
115
//rs1 = st1.executeQuery("SELECT organisationunit.shortname FROM organisationunit WHERE id = "+selectedOrgUnitID);
116
rs1 = st1.executeQuery("SELECT organisationunit.shortname FROM organisationunit WHERE organisationunitid = "+selectedOrgUnitID);
117
if(rs1.next()) { selectedOrgUnitName = rs1.getString(1); }
118
else { selectedOrgUnitName = ""; }
120
// rs2 = st2.executeQuery("select startDate from period where id = "+selectedDataPeriodID);
121
// if(rs2.next()) { selectedDataPeriodStartDate = rs2.getDate(1).toString(); }
123
selectedDataPeriodStartDate = startingDate;
125
//rs3 = st3.executeQuery("select id,shortname from organisationunit where parent = "+selectedOrgUnitID);
126
rs3 = st3.executeQuery("select organisationunitid,shortname from organisationunit where parentid = "+selectedOrgUnitID);
129
Integer tempInt = new Integer(rs3.getInt(1));
130
childOrgUnitIDs.add(childOrgUnitCount,tempInt);
131
childOrgUnitNames.add(childOrgUnitCount,rs3.getString(2));
136
catch(Exception e) { out.println(e.getMessage()); }
138
String partsOfDataPeriodStartDate[] = selectedDataPeriodStartDate.split("-");
139
int lastYear = Integer.parseInt(partsOfDataPeriodStartDate[0]) - 1;
140
String lastDataPeriodStartDate = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
142
int tempForMonth1 = Integer.parseInt(partsOfDataPeriodStartDate[1]);
145
if(tempForMonth1 < 4) { tempForYear = lastYear; }
146
else { tempForYear = lastYear + 1; }
148
String tempForMonth2 = "";
149
if(tempForMonth1-1 ==0) tempForMonth2 = "-"+(tempForMonth1-1)+"-01";
150
else if(tempForMonth1-1 <= 9) {tempForMonth2 = "-0"+(tempForMonth1-1)+"-01";}
151
else tempForMonth2 = "-"+(tempForMonth1-1)+"-01";
153
String curYearStart = tempForYear+"-04-01";
154
String lastYearStart = (tempForYear-1)+"-04-01";
155
String lastYearEnd = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
156
String curYearEnd = ""+partsOfDataPeriodStartDate[0]+""+tempForMonth2;
165
<TITLE>Monthly Report on Kala-Azar</TITLE>
168
<P align="center"><FONT face="Arial" size="3"><b><u>Monthly Report on Kala-Azar</u></font></b><br></p>
170
<table cellpadding="0" cellspacing="0" bgcolor="ffffff" align="center" style="border-style:solid; border-width:0; border-collapse: collapse; padding: 0; position:relative; top:10" bordercolor="#ffffff" width="100%" border="0">
171
<tr style="border-collapse: collapse; border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; padding: 0" bordercolor="#111111" width="100%">
172
<td width="50%" style="border-collapse: collapse; border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; padding-left:15; padding-right:0; padding-top:0; padding-bottom:0" bordercolor="#111111" height="23">
173
<font face="Arial" size="3"><b>PHC : <%=selectedOrgUnitName%></b></font>
175
<td width="50%" align="right" style="border-collapse: collapse; border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; padding-left:15; padding-right:0; padding-top:0; padding-bottom:0" bordercolor="#111111" height="23">
176
<font face="Arial" size="2"><b>Month : <%=monthNames[Integer.parseInt(partsOfDataPeriodStartDate[1])]%> - <%=partsOfDataPeriodStartDate[0]%> </b></font>
188
while(count < childOrgUnitCount)
192
if(count != 0) {%></table><div align="right"><font face="Arial" size="1"><i>(page contd.)</i></font></div> <br><%}%>
194
<TABLE style="BORDER-COLLAPSE: collapse" borderColor=#111111 cellSpacing=3 cellPadding=3 width="100%" border=1>
196
<TD align="center" width="3%" rowSpan=2><b><font face="Arial" size="2">Sl. No.</font></b></TD>
197
<TD align="center" width="23%" rowSpan=2><b><font face="Arial" size="2">PHC</font></b></TD>
198
<TD align="center" width="4%" rowspan="2"><b><font face="Arial" size="1">Total Population</font></b></TD>
199
<TD align="center" width="6%" colspan="2"><b><font face="Arial" size="1">Report up to previous month</font></b></TD>
200
<TD align="center" width="6%" colspan="2"><b><font face="Arial" size="1">During the month</font></b></TD>
201
<TD align="center" width="6%" colspan="2"><b><font face="Arial" size="1">Progressive Total</font></b></TD>
202
<TD align="center" width="26%" colspan="12"><b><font face="Arial" size="2">No. of Cases reported</font></b></TD>
203
<TD align="center" width="26%" colspan="12"><b><font face="Arial" size="2">No. of Deaths reported</font></b></TD>
206
<TD align="center" width="3%"><b><font face="Arial" size="1">Cases</font></b></TD>
207
<TD align="center" width="3%"><b><font face="Arial" size="1">Deaths</font></b></TD>
208
<TD align="center" width="3%"><b><font face="Arial" size="1">Cases</font></b></TD>
209
<TD align="center" width="3%"><b><font face="Arial" size="1">Deaths</font></b></TD>
210
<TD align="center" width="3%"><b><font face="Arial" size="1">Cases</font></b></TD>
211
<TD align="center" width="3%"><b><font face="Arial" size="1">Deaths</font></b></TD>
212
<TD align="center" width="4%" colspan="2"><b><font face="Arial" size="1">0-1</font></b></TD>
213
<TD align="center" width="4%" colspan="2"><b><font face="Arial" size="1">1-5</font></b></TD>
214
<TD align="center" width="4%" colspan="2"><b><font face="Arial" size="1">6-8</font></b></TD>
215
<TD align="center" width="4%" colspan="2"><b><font face="Arial" size="1">9-14</font></b></TD>
216
<TD align="center" width="4%" colspan="2"><b><font face="Arial" size="1">Above 14yrs</font></b></TD>
217
<TD align="center" width="6%" colspan="2"><b><font face="Arial" size="1">Total</font></b></TD>
218
<TD align="center" width="4%" colspan="2"><b><font face="Arial" size="1">0-1</font></b></TD>
219
<TD align="center" width="4%" colspan="2"><b><font face="Arial" size="1">1-5</font></b></TD>
220
<TD align="center" width="4%" colspan="2"><b><font face="Arial" size="1">6-8</font></b></TD>
221
<TD align="center" width="4%" colspan="2"><b><font face="Arial" size="1">9-14</font></b></TD>
222
<TD align="center" width="4%" colspan="2"><b><font face="Arial" size="1">Above 14yrs</font></b></TD>
223
<TD align="center" width="16%" colspan="2"><b><font face="Arial" size="1">Total</font></b></TD>
226
<TD width="3%" HEIGHT="20" align="center"> </TD>
227
<TD width="23%" HEIGHT="20" align="center"> </TD>
228
<TD width="4%" HEIGHT="20" align="center"> </TD>
229
<TD width="3%" HEIGHT="20" align="center"> </TD>
230
<TD width="3%" HEIGHT="20" align="center"> </TD>
231
<TD width="3%" HEIGHT="20" align="center"> </TD>
232
<TD width="3%" HEIGHT="20" align="center"> </TD>
233
<TD width="3%" HEIGHT="20" align="center"> </TD>
234
<TD width="3%" HEIGHT="20" align="center"> </TD>
235
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">M </font></b></TD>
236
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">F</font></b></TD>
237
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">M</font></b></TD>
238
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">F</font></b></TD>
239
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">M</font></b></TD>
240
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">F</font></b></TD>
241
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">M</font></b></TD>
242
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">F</font></b></TD>
243
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">M</font></b></TD>
244
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">F</font></b></TD>
245
<TD width="3%" HEIGHT="20" align="center"><b><font face="Arial" size="2">M</font></b></TD>
246
<TD width="3%" HEIGHT="20" align="center"><b><font face="Arial" size="2">F</font></b></TD>
247
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">M</font></b></TD>
248
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">F</font></b></TD>
249
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">M</font></b></TD>
250
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">F</font></b></TD>
251
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">M</font></b></TD>
252
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">F</font></b></TD>
253
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">M</font></b></TD>
254
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">F</font></b></TD>
255
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">M</font></b></TD>
256
<TD width="2%" HEIGHT="20" align="center"><b><font face="Arial" size="2">F</font></b></TD>
257
<TD width="3%" HEIGHT="20" align="center"><b><font face="Arial" size="2">M</font></b></TD>
258
<TD width="3%" HEIGHT="20" align="center"><b><font face="Arial" size="2">F</font></b></TD>
262
Integer temp1 = (Integer) childOrgUnitIDs.get(count);
263
int currentChildID = temp1.intValue();
264
for(i=0;i<monthlyDataElements.length;i++)
268
//query = "SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataElement = dataelement.id WHERE datavalue.period in (select id from period where startdate between '"+curYearStart+"' and '"+curYearEnd+"' and periodType = "+periodTypeID+") AND datavalue.source ="+currentChildID+" AND dataelement.code like '"+monthlyDataElements[i]+"'";
269
query = "SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataelementid = dataelement.dataelementid WHERE datavalue.periodid in (select periodid from period where startdate between '"+curYearStart+"' and '"+curYearEnd+"' and periodtypeid = "+periodTypeID+") AND datavalue.sourceid ="+currentChildID+" AND dataelement.code like '"+monthlyDataElements[i]+"'";
271
//query = "SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataElement = dataelement.id WHERE datavalue.period in (select id from period where startdate between '"+startingDate+"' and '"+startingDate+"') AND datavalue.source ="+currentChildID+" AND dataelement.code like '"+monthlyDataElements[i]+"'";
272
query = "SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataelementid = dataelement.dataelementid WHERE datavalue.periodid in (select periodid from period where startdate between '"+startingDate+"' and '"+startingDate+"') AND datavalue.sourceid ="+currentChildID+" AND dataelement.code like '"+monthlyDataElements[i]+"'";
277
// query = "SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataElement = dataelement.id WHERE datavalue.period in (select id from period where startdate between '"+curYearStart+"' and '"+curYearEnd+"' and periodType = "+periodTypeID+") AND datavalue.source in (select id from organisationunit where parent ="+currentChildID+") AND dataelement.code like '"+monthlyDataElements[i]+"'";
278
// else query = "SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataElement = dataelement.id WHERE datavalue.period ="+selectedDataPeriodID+" AND datavalue.source in (select id from organisationunit where parent ="+currentChildID+") AND dataelement.code like '"+monthlyDataElements[i]+"'";
282
rs4 = st4.executeQuery(query);
283
//"SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataElement = dataelement.id WHERE datavalue.period ="+selectedDataPeriodID+" AND datavalue.source in (select id from organisationunit where parent ="+currentChildID+") AND dataelement.code like '"+monthlyDataElements[i]+"'");
284
//SELECT datavalue.value FROM datavalue INNER JOIN dataelement ON datavalue.dataElement = dataelement.id WHERE datavalue.period="+selectedDataPeriodID+" AND datavalue.source="+currentChildID+" AND dataelement.code like '"+monthlyDataElements[i]+"'");
285
//SELECT sum(datavalue.value) FROM (organisationunit INNER JOIN datavalue ON organisationunit.id = datavalue.source) INNER JOIN period ON datavalue.period = period.id WHERE organisationunit.parent="+selectedOrgUnitID+" AND period.startDate='"+selectedDataPeriodStartDate+"' AND periodType="+periodTypeID+" AND datavalue.dataElement="+dataElementIDs[i])
287
if(!rs4.next()) { tempval[i] = 0; }
288
else { tempval[i] = rs4.getInt(1); }
289
total[i] += tempval[i];
295
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="2"><%=(count+1)%>.</font></TD>
296
<TD width="23%" HEIGHT="20" align="center"><FONT face="Arial" size="2"><%=childOrgUnitNames.get(count)%></font></TD>
297
<TD width="4%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[0]%></font></TD>
298
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[1]%></font></TD>
299
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[2]%></font></TD>
300
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[3]%></font></TD>
301
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[4]%></font></TD>
302
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"></font></TD>
303
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"></font></TD>
304
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[5]%></font></TD>
305
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[6]%></font></TD>
306
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[7]%></font></TD>
307
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[8]%></font></TD>
308
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[9]%></font></TD>
309
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[10]%></font></TD>
310
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[11]%></font></TD>
311
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[12]%></font></TD>
312
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[13]%></font></TD>
313
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[14]%></font></TD>
314
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=(tempval[5]+tempval[7]+tempval[9]+tempval[11]+tempval[13])%></font></TD>
315
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=(tempval[6]+tempval[8]+tempval[10]+tempval[12]+tempval[14])%></font></TD>
316
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[15]%></font></TD>
317
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[16]%></font></TD>
318
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[17]%></font></TD>
319
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[18]%></font></TD>
320
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[19]%></font></TD>
321
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[20]%></font></TD>
322
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[21]%></font></TD>
323
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[22]%></font></TD>
324
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[23]%></font></TD>
325
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=tempval[24]%></font></TD>
326
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=(tempval[15]+tempval[17]+tempval[19]+tempval[21]+tempval[23])%></font></TD>
327
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=(tempval[16]+tempval[18]+tempval[20]+tempval[22]+tempval[24])%></font></TD>
333
catch(Exception e) { out.println(e.getMessage()); }
338
if(rs1!=null) rs1.close(); if(st1!=null) st1.close();
339
if(rs2!=null) rs2.close(); if(st2!=null) st2.close();
340
if(rs3!=null) rs3.close(); if(st3!=null) st3.close();
341
if(rs4!=null) rs4.close(); if(st4!=null) st4.close();
343
if(con!=null) con.close();
345
catch(Exception e) { out.println(e.getMessage()); }
346
} // finally block end
350
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"> </font></TD>
351
<TD width="23%" HEIGHT="20" align="center"><FONT face="Arial" size="2"><b>Total</b></font></TD>
352
<TD width="4%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[0]%></font></TD>
353
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[1]%></font></TD>
354
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[2]%></font></TD>
355
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[3]%></font></TD>
356
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[4]%></font></TD>
357
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"></font></TD>
358
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"></font></TD>
359
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[5]%></font></TD>
360
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[6]%></font></TD>
361
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[7]%></font></TD>
362
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[8]%></font></TD>
363
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[9]%></font></TD>
364
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[10]%></font></TD>
365
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[11]%></font></TD>
366
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[12]%></font></TD>
367
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[13]%></font></TD>
368
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[14]%></font></TD>
369
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=(total[5]+total[7]+total[9]+total[11]+total[13])%></font></TD>
370
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=(total[6]+total[8]+total[10]+total[12]+total[14])%></font></TD>
371
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[15]%></font></TD>
372
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[16]%></font></TD>
373
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[17]%></font></TD>
374
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[18]%></font></TD>
375
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[19]%></font></TD>
376
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[20]%></font></TD>
377
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[21]%></font></TD>
378
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[22]%></font></TD>
379
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[23]%></font></TD>
380
<TD width="2%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=total[24]%></font></TD>
381
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=(total[15]+total[17]+total[19]+total[21]+total[23])%></font></TD>
382
<TD width="3%" HEIGHT="20" align="center"><FONT face="Arial" size="1"><%=(total[16]+total[18]+total[20]+total[22]+total[24])%></font></TD>
b'\\ No newline at end of file'