1
<%@ page import="java.sql.*" %>
2
<%@ page import="com.opensymphony.xwork.util.OgnlValueStack" %>
4
<%@ page session="true"%>
9
// For finding organisationunit name of selected Orgunit based on Orgunit id
13
// For finding start date of selected period based on period id
17
//For finding monthly values
21
//For finding cumulative values
25
//For finding blockphc name and id
29
//For finding taluk name and id
33
//For finding district name and id
37
//For finding state name and id
41
String userName = "dhis";
43
String urlForConnection = "jdbc:mysql://localhost/mp_dhis2";
46
OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
48
String selectedId = (String) stack.findValue( "orgUnitId" );
49
int selectedOrgUnitID = Integer.parseInt( selectedId );
50
// int selectedOrgUnitID = 240;
53
String startingDate = (String) stack.findValue( "startingPeriod" );
54
String endingDate = (String) stack.findValue( "endingPeriod" );
56
// String startingDate = "2007-03-01";
57
// String endingDate = "2007-03-01";
59
String monthlyPeriodId = (String) stack.findValue( "monthlyPeriodTypeId" );
60
int periodTypeID = Integer.parseInt( monthlyPeriodId );
61
//int periodTypeID = 1;
63
String selectedOrgUnitName = "";
64
String selectedDataPeriodStartDate = "";
66
String monthlyDataElements[] = {
69
"Form6_DE5","Form6_DE6","Form6_DE7",
71
// BCG Under 1 Year - Male, Female
72
"Form6_DE44","Form6_DE45",
74
// OPV Under 1 Year - 0,1,2,3 Doses Male, Female
75
"Form6_DE52","Form6_DE53", "Form6_DE54","Form6_DE55", "Form6_DE56","Form6_DE57", "Form6_DE58","Form6_DE59",
77
// DPT Under 1 Year - 1,2,3 Doses Male, Female
78
"Form6_DE46","Form6_DE47", "Form6_DE48","Form6_DE49", "Form6_DE50","Form6_DE51",
80
// Measles Under 1 Year - Male, Female
81
"Form6_DE60","Form6_DE61",
83
// Vitamin A Under 1 Year - Male,Female
86
// OPV Booster Over 1 Year - Male, Female
87
"Form6_DE66","Form6_DE67",
89
// DPT Booster Over 1 Year - Male, Female
90
"Form6_DE64","Form6_DE65",
92
// Vitamin A Over 1 Year - 2,(3-5) Male, Female
93
"Form6_DE80","Form6_DE81", "Form6_DE82","Form6_DE3",
95
// DT - 5 Year Male, Female
96
"Form6_DE70","Form6_DE71",
98
// TT - 10 Year Male, Female
99
"Form6_DE72","Form6_DE73",
101
// TT - 16 Year Male, Female
102
"Form6_DE74","Form6_DE75"
106
int monthlyValues[] = new int[monthlyDataElements.length+5];
107
int cumulativeValues[] = new int[monthlyDataElements.length+5];
115
String TalukName = "";
116
String DistrictName = "";
117
String StateName = "";
126
String monthNames[] = { "", "January", "February", "March", "April", "May", "June", "July", "August", "September",
127
"October", "November", "December" };
134
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
135
con = DriverManager.getConnection (urlForConnection, userName, password);
137
st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
138
st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
139
st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
140
st4=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
141
st5=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
142
st6=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
143
st7=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
144
st8=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
146
//rs1 = st1.executeQuery("select shortname from organisationunit where id = "+selectedOrgUnitID);
147
rs1 = st1.executeQuery("select shortname from organisationunit where organisationunitid = "+selectedOrgUnitID);
148
if(rs1.next()) { selectedOrgUnitName = rs1.getString(1); }
150
// rs2 = st2.executeQuery("select startDate from period where id = "+selectedDataPeriodID);
151
// if(rs2.next()) { selectedDataPeriodStartDate = rs2.getDate(1).toString(); }
153
selectedDataPeriodStartDate = startingDate;
156
//rs7=st7.executeQuery("select organisationunit.id, organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")");
157
rs7=st7.executeQuery("select organisationunit.organisationunitid, organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+selectedOrgUnitID+")");
158
if(rs7.next()) { DistrictID = rs7.getInt(1);DistrictName = rs7.getString(2); }
159
else { DistrictID = 0; DistrictName = ""; }
161
//rs8=st8.executeQuery("select organisationunit.id, organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+DistrictID+")");
162
rs8=st8.executeQuery("select organisationunit.organisationunitid, organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+DistrictID+")");
163
if(rs8.next()) { StateID = rs8.getInt(1);StateName = rs8.getString(2); }
164
else { StateID = 0; StateName = ""; }
167
catch(Exception e) { out.println(e.getMessage()); }
169
String partsOfDataPeriodStartDate[] = selectedDataPeriodStartDate.split("-");
170
int lastYear = Integer.parseInt(partsOfDataPeriodStartDate[0]) - 1;
171
int tempForMonth1 = Integer.parseInt(partsOfDataPeriodStartDate[1]);
173
if(tempForMonth1 < 4){ tempForYear = lastYear; }
174
else { tempForYear = lastYear + 1; }
175
String curYearStart=tempForYear+"-04-01";
179
for(i=0;i<monthlyDataElements.length;i++)
181
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 in (select organisationunitid from organisationunit where parentid in ( select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+")) AND dataelement.code like '"+monthlyDataElements[i]+"'");
182
if(rs3.next()) { monthlyValues[i] = rs3.getInt(1); }
184
rs4 = st4.executeQuery(" select sum(value) from datavalue where dataelementid in (select dataelementid from dataelement where code like '"+monthlyDataElements[i]+"') and sourceid in (select organisationunitid from organisationunit where parentid in ( select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+")) and periodid in (select periodid from period where startdate between '"+curYearStart+"' and '"+selectedDataPeriodStartDate+"' and periodtypeid = "+periodTypeID+")");
185
if(rs4.next()) { cumulativeValues[i] = rs4.getInt(1); }
188
catch(Exception e) { out.println(e.getMessage()); }
193
if(rs1!=null) rs1.close(); if(st1!=null) st1.close();
194
if(rs2!=null) rs2.close(); if(st2!=null) st2.close();
195
if(rs3!=null) rs3.close(); if(st3!=null) st3.close();
196
if(rs4!=null) rs4.close(); if(st4!=null) st4.close();
197
if(rs5!=null) rs5.close(); if(st5!=null) st5.close();
198
if(rs6!=null) rs6.close(); if(st6!=null) st6.close();
199
if(rs7!=null) rs7.close(); if(st7!=null) st7.close();
200
if(rs8!=null) rs8.close(); if(st8!=null) st8.close();
202
if(con!=null) con.close();
204
catch(Exception e) { out.println(e.getMessage()); }
205
} // finally block end
212
<title>UNIVERSAL IMMUNIZATION PROGRAMME</title>
217
<font face="Arial" size="2"><b>UNIVERSAL IMMUNIZATION PROGRAMME</font>
218
<font face="Arial" size="1"><BR> MONTHLY
219
CHC PERFORMANCE REPORT</B></font>
222
<font face="Arial" size="1">
223
224
225
226
227
228
229
230
231
MONTH : <%=monthNames[Integer.parseInt(partsOfDataPeriodStartDate[1])]%> - <%=partsOfDataPeriodStartDate[0]%></font>
233
<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">
235
<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="19">
236
<font face="Arial" size="1">CHC : <%=selectedOrgUnitName%></font>
238
<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="19">
239
<font face="Arial" size="1">District : <%=DistrictName%></font>
243
<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="19">
244
<font face="Arial" size="1">Year target: Infants</font>
246
<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="19">
247
<font face="Arial" size="1">Pregnant Women</font>
251
<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">
252
<font face="Arial" size="1">Number of Sessions: Planned</font>
254
<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">
255
<font face="Arial" size="1">Actually held</font>
259
<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="19">
260
<font face="Arial" size="1"></font>
262
<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="19"></td>
265
<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="19">
266
<font face="Arial" size="1">Number of Sessions where vaccines received at site</font>
268
<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="19"></td>
271
<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="1" colspan="2">
272
<font face="Arial" size="1">Number of Volunteers/ Sahiyya engaged to mobilise children</font>
274
<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="19"> </td>
279
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
281
<td width="40%" align="center" rowspan="2"><font face="Arial" size="1">Number of Sessions for which private vaccinators hired</font></td>
282
<td width="15%" align="center"><font face="Arial" size="1">ANM absent</font></td>
283
<td width="15%" align="center"><font face="Arial" size="1">Underserved areas</font></td>
284
<td width="15%" align="center"><font face="Arial" size="1">Urban slums</font></td>
285
<td width="15%" align="center"><font face="Arial" size="1">Total</font></td>
288
<td width="15%" align="center"><font face="Arial" size="2"> </font></td>
289
<td width="15%" align="center"><font face="Arial" size="2"></font></td>
290
<td width="15%" align="center"><font face="Arial" size="2"></font></td>
291
<td width="15%" align="center"><font face="Arial" size="2"></font></td>
296
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
298
<td width="40%" align="center" rowspan="2"><font face="Arial" size="1">Number of Supervisory visits undertaken by DIO</font></td>
299
<td width="15%" align="center"><font face="Arial" size="1">Block PHC Level</font></td>
300
<td width="15%" align="center"><font face="Arial" size="1">PHC Level</font></td>
301
<td width="15%" align="center"><font face="Arial" size="1">Sub Centre</font></td>
302
<td width="15%" align="center"><font face="Arial" size="1">Session Site</font></td>
305
<td width="15%" align="center"><font face="Arial" size="2"> </font></td>
306
<td width="15%" align="center"><font face="Arial" size="2"></font></td>
307
<td width="15%" align="center"><font face="Arial" size="2"></font></td>
308
<td width="15%" align="center"><font face="Arial" size="2"></font></td>
313
<font face="Arial" size="1"><b>(A) IMMUNISATION AND VIT. A.</b></font>
314
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
316
<td width="10%" align="center" rowspan="4"><font face="Arial" size="1">PREGNANT WOMEN</font></td>
317
<td width="16%" align="center" rowspan="4"><font face="Arial" size="1">TERANUS TOXIOD (TT)</font></td>
318
<td width="10%" align="center"><font face="Arial" size="1">Doses</font></td>
319
<td width="32%" align="center" colspan="4"><font face="Arial" size="1">For the Month</font></td>
320
<td width="32%" align="center" colspan="4"><font face="Arial" size="1">Cumulative</font></td>
323
<td width="10%" align="center"><font face="Arial" size="1">1</font></td>
324
<td width="32%" align="center" colspan="4"><font face="Arial" size="1"><%=monthlyValues[0]%></font> </td>
325
<td width="32%" align="center" colspan="4"><font face="Arial" size="1"><%=cumulativeValues[0]%></font> </td>
328
<td width="10%" align="center"><font face="Arial" size="1">2</font></td>
329
<td width="32%" align="center" colspan="4"><font face="Arial" size="1"><%=monthlyValues[1]%></font> </td>
330
<td width="32%" align="center" colspan="4"><font face="Arial" size="1"><%=cumulativeValues[1]%></font> </td>
333
<td width="10%" align="center"><font face="Arial" size="1">3</font></td>
334
<td width="32%" align="center" colspan="4"><font face="Arial" size="1"><%=monthlyValues[2]%></font> </td>
335
<td width="32%" align="center" colspan="4"><font face="Arial" size="1"><%=cumulativeValues[2]%></font> </td>
338
<td width="10%" align="center" rowspan="24"><font face="Arial" size="1">C<br><br>H<br><br>I<br><br>L<br><br>D<br><br>R<br><br>E<br><br>N</font></td>
339
<td width="15%" align="center" rowspan="3"><font face="Arial" size="1">Vaccines</font></td>
340
<td width="11%" align="center" rowspan="3"><font face="Arial" size="1">Doses</font></td>
341
<td width="32%" align="center" colspan="4"><font face="Arial" size="1">During the month</font></td>
342
<td width="32%" align="center" colspan="4"><font face="Arial" size="1">Cumulative</font></td>
345
<td width="16%" align="center" colspan="2"><font face="Arial" size="1">Under 1 year</font></td>
346
<td width="16%" align="center" colspan="2"><font face="Arial" size="1">Over 1 year</font></td>
347
<td width="16%" align="center" colspan="2"><font face="Arial" size="1">Under 1 year</font></td>
348
<td width="16%" align="center" colspan="2"><font face="Arial" size="1">Over 1 year</font></td>
351
<td width="8%" align="center"><font face="Arial" size="1">Male</font></td>
352
<td width="8%" align="center"><font face="Arial" size="1">Female</font></td>
353
<td width="8%" align="center"><font face="Arial" size="1">Male</font></td>
354
<td width="8%" align="center"><font face="Arial" size="1">Female</font></td>
355
<td width="8%" align="center"><font face="Arial" size="1">Male</font></td>
356
<td width="8%" align="center"><font face="Arial" size="1">Female</font></td>
357
<td width="8%" align="center"><font face="Arial" size="1">Male</font></td>
358
<td width="8%" align="center"><font face="Arial" size="1">Female</font></td>
361
<td width="15%" align="center" ><font face="Arial" size="1">BCG</font></td>
362
<td width="11%" align="center" ><font face="Arial" size="1">1</font></td>
363
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[3]%></font> </td>
364
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[4]%></font> </td>
365
<td width="8%" align="center" > </td>
366
<td width="8%" align="center" > </td>
367
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[3]%></font> </td>
368
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[4]%></font> </td>
369
<td width="8%" align="center" > </td>
370
<td width="8%" align="center" > </td>
373
<td width="15%" align="center" rowspan="4"><font face="Arial" size="1">OPV</font></td>
374
<td width="11%" align="center" ><font face="Arial" size="1">0 dose</font></td>
375
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[5]%></font> </td>
376
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[6]%></font> </td>
377
<td width="8%" align="center" > </td>
378
<td width="8%" align="center" > </td>
379
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[5]%></font> </td>
380
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[6]%></font> </td>
381
<td width="8%" align="center" > </td>
382
<td width="8%" align="center" > </td>
385
<td width="11%" align="center" ><font face="Arial" size="1">1</font></td>
386
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[7]%></font> </td>
387
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[8]%></font> </td>
388
<td width="8%" align="center" > </td>
389
<td width="8%" align="center" > </td>
390
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[7]%></font> </td>
391
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[8]%></font> </td>
392
<td width="8%" align="center" > </td>
393
<td width="8%" align="center" > </td>
396
<td width="11%" align="center" ><font face="Arial" size="1">2</font></td>
397
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[9]%></font> </td>
398
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[10]%></font> </td>
399
<td width="8%" align="center" > </td>
400
<td width="8%" align="center" > </td>
401
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[9]%></font> </td>
402
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[10]%></font> </td>
403
<td width="8%" align="center" > </td>
404
<td width="8%" align="center" > </td>
407
<td width="11%" align="center" ><font face="Arial" size="1">3</font></td>
408
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[11]%></font> </td>
409
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[12]%></font> </td>
410
<td width="8%" align="center" > </td>
411
<td width="8%" align="center" > </td>
412
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[11]%></font> </td>
413
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[12]%></font> </td>
414
<td width="8%" align="center" > </td>
415
<td width="8%" align="center" > </td>
418
<td width="15%" align="center" rowspan="3"><font face="Arial" size="1">DPT</font></td>
419
<td width="11%" align="center" ><font face="Arial" size="1">1</font></td>
420
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[13]%></font> </td>
421
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[14]%></font> </td>
422
<td width="8%" align="center" > </td>
423
<td width="8%" align="center" > </td>
424
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[13]%></font> </td>
425
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[14]%></font> </td>
426
<td width="8%" align="center" > </td>
427
<td width="8%" align="center" > </td>
430
<td width="11%" align="center" ><font face="Arial" size="1">2</font></td>
431
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[15]%></font> </td>
432
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[16]%></font> </td>
433
<td width="8%" align="center" > </td>
434
<td width="8%" align="center" > </td>
435
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[15]%></font> </td>
436
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[16]%></font> </td>
437
<td width="8%" align="center" > </td>
438
<td width="8%" align="center" > </td>
441
<td width="11%" align="center" ><font face="Arial" size="1">3</font></td>
442
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[17]%></font> </td>
443
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[18]%></font> </td>
444
<td width="8%" align="center" > </td>
445
<td width="8%" align="center" > </td>
446
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[17]%></font> </td>
447
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[18]%></font> </td>
448
<td width="8%" align="center" > </td>
449
<td width="8%" align="center" > </td>
452
<td width="15%" align="center" rowspan="3"><font face="Arial" size="1">Hepatitis B (where introduced)</font></td>
453
<td width="11%" align="center" ><font face="Arial" size="1">1</font></td>
454
<td width="8%" align="center" bgcolor="#000000"> </td>
455
<td width="8%" align="center" bgcolor="#000000"> </td>
456
<td width="8%" align="center" bgcolor="#000000"> </td>
457
<td width="8%" align="center" bgcolor="#000000"> </td>
458
<td width="8%" align="center" bgcolor="#000000"> </td>
459
<td width="8%" align="center" bgcolor="#000000"> </td>
460
<td width="8%" align="center" bgcolor="#000000"> </td>
461
<td width="8%" align="center" bgcolor="#000000"> </td>
464
<td width="11%" align="center" ><font face="Arial" size="1">2</font></td>
465
<td width="8%" align="center" bgcolor="#000000"> </td>
466
<td width="8%" align="center" bgcolor="#000000"> </td>
467
<td width="8%" align="center" bgcolor="#000000"> </td>
468
<td width="8%" align="center" bgcolor="#000000"> </td>
469
<td width="8%" align="center" bgcolor="#000000"> </td>
470
<td width="8%" align="center" bgcolor="#000000"> </td>
471
<td width="8%" align="center" bgcolor="#000000"> </td>
472
<td width="8%" align="center" bgcolor="#000000"> </td>
475
<td width="11%" align="center" ><font face="Arial" size="1">3</font></td>
476
<td width="8%" align="center" bgcolor="#000000"> </td>
477
<td width="8%" align="center" bgcolor="#000000"> </td>
478
<td width="8%" align="center" bgcolor="#000000"> </td>
479
<td width="8%" align="center" bgcolor="#000000"> </td>
480
<td width="8%" align="center" bgcolor="#000000"> </td>
481
<td width="8%" align="center" bgcolor="#000000"> </td>
482
<td width="8%" align="center" bgcolor="#000000"> </td>
483
<td width="8%" align="center" bgcolor="#000000"> </td>
486
<td width="15%" align="center" ><font face="Arial" size="1">Measles</font></td>
487
<td width="11%" align="center" ><font face="Arial" size="1">1</font></td>
488
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[19]%></font> </td>
489
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[20]%></font> </td>
490
<td width="8%" align="center" > </td>
491
<td width="8%" align="center" > </td>
492
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[19]%></font> </td>
493
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[20]%></font> </td>
494
<td width="8%" align="center" > </td>
495
<td width="8%" align="center" > </td>
498
<td width="15%" align="center" ><font face="Arial" size="1">Vitamin A</font></td>
499
<td width="11%" align="center" ><font face="Arial" size="1">1</font></td>
500
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[21]%></font> </td>
501
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[22]%></font> </td>
502
<td width="8%" align="center" > </td>
503
<td width="8%" align="center" > </td>
504
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[21]%></font> </td>
505
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[22]%></font> </td>
506
<td width="8%" align="center" > </td>
507
<td width="8%" align="center" > </td>
510
<td width="15%" align="center" ><font face="Arial" size="1">OPV Booster</font></td>
511
<td width="11%" align="center" > </td>
512
<td width="8%" align="center" bgcolor="#000000"> </td>
513
<td width="8%" align="center" bgcolor="#000000"> </td>
514
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[23]%></font> </td>
515
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[24]%></font> </td>
516
<td width="8%" align="center" bgcolor="#000000"> </td>
517
<td width="8%" align="center" bgcolor="#000000"> </td>
518
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[23]%></font> </td>
519
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[24]%></font> </td>
522
<td width="15%" align="center" ><font face="Arial" size="1">DPT Booster</font></td>
523
<td width="11%" align="center" > </td>
524
<td width="8%" align="center" bgcolor="#000000"> </td>
525
<td width="8%" align="center" bgcolor="#000000"> </td>
526
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[25]%></font> </td>
527
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[26]%></font> </td>
528
<td width="8%" align="center" bgcolor="#000000"> </td>
529
<td width="8%" align="center" bgcolor="#000000"> </td>
530
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[25]%></font> </td>
531
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[26]%></font> </td>
534
<td width="15%" align="center" rowspan="3"><font face="Arial" size="1">Vitamin A</font></td>
535
<td width="11%" align="center" ><font face="Arial" size="1">2</font></td>
536
<td width="8%" align="center" bgcolor="#000000"> </td>
537
<td width="8%" align="center" bgcolor="#000000"> </td>
538
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[27]%></font> </td>
539
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[28]%></font> </td>
540
<td width="8%" align="center" bgcolor="#000000"> </td>
541
<td width="8%" align="center" bgcolor="#000000"> </td>
542
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[27]%></font> </td>
543
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[28]%></font> </td>
546
<td width="11%" align="center" ><font face="Arial" size="1">3</font></td>
547
<td width="8%" align="center" bgcolor="#000000"> </td>
548
<td width="8%" align="center" bgcolor="#000000"> </td>
549
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[29]%></font> </td>
550
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[30]%></font> </td>
551
<td width="8%" align="center" bgcolor="#000000"> </td>
552
<td width="8%" align="center" bgcolor="#000000"> </td>
553
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[29]%></font> </td>
554
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[30]%></font> </td>
557
<td width="11%" align="center" ><font face="Arial" size="1">4</font></td>
558
<td width="8%" align="center" bgcolor="#000000"> </td>
559
<td width="8%" align="center" bgcolor="#000000"> </td>
560
<td width="8%" align="center" ><font face="Arial" size="1"></font></td>
561
<td width="8%" align="center" ><font face="Arial" size="1"></font></td>
562
<td width="8%" align="center" bgcolor="#000000"> </td>
563
<td width="8%" align="center" bgcolor="#000000"> </td>
564
<td width="8%" align="center" > </td>
565
<td width="8%" align="center" > </td>
568
<td width="15%" align="center" ><font face="Arial" size="1">DT ( 5 YEAR)</font></td>
569
<td width="11%" align="center" ><font face="Arial" size="1">1</font></td>
570
<td width="8%" align="center" bgcolor="#000000"> </td>
571
<td width="8%" align="center" bgcolor="#000000"> </td>
572
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[31]%></font> </td>
573
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[32]%></font> </td>
574
<td width="8%" align="center" bgcolor="#000000"> </td>
575
<td width="8%" align="center" bgcolor="#000000"> </td>
576
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[31]%></font> </td>
577
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[32]%></font> </td>
580
<td width="15%" align="center" ><font face="Arial" size="1">TT (10 YEAR)</font></td>
581
<td width="11%" align="center" ><font face="Arial" size="1">1</font></td>
582
<td width="8%" align="center" bgcolor="#000000"> </td>
583
<td width="8%" align="center" bgcolor="#000000"> </td>
584
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[33]%></font> </td>
585
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[34]%></font> </td>
586
<td width="8%" align="center" bgcolor="#000000"> </td>
587
<td width="8%" align="center" bgcolor="#000000"> </td>
588
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[33]%></font> </td>
589
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[34]%></font> </td>
592
<td width="15%" align="center" ><font face="Arial" size="1">TT (16 YEAR)</font></td>
593
<td width="11%" align="center" ><font face="Arial" size="1">1</font></td>
594
<td width="8%" align="center" bgcolor="#000000"> </td>
595
<td width="8%" align="center" bgcolor="#000000"> </td>
596
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[35]%></font> </td>
597
<td width="8%" align="center" ><font face="Arial" size="1"><%=monthlyValues[36]%></font> </td>
598
<td width="8%" align="center" bgcolor="#000000"> </td>
599
<td width="8%" align="center" bgcolor="#000000"> </td>
600
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[35]%></font> </td>
601
<td width="8%" align="center" ><font face="Arial" size="1"><%=cumulativeValues[36]%></font> </td>
606
<font face="Arial" size="1"><b>(B) VACCINE SUPPLY (IN DOSES)</b></font>
607
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
609
<td width="15%" align="center" ><font face="Arial" size="1">Vaccine</font></td>
610
<td width="20%" align="center" ><font face="Arial" size="1">Opening Balance</font></td>
611
<td width="21%" align="center" ><font face="Arial" size="1">Received during the month</font></td>
612
<td width="21%" align="center" ><font face="Arial" size="1">Consumed during the month</font></td>
613
<td width="23%" align="center" ><font face="Arial" size="1">Balance at the end of the month</font></td>
616
<td width="15%"><font face="Arial" size="1">DPT</font></td>
617
<td width="20%"> </td>
618
<td width="21%"> </td>
619
<td width="21%"> </td>
620
<td width="23%"> </td>
623
<td width="15%"><font face="Arial" size="1">OPV</font></td>
624
<td width="20%"> </td>
625
<td width="21%"> </td>
626
<td width="21%"> </td>
627
<td width="23%"> </td>
630
<td width="15%"><font face="Arial" size="1">BCG</font></td>
631
<td width="20%"> </td>
632
<td width="21%"> </td>
633
<td width="21%"> </td>
634
<td width="23%"> </td>
637
<td width="15%"><font face="Arial" size="1">MEASLES</font></td>
638
<td width="20%"> </td>
639
<td width="21%"> </td>
640
<td width="21%"> </td>
641
<td width="23%"> </td>
644
<td width="15%"><font face="Arial" size="1">TT</font></td>
645
<td width="20%"> </td>
646
<td width="21%"> </td>
647
<td width="21%"> </td>
648
<td width="23%"> </td>
651
<td width="15%"><font face="Arial" size="1">DT</font></td>
652
<td width="20%"> </td>
653
<td width="21%"> </td>
654
<td width="21%"> </td>
655
<td width="23%"> </td>
b'\\ No newline at end of file'