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
	}