2
<%@ page import="java.sql.*" %>
3
<%@ page import="com.opensymphony.xwork.util.OgnlValueStack" %>
7
// for Performance in the Reporting Month
11
// for selected OrgUnit Name and Population
15
// for Performance in Corresponding month Last Year
19
// for Cumulative Performance till Current Month
23
// for Cumulative Performance till corresponding month of Last Year
27
// for Taluk Name and Id
31
// for District Name and Id
35
// for State Name and Id
40
// for PHC Name and Id
44
// for CHC Name and Id
48
// for PHC Population Estimates
52
// for Data Period Start Date and End Date
56
// for DataElement ids based on DataElement code
61
String userName = "dhis";
63
String urlForConnection = "jdbc:mysql://localhost/kl_dhis2";
66
String talukName = "";
68
String districtName = "";
74
int totPHCPopulation = -1;
75
int totSCPopulation = -1;
77
OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
78
String selectedId = (String) stack.findValue( "orgUnitId" );
79
int selectedOrgUnitID = Integer.parseInt( selectedId );
82
String startingDate = (String) stack.findValue( "startingPeriod" );
83
String endingDate = (String) stack.findValue( "endingPeriod" );
85
String monthlyPeriodId = (String) stack.findValue( "monthlyPeriodTypeId" );
86
int periodTypeID = Integer.parseInt( monthlyPeriodId );
90
String selectedOrgUnitName = "";
91
String selectedDataPeriodStartDate = "";
92
String selectedDataPeriodEndDate = "";
93
String lastDataPeriodStartDate = "";
95
String dataElementCodes[] = {
97
// Element Group 1 + 2
98
"' '", "'Form6_DE1'", "'Form6_DE2'", "' '","' '","' '","'Form6_DE3'", "'Form6_DE4'", "'Form6_DE5'", "'Form6_DE6'", "'Form6_DE7'",
99
"'Form6_DE8'","'Form6_DE9'", "'Form6_DE10'", "'Form6_DE11'", "'Form6_DE12'", "'Form6_DE13'", "'Form6_DE14'", "'Form6_DE15'",
100
"'Form6_DE16'", "'Form6_DE17'", "'Form6_DE1501'", "'Form6_DE25'", "'Form6_DE1502'","'Form6_DE21'", "'Form6_DE22'", "'Form6_DE23'",
101
"'Form6_DE24'", "'Form6_DE19'", "'Form6_DE26'", "'Form6_DE27'", "'Form6_DE28'", "'Form6_DE29'", "'Form6_DE30'", "'Form6_DE31'",
102
"'Form6_DE32'", "'Form6_DE33'", "'Form6_DE34'", "'Form6_DE35'", "'Form6_DE36'", "'Form6_DE37'", "'Form6_DE38'",
105
"'Form6_DE39','Form6_DE42','Form6_DE45'",
106
"'Form6_DE40','Form6_DE43','Form6_DE46'",
107
"'Form6_DE41','Form6_DE44','Form6_DE47'",
109
"'Form6_DE39'", "'Form6_DE40'", "'Form6_DE41'", "'Form6_DE42'", "'Form6_DE43'", "'Form6_DE44'", "'Form6_DE45'", "'Form6_DE46'",
110
"'Form6_DE47'", "'Form6_DE48'", "'Form6_DE49'", "'Form6_DE50'", "'Form6_DE51'", "'Form6_DE52'", "'Form6_DE53'", "'Form6_DE54'",
111
"'Form6_DE55'","'Form6_DE56'",
116
" 'Form6_DE60','Form6_DE63','Form6_DE66','Form6_DE69','Form6_DE75','Form7_DE4','Form7_DE7','Form6_DE78','Form6_DE81'",
117
" 'Form6_DE61','Form6_DE64','Form6_DE67','Form6_DE70','Form6_DE76','Form7_DE5','Form7_DE8','Form6_DE79','Form6_DE82'",
118
" 'Form6_DE62','Form6_DE65','Form6_DE68','Form6_DE71','Form6_DE77','Form7_DE6','Form7_DE9','Form6_DE80','Form6_DE83'",
121
" 'Form6_DE60','Form6_DE63','Form6_DE66','Form6_DE69' ",
122
" 'Form6_DE61','Form6_DE64','Form6_DE67','Form6_DE70' ",
123
" 'Form6_DE62','Form6_DE65','Form6_DE68','Form6_DE71' ",
125
"'Form6_DE60'", "'Form6_DE61'", "'Form6_DE62'", "'Form6_DE63'", "'Form6_DE64'", "'Form6_DE65'", "'Form6_DE66'", "'Form6_DE67'",
126
"'Form6_DE68'", "'Form6_DE69'", "'Form6_DE70'", "'Form6_DE71'",
129
" 'Form6_DE75','Form7_DE4','Form7_DE7' ",
130
" 'Form6_DE76','Form7_DE5','Form7_DE8' ",
131
" 'Form6_DE77','Form7_DE6','Form7_DE9' ",
133
"'Form6_DE75'", "'Form6_DE76'", "'Form6_DE77'", "'Form7_DE4'","'Form7_DE5'","'Form7_DE6'", "'Form7_DE7'","'Form7_DE8'","'Form7_DE9'",
136
" 'Form6_DE78','Form6_DE81' ",
137
" 'Form6_DE79','Form6_DE82' ",
138
" 'Form6_DE80','Form6_DE83' ",
140
"'Form6_DE78'", "'Form6_DE79'", "'Form6_DE80'", "'Form6_DE81'", "'Form6_DE82'", "'Form6_DE83'",
142
"' '","' '","' '","' '","' '","' '",
153
"'Form6_DE84'", "'Form6_DE85'", "'Form6_DE86'", "'Form6_DE87'", "'Form6_DE88'", "'Form6_DE89'", "'Form6_DE90'", "'Form6_DE91'",
154
"'Form6_DE92'", "'Form6_DE93'", "'Form6_DE94'", "'Form6_DE95'",
156
"' '","' '","' '","' '","' '","' '",
158
"'Form6_DE96'", "'Form6_DE97'", "'Form6_DE98'", "'Form6_DE99'", "'Form6_DE100'", "'Form6_DE101'", "'Form6_DE102'","'Form6_DE103'",
159
"'Form6_DE104'", "'Form6_DE105'", "'Form6_DE106'", "'Form6_DE107'", "'Form6_DE108'", "'Form6_DE109'", "'Form6_DE110'", "'Form6_DE111'",
160
"'Form6_DE112'", "'Form6_DE113'",
163
" 'Form6_DE117','Form6_DE123' ",
164
" 'Form6_DE118','Form6_DE124' ",
165
" 'Form6_DE119','Form6_DE125' ",
166
" 'Form6_DE120','Form6_DE126' ",
167
" 'Form6_DE121','Form6_DE127' ",
168
" 'Form6_DE122','Form6_DE128' ",
170
"'Form6_DE117'", "'Form6_DE118'", "'Form6_DE119'", "'Form6_DE120'", "'Form6_DE121'", "'Form6_DE122'", "'Form6_DE123'", "'Form6_DE124'",
171
"'Form6_DE125'", "'Form6_DE126'", "'Form6_DE127'", "'Form6_DE128'",
174
" 'Form7_DE10','Form7_DE13' ",
175
" 'Form7_DE11','Form7_DE14' ",
176
" 'Form7_DE12','Form7_DE15' ",
178
"'Form7_DE10'", "'Form7_DE11'","'Form7_DE12'","'Form7_DE13'","'Form7_DE14'","'Form7_DE15'",
183
" 'Form6_DE135','Form6_DE138','Form6_DE141','Form6_DE144','Form6_DE147' ",
184
" 'Form6_DE136','Form6_DE139','Form6_DE142','Form6_DE145','Form6_DE148' ",
185
" 'Form6_DE137','Form6_DE140','Form6_DE143','Form6_DE146','Form6_DE149' ",
187
"'Form6_DE135'", "'Form6_DE136'", "'Form6_DE137'", "'Form6_DE138'", "'Form6_DE139'", "'Form6_DE140'", "'Form6_DE141'", "'Form6_DE142'",
188
"'Form6_DE143'", "'Form6_DE144'", "'Form6_DE145'", "'Form6_DE146'", "'Form6_DE147'", "'Form6_DE148'", "'Form6_DE149'", "'Form6_DE150'",
189
"'Form6_DE151'", "'Form6_DE152'", "'Form6_DE153'", "'Form6_DE154'", "'Form6_DE155'", "'Form6_DE156'", "'Form6_DE157'", "'Form6_DE158'",
190
"'Form6_DE159'", "'Form6_DE160'", "'Form6_DE161'",
195
" 'Form7_DE16','Form7_DE19' ",
196
" 'Form7_DE17','Form7_DE20' ",
197
" 'Form7_DE18','Form7_DE21' ",
199
"'Form7_DE16'", "'Form7_DE17'", "'Form7_DE18'", "'Form7_DE19'", "'Form7_DE20'", "'Form7_DE21'", "'Form7_DE22'", "'Form7_DE23'", "'Form7_DE24'",
202
" 'Form6_DE1500','Form6_DE171' ",
203
" 'Form6_DE180','Form6_DE172' ",
204
" 'Form6_DE1536','Form6_DE173' ",
206
"'Form6_DE1500'", "'Form6_DE180'", "'Form6_DE1536'", "'Form6_DE171'", "'Form6_DE172'", "'Form6_DE173'",
211
" 'Form6_DE1537','Form6_DE1540' ",
212
" 'Form6_DE1538','Form6_DE1541' ",
213
" 'Form6_DE1539','Form6_DE1542' ",
215
"'Form6_DE1537'", "'Form6_DE1538'", "'Form6_DE1539'", "'Form6_DE1540'", "'Form6_DE1541'", "'Form6_DE1542'",
218
" 'Form6_DE192','Form6_DE195','Form6_DE198' ",
219
" 'Form6_DE193','Form6_DE196','Form6_DE199' ",
220
" 'Form6_DE194','Form6_DE197','Form6_DE200' ",
222
"'Form6_DE192'", "'Form6_DE193'", "'Form6_DE194'", "'Form6_DE195'", "'Form6_DE196'", "'Form6_DE197'", "'Form6_DE198'", "'Form6_DE199'",
223
"'Form6_DE200'", "'Form7_DE25'", "'Form7_DE26'",
230
" 'Form6_DE207','Form6_DE210','Form6_DE213','Form6_DE216' ",
231
" 'Form6_DE208','Form6_DE211','Form6_DE214','Form6_DE217' ",
232
" 'Form6_DE209','Form6_DE212','Form6_DE215','Form6_DE218' ",
234
"'Form6_DE207'", "'Form6_DE208'", "'Form6_DE209'", "'Form6_DE210'", "'Form6_DE211'", "'Form6_DE212'", "'Form6_DE213'", "'Form6_DE214'",
235
"'Form6_DE215'", "'Form6_DE216'", "'Form6_DE217'", "'Form6_DE218'",
238
" 'Form6_DE222','Form6_DE225','Form6_DE228' ",
239
" 'Form6_DE223','Form6_DE226','Form6_DE229' ",
240
" 'Form6_DE224','Form6_DE227','Form6_DE230' ",
242
"'Form6_DE222'", "'Form6_DE223'", "'Form6_DE224'", "'Form6_DE225'", "'Form6_DE226'", "'Form6_DE227'", "'Form6_DE228'", "'Form6_DE229'",
246
" 'Form6_DE234','Form6_DE237' ",
247
" 'Form6_DE235','Form6_DE238' ",
248
" 'Form6_DE236','Form6_DE239' ",
250
"'Form6_DE234'", "'Form6_DE235'", "'Form6_DE236'", "'Form6_DE237'", "'Form6_DE238'", "'Form6_DE239'",
253
" 'Form7_DE27','Form7_DE30','Form7_DE33' ",
254
" 'Form7_DE28','Form7_DE31','Form7_DE34' ",
255
" 'Form7_DE29','Form7_DE32','Form7_DE35' ",
257
"'Form7_DE27'", "'Form7_DE28'", "'Form7_DE29'", "'Form7_DE30'", "'Form7_DE31'", "'Form7_DE32'", "'Form7_DE33'","'Form7_DE34'", "'Form7_DE35'",
260
" 'Form6_DE246','Form6_DE249','Form6_DE252' ",
261
" 'Form6_DE247','Form6_DE250','Form6_DE253' ",
262
" 'Form6_DE248','Form6_DE251','Form6_DE254' ",
264
"'Form6_DE246'", "'Form6_DE247'", "'Form6_DE248'", "'Form6_DE249'", "'Form6_DE250'", "'Form6_DE251'", "'Form6_DE252'", "'Form6_DE253'",
269
"'Form6_DE258'","'Form6_DE259'", "'Form6_DE260'", "'Form7_DE36'", "'Form7_DE37'", "'Form7_DE38'",
272
" 'Form7_DE42','Form7_DE45' ",
273
" 'Form7_DE43','Form7_DE46' ",
274
" 'Form7_DE44','Form7_DE47' ",
276
"'Form7_DE42'", "'Form7_DE43'", "'Form7_DE44'", "'Form7_DE45'", "'Form7_DE46'", "'Form7_DE47'", "'Form7_DE48'", "'Form7_DE49'", "'Form7_DE50'",
278
"' '","' '","' '","' '","' '","' '",
280
"'Form6_DE261'", "'Form6_DE262'", "'Form6_DE263'", "'Form6_DE264'", "'Form6_DE265'", "'Form6_DE266'", "'Form6_DE267'", "'Form6_DE268'",
281
"'Form6_DE269'", "'Form6_DE270'", "'Form6_DE271'", "'Form6_DE272'", "'Form6_DE273'", "'Form6_DE274'", "'Form6_DE275'", "'Form6_DE276'",
282
"'Form6_DE277'", "'Form6_DE278'", "'Form7_DE51'", "'Form7_DE52'", "'Form7_DE53'", "'Form7_DE54'", "'Form7_DE55'", "'Form7_DE56'",
286
"'Form6_DE279'", "'Form6_DE280'", "'Form6_DE281'", "'Form6_DE282'", "'Form6_DE283'", "'Form6_DE284'", "'Form6_DE285'", "'Form6_DE286'",
287
"'Form6_DE287'", "'Form6_DE288'", "'Form6_DE289'", "'Form6_DE290'", "'Form6_DE291'", "'Form6_DE292'", "'Form6_DE293'", "'Form6_DE294'",
292
"'Form6_DE296'", "'Form6_DE297'", "'Form6_DE298'",
295
" 'Form6_DE302','Form6_DE305','Form6_DE308' ",
296
" 'Form6_DE303','Form6_DE306','Form6_DE309' ",
297
" 'Form6_DE304','Form6_DE307','Form6_DE310' ",
299
"'Form6_DE302'", "'Form6_DE303'", "'Form6_DE304'", "'Form6_DE305'", "'Form6_DE306'", "'Form6_DE307'", "'Form6_DE308'", "'Form6_DE309'",
304
"'Form6_DE311'", "'Form6_DE312'",
308
"'Form6_DE313'", "'Form6_DE314'", "'Form6_DE315'",
311
" 'Form6_DE317','Form6_DE318' ",
313
"'Form6_DE317'", "'Form6_DE318'",
315
"' '", "' '", "' '", "' '", "' '", "' '",
317
"'Form6_DE319'", "'Form6_DE320'", "'Form6_DE321'", "'Form6_DE322'", "'Form6_DE323'", "'Form6_DE324'", "'Form6_DE325'", "'Form6_DE326'",
318
"'Form6_DE327'", "'Form6_DE328'", "'Form6_DE329'", "'Form6_DE330'",
321
" 'Form6_DE337','Form6_DE343','Form6_DE349' ",
322
" 'Form6_DE338','Form6_DE344','Form6_DE350' ",
323
" 'Form6_DE339','Form6_DE345','Form6_DE351' ",
324
" 'Form6_DE340','Form6_DE346','Form6_DE352' ",
325
" 'Form6_DE341','Form6_DE347','Form6_DE353' ",
326
" 'Form6_DE342','Form6_DE348','Form6_DE354' ",
328
"'Form6_DE337'", "'Form6_DE338'", "'Form6_DE339'", "'Form6_DE340'", "'Form6_DE341'", "'Form6_DE342'", "'Form6_DE343'", "'Form6_DE344'",
330
"'Form6_DE346'", "'Form6_DE347'", "'Form6_DE348'", "'Form6_DE349'", "'Form6_DE350'", "'Form6_DE351'", "'Form6_DE352'", "'Form6_DE353'",
334
" 'Form6_DE361','Form6_DE367','Form6_DE373','Form6_DE379' ",
335
" 'Form6_DE362','Form6_DE368','Form6_DE374','Form6_DE380' ",
336
" 'Form6_DE363','Form6_DE369','Form6_DE375','Form6_DE381' ",
337
" 'Form6_DE364','Form6_DE370','Form6_DE376','Form6_DE382' ",
338
" 'Form6_DE365','Form6_DE371','Form6_DE377','Form6_DE383' ",
339
" 'Form6_DE366','Form6_DE372','Form6_DE378','Form6_DE384' ",
341
"'Form6_DE361'", "'Form6_DE362'", "'Form6_DE363'",
342
"'Form6_DE364'", "'Form6_DE365'", "'Form6_DE366'", "'Form6_DE367'", "'Form6_DE368'", "'Form6_DE369'", "'Form6_DE370'", "'Form6_DE371'",
344
"'Form6_DE373'", "'Form6_DE374'", "'Form6_DE375'", "'Form6_DE376'", "'Form6_DE377'", "'Form6_DE378'", "'Form6_DE379'", "'Form6_DE380'",
346
"'Form6_DE382'", "'Form6_DE383'", "'Form6_DE384'",
349
" 'Form6_DE391','Form6_DE397','Form6_DE403' ",
350
" 'Form6_DE392','Form6_DE398','Form6_DE404' ",
351
" 'Form6_DE393','Form6_DE399','Form6_DE405' ",
352
" 'Form6_DE394','Form6_DE400','Form6_DE406' ",
353
" 'Form6_DE395','Form6_DE401','Form6_DE407' ",
354
" 'Form6_DE396','Form6_DE402','Form6_DE408' ",
356
"'Form6_DE391'", "'Form6_DE392'", "'Form6_DE393'", "'Form6_DE394'", "'Form6_DE395'", "'Form6_DE396'", "'Form6_DE397'", "'Form6_DE398'",
358
"'Form6_DE400'", "'Form6_DE401'", "'Form6_DE402'", "'Form6_DE403'", "'Form6_DE404'", "'Form6_DE405'", "'Form6_DE406'", "'Form6_DE407'",
360
"'Form6_DE409'", "'Form6_DE410'", "'Form6_DE411'", "'Form6_DE412'", "'Form6_DE413'", "'Form6_DE414'", "'Form6_DE415'", "'Form6_DE416'",
362
"'Form6_DE448'", "'Form6_DE449'", "'Form6_DE450'",
366
" 'Form6_DE457','Form6_DE463' ",
367
" 'Form6_DE458','Form6_DE464' ",
368
" 'Form6_DE459','Form6_DE465' ",
369
" 'Form6_DE460','Form6_DE466' ",
370
" 'Form6_DE461','Form6_DE467' ",
371
" 'Form6_DE462','Form6_DE468' ",
374
"'Form6_DE458'", "'Form6_DE459'", "'Form6_DE460'", "'Form6_DE461'", "'Form6_DE462'", "'Form6_DE463'", "'Form6_DE464'", "'Form6_DE465'",
376
"'Form6_DE467'", "'Form6_DE468'",
378
"' '","' '","' '","' '","' '","' '",
381
"'Form6_DE476'", "'Form6_DE477'", "'Form6_DE478'", "'Form6_DE479'", "'Form6_DE480'", "'Form6_DE481'", "'Form6_DE482'", "'Form6_DE483'",
383
"'Form6_DE485'", "'Form6_DE486'", "'Form6_DE487'", "'Form6_DE488'", "'Form6_DE489'", "'Form6_DE490'", "'Form6_DE491'", "'Form6_DE492'",
385
"'Form6_DE494'", "'Form6_DE495'", "'Form6_DE496'", "'Form6_DE497'", "'Form6_DE498'",
388
" 'Form6_DE505','Form6_DE511' ",
389
" 'Form6_DE506','Form6_DE512' ",
390
" 'Form6_DE507','Form6_DE513' ",
391
" 'Form6_DE508','Form6_DE514' ",
392
" 'Form6_DE509','Form6_DE515' ",
393
" 'Form6_DE510','Form6_DE516' ",
395
"'Form6_DE505'", "'Form6_DE506'", "'Form6_DE507'", "'Form6_DE508'", "'Form6_DE509'", "'Form6_DE510'", "'Form6_DE511'",
396
"'Form6_DE512'", "'Form6_DE513'", "'Form6_DE514'", "'Form6_DE515'", "'Form6_DE516'", "'Form6_DE517'", "'Form6_DE518'", "'Form6_DE519'",
398
"'Form6_DE521'", "'Form6_DE522'", "'Form6_DE523'", "'Form6_DE524'", "'Form6_DE525'", "'Form6_DE526'", "'Form6_DE527'", "'Form6_DE528'",
400
"'Form6_DE530'", "'Form6_DE531'", "'Form6_DE532'", "'Form6_DE533'", "'Form6_DE534'", "'Form6_DE535'", "'Form6_DE536'", "'Form6_DE537'",
402
"'Form6_DE539'", "'Form6_DE540'",
405
"'Form6_DE541'", "'Form6_DE542'", "'Form6_DE543'", "'Form6_DE544'", "'Form6_DE545'", "'Form6_DE546'", "'Form6_DE547'", "'Form6_DE548'",
407
"'Form6_DE550'", "'Form6_DE551'", "'Form6_DE552'", "'Form6_DE553'", "'Form6_DE554'", "'Form6_DE555'", "'Form6_DE556'", "'Form6_DE557'",
409
"'Form6_DE559'", "'Form6_DE560'", "'Form6_DE561'", "'Form6_DE562'", "'Form6_DE563'", "'Form6_DE564'", "'Form6_DE565'", "'Form6_DE566'",
411
"'Form6_DE568'", "'Form6_DE569'", "'Form6_DE570'", "'Form6_DE571'", "'Form6_DE572'", "'Form6_DE573'", "'Form6_DE574'", "'Form6_DE575'",
413
"'Form6_DE577'", "'Form6_DE578'", "'Form6_DE579'", "'Form6_DE580'", "'Form6_DE581'", "'Form6_DE582'", "'Form6_DE583'", "'Form6_DE584'",
415
"'Form6_DE586'", "'Form6_DE587'", "'Form6_DE588'", "'Form6_DE589'", "'Form6_DE590'", "'Form6_DE591'", "'Form6_DE592'", "'Form6_DE593'",
417
"'Form6_DE595'", "'Form6_DE596'", "'Form6_DE597'", "'Form6_DE598'", "'Form6_DE599'", "'Form6_DE600'", "'Form6_DE601'", "'Form6_DE602'",
419
"'Form6_DE604'", "'Form6_DE605'", "'Form6_DE606'", "'Form6_DE607'", "'Form6_DE608'", "'Form6_DE609'", "'Form6_DE610'", "'Form6_DE611'",
421
"'Form6_DE613'", "'Form6_DE614'", "'Form6_DE615'", "'Form6_DE616'", "'Form6_DE617'", "'Form6_DE618'", "'Form6_DE619'", "'Form6_DE620'",
424
"' '","' '","' '","' '",
426
"'Form7_DE57'", "'Form7_DE58'",
430
"'Form7_DE59'", "'Form7_DE60'",
434
"'Form7_DE61'", "'Form7_DE62'",
438
"'Form7_DE63'", "'Form7_DE64'",
442
"'Form7_DE65'", "'Form7_DE66'",
446
"'Form7_DE67'", "'Form7_DE68'",
450
"' '","' '","' '","' '","' '","' '","' '","' '","' '",
453
"'Form6_DE622'", "'Form6_DE623'", "'Form6_DE624'", "'Form6_DE625'", "'Form6_DE626'", "'Form6_DE627'",
454
"'Form6_DE628'", "'Form6_DE629'", "'Form6_DE630'", "'Form6_DE631'", "'Form6_DE632'", "'Form6_DE633'", "'Form6_DE634'", "'Form6_DE635'",
456
"'Form6_DE637'", "'Form6_DE638'", "'Form6_DE639'", "'Form6_DE640'", "'Form6_DE641'", "'Form6_DE642'", "'Form6_DE643'", "'Form6_DE644'",
458
"'Form6_DE646'", "'Form6_DE647'", "'Form6_DE648'", "'Form6_DE649'", "'Form6_DE650'",
461
"' '","' '","' '","' '",
463
"'Form7_DE69'", "'Form7_DE70'",
467
"'Form7_DE71'", "'Form7_DE72'",
471
"'Form7_DE73'", "'Form7_DE74'",
477
"'Form6_DE651'", "'Form6_DE652'", "'Form6_DE653'",
480
" 'Form7_DE75','Form6_DE726' ",
481
" 'Form7_DE76','Form6_DE727' ",
482
" 'Form7_DE77','Form6_DE728' ",
484
"'Form7_DE75'", "'Form7_DE76'", "'Form7_DE77'",
485
"'Form6_DE726'", "'Form6_DE727'", "'Form6_DE728'",
488
" 'Form6_DE729','Form6_DE732','Form6_DE735' ",
489
" 'Form6_DE730','Form6_DE733','Form6_DE736' ",
490
" 'Form6_DE731','Form6_DE734','Form6_DE737' ",
492
"'Form6_DE729'", "'Form6_DE730'", "'Form6_DE731'",
493
"'Form6_DE732'", "'Form6_DE733'", "'Form6_DE734'", "'Form6_DE735'", "'Form6_DE736'", "'Form6_DE737'",
494
"'Form6_DE666'", "'Form6_DE667'",
495
"'Form6_DE1529'", "'Form6_DE669'", "'Form6_DE670'", "'Form6_DE671'", "'Form6_DE672'", "'Form6_DE673'", "'Form6_DE674'", "'Form6_DE675'",
497
"'Form6_DE677'", "'Form6_DE678'", "'Form6_DE679'", "'Form6_DE680'", "'Form6_DE681'", "'Form6_DE682'", "'Form6_DE683'", "'Form6_DE684'",
499
"'Form6_DE686'", "'Form6_DE687'", "'Form6_DE688'", "'Form6_DE689'", "'Form6_DE690'", "'Form6_DE691'", "'Form6_DE692'", "'Form6_DE693'",
501
"'Form6_DE695'", "'Form6_DE696'", "'Form6_DE697'", "'Form6_DE698'", "'Form6_DE699'", "'Form6_DE700'", "'Form6_DE701'", "'Form6_DE702'",
503
"'Form6_DE704'", "'Form6_DE705'", "'Form6_DE706'", "'Form6_DE707'", "'Form6_DE708'", "'Form6_DE709'", "'Form6_DE710'", "'Form6_DE711'",
505
"'Form6_DE713'", "'Form6_DE714'", "'Form6_DE715'", "'Form6_DE716'", "'Form6_DE717'", "'Form6_DE718'", "'Form6_DE719'",
510
" 'Form6_DE723','Form6_DE726' ",
511
" 'Form6_DE724','Form6_DE727' ",
512
" 'Form6_DE725','Form6_DE728' ",
514
"'Form6_DE723'", "'Form6_DE724'", "'Form6_DE725'", "'Form6_DE726'", "'Form6_DE727'",
518
" 'Form6_DE729','Form6_DE732','Form6_DE735' ",
519
" 'Form6_DE730','Form6_DE733','Form6_DE736' ",
520
" 'Form6_DE731','Form6_DE734','Form6_DE737' ",
522
"'Form6_DE729'", "'Form6_DE730'", "'Form6_DE731'", "'Form6_DE732'", "'Form6_DE733'", "'Form6_DE734'", "'Form6_DE735'",
523
"'Form6_DE736'", "'Form6_DE737'",
525
"' '", "' '", "' '", "' '","' '","' '","' '","' '","' '",
527
"'Form6_DE741'", "'Form6_DE742'",
528
"'Form6_DE743'", "'Form6_DE744'", "'Form6_DE745'", "'Form6_DE746'", "'Form6_DE747'", "'Form6_DE748'", "'Form6_DE749'",
536
int dataElementIDs[] = new int[dataElementCodes.length+5];
537
int entryNumberValues[]= new int[dataElementCodes.length+5];
538
int entryValuesForLastYear[]= new int[dataElementCodes.length+5];
539
int cumentryValuesForCurYear[]= new int[dataElementCodes.length+5];
540
int cumentryValuesForLastYear[]= new int[dataElementCodes.length+5];
542
String monthNames[] = { "", "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" };
549
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
550
con = DriverManager.getConnection (urlForConnection, userName, password);
552
st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
553
st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
554
st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
555
st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
556
st4=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
557
st5=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
558
st6=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
559
st7=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
560
st8=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
561
st9=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
562
st10=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
563
st11=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
564
st12=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
567
//rs1 = st1.executeQuery("SELECT organisationunit.shortname FROM organisationunit WHERE id ="+selectedOrgUnitID);
568
rs1 = st1.executeQuery("SELECT organisationunit.shortname FROM organisationunit WHERE organisationunitid ="+selectedOrgUnitID);
569
if(rs1.next()) { selectedOrgUnitName = rs1.getString(1); }
570
else { selectedOrgUnitName = ""; }
572
//rs11 = st11.executeQuery("select startDate,endDate from period where id = "+selectedDataPeriodID);
575
// selectedDataPeriodStartDate = rs11.getDate(1).toString();
576
// selectedDataPeriodEndDate = rs11.getDate(2).toString();
579
selectedDataPeriodStartDate = startingDate;
582
catch(Exception e) { out.println(e.getMessage()); }
587
if(rs1!=null) rs1.close(); if(st1!=null) st1.close();
588
if(rs11!=null) rs11.close(); if(st11!=null) st11.close();
590
catch(Exception e) { out.println(e.getMessage()); }
591
} // finally block end
593
String partsOfDataPeriodStartDate[] = selectedDataPeriodStartDate.split("-");
594
String partsOfDataPeriodEndDate[] = endingDate.split("-");
596
lastYear = Integer.parseInt(partsOfDataPeriodStartDate[0]) - 1;
597
lastDataPeriodStartDate = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
599
int tempForMonth1 = Integer.parseInt(partsOfDataPeriodStartDate[1]);
602
if(tempForMonth1 < 4) { tempForYear = lastYear; }
603
else { tempForYear = lastYear + 1; }
605
String curYearStart = tempForYear+"-04-01";
606
String lastYearStart = (tempForYear-1)+"-04-01";
607
String lastYearEnd = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
609
//for district, taluk, CHC names
612
//rs8=st8.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")");
613
rs8=st8.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+selectedOrgUnitID+")");
614
if(rs8.next()) { PHCID = rs8.getInt(1);PHCName = rs8.getString(2); }
615
else { PHCID = 0; PHCName = ""; }
617
//rs9=st9.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+PHCID+")");
618
rs9=st9.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+PHCID+")");
619
if(rs9.next()) { CHCID = rs9.getInt(1);CHCName = rs9.getString(2); }
620
else { CHCID = 0; CHCName = ""; }
622
//rs5=st5.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+CHCID+")");
623
rs5=st5.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+CHCID+")");
624
if(rs5.next()) { talukID = rs5.getInt(1); talukName = rs5.getString(2); }
625
else { talukID = 0; talukName = ""; }
627
//rs6=st6.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+talukID+")");
628
rs6=st6.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.organisationunitid from organisationunit where organisationunit.organisationunitid = "+talukID+")");
629
if(rs6.next()) { districtID = rs6.getInt(1); districtName = rs6.getString(2);}
630
else {districtID = 0; districtName = "";}
632
//rs7=st7.executeQuery("select organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+districtID+")");
633
rs7=st7.executeQuery("select organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+districtID+")");
634
if(rs7.next()) { stateName = rs7.getString(1);}
635
else { stateName = "";}
637
//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'");
638
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'");
639
if(rs10.next()) { totPHCPopulation = rs10.getInt(1);}
640
else {totPHCPopulation = 0;}
643
catch(Exception e) { out.println(e.getMessage()); }
648
if(rs5!=null) rs5.close(); if(st5!=null) st5.close();
649
if(rs6!=null) rs6.close(); if(st6!=null) st6.close();
650
if(rs7!=null) rs7.close(); if(st7!=null) st7.close();
651
if(rs8!=null) rs8.close(); if(st8!=null) st8.close();
652
if(rs9!=null) rs9.close(); if(st9!=null) st9.close();
653
if(rs10!=null) rs10.close(); if(st10!=null) st10.close();
655
catch(Exception e) { out.println(e.getMessage()); }
656
} // finally block end
661
int j= dataElementCodes.length;
667
entryNumberValues[i] = -1;
668
entryValuesForLastYear[i] = -1;
669
cumentryValuesForCurYear[i] = -1;
670
cumentryValuesForLastYear[i] = -1;
672
// for Performance in the reporting month
673
//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]+")";
674
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]+")";
675
rs=st.executeQuery(query);
676
if(rs.next()) { entryNumberValues[i] = rs.getInt(1); }
677
else { entryNumberValues[i] = 0; }
679
// for Cumulative Performance till Current Month
680
//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]+")";
681
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]+")";
682
rs4=st4.executeQuery(query);
683
if(rs4.next()) { cumentryValuesForCurYear[i]= rs4.getInt(1); }
684
else { cumentryValuesForCurYear[i] = 0; }
689
catch(Exception e) { out.println(e.getMessage()); }
694
if(rs!=null) rs.close(); if(st!=null) st.close();
695
if(rs2!=null) rs2.close(); if(st2!=null) st2.close();
696
if(rs3!=null) rs3.close(); if(st3!=null) st3.close();
697
if(rs4!=null) rs4.close(); if(st4!=null) st4.close();
698
if(rs12!=null) rs12.close(); if(st12!=null) st12.close();
700
if(con!=null) con.close();
702
catch(Exception e) { out.println(e.getMessage()); }
703
} // finally block end
708
<TITLE>Form - 3</TITLE>
709
<script src="../dhis-web-reports/Kerala/KDENamesForForm3.js" type="text/javascript" language="Javascript"></script>
724
else if(j==2) end = 33;
725
else if(j==3) end = 25;
726
else if(j==4) end = 21;
727
else if(j==5) end = 14;
729
for(start=0;start<=end;start++)
732
document.getElementById(id).innerHTML = slnoForForm3[k];
734
document.getElementById(id).innerHTML = denamesForForm3[k];
743
<BODY BGCOLOR="#FFFFFF" onload="fun1()">
744
<font face="Arial" size="2">(To be submitted by 20th March to the District
745
Family Welfare Officer for data-entry in NIC-District Computer)</font>
747
<font face="Arial" size="3">
748
<b>FORM 3<br>FRU ACTION PLAN</b></font>
751
<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">
752
<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%">
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="23">
754
<font face="Arial" size="2">A. General Information : </font>
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="23">
757
<font face="Arial" size="2"></font>
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">State : <%=stateName%></font>
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">Year : <%=partsOfDataPeriodStartDate[0]%> - <%=partsOfDataPeriodEndDate[0]%></font>
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">District : <%=districtName%></font>
772
<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">
773
<font face="Arial" size="2">Eligible couples (As on 1st
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">FRU . : </font>
781
<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">
782
<font face="Arial" size="2"> </font></td>
785
<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">
786
<font face="Arial" size="2">No.of PHC under the FRU : </font>
788
<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">
792
<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">
793
<font face="Arial" size="2">Population under the FRU : </font>
795
<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">
800
<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">
801
<font face="Arial" size="2">Birth Rate of District / State : </font>
803
<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">
817
String tempForentryNumberValues[] = new String[12];
818
String tempForcumentryValuesForCurYear[] = new String[12];
832
<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%">
838
<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%">
844
<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%">
850
<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%">
856
<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%">
862
<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%">
866
if(j==1) endcount = 21;
867
else if(j==2) endcount = 33;
868
else if(j==3) endcount = 25;
869
else if(j==4) endcount = 21;
870
else if(j==5) endcount = 14;
873
for(i=0;i<=endcount;i++)
875
String id1="cell1"+k;
876
String id2="cell2"+k;
878
if((k>=29 && k<=68) || (k>=82 && k<=103))
882
tempForentryNumberValues[0]= "<b>Male</b>";
883
tempForentryNumberValues[1]= "<b>Female</b>";
884
tempForentryNumberValues[2]= "<b>Male</b>";
885
tempForentryNumberValues[3]= "<b>Female</b>";
894
<font face="arial" size=3><b>MATERIAL & SUPPLIES</b></font>
895
<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%">
898
tempForentryNumberValues[0]= "<font face='arial' size=3><b>Unit</font></b>";
899
tempForentryNumberValues[1]= "<font face='arial' size=3><b>Qty.used in<br>previous year</font></b>";
900
tempForentryNumberValues[2]= "<font face='arial' size=3><b>Stock position<br>on 1st April</font></b>";
901
tempForentryNumberValues[3]= "<font face='arial' size=3><b>Additional Quantity<br>required in<br>current year</font></b>";
906
else if(k==30 || k==34 || k==35 || k==45 || k==48 || k==50 || k==52 || k==54 || k==57 || k==61 || k==62 || k==65 || k==66 || k==83 || k==89 || k==96 || k==101)
908
tempForentryNumberValues[0]= " ";
909
tempForentryNumberValues[1]= " ";
910
tempForentryNumberValues[2]= " ";
911
tempForentryNumberValues[3]= " ";
918
temp = entryNumberValues[l];
919
if(temp==-1) tempForentryNumberValues[0] = "";
920
else tempForentryNumberValues[0] = ""+temp;
924
temp = entryNumberValues[l];
925
if(temp==-1) tempForentryNumberValues[1] = "";
926
else tempForentryNumberValues[1] = ""+temp;
930
temp = entryNumberValues[l];
931
if(temp==-1) tempForentryNumberValues[2] = "";
932
else tempForentryNumberValues[2] = ""+temp;
936
temp = entryNumberValues[l];
937
if(temp==-1) tempForentryNumberValues[3] = "";
938
else tempForentryNumberValues[3] = ""+temp;
946
<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>
947
<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>
948
<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>
949
<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>
950
<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>
951
<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>
960
tempForentryNumberValues[0]= "<font face='arial' size=3><b>Performance in<br>last year<br>from PHC plans</b></font>";
961
tempForentryNumberValues[1]= "<font face='arial' size=3><b>Planned performance<br>in next year as compiled</b></font>";
968
tempForentryNumberValues[0]= "<font face='arial' size=3><b>Available (No.)</b></font>";
969
tempForentryNumberValues[1]= "<font face='arial' size=3><b>Functioning (No.)</b></font>";
973
else if(k==1 || k==4 || k==10 || k==12 || k==16 || k==22 || k==25 || k==26 || k==69 || k==70 || k==73 || k==76 || k==109)
975
tempForentryNumberValues[0]= " ";
976
tempForentryNumberValues[1]= " ";
985
<font face="arial" size=3><b>Equipment and Facilities</b></font>
986
<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%">
988
tempForentryNumberValues[0]= "<b>Available (No.)</b>";
989
tempForentryNumberValues[1]= "<b>Functioning (No.)</b>";
997
<font face="arial" size=3><b>Staff Position</b></font>
998
<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%">
1000
tempForentryNumberValues[0]= "<b>Sanctioned (No.)</b>";
1001
tempForentryNumberValues[1]= "<b>Vacant (No.)</b>";
1007
temp = entryNumberValues[l];
1008
if(temp==-1) tempForentryNumberValues[0] = "";
1009
else tempForentryNumberValues[0] = ""+temp;
1013
temp = entryNumberValues[l];
1014
if(temp==-1) tempForentryNumberValues[1] = "";
1015
else tempForentryNumberValues[1] = ""+temp;
1021
<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>
1022
<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>
1023
<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>
1024
<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'