该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
HttpServletRequest request = ServletActionContext.getRequest();
projectId =(long) Integer.parseInt(request.getParameter("projectList3"));
starttime = request.getParameter("startdate3");
endtime = request.getParameter("enddate3");
hcCustomers = saleLogService.selCustomer(projectId, starttime, endtime);
HSSFWorkbook workbook = new HSSFWorkbook();//在内存中创建一个表格文件
HSSFSheet sheet = workbook.createSheet("来访客户统计表");//在表格中创建一个标签
HSSFRow row = sheet.createRow(0);//创建行,作为标题行
row.createCell(0).setCellValue("客户姓名");
row.createCell(1).setCellValue("联系方式");
row.createCell(3).setCellValue("接待日期");
row.createCell(4).setCellValue("登记人员");
row.createCell(2).setCellValue("性别");
row.createCell(5).setCellValue("认知途径");
row.createCell(6).setCellValue("接待来源");
row.createCell(7).setCellValue("居住区域");
row.createCell(8).setCellValue("年龄段");
row.createCell(9).setCellValue("购房用途");
row.createCell(10).setCellValue("意向户型");
row.createCell(11).setCellValue("意向价格");
for (Map map:hcCustomers) {
HSSFRow dataRow = sheet.createRow(sheet.getLastRowNum()+1);//创建行,作为标题行
dataRow.createCell(0).setCellValue(map.get("CustomerName")+"");
dataRow.createCell(1).setCellValue(map.get("MobilePhone")+"");
dataRow.createCell(2).setCellValue(map.get("Sex")+"");
dataRow.createCell(5).setCellValue(map.get("CognitiveChannel")+"");
dataRow.createCell(7).setCellValue(map.get("ResidentialZone")+"");
dataRow.createCell(8).setCellValue(map.get("AgeGroup")+"");
dataRow.createCell(9).setCellValue(map.get("PurchasePurpose")+"");
dataRow.createCell(3).setCellValue(map.get("ReceptionTime")+"");
dataRow.createCell(6).setCellValue(map.get("ReceptionSource")+"");
dataRow.createCell(4).setCellValue(map.get("Salesman")+"");
dataRow.createCell(10).setCellValue(map.get("IntentionalChamber")+"");
dataRow.createCell(11).setCellValue(map.get("IntentionalPrice")+"");
}
/*ServletOutputStream outputStream = ServletActionContext.getResponse().getOutputStream();
ServletActionContext.getResponse().setContentType("application/vnd.ms-excel");
String filename = starttime+"-"+endtime+"来访客户统计表.xls";
String agent = ServletActionContext.getRequest().getHeader("User-Agent");
String finalFilename = FileUtils.encodeDownloadFilename(filename, agent);
ServletActionContext.getResponse().setHeader("content-disposition", "attchment;filename="+finalFilename);
workbook.write(outputStream);*/
HttpServletResponse response =ServletActionContext.getResponse();
String starString = starttime.substring(0,10);
String endString = endtime.substring(0,10);
OutputStream output = response.getOutputStream();
String FILE_OUTPUT_NAME ="来访客户统计表";
response.reset();
String name =starString+projectId+".xls";
OutputStream out = new FileOutputStream(name);
// 设置输出文档的头文件
FILE_OUTPUT_NAME = FileUtils.encodeDownloadFilename(FILE_OUTPUT_NAME, request.getHeader("user-agent"));
response.setContentType(request.getSession().getServletContext().getMimeType(FILE_OUTPUT_NAME));
response.setHeader("content-disposition", "attachment;filename=" + FILE_OUTPUT_NAME);
workbook.write(out);
response.setHeader("Content-disposition","attachment; filename="+starString+"-"+endString+"-"+projectId+".xls");
response.setContentType("application/octet-stream");//告诉浏览器输出内容为流
workbook.write(output);
return NONE;