← 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/kiec.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/kiec.jsp
 
1
<%@ page import="java.sql.*" %>
 
2
<%@ page import="com.opensymphony.xwork.util.OgnlValueStack" %>
 
3
 
 
4
<%
 
5
      Connection con=null;
 
6
            
 
7
      // for selected OrgUnit Name
 
8
      Statement st1 = null;
 
9
      ResultSet rs1 = null;
 
10
      
 
11
      // for Data Period Start Date and End Date
 
12
      Statement st2 = null;
 
13
      ResultSet rs2 = null;
 
14
      
 
15
      //for no. of acceptors during the month
 
16
      Statement st3 = null;
 
17
      ResultSet rs3 = null;
 
18
 
 
19
      //for no. of acceptors during year
 
20
      Statement st4 = null;
 
21
      ResultSet rs4 = null;
 
22
      
 
23
      Statement st5 = null;
 
24
      ResultSet rs5 = null;
 
25
      
 
26
      Statement st6 = null;
 
27
      ResultSet rs6 = null;
 
28
      
 
29
      Statement st7 = null;
 
30
      ResultSet rs7 = null;
 
31
      
 
32
      Statement st8 = null;
 
33
      ResultSet rs8 = null;
 
34
      
 
35
 
 
36
      
 
37
      String userName = "dhis";           
 
38
      String password = "";           
 
39
      String urlForConnection = "jdbc:mysql://localhost/kl_dhis2";
 
40
          
 
41
          OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
 
42
          String selectedId = (String) stack.findValue( "orgUnitId" );
 
43
          int selectedOrgUnitID =         Integer.parseInt( selectedId );
 
44
        
 
45
//        String selectedPeriodId = (String) stack.findValue( "periodSelect" );
 
46
//        int selectedDataPeriodID =      Integer.parseInt( selectedPeriodId );
 
47
      
 
48
          String monthlyPeriodId = (String) stack.findValue( "monthlyPeriodTypeId" );
 
49
          int periodTypeID =      Integer.parseInt( monthlyPeriodId );
 
50
 
 
51
          String startingDate  = (String) stack.findValue( "startingPeriod" );
 
52
          String endingDate  = (String) stack.findValue( "endingPeriod" );
 
53
 
 
54
               
 
55
      int lastYear = 0;
 
56
      int i = 0;
 
57
      
 
58
          String selectedOrgUnitName = "";
 
59
          String selectedDataPeriodStartDate = "";
 
60
      String selectedDataPeriodEndDate = "";
 
61
      
 
62
      int PHCID = 0;
 
63
      int CHCID =0;
 
64
      int talukID=0;
 
65
      int districtID=0;
 
66
      
 
67
      String PHCName=" ";
 
68
      String CHCName =" ";
 
69
      String talukName=" "; 
 
70
      String districtName =" ";
 
71
      
 
72
          String dataElementCodes[] = {
 
73
                                                                        "IEC_DE1",
 
74
                                                                        "IEC_DE2",
 
75
                                                                        "IEC_DE3",
 
76
                                                                        "IEC_DE4",
 
77
                                                                        "IEC_DE5",
 
78
                                                                        "IEC_DE6",
 
79
                                                                        "IEC_DE7",
 
80
                                                                        "IEC_DE8",
 
81
                                                                        "IEC_DE9",
 
82
                                                                        "IEC_DE10",
 
83
                                                                        "IEC_DE11",
 
84
                                                                        "IEC_DE12",
 
85
                                                                        "IEC_DE13",
 
86
                                                                        "IEC_DE14",
 
87
                                                                        "Form6_DE1",
 
88
                                                                        "IEC_DE15",
 
89
                                                                        "IEC_DE16 ",
 
90
                                                                        "IEC_DE17",
 
91
                                                                        "IEC_DE18",
 
92
                                                                        "IEC_DE19",
 
93
                                                                        "IEC_DE20",
 
94
                                                                        "IEC_DE21",
 
95
                                                                        "IEC_DE22",
 
96
                                                                        "IEC_DE23",
 
97
                                                                        "IEC_DE24",
 
98
                                                                        "IEC_DE25"
 
99
                                                                  };     
 
100
          int monthlyDataValues[] = new int[dataElementCodes.length];
 
101
          int yearlyDataValues[]  = new int[dataElementCodes.length];
 
102
%>
 
103
 
 
104
<%
 
105
     try
 
106
      {
 
107
        Class.forName ("com.mysql.jdbc.Driver").newInstance ();
 
108
        con = DriverManager.getConnection (urlForConnection, userName, password);
 
109
        
 
110
        st1 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
111
        st2 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
112
        st3 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
113
        st4 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
114
        st5 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
115
        st6 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
116
        st7 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
117
        st8 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
118
 
 
119
        //rs1 = st1.executeQuery("SELECT organisationunit.name FROM organisationunit where organisationunit.id ="+selectedOrgUnitID);
 
120
        rs1 = st1.executeQuery("SELECT organisationunit.name FROM organisationunit where organisationunit.organisationunitid ="+selectedOrgUnitID);        
 
121
        if(rs1.next())  { selectedOrgUnitName = rs1.getString(1);       }
 
122
        else   {  selectedOrgUnitName = "";  }  
 
123
 
 
124
//        rs2 = st2.executeQuery("select startDate,endDate from period where id = "+selectedDataPeriodID);
 
125
//          if(rs2.next())
 
126
//                {
 
127
//                  selectedDataPeriodStartDate =  rs2.getDate(1).toString();
 
128
//                      selectedDataPeriodEndDate   =  rs2.getDate(2).toString();
 
129
//                }
 
130
 
 
131
                selectedDataPeriodStartDate = startingDate;
 
132
 
 
133
                String partsOfDataPeriodStartDate[]  =  selectedDataPeriodStartDate.split("-");
 
134
        lastYear  = Integer.parseInt(partsOfDataPeriodStartDate[0]) - 1;        
 
135
                int tempForMonth1 = Integer.parseInt(partsOfDataPeriodStartDate[1]);
 
136
                int tempForYear = 0;            
 
137
        if(tempForMonth1 < 4)           {   tempForYear = lastYear;  }
 
138
                else  {   tempForYear = lastYear + 1;           }        
 
139
                String curYearStart = tempForYear+"-04-01";
 
140
 
 
141
                        //rs3=st3.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 '"+startingDate+"' and '"+startingDate+"') ");
 
142
                        rs3=st3.executeQuery("SELECT sum(value) FROM datavalue WHERE dataelementid in (select dataelementid from dataelement where code like '"+dataElementCodes[i]+"') and sourceid in (select organisationunitid from organisationunit where parentid ="+selectedOrgUnitID+")  and periodid in (select periodid from period where startdate between '"+startingDate+"' and '"+startingDate+"') ");
 
143
                if(rs3.next())  { monthlyDataValues[i] = rs3.getInt(1);   } 
 
144
 
 
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
                        rs4=st4.executeQuery("SELECT sum(value) FROM datavalue WHERE dataelementid in (select dataelementid from dataelement where code like '"+dataElementCodes[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+")");
 
147
                if(rs4.next())  { yearlyDataValues[i] = rs4.getInt(1);   } 
 
148
                
 
149
                 //for district, taluk, CHC names
 
150
    
 
151
               
 
152
                        //rs8=st8.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")");
 
153
                        rs8=st8.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+selectedOrgUnitID+")");       
 
154
                        if(rs8.next())  { CHCID = rs8.getInt(1);CHCName = rs8.getString(2);  } 
 
155
                        else  {  CHCID = 0; CHCName = "";  } 
 
156
 
 
157
                        //rs5=st5.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+CHCID+")");
 
158
                        rs5=st5.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+CHCID+")");   
 
159
                        if(rs5.next())  { talukID = rs5.getInt(1); talukName = rs5.getString(2);  } 
 
160
                        else  {  talukID = 0; talukName = "";  } 
 
161
        
 
162
                    //rs6=st6.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+talukID+")");
 
163
                    rs6=st6.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+talukID+")"); 
 
164
                    if(rs6.next()) {  districtID = rs6.getInt(1); districtName = rs6.getString(2);}
 
165
                        else {districtID = 0; districtName = "";}               
 
166
          } // try block end
 
167
     catch(Exception e)  { out.println(e.getMessage());  }
 
168
     finally
 
169
       {
 
170
                        try
 
171
                                {
 
172
                                        if(rs1!=null)  rs1.close();                     if(st1!=null)  st1.close();
 
173
                                        if(rs2!=null)  rs2.close();                     if(st2!=null)  st2.close();
 
174
                                        if(rs3!=null)  rs3.close();                     if(st3!=null)  st3.close();
 
175
                                        if(rs4!=null)  rs4.close();                     if(st4!=null)  st4.close();
 
176
                                        if(rs5!=null)  rs5.close();                     if(st5!=null)  st5.close();                     
 
177
                    if(rs6!=null)  rs6.close();                 if(st6!=null)  st6.close();
 
178
                    if(rs7!=null)  rs7.close();                 if(st7!=null)  st7.close();
 
179
                                        if(rs8!=null)  rs8.close();                     if(st8!=null)  st8.close();
 
180
                                                                                
 
181
                                        if(con!=null) con.close();
 
182
                                }
 
183
                        catch(Exception e)   {  out.println(e.getMessage());   }
 
184
       } // finally block end                           
 
185
%>
 
186
 
 
187
 
 
188
 
 
189
 
 
190
<html>
 
191
 
 
192
        <head>
 
193
        <title>IEC REPORT</title>
 
194
        </head>
 
195
                <body>
 
196
<center>
 
197
<b>
 
198
<font face="arial" size=3>IEC REPORT</font><br><br>
 
199
 
 
200
</center>
 
201
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
 
202
  <tr>
 
203
    <td width="50%" ><font face="arial" size=2>Dist :<%=districtName%> </font></td>
 
204
    <td width="50%" align="right"><font face="arial" size=2> PHC :<%=selectedOrgUnitName%></font></td>
 
205
  </tr>
 
206
</table><br><br>
 
207
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
 
208
  <tr>
 
209
    <td width="5%"      align="center"><font face="arial" size=2>Sl.No</font></td>
 
210
    <td width="75%"     align="center"><font face="arial" size=2>Activities</font></td>
 
211
    <td width="10%"     align="center"><font face="arial" size=2>During the Month</font></td>
 
212
    <td width="10%"     align="center"><font face="arial" size=2>During the Year</font></td>
 
213
  </tr>
 
214
  <tr>
 
215
    <td width="5%"      align="center"><font face="arial" size=2>&nbsp;1</font></td>
 
216
    <td width="75%"     ><font face="arial" size="2">No.of M.S.S functioning</font></td>
 
217
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[0]%></font>&nbsp;</td>
 
218
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[0]%></font>&nbsp;</td>
 
219
  </tr>
 
220
  <tr>
 
221
   <td width="5%"       align="center"><font face="arial" size=2>&nbsp;2</font></td>
 
222
    <td width="75%"     ><font face="arial" size="2">No.of M.S.S discontinued</font></td>
 
223
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[1]%></font>&nbsp;</td>
 
224
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[1]%></font>&nbsp;</td>
 
225
  </tr>
 
226
  <tr>
 
227
   <td width="5%"       align="center"><font face="arial" size="2">&nbsp;3</font></td>
 
228
    <td width="75%"     ><font face="arial" size="2">No.of M.S.S continued</font></td>
 
229
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[0]- monthlyDataValues[1]%></font>&nbsp;</td>
 
230
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[0]- yearlyDataValues[1]%></font>&nbsp;</td>
 
231
  </tr>
 
232
  <tr>
 
233
    <td width="5%"      align="center"><font face="arial" size=2>&nbsp;4</font></td>
 
234
    <td width="75%"     ><font face="arial" size="2">Total no.of M.S.S members old and new</font></td>
 
235
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[2]%></font>&nbsp;</td>
 
236
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[2]%></font>&nbsp;</td>
 
237
  </tr>
 
238
  <tr>
 
239
   <td width="5%"       align="center"><font face="arial" size=2>&nbsp;5</font></td>
 
240
    <td width="75%"     ><font face="arial" size="2">No.of M.S.S members meeting held</font></td>
 
241
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[3]%></font>&nbsp;</td>
 
242
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[3]%></font>&nbsp;</td>
 
243
  </tr>
 
244
  <tr>
 
245
    <td width="5%"      align="center"><font face="arial" size=2>&nbsp;6</font></td>
 
246
    <td width="75%"     ><font face="arial" size="2">No.of folders/Booklets/phamlets/posters distributed</font></td>
 
247
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[4]%></font>&nbsp;</td>
 
248
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[4]%></font>&nbsp;</td>
 
249
  </tr>
 
250
  <tr>
 
251
   <td width="5%"       align="center"><font face="arial" size=2>&nbsp;7</font></td>
 
252
    <td width="75%"     ><font face="arial" size=2>&nbsp;No.of depoholders established by M.S.S</font></td>
 
253
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[5]%></font>&nbsp;</td>
 
254
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[5]%></font>&nbsp;</td>
 
255
  </tr>
 
256
  <tr>
 
257
   <td width="5%"       align="center"><font face="arial" size=2>&nbsp;8</font></td>
 
258
    <td width="75%"     ><font face="arial" size="2">No.of other educational activities organised/group discussions etc</font></td>
 
259
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[6]%></font>&nbsp;</td>
 
260
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[6]%></font>&nbsp;</td>
 
261
  </tr>
 
262
  <tr>
 
263
  <td width="5%"        align="center"><font face="arial" size=2>&nbsp;9</font></td>
 
264
    <td width="75%"     ><font face="arial" size="2">Immunization Camp</font></td>
 
265
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[7]%></font>&nbsp;</td>
 
266
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[7]%></font>&nbsp;</td>
 
267
  </tr>
 
268
  <tr>
 
269
   <td width="5%"       align="center"><font face="arial" size=2>&nbsp;10</font></td>
 
270
    <td width="75%"     ><font face="arial" size="2">IUD Cases</font></td>
 
271
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[8]%></font>&nbsp;</td>
 
272
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[8]%></font>&nbsp;</td>
 
273
  </tr>
 
274
  <tr>
 
275
  <td width="5%"        align="center"><font face="arial" size="2">&nbsp;11</font></td>
 
276
    <td width="75%"     ><font face="arial" size="2">Sterilization Cases</font></td>
 
277
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[9] + monthlyDataValues[10] + monthlyDataValues[11] + monthlyDataValues[12] + monthlyDataValues[13]%></font>&nbsp;</td>
 
278
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[9] + yearlyDataValues[10] + yearlyDataValues[11] + yearlyDataValues[12] + yearlyDataValues[13]%></font>&nbsp;</td>
 
279
  </tr>
 
280
  <tr>
 
281
   <td width="5%"       align="center"><font face="arial" size=2>&nbsp;12</font></td>
 
282
    <td width="75%"     ><font face="arial" size="2">Antinatal Cases</font></td>
 
283
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[14]%></font>&nbsp;</td>
 
284
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[14]%></font>&nbsp;</td>
 
285
  </tr>
 
286
  <tr>
 
287
   <td width="5%"       align="center"><font face="arial" size=2>&nbsp;13</font></td>
 
288
    <td width="75%"     ><font face="arial" size="2">Distribution of iron folic aoid</font></td>
 
289
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[15]%></font>&nbsp;</td>
 
290
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[15]%></font>&nbsp;</td>
 
291
 
 
292
  </tr>
 
293
  <tr>
 
294
   <td width="5%"       align="center"><font face="arial" size=2>&nbsp;14</font></td>
 
295
    <td width="75%"     ><font face="arial" size="2">Media Activities</font></td>
 
296
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[16]%></font>&nbsp;</td>
 
297
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[16]%></font>&nbsp;</td>
 
298
  </tr>
 
299
  <tr>
 
300
  <td width="5%"        align="center"><font face="arial" size=2>&nbsp;(a)</font></td>
 
301
    <td width="75%"     ><font face="arial" size="2">Film Show</font></td>
 
302
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[17]%></font>&nbsp;</td>
 
303
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[17]%></font>&nbsp;</td>
 
304
 
 
305
  </tr>
 
306
  <tr>
 
307
  <td width="5%"        align="center"><font face="arial" size=2>&nbsp;(b)</font></td>
 
308
    <td width="75%"     ><font face="arial" size="2">Cinema</font></td>
 
309
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[18]%></font>&nbsp;</td>
 
310
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[18]%></font>&nbsp;</td>
 
311
  </tr>
 
312
  <tr>
 
313
    <td width="5%"      align="center"><font face="arial" size="2">&nbsp;(c)</font></td>
 
314
    <td width="75%"     ><font face="arial" size="2">Mini exhibition</font></td>
 
315
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[19]%></font>&nbsp;</td>
 
316
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[19]%></font>&nbsp;</td>
 
317
  </tr>
 
318
  <tr>
 
319
   <td width="5%"       align="center"><font face="arial" size="2">&nbsp;(d)</font></td>
 
320
    <td width="75%"><font face="arial" size="2">Ward population unit seminars</font></td>
 
321
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[20]%></font>&nbsp;</td>
 
322
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[20]%></font>&nbsp;</td>
 
323
  </tr>
 
324
  <tr>
 
325
   <td width="5%"       align="center"><font face="arial" size="2">&nbsp;(e)</font></td>
 
326
    <td width="75%"     ><font face="arial" size="2">Video show</font></td>
 
327
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[21]%></font>&nbsp;</td>
 
328
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[21]%></font>&nbsp;</td>
 
329
  </tr>
 
330
  <tr>
 
331
    <td width="5%"      align="center"><font face="arial" size="2">&nbsp;(f)</font></td>
 
332
    <td width="75%"     ><font face="arial" size="2">Slide projection done</font></td>
 
333
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[22]%></font>&nbsp;</td>
 
334
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[22]%></font>&nbsp;</td>
 
335
  </tr>
 
336
  <tr>
 
337
   <td width="5%"       align="center"><font face="arial" size="2">&nbsp;(g)</font></td>
 
338
    <td width="75%"     ><font face="arial" size="2">Group discussion</font></td>
 
339
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[23]%></font>&nbsp;</td>
 
340
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[23]%></font>&nbsp;</td>
 
341
  </tr>
 
342
  <tr>
 
343
    <td width="5%"      align="center"><font face="arial" size="2">&nbsp;(h)</font></td>
 
344
    <td width="75%"><font face="arial" size="2">Public meeting</font></td>
 
345
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[24]%></font>&nbsp;</td>
 
346
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[24]%></font>&nbsp;</td>
 
347
  </tr>
 
348
  <tr>
 
349
   <td width="5%"       align="center"><font face="arial" size=2>&nbsp;(i)</font></td>
 
350
    <td width="75%"><font face="arial" size="2">Any fund Alloted</font></td>
 
351
    <td width="10%"     align="center"><font face="arial" size=2><%=monthlyDataValues[25]%></font>&nbsp;</td>
 
352
    <td width="10%"     align="center"><font face="arial" size=2><%=yearlyDataValues[25]%></font>&nbsp;</td>
 
353
  </tr>
 
354
</table>
 
355
</body>
 
356
 
 
357
</html>
 
 
b'\\ No newline at end of file'