2
<%@ page import="java.sql.*,java.util.*" %>
3
<%@ page import="com.opensymphony.xwork.util.OgnlValueStack" %>
6
<%@ page session="true"%>
11
// For finding organisationunit name of selected Orgunit based on Orgunit id
15
// For finding start date of selected period based on period id
19
// For finding datavalues
23
// For finding District Name and Id based on selected Orgunit id
27
// For finding State Name based on District id
31
String userName = "dhis";
33
String urlForConnection = "jdbc:mysql://localhost/mp_dhis2";
35
OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
37
String selectedId = (String) stack.findValue( "orgUnitId" );
38
int selectedOrgUnitID = Integer.parseInt( selectedId );
39
// int selectedOrgUnitID = 239;
42
String startingDate = (String) stack.findValue( "startingPeriod" );
43
String endingDate = (String) stack.findValue( "endingPeriod" );
44
// String startingDate = "2006-07-01";
45
// String endingDate = "2006-07-01";
48
String monthlyPeriodId = (String) stack.findValue( "monthlyPeriodTypeId" );
49
int periodTypeID = Integer.parseInt( monthlyPeriodId );
50
//int periodTypeID =1;
52
String selectedOrgUnitName = "";
53
String selectedDataPeriodStartDate = "";
55
String stateName = "";
56
String districtName = "";
60
String monthNames[] = { "", "January", "February", "March", "April", "May", "June", "July", "August", "September","October", "November", "December" };
62
String monthlyDataElements[] = {
65
"NC_DE1","NC_DE29", // col 3
66
"NC_DE2","NC_DE30", // col 4
76
// Ischemic Heart Diseases
78
"NC_DE3","NC_DE31", // col 3
79
"NC_DE4","NC_DE32", // col 4
89
// Cerebro Vascular Accident
90
"NC_DE5","NC_DE33", // col 3
91
"NC_DE6","NC_DE34", // col 4
101
// Other Neurological Disorders
102
"NC_DE7","NC_DE35", // col 3
103
"NC_DE8","NC_DE36", // col 4
113
// Diabetes Mellitus Type - 1
114
"NC_DE9","NC_DE37", // col 3
115
"NC_DE10","NC_DE38", // col 4
125
// Diabetes Mellitus Type - 2
126
"NC_DE11","NC_DE39", // col 3
127
"NC_DE12","NC_DE40", // col 4
138
"NC_DE13","NC_DE41", // col 3
139
"NC_DE14","NC_DE42", // col 4
150
"NC_DE15","NC_DE43", // col 3
151
"NC_DE16","NC_DE44", // col 4
162
"NC_DE17","NC_DE45", // col 3
163
"NC_DE18","NC_DE46", // col 4
173
// Common Mental Disorders
174
"NC_DE19","NC_DE47", // col 3
175
"NC_DE20","NC_DE48", // col 4
185
// Severe Mental Disorders
186
"NC_DE21","NC_DE49", // col 3
187
"NC_DE22","NC_DE50", // col 4
197
// Accidental Injuries
198
"NC_DE23","NC_DE51", // col 3
199
"NC_DE24","NC_DE52", // col 4
210
"NC_DE25","NC_DE53", // col 3
211
"NC_DE26","NC_DE54", // col 4
222
"NC_DE27","NC_DE55", // col 3
223
"NC_DE28","NC_DE56", // col 4
237
String nonCommDisNames[] = {
238
"कार्डियो भास्कुलर रोगी ",
239
"हाईपरटेनसन",
240
"इसेमिक ह्र्दय रोग",
241
"न्युरोलोजिकल रोग",
242
"सेरेबरो भास्कुलर दुघर्टना ",
243
"अन्य न्युरोलोजिकल डिस आर्डर",
244
"डायबिटिज",
245
"टाईप 1",
246
"टाईप 2",
247
"फेफडे",
248
"ब्रोनकाइटिस",
249
"इम्फीजमास",
250
"दमा",
251
"मानसिक असंतुलन",
252
"साधारण मानसिक असंतुलन",
253
"घातक मानसिक असंतुलन",
254
"दुघर्टना ग्रस्त चोट",
255
"कैंसर",
256
"सर्पदंश",
257
"योग"
260
String nonCommDisNo[] = {
261
"1.","1.1","1.2","2.","2.1","2.2","3.","3.1","3.2","4.","4.1","4.2","4.3","5.","5.1","5.2","6.","7.","8."," "
265
List childOrgUnitIDs = new ArrayList();
266
List childOrgUnitNames = new ArrayList();
268
int childOrgUnitCount = 0;
271
int totPopulation = 0;
273
int tempval[] = new int[16];
274
int total[] = new int[16];
281
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
282
con = DriverManager.getConnection (urlForConnection, userName, password);
284
st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
285
st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
286
st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
287
st4=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
288
st5=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
292
//rs1 = st1.executeQuery("SELECT organisationunit.shortname from organisationunit where id="+selectedOrgUnitID);
293
rs1 = st1.executeQuery("SELECT organisationunit.shortname from organisationunit where organisationunitid="+selectedOrgUnitID);
294
if(rs1.next()) { selectedOrgUnitName = rs1.getString(1); }
295
else { selectedOrgUnitName = ""; totPopulation = 0; }
297
// rs2 = st2.executeQuery("select startDate from period where id = "+selectedDataPeriodID);
298
// if(rs2.next()) { selectedDataPeriodStartDate = rs2.getDate(1).toString(); }
300
selectedDataPeriodStartDate = startingDate;
302
//rs4=st4.executeQuery("select organisationunit.id, organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")");
303
rs4=st4.executeQuery("select organisationunit.organisationunitid, organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+selectedOrgUnitID+")");
304
if(rs4.next()) { districtID = rs4.getInt(1); districtName = rs4.getString(2);}
305
else {districtID = 0; districtName = "";}
307
//rs5=st5.executeQuery("select organisationunit.id, organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+districtID+")");
308
rs5=st5.executeQuery("select organisationunit.organisationunitid, organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+districtID+")");
309
if(rs5.next()) { stateName = rs5.getString(2);}
310
else { stateName = "";}
313
catch(Exception e) { out.println(e.getMessage()); }
316
String partsOfDataPeriodStartDate[] = selectedDataPeriodStartDate.split("-");
317
int lastYear = Integer.parseInt(partsOfDataPeriodStartDate[0]) - 1;
318
String lastDataPeriodStartDate = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
320
int tempForMonth1 = Integer.parseInt(partsOfDataPeriodStartDate[1]);
323
if(tempForMonth1 < 4) { tempForYear = lastYear; }
324
else { tempForYear = lastYear + 1; }
326
String tempForMonth2 = "";
327
if(tempForMonth1-1 ==0) tempForMonth2 = "-"+(tempForMonth1-1)+"-01";
328
else if(tempForMonth1-1 <= 9) {tempForMonth2 = "-0"+(tempForMonth1-1)+"-01";}
329
else tempForMonth2 = "-"+(tempForMonth1-1)+"-01";
331
String curYearStart = tempForYear+"-04-01";
332
String lastYearStart = (tempForYear-1)+"-04-01";
333
String lastYearEnd = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
334
String curYearEnd = ""+partsOfDataPeriodStartDate[0]+""+tempForMonth2;
342
<title>Monthly Report on Non-Communicable Diseases</title>
346
<font face="arial" size="3"><b>
347
गैर-संचारी रोग का मासिक संकलित प्रतिवेदन ( लिंगानुसार आक्रांत एवं मॄत्यु)
348
जिला का
351
<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">
352
<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%">
353
<td width="50%" 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">
354
<font face="Arial" size="2">1. जिला नाम : <%=selectedOrgUnitName%></font>
356
<td width="50%" 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">
357
<font face="Arial" size="2">2. प्रतिवेदित माह एवं वर्ष : <%=monthNames[Integer.parseInt(partsOfDataPeriodStartDate[1])]%> - <%=partsOfDataPeriodStartDate[0]%> </font>
361
<td width="50%" 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">
362
<font face="Arial" size="2">3. प्रखण्ड स्त्तर पर प्रतिवेदित करने वाले संस्थान की कुल संख्या:</font>
364
<td width="50%" 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">
365
<font face="Arial" size="2">4. प्रतिवेदित माह में प्रखण्ड स्त्तर पर गैर-संचारी रोग प्रतिवेदन उपस्थापित करने वालों की कुल संख्या :</font>
370
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
372
<td width="2%" align="center" rowspan="3"><font face="arial" size="2"><b>क्रम सं.</b></font></td>
373
<td width="18%" align="center" rowspan="3"><font face="arial" size="2"><b>गैर-संचारी रोगों का प्रकॄति/ समूह</td>
374
<td width="20%" align="center" colspan="6"><font face="arial" size="2"><b>गत माह तक रोगों एवं मॄत्यु की कुल संख्या</b></font></td>
375
<td width="10%" align="center" colspan="3"><font face="arial" size="2"><b>प्रतिवेदित माह में बाह्य रोगियों की संख्या</b></font></td>
376
<td width="10%" align="center" colspan="3"><font face="arial" size="2"><b>प्रतिवेदित माह में अंत: रोगियों की संख्या</b></font></td>
377
<td width="10%" align="center" colspan="3"><font face="arial" size="2"><b>प्रतिवेदित माह में कुल रोगीयों की संख्या</b></font></td>
378
<td width="10%" align="center" colspan="3"><font face="arial" size="2"><b>प्रतिवेदित माह में मृत्य रोगीयों की संख्या</b></font></td>
379
<td width="20%" align="center" colspan="6"><font face="arial" size="2"><b>प्रतिवेदित माह के अंत में प्रतिवेदित रोगों एवं मॄत्यु की कुल संख्या</b></font></td>
382
<td width="10%" align="center" colspan="3"><font face="arial" size="2"><b>रोगी</b></font></td>
383
<td width="10%" align="center" colspan="3"><font face="arial" size="2"><b>मॄत्यु </b></font></td>
384
<td width="10%" align="center" colspan="3"><font face="arial" size="2"><b>नये रोगी</b></font></td>
385
<td width="10%" align="center" colspan="3"><font face="arial" size="2"><b>नये रोगी</b></font></td>
386
<td width="10%" align="center" colspan="3"><font face="arial" size="2"><b>रोगी</b></font></td>
387
<td width="10%" align="center" colspan="3"><font face="arial" size="2"><b> </b></font></td>
388
<td width="10%" align="center" colspan="3"><font face="arial" size="2"><b>रोगी</b></font></td>
389
<td width="10%" align="center" colspan="3"><font face="arial" size="2"><b>मॄत्यु</b></font></td>
392
<td width="3%" align="center" ><font face="arial" size="2"><b>पु.</b></font></td>
393
<td width="3%" align="center" ><font face="arial" size="2"><b>म.</b></font></td>
394
<td width="4%" align="center" ><font face="arial" size="2"><b>योग </b></font></td>
395
<td width="3%" align="center" ><font face="arial" size="2"><b>पु.</b></font></td>
396
<td width="3%" align="center" ><font face="arial" size="2"><b>म.</b></font></td>
397
<td width="4%" align="center" ><font face="arial" size="2"><b>योग </b></font></td>
398
<td width="3%" align="center" ><font face="arial" size="2"><b>पु.</b></font></td>
399
<td width="3%" align="center" ><font face="arial" size="2"><b>म.</b></font></td>
400
<td width="4%" align="center" ><font face="arial" size="2"><b>योग </b></font></td>
401
<td width="3%" align="center" ><font face="arial" size="2"><b>पु.</b></font></td>
402
<td width="3%" align="center" ><font face="arial" size="2"><b>म.</b></font></td>
403
<td width="4%" align="center" ><font face="arial" size="2"><b>योग </b></font></td>
404
<td width="3%" align="center" ><font face="arial" size="2"><b>पु.</b></font></td>
405
<td width="3%" align="center" ><font face="arial" size="2"><b>म.</b></font></td>
406
<td width="4%" align="center" ><font face="arial" size="2"><b>योग </b></font></td>
407
<td width="3%" align="center" ><font face="arial" size="2"><b>पु.</b></font></td>
408
<td width="3%" align="center" ><font face="arial" size="2"><b>म.</b></font></td>
409
<td width="4%" align="center" ><font face="arial" size="2"><b>योग </b></font></td>
410
<td width="3%" align="center" ><font face="arial" size="2"><b>पु.</b></font></td>
411
<td width="3%" align="center" ><font face="arial" size="2"><b>म.</b></font></td>
412
<td width="4%" align="center" ><font face="arial" size="2"><b>योग </b></font></td>
413
<td width="3%" align="center" ><font face="arial" size="2"><b>पु.</b></font></td>
414
<td width="3%" align="center" ><font face="arial" size="2"><b>म.</b></font></td>
415
<td width="4%" align="center" ><font face="arial" size="2"><b>योग </b></font></td>
418
<td width="2%" align="center" rowspan="2"><font face="arial" size="1"><b>1</b></font></td>
419
<td width="18%" align="center" rowspan="2"><font face="arial" size="1"><b>2</b></font></td>
420
<td width="3%" align="center" rowspan="2"><font face="arial" size="1"><b>3</b></font></td>
421
<td width="3%" align="center" rowspan="2"><font face="arial" size="1"><b>4</b></font></td>
422
<td width="4%" align="center" rowspan="2"><font face="arial" size="1"><b>5</b></font></td>
423
<td width="3%" align="center" rowspan="2"><font face="arial" size="1"><b>6</b></font></td>
424
<td width="3%" align="center" rowspan="2"><font face="arial" size="1"><b>7</b></font></td>
425
<td width="4%" align="center" rowspan="2"><font face="arial" size="1"><b>8</b></font></td>
426
<td width="3%" align="center" rowspan="2"><font face="arial" size="1"><b>9</b></font></td>
427
<td width="3%" align="center" rowspan="2"><font face="arial" size="1"><b>10</b></font></td>
428
<td width="4%" align="center" rowspan="2"><font face="arial" size="1"><b>11</b></font></td>
429
<td width="3%" align="center" rowspan="2"><font face="arial" size="1"><b>12</b></font></td>
430
<td width="3%" align="center" rowspan="2"><font face="arial" size="1"><b>13</b></font></td>
431
<td width="4%" align="center" rowspan="2"><font face="arial" size="1"><b>14</b></font></td>
432
<td width="3%" align="center" ><font face="arial" size="1"><b>15</b></font></td>
433
<td width="3%" align="center" ><font face="arial" size="1"><b>16</b></font></td>
434
<td width="4%" align="center" ><font face="arial" size="1"><b>17</b></font></td>
435
<td width="3%" align="center" rowspan="2"><font face="arial" size="1"><b>18</b></font></td>
436
<td width="3%" align="center" rowspan="2"><font face="arial" size="1"><b>19</b></font></td>
437
<td width="4%" align="center" rowspan="2"><font face="arial" size="1"><b>20</b></font></td>
438
<td width="3%" align="center" ><font face="arial" size="1"><b>21</b></font></td>
439
<td width="3%" align="center" ><font face="arial" size="1"><b>22</b></font></td>
440
<td width="4%" align="center" ><font face="arial" size="1"><b>23</b></font></td>
441
<td width="3%" align="center" ><font face="arial" size="1"><b>24</b></font></td>
442
<td width="3%" align="center" ><font face="arial" size="1"><b>25</b></font></td>
443
<td width="4%" align="center" ><font face="arial" size="1"><b>26</b></font></td>
446
<td width="3%" align="center" ><font face="arial" size="1"><b>9+12</b></font></td>
447
<td width="3%" align="center" ><font face="arial" size="1"><b>10+13</b></font></td>
448
<td width="4%" align="center" ><font face="arial" size="1"><b>11+14</b></font></td>
449
<td width="3%" align="center" ><font face="arial" size="1"><b>3+15</b></font></td>
450
<td width="3%" align="center" ><font face="arial" size="1"><b>4+16</b></font></td>
451
<td width="4%" align="center" ><font face="arial" size="1"><b>5+17</b></font></td>
452
<td width="3%" align="center" ><font face="arial" size="1"><b>6+18</b></font></td>
453
<td width="3%" align="center" ><font face="arial" size="1"><b>7+19</b></font></td>
454
<td width="4%" align="center" ><font face="arial" size="1"><b>8+20</b></font></td>
465
if(count==0 || count ==3 || count ==6 || count==9 || count==13)
469
<td width="2%"><font face="arial" size="2"><%=nonCommDisNo[count]%></font> </td>
470
<td width="98%" colspan="25"><font face="arial" size="2"><%=nonCommDisNames[count]%></font> </td>
476
// 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+") AND dataelement.code like '"+monthlyDataElements[k]+"'"
481
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 '"+curYearEnd+"' and periodtypeid = "+periodTypeID+") AND datavalue.sourceid in (select organisationunitid from organisationunit where parentid in ( select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+") or organisationunitid in (select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+") or organisationunitid = "+selectedOrgUnitID+") AND dataelement.code like '"+monthlyDataElements[k]+"'";
483
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 in ( select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+") or organisationunitid in (select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+") or organisationunitid = "+selectedOrgUnitID+") AND dataelement.code like '"+monthlyDataElements[k]+"'";
485
rs3 = st3.executeQuery(query);
487
// SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataElement = dataelement.id WHERE datavalue.period ="+selectedDataPeriodID+" AND datavalue.source in (select id from organisationunit where parent ="+selectedOrgUnitID+") AND dataelement.code like '"+monthlyDataElements[k]+"'");
489
if(!rs3.next()) { tempval[i] = 0; }
490
else { tempval[i] = rs3.getInt(1); }
491
total[i] += tempval[i];
499
<td width="2%"><font face="arial" size="2"><%=nonCommDisNo[count]%></font> </td>
500
<td width="18%"><font face="arial" size="2"><%=nonCommDisNames[count]%></font> </td>
501
<td width="3%" align="center" ><font face="arial" size="2"><%=(tempval[0]+tempval[1])%></font> </td>
502
<td width="3%" align="center" ><font face="arial" size="2"><%=(tempval[2]+tempval[3])%></font> </td>
503
<td width="4%" align="center" ><font face="arial" size="2"><%=(tempval[0]+tempval[1]+tempval[2]+tempval[3])%></font> </td>
504
<td width="3%" align="center" ><font face="arial" size="2"><%=tempval[4]%></font> </td>
505
<td width="3%" align="center" ><font face="arial" size="2"><%=tempval[5]%></font> </td>
506
<td width="4%" align="center" ><font face="arial" size="2"><%=(tempval[4]+tempval[5])%></font> </td>
507
<td width="3%" align="center" ><font face="arial" size="2"><%=tempval[6]%></font> </td>
508
<td width="3%" align="center" ><font face="arial" size="2"><%=tempval[7]%></font> </td>
509
<td width="4%" align="center" ><font face="arial" size="2"><%=(tempval[6]+tempval[7])%></font> </td>
510
<td width="3%" align="center" ><font face="arial" size="2"><%=tempval[8]%></font> </td>
511
<td width="3%" align="center" ><font face="arial" size="2"><%=tempval[9]%></font> </td>
512
<td width="4%" align="center" ><font face="arial" size="2"><%=(tempval[8]+tempval[9])%></font> </td>
513
<td width="3%" align="center" ><font face="arial" size="2"><%=(tempval[6]+tempval[8])%></font> </td>
514
<td width="3%" align="center" ><font face="arial" size="2"><%=(tempval[7]+tempval[9])%></font> </td>
515
<td width="4%" align="center" ><font face="arial" size="2"><%=(tempval[6]+tempval[7]+tempval[8]+tempval[9])%></font> </td>
516
<td width="3%" align="center" ><font face="arial" size="2"><%=tempval[10]%></font> </td>
517
<td width="3%" align="center" ><font face="arial" size="2"><%=tempval[11]%></font> </td>
518
<td width="4%" align="center" ><font face="arial" size="2"><%=(tempval[10]+tempval[11])%></font> </td>
519
<td width="3%" align="center" ><font face="arial" size="2"><%=(tempval[0]+tempval[1]+tempval[6]+tempval[8])%></font> </td>
520
<td width="3%" align="center" ><font face="arial" size="2"><%=(tempval[2]+tempval[3]+tempval[7]+tempval[9])%></font> </td>
521
<td width="4%" align="center" ><font face="arial" size="2"><%=(tempval[0]+tempval[1]+tempval[2]+tempval[3]+tempval[6]+tempval[7]+tempval[8]+tempval[9])%></font> </td>
522
<td width="3%" align="center" ><font face="arial" size="2"><%=(tempval[4]+tempval[10])%></font> </td>
523
<td width="3%" align="center" ><font face="arial" size="2"><%=(tempval[5]+tempval[11])%></font> </td>
524
<td width="4%" align="center" ><font face="arial" size="2"><%=(tempval[4]+tempval[5]+tempval[10]+tempval[11])%></font> </td>
527
<%} // else block end
531
catch(Exception e) { out.println(e.getMessage()); }
536
if(rs1!=null) rs1.close(); if(st1!=null) st1.close();
537
if(rs2!=null) rs2.close(); if(st2!=null) st2.close();
538
if(rs3!=null) rs3.close(); if(st3!=null) st3.close();
539
if(rs4!=null) rs4.close(); if(st4!=null) st4.close();
540
if(rs5!=null) rs5.close(); if(st5!=null) st5.close();
542
if(con!=null) con.close();
544
catch(Exception e) { out.println(e.getMessage()); }
545
} // finally block end
549
<td width="20%" align="center" colspan="2"><font face="arial" size="2">योग</font></td>
550
<td width="3%" align="center" ><font face="arial" size="2"><%=(total[0]+total[1])%></font> </td>
551
<td width="3%" align="center" ><font face="arial" size="2"><%=(total[2]+total[3])%></font> </td>
552
<td width="4%" align="center" ><font face="arial" size="2"><%=(total[0]+total[1]+total[2]+total[3])%></font> </td>
553
<td width="3%" align="center" ><font face="arial" size="2"><%=total[4]%></font> </td>
554
<td width="3%" align="center" ><font face="arial" size="2"><%=total[5]%></font> </td>
555
<td width="4%" align="center" ><font face="arial" size="2"><%=(total[4]+total[5])%></font> </td>
556
<td width="3%" align="center" ><font face="arial" size="2"><%=total[6]%></font> </td>
557
<td width="3%" align="center" ><font face="arial" size="2"><%=total[7]%></font> </td>
558
<td width="4%" align="center" ><font face="arial" size="2"><%=(total[6]+total[7])%></font> </td>
559
<td width="3%" align="center" ><font face="arial" size="2"><%=total[8]%></font> </td>
560
<td width="3%" align="center" ><font face="arial" size="2"><%=total[9]%></font> </td>
561
<td width="4%" align="center" ><font face="arial" size="2"><%=(total[8]+total[9])%></font> </td>
562
<td width="3%" align="center" ><font face="arial" size="2"><%=(total[6]+total[8])%></font> </td>
563
<td width="3%" align="center" ><font face="arial" size="2"><%=(total[7]+total[9])%></font> </td>
564
<td width="4%" align="center" ><font face="arial" size="2"><%=(total[6]+total[7]+total[8]+total[9])%></font> </td>
565
<td width="3%" align="center" ><font face="arial" size="2"><%=total[10]%></font> </td>
566
<td width="3%" align="center" ><font face="arial" size="2"><%=total[11]%></font> </td>
567
<td width="4%" align="center" ><font face="arial" size="2"><%=(total[10]+total[11])%></font> </td>
568
<td width="3%" align="center" ><font face="arial" size="2"><%=(total[0]+total[1]+total[6]+total[8])%></font> </td>
569
<td width="3%" align="center" ><font face="arial" size="2"><%=(total[2]+total[3]+total[7]+total[9])%></font> </td>
570
<td width="4%" align="center" ><font face="arial" size="2"><%=(total[0]+total[1]+total[2]+total[3]+total[6]+total[7]+total[8]+total[9])%></font> </td>
571
<td width="3%" align="center" ><font face="arial" size="2"><%=(total[4]+total[10])%></font> </td>
572
<td width="3%" align="center" ><font face="arial" size="2"><%=(total[5]+total[11])%></font> </td>
573
<td width="4%" align="center" ><font face="arial" size="2"><%=(total[4]+total[5]+total[10]+total[11])%></font> </td>
b'\\ No newline at end of file'