← 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/rptARV.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/rptARV.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[] pretestM= new int[100];
 
33
        int[] pretestF= new int[100];
 
34
        int[] testM= new int[100];
 
35
        int[] testF= new int[100];
 
36
        int[] positiveM= new int[100];
 
37
        int[] positiveF= new int[100];
 
38
        int[] posttestM= new int[100];
 
39
        int[] posttestF= new int[100];
 
40
        int[] HIVprM= new int[100];
 
41
        int[] HIVprF= new int[100];
 
42
        
 
43
        boolean nextde=true;
 
44
        
 
45
        String[] destring1={"2703","2705","2707","2709","2711","2713","2715","2717","2719","2721"};
 
46
        String[] destring2={"2704","2706","2708","2710","2712","2714","2716","2718","2720","2722"};
 
47
        String[] destring3={"2723","2725","2727","2729","2731","2733","2735","2737","2739","2741"};
 
48
        String[] destring4={"2724","2726","2728","2730","2732","2734","2736","2738","2740","2742"};
 
49
        String[] destring5={"2743","2745","2747","2749","2751","2753","2755","2757","2759","2761"};
 
50
        String[] destring6={"2744","2746","2748","2750","2752","2754","2756","2758","2760","2762"};
 
51
        String[] destring7={"2763","2765","2767","2769","2771","2773","2775","2777","2779","2781"};
 
52
        String[] destring8={"2764","2766","2768","2770","2772","2774","2776","2778","2780","2782"};
 
53
        String[] destring9={"2783","2785","2787","2789","2791","2793","2795","2797","2799","2801"};
 
54
        String[] destring10={"2784","2786","2788","2790","2792","2794","2796","2798","2800","2802"};
 
55
        
 
56
        String[] age= {"<15","15-19","20-24","25-29","30-34","35-39","40-44","45-49","50+","Unrecorded", "Total",};
 
57
        
 
58
        int i=0;
 
59
     try
 
60
      {
 
61
        Class.forName ("com.mysql.jdbc.Driver");
 
62
        con = DriverManager.getConnection (urlForConnection, userName, password);
 
63
        st1=con.createStatement();
 
64
                String sql = "select value,dataelement from datavalue where period="+periodId+" and source="+orgUnitId ;
 
65
                sql+=" and dataelement in (2703,2705,2707,2709,2711,2713,2715,2717,2719,2721)";         
 
66
        rs1 = st1.executeQuery(sql);
 
67
          if (rs1.next())
 
68
        {
 
69
            for(i=0;i<10;i++)
 
70
            {
 
71
                        rs1.beforeFirst();
 
72
                        nextde=true;
 
73
                        while (rs1.next() && nextde)
 
74
                        {
 
75
                        if (destring1[i].equals(rs1.getString("dataelement")))
 
76
                        {
 
77
                pretestM[i]=rs1.getInt("value");
 
78
                                nextde=false;
 
79
                        }
 
80
                        }                               
 
81
            
 
82
            }
 
83
         }                              
 
84
           
 
85
                sql = "select value,dataelement from datavalue where period="+periodId+" and source="+orgUnitId ;
 
86
                sql+=" and dataelement in (2704,2706,2708,2710,2712,2714,2716,2718,2720,2722)";         
 
87
        rs1 = st1.executeQuery(sql);  
 
88
          if (rs1.next())
 
89
        {
 
90
            for(i=0;i<10;i++)
 
91
            {
 
92
                        rs1.beforeFirst();
 
93
                        nextde=true;
 
94
                        while (rs1.next() && nextde)
 
95
                        {
 
96
                        if (destring2[i].equals(rs1.getString("dataelement")))
 
97
                        {
 
98
                pretestF[i]=rs1.getInt("value");                                
 
99
                nextde=false;
 
100
                        }
 
101
                        }
 
102
            }
 
103
         }                              
 
104
           
 
105
//geting orguntname
 
106
                sql = "select name,parent from organizationunit where id ="+orgUnitId ;
 
107
            rs1 = st1.executeQuery(sql);  
 
108
         if (rs1.next())
 
109
        {
 
110
           orgUnitName=rs1.getString("name");
 
111
                   parentId=rs1.getInt("parent");                               
 
112
            }
 
113
                
 
114
                sql = "select name from organizationunit where id="+parentId;
 
115
                rs1 = st1.executeQuery(sql);
 
116
                if (rs1.next())
 
117
                {
 
118
                        parentName=rs1.getString("name");
 
119
                }
 
120
                
 
121
            sql = "select startDate,endDate from period where id ="+periodId ;
 
122
            rs1 = st1.executeQuery(sql);  
 
123
         if (rs1.next())
 
124
        {
 
125
           startDate=rs1.getString("startDate");                                
 
126
           endDate=rs1.getString("endDate");                            
 
127
 
 
128
            }
 
129
            //end getting 
 
130
 
 
131
                   sql = "select value,dataelement from datavalue where period="+periodId+" and source="+orgUnitId ;
 
132
                sql+=" and dataelement in (2723,2725,2727,2729,2731,2733,2735,2737,2739,2741)";         
 
133
          if (rs1.next())
 
134
        {
 
135
            for(i=0;i<10;i++)
 
136
            {
 
137
                        rs1.beforeFirst();
 
138
                        nextde=true;
 
139
                        while (rs1.next() && nextde)
 
140
                        {
 
141
                        if (destring3[i].equals(rs1.getString("dataelement")))
 
142
                        {
 
143
                testM[i]=rs1.getInt("value");                           
 
144
                                nextde=false;
 
145
                        }
 
146
                        }            
 
147
            }
 
148
         }                              
 
149
            
 
150
                   sql = "select value,dataelement from datavalue where period="+periodId+" and source="+orgUnitId ;
 
151
                sql+=" and dataelement in (2724,2726,2728,2730,2732,2734,2736,2738,2740,2742)";         
 
152
        rs1 = st1.executeQuery(sql); 
 
153
          if (rs1.next())
 
154
        {
 
155
            for(i=0;i<10;i++)
 
156
            {
 
157
                        rs1.beforeFirst();
 
158
                        nextde=true;
 
159
                        while (rs1.next() && nextde)
 
160
                        {
 
161
                        if (destring4[i].equals(rs1.getString("dataelement")))
 
162
                        {
 
163
                testF[i]=rs1.getInt("value");                           
 
164
                                nextde=false;    
 
165
                        }
 
166
                        }       
 
167
            }
 
168
         }                              
 
169
           
 
170
                   sql = "select value,dataelement from datavalue where period="+periodId+" and source="+orgUnitId ;
 
171
                sql+=" and dataelement in (2743,2745,2747,2749,2751,2753,2755,2757,2759,2761)";         
 
172
        rs1 = st1.executeQuery(sql); 
 
173
          if (rs1.next())
 
174
        {
 
175
            for(i=0;i<10;i++)
 
176
            {
 
177
                        rs1.beforeFirst();
 
178
                        nextde=true;
 
179
                        while (rs1.next() && nextde)
 
180
                        {
 
181
                        if (destring5[i].equals(rs1.getString("dataelement")))
 
182
                        {
 
183
                positiveM[i]=rs1.getInt("value");                               
 
184
                                nextde=false;
 
185
                        }
 
186
                        }            
 
187
            }
 
188
         }                              
 
189
            
 
190
                   sql = "select value,dataelement from datavalue where period="+periodId+" and source="+orgUnitId ;
 
191
                sql+=" and dataelement in (2744,2746,2748,2750,2752,2754,2756,2758,2760,2762)";         
 
192
        rs1 = st1.executeQuery(sql);  
 
193
          if (rs1.next())
 
194
        {
 
195
            for(i=0;i<10;i++)
 
196
            {
 
197
                        rs1.beforeFirst();
 
198
                        nextde=true;
 
199
                        while (rs1.next() && nextde)
 
200
                        {
 
201
                        if (destring6[i].equals(rs1.getString("dataelement")))
 
202
                        {
 
203
                positiveF[i]=rs1.getInt("value");                               
 
204
                                nextde=false;
 
205
                        }
 
206
                        }            
 
207
            }
 
208
         }                              
 
209
            
 
210
                   sql = "select value,dataelement from datavalue where period="+periodId+" and source="+orgUnitId ;
 
211
                   sql+=" and dataelement in (2763,2765,2767,2769,2771,2773,2775,2777,2779,2781)";              
 
212
        rs1 = st1.executeQuery(sql);                                    
 
213
          
 
214
          if (rs1.next())
 
215
        {
 
216
            for(i=0;i<10;i++)
 
217
            {
 
218
                        rs1.beforeFirst();
 
219
                        nextde=true;
 
220
                        while (rs1.next() && nextde)
 
221
                        {
 
222
                        if (destring7[i].equals(rs1.getString("dataelement")))
 
223
                        {
 
224
                posttestM[i]=rs1.getInt("value");                               
 
225
                                nextde=false;
 
226
                        }
 
227
                        }            
 
228
            }
 
229
         }  
 
230
                   sql = "select value,dataelement from datavalue where period="+periodId+" and source="+orgUnitId ;
 
231
                sql+=" and dataelement in (2764,2766,2768,2770,2772,2774,2776,2778,2780,2782)";         
 
232
        rs1 = st1.executeQuery(sql); 
 
233
          if (rs1.next())
 
234
        {
 
235
            for(i=0;i<10;i++)
 
236
            {
 
237
                        rs1.beforeFirst();
 
238
                        nextde=true;
 
239
                        while (rs1.next() && nextde)
 
240
                        {
 
241
                        if (destring8[i].equals(rs1.getString("dataelement")))
 
242
                        {
 
243
                posttestF[i]=rs1.getInt("value");                               
 
244
                                nextde=false;
 
245
                        }
 
246
                        }            
 
247
            }
 
248
         }                              
 
249
            
 
250
                   sql = "select value,dataelement from datavalue where period="+periodId+" and source="+orgUnitId ;
 
251
                sql+=" and dataelement in (2783,2785,2787,2789,2791,2793,2795,2797,2799,2801)";         
 
252
        rs1 = st1.executeQuery(sql); 
 
253
          if (rs1.next())
 
254
        {
 
255
            for(i=0;i<10;i++)
 
256
            {
 
257
                        rs1.beforeFirst();
 
258
                        nextde=true;
 
259
                        while (rs1.next() && nextde)
 
260
                        {
 
261
                        if (destring9[i].equals(rs1.getString("dataelement")))
 
262
                        {
 
263
                HIVprM[i]=rs1.getInt("value");                          
 
264
                                nextde=false;  
 
265
                        }
 
266
                        }          
 
267
            }
 
268
         }                              
 
269
            
 
270
                   sql = "select value,dataelement from datavalue where period="+periodId+" and source="+orgUnitId ;
 
271
                sql+=" and dataelement in (2784,2786,2788,2790,2792,2794,2796,2798,2800,2802)";         
 
272
        rs1 = st1.executeQuery(sql);                                    
 
273
          
 
274
          if (rs1.next())
 
275
        {
 
276
            for(i=0;i<10;i++)
 
277
            {
 
278
                        rs1.beforeFirst();
 
279
                        nextde=true;
 
280
                        while (rs1.next() && nextde)
 
281
                        {
 
282
                        if (destring10[i].equals(rs1.getString("dataelement")))
 
283
                        {
 
284
                HIVprF[i]=rs1.getInt("value");                          
 
285
                                nextde=false;
 
286
                        }
 
287
                        }
 
288
            }
 
289
         }  
 
290
         
 
291
                   for(int z=0;z<=9;z++){
 
292
                                pretestM[10]+=pretestM[z];
 
293
                                pretestF[10]+=pretestF[z];
 
294
                                testM[10]+=testM[z];
 
295
                                testF[10]+=testF[z];
 
296
                                positiveM[10]+=positiveM[z];
 
297
                                positiveF[10]+=positiveF[z];
 
298
                                posttestM[10]+=posttestM[z];
 
299
                                posttestF[10]+=posttestF[z];
 
300
                                HIVprM[10]+=HIVprM[z];
 
301
                                HIVprF[10]+=HIVprF[z];
 
302
                   }
 
303
                   
 
304
       } //try block end
 
305
      catch(Exception e)  { out.println("Loi cho ma gi day: "+e.getMessage());  }
 
306
      
 
307
%>
 
308
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 
309
<html>
 
310
<head>
 
311
<title>VCT Report for <%=orgUnitName%></title>
 
312
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
 
313
<link href="styles.css" rel="stylesheet" type="text/css">
 
314
<style type="text/css">
 
315
<!--
 
316
.style10 {font-family: Geneva, Arial, Helvetica, sans-serif}
 
317
-->
 
318
</style>
 
319
</head>
 
320
 
 
321
<body>
 
322
<table width="559" border="0" cellpadding="1" cellspacing="1" height="680">
 
323
  <!--DWLayoutTable-->
 
324
  <tr> 
 
325
    <td colspan="2" valign="top" height="590" width="561">
 
326
    <table width="544" border="0" cellpadding="1" cellspacing="1" height="554">
 
327
        <!--DWLayoutTable-->
 
328
        <tr> 
 
329
          <td width="560" height="60" valign="top">
 
330
          <table width="556" border="0" cellpadding="1" cellspacing="0">
 
331
              <!--DWLayoutTable-->
 
332
              <tr class="header"> 
 
333
                <td width="554" height="54" valign="top"  >Voluntary Counseling and Testing (VCT) Service by Health Facility </td>
 
334
              </tr>
 
335
            </table></td>
 
336
        </tr>
 
337
        <tr> 
 
338
          <td height="47" valign="top" width="560">
 
339
          <table width="556" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" class="header1" style="border-collapse: collapse" >
 
340
              <!--DWLayoutTable-->
 
341
              <tr bgcolor="#FFCCCC" class="header1"> 
 
342
                <td width="137" height="47" valign="top" class="header1" bgcolor="#008080" bordercolor="#FFFFFF"><div align="left">
 
343
                  Region
 
344
                    
 
345
                </div>                </td>
 
346
                <td width="137" class="header1" bgcolor="#008080" bordercolor="#FFFFFF"><%=parentName%>&nbsp;</td>
 
347
                <td width="137" valign="top" class="header1" bgcolor="#008080" bordercolor="#FFFFFF" >
 
348
                OrgUnit</td>
 
349
                <td width="130" bgcolor="#008080" bordercolor="#FFFFFF"><%=orgUnitName%>&nbsp;</td>
 
350
              </tr>
 
351
            </table></td>
 
352
        </tr>
 
353
        <tr> 
 
354
          <td height="55" valign="top" width="560">
 
355
          <table width="556" border="1" cellpadding="0" cellspacing="0" class="header1" style="border-collapse: collapse" bordercolor="#FFFFFF">
 
356
              <!--DWLayoutTable-->
 
357
              <tr bgcolor="#FFCCCC"> 
 
358
                <td width="118" height="55" valign="top" class="header1" bgcolor="#008080"><div align="left">Period</div></td>
 
359
                <td width="117" valign="top" class="header1" bgcolor="#008080">From</td>
 
360
                <td width="111" bgcolor="#008080"><%=startDate%>&nbsp;</td>
 
361
                <td width="114" valign="top" class="header1" bgcolor="#008080">To</td>
 
362
                <td width="77" valign="top" class="header1" bgcolor="#008080">
 
363
                <%=endDate%>&nbsp;</td>
 
364
              </tr>
 
365
            </table></td>
 
366
        </tr>
 
367
        <tr> 
 
368
          <td height="380" valign="top" width="560">
 
369
          <table width="89%" border="0" cellpadding="0" cellspacing="0" height="75">
 
370
              <!--DWLayoutTable-->
 
371
              <tr> 
 
372
                <td width="555" height="93" valign="top">
 
373
                <table width="556" height="92" border="1" cellpadding="0" cellspacing="0" bgcolor="#000066" style="border-collapse: collapse" bordercolor="#000099">
 
374
                    <!--DWLayoutTable-->
 
375
                    <tr class="tableheader">
 
376
                      <td width="58" height="37" rowspan="2" valign="top" class="tableheader">Age</td>
 
377
                      <td height="33" colspan="3" valign="top" class="tableheader" width="82">pretest Counseled </td>
 
378
                      <td colspan="3" valign="top" class="tableheader" width="83">Tested </td> 
 
379
                      <td colspan="3" valign="top" class="tableheader" width="81">Positive Case </td>
 
380
                      <td colspan="3" valign="top" class="tableheader" width="83">Post test counseled</td>
 
381
                      <td colspan="3" valign="top" class="tableheader" width="86">HIV positive Referred</td>
 
382
                      </td> 
 
383
                      <td colspan="3" valign="top" class="tableheader" width="61">
 
384
                      Total</td>
 
385
                    </tr>
 
386
                    <tr>
 
387
                      <td width="19" height="23" valign="top" class="tableheader">M</td>                    
 
388
                      
 
389
                      <td width="23" valign="top" class="tableheader">F </td>                     
 
390
                      <td width="34" valign="top" class="tableheader">Total</td>                       
 
391
                      <td width="20" valign="top" class="tableheader">M</td>
 
392
                      <td width="23" valign="top" class="tableheader">F</td>
 
393
                      <td width="34" valign="top" class="tableheader">Total</td>
 
394
                      <td width="24" valign="top" class="tableheader">M</td>
 
395
                      <td width="18" valign="top" class="tableheader">F </td>
 
396
                      <td width="33" valign="top" class="tableheader">Total</td>
 
397
                      <td width="23" valign="top" class="tableheader">M</td>
 
398
                      <td width="21" valign="top" class="tableheader">F</td>
 
399
                      <td width="33" valign="top" class="tableheader">Total</td>
 
400
                      <td width="23" valign="top" class="tableheader">M</td>
 
401
                      <td width="19" valign="top" class="tableheader">F</td>
 
402
                      <td width="17" valign="top" class="tableheader">Total</td>
 
403
                      <td width="23" valign="top" class="tableheader">M</td>
 
404
                      <td width="22" valign="top" class="tableheader">F</td>
 
405
                      <td width="37" valign="top" class="tableheader">GT</td>
 
406
                    </tr>
 
407
                  <% for (int k=0;k<10;k++){%>
 
408
                    <tr bordercolor="#000000" class="tableitem">
 
409
                      <%if (k==10) {%><td width="58" height="32" valign="top" class="tableheader"><%=age[k]%>&nbsp;</td><%}%>
 
410
                      <%if (k!=10) {%><td width="58" height="32" valign="top" class="tableitem"><%=age[k]%>&nbsp;</td><%}%>
 
411
                      <%if (k==10) {%><td width="19" valign="top" class="tableheader"><%=pretestM[k]%>&nbsp;</td><%}%>
 
412
                      <%if (k!=10) {%><td width="19" valign="top" class="tableitem"><%=pretestM[k]%>&nbsp;</td><%}%>
 
413
                      <%if (k==10) {%><td width="23" valign="top" class="tableheader"><%=pretestF[k]%>&nbsp;</td><%}%>
 
414
                      <%if (k!=10) {%><td width="23" valign="top" class="tableitem"><%=pretestF[k]%>&nbsp;</td><%}%>
 
415
                      <%if (k==10) {%><td width="34" valign="top" class="tableheader"><%=pretestM[k]+pretestF[k]%>&nbsp;</td><%}%>
 
416
                      <%if (k!=10) {%><td width="34" valign="top" class="tableitem"><%=pretestM[k]+pretestF[k]%>&nbsp;</td><%}%>
 
417
                      <%if (k==10) {%><td width="20" valign="top" class="tableheader"><%=testM[k]%>&nbsp;</td><%}%>
 
418
                      <%if (k!=10) {%><td width="20" valign="top" class="tableitem"><%=testM[k]%>&nbsp;</td><%}%>
 
419
                      <%if (k==10) {%><td width="23" valign="top" class="tableheader"><%=testF[k]%>&nbsp;</td><%}%>
 
420
                      <%if (k!=10) {%><td width="23" valign="top" class="tableitem"><%=testF[k]%>&nbsp;</td><%}%>
 
421
                      <%if (k==10) {%><td width="34" valign="top" class="tableheader"><%=testM[k]+testF[k]%>&nbsp;</td><%}%>
 
422
                      <%if (k!=10) {%><td width="34" valign="top" class="tableitem"><%=testM[k]+testF[k]%>&nbsp;</td><%}%>
 
423
                      <%if (k==10) {%><td width="24" valign="top" class="tableheader"><%=positiveM[k]%>&nbsp;</td><%}%>
 
424
                      <%if (k!=10) {%><td width="24" valign="top" class="tableitem"><%=positiveM[k]%>&nbsp;</td><%}%>
 
425
                      <%if (k==10) {%><td width="18" valign="top" class="tableheader"><%=positiveF[k]%>&nbsp;</td><%}%>
 
426
                      <%if (k!=10) {%><td width="18" valign="top" class="tableitem"><%=positiveF[k]%>&nbsp;</td><%}%>
 
427
                      <%if (k==10) {%><td width="33" valign="top" class="tableheader"><%=positiveM[k]+positiveF[k]%>&nbsp;</td><%}%>
 
428
                      <%if (k!=10) {%><td width="33" valign="top" class="tableitem"><%=positiveM[k]+positiveF[k]%>&nbsp;</td><%}%>
 
429
                      <%if (k==10) {%><td width="23" valign="top" class="tableheader"><%=posttestM[k]%>&nbsp;</td><%}%>
 
430
                      <%if (k!=10) {%><td width="23" valign="top" class="tableitem"><%=posttestM[k]%>&nbsp;</td><%}%>
 
431
                      <%if (k==10) {%><td width="21" valign="top" class="tableheader"><%=posttestF[k]%>&nbsp;</td><%}%>
 
432
                      <%if (k!=10) {%><td width="21" valign="top" class="tableitem"><%=posttestF[k]%>&nbsp;</td><%}%>
 
433
                      <%if (k==10) {%><td width="33" valign="top" class="tableheader"><%=posttestM[k]+posttestF[k]%>&nbsp;</td><%}%>
 
434
                      <%if (k!=10) {%><td width="33" valign="top" class="tableitem"><%=posttestM[k]+posttestF[k]%>&nbsp;</td><%}%>
 
435
                      <%if (k==10) {%><td width="23" valign="top" class="tableheader"><%=HIVprM[k]%>&nbsp;</td><%}%>
 
436
                      <%if (k!=10) {%><td width="23" valign="top" class="tableitem"><%=HIVprM[k]%>&nbsp;</td><%}%>
 
437
                      <%if (k==10) {%><td width="19" valign="top" class="tableheader"><%=HIVprF[k]%>&nbsp;</td><%}%>
 
438
                      <%if (k!=10) {%><td width="19" valign="top" class="tableitem"><%=HIVprF[k]%>&nbsp;</td><%}%>
 
439
                      <%if (k==10) {%><td width="17" valign="top" class="tableheader"><%=HIVprM[k]+HIVprF[k]%>&nbsp;</td><%}%>
 
440
                      <%if (k!=10) {%><td width="17" valign="top" class="tableitem"><%=HIVprM[k]+HIVprF[k]%>&nbsp;</td><%}%>
 
441
                      <td width="23" valign="top" class="tableheader"><%=pretestM[k]+testM[k]+positiveM[k]+posttestM[k]+HIVprM[k]%></td>
 
442
                      <td width="22" valign="top" class="tableheader"><%=pretestF[k]+testF[k]+positiveF[k]+posttestF[k]+HIVprF[k]%></td>
 
443
                      <td width="37" valign="top" class="tableheader"><%=pretestM[k]+pretestF[k]+testM[k]+testF[k]+positiveM[k]+positiveF[k]+posttestM[k]+posttestF[k]+HIVprM[k]+HIVprF[k]%>&nbsp;</td>
 
444
                    </tr>
 
445
                                        <%}%>
 
446
                  </table>
 
447
              </tr>
 
448
              <tr> 
 
449
                <td height="1" valign="top"><table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#000066">
 
450
                    <!--DWLayoutTable-->
 
451
                                        
 
452
                
 
453
              </tr>
 
454
            </table></td>
 
455
        </tr>
 
456
      </table></td>
 
457
  </tr>
 
458
  <tr> 
 
459
                  </table></td>
 
460
              </tr>
 
461
              <tr>
 
462
                <td height="19"><p style="line-height: 100%"><b><i>
 
463
                <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;
 
464
                </font>
 
465
                </i>
 
466
                </b>
 
467
                </p>
 
468
                <p style="line-height: 100%"><b><i>
 
469
                <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; 
 
470
                Follow-up Counseling&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ANC</font></i></b></p>
 
471
                <p style="line-height: 100%"><b><i>
 
472
                <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;
 
473
                </font></i>
 
474
                </b><i>
 
475
                <font face="Tahoma"><b><font size="1" face="Tahoma">Orphanage&nbsp;
 
476
                </font> </b></font></i></p>
 
477
                <p style="line-height: 100%"><b><i>
 
478
                <font face="Tahoma" size="1"><font face="Tahoma">&nbsp; </font>
 
479
                <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; 
 
480
                Other (specify)</font></font></i></b></p>
 
481
                <p style="line-height: 100%"><b><i>
 
482
                <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;
 
483
                </font></i>
 
484
                </b><i>
 
485
                <b>
 
486
                <font size="1" face="Tahoma">Total</font></b></i></p>
 
487
                <p style="line-height: 100%"><b><i>
 
488
                <font face="Tahoma">&nbsp;&nbsp;</font></i></b></p>
 
489
    <td width="539" height="1"></td>
 
490
    <td height="1" width="19"></td>
 
491
  </tr>
 
492
</table>
 
493
</body>
 
494
</html>
 
 
b'\\ No newline at end of file'