← Back to branch summary

~mortenoh/+junk/dhis2-detailed-import-export

« back to all changes in this revision

Viewing changes to local/in/dhis-web-reports/src/main/webapp/dhis-web-reports/MadhyaPradesh/mchcphcprofile2.jsp

  • Committer: larshelge at gmail
  • Date: 2009-03-03 16:46:36 UTC
  • Revision ID: larshelge@gmail.com-20090303164636-2sjlrquo7ib1gf7r
Initial check-in

Show diffs side-by-side

added added

removed removed

Lines of Context:
local/in/dhis-web-reports/src/main/webapp/dhis-web-reports/MadhyaPradesh/mchcphcprofile2.jsp
 
1
<%@ page contentType="text/html ; charset=UTF-8"%>
 
2
 
 
3
<%@ page import="java.sql.*,java.util.*" %>
 
4
<%@ page import="com.opensymphony.xwork.util.OgnlValueStack" %>
 
5
 
 
6
<%@ page session="true"%>
 
7
 
 
8
<%
 
9
    Connection con=null;
 
10
    
 
11
        Statement st1 = null;
 
12
    ResultSet rs1 = null;
 
13
                
 
14
    Statement st2 = null;
 
15
    ResultSet rs2 = null;
 
16
 
 
17
    Statement st3 = null;
 
18
    ResultSet rs3 = null;
 
19
 
 
20
        PreparedStatement pst = null;
 
21
    ResultSet rs4 = null;
 
22
 
 
23
    String userName = "dhis";      
 
24
    String password = "";           
 
25
    String urlForConnection = "jdbc:mysql://localhost/mp_dhis2";
 
26
          
 
27
 
 
28
        OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
 
29
 
 
30
        String selectedId = (String) stack.findValue( "orgUnitId" );
 
31
        int selectedOrgUnitID = Integer.parseInt( selectedId );
 
32
        //int selectedOrgUnitID = 243;
 
33
        
 
34
        String startingDate  = (String) stack.findValue( "startingPeriod" );
 
35
        String endingDate  = (String) stack.findValue( "endingPeriod" );
 
36
 
 
37
        //String startingDate = "2006-01-01";
 
38
        //String endingDate = "2006-12-31";
 
39
        
 
40
        int seletedDataSetID = 240;
 
41
        int selectedPeriodID = 0;
 
42
        int periodTypeID = 3; // Yearly
 
43
        
 
44
    String partsOfDataPeriodStartDate[] = startingDate.split("-");        
 
45
        String selectedOrgUnitName = ""; 
 
46
        
 
47
        Hashtable htForDataSetMembers = new Hashtable();
 
48
        
 
49
        
 
50
        
 
51
%>              
 
52
                                        
 
53
<%
 
54
 
 
55
     try
 
56
     {
 
57
        Class.forName ("com.mysql.jdbc.Driver").newInstance ();
 
58
        con = DriverManager.getConnection (urlForConnection, userName, password);
 
59
        
 
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);
 
63
                
 
64
        rs1 = st1.executeQuery("SELECT name FROM organisationunit WHERE organisationunitid = "+selectedOrgUnitID);
 
65
        if(rs1.next()) selectedOrgUnitName = rs1.getString(1);       
 
66
                
 
67
        rs2 = st2.executeQuery("SELECT datasetmembers.dataelementid,dataelement.name FROM datasetmembers INNER JOIN dataelement ON datasetmembers.dataelementid = dataelement.dataelementid WHERE datasetmembers.datasetid = "+seletedDataSetID);
 
68
        while(rs2.next()) 
 
69
        {
 
70
                        String temp1 = ""+rs2.getInt(1);
 
71
                        String temp2 = rs2.getString(2);
 
72
                htForDataSetMembers.put(temp1,temp2);
 
73
        }// while block end
 
74
 
 
75
        rs3 = st3.executeQuery("SELECT periodid FROM period WHERE startdate LIKE '"+startingDate+"' AND periodtypeid = "+periodTypeID);
 
76
        if(rs3.next()) selectedPeriodID = rs3.getInt(1);
 
77
                                                                                                                
 
78
     } //try block end
 
79
     catch(Exception e)  { out.println(e.getMessage());  }                                    
 
80
          
 
81
%>
 
82
 
 
83
 
 
84
<html>
 
85
        <head>
 
86
                <title>SubCentre PHC PROFILE</title>
 
87
        </head>
 
88
        <body onload="onLoadFun()">             
 
89
                <center> 
 
90
                <FONT face="Arial" size="3"><b><u>PHC PROFILE</u></font>
 
91
                </center>
 
92
                <br>                        
 
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>PHC Name : <%=selectedOrgUnitName%></b></font>
 
97
                                </td>
 
98
                                <td width="25%" align="right">
 
99
                                <font face="Arial" size="2"><b>Year : <%=partsOfDataPeriodStartDate[0]%></b></font>
 
100
                                </td>   
 
101
                        </tr>                   
 
102
                </table>
 
103
                <br><br>
 
104
                <table style="border-collapse: collapse; padding: 0;"  width="100%"  border="1">
 
105
                        <tr>
 
106
                        <td width="3%" align="left">
 
107
                                <font face="Arial" size="2">Sl. No.</font> &nbsp;
 
108
                        </td>
 
109
                        <td width="72%" align="center">
 
110
                                <font face="Arial" size="2"><b>Service</b></font>
 
111
                                </td>
 
112
                                <td width="25%" align="center">
 
113
                                <font face="Arial" size="2"><b>Value</b></font>
 
114
                                </td>   
 
115
                        </tr>                   
 
116
                
 
117
                
 
118
<%
 
119
 
 
120
     try
 
121
     {                  
 
122
        Enumeration keysForDataSetMembers = htForDataSetMembers.keys();
 
123
        pst = con.prepareStatement("SELECT value FROM datavalue WHERE sourceid = ? AND periodid = ? AND dataelementid = ?");
 
124
        
 
125
        int count = 1;
 
126
        while(keysForDataSetMembers.hasMoreElements())
 
127
        {
 
128
                String DEID = (String) keysForDataSetMembers.nextElement();
 
129
                String DEName = (String) htForDataSetMembers.get(DEID);
 
130
                int deid = Integer.parseInt(DEID);
 
131
                String dataValue = "";
 
132
                
 
133
                pst.setInt(1,selectedOrgUnitID);
 
134
                pst.setInt(2,selectedPeriodID);
 
135
                pst.setInt(3,deid);
 
136
                
 
137
                        rs4 = pst.executeQuery();       
 
138
                if(rs4.next()) dataValue = rs4.getString(1);
 
139
                else dataValue = "";
 
140
                if(dataValue == null) dataValue = "";       
 
141
        
 
142
                %>
 
143
                <tr>
 
144
                        <td width="3%" align="left">
 
145
                                <font face="Arial" size="2"><%=count%></font> &nbsp;</td>
 
146
                        <td width="72%" align="left">
 
147
                                <font face="Arial" size="2"><%=DEName%></font> &nbsp;</td>
 
148
                                <td width="25%" align="center">
 
149
                                <font face="Arial" size="2"><%=dataValue%></font> &nbsp;</td>   
 
150
                        </tr>                   
 
151
                        <%
 
152
                        count++;
 
153
        }// while block end
 
154
     } //try block end
 
155
     catch(Exception e)  { out.println(e.getMessage());  }                                 
 
156
     finally
 
157
     {
 
158
                try
 
159
                {
 
160
                        if(st1 != null) st1.close();            if(rs1 != null) rs1.close();
 
161
                        if(st2 != null) st2.close();            if(rs2 != null) rs2.close();
 
162
                        if(st3 != null) st3.close();            if(rs3 != null) rs3.close();    
 
163
                        if(pst != null) pst.close();            if(rs4 != null) rs4.close();
 
164
                                
 
165
                        if(con!=null)  con.close(); 
 
166
                }
 
167
                catch(Exception e)   {  out.println(e.getMessage());   }
 
168
     } // finally block end            
 
169
%>                          
 
170
                </table>
 
171
        </body> 
 
172
</html>
 
 
b'\\ No newline at end of file'