Subversion Repositories SmartDukaan

Rev

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

Rev 20779 Rev 20780
Line 7... Line 7...
7 
import in.shop2020.support.utils.ReportsUtils;
 7 
import in.shop2020.support.utils.ReportsUtils;
8 
import in.shop2020.thrift.clients.PaymentClient;
 8 
import in.shop2020.thrift.clients.PaymentClient;
9 
import in.shop2020.thrift.clients.TransactionClient;
 9 
import in.shop2020.thrift.clients.TransactionClient;
10 
import in.shop2020.thrift.clients.UserClient;
 10 
import in.shop2020.thrift.clients.UserClient;
11 
 
 11 
 
12 
import java.io.FileOutputStream;
 - 
 
13 
import java.io.InputStream;
 12 
import java.io.InputStream;
14 
import java.text.DateFormat;
 13 
import java.text.DateFormat;
15 
import java.text.SimpleDateFormat;
 14 
import java.text.SimpleDateFormat;
16 
import java.util.ArrayList;
 15 
import java.util.ArrayList;
17 
import java.util.Calendar;
 16 
import java.util.Calendar;
Line 20... Line 19...
20 
 
 19 
 
21 
import javax.servlet.ServletContext;
 20 
import javax.servlet.ServletContext;
22 
import javax.servlet.http.HttpServletRequest;
 21 
import javax.servlet.http.HttpServletRequest;
23 
import javax.servlet.http.HttpSession;
 22 
import javax.servlet.http.HttpSession;
24 
 
 23 
 
25 
import org.apache.poi.ss.usermodel.Cell;
 - 
 
26 
import org.apache.poi.ss.usermodel.Row;
 24 
import org.apache.poi.ss.usermodel.Row;
27 
import org.apache.poi.ss.usermodel.Sheet;
 25 
import org.apache.poi.ss.usermodel.Sheet;
28 
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
 26 
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
29 
import org.apache.struts2.convention.annotation.InterceptorRef;
 27 
import org.apache.struts2.convention.annotation.InterceptorRef;
30 
import org.apache.struts2.convention.annotation.InterceptorRefs;
 28 
import org.apache.struts2.convention.annotation.InterceptorRefs;
Line 36... Line 34...
36 
import org.slf4j.Logger;
 34 
import org.slf4j.Logger;
37 
import org.slf4j.LoggerFactory;
 35 
import org.slf4j.LoggerFactory;
38 
 
 36 
 
39 
@InterceptorRefs({ @InterceptorRef("defaultStack"), @InterceptorRef("login") })
 37 
@InterceptorRefs({ @InterceptorRef("defaultStack"), @InterceptorRef("login") })
40 
@Results({ @Result(name = "authfail", type = "redirectAction", params = {
 38 
@Results({ @Result(name = "authfail", type = "redirectAction", params = {
41 
		"actionName", "reports" }) })
 39 
		"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 
})
42 
public class StatisticsController implements ServletRequestAware,
 51 
public class StatisticsController implements ServletRequestAware,
43 
		ServletContextAware {
 52 
		ServletContextAware {
44 
 
 53 
 
45 
	private static Logger logger = LoggerFactory
 54 
	private static Logger logger = LoggerFactory
46 
			.getLogger(StatisticsController.class);
 55 
			.getLogger(StatisticsController.class);
- 
 
 56
- 
 
 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 
 
- 
 
 70 
	public void setStream(InputStream stream) {
- 
 
 71 
		this.stream = stream;
- 
 
 72 
	}
- 
 
 73 
 
- 
 
 74 
	private InputStream stream;
- 
 
 75 
	private String filename;
- 
 
 76 
	private String type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
- 
 
 77 
 
- 
 
 78 
	public String getType() {
- 
 
 79 
		return type;
- 
 
 80 
	}
47 
 
 81 
 
48 
	private HttpServletRequest request;
 82 
	private HttpServletRequest request;
49 
	private HttpSession session;
 83 
	private HttpSession session;
50 
	private ServletContext context;
 84 
	private ServletContext context;
51 
 
 85 
 
Line 252... Line 286...
252 
			}
 286 
			}
253 
			row.createCell(++i).setCellValue(o.getStatusDescription());
 287 
			row.createCell(++i).setCellValue(o.getStatusDescription());
254 
			row.createCell(++i).setCellValue(o.getCustomer_city());
 288 
			row.createCell(++i).setCellValue(o.getCustomer_city());
255
289
256 
		}
 290 
		}
257 
		FileOutputStream out = new FileOutputStream("/tmp/file.xls");
 291 
		stream = is;
258 
		workbook.write(out);
 292 
		filename=this.getMy() + "-order.xlsx";
259
- 
 
260
293
261 
		return null;
 294 
		return "report";
262 
	}
 295 
	}
263 
 
 296 
 
264 
	public void setMy(String my) {
 297 
	public void setMy(String my) {
265 
		this.my = my;
 298 
		this.my = my;
266 
	}
 299 
	}