← 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/jform9.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/jform9.jsp
 
1
 
 
2
<%@ page import="java.sql.*" %>
 
3
<%@ page import="com.opensymphony.xwork.util.OgnlValueStack" %>
 
4
 
 
5
<%
 
6
      Connection con=null;
 
7
      
 
8
      // for Performance in the Reporting Month
 
9
      Statement st=null;
 
10
      ResultSet rs=null;
 
11
      
 
12
      // for selected OrgUnit Name and Population
 
13
      Statement st1=null;
 
14
      ResultSet rs1=null;
 
15
      
 
16
      // for Performance in Corresponding month Last Year
 
17
      Statement st2=null;
 
18
      ResultSet rs2=null;
 
19
      
 
20
      // for Cumulative Performance till Current Month
 
21
      Statement st4=null;
 
22
      ResultSet rs4=null;
 
23
     
 
24
      // for Cumulative Performance till corresponding month of Last Year
 
25
      Statement st3=null;
 
26
      ResultSet rs3=null;
 
27
 
 
28
      // for Taluk Name and Id
 
29
      Statement st5=null;
 
30
      ResultSet rs5=null;
 
31
 
 
32
      // for District Name and Id
 
33
      Statement st6=null;
 
34
      ResultSet rs6=null;
 
35
 
 
36
     // for PHC Name and Id
 
37
      Statement st8=null;
 
38
      ResultSet rs8=null;
 
39
 
 
40
     // for CHC Name and Id
 
41
      Statement st9=null;
 
42
      ResultSet rs9=null;
 
43
 
 
44
     // for PHC Population Estimates
 
45
      Statement st10=null;
 
46
      ResultSet rs10=null;
 
47
 
 
48
     // for Data Period Start Date and End Date
 
49
      Statement st11=null;
 
50
      ResultSet rs11=null;
 
51
      
 
52
     // for DataElement ids based on DataElement code
 
53
      Statement st12=null;
 
54
      ResultSet rs12=null;
 
55
     
 
56
      
 
57
      String userName = "dhis";           
 
58
      String password = "";           
 
59
      String urlForConnection = "jdbc:mysql://localhost/jh_dhis2";
 
60
          
 
61
      int talukID = 0;
 
62
      String talukName = "";
 
63
      int districtID = 0; 
 
64
      String districtName = ""; 
 
65
      int CHCID = 0;
 
66
      String CHCName ="";
 
67
      int PHCID = 0;
 
68
      String PHCName ="";          
 
69
          String stateName = "";
 
70
      int totPHCPopulation = -1;
 
71
      int totSCPopulation = -1;
 
72
 
 
73
          OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
 
74
          String selectedId = (String) stack.findValue( "orgUnitId" );
 
75
          int selectedOrgUnitID =   Integer.parseInt( selectedId );
 
76
         
 
77
          String startingDate  =   (String) stack.findValue( "startingPeriod" );
 
78
          String endingDate  =    (String) stack.findValue( "endingPeriod" );
 
79
      
 
80
          String monthlyPeriodId = (String) stack.findValue( "monthlyPeriodTypeId" );
 
81
          int periodTypeID =       Integer.parseInt( monthlyPeriodId );
 
82
               
 
83
          int lastYear = 0;
 
84
      
 
85
          String selectedOrgUnitName = "";
 
86
          String selectedDataPeriodStartDate = "";
 
87
          String selectedDataPeriodEndDate = "";
 
88
          String lastDataPeriodStartDate = "";
 
89
          
 
90
           String dataElementCodes[] = {
 
91
                                                                                
 
92
                                                                                "'Form6_DE1'", "'Form6_DE3'",
 
93
                                                                                
 
94
                                                                                "' '",
 
95
                                                                                
 
96
                                                                                "'Form6_DE6'","'Form6_DE7'","'Form6_DE9'",
 
97
                                                                                
 
98
                                                                                "' '","' '",                                                                            
 
99
                                                                                
 
100
                                                                                "'Form7_DE1'","'Form7_DE1'","'Form7_DE1'",
 
101
                                                                                
 
102
                                                                                "' '","' '","' '","' '",
 
103
                                                                                
 
104
                                                                                "'Form7_DE5'",
 
105
                                                                                
 
106
                                                                                "' '",
 
107
 
 
108
                                                                                "'Form6_DE13'","'Form6_DE11','Form6_DE12'",
 
109
 
 
110
                                                                                "' '",
 
111
 
 
112
                                                                                "'Form6_DE15'","'Form7_DE3'","'Form7_DE3'",
 
113
 
 
114
                                                                                "' '","' '","' '","' '",
 
115
 
 
116
                                                                                "'Form6_DE16'","'Form6_DE35'","'Form6_DE36'","'Form6_DE37'",
 
117
                                                                                "'Form6_DE17','Form6_DE18'",
 
118
                                                                                "'Form6_DE19','Form6_DE20'",
 
119
 
 
120
                                                                                "' '",
 
121
 
 
122
                                                                                "'Form6_DE21','Form6_DE22'",
 
123
                                                                                "'Form6_DE23','Form6_DE24'",
 
124
                                                                                "'Form6_DE25','Form6_DE26'",
 
125
 
 
126
                                                                                "' '",
 
127
 
 
128
                                                                                "'Form6_DE27','Form6_DE28'",
 
129
                                                                                "'Form6_DE29','Form6_DE30'",
 
130
 
 
131
                                                                                "' '","' '","' '",
 
132
 
 
133
                                                                                "'Form6_DE33'",
 
134
 
 
135
                                                                                "' '",
 
136
 
 
137
                                                                                "'Form6_DE40'","'Form6_DE41'",
 
138
                                                                                
 
139
                                                                                "' '",
 
140
                                                                                
 
141
                                                                                "'Form6_DE42','Form6_DE43'",
 
142
 
 
143
                                                                                "' '","' '","' '",
 
144
        
 
145
                                                                                "'Form6_DE151'",
 
146
                                                                                
 
147
                                                                                "' '","' '","' '",
 
148
 
 
149
                                                                                "'Form6_DE44'","'Form6_DE45'",
 
150
                                                                                "'Form6_DE44','Form6_DE45'",
 
151
 
 
152
                                                                                "'Form6_DE46'","'Form6_DE47'",
 
153
                                                                                "'Form6_DE46','Form6_DE47'",
 
154
                                                                                
 
155
                                                                                "'Form6_DE48'","'Form6_DE49'",
 
156
                                                                                "'Form6_DE48','Form6_DE49'",
 
157
                                                                                
 
158
                                                                                "'Form6_DE50'","'Form6_DE51'",
 
159
                                                                                "'Form6_DE50','Form6_DE51'",
 
160
                                                                                
 
161
                                                                                "'Form6_DE52'","'Form6_DE53'",
 
162
                                                                                "'Form6_DE52','Form6_DE53'",
 
163
                                                                                
 
164
                                                                                "'Form6_DE54'","'Form6_DE55'",
 
165
                                                                                "'Form6_DE54','Form6_DE55'",
 
166
                                                                                
 
167
                                                                                "'Form6_DE56'","'Form6_DE57'",
 
168
                                                                                "'Form6_DE56','Form6_DE57'",
 
169
                                                                                
 
170
                                                                                "'Form6_DE58'","'Form6_DE59'",
 
171
                                                                                "'Form6_DE58','Form6_DE59'",
 
172
                                                                                
 
173
                                                                                "'Form6_DE60'","'Form6_DE61'",
 
174
                                                                                "'Form6_DE60','Form6_DE61'",
 
175
 
 
176
                                                                                "' '","' '","' '",
 
177
 
 
178
                                                                                "'Form6_DE64'","'Form6_DE65'",
 
179
                                                                                "'Form6_DE64','Form6_DE65'",
 
180
                                                                                
 
181
                                                                                "'Form6_DE66'","'Form6_DE67'",
 
182
                                                                                "'Form6_DE66','Form6_DE67'",
 
183
                                                                                
 
184
                                                                                "'Form6_DE68'","'Form6_DE69'",
 
185
                                                                                "'Form6_DE68','Form6_DE69'",
 
186
 
 
187
                                                                                "' '","' '","' '",
 
188
 
 
189
                                                                                "'Form6_DE70'","'Form6_DE71'",
 
190
                                                                                "'Form6_DE70','Form6_DE71'",
 
191
 
 
192
                                                                                "' '","' '","' '",
 
193
 
 
194
                                                                                "'Form6_DE72'","'Form6_DE73'",
 
195
                                                                                "'Form6_DE72','Form6_DE73'",
 
196
 
 
197
                                                                                "' '","' '","' '",
 
198
 
 
199
                                                                                "'Form6_DE74'","'Form6_DE75'",
 
200
                                                                                "'Form6_DE74','Form6_DE75'",
 
201
                                                                                
 
202
                                                                                "'Form6_DE76'","'Form6_DE77'",
 
203
                                                                                "'Form6_DE76','Form6_DE77'",
 
204
                                                                                
 
205
                                                                                "'Form6_DE78'","'Form6_DE79'",
 
206
                                                                                "'Form6_DE78','Form6_DE79'",
 
207
                                                                                
 
208
                                                                                "'Form6_DE80'","'Form6_DE81'",
 
209
                                                                                "'Form6_DE80','Form6_DE81'",
 
210
                                                                                
 
211
                                                                                "'Form6_DE82'","'Form6_DE83'",
 
212
                                                                                "'Form6_DE82','Form6_DE83'",
 
213
 
 
214
                                                                                "' '","' '",
 
215
                                                                                
 
216
                                                                                "'Form6_DE100','Form6_DE101'",
 
217
                                                                                "'Form6_DE106','Form6_DE107'",
 
218
 
 
219
                                                                                "' '",
 
220
 
 
221
                                                                                "'Form6_DE84','Form6_DE85'",
 
222
                                                                                "'Form6_DE90','Form6_DE91'",
 
223
 
 
224
                                                                                "' '",
 
225
 
 
226
                                                                                "'Form6_DE92','Form6_DE93'",
 
227
                                                                                "'Form6_DE98','Form6_DE99'",
 
228
 
 
229
                                                                                "' '",
 
230
 
 
231
                                                                                "'Form6_DE166','Form6_DE167'",
 
232
                                                                                "'Form6_DE168','Form6_DE169'",
 
233
 
 
234
                                                                                "' '",
 
235
 
 
236
                                                                                "'Form6_DE173','Form6_DE174'",
 
237
                                                                                "'Form6_DE179','Form6_DE180'",
 
238
 
 
239
                                                                                "' '",
 
240
 
 
241
                                                                                "'Form6_DE108','Form6_DE109'",
 
242
                                                                                "'Form6_DE114','Form6_DE115'",
 
243
 
 
244
                                                                                "' '",
 
245
 
 
246
                                                                                "'Form6_DE175','Form6_DE176'",
 
247
                                                                                "'Form6_DE116','Form6_DE117'",
 
248
                                                                                "'Form6_DE118','Form6_DE119'",
 
249
                                                                                "'Form6_DE120','Form6_DE121'",
 
250
 
 
251
                                                                                "' '",
 
252
 
 
253
                                                                                "'Form6_DE177','Form6_DE178'",
 
254
                                                                                "'Form6_DE122','Form6_DE123'",
 
255
                                                                                "'Form6_DE124','Form6_DE125'",
 
256
                                                                                "'Form6_DE126','Form6_DE127'",
 
257
                                                                                "'Form6_DE128','Form6_DE129'",
 
258
                                                                                "'Form6_DE130','Form6_DE131'",
 
259
                                                                                "'Form6_DE132','Form6_DE133'",
 
260
                                                                                "'Form6_DE134','Form6_DE135'",
 
261
                                                                                "'Form6_DE137','Form6_DE138'",
 
262
                                                                                "'Form6_DE139','Form6_DE140'",
 
263
 
 
264
                                                                                "' '",
 
265
 
 
266
                                                                                "'Form6_DE145','Form6_DE146'",
 
267
                                                                                "'Form6_DE149'",
 
268
 
 
269
                                                                                "' '","' '","' '","' '","' '",
 
270
 
 
271
                                                                                "'Form6_DE171'",
 
272
 
 
273
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
274
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
275
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
276
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
277
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
278
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",                                                                                
 
279
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
280
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
281
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
282
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
283
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
284
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
285
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
286
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
287
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
288
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
289
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
290
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
291
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
292
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
293
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
294
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '","' '"                                                                                                                                                                                                                                                                                                                                                                                                                 
 
295
 
 
296
                                                                           };
 
297
 
 
298
                 
 
299
        int dataElementIDs[] = new int[dataElementCodes.length+5];  
 
300
        int entryNumberValues[]=  new int[dataElementCodes.length+5];     
 
301
        int entryValuesForLastYear[]= new int[dataElementCodes.length+5];      
 
302
        int cumentryValuesForCurYear[]= new int[dataElementCodes.length+5];      
 
303
        int cumentryValuesForLastYear[]= new int[dataElementCodes.length+5];      
 
304
        
 
305
        String monthNames[] = { "", "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" };            
 
306
   
 
307
%>
 
308
                                
 
309
<%
 
310
     try
 
311
      {
 
312
        Class.forName ("com.mysql.jdbc.Driver").newInstance ();
 
313
        con = DriverManager.getConnection (urlForConnection, userName, password);
 
314
        
 
315
        st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
 
316
        st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
317
        st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
318
        st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
319
        st4=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
320
        st5=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
 
321
        st6=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
322
        st8=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
323
        st9=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
324
        st10=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
325
        st11=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
326
        st12=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
327
 
 
328
     
 
329
        //rs1 = st1.executeQuery("SELECT organisationunit.shortname FROM organisationunit WHERE id ="+selectedOrgUnitID);
 
330
        rs1 = st1.executeQuery("SELECT organisationunit.shortname FROM organisationunit WHERE organisationunitid ="+selectedOrgUnitID);        
 
331
        if(rs1.next())  {   selectedOrgUnitName = rs1.getString(1);     }
 
332
        else   {        selectedOrgUnitName = "";                   }  
 
333
 
 
334
        //rs11 = st11.executeQuery("select startDate,endDate from period where id = "+selectedDataPeriodID);
 
335
                //if(rs11.next())
 
336
                //  {
 
337
                //      selectedDataPeriodStartDate =  rs11.getDate(1).toString();
 
338
                //      selectedDataPeriodEndDate   =  rs11.getDate(2).toString();
 
339
                //  }
 
340
                
 
341
                selectedDataPeriodStartDate = startingDate;
 
342
                
 
343
      } // try block end
 
344
     catch(Exception e)  { out.println(e.getMessage());  }
 
345
     finally
 
346
       {
 
347
                        try
 
348
                                {
 
349
                                        if(rs1!=null)  rs1.close();                     if(st1!=null)  st1.close();
 
350
                                        if(rs11!=null)  rs11.close();           if(st11!=null)  st11.close();
 
351
                                }
 
352
                        catch(Exception e)   {  out.println(e.getMessage());   }
 
353
       } // finally block end           
 
354
 
 
355
        String partsOfDataPeriodStartDate[]  =  selectedDataPeriodStartDate.split("-");
 
356
        lastYear  = Integer.parseInt(partsOfDataPeriodStartDate[0]) - 1;
 
357
        lastDataPeriodStartDate = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
 
358
        
 
359
        int tempForMonth1 = Integer.parseInt(partsOfDataPeriodStartDate[1]);
 
360
        int tempForYear = 0;
 
361
                
 
362
        if(tempForMonth1 < 4)           {   tempForYear = lastYear;  }
 
363
        else  {   tempForYear = lastYear + 1;           }
 
364
         
 
365
         String curYearStart = tempForYear+"-04-01";
 
366
         String lastYearStart = (tempForYear-1)+"-04-01";
 
367
         String lastYearEnd = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
 
368
         
 
369
     //for district, taluk, CHC names
 
370
     try
 
371
      {
 
372
//              rs8=st8.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")");        
 
373
//                      if(rs8.next())  { PHCID = rs8.getInt(1);PHCName = rs8.getString(2);  } 
 
374
//                      else  {  PHCID = 0; PHCName = "";  } 
 
375
 
 
376
//                      rs9=st9.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+PHCID+")");     
 
377
//                      if(rs9.next())  { CHCID = rs9.getInt(1);CHCName = rs9.getString(2);  } 
 
378
//                      else  {  CHCID = 0; CHCName = "";  } 
 
379
 
 
380
//                      rs5=st5.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+CHCID+")");     
 
381
//                      if(rs5.next())  { talukID = rs5.getInt(1); talukName = rs5.getString(2);  } 
 
382
//                      else  {  talukID = 0; talukName = "";  } 
 
383
        
 
384
                    //rs6=st6.executeQuery("select organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")");
 
385
                    rs6=st6.executeQuery("select organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+selectedOrgUnitID+")"); 
 
386
                    if(rs6.next()) {  stateName = rs6.getString(1);}
 
387
                        else { stateName = "";}      
 
388
 
 
389
                        //rs10=st10.executeQuery("SELECT sum(datavalue.value) FROM organisationunit INNER JOIN (dataelement INNER JOIN datavalue ON dataelement.id = datavalue.dataElement) ON organisationunit.id = datavalue.source WHERE organisationunit.parent = "+PHCID+" AND dataelement.name like 'Total Population'");
 
390
                        rs10=st10.executeQuery("SELECT sum(datavalue.value) FROM organisationunit INNER JOIN (dataelement INNER JOIN datavalue ON dataelement.dataelementid = datavalue.dataelementid) ON organisationunit.organisationunitid = datavalue.sourceid WHERE organisationunit.parentid = "+PHCID+" AND dataelement.name like 'Total Population'");
 
391
                        if(rs10.next()) { totPHCPopulation = rs10.getInt(1);}
 
392
                        else {totPHCPopulation = 0;}      
 
393
       
 
394
       }   // try block end              
 
395
     catch(Exception e)  { out.println(e.getMessage());  }
 
396
     finally
 
397
       {
 
398
                 try
 
399
                          {
 
400
                            if(rs5!=null)  rs5.close();                 if(st5!=null)  st5.close();
 
401
                            if(rs6!=null)  rs6.close();                 if(st6!=null)  st6.close();
 
402
                            if(rs8!=null)  rs8.close();                 if(st8!=null)  st8.close();   
 
403
                            if(rs9!=null)  rs9.close();                 if(st9!=null)  st9.close();
 
404
                            if(rs10!=null)  rs10.close();               if(st10!=null)  st10.close();                                                                                                                
 
405
                          }
 
406
                catch(Exception e)   {  out.println(e.getMessage());   }
 
407
       }  // finally block end
 
408
    
 
409
     try
 
410
      {
 
411
                int i=0;    
 
412
                int j= dataElementCodes.length;
 
413
                String query = "";
 
414
                int in = 0;
 
415
                        
 
416
                while(i!=j)
 
417
                        {               
 
418
                                entryNumberValues[i]     = -1;
 
419
                                entryValuesForLastYear[i] = -1;
 
420
                                cumentryValuesForCurYear[i] = -1;
 
421
                                cumentryValuesForLastYear[i] = -1;
 
422
                                                                                                                                
 
423
                                // for Performance in the reporting month
 
424
                                //query = "SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataElement = dataelement.id WHERE datavalue.period  in (select id from period where startdate between '"+startingDate+"' and '"+startingDate+"') AND datavalue.source in (select id from organisationunit where id = "+selectedOrgUnitID+" OR id  in (select id from organisationunit where parent = "+selectedOrgUnitID+") OR parent in (select id from organisationunit where parent = "+selectedOrgUnitID+")) AND dataelement.code in ("+dataElementCodes[i]+")";
 
425
                                query = "SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataelementid = dataelement.dataelementid WHERE datavalue.periodid  in (select periodid from period where startdate between '"+startingDate+"' and '"+startingDate+"') AND datavalue.sourceid in (select organisationunitid from organisationunit where organisationunitid = "+selectedOrgUnitID+" OR organisationunitid  in (select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+") OR parentid in (select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+")) AND dataelement.code in ("+dataElementCodes[i]+")";
 
426
                                rs=st.executeQuery(query);
 
427
                                if(rs.next())  {  entryNumberValues[i] = rs.getInt(1);  } 
 
428
                                else  {  entryNumberValues[i] = 0;  } 
 
429
                                                                                                
 
430
                        // for Cumulative Performance till Current Month
 
431
                            //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 '"+selectedDataPeriodStartDate+"' and periodType = "+periodTypeID+")  AND datavalue.source in (select id from organisationunit where id = "+selectedOrgUnitID+" OR id  in (select id from organisationunit where parent = "+selectedOrgUnitID+") OR parent in (select id from organisationunit where parent = "+selectedOrgUnitID+")) AND dataelement.code in ("+dataElementCodes[i]+")";
 
432
                            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 '"+selectedDataPeriodStartDate+"' and periodtypeid = "+periodTypeID+")  AND datavalue.sourceid in (select organisationunitid from organisationunit where organisationunitid = "+selectedOrgUnitID+" OR organisationunitid  in (select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+") OR parentid in (select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+")) AND dataelement.code in ("+dataElementCodes[i]+")";       
 
433
                            rs4=st4.executeQuery(query);
 
434
                        if(rs4.next())  {  cumentryValuesForCurYear[i]= rs4.getInt(1);  } 
 
435
                            else  {  cumentryValuesForCurYear[i] = 0;  } 
 
436
                                    
 
437
                                i++;
 
438
                        }  // while loop end
 
439
      }  // try block end                
 
440
     catch(Exception e)  { out.println(e.getMessage());  }
 
441
     finally
 
442
       {
 
443
                         try
 
444
                                {
 
445
                                    if(rs!=null)  rs.close();           if(st!=null)  st.close();                                                       
 
446
                                        if(rs2!=null)  rs2.close();             if(st2!=null)  st2.close();    
 
447
                                        if(rs3!=null)  rs3.close();             if(st3!=null)  st3.close();                                     
 
448
                                        if(rs4!=null)  rs4.close();             if(st4!=null)  st4.close();
 
449
                                        if(rs12!=null)  rs12.close();   if(st12!=null)  st12.close();
 
450
                                                                                
 
451
                                        if(con!=null) con.close();                                      
 
452
                        }        
 
453
                        catch(Exception e)   {  out.println(e.getMessage());   }
 
454
       }  // finally block end                                  
 
455
%>
 
456
 
 
457
<HTML>
 
458
<HEAD>
 
459
   <TITLE> Form - 9</TITLE>
 
460
   <script src="../dhis-web-reports/Jharkhand/JDENamesForForm9.js" type="text/javascript" language="Javascript"></script>       
 
461
   <script>
 
462
                function fun1()
 
463
                { 
 
464
                    
 
465
                        var start=0;
 
466
                        var end = 28;    
 
467
                        var j=1;
 
468
                        var k=0;                
 
469
                        var id="";                      
 
470
                
 
471
                        while(j<=5)
 
472
                         {                          
 
473
                                
 
474
                                if(j==1) end = 30;
 
475
                                        else if(j==2) end = 45;
 
476
                                        else if(j==3) end = 43;
 
477
                                        else if(j==4) end = 44;
 
478
                                        else if(j==5) end = 23;
 
479
                                
 
480
                                        for(start=0;start<=end;start++)
 
481
                                         {      
 
482
                                                 id="cell1"+k;                                    
 
483
                                                 document.getElementById(id).innerHTML = slnoForForm9[k];
 
484
                                                 id="cell2"+k;                                    
 
485
                                                 document.getElementById(id).innerHTML = servicesForForm9[k];
 
486
                                                 id="cell3"+k;                                    
 
487
                                                 document.getElementById(id).innerHTML = denamesForForm9[k];
 
488
                                                 
 
489
                                                 k++;
 
490
                                         }
 
491
                                        j++; 
 
492
                                 }                                                              
 
493
                        }
 
494
        </script>                   
 
495
</HEAD>
 
496
<BODY BGCOLOR="#FFFFFF" onload="fun1()">  
 
497
        <font face="Arial" size="2">(&#2344;&#2367;&#2325;&#2344;&#2375;&#2335; &#2325;&#2375; &#2350;&#2366;&#2343;&#2381;&#2351;&#2350; &#2360;&#2375; &#2352;&#2366;&#2332;&#2381;&#2351; &#2360;&#2352;&#2325;&#2366;&#2352; &#2340;&#2341;&#2366; &#2346;&#2352;&#2367;&#2357;&#2366;&#2352; &#2325;&#2354;&#2381;&#2351;&#2366;&#2339; &#2357;&#2367;&#2349;&#2366;&#2327;, &#2349;&#2366;&#2352;&#2340; &#2360;&#2352;&#2325;&#2366;&#2352; &#2325;&#2379; &#2309;&#2357;&#2369;&#2357;&#2352;&#2381;&#2340;&#2368; &#2350;&#2361;&#2368;&#2344;&#2375; &#2325;&#2368; 25 &#2340;&#2366;&#2352;&#2368;&#2326; &#2340;&#2325; &#2346;&#2381;&#2352;&#2360;&#2381;&#2340;&#2369;&#2340; &#2325;&#2367;&#2351;&#2366; &#2332;&#2366;&#2319;)</font>
 
498
        <center>
 
499
                <font face="Arial" size="3">
 
500
                        <b>&#2347;&#2366;&#2352;&#2381;&#2350; 9 <br> &#2352;&#2366;&#2332;&#2381;&#2351;/&#2325;&#2375;&#2306;&#2342;&#2381;&#2352; &#2325;&#2375; &#2354;&#2367;&#2319; &#2332;&#2367;&#2354;&#2375; &#2325;&#2368; &#2360;&#2350;&#2375;&#2325;&#2367;&#2340; &#2350;&#2366;&#2360;&#2367;&#2325; &#2352;&#2367;&#2346;&#2379;&#2352;&#2381;&#2335;  
 
501
        </center>
 
502
        &#2360;&#2366;&#2350;&#2366;&#2344;&#2381;&#2351;
 
503
        </b></font>
 
504
                <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">
 
505
                        <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%">
 
506
                        <td width="60%" 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">
 
507
                                <font face="Arial" size="2">1. &#2352;&#2366;&#2332;&#2381;&#2351; : &nbsp;&nbsp;&nbsp;<%=stateName%></font>
 
508
                </td>
 
509
                        <td width="40%" 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">
 
510
                                <font face="Arial" size="2">4. &#2350;&#2366;&#2360; &#2325;&#2368; &#2352;&#2367;&#2346;&#2379;&#2352;&#2381;&#2335; :  &nbsp;&nbsp;<%=monthNames[Integer.parseInt(partsOfDataPeriodStartDate[1])]%> - <%=partsOfDataPeriodStartDate[0]%></font>
 
511
                </td>   
 
512
                </tr>
 
513
                <tr>
 
514
                        <td width="60%" 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">
 
515
                                <font face="Arial" size="2">2. &#2332;&#2367;&#2354;&#2366; : &nbsp;&nbsp;<%=selectedOrgUnitName%></font>
 
516
                </td>
 
517
                        <td width="40%" 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">
 
518
                                <font face="Arial" size="2">5. &#2346;&#2366;&#2340;&#2381;&#2352; &#2342;&#2350;&#2381;&#2346;&#2340;&#2367;&#2351;&#2366;&#2306; ( &#2357;&#2352;&#2381;&#2359; &#2325;&#2368; &#2346;&#2361;&#2354;&#2368; &#2309;&#2346;&#2381;&#2352;&#2376;&#2354; &#2325;&#2379;) </font>
 
519
                </td>
 
520
                </tr>           
 
521
                <tr>
 
522
                        <td width="60%" 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">
 
523
                                <font face="Arial" size="2">3. &#2332;&#2367;&#2354;&#2375; &#2325;&#2368; &#2332;&#2344;&#2360;&#2306;&#2326;&#2381;&#2351;&#2366;</font>
 
524
                </td>
 
525
                        <td width="40%" 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">
 
526
                                <font face="Arial" size="2"></font>
 
527
                </td>
 
528
                </tr>           
 
529
        </table>  
 
530
<br>
 
531
 
 
532
<%
 
533
        int i;
 
534
        int j = 1;
 
535
        int k = 0;
 
536
        int l = 0;
 
537
        int endcount = 28;
 
538
        int flag = 0;
 
539
        String tempForentryNumberValues[] = new String[12];
 
540
        String tempForcumentryValuesForCurYear[] = new String[12];
 
541
        
 
542
                        
 
543
        String temp1 = "";
 
544
        
 
545
        String temp2 = "";
 
546
        
 
547
        int temp = 0;
 
548
int bt =0;      
 
549
        while(j<=5)
 
550
         { 
 
551
           
 
552
            if(j==1) 
 
553
              { %>
 
554
                <table cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1;padding: 0" bordercolor="#111111" width="100%">
 
555
                        <tr>
 
556
                                        <td width="3%" align="center" style="border-collapse: collapse; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding-bottom:0; " bordercolor="#111111" align="left"><font face="Arial" size="2"><b>&#2325;&#2381;&#2352;. &#2360;&#2306;.</b></font></td>
 
557
                                        <td width="36%" align="center" style="border-collapse: collapse; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding-bottom:0; padding-left:15; padding-right:1; " bordercolor="#111111" ><font face="Arial" size="2"><b>&#2360;&#2375;&#2357;&#2366;</b></font></td>
 
558
                                        <td width="45%" style="border-collapse: collapse; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding-bottom:0; padding-left:3; padding-right:1; " bordercolor="#111111" dir="ltr"><font face="Arial" size="2"></font></td>
 
559
                                        <td width="16%" style="border-collapse: collapse; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding-bottom:0; padding-left:3; padding-right:1; " bordercolor="#111111" align="center" colspan="3"><font face="Arial" size="2"></font></td>
 
560
                                </tr>
 
561
                   <%                 
 
562
               }
 
563
            else if(j==2)
 
564
              { %>
 
565
                        <br><br><br><br><br>
 
566
                <table cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1;padding: 0" bordercolor="#111111" width="100%">              
 
567
              <% 
 
568
                        }
 
569
        else if(j==3)
 
570
              { %>
 
571
                        <br><br>
 
572
                <table cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1;padding: 0" bordercolor="#111111" width="100%">              
 
573
              <% 
 
574
                        }
 
575
                else if(j==4)
 
576
              { %>
 
577
                        <br><br>
 
578
                <table cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1;padding: 0" bordercolor="#111111" width="100%">              
 
579
              <% 
 
580
                        }
 
581
                else if(j==5)
 
582
              { %>
 
583
                        <br><br><br><br><br>
 
584
                <table cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1;padding: 0" bordercolor="#111111" width="100%">              
 
585
              <% 
 
586
                        }
 
587
            else
 
588
              { %>
 
589
                        <br>
 
590
                <table cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1;padding: 0" bordercolor="#111111" width="100%">              
 
591
              <% 
 
592
                        }
 
593
 
 
594
                if(j==1) endcount = 30; 
 
595
                else if(j==2) endcount = 45; 
 
596
                else if(j==3) endcount = 43;
 
597
                else if(j==4) endcount = 44;
 
598
                else if(j==5) endcount = 23;
 
599
                                                                                                
 
600
                for(i=0;i<=endcount;i++)
 
601
                  {     
 
602
                String id1="cell1"+k;
 
603
                String id2="cell2"+k;
 
604
                String id3="cell3"+k;
 
605
                            
 
606
                if((k>=53 && k<=76))
 
607
                { 
 
608
               if(k==53) 
 
609
                    {
 
610
                      tempForentryNumberValues[0]= "<b>M</b>";
 
611
                      tempForentryNumberValues[1]= "<b>F</b>";
 
612
                                  tempForentryNumberValues[2]= "<b>T</b>";
 
613
                      
 
614
                      l=l+3;
 
615
                    }
 
616
                   else if(k==2 || k==6 || k==7 || k==11 || k==12 || k==13 || k==14 || k==16 || k==19 || k==23 || k==24 || k==25 || k==26 || k==33 || k==37 || k==40 || k==41 || k==44 || k==49 || k==50 || k==51 || k==63 || k==67 || k==69 || k==71 || k==77 || k==78 || k==81 || k==84 || k==87 || k==90 || k==93 || k==96 || k==101 || k==112 || k==115)
 
617
                                {
 
618
                      tempForentryNumberValues[0]= " ";
 
619
                      tempForentryNumberValues[1]= " ";
 
620
                                  tempForentryNumberValues[2]= " ";
 
621
                      
 
622
                      l=l+3;
 
623
                    }
 
624
                    
 
625
                   else 
 
626
                    {
 
627
                                        temp =  entryNumberValues[l];
 
628
                                if(temp==-1) tempForentryNumberValues[0] = "";
 
629
                                else tempForentryNumberValues[0] = ""+temp;
 
630
// tempForentryNumberValues[0] = dataElementCodes[l];
 
631
                                        
 
632
                                        l++;
 
633
                                                         
 
634
                                temp =  entryNumberValues[l];
 
635
                                if(temp==-1) tempForentryNumberValues[1] = "";
 
636
                                else tempForentryNumberValues[1] = ""+temp;
 
637
 //tempForentryNumberValues[1] = dataElementCodes[l];
 
638
                                                                        
 
639
                                l++;
 
640
                                
 
641
                                        temp =  entryNumberValues[l];
 
642
                                if(temp==-1) tempForentryNumberValues[2] = "";
 
643
                                else tempForentryNumberValues[2] = ""+temp;
 
644
                                
 
645
                                        l++;
 
646
                    } 
 
647
                %>              
 
648
           
 
649
                <tr>
 
650
                                <td id="<%=id1%>" name="<%=id1%>" width="3%" style="border-collapse: collapse; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding-bottom:0; " bordercolor="#111111" align="left">&nbsp;</td>
 
651
                                <td id="<%=id2%>" name="<%=id2%>" width="36%" style="border-collapse: collapse; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding-bottom:0; padding-left:15; padding-right:1; " bordercolor="#111111" ></td>
 
652
                                <td id="<%=id3%>" name="<%=id3%>" width="45%" style="border-collapse: collapse; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding-bottom:0; padding-left:3; padding-right:1; " bordercolor="#111111" dir="ltr"></td>
 
653
                                <td width="5%" style="border-collapse: collapse; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding-bottom:0; padding-left:3; padding-right:1; " bordercolor="#111111" align="center"><font face="Arial" size="2"><%=tempForentryNumberValues[0]%></font></td>
 
654
                                <td width="5%" style="border-collapse: collapse; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding-bottom:0; padding-left:3; padding-right:1; " bordercolor="#111111" align="center"><font face="Arial" size="2"><%=tempForentryNumberValues[1]%></font></td>
 
655
                                <td width="6%" style="border-collapse: collapse; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding-bottom:0; padding-left:3; padding-right:1; " bordercolor="#111111" align="center"><font face="Arial" size="2"><%=tempForentryNumberValues[2]%></font></td>
 
656
                        </tr>
 
657
                
 
658
           <%   }
 
659
             else 
 
660
              {                
 
661
                         if(k==2 || k==6 || k==7 || k==11 || k==12 || k==13 || k==14 || k==16 || k==19 || k==23 || k==24 || k==25 || k==26 || k==33 || k==37 || k==40 || k==41 || k==44 || k==49 || k==50 || k==51 || k==63 || k==67 || k==69 || k==71 || k==77 || k==78 || k==81 || k==84 || k==87 || k==90 || k==93 || k==96 || k==101 || k==112 || k==115) 
 
662
                    {
 
663
                      tempForentryNumberValues[0]= "";
 
664
 
 
665
                      l++;
 
666
                     }
 
667
                         else 
 
668
                  {
 
669
                                        temp =  entryNumberValues[l];
 
670
                                if(temp==-1) tempForentryNumberValues[0] = "";
 
671
                                else tempForentryNumberValues[0] = ""+temp;
 
672
 //tempForentryNumberValues[0] = dataElementCodes[l];
 
673
                                                                        
 
674
                                        l++;
 
675
                  }     
 
676
               %>
 
677
                <tr>
 
678
                                <td id="<%=id1%>" name="<%=id1%>" width="3%" style="border-collapse: collapse; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding-bottom:0; " bordercolor="#111111" align="left">&nbsp;</td>
 
679
                                <td id="<%=id2%>" name="<%=id2%>" width="36%" style="border-collapse: collapse; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding-bottom:0; padding-left:15; padding-right:1; " bordercolor="#111111" ></td>
 
680
                                <td id="<%=id3%>" name="<%=id3%>" width="45%" style="border-collapse: collapse; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding-bottom:0; padding-left:3; padding-right:1; " bordercolor="#111111" dir="ltr"><font face="Arial" size="2"></font></td>
 
681
                                <td width="16%" style="border-collapse: collapse; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding-bottom:0; padding-left:3; padding-right:1; " bordercolor="#111111" align="center" colspan="3"><font face="Arial" size="2"><%=tempForentryNumberValues[0]%></font></td>
 
682
                        </tr>
 
683
                <% 
 
684
             }                     
 
685
                 k++;
 
686
                }               
 
687
                 j++;
 
688
                %>
 
689
                </table>
 
690
                <%
 
691
         }      
 
692
 %>
 
693
</BODY>
 
694
</HTML>
 
 
b'\\ No newline at end of file'