1 /**
2 * 导出 用get请求
3 * @param response
4 * @param
5 * @throws IOException
6 */
7 @RequestMapping(value = "/download")
8 public void download(HttpServletResponse response,HttpServletRequest request) throws IOException {
9
10 int quality = UtilReq.parseInt(request.getParameter("quality"), -1);
11 String status = UtilReq.parseString(request.getParameter("status"),"");
12 String mobile = UtilReq.parseString(request.getParameter("mobile"),"");
13 long agentUid = UtilReq.parseLong(request.getParameter("agentUid"),0l);
14 HSSFWorkbook workbook = aritstService.download(quality,status,mobile,agentUid);
15
16 //设置要导出的文件的名字
17 String fileName="";
18 Date now = new Date();
19
20 fileName = "艺人数据" + UtilDate.formatDate2Str(now,"yyyy年MM月dd日HH时mm分ss秒") + ".xls";
21
22 fileName = new String(fileName.getBytes("gbk"), "iso-8859-1");
23 response.setContentType("application/octet-stream");
24 response.setHeader("Content-disposition", "attachment;filename=" + fileName);
25 response.flushBuffer();
26 workbook.write(response.getOutputStream());
27 }
1 /**
2 * 导出
3 * @param quality
4 * @param status
5 * @param mobile
6 * @param agentUid
7 * @return
8 */
9 public HSSFWorkbook download(int quality, String status, String mobile, long agentUid) {
10 //创建
11 HSSFWorkbook wb = new HSSFWorkbook();
12 //headers表示excel表中第一行的表头
13 String[] headers = {"姓名","邀请码","所属经纪人","经纪人手机号", "总收入金额", "接单数", "成单数","满意度","优质艺人"};
14 //创建一个只有头信息的空表
15 HSSFSheet sheet = null;
16 sheet = wb.createSheet("艺人数据");
17
18 //headers表示excel表中第一行的表头
19 HSSFRow row = sheet.createRow(0);
20
21 //在excel表中添加表头
22 for(int i=0;i<headers.length;i++){
23 HSSFCell cell = row.createCell(i);
24 HSSFRichTextString text = new HSSFRichTextString(headers[i]);
25 cell.setCellValue(text);
26 }
27
28 //查询艺人列表，根据筛选条件
29 List<Integer> statusList = null;
30 if ("".equals(status)){
31 status = "1,2";
32 }
33 if (StringUtils.isNotEmpty(status)) {
34 statusList = new ArrayList<>();
35 String[] statuss = status.split(",");
36 for (String statu : statuss) {
37 statusList.add(Integer.parseInt(statu));
38 }
39 }
40 //需要导出的数据
41 List<Aritst> aritsts = aritstDao.selectArtistByAgentAndMobile(statusList, mobile, agentUid,quality, null,null,null);
42
43 int rowNum = 1;
44 if (null != aritsts) {
45 //在表中存放查询到的数据放入对应的列
46 for (Aritst aritst : aritsts) {
47 HSSFRow row1 = sheet.createRow(rowNum);
48 //"姓名","邀请码","所属经纪人","经纪人手机号", "总收入金额", "接单号", "成单数","满意度","是否优质艺人"
49
50 row1.createCell(0).setCellValue(aritst.getNickname());
51 row1.createCell(1).setCellValue(aritst.getInviteCode());
52 row1.createCell(2).setCellValue(aritst.getAgent());
53 row1.createCell(3).setCellValue(aritst.getAgentMobile());
54 row1.createCell(4).setCellValue(aritst.getRevenue());
55 row1.createCell(5).setCellValue(aritst.getConnectionnum());
56 row1.createCell(6).setCellValue(aritst.getServernum());
57 row1.createCell(7).setCellValue(aritst.getSatisfiedRate());
58 row1.createCell(8).setCellValue(aritst.getQuality()==1?"是":"否");
59 rowNum++;
60 }
61 }
62 return wb;
63 }
