| | |
|---|
| | | //导出 |
|---|
| | | @Override |
|---|
| | | public void exportWorkingHours(HttpServletResponse response) throws IOException { |
|---|
| | | List<AuxiliaryOutputWorkingHoursDto> auxiliaryOutputWorkingHoursDtos = null; |
|---|
| | | List<AuxiliaryWorkingHoursDayDto> auxiliaryWorkingHoursDayDtos = null; |
|---|
| | | List<AuxiliaryOutputWorkingHoursDto> auxiliaryOutputWorkingHoursDtos = new ArrayList<>(); |
|---|
| | | List<AuxiliaryWorkingHoursDayDto> auxiliaryWorkingHoursDayDtos = new ArrayList<>(); |
|---|
| | | List<Integer> ids = null; |
|---|
| | | //判断是组长还是组员还是管理员 |
|---|
| | | Map<String, Integer> map1 = getLook.selectPowerByMethodAndUserId("selectAuxiliaryOutputWorkingHours"); |
|---|
| | |
|---|
| | | response.setContentType("application/vnd.ms-excel"); |
|---|
| | | response.setCharacterEncoding("UTF-8"); |
|---|
| | | // 这里URLEncoder.encode可以防止中文乱码 当然和easyexcel没有关系 |
|---|
| | | String fileName = URLEncoder.encode("工时管理导出", "UTF-8"); |
|---|
| | | String fileName = URLEncoder.encode("日工时管理导出", "UTF-8"); |
|---|
| | | response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx"); |
|---|
| | | try { |
|---|
| | | // 新建ExcelWriter |
|---|
