← Back to branch summary

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

« back to all changes in this revision

Viewing changes to local/et/dhis-web-ethiopia/src/main/webapp/dhis-web-reports/Ethiopia/rptANC.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/et/dhis-web-ethiopia/src/main/webapp/dhis-web-reports/Ethiopia/rptANC.jsp
 
1
<%@ page import="java.sql.*" %>
 
2
<%@ page import="java.util.*" %>
 
3
<%@ page import="com.opensymphony.xwork.util.OgnlValueStack" %>
 
4
 
 
5
<%@ page session="true" %>
 
6
 
 
7
<%
 
8
 
 
9
   Connection con=null;            
 
10
    Statement st1=null;
 
11
    ResultSet rs1=null;      
 
12
  
 
13
    String userName = "root";      
 
14
    String password = "";           
 
15
    String urlForConnection = "jdbc:mysql://localhost/dhis2";  
 
16
    
 
17
        int orgUnitId = 16;
 
18
        String orgUnitName="";
 
19
        String parentName="";
 
20
        int parentId=0; 
 
21
        int periodId = 204;
 
22
        String startDate="";
 
23
        String endDate="";
 
24
OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
 
25
          String selectedId = (String) stack.findValue( "orgUnitId" );
 
26
          orgUnitId = Integer.parseInt( selectedId );
 
27
        
 
28
          String selectedPeriodId = (String) stack.findValue( "periodSelect" );
 
29
          periodId = Integer.parseInt( selectedPeriodId );
 
30
  
 
31
 
 
32
    int[] cARVM= new int[100];
 
33
        int[] cARVF= new int[100];
 
34
        int[] sARVM= new int[100];
 
35
        int[] sARVF= new int[100];
 
36
        int[] dARVM= new int[100];
 
37
        int[] dARVF= new int[100];
 
38
        int total=0;
 
39
        
 
40
        boolean nextde=true;
 
41
        
 
42
        /*String[] destring1={"2703","2705","2707","2709","2711","2713","2715","2717","2719","2721"};
 
43
        String[] destring2={"2704","2706","2708","2710","2712","2714","2716","2718","2720","2722"};
 
44
        String[] destring3={"2723","2725","2727","2729","2731","2733","2735","2737","2739","2741"};
 
45
        String[] destring4={"2724","2726","2728","2730","2732","2734","2736","2738","2740","2742"};
 
46
        String[] destring5={"2743","2745","2747","2749","2751","2753","2755","2757","2759","2761"};
 
47
        String[] destring6={"2744","2746","2748","2750","2752","2754","2756","2758","2760","2762"};
 
48
        String[] destring7={"2763","2765","2767","2769","2771","2773","2775","2777","2779","2781"};
 
49
        String[] destring8={"2764","2766","2768","2770","2772","2774","2776","2778","2780","2782"};
 
50
        String[] destring9={"2783","2785","2787","2789","2791","2793","2795","2797","2799","2801"};
 
51
        String[] destring10={"2784","2786","2788","2790","2792","2794","2796","2798","2800","2802"};*/
 
52
        int [] deint1={140,158,142,144,146,148,150,152,154,156,160};
 
53
        int [] deint2={139,157,141,143,145,147,149,151,153,155,159};
 
54
        int [] deint3={162,180,164,166,168,170,172,174,176,178,182};
 
55
        int [] deint4={161,179,163,165,167,169,171,173,175,177,181};
 
56
        int [] deint5={184,202,186,188,190,192,194,196,198,200,204};
 
57
        int [] deint6={183,201,185,187,189,191,193,195,197,199,203};
 
58
        
 
59
        String[] age= {"0-4","5-14","15-19","20-24","25-29","30-34","35-39","40-44","45-49","50+","Age Unspecified", "Total",};
 
60
        
 
61
        int i=0;
 
62
     try
 
63
      {
 
64
        Class.forName ("com.mysql.jdbc.Driver");
 
65
        con = DriverManager.getConnection (urlForConnection, userName, password);
 
66
        st1=con.createStatement();
 
67
                String sql = "select value,dataelement from datavalue where period="+periodId+" and source="+orgUnitId ;
 
68
                sql+=" and dataelement in (140,158,142,144,146,148,150,152,154,156,160)";               
 
69
        rs1 = st1.executeQuery(sql);
 
70
          if (rs1.next())
 
71
        {
 
72
            for(i=0;i<11;i++)
 
73
            {
 
74
                        rs1.beforeFirst();
 
75
                        nextde=true;
 
76
                        while (rs1.next() && nextde)
 
77
                        {
 
78
                        if (deint1[i]==(rs1.getInt("dataelement")))
 
79
                        {
 
80
                cARVM[i]=rs1.getInt("value");
 
81
                                nextde=false;
 
82
                        }
 
83
                        }                               
 
84
            
 
85
            }
 
86
         }                              
 
87
           
 
88
                sql = "select value,dataelement from datavalue where period="+periodId+" and source="+orgUnitId ;
 
89
                sql+=" and dataelement in (139,157,141,143,145,147,149,151,153,155,159)";               
 
90
        rs1 = st1.executeQuery(sql);  
 
91
          if (rs1.next())
 
92
        {
 
93
            for(i=0;i<11;i++)
 
94
            {
 
95
                        rs1.beforeFirst();
 
96
                        nextde=true;
 
97
                        while (rs1.next() && nextde)
 
98
                        {
 
99
                        if (deint2[i]==(rs1.getInt("dataelement")))
 
100
                        {
 
101
                cARVF[i]=rs1.getInt("value");                           
 
102
                nextde=false;
 
103
                        }
 
104
                        }
 
105
            }
 
106
         }                              
 
107
           
 
108
//geting orguntname
 
109
                sql = "select name,parent from organizationunit where id ="+orgUnitId ;
 
110
            rs1 = st1.executeQuery(sql);  
 
111
         if (rs1.next())
 
112
        {
 
113
           orgUnitName=rs1.getString("name");
 
114
                   parentId=rs1.getInt("parent");                               
 
115
            }
 
116
                
 
117
                sql = "select name from organizationunit where id="+parentId;
 
118
                rs1 = st1.executeQuery(sql);
 
119
                if (rs1.next())
 
120
                {
 
121
                        parentName=rs1.getString("name");
 
122
                }
 
123
                
 
124
            sql = "select startDate,endDate from period where id ="+periodId ;
 
125
            rs1 = st1.executeQuery(sql);  
 
126
         if (rs1.next())
 
127
        {
 
128
           startDate=rs1.getString("startDate");                                
 
129
           endDate=rs1.getString("endDate");                            
 
130
 
 
131
            }
 
132
            //end getting 
 
133
 
 
134
                   sql = "select value,dataelement from datavalue where period="+periodId+" and source="+orgUnitId ;
 
135
                sql+=" and dataelement in (162,180,164,166,168,170,172,174,176,178,182)";               
 
136
        rs1 = st1.executeQuery(sql); 
 
137
          if (rs1.next())
 
138
        {
 
139
            for(i=0;i<11;i++)
 
140
            {
 
141
                        rs1.beforeFirst();
 
142
                        nextde=true;
 
143
                        while (rs1.next() && nextde)
 
144
                        {
 
145
                        if (deint3[i]==(rs1.getInt("dataelement")))
 
146
                        {
 
147
                sARVM[i]=rs1.getInt("value");                           
 
148
                                nextde=false;    
 
149
                        }
 
150
                        }       
 
151
            }
 
152
         }                              
 
153
           
 
154
                   sql = "select value,dataelement from datavalue where period="+periodId+" and source="+orgUnitId ;
 
155
                sql+=" and dataelement in (161,179,163,165,167,169,171,173,175,177,181)";               
 
156
        rs1 = st1.executeQuery(sql); 
 
157
          if (rs1.next())
 
158
        {
 
159
            for(i=0;i<11;i++)
 
160
            {
 
161
                        rs1.beforeFirst();
 
162
                        nextde=true;
 
163
                        while (rs1.next() && nextde)
 
164
                        {
 
165
                        if (deint4[i]==(rs1.getInt("dataelement")))
 
166
                        {
 
167
                sARVF[i]=rs1.getInt("value");                           
 
168
                                nextde=false;    
 
169
                        }
 
170
                        }       
 
171
            }
 
172
         }                              
 
173
            
 
174
                   sql = "select value,dataelement from datavalue where period="+periodId+" and source="+orgUnitId ;
 
175
                sql+=" and dataelement in (184,202,186,188,190,192,194,196,198,200,204)";               
 
176
        rs1 = st1.executeQuery(sql); 
 
177
          if (rs1.next())
 
178
        {
 
179
            for(i=0;i<11;i++)
 
180
            {
 
181
                        rs1.beforeFirst();
 
182
                        nextde=true;
 
183
                        while (rs1.next() && nextde)
 
184
                        {
 
185
                        if (deint5[i]==(rs1.getInt("dataelement")))
 
186
                        {
 
187
                dARVM[i]=rs1.getInt("value");                           
 
188
                                nextde=false;
 
189
                        }
 
190
                        }            
 
191
            }
 
192
         }                              
 
193
            
 
194
                   sql = "select value,dataelement from datavalue where period="+periodId+" and source="+orgUnitId ;
 
195
                sql+=" and dataelement in (183,201,185,187,189,191,193,195,197,199,203)";               
 
196
        rs1 = st1.executeQuery(sql);  
 
197
          if (rs1.next())
 
198
        {
 
199
            for(i=0;i<11;i++)
 
200
            {
 
201
                        rs1.beforeFirst();
 
202
                        nextde=true;
 
203
                        while (rs1.next() && nextde)
 
204
                        {
 
205
                        if (deint6[i]==(rs1.getInt("dataelement")))
 
206
                        {
 
207
                dARVF[i]=rs1.getInt("value");                           
 
208
                                nextde=false;
 
209
                        }
 
210
                        }            
 
211
            }
 
212
         }                              
 
213
            
 
214
         
 
215
                   for(int z=0;z<=10;z++){
 
216
                                cARVM[11]+=cARVM[z];
 
217
                                cARVF[11]+=cARVF[z];
 
218
                                sARVM[11]+=sARVM[z];
 
219
                                sARVF[11]+=sARVF[z];
 
220
                                dARVM[11]+=dARVM[z];
 
221
                                dARVF[11]+=dARVF[z];
 
222
                   }
 
223
                   
 
224
                   total=cARVM[11]+cARVF[11]+sARVM[11]+sARVF[11]+dARVM[11]+dARVF[11];
 
225
                   
 
226
       } //try block end
 
227
      catch(Exception e)  { out.println("Loi cho ma gi day: "+e.getMessage());  }
 
228
      
 
229
%>
 
230
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 
231
<html>
 
232
<head>
 
233
<title>VCT Report for <%=orgUnitName%></title>
 
234
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
 
235
<link href="styles.css" rel="stylesheet" type="text/css">
 
236
<style type="text/css">
 
237
<!--
 
238
.style10 {font-family: Geneva, Arial, Helvetica, sans-serif}
 
239
-->
 
240
</style>
 
241
</head>
 
242
 
 
243
<body>
 
244
<table width="559" border="0" cellpadding="1" cellspacing="1" height="680">
 
245
  <!--DWLayoutTable-->
 
246
  <tr> 
 
247
    <td colspan="2" valign="top" height="590" width="561">
 
248
    <table width="544" border="0" cellpadding="1" cellspacing="1" height="554">
 
249
        <!--DWLayoutTable-->
 
250
        <tr> 
 
251
          <td width="560" height="60" valign="top">
 
252
          <table width="568" border="0" cellpadding="1" cellspacing="0">
 
253
              <!--DWLayoutTable-->
 
254
              <tr class="header"> 
 
255
                <td width="566" height="54" valign="top"  >Anti-Retroviral (ARV) Therapy for <%=orgUnitName%> </td>
 
256
              </tr>
 
257
            </table></td>
 
258
        </tr>
 
259
        <tr> 
 
260
          <td height="47" valign="top" width="560">
 
261
          <table width="569" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" class="header1" style="border-collapse: collapse" >
 
262
              <!--DWLayoutTable-->
 
263
              <tr bgcolor="#FFCCCC" class="header1"> 
 
264
                <td width="137" height="47" valign="top" class="header1" bgcolor="#008080" bordercolor="#FFFFFF"><div align="left">
 
265
                  Region
 
266
                    
 
267
                </div>                </td>
 
268
                <td width="137" class="header1" bgcolor="#008080" bordercolor="#FFFFFF"><%=parentName%>&nbsp;</td>
 
269
                <td width="137" valign="top" class="header1" bgcolor="#008080" bordercolor="#FFFFFF" >
 
270
                OrgUnit</td>
 
271
                <td width="143" bgcolor="#008080" bordercolor="#FFFFFF"><%=orgUnitName%>&nbsp;</td>
 
272
              </tr>
 
273
            </table></td>
 
274
        </tr>
 
275
        <tr> 
 
276
          <td height="55" valign="top" width="560">
 
277
          <table width="569" border="1" cellpadding="0" cellspacing="0" class="header1" style="border-collapse: collapse" bordercolor="#FFFFFF">
 
278
              <!--DWLayoutTable-->
 
279
              <tr bgcolor="#FFCCCC"> 
 
280
                <td width="118" height="55" valign="top" class="header1" bgcolor="#008080"><div align="left">Period</div></td>
 
281
                <td width="117" valign="top" class="header1" bgcolor="#008080">From</td>
 
282
                <td width="111" bgcolor="#008080"><%=startDate%>&nbsp;</td>
 
283
                <td width="114" valign="top" class="header1" bgcolor="#008080">To</td>
 
284
                <td width="90" valign="top" class="header1" bgcolor="#008080">
 
285
                <%=endDate%>&nbsp;</td>
 
286
              </tr>
 
287
            </table></td>
 
288
        </tr>
 
289
        <tr> 
 
290
          <td height="380" valign="top" width="560">
 
291
          <table width="89%" border="0" cellpadding="0" cellspacing="0" height="75">
 
292
              <!--DWLayoutTable-->
 
293
              <tr> 
 
294
                <td width="555" height="93" valign="top">
 
295
                <table width="570" height="92" border="1" cellpadding="0" cellspacing="0" bgcolor="#000066" style="border-collapse: collapse" bordercolor="#000099">
 
296
                    <!--DWLayoutTable-->
 
297
                    <tr class="tableheader">
 
298
                      <td width="58" height="62" rowspan="2" valign="top" class="tableheader">Age</td>
 
299
                      <td height="65" colspan="3" valign="top" class="tableheader" width="82">
 
300
                      Clients on ARV Treatment </td>
 
301
                      <td colspan="3" valign="top" class="tableheader" width="83" height="65">
 
302
                      Clients Starting ARV Treatment </td> 
 
303
                      <td colspan="3" valign="top" class="tableheader" width="81" height="65">
 
304
                      Clients Discontinued ARV Treatment</td>
 
305
                      </td> 
 
306
                      <td colspan="3" valign="top" class="tableheader" width="61" height="65">
 
307
                      Total</td>
 
308
                    </tr>
 
309
                    <tr>
 
310
                      <td width="19" height="13" valign="top" class="tableheader">Male</td>                    
 
311
                      <td width="23" valign="top" class="tableheader" height="13">Female </td>                     
 
312
                      <td width="34" valign="top" class="tableheader" height="13">Total</td>                       
 
313
                      <td width="20" valign="top" class="tableheader" height="13">Male</td>
 
314
                      <td width="23" valign="top" class="tableheader" height="13">Female</td>
 
315
                      <td width="34" valign="top" class="tableheader" height="13">Total</td>
 
316
                      <td width="24" valign="top" class="tableheader" height="13">Male</td>
 
317
                      <td width="18" valign="top" class="tableheader" height="13">Female </td>
 
318
                      <td width="33" valign="top" class="tableheader" height="13">Total</td>
 
319
                      <td width="38" valign="top" class="tableheader" height="13">Male Total</td>
 
320
                      <td width="18" valign="top" class="tableheader" height="13">Female Total</td>
 
321
                      <td width="33" valign="top" class="tableheader" height="13">Grand Total</td>
 
322
                                        
 
323
                                        <% for (int k=0;k<12;k++) {%>
 
324
                                        <tr>
 
325
                      <td width="19" height="13" valign="top" class="tableheader"><%=age[k]%></td>
 
326
                                          <%if (k==11) {%><td width="19" height="13" valign="top" class="tableheader"><%=cARVM[k]%></td><%}%>
 
327
                      <%if (k!=11) {%><td width="19" height="13" valign="top" class="tableitem"><%=cARVM[k]%></td><%}%>
 
328
                      <%if (k==11) {%><td width="19" height="13" valign="top" class="tableheader"><%=cARVF[k]%></td><%}%>
 
329
                      <%if (k!=11) {%><td width="19" height="13" valign="top" class="tableitem"><%=cARVF[k]%></td><%}%>
 
330
                      <%if (k==11) {%><td width="19" height="13" valign="top" class="tableheader"><%=cARVM[k]+cARVF[k]%></td><%}%>
 
331
                      <%if (k!=11) {%><td width="18" valign="top" class="tableheader" height="13"><%=cARVM[k]+cARVF[k]%></td><%}%>
 
332
                      <%if (k==11) {%><td width="18" valign="top" class="tableheader" height="13"><%=sARVM[k]%></td><%}%>
 
333
                      <%if (k!=11) {%><td width="33" valign="top" class="tableitem" height="13"><%=sARVM[k]%></td><%}%>
 
334
                      <%if (k==11) {%><td width="19" height="13" valign="top" class="tableheader"><%=sARVF[k]%></td><%}%>
 
335
                      <%if (k!=11) {%><td width="33" height="13" valign="top" class="tableitem"><%=sARVF[k]%></td><%}%>
 
336
                      <%if (k==11) {%><td width="19" height="13" valign="top" class="tableheader"><%=sARVM[k]+sARVF[k]%></td><%}%>
 
337
                      <%if (k!=11) {%><td width="19" height="13" valign="top" class="tableheader"><%=sARVM[k]+sARVF[k]%></td><%}%>
 
338
                      <%if (k==11) {%><td width="19" height="13" valign="top" class="tableheader"><%=dARVM[k]%></td><%}%>
 
339
                      <%if (k!=11) {%><td width="19" height="13" valign="top" class="tableitem"><%=dARVM[k]%></td><%}%>
 
340
                      <%if (k==11) {%><td width="19" height="13" valign="top" class="tableheader"><%=dARVF[k]%></td><%}%>
 
341
                      <%if (k!=11) {%><td width="19" height="13" valign="top" class="tableitem"><%=dARVF[k]%></td><%}%>
 
342
                      <%if (k==11) {%><td width="19" height="13" valign="top" class="tableheader"><%=dARVM[k]+dARVF[k]%></td><%}%>
 
343
                      <%if (k!=11) {%><td width="19" height="13" valign="top" class="tableheader"><%=dARVM[k]+dARVF[k]%></td><%}%>
 
344
                      <td width="19" height="13" valign="top" class="tableheader"><%=cARVM[k]+sARVM[k]+dARVM[k]%></td>
 
345
                      <td width="19" height="13" valign="top" class="tableheader"><%=cARVF[k]+sARVF[k]+dARVF[k]%></td>
 
346
                      <td width="19" height="13" valign="top" class="tableheader"><%=cARVM[k]+sARVM[k]+dARVM[k]+cARVF[k]+sARVF[k]+dARVF[k]%></td>
 
347
                                         </tr>
 
348
                                         <% } %>
 
349
                    
 
350
                  </table>
 
351
              </tr>
 
352
              <tr> 
 
353
                <td height="1" valign="top"><table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#000066">
 
354
                    <!--DWLayoutTable-->
 
355
                                        
 
356
                
 
357
              </tr>
 
358
            </table></td>
 
359
        </tr>
 
360
      </table></td>
 
361
  </tr>
 
362
                  </table></td>
 
363
              </tr>
 
364
              <tr>
 
365
                <td height="19"><p style="line-height: 100%"><b><i>
 
366
                <font face="Tahoma" size="1">Referrals for:-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
367
                </font>
 
368
                </i>
 
369
                </b>
 
370
                </p>
 
371
                <p style="line-height: 100%"><b><i>
 
372
                <font face="Tahoma" size="1">&nbsp;&nbsp;&nbsp;clinical Care&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 
373
                Follow-up Counseling&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ANC</font></i></b></p>
 
374
                <p style="line-height: 100%"><b><i>
 
375
                <font size="1" face="Tahoma">&nbsp;&nbsp;TB Follow-up&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Spiritual Counseling&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
376
                </font></i>
 
377
                </b><i>
 
378
                <font face="Tahoma"><b><font size="1" face="Tahoma">Orphanage&nbsp;
 
379
                </font> </b></font></i></p>
 
380
                <p style="line-height: 100%"><b><i>
 
381
                <font face="Tahoma" size="1"><font face="Tahoma">&nbsp; </font>
 
382
                <font face="Tahoma">STI</font><font face="Tahoma"> Follow-up&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Home based Care&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 
383
                Other (specify)</font></font></i></b></p>
 
384
                <p style="line-height: 100%"><b><i>
 
385
                <font size="1" face="Tahoma">&nbsp;&nbsp;Family Planning&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Financial Support&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
386
                </font></i>
 
387
                </b><i>
 
388
                <b>
 
389
                <font size="1" face="Tahoma">Total</font></b></i></p>
 
390
                <p style="line-height: 100%"><b><i>
 
391
                <font face="Tahoma">&nbsp;&nbsp;</font></i></b></p>
 
392
    <td width="539" height="1"></td>
 
393
    <td height="1" width="19"></td>
 
394
  </tr>
 
395
</table>
 
396
</body>
 
397
</html>
 
 
b'\\ No newline at end of file'