← 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/Jharkhand/jnon-comm-p.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/Jharkhand/jnon-comm-p.jsp
 
1
 
 
2
<%@ page import="java.sql.*,java.util.*" %>
 
3
<%@ page import="com.opensymphony.xwork.util.OgnlValueStack" %>
 
4
 
 
5
<%@ page session="true"%>
 
6
 
 
7
<%
 
8
    Connection con=null;
 
9
            
 
10
    // For finding organisationunit name of selected Orgunit based on Orgunit id
 
11
    Statement st1=null;
 
12
    ResultSet rs1=null;
 
13
      
 
14
    // For finding start date of selected period based on period id
 
15
    Statement st2=null;
 
16
    ResultSet rs2=null;
 
17
  
 
18
   // For finding datavalues 
 
19
    Statement st3=null;
 
20
    ResultSet rs3=null;
 
21
 
 
22
    // For finding District Name and Id based on selected Orgunit id
 
23
    Statement st4=null;
 
24
    ResultSet rs4=null;
 
25
 
 
26
    // For finding State Name based on District id
 
27
    Statement st5=null;
 
28
    ResultSet rs5=null;
 
29
  
 
30
    String userName = "dhis";      
 
31
    String password = "";           
 
32
    String urlForConnection = "jdbc:mysql://localhost/jh_dhis2";
 
33
          
 
34
        OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
 
35
 
 
36
        String selectedId = (String) stack.findValue( "orgUnitId" );
 
37
        int selectedOrgUnitID = Integer.parseInt( selectedId );
 
38
        
 
39
//      String selectedPeriodId = (String) stack.findValue( "periodSelect" );
 
40
//      int selectedDataPeriodID =      Integer.parseInt( selectedPeriodId );
 
41
 
 
42
        String startingDate  = (String) stack.findValue( "startingPeriod" );
 
43
        String endingDate  = (String) stack.findValue( "endingPeriod" );
 
44
 
 
45
      
 
46
        String monthlyPeriodId = (String) stack.findValue( "monthlyPeriodTypeId" );
 
47
        int periodTypeID = Integer.parseInt( monthlyPeriodId );
 
48
 
 
49
      
 
50
        String selectedOrgUnitName = "";        
 
51
        String selectedDataPeriodStartDate = ""; 
 
52
        
 
53
        String stateName = "";
 
54
        String districtName = "";
 
55
        int districtID = 0;
 
56
        
 
57
        
 
58
        String monthNames[] = { "", "January", "February", "March", "April", "May", "June", "July", "August", "September","October", "November", "December" };                  
 
59
 
 
60
        String monthlyDataElements[] = {                                                                                        
 
61
                                                                                        //Hypertension
 
62
                                                                                        
 
63
                                                                                        "NC_DE1","NC_DE29", // col 3
 
64
                                                                                        "NC_DE2","NC_DE30", // col 4
 
65
                                                                                        "NC_DE57", // col 6
 
66
                                                                                        "NC_DE58", // col 7
 
67
                                                                                        "NC_DE1", // col 9
 
68
                                                                                        "NC_DE2", // col 10
 
69
                                                                                        "NC_DE29", // col 12
 
70
                                                                                        "NC_DE30", // col 13
 
71
                                                                                        "NC_DE57", // col 18
 
72
                                                                                        "NC_DE58", // col 19
 
73
                                                                                        
 
74
                                                                                        // Ischemic Heart Diseases
 
75
                                                                                        
 
76
                                                                                        "NC_DE3","NC_DE31", // col 3
 
77
                                                                                        "NC_DE4","NC_DE32", // col 4
 
78
                                                                                        "NC_DE59", // col 6
 
79
                                                                                        "NC_DE60", // col 7
 
80
                                                                                        "NC_DE3", // col 9
 
81
                                                                                        "NC_DE4", // col 10
 
82
                                                                                        "NC_DE31", // col 12
 
83
                                                                                        "NC_DE32", // col 13
 
84
                                                                                        "NC_DE59", // col 18
 
85
                                                                                        "NC_DE60", // col 19
 
86
 
 
87
                                                                                        // Cerebro Vascular Accident
 
88
                                                                                        "NC_DE5","NC_DE33", // col 3
 
89
                                                                                        "NC_DE6","NC_DE34", // col 4
 
90
                                                                                        "NC_DE61", // col 6
 
91
                                                                                        "NC_DE62", // col 7
 
92
                                                                                        "NC_DE5", // col 9
 
93
                                                                                        "NC_DE6", // col 10
 
94
                                                                                        "NC_DE33", // col 12
 
95
                                                                                        "NC_DE34", // col 13
 
96
                                                                                        "NC_DE61", // col 18
 
97
                                                                                        "NC_DE62", // col 19
 
98
 
 
99
                                                                                        // Other Neurological Disorders
 
100
                                                                                        "NC_DE7","NC_DE35", // col 3
 
101
                                                                                        "NC_DE8","NC_DE36", // col 4
 
102
                                                                                        "NC_DE63", // col 6
 
103
                                                                                        "NC_DE64", // col 7
 
104
                                                                                        "NC_DE7", // col 9
 
105
                                                                                        "NC_DE8", // col 10
 
106
                                                                                        "NC_DE35", // col 12
 
107
                                                                                        "NC_DE36", // col 13
 
108
                                                                                        "NC_DE63", // col 18
 
109
                                                                                        "NC_DE64", // col 19
 
110
 
 
111
                                                                                        // Diabetes Mellitus Type - 1
 
112
                                                                                        "NC_DE9","NC_DE37", // col 3
 
113
                                                                                        "NC_DE10","NC_DE38", // col 4
 
114
                                                                                        "NC_DE65", // col 6
 
115
                                                                                        "NC_DE66", // col 7
 
116
                                                                                        "NC_DE9", // col 9
 
117
                                                                                        "NC_DE10", // col 10
 
118
                                                                                        "NC_DE37", // col 12
 
119
                                                                                        "NC_DE38", // col 13
 
120
                                                                                        "NC_DE65", // col 18
 
121
                                                                                        "NC_DE66", // col 19
 
122
 
 
123
                                                                                        // Diabetes Mellitus Type - 2
 
124
                                                                                        "NC_DE11","NC_DE39", // col 3
 
125
                                                                                        "NC_DE12","NC_DE40", // col 4
 
126
                                                                                        "NC_DE67", // col 6
 
127
                                                                                        "NC_DE68", // col 7
 
128
                                                                                        "NC_DE11", // col 9
 
129
                                                                                        "NC_DE12", // col 10
 
130
                                                                                        "NC_DE39", // col 12
 
131
                                                                                        "NC_DE40", // col 13
 
132
                                                                                        "NC_DE67", // col 18
 
133
                                                                                        "NC_DE68", // col 19
 
134
                                                                                        
 
135
                                                                                        // Bronchitis
 
136
                                                                                        "NC_DE13","NC_DE41", // col 3
 
137
                                                                                        "NC_DE14","NC_DE42", // col 4
 
138
                                                                                        "NC_DE69", // col 6
 
139
                                                                                        "NC_DE70", // col 7
 
140
                                                                                        "NC_DE13", // col 9
 
141
                                                                                        "NC_DE14", // col 10
 
142
                                                                                        "NC_DE41", // col 12
 
143
                                                                                        "NC_DE42", // col 13
 
144
                                                                                        "NC_DE69", // col 18
 
145
                                                                                        "NC_DE70", // col 19
 
146
 
 
147
                                                                                        // Emphysemas
 
148
                                                                                        "NC_DE15","NC_DE43", // col 3
 
149
                                                                                        "NC_DE16","NC_DE44", // col 4
 
150
                                                                                        "NC_DE71", // col 6
 
151
                                                                                        "NC_DE72", // col 7
 
152
                                                                                        "NC_DE15", // col 9
 
153
                                                                                        "NC_DE16", // col 10
 
154
                                                                                        "NC_DE43", // col 12
 
155
                                                                                        "NC_DE44", // col 13
 
156
                                                                                        "NC_DE71", // col 18
 
157
                                                                                        "NC_DE72", // col 19
 
158
 
 
159
                                                                                        // Asthma
 
160
                                                                                        "NC_DE17","NC_DE45", // col 3
 
161
                                                                                        "NC_DE18","NC_DE46", // col 4
 
162
                                                                                        "NC_DE73", // col 6
 
163
                                                                                        "NC_DE74", // col 7
 
164
                                                                                        "NC_DE17", // col 9
 
165
                                                                                        "NC_DE18", // col 10
 
166
                                                                                        "NC_DE45", // col 12
 
167
                                                                                        "NC_DE46", // col 13
 
168
                                                                                        "NC_DE73", // col 18
 
169
                                                                                        "NC_DE74", // col 19
 
170
 
 
171
                                                                                        // Common Mental Disorders
 
172
                                                                                        "NC_DE19","NC_DE47", // col 3
 
173
                                                                                        "NC_DE20","NC_DE48", // col 4
 
174
                                                                                        "NC_DE75", // col 6
 
175
                                                                                        "NC_DE76", // col 7
 
176
                                                                                        "NC_DE19", // col 9
 
177
                                                                                        "NC_DE20", // col 10
 
178
                                                                                        "NC_DE47", // col 12
 
179
                                                                                        "NC_DE48", // col 13
 
180
                                                                                        "NC_DE75", // col 18
 
181
                                                                                        "NC_DE76", // col 19
 
182
 
 
183
                                                                                        // Severe Mental Disorders
 
184
                                                                                        "NC_DE21","NC_DE49", // col 3
 
185
                                                                                        "NC_DE22","NC_DE50", // col 4
 
186
                                                                                        "NC_DE77", // col 6
 
187
                                                                                        "NC_DE78", // col 7
 
188
                                                                                        "NC_DE21", // col 9
 
189
                                                                                        "NC_DE22", // col 10
 
190
                                                                                        "NC_DE49", // col 12
 
191
                                                                                        "NC_DE50", // col 13
 
192
                                                                                        "NC_DE77", // col 18
 
193
                                                                                        "NC_DE78", // col 19
 
194
 
 
195
                                                                                        // Accidental Injuries
 
196
                                                                                        "NC_DE23","NC_DE51", // col 3
 
197
                                                                                        "NC_DE24","NC_DE52", // col 4
 
198
                                                                                        "NC_DE79", // col 6
 
199
                                                                                        "NC_DE80", // col 7
 
200
                                                                                        "NC_DE23", // col 9
 
201
                                                                                        "NC_DE24", // col 10
 
202
                                                                                        "NC_DE51", // col 12
 
203
                                                                                        "NC_DE52", // col 13
 
204
                                                                                        "NC_DE79", // col 18
 
205
                                                                                        "NC_DE80", // col 19
 
206
 
 
207
                                                                                        // Cancer
 
208
                                                                                        "NC_DE25","NC_DE53", // col 3
 
209
                                                                                        "NC_DE26","NC_DE54", // col 4
 
210
                                                                                        "NC_DE81", // col 6
 
211
                                                                                        "NC_DE82", // col 7
 
212
                                                                                        "NC_DE25", // col 9
 
213
                                                                                        "NC_DE26", // col 10
 
214
                                                                                        "NC_DE53", // col 12
 
215
                                                                                        "NC_DE54", // col 13
 
216
                                                                                        "NC_DE81", // col 18
 
217
                                                                                        "NC_DE82", // col 19
 
218
 
 
219
                                                                                        // Snake Bite
 
220
                                                                                        "NC_DE27","NC_DE55", // col 3
 
221
                                                                                        "NC_DE28","NC_DE56", // col 4
 
222
                                                                                        "NC_DE83", // col 6
 
223
                                                                                        "NC_DE84", // col 7
 
224
                                                                                        "NC_DE27", // col 9
 
225
                                                                                        "NC_DE28", // col 10
 
226
                                                                                        "NC_DE55", // col 12
 
227
                                                                                        "NC_DE56", // col 13
 
228
                                                                                        "NC_DE83", // col 18
 
229
                                                                                        "NC_DE84", // col 19
 
230
 
 
231
 
 
232
                                                                                        
 
233
                                                                        };
 
234
        
 
235
        String nonCommDisNames[] = {
 
236
                                                                "&#2325;&#2366;&#2352;&#2381;&#2337;&#2367;&#2351;&#2379; &#2349;&#2366;&#2360;&#2381;&#2325;&#2369;&#2354;&#2352; &#2352;&#2379;&#2327;&#2368; ",
 
237
                                                                "&#2361;&#2366;&#2312;&#2346;&#2352;&#2335;&#2375;&#2344;&#2360;&#2344;",
 
238
                                                                "&#2311;&#2360;&#2375;&#2350;&#2367;&#2325; &#2361;&#2381;&#2352;&#2381;&#2342;&#2351; &#2352;&#2379;&#2327;",
 
239
                                                                "&#2344;&#2381;&#2351;&#2369;&#2352;&#2379;&#2354;&#2379;&#2332;&#2367;&#2325;&#2354; &#2352;&#2379;&#2327;",
 
240
                                                                "&#2360;&#2375;&#2352;&#2375;&#2348;&#2352;&#2379; &#2349;&#2366;&#2360;&#2381;&#2325;&#2369;&#2354;&#2352; &#2342;&#2369;&#2328;&#2352;&#2381;&#2335;&#2344;&#2366; ",
 
241
                                                                "&#2309;&#2344;&#2381;&#2351; &#2344;&#2381;&#2351;&#2369;&#2352;&#2379;&#2354;&#2379;&#2332;&#2367;&#2325;&#2354; &#2337;&#2367;&#2360; &#2310;&#2352;&#2381;&#2337;&#2352;",
 
242
                                                                "&#2337;&#2366;&#2351;&#2348;&#2367;&#2335;&#2367;&#2332;",
 
243
                                                                "&#2335;&#2366;&#2312;&#2346; 1",
 
244
                                                                "&#2335;&#2366;&#2312;&#2346; 2",
 
245
                                                                "&#2347;&#2375;&#2347;&#2337;&#2375;",
 
246
                                                                "&#2348;&#2381;&#2352;&#2379;&#2344;&#2325;&#2366;&#2311;&#2335;&#2367;&#2360;",
 
247
                                                                "&#2311;&#2350;&#2381;&#2347;&#2368;&#2332;&#2350;&#2366;&#2360;",
 
248
                                                                "&#2342;&#2350;&#2366;",
 
249
                                                                "&#2350;&#2366;&#2344;&#2360;&#2367;&#2325; &#2309;&#2360;&#2306;&#2340;&#2369;&#2354;&#2344;",
 
250
                                                                "&#2360;&#2366;&#2343;&#2366;&#2352;&#2339; &#2350;&#2366;&#2344;&#2360;&#2367;&#2325; &#2309;&#2360;&#2306;&#2340;&#2369;&#2354;&#2344;",
 
251
                                                                "&#2328;&#2366;&#2340;&#2325; &#2350;&#2366;&#2344;&#2360;&#2367;&#2325; &#2309;&#2360;&#2306;&#2340;&#2369;&#2354;&#2344;",
 
252
                                                                "&#2342;&#2369;&#2328;&#2352;&#2381;&#2335;&#2344;&#2366; &#2327;&#2381;&#2352;&#2360;&#2381;&#2340; &#2330;&#2379;&#2335;",
 
253
                                                                "&#2325;&#2376;&#2306;&#2360;&#2352;",
 
254
                                                                "&#2360;&#2352;&#2381;&#2346;&#2342;&#2306;&#2358;",
 
255
                                                                "&#2351;&#2379;&#2327;"
 
256
                                                        };      
 
257
                                                        
 
258
        String nonCommDisNo[] = {
 
259
                                                                "1.","1.1","1.2","2.","2.1","2.2","3.","3.1","3.2","4.","4.1","4.2","4.3","5.","5.1","5.2","6.","7.","8."," "
 
260
                                                        };      
 
261
                                                        
 
262
        
 
263
        List childOrgUnitIDs = new ArrayList(); 
 
264
        List childOrgUnitNames = new ArrayList();       
 
265
                
 
266
        int childOrgUnitCount = 0;      
 
267
        int count = 0;          
 
268
        int i=0;
 
269
        int totPopulation = 0;
 
270
                
 
271
        int tempval[] = new int[16];
 
272
        int total[] = new int[16];
 
273
%>
 
274
 
 
275
<%
 
276
   
 
277
  try
 
278
      {
 
279
        Class.forName ("com.mysql.jdbc.Driver").newInstance ();
 
280
        con = DriverManager.getConnection (urlForConnection, userName, password);
 
281
        
 
282
        st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
283
        st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
284
        st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
285
        st4=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
286
                st5=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
287
 
 
288
 
 
289
 
 
290
        //rs1 = st1.executeQuery("SELECT organisationunit.shortname from organisationunit where id="+selectedOrgUnitID);
 
291
        rs1 = st1.executeQuery("SELECT organisationunit.shortname from organisationunit where organisationunitid="+selectedOrgUnitID);        
 
292
        if(rs1.next())    {  selectedOrgUnitName = rs1.getString(1);   }
 
293
        else  {  selectedOrgUnitName = "";          totPopulation = 0;    }  
 
294
                
 
295
//        rs2 = st2.executeQuery("select startDate from period where id = "+selectedDataPeriodID);
 
296
//          if(rs2.next())      {       selectedDataPeriodStartDate =  rs2.getDate(1).toString();       }               
 
297
 
 
298
                selectedDataPeriodStartDate = startingDate;
 
299
            
 
300
            //rs4=st4.executeQuery("select organisationunit.id, organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")");
 
301
            rs4=st4.executeQuery("select organisationunit.organisationunitid, organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+selectedOrgUnitID+")"); 
 
302
                if(rs4.next()) {  districtID = rs4.getInt(1); districtName = rs4.getString(2);}
 
303
                else {districtID = 0; districtName = "";}   
 
304
                
 
305
                //rs5=st5.executeQuery("select organisationunit.id, organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+districtID+")");
 
306
                rs5=st5.executeQuery("select organisationunit.organisationunitid, organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+districtID+")"); 
 
307
                if(rs5.next()) {  stateName = rs5.getString(2);}
 
308
                else { stateName = "";}  
 
309
                                                         
 
310
          } // try block end
 
311
    catch(Exception e)  { out.println(e.getMessage());  }
 
312
 
 
313
        
 
314
        String partsOfDataPeriodStartDate[]  =  selectedDataPeriodStartDate.split("-");
 
315
    int lastYear  = Integer.parseInt(partsOfDataPeriodStartDate[0]) - 1;
 
316
        String lastDataPeriodStartDate = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
 
317
        
 
318
        int tempForMonth1 = Integer.parseInt(partsOfDataPeriodStartDate[1]);
 
319
        int tempForYear = 0;
 
320
                
 
321
    if(tempForMonth1 < 4)       {   tempForYear = lastYear;  }
 
322
        else  {   tempForYear = lastYear + 1;           }
 
323
    
 
324
    String tempForMonth2 = "";
 
325
    if(tempForMonth1-1 ==0) tempForMonth2 = "-"+(tempForMonth1-1)+"-01";
 
326
    else if(tempForMonth1-1 <= 9) {tempForMonth2 = "-0"+(tempForMonth1-1)+"-01";}
 
327
    else tempForMonth2 = "-"+(tempForMonth1-1)+"-01";   
 
328
 
 
329
        String curYearStart = tempForYear+"-04-01";
 
330
        String lastYearStart = (tempForYear-1)+"-04-01";
 
331
        String lastYearEnd = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
 
332
        String curYearEnd = ""+partsOfDataPeriodStartDate[0]+""+tempForMonth2;
 
333
        
 
334
        String query="";
 
335
                     
 
336
%>
 
337
 
 
338
<html>
 
339
        <head>
 
340
                <title>Monthly Report on Non-Communicable Diseases</title>              
 
341
        </head>
 
342
        <body>          
 
343
                <center>
 
344
                        <font face="arial" size="3"><b>
 
345
                                &#2327;&#2376;&#2352;-&#2360;&#2306;&#2330;&#2366;&#2352;&#2368; &#2352;&#2379;&#2327; &#2325;&#2366; &#2350;&#2366;&#2360;&#2367;&#2325; &#2360;&#2306;&#2325;&#2354;&#2367;&#2340; &#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2344; ( &#2354;&#2367;&#2306;&#2327;&#2366;&#2344;&#2369;&#2360;&#2366;&#2352; &#2310;&#2325;&#2381;&#2352;&#2366;&#2306;&#2340; &#2319;&#2357;&#2306; &#2350;&#2372;&#2340;&#2381;&#2351;&#2369;) 
 
346
            &#2346;&#2381;&#2352;. &#2360;&#2381;&#2357;&#2366;. &#2325;&#2375;&#2306;. /&#2346;&#2381;&#2352;&#2326;&#2339;&#2381;&#2337; &#2325;&#2366;
 
347
                        </b></font> 
 
348
                </center>
 
349
                <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">
 
350
                        <tr style="border-collapse: collapse; border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; padding: 0" bordercolor="#111111" width="100%">
 
351
                        <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">
 
352
                                <font face="Arial" size="2">1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#2346;&#2381;&#2352;. 
 
353
                    &#2360;&#2381;&#2357;&#2366;. &#2325;&#2375;&#2306;. &#2325;&#2366; &#2344;&#2366;&#2350; :&nbsp;&nbsp;<%=selectedOrgUnitName%></font>
 
354
                </td>
 
355
                        <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">
 
356
                                <font face="Arial" size="2">2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2367;&#2340; &#2350;&#2366;&#2361; &#2319;&#2357;&#2306; &#2357;&#2352;&#2381;&#2359; :&nbsp;&nbsp;<%=monthNames[Integer.parseInt(partsOfDataPeriodStartDate[1])]%> - <%=partsOfDataPeriodStartDate[0]%> </font>
 
357
                </td>   
 
358
                </tr>
 
359
                <tr>
 
360
                        <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">
 
361
                                <font face="Arial" size="2">3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#2346;&#2381;&#2352;&#2326;&#2339;&#2381;&#2337; &#2360;&#2381;&#2340;&#2381;&#2340;&#2352; &#2346;&#2352; &#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2367;&#2340; &#2325;&#2352;&#2344;&#2375; &#2357;&#2366;&#2354;&#2375; &#2360;&#2306;&#2360;&#2381;&#2341;&#2366;&#2344; &#2325;&#2368; &#2325;&#2369;&#2354; &#2360;&#2306;&#2326;&#2381;&#2351;&#2366;:</font>
 
362
                </td>
 
363
                        <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">
 
364
                                <font face="Arial" size="2">4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2367;&#2340; &#2350;&#2366;&#2361; &#2350;&#2375;&#2306; &#2346;&#2381;&#2352;&#2326;&#2339;&#2381;&#2337; &#2360;&#2381;&#2340;&#2381;&#2340;&#2352; &#2346;&#2352; &#2327;&#2376;&#2352;-&#2360;&#2306;&#2330;&#2366;&#2352;&#2368; &#2352;&#2379;&#2327; &#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2344; &#2313;&#2346;&#2360;&#2381;&#2341;&#2366;&#2346;&#2367;&#2340; &#2325;&#2352;&#2344;&#2375; &#2357;&#2366;&#2354;&#2379;&#2306; &#2325;&#2368; &#2325;&#2369;&#2354; &#2360;&#2306;&#2326;&#2381;&#2351;&#2366;&nbsp;&nbsp; :</font>
 
365
                </td>
 
366
                </tr>                           
 
367
                </table>  
 
368
                <br>
 
369
                <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
370
                        <tr>
 
371
                                <td width="2%"  align="center" rowspan="3"><font face="arial" size="2"><b>&#2325;&#2381;&#2352;&#2350; &#2360;&#2306;.</b></font></td>
 
372
                                <td width="18%" align="center"  rowspan="3"><font face="arial" size="2"><b>&#2327;&#2376;&#2352;-&#2360;&#2306;&#2330;&#2366;&#2352;&#2368; &#2352;&#2379;&#2327;&#2379;&#2306; &#2325;&#2366; &#2346;&#2381;&#2352;&#2325;&#2372;&#2340;&#2367;/ &#2360;&#2350;&#2370;&#2361;</td>
 
373
                                <td width="20%" align="center"  colspan="6"><font face="arial" size="2"><b>&#2327;&#2340; &#2350;&#2366;&#2361; &#2340;&#2325; &#2352;&#2379;&#2327;&#2379;&#2306; &#2319;&#2357;&#2306; &#2350;&#2372;&#2340;&#2381;&#2351;&#2369; &#2325;&#2368; &#2325;&#2369;&#2354; &#2360;&#2306;&#2326;&#2381;&#2351;&#2366;</b></font></td>
 
374
                                <td width="10%" align="center"  colspan="3"><font face="arial" size="2"><b>&#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2367;&#2340; &#2350;&#2366;&#2361; &#2350;&#2375;&#2306; &#2348;&#2366;&#2361;&#2381;&#2351; &#2352;&#2379;&#2327;&#2367;&#2351;&#2379;&#2306; &#2325;&#2368; &#2360;&#2306;&#2326;&#2381;&#2351;&#2366;</b></font></td>
 
375
                                <td width="10%" align="center"  colspan="3"><font face="arial" size="2"><b>&#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2367;&#2340; &#2350;&#2366;&#2361; &#2350;&#2375;&#2306; &#2309;&#2306;&#2340;: &#2352;&#2379;&#2327;&#2367;&#2351;&#2379;&#2306; &#2325;&#2368; &#2360;&#2306;&#2326;&#2381;&#2351;&#2366;</b></font></td>
 
376
                                <td width="10%" align="center"  colspan="3"><font face="arial" size="2"><b>&#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2367;&#2340; &#2350;&#2366;&#2361; &#2350;&#2375;&#2306; &#2325;&#2369;&#2354; &#2352;&#2379;&#2327;&#2368;&#2351;&#2379;&#2306; &#2325;&#2368; &#2360;&#2306;&#2326;&#2381;&#2351;&#2366;</b></font></td>
 
377
                                <td width="10%" align="center"  colspan="3"><font face="arial" size="2"><b>&#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2367;&#2340; &#2350;&#2366;&#2361; &#2350;&#2375;&#2306; &#2350;&#2371;&#2340;&#2381;&#2351; &#2352;&#2379;&#2327;&#2368;&#2351;&#2379;&#2306; &#2325;&#2368; &#2360;&#2306;&#2326;&#2381;&#2351;&#2366;</b></font></td>
 
378
                                <td width="20%" align="center"  colspan="6"><font face="arial" size="2"><b>&#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2367;&#2340; &#2350;&#2366;&#2361; &#2325;&#2375; &#2309;&#2306;&#2340; &#2350;&#2375;&#2306; &#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2367;&#2340; &#2352;&#2379;&#2327;&#2379;&#2306; &#2319;&#2357;&#2306; &#2350;&#2372;&#2340;&#2381;&#2351;&#2369; &#2325;&#2368; &#2325;&#2369;&#2354; &#2360;&#2306;&#2326;&#2381;&#2351;&#2366;</b></font></td>
 
379
                        </tr>
 
380
                        <tr>
 
381
                                <td width="10%"  align="center"  colspan="3"><font face="arial" size="2"><b>&#2352;&#2379;&#2327;&#2368;</b></font></td>
 
382
                                <td width="10%"  align="center"  colspan="3"><font face="arial" size="2"><b>&#2350;&#2372;&#2340;&#2381;&#2351;&#2369; </b></font></td>
 
383
                                <td width="10%"  align="center" colspan="3"><font face="arial" size="2"><b>&#2344;&#2351;&#2375; &#2352;&#2379;&#2327;&#2368;</b></font></td>
 
384
                                <td width="10%"  align="center" colspan="3"><font face="arial" size="2"><b>&#2344;&#2351;&#2375; &#2352;&#2379;&#2327;&#2368;</b></font></td>
 
385
                                <td width="10%"  align="center" colspan="3"><font face="arial" size="2"><b>&#2352;&#2379;&#2327;&#2368;</b></font></td>
 
386
                                <td width="10%"  align="center" colspan="3"><font face="arial" size="2"><b>&nbsp;</b></font></td>
 
387
                                <td width="10%"  align="center" colspan="3"><font face="arial" size="2"><b>&#2352;&#2379;&#2327;&#2368;</b></font></td>
 
388
                                <td width="10%"  align="center" colspan="3"><font face="arial" size="2"><b>&#2350;&#2372;&#2340;&#2381;&#2351;&#2369;</b></font></td>
 
389
                        </tr>
 
390
                        <tr>
 
391
                        <td width="3%" align="center" ><font face="arial" size="2"><b>&#2346;&#2369;.</b></font></td>
 
392
                        <td width="3%" align="center" ><font face="arial" size="2"><b>&#2350;.</b></font></td>
 
393
                        <td width="4%" align="center" ><font face="arial" size="2"><b>&#2351;&#2379;&#2327; </b></font></td>
 
394
                        <td width="3%" align="center" ><font face="arial" size="2"><b>&#2346;&#2369;.</b></font></td>
 
395
                        <td width="3%" align="center" ><font face="arial" size="2"><b>&#2350;.</b></font></td>
 
396
                        <td width="4%" align="center" ><font face="arial" size="2"><b>&#2351;&#2379;&#2327; </b></font></td>
 
397
                        <td width="3%" align="center" ><font face="arial" size="2"><b>&#2346;&#2369;.</b></font></td>
 
398
                        <td width="3%" align="center" ><font face="arial" size="2"><b>&#2350;.</b></font></td>
 
399
                        <td width="4%" align="center" ><font face="arial" size="2"><b>&#2351;&#2379;&#2327; </b></font></td>
 
400
                        <td width="3%" align="center" ><font face="arial" size="2"><b>&#2346;&#2369;.</b></font></td>
 
401
                        <td width="3%" align="center" ><font face="arial" size="2"><b>&#2350;.</b></font></td>
 
402
                        <td width="4%" align="center" ><font face="arial" size="2"><b>&#2351;&#2379;&#2327; </b></font></td>
 
403
                        <td width="3%" align="center" ><font face="arial" size="2"><b>&#2346;&#2369;.</b></font></td>
 
404
                        <td width="3%" align="center" ><font face="arial" size="2"><b>&#2350;.</b></font></td>
 
405
                        <td width="4%" align="center" ><font face="arial" size="2"><b>&#2351;&#2379;&#2327; </b></font></td>
 
406
                        <td width="3%" align="center" ><font face="arial" size="2"><b>&#2346;&#2369;.</b></font></td>
 
407
                        <td width="3%" align="center" ><font face="arial" size="2"><b>&#2350;.</b></font></td>
 
408
                        <td width="4%" align="center" ><font face="arial" size="2"><b>&#2351;&#2379;&#2327; </b></font></td>
 
409
                        <td width="3%" align="center" ><font face="arial" size="2"><b>&#2346;&#2369;.</b></font></td>
 
410
                        <td width="3%" align="center" ><font face="arial" size="2"><b>&#2350;.</b></font></td>
 
411
                        <td width="4%" align="center" ><font face="arial" size="2"><b>&#2351;&#2379;&#2327; </b></font></td>
 
412
                        <td width="3%" align="center" ><font face="arial" size="2"><b>&#2346;&#2369;.</b></font></td>
 
413
                        <td width="3%" align="center" ><font face="arial" size="2"><b>&#2350;.</b></font></td>
 
414
                        <td width="4%" align="center" ><font face="arial" size="2"><b>&#2351;&#2379;&#2327; </b></font></td>
 
415
                        </tr>
 
416
                        <tr>
 
417
                        <td width="2%"  align="center" rowspan="2"><font face="arial" size="1"><b>1</b></font></td>
 
418
                        <td width="18%"  align="center" rowspan="2"><font face="arial" size="1"><b>2</b></font></td>
 
419
                        <td width="3%"  align="center" rowspan="2"><font face="arial" size="1"><b>3</b></font></td>
 
420
                        <td width="3%"  align="center" rowspan="2"><font face="arial" size="1"><b>4</b></font></td>
 
421
                        <td width="4%"  align="center" rowspan="2"><font face="arial" size="1"><b>5</b></font></td>
 
422
                        <td width="3%"  align="center" rowspan="2"><font face="arial" size="1"><b>6</b></font></td>
 
423
                        <td width="3%"  align="center" rowspan="2"><font face="arial" size="1"><b>7</b></font></td>
 
424
                        <td width="4%"  align="center" rowspan="2"><font face="arial" size="1"><b>8</b></font></td>
 
425
                        <td width="3%"  align="center" rowspan="2"><font face="arial" size="1"><b>9</b></font></td>
 
426
                        <td width="3%"  align="center" rowspan="2"><font face="arial" size="1"><b>10</b></font></td>
 
427
                        <td width="4%"  align="center" rowspan="2"><font face="arial" size="1"><b>11</b></font></td>
 
428
                        <td width="3%"  align="center" rowspan="2"><font face="arial" size="1"><b>12</b></font></td>
 
429
                        <td width="3%"  align="center" rowspan="2"><font face="arial" size="1"><b>13</b></font></td>
 
430
                        <td width="4%"  align="center" rowspan="2"><font face="arial" size="1"><b>14</b></font></td>
 
431
                        <td width="3%" align="center" ><font face="arial" size="1"><b>15</b></font></td>
 
432
                        <td width="3%" align="center" ><font face="arial" size="1"><b>16</b></font></td>
 
433
                        <td width="4%" align="center" ><font face="arial" size="1"><b>17</b></font></td>
 
434
                        <td width="3%" align="center" rowspan="2"><font face="arial" size="1"><b>18</b></font></td>
 
435
                        <td width="3%"  align="center" rowspan="2"><font face="arial" size="1"><b>19</b></font></td>
 
436
                        <td width="4%" align="center"  rowspan="2"><font face="arial" size="1"><b>20</b></font></td>
 
437
                        <td width="3%" align="center" ><font face="arial" size="1"><b>21</b></font></td>
 
438
                        <td width="3%" align="center" ><font face="arial" size="1"><b>22</b></font></td>
 
439
                        <td width="4%" align="center" ><font face="arial" size="1"><b>23</b></font></td>
 
440
                        <td width="3%" align="center" ><font face="arial" size="1"><b>24</b></font></td>
 
441
                        <td width="3%" align="center" ><font face="arial" size="1"><b>25</b></font></td>
 
442
                        <td width="4%" align="center" ><font face="arial" size="1"><b>26</b></font></td>
 
443
                        </tr>
 
444
                        <tr>
 
445
                        <td width="3%" align="center" ><font face="arial" size="1"><b>9+12</b></font></td>
 
446
                        <td width="3%" align="center" ><font face="arial" size="1"><b>10+13</b></font></td>
 
447
                        <td width="4%" align="center" ><font face="arial" size="1"><b>11+14</b></font></td>
 
448
                        <td width="3%" align="center" ><font face="arial" size="1"><b>3+15</b></font></td>
 
449
                        <td width="3%" align="center" ><font face="arial" size="1"><b>4+16</b></font></td>
 
450
                        <td width="4%" align="center" ><font face="arial" size="1"><b>5+17</b></font></td>
 
451
                        <td width="3%" align="center" ><font face="arial" size="1"><b>6+18</b></font></td>
 
452
                        <td width="3%" align="center" ><font face="arial" size="1"><b>7+19</b></font></td>
 
453
                        <td width="4%" align="center" ><font face="arial" size="1"><b>8+20</b></font></td>
 
454
                        </tr>
 
455
                        
 
456
                        <%
 
457
                        
 
458
                                try
 
459
                                {
 
460
                                  count = 0;
 
461
                                  int k=0;
 
462
                                  while(count < 19)
 
463
                                   {                               
 
464
                                    if(count==0 || count ==3 || count ==6 || count==9 || count==13)
 
465
                                     {%>
 
466
                                     
 
467
                                        <tr>
 
468
                                                <td width="2%"><font face="arial" size="2"><%=nonCommDisNo[count]%></font>&nbsp;</td>
 
469
                                                <td width="98%" colspan="25"><font face="arial" size="1"><%=nonCommDisNames[count]%></font>&nbsp;</td>
 
470
                                                </tr>
 
471
                                     
 
472
                                     <%}
 
473
                                    else
 
474
                                     {                                                                             
 
475
                                           // 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 '"+curYearStart+"' and '"+selectedDataPeriodStartDate+"' and periodType = "+periodTypeID+") AND datavalue.source in (select id from organisationunit where parent ="+selectedOrgUnitID+") AND dataelement.code like '"+monthlyDataElements[k]+"'"
 
476
 
 
477
                                                for(i=0;i<12;i++)
 
478
                                                        {
 
479
                                                           if(i>=0 && i<=5)
 
480
                                                              //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 '"+curYearStart+"' and '"+curYearEnd+"' and periodType = "+periodTypeID+") AND datavalue.source ="+selectedOrgUnitID+" AND dataelement.code like '"+monthlyDataElements[k]+"'";
 
481
                                                              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 '"+curYearStart+"' and '"+curYearEnd+"' and periodtypeid = "+periodTypeID+") AND datavalue.sourceid ="+selectedOrgUnitID+" AND dataelement.code like '"+monthlyDataElements[k]+"'";
 
482
                                                           else 
 
483
                                                                        //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 ="+selectedOrgUnitID+" AND dataelement.code like '"+monthlyDataElements[k]+"'";
 
484
                                                                        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 ="+selectedOrgUnitID+" AND dataelement.code like '"+monthlyDataElements[k]+"'";                   
 
485
                                                           
 
486
                                                           rs3 = st3.executeQuery(query);
 
487
 
 
488
                                                        //      SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataElement = dataelement.id WHERE datavalue.period ="+selectedDataPeriodID+" AND datavalue.source in (select id from organisationunit where parent ="+selectedOrgUnitID+") AND dataelement.code like '"+monthlyDataElements[k]+"'");
 
489
                                                                                                                                                
 
490
                                                                if(!rs3.next())  {  tempval[i] = 0;      }
 
491
                                                                else   {  tempval[i] = rs3.getInt(1);  }
 
492
                                                                total[i] += tempval[i];
 
493
                                                                k++;
 
494
                                                        } // for loop end       
 
495
                                                
 
496
                                                                                                                                     
 
497
                                        %>
 
498
                                     
 
499
                                        <tr>
 
500
                                                <td width="2%"><font face="arial" size="2"><%=nonCommDisNo[count]%></font>&nbsp;</td>
 
501
                                                        <td width="18%"><font face="arial" size="1"><%=nonCommDisNames[count]%></font>&nbsp;</td>
 
502
                                                <td width="3%" align="center" ><font face="arial" size="2"><%=(tempval[0]+tempval[1])%></font>&nbsp;</td>
 
503
                                                <td width="3%" align="center" ><font face="arial" size="2"><%=(tempval[2]+tempval[3])%></font>&nbsp;</td>
 
504
                                                <td width="4%" align="center" ><font face="arial" size="2"><%=(tempval[0]+tempval[1]+tempval[2]+tempval[3])%></font>&nbsp;</td>
 
505
                                                <td width="3%" align="center" ><font face="arial" size="2"><%=tempval[4]%></font>&nbsp;</td>
 
506
                                                <td width="3%" align="center" ><font face="arial" size="2"><%=tempval[5]%></font>&nbsp;</td>
 
507
                                                <td width="4%" align="center" ><font face="arial" size="2"><%=(tempval[4]+tempval[5])%></font>&nbsp;</td>
 
508
                                                <td width="3%" align="center" ><font face="arial" size="2"><%=tempval[6]%></font>&nbsp;</td>
 
509
                                                <td width="3%" align="center" ><font face="arial" size="2"><%=tempval[7]%></font>&nbsp;</td>
 
510
                                                <td width="4%" align="center" ><font face="arial" size="2"><%=(tempval[6]+tempval[7])%></font>&nbsp;</td>
 
511
                                                <td width="3%" align="center" ><font face="arial" size="2"><%=tempval[8]%></font>&nbsp;</td>
 
512
                                                <td width="3%" align="center" ><font face="arial" size="2"><%=tempval[9]%></font>&nbsp;</td>
 
513
                                                <td width="4%" align="center" ><font face="arial" size="2"><%=(tempval[8]+tempval[9])%></font>&nbsp;</td>
 
514
                                                <td width="3%" align="center" ><font face="arial" size="2"><%=(tempval[6]+tempval[8])%></font>&nbsp;</td>
 
515
                                                <td width="3%" align="center" ><font face="arial" size="2"><%=(tempval[7]+tempval[9])%></font>&nbsp;</td>
 
516
                                                <td width="4%" align="center" ><font face="arial" size="2"><%=(tempval[6]+tempval[7]+tempval[8]+tempval[9])%></font>&nbsp;</td>
 
517
                                                <td width="3%" align="center" ><font face="arial" size="2"><%=tempval[10]%></font>&nbsp;</td>
 
518
                                                <td width="3%" align="center" ><font face="arial" size="2"><%=tempval[11]%></font>&nbsp;</td>
 
519
                                                        <td width="4%" align="center" ><font face="arial" size="2"><%=(tempval[10]+tempval[11])%></font>&nbsp;</td>
 
520
                                                <td width="3%" align="center" ><font face="arial" size="2"><%=(tempval[0]+tempval[1]+tempval[6]+tempval[8])%></font>&nbsp;</td>
 
521
                                                <td width="3%" align="center" ><font face="arial" size="2"><%=(tempval[2]+tempval[3]+tempval[7]+tempval[9])%></font>&nbsp;</td>
 
522
                                                <td width="4%" align="center" ><font face="arial" size="2"><%=(tempval[0]+tempval[1]+tempval[2]+tempval[3]+tempval[6]+tempval[7]+tempval[8]+tempval[9])%></font>&nbsp;</td>
 
523
                                                <td width="3%" align="center" ><font face="arial" size="2"><%=(tempval[4]+tempval[10])%></font>&nbsp;</td>
 
524
                                                <td width="3%" align="center" ><font face="arial" size="2"><%=(tempval[5]+tempval[11])%></font>&nbsp;</td>
 
525
                                                <td width="4%" align="center" ><font face="arial" size="2"><%=(tempval[4]+tempval[5]+tempval[10]+tempval[11])%></font>&nbsp;</td>
 
526
                                                </tr>                                
 
527
                                     
 
528
                                     <%} // else block end                                                                                                              
 
529
                                 count++;
 
530
                                   } // while loop end
 
531
                          } // try block end
 
532
                        catch(Exception e)  { out.println(e.getMessage());  }
 
533
                finally
 
534
                 {
 
535
                                try
 
536
                                 {
 
537
                                        if(rs1!=null)  rs1.close();             if(st1!=null)  st1.close();
 
538
                                        if(rs2!=null)  rs2.close();             if(st2!=null)  st2.close();
 
539
                                        if(rs3!=null)  rs3.close();             if(st3!=null)  st3.close(); 
 
540
                                        if(rs4!=null)  rs4.close();             if(st4!=null)  st4.close(); 
 
541
                                        if(rs5!=null)  rs5.close();             if(st5!=null)  st5.close();                                     
 
542
                                        
 
543
                                        if(con!=null)  con.close();
 
544
                                 }
 
545
                                catch(Exception e)   {  out.println(e.getMessage());   }
 
546
                 } // finally block end                                 
 
547
                %>
 
548
                
 
549
                <tr>
 
550
                                <td width="20%" align="center" colspan="2"><font face="arial" size="2">&#2351;&#2379;&#2327;</font></td>
 
551
                                <td width="3%" align="center" ><font face="arial" size="2"><%=(total[0]+total[1])%></font>&nbsp;</td>
 
552
                                <td width="3%" align="center" ><font face="arial" size="2"><%=(total[2]+total[3])%></font>&nbsp;</td>
 
553
                                <td width="4%" align="center" ><font face="arial" size="2"><%=(total[0]+total[1]+total[2]+total[3])%></font>&nbsp;</td>
 
554
                                <td width="3%" align="center" ><font face="arial" size="2"><%=total[4]%></font>&nbsp;</td>
 
555
                                <td width="3%" align="center" ><font face="arial" size="2"><%=total[5]%></font>&nbsp;</td>
 
556
                                <td width="4%" align="center" ><font face="arial" size="2"><%=(total[4]+total[5])%></font>&nbsp;</td>
 
557
                                <td width="3%" align="center" ><font face="arial" size="2"><%=total[6]%></font>&nbsp;</td>
 
558
                                <td width="3%" align="center" ><font face="arial" size="2"><%=total[7]%></font>&nbsp;</td>
 
559
                                <td width="4%" align="center" ><font face="arial" size="2"><%=(total[6]+total[7])%></font>&nbsp;</td>
 
560
                                <td width="3%" align="center" ><font face="arial" size="2"><%=total[8]%></font>&nbsp;</td>
 
561
                                <td width="3%" align="center" ><font face="arial" size="2"><%=total[9]%></font>&nbsp;</td>
 
562
                                <td width="4%" align="center" ><font face="arial" size="2"><%=(total[8]+total[9])%></font>&nbsp;</td>
 
563
                                <td width="3%" align="center" ><font face="arial" size="2"><%=(total[6]+total[8])%></font>&nbsp;</td>
 
564
                                <td width="3%" align="center" ><font face="arial" size="2"><%=(total[7]+total[9])%></font>&nbsp;</td>
 
565
                                <td width="4%" align="center" ><font face="arial" size="2"><%=(total[6]+total[7]+total[8]+total[9])%></font>&nbsp;</td>
 
566
                                <td width="3%" align="center" ><font face="arial" size="2"><%=total[10]%></font>&nbsp;</td>
 
567
                                <td width="3%" align="center" ><font face="arial" size="2"><%=total[11]%></font>&nbsp;</td>
 
568
                                <td width="4%" align="center" ><font face="arial" size="2"><%=(total[10]+total[11])%></font>&nbsp;</td>
 
569
                                <td width="3%" align="center" ><font face="arial" size="2"><%=(total[0]+total[1]+total[6]+total[8])%></font>&nbsp;</td>
 
570
                                <td width="3%" align="center" ><font face="arial" size="2"><%=(total[2]+total[3]+total[7]+total[9])%></font>&nbsp;</td>
 
571
                                <td width="4%" align="center" ><font face="arial" size="2"><%=(total[0]+total[1]+total[2]+total[3]+total[6]+total[7]+total[8]+total[9])%></font>&nbsp;</td>
 
572
                                <td width="3%" align="center" ><font face="arial" size="2"><%=(total[4]+total[10])%></font>&nbsp;</td>
 
573
                                <td width="3%" align="center" ><font face="arial" size="2"><%=(total[5]+total[11])%></font>&nbsp;</td>
 
574
                                <td width="4%" align="center" ><font face="arial" size="2"><%=(total[4]+total[5]+total[10]+total[11])%></font>&nbsp;</td>
 
575
                        </tr>                                                                           
 
576
                </table>
 
577
        </body>
 
578
</html>
 
 
b'\\ No newline at end of file'