← 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/jform2.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/jform2.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
                                                                                // Element Group 1 + 2
 
93
                                                                                "' '", "'Form10_DE1'", "'Form10_DE2'", "' '","' '","' '","'Form10_DE3'", "'Form10_DE4'", "'Form10_DE5'", "'Form10_DE6'", "'Form10_DE7'", 
 
94
                                                                                "'Form10_DE8'","'Form10_DE9'", "'Form10_DE10'", "'Form10_DE11'", "'Form10_DE12'", "'Form10_DE13'", "'Form10_DE14'", "'Form10_DE15'",
 
95
                                                                                "'Form10_DE16'", "'Form10_DE17'", "'Form10_DE1501'", "'Form10_DE25'", "'Form10_DE1502'","'Form10_DE21'", "'Form10_DE22'", "'Form10_DE23'", 
 
96
                                                                                "'Form10_DE24'", "'Form10_DE19'", "'Form10_DE26'", "'Form10_DE27'", "'Form10_DE28'", "'Form10_DE29'", "'Form10_DE30'", "'Form10_DE31'", 
 
97
                                                                                "'Form10_DE32'", "'Form10_DE33'", "'Form10_DE34'", "'Form10_DE35'", "'Form10_DE36'", "'Form10_DE37'", "'Form10_DE38'", 
 
98
                                                                                
 
99
                                                                                // 2.7
 
100
                                                                                "'Form10_DE39','Form10_DE42','Form10_DE45'",
 
101
                                                                                "'Form10_DE40','Form10_DE43','Form10_DE46'",
 
102
                                                                                "'Form10_DE41','Form10_DE44','Form10_DE47'",
 
103
                                                                                
 
104
                                                                                "'Form10_DE39'", "'Form10_DE40'", "'Form10_DE41'", "'Form10_DE42'", "'Form10_DE43'",    "'Form10_DE44'", "'Form10_DE45'", "'Form10_DE46'", 
 
105
                                                                                "'Form10_DE47'",        "'Form10_DE48'", "'Form10_DE49'", "'Form10_DE50'", "'Form10_DE51'", "'Form10_DE52'", "'Form10_DE53'", "'Form10_DE54'", 
 
106
                                                                                "'Form10_DE55'","'Form10_DE56'", 
 
107
                                                                                                                                                                                                                                
 
108
                                                                                "' '","' '","' '", 
 
109
                                                
 
110
                                                                                // 3.0
 
111
                                                                                " 'Form10_DE60','Form10_DE63','Form10_DE66','Form10_DE69','Form10_DE75','Form11_DE4','Form11_DE7','Form10_DE78','Form10_DE81'",
 
112
                                                                                " 'Form10_DE61','Form10_DE64','Form10_DE67','Form10_DE70','Form10_DE76','Form11_DE5','Form11_DE8','Form10_DE79','Form10_DE82'",
 
113
                                                                                " 'Form10_DE62','Form10_DE65','Form10_DE68','Form10_DE71','Form10_DE77','Form11_DE6','Form11_DE9','Form10_DE80','Form10_DE83'",
 
114
                                                                        
 
115
                                                                                // 3.1
 
116
                                                                                " 'Form10_DE60','Form10_DE63','Form10_DE66','Form10_DE69' ",
 
117
                                                                                " 'Form10_DE61','Form10_DE64','Form10_DE67','Form10_DE70' ",
 
118
                                                                                " 'Form10_DE62','Form10_DE65','Form10_DE68','Form10_DE71' ",
 
119
 
 
120
                                                                                "'Form10_DE60'", "'Form10_DE61'", "'Form10_DE62'",      "'Form10_DE63'", "'Form10_DE64'", "'Form10_DE65'", "'Form10_DE66'", "'Form10_DE67'",
 
121
                                                                                "'Form10_DE68'", "'Form10_DE69'", "'Form10_DE70'", "'Form10_DE71'",
 
122
                                                                                
 
123
                                                                                // 3.2
 
124
                                                                                " 'Form10_DE75','Form11_DE4','Form11_DE7' ",
 
125
                                                                                " 'Form10_DE76','Form11_DE5','Form11_DE8' ",
 
126
                                                                                " 'Form10_DE77','Form11_DE6','Form11_DE9' ",
 
127
                                                                                
 
128
                                                                                "'Form10_DE75'", "'Form10_DE76'", "'Form10_DE77'", "'Form11_DE4'","'Form11_DE5'","'Form11_DE6'", "'Form11_DE7'","'Form11_DE8'","'Form11_DE9'",
 
129
 
 
130
                                                                                // 3.3
 
131
                                                                                " 'Form10_DE78','Form10_DE81' ",
 
132
                                                                                " 'Form10_DE79','Form10_DE82' ",
 
133
                                                                                " 'Form10_DE80','Form10_DE83' ",
 
134
 
 
135
                                                                                "'Form10_DE78'", "'Form10_DE79'", "'Form10_DE80'", "'Form10_DE81'", "'Form10_DE82'", "'Form10_DE83'", 
 
136
 
 
137
                                                                                "' '","' '","' '","' '","' '","' '",
 
138
                                                                                
 
139
                                                                                // 4.1
 
140
                                                                                " 'Form10_DE84' ",
 
141
                                                                                " 'Form10_DE85' ",
 
142
                                                                                " 'Form10_DE86' ",
 
143
                                                                                " 'Form10_DE87' ",
 
144
                                                                                " 'Form10_DE88' ",
 
145
                                                                                " 'Form10_DE89' ",
 
146
 
 
147
 
 
148
                                                                                "'Form10_DE84'", "'Form10_DE85'", "'Form10_DE86'", "'Form10_DE87'", "'Form10_DE88'", "'Form10_DE89'", "'Form10_DE90'", "'Form10_DE91'", 
 
149
                                                                                "'Form10_DE92'", "'Form10_DE93'", "'Form10_DE94'", "'Form10_DE95'", 
 
150
                                                                                
 
151
                                                                                "' '","' '","' '","' '","' '","' '",
 
152
                                                                                 
 
153
                                                                                "'Form10_DE96'", "'Form10_DE97'", "'Form10_DE98'", "'Form10_DE99'", "'Form10_DE100'", "'Form10_DE101'", "'Form10_DE102'","'Form10_DE103'", 
 
154
                                                                                "'Form10_DE104'", "'Form10_DE105'", "'Form10_DE106'", "'Form10_DE107'", "'Form10_DE108'", "'Form10_DE109'", "'Form10_DE110'", "'Form10_DE111'",
 
155
                                                                                "'Form10_DE112'", "'Form10_DE113'",
 
156
                                                                                
 
157
                                                                                // 4.3
 
158
                                                                                " 'Form10_DE117','Form10_DE123' ",
 
159
                                                                                " 'Form10_DE118','Form10_DE124' ",
 
160
                                                                                " 'Form10_DE119','Form10_DE125' ",
 
161
                                                                                " 'Form10_DE120','Form10_DE126' ",      
 
162
                                                                                " 'Form10_DE121','Form10_DE127' ",
 
163
                                                                                " 'Form10_DE122','Form10_DE128' ",
 
164
                                                                                                                                                                
 
165
                                                                                "'Form10_DE117'", "'Form10_DE118'", "'Form10_DE119'", "'Form10_DE120'", "'Form10_DE121'", "'Form10_DE122'", "'Form10_DE123'", "'Form10_DE124'", 
 
166
                                                                                "'Form10_DE125'", "'Form10_DE126'", "'Form10_DE127'", "'Form10_DE128'", 
 
167
                                                                                
 
168
                                                                                // 4.4
 
169
                                                                                " 'Form11_DE10','Form11_DE13' ",
 
170
                                                                                " 'Form11_DE11','Form11_DE14' ",
 
171
                                                                                " 'Form11_DE12','Form11_DE15' ",
 
172
                                                                                
 
173
                                                                                "'Form11_DE10'", "'Form11_DE11'","'Form11_DE12'","'Form11_DE13'","'Form11_DE14'","'Form11_DE15'",
 
174
                                                                                                                                                                
 
175
                                                                                "' '","' '","' '", 
 
176
                                                                                                                                                                
 
177
                                                                                // 5.1
 
178
                                                                                " 'Form10_DE135','Form10_DE138','Form10_DE141','Form10_DE144','Form10_DE147' ",
 
179
                                                                                " 'Form10_DE136','Form10_DE139','Form10_DE142','Form10_DE145','Form10_DE148' ",
 
180
                                                                                " 'Form10_DE137','Form10_DE140','Form10_DE143','Form10_DE146','Form10_DE149' ",
 
181
 
 
182
                                                                                "'Form10_DE135'", "'Form10_DE136'", "'Form10_DE137'", "'Form10_DE138'", "'Form10_DE139'", "'Form10_DE140'", "'Form10_DE141'", "'Form10_DE142'", 
 
183
                                                                                "'Form10_DE143'", "'Form10_DE144'", "'Form10_DE145'", "'Form10_DE146'", "'Form10_DE147'", "'Form10_DE148'", "'Form10_DE149'", "'Form10_DE150'", 
 
184
                                                                                "'Form10_DE151'", "'Form10_DE152'", "'Form10_DE153'", "'Form10_DE154'", "'Form10_DE155'", "'Form10_DE156'", "'Form10_DE157'", "'Form10_DE158'", 
 
185
                                                                                "'Form10_DE159'", "'Form10_DE160'", "'Form10_DE161'",
 
186
                                                                                
 
187
                                                                                "' '","' '","' '",
 
188
                                                                                
 
189
                                                                                // 6.1
 
190
                                                                                " 'Form11_DE16','Form11_DE19' ",
 
191
                                                                                " 'Form11_DE17','Form11_DE20' ",
 
192
                                                                                " 'Form11_DE18','Form11_DE21' ",
 
193
                                                                                                                                                                                                                                                                                                                                                                                                                
 
194
                                                                                "'Form11_DE16'", "'Form11_DE17'", "'Form11_DE18'", "'Form11_DE19'", "'Form11_DE20'", "'Form11_DE21'", "'Form11_DE22'", "'Form11_DE23'", "'Form11_DE24'",
 
195
                                        
 
196
                                                                                // 6.3
 
197
                                                                                " 'Form10_DE1500','Form10_DE171' ",
 
198
                                                                                " 'Form10_DE180','Form10_DE172' ",
 
199
                                                                                " 'Form10_DE1536','Form10_DE173' ",
 
200
                                                                                
 
201
                                                                                "'Form10_DE1500'", "'Form10_DE180'", "'Form10_DE1536'", "'Form10_DE171'", "'Form10_DE172'", "'Form10_DE173'",
 
202
                                                                                
 
203
                                                                                "' '","' '","' '",
 
204
                                                                                
 
205
                                                                                // 7.1
 
206
                                                                                " 'Form10_DE1537','Form10_DE1540' ",
 
207
                                                                                " 'Form10_DE1538','Form10_DE1541' ",
 
208
                                                                                " 'Form10_DE1539','Form10_DE1542' ",
 
209
                                                                                
 
210
                                                                                "'Form10_DE1537'", "'Form10_DE1538'", "'Form10_DE1539'", "'Form10_DE1540'", "'Form10_DE1541'", "'Form10_DE1542'",
 
211
                                                                                
 
212
                                                                                // 8
 
213
                                                                                " 'Form10_DE192','Form10_DE195','Form10_DE198' ",
 
214
                                                                                " 'Form10_DE193','Form10_DE196','Form10_DE199' ",
 
215
                                                                                " 'Form10_DE194','Form10_DE197','Form10_DE200' ",
 
216
                                                                                
 
217
                                                                                "'Form10_DE192'", "'Form10_DE193'", "'Form10_DE194'", "'Form10_DE195'", "'Form10_DE196'", "'Form10_DE197'", "'Form10_DE198'", "'Form10_DE199'", 
 
218
                                                                                "'Form10_DE200'", "'Form11_DE25'", "'Form11_DE26'",
 
219
                                                                                                                                                                
 
220
                                                                                "' '",
 
221
                                                                                
 
222
                                                                                "' '","' '","' '",
 
223
                                                                                
 
224
                                                                                // 9.1
 
225
                                                                                " 'Form10_DE207','Form10_DE210','Form10_DE213','Form10_DE216' ",
 
226
                                                                                " 'Form10_DE208','Form10_DE211','Form10_DE214','Form10_DE217' ",
 
227
                                                                                " 'Form10_DE209','Form10_DE212','Form10_DE215','Form10_DE218' ",
 
228
                                                                                
 
229
                                                                                "'Form10_DE207'", "'Form10_DE208'", "'Form10_DE209'", "'Form10_DE210'", "'Form10_DE211'", "'Form10_DE212'", "'Form10_DE213'", "'Form10_DE214'", 
 
230
                                                                                "'Form10_DE215'", "'Form10_DE216'", "'Form10_DE217'", "'Form10_DE218'",
 
231
                                                                                
 
232
                                                                                // 9.2
 
233
                                                                                " 'Form10_DE222','Form10_DE225','Form10_DE228' ",
 
234
                                                                                " 'Form10_DE223','Form10_DE226','Form10_DE229' ",
 
235
                                                                                " 'Form10_DE224','Form10_DE227','Form10_DE230' ",       
 
236
                                                                                
 
237
                                                                                "'Form10_DE222'", "'Form10_DE223'", "'Form10_DE224'", "'Form10_DE225'", "'Form10_DE226'", "'Form10_DE227'", "'Form10_DE228'", "'Form10_DE229'", 
 
238
                                                                                "'Form10_DE230'",
 
239
                                                                                
 
240
                                                                                // 9.3
 
241
                                                                                " 'Form10_DE234','Form10_DE237' ",
 
242
                                                                                " 'Form10_DE235','Form10_DE238' ",
 
243
                                                                                " 'Form10_DE236','Form10_DE239' ",
 
244
                                                                                
 
245
                                                                                "'Form10_DE234'", "'Form10_DE235'", "'Form10_DE236'", "'Form10_DE237'", "'Form10_DE238'", "'Form10_DE239'",
 
246
                                                                                
 
247
                                                                                // 9.4
 
248
                                                                                " 'Form11_DE27','Form11_DE30','Form11_DE33' ",
 
249
                                                                                " 'Form11_DE28','Form11_DE31','Form11_DE34' ",
 
250
                                                                                " 'Form11_DE29','Form11_DE32','Form11_DE35' ",
 
251
                                                                                                                                                                                                                                                
 
252
                                                                                "'Form11_DE27'", "'Form11_DE28'", "'Form11_DE29'", "'Form11_DE30'", "'Form11_DE31'", "'Form11_DE32'", "'Form11_DE33'","'Form11_DE34'", "'Form11_DE35'",
 
253
 
 
254
                                                                                // 9.5
 
255
                                                                                " 'Form10_DE246','Form10_DE249','Form10_DE252' ",
 
256
                                                                                " 'Form10_DE247','Form10_DE250','Form10_DE253' ",
 
257
                                                                                " 'Form10_DE248','Form10_DE251','Form10_DE254' ",
 
258
 
 
259
                                                                                "'Form10_DE246'", "'Form10_DE247'", "'Form10_DE248'", "'Form10_DE249'", "'Form10_DE250'", "'Form10_DE251'", "'Form10_DE252'", "'Form10_DE253'", 
 
260
                                                                                "'Form10_DE254'", 
 
261
                                                                                
 
262
                                                                                "' '","' '","' '", 
 
263
                                                                                
 
264
                                                                                "'Form10_DE258'","'Form10_DE259'", "'Form10_DE260'", "'Form11_DE36'", "'Form11_DE37'", "'Form11_DE38'",
 
265
                                                                                
 
266
                                                                                // 10.3
 
267
                                                                                " 'Form11_DE42','Form11_DE45' ",
 
268
                                                                                " 'Form11_DE43','Form11_DE46' ",
 
269
                                                                                " 'Form11_DE44','Form11_DE47' ",
 
270
                                                                                
 
271
                                                                                "'Form11_DE42'", "'Form11_DE43'", "'Form11_DE44'", "'Form11_DE45'",     "'Form11_DE46'", "'Form11_DE47'", "'Form11_DE48'", "'Form11_DE49'", "'Form11_DE50'",
 
272
                                                                                
 
273
                                                                                "' '","' '","' '","' '","' '","' '",
 
274
                                                                                                                                                                
 
275
                                                                                "'Form10_DE261'", "'Form10_DE262'", "'Form10_DE263'", "'Form10_DE264'", "'Form10_DE265'", "'Form10_DE266'", "'Form10_DE267'", "'Form10_DE268'", 
 
276
                                                                                "'Form10_DE269'", "'Form10_DE270'", "'Form10_DE271'", "'Form10_DE272'", "'Form10_DE273'", "'Form10_DE274'", "'Form10_DE275'", "'Form10_DE276'", 
 
277
                                                                                "'Form10_DE277'", "'Form10_DE278'", "'Form11_DE51'", "'Form11_DE52'", "'Form11_DE53'", "'Form11_DE54'", "'Form11_DE55'", "'Form11_DE56'", 
 
278
                                                                                
 
279
                                                                                "' '","' '","' '",
 
280
                                                                                
 
281
                                                                                "'Form10_DE279'", "'Form10_DE280'", "'Form10_DE281'", "'Form10_DE282'", "'Form10_DE283'", "'Form10_DE284'", "'Form10_DE285'", "'Form10_DE286'", 
 
282
                                                                                "'Form10_DE287'", "'Form10_DE288'", "'Form10_DE289'", "'Form10_DE290'", "'Form10_DE291'", "'Form10_DE292'", "'Form10_DE293'", "'Form10_DE294'", 
 
283
                                                                                "'Form10_DE295'", 
 
284
                                                                                
 
285
                                                                                "' '","' '","' '",
 
286
                                                                                
 
287
                                                                                "'Form10_DE296'", "'Form10_DE297'", "'Form10_DE298'",
 
288
                                                                                
 
289
                                                                                // 13.2
 
290
                                                                                " 'Form10_DE302','Form10_DE305','Form10_DE308' ",
 
291
                                                                                " 'Form10_DE303','Form10_DE306','Form10_DE309' ",
 
292
                                                                                " 'Form10_DE304','Form10_DE307','Form10_DE310' ",
 
293
                                                                                
 
294
                                                                                "'Form10_DE302'", "'Form10_DE303'", "'Form10_DE304'", "'Form10_DE305'", "'Form10_DE306'", "'Form10_DE307'", "'Form10_DE308'", "'Form10_DE309'", 
 
295
                                                                                "'Form10_DE310'", 
 
296
                                                                                
 
297
                                                                                "' '",
 
298
                                                                                
 
299
                                                                                "'Form10_DE311'", "'Form10_DE312'",                                                                             
 
300
                                                                                
 
301
                                                                                "' '",
 
302
                                                                                
 
303
                                                                                "'Form10_DE313'", "'Form10_DE314'", "'Form10_DE315'",
 
304
                                                                                
 
305
                                                                                // 15
 
306
                                                                                " 'Form10_DE317','Form10_DE318' ",
 
307
                                                                                
 
308
                                                                                "'Form10_DE317'", "'Form10_DE318'", 
 
309
 
 
310
                                                                                "' '", "' '", "' '", "' '", "' '", "' '",
 
311
                                                                                
 
312
                                                                                "'Form10_DE319'", "'Form10_DE320'", "'Form10_DE321'", "'Form10_DE322'", "'Form10_DE323'", "'Form10_DE324'", "'Form10_DE325'", "'Form10_DE326'", 
 
313
                                                                                "'Form10_DE327'", "'Form10_DE328'", "'Form10_DE329'", "'Form10_DE330'", 
 
314
                                                                                
 
315
                                                                                // 17.12
 
316
                                                                                " 'Form10_DE337','Form10_DE343','Form10_DE349' ",
 
317
                                                                                " 'Form10_DE338','Form10_DE344','Form10_DE350' ",
 
318
                                                                                " 'Form10_DE339','Form10_DE345','Form10_DE351' ",
 
319
                                                                                " 'Form10_DE340','Form10_DE346','Form10_DE352' ",
 
320
                                                                                " 'Form10_DE341','Form10_DE347','Form10_DE353' ",
 
321
                                                                                " 'Form10_DE342','Form10_DE348','Form10_DE354' ",
 
322
                                                                                                                                                        
 
323
                                                                                "'Form10_DE337'", "'Form10_DE338'", "'Form10_DE339'", "'Form10_DE340'", "'Form10_DE341'", "'Form10_DE342'", "'Form10_DE343'", "'Form10_DE344'", 
 
324
                                                                                "'Form10_DE345'",
 
325
                                                                                "'Form10_DE346'", "'Form10_DE347'", "'Form10_DE348'", "'Form10_DE349'", "'Form10_DE350'", "'Form10_DE351'", "'Form10_DE352'", "'Form10_DE353'", 
 
326
                                                                                "'Form10_DE354'",
 
327
                                                                                
 
328
                                                                                // 17.13
 
329
                                                                                " 'Form10_DE361','Form10_DE367','Form10_DE373','Form10_DE379' ",
 
330
                                                                                " 'Form10_DE362','Form10_DE368','Form10_DE374','Form10_DE380' ",
 
331
                                                                                " 'Form10_DE363','Form10_DE369','Form10_DE375','Form10_DE381' ",
 
332
                                                                                " 'Form10_DE364','Form10_DE370','Form10_DE376','Form10_DE382' ",
 
333
                                                                                " 'Form10_DE365','Form10_DE371','Form10_DE377','Form10_DE383' ",
 
334
                                                                                " 'Form10_DE366','Form10_DE372','Form10_DE378','Form10_DE384' ",
 
335
                                                                                
 
336
                                                                                "'Form10_DE361'", "'Form10_DE362'", "'Form10_DE363'",
 
337
                                                                                "'Form10_DE364'", "'Form10_DE365'", "'Form10_DE366'", "'Form10_DE367'", "'Form10_DE368'", "'Form10_DE369'", "'Form10_DE370'", "'Form10_DE371'", 
 
338
                                                                                "'Form10_DE372'",
 
339
                                                                                "'Form10_DE373'", "'Form10_DE374'", "'Form10_DE375'", "'Form10_DE376'", "'Form10_DE377'", "'Form10_DE378'", "'Form10_DE379'", "'Form10_DE380'", 
 
340
                                                                                "'Form10_DE381'",
 
341
                                                                                "'Form10_DE382'", "'Form10_DE383'", "'Form10_DE384'", 
 
342
                                                                                
 
343
                                                                                // 17.14
 
344
                                                                                " 'Form10_DE391','Form10_DE397','Form10_DE403' ",
 
345
                                                                                " 'Form10_DE392','Form10_DE398','Form10_DE404' ",
 
346
                                                                                " 'Form10_DE393','Form10_DE399','Form10_DE405' ",
 
347
                                                                                " 'Form10_DE394','Form10_DE400','Form10_DE406' ",
 
348
                                                                                " 'Form10_DE395','Form10_DE401','Form10_DE407' ",
 
349
                                                                                " 'Form10_DE396','Form10_DE402','Form10_DE408' ",
 
350
                                                                                
 
351
                                                                                "'Form10_DE391'", "'Form10_DE392'", "'Form10_DE393'", "'Form10_DE394'", "'Form10_DE395'", "'Form10_DE396'", "'Form10_DE397'", "'Form10_DE398'", 
 
352
                                                                                "'Form10_DE399'",
 
353
                                                                                "'Form10_DE400'", "'Form10_DE401'", "'Form10_DE402'", "'Form10_DE403'", "'Form10_DE404'", "'Form10_DE405'", "'Form10_DE406'", "'Form10_DE407'", 
 
354
                                                                                "'Form10_DE408'",
 
355
                                                                                "'Form10_DE409'", "'Form10_DE410'", "'Form10_DE411'", "'Form10_DE412'", "'Form10_DE413'", "'Form10_DE414'", "'Form10_DE415'", "'Form10_DE416'", 
 
356
                                                                                "'Form10_DE417'",
 
357
                                                                                "'Form10_DE448'", "'Form10_DE449'", "'Form10_DE450'", 
 
358
                                                                                
 
359
                                                                                
 
360
                                                                                // 17.2
 
361
                                                                                " 'Form10_DE457','Form10_DE463' ",
 
362
                                                                                " 'Form10_DE458','Form10_DE464' ",
 
363
                                                                                " 'Form10_DE459','Form10_DE465' ",
 
364
                                                                                " 'Form10_DE460','Form10_DE466' ",
 
365
                                                                                " 'Form10_DE461','Form10_DE467' ",
 
366
                                                                                " 'Form10_DE462','Form10_DE468' ",
 
367
                                                                                
 
368
                                                                                "'Form10_DE457'",
 
369
                                                                                "'Form10_DE458'", "'Form10_DE459'", "'Form10_DE460'", "'Form10_DE461'", "'Form10_DE462'", "'Form10_DE463'", "'Form10_DE464'", "'Form10_DE465'", 
 
370
                                                                                "'Form10_DE466'",
 
371
                                                                                "'Form10_DE467'", "'Form10_DE468'", 
 
372
                                                                                
 
373
                                                                                "' '","' '","' '","' '","' '","' '",
 
374
                                                                                
 
375
                                                                                "'Form10_DE475'",
 
376
                                                                                "'Form10_DE476'", "'Form10_DE477'", "'Form10_DE478'", "'Form10_DE479'", "'Form10_DE480'", "'Form10_DE481'", "'Form10_DE482'", "'Form10_DE483'", 
 
377
                                                                                "'Form10_DE484'",
 
378
                                                                                "'Form10_DE485'", "'Form10_DE486'", "'Form10_DE487'", "'Form10_DE488'", "'Form10_DE489'", "'Form10_DE490'", "'Form10_DE491'", "'Form10_DE492'", 
 
379
                                                                                "'Form10_DE493'",
 
380
                                                                                "'Form10_DE494'", "'Form10_DE495'", "'Form10_DE496'", "'Form10_DE497'", "'Form10_DE498'", 
 
381
                                                                                
 
382
                                                                                // 17.4
 
383
                                                                                " 'Form10_DE505','Form10_DE511' ",
 
384
                                                                                " 'Form10_DE506','Form10_DE512' ",
 
385
                                                                                " 'Form10_DE507','Form10_DE513' ",
 
386
                                                                                " 'Form10_DE508','Form10_DE514' ",
 
387
                                                                                " 'Form10_DE509','Form10_DE515' ",
 
388
                                                                                " 'Form10_DE510','Form10_DE516' ",
 
389
                                                                                
 
390
                                                                                "'Form10_DE505'", "'Form10_DE506'", "'Form10_DE507'", "'Form10_DE508'", "'Form10_DE509'", "'Form10_DE510'", "'Form10_DE511'",
 
391
                                                                                "'Form10_DE512'", "'Form10_DE513'", "'Form10_DE514'", "'Form10_DE515'", "'Form10_DE516'", "'Form10_DE517'", "'Form10_DE518'", "'Form10_DE519'", 
 
392
                                                                                "'Form10_DE520'",
 
393
                                                                                "'Form10_DE521'", "'Form10_DE522'", "'Form10_DE523'", "'Form10_DE524'", "'Form10_DE525'", "'Form10_DE526'", "'Form10_DE527'", "'Form10_DE528'", 
 
394
                                                                                "'Form10_DE529'",
 
395
                                                                                "'Form10_DE530'", "'Form10_DE531'", "'Form10_DE532'", "'Form10_DE533'", "'Form10_DE534'", "'Form10_DE535'", "'Form10_DE536'", "'Form10_DE537'", 
 
396
                                                                                "'Form10_DE538'", 
 
397
                                                                                "'Form10_DE539'", "'Form10_DE540'", 
 
398
                                                                                
 
399
                                                                                
 
400
                                                                                "'Form10_DE541'", "'Form10_DE542'", "'Form10_DE543'", "'Form10_DE544'", "'Form10_DE545'", "'Form10_DE546'", "'Form10_DE547'", "'Form10_DE548'", 
 
401
                                                                                "'Form10_DE549'",
 
402
                                                                                "'Form10_DE550'", "'Form10_DE551'", "'Form10_DE552'", "'Form10_DE553'", "'Form10_DE554'", "'Form10_DE555'", "'Form10_DE556'", "'Form10_DE557'", 
 
403
                                                                                "'Form10_DE558'",   
 
404
                                                                                "'Form10_DE559'", "'Form10_DE560'", "'Form10_DE561'", "'Form10_DE562'", "'Form10_DE563'", "'Form10_DE564'", "'Form10_DE565'", "'Form10_DE566'", 
 
405
                                                                                "'Form10_DE567'",
 
406
                                                                                "'Form10_DE568'", "'Form10_DE569'", "'Form10_DE570'", "'Form10_DE571'", "'Form10_DE572'", "'Form10_DE573'", "'Form10_DE574'", "'Form10_DE575'", 
 
407
                                                                                "'Form10_DE576'",
 
408
                                                                                "'Form10_DE577'", "'Form10_DE578'", "'Form10_DE579'", "'Form10_DE580'", "'Form10_DE581'", "'Form10_DE582'", "'Form10_DE583'", "'Form10_DE584'", 
 
409
                                                                                "'Form10_DE585'",
 
410
                                                                                "'Form10_DE586'", "'Form10_DE587'", "'Form10_DE588'", "'Form10_DE589'", "'Form10_DE590'", "'Form10_DE591'", "'Form10_DE592'", "'Form10_DE593'", 
 
411
                                                                                "'Form10_DE594'",
 
412
                                                                                "'Form10_DE595'", "'Form10_DE596'", "'Form10_DE597'", "'Form10_DE598'", "'Form10_DE599'", "'Form10_DE600'", "'Form10_DE601'", "'Form10_DE602'", 
 
413
                                                                                "'Form10_DE603'",
 
414
                                                                                "'Form10_DE604'", "'Form10_DE605'", "'Form10_DE606'", "'Form10_DE607'", "'Form10_DE608'", "'Form10_DE609'", "'Form10_DE610'", "'Form10_DE611'", 
 
415
                                                                                "'Form10_DE612'",
 
416
                                                                                "'Form10_DE613'", "'Form10_DE614'", "'Form10_DE615'", "'Form10_DE616'", "'Form10_DE617'", "'Form10_DE618'", "'Form10_DE619'", "'Form10_DE620'", 
 
417
                                                                                
 
418
                                                                                
 
419
                                                                                "' '","' '","' '","' '",
 
420
                                                                                
 
421
                                                                                "'Form11_DE57'", "'Form11_DE58'", 
 
422
                                                                                
 
423
                                                                                "' '", 
 
424
                                                                                
 
425
                                                                                "'Form11_DE59'", "'Form11_DE60'", 
 
426
                                                                                
 
427
                                                                                "' '", 
 
428
                                                                                
 
429
                                                                                "'Form11_DE61'", "'Form11_DE62'", 
 
430
                                                                                
 
431
                                                                                "' '", 
 
432
                                                                                
 
433
                                                                                "'Form11_DE63'", "'Form11_DE64'",
 
434
                                                                                
 
435
                                                                                "' '", 
 
436
                                                                                
 
437
                                                                                "'Form11_DE65'", "'Form11_DE66'", 
 
438
                                                                                
 
439
                                                                                "' '", 
 
440
                                                                                
 
441
                                                                                "'Form11_DE67'", "'Form11_DE68'", 
 
442
                                                                                
 
443
                                                                                "' '", 
 
444
                                                                                
 
445
                                                                                "' '","' '","' '","' '","' '","' '","' '","' '","' '",
 
446
                                                                                
 
447
                                                                                "'Form10_DE621'", 
 
448
                                                                                "'Form10_DE622'", "'Form10_DE623'", "'Form10_DE624'", "'Form10_DE625'", "'Form10_DE626'", "'Form10_DE627'",
 
449
                                                                                "'Form10_DE628'", "'Form10_DE629'", "'Form10_DE630'", "'Form10_DE631'", "'Form10_DE632'", "'Form10_DE633'", "'Form10_DE634'", "'Form10_DE635'", 
 
450
                                                                                "'Form10_DE636'",
 
451
                                                                                "'Form10_DE637'", "'Form10_DE638'", "'Form10_DE639'", "'Form10_DE640'", "'Form10_DE641'", "'Form10_DE642'", "'Form10_DE643'", "'Form10_DE644'", 
 
452
                                                                                "'Form10_DE645'",
 
453
                                                                                "'Form10_DE646'", "'Form10_DE647'", "'Form10_DE648'", "'Form10_DE649'", "'Form10_DE650'", 
 
454
                                                                                
 
455
                                                                                
 
456
                                                                                "' '","' '","' '","' '",
 
457
                                                                                
 
458
                                                                                "'Form11_DE69'", "'Form11_DE70'", 
 
459
                                                                                
 
460
                                                                                "' '", 
 
461
                                                                                
 
462
                                                                                "'Form11_DE71'", "'Form11_DE72'", 
 
463
                                                                                
 
464
                                                                                "' '", 
 
465
                                                                                
 
466
                                                                                "'Form11_DE73'", "'Form11_DE74'", 
 
467
                                                                                
 
468
                                                                                "' '", 
 
469
                                                                                
 
470
                                                                                "' '", "' '", "' '",
 
471
                                                                                
 
472
                                                                                "'Form10_DE651'", "'Form10_DE652'", "'Form10_DE653'", 
 
473
                                                                                
 
474
                                                                                // 23.2
 
475
                                                                                " 'Form11_DE75','Form10_DE726' ",
 
476
                                                                                " 'Form11_DE76','Form10_DE727' ",
 
477
                                                                                " 'Form11_DE77','Form10_DE728' ",
 
478
                                                                                
 
479
                                                                                "'Form11_DE75'", "'Form11_DE76'", "'Form11_DE77'",
 
480
                                                                                "'Form10_DE726'", "'Form10_DE727'", "'Form10_DE728'", 
 
481
                                                                                
 
482
                                                                                // 23.3
 
483
                                                                                " 'Form10_DE729','Form10_DE732','Form10_DE735' ",
 
484
                                                                                " 'Form10_DE730','Form10_DE733','Form10_DE736' ",
 
485
                                                                                " 'Form10_DE731','Form10_DE734','Form10_DE737' ",
 
486
                                                                                
 
487
                                                                                "'Form10_DE729'", "'Form10_DE730'", "'Form10_DE731'",
 
488
                                                                                "'Form10_DE732'", "'Form10_DE733'", "'Form10_DE734'", "'Form10_DE735'", "'Form10_DE736'", "'Form10_DE737'",  
 
489
                                                                                "'Form10_DE666'", "'Form10_DE667'",
 
490
                                                                                "'Form10_DE1529'", "'Form10_DE669'", "'Form10_DE670'", "'Form10_DE671'", "'Form10_DE672'", "'Form10_DE673'", "'Form10_DE674'", "'Form10_DE675'", 
 
491
                                                                                "'Form10_DE676'",
 
492
                                                                                "'Form10_DE677'", "'Form10_DE678'", "'Form10_DE679'", "'Form10_DE680'", "'Form10_DE681'", "'Form10_DE682'", "'Form10_DE683'", "'Form10_DE684'", 
 
493
                                                                                "'Form10_DE685'",
 
494
                                                                                "'Form10_DE686'", "'Form10_DE687'", "'Form10_DE688'", "'Form10_DE689'", "'Form10_DE690'", "'Form10_DE691'", "'Form10_DE692'", "'Form10_DE693'", 
 
495
                                                                                "'Form10_DE694'",
 
496
                                                                                "'Form10_DE695'", "'Form10_DE696'", "'Form10_DE697'", "'Form10_DE698'", "'Form10_DE699'", "'Form10_DE700'", "'Form10_DE701'", "'Form10_DE702'", 
 
497
                                                                                "'Form10_DE703'",
 
498
                                                                                "'Form10_DE704'", "'Form10_DE705'", "'Form10_DE706'", "'Form10_DE707'", "'Form10_DE708'", "'Form10_DE709'", "'Form10_DE710'", "'Form10_DE711'", 
 
499
                                                                                "'Form10_DE712'",
 
500
                                                                                "'Form10_DE713'", "'Form10_DE714'", "'Form10_DE715'", "'Form10_DE716'", "'Form10_DE717'", "'Form10_DE718'", "'Form10_DE719'", 
 
501
                                                                                
 
502
                                                                                "' '","' '","' '",
 
503
                                                                                
 
504
                                                                                // 23.81
 
505
                                                                                " 'Form10_DE723','Form10_DE726' ",
 
506
                                                                                " 'Form10_DE724','Form10_DE727' ",
 
507
                                                                                " 'Form10_DE725','Form10_DE728' ",
 
508
                                                                                
 
509
                                                                                "'Form10_DE723'", "'Form10_DE724'", "'Form10_DE725'", "'Form10_DE726'", "'Form10_DE727'", 
 
510
                                                                                "'Form10_DE728'", 
 
511
                                                                                
 
512
                                                                                // 23.82
 
513
                                                                                " 'Form10_DE729','Form10_DE732','Form10_DE735' ",
 
514
                                                                                " 'Form10_DE730','Form10_DE733','Form10_DE736' ",
 
515
                                                                                " 'Form10_DE731','Form10_DE734','Form10_DE737' ",
 
516
                                                                                
 
517
                                                                                "'Form10_DE729'", "'Form10_DE730'", "'Form10_DE731'", "'Form10_DE732'", "'Form10_DE733'", "'Form10_DE734'", "'Form10_DE735'",
 
518
                                                                                "'Form10_DE736'", "'Form10_DE737'", 
 
519
                                                                                
 
520
                                                                                "' '", "' '", "' '", "' '","' '","' '","' '","' '","' '",
 
521
                                                                                
 
522
                                                                                "'Form10_DE741'", "'Form10_DE742'", 
 
523
                                                                                "'Form10_DE743'", "'Form10_DE744'", "'Form10_DE745'", "'Form10_DE746'", "'Form10_DE747'", "'Form10_DE748'", "'Form10_DE749'",
 
524
                                                                                
 
525
                                                                                
 
526
                                                                                        
 
527
 
 
528
                                                                           };
 
529
 
 
530
                 
 
531
        int dataElementIDs[] = new int[dataElementCodes.length+5];  
 
532
        int entryNumberValues[]=  new int[dataElementCodes.length+5];     
 
533
        int entryValuesForLastYear[]= new int[dataElementCodes.length+5];      
 
534
        int cumentryValuesForCurYear[]= new int[dataElementCodes.length+5];      
 
535
        int cumentryValuesForLastYear[]= new int[dataElementCodes.length+5];      
 
536
        
 
537
        String monthNames[] = { "", "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" };            
 
538
   
 
539
%>
 
540
                                
 
541
<%
 
542
     try
 
543
      {
 
544
        Class.forName ("com.mysql.jdbc.Driver").newInstance ();
 
545
        con = DriverManager.getConnection (urlForConnection, userName, password);
 
546
        
 
547
        st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
 
548
        st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
549
        st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
550
        st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
551
        st4=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
552
        st5=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
 
553
        st6=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
554
        st8=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
555
        st9=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
556
        st10=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
557
        st11=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
558
        st12=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
559
 
 
560
     
 
561
        //rs1 = st1.executeQuery("SELECT organisationunit.shortname FROM organisationunit WHERE id ="+selectedOrgUnitID);
 
562
        rs1 = st1.executeQuery("SELECT organisationunit.shortname FROM organisationunit WHERE organisationunitid ="+selectedOrgUnitID);        
 
563
        if(rs1.next())  {   selectedOrgUnitName = rs1.getString(1);     }
 
564
        else   {        selectedOrgUnitName = "";                   }  
 
565
 
 
566
        //rs11 = st11.executeQuery("select startDate,endDate from period where id = "+selectedDataPeriodID);
 
567
                //if(rs11.next())
 
568
                //  {
 
569
                //      selectedDataPeriodStartDate =  rs11.getDate(1).toString();
 
570
                //      selectedDataPeriodEndDate   =  rs11.getDate(2).toString();
 
571
                //  }
 
572
                
 
573
                selectedDataPeriodStartDate = startingDate;
 
574
                
 
575
      } // try block end
 
576
     catch(Exception e)  { out.println(e.getMessage());  }
 
577
     finally
 
578
       {
 
579
                        try
 
580
                                {
 
581
                                        if(rs1!=null)  rs1.close();                     if(st1!=null)  st1.close();
 
582
                                        if(rs11!=null)  rs11.close();           if(st11!=null)  st11.close();
 
583
                                }
 
584
                        catch(Exception e)   {  out.println(e.getMessage());   }
 
585
       } // finally block end           
 
586
 
 
587
        String partsOfDataPeriodStartDate[]  =  selectedDataPeriodStartDate.split("-");
 
588
        String partsOfDataPeriodEndDate[] = endingDate.split("-");
 
589
        lastYear  = Integer.parseInt(partsOfDataPeriodStartDate[0]) - 1;
 
590
        lastDataPeriodStartDate = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
 
591
        
 
592
        int tempForMonth1 = Integer.parseInt(partsOfDataPeriodStartDate[1]);
 
593
        int tempForYear = 0;
 
594
                
 
595
        if(tempForMonth1 < 4)           {   tempForYear = lastYear;  }
 
596
        else  {   tempForYear = lastYear + 1;           }
 
597
         
 
598
         String curYearStart = tempForYear+"-04-01";
 
599
         String lastYearStart = (tempForYear-1)+"-04-01";
 
600
         String lastYearEnd = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
 
601
         
 
602
     //for district, taluk, CHC names
 
603
     try
 
604
      {
 
605
//              rs8=st8.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")");        
 
606
//                      if(rs8.next())  { PHCID = rs8.getInt(1);PHCName = rs8.getString(2);  } 
 
607
//                      else  {  PHCID = 0; PHCName = "";  } 
 
608
 
 
609
//                      rs9=st9.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+PHCID+")");     
 
610
//                      if(rs9.next())  { CHCID = rs9.getInt(1);CHCName = rs9.getString(2);  } 
 
611
//                      else  {  CHCID = 0; CHCName = "";  } 
 
612
 
 
613
                        //rs5=st5.executeQuery("select organisationunit.id, organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")");
 
614
                        rs5=st5.executeQuery("select organisationunit.organisationunitid, organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+selectedOrgUnitID+")");  
 
615
                        if(rs5.next())  {  districtID = rs5.getInt(1); districtName = rs5.getString(2);}
 
616
                        else  {districtID = 0; districtName = "";}
 
617
        
 
618
                    //rs6=st6.executeQuery("select organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+districtID+")");
 
619
                    rs6=st6.executeQuery("select organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+districtID+")"); 
 
620
                    if(rs6.next()) {  stateName = rs6.getString(1);}
 
621
                        else { stateName = "";}      
 
622
 
 
623
                        //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'");
 
624
                        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'");
 
625
                        if(rs10.next()) { totPHCPopulation = rs10.getInt(1);}
 
626
                        else {totPHCPopulation = 0;}      
 
627
       
 
628
       }   // try block end              
 
629
     catch(Exception e)  { out.println(e.getMessage());  }
 
630
     finally
 
631
       {
 
632
                 try
 
633
                          {
 
634
                            if(rs5!=null)  rs5.close();                 if(st5!=null)  st5.close();
 
635
                            if(rs6!=null)  rs6.close();                 if(st6!=null)  st6.close();
 
636
                            if(rs8!=null)  rs8.close();                 if(st8!=null)  st8.close();   
 
637
                            if(rs9!=null)  rs9.close();                 if(st9!=null)  st9.close();
 
638
                            if(rs10!=null)  rs10.close();               if(st10!=null)  st10.close();                                                                                                                
 
639
                          }
 
640
                catch(Exception e)   {  out.println(e.getMessage());   }
 
641
       }  // finally block end
 
642
    
 
643
     try
 
644
      {
 
645
                int i=0;    
 
646
                int j= dataElementCodes.length;
 
647
                String query = "";
 
648
                int in = 0;
 
649
                        
 
650
                while(i!=j)
 
651
                        {               
 
652
                                entryNumberValues[i]     = -1;
 
653
                                entryValuesForLastYear[i] = -1;
 
654
                                cumentryValuesForCurYear[i] = -1;
 
655
                                cumentryValuesForLastYear[i] = -1;
 
656
                                                                                                                                
 
657
                                // for Performance in the reporting month
 
658
                                //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 parent ="+selectedOrgUnitID+" OR id ="+selectedOrgUnitID+") AND dataelement.code in ("+dataElementCodes[i]+")";
 
659
                                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 parentid ="+selectedOrgUnitID+" OR organisationunitid ="+selectedOrgUnitID+") AND dataelement.code in ("+dataElementCodes[i]+")"; 
 
660
                                rs=st.executeQuery(query);
 
661
                                if(rs.next())  {  entryNumberValues[i] = rs.getInt(1);  } 
 
662
                                else  {  entryNumberValues[i] = 0;  } 
 
663
                                                                                                
 
664
                        // for Cumulative Performance till Current Month
 
665
                                //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 parent ="+selectedOrgUnitID+" OR id ="+selectedOrgUnitID+")  AND dataelement.code in ("+dataElementCodes[i]+")";
 
666
                                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 parentid ="+selectedOrgUnitID+" OR organisationunitid ="+selectedOrgUnitID+")  AND dataelement.code in ("+dataElementCodes[i]+")";                      
 
667
                            rs4=st4.executeQuery(query);
 
668
                        if(rs4.next())  {  cumentryValuesForCurYear[i]= rs4.getInt(1);  } 
 
669
                            else  {  cumentryValuesForCurYear[i] = 0;  } 
 
670
                                    
 
671
                                i++;
 
672
                        }  // while loop end
 
673
      }  // try block end                
 
674
     catch(Exception e)  { out.println(e.getMessage());  }
 
675
     finally
 
676
       {
 
677
                         try
 
678
                                {
 
679
                                    if(rs!=null)  rs.close();           if(st!=null)  st.close();                                                       
 
680
                                        if(rs2!=null)  rs2.close();             if(st2!=null)  st2.close();    
 
681
                                        if(rs3!=null)  rs3.close();             if(st3!=null)  st3.close();                                     
 
682
                                        if(rs4!=null)  rs4.close();             if(st4!=null)  st4.close();
 
683
                                        if(rs12!=null)  rs12.close();   if(st12!=null)  st12.close();
 
684
                                                                                
 
685
                                        if(con!=null) con.close();                                      
 
686
                        }        
 
687
                        catch(Exception e)   {  out.println(e.getMessage());   }
 
688
       }  // finally block end                                  
 
689
%>
 
690
 
 
691
<HTML>
 
692
<HEAD>
 
693
   <TITLE>Form - 2</TITLE>
 
694
   <script src="../dhis-web-reports/Jharkhand/JDENamesForForm2.js" type="text/javascript" language="Javascript"></script>       
 
695
   <script>
 
696
                function fun1()
 
697
                { 
 
698
                    
 
699
                        var start=0;
 
700
                        var end = 28;    
 
701
                        var j=1;
 
702
                        var k=0;                
 
703
                        var id="";                      
 
704
                
 
705
                        while(j<=5)
 
706
                         {                          
 
707
                                
 
708
                                if(j==1) end = 21;
 
709
                                        else if(j==2) end = 31;
 
710
                                        else if(j==3) end = 32;
 
711
                                        else if(j==4) end = 30;
 
712
                                        else if(j==5) end = 32;
 
713
                                
 
714
                                        for(start=0;start<=end;start++)
 
715
                                         {      
 
716
                                                 id="cell1"+k;                                    
 
717
                                                 document.getElementById(id).innerHTML = slnoForForm2[k];
 
718
                                                 id="cell2"+k;                                    
 
719
                                                 document.getElementById(id).innerHTML = denamesForForm2[k];
 
720
                                                 
 
721
                                                 k++;
 
722
                                         }
 
723
                                        j++; 
 
724
                                 }                                                              
 
725
                        }
 
726
        </script>                   
 
727
</HEAD>
 
728
<BODY BGCOLOR="#FFFFFF" onload="fun1()">  
 
729
        <font face="Arial" size="2">&#2344;&#2367;&#2325;-&#2344;&#2375;&#2335; &#2325;&#2350;&#2381;&#2346;&#2381;&#2351;&#2370;&#2335;&#2352; &#2350;&#2375;&#2306; &#2337;&#2366;&#2335;&#2366; &#2346;&#2381;&#2352;&#2357;&#2367;&#2359;&#2381;&#2335;&#2367; &#2325;&#2375; &#2354;&#2367;&#2319; &#2332;&#2367;&#2354;&#2366; &#2346;&#2352;&#2367;&#2357;&#2366;&#2352; &#2325;&#2354;&#2381;&#2351;&#2366;&#2339; &#2309;&#2343;&#2367;&#2325;&#2366;&#2352;&#2368; &#2325;&#2379; 15 &#2350;&#2366;&#2352;&#2381;&#2330; &#2340;&#2325; &#2346;&#2381;&#2352;&#2360;&#2381;&#2340;&#2369;&#2340; &#2325;&#2367;&#2351;&#2366; &#2332;&#2366;&#2319;)</font>
 
730
        <center>
 
731
                <font face="Arial" size="3">
 
732
                        <b>&#2347;&#2366;&#2352;&#2381;&#2350; 2<br>&#2346;&#2381;&#2352;&#2366;&#2341;&#2350;&#2367;&#2325; &#2360;&#2381;&#2357;&#2366;&#2360;&#2381;&#2341;&#2381;&#2351; &#2325;&#2375;&#2306;&#2342;&#2381;&#2352; &#2325;&#2366;&#2352;&#2381;&#2351;&#2351;&#2379;&#2332;&#2344;&#2366;</b></font>
 
733
        </center>
 
734
 
 
735
                <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">
 
736
                        <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%">
 
737
                        <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">
 
738
                                <font face="Arial" size="2">&#2325;. &#2360;&#2366;&#2350;&#2366;&#2344;&#2381;&#2351; &#2360;&#2370;&#2330;&#2344;&#2366; : &nbsp;&nbsp;&nbsp;</font>
 
739
                </td>
 
740
                        <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">
 
741
                                <font face="Arial" size="2"></font>
 
742
                </td>   
 
743
                </tr>
 
744
                <tr>
 
745
                <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">
 
746
                                <font face="Arial" size="2">&#2352;&#2366;&#2332;&#2381;&#2351; : &nbsp;&nbsp;<%=stateName%></font>
 
747
                </td>
 
748
                <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">
 
749
                                        <font face="Arial" size="2">&#2357;&#2352;&#2381;&#2359; : &nbsp;&nbsp;<%=partsOfDataPeriodStartDate[0]%> - <%=partsOfDataPeriodEndDate[0]%></font>
 
750
                </td>
 
751
                </tr>           
 
752
                <tr>
 
753
                        <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">
 
754
                                <font face="Arial" size="2">&#2332;&#2367;&#2354;&#2366; : &nbsp;&nbsp;<%=districtName%></font>
 
755
                </td>
 
756
                        <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">
 
757
                                <font face="Arial" size="2">&#2332;&#2344;&#2381;&#2350;&#2342;&#2352; : </font>
 
758
                </td>
 
759
                </tr>           
 
760
                <tr>
 
761
                        <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">
 
762
                                <font face="Arial" size="2">&#2346;&#2381;&#2352;&#2366;.&#2360;&#2381;&#2357;&#2366;.&#2325;&#2375;&#2306;. : &nbsp;&nbsp;<%=selectedOrgUnitName%></font>
 
763
                </td>
 
764
                        <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">
 
765
                                <font face="Arial" size="2">(&#2332;&#2367;&#2354;&#2366; / &#2352;&#2366;&#2332;&#2381;&#2351;) : </font>
 
766
                </td>
 
767
                </tr>           
 
768
                <tr>
 
769
                        <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">
 
770
                                <font face="Arial" size="2">&#2346;&#2381;&#2352;&#2366;.&#2360;&#2381;&#2357;&#2366;.&#2325;&#2375;&#2306;. &#2325;&#2375; &#2309;&#2343;&#2368;&#2344; 
 
771
                    &#2313;&#2346;&#2325;&#2375;&#2306;&#2342;&#2381;&#2352;&#2379;&#2306; &#2325;&#2368; &#2360;&#2306;. : </font>
 
772
                </td>
 
773
                        <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">
 
774
                                <font face="Arial" size="2">&#2346;&#2366;&#2340;&#2381;&#2352; &#2342;&#2350;&#2381;&#2346;&#2340;&#2367;&#2351;&#2366;&#2306; (&#2346;&#2361;&#2354;&#2368; &#2309;&#2346;&#2381;&#2352;&#2376;&#2354; &#2325;&#2379;) : </font>
 
775
                </td>
 
776
                </tr>           
 
777
                <tr>
 
778
                        <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">
 
779
                                <font face="Arial" size="2">&#2346;&#2381;&#2352;&#2366;.&#2360;&#2381;&#2357;&#2366;.&#2325;&#2375;&#2306; &#2325;&#2368; &#2332;&#2344;&#2360;&#2306;&#2326;&#2381;&#2351;&#2366; 
 
780
                    (&#2313;&#2346;-&#2325;&#2375;&#2306;&#2342;&#2381;&#2352;&#2379;&#2306; &#2325;&#2375; &#2309;&#2343;&#2368;&#2344; &#2325;&#2369;&#2354; &#2332;&#2344;&#2360;&#2306;&#2326;&#2381;&#2351;&#2366;) : </font>
 
781
                </td>
 
782
                        <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">
 
783
                                &nbsp;
 
784
                </td>
 
785
                </tr>           
 
786
        </table>  
 
787
<br>
 
788
 
 
789
<%
 
790
        int i;
 
791
        int j = 1;
 
792
        int k = 0;
 
793
        int l = 0;
 
794
        int endcount = 28;
 
795
        int flag = 0;
 
796
        String tempForentryNumberValues[] = new String[12];
 
797
        String tempForcumentryValuesForCurYear[] = new String[12];
 
798
        
 
799
                        
 
800
        String temp1 = "";
 
801
        
 
802
        String temp2 = "";
 
803
        
 
804
        int temp = 0;
 
805
int bt =0;      
 
806
        while(j<=5)
 
807
         { 
 
808
           
 
809
            if(j==1) 
 
810
              { %>
 
811
                <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%">
 
812
                   <%                 
 
813
               }
 
814
            else if(j==2)
 
815
              { %>
 
816
                        <br><br><br><br>
 
817
                <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%">              
 
818
              <% 
 
819
                        }
 
820
        else if(j==3)
 
821
              { %>
 
822
                        <br><br><br><br><br><br><br>
 
823
                <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%">              
 
824
              <% 
 
825
                        }
 
826
                else if(j==4)
 
827
              { %>
 
828
                        <br><br><br><br><br><br>
 
829
                <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%">              
 
830
              <% 
 
831
                        }
 
832
                else if(j==5)
 
833
              { %>
 
834
                        <br>
 
835
                <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%">              
 
836
              <% 
 
837
                        }
 
838
            else
 
839
              { %>
 
840
                        <br>
 
841
                <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%">              
 
842
              <% 
 
843
                        }
 
844
 
 
845
                if(j==1) endcount = 21; 
 
846
                else if(j==2) endcount = 31; 
 
847
                else if(j==3) endcount = 32;
 
848
                else if(j==4) endcount = 30;
 
849
                else if(j==5) endcount = 32;
 
850
                                                                
 
851
                                
 
852
                for(i=0;i<=endcount;i++)
 
853
                  {     
 
854
                String id1="cell1"+k;
 
855
                String id2="cell2"+k;
 
856
                            
 
857
                if((k>=29 && k<=74))
 
858
                { 
 
859
               if(k==29) 
 
860
                    {
 
861
                      tempForentryNumberValues[0]= "<b>&#2346;&#2369;&#2352;&#2369;&#2359;</b>";
 
862
                      tempForentryNumberValues[1]= "<b>&#2360;&#2381;&#2340;&#2381;&#2352;&#2368;</b>";
 
863
                                  tempForentryNumberValues[2]= "<b>&#2346;&#2369;&#2352;&#2369;&#2359;</b>";
 
864
                                  tempForentryNumberValues[3]= "<b>&#2360;&#2381;&#2340;&#2381;&#2352;&#2368;</b>";
 
865
                      
 
866
                      l=l+4;
 
867
                    }
 
868
                   else if(k==1 || k==3 || k==6 || k==12 || k==14 || k==18 || k==22 || k==23 || k==26 || k==30 || k==31 || k==36 || k==37 || k==47 || k==50 || k==52 || k==54 || k==56 || k==58 || k==59 || k==63 || k==64 || k==69 || k==70 || k==75 || k==76 || k==79 || k==82 || k==88 || k==94 || k==101 || k==106)
 
869
                                {
 
870
                      tempForentryNumberValues[0]= " ";
 
871
                      tempForentryNumberValues[1]= " ";
 
872
                                  tempForentryNumberValues[2]= " ";
 
873
                                  tempForentryNumberValues[3]= " ";
 
874
                      
 
875
                      l=l+4;
 
876
                    }
 
877
                    
 
878
                   else 
 
879
                    {
 
880
                                        temp =  entryNumberValues[l];
 
881
                                if(temp==-1) tempForentryNumberValues[0] = "";
 
882
                                else tempForentryNumberValues[0] = ""+temp;
 
883
                                        
 
884
                                        l++;
 
885
                                                         
 
886
                                temp =  entryNumberValues[l];
 
887
                                if(temp==-1) tempForentryNumberValues[1] = "";
 
888
                                else tempForentryNumberValues[1] = ""+temp;
 
889
                                                                        
 
890
                                l++;
 
891
                                
 
892
                                        temp =  entryNumberValues[l];
 
893
                                if(temp==-1) tempForentryNumberValues[2] = "";
 
894
                                else tempForentryNumberValues[2] = ""+temp;
 
895
                                
 
896
                                        l++;
 
897
 
 
898
                                        temp =  entryNumberValues[l];
 
899
                                if(temp==-1) tempForentryNumberValues[3] = "";
 
900
                                else tempForentryNumberValues[3] = ""+temp;
 
901
                                
 
902
                                        l++;
 
903
 
 
904
                    } 
 
905
                %>              
 
906
           
 
907
                        <tr>
 
908
                                        <td id="<%=id1%>" name="<%=id1%>" 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"></font></td>
 
909
                                        <td id="<%=id2%>" name="<%=id2%>" width="67%" align="left" 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"></font></td>
 
910
                                        <td width="8%" 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:3; padding-right:1; " bordercolor="#111111" dir="ltr" colspan="2"><font face="Arial" size="2"><%=tempForentryNumberValues[0]%></font></td>
 
911
                                        <td width="7%" 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:3; padding-right:1; " bordercolor="#111111" dir="ltr" colspan="3"><font face="Arial" size="2"><%=tempForentryNumberValues[1]%></font></td>
 
912
                                        <td width="8%" 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:3; padding-right:1; " bordercolor="#111111" align="center" colspan="3"><font face="Arial" size="2"><%=tempForentryNumberValues[2]%></font></td>
 
913
                                        <td width="7%" 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:3; padding-right:1; " bordercolor="#111111" align="center" colspan="2"><font face="Arial" size="2"><%=tempForentryNumberValues[3]%></font></td>
 
914
                                </tr>
 
915
                
 
916
             <%   }
 
917
                
 
918
             else if((k>=-1 && k<=-1))
 
919
                { 
 
920
               if(k==72) 
 
921
                    { 
 
922
                      %>
 
923
                      </table>
 
924
                      <center>
 
925
                      <br><br>
 
926
                        <font face="arial" size=3><b>&#2357;&#2376;&#2325;&#2381;&#2360;&#2368;&#2344;&#2379;&#2306; &#2324;&#2352; &#2324;&#2359;&#2343;&#2367;&#2351;&#2379;&#2306; &#2325;&#2368; &#2360;&#2370;&#2330;&#2368;</b></font>
 
927
                      </center> 
 
928
                                <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%">
 
929
                      <%
 
930
                      tempForentryNumberValues[0]= "<b>&#2351;&#2370;&#2344;&#2367;&#2335;</b>";
 
931
                             tempForentryNumberValues[1]= "<b>&#2327;&#2340; &#2357;&#2352;&#2381;&#2359; &#2325;&#2375; &#2342;&#2380;&#2352;&#2366;&#2344; &#2344;&#2367;&#2352;&#2381;&#2343;&#2366;&#2352;&#2367;&#2340; &#2325;&#2368; &#2327;&#2312; &#2310;&#2357;&#2358;&#2381;&#2351;&#2325;&#2340;&#2366;</b>";
 
932
                                          tempForentryNumberValues[2]= "<b>&#2327;&#2340; &#2357;&#2352;&#2381;&#2359; &#2346;&#2381;&#2352;&#2366;&#2346;&#2381;&#2340; &#2357;&#2366;&#2360;&#2381;&#2340;&#2357;&#2367;&#2325; &#2350;&#2366;&#2340;&#2381;&#2352;&#2366;</b>";
 
933
                                  tempForentryNumberValues[3]= "<b>&#2327;&#2340; &#2357;&#2352;&#2381;&#2359; &#2325;&#2366; &#2358;&#2375;&#2359; &#2351;&#2366; &#2325;&#2350;&#2368;</b>";
 
934
                                          tempForentryNumberValues[4]= "<b>&#2330;&#2366;&#2354;&#2370; &#2357;&#2352;&#2381;&#2359; &#2325;&#2375; &#2354;&#2367;&#2319; &#2310;&#2357;&#2358;&#2381;&#2351;&#2325;&#2340;&#2366;</b>";
 
935
                      
 
936
                      l=l+5;
 
937
                    }
 
938
                   else if(k==1 || k==3 || k==6 || k==12 || k==14 || k==18 || k==22 || k==23 || k==26 || k==30 || k==31 || k==36 || k==37 || k==47 || k==50 || k==52 || k==54 || k==56 || k==58 || k==59 || k==63 || k==64 || k==69 || k==70 || k==75 || k==76 || k==79 || k==82 || k==88 || k==94 || k==101 || k==106)
 
939
                                {
 
940
                      tempForentryNumberValues[0]= " ";
 
941
                      tempForentryNumberValues[1]= " ";
 
942
                                  tempForentryNumberValues[2]= " ";
 
943
                                  tempForentryNumberValues[3]= " ";
 
944
                                  tempForentryNumberValues[4]= " ";
 
945
                      
 
946
                      l=l+5;
 
947
                    }
 
948
                    
 
949
                   else 
 
950
                    {
 
951
                                        temp =  entryNumberValues[l];
 
952
                                if(temp==-1) tempForentryNumberValues[0] = "";
 
953
                                else tempForentryNumberValues[0] = ""+temp;
 
954
                                        
 
955
                                        l++;
 
956
                                                         
 
957
                                temp =  entryNumberValues[l];
 
958
                                if(temp==-1) tempForentryNumberValues[1] = "";
 
959
                                else tempForentryNumberValues[1] = ""+temp;
 
960
                                                                        
 
961
                                l++;
 
962
                                
 
963
                                        temp =  entryNumberValues[l];
 
964
                                if(temp==-1) tempForentryNumberValues[2] = "";
 
965
                                else tempForentryNumberValues[2] = ""+temp;
 
966
                                
 
967
                                        l++;
 
968
 
 
969
                                        temp =  entryNumberValues[l];
 
970
                                if(temp==-1) tempForentryNumberValues[3] = "";
 
971
                                else tempForentryNumberValues[3] = ""+temp;
 
972
                                
 
973
                                        l++;
 
974
 
 
975
                                        temp =  entryNumberValues[l];
 
976
                                if(temp==-1) tempForentryNumberValues[4] = "";
 
977
                                else tempForentryNumberValues[4] = ""+temp;
 
978
                                
 
979
                                        l++;
 
980
                    } 
 
981
                %>              
 
982
           
 
983
                        <tr>
 
984
                                        <td id="<%=id1%>" name="<%=id1%>" 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"></font></td>
 
985
                                        <td id="<%=id2%>" name="<%=id2%>" width="67%" align="left" 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"></font></td>
 
986
                                        <td width="6%" 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:3; padding-right:1; " bordercolor="#111111" dir="ltr"><font face="Arial" size="2"><%=tempForentryNumberValues[0]%></font></td>
 
987
                                        <td width="6%" 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:3; padding-right:1; " bordercolor="#111111" dir="ltr" colspan="3"><font face="Arial" size="2"><%=tempForentryNumberValues[1]%></font></td>
 
988
                                        <td width="6%" 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:3; padding-right:1; " bordercolor="#111111" dir="ltr" colspan="2"><font face="Arial" size="2"><%=tempForentryNumberValues[2]%></font></td>
 
989
                                        <td width="6%" 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:3; padding-right:1; " bordercolor="#111111" dir="ltr" colspan="3"><font face="Arial" size="2"><%=tempForentryNumberValues[3]%></font></td>
 
990
                                        <td width="6%" 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:3; padding-right:1; " bordercolor="#111111" dir="ltr"><font face="Arial" size="2"><%=tempForentryNumberValues[4]%></font></td>
 
991
                                </tr>
 
992
                
 
993
           <%   }
 
994
 
 
995
             else if((k>=87 && k<=107) || (k>=133 && k<=150))
 
996
                { 
 
997
               if(k==87) 
 
998
                    {
 
999
                        tempForentryNumberValues[0]= "<b>&#2327;&#2340; &#2357;&#2352;&#2381;&#2359; &#2346;&#2381;&#2352;&#2351;&#2369;&#2325;&#2381;&#2340; &#2350;&#2366;&#2340;&#2381;&#2352;&#2366;</b>";
 
1000
                        tempForentryNumberValues[1]= "<b>&#2346;&#2361;&#2354;&#2368; &#2309;&#2346;&#2381;&#2352;&#2376;&#2354; &#2325;&#2379; &#2360;&#2381;&#2335;&#2366;&#2325; &#2325;&#2368; &#2360;&#2381;&#2341;&#2367;&#2340;&#2367;</b>";
 
1001
                                        tempForentryNumberValues[2]= "<b>&#2330;&#2366;&#2354;&#2370; &#2357;&#2352;&#2381;&#2359; &#2325;&#2375; &#2354;&#2367;&#2319; &#2309;&#2346;&#2375;&#2325;&#2381;&#2359;&#2367;&#2340; &#2309;&#2340;&#2367;&#2352;&#2367;&#2325;&#2381;&#2340; &#2350;&#2366;&#2340;&#2381;&#2352;&#2366;</b>";
 
1002
                      
 
1003
                      l=l+3;
 
1004
                    }
 
1005
               else if(k==133) 
 
1006
                    {
 
1007
                        %>
 
1008
                                </table>                      
 
1009
                        <br>
 
1010
                        <font face="arial" size=3><b>&#2360;&#2381;&#2335;&#2366;&#2347; &#2325;&#2368; &#2360;&#2381;&#2341;&#2367;&#2340;&#2367;</b></font>                   
 
1011
                         <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%">
 
1012
                        
 
1013
                        <%
 
1014
                        tempForentryNumberValues[0]= "<b>&#2360;&#2306;&#2360;&#2381;&#2357;&#2368;&#2325;&#2371;&#2340; &#2360;&#2306;&#2326;&#2381;&#2351;&#2366;</b>";
 
1015
                        tempForentryNumberValues[1]= "<b>&#2357;&#2352;&#2381;&#2340;&#2350;&#2366;&#2344; &#2360;&#2306;&#2326;&#2381;&#2351;&#2366;</b>";
 
1016
                                          tempForentryNumberValues[2]= "<b>&#2325;&#2367;&#2360; &#2340;&#2366;&#2352;&#2368;&#2326; &#2360;&#2375; &#2352;&#2367;&#2325;&#2381;&#2340; &#2346;&#2342;&#2379;&#2306; &#2325;&#2368; &#2360;&#2306;&#2326;&#2381;&#2351;&#2366;</b>";
 
1017
                      
 
1018
                      l=l+3;
 
1019
                    }               
 
1020
                   else if(k==1 || k==3 || k==6 || k==12 || k==14 || k==18 || k==22 || k==23 || k==26 || k==30 || k==31 || k==36 || k==37 || k==47 || k==50 || k==52 || k==54 || k==56 || k==58 || k==59 || k==63 || k==64 || k==69 || k==70 || k==75 || k==76 || k==79 || k==82 || k==88 || k==94 || k==101 || k==106)
 
1021
                                {
 
1022
                      tempForentryNumberValues[0]= " ";
 
1023
                      tempForentryNumberValues[1]= " ";
 
1024
                                  tempForentryNumberValues[2]= " ";
 
1025
                      
 
1026
                      l=l+3;
 
1027
                    }
 
1028
                    
 
1029
                   else 
 
1030
                    {
 
1031
                                        temp =  entryNumberValues[l];
 
1032
                                if(temp==-1) tempForentryNumberValues[0] = "";
 
1033
                                else tempForentryNumberValues[0] = ""+temp;
 
1034
                                        
 
1035
                                        l++;
 
1036
                                                         
 
1037
                                temp =  entryNumberValues[l];
 
1038
                                if(temp==-1) tempForentryNumberValues[1] = "";
 
1039
                                else tempForentryNumberValues[1] = ""+temp;
 
1040
                                                                        
 
1041
                                l++;
 
1042
                                
 
1043
                                        temp =  entryNumberValues[l];
 
1044
                                if(temp==-1) tempForentryNumberValues[2] = "";
 
1045
                                else tempForentryNumberValues[2] = ""+temp;
 
1046
                                
 
1047
                                        l++;
 
1048
 
 
1049
                    } 
 
1050
                %>              
 
1051
           
 
1052
                        <tr>
 
1053
                                        <td id="<%=id1%>" name="<%=id1%>" 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"></font></td>
 
1054
                                        <td id="<%=id2%>" name="<%=id2%>" width="67%" align="left" 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"></font></td>
 
1055
                                        <td width="10%" 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:3; padding-right:1; " bordercolor="#111111" dir="ltr" colspan="4"><font face="Arial" size="2"><%=tempForentryNumberValues[0]%></font></td>
 
1056
                                        <td width="10%" 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:3; padding-right:1; " bordercolor="#111111" dir="ltr" colspan="5"><font face="Arial" size="2"><%=tempForentryNumberValues[1]%></font></td>
 
1057
                                        <td width="10%" 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:3; padding-right:1; " bordercolor="#111111" dir="ltr" colspan="4"><font face="Arial" size="2"><%=tempForentryNumberValues[2]%></font></td>
 
1058
                                </tr>
 
1059
           <%   }
 
1060
 
 
1061
             else 
 
1062
              {                                   
 
1063
                          if(k==0)
 
1064
                            {
 
1065
                                tempForentryNumberValues[0]= "<font face='arial' size=3><b>&#2327;&#2340; &#2357;&#2352;&#2381;&#2359; &#2325;&#2366; &#2344;&#2367;&#2359;&#2381;&#2346;&#2366;&#2342;&#2344;</b></font>";
 
1066
                        tempForentryNumberValues[1]= "<font face='arial' size=3><b>&#2313;&#2346;-&#2325;&#2375;&#2306;&#2342;&#2381;&#2352; &#2351;&#2379;&#2332;&#2344;&#2366;&#2323;&#2306; &#2360;&#2375; &#2360;&#2306;&#2325;&#2354;&#2367;&#2340; &#2330;&#2366;&#2354;&#2370; &#2357;&#2352;&#2381;&#2359; &#2325;&#2375; &#2354;&#2367;&#2319; &#2351;&#2379;&#2332;&#2344;&#2366;&#2348;&#2342;&#2381;&#2342; &#2310;&#2357;&#2358;&#2381;&#2351;&#2325;&#2340;&#2366;</b></font>";
 
1067
                      
 
1068
                      l=l+2;
 
1069
                            }                       
 
1070
                          else if(k==28)
 
1071
                            {
 
1072
                                tempForentryNumberValues[0]= "<font face='arial' size=3><b>&#2327;&#2340; &#2357;&#2352;&#2381;&#2359; &#2325;&#2366; &#2344;&#2367;&#2359;&#2381;&#2346;&#2366;&#2342;&#2344;</b></font>";
 
1073
                        tempForentryNumberValues[1]= "<font face='arial' size=3><b>&#2330;&#2366;&#2354;&#2370; &#2357;&#2352;&#2381;&#2359; &#2325;&#2375; &#2354;&#2367;&#2319; &#2346;&#2381;&#2352;&#2340;&#2381;&#2351;&#2366;&#2358;&#2367;&#2340; &#2310;&#2357;&#2358;&#2381;&#2351;&#2325;&#2340;&#2366;</b></font>";
 
1074
                      
 
1075
                      l=l+2;
 
1076
                            }                       
 
1077
              else if(k==108) 
 
1078
                    { %>
 
1079
                               </table>                       
 
1080
                        <br>
 
1081
                        <font face="arial" size=3><b>&#2313;&#2346;&#2360;&#2381;&#2325;&#2352; &#2340;&#2341;&#2366; &#2360;&#2369;&#2357;&#2367;&#2343;&#2366;&#2319;&#2306;<br>1. &#2346;&#2381;&#2352;&#2366;&#2341;&#2350;&#2367;&#2325; &#2360;&#2381;&#2357;&#2366;&#2360;&#2381;&#2341;&#2381;&#2351; &#2325;&#2375;&#2306;&#2342;&#2381;&#2352; &#2349;&#2357;&#2344; &#2309;&#2346;&#2344;&#2366; &#2351;&#2366; &#2325;&#2367;&#2352;&#2366;&#2351;&#2375; &#2346;&#2352;:</b></font>                        
 
1082
                         <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%">
 
1083
                                  
 
1084
                                  <%    
 
1085
                      tempForentryNumberValues[0]= "<b>&#2313;&#2346;&#2354;&#2348;&#2381;&#2343;</b>";
 
1086
                      tempForentryNumberValues[1]= "<b>&#2350;&#2366;&#2340;&#2381;&#2352;&#2366; / &#2327;&#2369;&#2339;&#2357;&#2340;&#2381;&#2340;&#2366;</b>";
 
1087
                      
 
1088
                      l=l+2;
 
1089
                    }
 
1090
                   else if(k==1 || k==3 || k==6 || k==12 || k==14 || k==18 || k==22 || k==23 || k==26 || k==30 || k==31 || k==36 || k==37 || k==47 || k==50 || k==52 || k==54 || k==56 || k==58 || k==59 || k==63 || k==64 || k==69 || k==70 || k==75 || k==76 || k==79 || k==82 || k==88 || k==94 || k==101 || k==106)
 
1091
                                {
 
1092
                                tempForentryNumberValues[0]= " ";
 
1093
                        tempForentryNumberValues[1]= " ";
 
1094
                      
 
1095
                        l=l+2;                          
 
1096
                                }
 
1097
                         else 
 
1098
                  {
 
1099
                                        temp =  entryNumberValues[l];
 
1100
                                if(temp==-1) tempForentryNumberValues[0] = "";
 
1101
                                else tempForentryNumberValues[0] = ""+temp;
 
1102
                                        
 
1103
                                        l++;
 
1104
                                        
 
1105
                                        temp =  entryNumberValues[l];
 
1106
                                if(temp==-1) tempForentryNumberValues[1] = "";
 
1107
                                else tempForentryNumberValues[1] = ""+temp;
 
1108
                                                                        
 
1109
                                        l++;
 
1110
                  }     
 
1111
               %>
 
1112
                        <tr>
 
1113
                                        <td id="<%=id1%>" name="<%=id1%>" 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"></font></td>
 
1114
                                        <td id="<%=id2%>" name="<%=id2%>" width="67%" align="left" 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"></font></td>
 
1115
                                        <td width="15%" 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:3; padding-right:1; " bordercolor="#111111" dir="ltr" colspan="5"><font face="Arial" size="2"><%=tempForentryNumberValues[0]%></font></td>
 
1116
                                        <td width="15%" 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:3; padding-right:1; " bordercolor="#111111" align="center" colspan="5"><font face="Arial" size="2"><%=tempForentryNumberValues[1]%></font></td>
 
1117
                                </tr>
 
1118
                <% 
 
1119
             }                     
 
1120
                 k++;
 
1121
                }               
 
1122
                 j++;
 
1123
                %>
 
1124
                </table>
 
1125
                <%
 
1126
         }      
 
1127
 %>
 
1128
</BODY>
 
1129
</HTML>
 
 
b'\\ No newline at end of file'