← 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/Jharkhand/jnlep-p.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/Jharkhand/jnlep-p.jsp
 
1
<%@ page import="java.sql.*" %>
 
2
<%@ page import="com.opensymphony.xwork.util.OgnlValueStack" %>
 
3
<%@ page session="true"%>
 
4
 
 
5
<%
 
6
    Connection con=null;
 
7
            
 
8
    // For finding organisationunit name of selected Orgunit based on Orgunit id
 
9
    Statement st1=null;
 
10
    ResultSet rs1=null;
 
11
      
 
12
    // For finding start date of selected period based on period id
 
13
    Statement st2=null;
 
14
    ResultSet rs2=null;
 
15
    
 
16
    //For finding monthly values
 
17
    Statement st3=null;
 
18
    ResultSet rs3=null;
 
19
    
 
20
    //For finding cumulative values
 
21
    Statement st4=null;
 
22
    ResultSet rs4=null;
 
23
    
 
24
    //For finding blockphc name and id 
 
25
    Statement st5=null;
 
26
    ResultSet rs5=null;
 
27
    
 
28
    //For finding taluk name and id
 
29
    Statement st6=null;
 
30
    ResultSet rs6=null;
 
31
    
 
32
    //For finding district name and id
 
33
    Statement st7=null;
 
34
    ResultSet rs7=null;
 
35
    
 
36
    //For finding state name and id
 
37
    Statement st8=null;
 
38
    ResultSet rs8=null;
 
39
    
 
40
    String userName = "dhis";      
 
41
    String password = "";           
 
42
    String urlForConnection = "jdbc:mysql://localhost/jh_dhis2";
 
43
          
 
44
 
 
45
        OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
 
46
 
 
47
        String selectedId = (String) stack.findValue( "orgUnitId" );
 
48
        int selectedOrgUnitID = Integer.parseInt( selectedId );
 
49
        
 
50
//      String selectedPeriodId = (String) stack.findValue( "periodSelect" );
 
51
//      int selectedDataPeriodID =      Integer.parseInt( selectedPeriodId );
 
52
 
 
53
        String startingDate  = (String) stack.findValue( "startingPeriod" );
 
54
        String endingDate  = (String) stack.findValue( "endingPeriod" );
 
55
 
 
56
      
 
57
        String monthlyPeriodId = (String) stack.findValue( "monthlyPeriodTypeId" );
 
58
        int periodTypeID = Integer.parseInt( monthlyPeriodId );
 
59
 
 
60
      
 
61
        String selectedOrgUnitName = "";        
 
62
        String selectedDataPeriodStartDate = "";
 
63
                        
 
64
        String monthlyDataElements[] = {
 
65
                                                                                        "Lep_DE1",
 
66
                                                                                        "Lep_DE2",
 
67
                                                                                        "Lep_DE3",
 
68
                                                                                        "Lep_DE4",
 
69
                                                                                        "Lep_DE5",
 
70
                                                                                        "Lep_DE6",
 
71
                                                                                        "Lep_DE7",
 
72
                                                                                        "Lep_DE8",
 
73
                                                                                        "Lep_DE9",
 
74
                                                                                        "Lep_DE10",
 
75
                                                                                        
 
76
                                                                                        "Lep_DE11",
 
77
                                                                                        "Lep_DE12",
 
78
                                                                                        "Lep_DE13",
 
79
                                                                                        "Lep_DE14",
 
80
                                                                                        "Lep_DE15",
 
81
                                                                                        "",
 
82
                                                                                };
 
83
                                        
 
84
          int monthlyValues[] = new int[17];            
 
85
          int cumulativeValues[] =  new int[17];
 
86
          
 
87
          int CHCID=0;
 
88
          int TalukID=0;
 
89
          int DistrictID=0;
 
90
          int StateID=0;
 
91
          
 
92
          String CHCName="";
 
93
          String TalukName = "";
 
94
          String  DistrictName = "";
 
95
          String StateName = "";
 
96
 
 
97
          int j=1;       
 
98
          int i=1;       
 
99
          int k=0;       
 
100
          int endcount = 0;
 
101
          int p = 0;     
 
102
          int q = 0;
 
103
        
 
104
          String monthNames[] = { "", "January", "February", "March", "April", "May", "June", "July", "August", "September",
 
105
                                                                        "October", "November", "December" };    
 
106
%>
 
107
 
 
108
<%
 
109
 
 
110
     try
 
111
      {
 
112
                Class.forName ("com.mysql.jdbc.Driver").newInstance ();
 
113
                con = DriverManager.getConnection (urlForConnection, userName, password);
 
114
        
 
115
                st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
116
                st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
117
                st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
118
                st4=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
119
                st5=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
120
                st6=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
121
                st7=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
122
                st8=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);    
 
123
                
 
124
                //rs1 = st1.executeQuery("select shortname from organisationunit  where id = "+selectedOrgUnitID);
 
125
                rs1 = st1.executeQuery("select shortname from organisationunit  where organisationunitid = "+selectedOrgUnitID);        
 
126
                if(rs1.next())        {  selectedOrgUnitName = rs1.getString(1);      }
 
127
                
 
128
//              rs2 = st2.executeQuery("select startDate from period where id = "+selectedDataPeriodID);
 
129
//                      if(rs2.next())    {  selectedDataPeriodStartDate =  rs2.getDate(1).toString();  }                 
 
130
 
 
131
                        selectedDataPeriodStartDate = startingDate;
 
132
 
 
133
                                                
 
134
                        //rs7=st7.executeQuery("select organisationunit.id, organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")");
 
135
                        rs7=st7.executeQuery("select organisationunit.organisationunitid, organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+selectedOrgUnitID+")");  
 
136
                        if(rs7.next())  { DistrictID = rs7.getInt(1);DistrictName = rs7.getString(2);  } 
 
137
                        else  {  DistrictID = 0; DistrictName = "";  } 
 
138
 
 
139
                        //rs8=st8.executeQuery("select organisationunit.id, organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+DistrictID+")");
 
140
                        rs8=st8.executeQuery("select organisationunit.organisationunitid, organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+DistrictID+")"); 
 
141
                        if(rs8.next())  { StateID = rs8.getInt(1);StateName = rs8.getString(2);  } 
 
142
                        else  {  StateID = 0; StateName = "";  } 
 
143
 
 
144
      } //try block end
 
145
      catch(Exception e)  { out.println(e.getMessage());  }
 
146
      
 
147
     String partsOfDataPeriodStartDate[] = selectedDataPeriodStartDate.split("-");
 
148
     int lastYear = Integer.parseInt(partsOfDataPeriodStartDate[0]) - 1;
 
149
     int tempForMonth1 = Integer.parseInt(partsOfDataPeriodStartDate[1]);
 
150
     int tempForYear = 0;
 
151
     if(tempForMonth1 < 4){   tempForYear = lastYear;  }
 
152
     else  {   tempForYear = lastYear + 1;      }
 
153
     String curYearStart=tempForYear+"-04-01";
 
154
                
 
155
    try
 
156
     {     
 
157
        for(i=0;i<15;i++)         
 
158
                        {         
 
159
                                //rs3 = st3.executeQuery("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 ="+selectedOrgUnitID+" AND dataelement.code like '"+monthlyDataElements[i]+"'");
 
160
                                rs3 = st3.executeQuery("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 ="+selectedOrgUnitID+" AND dataelement.code like '"+monthlyDataElements[i]+"'");                                           
 
161
                        if(rs3.next())          {  monthlyValues[i] =  rs3.getInt(1);   }  
 
162
                                        
 
163
                                //rs4 = st4.executeQuery(" select sum(value) from datavalue where dataElement in (select id from dataelement where code like '"+monthlyDataElements[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+")");
 
164
                                rs4 = st4.executeQuery(" select sum(value) from datavalue where dataElement in (select dataelementid from dataelement where code like '"+monthlyDataElements[i]+"') and sourceid in (select organisationunitid from organisationunit where parentid ="+selectedOrgUnitID+") and periodid in (select periodid from period where startdate between '"+curYearStart+"' and '"+selectedDataPeriodStartDate+"' and periodtypeid = "+periodTypeID+")");                                                       
 
165
                        if(rs4.next())                  {       cumulativeValues[i] =  rs4.getInt(1);           }         
 
166
                        }
 
167
        } // try block end
 
168
    catch(Exception e)  { out.println(e.getMessage());  }
 
169
    finally
 
170
       {
 
171
                        try
 
172
                        {
 
173
                                if(rs1!=null)  rs1.close();             if(st1!=null)  st1.close();
 
174
                                if(rs2!=null)  rs2.close();             if(st2!=null)  st2.close();                             
 
175
                                if(rs3!=null)  rs3.close();             if(st3!=null)  st3.close();                             
 
176
                                if(rs4!=null)  rs4.close();             if(st4!=null)  st4.close();
 
177
                                if(rs5!=null)  rs5.close();             if(st5!=null)  st5.close();
 
178
                                if(rs6!=null)  rs6.close();             if(st6!=null)  st6.close();
 
179
                                if(rs7!=null)  rs7.close();             if(st7!=null)  st7.close();
 
180
                                if(rs8!=null)  rs8.close();             if(st8!=null)  st8.close();
 
181
                                
 
182
                                if(con!=null)  con.close(); 
 
183
                        }
 
184
                        catch(Exception e)   {  out.println(e.getMessage());   }
 
185
       } // finally block end   
 
186
       
 
187
  %>
 
188
 
 
189
<html>
 
190
<head>
 
191
        <title>NLEP Monthly Reporting Form</title>
 
192
</head>
 
193
<body>  
 
194
   <center>
 
195
      <font face="arial" size="4">
 
196
                &#2310;&#2352;&#2379;&#2327;&#2381;&#2351;&#2350; &#2360;&#2369;&#2326;&#2360;&#2350;&#2381;&#2346;&#2342;&#2366; </font>
 
197
                <br>
 
198
          <font face="arial" size="2">  
 
199
                &#2309;&#2344;&#2369;&#2360;&#2370;&#2330;&#2367; - IV 
 
200
                </font>
 
201
        </center>       
 
202
        <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
203
                <tr>
 
204
          <td width="100%" colspan="9" align="center" style="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-width: 0; "><font face="Arial" size="3"><b>NLEP  
 
205
          - &#2350;&#2366;&#2360;&#2367;&#2325; &#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2344; &#2346;&#2381;&#2352;&#2346;&#2340;&#2381;&#2352;</b></font></td></tr>
 
206
                <tr>
 
207
          <td width="100%" colspan="9" align="center" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-width: 0; border-bottom-width: 0"><font face="Arial" size="3"><b>&#2346;&#2381;&#2352;. 
 
208
                        &#2360;&#2381;&#2357;&#2366;. &#2325;&#2375;&#2306;. / &#2346;&#2381;&#2352;&#2326;&#2339;&#2381;&#2337; &#2346;&#2381;&#2352;. 
 
209
          &#2360;&#2381;&#2357;&#2366;. &#2325;&#2375;&#2306;. &#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2344;</b></font></td></tr>
 
210
                <tr>
 
211
                        <td width="50%" height="25" colspan="4" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 0; border-top-width: 0; border-bottom-width: 0"><font face="Arial" size="2">&#2346;&#2368; &#2319;&#2330; &#2360;&#2368;&nbsp;&nbsp;&nbsp;&nbsp;<%=selectedOrgUnitName%></font></td>
 
212
                        <td width="50%" height="25" colspan="5" style="border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 1; border-top-width: 0; border-bottom-width: 0"><font face="Arial" size="2">&#2348;&#2381;&#2354;&#2366;&#2325;&nbsp;&nbsp;&nbsp;&nbsp;</font></td>
 
213
                </tr>
 
214
                <tr>
 
215
                        <td width="50%" height="25" colspan="4" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 0; border-top-width: 0; border-bottom-width: 0"><font face="Arial" size="2">&#2332;&#2367;&#2354;&#2366;&nbsp;&nbsp;&nbsp;&nbsp;<%=DistrictName%></font></td>
 
216
                        <td width="50%" height="25" colspan="5" style="border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 1; border-top-width: 0; border-bottom-width: 0"><font face="Arial" size="2">&#2352;&#2366;&#2332;&#2381;&#2351;&nbsp;&nbsp;&nbsp;&nbsp;<%=StateName%></font></td>
 
217
                </tr>
 
218
                <tr>
 
219
                        <td width="50%" height="25" colspan="4" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 0; border-top-width: 0; border-bottom-width: 0"><font face="Arial" size="2">&#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2367;&#2340; &#2350;&#2366;&#2361;&nbsp;&nbsp;&nbsp;<%=monthNames[Integer.parseInt(partsOfDataPeriodStartDate[1])]%></font></td>
 
220
                        <td width="50%" height="25" colspan="5" style="border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 1; border-top-width: 0; border-bottom-width: 0"><font face="Arial" size="2">&#2357;&#2352;&#2381;&#2359;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<%=partsOfDataPeriodStartDate[0]%></font></td>
 
221
                </tr>
 
222
                <tr>
 
223
                        <td width="3%" height="25" ><font face="Arial" size="2">1.</font></td>
 
224
                        <td width="57%" height="25" colspan="4"><font face="Arial" size="2">&#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2367;&#2340; &#2350;&#2366;&#2361; &#2346;&#2381;&#2352;&#2366;&#2352;&#2350;&#2381;&#2349; &#2361;&#2379;&#2344;&#2375; &#2325;&#2375; &#2360;&#2350;&#2351; &#2350;&#2352;&#2368;&#2332;&#2379;&#2306; &#2325;&#2368; &#2360;&#2306;&#2326;&#2381;&#2351;&#2366;</font></td>
 
225
                        <td width="25%" height="25" colspan="3" bgcolor="#000000">&nbsp;</td>
 
226
                        <td width="10%" height="25"  align="center"><font face="Arial" size="2"><%=monthlyValues[0]%></font></td>
 
227
                </tr>
 
228
                <tr>
 
229
                        <td width="3%" rowspan="3" height="25" ><font face="Arial" size="2">2.</font></td>
 
230
                        <td width="57%" rowspan="3" colspan="4" height="25" ><font face="Arial" size="2">&#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2367;&#2340; &#2350;&#2366;&#2361; &#2350;&#2375;&#2306; &#2344;&#2351;&#2375; &#2325;&#2369;&#2359;&#2381;&#2336; &#2352;&#2379;&#2327;&#2367;&#2351;&#2379;&#2306; &#2325;&#2368; &#2326;&#2379;&#2332; &#2325;&#2368; &#2360;&#2306;&#2326;&#2381;&#2351;&#2366;</font></td>
 
231
                </tr>
 
232
                <tr>
 
233
                        <td width="15%" height="25" colspan="2" ><font face="Arial" size="2">
 
234
                &#2346;&#2368; &#2348;&#2368; -</font></td>
 
235
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2"><%=monthlyValues[1]%></font></td>
 
236
                        <td width="10%" height="25"  align="center" bgcolor="#000000" bordercolor="#FFFFFF" ><font face="Arial" size="2"></font></td>
 
237
                </tr>
 
238
                <tr>
 
239
                        <td width="15%" height="25" colspan="2" ><font face="Arial" size="2">
 
240
                &#2319;&#2350; &#2348;&#2368; -</font></td>
 
241
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2"><%=monthlyValues[2]%></font></td>
 
242
                        <td width="10%" height="25"  align="center" bgcolor="#000000" bordercolor="#FFFFFF" ><font face="Arial" size="2"></font></td>
 
243
                </tr>
 
244
                <tr>
 
245
                        <td width="3%" height="25" rowspan="5" ><font face="Arial" size="2">3.</font></td>
 
246
                        <td width="57%" height="25" rowspan="5" colspan="4"><font face="Arial" size="2">&#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2367;&#2340; &#2350;&#2366;&#2361; &#2325;&#2375; &#2342;&#2380;&#2352;&#2366;&#2344; &#2344;&#2351;&#2375; &#2325;&#2369;&#2359;&#2381;&#2336; &#2352;&#2379;&#2327;&#2367;&#2351;&#2379;&#2306; &#2325;&#2368; &#2326;&#2379;&#2332; &#2325;&#2375; &#2348;&#2368;&#2330; &#2325;&#2368; &#2360;&#2306;&#2326;&#2381;&#2351;&#2366;-</font></td>
 
247
                        <td width="15%" height="25" colspan="2" ><font face="Arial" size="2">&#2348;&#2330;&#2381;&#2330;&#2375;</font></td>
 
248
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2"><%=monthlyValues[3]%></font></td>
 
249
                        <td width="10%" height="25"  align="center" bgcolor="#000000" bordercolor="#FFFFFF" ><font face="Arial" size="2"></font></td>
 
250
                </tr>
 
251
                <tr>
 
252
                        <td width="15%" height="25" colspan="2" ><font face="Arial" size="2">&#2350;.</font></td>
 
253
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2"><%=monthlyValues[4]%></font></td>
 
254
                        <td width="10%" height="25"  align="center" bgcolor="#000000" bordercolor="#FFFFFF" ><font face="Arial" size="2"></font></td>
 
255
                </tr>
 
256
                <tr>
 
257
                        <td width="15%" height="25" colspan="2" ><font face="Arial" size="2">&#2342;&#2375;&#2326;&#2344;&#2375; &#2351;&#2379;&#2327;&#2381;&#2351; &#2357;&#2367;&#2325;&#2371;&#2340;&#2367;&#2351;&#2366;&#2305;</font></td>
 
258
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2"><%=monthlyValues[5]%></font></td>
 
259
                        <td width="15%" height="25"  align="center" bgcolor="#000000" bordercolor="#FFFFFF" ><font face="Arial" size="2"></font></td>
 
260
                </tr>
 
261
                <tr>
 
262
                        <td width="15%" height="25" colspan="2" ><font face="Arial" size="2">&#2319;&#2360; &#2360;&#2368;</font></td>
 
263
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2"><%=monthlyValues[6]%></font></td>
 
264
                        <td width="15%" height="25"  align="center" bgcolor="#000000" bordercolor="#FFFFFF" ><font face="Arial" size="2"></font></td>
 
265
                </tr>
 
266
                <tr>
 
267
                        <td width="15%" height="25" colspan="2" ><font face="Arial" size="2">&#2319;&#2360; &#2335;&#2368;</font></td>
 
268
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2"><%=monthlyValues[7]%></font></td>
 
269
                        <td width="15%" height="25"  align="center" bgcolor="#000000" bordercolor="#FFFFFF" ><font face="Arial" size="2"></font></td>
 
270
                </tr>
 
271
                <tr>
 
272
                        <td width="3%" rowspan="2" height="25" ><font face="Arial" size="2">4.</font></td>
 
273
                        <td width="57%" height="25" rowspan="2" colspan="4"><font face="Arial" size="2">&#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2367;&#2340; &#2350;&#2366;&#2361; &#2350;&#2375;&#2306; &#2352;&#2379;&#2327; &#2350;&#2369;&#2325;&#2381;&#2340; &#2325;&#2367;&#2319; &#2327;&#2319; &#2352;&#2379;&#2327;&#2367;&#2351;&#2379;&#2306; &#2325;&#2368; &#2360;&#2306;&#2326;&#2381;&#2351;&#2366;</font></td>
 
274
                        <td width="15%" height="25" colspan="2" ><font face="Arial" size="2">&#2310;&#2352; &#2319;&#2347; &#2335;&#2368; -</font></td>
 
275
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2"><%=monthlyValues[8]%></font></td>
 
276
                        <td width="10%" height="25"  align="center" bgcolor="#000000" bordercolor="#FFFFFF" ><font face="Arial" size="2"></font></td>
 
277
                </tr>
 
278
                <tr>
 
279
                        <td width="15%" height="25" colspan="2" ><font face="Arial" size="2">&#2309;&#2344;&#2381;&#2351; -</font></td>
 
280
                        <td width="10%" height="25" align="center" ><font face="Arial" size="2"><%=monthlyValues[9]%></font></td>
 
281
                        <td width="15%" height="25"  align="center" bgcolor="#000000" bordercolor="#FFFFFF" ><font face="Arial" size="2"></font></td>
 
282
                </tr>
 
283
                <tr>
 
284
                        <td width="3%" height="25" ><font face="Arial" size="2">5.</font></td>
 
285
                        <td width="57%" height="25" colspan="4"><font face="Arial" size="2">&#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2367;&#2340; &#2350;&#2366;&#2361; &#2325;&#2375; &#2309;&#2306;&#2340; &#2350;&#2375;&#2306; &#2352;&#2379;&#2327;&#2367;&#2351;&#2379;&#2306; &#2325;&#2368; &#2360;&#2306;&#2326;&#2381;&#2351;&#2366; (1+2+4)</td>
 
286
                        <td width="25%" height="25" colspan="3" bgcolor="#000000" bordercolor="#FFFFFF">&nbsp;</td>
 
287
                        <td width="15%" height="25" align="center" bgcolor="#FFFFFF" ><font face="Arial" size="2"><%=(monthlyValues[0]+monthlyValues[1]+monthlyValues[2]+monthlyValues[8]+monthlyValues[9])%></font></td>
 
288
                </tr>
 
289
                <tr>
 
290
                        <td width="3%" height="25" ><font face="Arial" size="2">6.</font></td>
 
291
                        <td width="57%" height="25" colspan="4"><font face="Arial" size="2">&#2319;&#2350; &#2337;&#2368; &#2335;&#2368; &#2360;&#2375;&#2357;&#2366; &#2313;&#2346;&#2354;&#2348;&#2381;&#2343; &#2325;&#2352;&#2366;&#2312; &#2327;&#2312; &#2313;&#2346;&#2325;&#2375;&#2306;&#2342;&#2381;&#2352;&#2379;&#2306; &#2325;&#2368; &#2360;&#2306;&#2326;&#2381;&#2351;&#2366;</font></td>
 
292
                        <td width="25%" height="25" colspan="3" bgcolor="#000000" bordercolor="#FFFFFF">&nbsp;</td>
 
293
                        <td width="15%" height="25" align="center" bgcolor="#FFFFFF"><font face="Arial" size="2"><%=monthlyValues[10]%></font></td>
 
294
                </tr>
 
295
                <tr>
 
296
                        <td width="2%" height="25" ><font face="Arial" size="2">7.</font></td>
 
297
                        <td width="98%" height="25" colspan="8"><font face="Arial" size="2">&#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2367;&#2340; &#2350;&#2366;&#2361; &#2325;&#2375; &#2309;&#2344;&#2381;&#2340; &#2350;&#2375;&#2306; &#2325;&#2369;&#2359;&#2381;&#2336; &#2342;&#2357;&#2366;&#2323;&#2306; &#2325;&#2368; &#2349;&#2339;&#2381;&#2337;&#2366;&#2352;&#2339; &#2360;&#2306;&#2326;&#2381;&#2351;&#2366;</font></td>
 
298
                </tr>
 
299
                <tr>
 
300
                        <td width="3%" height="25" >&nbsp;</td>
 
301
                        <td width="20%" height="25" align="center" colspan="2"><font face="Arial" size="2">Blister Pack</font></td>
 
302
                        <td width="25%" height="25" align="center" ><font face="Arial" size="2">Quantity</font></td>
 
303
                        <td width="25" height="25" align="center" colspan="3"><font face="Arial" size="2">Expiry Date</font></td>
 
304
                        <td width="25%" height="25" align="center" colspan="2"><font face="Arial" size="2">Total Stock</font></td>
 
305
                </tr>
 
306
                <tr>
 
307
                        <td width="3%" height="25" rowspan="3" >&nbsp;</td>
 
308
                        <td width="20%" height="25" align="center" rowspan="3" colspan="2" ><font face="Arial" size="2">&#2319;&#2350; &#2348;&#2368;(&#2319;)</font></td>
 
309
                        <td width="25%" height="25" ></td>
 
310
                        <td width="25" height="25" colspan="3"></td>
 
311
                        <td width="25%"  align="center" height="25" colspan="2" rowspan="3"><font face="Arial" size="2"><%=monthlyValues[11]%></font></td>
 
312
                </tr>
 
313
                <tr>
 
314
                        <td width="25%" height="25"></td>
 
315
                        <td width="25" height="25" colspan="3"></td>
 
316
                </tr>
 
317
                <tr>
 
318
                        <td width="25%" height="25"></td>
 
319
                        <td width="25" height="25" colspan="3"></td>
 
320
                </tr>
 
321
                <tr>
 
322
                        <td width="3%" height="25" rowspan="3" >&nbsp;</td>
 
323
                        <td width="20%" height="25" align="center" rowspan="3" colspan="2" ><font face="Arial" size="2">&#2319;&#2350; &#2348;&#2368;(&#2360;&#2368;)</font></td>
 
324
                        <td width="25%" height="25"></td>
 
325
                        <td width="25" height="25" colspan="3"></td>
 
326
                        <td width="25%" align="center" height="25" colspan="2" rowspan="3"><font face="Arial" size="2"><%=monthlyValues[12]%></font></td>
 
327
                </tr>
 
328
                <tr>
 
329
                        <td width="25%" height="25"></td>
 
330
                        <td width="25" height="25" colspan="3"></td>
 
331
                </tr>
 
332
                <tr>
 
333
                        <td width="25%" height="25"></td>
 
334
                        <td width="25" height="25" colspan="3"></td>
 
335
                </tr>
 
336
                <tr>
 
337
                        <td width="3%" height="25" rowspan="3" >&nbsp;</td>
 
338
                        <td width="20%" height="25" align="center" rowspan="3" colspan="2" ><font face="Arial" size="2">&#2346;&#2368; &#2348;&#2368;(&#2319;)</font></td>
 
339
                        <td width="25%" height="25"></td>
 
340
                        <td width="25" height="25" colspan="3"></td>
 
341
                        <td width="25%"  align="center" height="25" colspan="2" rowspan="3"><font face="Arial" size="2"><%=monthlyValues[13]%></font></td>
 
342
                </tr>
 
343
                <tr>
 
344
                        <td width="25%" height="25"></td>
 
345
                        <td width="25" height="25" colspan="3"></td>
 
346
                </tr>
 
347
                <tr>
 
348
                        <td width="25%" height="25"></td>
 
349
                        <td width="25" height="25" colspan="3"></td>
 
350
                </tr>
 
351
                <tr>
 
352
                        <td width="3%" height="25" rowspan="3" >&nbsp;</td>
 
353
                        <td width="20%" height="25" align="center" rowspan="3" colspan="2" ><font face="Arial" size="2">&#2346;&#2368; &#2348;&#2368;(&#2360;&#2368;)</font></td>
 
354
                        <td width="25%" height="25"></td>
 
355
                        <td width="25" height="25" colspan="3"></td>
 
356
                        <td width="25%"  align="center" height="25" colspan="2" rowspan="3"><font face="Arial" size="2"><%=monthlyValues[14]%></font></td>
 
357
                </tr>
 
358
                <tr>
 
359
                        <td width="25%" height="25"></td>
 
360
                        <td width="25" height="25" colspan="3"></td>
 
361
                </tr>
 
362
                <tr>
 
363
                        <td width="25%" height="25"></td>
 
364
                        <td width="25" height="25" colspan="3"></td>
 
365
                </tr>
 
366
                <tr>
 
367
                        <td width="100%" height="100" valign="top" colspan="9"><font face="Arial" size="2">&#2344;&#2379;&#2335;: &#2350;&#2366;&#2361; &#2350;&#2366;&#2352;&#2381;&#2330;, &#2332;&#2370;&#2344;, &#2360;&#2367;&#2340;&#2350;&#2381;&#2348;&#2352; &#2319;&#2357;&#2306; &#2342;&#2367;&#2360;&#2350;&#2381;&#2348;&#2352; &#2350;&#2375;&#2306; &#2340;&#2381;&#2352;&#2376;&#2350;&#2366;&#2360;&#2367;&#2325; &#2352;&#2379;&#2327;&#2367;&#2351;&#2379;&#2306; &#2325;&#2368; &#2327;&#2339;&#2344;&#2366; &#2319;&#2350; &#2348;&#2368;(&#2319;),&#2319;&#2350; &#2348;&#2368;(&#2360;&#2368;),&#2346;&#2368; &#2348;&#2368;(&#2319;) &#2319;&#2357;&#2306; &#2319;&#2350; &#2348;&#2368;(&#2360;&#2368;) &#2325;&#2368; &#2325;&#2371;&#2346;&#2366; &#2325;&#2352;&#2375;&#2306; &#2332;&#2376;&#2360;&#2366; &#2360;&#2350;&#2381;&#2348;&#2343;&#2367;&#2340; &#2350;&#2366;&#2360;&#2367;&#2325; &#2346;&#2381;&#2352;&#2340;&#2367;&#2357;&#2375;&#2342;&#2344; &#2350;&#2375;&#2306; &#2325;&#2367;&#2351;&#2366; &#2327;&#2351;&#2366; &#2361;&#2376;!</font></td>
 
368
                </tr>
 
369
                <tr>
 
370
                        <td width="20%" height="25" colspan="2"><font face="Arial" size="2">Date:</font></td>
 
371
                        <td width="30%" height="25" colspan="3">&nbsp;</td>
 
372
                        <td width="50%" height="25" colspan="4"><font face="Arial" size="2">
 
373
                Name and Signature of Medical Officer</font></td>
 
374
                </tr>
 
375
  </table>                                   
 
376
</body>
 
377
</html>
 
 
b'\\ No newline at end of file'