← Back to branch summary

~mortenoh/+junk/dhis2-detailed-import-export

« back to all changes in this revision

Viewing changes to local/in/dhis-web-reports/src/main/webapp/dhis-web-reports/Kerala/knlep.jsp

  • Committer: larshelge at gmail
  • Date: 2009-03-03 16:46:36 UTC
  • Revision ID: larshelge@gmail.com-20090303164636-2sjlrquo7ib1gf7r
Initial check-in

Show diffs side-by-side

added added

removed removed

Lines of Context:
local/in/dhis-web-reports/src/main/webapp/dhis-web-reports/Kerala/knlep.jsp
 
1
<%@ page import="java.sql.*" %>
 
2
<%@ page import="com.opensymphony.xwork.util.OgnlValueStack" %>
 
3
 
 
4
<%@ page session="true"%>
 
5
 
 
6
<%
 
7
    Connection con=null;
 
8
            
 
9
    // For finding organisationunit name of selected Orgunit based on Orgunit id
 
10
    Statement st1=null;
 
11
    ResultSet rs1=null;
 
12
      
 
13
    // For finding start date of selected period based on period id
 
14
    Statement st2=null;
 
15
    ResultSet rs2=null;
 
16
    
 
17
    //For finding monthly values
 
18
    Statement st3=null;
 
19
    ResultSet rs3=null;
 
20
    
 
21
    //For finding cumulative values
 
22
    Statement st4=null;
 
23
    ResultSet rs4=null;
 
24
    
 
25
    //For finding blockphc name and id 
 
26
    Statement st5=null;
 
27
    ResultSet rs5=null;
 
28
    
 
29
    //For finding taluk name and id
 
30
    Statement st6=null;
 
31
    ResultSet rs6=null;
 
32
    
 
33
    //For finding district name and id
 
34
    Statement st7=null;
 
35
    ResultSet rs7=null;
 
36
    
 
37
    //For finding state name and id
 
38
    Statement st8=null;
 
39
    ResultSet rs8=null;
 
40
    
 
41
    String userName = "dhis";      
 
42
    String password = "";           
 
43
    String urlForConnection = "jdbc:mysql://localhost/kl_dhis2";
 
44
          
 
45
 
 
46
        OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
 
47
 
 
48
        String selectedId = (String) stack.findValue( "orgUnitId" );
 
49
        int selectedOrgUnitID = Integer.parseInt( selectedId );
 
50
        
 
51
  
 
52
          String startingDate  = (String) stack.findValue( "startingPeriod" );
 
53
          String endingDate  = (String) stack.findValue( "endingPeriod" );
 
54
  
 
55
      
 
56
        String monthlyPeriodId = (String) stack.findValue( "monthlyPeriodTypeId" );
 
57
        int periodTypeID = Integer.parseInt( monthlyPeriodId );
 
58
 
 
59
      
 
60
        String selectedOrgUnitName = "";        
 
61
        String selectedDataPeriodStartDate = "";
 
62
                        
 
63
        String monthlyDataElements[] = {
 
64
                                                                                        // No of Leprosy Cases at the begining of the reporting month
 
65
                                                                                        "NLEP_DE1",
 
66
                                                                                        // No of PB new Leprosy Cases detected
 
67
                                                                                        "NLEP_DE2",
 
68
                                                                                        // No of MB new Leprosy Cases detected
 
69
                                                                                        "NLEP_DE3",
 
70
                                                                                        // No of new Leprosy Cases detected in children
 
71
                                                                                        "NLEP_DE4",
 
72
                                                                                        // No of new Leprosy Cases detected in Female
 
73
                                                                                        "NLEP_DE5",
 
74
                                                                                        // No of new Leprosy Cases detected - Visible Deformity
 
75
                                                                                        "NLEP_DE6",
 
76
                                                                                        // No of new Leprosy Cases detected - SC
 
77
                                                                                        "NLEP_DE7",
 
78
                                                                                        // No of new Leprosy Cases detected - ST
 
79
                                                                                        "NLEP_DE8",
 
80
                                                                                        //No of RFT Cases deleted
 
81
                                                                                        "NLEP_DE9",
 
82
                                                                                        //No of Other Cases deleted
 
83
                                                                                        "NLEP_DE10",
 
84
                                                                                        //No of Sub-Centres providing MDT services
 
85
                                                                                        "NLEP_DE11",
 
86
                                                                                        //BLISTER PACK MB(A)1
 
87
                                                                                        "NLEP_DE12",
 
88
                                                                                        //BLISTER PACK MB(A)2
 
89
                                                                                        "NLEP_DE13",
 
90
                                                                                        //BLISTER PACK MB(A)3
 
91
                                                                                        "NLEP_DE14",
 
92
                                                                                        //BLISTER PACK MB(C)1
 
93
                                                                                        "NLEP_DE15",
 
94
                                                                                        //BLISTER PACK MB(C)2
 
95
                                                                                        "NLEP_DE16",
 
96
                                                                                        //BLISTER PACK MB(C)3
 
97
                                                                                        "NLEP_DE17",
 
98
                                                                                        //BLISTER PACK PB(A)1
 
99
                                                                                        "NLEP_DE18",
 
100
                                                                                        //BLISTER PACK PB(A)2
 
101
                                                                                        "NLEP_DE19",
 
102
                                                                                        //BLISTER PACK PB(A)3
 
103
                                                                                        "NLEP_DE20",
 
104
                                                                                        //BLISTER PACK PB(C)1
 
105
                                                                                        "NLEP_DE21",
 
106
                                                                                        //BLISTER PACK PB(C)2
 
107
                                                                                        "NLEP_DE22",
 
108
                                                                                        //BLISTER PACK PB(C)3
 
109
                                                                                        "NLEP_DE23"
 
110
                                                                                };
 
111
                                        
 
112
          int monthlyValues[] = new int[monthlyDataElements.length+5];          
 
113
          int cumulativeValues[] =  new int[monthlyDataElements.length+5];
 
114
          
 
115
          int CHCID=0;
 
116
          int TalukID=0;
 
117
          int DistrictID=0;
 
118
          int StateID=0;
 
119
          
 
120
          String CHCName="";
 
121
          String TalukName = "";
 
122
          String  DistrictName = "";
 
123
          String StateName = "";
 
124
 
 
125
          int j=1;       
 
126
          int i=1;       
 
127
          int k=0;       
 
128
          int endcount = 0;
 
129
          int p = 0;     
 
130
          int q = 0;
 
131
        
 
132
          String monthNames[] = { "", "January", "February", "March", "April", "May", "June", "July", "August", "September",
 
133
                                                                        "October", "November", "December" };    
 
134
%>
 
135
 
 
136
<%
 
137
 
 
138
     try
 
139
      {
 
140
                Class.forName ("com.mysql.jdbc.Driver").newInstance ();
 
141
                con = DriverManager.getConnection (urlForConnection, userName, password);
 
142
        
 
143
                st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
144
                st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
145
                st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
146
                st4=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
147
                st5=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
148
                st6=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
149
                st7=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
150
                st8=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);    
 
151
                
 
152
                //rs1 = st1.executeQuery("select name from organisationunit  where id = "+selectedOrgUnitID);
 
153
                rs1 = st1.executeQuery("select name from organisationunit  where organisationunitid = "+selectedOrgUnitID);        
 
154
                if(rs1.next())        {  selectedOrgUnitName = rs1.getString(1);      }
 
155
                
 
156
  //            rs2 = st2.executeQuery("select startDate from period where id = "+selectedDataPeriodID);
 
157
//              if(rs2.next())    {  selectedDataPeriodStartDate =  rs2.getDate(1).toString();  }                 
 
158
        
 
159
                        selectedDataPeriodStartDate = startingDate;
 
160
        
 
161
                                
 
162
                //rs5=st5.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")");
 
163
                rs5=st5.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+selectedOrgUnitID+")");       
 
164
                if(rs5.next())  { CHCID = rs5.getInt(1);CHCName = rs5.getString(2);  } 
 
165
                else  {  CHCID = 0; CHCName = "";  } 
 
166
 
 
167
                //rs6=st6.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+CHCID+")");
 
168
                rs6=st6.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+CHCID+")");   
 
169
                if(rs6.next())  { TalukID = rs6.getInt(1);TalukName = rs6.getString(2);  } 
 
170
                else  {  TalukID = 0; TalukName = "";  } 
 
171
 
 
172
                //rs7=st7.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+TalukID+")");
 
173
                rs7=st7.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+TalukID+")"); 
 
174
                if(rs7.next())  { DistrictID = rs7.getInt(1);DistrictName = rs7.getString(2);  } 
 
175
                else  {  DistrictID = 0; DistrictName = "";  } 
 
176
 
 
177
                //rs8=st8.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+DistrictID+")");
 
178
                rs8=st8.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+DistrictID+")");      
 
179
                if(rs8.next())  { StateID = rs8.getInt(1);StateName = rs8.getString(2);  } 
 
180
                else  {  StateID = 0; StateName = "";  } 
 
181
 
 
182
      } //try block end
 
183
      catch(Exception e)  { out.println(e.getMessage());  }
 
184
      
 
185
     String partsOfDataPeriodStartDate[] = selectedDataPeriodStartDate.split("-");
 
186
     int lastYear = Integer.parseInt(partsOfDataPeriodStartDate[0]) - 1;
 
187
     int tempForMonth1 = Integer.parseInt(partsOfDataPeriodStartDate[1]);
 
188
     int tempForYear = 0;
 
189
     if(tempForMonth1 < 4){   tempForYear = lastYear;  }
 
190
     else  {   tempForYear = lastYear + 1;      }
 
191
     String curYearStart=tempForYear+"-04-01";
 
192
                
 
193
    try
 
194
     {     
 
195
        for(i=0;i<monthlyDataElements.length;i++)         
 
196
                        {         
 
197
                                //rs3 = st3.executeQuery("SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataElement = dataelement.id INNER JOIN period ON datavalue.period = period.id INNER JOIN organisationunit ON datavalue.source = organisationunit.parent WHERE dataelement.name like '"+monthlyDataElements[i]+"' AND organisationunit.parent="+selectedOrgUnitID+" AND period.id in (select id from period where startdate between '"+startingDate+"' and '"+startingDate+"') ");
 
198
                                rs3 = st3.executeQuery("SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataelementid = dataelement.dataelementid INNER JOIN period ON datavalue.periodid = period.periodid INNER JOIN organisationunit ON datavalue.sourceid = organisationunit.parentid WHERE dataelement.name like '"+monthlyDataElements[i]+"' AND organisationunit.parentid="+selectedOrgUnitID+" AND period.periodid in (select periodid from period where startdate between '"+startingDate+"' and '"+startingDate+"') ");    
 
199
                        if(rs3.next())          {  monthlyValues[i] =  rs3.getInt(1);   }  
 
200
                                        
 
201
                                //rs4 = st4.executeQuery("select sum(value) from datavalue where dataElement in (select id from dataelement where code like '"+monthlyDataElements[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+")");
 
202
                                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 ="+selectedOrgUnitID+") and periodid in (select periodid from period where startdate between '"+curYearStart+"' and '"+selectedDataPeriodStartDate+"' and periodtypeid = "+periodTypeID+")");                                                      
 
203
                        if(rs4.next())                  {       cumulativeValues[i] =  rs4.getInt(1);           }         
 
204
                        }
 
205
        } // try block end
 
206
    catch(Exception e)  { out.println(e.getMessage());  }
 
207
    finally
 
208
       {
 
209
                        try
 
210
                        {
 
211
                                if(rs1!=null)  rs1.close();             if(st1!=null)  st1.close();
 
212
                                if(rs2!=null)  rs2.close();             if(st2!=null)  st2.close();                             
 
213
                                if(rs3!=null)  rs3.close();             if(st3!=null)  st3.close();                             
 
214
                                if(rs4!=null)  rs4.close();             if(st4!=null)  st4.close();
 
215
                                if(rs5!=null)  rs5.close();             if(st5!=null)  st5.close();
 
216
                                if(rs6!=null)  rs6.close();             if(st6!=null)  st6.close();
 
217
                                if(rs7!=null)  rs7.close();             if(st7!=null)  st7.close();
 
218
                                if(rs8!=null)  rs8.close();             if(st8!=null)  st8.close();
 
219
                                
 
220
                                if(con!=null)  con.close(); 
 
221
                        }
 
222
                        catch(Exception e)   {  out.println(e.getMessage());   }
 
223
       } // finally block end   
 
224
       
 
225
  %>
 
226
 
 
227
<html>
 
228
<head>
 
229
        <title>NLEP Monthly Reporting Form</title>
 
230
</head>
 
231
<body>                               
 
232
        <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
233
                <tr><td width="100%" colspan="8" align="center"><font face="Arial" size="3"><b>NLEP Monthly Reporting Form</b></font></td></tr>
 
234
                <tr><td width="100%" colspan="8" align="center"><font face="Arial" size="3"><b>PHC/Block PHC Report</b></font></td></tr>
 
235
                <tr>
 
236
                        <td width="50%" height="25" colspan="3"><font face="Arial" size="2">PHC&nbsp;&nbsp;&nbsp;&nbsp;<%=selectedOrgUnitName%></font></td>
 
237
                        <td width="50%" height="25" colspan="5"><font face="Arial" size="2">Block&nbsp;&nbsp;&nbsp;&nbsp;<%=CHCName%></font></td>
 
238
                </tr>
 
239
                <tr>
 
240
                        <td width="50%" height="25" colspan="3"><font face="Arial" size="2">District&nbsp;&nbsp;&nbsp;&nbsp;<%=DistrictName%></font></td>
 
241
                        <td width="50%" height="25" colspan="5"><font face="Arial" size="2">State&nbsp;&nbsp;&nbsp;&nbsp;<%=StateName%></font></td>
 
242
                </tr>
 
243
                <tr>
 
244
                        <td width="50%" height="25" colspan="3"><font face="Arial" size="2">Reporting Month&nbsp;&nbsp;&nbsp;<%=monthNames[Integer.parseInt(partsOfDataPeriodStartDate[1])]%></font></td>
 
245
                        <td width="50%" height="25" colspan="5"><font face="Arial" size="2">Year&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<%=partsOfDataPeriodStartDate[0]%></font></td>
 
246
                </tr>
 
247
                <tr>
 
248
                        <td width="5%" height="25" ><font face="Arial" size="3">1</font></td>
 
249
                        <td width="55%" height="25" colspan="4"><font face="Arial" size="2">No. of cases at the beginning of the reporting month</font></td>
 
250
                        <td width="25%" height="25" colspan="2">&nbsp;</td>
 
251
                        <td width="15%" height="25"  align="center"><font face="Arial" size="2"><%=monthlyValues[0]%></font></td>
 
252
                </tr>
 
253
                <tr>
 
254
                        <td width="5%" rowspan="3" height="25" ><font face="Arial" size="2">2</font></td>
 
255
                        <td width="55%" rowspan="3" colspan="4" height="25" ><font face="Arial" size="2">Total New Leprosy Cases detected in the reporting month</font></td>
 
256
                        <td width="15%" height="25" >&nbsp;</td>
 
257
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2">During Reporting Month</font></td>
 
258
                        <td width="15%" height="25" ><font face="Arial" size="2">Cumulative from 1st April</font></td>
 
259
                </tr>
 
260
                <tr>
 
261
                        <td width="15%" height="25" ><font face="Arial" size="2">PB-</font></td>
 
262
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2"><%=monthlyValues[1]%></font></td>
 
263
                        <td width="15%" height="25"  align="center" ><font face="Arial" size="2"><%=cumulativeValues[1]%></font></td>
 
264
                </tr>
 
265
                <tr>
 
266
                        <td width="15%" height="25" ><font face="Arial" size="2">MB-</font></td>
 
267
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2"><%=monthlyValues[2]%></font></td>
 
268
                        <td width="15%" height="25"  align="center" ><font face="Arial" size="2"><%=cumulativeValues[2]%></font></td>
 
269
                </tr>
 
270
                <tr>
 
271
                        <td width="5%" height="25" rowspan="5" ><font face="Arial" size="2">3</font></td>
 
272
                                <td width="55%" height="25" rowspan="5" colspan="4"><font face="Arial" size="2">Among the new leprosy cases detected during the reporting month, number of-</font></td>
 
273
                        <td width="15%" height="25" ><font face="Arial" size="2">Children</font></td>
 
274
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2"><%=monthlyValues[3]%></font></td>
 
275
                        <td width="15%" height="25"  align="center" ><font face="Arial" size="2"><%=cumulativeValues[3]%></font></td>
 
276
                </tr>
 
277
                <tr>
 
278
                        <td width="15%" height="25" ><font face="Arial" size="2">Female</font></td>
 
279
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2"><%=monthlyValues[4]%></font></td>
 
280
                        <td width="15%" height="25"  align="center" ><font face="Arial" size="2"><%=cumulativeValues[4]%></font></td>
 
281
                </tr>
 
282
                <tr>
 
283
                        <td width="15%" height="25" ><font face="Arial" size="2">Visible Deformity</font></td>
 
284
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2"><%=monthlyValues[5]%></font></td>
 
285
                        <td width="15%" height="25"  align="center" ><font face="Arial" size="2"><%=cumulativeValues[5]%></font></td>
 
286
                </tr>
 
287
                <tr>
 
288
                        <td width="15%" height="25" ><font face="Arial" size="2">SC</font></td>
 
289
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2"><%=monthlyValues[6]%></font></td>
 
290
                        <td width="15%" height="25"  align="center" ><font face="Arial" size="2"><%=cumulativeValues[6]%></font></td>
 
291
                </tr>
 
292
                <tr>
 
293
                        <td width="15%" height="25" ><font face="Arial" size="2">ST</font></td>
 
294
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2"><%=monthlyValues[7]%></font></td>
 
295
                        <td width="15%" height="25"  align="center" ><font face="Arial" size="2"><%=cumulativeValues[7]%></font></td>
 
296
                </tr>
 
297
                <tr>
 
298
                        <td width="5%" rowspan="2" height="25" ><font face="Arial" size="2">4</font></td>
 
299
                        <td width="55%" height="25" rowspan="2" colspan="4"><font face="Arial" size="2">Number of Cases deleted in the reporting month</font></td>
 
300
                        <td width="15%" height="25" ><font face="Arial" size="2">RFT-</font></td>
 
301
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2"><%=monthlyValues[8]%></font></td>
 
302
                        <td width="15%" height="25"  align="center" ><font face="Arial" size="2"><%=cumulativeValues[8]%></font></td>
 
303
                </tr>
 
304
                <tr>
 
305
                        <td width="15%" height="25" ><font face="Arial" size="2">Others-</font></td>
 
306
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2"><%=monthlyValues[9]%></font></td>
 
307
                        <td width="15%" height="25"  align="center" ><font face="Arial" size="2"><%=cumulativeValues[9]%></font></td>
 
308
                </tr>
 
309
                <tr>
 
310
                        <td width="5%" height="25" ><font face="Arial" size="2">5</font></td>
 
311
                        <td width="55%" height="25" colspan="4"><font face="Arial" size="2">Number of Cases at the end of the reporting month (1+2-4)</font></td>
 
312
                        <td width="25%" height="25" colspan="2" align="center"><font face="Arial" size="2"><%=(monthlyValues[1] + monthlyValues[2] - monthlyValues[4])%>&nbsp;</font></td>
 
313
                        <td width="15%" height="25" align="center"><font face="Arial" size="2"><%=(cumulativeValues[1] + cumulativeValues[2]- cumulativeValues[4])%></font></td>
 
314
                </tr>
 
315
                <tr>
 
316
                        <td width="5%" height="25" ><font face="Arial" size="2">6</font></td>
 
317
                        <td width="55%" height="25" colspan="4"><font face="Arial" size="2">Number of Sub-Centres providing MDT services</font></td>
 
318
                        <td width="25%" height="25" colspan="2" align="center"><%=monthlyValues[11]%>&nbsp;</td>
 
319
                        <td width="15%" height="25" align="center"><font face="Arial" size="2"><%=cumulativeValues[11]%></font></td>
 
320
                </tr>
 
321
                <tr>
 
322
                        <td width="5%" height="25" ><font face="Arial" size="2">7</font></td>
 
323
                        <td width="95%" height="25" colspan="7"><font face="Arial" size="2">Leprosy Drug Stock at the end of the reporting month</font></td>
 
324
                </tr>
 
325
                <tr>
 
326
                        <td width="5%" height="25" >&nbsp;</td>
 
327
                        <td width="20%" height="25" align="center"><font face="Arial" size="2">Blister Pack</font></td>
 
328
                        <td width="25%" height="25" align="center"><font face="Arial" size="2">Quantity</font></td>
 
329
                        <td width="25" height="25"      align="center" colspan="3"><font face="Arial" size="2">Expiry Date</font></td>
 
330
                        <td width="25%" height="25" align="center" colspan="2"><font face="Arial" size="2">Total Stock</font></td>
 
331
                </tr>
 
332
                <tr>
 
333
                        <td width="5%" height="25" rowspan="3" >&nbsp;</td>
 
334
                        <td width="20%" height="25" align="center" rowspan="3" ><font face="Arial" size="2">MB(A)</font></td>
 
335
                        <td width="25%" height="25"     align="center"><%=monthlyValues[12]%></td>
 
336
                        <td width="25" height="25" colspan="3"></td>
 
337
                        <td width="25%" height="25" colspan="2" rowspan="3"align="center"><%=monthlyValues[12] + monthlyValues[13] + monthlyValues[14]%></td>
 
338
                </tr>
 
339
                <tr>
 
340
                        <td width="25%" height="25"     align="center"><%=monthlyValues[13]%></td>
 
341
                        <td width="25" height="25" colspan="3"></td>
 
342
                </tr>
 
343
                <tr>
 
344
                        <td width="25%" height="25"     align="center"><%=monthlyValues[14]%></td>
 
345
                        <td width="25" height="25" colspan="3"></td>
 
346
                </tr>
 
347
                <tr>
 
348
                        <td width="5%" height="25" rowspan="3" >&nbsp;</td>
 
349
                        <td width="20%" height="25" align="center" rowspan="3" ><font face="Arial" size="2">MB(C)</font></td>
 
350
                        <td width="25%" height="25"     align="center"><%=monthlyValues[15]%></td>
 
351
                        <td width="25" height="25" colspan="3"></td>
 
352
                        <td width="25%" height="25" colspan="2" rowspan="3"align="center"><%=(monthlyValues[15] + monthlyValues[16] + monthlyValues[17])%></td>
 
353
                </tr>
 
354
                <tr>
 
355
                        <td width="25%" height="25"     align="center"><%=monthlyValues[16]%></td>
 
356
                        <td width="25" height="25" colspan="3"></td>
 
357
                </tr>
 
358
                <tr>
 
359
                        <td width="25%" height="25"     align="center"><%=monthlyValues[17]%></td>
 
360
                        <td width="25" height="25" colspan="3"></td>
 
361
                </tr>
 
362
                <tr>
 
363
                        <td width="5%" height="25" rowspan="3" >&nbsp;</td>
 
364
                        <td width="20%" height="25" align="center" rowspan="3" ><font face="Arial" size="2">PB(A)</font></td>
 
365
                        <td width="25%" height="25"     align="center"><%=monthlyValues[18]%></td>
 
366
                        <td width="25" height="25" colspan="3"></td>
 
367
                        <td width="25%" height="25" colspan="2" rowspan="3"align="center"><%=(monthlyValues[18] + monthlyValues[19] + monthlyValues[20])%></td>
 
368
                </tr>
 
369
                <tr>
 
370
                        <td width="25%" height="25"     align="center"><%=monthlyValues[19]%></td>
 
371
                        <td width="25" height="25" colspan="3"></td>
 
372
                </tr>
 
373
                <tr>
 
374
                        <td width="25%" height="25"     align="center"><%=monthlyValues[20]%></td>
 
375
                        <td width="25" height="25" colspan="3"></td>
 
376
                </tr>
 
377
                <tr>
 
378
                        <td width="5%" height="25" rowspan="3" >&nbsp;</td>
 
379
                        <td width="20%" height="25" align="center" rowspan="3" ><font face="Arial" size="2">PB(C)</font></td>
 
380
                        <td width="25%" height="25"     align="center"><%=monthlyValues[21]%></td>
 
381
                        <td width="25" height="25" colspan="3"></td>
 
382
                        <td width="25%" height="25" colspan="2" rowspan="3"     align="center"><%=(monthlyValues[21] + monthlyValues[22] + monthlyValues[23])%></td>
 
383
                </tr>
 
384
                <tr>
 
385
                        <td width="25%" height="25"     align="center"><%=monthlyValues[22]%></td>
 
386
                        <td width="25" height="25" colspan="3"></td>
 
387
                </tr>
 
388
                <tr>
 
389
                        <td width="25%" height="25" align="center"><%=monthlyValues[23]%></td>
 
390
                        <td width="25" height="25" colspan="3"  align="center"></td>
 
391
                </tr>
 
392
                <tr>
 
393
                        <td width="100%" height="25" colspan="8"><font face="Arial" size="2">NB: Please calculate Patient-Month Blister 
 
394
                                        Packs for MB(A), MB(C), PB(A) and PB(C) Quarterly in the months of March, June, Sept and Dec and indicate the same in that respective Monthly Report.</font></td>
 
395
                </tr>
 
396
                <tr>
 
397
                        <td width="5%" height="50" ><font face="Arial" size="2">Date</font></td>
 
398
                        <td width="45%" height="50" colspan="3">&nbsp;</td>
 
399
                        <td width="50%" height="50" colspan="4"><font face="Arial" size="2">Name and Signature of Medical Officer</font></td>
 
400
                </tr>
 
401
  </table>                                   
 
402
</body>
 
403
</html>
 
 
b'\\ No newline at end of file'