← 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/kvector.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/kvector.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
      
 
57
        String monthlyPeriodId = (String) stack.findValue( "monthlyPeriodTypeId" );
 
58
        int periodTypeID = Integer.parseInt( monthlyPeriodId );
 
59
 
 
60
      
 
61
        String selectedOrgUnitName = "";        
 
62
        String selectedDataPeriodStartDate = "";
 
63
                        
 
64
        String monthlyDataElements[] = {
 
65
                                                                                "'Some_DE'",
 
66
                                                                                "'Some_DE'",
 
67
                                                                                "'Some_DE'",
 
68
                                                                                "'Some_DE'",
 
69
                                                                                "'Some_DE'",
 
70
                                                                                "'Some_DE'",
 
71
                                                                                "'Some_DE'",
 
72
                                                                                "'Some_DE'",
 
73
                                                                                "'Some_DE'",
 
74
                                                                                "'Some_DE'",
 
75
                                                                                "'Some_DE'",
 
76
                                                                                "'Some_DE'",
 
77
                                                                                "'Some_DE'",
 
78
                                                                                "'Some_DE'",
 
79
                                                                                "'Some_DE'",
 
80
                                                                                "'Some_DE'",
 
81
                                                                                "'Some_DE'",
 
82
                                                                                "'Some_DE'",
 
83
                                                                                "'Some_DE'",
 
84
                                                                                "'Some_DE'",
 
85
                                                                                "'Some_DE'",
 
86
                                                                                "'Some_DE'",
 
87
                                                                                "'Some_DE'",
 
88
                                                                                "'Some_DE'",
 
89
                                                                                "'Some_DE'",
 
90
                                                                                "'Some_DE'",
 
91
                                                                                "'Some_DE'",
 
92
                                                                                "'Some_DE'",
 
93
                                                                                "'Some_DE'",
 
94
                                                                                "'Some_DE'",
 
95
                                                                                "'Some_DE'",
 
96
                                                                                "'Some_DE'",
 
97
                                                                                "'Some_DE'",
 
98
                                                                                "'Some_DE'",
 
99
                                                                                "'Some_DE'",
 
100
                                                                                "'Some_DE'",
 
101
                                                                                "'Some_DE'",
 
102
                                                                                "'Some_DE'",
 
103
                                                                                "'Some_DE'",
 
104
                                                                                "'Some_DE'",
 
105
                                                                                "'Some_DE'",
 
106
                                                                                "'Some_DE'",
 
107
                                                                                "'Some_DE'",
 
108
                                                                                "'Some_DE'",
 
109
                                                                                "'Some_DE'",
 
110
                                                                                "'Some_DE'"
 
111
                                                                                                                                                        
 
112
                
 
113
                                                                        };
 
114
                                        
 
115
          int monthlyValues[] = new int[monthlyDataElements.length+5];          
 
116
          int cumulativeValues[] =  new int[monthlyDataElements.length+5];
 
117
          
 
118
          int CHCID=0;
 
119
          int TalukID=0;
 
120
          int DistrictID=0;
 
121
          int StateID=0;
 
122
          
 
123
          String CHCName="";
 
124
          String TalukName = "";
 
125
          String  DistrictName = "";
 
126
          String StateName = "";
 
127
 
 
128
          int j=1;       
 
129
          int i=1;       
 
130
          int k=0;       
 
131
          int endcount = 0;
 
132
          int p = 0;     
 
133
          int q = 0;
 
134
        
 
135
          String monthNames[] = { "", "January", "February", "March", "April", "May", "June", "July", "August", "September",
 
136
                                                                        "October", "November", "December" };    
 
137
          String query = "";    
 
138
%>
 
139
 
 
140
<%
 
141
 
 
142
     try
 
143
      {
 
144
                Class.forName ("com.mysql.jdbc.Driver").newInstance ();
 
145
                con = DriverManager.getConnection (urlForConnection, userName, password);
 
146
        
 
147
                st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
148
                st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
149
                st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
150
                st4=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
151
                st5=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
152
                st6=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
153
                st7=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
154
                st8=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);    
 
155
                
 
156
                //rs1 = st1.executeQuery("select name from organisationunit  where id = "+selectedOrgUnitID);
 
157
                rs1 = st1.executeQuery("select name from organisationunit  where organisationunitid = "+selectedOrgUnitID);        
 
158
                if(rs1.next())        {  selectedOrgUnitName = rs1.getString(1);      }
 
159
                
 
160
        //      rs2 = st2.executeQuery("select startDate from period where id = "+selectedDataPeriodID);
 
161
                //      if(rs2.next())    {  selectedDataPeriodStartDate =  rs2.getDate(1).toString();  }                                                               
 
162
                
 
163
                   selectedDataPeriodStartDate = startingDate;
 
164
 
 
165
      } //try block end
 
166
      catch(Exception e)  { out.println(e.getMessage());  }
 
167
      
 
168
     String partsOfDataPeriodStartDate[] = selectedDataPeriodStartDate.split("-");
 
169
     int lastYear = Integer.parseInt(partsOfDataPeriodStartDate[0]) - 1;
 
170
     int tempForMonth1 = Integer.parseInt(partsOfDataPeriodStartDate[1]);
 
171
     int tempForYear = 0;
 
172
     if(tempForMonth1 < 4){   tempForYear = lastYear;  }
 
173
     else  {   tempForYear = lastYear + 1;      }
 
174
     String curYearStart=tempForYear+"-04-01";
 
175
                
 
176
    try
 
177
     {     
 
178
        for(i=0;i<monthlyDataElements.length;i++)         
 
179
                        {         
 
180
                                //query = "SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataElement = dataelement.id WHERE datavalue.period  in (select id from period where startdate between '"+startingDate+"' and '"+startingDate+"') AND datavalue.source in ( select id from organisationunit where parent = "+selectedOrgUnitID+")  AND dataelement.code in ("+monthlyDataElements[i]+")";
 
181
                                query = "SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataelementid = dataelement.dataelementid WHERE datavalue.periodid  in (select periodid from period where startdate between '"+startingDate+"' and '"+startingDate+"') AND datavalue.sourceid in ( select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+")  AND dataelement.code in ("+monthlyDataElements[i]+")";
 
182
 
 
183
                                rs3 = st3.executeQuery(query);
 
184
                                // "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="+selectedDataPeriodID);                                           
 
185
                        if(rs3.next())          {  monthlyValues[i] =  rs3.getInt(1);   }                                                                         
 
186
                        }
 
187
        } // try block end
 
188
    catch(Exception e)  { out.println(e.getMessage());  }
 
189
    finally
 
190
       {
 
191
                        try
 
192
                        {
 
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
                                
 
197
                                if(con!=null)  con.close(); 
 
198
                        }
 
199
                        catch(Exception e)   {  out.println(e.getMessage());   }
 
200
       } // finally block end   
 
201
       
 
202
  %>
 
203
 
 
204
<html>
 
205
<head>
 
206
        <title>VECTOR BORN DISEASES AND COMMUNICABLE DISEASES</title>
 
207
</head>
 
208
<body>                               
 
209
        <p align="center"><font face="Arial" size="3"><b>VECTOR BORN DISEASES AND COMMUNICABLE DISEASES&nbsp;&nbsp;<U><%=selectedOrgUnitName%></U>  </b></font></p>
 
210
        <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
211
                <tr>
 
212
                        <td width="24%" height="25" rowspan="2" ALIGN="CENTER"><font face="Arial" size="2">INSTITUTION</FONT></td>
 
213
                        <td width="8%" height="13" colspan="2" ALIGN="CENTER"><font face="Arial" size="2">DENGUE</FONT></td>
 
214
                        <td width="8%" height="13" colspan="2" ALIGN="CENTER"><font face="Arial" size="2">LAPTO</FONT></td>
 
215
                        <td width="8%" height="13" colspan="2" ALIGN="CENTER"><font face="Arial" size="2">MALARIA</FONT></td>
 
216
                        <td width="8%" height="13" colspan="2" ALIGN="CENTER"><font face="Arial" size="2">DIARRHOEAL</FONT></td>
 
217
                        <td width="8%" height="13" colspan="2" ALIGN="CENTER"><font face="Arial" size="2">DYSENTRY</FONT></td>
 
218
                        <td width="8%" height="13" colspan="2" ALIGN="CENTER"><font face="Arial" size="2">MEASLES</FONT></td>
 
219
                        <td width="8%" height="13" colspan="2" ALIGN="CENTER"><font face="Arial" size="2">MUMPS</FONT></td>
 
220
                        <td width="8%" height="13" colspan="2" ALIGN="CENTER"><font face="Arial" size="2">CHICKEN POX</FONT></td>
 
221
                        <td width="12%" height="13" colspan="3" ALIGN="CENTER"><font face="Arial" size="2">IEC ACTIVITIES</FONT></td>
 
222
                </tr>
 
223
                <tr>
 
224
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">M<BR>O<BR>N<BR>T<BR>H<BR>L<BR>Y</FONT></td>
 
225
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">P<BR>R<BR>O<BR>G<BR>R<BR>E<BR>S<BR>S<BR>I<BR>V<BR>E</FONT></td>
 
226
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">M<BR>O<BR>N<BR>T<BR>H<BR>L<BR>Y</FONT></td>
 
227
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">P<BR>R<BR>O<BR>G<BR>R<BR>E<BR>S<BR>S<BR>I<BR>V<BR>E</FONT></td>
 
228
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">M<BR>O<BR>N<BR>T<BR>H<BR>L<BR>Y</FONT></td>
 
229
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">P<BR>R<BR>O<BR>G<BR>R<BR>E<BR>S<BR>S<BR>I<BR>V<BR>E</FONT></td>
 
230
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">M<BR>O<BR>N<BR>T<BR>H<BR>L<BR>Y</FONT></td>
 
231
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">P<BR>R<BR>O<BR>G<BR>R<BR>E<BR>S<BR>S<BR>I<BR>V<BR>E</FONT></td>
 
232
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">M<BR>O<BR>N<BR>T<BR>H<BR>L<BR>Y</FONT></td>
 
233
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">P<BR>R<BR>O<BR>G<BR>R<BR>E<BR>S<BR>S<BR>I<BR>V<BR>E</FONT></td>
 
234
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">M<BR>O<BR>N<BR>T<BR>H<BR>L<BR>Y</FONT></td>
 
235
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">P<BR>R<BR>O<BR>G<BR>R<BR>E<BR>S<BR>S<BR>I<BR>V<BR>E</FONT></td>
 
236
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">M<BR>O<BR>N<BR>T<BR>H<BR>L<BR>Y</FONT></td>
 
237
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">P<BR>R<BR>O<BR>G<BR>R<BR>E<BR>S<BR>S<BR>I<BR>V<BR>E</FONT></td>
 
238
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">M<BR>O<BR>N<BR>T<BR>H<BR>L<BR>Y</FONT></td>
 
239
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">P<BR>R<BR>O<BR>G<BR>R<BR>E<BR>S<BR>S<BR>I<BR>V<BR>E</FONT></td>
 
240
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">G<BR>R<BR>O<BR>U<BR>P<BR> <BR>T<BR>A<BR>L<BR>K</FONT></td>
 
241
                                <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">W<BR>E<BR>L<BR>L<BR> <BR>C<BR>H<BR>L<BR>O<BR>R<BR>I<BR>O<BR>S<BR>A<BR>T<BR>I<BR>O<BR>N</FONT></td>
 
242
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">O<BR>R<BR>S<BR> <BR>I<BR>S<BR>S<BR>U<BR>E<BR>D</FONT></td>
 
243
                </tr>
 
244
                <tr>
 
245
                        <td width="24%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=selectedOrgUnitName%></FONT></td>
 
246
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[0]%></FONT></td>
 
247
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[1]%></FONT></td>
 
248
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[2]%></FONT></td>
 
249
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[3]%></FONT></td>
 
250
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[4]%></FONT></td>
 
251
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[5]%></FONT></td>
 
252
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[6]%></FONT></td>
 
253
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[7]%></FONT></td>
 
254
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[8]%></FONT></td>
 
255
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[9]%></FONT></td>
 
256
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[10]%></FONT></td>
 
257
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[11]%></FONT></td>
 
258
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[12]%></FONT></td>
 
259
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[13]%></FONT></td>
 
260
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[14]%></FONT></td>
 
261
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[15]%></FONT></td>
 
262
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[16]%></FONT></td>
 
263
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[17]%></FONT></td>
 
264
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[18]%></FONT></td>
 
265
                </tr>
 
266
                </table>                                     
 
267
 
 
268
<BR>
 
269
        <font face="Arial" size="3"><b>NVBDCP</b></FONT>
 
270
<BR>
 
271
        <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="40%">
 
272
                <tr>
 
273
                        <td width="20%" height="13" colspan="4" ALIGN="CENTER"><font face="Arial" size="2">ACTIVE</font></td>
 
274
                        <td width="20%" height="13" colspan="4" ALIGN="CENTER"><font face="Arial" size="2">PASSIVE</FONT></td>
 
275
                </tr>
 
276
                <tr>
 
277
                        <td width="5%" ALIGN="CENTER"><font face="Arial" size="2">T<BR>A<BR>R<BR>G<BR>E<BR>T</font></td>
 
278
                        <td width="5%" ALIGN="CENTER"><font face="Arial" size="2">M<BR>O<BR>N<BR>T<BR>H<BR>L<BR>Y</font></td>
 
279
                        <td width="5%" ALIGN="CENTER"><font face="Arial" size="2">P<BR>R<BR>O<BR>G<BR>R<BR>E<BR>S<BR>S<BR>I<BR>V<BR>E</font></td>
 
280
                        <td width="5%" ALIGN="CENTER"><font face="Arial" size="2">%</font></td>
 
281
                        <td width="5%" ALIGN="CENTER"><font face="Arial" size="2">T<BR>A<BR>R<BR>G<BR>E<BR>T</font></td>
 
282
                        <td width="5%" ALIGN="CENTER"><font face="Arial" size="2">M<BR>O<BR>N<BR>T<BR>H<BR>L<BR>Y</font></td>
 
283
                        <td width="5%" ALIGN="CENTER"><font face="Arial" size="2">P<BR>R<BR>O<BR>G<BR>R<BR>E<BR>S<BR>S<BR>I<BR>V<BR>E</font></td>
 
284
                        <td width="5%" ALIGN="CENTER"><font face="Arial" size="2">%</font></td>
 
285
                </tr>
 
286
                <tr>
 
287
                        <td width="5%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[19]%></FONT></td>
 
288
                        <td width="5%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[20]%></font></td>
 
289
                        <td width="5%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[21]%></font></td>
 
290
                        <td width="5%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[22]%></font></td>
 
291
                        <td width="5%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[23]%></FONT></td>
 
292
                        <td width="5%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[24]%></font></td>
 
293
                        <td width="5%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[25]%></font></td>
 
294
                        <td width="5%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[26]%></font></td>
 
295
                </tr>
 
296
        </table>                
 
297
        
 
298
        <br>
 
299
        <p align="center"><font face="Arial" size="3"><b>RNTCP REPORT OF&nbsp;&nbsp;<U><%=selectedOrgUnitName%></U> </b></font></p>
 
300
        <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
301
                <tr>
 
302
                        <td width="24%" height="25" rowspan="2" ALIGN="CENTER"><font face="Arial" size="2">INSTITUTION</FONT></td>
 
303
                        <td width="24%" height="13" colspan="6" ALIGN="CENTER"><font face="Arial" size="2">CATEGORY-1</FONT></td>
 
304
                        <td width="24%" height="13" colspan="6" ALIGN="CENTER"><font face="Arial" size="2">CATEGORY-2</FONT></td>
 
305
                        <td width="28%" height="13" colspan="7" ALIGN="CENTER"><font face="Arial" size="2">CATEGORY-3</font></td>
 
306
                </tr>
 
307
                <tr>
 
308
                                <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">C &nbsp;&nbsp;<BR>A L<BR>S A<BR>E S<BR>S T<BR>&nbsp;&nbsp;&nbsp;<BR>U M<BR>P O<BR>T N<BR>O T<BR>&nbsp;&nbsp;&nbsp;&nbsp;H</font></td>
 
309
                                <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">&nbsp;&nbsp;&nbsp;R<BR>N E<BR>E G<BR>W I<BR>&nbsp;&nbsp;&nbsp;S<BR>C T<BR>A E<BR>S R<BR>E E<BR>&nbsp;&nbsp;&nbsp;D</font></td>
 
310
                                <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">&nbsp;&nbsp;&nbsp;C&nbsp;&nbsp;&nbsp;<BR>T O&nbsp;&nbsp;&nbsp;<BR>R M C<BR>E P U<BR>A L R<BR>T E E<BR>M T D<BR>E E&nbsp;&nbsp;&nbsp;<BR>N D&nbsp;&nbsp;&nbsp;<BR>T&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;&nbsp;&nbsp;&&nbsp;&nbsp;&nbsp;</font></td>
 
311
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">D<BR>E<BR>F<BR>A<BR>U<BR>L<BR>T</font></td>
 
312
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">C<BR>A<BR>S<BR>E<BR>S<BR> <BR>D<BR>E<BR>A<BR>T<BR>H</font></td>
 
313
                                <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">&nbsp;&nbsp;&nbsp;U<BR>&nbsp;&nbsp;&nbsp;N<BR>T D<BR>O E<BR>T R<BR>A&nbsp;&nbsp;&nbsp;<BR>L T<BR>&nbsp;&nbsp;&nbsp;R<BR>C E<BR>A A<BR>S T<BR>E M<BR>S E<BR>&nbsp;&nbsp;&nbsp;N<BR>&nbsp;&nbsp;&nbsp;T</font></td>
 
314
                                <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">C &nbsp;&nbsp;<BR>A L<BR>S A<BR>E S<BR>S T<BR>&nbsp;&nbsp;&nbsp;<BR>U M<BR>P O<BR>T N<BR>O T<BR>&nbsp;&nbsp;&nbsp;&nbsp;H</font></td>
 
315
                                <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">&nbsp;&nbsp;&nbsp;R<BR>N E<BR>E G<BR>W I<BR>&nbsp;&nbsp;&nbsp;S<BR>C T<BR>A E<BR>S R<BR>E E<BR>&nbsp;&nbsp;&nbsp;D</font></td>
 
316
                                <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">&nbsp;&nbsp;&nbsp;C&nbsp;&nbsp;&nbsp;<BR>T O&nbsp;&nbsp;&nbsp;<BR>R M C<BR>E P U<BR>A L R<BR>T E E<BR>M T D<BR>E E&nbsp;&nbsp;&nbsp;<BR>N D&nbsp;&nbsp;&nbsp;<BR>T&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;&nbsp;&nbsp;&&nbsp;&nbsp;&nbsp;</font></td>
 
317
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">D<BR>E<BR>F<BR>A<BR>U<BR>L<BR>T</font></td>
 
318
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">C<BR>A<BR>S<BR>E<BR>S<BR> <BR>D<BR>E<BR>A<BR>T<BR>H</font></td>
 
319
                                <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">&nbsp;&nbsp;&nbsp;U<BR>&nbsp;&nbsp;&nbsp;N<BR>T D<BR>O E<BR>T R<BR>A&nbsp;&nbsp;&nbsp;<BR>L T<BR>&nbsp;&nbsp;&nbsp;R<BR>C E<BR>A A<BR>S T<BR>E M<BR>S E<BR>&nbsp;&nbsp;&nbsp;N<BR>&nbsp;&nbsp;&nbsp;T</font></td>
 
320
                                <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">C &nbsp;&nbsp;<BR>A L<BR>S A<BR>E S<BR>S T<BR>&nbsp;&nbsp;&nbsp;<BR>U M<BR>P O<BR>T N<BR>O T<BR>&nbsp;&nbsp;&nbsp;&nbsp;H</font></td>
 
321
                                <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">&nbsp;&nbsp;&nbsp;R<BR>N E<BR>E G<BR>W I<BR>&nbsp;&nbsp;&nbsp;S<BR>C T<BR>A E<BR>S R<BR>E E<BR>&nbsp;&nbsp;&nbsp;D</font></td>
 
322
                                <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">&nbsp;&nbsp;&nbsp;C&nbsp;&nbsp;&nbsp;<BR>T O&nbsp;&nbsp;&nbsp;<BR>R M C<BR>E P U<BR>A L R<BR>T E E<BR>M T D<BR>E E&nbsp;&nbsp;&nbsp;<BR>N D&nbsp;&nbsp;&nbsp;<BR>T&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR>&nbsp;&nbsp;&nbsp;&&nbsp;&nbsp;&nbsp;</font></td>
 
323
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">D<BR>E<BR>F<BR>A<BR>U<BR>L<BR>T</font></td>
 
324
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">C<BR>A<BR>S<BR>E<BR>S<BR> <BR>D<BR>E<BR>A<BR>T<BR>H</font></td>
 
325
                        <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">M<BR>D<BR>R<BR> <BR>T<BR>B</font></td>
 
326
                                <td width="4%" ALIGN="CENTER"><font face="Arial" size="1">&nbsp;&nbsp;&nbsp;U<BR>&nbsp;&nbsp;&nbsp;N<BR>T D<BR>O E<BR>T R<BR>A&nbsp;&nbsp;&nbsp;<BR>L T<BR>&nbsp;&nbsp;&nbsp;R<BR>C E<BR>A A<BR>S T<BR>E M<BR>S E<BR>&nbsp;&nbsp;&nbsp;N<BR>&nbsp;&nbsp;&nbsp;T</font></td>
 
327
                </tr>
 
328
                <tr>
 
329
                        <td width="24%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=selectedOrgUnitName%></FONT></td>
 
330
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[27]%></FONT></td>
 
331
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[28]%></FONT></td>
 
332
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[29]%></FONT></td>
 
333
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[30]%></FONT></td>
 
334
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[31]%></FONT></td>
 
335
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[32]%></FONT></td>
 
336
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[33]%></FONT></td>
 
337
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[34]%></FONT></td>
 
338
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[35]%></FONT></td>
 
339
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[36]%></FONT></td>
 
340
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[37]%></FONT></td>
 
341
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[38]%></FONT></td>
 
342
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[39]%></FONT></td>
 
343
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[40]%></FONT></td>
 
344
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[41]%></FONT></td>
 
345
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[42]%></FONT></td>
 
346
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[43]%></FONT></td>
 
347
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[44]%></FONT></td>
 
348
                        <td width="4%" height="50" ALIGN="CENTER"><font face="Arial" size="2"><%=monthlyValues[45]%></FONT></td>
 
349
                </tr>
 
350
        </table>                                                                     
 
351
</body>
 
352
</html>
 
 
b'\\ No newline at end of file'