From 0414ddb0b2b3a7199ae6181a770f97ac140dbd73 Mon Sep 17 00:00:00 2001 From: zhangf <1603559716@qq.com> Date: 星期三, 08 五月 2024 16:46:22 +0800 Subject: [PATCH] spi统计 --- goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/TargetDutySummaryController.java | 54 ++++++++++++++---------------------------------------- 1 files changed, 14 insertions(+), 40 deletions(-) diff --git a/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/TargetDutySummaryController.java b/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/TargetDutySummaryController.java index 510f3b9..5cf32ba 100644 --- a/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/TargetDutySummaryController.java +++ b/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/TargetDutySummaryController.java @@ -13,6 +13,7 @@ import com.gkhy.safePlatform.targetDuty.entity.TargetMng; import com.gkhy.safePlatform.targetDuty.model.dto.resp.TargetDutySummaryExcel; import com.gkhy.safePlatform.targetDuty.service.TargetDutySummaryService; +import com.gkhy.safePlatform.targetDuty.service.baseService.TargetDutySummaryBaseService; import com.gkhy.safePlatform.targetDuty.utils.DateUtils; import com.gkhy.safePlatform.targetDuty.utils.poihelper.ExcelUtil; import org.springframework.beans.factory.annotation.Autowired; @@ -45,6 +46,9 @@ @Resource private TargetDutySummaryService targetDutySummaryService; + @Resource + private TargetDutySummaryBaseService targetDutySummaryBaseService; + @Autowired public HttpServletRequest request; @@ -59,10 +63,10 @@ */ @PostMapping(value = "/page/list") public ResultVO selectAll(@RequestBody PageQuery<TargetDutySummaryQueryCriteria> pageQuery){ - PageUtils.checkCheck(pageQuery); + PageUtils.checkCheck(pageQuery); return this.targetDutySummaryService.queryAll(pageQuery); } - + /** * 通过主键查询单条数据 @@ -72,7 +76,7 @@ */ @GetMapping(value = "/selectOne/{id}") public ResultVO selectOne(@PathVariable Serializable id) { - return new ResultVO<>(ResultCodes.OK,this.targetDutySummaryService.getById(id)); + return new ResultVO<>(ResultCodes.OK,this.targetDutySummaryBaseService.getById(id)); } /** @@ -84,9 +88,9 @@ @PostMapping(value = "/addOrUpdate") public ResultVO update(@RequestBody TargetDutySummary targetDutySummary) { if (targetDutySummary.getId() == null) { - return new ResultVO<>(ResultCodes.OK,targetDutySummaryService.save(targetDutySummary)); + return new ResultVO<>(ResultCodes.OK,targetDutySummaryBaseService.save(targetDutySummary)); } else { - targetDutySummaryService.update(targetDutySummary,new UpdateWrapper<TargetDutySummary>().eq("id",targetDutySummary.getId())); + targetDutySummaryBaseService.update(targetDutySummary,new UpdateWrapper<TargetDutySummary>().eq("id",targetDutySummary.getId())); return new ResultVO<>(ResultCodes.OK); } } @@ -97,11 +101,9 @@ * @param ids 主键结合 * @return 删除结果 */ - @GetMapping(value = "/delete") - public ResultVO delete(String ids) { - List<String> idList = Arrays.stream(ids.split(",")) - .collect(Collectors.toList()); - this.targetDutySummaryService.removeByIds(idList); + @RequestMapping(value = "/delete",method = RequestMethod.POST) + public ResultVO delete(@RequestBody Long[] ids) { + this.targetDutySummaryService.delete(ids); return new ResultVO<>(ResultCodes.OK); } @@ -111,35 +113,7 @@ */ @GetMapping(value = "/exportData") public void exportData(TargetDutySummaryQueryCriteria queryCriteria) throws IOException { - Map<String,String> map = new LinkedHashMap<>(); - map.put("1","责任部门"); - map.put("2","安全目标指标"); - map.put("3","考核指标"); - map.put("4","1月"); - map.put("5","2月"); - map.put("6","3月"); - map.put("7","4月"); - map.put("8","5月"); - map.put("9","6月"); - map.put("10","7月"); - map.put("11","8月"); - map.put("12","9月"); - map.put("13","10月"); - map.put("14","11月"); - map.put("15","12月"); - map.put("16","考核结果"); - - 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<TargetDutySummaryExcel> respList = BeanCopyUtils.copyBeanList(targetDutySummaryService.queryAll(queryCriteria), TargetDutySummaryExcel.class); - - ExcelUtil.exportExcel(map,respList , response.getOutputStream(),DateUtils.PATTERN_STANDARD); - response.getOutputStream().close(); + targetDutySummaryService.exportData(queryCriteria); } public static void main(String[] args) { @@ -166,4 +140,4 @@ System.out.println(JSONObject.toJSONString(mng)); } -} +} \ No newline at end of file -- Gitblit v1.9.2