← 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/Kerala/kform7b.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/Kerala/kform7b.jsp
 
1
 
 
2
<%@ page import="java.sql.*" %>
 
3
<%@ page import="com.opensymphony.xwork.util.OgnlValueStack" %>
 
4
 
 
5
 
 
6
<%
 
7
      Connection con=null;
 
8
      
 
9
      // for Performance in the Reporting Month
 
10
      Statement st=null;
 
11
      ResultSet rs=null;
 
12
      
 
13
      // for selected OrgUnit Name and Population
 
14
      Statement st1=null;
 
15
      ResultSet rs1=null;
 
16
      
 
17
      // for Performance in Corresponding month Last Year
 
18
      Statement st2=null;
 
19
      ResultSet rs2=null;
 
20
      
 
21
      // for Cumulative Performance till Current Month
 
22
      Statement st4=null;
 
23
      ResultSet rs4=null;
 
24
     
 
25
      // for Cumulative Performance till corresponding month of Last Year
 
26
      Statement st3=null;
 
27
      ResultSet rs3=null;
 
28
 
 
29
      // for Taluk Name and Id
 
30
      Statement st5=null;
 
31
      ResultSet rs5=null;
 
32
 
 
33
      // for District Name and Id
 
34
      Statement st6=null;
 
35
      ResultSet rs6=null;
 
36
 
 
37
     // for PHC Name and Id
 
38
      Statement st8=null;
 
39
      ResultSet rs8=null;
 
40
 
 
41
     // for CHC Name and Id
 
42
      Statement st9=null;
 
43
      ResultSet rs9=null;
 
44
 
 
45
     // for PHC Population Estimates
 
46
      Statement st10=null;
 
47
      ResultSet rs10=null;
 
48
 
 
49
     // for Data Period Start Date and End Date
 
50
      Statement st11=null;
 
51
      ResultSet rs11=null;
 
52
      
 
53
     // for DataElement ids based on DataElement code
 
54
      Statement st12=null;
 
55
      ResultSet rs12=null;
 
56
     
 
57
      
 
58
      String userName = "dhis";           
 
59
      String password = "";           
 
60
      String urlForConnection = "jdbc:mysql://localhost/kl_dhis2";
 
61
          
 
62
      int talukID = 0;
 
63
      String talukName = "";
 
64
      int districtID = 0; 
 
65
      String districtName = ""; 
 
66
      int CHCID = 0;
 
67
      String CHCName ="";
 
68
      int PHCID = 0;
 
69
      String PHCName ="";          
 
70
      int totPHCPopulation = -1;
 
71
      int totSCPopulation = -1;
 
72
 
 
73
          OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
 
74
          String selectedId = (String) stack.findValue( "orgUnitId" );
 
75
          int selectedOrgUnitID =         Integer.parseInt( selectedId );
 
76
        
 
77
      
 
78
          String startingDate  =  (String) stack.findValue( "startingPeriod" );
 
79
          String endingDate  =    (String) stack.findValue( "endingPeriod" );
 
80
 
 
81
          String monthlyPeriodId = (String) stack.findValue( "monthlyPeriodTypeId" );
 
82
          int periodTypeID =       Integer.parseInt( monthlyPeriodId );
 
83
 
 
84
               
 
85
          int lastYear = 0;
 
86
      
 
87
          String selectedOrgUnitName = "";
 
88
          String selectedDataPeriodStartDate = "";
 
89
          String selectedDataPeriodEndDate = "";
 
90
          String lastDataPeriodStartDate = "";
 
91
          
 
92
           String dataElementCodes[] = {
 
93
                                                                                "' '", "' '", "'Form6_DE1'", "'Form6_DE2'", "'Form6_DE3'", "' '","'FORM6_DE4 '",
 
94
                                                                                // REFERRED TO FRU
 
95
                                                                                "'FORM6_DE184'",
 
96
                                                                                
 
97
                                                                                "' '",
 
98
                                                                                "'Form6_DE5'", "'Form6_DE6'", "'Form6_DE7'", "'Form6_DE8'", 
 
99
                                                                                "'Form6_DE9'",
 
100
                                                                                 "' '", "'Form6_DE10'", "' '", "'Form6_DE11','Form6_DE12'", "'Form6_DE13'", "'Form6_DE14'", 
 
101
                                                                                "' '",
 
102
                                                                                "'FORM6_DE185'",
 
103
                                                                                "'Form6_DE15'", 
 
104
                                                                                "'Form6_DE16'",  "' '","' '", "'Form6_DE17'", "'Form6_DE18'", "'Form6_DE19'", "'Form6_DE20'",
 
105
                                                                                "' '", "' '", "'Form6_DE21'", "'Form6_DE22'", "'Form6_DE23'", "'Form6_DE24'", "'Form6_DE25'", "'Form6_DE26'", 
 
106
                                                                                "' '", "' '", "'Form6_DE29'", 
 
107
                                                                                "'Form6_DE30'", "'Form6_DE27'", "'Form6_DE28'", "'Form6_DE31'", "'Form6_DE32'", "' '", 
 
108
                                                                                
 
109
                                                                                "'Form6_DE33'", "'Form6_DE34'", "' '", 
 
110
                                                                                "'Form6_DE35'", "'Form6_DE36'", "'Form6_DE37'", "'Form6_DE38'", "'Form6_DE39'", "'Form6_DE42'", "'Form6_DE43'",
 
111
                                                                                "' '", "' '", "' '", "' '",
 
112
                                                                                 "'Form6_DE44'", "'Form6_DE45'", "'Form6_DE46'", "'Form6_DE47'", 
 
113
                                                                                "'Form6_DE48'", "'Form6_DE49'", "'Form6_DE50'", "'Form6_DE51'","' '","' '", "'Form6_DE52'", "'Form6_DE53'", 
 
114
                                                                                "'Form6_DE54'", "'Form6_DE55'",
 
115
                                                                                "'Form6_DE56'", "'Form6_DE57'", "'Form6_DE58'", "'Form6_DE59'", "'Form6_DE60'", "'Form6_DE61'", 
 
116
                                                                                "' '", "' '", "'Form6_DE62'",
 
117
                                                                                "'Form6_DE63'", "'Form6_DE64'", "'Form6_DE65'", "' '", "' '", "' '", "' '", "'Form6_DE66'", "'Form6_DE67'", "' '", "' '", "'Form6_DE68'", 
 
118
                                                                                "'Form6_DE69'", "' '", "' '", "'Form6_DE70'", "'Form6_DE71'","' '", "' '", "' '", "' '", "'Form6_DE72'", "'Form6_DE73'", "'Form6_DE74'", 
 
119
                                                                                "'Form6_DE75'",
 
120
                                                                                "'Form6_DE76'", "'Form6_DE77'","' '", "' '", "' '", "' '","' '", "' '", "'Form6_DE78'", "'Form6_DE79'",
 
121
                                                                                "'Form6_DE84'", "'Form6_DE85'","' '", "' '",
 
122
                                                                                "'Form6_DE86'", "'Form6_DE87'", 
 
123
                                                                                "'Form6_DE92'",
 
124
                                                                                "'Form6_DE93'","' '", "' '", 
 
125
                                                                                "'Form6_DE94'", "'Form6_DE95'",
 
126
                                                                                "'Form6_DE100'", "'Form6_DE101'","' '", "' '","'Form8_DE9.1diM'", "'Form8_DE9.1diF'","'Form8_DE9.1diiM'","'Form8_DE9.1diiF'","' '", "' '",
 
127
                                                                                "'Form8_DE9.1eiM'","'Form8_DE9.1eiF'","'Form8_DE9.1eiiM'","'Form8_DE9.1eiiF'","' '", "' '","'Form6_DE102'", "'Form6_DE103'",
 
128
                                                                                "'Form6_DE108'", "'Form6_DE109'", "' '", "' '", 
 
129
                                                                                "'Form6_DE110', 'Form6_DE112'", "'Form6_DE111', 'Form6_DE113'","'Form6_DE110'", "'Form6_DE111'", "'Form6_DE112'", "'Form6_DE113'", "'Form6_DE114'", 
 
130
                                                                                "'Form6_DE115'", 
 
131
 
 
132
                                                                                
 
133
                                                                                "' '", "' '",
 
134
                                                                                
 
135
                                                                                "'Form6_DE110'", "'Form6_DE111'","'Form6_DE116'", 
 
136
                                                                                "'Form6_DE117'",  
 
137
                                                                                "'Form6_DE118'", "'Form6_DE119'", "'Form6_DE120'", "'Form6_DE121'","' '", "' '", "'Form6_DE122'", "'Form6_DE123'",
 
138
                                                                                 "'Form6_DE124'", "'Form6_DE125'", "'Form6_DE126'", "'Form6_DE127'", "'Form6_DE128'", "'Form6_DE129'","' '",
 
139
                                                                                "'Form6_DE130'","' '","'Form8_DE1a'","'Form8_DE11.1b'", "'Form6_DE183'",  "'Form6_DE135'","'Form6_DE136'",  
 
140
                                                                                "'Form6_DE137', 'Form6_DE138'","' '", "'Form6_DE139'", "'Form6_DE140'","'Form6_DE141'", 
 
141
                                                                                
 
142
                                                                                "'Form6_DE142'", "'Form6_DE143'","' '", "'Form8_DE12a'", "'Form6_DE145'", "'Form6_DE146'", "'Form6_DE147'",
 
143
                                                                                "'Form6_DE148'"
 
144
                                                                                
 
145
                                                                                
 
146
                                                                           };
 
147
 
 
148
                 
 
149
        int dataElementIDs[] = new int[dataElementCodes.length+5];  
 
150
        int entryNumberValues[]=  new int[dataElementCodes.length+5];     
 
151
        int entryValuesForLastYear[]= new int[dataElementCodes.length+5];      
 
152
        int cumentryValuesForCurYear[]= new int[dataElementCodes.length+5];      
 
153
        int cumentryValuesForLastYear[]= new int[dataElementCodes.length+5];     
 
154
        
 
155
        String monthNames[] = { "", "January", "February", "March", "April", "May", "June", "July", "August", "September","October", "November", "December" };  
 
156
        
 
157
        String query = "";
 
158
%>
 
159
 
 
160
<%
 
161
     try
 
162
      {
 
163
        Class.forName ("com.mysql.jdbc.Driver").newInstance ();
 
164
        con = DriverManager.getConnection (urlForConnection, userName, password);
 
165
        
 
166
        st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
 
167
        st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
168
        st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
169
        st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
170
        st4=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
171
        st5=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
 
172
        st6=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
173
        st8=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
174
        st9=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
175
        st10=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
176
        st11=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
177
        st12=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
178
 
 
179
     
 
180
        //rs1 = st1.executeQuery("SELECT organisationunit.name FROM organisationunit WHERE id ="+selectedOrgUnitID);
 
181
        rs1 = st1.executeQuery("SELECT organisationunit.name FROM organisationunit WHERE organisationunitid ="+selectedOrgUnitID);        
 
182
        if(rs1.next())  {   selectedOrgUnitName = rs1.getString(1);       }
 
183
        else   {        selectedOrgUnitName = "";        }  
 
184
 
 
185
//      rs11 = st11.executeQuery("select startDate,endDate from period where id = "+selectedDataPeriodID);
 
186
//              if(rs11.next())
 
187
//                {
 
188
//                      selectedDataPeriodStartDate =  rs11.getDate(1).toString();
 
189
//                      selectedDataPeriodEndDate   =  rs11.getDate(2).toString();
 
190
//                }
 
191
 
 
192
                selectedDataPeriodStartDate = startingDate;
 
193
 
 
194
      } // try block end
 
195
     catch(Exception e)  { out.println("exception 1 -"+e.getMessage());  }
 
196
     finally
 
197
       {
 
198
                        try
 
199
                                {
 
200
                                        if(rs1!=null)  rs1.close();                     if(st1!=null)  st1.close();
 
201
                                        if(rs11!=null)  rs11.close();           if(st11!=null)  st11.close();
 
202
                                }
 
203
                        catch(Exception e)   {  out.println("exception 2 - "+e.getMessage());   }
 
204
       } // finally block end           
 
205
 
 
206
        String partsOfDataPeriodStartDate[]  =  selectedDataPeriodStartDate.split("-");
 
207
        lastYear  = Integer.parseInt(partsOfDataPeriodStartDate[0]) - 1;
 
208
        lastDataPeriodStartDate = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
 
209
        
 
210
        int tempForMonth1 = Integer.parseInt(partsOfDataPeriodStartDate[1]);
 
211
        int tempForYear = 0;
 
212
                
 
213
        if(tempForMonth1 < 4)           {   tempForYear = lastYear;  }
 
214
        else  {   tempForYear = lastYear + 1;           }
 
215
                         
 
216
        String curYearStart = tempForYear+"-04-01";
 
217
        String lastYearStart = (tempForYear-1)+"-04-01";
 
218
        String lastYearEnd = lastYear+"-"+partsOfDataPeriodStartDate[1]+"-"+partsOfDataPeriodStartDate[2];
 
219
         
 
220
    //for district, taluk, CHC names
 
221
    try
 
222
      {
 
223
           //     rs8=st8.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")");        
 
224
        //              if(rs8.next())  { PHCID = rs8.getInt(1);PHCName = rs8.getString(2);  } 
 
225
        //              else  {  PHCID = 0; PHCName = "";  } 
 
226
 
 
227
//                      rs9=st9.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")"); 
 
228
//                      if(rs9.next())  { CHCID = rs9.getInt(1);CHCName = rs9.getString(2);  } 
 
229
//                      else  {  CHCID = 0; CHCName = "";  } 
 
230
 
 
231
                        //rs5=st5.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")");
 
232
                        rs5=st5.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+selectedOrgUnitID+")");       
 
233
                        if(rs5.next())  { talukID = rs5.getInt(1); talukName = rs5.getString(2);  } 
 
234
                        else  {  talukID = 0; talukName = "";  } 
 
235
        
 
236
                    //rs6=st6.executeQuery("select organisationunit.id, organisationunit.name FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+talukID+")");
 
237
                    rs6=st6.executeQuery("select organisationunit.organisationunitid, organisationunit.name FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+talukID+")"); 
 
238
                    if(rs6.next()) {  districtID = rs6.getInt(1); districtName = rs6.getString(2);}
 
239
                        else {districtID = 0; districtName = "";}      
 
240
 
 
241
                        //rs10=st10.executeQuery("SELECT sum(datavalue.value) FROM organisationunit INNER JOIN (dataelement INNER JOIN datavalue ON dataelement.id = datavalue.dataElement) ON organisationunit.id = datavalue.source WHERE organisationunit.parent = "+PHCID+" AND dataelement.name like 'Total Population'");
 
242
                        rs10=st10.executeQuery("SELECT sum(datavalue.value) FROM organisationunit INNER JOIN (dataelement INNER JOIN datavalue ON dataelement.dataelementid = datavalue.dataelementid) ON organisationunit.organisationunitid = datavalue.sourceid WHERE organisationunit.parentid = "+PHCID+" AND dataelement.name like 'Total Population'");
 
243
                        if(rs10.next()) { totPHCPopulation = rs10.getInt(1);}
 
244
                        else {totPHCPopulation = 0;}      
 
245
       
 
246
       }   // try block end              
 
247
     catch(Exception e)  { out.println(e.getMessage());  }
 
248
     finally
 
249
       {
 
250
                 try
 
251
                          {
 
252
                            if(rs5!=null)  rs5.close();                 if(st5!=null)  st5.close();
 
253
                            if(rs6!=null)  rs6.close();                 if(st6!=null)  st6.close();
 
254
                            if(rs8!=null)  rs8.close();                 if(st8!=null)  st8.close();   
 
255
                            if(rs9!=null)  rs9.close();                 if(st9!=null)  st9.close();
 
256
                            if(rs10!=null)  rs10.close();                       if(st10!=null)  st10.close();                                                                                                                
 
257
                          }
 
258
                catch(Exception e)   {  out.println(e.getMessage());   }
 
259
       }  // finally block end
 
260
    
 
261
     try
 
262
      {
 
263
                int i=0;    
 
264
                int j= dataElementCodes.length;
 
265
                        
 
266
                while(i!=j)
 
267
                        {
 
268
                                //rs12 = st12.executeQuery("select id from dataelement where code in ("+dataElementCodes[i]+")");
 
269
                                rs12 = st12.executeQuery("select dataelementid from dataelement where code in ("+dataElementCodes[i]+")");
 
270
                                if(rs12.next())         {   dataElementIDs[i] = rs12.getInt(1); }
 
271
                        else { dataElementIDs[i] = 0; }
 
272
                
 
273
                                entryNumberValues[i]     = -1;
 
274
                                entryValuesForLastYear[i] = -1;
 
275
                                cumentryValuesForCurYear[i] = -1;
 
276
                                cumentryValuesForLastYear[i] = -1;
 
277
                                                        
 
278
                                if(dataElementIDs[i]!=0)
 
279
                                        {
 
280
                                                // for Performance in the reporting month  FOR BLOCK PHC ( CONSOLIDATAION OF ALL PHCs)
 
281
                                                //query = "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 '"+startingDate+"' and '"+startingDate+"') AND datavalue.source in (select id from organisationunit where id = "+selectedOrgUnitID+" OR id  in (select id from organisationunit where parent = "+selectedOrgUnitID+") OR parent in (select id from organisationunit where parent = "+selectedOrgUnitID+"))  AND dataelement.code in ("+dataElementCodes[i]+")";
 
282
                                                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 organisationunitid = "+selectedOrgUnitID+" OR organisationunitid  in (select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+") OR parentid in (select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+"))  AND dataelement.code in ("+dataElementCodes[i]+")";     
 
283
                                                rs=st.executeQuery(query);                                              
 
284
                                            if(rs.next())  {  entryNumberValues[i] = rs.getInt(1);  } 
 
285
                                                else  {  entryNumberValues[i] = 0;  } 
 
286
                                                
 
287
                                                // for Performance in Corresponding month Last Year
 
288
                                                //query = "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 '"+lastYearEnd+"' and '"+lastYearEnd+"') AND datavalue.source in (select id from organisationunit where id = "+selectedOrgUnitID+" OR id  in (select id from organisationunit where parent = "+selectedOrgUnitID+") OR parent in (select id from organisationunit where parent = "+selectedOrgUnitID+"))  AND dataelement.code in ("+dataElementCodes[i]+")";
 
289
                                                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 '"+lastYearEnd+"' and '"+lastYearEnd+"') AND datavalue.sourceid in (select organisationunitid from organisationunit where organisationunitid = "+selectedOrgUnitID+" OR organisationunitid  in (select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+") OR parentid in (select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+"))  AND dataelement.code in ("+dataElementCodes[i]+")";       
 
290
                                        rs2=st2.executeQuery(query);
 
291
                                        //select value from datavalue where dataElement ="+dataElementIDs[i]+" and source= "+selectedOrgUnitID+" and period in (select id from period where startdate like '"+lastYearEnd+"' and periodType = "+periodTypeID+" )"); 
 
292
                                if(rs2.next())  {  entryValuesForLastYear[i] = rs2.getInt(1);  } 
 
293
                                    else  {  entryValuesForLastYear[i] = 0;  } 
 
294
                                        
 
295
                                    // for Cumulative Performance till Current Month
 
296
                                    //query = "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 datavalue.source in (select id from organisationunit where id = "+selectedOrgUnitID+" OR id  in (select id from organisationunit where parent = "+selectedOrgUnitID+") OR parent in (select id from organisationunit where parent = "+selectedOrgUnitID+"))  AND dataelement.code in ("+dataElementCodes[i]+")";
 
297
                                    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 '"+selectedDataPeriodStartDate+"') AND datavalue.sourceid in (select organisationunitid from organisationunit where organisationunitid = "+selectedOrgUnitID+" OR organisationunitid  in (select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+") OR parentid in (select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+"))  AND dataelement.code in ("+dataElementCodes[i]+")";  
 
298
                                    rs4=st4.executeQuery(query);
 
299
                                    //"select sum(value) from datavalue where dataElement ="+dataElementIDs[i]+" and source in (select id from organisationunit where parent ="+selectedOrgUnitID+")  and period in (select id from period where startdate between '"+curYearStart+"' and '"+selectedDataPeriodStartDate+"' and periodType = "+periodTypeID+")");                                  
 
300
                                        if(rs4.next())  {  cumentryValuesForCurYear[i]= rs4.getInt(1);  } 
 
301
                                    else  {  cumentryValuesForCurYear[i] = 0;  } 
 
302
                                    
 
303
                                    // for Cumulative Performance till corresponding month of Last Year
 
304
                                    //query = "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 '"+lastYearStart+"' and '"+lastYearEnd+"') AND datavalue.source in (select id from organisationunit where id = "+selectedOrgUnitID+" OR id  in (select id from organisationunit where parent = "+selectedOrgUnitID+") OR parent in (select id from organisationunit where parent = "+selectedOrgUnitID+"))  AND dataelement.code in ("+dataElementCodes[i]+")";
 
305
                                    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 '"+lastYearStart+"' and '"+lastYearEnd+"') AND datavalue.sourceid in (select organisationunitid from organisationunit where organisationunitid = "+selectedOrgUnitID+" OR organisationunitid  in (select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+") OR parentid in (select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+"))  AND dataelement.code in ("+dataElementCodes[i]+")"; 
 
306
                                    rs3=st3.executeQuery(query);
 
307
                                    //"select sum(value) from datavalue where dataElement ="+dataElementIDs[i]+" and source in (select id from organisationunit where parent ="+selectedOrgUnitID+")  and period in (select id from period where startdate between '"+lastYearStart+"' and '"+lastYearEnd+"' and periodType = "+periodTypeID+")");                                  
 
308
                                            if(rs3.next())  {  cumentryValuesForLastYear[i]= rs3.getInt(1);  } 
 
309
                                        else  {  cumentryValuesForLastYear[i] = 0;  }                                                                                   
 
310
                                        } // if block end               
 
311
                                i++;
 
312
                        }  // while loop end
 
313
      }  // try block end                
 
314
     catch(Exception e)  { out.println(e.getMessage());  }
 
315
     finally
 
316
       {
 
317
                         try
 
318
                                {
 
319
                                    if(rs!=null)  rs.close();           if(st!=null)  st.close();                                                       
 
320
                                        if(rs2!=null)  rs2.close();             if(st2!=null)  st2.close();    
 
321
                                        if(rs3!=null)  rs3.close();             if(st3!=null)  st3.close();                                     
 
322
                                        if(rs4!=null)  rs4.close();             if(st4!=null)  st4.close();
 
323
                                        if(rs12!=null)  rs12.close();           if(st12!=null)  st12.close();
 
324
                                                                                
 
325
                                        if(con!=null) con.close();                                      
 
326
                        }        
 
327
                        catch(Exception e)   {  out.println(e.getMessage());   }
 
328
       }  // finally block end                                  
 
329
%>
 
330
 
 
331
<HTML>
 
332
<HEAD>
 
333
   <TITLE>REPORT OF MEDICAL OFFICER</TITLE>
 
334
   <script src="../dhis-web-reports/Kerala/KDENamesForForm7.js" type="text/javascript" language="Javascript"></script>  
 
335
   <script>
 
336
                function fun1()
 
337
                { 
 
338
                    
 
339
                        var start=0;
 
340
                        var end = 28;    
 
341
                        var j=1;
 
342
                        var k=0;                
 
343
                        var id="";                      
 
344
                
 
345
                        while(j<=5)
 
346
                         {                          
 
347
                                
 
348
                                if(j==1) end = 13;
 
349
                                        else if(j==2) end = 28;
 
350
                                        else if(j==3) end = 29;
 
351
                                        else if(j==4) end = 29;
 
352
                                        else if(j==5) end = 25;
 
353
 
 
354
                                        for(start=0;start<=end;start++)
 
355
                                         {      
 
356
                                                id="cell1"+k;                                     
 
357
                                                document.getElementById(id).innerHTML = slnoForForm7[k];
 
358
                                                id="cell2"+k;                                     
 
359
                                                document.getElementById(id).innerHTML = denamesForForm7[k];
 
360
                                                k++;
 
361
                                         }
 
362
                                        j++; 
 
363
                                 }                                                              
 
364
                        }
 
365
        </script>                   
 
366
</HEAD>
 
367
<BODY BGCOLOR="#FFFFFF" onload="fun1()">
 
368
        <font face="Arial" size="2">(To be submitted by 20th of following month to District Family Welfare Officer For DataEntry in NIC-District Computer)</font><BR><br>
 
369
        <center>
 
370
                <font face="Arial" size="3">
 
371
                        <b>FORM 7<BR>MONTHLY REPORT FROM BLOCK PHC / URBAN DISPENSARY TO DISTRICT<BR>(REPORT OF MEDICAL OFFICER)</b>
 
372
                </font>
 
373
        </center>
 
374
        <br>
 
375
        
 
376
        <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">
 
377
                <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%">
 
378
                <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">
 
379
                        <font face="Arial" size="2">1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;State &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp; &nbsp;&nbsp;&nbsp;KERALA </font>
 
380
                </td>
 
381
                <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">
 
382
                        <font face="Arial" size="2">6.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Reporting for the month of :&nbsp;&nbsp;<%=monthNames[Integer.parseInt(partsOfDataPeriodStartDate[1])]%> - <%=partsOfDataPeriodStartDate[0]%></font>
 
383
                </td>   
 
384
                </tr>
 
385
                <tr>
 
386
                <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">
 
387
                        <font face="Arial" size="2">2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;District &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp; &nbsp;&nbsp;&nbsp;<%=districtName%></font>
 
388
                </td>
 
389
                <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">
 
390
                        <font face="Arial" size="2">7.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Eligible couples (as on 1st April of the year) :</font>
 
391
                </td>
 
392
                </tr>
 
393
                <tr>
 
394
                <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">
 
395
                        <font face="Arial" size="2">3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Block PHC &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<%=selectedOrgUnitName %></font>
 
396
                </td>
 
397
                <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"></td>
 
398
                </tr>
 
399
                <tr>
 
400
                <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" width="100%" height="19">
 
401
                        <font face="Arial" size="2">5.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Population of Block PHC :&nbsp;&nbsp;&nbsp;&nbsp;<%=totPHCPopulation%></font>
 
402
                </td>
 
403
                <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" width="100%" height="19"></td>
 
404
                </tr> 
 
405
                </table>  
 
406
<br><br>
 
407
<font face="Arial" size="3"><b>II.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Services</b></font><br>
 
408
<br>
 
409
<%
 
410
        int i;
 
411
        int j = 1;
 
412
        int k = 0;
 
413
        int l = 0;
 
414
        int endcount = 28;
 
415
        int flag = 0;
 
416
        String tempForentryNumberValues1 = "";
 
417
        String tempForentryNumberValues2 = "";
 
418
        String tempForentryValuesForLastYear1 = "";
 
419
        String tempForentryValuesForLastYear2 = "";
 
420
        String tempForcumentryValuesForCurYear1 = "";
 
421
        String tempForcumentryValuesForCurYear2 = "";
 
422
        String tempForcumentryValuesForLastYear1 = "";
 
423
        String tempForcumentryValuesForLastYear2 = "";
 
424
                        
 
425
        String temp1 = "";
 
426
        
 
427
        String temp2 = "";
 
428
        
 
429
        int temp = 0;
 
430
        while(j<=5)
 
431
         { 
 
432
            if(flag == 0) 
 
433
              { %>
 
434
                <table cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1;padding: 0" bordercolor="#111111" width="100%">
 
435
                                <tr>
 
436
                                <td width="3%" style="border-collapse: collapse; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1;padding: 0" bordercolor="#111111" width="100%" align="center"><font face="Arial" size="2">Sl. No.</font></td>
 
437
                                <td width="50%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:15; padding-right:0; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center"><font face="Arial" size="2">Services</font></td>
 
438
                                <td width="10%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center"  colspan="2"><font face="Arial" size="2">Performance in corresponding month last year</font></td>
 
439
                                <td width="10%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center"  colspan="2"><font face="Arial" size="2">Performance in the reporting month</font></td>
 
440
                                <td width="10%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center"  colspan="2"><font face="Arial" size="2">Cumulative performance till corresponding month of last year</font></td>
 
441
                                <td width="10%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center"  colspan="2"><font face="Arial" size="2">Cumulative performance till current month</font></td>
 
442
                                <td width="7%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center"><font face="Arial" size="2">Planned performance in current year</font></td>
 
443
                                </tr>
 
444
                   <%   
 
445
               flag = 1;
 
446
               }
 
447
            else
 
448
              { %>
 
449
                <br>
 
450
                        <table cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1;padding: 0" bordercolor="#111111" width="100%">  
 
451
              <%}   
 
452
               
 
453
                
 
454
                if(j==1) endcount = 13; 
 
455
                else if(j==2) endcount = 28; 
 
456
                else if(j==3) endcount = 29;
 
457
                else if(j==4) endcount = 29;
 
458
                else if(j==5) endcount = 25;
 
459
                else endcount = 28;
 
460
                for(i=0;i<=endcount;i++)
 
461
                {       
 
462
             String id1="cell1"+k;
 
463
             String id2="cell2"+k;
 
464
            
 
465
             if((k>=24 && k<=35) || (k>=43 && k<=107))
 
466
              { 
 
467
                  if(k==24 || k==43) 
 
468
                    {
 
469
                      tempForentryNumberValues1= "<B>M</B>";
 
470
                      tempForentryValuesForLastYear1 = "<B>M</B>";
 
471
                      tempForcumentryValuesForLastYear1 = "<B>M</B>";
 
472
                      tempForcumentryValuesForCurYear1 = "<B>M</B>";
 
473
                      
 
474
                      tempForentryNumberValues2 = "<B>F</B>";
 
475
                      tempForentryValuesForLastYear2 = "<B>F</B>";
 
476
                      tempForcumentryValuesForLastYear2 = "<B>F</B>";
 
477
                      tempForcumentryValuesForCurYear2 = "<B>F</B>";                                                  
 
478
                    }
 
479
                 else if( k==-1)
 
480
                   {
 
481
                                temp = entryNumberValues[l] + entryNumberValues[l+1];
 
482
                                if(temp==0) tempForentryNumberValues1 = "";
 
483
                                else tempForentryNumberValues1 = ""+temp;
 
484
                                
 
485
                                temp = entryValuesForLastYear[l] + entryValuesForLastYear[l+1];
 
486
                                if(temp==0) tempForentryValuesForLastYear1 = "";
 
487
                                else tempForentryValuesForLastYear1 = ""+temp;
 
488
                                                                
 
489
                                temp = cumentryValuesForLastYear[l] + cumentryValuesForLastYear[l+1];
 
490
                                if(temp==0) tempForcumentryValuesForLastYear1 = "";
 
491
                                else tempForcumentryValuesForLastYear1 = ""+temp;
 
492
 
 
493
                                temp = cumentryValuesForCurYear[l] + cumentryValuesForCurYear[l+1];
 
494
                                if(temp==0) tempForcumentryValuesForCurYear1 = "";
 
495
                                else tempForcumentryValuesForCurYear1 = ""+temp;
 
496
 
 
497
                                //temp = dataElementIDs[l] + dataElementIDs[l+1];
 
498
                                //if(temp==0) temp1 = "";
 
499
                                //else temp1 = ""+temp;
 
500
                                
 
501
                                l = l+2;
 
502
                                
 
503
                                temp = entryNumberValues[l] + entryNumberValues[l+1];
 
504
                    if(temp==0) tempForentryNumberValues2 = "";
 
505
                    else tempForentryNumberValues2 = ""+temp;
 
506
                    
 
507
                    temp = entryValuesForLastYear[l] + entryValuesForLastYear[l+1];
 
508
                    if(temp==0) tempForentryValuesForLastYear2 = "";
 
509
                    else tempForentryValuesForLastYear2 = ""+temp;                  
 
510
 
 
511
                                temp = cumentryValuesForLastYear[l] + cumentryValuesForLastYear[l+1];
 
512
                                if(temp==0) tempForcumentryValuesForLastYear2 = "";
 
513
                                else tempForcumentryValuesForLastYear2 = ""+temp;
 
514
 
 
515
                                temp = cumentryValuesForCurYear[l] + cumentryValuesForCurYear[l+1];
 
516
                                if(temp==0) tempForcumentryValuesForCurYear2 = "";
 
517
                                else tempForcumentryValuesForCurYear2 = ""+temp;
 
518
 
 
519
                                //temp = dataElementIDs[l] + dataElementIDs[l+1];
 
520
                                //if(temp==0) temp2 = "";
 
521
                                //else temp2 = ""+temp;
 
522
                                
 
523
                                l = l+2;                                    
 
524
                   } // if block end
 
525
                  else
 
526
                    {
 
527
                                temp = entryNumberValues[l];
 
528
                                                if(temp==-1) tempForentryNumberValues1 = "";
 
529
                                else tempForentryNumberValues1 = ""+temp;
 
530
//tempForentryNumberValues1 = dataElementCodes[l];
 
531
 
 
532
                      
 
533
                                temp = entryValuesForLastYear[l];
 
534
                                if(temp==-1) tempForentryValuesForLastYear1 = "";
 
535
                                else tempForentryValuesForLastYear1 = ""+temp;
 
536
 
 
537
                                temp = cumentryValuesForLastYear[l];
 
538
                                if(temp==-1) tempForcumentryValuesForLastYear1 = "";
 
539
                                else tempForcumentryValuesForLastYear1 = ""+temp;
 
540
                     
 
541
                                temp = cumentryValuesForCurYear[l];
 
542
                                if(temp==-1) tempForcumentryValuesForCurYear1 = "";
 
543
                                else tempForcumentryValuesForCurYear1 = ""+temp;
 
544
 
 
545
                                 //temp = dataElementIDs[l];
 
546
                                //if(temp==0) temp1 = "";
 
547
                                //else temp1 = ""+temp;
 
548
 
 
549
                                 l++;   
 
550
                     
 
551
                                 temp = entryNumberValues[l];
 
552
                                 if(temp==-1) tempForentryNumberValues2 = "";
 
553
                                 else tempForentryNumberValues2 = ""+temp;
 
554
//tempForentryNumberValues2 = dataElementCodes[l];
 
555
 
 
556
                     
 
557
                                 temp = entryValuesForLastYear[l];
 
558
                                 if(temp==-1) tempForentryValuesForLastYear2 = "";
 
559
                                 else tempForentryValuesForLastYear2 = ""+temp;
 
560
                     
 
561
                                 temp = cumentryValuesForLastYear[l];
 
562
                                 if(temp==-1) tempForcumentryValuesForLastYear2 = "";
 
563
                                 else tempForcumentryValuesForLastYear2 = ""+temp;
 
564
 
 
565
                                 temp = cumentryValuesForCurYear[l];
 
566
                                 if(temp==-1) tempForcumentryValuesForCurYear2 = "";
 
567
                                 else tempForcumentryValuesForCurYear2 = ""+temp;                    
 
568
                     
 
569
                                //temp = dataElementIDs[l];
 
570
                                //if(temp==0) temp2 = "";
 
571
                                 //else temp2 = ""+temp;
 
572
                                 
 
573
                                 l++;
 
574
 
 
575
                    }  // else block end
 
576
                %>
 
577
                <tr>
 
578
                        <td id="<%=id1%>" name="<%=id1%>" width="3%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="left"></td>
 
579
                        <td id="<%=id2%>" name="<%=id2%>" width="50%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%"></td>
 
580
                        <td width="5%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center"><font face="Arial" size="2"><%=tempForentryValuesForLastYear1%></font></td>
 
581
                        <td width="5%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center"><font face="Arial" size="2"><%=tempForentryValuesForLastYear2%></font></td>
 
582
                        <td width="5%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center"><font face="Arial" size="2"><%=tempForentryNumberValues1%></font></td>
 
583
                        <td width="5%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center"><font face="Arial" size="2"><%=tempForentryNumberValues2%></font></td>
 
584
                        <td width="5%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center"><font face="Arial" size="2"><%=tempForcumentryValuesForLastYear1%></font></td>
 
585
                        <td width="5%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center"><font face="Arial" size="2"><%=tempForcumentryValuesForLastYear2%></font></td>
 
586
                        <td width="5%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center"><font face="Arial" size="2"><%=tempForcumentryValuesForCurYear1%></font></td>
 
587
                        <td width="5%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center"><font face="Arial" size="2"><%=tempForcumentryValuesForCurYear2%></font></td>
 
588
                        <td width="7%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center">&nbsp;</td>
 
589
                        </tr>
 
590
           <%   }
 
591
             else
 
592
              {  
 
593
               if(k==-2)
 
594
                 {
 
595
                  temp = entryNumberValues[l] + entryNumberValues[l+1];
 
596
                  if(temp==0) tempForentryNumberValues1 = "";
 
597
                  else tempForentryNumberValues1 = ""+temp;
 
598
                  
 
599
              temp = entryValuesForLastYear[l] + entryValuesForLastYear[l+1];
 
600
                  if(temp==0) tempForentryValuesForLastYear1 = "";
 
601
                  else tempForentryValuesForLastYear1 = ""+temp;
 
602
                  
 
603
                          temp = cumentryValuesForLastYear[l] + cumentryValuesForLastYear[l+1];
 
604
                          if(temp==0) tempForcumentryValuesForLastYear1 = "";
 
605
                          else tempForcumentryValuesForLastYear1 = ""+temp;
 
606
                  
 
607
                          temp = cumentryValuesForCurYear[l] + cumentryValuesForCurYear[l+1];
 
608
                          if(temp==0) tempForcumentryValuesForCurYear1 = "";
 
609
                          else tempForcumentryValuesForCurYear1 = ""+temp;
 
610
                  
 
611
              //temp = dataElementIDs[l] + dataElementIDs[l+1];
 
612
              //if(temp==0) temp1 = "";
 
613
                          //else temp1 = ""+temp;
 
614
                          
 
615
                          l = l+2;                                
 
616
                 } 
 
617
               else 
 
618
                {
 
619
                 temp =  entryNumberValues[l];
 
620
                 if(temp==-1) tempForentryNumberValues1 = "";
 
621
                 else tempForentryNumberValues1 = ""+temp;
 
622
//tempForentryNumberValues1 = dataElementCodes[l];
 
623
                 
 
624
                 
 
625
                 temp = entryValuesForLastYear[l];
 
626
                 if(temp==-1) tempForentryValuesForLastYear1 = "";
 
627
                 else tempForentryValuesForLastYear1 = ""+temp;
 
628
                 
 
629
                         temp = cumentryValuesForLastYear[l];
 
630
                         if(temp==-1) tempForcumentryValuesForLastYear1 = "";
 
631
                         else tempForcumentryValuesForLastYear1 = ""+temp;
 
632
 
 
633
                         temp = cumentryValuesForCurYear[l];
 
634
                         if(temp==-1) tempForcumentryValuesForCurYear1 = "";
 
635
                         else tempForcumentryValuesForCurYear1 = ""+temp;
 
636
                 
 
637
                        //temp = dataElementIDs[l];
 
638
                        //if(temp==0) temp1 = "";
 
639
                        //else temp1 = ""+temp;
 
640
 
 
641
                         l++;
 
642
                }  
 
643
               %>
 
644
                <tr>
 
645
                        <td id="<%=id1%>" name="<%=id1%>" width="3%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="left">&nbsp;</td>
 
646
                        <td id="<%=id2%>" name="<%=id2%>" width="50%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%"></td>
 
647
                        <td width="10%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center" colspan="2"><font face="Arial" size="2"><%=tempForentryValuesForLastYear1%></font></td>
 
648
                        <td width="10%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center" colspan="2"><font face="Arial" size="2"><%=tempForentryNumberValues1%></font></td>
 
649
                        <td width="10%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center" colspan="2"><font face="Arial" size="2"><%=tempForcumentryValuesForLastYear1%></font></td>
 
650
                        <td width="10%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center" colspan="2"><font face="Arial" size="2"><%=tempForcumentryValuesForCurYear1%></font></td>
 
651
                                <td width="7%" style="border-style:solid; border-width:1; border-collapse: collapse; padding-left:3; padding-right:3; padding-top:0; padding-bottom:0" bordercolor="#111111" width="100%" align="center"></td>
 
652
                        </tr>
 
653
                <% 
 
654
             }                     
 
655
                 k++;
 
656
                }               
 
657
                 j++;
 
658
                %>
 
659
                </table>
 
660
                <%
 
661
         }      
 
662
 %>
 
663
</BODY>
 
664
</HTML>
 
 
b'\\ No newline at end of file'