← Back to branch summary

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

« back to all changes in this revision

Viewing changes to local/in/dhis-web-ga/WEB-INF/src/org/hisp/gtool/action/ViewChartBean.java

  • 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-ga/WEB-INF/src/org/hisp/gtool/action/ViewChartBean.java
 
1
package org.hisp.gtool.action;
 
2
 
 
3
import java.sql.Connection;
 
4
import java.sql.ResultSet;
 
5
import java.sql.Statement;
 
6
import java.util.ArrayList;
 
7
import java.util.Collections;
 
8
import java.util.Enumeration;
 
9
import java.util.Hashtable;
 
10
import java.util.Iterator;
 
11
import java.util.List;
 
12
import java.util.Vector;
 
13
 
 
14
public class ViewChartBean {
 
15
 
 
16
        String indicatorList[];
 
17
        String orgUnitName;
 
18
        String s_Date;
 
19
        String e_Date;
 
20
        String i_category;
 
21
        String ide_type;
 
22
        
 
23
        Connection con = (new DBConnection()).openConnection();
 
24
        int periodType=1;
 
25
        int orgUnitID;
 
26
        List periodIDs;
 
27
        List indicatorIDs;
 
28
        
 
29
        String tempEDate="";
 
30
        int noOfPeriods;
 
31
        
 
32
        
 
33
                
 
34
/*      public Hashtable findChildOrgUnits()
 
35
        {
 
36
                Statement st = null;
 
37
                ResultSet rs = null;
 
38
                
 
39
                Hashtable ht = new Hashtable();
 
40
                
 
41
                try
 
42
                {
 
43
                        String query = "select shortname,id from organisationunit where parent ="+orgUnitID;
 
44
                        st = con.createStatement();
 
45
                        rs = st.executeQuery(query);
 
46
                                                
 
47
                        while(rs.next())
 
48
                        {
 
49
                                ht.put(rs.getString(1),new Integer(rs.getInt(2)));
 
50
                        }// while loop end                      
 
51
                } // try block end
 
52
                catch(Exception e)
 
53
                {
 
54
                        System.out.println(e.getMessage()); return null;
 
55
                }
 
56
                finally
 
57
                {
 
58
                        try
 
59
                        {
 
60
                                if(rs!=null) rs.close();
 
61
                                if(st!=null) st.close();
 
62
                        }
 
63
                        catch(Exception e){System.out.println(e.getMessage());return null;}
 
64
                }// finally block end   
 
65
                
 
66
                return ht;
 
67
        } // findChildOrgUnits end
 
68
        
 
69
*/      
 
70
        
 
71
        public Hashtable setPeriodIDs()
 
72
        {
 
73
                Statement st = null;
 
74
                ResultSet rs = null;
 
75
                
 
76
                Statement st1 = null;
 
77
                ResultSet rs1 = null;
 
78
                
 
79
                String partsOfEDate[] = e_Date.split("-");
 
80
                tempEDate = partsOfEDate[0]+"-"+partsOfEDate[1]+"-01";
 
81
                
 
82
                Hashtable ht = new Hashtable();
 
83
                                        
 
84
                try
 
85
                {
 
86
                        String query = "";
 
87
                        if(i_category.equals("Period")) 
 
88
                                /*
 
89
                                query ="select startdate,id from period where startDate between '"+s_Date+"' and '"+tempEDate+"' and periodType="+periodType+" order by startdate";
 
90
                                */
 
91
                                query ="SELECT startdate,periodid FROM period " +
 
92
                                                        "WHERE startDate BETWEEN '"+s_Date+"' AND" +
 
93
                                                                        " '"+tempEDate+"' AND" +
 
94
                                                                        " periodtypeid="+periodType+" ORDER BY startdate";
 
95
                        else if(i_category.equals("Facility"))
 
96
                                /*
 
97
                                query = "select shortname,id from organisationunit where parent ="+orgUnitID;
 
98
                                */
 
99
                                query = "SELECT shortname,organisationunitid FROM organisationunit WHERE parentid ="+orgUnitID;                                         
 
100
                        st = con.createStatement();
 
101
                        st1 = con.createStatement();
 
102
                        
 
103
                        rs = st.executeQuery(query);
 
104
                                                
 
105
                        while(rs.next())
 
106
                        {                                                       
 
107
                                ht.put(rs.getString(1),new Integer(rs.getInt(2)));
 
108
                        }// while loop end      
 
109
                        
 
110
                        
 
111
                        if(i_category.equals("Period"))
 
112
                        {
 
113
                                noOfPeriods = 1;
 
114
                        }                               
 
115
                        else if(i_category.equals("Facility"))
 
116
                        {
 
117
                                /*
 
118
                                query = "select count(*) from period where startDate between '"+s_Date+"' and '"+tempEDate+"' and periodType="+periodType+" order by startdate";
 
119
                                */
 
120
                                query = "SELECT COUNT(*) FROM period " +
 
121
                                                        "WHERE startDate BETWEEN '"+s_Date+"' AND '"+tempEDate+"' AND" +
 
122
                                                                        " periodtypeid = "+periodType+" ORDER BY startdate";
 
123
                                rs1 = st1.executeQuery(query);
 
124
                                if(rs1.next()) noOfPeriods = rs1.getInt(1);
 
125
                                else noOfPeriods = 1;                                                   
 
126
                        }                                                                       
 
127
                } // try block end
 
128
                catch(Exception e)
 
129
                {
 
130
                        return null;
 
131
                }
 
132
                finally
 
133
                {
 
134
                        try
 
135
                        {
 
136
                                if(rs!=null) rs.close();
 
137
                                if(st!=null) st.close();
 
138
                        }
 
139
                        catch(Exception e){ return null;}
 
140
                }// finally block end                           
 
141
                return ht;                                                      
 
142
        } // setPeriodID end
 
143
        
 
144
        
 
145
        
 
146
        public Hashtable setIndicatorIDs()
 
147
        {
 
148
                                                                        
 
149
                Statement st = null;
 
150
                ResultSet rs = null;                            
 
151
                
 
152
                Hashtable ht = new Hashtable();
 
153
                                
 
154
                int count=0;
 
155
                
 
156
                try
 
157
                {
 
158
                        String query = "";
 
159
                        st = con.createStatement();
 
160
                        while(count<indicatorList.length)
 
161
                        {
 
162
                                if(ide_type.equals("indicatorsRadio"))                                  
 
163
                                        //query = "select id,Target from indicator where name like '"+indicatorList[count]+"'";
 
164
                                        query = "SELECT indicatorid,Target FROM indicator WHERE name LIKE '"+indicatorList[count]+"'";
 
165
                                else 
 
166
                                        //query = "select id from dataelement where shortname like '"+indicatorList[count]+"'";
 
167
                                        query = "SELECT dataelementid FROM dataelement WHERE alternativeName LIKE '"+indicatorList[count]+"'";
 
168
                                rs = st.executeQuery(query);
 
169
                                
 
170
                                if(rs.next())   { ht.put(indicatorList[count],new Integer(rs.getInt(1)));}
 
171
                                count++;
 
172
                        }// while loop end      
 
173
                } // try block end
 
174
                catch(Exception e)
 
175
                {
 
176
                        return null;
 
177
                }
 
178
                finally
 
179
                {
 
180
                        try
 
181
                        {
 
182
                                if(rs!=null) rs.close();
 
183
                                if(st!=null) st.close();
 
184
                        }
 
185
                        catch(Exception e){ return null;}
 
186
                }// finally block end
 
187
                return ht;
 
188
        } // setPeriodID end
 
189
        
 
190
        
 
191
        // Target Values
 
192
        public Hashtable getTargetValues()
 
193
        {
 
194
                                                                        
 
195
                Statement st = null;
 
196
                ResultSet rs = null;                            
 
197
                
 
198
                Hashtable ht = new Hashtable();
 
199
                                
 
200
                int count=0;
 
201
                
 
202
                try
 
203
                {
 
204
                        st = con.createStatement();
 
205
                        while(count<indicatorList.length)
 
206
                        {
 
207
                                String query = "select Target from indicator where name like '"+indicatorList[count]+"'";
 
208
                                                                
 
209
                                rs = st.executeQuery(query);
 
210
                                
 
211
                                if(rs.next())   { ht.put(indicatorList[count],new Double(rs.getDouble(1)));}
 
212
                                else { ht.put(indicatorList[count],new Double(0.0));} 
 
213
                                count++;
 
214
                        }// while loop end      
 
215
                } // try block end
 
216
                catch(Exception e)
 
217
                {
 
218
                        return null;
 
219
                }
 
220
                finally
 
221
                {
 
222
                        try
 
223
                        {
 
224
                                if(rs!=null) rs.close();
 
225
                                if(st!=null) st.close();
 
226
                        }
 
227
                        catch(Exception e){ return null;}
 
228
                }// finally block end
 
229
                return ht;
 
230
        } // getTargetValues end
 
231
        
 
232
        
 
233
        // Indicator Numerator Formula
 
234
        public Hashtable getIndNumeratorFormula()
 
235
        {
 
236
                                                                        
 
237
                Statement st = null;
 
238
                ResultSet rs = null;                            
 
239
                
 
240
                Hashtable ht = new Hashtable();
 
241
                                
 
242
                int count=0;
 
243
                
 
244
                try
 
245
                {
 
246
                        st = con.createStatement();
 
247
                        while(count<indicatorList.length)
 
248
                        {
 
249
                                //String query = "select numeratorDescription from indicator where name like '"+indicatorList[count]+"'";
 
250
                                String query = "SELECT numeratordescription FROM indicator WHERE name LIKE '"+indicatorList[count]+"'";                         
 
251
                                rs = st.executeQuery(query);
 
252
                                
 
253
                                if(rs.next())   { ht.put(indicatorList[count],rs.getString(1));}
 
254
                                else { ht.put(indicatorList[count]," ");}
 
255
                                                                
 
256
                                count++;
 
257
                        }// while loop end      
 
258
                } // try block end
 
259
                catch(Exception e)
 
260
                {
 
261
                        return null;
 
262
                }
 
263
                finally
 
264
                {
 
265
                        try
 
266
                        {
 
267
                                if(rs!=null) rs.close();
 
268
                                if(st!=null) st.close();
 
269
                        }
 
270
                        catch(Exception e){ return null;}
 
271
                }// finally block end
 
272
                return ht;
 
273
        } // getIndNumeratorFormula end
 
274
        
 
275
        
 
276
        
 
277
        // Indicator Denominator Formula
 
278
        public Hashtable getIndDenominatorFormula()
 
279
        {
 
280
                                                                        
 
281
                Statement st = null;
 
282
                ResultSet rs = null;                            
 
283
                
 
284
                Hashtable ht = new Hashtable();
 
285
                                
 
286
                int count=0;
 
287
                
 
288
                try
 
289
                {
 
290
                        st = con.createStatement();
 
291
                        while(count<indicatorList.length)
 
292
                        {
 
293
                                //String query = "select denominatorDescription from indicator where name like '"+indicatorList[count]+"'";
 
294
                                String query = "SELECT denominatordescription FROM indicator WHERE name LIKE '"+indicatorList[count]+"'";
 
295
                                
 
296
                                rs = st.executeQuery(query);
 
297
                                
 
298
                                if(rs.next())   { ht.put(indicatorList[count],rs.getString(1));}
 
299
                                else { ht.put(indicatorList[count],"");} 
 
300
                                count++;
 
301
                        }// while loop end      
 
302
                } // try block end
 
303
                catch(Exception e)
 
304
                {
 
305
                        return null;
 
306
                }
 
307
                finally
 
308
                {
 
309
                        try
 
310
                        {
 
311
                                if(rs!=null) rs.close();
 
312
                                if(st!=null) st.close();
 
313
                        }
 
314
                        catch(Exception e){ return null;}
 
315
                }// finally block end
 
316
                return ht;
 
317
        } // getIndDenominatorFormula end
 
318
 
 
319
 
 
320
        //       Indicator Denominator DataElements
 
321
        public Hashtable getIndDenominatorDEs()
 
322
        {
 
323
                                                                        
 
324
                Statement st = null;
 
325
                ResultSet rs = null;                            
 
326
                
 
327
                Hashtable ht = new Hashtable();
 
328
                
 
329
                int count=0;
 
330
                
 
331
                try
 
332
                {
 
333
                        st = con.createStatement();
 
334
                        while(count<indicatorList.length)
 
335
                        {
 
336
                                String deNames = "";
 
337
                                String query = "select denominator from indicator where name like '"+indicatorList[count]+"'";                                                          
 
338
                                rs = st.executeQuery(query);                            
 
339
                                if(rs.next())   
 
340
                                        { 
 
341
                                                deNames = getDEsofNandD(rs.getString(1));
 
342
                                                ht.put(indicatorList[count],deNames);
 
343
                                        }// if end
 
344
                                else { ht.put(indicatorList[count],"");}
 
345
                                 
 
346
                                count++;
 
347
                        }// while loop end      
 
348
                } // try block end
 
349
                catch(Exception e)
 
350
                {
 
351
                        return null;
 
352
                }
 
353
                finally
 
354
                {
 
355
                        try
 
356
                        {
 
357
                                if(rs!=null) rs.close();
 
358
                                if(st!=null) st.close();
 
359
                        }
 
360
                        catch(Exception e){ return null;}
 
361
                }// finally block end
 
362
                return ht;
 
363
        } // getIndDenominatorDEs end
 
364
        
 
365
        
 
366
//       Indicator Numerator DataElements
 
367
        public Hashtable getIndNumeratorDEs()
 
368
        {
 
369
                                                                        
 
370
                Statement st = null;
 
371
                ResultSet rs = null;                            
 
372
                
 
373
                Hashtable ht = new Hashtable();
 
374
                
 
375
                int count=0;
 
376
                
 
377
                try
 
378
                {
 
379
                        st = con.createStatement();
 
380
                        while(count<indicatorList.length)
 
381
                        {
 
382
                                String deNames = "";
 
383
                                String query = "select numerator from indicator where name like '"+indicatorList[count]+"'";                                                            
 
384
                                rs = st.executeQuery(query);                            
 
385
                                if(rs.next())   
 
386
                                        { 
 
387
                                                deNames = getDEsofNandD(rs.getString(1));
 
388
                                                ht.put(indicatorList[count],deNames);
 
389
                                        }// if end
 
390
                                else { ht.put(indicatorList[count],"");}
 
391
                                 
 
392
                                count++;
 
393
                        }// while loop end      
 
394
                } // try block end
 
395
                catch(Exception e)
 
396
                {
 
397
                        return null;
 
398
                }
 
399
                finally
 
400
                {
 
401
                        try
 
402
                        {
 
403
                                if(rs!=null) rs.close();
 
404
                                if(st!=null) st.close();
 
405
                        }
 
406
                        catch(Exception e){ return null;}
 
407
                }// finally block end
 
408
                return ht;
 
409
        } // getIndNumeratorDEs end
 
410
        
 
411
        // get DataelementList of Numerator or Denominator 
 
412
        public String getDEsofNandD(String tempSD)
 
413
        {
 
414
                Statement st = null;
 
415
                ResultSet rs = null;    
 
416
                
 
417
                char[] tempCD = tempSD.toCharArray();
 
418
                String deNames="";
 
419
                String temp1="";
 
420
                int flag=0;
 
421
                try
 
422
                {
 
423
                        st = con.createStatement();
 
424
                        
 
425
                        for(int i=0;i<tempCD.length;i++)
 
426
                        {                                                          
 
427
                                if(tempCD[i]=='[') { flag=1;temp1 = ""; }
 
428
                                else if(tempCD[i]==']') 
 
429
                                {
 
430
                                        flag=2;
 
431
                                        int itemp = Integer.parseInt(temp1);
 
432
                                        //String query = "select alternativeName from dataelement where id="+itemp;
 
433
                                        String query = "select alternativeName from dataelement where dataelementid="+itemp;
 
434
                                        rs = st.executeQuery(query);                                    
 
435
                                        if(rs.next())   {       deNames+=rs.getString(1)+", ";  }
 
436
                                }
 
437
                                else    if(flag==1) temp1 += tempCD[i];
 
438
                        }// for end             
 
439
                } // try block end
 
440
                catch(Exception e)      {       return null; }
 
441
                finally
 
442
                {
 
443
                        try
 
444
                        {
 
445
                                if(rs!=null) rs.close();
 
446
                                if(st!=null) st.close();
 
447
                        }
 
448
                        catch(Exception e){ return null;}
 
449
                }// finally block end
 
450
                
 
451
                return deNames;
 
452
        }// end function getDEsofNandD
 
453
        
 
454
        //       Indicator Factor
 
455
        public Hashtable getIndFactor()
 
456
        {
 
457
                                                                        
 
458
                Statement st = null;
 
459
                ResultSet rs = null;                            
 
460
                
 
461
                Hashtable ht = new Hashtable();
 
462
                                
 
463
                int count=0;
 
464
                
 
465
                try
 
466
                {
 
467
                        st = con.createStatement();
 
468
                        while(count<indicatorList.length)
 
469
                        {
 
470
                                //String query = "select indicatortype.factor from indicatortype inner join indicator on indicatortype.id = indicator.indicatorType where indicator.name like '"+indicatorList[count]+"'";
 
471
                                String query = "SELECT indicatortype.indicatorfactor FROM indicatortype " +
 
472
                                                                        "INNER JOIN indicator ON indicatortype.indicatortypeid = indicator.indicatortypeid " +
 
473
                                                                        "WHERE indicator.name LIKE '"+indicatorList[count]+"'";                         
 
474
                                rs = st.executeQuery(query);
 
475
                                
 
476
                                if(rs.next())   { ht.put(indicatorList[count],rs.getString(1));}
 
477
                                else { ht.put(indicatorList[count],"");} 
 
478
                                count++;
 
479
                        }// while loop end      
 
480
                } // try block end
 
481
                catch(Exception e)
 
482
                {
 
483
                        return null;
 
484
                }
 
485
                finally
 
486
                {
 
487
                        try
 
488
                        {
 
489
                                if(rs!=null) rs.close();
 
490
                                if(st!=null) st.close();
 
491
                        }
 
492
                        catch(Exception e){ return null;}
 
493
                }// finally block end
 
494
                return ht;
 
495
        } // getIndFactor end
 
496
        
 
497
        
 
498
        
 
499
        public Hashtable getValuesByPeriod()
 
500
        {
 
501
                Statement st1 = null;
 
502
                ResultSet rs1 = null;
 
503
                
 
504
                Statement st2 = null;
 
505
                ResultSet rs2 = null;
 
506
                
 
507
                //int orgUnitLevel = 4;
 
508
                                        
 
509
                Hashtable ht = new Hashtable();
 
510
                                        
 
511
                try
 
512
                {                       
 
513
                        st1 = con.createStatement();
 
514
                        st2 = con.createStatement();
 
515
                        
 
516
                        //rs2 =  st2.executeQuery("select level from organisationunitstructure where source = "+orgUnitID);
 
517
                        //if(rs2.next()) orgUnitLevel = rs2.getInt(1);
 
518
                        
 
519
                        //if(orgUnitLevel==1)
 
520
                        
 
521
                        Hashtable htForIndicator = setIndicatorIDs();
 
522
                        Enumeration keysForIndicator = htForIndicator.keys();
 
523
                        
 
524
                        while(keysForIndicator.hasMoreElements())
 
525
                        {
 
526
                                String keyI = (String) keysForIndicator.nextElement();
 
527
                                int iID = ((Integer)htForIndicator.get(keyI)).intValue();
 
528
                                
 
529
                                List liForValues = new ArrayList();
 
530
                                Hashtable htForPeriods = setPeriodIDs();
 
531
                                //Enumeration keysForPeriod = htForPeriods.keys();
 
532
                                
 
533
                                Vector vForPeriods = new Vector(htForPeriods.keySet());
 
534
                                Collections.sort(vForPeriods);
 
535
                            Iterator iteratorForPeriod = vForPeriods.iterator();
 
536
                                while(iteratorForPeriod.hasNext())
 
537
                                {                               
 
538
                                        String keyP = (String) iteratorForPeriod.next();;
 
539
                                        int pID = ((Integer)htForPeriods.get(keyP)).intValue();
 
540
                                        String query = "";
 
541
                                        if(i_category.equals("Period")) 
 
542
                                        {
 
543
                                                if(ide_type.equals("indicatorsRadio")) 
 
544
                                                        //query ="select sum(value) from aggregatedindicatorvalue where periodTypeId ="+periodType+" and organisationUnitId in (select id from organisationunit where id ="+orgUnitID+") and indicatorID="+iID+" and periodID="+pID;
 
545
                                                        query ="SELECT SUM(value) FROM aggregatedindicatorvalue " +
 
546
                                                                                "WHERE periodtypeid ="+periodType+" AND " +
 
547
                                                                                                "organisationunitid ="+orgUnitID+" AND " +
 
548
                                                                                                "indicatorid="+iID+" AND " +
 
549
                                                                                                "periodid="+pID;
 
550
                                                else    
 
551
                                                        //query ="select value from aggregateddatavalue where periodTypeId ="+periodType+" and organisationUnitId="+orgUnitID+" and dataElementId="+iID+" and periodID="+pID;
 
552
                                                        query ="SELECT value FROM aggregateddatavalue " +
 
553
                                                                                "WHERE periodtypeid ="+periodType+" AND " +
 
554
                                                                                                "organisationunitid="+orgUnitID+" AND " +
 
555
                                                                                                "dataelementid="+iID+" AND " +
 
556
                                                                                                "periodid="+pID;
 
557
                                        }       
 
558
                                        else if(i_category.equals("Facility"))
 
559
                                        {                                                                                       
 
560
                                                if(ide_type.equals("indicatorsRadio")) 
 
561
                                                        //query = "select sum(value) from aggregatedindicatorvalue where periodTypeId ="+periodType+" and organisationUnitId in (select id from organisationunit where id ="+pID+") and indicatorID="+iID+" and periodID in (select id from period where startdate between '"+s_Date+"' and '"+tempEDate+"' and periodtype="+periodType+")";
 
562
                                                        query = "SELECT sum(value) FROM aggregatedindicatorvalue " +
 
563
                                                                                "WHERE periodtypeid ="+periodType+" AND " +
 
564
                                                                                                "organisationunitid ="+pID+" AND " +
 
565
                                                                                                "indicatorid="+iID+" AND " +
 
566
                                                                                                "periodid IN (SELECT periodid FROM period WHERE startdate BETWEEN '"+s_Date+"' AND '"+tempEDate+"' AND periodtypeid="+periodType+")";
 
567
                                                else 
 
568
                                                {
 
569
                                                        //query = "select sum(value) from aggregateddatavalue where periodTypeId ="+periodType+" and organisationUnitId="+pID+" and dataElementId="+iID+" and periodID in (select id from period where startdate between '"+s_Date+"' and '"+tempEDate+"' and periodtype="+periodType+")";
 
570
                                                        query = "SELECT SUM(value) FROM aggregateddatavalue " +
 
571
                                                                                "WHERE periodtypeid ="+periodType+" AND " +
 
572
                                                                                                "organisationunitid="+pID+" AND " +
 
573
                                                                                                "dataelementid="+iID+" AND " +
 
574
                                                                                                "periodid IN (SELECT periodid FROM period WHERE startdate BETWEEN '"+s_Date+"' AND '"+tempEDate+"' AND periodtypeid="+periodType+")";
 
575
                                                        noOfPeriods=1;
 
576
                                                }
 
577
                                        }       
 
578
                                        rs1 = st1.executeQuery(query);                                  
 
579
                                        if(rs1.next()) liForValues.add(new Double( (Math.round(rs1.getDouble(1)*Math.pow(10,2))/Math.pow(10,2))/noOfPeriods));
 
580
                                        else liForValues.add(new Double(0));                                                                                                                                                                                                    
 
581
                                }// period while loop end
 
582
                                ht.put(keyI,liForValues);                                                                                       
 
583
                                
 
584
                        }// indicator while loop end
 
585
                } // try block end
 
586
                catch(Exception e)
 
587
                {
 
588
                        System.out.println(e.getMessage());return null;
 
589
                }
 
590
                finally
 
591
                {
 
592
                        try
 
593
                        {
 
594
                                if(rs1!=null) rs1.close();
 
595
                                if(st1!=null) st1.close();
 
596
                                
 
597
                                if(rs2!=null) rs2.close();
 
598
                                if(st2!=null) st2.close();
 
599
                        }
 
600
                        catch(Exception e){System.out.println(e.getMessage());return null;}
 
601
                }// finally block end           
 
602
                
 
603
                return ht;
 
604
                
 
605
                
 
606
        }// getValues end
 
607
 
 
608
        
 
609
 
 
610
        public String getI_category() {
 
611
                return i_category;
 
612
        }
 
613
 
 
614
 
 
615
        public void setI_category(String i_category) {
 
616
                this.i_category = i_category;
 
617
        }
 
618
 
 
619
 
 
620
        public Connection getCon() {
 
621
                return con;
 
622
        }
 
623
 
 
624
 
 
625
        public void setCon(Connection con) {
 
626
                this.con = con;
 
627
        }
 
628
 
 
629
 
 
630
        public List getIndicatorIDs() {
 
631
                return indicatorIDs;
 
632
        }
 
633
 
 
634
 
 
635
        public void setIndicatorIDs(List indicatorIDs) {
 
636
                this.indicatorIDs = indicatorIDs;
 
637
        }
 
638
 
 
639
 
 
640
        public String[] getIndicatorList() {
 
641
                return indicatorList;
 
642
        }
 
643
 
 
644
 
 
645
        public void setIndicatorList(String[] indicatorList) {
 
646
                this.indicatorList = indicatorList;
 
647
        }
 
648
 
 
649
 
 
650
        public int getOrgUnitID() {
 
651
                return orgUnitID;
 
652
        }
 
653
 
 
654
 
 
655
        public void setOrgUnitID(int orgUnitID) {
 
656
                this.orgUnitID = orgUnitID;
 
657
        }
 
658
 
 
659
 
 
660
        public String getOrgUnitName() {
 
661
                return orgUnitName;
 
662
        }
 
663
 
 
664
 
 
665
        public void setOrgUnitName(String orgUnitName) {
 
666
                this.orgUnitName = orgUnitName;
 
667
        }
 
668
 
 
669
 
 
670
        public List getPeriodIDs() {
 
671
                return periodIDs;
 
672
        }
 
673
 
 
674
 
 
675
        public void setPeriodIDs(List periodIDs) {
 
676
                this.periodIDs = periodIDs;
 
677
        }
 
678
 
 
679
 
 
680
        public int getPeriodType() {
 
681
                return periodType;
 
682
        }
 
683
 
 
684
 
 
685
        public void setPeriodType(int periodType) {
 
686
                this.periodType = periodType;
 
687
        }
 
688
 
 
689
 
 
690
        public String getE_Date() {
 
691
                return e_Date;
 
692
        }
 
693
 
 
694
 
 
695
        public void setE_Date(String date) {
 
696
                e_Date = date;
 
697
        }
 
698
 
 
699
 
 
700
        public String getS_Date() {
 
701
                return s_Date;
 
702
        }
 
703
 
 
704
 
 
705
        public void setS_Date(String date) {
 
706
                s_Date = date;
 
707
        }
 
708
 
 
709
 
 
710
 
 
711
        public int getNoOfPeriods() {
 
712
                return noOfPeriods;
 
713
        }
 
714
 
 
715
 
 
716
 
 
717
        public void setNoOfPeriods(int noOfPeriods) {
 
718
                this.noOfPeriods = noOfPeriods;
 
719
        }
 
720
 
 
721
        public String getTempEDate() {
 
722
                return tempEDate;
 
723
        }
 
724
 
 
725
 
 
726
 
 
727
        public void setTempEDate(String tempEDate) {
 
728
                this.tempEDate = tempEDate;
 
729
        }
 
730
 
 
731
 
 
732
 
 
733
        public String getIde_type() {
 
734
                return ide_type;
 
735
        }
 
736
 
 
737
 
 
738
 
 
739
        public void setIde_type(String ide_type) {
 
740
                this.ide_type = ide_type;
 
741
        }
 
742
}