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/kl_dhis2";
62
String talukName = "";
64
String districtName = "";
69
String stateName = "";
70
int totPHCPopulation = -1;
71
int totSCPopulation = -1;
73
OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
74
String selectedId = (String) stack.findValue( "orgUnitId" );
75
int selectedOrgUnitID = Integer.parseInt( selectedId );
78
String startingDate = (String) stack.findValue( "startingPeriod" );
79
String endingDate = (String) stack.findValue( "endingPeriod" );
81
String monthlyPeriodId = (String) stack.findValue( "monthlyPeriodTypeId" );
82
int periodTypeID = Integer.parseInt( monthlyPeriodId );
86
String selectedOrgUnitName = "";
87
String selectedDataPeriodStartDate = "";
88
String selectedDataPeriodEndDate = "";
89
String lastDataPeriodStartDate = "";
91
String dataElementCodes[] = {
93
// Element Group 1 + 2
94
"' '", "'Form6_DE1'", "'Form6_DE2'", "' '","' '","' '","'Form6_DE3'", "'Form6_DE4'", "'Form6_DE5'", "'Form6_DE6'", "'Form6_DE7'",
95
"'Form6_DE8'","'Form6_DE9'", "'Form6_DE10'", "'Form6_DE11'", "'Form6_DE12'", "'Form6_DE13'", "'Form6_DE14'", "'Form6_DE15'",
96
"'Form6_DE16'", "'Form6_DE17'", "'Form6_DE1501'", "'Form6_DE25'", "'Form6_DE1502'","'Form6_DE21'", "'Form6_DE22'", "'Form6_DE23'",
97
"'Form6_DE24'", "'Form6_DE19'", "'Form6_DE26'", "'Form6_DE27'", "'Form6_DE28'", "'Form6_DE29'", "'Form6_DE30'", "'Form6_DE31'",
98
"'Form6_DE32'", "'Form6_DE33'", "'Form6_DE34'", "'Form6_DE35'", "'Form6_DE36'", "'Form6_DE37'", "'Form6_DE38'",
101
"'Form6_DE39','Form6_DE42','Form6_DE45'",
102
"'Form6_DE40','Form6_DE43','Form6_DE46'",
103
"'Form6_DE41','Form6_DE44','Form6_DE47'",
105
"'Form6_DE39'", "'Form6_DE40'", "'Form6_DE41'", "'Form6_DE42'", "'Form6_DE43'", "'Form6_DE44'", "'Form6_DE45'", "'Form6_DE46'",
106
"'Form6_DE47'", "'Form6_DE48'", "'Form6_DE49'", "'Form6_DE50'", "'Form6_DE51'", "'Form6_DE52'", "'Form6_DE53'", "'Form6_DE54'",
107
"'Form6_DE55'","'Form6_DE56'",
112
" 'Form6_DE60','Form6_DE63','Form6_DE66','Form6_DE69','Form6_DE75','Form7_DE4','Form7_DE7','Form6_DE78','Form6_DE81'",
113
" 'Form6_DE61','Form6_DE64','Form6_DE67','Form6_DE70','Form6_DE76','Form7_DE5','Form7_DE8','Form6_DE79','Form6_DE82'",
114
" 'Form6_DE62','Form6_DE65','Form6_DE68','Form6_DE71','Form6_DE77','Form7_DE6','Form7_DE9','Form6_DE80','Form6_DE83'",
117
" 'Form6_DE60','Form6_DE63','Form6_DE66','Form6_DE69' ",
118
" 'Form6_DE61','Form6_DE64','Form6_DE67','Form6_DE70' ",
119
" 'Form6_DE62','Form6_DE65','Form6_DE68','Form6_DE71' ",
121
"'Form6_DE60'", "'Form6_DE61'", "'Form6_DE62'", "'Form6_DE63'", "'Form6_DE64'", "'Form6_DE65'", "'Form6_DE66'", "'Form6_DE67'",
122
"'Form6_DE68'", "'Form6_DE69'", "'Form6_DE70'", "'Form6_DE71'",
125
" 'Form6_DE75','Form7_DE4','Form7_DE7' ",
126
" 'Form6_DE76','Form7_DE5','Form7_DE8' ",
127
" 'Form6_DE77','Form7_DE6','Form7_DE9' ",
129
"'Form6_DE75'", "'Form6_DE76'", "'Form6_DE77'", "'Form7_DE4'","'Form7_DE5'","'Form7_DE6'", "'Form7_DE7'","'Form7_DE8'","'Form7_DE9'",
132
" 'Form6_DE78','Form6_DE81' ",
133
" 'Form6_DE79','Form6_DE82' ",
134
" 'Form6_DE80','Form6_DE83' ",
136
"'Form6_DE78'", "'Form6_DE79'", "'Form6_DE80'", "'Form6_DE81'", "'Form6_DE82'", "'Form6_DE83'",
138
"' '","' '","' '","' '","' '","' '",
149
"'Form6_DE84'", "'Form6_DE85'", "'Form6_DE86'", "'Form6_DE87'", "'Form6_DE88'", "'Form6_DE89'", "'Form6_DE90'", "'Form6_DE91'",
150
"'Form6_DE92'", "'Form6_DE93'", "'Form6_DE94'", "'Form6_DE95'",
152
"' '","' '","' '","' '","' '","' '",
154
"'Form6_DE96'", "'Form6_DE97'", "'Form6_DE98'", "'Form6_DE99'", "'Form6_DE100'", "'Form6_DE101'", "'Form6_DE102'","'Form6_DE103'",
155
"'Form6_DE104'", "'Form6_DE105'", "'Form6_DE106'", "'Form6_DE107'", "'Form6_DE108'", "'Form6_DE109'", "'Form6_DE110'", "'Form6_DE111'",
156
"'Form6_DE112'", "'Form6_DE113'",
159
" 'Form6_DE117','Form6_DE123' ",
160
" 'Form6_DE118','Form6_DE124' ",
161
" 'Form6_DE119','Form6_DE125' ",
162
" 'Form6_DE120','Form6_DE126' ",
163
" 'Form6_DE121','Form6_DE127' ",
164
" 'Form6_DE122','Form6_DE128' ",
166
"'Form6_DE117'", "'Form6_DE118'", "'Form6_DE119'", "'Form6_DE120'", "'Form6_DE121'", "'Form6_DE122'", "'Form6_DE123'", "'Form6_DE124'",
167
"'Form6_DE125'", "'Form6_DE126'", "'Form6_DE127'", "'Form6_DE128'",
170
" 'Form7_DE10','Form7_DE13' ",
171
" 'Form7_DE11','Form7_DE14' ",
172
" 'Form7_DE12','Form7_DE15' ",
174
"'Form7_DE10'", "'Form7_DE11'","'Form7_DE12'","'Form7_DE13'","'Form7_DE14'","'Form7_DE15'",
179
" 'Form6_DE135','Form6_DE138','Form6_DE141','Form6_DE144','Form6_DE147' ",
180
" 'Form6_DE136','Form6_DE139','Form6_DE142','Form6_DE145','Form6_DE148' ",
181
" 'Form6_DE137','Form6_DE140','Form6_DE143','Form6_DE146','Form6_DE149' ",
183
"'Form6_DE135'", "'Form6_DE136'", "'Form6_DE137'", "'Form6_DE138'", "'Form6_DE139'", "'Form6_DE140'", "'Form6_DE141'", "'Form6_DE142'",
184
"'Form6_DE143'", "'Form6_DE144'", "'Form6_DE145'", "'Form6_DE146'", "'Form6_DE147'", "'Form6_DE148'", "'Form6_DE149'", "'Form6_DE150'",
185
"'Form6_DE151'", "'Form6_DE152'", "'Form6_DE153'", "'Form6_DE154'", "'Form6_DE155'", "'Form6_DE156'", "'Form6_DE157'", "'Form6_DE158'",
186
"'Form6_DE159'", "'Form6_DE160'", "'Form6_DE161'",
191
" 'Form7_DE16','Form7_DE19' ",
192
" 'Form7_DE17','Form7_DE20' ",
193
" 'Form7_DE18','Form7_DE21' ",
195
"'Form7_DE16'", "'Form7_DE17'", "'Form7_DE18'", "'Form7_DE19'", "'Form7_DE20'", "'Form7_DE21'", "'Form7_DE22'", "'Form7_DE23'", "'Form7_DE24'",
198
" 'Form6_DE1500','Form6_DE171' ",
199
" 'Form6_DE180','Form6_DE172' ",
200
" 'Form6_DE1536','Form6_DE173' ",
202
"'Form6_DE1500'", "'Form6_DE180'", "'Form6_DE1536'", "'Form6_DE171'", "'Form6_DE172'", "'Form6_DE173'",
207
" 'Form6_DE1537','Form6_DE1540' ",
208
" 'Form6_DE1538','Form6_DE1541' ",
209
" 'Form6_DE1539','Form6_DE1542' ",
211
"'Form6_DE1537'", "'Form6_DE1538'", "'Form6_DE1539'", "'Form6_DE1540'", "'Form6_DE1541'", "'Form6_DE1542'",
214
" 'Form6_DE192','Form6_DE195','Form6_DE198' ",
215
" 'Form6_DE193','Form6_DE196','Form6_DE199' ",
216
" 'Form6_DE194','Form6_DE197','Form6_DE200' ",
218
"'Form6_DE192'", "'Form6_DE193'", "'Form6_DE194'", "'Form6_DE195'", "'Form6_DE196'", "'Form6_DE197'", "'Form6_DE198'", "'Form6_DE199'",
219
"'Form6_DE200'", "'Form7_DE25'", "'Form7_DE26'",
226
" 'Form6_DE207','Form6_DE210','Form6_DE213','Form6_DE216' ",
227
" 'Form6_DE208','Form6_DE211','Form6_DE214','Form6_DE217' ",
228
" 'Form6_DE209','Form6_DE212','Form6_DE215','Form6_DE218' ",
230
"'Form6_DE207'", "'Form6_DE208'", "'Form6_DE209'", "'Form6_DE210'", "'Form6_DE211'", "'Form6_DE212'", "'Form6_DE213'", "'Form6_DE214'",
231
"'Form6_DE215'", "'Form6_DE216'", "'Form6_DE217'", "'Form6_DE218'",
234
" 'Form6_DE222','Form6_DE225','Form6_DE228' ",
235
" 'Form6_DE223','Form6_DE226','Form6_DE229' ",
236
" 'Form6_DE224','Form6_DE227','Form6_DE230' ",
238
"'Form6_DE222'", "'Form6_DE223'", "'Form6_DE224'", "'Form6_DE225'", "'Form6_DE226'", "'Form6_DE227'", "'Form6_DE228'", "'Form6_DE229'",
242
" 'Form6_DE234','Form6_DE237' ",
243
" 'Form6_DE235','Form6_DE238' ",
244
" 'Form6_DE236','Form6_DE239' ",
246
"'Form6_DE234'", "'Form6_DE235'", "'Form6_DE236'", "'Form6_DE237'", "'Form6_DE238'", "'Form6_DE239'",
249
" 'Form7_DE27','Form7_DE30','Form7_DE33' ",
250
" 'Form7_DE28','Form7_DE31','Form7_DE34' ",
251
" 'Form7_DE29','Form7_DE32','Form7_DE35' ",
253
"'Form7_DE27'", "'Form7_DE28'", "'Form7_DE29'", "'Form7_DE30'", "'Form7_DE31'", "'Form7_DE32'", "'Form7_DE33'","'Form7_DE34'", "'Form7_DE35'",
256
" 'Form6_DE246','Form6_DE249','Form6_DE252' ",
257
" 'Form6_DE247','Form6_DE250','Form6_DE253' ",
258
" 'Form6_DE248','Form6_DE251','Form6_DE254' ",
260
"'Form6_DE246'", "'Form6_DE247'", "'Form6_DE248'", "'Form6_DE249'", "'Form6_DE250'", "'Form6_DE251'", "'Form6_DE252'", "'Form6_DE253'",
265
"'Form6_DE258'","'Form6_DE259'", "'Form6_DE260'", "'Form7_DE36'", "'Form7_DE37'", "'Form7_DE38'",
268
" 'Form7_DE42','Form7_DE45' ",
269
" 'Form7_DE43','Form7_DE46' ",
270
" 'Form7_DE44','Form7_DE47' ",
272
"'Form7_DE42'", "'Form7_DE43'", "'Form7_DE44'", "'Form7_DE45'", "'Form7_DE46'", "'Form7_DE47'", "'Form7_DE48'", "'Form7_DE49'", "'Form7_DE50'",
274
"' '","' '","' '","' '","' '","' '",
276
"'Form6_DE261'", "'Form6_DE262'", "'Form6_DE263'", "'Form6_DE264'", "'Form6_DE265'", "'Form6_DE266'", "'Form6_DE267'", "'Form6_DE268'",
277
"'Form6_DE269'", "'Form6_DE270'", "'Form6_DE271'", "'Form6_DE272'", "'Form6_DE273'", "'Form6_DE274'", "'Form6_DE275'", "'Form6_DE276'",
278
"'Form6_DE277'", "'Form6_DE278'", "'Form7_DE51'", "'Form7_DE52'", "'Form7_DE53'", "'Form7_DE54'", "'Form7_DE55'", "'Form7_DE56'",
282
"'Form6_DE279'", "'Form6_DE280'", "'Form6_DE281'", "'Form6_DE282'", "'Form6_DE283'", "'Form6_DE284'", "'Form6_DE285'", "'Form6_DE286'",
283
"'Form6_DE287'", "'Form6_DE288'", "'Form6_DE289'", "'Form6_DE290'", "'Form6_DE291'", "'Form6_DE292'", "'Form6_DE293'", "'Form6_DE294'",
288
"'Form6_DE296'", "'Form6_DE297'", "'Form6_DE298'",
291
" 'Form6_DE302','Form6_DE305','Form6_DE308' ",
292
" 'Form6_DE303','Form6_DE306','Form6_DE309' ",
293
" 'Form6_DE304','Form6_DE307','Form6_DE310' ",
295
"'Form6_DE302'", "'Form6_DE303'", "'Form6_DE304'", "'Form6_DE305'", "'Form6_DE306'", "'Form6_DE307'", "'Form6_DE308'", "'Form6_DE309'",
300
"'Form6_DE311'", "'Form6_DE312'",
304
"'Form6_DE313'", "'Form6_DE314'", "'Form6_DE315'",
307
" 'Form6_DE317','Form6_DE318' ",
309
"'Form6_DE317'", "'Form6_DE318'",
311
"' '", "' '", "' '", "' '", "' '", "' '",
313
"'Form6_DE319'", "'Form6_DE320'", "'Form6_DE321'", "'Form6_DE322'", "'Form6_DE323'", "'Form6_DE324'", "'Form6_DE325'", "'Form6_DE326'",
314
"'Form6_DE327'", "'Form6_DE328'", "'Form6_DE329'", "'Form6_DE330'",
317
" 'Form6_DE337','Form6_DE343','Form6_DE349' ",
318
" 'Form6_DE338','Form6_DE344','Form6_DE350' ",
319
" 'Form6_DE339','Form6_DE345','Form6_DE351' ",
320
" 'Form6_DE340','Form6_DE346','Form6_DE352' ",
321
" 'Form6_DE341','Form6_DE347','Form6_DE353' ",
322
" 'Form6_DE342','Form6_DE348','Form6_DE354' ",
324
"'Form6_DE337'", "'Form6_DE338'", "'Form6_DE339'", "'Form6_DE340'", "'Form6_DE341'", "'Form6_DE342'", "'Form6_DE343'", "'Form6_DE344'",
326
"'Form6_DE346'", "'Form6_DE347'", "'Form6_DE348'", "'Form6_DE349'", "'Form6_DE350'", "'Form6_DE351'", "'Form6_DE352'", "'Form6_DE353'",
330
" 'Form6_DE361','Form6_DE367','Form6_DE373','Form6_DE379' ",
331
" 'Form6_DE362','Form6_DE368','Form6_DE374','Form6_DE380' ",
332
" 'Form6_DE363','Form6_DE369','Form6_DE375','Form6_DE381' ",
333
" 'Form6_DE364','Form6_DE370','Form6_DE376','Form6_DE382' ",
334
" 'Form6_DE365','Form6_DE371','Form6_DE377','Form6_DE383' ",
335
" 'Form6_DE366','Form6_DE372','Form6_DE378','Form6_DE384' ",
337
"'Form6_DE361'", "'Form6_DE362'", "'Form6_DE363'",
338
"'Form6_DE364'", "'Form6_DE365'", "'Form6_DE366'", "'Form6_DE367'", "'Form6_DE368'", "'Form6_DE369'", "'Form6_DE370'", "'Form6_DE371'",
340
"'Form6_DE373'", "'Form6_DE374'", "'Form6_DE375'", "'Form6_DE376'", "'Form6_DE377'", "'Form6_DE378'", "'Form6_DE379'", "'Form6_DE380'",
342
"'Form6_DE382'", "'Form6_DE383'", "'Form6_DE384'",
345
" 'Form6_DE391','Form6_DE397','Form6_DE403' ",
346
" 'Form6_DE392','Form6_DE398','Form6_DE404' ",
347
" 'Form6_DE393','Form6_DE399','Form6_DE405' ",
348
" 'Form6_DE394','Form6_DE400','Form6_DE406' ",
349
" 'Form6_DE395','Form6_DE401','Form6_DE407' ",
350
" 'Form6_DE396','Form6_DE402','Form6_DE408' ",
352
"'Form6_DE391'", "'Form6_DE392'", "'Form6_DE393'", "'Form6_DE394'", "'Form6_DE395'", "'Form6_DE396'", "'Form6_DE397'", "'Form6_DE398'",
354
"'Form6_DE400'", "'Form6_DE401'", "'Form6_DE402'", "'Form6_DE403'", "'Form6_DE404'", "'Form6_DE405'", "'Form6_DE406'", "'Form6_DE407'",
356
"'Form6_DE409'", "'Form6_DE410'", "'Form6_DE411'", "'Form6_DE412'", "'Form6_DE413'", "'Form6_DE414'", "'Form6_DE415'", "'Form6_DE416'",
358
"'Form6_DE448'", "'Form6_DE449'", "'Form6_DE450'",
362
" 'Form6_DE457','Form6_DE463' ",
363
" 'Form6_DE458','Form6_DE464' ",
364
" 'Form6_DE459','Form6_DE465' ",
365
" 'Form6_DE460','Form6_DE466' ",
366
" 'Form6_DE461','Form6_DE467' ",
367
" 'Form6_DE462','Form6_DE468' ",
370
"'Form6_DE458'", "'Form6_DE459'", "'Form6_DE460'", "'Form6_DE461'", "'Form6_DE462'", "'Form6_DE463'", "'Form6_DE464'", "'Form6_DE465'",
372
"'Form6_DE467'", "'Form6_DE468'",
374
"' '","' '","' '","' '","' '","' '",
377
"'Form6_DE476'", "'Form6_DE477'", "'Form6_DE478'", "'Form6_DE479'", "'Form6_DE480'", "'Form6_DE481'", "'Form6_DE482'", "'Form6_DE483'",
379
"'Form6_DE485'", "'Form6_DE486'", "'Form6_DE487'", "'Form6_DE488'", "'Form6_DE489'", "'Form6_DE490'", "'Form6_DE491'", "'Form6_DE492'",
381
"'Form6_DE494'", "'Form6_DE495'", "'Form6_DE496'", "'Form6_DE497'", "'Form6_DE498'",
384
" 'Form6_DE505','Form6_DE511' ",
385
" 'Form6_DE506','Form6_DE512' ",
386
" 'Form6_DE507','Form6_DE513' ",
387
" 'Form6_DE508','Form6_DE514' ",
388
" 'Form6_DE509','Form6_DE515' ",
389
" 'Form6_DE510','Form6_DE516' ",
391
"'Form6_DE505'", "'Form6_DE506'", "'Form6_DE507'", "'Form6_DE508'", "'Form6_DE509'", "'Form6_DE510'", "'Form6_DE511'",
392
"'Form6_DE512'", "'Form6_DE513'", "'Form6_DE514'", "'Form6_DE515'", "'Form6_DE516'", "'Form6_DE517'", "'Form6_DE518'", "'Form6_DE519'",
394
"'Form6_DE521'", "'Form6_DE522'", "'Form6_DE523'", "'Form6_DE524'", "'Form6_DE525'", "'Form6_DE526'", "'Form6_DE527'", "'Form6_DE528'",
396
"'Form6_DE530'", "'Form6_DE531'", "'Form6_DE532'", "'Form6_DE533'", "'Form6_DE534'", "'Form6_DE535'", "'Form6_DE536'", "'Form6_DE537'",
398
"'Form6_DE539'", "'Form6_DE540'",
401
"'Form6_DE541'", "'Form6_DE542'", "'Form6_DE543'", "'Form6_DE544'", "'Form6_DE545'", "'Form6_DE546'", "'Form6_DE547'", "'Form6_DE548'",
403
"'Form6_DE550'", "'Form6_DE551'", "'Form6_DE552'", "'Form6_DE553'", "'Form6_DE554'", "'Form6_DE555'", "'Form6_DE556'", "'Form6_DE557'",
405
"'Form6_DE559'", "'Form6_DE560'", "'Form6_DE561'", "'Form6_DE562'", "'Form6_DE563'", "'Form6_DE564'", "'Form6_DE565'", "'Form6_DE566'",
407
"'Form6_DE568'", "'Form6_DE569'", "'Form6_DE570'", "'Form6_DE571'", "'Form6_DE572'", "'Form6_DE573'", "'Form6_DE574'", "'Form6_DE575'",
409
"'Form6_DE577'", "'Form6_DE578'", "'Form6_DE579'", "'Form6_DE580'", "'Form6_DE581'", "'Form6_DE582'", "'Form6_DE583'", "'Form6_DE584'",
411
"'Form6_DE586'", "'Form6_DE587'", "'Form6_DE588'", "'Form6_DE589'", "'Form6_DE590'", "'Form6_DE591'", "'Form6_DE592'", "'Form6_DE593'",
413
"'Form6_DE595'", "'Form6_DE596'", "'Form6_DE597'", "'Form6_DE598'", "'Form6_DE599'", "'Form6_DE600'", "'Form6_DE601'", "'Form6_DE602'",
415
"'Form6_DE604'", "'Form6_DE605'", "'Form6_DE606'", "'Form6_DE607'", "'Form6_DE608'", "'Form6_DE609'", "'Form6_DE610'", "'Form6_DE611'",
417
"'Form6_DE613'", "'Form6_DE614'", "'Form6_DE615'", "'Form6_DE616'", "'Form6_DE617'", "'Form6_DE618'", "'Form6_DE619'", "'Form6_DE620'",
420
"' '","' '","' '","' '",
422
"'Form7_DE57'", "'Form7_DE58'",
426
"'Form7_DE59'", "'Form7_DE60'",
430
"'Form7_DE61'", "'Form7_DE62'",
434
"'Form7_DE63'", "'Form7_DE64'",
438
"'Form7_DE65'", "'Form7_DE66'",
442
"'Form7_DE67'", "'Form7_DE68'",
446
"' '","' '","' '","' '","' '","' '","' '","' '","' '",
449
"'Form6_DE622'", "'Form6_DE623'", "'Form6_DE624'", "'Form6_DE625'", "'Form6_DE626'", "'Form6_DE627'",
450
"'Form6_DE628'", "'Form6_DE629'", "'Form6_DE630'", "'Form6_DE631'", "'Form6_DE632'", "'Form6_DE633'", "'Form6_DE634'", "'Form6_DE635'",
452
"'Form6_DE637'", "'Form6_DE638'", "'Form6_DE639'", "'Form6_DE640'", "'Form6_DE641'", "'Form6_DE642'", "'Form6_DE643'", "'Form6_DE644'",
454
"'Form6_DE646'", "'Form6_DE647'", "'Form6_DE648'", "'Form6_DE649'", "'Form6_DE650'",
457
"' '","' '","' '","' '",
459
"'Form7_DE69'", "'Form7_DE70'",
463
"'Form7_DE71'", "'Form7_DE72'",
467
"'Form7_DE73'", "'Form7_DE74'",
473
"'Form6_DE651'", "'Form6_DE652'", "'Form6_DE653'",
476
" 'Form7_DE75','Form6_DE726' ",
477
" 'Form7_DE76','Form6_DE727' ",
478
" 'Form7_DE77','Form6_DE728' ",
480
"'Form7_DE75'", "'Form7_DE76'", "'Form7_DE77'",
481
"'Form6_DE726'", "'Form6_DE727'", "'Form6_DE728'",
484
" 'Form6_DE729','Form6_DE732','Form6_DE735' ",
485
" 'Form6_DE730','Form6_DE733','Form6_DE736' ",
486
" 'Form6_DE731','Form6_DE734','Form6_DE737' ",
488
"'Form6_DE729'", "'Form6_DE730'", "'Form6_DE731'",
489
"'Form6_DE732'", "'Form6_DE733'", "'Form6_DE734'", "'Form6_DE735'", "'Form6_DE736'", "'Form6_DE737'",
490
"'Form6_DE666'", "'Form6_DE667'",
491
"'Form6_DE1529'", "'Form6_DE669'", "'Form6_DE670'", "'Form6_DE671'", "'Form6_DE672'", "'Form6_DE673'", "'Form6_DE674'", "'Form6_DE675'",
493
"'Form6_DE677'", "'Form6_DE678'", "'Form6_DE679'", "'Form6_DE680'", "'Form6_DE681'", "'Form6_DE682'", "'Form6_DE683'", "'Form6_DE684'",
495
"'Form6_DE686'", "'Form6_DE687'", "'Form6_DE688'", "'Form6_DE689'", "'Form6_DE690'", "'Form6_DE691'", "'Form6_DE692'", "'Form6_DE693'",
497
"'Form6_DE695'", "'Form6_DE696'", "'Form6_DE697'", "'Form6_DE698'", "'Form6_DE699'", "'Form6_DE700'", "'Form6_DE701'", "'Form6_DE702'",
499
"'Form6_DE704'", "'Form6_DE705'", "'Form6_DE706'", "'Form6_DE707'", "'Form6_DE708'", "'Form6_DE709'", "'Form6_DE710'", "'Form6_DE711'",
501
"'Form6_DE713'", "'Form6_DE714'", "'Form6_DE715'", "'Form6_DE716'", "'Form6_DE717'", "'Form6_DE718'", "'Form6_DE719'",
506
" 'Form6_DE723','Form6_DE726' ",
507
" 'Form6_DE724','Form6_DE727' ",
508
" 'Form6_DE725','Form6_DE728' ",
510
"'Form6_DE723'", "'Form6_DE724'", "'Form6_DE725'", "'Form6_DE726'", "'Form6_DE727'",
514
" 'Form6_DE729','Form6_DE732','Form6_DE735' ",
515
" 'Form6_DE730','Form6_DE733','Form6_DE736' ",
516
" 'Form6_DE731','Form6_DE734','Form6_DE737' ",
518
"'Form6_DE729'", "'Form6_DE730'", "'Form6_DE731'", "'Form6_DE732'", "'Form6_DE733'", "'Form6_DE734'", "'Form6_DE735'",
519
"'Form6_DE736'", "'Form6_DE737'",
521
"' '", "' '", "' '", "' '","' '","' '","' '","' '","' '",
523
"'Form6_DE741'", "'Form6_DE742'",
524
"'Form6_DE743'", "'Form6_DE744'", "'Form6_DE745'", "'Form6_DE746'", "'Form6_DE747'", "'Form6_DE748'", "'Form6_DE749'",
532
int dataElementIDs[] = new int[dataElementCodes.length+5];
533
int entryNumberValues[]= new int[dataElementCodes.length+5];
534
int entryValuesForLastYear[]= new int[dataElementCodes.length+5];
535
int cumentryValuesForCurYear[]= new int[dataElementCodes.length+5];
536
int cumentryValuesForLastYear[]= new int[dataElementCodes.length+5];
538
String monthNames[] = { "", "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" };
545
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
546
con = DriverManager.getConnection (urlForConnection, userName, password);
548
st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
549
st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
550
st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
551
st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
552
st4=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
553
st5=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
554
st6=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
555
st8=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
556
st9=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
557
st10=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
558
st11=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
559
st12=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
562
//rs1 = st1.executeQuery("SELECT organisationunit.shortname FROM organisationunit WHERE id ="+selectedOrgUnitID);
563
rs1 = st1.executeQuery("SELECT organisationunit.shortname FROM organisationunit WHERE organisationunitid ="+selectedOrgUnitID);
564
if(rs1.next()) { selectedOrgUnitName = rs1.getString(1); }
565
else { selectedOrgUnitName = ""; }
567
//rs11 = st11.executeQuery("select startDate,endDate from period where id = "+selectedDataPeriodID);
570
// selectedDataPeriodStartDate = rs11.getDate(1).toString();
571
// selectedDataPeriodEndDate = rs11.getDate(2).toString();
574
selectedDataPeriodStartDate = startingDate;
577
catch(Exception e) { out.println(e.getMessage()); }
582
if(rs1!=null) rs1.close(); if(st1!=null) st1.close();
583
if(rs11!=null) rs11.close(); if(st11!=null) st11.close();
585
catch(Exception e) { out.println(e.getMessage()); }
586
} // finally block end
588
String partsOfDataPeriodStartDate[] = selectedDataPeriodStartDate.split("-");
589
String partsOfDataPeriodEndDate[] = endingDate.split("-");
590
lastYear = Integer.parseInt(partsOfDataPeriodStartDate[0]) - 1;
591
lastDataPeriodStartDate = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
593
int tempForMonth1 = Integer.parseInt(partsOfDataPeriodStartDate[1]);
596
if(tempForMonth1 < 4) { tempForYear = lastYear; }
597
else { tempForYear = lastYear + 1; }
599
String curYearStart = tempForYear+"-04-01";
600
String lastYearStart = (tempForYear-1)+"-04-01";
601
String lastYearEnd = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
603
//for district, taluk, CHC names
606
//rs8=st8.executeQuery("select organisationunit.id, organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")");
607
rs8=st8.executeQuery("select organisationunit.organisationunitid, organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+selectedOrgUnitID+")");
608
if(rs8.next()) { PHCID = rs8.getInt(1);PHCName = rs8.getString(2); }
609
else { PHCID = 0; PHCName = ""; }
611
// rs9=st9.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+PHCID+")");
612
// if(rs9.next()) { CHCID = rs9.getInt(1);CHCName = rs9.getString(2); }
613
// else { CHCID = 0; CHCName = ""; }
615
//rs6=st6.executeQuery("select organisationunit.id, organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+PHCID+")");
616
rs6=st6.executeQuery("select organisationunit.organisationunitid, organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+PHCID+")");
617
if(rs6.next()) { districtID = rs6.getInt(1); districtName = rs6.getString(2);}
618
else {districtID = 0; districtName = "";}
620
//rs5=st5.executeQuery("select organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+districtID+")");
621
rs5=st5.executeQuery("select organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+districtID+")");
622
if(rs5.next()) { stateName = rs5.getString(1); }
623
else { stateName = ""; }
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 - 1</TITLE>
696
<script src="../dhis-web-reports/Kerala/KDENamesForForm1.js" type="text/javascript" language="Javascript"></script>
711
else if(j==2) end = 46;
712
else if(j==3) end = 18;
713
else if(j==4) end = 27;
715
for(start=0;start<=end;start++)
718
document.getElementById(id).innerHTML = slnoForForm1[k];
720
document.getElementById(id).innerHTML = denamesForForm1[k];
729
<BODY BGCOLOR="#FFFFFF" onload="fun1()">
730
<font face="Arial" size="2">(To be submitted by 10th March to the PHC)</font>
732
<font face="Arial" size="3">
733
<b>FORM 1<br>SUB-CENTRE (S.C) ACTION PLAN</b></font>
736
<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">
737
<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%">
738
<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">
739
<font face="Arial" size="2">A. General Information : </font>
741
<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">
742
Year:<%=partsOfDataPeriodStartDate[0]%> - <%=partsOfDataPeriodEndDate[0]%></td>
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
State :<%=stateName%></td>
747
<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">
748
<font face="Arial" size="2">Population of S.C.</font></td>
751
<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">
752
District : <%=districtName%></td>
753
<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">
754
<font face="Arial" size="2">Bitrh Rate)Distt./State</font></td>
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
P.H.C:<%=PHCName%></td>
759
<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">
760
Eligible couples</td>
763
<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">
764
Sub-center:<%=selectedOrgUnitName%></td>
765
<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">
766
<font face="Arial" size="2"> (As on 1st April)</font>
770
<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">
771
No.of Villages<br>under the sub-centre</td>
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"></font>
777
<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">
778
<font face="Arial" size="2"></font>
780
<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">
781
<font face="Arial" size="2"></font>
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">ANC = (population x Birth rate ) + 10%</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">
789
<font face="Arial" size="2">DELIVERY/LIVE BIRTH =
790
(Population x Birth rate).</font>
805
String tempForentryNumberValues[] = new String[12];
806
String tempForcumentryValuesForCurYear[] = new String[12];
820
<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
<td width="3%" align="center" style="border-collapse: collapse; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding-bottom:0; " bordercolor="#111111" align="left"><font face="Arial" size="2"><b>Sl.No</b></font></td>
823
<td width="67%" align="center" style="border-collapse: collapse; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding-bottom:0; padding-left:15; padding-right:1; " bordercolor="#111111" ><font face="Arial" size="2"><b>Consultation with</b></font></td>
824
<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"><b>No.of<br> Consultation</b></font></td>
825
<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"><b>When consulation made <br>(month of year)</b></font></td>
833
<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%">
839
<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
<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%">
851
<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%">
857
<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%">
861
if(j==1) endcount = 24;
862
else if(j==2) endcount = 46;
863
else if(j==3) endcount = 18;
864
else if(j==4) endcount = 27;
866
for(i=0;i<=endcount;i++)
868
String id1="cell1"+k;
869
String id2="cell2"+k;
875
tempForentryNumberValues[0]= "<b>Male</b>";
876
tempForentryNumberValues[1]= "<b>Female</b>";
877
tempForentryNumberValues[2]= "<b>Male</b>";
878
tempForentryNumberValues[3]= "<b>Female</b>";
882
else if(k==5 || k==8 || k==14 || k==16 || k==21 || k==23 || k==27 || k==29 || k==30 || k==40 || k==43 || k==45 || k==47 || k==49 || k==51 || k==55 || k==56 || k==59 || k==60 || k==63 || k==64 || k==68 || k==92 || k==98 || k==114 )
884
tempForentryNumberValues[0]= " ";
885
tempForentryNumberValues[1]= " ";
886
tempForentryNumberValues[2]= " ";
887
tempForentryNumberValues[3]= " ";
894
temp = entryNumberValues[l];
895
if(temp==-1) tempForentryNumberValues[0] = "";
896
else tempForentryNumberValues[0] = ""+temp;
900
temp = entryNumberValues[l];
901
if(temp==-1) tempForentryNumberValues[1] = "";
902
else tempForentryNumberValues[1] = ""+temp;
906
temp = entryNumberValues[l];
907
if(temp==-1) tempForentryNumberValues[2] = "";
908
else tempForentryNumberValues[2] = ""+temp;
912
temp = entryNumberValues[l];
913
if(temp==-1) tempForentryNumberValues[3] = "";
914
else tempForentryNumberValues[3] = ""+temp;
922
<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>
923
<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>
924
<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>
925
<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>
926
<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>
927
<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>
932
else if((k>=72 && k<=90))
940
<font face="arial" size=3><b>INVENTORY OF VACCINES AND DRUGS</b></font><br><br>
942
<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%">
944
tempForentryNumberValues[0]= "<b>Unit</b>";
945
tempForentryNumberValues[1]= "<b>Requirement<br>assessed<br>lastYear</b>";
946
tempForentryNumberValues[2]= "<b>Actual<br>quantity<br>received<br>last Year</b>";
947
tempForentryNumberValues[3]= "<b>Surplus or<br>shortage<br>last year</b>";
948
tempForentryNumberValues[4]= "<b>Requirement<br>for current<br>Year</b>";
952
else if(k==5 || k==8 || k==14 || k==16 || k==21 || k==23 || k==27 || k==29 || k==30 || k==40 || k==43 || k==45 || k==47 || k==49 || k==51 || k==55 || k==56 || k==59 || k==60 || k==63 || k==64 || k==68 || k==92 || k==97 || k==114 )
954
tempForentryNumberValues[0]= " ";
955
tempForentryNumberValues[1]= " ";
956
tempForentryNumberValues[2]= " ";
957
tempForentryNumberValues[3]= " ";
958
tempForentryNumberValues[4]= " ";
965
temp = entryNumberValues[l];
966
if(temp==-1) tempForentryNumberValues[0] = "";
967
else tempForentryNumberValues[0] = ""+temp;
971
temp = entryNumberValues[l];
972
if(temp==-1) tempForentryNumberValues[1] = "";
973
else tempForentryNumberValues[1] = ""+temp;
977
temp = entryNumberValues[l];
978
if(temp==-1) tempForentryNumberValues[2] = "";
979
else tempForentryNumberValues[2] = ""+temp;
983
temp = entryNumberValues[l];
984
if(temp==-1) tempForentryNumberValues[3] = "";
985
else tempForentryNumberValues[3] = ""+temp;
989
temp = entryNumberValues[l];
990
if(temp==-1) tempForentryNumberValues[4] = "";
991
else tempForentryNumberValues[4] = ""+temp;
998
<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>
999
<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>
1000
<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>
1001
<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>
1002
<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>
1003
<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>
1004
<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>
1009
else if((k>=92 && k<=118))
1013
tempForentryNumberValues[0]= "<b>Yes</b>";
1014
tempForentryNumberValues[1]= "<b>No</b>";
1015
tempForentryNumberValues[2]= " ";
1019
else if(k==5 || k==8 || k==14 || k==16 || k==21 || k==23 || k==27 || k==29 || k==30 || k==40 || k==43 || k==45 || k==47 || k==49 || k==51 || k==55 || k==56 || k==59 || k==60 || k==63 || k==64 || k==68 || k==93 || k==98 || k==115 )
1021
tempForentryNumberValues[0]= " ";
1022
tempForentryNumberValues[1]= " ";
1023
tempForentryNumberValues[2]= " ";
1030
temp = entryNumberValues[l];
1031
if(temp==-1) tempForentryNumberValues[0] = "";
1032
else tempForentryNumberValues[0] = ""+temp;
1036
temp = entryNumberValues[l];
1037
if(temp==-1) tempForentryNumberValues[1] = "";
1038
else tempForentryNumberValues[1] = ""+temp;
1042
temp = entryNumberValues[l];
1043
if(temp==-1) tempForentryNumberValues[2] = "";
1044
else tempForentryNumberValues[2] = ""+temp;
1052
<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>
1053
<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>
1054
<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="3"><font face="Arial" size="2"><%=tempForentryNumberValues[0]%></font></td>
1055
<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>
1056
<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[2]%></font></td>
1068
<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%">
1070
tempForentryNumberValues[0]= "<b>Performance <br>in last year</b>";
1071
tempForentryNumberValues[1]= "<b>Planned performance in <br>current year</b>";
1078
tempForentryNumberValues[0]= "<b>Performance <br>in last year</b>";
1079
tempForentryNumberValues[1]= "<b>Planned performance in <br>current year</b>";
1089
<font face="arial" size=3><b>FACILITY IN SUB-CENTRE</b></font><br><br>
1091
<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%">
1094
tempForentryNumberValues[0]= "<b>Avaliable</b>";
1095
tempForentryNumberValues[1]= "<b>Quantity / quality</b>";
1099
else if(k==5 || k==8 || k==14 || k==16 || k==21 || k==23 || k==27 || k==29 || k==30 || k==40 || k==43 || k==45 || k==47 || k==49 || k==51 || k==55 || k==56 || k==59 || k==60 || k==63 || k==64 || k==68 || k==92 || k==97 || k==114 )
1101
tempForentryNumberValues[0]= " ";
1102
tempForentryNumberValues[1]= " ";
1108
temp = entryNumberValues[l];
1109
if(temp==-1) tempForentryNumberValues[0] = "";
1110
else tempForentryNumberValues[0] = ""+temp;
1114
temp = entryNumberValues[l];
1115
if(temp==-1) tempForentryNumberValues[1] = "";
1116
else tempForentryNumberValues[1] = ""+temp;
1122
<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>
1123
<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>
1124
<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>
1125
<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'