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
27
String userName = "dhis";
29
String urlForConnection = "jdbc:mysql://localhost/kl_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 = "";
51
String curYearStart="";
54
String monthNames[] = { "", "January", "February", "March", "April", "May", "June", "July", "August", "September","October", "November", "December" };
56
String dataElementCodes[] = {
57
"COMM_DE1","COMM_DE2","COMM_DE3","COMM_DE4","COMM_DE5","COMM_DE6",
58
"COMM_DE7","COMM_DE8","COMM_DE9","COMM_DE10","COMM_DE11","COMM_DE12",
60
"COMM_DE13","COMM_DE14","COMM_DE15","COMM_DE16","COMM_DE17","COMM_DE18",
61
"COMM_DE19","COMM_DE20","COMM_DE21","COMM_DE22","COMM_DE23","COMM_DE24",
63
"COMM_DE25","COMM_DE26","COMM_DE27","COMM_DE28","COMM_DE29","COMM_DE30",
64
"COMM_DE31","COMM_DE32","COMM_DE33","COMM_DE34","COMM_DE35","COMM_DE36",
66
"COMM_DE37","COMM_DE38","COMM_DE39","COMM_DE40","COMM_DE41","COMM_DE42",
67
"COMM_DE43","COMM_DE44","COMM_DE45","COMM_DE46","COMM_DE47","COMM_DE48",
70
"COMM_DE49","COMM_DE50","COMM_DE51","COMM_DE52","COMM_DE53","COMM_DE54",
71
"COMM_DE55","COMM_DE56","COMM_DE57","COMM_DE58","COMM_DE59","COMM_DE60",
73
"COMM_DE61","COMM_DE62","COMM_DE63","COMM_DE64","COMM_DE65","COMM_DE66",
74
"COMM_DE67","COMM_DE68","COMM_DE69","COMM_DE70","COMM_DE71","COMM_DE72",
76
"COMM_DE73","COMM_DE74","COMM_DE75","COMM_DE76","COMM_DE77","COMM_DE78",
77
"COMM_DE79","COMM_DE80","COMM_DE81","COMM_DE82","COMM_DE83","COMM_DE84",
79
"COMM_DE85","COMM_DE86","COMM_DE87","COMM_DE88","COMM_DE89","COMM_DE90",
80
"COMM_DE91","COMM_DE92","COMM_DE93","COMM_DE94","COMM_DE95","COMM_DE96",
83
"COMM_DE97","COMM_DE98","COMM_DE99","COMM_DE100","COMM_DE101","COMM_DE102",
84
"COMM_DE103","COMM_DE104","COMM_DE105","COMM_DE106","COMM_DE107","COMM_DE108",
86
"COMM_DE109","COMM_DE110","COMM_DE111","COMM_DE112","COMM_DE113","COMM_DE114",
87
"COMM_DE115","COMM_DE116","COMM_DE117","COMM_DE118","COMM_DE119","COMM_DE120",
89
"COMM_DE121","COMM_DE122","COMM_DE123","COMM_DE124","COMM_DE125","COMM_DE126",
90
"COMM_DE127","COMM_DE128","COMM_DE129","COMM_DE130","COMM_DE131","COMM_DE132",
92
"COMM_DE133","COMM_DE134","COMM_DE135","COMM_DE136","COMM_DE137","COMM_DE138",
98
int monthlyValues[] = new int[dataElementCodes.length+5];
99
int cumulativeValues[] = new int[dataElementCodes.length+5];
105
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
106
con = DriverManager.getConnection (urlForConnection, userName, password);
108
st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
109
st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
110
st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
111
st4=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
114
//rs1 = st1.executeQuery("SELECT organisationunit.shortname FROM organisationunit WHERE id ="+selectedOrgUnitID);
115
rs1 = st1.executeQuery("SELECT organisationunit.shortname FROM organisationunit WHERE organisationunitid ="+selectedOrgUnitID);
116
if(rs1.next()) { selectedOrgUnitName = rs1.getString(1); }
117
else { selectedOrgUnitName = ""; }
119
// rs2 = st2.executeQuery("select startDate from period where id = "+selectedDataPeriodID);
120
// if(rs2.next()) { selectedDataPeriodStartDate = rs2.getDate(1).toString(); }
122
selectedDataPeriodStartDate = startingDate;
126
catch(Exception e) { out.println(e.getMessage()); }
129
String partsOfDataPeriodStartDate[] = selectedDataPeriodStartDate.split("-");
130
int lastYear = Integer.parseInt(partsOfDataPeriodStartDate[0]) - 1;
131
int tempForMonth1 = Integer.parseInt(partsOfDataPeriodStartDate[1]);
133
if(tempForMonth1 < 4){ tempForYear = lastYear; }
134
else { tempForYear = lastYear + 1; }
135
curYearStart=tempForYear+"-04-01";
139
for(i=0;i<dataElementCodes.length;i++)
141
//rs3 = st3.executeQuery("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 ="+selectedOrgUnitID+" AND dataelement.code like '"+dataElementCodes[i]+"'");
142
rs3 = st3.executeQuery("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 ="+selectedOrgUnitID+" AND dataelement.code like '"+dataElementCodes[i]+"'");
143
if(rs3.next()) {monthlyValues[i] = rs3.getInt(1);}
145
// rs4 = st4.executeQuery("select sum(value) from datavalue where dataElement in (select id from dataelement where code like '"+dataElementCodes[i]+"') and source in (select id from organisationunit where parent ="+selectedOrgUnitID+") and period in (select id from period where startdate between '"+curYearStart+"' and '"+selectedDataPeriodStartDate+"' and periodType = "+periodTypeID+")");
146
// if(rs4.next()) {cumulativeValues[i] = rs4.getInt(1);}
148
// rs4 = st4.executeQuery("select sum(value) from datavalue where dataElement in (select id from dataelement where code like '"+dataElementCodes[i]+"') and source in (select id from organisationunit where parent ="+selectedOrgUnitID+") and period in (select id from period where startdate between '"+curYearStart+"' and '"+selectedDataPeriodStartDate+"' and periodType = "+periodTypeID+")");
149
// if(rs4.next()) { cumulativeValues[i] = rs4.getInt(1); }
156
catch(Exception e) { out.println(e.getMessage()); }
161
if(rs1!=null) rs1.close(); if(st1!=null) st1.close();
162
if(rs2!=null) rs2.close(); if(st2!=null) st2.close();
163
if(rs3!=null) rs3.close(); if(st3!=null) st3.close();
164
if(rs4!=null) rs4.close(); if(st4!=null) st4.close();
167
if(con!=null) con.close();
169
catch(Exception e) { out.println(e.getMessage()); }
170
} // finally block end
180
<title>Communicable Diseases</title>
184
<font face="arial" size=3>Statement showing the OP , IP and death due to the Communicable diseases for the month of<%=monthNames[Integer.parseInt(partsOfDataPeriodStartDate[1])]%> - <%=partsOfDataPeriodStartDate[0]%></font></center><br>
185
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
187
<td width="100%" align="right"><font face="arial" size=3>PHC :<%=selectedOrgUnitName%></font></td>
191
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
193
<td width="40%" rowspan="3" align="center"><font face="arial" size=2>Name of disease</font></td>
194
<td width="30%" colspan="6" align="center"><font face="arial" size=2>Monthly</font></td>
195
<td width="30%" colspan="6" align="center"><font face="arial" size=2>Yearly</font></td>
198
<td width="10%" colspan="2" align="center"><font face="arial" size=2>OP</font></td>
199
<td width="10%" colspan="2" align="center"><font face="arial" size=2>IP</font></td>
200
<td width="10%" colspan="2" align="center"><font face="arial" size=2>Death</font></td>
201
<td width="10%" colspan="2" align="center"><font face="arial" size=2>OP</font></td>
202
<td width="10%" colspan="2" align="center"><font face="arial" size=2>IP</font></td>
203
<td width="10%" colspan="2" align="center"><font face="arial" size=2>Death</font></td>
206
<td width="5%" align="center"><font face="arial" size=2>M</font></td>
207
<td width="5%" align="center"><font face="arial" size=2>F</font></td>
208
<td width="5%" align="center"><font face="arial" size=2>M</font></td>
209
<td width="5%" align="center"><font face="arial" size=2>F</font></td>
210
<td width="5%" align="center"><font face="arial" size=2>M</font></td>
211
<td width="5%" align="center"><font face="arial" size=2>F</font></td>
212
<td width="5%" align="center"><font face="arial" size=2>M</font></td>
213
<td width="5%" align="center"><font face="arial" size=2>F</font></td>
214
<td width="5%" align="center"><font face="arial" size=2>M</font></td>
215
<td width="5%" align="center"><font face="arial" size=2>F</font></td>
216
<td width="5%" align="center"><font face="arial" size=2>M</font></td>
217
<td width="5%" align="center"><font face="arial" size=2>F</font></td>
220
<td width="40%"><font face="arial" size=2>Acute diarrhoea disease</font></td>
221
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[0]%></font> </td>
222
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[1]%></font> </td>
223
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[2]%></font> </td>
224
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[3]%></font> </td>
225
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[4]%></font> </td>
226
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[5]%></font> </td>
227
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[0]%></font> </td>
228
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[1]%> </font></td>
229
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[2]%> </font></td>
230
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[3]%> </font></td>
231
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[4]%> </font></td>
232
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[5]%> </font></td>
235
<td width="40%"><font face="arial" size=2>Acute watery disease</font></td>
236
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[6]%></font> </td>
237
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[7]%></font> </td>
238
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[8]%></font> </td>
239
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[9]%></font> </td>
240
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[10]%></font> </td>
241
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[11]%></font> </td>
242
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[6]%> </font></td>
243
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[7]%> </font></td>
244
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[8]%> </font></td>
245
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[9]%> </font></td>
246
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[10]%> </font></td>
247
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[11]%> </font></td>
250
<td width="40%"><font face="arial" size=2>Cholera</font></td>
251
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[12]%></font> </td>
252
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[13]%></font> </td>
253
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[14]%></font> </td>
254
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[15]%></font> </td>
255
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[16]%></font> </td>
256
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[17]%> </font></td>
257
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[12]%> </font></td>
258
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[13]%> </font></td>
259
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[14]%> </font></td>
260
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[15]%> </font></td>
261
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[16]%> </font></td>
262
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[17]%> </font></td>
265
<td width="40%"><font face="arial" size=2>Dysentry</font></td>
266
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[18]%></font> </td>
267
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[19]%></font> </td>
268
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[20]%></font> </td>
269
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[21]%></font> </td>
270
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[22]%></font> </td>
271
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[23]%></font> </td>
272
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[18]%> </font></td>
273
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[19]%> </font></td>
274
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[20]%> </font></td>
275
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[21]%> </font></td>
276
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[22]%> </font></td>
277
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[23]%> </font></td>
280
<td width="40%"><font face="arial" size=2>Persistal Diarrhoca</font></td>
281
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[24]%></font> </td>
282
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[25]%></font> </td>
283
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[26]%></font> </td>
284
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[27]%></font> </td>
285
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[28]%></font> </td>
286
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[29]%></font> </td>
287
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[24]%> </font></td>
288
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[25]%> </font></td>
289
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[26]%> </font></td>
290
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[27]%> </font></td>
291
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[28]%> </font></td>
292
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[29]%> </font></td>
295
<td width="40%"><font face="arial" size=2>Polio</font></td>
296
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[30]%></font> </td>
297
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[31]%> </font></td>
298
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[32]%> </font></td>
299
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[33]%> </font></td>
300
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[34]%> </font></td>
301
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[35]%> </font></td>
302
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[30]%> </font></td>
303
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[31]%> </font></td>
304
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[32]%> </font></td>
305
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[33]%> </font></td>
306
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[34]%> </font></td>
307
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[35]%> </font></td>
310
<td width="40%" ><font face="arial" size=2>Diphteria</font></td>
311
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[36]%> </font></td>
312
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[37]%> </font></td>
313
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[38]%> </font></td>
314
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[39]%> </font></td>
315
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[40]%> </font></td>
316
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[41]%> </font></td>
317
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[36]%> </font></td>
318
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[37]%> </font></td>
319
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[38]%> </font></td>
320
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[39]%> </font></td>
321
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[40]%> </font></td>
322
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[41]%> </font></td>
325
<td width="40%"><font face="arial" size=2>Tetanus</font></td>
326
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[42]%> </font></td>
327
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[43]%> </font></td>
328
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[44]%> </font></td>
329
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[45]%> </font></td>
330
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[46]%> </font></td>
331
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[47]%> </font></td>
332
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[42]%> </font></td>
333
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[43]%> </font></td>
334
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[44]%> </font></td>
335
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[45]%> </font></td>
336
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[46]%> </font></td>
337
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[47]%> </font></td>
340
<td width="40%"><font face="arial" size=2>Woophing Cough</font></td>
341
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[48]%> </font></td>
342
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[49]%> </font></td>
343
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[50]%> </font></td>
344
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[51]%> </font></td>
345
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[52]%> </font></td>
346
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[53]%> </font></td>
347
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[48]%> </font></td>
348
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[49]%> </font></td>
349
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[50]%> </font></td>
350
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[51]%> </font></td>
351
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[52]%> </font></td>
352
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[53]%> </font></td>
355
<td width="40%"><font face="arial" size=2>Measles</font></td>
356
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[54]%> </font></td>
357
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[55]%> </font></td>
358
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[56]%> </font></td>
359
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[57]%> </font></td>
360
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[58]%> </font></td>
361
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[59]%> </font></td>
362
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[54]%> </font></td>
363
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[55]%> </font></td>
364
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[56]%> </font></td>
365
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[57]%> </font></td>
366
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[58]%> </font></td>
367
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[59]%> </font></td>
370
<td width="40%"><font face="arial" size=2>Chicken pox</font></td>
371
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[60]%> </font></td>
372
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[61]%> </font></td>
373
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[62]%> </font></td>
374
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[63]%> </font></td>
375
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[64]%> </font></td>
376
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[65]%> </font></td>
377
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[60]%> </font></td>
378
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[61]%> </font></td>
379
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[62]%> </font></td>
380
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[63]%> </font></td>
381
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[64]%> </font></td>
382
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[65]%> </font></td>
385
<td width="40%"><font face="arial" size=2>Respiratory Infection</font></td>
386
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[66]%> </font></td>
387
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[67]%> </font></td>
388
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[68]%> </font></td>
389
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[69]%> </font></td>
390
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[70]%> </font></td>
391
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[71]%> </font></td>
392
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[66]%> </font></td>
393
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[67]%> </font></td>
394
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[68]%> </font></td>
395
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[69]%> </font></td>
396
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[70]%> </font></td>
397
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[71]%> </font></td>
400
<td width="40%"><font face="arial" size=2>Pnemonia</font></td>
401
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[72]%> </font></td>
402
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[73]%> </font></td>
403
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[74]%> </font></td>
404
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[75]%> </font></td>
405
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[76]%> </font></td>
406
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[77]%> </font></td>
407
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[72]%> </font></td>
408
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[73]%> </font></td>
409
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[74]%> </font></td>
410
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[75]%> </font></td>
411
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[76]%> </font></td>
412
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[77]%> </font></td>
415
<td width="40%"><font face="arial" size=2>Typhoid</font></td>
416
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[78]%> </font></td>
417
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[79]%> </font></td>
418
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[80]%> </font></td>
419
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[81]%> </font></td>
420
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[82]%> </font></td>
421
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[83]%> </font></td>
422
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[78]%> </font></td>
423
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[79]%> </font></td>
424
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[80]%> </font></td>
425
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[81]%> </font></td>
426
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[82]%> </font></td>
427
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[83]%> </font></td>
430
<td width="40%"><font face="arial" size=2>Dengue Fever</font></td>
431
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[84]%> </font></td>
432
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[85]%> </font></td>
433
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[86]%> </font></td>
434
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[87]%> </font></td>
435
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[88]%> </font></td>
436
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[89]%> </font></td>
437
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[84]%> </font></td>
438
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[85]%> </font></td>
439
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[86]%> </font></td>
440
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[87]%> </font></td>
441
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[88]%> </font></td>
442
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[89]%> </font></td>
445
<td width="40%"><font face="arial" size=2>Hepatitis A</font></td>
446
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[90]%> </font></td>
447
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[91]%> </font></td>
448
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[92]%> </font></td>
449
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[93]%> </font></td>
450
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[94]%> </font></td>
451
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[95]%> </font></td>
452
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[90]%> </font></td>
453
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[91]%> </font></td>
454
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[92]%> </font></td>
455
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[93]%> </font></td>
456
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[94]%> </font></td>
457
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[95]%> </font></td>
460
<td width="40%"><font face="arial" size=2>Hepatitis B</font></td>
461
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[96]%> </font></td>
462
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[97]%> </font></td>
463
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[98]%> </font></td>
464
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[99]%> </font></td>
465
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[100]%> </font></td>
466
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[101]%> </font></td>
467
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[96]%> </font></td>
468
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[97]%> </font></td>
469
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[98]%> </font></td>
470
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[99]%> </font></td>
471
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[100]%> </font></td>
472
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[101]%> </font></td>
475
<td width="40%"><font face="arial" size=2>J.E</font></td>
476
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[102]%> </font></td>
477
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[103]%> </font></td>
478
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[104]%> </font></td>
479
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[105]%> </font></td>
480
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[106]%> </font></td>
481
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[107]%> </font></td>
482
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[102]%> </font></td>
483
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[103]%> </font></td>
484
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[104]%> </font></td>
485
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[105]%> </font></td>
486
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[106]%> </font></td>
487
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[107]%> </font></td>
490
<td width="40%"><font face="arial" size=2>Mumps</font></td>
491
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[108]%> </font></td>
492
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[109]%> </font></td>
493
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[110]%> </font></td>
494
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[111]%> </font></td>
495
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[112]%> </font></td>
496
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[113]%> </font></td>
497
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[108]%> </font></td>
498
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[109]%> </font></td>
499
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[110]%> </font></td>
500
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[111]%> </font></td>
501
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[112]%> </font></td>
502
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[113]%> </font></td>
505
<td width="40%"><font face="arial" size=2>Filaria</font></td>
506
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[114]%> </font></td>
507
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[115]%> </font></td>
508
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[116]%> </font></td>
509
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[117]%> </font></td>
510
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[118]%> </font></td>
511
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[119]%> </font></td>
512
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[114]%> </font></td>
513
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[115]%> </font></td>
514
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[116]%> </font></td>
515
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[117]%> </font></td>
516
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[118]%> </font></td>
517
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[119]%> </font></td>
520
<td width="40%"><font face="arial" size=2>TB</font></td>
521
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[120]%> </font></td>
522
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[121]%> </font></td>
523
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[122]%> </font></td>
524
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[123]%> </font></td>
525
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[124]%> </font></td>
526
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[125]%> </font></td>
527
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[120]%> </font></td>
528
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[121]%> </font></td>
529
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[122]%> </font></td>
530
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[123]%> </font></td>
531
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[124]%> </font></td>
532
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[125]%> </font></td>
535
<td width="40%"><font face="arial" size=2>Malaria</font></td>
536
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[126]%> </font></td>
537
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[127]%> </font></td>
538
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[128]%> </font></td>
539
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[129]%> </font></td>
540
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[130]%> </font></td>
541
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[131]%> </font></td>
542
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[126]%> </font></td>
543
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[127]%> </font></td>
544
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[128]%> </font></td>
545
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[129]%> </font></td>
546
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[130]%> </font></td>
547
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[131]%> </font></td>
550
<td width="40%"><font face="arial" size=2>All other Disease</font></td>
551
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[132]%> </font></td>
552
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[133]%> </font></td>
553
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[134]%> </font></td>
554
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[135]%> </font></td>
555
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[136]%> </font></td>
556
<td width="5%" align="center"><font face="arial" size=2><%=monthlyValues[137]%> </font></td>
557
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[132]%> </font></td>
558
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[133]%> </font></td>
559
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[134]%> </font></td>
560
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[135]%> </font></td>
561
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[136]%> </font></td>
562
<td width="5%" align="center"><font face="arial" size=2><%=cumulativeValues[137]%> </font></td>
565
<td width="40%"><font face="arial" size=2>TOTAL</font></td>
566
<td width="5%" align="center"><font face="arial" size=2> </font></td>
567
<td width="5%" align="center"><font face="arial" size=2> </font></td>
568
<td width="5%" align="center"><font face="arial" size=2> </font></td>
569
<td width="5%" align="center"><font face="arial" size=2> </font></td>
570
<td width="5%" align="center"><font face="arial" size=2> </font></td>
571
<td width="5%" align="center"><font face="arial" size=2> </font></td>
572
<td width="5%" align="center"><font face="arial" size=2> </font></td>
573
<td width="5%" align="center"><font face="arial" size=2> </font></td>
574
<td width="5%" align="center"><font face="arial" size=2> </font></td>
575
<td width="5%" align="center"><font face="arial" size=2> </font></td>
576
<td width="5%" align="center"><font face="arial" size=2> </font></td>
577
<td width="5%" align="center"><font face="arial" size=2> </font></td>
b'\\ No newline at end of file'