← Back to branch summary

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

« back to all changes in this revision

Viewing changes to local/et/dhis-web-ethiopia/src/main/webapp/dhis-web-reports/Ethiopia/rptLAB.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/et/dhis-web-ethiopia/src/main/webapp/dhis-web-reports/Ethiopia/rptLAB.jsp
 
1
 
 
2
<%@ page import="java.sql.*" %>
 
3
<%@ page import="java.util.*" %>
 
4
<%@ page import="com.opensymphony.xwork.util.OgnlValueStack" %>
 
5
 
 
6
<%@ page session="true" %>
 
7
 
 
8
<%
 
9
 
 
10
   Connection con=null;            
 
11
    Statement st1=null;
 
12
    ResultSet rs1=null;      
 
13
  
 
14
    String userName = "root";      
 
15
    String password = "";           
 
16
    String urlForConnection = "jdbc:mysql://localhost/dhis2";  
 
17
    
 
18
        int orgUnitId = 16;
 
19
        String orgUnitName="";  
 
20
        int periodId = 204;
 
21
        int parentId=0;
 
22
        String parentName=null;
 
23
        String startDate="";
 
24
        String endDate="";
 
25
OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
 
26
          String selectedId = (String) stack.findValue( "orgUnitId" );
 
27
          orgUnitId = Integer.parseInt( selectedId );
 
28
        
 
29
          String selectedPeriodId = (String) stack.findValue( "periodSelect" );
 
30
          periodId = Integer.parseInt( selectedPeriodId );
 
31
  
 
32
    int[] noutpM= new int[100];
 
33
        int[] noutpF= new int[100];
 
34
        
 
35
        int[] noutnM= new int[100];
 
36
        int[] noutnF= new int[100];
 
37
        
 
38
        int[] ninpM= new int[100];
 
39
        int[] ninpF= new int[100];
 
40
        
 
41
        int[] ninnM= new int[100];
 
42
        int[] ninnF= new int[100];
 
43
        
 
44
        int[] ootherM=new int[100];
 
45
        int[] ootherF=new int[100];
 
46
        
 
47
        int[] iotherM=new int[100];
 
48
        int[] iotherF=new int[100];
 
49
        
 
50
        
 
51
        
 
52
        //int[] sn= {1,2,3,4,5,6,7};
 
53
        String[] lab1= {"Stool and Other Parasite Test","Bacteriology"," ","Urinalysis","Hematology"," "," "," ","Serology"," "," "," "," ","Clinical Chemistry","Others","Total"};
 
54
        String[] lab2= {" ","Sputum for AFB","Others"," ","Blood Film","Malaria","Relapsing Fever","Others","HIV Screened","VDRL","WIDAL","WELIFELX","Others"," "," "," "};
 
55
        
 
56
        
 
57
        //String[] no={"1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17"};
 
58
 
 
59
        //String[] type_of_test= {"Stool and Other parasite test","Bacteriology sputum for AFB"," Bacteriology sputum for Others","Urinalysis","Pregnancy Test","Hematology Blood Film","Hematology Malaria","Hematolgy Relapsing Fever","Hematology Others","Serology VDRL","Serology WIDAL","Serology WEILFELX","Serology Others","Chemistry","HIV screened","Others","Total"};
 
60
        
 
61
        int [] deint1={1361,1328,1375,1387,1283,2619,1324,1399,2643,1348,1357,1353,1311,1412,1424};
 
62
        int [] deint2={1362,1326,1378,1388,1282,2620,1322,1307,2644,1346,1358,1354,1312,1414,1425};
 
63
        int [] deint3={1363,1332,1376,1389,1269,2622,2631,1400,2645,1352,1359,1355,1313,1415,1428};
 
64
        int [] deint4={1364,1330,1377,1390,1284,2621,2632,1308,2646,1350,1360,1356,1314,1413,1429};
 
65
        int [] deint5={1365,2618,1379,1391,2639,2623,2635,1309,2647,2655,2459,2667,2675,1418,1426};
 
66
        int [] deint6={1367,2617,1380,1392,2640,2624,2636,1310,2648,2656,2660,2668,2676,1416,1427};
 
67
        int [] deint7={1370,1327,1381,1393,1279,2625,1323,1405,2649,1347,2661,2669,2677,1420,1430};
 
68
        int [] deint8={1369,1325,1382,1394,1278,2626,1321,1406,2650,1345,2662,2670,2678,1422,1431};
 
69
        int [] deint9={1371,1331,1385,1395,1281,2627,2633,1408,2651,1351,2663,2671,2679,1419,1432};
 
70
        int [] deint10={1372,1329,1386,1396,1290,2630,2634,1409,2652,1349,2664,2672,2680,1421,1433};
 
71
        int [] deint11={1373,2616,1383,1398,2641,2628,2637,1407,2653,2657,2665,2673,2651,1423,1434};
 
72
        int [] deint12={1374,2615,1384,1397,2642,2629,2638,1410,2654,2658,2666,2674,2682,1624,1435};
 
73
        
 
74
        
 
75
        int i=0;
 
76
        String sql;
 
77
     try
 
78
      {
 
79
        Class.forName ("com.mysql.jdbc.Driver");
 
80
        con = DriverManager.getConnection (urlForConnection, userName, password);
 
81
        st1=con.createStatement();
 
82
          
 
83
                
 
84
                sql = "select value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
85
                sql+=" and dataelement in (1361,1328,1375,1387,1283,2619,1324,1399,2643,1348,1357,1353,1311,1412,1424)";                
 
86
        rs1 = st1.executeQuery(sql);                                    
 
87
          
 
88
       if (rs1.next())
 
89
        {
 
90
            for(i=0;i<15;i++)
 
91
            {
 
92
                        rs1.beforeFirst();
 
93
                        nextde=true;
 
94
                        while (rs1.next() && nextde)
 
95
                        {
 
96
                        if (deint1[i]==(rs1.getInt("dataelement")))
 
97
                        {
 
98
                noutpM[i]=rs1.getInt("value");                          
 
99
                nextde=false;
 
100
            }
 
101
                        }
 
102
                        }
 
103
         }
 
104
                //geting orguntname
 
105
                sql = "select name,parent from organizationunit where id ="+orgUnitId ;
 
106
            rs1 = st1.executeQuery(sql);  
 
107
         if (rs1.next())
 
108
        {
 
109
           orgUnitName=rs1.getString("name");
 
110
                   parentId=rs1.getInt("parent");                               
 
111
            }
 
112
                
 
113
                sql = "select name from organizationunit where id="+parentId;
 
114
                rs1 = st1.executeQuery(sql);
 
115
                if (rs1.next())
 
116
                {
 
117
                        parentName=rs1.getString("name");
 
118
                }
 
119
                
 
120
            sql = "select startDate,endDate from period where id ="+periodId ;
 
121
            rs1 = st1.executeQuery(sql);  
 
122
         if (rs1.next())
 
123
        {
 
124
           startDate=rs1.getString("startDate");                                
 
125
           endDate=rs1.getString("endDate");                            
 
126
 
 
127
            }
 
128
            //end getting 
 
129
           
 
130
                sql = "select value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
131
                sql+=" and dataelement in (1362,1326,1378,1388,1282,2620,1322,1307,2644,1346,1358,1354,1312,1414,1425)";                
 
132
        rs1 = st1.executeQuery(sql);  
 
133
          
 
134
       if (rs1.next())
 
135
        {
 
136
            for(i=0;i<15;i++)
 
137
            {
 
138
                        rs1.beforeFirst();
 
139
                        nextde=true;
 
140
                        while (rs1.next() && nextde)
 
141
                        {
 
142
                        if (deint2[i]==(rs1.getInt("dataelement")))
 
143
                        {
 
144
                noutpF[i]=rs1.getInt("value");                          
 
145
                nextde=false;
 
146
            }
 
147
                        }
 
148
                        }
 
149
         }
 
150
                    
 
151
                   sql = "select value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
152
                sql+=" and dataelement in (1363,1332,1376,1389,1269,2622,2631,1400,2645,1352,1359,1355,1313,1415,1428)";                
 
153
        rs1 = st1.executeQuery(sql);
 
154
          
 
155
       if (rs1.next())
 
156
        {
 
157
            for(i=0;i<15;i++)
 
158
            {
 
159
                        rs1.beforeFirst();
 
160
                        nextde=true;
 
161
                        while (rs1.next() && nextde)
 
162
                        {
 
163
                        if (deint3[i]==(rs1.getInt("dataelement")))
 
164
                        {
 
165
                noutnM[i]=rs1.getInt("value");                          
 
166
                nextde=false;
 
167
            }
 
168
                        }
 
169
                        }
 
170
         }
 
171
 
 
172
        
 
173
        
 
174
                   
 
175
                   sql = "select value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
176
                sql+=" and dataelement in (1364,1330,1377,1390,1284,2621,2632,1308,2646,1350,1360,1356,1314,1413,1429)";                
 
177
        rs1 = st1.executeQuery(sql);                                    
 
178
          
 
179
       if (rs1.next())
 
180
        {
 
181
            for(i=0;i<15;i++)
 
182
            {
 
183
                        rs1.beforeFirst();
 
184
                        nextde=true;
 
185
                        while (rs1.next() && nextde)
 
186
                        {
 
187
                        if (deint4[i]==(rs1.getInt("dataelement")))
 
188
                        {
 
189
                noutnF[i]=rs1.getInt("value");                          
 
190
                nextde=false;
 
191
                        }
 
192
                        }
 
193
            }
 
194
         }
 
195
 
 
196
                   sql = "select value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
197
                sql+=" and dataelement in (1365,2618,1379,1391,2639,2623,2635,1309,2647,2655,2459,2667,2675,1418,1426)";                
 
198
        rs1 = st1.executeQuery(sql);  
 
199
          
 
200
        if (rs1.next())
 
201
        {
 
202
            for(i=0;i<15;i++)
 
203
            {
 
204
                        rs1.beforeFirst();
 
205
                        nextde=true;
 
206
                        while (rs1.next() && nextde)
 
207
                        {
 
208
                        if (deint5[i]==(rs1.getInt("dataelement")))
 
209
                        {
 
210
                ootherM[i]=rs1.getInt("value");                         
 
211
                nextde=false;
 
212
                        }
 
213
                        }
 
214
            }
 
215
         }
 
216
                                
 
217
                   sql = "select value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
218
                sql+=" and dataelement in (1367,2617,1380,1392,2640,2624,2636,1310,2648,2656,2660,2668,2676,1416,1427)";                
 
219
        rs1 = st1.executeQuery(sql); 
 
220
          
 
221
       if (rs1.next())
 
222
        {
 
223
            for(i=0;i<15;i++)
 
224
            {
 
225
                        rs1.beforeFirst();
 
226
                        nextde=true;
 
227
                        while (rs1.next() && nextde)
 
228
                        {
 
229
                        if (deint6[i]==(rs1.getInt("dataelement")))
 
230
                        {
 
231
                ootherF[i]=rs1.getInt("value");                         
 
232
                nextde=false;
 
233
                        }
 
234
                        }
 
235
            }
 
236
         }
 
237
                                
 
238
          
 
239
                   sql = "select value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
240
                   sql+=" and dataelement in (1370,1327,1381,1393,1279,2625,1323,1405,2649,1347,2661,2669,2677,1420,1430)";             
 
241
        rs1 = st1.executeQuery(sql);  
 
242
          
 
243
       if (rs1.next())
 
244
        {
 
245
            for(i=0;i<15;i++)
 
246
            {
 
247
                        rs1.beforeFirst();
 
248
                        nextde=true;
 
249
                        while (rs1.next() && nextde)
 
250
                        {
 
251
                        if (deint7[i]==(rs1.getInt("dataelement")))
 
252
                        {
 
253
                ninpM[i]=rs1.getInt("value");                           
 
254
                nextde=false;
 
255
                        }
 
256
                        }
 
257
            }
 
258
         }
 
259
                                
 
260
          
 
261
                   sql = "select value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
262
                sql+=" and dataelement in (1369,1325,1382,1394,1278,2626,1321,1406,2650,1345,2662,2670,2678,1422,1431)";                
 
263
        rs1 = st1.executeQuery(sql);                                    
 
264
          
 
265
       if (rs1.next())
 
266
        {
 
267
            for(i=0;i<15;i++)
 
268
            {
 
269
                        rs1.beforeFirst();
 
270
                        nextde=true;
 
271
                        while (rs1.next() && nextde)
 
272
                        {
 
273
                        if (deint8[i]==(rs1.getInt("dataelement")))
 
274
                        {
 
275
                ninpF[i]=rs1.getInt("value");                           
 
276
                nextde=false;
 
277
                        }
 
278
                        }
 
279
            }
 
280
         }
 
281
         
 
282
         
 
283
         
 
284
 
 
285
           sql = "select value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
286
                sql+=" and dataelement in (1371,1331,1385,1395,1281,2627,2633,1408,2651,1351,2663,2671,2679,1419,1432)";                
 
287
        rs1 = st1.executeQuery(sql);                                    
 
288
     
 
289
          
 
290
       if (rs1.next())
 
291
        {
 
292
            for(i=0;i<15;i++)
 
293
            {
 
294
                        rs1.beforeFirst();
 
295
                        nextde=true;
 
296
                        while (rs1.next() && nextde)
 
297
                        {
 
298
                        if (deint9[i]==(rs1.getInt("dataelement")))
 
299
                        {
 
300
                ninnM[i]=rs1.getInt("value");
 
301
                                nextde=false;
 
302
                        }
 
303
                        }
 
304
                        }        
 
305
            
 
306
         }
 
307
     
 
308
  sql = "select value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
309
                sql+=" and dataelement in (1372,1329,1386,1396,1290,2630,2634,1409,2652,1349,2664,2672,2680,1421,1433)";                
 
310
        rs1 = st1.executeQuery(sql);                                    
 
311
     
 
312
          
 
313
       if (rs1.next())
 
314
        {
 
315
            for(i=0;i<15;i++)
 
316
            {
 
317
                        rs1.beforeFirst();
 
318
                        nextde=true;
 
319
                        while (rs1.next() && nextde)
 
320
                        {
 
321
                        if (deint10[i]==(rs1.getInt("dataelement")))
 
322
                        {
 
323
                ninnF[i]=rs1.getInt("value");
 
324
                                nextde=false;
 
325
                        }
 
326
                        }
 
327
                        }                               
 
328
         }
 
329
     
 
330
  sql = "select value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
331
                sql+=" and dataelement in (1373,2616,1383,1398,2641,2628,2637,1407,2653,2657,2665,2673,2651,1423,1434)";                
 
332
        rs1 = st1.executeQuery(sql);                                    
 
333
     
 
334
          
 
335
       if (rs1.next())
 
336
        {
 
337
            for(i=0;i<15;i++)
 
338
            {
 
339
                        rs1.beforeFirst();
 
340
                        nextde=true;
 
341
                        while (rs1.next() && nextde)
 
342
                        {
 
343
                        if (deint10[i]==(rs1.getInt("dataelement")))
 
344
                        {
 
345
                iotherM[i]=rs1.getInt("value");
 
346
                                nextde=false;
 
347
                        }
 
348
                        }
 
349
                        }                               
 
350
         }
 
351
     
 
352
  sql = "select value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
353
                sql+=" and dataelement in (1374,2615,1384,1397,2642,2629,2638,1410,2654,2658,2666,2674,2682,1624,1435)";                
 
354
        rs1 = st1.executeQuery(sql);                                    
 
355
     
 
356
          
 
357
       if (rs1.next())
 
358
        {
 
359
            for(i=0;i<15;i++)
 
360
            {
 
361
                        rs1.beforeFirst();
 
362
                        nextde=true;
 
363
                        while (rs1.next() && nextde)
 
364
                        {
 
365
                        if (deint12[i]==(rs1.getInt("dataelement")))
 
366
                        {
 
367
                iotherF[i]=rs1.getInt("value");
 
368
                                nextde=false;
 
369
                        }
 
370
                        }
 
371
                        }                               
 
372
         }
 
373
      
 
374
                for(int z=0;z<=14;z++){
 
375
                                noutpM[15]+=noutpM[z];
 
376
                                noutpF[15]+=noutpF[z];
 
377
                                noutnM[15]+=noutnM[z];
 
378
                                noutnF[15]+=noutnF[z];
 
379
                                ninpM[15]+=ninpM[z];
 
380
                                ninpF[15]+=ninpF[z];
 
381
                                ninnM[15]+=ninnM[z];
 
382
                                ninnF[15]+=ninnF[z];
 
383
                                ootherM[15]+=ootherM[z];
 
384
                                ootherF[15]+=ootherF[z];
 
385
                                iotherM[15]+=iotherM[z];
 
386
                                iotherF[15]+=iotherF[z];
 
387
                                }
 
388
   
 
389
                   
 
390
       } 
 
391
      catch(Exception e)  { out.println("Loi cho ma gi day: "+e.getMessage());  }
 
392
      
 
393
%>
 
394
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 
395
<html>
 
396
<head>
 
397
<title>Untitled Document</title>
 
398
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
 
399
<link href="styles.css" rel="stylesheet" type="text/css">
 
400
<style type="text/css">
 
401
<!--
 
402
.style10 {font-family: Geneva, Arial, Helvetica, sans-serif}
 
403
-->
 
404
</style>
 
405
</head>
 
406
 
 
407
<body>
 
408
<table width="744" border="0" cellpadding="1" cellspacing="1">
 
409
  <!--DWLayoutTable-->
 
410
  <tr> 
 
411
    <td colspan="2" valign="top">
 
412
    <table width="651" border="0" cellpadding="1" cellspacing="1">
 
413
        <!--DWLayoutTable-->
 
414
        <tr> 
 
415
          <td width="665" height="54" valign="top">
 
416
          <table width="649" border="0" cellpadding="1" cellspacing="0">
 
417
              <!--DWLayoutTable-->
 
418
              <tr class="header"> 
 
419
                <td width="647" height="54" valign="top"  >&nbsp; Laboratory Test Report for <%=orgUnitName%></td>
 
420
              </tr>
 
421
            </table></td>
 
422
        </tr>
 
423
        <tr> 
 
424
          <td height="45" valign="top" width="665">
 
425
          <table width="650" border="0" cellpadding="1" cellspacing="1" bordercolor="#660000" class="header1" >
 
426
              <!--DWLayoutTable-->
 
427
              <tr bgcolor="#FFCCCC" class="header1"> 
 
428
                <td width="124" height="47" valign="top" class="header1" bgcolor="#008080"><div align="left">Region
 
429
                    
 
430
                </div>                </td>
 
431
               
 
432
                <td width="119" class="header1" bordercolor="#FF00FF" bgcolor="#008080"><%=parentName%></td>
 
433
                <td width="123" valign="top" class="header1" bgcolor="#008080" >OrgUnit</td>
 
434
                <td width="271" bgcolor="#008080"><%=orgUnitName %>&nbsp;</td>
 
435
              </tr>
 
436
            </table></td>
 
437
        </tr>
 
438
        <tr> 
 
439
          <td height="55" valign="top" width="665">
 
440
          <table width="648" border="0" cellpadding="1" cellspacing="1" class="header1">
 
441
              <!--DWLayoutTable-->
 
442
              <tr bgcolor="#FFCCCC"> 
 
443
                <td width="108" height="55" valign="top" class="header1" bgcolor="#008080"><div align="left">Period</div></td>
 
444
                <td width="106" valign="top" class="header1" bgcolor="#008080">From</td>
 
445
                <td width="94" bgcolor="#008080"><%=startDate %>&nbsp;</td>
 
446
                <td width="101" valign="top" class="header1" bgcolor="#008080">To</td>
 
447
                <td width="223" valign="top" class="header1" bgcolor="#008080"><%=endDate %>&nbsp;</td>
 
448
              </tr>
 
449
            </table></td>
 
450
        </tr>
 
451
        <tr> 
 
452
          <td height="515" valign="top" width="665">
 
453
          <table width="89%" border="0" cellpadding="0" cellspacing="0" height="141">
 
454
              <!--DWLayoutTable-->
 
455
              <tr> 
 
456
                <td width="555" height="123" valign="top">
 
457
                <table width="648" height="1" border="0" cellpadding="1" cellspacing="1" bgcolor="#000066">
 
458
                    <!--DWLayoutTable-->
 
459
                    <tr class="tableheader">
 
460
                      <td width="22" height="98" rowspan="4" valign="top" class="tableheader">
 
461
                     NO.</td>
 
462
                      <td width="214" height="98" rowspan="4" valign="top" class="tableheader" colspan="2">
 
463
                     Type Of Test</td>
 
464
                      <td height="1" colspan="27" valign="top" class="tableheader" width="526">
 
465
                      Number Of Test<p>&nbsp;</td>
 
466
                    </tr>
 
467
                    <tr class="tableheader">
 
468
                      <td height="1" colspan="12" valign="top" class="tableheader" width="138">
 
469
                      Out Patient</td>
 
470
                      <td height="1" colspan="15" valign="top" class="tableheader" width="388">
 
471
                      In Patient</td>
 
472
                    </tr>
 
473
                    <tr class="tableheader">
 
474
                      <td height="13" colspan="2" valign="top" class="tableheader" width="1">
 
475
                      Positive</td>
 
476
                      <td height="14" valign="top" class="tableheader" width="0" rowspan="2">
 
477
                      Total</td>
 
478
                      <td height="13" colspan="2" valign="top" class="tableheader" width="80">
 
479
                      Negative</td>
 
480
                      <td height="14" valign="top" class="tableheader" width="40" rowspan="2">
 
481
                      Total</td>
 
482
                      <td height="13" colspan="2" valign="top" class="tableheader" width="68">
 
483
                      Other</td>
 
484
                      <td height="14" valign="top" class="tableheader" width="34" rowspan="2">
 
485
                      Total</td>
 
486
                      <td height="13" colspan="3" valign="top" class="tableheader" width="50">
 
487
                      Outpatient Total</td>
 
488
                      <td height="13" colspan="2" valign="top" class="tableheader" width="104">
 
489
                      Positive</td>
 
490
                      <td height="14" valign="top" class="tableheader" width="52" rowspan="2">
 
491
                      Total</td>
 
492
                      <td height="13" colspan="2" valign="top" class="tableheader" width="64">
 
493
                      Negative</td>
 
494
                      <td height="14" valign="top" class="tableheader" width="16" rowspan="2">
 
495
                      Total</td>
 
496
                      <td height="7" colspan="2" valign="top" class="tableheader" width="12">
 
497
                      Other</td>
 
498
                      <td height="14" valign="top" class="tableheader" width="3" rowspan="2">
 
499
                      Total</td>
 
500
                      <td height="13" colspan="3" valign="top" class="tableheader" width="46">
 
501
                      Inpatient Total</td>
 
502
                      <td height="13" colspan="3" valign="top" class="tableheader" width="46">
 
503
                      Grand Total</td>
 
504
                    </tr>
 
505
                    <tr class="tableheader">
 
506
                      <td height="1" valign="top" class="tableheader" width="1">
 
507
                      M</td>
 
508
                      <td height="1" valign="top" class="tableheader" width="21">
 
509
                      F</td>
 
510
                      <td height="1" valign="top" class="tableheader" width="57">
 
511
                      M</td>
 
512
                      <td height="1" valign="top" class="tableheader" width="32">
 
513
                      F</td>
 
514
                      <td height="1" valign="top" class="tableheader" width="62">
 
515
                      M</td>
 
516
                      <td height="1" valign="top" class="tableheader" width="23">
 
517
                      F</td>
 
518
                      <td height="1" valign="top" class="tableheader" width="23">
 
519
                      M</td>
 
520
                      <td height="1" valign="top" class="tableheader" width="11">
 
521
                      F</td>
 
522
                      <td height="1" valign="top" class="tableheader" width="11">
 
523
                      T</td>
 
524
                      <td height="1" valign="top" class="tableheader" width="83">
 
525
                      M</td>
 
526
                      <td height="1" valign="top" class="tableheader" width="37">
 
527
                      F</td>
 
528
                      <td height="1" valign="top" class="tableheader" width="52">
 
529
                      M</td>
 
530
                      <td height="1" valign="top" class="tableheader" width="22">
 
531
                      F</td>
 
532
                      <td height="7" valign="top" class="tableheader" width="8">
 
533
                      M</td>
 
534
                      <td height="7" valign="top" class="tableheader" width="4">
 
535
                      F</td>
 
536
                      <td height="1" valign="top" class="tableheader" width="32">
 
537
                      M</td>
 
538
                      <td height="1" valign="top" class="tableheader" width="32">
 
539
                      F</td>
 
540
                      <td height="1" valign="top" class="tableheader" width="31">
 
541
                      T</td>
 
542
                      <td height="1" valign="top" class="tableheader" width="7">
 
543
                      M</td>
 
544
                      <td height="1" valign="top" class="tableheader" width="7">
 
545
                      F</td>
 
546
                      <td height="1" valign="top" class="tableheader" width="7">
 
547
                      GT</td>
 
548
                    </tr>
 
549
                    <tr class="tableheader">
 
550
                      </td> 
 
551
                    </tr>
 
552
                  <% for (int k=0;k<15;k++){%>
 
553
                    <tr bordercolor="#000000" class="tableitem">
 
554
                        <td width="22" height="30" valign="top" class="tableitem"><%=sn[k]%></td>
 
555
                    <% if (k==0 || k==1 || k==3 || k==4 || k==8 || k==13 || k==14 || k==15) {%><td width="11" height="30" valign="top" class="tableitem"><%=lab1[k]%></td><%}%>
 
556
                    <% if (k!=0 && k!=1 && k!=3 && k!=4 && k!=8 && k!=13 && k!=14 && k==15) {%><!-- Just to Try --><%}%>
 
557
                                        <% if (k ==1 || k== 2 || k==4 || k==5 || k==6 || k==7 || k==8 || k==9 || k==10 || k==11 || k==12) { %>
 
558
                    <td width="11" height="30" valign="top" class="tableitem">&nbsp;</td> <td width="26" height="30" valign="top" class="tableitem"><%=lab2[k]%></td> <%}%>
 
559
                                        <% if (k !=1 && k!= 2 && k!=4 && k!=5 && k!=6 && k!=7 && k!=8 && k!=9 && k!=10 && k!=11 && k!=12) { %> <!-- And Again Just to Try --> <%}%>
 
560
                    <% if (k==15) {%><td width="13" height="30" valign="top" class="tableheader"><%=noutpM[k]%></td> <%}%>
 
561
                    <% if (k!=15) {%><td width="13" height="30" valign="top" class="tableitem"><%=noutpM[k]%></td> <%}%>
 
562
                    <% if (k==15) {%><td width="13" height="30" valign="top" class="tableheader"><%=noutpF[k]%></td> <%}%>
 
563
                    <% if (k!=15) {%><td width="13" height="30" valign="top" class="tableitem"><%=noutpF[k]%></td> <%}%>
 
564
                    <td width="13" height="30" valign="top" class="tableheader"><%=noutpM[k]+noutpF[k]%></td>
 
565
                    <% if (k!=15) {%><td width="13" height="30" valign="top" class="tableheader"><%=noutnM[k]%></td> <%}%>
 
566
                    <% if (k==15) {%><td width="13" height="30" valign="top" class="tableitem"><%=noutnM[k]%></td> <%}%>
 
567
                    <% if (k!=15) {%><td width="13" height="30" valign="top" class="tableheader"><%=noutnF[k]%></td> <%}%>
 
568
                    <% if (k==15) {%><td width="13" height="30" valign="top" class="tableitem"><%=noutnF[k]%></td> <%}%>
 
569
                    <td width="13" height="30" valign="top" class="tableheader"><%=noutnM[k]+noutnF[k]%></td>
 
570
                    <% if (k==15) {%><td width="13" height="30" valign="top" class="tableheader"><%=ootherM[k]%></td> <%}%>
 
571
                    <% if (k!=15) {%><td width="13" height="30" valign="top" class="tableitem"><%=ootherM[k]%></td> <%}%>
 
572
                    <% if (k==15) {%><td width="13" height="30" valign="top" class="tableheader"><%=ootherF[k]%></td> <%}%>
 
573
                    <% if (k!=15) {%><td width="13" height="30" valign="top" class="tableitem"><%=ootherF[k]%></td> <%}%>
 
574
                    <td width="13" height="30" valign="top" class="tableheader"><%=ootherM[k]+ootherF[k]%></td>
 
575
                    <td width="13" height="30" valign="top" class="tableheader"><%=noutpM[k]+noutnM[k]+ootherM[k]%></td>
 
576
                    <td width="13" height="30" valign="top" class="tableheader"><%=noutpF[k]+noutnF[k]+ootherF[k]%></td>
 
577
                    <td width="13" height="30" valign="top" class="tableheader"><%=noutpM[k]+noutnM[k]+ootherM[k]+noutpF[k]+noutnF[k]+ootherF[k]%></td>
 
578
                    <% if (k==15) {%><td width="13" height="30" valign="top" class="tableheader"><%=ninpM[k]%></td> <%}%>
 
579
                    <% if (k!=15) {%><td width="13" height="30" valign="top" class="tableitem"><%=ninpM[k]%></td> <%}%>
 
580
                    <% if (k==15) {%><td width="13" height="30" valign="top" class="tableheader"><%=ninpF[k]%></td> <%}%>
 
581
                    <% if (k!=15) {%><td width="13" height="30" valign="top" class="tableitem"><%=ninpF[k]%></td> <%}%>
 
582
                    <td width="13" height="30" valign="top" class="tableheader"><%=ninpM[k]+ninF[k]%></td>
 
583
                    <% if (k!=15) {%><td width="13" height="30" valign="top" class="tableheader"><%=ninnM[k]%></td> <%}%>
 
584
                    <% if (k==15) {%><td width="13" height="30" valign="top" class="tableitem"><%=ninnM[k]%></td> <%}%>
 
585
                    <% if (k!=15) {%><td width="13" height="30" valign="top" class="tableheader"><%=ninnF[k]%></td> <%}%>
 
586
                   // 
 
587
                                        <%}%>
 
588
                  </table>
 
589
              </tr>
 
590
              <tr> 
 
591
                <td height="1" valign="top"><table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#000066">
 
592
                    <!--DWLayoutTable-->
 
593
                                        
 
594
                  </table></td>
 
595
              </tr>
 
596
              <tr>
 
597
                <td height="19">&nbsp;<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#000080" width="100%" id="AutoNumber1" bgcolor="#000080">
 
598
                  <tr>
 
599
                    <td width="100%" colspan="2" bgcolor="#00CCFF" bordercolor="#000099">Number of tested persons</td>
 
600
                  </tr>
 
601
                  <tr>
 
602
                    <td width="50%" bgcolor="#00CCFF" bordercolor="#000099">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 
603
                    Male </td>
 
604
                    <td width="50%" bgcolor="#00CCFF" bordercolor="#000099">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 
605
                    Female</td>
 
606
                  </tr>
 
607
                  <tr>
 
608
                    <td width="50%" bgcolor="#00CCFF" bordercolor="#000099"><%=tpM%>&nbsp;</td>
 
609
                    <td width="50%" bgcolor="#00CCFF" bordercolor="#000099"><%=tpF%>&nbsp;</td>
 
610
                  </tr>
 
611
                </table>
 
612
                </td>
 
613
              </tr>
 
614
              </table></td>
 
615
        </tr>
 
616
      </table></td>
 
617
  </tr>
 
618
  <tr> 
 
619
    <td width="452"></td>
 
620
    <td></td>
 
621
  </tr>
 
622
</table>
 
623
</body>
 
624
</html><%@ page contentType="text/html; charset=" language="java" import="java.sql.*" errorPage="" %>
 
625
<html>
 
626
<head>
 
627
<title>Untitled Document</title>
 
628
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
 
629
</head>
 
630
 
 
631
<body>
 
632
 
 
633
</body>
 
634
</html>
 
 
b'\\ No newline at end of file'