Subversion Repositories SmartDukaan

Rev

Rev 20787 | Rev 20789 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 20787 Rev 20788
Line 16... Line 16...
16 
import java.util.Calendar;
 16 
import java.util.Calendar;
17 
import java.util.Date;
 17 
import java.util.Date;
18 
import java.util.List;
 18 
import java.util.List;
19 
 
 19 
 
20 
import javax.servlet.ServletContext;
 20 
import javax.servlet.ServletContext;
- 
 
 21 
import javax.servlet.ServletOutputStream;
21 
import javax.servlet.http.HttpServletRequest;
 22 
import javax.servlet.http.HttpServletRequest;
- 
 
 23 
import javax.servlet.http.HttpServletResponse;
22 
import javax.servlet.http.HttpSession;
 24 
import javax.servlet.http.HttpSession;
23 
 
 25 
 
24 
import org.apache.poi.ss.usermodel.Row;
 26 
import org.apache.poi.ss.usermodel.Row;
25 
import org.apache.poi.ss.usermodel.Sheet;
 27 
import org.apache.poi.ss.usermodel.Sheet;
26 
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
 28 
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
27 
import org.apache.struts2.convention.annotation.InterceptorRef;
 29 
import org.apache.struts2.convention.annotation.InterceptorRef;
28 
import org.apache.struts2.convention.annotation.InterceptorRefs;
 30 
import org.apache.struts2.convention.annotation.InterceptorRefs;
29 
import org.apache.struts2.convention.annotation.Result;
 31 
import org.apache.struts2.convention.annotation.Result;
30 
import org.apache.struts2.convention.annotation.Results;
 32 
import org.apache.struts2.convention.annotation.Results;
31 
import org.apache.struts2.interceptor.ServletRequestAware;
 33 
import org.apache.struts2.interceptor.ServletRequestAware;
- 
 
 34 
import org.apache.struts2.interceptor.ServletResponseAware;
32 
import org.apache.struts2.util.ServletContextAware;
 35 
import org.apache.struts2.util.ServletContextAware;
33 
import org.apache.thrift.TException;
 36 
import org.apache.thrift.TException;
34 
import org.slf4j.Logger;
 37 
import org.slf4j.Logger;
35 
import org.slf4j.LoggerFactory;
 38 
import org.slf4j.LoggerFactory;
36 
 
 39 
 
- 
 
 40 
import com.opensymphony.xwork2.ActionSupport;
- 
 
 41 
 
37 
@InterceptorRefs({ @InterceptorRef("defaultStack"), @InterceptorRef("login") })
 42 
@InterceptorRefs({ @InterceptorRef("defaultStack"), @InterceptorRef("login") })
38 
@Results({ @Result(name = "authfail", type = "redirectAction", params = {
 43 
@Results({ @Result(name = "authfail", type = "redirectAction", params = {
39 
		"actionName", "reports" }),
 44 
		"actionName", "reports" })
40 
	@Result(
- 
 
41 
	    name = "report",
- 
 
42 
	    type = "stream",
- 
 
43 
	    params = {
- 
 
44 
	        "contentType", "${type}",
- 
 
45 
	        "inputName", "${stream}",
- 
 
46 
	        "bufferSize", "1024",
- 
 
47 
	        "contentDisposition", "attachment;filename=\"${filename}\""
 - 
 
48 
	    }
 - 
 
49 
	)
 - 
 
50 
})
 45 
})
51 
public class StatisticsController implements ServletRequestAware,
 46 
public class StatisticsController implements ServletRequestAware, ServletResponseAware,
52 
		ServletContextAware {
 47 
		ServletContextAware {
53 
 
 48 
 
54 
	private static Logger logger = LoggerFactory
 49 
	private static Logger logger = LoggerFactory
55 
			.getLogger(StatisticsController.class);
 50 
			.getLogger(StatisticsController.class);
56
51
57
- 
 
58 
    public String getFilename() {
 - 
 
59 
		return filename;
 - 
 
60 
	}
 - 
 
61 
 
 - 
 
62 
	public void setFilename(String filename) {
 - 
 
63 
		this.filename = filename;
 - 
 
64 
	}
 - 
 
65 
 
 - 
 
66 
	public InputStream getStream() {
 - 
 
67 
		return stream;
 - 
 
68 
	}
 - 
 
69 
 
 52 
 
70 
	public void setStream(InputStream stream) {
 - 
 
71 
		this.stream = stream;
 - 
 
72 
	}
 - 
 
73 
 
 - 
 
74 
	private InputStream stream;
 53 
	private HttpServletResponse response;
75 
	private String filename;
 - 
 
76 
	private String type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
 54 
	private String type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
77 
 
 55 
 
78 
	public String getType() {
 56 
	public String getType() {
79 
		return type;
 57 
		return type;
80 
	}
 58 
	}
Line 288... Line 266...
288 
			}
 266 
			}
289 
			row.createCell(++i).setCellValue(o.getStatusDescription());
 267 
			row.createCell(++i).setCellValue(o.getStatusDescription());
290 
			row.createCell(++i).setCellValue(o.getCustomer_city());
 268 
			row.createCell(++i).setCellValue(o.getCustomer_city());
291
269
292 
		}
 270 
		}
- 
 
 271 
		ServletOutputStream os = response.getOutputStream();
293 
		stream = is;
 272 
		workbook.write(os);
294 
		filename=this.getMy() + "-order.xlsx";
 273 
		String filename=this.getMy() + "-order.xlsx";
- 
 
 274 
		response.setContentType("application/pdf");
- 
 
 275 
		response.setHeader("Content-Disposition","attachment; filename=\"" + filename + "\"");
- 
 
 276 
 
295
277
296 
		return "report";
 278 
		return ActionSupport.NONE;
297 
	}
 279 
	}
298 
 
 280 
 
299 
	public void setMy(String my) {
 281 
	public void setMy(String my) {
300 
		this.my = my;
 282 
		this.my = my;
301 
	}
 283 
	}
302 
 
 284 
 
303 
	public String getMy() {
 285 
	public String getMy() {
304 
		return my;
 286 
		return my;
305 
	}
 287 
	}
- 
 
 288 
 
- 
 
 289 
	@Override
- 
 
 290 
	public void setServletResponse(HttpServletResponse arg0) {
- 
 
 291 
		this.response = arg0;
- 
 
 292
- 
 
 293 
	}
306 
}
 294 
}