diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java index e828464..8ec908f 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java @@ -11,6 +11,7 @@ import javafx.beans.binding.ObjectExpression; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.beans.factory.annotation.Value; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; @@ -36,6 +37,9 @@ @Resource private UserActionService userActionService; + @Value("${casic.file.uploadPath}") + private String path; + /** * 访客信息提交 */ @@ -67,7 +71,7 @@ @RequestMapping("/exportMessage") public Object exportMessage(@RequestBody VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response) { - return visitorApplyService.exportMessage(visitorApplyListRequest,request,response); + return visitorApplyService.exportMessage(visitorApplyListRequest,request,response,path); } @RequestMapping("/getMessageList") diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java index e828464..8ec908f 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java @@ -11,6 +11,7 @@ import javafx.beans.binding.ObjectExpression; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.beans.factory.annotation.Value; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; @@ -36,6 +37,9 @@ @Resource private UserActionService userActionService; + @Value("${casic.file.uploadPath}") + private String path; + /** * 访客信息提交 */ @@ -67,7 +71,7 @@ @RequestMapping("/exportMessage") public Object exportMessage(@RequestBody VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response) { - return visitorApplyService.exportMessage(visitorApplyListRequest,request,response); + return visitorApplyService.exportMessage(visitorApplyListRequest,request,response,path); } @RequestMapping("/getMessageList") diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java b/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java index 32b5597..8e9e26a 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java @@ -25,5 +25,5 @@ Object getMessageList(HttpServletRequest request); - Object exportMessage(VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response); + Object exportMessage(VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response,String path); } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java index e828464..8ec908f 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java @@ -11,6 +11,7 @@ import javafx.beans.binding.ObjectExpression; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.beans.factory.annotation.Value; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; @@ -36,6 +37,9 @@ @Resource private UserActionService userActionService; + @Value("${casic.file.uploadPath}") + private String path; + /** * 访客信息提交 */ @@ -67,7 +71,7 @@ @RequestMapping("/exportMessage") public Object exportMessage(@RequestBody VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response) { - return visitorApplyService.exportMessage(visitorApplyListRequest,request,response); + return visitorApplyService.exportMessage(visitorApplyListRequest,request,response,path); } @RequestMapping("/getMessageList") diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java b/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java index 32b5597..8e9e26a 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java @@ -25,5 +25,5 @@ Object getMessageList(HttpServletRequest request); - Object exportMessage(VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response); + Object exportMessage(VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response,String path); } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java b/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java index 565bef1..4bb9b91 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java @@ -15,11 +15,13 @@ import com.casic.missiles.modular.system.model.VisitorApply; import com.casic.missiles.modular.system.service.UserActionService; import com.casic.missiles.modular.system.service.VisitorApplyService; +import com.casic.missiles.modular.system.utils.ExportUtils; import com.casic.missiles.modular.system.utils.InitialUtils; import com.casic.missiles.modular.system.utils.UuidUtils; import com.casic.missiles.modular.system.utils.WXUserUtils; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.BeanUtils; +import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; @@ -107,10 +109,10 @@ @Override public Object updateStatus(VisitorApplyStatusRequest visitorApplyStatusRequest, HttpServletRequest request) { try { - /*JSONObject jsonObject = userActionService.getLoginStatus(request); + JSONObject jsonObject = userActionService.getLoginStatus(request); if(null == jsonObject){ return ResponseData.error(2401,Status.TOKEN_EXPIRES); - }*/ + } String[] split = visitorApplyStatusRequest.getIds().split(","); for (String id : split) { VisitorApply visitorApply = new VisitorApply(); @@ -173,7 +175,7 @@ } @Override - public Object exportMessage(VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response) { + public Object exportMessage(VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response,String path) { try { String[] split = visitorApplyListRequest.getIds().split(","); List list = new ArrayList<>(Arrays.asList(split)); @@ -183,9 +185,11 @@ visitorApplyList.forEach(visitorApply -> { visitorApply.setVisitorApplyStatus(""); }); - iBaseExportService.exportExcel(response,VisitorApply.class,visitorApplyList,"sheet"); - return ResponseData.error(Status.OK); - } catch (IOException e) { + String url = path+"file.xls"+new Date().getTime(); + ExportUtils.excel(visitorApplyList,url); + //iBaseExportService.exportExcel(response,VisitorApply.class,visitorApplyList,"sheet"); + return ResponseData.error(url); + } catch (Exception e) { e.printStackTrace(); return ResponseData.error(Status.FAIL); } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java index e828464..8ec908f 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java @@ -11,6 +11,7 @@ import javafx.beans.binding.ObjectExpression; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.beans.factory.annotation.Value; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; @@ -36,6 +37,9 @@ @Resource private UserActionService userActionService; + @Value("${casic.file.uploadPath}") + private String path; + /** * 访客信息提交 */ @@ -67,7 +71,7 @@ @RequestMapping("/exportMessage") public Object exportMessage(@RequestBody VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response) { - return visitorApplyService.exportMessage(visitorApplyListRequest,request,response); + return visitorApplyService.exportMessage(visitorApplyListRequest,request,response,path); } @RequestMapping("/getMessageList") diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java b/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java index 32b5597..8e9e26a 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java @@ -25,5 +25,5 @@ Object getMessageList(HttpServletRequest request); - Object exportMessage(VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response); + Object exportMessage(VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response,String path); } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java b/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java index 565bef1..4bb9b91 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java @@ -15,11 +15,13 @@ import com.casic.missiles.modular.system.model.VisitorApply; import com.casic.missiles.modular.system.service.UserActionService; import com.casic.missiles.modular.system.service.VisitorApplyService; +import com.casic.missiles.modular.system.utils.ExportUtils; import com.casic.missiles.modular.system.utils.InitialUtils; import com.casic.missiles.modular.system.utils.UuidUtils; import com.casic.missiles.modular.system.utils.WXUserUtils; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.BeanUtils; +import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; @@ -107,10 +109,10 @@ @Override public Object updateStatus(VisitorApplyStatusRequest visitorApplyStatusRequest, HttpServletRequest request) { try { - /*JSONObject jsonObject = userActionService.getLoginStatus(request); + JSONObject jsonObject = userActionService.getLoginStatus(request); if(null == jsonObject){ return ResponseData.error(2401,Status.TOKEN_EXPIRES); - }*/ + } String[] split = visitorApplyStatusRequest.getIds().split(","); for (String id : split) { VisitorApply visitorApply = new VisitorApply(); @@ -173,7 +175,7 @@ } @Override - public Object exportMessage(VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response) { + public Object exportMessage(VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response,String path) { try { String[] split = visitorApplyListRequest.getIds().split(","); List list = new ArrayList<>(Arrays.asList(split)); @@ -183,9 +185,11 @@ visitorApplyList.forEach(visitorApply -> { visitorApply.setVisitorApplyStatus(""); }); - iBaseExportService.exportExcel(response,VisitorApply.class,visitorApplyList,"sheet"); - return ResponseData.error(Status.OK); - } catch (IOException e) { + String url = path+"file.xls"+new Date().getTime(); + ExportUtils.excel(visitorApplyList,url); + //iBaseExportService.exportExcel(response,VisitorApply.class,visitorApplyList,"sheet"); + return ResponseData.error(url); + } catch (Exception e) { e.printStackTrace(); return ResponseData.error(Status.FAIL); } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/utils/ExportUtils.java b/casic-server/src/main/java/com/casic/missiles/modular/system/utils/ExportUtils.java new file mode 100644 index 0000000..7b36654 --- /dev/null +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/utils/ExportUtils.java @@ -0,0 +1,91 @@ +package com.casic.missiles.modular.system.utils; + +import com.casic.missiles.modular.system.model.VisitorApply; +import org.apache.poi.hssf.usermodel.*; +import org.apache.poi.hssf.util.HSSFColor; +import org.apache.poi.ss.usermodel.BorderStyle; +import org.apache.poi.ss.usermodel.HorizontalAlignment; +import org.apache.poi.ss.usermodel.VerticalAlignment; + +import java.io.*; +import java.util.List; + +/** + * @author QY + * @since 2020-08-03 + * @description 使用easyExcel来导出xlsx的工具类 + */ +public class ExportUtils { + + public static void excel(List list, String filePath) throws IOException { + //导出路径 + FileOutputStream output = new FileOutputStream(filePath); + try { + //创建HSSFWorkbook对象 + HSSFWorkbook wb = new HSSFWorkbook(); + //创建HSSFSheet对象 + HSSFSheet sheet = wb.createSheet("sheet"); + //创建HSSFRow对象 + HSSFRow row = sheet.createRow(0); +/* + HSSFCellStyle cellStyle=wb.createCellStyle(); + cellStyle.setVerticalAlignment(VerticalAlignment.CENTER); + cellStyle.setAlignment(HorizontalAlignment.CENTER); + // 设置边框 + cellStyle.setBorderBottom(BorderStyle.THIN); + cellStyle.setBorderLeft(BorderStyle.THIN); + cellStyle.setBorderRight(BorderStyle.THIN); + cellStyle.setBorderTop(BorderStyle.THIN); + HSSFFont fontStyle=wb.createFont(); + fontStyle.setFontName( "宋体" ); + fontStyle.setFontHeightInPoints(( short ) 20 ); + row.setRowStyle(cellStyle);*/ + //设置表头 + row.createCell(0).setCellValue("访客申请单号"); + row.createCell(1).setCellValue("访客姓名"); + row.createCell(2).setCellValue("访客身份证"); + row.createCell(3).setCellValue("访客联系方式"); + row.createCell(4).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("状态"); + row.createCell(12).setCellValue("备注"); + row = sheet.createRow(sheet.getLastRowNum() + 1); + //循环遍历集合，生成表格 + for(VisitorApply cc : list) { + row.createCell(0).setCellValue(cc.getApplyNo()); + row.createCell(1).setCellValue(cc.getVisitorName()); + row.createCell(2).setCellValue(cc.getVisitorIdCard()); + row.createCell(3).setCellValue(cc.getVisitorPhone()); + row.createCell(4).setCellValue(cc.getVisitReason()); + row.createCell(5).setCellValue(cc.getVisitPosition()); + row.createCell(6).setCellValue(cc.getInTime()); + row.createCell(7).setCellValue(cc.getOutTime()); + row.createCell(8).setCellValue(cc.getStaffCode()); + row.createCell(9).setCellValue(cc.getStaffName()); + row.createCell(10).setCellValue(cc.getStaffPhone()); + row.createCell(11).setCellValue(""); + row.createCell(12).setCellValue(cc.getRemarks()); + row = sheet.createRow(row.getRowNum() + 1); + } + File file = new File(filePath); + if(file.exists()){ + file.delete(); + } + //输出Excel文件 + output.flush(); + wb.write(output); + } catch (Exception e) { + e.printStackTrace(); + }finally { + output.close(); + } + } + + + +} diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java index e828464..8ec908f 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java @@ -11,6 +11,7 @@ import javafx.beans.binding.ObjectExpression; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.beans.factory.annotation.Value; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; @@ -36,6 +37,9 @@ @Resource private UserActionService userActionService; + @Value("${casic.file.uploadPath}") + private String path; + /** * 访客信息提交 */ @@ -67,7 +71,7 @@ @RequestMapping("/exportMessage") public Object exportMessage(@RequestBody VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response) { - return visitorApplyService.exportMessage(visitorApplyListRequest,request,response); + return visitorApplyService.exportMessage(visitorApplyListRequest,request,response,path); } @RequestMapping("/getMessageList") diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java b/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java index 32b5597..8e9e26a 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java @@ -25,5 +25,5 @@ Object getMessageList(HttpServletRequest request); - Object exportMessage(VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response); + Object exportMessage(VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response,String path); } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java b/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java index 565bef1..4bb9b91 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java @@ -15,11 +15,13 @@ import com.casic.missiles.modular.system.model.VisitorApply; import com.casic.missiles.modular.system.service.UserActionService; import com.casic.missiles.modular.system.service.VisitorApplyService; +import com.casic.missiles.modular.system.utils.ExportUtils; import com.casic.missiles.modular.system.utils.InitialUtils; import com.casic.missiles.modular.system.utils.UuidUtils; import com.casic.missiles.modular.system.utils.WXUserUtils; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.BeanUtils; +import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; @@ -107,10 +109,10 @@ @Override public Object updateStatus(VisitorApplyStatusRequest visitorApplyStatusRequest, HttpServletRequest request) { try { - /*JSONObject jsonObject = userActionService.getLoginStatus(request); + JSONObject jsonObject = userActionService.getLoginStatus(request); if(null == jsonObject){ return ResponseData.error(2401,Status.TOKEN_EXPIRES); - }*/ + } String[] split = visitorApplyStatusRequest.getIds().split(","); for (String id : split) { VisitorApply visitorApply = new VisitorApply(); @@ -173,7 +175,7 @@ } @Override - public Object exportMessage(VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response) { + public Object exportMessage(VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response,String path) { try { String[] split = visitorApplyListRequest.getIds().split(","); List list = new ArrayList<>(Arrays.asList(split)); @@ -183,9 +185,11 @@ visitorApplyList.forEach(visitorApply -> { visitorApply.setVisitorApplyStatus(""); }); - iBaseExportService.exportExcel(response,VisitorApply.class,visitorApplyList,"sheet"); - return ResponseData.error(Status.OK); - } catch (IOException e) { + String url = path+"file.xls"+new Date().getTime(); + ExportUtils.excel(visitorApplyList,url); + //iBaseExportService.exportExcel(response,VisitorApply.class,visitorApplyList,"sheet"); + return ResponseData.error(url); + } catch (Exception e) { e.printStackTrace(); return ResponseData.error(Status.FAIL); } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/utils/ExportUtils.java b/casic-server/src/main/java/com/casic/missiles/modular/system/utils/ExportUtils.java new file mode 100644 index 0000000..7b36654 --- /dev/null +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/utils/ExportUtils.java @@ -0,0 +1,91 @@ +package com.casic.missiles.modular.system.utils; + +import com.casic.missiles.modular.system.model.VisitorApply; +import org.apache.poi.hssf.usermodel.*; +import org.apache.poi.hssf.util.HSSFColor; +import org.apache.poi.ss.usermodel.BorderStyle; +import org.apache.poi.ss.usermodel.HorizontalAlignment; +import org.apache.poi.ss.usermodel.VerticalAlignment; + +import java.io.*; +import java.util.List; + +/** + * @author QY + * @since 2020-08-03 + * @description 使用easyExcel来导出xlsx的工具类 + */ +public class ExportUtils { + + public static void excel(List list, String filePath) throws IOException { + //导出路径 + FileOutputStream output = new FileOutputStream(filePath); + try { + //创建HSSFWorkbook对象 + HSSFWorkbook wb = new HSSFWorkbook(); + //创建HSSFSheet对象 + HSSFSheet sheet = wb.createSheet("sheet"); + //创建HSSFRow对象 + HSSFRow row = sheet.createRow(0); +/* + HSSFCellStyle cellStyle=wb.createCellStyle(); + cellStyle.setVerticalAlignment(VerticalAlignment.CENTER); + cellStyle.setAlignment(HorizontalAlignment.CENTER); + // 设置边框 + cellStyle.setBorderBottom(BorderStyle.THIN); + cellStyle.setBorderLeft(BorderStyle.THIN); + cellStyle.setBorderRight(BorderStyle.THIN); + cellStyle.setBorderTop(BorderStyle.THIN); + HSSFFont fontStyle=wb.createFont(); + fontStyle.setFontName( "宋体" ); + fontStyle.setFontHeightInPoints(( short ) 20 ); + row.setRowStyle(cellStyle);*/ + //设置表头 + row.createCell(0).setCellValue("访客申请单号"); + row.createCell(1).setCellValue("访客姓名"); + row.createCell(2).setCellValue("访客身份证"); + row.createCell(3).setCellValue("访客联系方式"); + row.createCell(4).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("状态"); + row.createCell(12).setCellValue("备注"); + row = sheet.createRow(sheet.getLastRowNum() + 1); + //循环遍历集合，生成表格 + for(VisitorApply cc : list) { + row.createCell(0).setCellValue(cc.getApplyNo()); + row.createCell(1).setCellValue(cc.getVisitorName()); + row.createCell(2).setCellValue(cc.getVisitorIdCard()); + row.createCell(3).setCellValue(cc.getVisitorPhone()); + row.createCell(4).setCellValue(cc.getVisitReason()); + row.createCell(5).setCellValue(cc.getVisitPosition()); + row.createCell(6).setCellValue(cc.getInTime()); + row.createCell(7).setCellValue(cc.getOutTime()); + row.createCell(8).setCellValue(cc.getStaffCode()); + row.createCell(9).setCellValue(cc.getStaffName()); + row.createCell(10).setCellValue(cc.getStaffPhone()); + row.createCell(11).setCellValue(""); + row.createCell(12).setCellValue(cc.getRemarks()); + row = sheet.createRow(row.getRowNum() + 1); + } + File file = new File(filePath); + if(file.exists()){ + file.delete(); + } + //输出Excel文件 + output.flush(); + wb.write(output); + } catch (Exception e) { + e.printStackTrace(); + }finally { + output.close(); + } + } + + + +} diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/utils/JJWTRootUtils.java b/casic-server/src/main/java/com/casic/missiles/modular/system/utils/JJWTRootUtils.java index 6fd6672..a3b0dea 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/utils/JJWTRootUtils.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/utils/JJWTRootUtils.java @@ -93,21 +93,5 @@ return header; } - - public static void main(String[] args) { - //随机获取盐值 -// System.out.println(UUID.randomUUID().toString().replaceAll("-", "")); - Map payLoad = new HashMap<>(); - payLoad.put("name", "curry"); - String s = generatorToken(payLoad); - //eyJhbGciOiJIUzI1NiJ9.eyJuYW1lIjoiY3VycnkifQ.Sf3GiF3p56nLzoAxEHLXcAckPmmPTtecj1_lGT9oV8s - System.out.println(s); - - //调用自定义API获取结果 - Claims claims = phaseTokenGetBody(s); - //{name=curry} - System.out.println(claims); - } - } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java index e828464..8ec908f 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/VisitController.java @@ -11,6 +11,7 @@ import javafx.beans.binding.ObjectExpression; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.beans.factory.annotation.Value; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; @@ -36,6 +37,9 @@ @Resource private UserActionService userActionService; + @Value("${casic.file.uploadPath}") + private String path; + /** * 访客信息提交 */ @@ -67,7 +71,7 @@ @RequestMapping("/exportMessage") public Object exportMessage(@RequestBody VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response) { - return visitorApplyService.exportMessage(visitorApplyListRequest,request,response); + return visitorApplyService.exportMessage(visitorApplyListRequest,request,response,path); } @RequestMapping("/getMessageList") diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java b/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java index 32b5597..8e9e26a 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/service/VisitorApplyService.java @@ -25,5 +25,5 @@ Object getMessageList(HttpServletRequest request); - Object exportMessage(VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response); + Object exportMessage(VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response,String path); } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java b/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java index 565bef1..4bb9b91 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java @@ -15,11 +15,13 @@ import com.casic.missiles.modular.system.model.VisitorApply; import com.casic.missiles.modular.system.service.UserActionService; import com.casic.missiles.modular.system.service.VisitorApplyService; +import com.casic.missiles.modular.system.utils.ExportUtils; import com.casic.missiles.modular.system.utils.InitialUtils; import com.casic.missiles.modular.system.utils.UuidUtils; import com.casic.missiles.modular.system.utils.WXUserUtils; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.BeanUtils; +import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; @@ -107,10 +109,10 @@ @Override public Object updateStatus(VisitorApplyStatusRequest visitorApplyStatusRequest, HttpServletRequest request) { try { - /*JSONObject jsonObject = userActionService.getLoginStatus(request); + JSONObject jsonObject = userActionService.getLoginStatus(request); if(null == jsonObject){ return ResponseData.error(2401,Status.TOKEN_EXPIRES); - }*/ + } String[] split = visitorApplyStatusRequest.getIds().split(","); for (String id : split) { VisitorApply visitorApply = new VisitorApply(); @@ -173,7 +175,7 @@ } @Override - public Object exportMessage(VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response) { + public Object exportMessage(VisitorApplyListRequest visitorApplyListRequest, HttpServletRequest request, HttpServletResponse response,String path) { try { String[] split = visitorApplyListRequest.getIds().split(","); List list = new ArrayList<>(Arrays.asList(split)); @@ -183,9 +185,11 @@ visitorApplyList.forEach(visitorApply -> { visitorApply.setVisitorApplyStatus(""); }); - iBaseExportService.exportExcel(response,VisitorApply.class,visitorApplyList,"sheet"); - return ResponseData.error(Status.OK); - } catch (IOException e) { + String url = path+"file.xls"+new Date().getTime(); + ExportUtils.excel(visitorApplyList,url); + //iBaseExportService.exportExcel(response,VisitorApply.class,visitorApplyList,"sheet"); + return ResponseData.error(url); + } catch (Exception e) { e.printStackTrace(); return ResponseData.error(Status.FAIL); } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/utils/ExportUtils.java b/casic-server/src/main/java/com/casic/missiles/modular/system/utils/ExportUtils.java new file mode 100644 index 0000000..7b36654 --- /dev/null +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/utils/ExportUtils.java @@ -0,0 +1,91 @@ +package com.casic.missiles.modular.system.utils; + +import com.casic.missiles.modular.system.model.VisitorApply; +import org.apache.poi.hssf.usermodel.*; +import org.apache.poi.hssf.util.HSSFColor; +import org.apache.poi.ss.usermodel.BorderStyle; +import org.apache.poi.ss.usermodel.HorizontalAlignment; +import org.apache.poi.ss.usermodel.VerticalAlignment; + +import java.io.*; +import java.util.List; + +/** + * @author QY + * @since 2020-08-03 + * @description 使用easyExcel来导出xlsx的工具类 + */ +public class ExportUtils { + + public static void excel(List list, String filePath) throws IOException { + //导出路径 + FileOutputStream output = new FileOutputStream(filePath); + try { + //创建HSSFWorkbook对象 + HSSFWorkbook wb = new HSSFWorkbook(); + //创建HSSFSheet对象 + HSSFSheet sheet = wb.createSheet("sheet"); + //创建HSSFRow对象 + HSSFRow row = sheet.createRow(0); +/* + HSSFCellStyle cellStyle=wb.createCellStyle(); + cellStyle.setVerticalAlignment(VerticalAlignment.CENTER); + cellStyle.setAlignment(HorizontalAlignment.CENTER); + // 设置边框 + cellStyle.setBorderBottom(BorderStyle.THIN); + cellStyle.setBorderLeft(BorderStyle.THIN); + cellStyle.setBorderRight(BorderStyle.THIN); + cellStyle.setBorderTop(BorderStyle.THIN); + HSSFFont fontStyle=wb.createFont(); + fontStyle.setFontName( "宋体" ); + fontStyle.setFontHeightInPoints(( short ) 20 ); + row.setRowStyle(cellStyle);*/ + //设置表头 + row.createCell(0).setCellValue("访客申请单号"); + row.createCell(1).setCellValue("访客姓名"); + row.createCell(2).setCellValue("访客身份证"); + row.createCell(3).setCellValue("访客联系方式"); + row.createCell(4).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("状态"); + row.createCell(12).setCellValue("备注"); + row = sheet.createRow(sheet.getLastRowNum() + 1); + //循环遍历集合，生成表格 + for(VisitorApply cc : list) { + row.createCell(0).setCellValue(cc.getApplyNo()); + row.createCell(1).setCellValue(cc.getVisitorName()); + row.createCell(2).setCellValue(cc.getVisitorIdCard()); + row.createCell(3).setCellValue(cc.getVisitorPhone()); + row.createCell(4).setCellValue(cc.getVisitReason()); + row.createCell(5).setCellValue(cc.getVisitPosition()); + row.createCell(6).setCellValue(cc.getInTime()); + row.createCell(7).setCellValue(cc.getOutTime()); + row.createCell(8).setCellValue(cc.getStaffCode()); + row.createCell(9).setCellValue(cc.getStaffName()); + row.createCell(10).setCellValue(cc.getStaffPhone()); + row.createCell(11).setCellValue(""); + row.createCell(12).setCellValue(cc.getRemarks()); + row = sheet.createRow(row.getRowNum() + 1); + } + File file = new File(filePath); + if(file.exists()){ + file.delete(); + } + //输出Excel文件 + output.flush(); + wb.write(output); + } catch (Exception e) { + e.printStackTrace(); + }finally { + output.close(); + } + } + + + +} diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/utils/JJWTRootUtils.java b/casic-server/src/main/java/com/casic/missiles/modular/system/utils/JJWTRootUtils.java index 6fd6672..a3b0dea 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/utils/JJWTRootUtils.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/utils/JJWTRootUtils.java @@ -93,21 +93,5 @@ return header; } - - public static void main(String[] args) { - //随机获取盐值 -// System.out.println(UUID.randomUUID().toString().replaceAll("-", "")); - Map payLoad = new HashMap<>(); - payLoad.put("name", "curry"); - String s = generatorToken(payLoad); - //eyJhbGciOiJIUzI1NiJ9.eyJuYW1lIjoiY3VycnkifQ.Sf3GiF3p56nLzoAxEHLXcAckPmmPTtecj1_lGT9oV8s - System.out.println(s); - - //调用自定义API获取结果 - Claims claims = phaseTokenGetBody(s); - //{name=curry} - System.out.println(claims); - } - } diff --git a/casic-web/src/main/resources/mapper/VisitorApplyMapper.xml b/casic-web/src/main/resources/mapper/VisitorApplyMapper.xml index 1eb0ec0..e81414d 100644 --- a/casic-web/src/main/resources/mapper/VisitorApplyMapper.xml +++ b/casic-web/src/main/resources/mapper/VisitorApplyMapper.xml @@ -20,9 +20,6 @@ and visitor_apply_status = #{request.status} - - and id in #{item} - ORDER BY create_time DESC