2
<%@ page import="java.sql.*" %>
3
<%@ page import="com.opensymphony.xwork.util.OgnlValueStack" %>
8
// for Performance in the Reporting Month
12
// for selected OrgUnit Name and Population
16
// for Performance in Corresponding month Last Year
20
// for Cumulative Performance till Current Month
24
// for Cumulative Performance till corresponding month of Last Year
28
// for Taluk Name and Id
32
// for District Name and Id
36
// for PHC Name and Id
40
// for CHC Name and Id
44
// for PHC Population Estimates
48
// for Data Period Start Date and End Date
52
// for DataElement ids based on DataElement code
57
String userName = "dhis";
59
String urlForConnection = "jdbc:mysql://localhost/jh_dhis2";
62
String talukName = "";
64
String districtName = "";
69
int totPHCPopulation = -1;
70
int totSCPopulation = -1;
72
OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
73
String selectedId = (String) stack.findValue( "orgUnitId" );
74
int selectedOrgUnitID = Integer.parseInt( selectedId );
76
String startingDate = (String) stack.findValue( "startingPeriod" );
77
String endingDate = (String) stack.findValue( "endingPeriod" );
79
String monthlyPeriodId = (String) stack.findValue( "monthlyPeriodTypeId" );
80
int periodTypeID = Integer.parseInt( monthlyPeriodId );
84
String selectedOrgUnitName = "";
85
String selectedDataPeriodStartDate = "";
86
String selectedDataPeriodEndDate = "";
87
String lastDataPeriodStartDate = "";
89
String dataElementCodes[] = {
91
// Element Group 1 + 2
92
"' '", "'Form6_DE1'", "'Form6_DE2'", "' '","' '","' '","'Form6_DE3'", "'Form6_DE4'", "'Form6_DE5'", "'Form6_DE6'", "'Form6_DE7'",
93
"'Form6_DE8'","'Form6_DE9'", "'Form6_DE10'", "'Form6_DE11'", "'Form6_DE12'", "'Form6_DE13'", "'Form6_DE14'", "'Form6_DE15'",
94
"'Form6_DE16'", "'Form6_DE17'", "'Form6_DE1501'", "'Form6_DE25'", "'Form6_DE1502'","'Form6_DE21'", "'Form6_DE22'", "'Form6_DE23'",
95
"'Form6_DE24'", "'Form6_DE19'", "'Form6_DE26'", "'Form6_DE27'", "'Form6_DE28'", "'Form6_DE29'", "'Form6_DE30'", "'Form6_DE31'",
96
"'Form6_DE32'", "'Form6_DE33'", "'Form6_DE34'", "'Form6_DE35'", "'Form6_DE36'", "'Form6_DE37'", "'Form6_DE38'",
99
"'Form6_DE39','Form6_DE42','Form6_DE45'",
100
"'Form6_DE40','Form6_DE43','Form6_DE46'",
101
"'Form6_DE41','Form6_DE44','Form6_DE47'",
103
"'Form6_DE39'", "'Form6_DE40'", "'Form6_DE41'", "'Form6_DE42'", "'Form6_DE43'", "'Form6_DE44'", "'Form6_DE45'", "'Form6_DE46'",
104
"'Form6_DE47'", "'Form6_DE48'", "'Form6_DE49'", "'Form6_DE50'", "'Form6_DE51'", "'Form6_DE52'", "'Form6_DE53'", "'Form6_DE54'",
105
"'Form6_DE55'","'Form6_DE56'",
110
" 'Form6_DE60','Form6_DE63','Form6_DE66','Form6_DE69','Form6_DE75','Form7_DE4','Form7_DE7','Form6_DE78','Form6_DE81'",
111
" 'Form6_DE61','Form6_DE64','Form6_DE67','Form6_DE70','Form6_DE76','Form7_DE5','Form7_DE8','Form6_DE79','Form6_DE82'",
112
" 'Form6_DE62','Form6_DE65','Form6_DE68','Form6_DE71','Form6_DE77','Form7_DE6','Form7_DE9','Form6_DE80','Form6_DE83'",
115
" 'Form6_DE60','Form6_DE63','Form6_DE66','Form6_DE69' ",
116
" 'Form6_DE61','Form6_DE64','Form6_DE67','Form6_DE70' ",
117
" 'Form6_DE62','Form6_DE65','Form6_DE68','Form6_DE71' ",
119
"'Form6_DE60'", "'Form6_DE61'", "'Form6_DE62'", "'Form6_DE63'", "'Form6_DE64'", "'Form6_DE65'", "'Form6_DE66'", "'Form6_DE67'",
120
"'Form6_DE68'", "'Form6_DE69'", "'Form6_DE70'", "'Form6_DE71'",
123
" 'Form6_DE75','Form7_DE4','Form7_DE7' ",
124
" 'Form6_DE76','Form7_DE5','Form7_DE8' ",
125
" 'Form6_DE77','Form7_DE6','Form7_DE9' ",
127
"'Form6_DE75'", "'Form6_DE76'", "'Form6_DE77'", "'Form7_DE4'","'Form7_DE5'","'Form7_DE6'", "'Form7_DE7'","'Form7_DE8'","'Form7_DE9'",
130
" 'Form6_DE78','Form6_DE81' ",
131
" 'Form6_DE79','Form6_DE82' ",
132
" 'Form6_DE80','Form6_DE83' ",
134
"'Form6_DE78'", "'Form6_DE79'", "'Form6_DE80'", "'Form6_DE81'", "'Form6_DE82'", "'Form6_DE83'",
136
"' '","' '","' '","' '","' '","' '",
147
"'Form6_DE84'", "'Form6_DE85'", "'Form6_DE86'", "'Form6_DE87'", "'Form6_DE88'", "'Form6_DE89'", "'Form6_DE90'", "'Form6_DE91'",
148
"'Form6_DE92'", "'Form6_DE93'", "'Form6_DE94'", "'Form6_DE95'",
150
"' '","' '","' '","' '","' '","' '",
152
"'Form6_DE96'", "'Form6_DE97'", "'Form6_DE98'", "'Form6_DE99'", "'Form6_DE100'", "'Form6_DE101'", "'Form6_DE102'","'Form6_DE103'",
153
"'Form6_DE104'", "'Form6_DE105'", "'Form6_DE106'", "'Form6_DE107'", "'Form6_DE108'", "'Form6_DE109'", "'Form6_DE110'", "'Form6_DE111'",
154
"'Form6_DE112'", "'Form6_DE113'",
157
" 'Form6_DE117','Form6_DE123' ",
158
" 'Form6_DE118','Form6_DE124' ",
159
" 'Form6_DE119','Form6_DE125' ",
160
" 'Form6_DE120','Form6_DE126' ",
161
" 'Form6_DE121','Form6_DE127' ",
162
" 'Form6_DE122','Form6_DE128' ",
164
"'Form6_DE117'", "'Form6_DE118'", "'Form6_DE119'", "'Form6_DE120'", "'Form6_DE121'", "'Form6_DE122'", "'Form6_DE123'", "'Form6_DE124'",
165
"'Form6_DE125'", "'Form6_DE126'", "'Form6_DE127'", "'Form6_DE128'",
168
" 'Form7_DE10','Form7_DE13' ",
169
" 'Form7_DE11','Form7_DE14' ",
170
" 'Form7_DE12','Form7_DE15' ",
172
"'Form7_DE10'", "'Form7_DE11'","'Form7_DE12'","'Form7_DE13'","'Form7_DE14'","'Form7_DE15'",
177
" 'Form6_DE135','Form6_DE138','Form6_DE141','Form6_DE144','Form6_DE147' ",
178
" 'Form6_DE136','Form6_DE139','Form6_DE142','Form6_DE145','Form6_DE148' ",
179
" 'Form6_DE137','Form6_DE140','Form6_DE143','Form6_DE146','Form6_DE149' ",
181
"'Form6_DE135'", "'Form6_DE136'", "'Form6_DE137'", "'Form6_DE138'", "'Form6_DE139'", "'Form6_DE140'", "'Form6_DE141'", "'Form6_DE142'",
182
"'Form6_DE143'", "'Form6_DE144'", "'Form6_DE145'", "'Form6_DE146'", "'Form6_DE147'", "'Form6_DE148'", "'Form6_DE149'", "'Form6_DE150'",
183
"'Form6_DE151'", "'Form6_DE152'", "'Form6_DE153'", "'Form6_DE154'", "'Form6_DE155'", "'Form6_DE156'", "'Form6_DE157'", "'Form6_DE158'",
184
"'Form6_DE159'", "'Form6_DE160'", "'Form6_DE161'",
189
" 'Form7_DE16','Form7_DE19' ",
190
" 'Form7_DE17','Form7_DE20' ",
191
" 'Form7_DE18','Form7_DE21' ",
193
"'Form7_DE16'", "'Form7_DE17'", "'Form7_DE18'", "'Form7_DE19'", "'Form7_DE20'", "'Form7_DE21'", "'Form7_DE22'", "'Form7_DE23'", "'Form7_DE24'",
196
" 'Form6_DE1500','Form6_DE171' ",
197
" 'Form6_DE180','Form6_DE172' ",
198
" 'Form6_DE1536','Form6_DE173' ",
200
"'Form6_DE1500'", "'Form6_DE180'", "'Form6_DE1536'", "'Form6_DE171'", "'Form6_DE172'", "'Form6_DE173'",
205
" 'Form6_DE1537','Form6_DE1540' ",
206
" 'Form6_DE1538','Form6_DE1541' ",
207
" 'Form6_DE1539','Form6_DE1542' ",
209
"'Form6_DE1537'", "'Form6_DE1538'", "'Form6_DE1539'", "'Form6_DE1540'", "'Form6_DE1541'", "'Form6_DE1542'",
212
" 'Form6_DE192','Form6_DE195','Form6_DE198' ",
213
" 'Form6_DE193','Form6_DE196','Form6_DE199' ",
214
" 'Form6_DE194','Form6_DE197','Form6_DE200' ",
216
"'Form6_DE192'", "'Form6_DE193'", "'Form6_DE194'", "'Form6_DE195'", "'Form6_DE196'", "'Form6_DE197'", "'Form6_DE198'", "'Form6_DE199'",
217
"'Form6_DE200'", "'Form7_DE25'", "'Form7_DE26'",
224
" 'Form6_DE207','Form6_DE210','Form6_DE213','Form6_DE216' ",
225
" 'Form6_DE208','Form6_DE211','Form6_DE214','Form6_DE217' ",
226
" 'Form6_DE209','Form6_DE212','Form6_DE215','Form6_DE218' ",
228
"'Form6_DE207'", "'Form6_DE208'", "'Form6_DE209'", "'Form6_DE210'", "'Form6_DE211'", "'Form6_DE212'", "'Form6_DE213'", "'Form6_DE214'",
229
"'Form6_DE215'", "'Form6_DE216'", "'Form6_DE217'", "'Form6_DE218'",
232
" 'Form6_DE222','Form6_DE225','Form6_DE228' ",
233
" 'Form6_DE223','Form6_DE226','Form6_DE229' ",
234
" 'Form6_DE224','Form6_DE227','Form6_DE230' ",
236
"'Form6_DE222'", "'Form6_DE223'", "'Form6_DE224'", "'Form6_DE225'", "'Form6_DE226'", "'Form6_DE227'", "'Form6_DE228'", "'Form6_DE229'",
240
" 'Form6_DE234','Form6_DE237' ",
241
" 'Form6_DE235','Form6_DE238' ",
242
" 'Form6_DE236','Form6_DE239' ",
244
"'Form6_DE234'", "'Form6_DE235'", "'Form6_DE236'", "'Form6_DE237'", "'Form6_DE238'", "'Form6_DE239'",
247
" 'Form7_DE27','Form7_DE30','Form7_DE33' ",
248
" 'Form7_DE28','Form7_DE31','Form7_DE34' ",
249
" 'Form7_DE29','Form7_DE32','Form7_DE35' ",
251
"'Form7_DE27'", "'Form7_DE28'", "'Form7_DE29'", "'Form7_DE30'", "'Form7_DE31'", "'Form7_DE32'", "'Form7_DE33'","'Form7_DE34'", "'Form7_DE35'",
254
" 'Form6_DE246','Form6_DE249','Form6_DE252' ",
255
" 'Form6_DE247','Form6_DE250','Form6_DE253' ",
256
" 'Form6_DE248','Form6_DE251','Form6_DE254' ",
258
"'Form6_DE246'", "'Form6_DE247'", "'Form6_DE248'", "'Form6_DE249'", "'Form6_DE250'", "'Form6_DE251'", "'Form6_DE252'", "'Form6_DE253'",
263
"'Form6_DE258'","'Form6_DE259'", "'Form6_DE260'", "'Form7_DE36'", "'Form7_DE37'", "'Form7_DE38'",
266
" 'Form7_DE42','Form7_DE45' ",
267
" 'Form7_DE43','Form7_DE46' ",
268
" 'Form7_DE44','Form7_DE47' ",
270
"'Form7_DE42'", "'Form7_DE43'", "'Form7_DE44'", "'Form7_DE45'", "'Form7_DE46'", "'Form7_DE47'", "'Form7_DE48'", "'Form7_DE49'", "'Form7_DE50'",
272
"' '","' '","' '","' '","' '","' '",
274
"'Form6_DE261'", "'Form6_DE262'", "'Form6_DE263'", "'Form6_DE264'", "'Form6_DE265'", "'Form6_DE266'", "'Form6_DE267'", "'Form6_DE268'",
275
"'Form6_DE269'", "'Form6_DE270'", "'Form6_DE271'", "'Form6_DE272'", "'Form6_DE273'", "'Form6_DE274'", "'Form6_DE275'", "'Form6_DE276'",
276
"'Form6_DE277'", "'Form6_DE278'", "'Form7_DE51'", "'Form7_DE52'", "'Form7_DE53'", "'Form7_DE54'", "'Form7_DE55'", "'Form7_DE56'",
280
"'Form6_DE279'", "'Form6_DE280'", "'Form6_DE281'", "'Form6_DE282'", "'Form6_DE283'", "'Form6_DE284'", "'Form6_DE285'", "'Form6_DE286'",
281
"'Form6_DE287'", "'Form6_DE288'", "'Form6_DE289'", "'Form6_DE290'", "'Form6_DE291'", "'Form6_DE292'", "'Form6_DE293'", "'Form6_DE294'",
286
"'Form6_DE296'", "'Form6_DE297'", "'Form6_DE298'",
289
" 'Form6_DE302','Form6_DE305','Form6_DE308' ",
290
" 'Form6_DE303','Form6_DE306','Form6_DE309' ",
291
" 'Form6_DE304','Form6_DE307','Form6_DE310' ",
293
"'Form6_DE302'", "'Form6_DE303'", "'Form6_DE304'", "'Form6_DE305'", "'Form6_DE306'", "'Form6_DE307'", "'Form6_DE308'", "'Form6_DE309'",
298
"'Form6_DE311'", "'Form6_DE312'",
302
"'Form6_DE313'", "'Form6_DE314'", "'Form6_DE315'",
305
" 'Form6_DE317','Form6_DE318' ",
307
"'Form6_DE317'", "'Form6_DE318'",
309
"' '", "' '", "' '", "' '", "' '", "' '",
311
"'Form6_DE319'", "'Form6_DE320'", "'Form6_DE321'", "'Form6_DE322'", "'Form6_DE323'", "'Form6_DE324'", "'Form6_DE325'", "'Form6_DE326'",
312
"'Form6_DE327'", "'Form6_DE328'", "'Form6_DE329'", "'Form6_DE330'",
315
" 'Form6_DE337','Form6_DE343','Form6_DE349' ",
316
" 'Form6_DE338','Form6_DE344','Form6_DE350' ",
317
" 'Form6_DE339','Form6_DE345','Form6_DE351' ",
318
" 'Form6_DE340','Form6_DE346','Form6_DE352' ",
319
" 'Form6_DE341','Form6_DE347','Form6_DE353' ",
320
" 'Form6_DE342','Form6_DE348','Form6_DE354' ",
322
"'Form6_DE337'", "'Form6_DE338'", "'Form6_DE339'", "'Form6_DE340'", "'Form6_DE341'", "'Form6_DE342'", "'Form6_DE343'", "'Form6_DE344'",
324
"'Form6_DE346'", "'Form6_DE347'", "'Form6_DE348'", "'Form6_DE349'", "'Form6_DE350'", "'Form6_DE351'", "'Form6_DE352'", "'Form6_DE353'",
328
" 'Form6_DE361','Form6_DE367','Form6_DE373','Form6_DE379' ",
329
" 'Form6_DE362','Form6_DE368','Form6_DE374','Form6_DE380' ",
330
" 'Form6_DE363','Form6_DE369','Form6_DE375','Form6_DE381' ",
331
" 'Form6_DE364','Form6_DE370','Form6_DE376','Form6_DE382' ",
332
" 'Form6_DE365','Form6_DE371','Form6_DE377','Form6_DE383' ",
333
" 'Form6_DE366','Form6_DE372','Form6_DE378','Form6_DE384' ",
335
"'Form6_DE361'", "'Form6_DE362'", "'Form6_DE363'",
336
"'Form6_DE364'", "'Form6_DE365'", "'Form6_DE366'", "'Form6_DE367'", "'Form6_DE368'", "'Form6_DE369'", "'Form6_DE370'", "'Form6_DE371'",
338
"'Form6_DE373'", "'Form6_DE374'", "'Form6_DE375'", "'Form6_DE376'", "'Form6_DE377'", "'Form6_DE378'", "'Form6_DE379'", "'Form6_DE380'",
340
"'Form6_DE382'", "'Form6_DE383'", "'Form6_DE384'",
343
" 'Form6_DE391','Form6_DE397','Form6_DE403' ",
344
" 'Form6_DE392','Form6_DE398','Form6_DE404' ",
345
" 'Form6_DE393','Form6_DE399','Form6_DE405' ",
346
" 'Form6_DE394','Form6_DE400','Form6_DE406' ",
347
" 'Form6_DE395','Form6_DE401','Form6_DE407' ",
348
" 'Form6_DE396','Form6_DE402','Form6_DE408' ",
350
"'Form6_DE391'", "'Form6_DE392'", "'Form6_DE393'", "'Form6_DE394'", "'Form6_DE395'", "'Form6_DE396'", "'Form6_DE397'", "'Form6_DE398'",
352
"'Form6_DE400'", "'Form6_DE401'", "'Form6_DE402'", "'Form6_DE403'", "'Form6_DE404'", "'Form6_DE405'", "'Form6_DE406'", "'Form6_DE407'",
354
"'Form6_DE409'", "'Form6_DE410'", "'Form6_DE411'", "'Form6_DE412'", "'Form6_DE413'", "'Form6_DE414'", "'Form6_DE415'", "'Form6_DE416'",
356
"'Form6_DE448'", "'Form6_DE449'", "'Form6_DE450'",
360
" 'Form6_DE457','Form6_DE463' ",
361
" 'Form6_DE458','Form6_DE464' ",
362
" 'Form6_DE459','Form6_DE465' ",
363
" 'Form6_DE460','Form6_DE466' ",
364
" 'Form6_DE461','Form6_DE467' ",
365
" 'Form6_DE462','Form6_DE468' ",
368
"'Form6_DE458'", "'Form6_DE459'", "'Form6_DE460'", "'Form6_DE461'", "'Form6_DE462'", "'Form6_DE463'", "'Form6_DE464'", "'Form6_DE465'",
370
"'Form6_DE467'", "'Form6_DE468'",
372
"' '","' '","' '","' '","' '","' '",
375
"'Form6_DE476'", "'Form6_DE477'", "'Form6_DE478'", "'Form6_DE479'", "'Form6_DE480'", "'Form6_DE481'", "'Form6_DE482'", "'Form6_DE483'",
377
"'Form6_DE485'", "'Form6_DE486'", "'Form6_DE487'", "'Form6_DE488'", "'Form6_DE489'", "'Form6_DE490'", "'Form6_DE491'", "'Form6_DE492'",
379
"'Form6_DE494'", "'Form6_DE495'", "'Form6_DE496'", "'Form6_DE497'", "'Form6_DE498'",
382
" 'Form6_DE505','Form6_DE511' ",
383
" 'Form6_DE506','Form6_DE512' ",
384
" 'Form6_DE507','Form6_DE513' ",
385
" 'Form6_DE508','Form6_DE514' ",
386
" 'Form6_DE509','Form6_DE515' ",
387
" 'Form6_DE510','Form6_DE516' ",
389
"'Form6_DE505'", "'Form6_DE506'", "'Form6_DE507'", "'Form6_DE508'", "'Form6_DE509'", "'Form6_DE510'", "'Form6_DE511'",
390
"'Form6_DE512'", "'Form6_DE513'", "'Form6_DE514'", "'Form6_DE515'", "'Form6_DE516'", "'Form6_DE517'", "'Form6_DE518'", "'Form6_DE519'",
392
"'Form6_DE521'", "'Form6_DE522'", "'Form6_DE523'", "'Form6_DE524'", "'Form6_DE525'", "'Form6_DE526'", "'Form6_DE527'", "'Form6_DE528'",
394
"'Form6_DE530'", "'Form6_DE531'", "'Form6_DE532'", "'Form6_DE533'", "'Form6_DE534'", "'Form6_DE535'", "'Form6_DE536'", "'Form6_DE537'",
396
"'Form6_DE539'", "'Form6_DE540'",
399
"'Form6_DE541'", "'Form6_DE542'", "'Form6_DE543'", "'Form6_DE544'", "'Form6_DE545'", "'Form6_DE546'", "'Form6_DE547'", "'Form6_DE548'",
401
"'Form6_DE550'", "'Form6_DE551'", "'Form6_DE552'", "'Form6_DE553'", "'Form6_DE554'", "'Form6_DE555'", "'Form6_DE556'", "'Form6_DE557'",
403
"'Form6_DE559'", "'Form6_DE560'", "'Form6_DE561'", "'Form6_DE562'", "'Form6_DE563'", "'Form6_DE564'", "'Form6_DE565'", "'Form6_DE566'",
405
"'Form6_DE568'", "'Form6_DE569'", "'Form6_DE570'", "'Form6_DE571'", "'Form6_DE572'", "'Form6_DE573'", "'Form6_DE574'", "'Form6_DE575'",
407
"'Form6_DE577'", "'Form6_DE578'", "'Form6_DE579'", "'Form6_DE580'", "'Form6_DE581'", "'Form6_DE582'", "'Form6_DE583'", "'Form6_DE584'",
409
"'Form6_DE586'", "'Form6_DE587'", "'Form6_DE588'", "'Form6_DE589'", "'Form6_DE590'", "'Form6_DE591'", "'Form6_DE592'", "'Form6_DE593'",
411
"'Form6_DE595'", "'Form6_DE596'", "'Form6_DE597'", "'Form6_DE598'", "'Form6_DE599'", "'Form6_DE600'", "'Form6_DE601'", "'Form6_DE602'",
413
"'Form6_DE604'", "'Form6_DE605'", "'Form6_DE606'", "'Form6_DE607'", "'Form6_DE608'", "'Form6_DE609'", "'Form6_DE610'", "'Form6_DE611'",
415
"'Form6_DE613'", "'Form6_DE614'", "'Form6_DE615'", "'Form6_DE616'", "'Form6_DE617'", "'Form6_DE618'", "'Form6_DE619'", "'Form6_DE620'",
418
"' '","' '","' '","' '",
420
"'Form7_DE57'", "'Form7_DE58'",
424
"'Form7_DE59'", "'Form7_DE60'",
428
"'Form7_DE61'", "'Form7_DE62'",
432
"'Form7_DE63'", "'Form7_DE64'",
436
"'Form7_DE65'", "'Form7_DE66'",
440
"'Form7_DE67'", "'Form7_DE68'",
444
"' '","' '","' '","' '","' '","' '","' '","' '","' '",
447
"'Form6_DE622'", "'Form6_DE623'", "'Form6_DE624'", "'Form6_DE625'", "'Form6_DE626'", "'Form6_DE627'",
448
"'Form6_DE628'", "'Form6_DE629'", "'Form6_DE630'", "'Form6_DE631'", "'Form6_DE632'", "'Form6_DE633'", "'Form6_DE634'", "'Form6_DE635'",
450
"'Form6_DE637'", "'Form6_DE638'", "'Form6_DE639'", "'Form6_DE640'", "'Form6_DE641'", "'Form6_DE642'", "'Form6_DE643'", "'Form6_DE644'",
452
"'Form6_DE646'", "'Form6_DE647'", "'Form6_DE648'", "'Form6_DE649'", "'Form6_DE650'",
455
"' '","' '","' '","' '",
457
"'Form7_DE69'", "'Form7_DE70'",
461
"'Form7_DE71'", "'Form7_DE72'",
465
"'Form7_DE73'", "'Form7_DE74'",
471
"'Form6_DE651'", "'Form6_DE652'", "'Form6_DE653'",
474
" 'Form7_DE75','Form6_DE726' ",
475
" 'Form7_DE76','Form6_DE727' ",
476
" 'Form7_DE77','Form6_DE728' ",
478
"'Form7_DE75'", "'Form7_DE76'", "'Form7_DE77'",
479
"'Form6_DE726'", "'Form6_DE727'", "'Form6_DE728'",
482
" 'Form6_DE729','Form6_DE732','Form6_DE735' ",
483
" 'Form6_DE730','Form6_DE733','Form6_DE736' ",
484
" 'Form6_DE731','Form6_DE734','Form6_DE737' ",
486
"'Form6_DE729'", "'Form6_DE730'", "'Form6_DE731'",
487
"'Form6_DE732'", "'Form6_DE733'", "'Form6_DE734'", "'Form6_DE735'", "'Form6_DE736'", "'Form6_DE737'",
488
"'Form6_DE666'", "'Form6_DE667'",
489
"'Form6_DE1529'", "'Form6_DE669'", "'Form6_DE670'", "'Form6_DE671'", "'Form6_DE672'", "'Form6_DE673'", "'Form6_DE674'", "'Form6_DE675'",
491
"'Form6_DE677'", "'Form6_DE678'", "'Form6_DE679'", "'Form6_DE680'", "'Form6_DE681'", "'Form6_DE682'", "'Form6_DE683'", "'Form6_DE684'",
493
"'Form6_DE686'", "'Form6_DE687'", "'Form6_DE688'", "'Form6_DE689'", "'Form6_DE690'", "'Form6_DE691'", "'Form6_DE692'", "'Form6_DE693'",
495
"'Form6_DE695'", "'Form6_DE696'", "'Form6_DE697'", "'Form6_DE698'", "'Form6_DE699'", "'Form6_DE700'", "'Form6_DE701'", "'Form6_DE702'",
497
"'Form6_DE704'", "'Form6_DE705'", "'Form6_DE706'", "'Form6_DE707'", "'Form6_DE708'", "'Form6_DE709'", "'Form6_DE710'", "'Form6_DE711'",
499
"'Form6_DE713'", "'Form6_DE714'", "'Form6_DE715'", "'Form6_DE716'", "'Form6_DE717'", "'Form6_DE718'", "'Form6_DE719'",
504
" 'Form6_DE723','Form6_DE726' ",
505
" 'Form6_DE724','Form6_DE727' ",
506
" 'Form6_DE725','Form6_DE728' ",
508
"'Form6_DE723'", "'Form6_DE724'", "'Form6_DE725'", "'Form6_DE726'", "'Form6_DE727'",
512
" 'Form6_DE729','Form6_DE732','Form6_DE735' ",
513
" 'Form6_DE730','Form6_DE733','Form6_DE736' ",
514
" 'Form6_DE731','Form6_DE734','Form6_DE737' ",
516
"'Form6_DE729'", "'Form6_DE730'", "'Form6_DE731'", "'Form6_DE732'", "'Form6_DE733'", "'Form6_DE734'", "'Form6_DE735'",
517
"'Form6_DE736'", "'Form6_DE737'",
519
"' '", "' '", "' '", "' '","' '","' '","' '","' '","' '",
521
"'Form6_DE741'", "'Form6_DE742'",
522
"'Form6_DE743'", "'Form6_DE744'", "'Form6_DE745'", "'Form6_DE746'", "'Form6_DE747'", "'Form6_DE748'", "'Form6_DE749'",
530
int dataElementIDs[] = new int[dataElementCodes.length+5];
531
int entryNumberValues[]= new int[dataElementCodes.length+5];
532
int entryValuesForLastYear[]= new int[dataElementCodes.length+5];
533
int cumentryValuesForCurYear[]= new int[dataElementCodes.length+5];
534
int cumentryValuesForLastYear[]= new int[dataElementCodes.length+5];
536
String monthNames[] = { "", "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" };
543
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
544
con = DriverManager.getConnection (urlForConnection, userName, password);
546
st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
547
st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
548
st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
549
st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
550
st4=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
551
st5=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
552
st6=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
553
st8=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
554
st9=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
555
st10=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
556
st11=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
557
st12=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
560
//rs1 = st1.executeQuery("SELECT organisationunit.shortname FROM organisationunit WHERE id ="+selectedOrgUnitID);
561
rs1 = st1.executeQuery("SELECT organisationunit.shortname FROM organisationunit WHERE organisationunitid ="+selectedOrgUnitID);
562
if(rs1.next()) { selectedOrgUnitName = rs1.getString(1); }
563
else { selectedOrgUnitName = ""; }
565
//rs11 = st11.executeQuery("select startDate,endDate from period where id = "+selectedDataPeriodID);
568
// selectedDataPeriodStartDate = rs11.getDate(1).toString();
569
// selectedDataPeriodEndDate = rs11.getDate(2).toString();
572
selectedDataPeriodStartDate = startingDate;
575
catch(Exception e) { out.println(e.getMessage()); }
580
if(rs1!=null) rs1.close(); if(st1!=null) st1.close();
581
if(rs11!=null) rs11.close(); if(st11!=null) st11.close();
583
catch(Exception e) { out.println(e.getMessage()); }
584
} // finally block end
586
String partsOfDataPeriodStartDate[] = selectedDataPeriodStartDate.split("-");
587
String partsOfDataPeriodEndDate[] = endingDate.split("-");
589
lastYear = Integer.parseInt(partsOfDataPeriodStartDate[0]) - 1;
590
lastDataPeriodStartDate = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
592
int tempForMonth1 = Integer.parseInt(partsOfDataPeriodStartDate[1]);
595
if(tempForMonth1 < 4) { tempForYear = lastYear; }
596
else { tempForYear = lastYear + 1; }
598
String curYearStart = tempForYear+"-04-01";
599
String lastYearStart = (tempForYear-1)+"-04-01";
600
String lastYearEnd = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
602
//for district, taluk, CHC names
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
rs8=st8.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+selectedOrgUnitID+")");
607
if(rs8.next()) { PHCID = rs8.getInt(1);PHCName = rs8.getString(2); }
608
else { PHCID = 0; PHCName = ""; }
610
//rs9=st9.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+PHCID+")");
611
rs9=st9.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+PHCID+")");
612
if(rs9.next()) { CHCID = rs9.getInt(1);CHCName = rs9.getString(2); }
613
else { CHCID = 0; CHCName = ""; }
615
//rs5=st5.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+CHCID+")");
616
rs5=st5.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+CHCID+")");
617
if(rs5.next()) { talukID = rs5.getInt(1); talukName = rs5.getString(2); }
618
else { talukID = 0; talukName = ""; }
620
//rs6=st6.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+talukID+")");
621
rs6=st6.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+talukID+")");
622
if(rs6.next()) { districtID = rs6.getInt(1); districtName = rs6.getString(2);}
623
else {districtID = 0; districtName = "";}
625
//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'");
626
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'");
627
if(rs10.next()) { totPHCPopulation = rs10.getInt(1);}
628
else {totPHCPopulation = 0;}
631
catch(Exception e) { out.println(e.getMessage()); }
636
if(rs5!=null) rs5.close(); if(st5!=null) st5.close();
637
if(rs6!=null) rs6.close(); if(st6!=null) st6.close();
638
if(rs8!=null) rs8.close(); if(st8!=null) st8.close();
639
if(rs9!=null) rs9.close(); if(st9!=null) st9.close();
640
if(rs10!=null) rs10.close(); if(st10!=null) st10.close();
642
catch(Exception e) { out.println(e.getMessage()); }
643
} // finally block end
648
int j= dataElementCodes.length;
654
entryNumberValues[i] = -1;
655
entryValuesForLastYear[i] = -1;
656
cumentryValuesForCurYear[i] = -1;
657
cumentryValuesForLastYear[i] = -1;
659
// for Performance in the reporting month
660
//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]+")";
661
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]+")";
662
rs=st.executeQuery(query);
663
if(rs.next()) { entryNumberValues[i] = rs.getInt(1); }
664
else { entryNumberValues[i] = 0; }
666
// for Cumulative Performance till Current Month
667
//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]+")";
668
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]+")";
669
rs4=st4.executeQuery(query);
670
if(rs4.next()) { cumentryValuesForCurYear[i]= rs4.getInt(1); }
671
else { cumentryValuesForCurYear[i] = 0; }
676
catch(Exception e) { out.println(e.getMessage()); }
681
if(rs!=null) rs.close(); if(st!=null) st.close();
682
if(rs2!=null) rs2.close(); if(st2!=null) st2.close();
683
if(rs3!=null) rs3.close(); if(st3!=null) st3.close();
684
if(rs4!=null) rs4.close(); if(st4!=null) st4.close();
685
if(rs12!=null) rs12.close(); if(st12!=null) st12.close();
687
if(con!=null) con.close();
689
catch(Exception e) { out.println(e.getMessage()); }
690
} // finally block end
695
<TITLE>Form - 5</TITLE>
696
<script src="../dhis-web-reports/Jharkhand/JDENamesForForm5.js" type="text/javascript" language="Javascript"></script>
711
else if(j==2) end = 31;
712
else if(j==3) end = 25;
713
else if(j==4) end = 21;
714
else if(j==5) end = 14;
716
for(start=0;start<=end;start++)
719
document.getElementById(id).innerHTML = slnoForForm5[k];
721
document.getElementById(id).innerHTML = denamesForForm5[k];
730
<BODY BGCOLOR="#FFFFFF" onload="fun1()">
731
<font face="Arial" size="2">(निकनेट के
732
माध्यम से राज्य परिवार कल्याण अधिकारी द्वारा परिवार कल्याण विभाग भारत सरकार
733
को 25 मार्च तक प्रस्तुत किया जाए)</font>
735
<font face="Arial" size="3">
736
<b>फार्म 5<br>राज्य कार्ययोजना</b></font>
739
<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">
740
<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%">
741
<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">
742
<font face="Arial" size="2">क. सामान्य सूचना : </font>
744
<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">
745
<font face="Arial" size="2"></font>
749
<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">
750
<font face="Arial" size="2">राज्य : <%=selectedOrgUnitName%></font>
752
<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">
753
<font face="Arial" size="2">वर्ष : <%=partsOfDataPeriodStartDate[0]%> - <%=partsOfDataPeriodEndDate[0]%></font>
757
<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">
758
<font face="Arial" size="2">राज्य में जिलों की संख्या : </font>
760
<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">
761
<font face="Arial" size="2">पात्र दम्पतियां (पहली अप्रैल को) : </font>
765
<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">
766
<font face="Arial" size="2">राज्य की जनसंख्या : </font>
768
<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">
769
<font face="Arial" size="2"> </font></td>
772
<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">
773
<font face="Arial" size="2">प्राप्त जिला कार्य योजनाओं : </font>
775
<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">
779
<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">
780
<font face="Arial" size="2">राज्य में जन्म-दर : </font>
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">
796
String tempForentryNumberValues[] = new String[12];
797
String tempForcumentryValuesForCurYear[] = new String[12];
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%">
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%">
822
<br><br><br><br><br><br><br><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%">
828
<br><br><br><br><br><br><br><br><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%">
834
<br><br><br><br><br><br><br><br><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%">
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%">
845
if(j==1) endcount = 21;
846
else if(j==2) endcount = 31;
847
else if(j==3) endcount = 25;
848
else if(j==4) endcount = 21;
849
else if(j==5) endcount = 14;
852
for(i=0;i<=endcount;i++)
854
String id1="cell1"+k;
855
String id2="cell2"+k;
857
if((k>=28 && k<=65) || (k>=80 && k<=101))
861
tempForentryNumberValues[0]= "<b>पुरुष</b>";
862
tempForentryNumberValues[1]= "<b>स्त्री</b>";
863
tempForentryNumberValues[2]= "<b>पुरुष</b>";
864
tempForentryNumberValues[3]= "<b>स्त्री</b>";
873
<font face="arial" size=3><b>सामाग्री तथा आपूर्ति</b></font>
874
<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%">
877
tempForentryNumberValues[0]= "<b>यूनिट</b>";
878
tempForentryNumberValues[1]= "<b>गत वर्ष प्रयुक्त मात्रा</b>";
879
tempForentryNumberValues[2]= "<b>पहली अप्रैल को विद्यमान स्टाक</b>";
880
tempForentryNumberValues[3]= "<b>चालू वर्ष के लिए अपेक्षित अतिरिक्त मात्रा</b>";
885
else if(k==1 || k==3 || k==5 || k==11 || k==13 || k==17 || k==22 || k==23 || k==26 || k==28 || k==29 || k==32 || k==33 || k==43 || k==46 || k==48 || k==50 || k==52 || k==54 || k==55 || k==59 || k==60 || k==63 || k==64 || k==66 || k==67 || k==70 || k==73 || k==81 || k==87 || k==94 || k==99 || k==107 )
887
tempForentryNumberValues[0]= " ";
888
tempForentryNumberValues[1]= " ";
889
tempForentryNumberValues[2]= " ";
890
tempForentryNumberValues[3]= " ";
897
temp = entryNumberValues[l];
898
if(temp==-1) tempForentryNumberValues[0] = "";
899
else tempForentryNumberValues[0] = ""+temp;
903
temp = entryNumberValues[l];
904
if(temp==-1) tempForentryNumberValues[1] = "";
905
else tempForentryNumberValues[1] = ""+temp;
909
temp = entryNumberValues[l];
910
if(temp==-1) tempForentryNumberValues[2] = "";
911
else tempForentryNumberValues[2] = ""+temp;
915
temp = entryNumberValues[l];
916
if(temp==-1) tempForentryNumberValues[3] = "";
917
else tempForentryNumberValues[3] = ""+temp;
925
<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>
926
<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>
927
<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>
928
<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>
929
<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>
930
<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>
939
tempForentryNumberValues[0]= "<font face='arial' size=3><b>गत वर्ष के दौरान निष्पादन</b></font>";
940
tempForentryNumberValues[1]= "<font face='arial' size=3><b>जिला योजना से संकलित चालू वर्ष के लिए योजनाबद्द आवश्यकता</b></font>";
948
<font face="arial" size=3><b>उपस्कर तथा सुविधाएं</b></font>
949
<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%">
951
tempForentryNumberValues[0]= "<b>उपलब्ध<br>(सं.)</b>";
952
tempForentryNumberValues[1]= "<b>चालू हालत में<br>(सं)</b>";
960
<font face="arial" size=3><b>स्टाफ की स्थिति</b></font>
961
<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%">
963
tempForentryNumberValues[0]= "<b>संस्वीकृत<br>(सं.)</b>";
964
tempForentryNumberValues[1]= "<b>रिक्त<br>(सं.)</b>";
968
else if(k==1 || k==3 || k==5 || k==11 || k==13 || k==17 || k==22 || k==23 || k==26 || k==28 || k==29 || k==32 || k==33 || k==43 || k==46 || k==48 || k==50 || k==52 || k==54 || k==55 || k==59 || k==60 || k==63 || k==64 || k==66 || k==67 || k==70 || k==73 || k==81 || k==87 || k==94 || k==99 || k==107 )
970
tempForentryNumberValues[0]= " ";
971
tempForentryNumberValues[1]= " ";
977
temp = entryNumberValues[l];
978
if(temp==-1) tempForentryNumberValues[0] = "";
979
else tempForentryNumberValues[0] = ""+temp;
983
temp = entryNumberValues[l];
984
if(temp==-1) tempForentryNumberValues[1] = "";
985
else tempForentryNumberValues[1] = ""+temp;
991
<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>
992
<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>
993
<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>
994
<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>
b'\\ No newline at end of file'