|  |  | 
 |  |  | package com.dy.pipIrrProject.intake; | 
 |  |  |  | 
 |  |  | import com.alibaba.excel.EasyExcel; | 
 |  |  | import com.alibaba.excel.support.ExcelTypeEnum; | 
 |  |  | import com.dy.common.aop.SsoAop; | 
 |  |  | import com.dy.common.webUtil.BaseResponse; | 
 |  |  | import com.dy.common.webUtil.BaseResponseUtils; | 
 |  |  | import com.dy.common.webUtil.QueryResultVo; | 
 |  |  | import com.dy.common.webUtil.ResultCodeMsg; | 
 |  |  | import com.dy.pipIrrGlobal.excel.CellWriteHandler; | 
 |  |  | import com.dy.pipIrrGlobal.excel.ExcelUtil; | 
 |  |  | import com.dy.pipIrrGlobal.pojoPr.PrIntake; | 
 |  |  | import com.dy.pipIrrGlobal.voPr.VoIntake; | 
 |  |  | import com.dy.pipIrrGlobal.voPr.VoOnLineIntake; | 
 |  |  | 
 |  |  | import java.io.IOException; | 
 |  |  | import java.io.UnsupportedEncodingException; | 
 |  |  | import java.net.URLEncoder; | 
 |  |  | import java.time.LocalDate; | 
 |  |  | import java.time.format.DateTimeFormatter; | 
 |  |  | import java.util.*; | 
 |  |  |  | 
 |  |  | 
 |  |  |             log.error("保存分水口异常", e); | 
 |  |  |             return BaseResponseUtils.buildException(e.getMessage()); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  | 
 |  |  |      */ | 
 |  |  |     @SneakyThrows(IOException.class) | 
 |  |  |     @GetMapping(value = "exportIntakes") | 
 |  |  |     @SsoAop() | 
 |  |  |     public void exportIntakes(HttpServletResponse response, QueryVo vo) { | 
 |  |  |         setExcelRespProp(response, "取水口列表"); | 
 |  |  |         //List<VoDivide> memberList = LocalJsonUtil.getListFromJson("json/members.json", VoDivide.class); | 
 |  |  |         List<VoIntake> memberList = intakeSv.exportIntakes(vo); | 
 |  |  |         List<VoIntake> intakeList = intakeSv.exportIntakes(vo); | 
 |  |  |  | 
 |  |  |         EasyExcel.write(response.getOutputStream()) | 
 |  |  |                 .head(VoIntake.class) | 
 |  |  |                 .excelType(ExcelTypeEnum.XLSX) | 
 |  |  |                 .sheet("取水口列表") | 
 |  |  |                 .doWrite(memberList); | 
 |  |  |         ExcelUtil.setExcelRespProp(response, "取水口列表" + LocalDate.now()); | 
 |  |  |         EasyExcel.write(response.getOutputStream(), VoIntake.class) | 
 |  |  |                 .registerWriteHandler(new CellWriteHandler("取水口列表")) | 
 |  |  |                 .sheet("取水口") | 
 |  |  |                 .doWrite(intakeList); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     /** |