From 6f3433551682ed596fe2c75ce0eb4181e550f053 Mon Sep 17 00:00:00 2001 From: SZH <szh_hello@163.com> Date: 星期五, 16 九月 2022 14:47:30 +0800 Subject: [PATCH] 修改配置文件 --- goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/TargetMngController.java | 83 ++++++----------------------------------- 1 files changed, 12 insertions(+), 71 deletions(-) diff --git a/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/TargetMngController.java b/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/TargetMngController.java index 68f0a8b..e8904ce 100644 --- a/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/TargetMngController.java +++ b/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/TargetMngController.java @@ -17,6 +17,7 @@ import com.gkhy.safePlatform.targetDuty.model.dto.resp.TargetMngExcel; import com.gkhy.safePlatform.targetDuty.service.TargetDivideDetailService; import com.gkhy.safePlatform.targetDuty.service.TargetMngService; +import com.gkhy.safePlatform.targetDuty.service.baseService.TargetMngBaseService; import com.gkhy.safePlatform.targetDuty.utils.DateUtils; import com.gkhy.safePlatform.targetDuty.utils.poihelper.ExcelLogs; import com.gkhy.safePlatform.targetDuty.utils.poihelper.ExcelUtil; @@ -51,7 +52,8 @@ @Resource private TargetMngService targetMngService; @Resource - private TargetDivideDetailService targetDivideDetailService; + private TargetMngBaseService targetMngBaseService; + @Autowired public HttpServletRequest request; @@ -67,10 +69,7 @@ */ @PostMapping(value = "/page/list") public ResultVO selectAll(@RequestBody PageQuery<TargetMngQueryCriteria> pageQuery){ - if(pageQuery.getSearchParams().getTargetType() == null){ - return new ResultVO<>(ResultCodes.CLIENT_PARAM_ILLEGAL,"缺少targetType"); - } - PageUtils.checkCheck(pageQuery); + return this.targetMngService.queryAll(pageQuery); } @@ -95,15 +94,15 @@ @PostMapping(value = "/addOrUpdate") public ResultVO update(@RequestBody TargetMng targetMng) { - if( !StringUtils.hasText(targetMng.getQName()) || !StringUtils.hasText(targetMng.getIndexNum()) + if( !StringUtils.hasText(targetMng.getqName()) || !StringUtils.hasText(targetMng.getIndexNum()) || !StringUtils.hasText(targetMng.getYear()) || !StringUtils.hasText(targetMng.getValue()) || targetMng.getTargetType() == null){ return new ResultVO<>(ResultCodes.CLIENT_PARAM_ILLEGAL,"缺少必填字段"); } if (targetMng.getId() == null) { - return new ResultVO<>(ResultCodes.OK,targetMngService.save(targetMng)); + return new ResultVO<>(ResultCodes.OK,targetMngBaseService.save(targetMng)); } else { - targetMngService.update(targetMng,new UpdateWrapper<TargetMng>().eq("id",targetMng.getId())); + targetMngBaseService.update(targetMng,new UpdateWrapper<TargetMng>().eq("id",targetMng.getId())); return new ResultVO<>(ResultCodes.OK); } } @@ -116,14 +115,7 @@ */ @RequestMapping(value = "/delete",method = RequestMethod.POST) public ResultVO delete(@RequestBody Long[] ids) { - if(ids == null){ - return new ResultVO<>(ResultCodes.CLIENT_PARAM_ILLEGAL); - } - List<Long> idList = Arrays.asList(ids); - //删除关联表数据 - this.targetDivideDetailService.remove(new QueryWrapper<TargetDivideDetail>().in("target_id",idList)); - - this.targetMngService.removeByIds(idList); + this.targetMngService.delete(ids); return new ResultVO<>(ResultCodes.OK); } @@ -133,23 +125,7 @@ */ @GetMapping(value = "/exportTemplate") public void exportTemplate() throws IOException { - Map<String,String> map = new LinkedHashMap<>(); - map.put("1","安全目标指标"); - map.put("2","目标指标编号"); - map.put("3","指标类型 1:年指标 2:月指标 3:半年 4:季度"); - map.put("4","年度"); - map.put("5","指标值"); - map.put("6","指标级别 1:公司级 2:部门分厂级 3:工段班组级"); - map.put("7","完成期限(yyyy-MM-dd HH:mm:ss)"); - map.put("8","备注信息"); - - String fileName = URLEncoder.encode("目标设置数据导入模板.xls", "UTF-8"); - response.setContentType("application/vnd.ms-excel"); - response.setHeader("Content-Disposition", "attachment;filename=" + fileName + ".xlsx"); - response.setHeader("Access-Control-Expose-Headers", "Content-Disposition"); - - ExcelUtil.exportExcel(map,new ArrayList<>() , response.getOutputStream()); - response.getOutputStream().close(); + targetMngService.exportTemplate(); } /** @@ -158,28 +134,7 @@ */ @GetMapping(value = "/exportData") public void exportData(TargetMngQueryCriteria queryCriteria) throws IOException { - Map<String,String> map = new LinkedHashMap<>(); - map.put("1","安全目标指标"); - map.put("2","目标指标编号"); - map.put("3","年度"); - map.put("4","指标值"); - map.put("5","指标级别"); - map.put("6","指标类型"); - map.put("7","完成期限"); - map.put("8","状态"); - map.put("9","备注信息"); - - String key = DateUtils.date2String(new Date(), DateUtils.PATTERN_ALLTIME_NOSIGN) ; - String fileName = URLEncoder.encode("目标设置"+key+".xls", "UTF-8"); - response.setContentType("application/vnd.ms-excel"); - response.setHeader("Content-Disposition", "attachment;filename=" + fileName + ".xlsx"); - response.setHeader("Access-Control-Expose-Headers", "Content-Disposition"); - - - List<TargetMngExcel> respList = BeanCopyUtils.copyBeanList(targetMngService.queryAll(queryCriteria), TargetMngExcel.class); - - ExcelUtil.exportExcel(map,respList , response.getOutputStream(),DateUtils.PATTERN_STANDARD); - response.getOutputStream().close(); + targetMngService.exportData(queryCriteria); } /** @@ -188,21 +143,7 @@ */ @RequestMapping(value = "/importData") public ResultVO importData(MultipartFile file) throws IOException { - String contentType = file.getContentType(); - if(!"application/vnd.ms-excel".equals(contentType) - && !"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet".equals(contentType)) { - return new ResultVO<>(ResultCodes.CLIENT_PARAM_ILLEGAL, "上传的excel格式错误"); - } - - Collection<TargetMngImportExcel> importExcel = ExcelUtil.importExcel(TargetMngImportExcel.class, file.getInputStream(), "yyyy-MM-dd HH:mm:ss", new ExcelLogs() , 0); - - if (CollectionUtils.isEmpty(importExcel)) { - return new ResultVO<>(ResultCodes.OK); - } - - List<TargetMng> respList = BeanCopyUtils.copyBeanList((List<TargetMngImportExcel>)importExcel, TargetMng.class); - - targetMngService.saveBatch(respList); + targetMngService.importData(file); return new ResultVO<>(ResultCodes.OK); } @@ -237,7 +178,7 @@ public static void main(String[] args) { TargetMng mng = new TargetMng(); - mng.setQName("12"); + mng.setqName("12"); mng.setIndexNum("3"); mng.setYear("2021"); mng.setValue("312"); -- Gitblit v1.9.2