1
<%@ page contentType="text/html ; charset=UTF-8"%>
3
<%@ page import="java.sql.*,java.util.*" %>
4
<%@ page import="com.opensymphony.xwork.util.OgnlValueStack" %>
6
<%@ page session="true"%>
20
PreparedStatement pst = null;
23
String userName = "dhis";
25
String urlForConnection = "jdbc:mysql://localhost/mp_dhis2";
28
OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
30
String selectedId = (String) stack.findValue( "orgUnitId" );
31
int selectedOrgUnitID = Integer.parseInt( selectedId );
32
//int selectedOrgUnitID = 259;
34
String startingDate = (String) stack.findValue( "startingPeriod" );
35
String endingDate = (String) stack.findValue( "endingPeriod" );
37
//String startingDate = "2006-01-01";
38
//String endingDate = "2006-12-31";
40
int seletedDataSetID = 242;
41
int selectedPeriodID = 0;
42
int periodTypeID = 3; // Yearly
44
String partsOfDataPeriodStartDate[] = startingDate.split("-");
45
String selectedOrgUnitName = "";
47
Hashtable htForDataSetMembers = new Hashtable();
57
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
58
con = DriverManager.getConnection (urlForConnection, userName, password);
60
st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
61
st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
62
st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
64
rs1 = st1.executeQuery("SELECT name FROM organisationunit WHERE organisationunitid = "+selectedOrgUnitID);
65
if(rs1.next()) selectedOrgUnitName = rs1.getString(1);
67
rs2 = st2.executeQuery("SELECT datasetmembers.dataelementid,dataelement.name FROM datasetmembers INNER JOIN dataelement ON datasetmembers.dataelementid = dataelement.dataelementid WHERE datasetmembers.datasetid = "+seletedDataSetID);
70
String temp1 = ""+rs2.getInt(1);
71
String temp2 = rs2.getString(2);
72
htForDataSetMembers.put(temp1,temp2);
75
rs3 = st3.executeQuery("SELECT periodid FROM period WHERE startdate LIKE '"+startingDate+"' AND periodtypeid = "+periodTypeID);
76
if(rs3.next()) selectedPeriodID = rs3.getInt(1);
79
catch(Exception e) { out.println(e.getMessage()); }
86
<title>SubCentre PHC PROFILE</title>
88
<body onload="onLoadFun()">
90
<FONT face="Arial" size="3"><b><u>PHC PROFILE</u></font>
93
<table cellpadding="0" cellspacing="0" bgcolor="ffffff" align="left" style="border-style:solid; border-width:0; border-collapse: collapse; padding: 0; position:relative; top:10" bordercolor="#ffffff" width="100%" border="0">
94
<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%">
95
<td width="75%" align="left">
96
<font face="Arial" size="2"><b>SubCentre Name : <%=selectedOrgUnitName%></b></font>
98
<td width="25%" align="right">
99
<font face="Arial" size="2"><b>Year : <%=partsOfDataPeriodStartDate[0]%></b></font>
104
<table style="border-collapse: collapse; padding: 0;" width="100%" border="1">
106
<td width="3%" align="left">
107
<font face="Arial" size="2">Sl. No.</font>
109
<td width="72%" align="center">
110
<font face="Arial" size="2"><b>Service</b></font>
112
<td width="25%" align="center">
113
<font face="Arial" size="2"><b>Value</b></font>
122
Enumeration keysForDataSetMembers = htForDataSetMembers.keys();
123
pst = con.prepareStatement("SELECT value FROM datavalue WHERE sourceid = ? AND periodid = ? AND dataelementid = ?");
126
while(keysForDataSetMembers.hasMoreElements())
128
String DEID = (String) keysForDataSetMembers.nextElement();
129
String DEName = (String) htForDataSetMembers.get(DEID);
130
int deid = Integer.parseInt(DEID);
131
String dataValue = "";
133
pst.setInt(1,selectedOrgUnitID);
134
pst.setInt(2,selectedPeriodID);
137
rs4 = pst.executeQuery();
138
if(rs4.next()) dataValue = rs4.getString(1);
140
if(dataValue == null) dataValue = "";
144
<td width="3%" align="left">
145
<font face="Arial" size="2"><%=count%></font>
147
<td width="72%" align="left">
148
<font face="Arial" size="2"><%=DEName%></font>
150
<td width="25%" align="center">
151
<font face="Arial" size="2"><%=dataValue%></font> </td>
157
catch(Exception e) { out.println(e.getMessage()); }
162
if(st1 != null) st1.close(); if(rs1 != null) rs1.close();
163
if(st2 != null) st2.close(); if(rs2 != null) rs2.close();
164
if(st3 != null) st3.close(); if(rs3 != null) rs3.close();
165
if(pst != null) pst.close(); if(rs4 != null) rs4.close();
167
if(con!=null) con.close();
169
catch(Exception e) { out.println(e.getMessage()); }
170
} // finally block end
b'\\ No newline at end of file'