← 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/rptHERR.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/rptHERR.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
        Statement st2=null;
 
13
    ResultSet rs1=null;
 
14
        ResultSet rs2=null;      
 
15
  
 
16
    String userName = "root";      
 
17
    String password = "";           
 
18
    String urlForConnection = "jdbc:mysql://localhost/dhis2";  
 
19
    
 
20
        int orgUnitId = 16;
 
21
        String orgUnitName="";
 
22
        String parentName="";
 
23
        int parentId=0; 
 
24
        int periodId = 204;
 
25
        String startDate="";
 
26
        String endDate="";   
 
27
OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
 
28
          String selectedId = (String) stack.findValue( "orgUnitId" );
 
29
          orgUnitId = Integer.parseInt( selectedId );
 
30
        
 
31
          String selectedPeriodId = (String) stack.findValue( "periodSelect" );
 
32
          periodId = Integer.parseInt( selectedPeriodId );
 
33
  
 
34
 
 
35
        
 
36
    int[] hfM= new int[100];
 
37
        int[] hfF= new int[100];
 
38
        int totHFM=0;
 
39
        int totHFF=0;
 
40
        
 
41
        
 
42
        int[] sM= new int[100];
 
43
        int[] sF= new int[100];
 
44
        int totSM=0;
 
45
        int totSF=0;
 
46
        
 
47
        int[] faF= new int[100];
 
48
        int totFAF=0;
 
49
        
 
50
        int[] yaM= new int[100];
 
51
        int[] yaF= new int[100];
 
52
        int totYAM=0;
 
53
        int totYAF=0;
 
54
 
 
55
        int[] fraM= new int[100];
 
56
        int[] fraF= new int[100];
 
57
        int totFRAM=0;
 
58
        int totFRAF=0;
 
59
        
 
60
        int[] psM= new int[100];
 
61
        int[] psF= new int[100];
 
62
        int totPSM=0;
 
63
        int totPSF=0;
 
64
        
 
65
        int[] oM= new int[100];
 
66
        int[] oF= new int[100];
 
67
        int totOM=0;
 
68
        int totOF=0;
 
69
        
 
70
        int[] um= new int[100];
 
71
        
 
72
        
 
73
        
 
74
 
 
75
        
 
76
        String[] topic= {"Malaria","HIV/AIDS","CDD","TB and Leprosy","Parasites","Nutrition","Use Of medicines","Personal Hygiene","Environmental Health","MCH","EPI","FP","Harmful Traditions","Meningitis","Others"};
 
77
        
 
78
        String[] sn= {"1","2","3","4","5","6","7","8","9","10","11","12","13","14","15"};
 
79
 
 
80
        boolean nextde=true;
 
81
        
 
82
        String[] destring1={"872","754","893","852","914","934","954","974","701","994","729","1014","1041","1054","816"};
 
83
        String[] destring2={"873","747","892","846","913","933","953","973","694","993","722","1013","1040","1053","808"};
 
84
        String[] destring3={"875","759","895","857","916","936","956","976","706","995","733","1016","1042","1056","820"};
 
85
        String[] destring4={"874","751","894","850","915","935","955","975","699","996","726","1015","1043","1055","814"};
 
86
        String[] destring5={"876","753","896","853","917","937","957","977","704","997","727","1017","1044","1057","811"};
 
87
        String[] destring6={"877","746","897","845","918","938","958","978","693","998","723","1018","1045","1058","807"};
 
88
        String[] destring7={"878","752","898","851","919","939","959","979","700","999","730","1019","1046","1059","815"};
 
89
        String[] destring8={"880","756","900","854","921","940","961","980","702","1000","728","1020","1047","1060","817"};
 
90
        String[] destring9={"879","748","899","847","920","941","960","981","695","1001","721","1021","1048","1061","809"};
 
91
        String[] destring10={"881","758","902","856","922","943","963","983","705","1003","732","1023","1049","1063","819"};
 
92
        String[] destring11={"882","750","901","849","923","942","962","982","698","1002","725","1022","1050","1062","813"};
 
93
        String[] destring12={"884","755","903","855","925","945","965","985","703","1004","731","1025","1052","1064","818"};
 
94
        String[] destring13={"883","749","904","848","924","944","964","984","696","1005","724","1024","1051","1065","810"};
 
95
        String[] destring14={"772","777","773","782","778","780","781","783","774","784","775","776","785","786","787"};
 
96
        
 
97
 
 
98
        int i=0;
 
99
        
 
100
     try
 
101
      {
 
102
        Class.forName ("com.mysql.jdbc.Driver");
 
103
        con = DriverManager.getConnection (urlForConnection, userName, password);
 
104
        st1=con.createStatement();
 
105
                st2=con.createStatement();
 
106
                String sql = "select value,dataelement from datavalue where period="+periodId+" and source="+orgUnitId ;
 
107
                sql+=" and dataelement in (872,754,893,852,914,934,954,974,701,994,729,1014,1041,1054,816)";            
 
108
        rs1 = st1.executeQuery(sql);  
 
109
    if (rs1.next())
 
110
        {
 
111
            for(i=0;i<15;i++)
 
112
            {
 
113
                        rs1.beforeFirst();
 
114
                        nextde=true;
 
115
                        while (rs1.next() && nextde)
 
116
                        {
 
117
                        if (destring1[i].equals(rs1.getString("dataelement")))
 
118
                        {
 
119
                
 
120
                hfM[i]=rs1.getInt("value");                             
 
121
                                //System.out.print("YEAH");
 
122
                                //if(!rs1.next()) break;
 
123
                                nextde=false;
 
124
            
 
125
            }
 
126
                        }
 
127
                        
 
128
         
 
129
        }
 
130
                }
 
131
                
 
132
                sql = "select dataelement,value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
133
                sql+=" and dataelement in (873,747,892,846,913,933,953,973,694,993,722,1013,1040,1053,808)";            
 
134
        rs1 = st1.executeQuery(sql); 
 
135
 
 
136
          
 
137
    if (rs1.next())
 
138
        {
 
139
            for(i=0;i<15;i++)
 
140
            {
 
141
                        rs1.beforeFirst();
 
142
                        nextde=true;
 
143
                        while (rs1.next() && nextde)
 
144
                        {
 
145
                        if (destring2[i].equals(rs1.getString("dataelement")))
 
146
                        {
 
147
                
 
148
                hfF[i]=rs1.getInt("value");                             
 
149
                                //System.out.println("YEAH");
 
150
                                //if(!rs1.next()) break;
 
151
                                nextde=false;
 
152
                                }
 
153
                                }
 
154
            
 
155
            }
 
156
         }
 
157
  
 
158
  //geting orguntname
 
159
                sql = "select name,parent from organizationunit where id ="+orgUnitId ;
 
160
            rs1 = st1.executeQuery(sql);  
 
161
         if (rs1.next())
 
162
        {
 
163
           orgUnitName=rs1.getString("name");
 
164
                   parentId=rs1.getInt("parent");
 
165
            }
 
166
                
 
167
                
 
168
                sql = "select name from organizationunit where id ="+parentId ;
 
169
                rs1=st1.executeQuery(sql);
 
170
                if (rs1.next())
 
171
                {
 
172
                parentName=rs1.getString("name");
 
173
                }
 
174
                
 
175
                sql = "select startDate,endDate from period where id ="+periodId ;
 
176
            rs1 = st1.executeQuery(sql);  
 
177
         if (rs1.next())
 
178
        {
 
179
           startDate=rs1.getString("startDate");                                
 
180
           endDate=rs1.getString("endDate");                            
 
181
 
 
182
            }
 
183
            //end getting 
 
184
 
 
185
                    
 
186
                sql = "select dataelement,value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
187
                sql+=" and dataelement in (875,759,895,857,916,936,956,976,706,995,733,1016,1042,1056,820)";            
 
188
        rs1 = st1.executeQuery(sql);                                    
 
189
         
 
190
    if (rs1.next())
 
191
        {
 
192
            for(i=0;i<15;i++)
 
193
            {
 
194
                        rs1.beforeFirst();
 
195
                        nextde=true;
 
196
                        while (rs1.next() && nextde)
 
197
                        {
 
198
                        if (destring3[i].equals(rs1.getString("dataelement")))
 
199
                        {
 
200
                
 
201
                sM[i]=rs1.getInt("value");                              
 
202
                                //System.out.print("have value");
 
203
                                //if(!rs1.next()) break;
 
204
                                nextde=false;
 
205
                                }
 
206
                                }
 
207
            
 
208
            }
 
209
         }
 
210
   
 
211
                   
 
212
                   sql = "select dataelement,value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
213
                sql+=" and dataelement in (874,751,894,850,915,935,955,975,699,996,726,1015,1043,1055,814)";            
 
214
        rs1 = st1.executeQuery(sql);                                    
 
215
         
 
216
    if (rs1.next())
 
217
        {
 
218
            for(i=0;i<15;i++)
 
219
            {
 
220
                        rs1.beforeFirst();
 
221
                        nextde=true;
 
222
                        while (rs1.next() && nextde)
 
223
                        {
 
224
                        if (destring4[i].equals(rs1.getString("dataelement")))
 
225
                        {
 
226
                
 
227
                sF[i]=rs1.getInt("value");                              
 
228
                                //System.out.print("have value");
 
229
                                //if(!rs1.next()) break;
 
230
                                nextde=false;
 
231
                                }
 
232
                                }
 
233
            
 
234
            }
 
235
         }
 
236
   
 
237
                   sql = "select dataelement,value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
238
                sql+=" and dataelement in (876,753,896,853,917,937,957,977,704,997,727,1017,1044,1057,811)";            
 
239
        rs1 = st1.executeQuery(sql);                                    
 
240
       
 
241
    if (rs1.next())
 
242
        {
 
243
            for(i=0;i<15;i++)
 
244
            {
 
245
                        rs1.beforeFirst();
 
246
                        nextde=true;
 
247
                        while (rs1.next() && nextde)
 
248
                        {
 
249
                        if (destring5[i].equals(rs1.getString("dataelement")))
 
250
                        {
 
251
                
 
252
                faF[i]=rs1.getInt("value");                             
 
253
                                //System.out.print("have value");
 
254
                                //if(!rs1.next()) break;
 
255
                                nextde=false;
 
256
                                }
 
257
                                }
 
258
            
 
259
            }
 
260
         }
 
261
     
 
262
                   sql = "select dataelement,value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
263
                sql+=" and dataelement in (877,746,897,845,918,938,958,978,693,998,723,1018,1045,1058,807)";            
 
264
        rs1 = st1.executeQuery(sql);                                    
 
265
          
 
266
    if (rs1.next())
 
267
        {
 
268
            for(i=0;i<15;i++)
 
269
            {
 
270
                        rs1.beforeFirst();
 
271
                        nextde=true;
 
272
                        while (rs1.next() && nextde)
 
273
                        {
 
274
                        if (destring6[i].equals(rs1.getString("dataelement")))
 
275
                        {
 
276
                
 
277
                yaF[i]=rs1.getInt("value");                             
 
278
                                //System.out.print("have value");
 
279
                                //if(!rs1.next()) break;
 
280
                                nextde=false;
 
281
                                }
 
282
                                }
 
283
            
 
284
            }
 
285
         }
 
286
  
 
287
                   sql = "select dataelement,value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
288
                   sql+=" and dataelement in (878,752,898,851,919,939,959,979,700,999,730,1019,1046,1059,815)";         
 
289
        rs1 = st1.executeQuery(sql);                                    
 
290
         
 
291
    if (rs1.next())
 
292
        {
 
293
            for(i=0;i<15;i++)
 
294
            {
 
295
                        rs1.beforeFirst();
 
296
                        nextde=true;
 
297
                        while (rs1.next() && nextde)
 
298
                        {
 
299
                        if (destring7[i].equals(rs1.getString("dataelement")))
 
300
                        {
 
301
                
 
302
                yaM[i]=rs1.getInt("value");                             
 
303
                                //System.out.print("have value");
 
304
                                //if(!rs1.next()) break;
 
305
                                nextde=false;
 
306
                                }
 
307
                                }
 
308
            
 
309
            }
 
310
         }
 
311
   
 
312
                   sql = "select dataelement,value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
313
                sql+=" and dataelement in (880,756,900,854,921,940,961,980,702,1000,728,1020,1047,1060,817)";           
 
314
        rs1 = st1.executeQuery(sql);                                    
 
315
          
 
316
    if (rs1.next())
 
317
        {
 
318
            for(i=0;i<15;i++)
 
319
            {
 
320
                        rs1.beforeFirst();
 
321
                        nextde=true;
 
322
                        while (rs1.next() && nextde)
 
323
                        {
 
324
                        if (destring8[i].equals(rs1.getString("dataelement")))
 
325
                        {
 
326
                
 
327
                fraM[i]=rs1.getInt("value");                            
 
328
                                //System.out.print("have value");
 
329
                                //if(!rs1.next()) break;
 
330
                                nextde=false;
 
331
                                }
 
332
                                }
 
333
            
 
334
            }
 
335
         }
 
336
  
 
337
                   sql = "select dataelement,value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
338
 
 
339
                sql+=" and dataelement in (879,748,899,847,920,941,960,981,695,1001,721,1021,1048,1061,809)";           
 
340
        rs1 = st1.executeQuery(sql);                                    
 
341
          
 
342
    if (rs1.next())
 
343
        {
 
344
            for(i=0;i<15;i++)
 
345
            {
 
346
                        rs1.beforeFirst();
 
347
                        nextde=true;
 
348
                        while (rs1.next() && nextde)
 
349
                        {
 
350
                        if (destring9[i].equals(rs1.getString("dataelement")))
 
351
                        {
 
352
                
 
353
                fraF[i]=rs1.getInt("value");                            
 
354
                                //System.out.print("have value");
 
355
                                //if(!rs1.next()) break;
 
356
                                nextde=false;
 
357
                                }
 
358
                                }
 
359
            
 
360
            }
 
361
         }
 
362
  
 
363
                   sql = "select dataelement,value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
364
                sql+=" and dataelement in (881,758,902,856,922,943,963,983,705,1003,732,1023,1049,1063,819)";           
 
365
        rs1 = st1.executeQuery(sql);                                    
 
366
         
 
367
    if (rs1.next())
 
368
        {
 
369
            for(i=0;i<15;i++)
 
370
            {
 
371
                        rs1.beforeFirst();
 
372
                        nextde=true;
 
373
                        while (rs1.next() && nextde)
 
374
                        {
 
375
                        if (destring10[i].equals(rs1.getString("dataelement")))
 
376
                        {
 
377
                
 
378
                psM[i]=rs1.getInt("value");                             
 
379
                                //System.out.print("have value");
 
380
                                //if(!rs1.next()) break;
 
381
                                nextde=false;
 
382
                                }
 
383
                                }
 
384
            
 
385
            }
 
386
         }
 
387
   
 
388
                   sql = "select dataelement,value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
389
                sql+=" and dataelement in (882,750,901,849,923,942,962,982,698,1002,725,1022,1050,1062,813)";           
 
390
        rs1 = st1.executeQuery(sql);                                    
 
391
       
 
392
    if (rs1.next())
 
393
        {
 
394
            for(i=0;i<15;i++)
 
395
            {
 
396
                        rs1.beforeFirst();
 
397
                        nextde=true;
 
398
                        while (rs1.next() && nextde)
 
399
                        {
 
400
                        if (destring11[i].equals(rs1.getString("dataelement")))
 
401
                        {
 
402
                
 
403
                psF[i]=rs1.getInt("value");                             
 
404
                                //System.out.print("have value");
 
405
                                //if(!rs1.next()) break;
 
406
                                nextde=false;
 
407
                                }
 
408
                                }
 
409
            
 
410
            }
 
411
         }
 
412
     
 
413
                   sql = "select dataelement,value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
414
                sql+=" and dataelement in (884,755,903,855,925,945,965,985,703,1004,731,1025,1052,1064,818)";           
 
415
        rs1 = st1.executeQuery(sql);                                    
 
416
         
 
417
    if (rs1.next())
 
418
        {
 
419
            for(i=0;i<15;i++)
 
420
            {
 
421
                        rs1.beforeFirst();
 
422
                        nextde=true;
 
423
                        while (rs1.next() && nextde)
 
424
                        {
 
425
                        if (destring12[i].equals(rs1.getString("dataelement")))
 
426
                        {
 
427
                
 
428
                oM[i]=rs1.getInt("value");                              
 
429
                                //System.out.print("have value");
 
430
                                //if(!rs1.next()) break;
 
431
                                nextde=false;
 
432
                                }
 
433
                                }
 
434
            
 
435
            }
 
436
         }
 
437
   
 
438
                   sql = "select dataelement,value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
439
                sql+=" and dataelement in (883,749,904,948,924,944,964,984,696,1005,724,1024,1051,1065,810)";           
 
440
        rs1 = st1.executeQuery(sql);                                    
 
441
         
 
442
    if (rs1.next())
 
443
        {
 
444
            for(i=0;i<15;i++)
 
445
            {
 
446
                        rs1.beforeFirst();
 
447
                        nextde=true;
 
448
                        while (rs1.next() && nextde)
 
449
                        {
 
450
                        if (destring13[i].equals(rs1.getString("dataelement")))
 
451
                        {
 
452
                
 
453
                oF[i]=rs1.getInt("value");                              
 
454
                                //System.out.print("have value");
 
455
                                //if(!rs1.next()) break;
 
456
                                nextde=false;
 
457
                                }
 
458
                                }
 
459
            
 
460
            }
 
461
         }
 
462
  
 
463
                   sql = "select dataelement,value from datavalue where period="+periodId+" and source="+orgUnitId ;
 
464
                sql+=" and dataelement in (772,777,773,782,778,780,781,783,774,784,775,776,785,786,787)";               
 
465
        rs1 = st1.executeQuery(sql);                                    
 
466
          
 
467
    if (rs1.next())
 
468
        {
 
469
            for(i=0;i<15;i++)
 
470
            {
 
471
                        rs1.beforeFirst();
 
472
                        nextde=true;
 
473
                        while (rs1.next() && nextde)
 
474
                        {
 
475
                        if (destring14[i].equals(rs1.getString("dataelement")))
 
476
                        {
 
477
                
 
478
                um[i]=rs1.getInt("value");                              
 
479
                                //System.out.print("have value");
 
480
                                //if(!rs1.next()) break;
 
481
                                nextde=false;
 
482
                                }
 
483
                                }
 
484
            
 
485
            }
 
486
         }
 
487
  
 
488
           
 
489
        for (i=0;i<15;i++)
 
490
        {
 
491
        totHFM+=hfM[i];
 
492
        totHFF+=hfF[i];
 
493
        totSM+=sM[i];
 
494
        totSF+=sF[i];
 
495
        totFAF+=faF[i];
 
496
        totYAM+=yaM[i];
 
497
        totYAF+=yaF[i];
 
498
        totFRAM+=fraM[i];
 
499
        totFRAF+=fraF[i];
 
500
        totPSM+=psM[i];
 
501
        totPSF+=psF[i];
 
502
        totOM+=oM[i];
 
503
        totOF+=oF[i];
 
504
        
 
505
        }
 
506
        
 
507
                  
 
508
                   
 
509
                   
 
510
       } 
 
511
      catch(Exception e)  { out.println("Loi cho ma gi day: "+e.getMessage());  }
 
512
      
 
513
%>
 
514
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 
515
<html>
 
516
<head>
 
517
<title>Health Education Report for <%=orgUnitName%></title>
 
518
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
 
519
<link href="styles.css" rel="stylesheet" type="text/css">
 
520
 
 
521
<!-- <style type="text/css">
 
522
<!--
 
523
.style10 {font-family: Geneva, Arial, Helvetica, sans-serif}
 
524
 
 
525
</style> -->
 
526
</head>
 
527
 
 
528
<body>
 
529
<table width="740" border="0" cellpadding="1" cellspacing="1" height="202">
 
530
  <!--DWLayoutTable-->
 
531
  <tr> 
 
532
    <td colspan="2" rowspan="2" valign="top" height="375" width="744">
 
533
    <table width="914" border="0" cellpadding="1" cellspacing="1" height="1">
 
534
        <!--DWLayoutTable-->
 
535
        <tr> 
 
536
          <td width="910" height="79" valign="top">
 
537
          <table width="743" border="0" cellspacing="0" height="78">
 
538
              <!--DWLayoutTable-->
 
539
              <tr class="header"> 
 
540
                <td width="910" height="76" valign="top"  >Monthly Activity 
 
541
                Report on Health Education for <%=orgUnitName%></td>
 
542
              </tr>
 
543
            </table></td>
 
544
        </tr>
 
545
        <tr> 
 
546
          <td height="47" valign="top" width="910">
 
547
          <table width="743" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" class="header1" style="border-collapse: collapse" bgcolor="#008080" >
 
548
              <!--DWLayoutTable-->
 
549
              <tr bgcolor="#FFCCCC" class="header1"> 
 
550
                <td width="126" height="47" valign="top" class="header1" bgcolor="#008080" bordercolor="#000099"><div align="left">
 
551
                  District</div>                </td>
 
552
                <td width="124" class="header1" bgcolor="#008080" bordercolor="#000099"><%=parentName%>&nbsp;</td>
 
553
                <td width="126" valign="top" class="header1" bgcolor="#008080" bordercolor="#000099" >
 
554
                Health Institution</td>
 
555
                <td width="456" bgcolor="#008080" bordercolor="#000099"><%=orgUnitName%>&nbsp;</td>
 
556
              </tr>
 
557
            </table></td>
 
558
        </tr>
 
559
        <tr> 
 
560
          <td height="55" valign="top" width="910">
 
561
          <table width="743" border="1" cellpadding="0" cellspacing="0" class="header1" style="border-collapse: collapse" bordercolor="#FFFFFF" bgcolor="#008080" height="52">
 
562
              <!--DWLayoutTable-->
 
563
              <tr bgcolor="#FFCCCC"> 
 
564
                <td width="110" height="52" valign="top" class="header1" bgcolor="#008080" bordercolor="#0000FF"><div align="left">Period</div></td>
 
565
                <td width="108" valign="top" class="header1" bgcolor="#008080" bordercolor="#0000FF" height="52">From</td>
 
566
                <td width="99" bgcolor="#008080" bordercolor="#0000FF" height="52"><%=startDate%>&nbsp;</td>
 
567
                <td width="104" valign="top" class="header1" bgcolor="#008080" bordercolor="#0000FF" height="52">To</td>
 
568
                <td width="408" valign="top" class="header1" bgcolor="#008080" bordercolor="#0000FF" height="52">
 
569
                <%=endDate%>&nbsp;</td>
 
570
              </tr>
 
571
            </table></td>
 
572
        </tr>
 
573
                  
 
574
      
 
575
        <table width="89%" border="0" cellpadding="0" cellspacing="0" height="122">
 
576
              <!--DWLayoutTable-->
 
577
              <tr> 
 
578
                <td width="555" height="143" valign="top">
 
579
                
 
580
          <table width="743" height="60" border="1" cellpadding="0" cellspacing="0"  bgcolor="#000066">
 
581
            <!--DWLayoutTable-->
 
582
            <tr class="tableheader">
 
583
                                            </td> 
 
584
                    </tr>
 
585
                    <tr>
 
586
                      <td width="24" height="30" rowspan="2" valign="top" class="tableheader" bordercolor="#000080">
 
587
                      S.N</td>
 
588
                      <td width="65" height="30" rowspan="2" valign="top" class="tableheader" bordercolor="#000080">
 
589
                      Topic of Education</td>
 
590
                      <td width="55" height="1" valign="top" class="tableheader" colspan="3" bordercolor="#000080">
 
591
                      Health Facility<p>&nbsp;</td>                    
 
592
                      
 
593
                      <td width="54" valign="top" class="tableheader" height="1" colspan="3" bordercolor="#000080">
 
594
                      School</td>
 
595
                      
 
596
                      <td width="76" valign="top" class="tableheader" height="24" rowspan="2" bordercolor="#000080">
 
597
                      Females Association</td>
 
598
                      
 
599
                      <td width="76" valign="top" class="tableheader" height="1" colspan="3" bordercolor="#000080">
 
600
                      Youth Association</td>
 
601
                      
 
602
                      <td width="72" valign="top" class="tableheader" height="1" colspan="3" bordercolor="#000080">
 
603
                      Farmers<p>Association</td>
 
604
                      
 
605
                      <td width="52" valign="top" class="tableheader" height="1" colspan="3" bordercolor="#000080">
 
606
                      Prayer Sites</td>
 
607
                                          
 
608
                      <td width="59" valign="top" class="tableheader" height="1" colspan="3" bordercolor="#000080">
 
609
                      Others</td>
 
610
                                          
 
611
                                          
 
612
                      <td width="54" valign="top" class="tableheader" height="12" colspan="3" bordercolor="#000080">
 
613
                      Total</td>
 
614
                                          
 
615
                                          
 
616
                      <td width="81" valign="top" class="tableheader" height="24" rowspan="2" bordercolor="#000080">
 
617
                      Used<p>Methodology<p>&nbsp;</td>
 
618
                                          
 
619
                    </tr>
 
620
                    <tr>
 
621
                      <td width="20" height="23" valign="top" class="tableheader" bordercolor="#000080">
 
622
                      M</td>                    
 
623
                      
 
624
                      <td width="16" height="23" valign="top" class="tableheader" bordercolor="#000080">
 
625
                      F</td>                    
 
626
                      
 
627
                      <td width="17" height="23" valign="top" class="tableheader" bordercolor="#000080">
 
628
                      Total</td>                    
 
629
                      
 
630
                      <td width="18" valign="top" class="tableheader" height="23" bordercolor="#000080">
 
631
                      M</td>
 
632
                      
 
633
                      <td width="17" valign="top" class="tableheader" height="23" bordercolor="#000080">
 
634
                      F</td>
 
635
                      
 
636
                      <td width="17" valign="top" class="tableheader" height="23" bordercolor="#000080">
 
637
                      Total</td>
 
638
                      
 
639
                      <td width="34" valign="top" class="tableheader" height="23" bordercolor="#000080">
 
640
                      M</td>
 
641
                      
 
642
                      <td width="20" valign="top" class="tableheader" height="23" bordercolor="#000080">
 
643
                      F</td>
 
644
                      
 
645
                      <td width="20" valign="top" class="tableheader" height="23" bordercolor="#000080">
 
646
                      Total</td>
 
647
                      
 
648
                      <td width="37" valign="top" class="tableheader" height="23" bordercolor="#000080">
 
649
                      M</td>
 
650
                      
 
651
                      <td width="18" valign="top" class="tableheader" height="23" bordercolor="#000080">
 
652
                      F</td>
 
653
                      
 
654
                      <td width="15" valign="top" class="tableheader" height="23" bordercolor="#000080">
 
655
                      Total</td>
 
656
                      
 
657
                      <td width="23" valign="top" class="tableheader" height="23" bordercolor="#000080">
 
658
                      M</td>
 
659
                      
 
660
                      <td width="13" valign="top" class="tableheader" height="23" bordercolor="#000080">
 
661
                      F</td>
 
662
                      
 
663
                      <td width="14" valign="top" class="tableheader" height="23" bordercolor="#000080">
 
664
                      Total</td>
 
665
                      
 
666
                      <td width="20" valign="top" class="tableheader" height="23" bordercolor="#000080">
 
667
                      M</td>
 
668
                      
 
669
                      <td width="19" valign="top" class="tableheader" height="23" bordercolor="#000080">
 
670
                      F</td>
 
671
                      
 
672
                      <td width="18" valign="top" class="tableheader" height="23" bordercolor="#000080">
 
673
                      Total</td>
 
674
                      
 
675
                                          
 
676
                      <td width="17" valign="top" class="tableheader" height="12" bordercolor="#000080">
 
677
                      M</td>
 
678
                                          
 
679
                                          
 
680
                      <td width="15" valign="top" class="tableheader" height="12" bordercolor="#000080">
 
681
                      F</td>
 
682
                                          
 
683
                                          
 
684
                      <td width="20" valign="top" class="tableheader" height="12" bordercolor="#000080">
 
685
                      Grand Total</td>
 
686
                                          
 
687
                    </tr>
 
688
                  <% for (int k=0;k<15;k++){%>
 
689
                  <tr bordercolor="#000000" class="tableitem">
 
690
                      <td width="22" height="30" valign="top" class="tableitem" bordercolor="#000080"><%=sn[k]%>&nbsp;</td>
 
691
                                          <td width="63" height="30" valign="top" class="tableitem" bordercolor="#000080"><%=topic[k]%>&nbsp;</td>
 
692
                      <td width="18" valign="top" class="tableitem" height="30" bordercolor="#000080"><%=hfM[k]%>&nbsp;</td>
 
693
                      <td width="14" valign="top" class="tableitem" height="30" bordercolor="#000080"><%=hfF[k]%>&nbsp;</td>
 
694
                      <td width="15" valign="top" class="tableheader" height="30" bordercolor="#000080"><%=hfM[k]+hfF[k]%>&nbsp;</td>
 
695
                      <td width="16" valign="top" class="tableitem" height="30" bordercolor="#000080"><%=sM[k]%>&nbsp;</td>
 
696
                      <td width="15" valign="top" class="tableitem" height="30" bordercolor="#000080"><%=sF[k]%>&nbsp;</td>
 
697
                      <td width="15" valign="top" class="tableheader" height="30" bordercolor="#000080"><%=sM[k]+sF[k]%>&nbsp;</td>
 
698
                      <td width="74" valign="top" class="tableitem" height="30" bordercolor="#000080"><%=faF[k]%></td>
 
699
                      <td width="32" valign="top" class="tableitem" height="30" bordercolor="#000080"><%=yaM[k]%>&nbsp;</td>
 
700
                      <td width="18" valign="top" class="tableitem" height="30" bordercolor="#000080"><%=yaF[k]%>&nbsp;</td>
 
701
                      <td width="18" valign="top" class="tableheader" height="30" bordercolor="#000080"><%=yaM[k]+yaF[k]%>&nbsp;</td>
 
702
                      <td width="35" valign="top" class="tableitem" height="30" bordercolor="#000080"><%=fraM[k]%>&nbsp;</td>
 
703
                      <td width="16" valign="top" class="tableitem" height="30" bordercolor="#000080"><%=fraF[k]%>&nbsp;</td>
 
704
                      <td width="13" valign="top" class="tableheader" height="30" bordercolor="#000080"><%=fraM[k]+fraF[k]%>&nbsp;</td>
 
705
                      <td width="21" valign="top" class="tableitem" height="30" bordercolor="#000080"><%=psM[k]%>&nbsp;</td>
 
706
                      <td width="11" valign="top" class="tableitem" height="30" bordercolor="#000080"><%=psF[k]%>&nbsp;</td>
 
707
                      <td width="12" valign="top" class="tableheader" height="30" bordercolor="#000080"><%=psM[k]+psF[k]%>&nbsp;</td>
 
708
                      <td width="18" valign="top" class="tableitem" height="30" bordercolor="#000080"><%=oM[k]%>&nbsp;</td>
 
709
                      <td width="17" valign="top" class="tableitem" height="30" bordercolor="#000080"><%=oF[k]%>&nbsp;</td>
 
710
                          <td width="16" valign="top" class="tableheader" height="30" bordercolor="#000080"><%=oM[k]+oF[k]%>&nbsp;</td>
 
711
                                          <td width="15" valign="top" class="tableheader" height="30" bordercolor="#000080"><%=hfM[k]+sM[k]+yaM[k]+fraM[k]+psM[k]+oM[k]%>&nbsp;</td>
 
712
                                          <td width="13" valign="top" class="tableheader" height="30" bordercolor="#000080"><%=hfF[k]+sF[k]+faF[k]+yaF[k]+fraF[k]+psF[k]+oF[k]%>&nbsp;</td>
 
713
                                          
 
714
              <td width="18" valign="top" class="tableheader" height="30" bordercolor="#000080"><%=hfM[k]+hfF[k]+sM[k]+sF[k]+faF[k]+yaM[k]+yaF[k]+fraM[k]+fraF[k]+psM[k]+psF[k]+oM[k]+oF[k]%>&nbsp;</td>
 
715
                      <td width="59" valign="top" class="tableitem" height="30" bordercolor="#000080"><%=um[k]%></td>
 
716
                    </tr>
 
717
 
 
718
                                        <%}%>
 
719
              <tr> 
 
720
                <td class="none"></td>
 
721
                                <td class="tableheader" width="65" >Total</td>
 
722
                <td class="tableheader" width="20" style="background-color: #4040FF" bordercolor="#000080"><%=totHFM%>&nbsp;</td>
 
723
                <td class="tableheader" width="16" style="background-color: #4040FF" bordercolor="#000080"><%=totHFF%>&nbsp;</td>
 
724
                <td class="tableheader" width="17" style="background-color: #4040FF" bordercolor="#000080"><%=totHFM + totHFF%>&nbsp;</td>
 
725
                <td class="tableheader" width="18" style="background-color: #4040FF" bordercolor="#000080"><%=totSM%>&nbsp;</td>
 
726
                <td class="tableheader" width="17" style="background-color: #4040FF" bordercolor="#000080"><%=totSF%>&nbsp;</td>
 
727
                <td class="tableheader" width="17" style="background-color: #4040FF" bordercolor="#000080"><%=totSM + totSF%>&nbsp;</td>
 
728
                
 
729
              <td class="tableheader" width="76" style="background-color: #4040FF" bordercolor="#000080"><%=totFAF%>&nbsp;</td>
 
730
                <td class="tableheader" width="34" style="background-color: #4040FF" bordercolor="#000080"><%=totYAM%>&nbsp;</td>
 
731
                <td class="tableheader" width="20" style="background-color: #4040FF" bordercolor="#000080"><%=totYAF%>&nbsp;</td>
 
732
                <td class="tableheader" width="20" style="background-color: #4040FF" bordercolor="#000080"><%=totYAM + totYAF%>&nbsp;</td>
 
733
                <td class="tableheader" width="37" style="background-color: #4040FF" bordercolor="#000080"><%=totFRAM%>&nbsp;</td>
 
734
                <td class="tableheader" width="18" style="background-color: #4040FF" bordercolor="#000080"><%=totFRAF%>&nbsp;</td>
 
735
                <td class="tableheader" width="15" style="background-color: #4040FF" bordercolor="#000080"><%=totFRAM + totFRAF%>&nbsp;</td>
 
736
                <td class="tableheader" width="23" style="background-color: #4040FF" bordercolor="#000080"><%=totPSM%>&nbsp;</td>
 
737
                <td class="tableheader" width="13" style="background-color: #4040FF" bordercolor="#000080"><%=totPSF%>&nbsp;</td>
 
738
                <td class="tableheader" width="14" style="background-color: #4040FF" bordercolor="#000080"><%=totPSM + totPSF%>&nbsp;</td>
 
739
                <td class="tableheader" width="20" style="background-color: #4040FF" bordercolor="#000080"><%=totOM%>&nbsp;</td>
 
740
                <td class="tableheader" width="19" style="background-color: #4040FF" bordercolor="#000080"><%=totOF%>&nbsp;</td>
 
741
                <td class="tableheader" width="18" style="background-color: #4040FF" bordercolor="#000080"><%=totOM + totOF%>&nbsp;</td>
 
742
                                <td class="tableheader" width="17" style="background-color: #4040FF" bordercolor="#000080"><%=totHFM+totSM+totYAM+totFRAM+totPSM+totOM%>&nbsp;</td>
 
743
                                <td class="tableheader" width="15" style="background-color: #4040FF" bordercolor="#000080"><%=totHFF+totSF+totFAF+totYAF+totFRAF+totPSF+totOF%>&nbsp;</td>
 
744
                                <td class="tableheader" width="20" style="background-color: #4040FF" bordercolor="#000080"><%=totHFM+totHFF+totSM+totSF+totFAF+totYAM+totYAF+totFRAM+totFRAF+totPSM+totPSF+totOM + totOF%>&nbsp;</td>
 
745
                <td  class="none">&nbsp;</td>
 
746
                                
 
747
              </tr>
 
748
                  </table>
 
749
              </tr>
 
750
              <tr> 
 
751
                <td height="1" valign="top"><table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#000066">
 
752
                    <!--DWLayoutTable-->
 
753
                                        
 
754
                  </table></td>
 
755
              </tr>
 
756
              </table></td>
 
757
        </tr>
 
758
      </table></td>
 
759
    <td height="352" width="1"></td>
 
760
  </tr>
 
761
  <tr> 
 
762
    <td height="20" width="1"></td>
 
763
  </tr>
 
764
  <tr> 
 
765
    <td width="716" height="1"></td>
 
766
    <td height="1" width="25"></td>
 
767
    <td height="1" width="1"></td>
 
768
  </tr>
 
769
</table>
 
770
</body>
 
771
</html>
 
 
b'\\ No newline at end of file'