/**

      * 导出 用get请求

      * @param response

      * @param

      * @throws IOException

      */

     @RequestMapping(value = "/download")

     public void download(HttpServletResponse response,HttpServletRequest request) throws IOException {

         int quality = UtilReq.parseInt(request.getParameter("quality"), -1);

         String status = UtilReq.parseString(request.getParameter("status"),"");

         String mobile = UtilReq.parseString(request.getParameter("mobile"),"");

         long agentUid = UtilReq.parseLong(request.getParameter("agentUid"),0l);

         HSSFWorkbook workbook = aritstService.download(quality,status,mobile,agentUid);

         //设置要导出的文件的名字

         String fileName="";

         Date now = new Date();

         fileName = "艺人数据" + UtilDate.formatDate2Str(now,"yyyy年MM月dd日HH时mm分ss秒") + ".xls";

         fileName = new String(fileName.getBytes("gbk"), "iso-8859-1");

         response.setContentType("application/octet-stream");

         response.setHeader("Content-disposition", "attachment;filename=" + fileName);

         response.flushBuffer();

         workbook.write(response.getOutputStream());

     }

 /**

      * 导出

      * @param quality

      * @param status

      * @param mobile

      * @param agentUid

      * @return

      */

     public HSSFWorkbook download(int quality, String status, String mobile, long agentUid) {

         //创建

         HSSFWorkbook wb = new HSSFWorkbook();

         //headers表示excel表中第一行的表头

         String[] headers = {"姓名","邀请码","所属经纪人","经纪人手机号", "总收入金额", "接单数", "成单数","满意度","优质艺人"};

         //创建一个只有头信息的空表

         HSSFSheet sheet = null;

         sheet = wb.createSheet("艺人数据");

         //headers表示excel表中第一行的表头

         HSSFRow row = sheet.createRow(0);

         //在excel表中添加表头

         for(int i=0;i<headers.length;i++){

             HSSFCell cell = row.createCell(i);

             HSSFRichTextString text = new HSSFRichTextString(headers[i]);

             cell.setCellValue(text);

         }

         //查询艺人列表，根据筛选条件

         List<Integer> statusList = null;

         if ("".equals(status)){

             status = "1,2";

         }

         if (StringUtils.isNotEmpty(status)) {

             statusList = new ArrayList<>();

             String[] statuss = status.split(",");

             for (String statu : statuss) {

                 statusList.add(Integer.parseInt(statu));

             }

         }

         //需要导出的数据

         List<Aritst> aritsts = aritstDao.selectArtistByAgentAndMobile(statusList, mobile, agentUid,quality, null,null,null);

         int rowNum = 1;

         if (null != aritsts) {

             //在表中存放查询到的数据放入对应的列

             for (Aritst aritst : aritsts) {

                 HSSFRow row1 = sheet.createRow(rowNum);

                 //"姓名","邀请码","所属经纪人","经纪人手机号", "总收入金额", "接单号", "成单数","满意度","是否优质艺人"

                 row1.createCell(0).setCellValue(aritst.getNickname());

                 row1.createCell(1).setCellValue(aritst.getInviteCode());

                 row1.createCell(2).setCellValue(aritst.getAgent());

                 row1.createCell(3).setCellValue(aritst.getAgentMobile());

                 row1.createCell(4).setCellValue(aritst.getRevenue());

                 row1.createCell(5).setCellValue(aritst.getConnectionnum());

                 row1.createCell(6).setCellValue(aritst.getServernum());

                 row1.createCell(7).setCellValue(aritst.getSatisfiedRate());

                 row1.createCell(8).setCellValue(aritst.getQuality()==1?"是":"否");

                 rowNum++;

             }

         }

         return wb;

     }