From c4c7be7e619761aaab55055c1b5e9ffa9bd91068 Mon Sep 17 00:00:00 2001 From: kaiyu <404897439@qq.com> Date: Wed, 11 May 2022 16:50:51 +0800 Subject: [PATCH] screen-api 增加企业整顿导出接口 --- screen-api/src/main/java/com/moral/api/service/RectifyService.java | 3 +++ screen-api/src/main/java/com/moral/api/controller/RectifyController.java | 12 ++++++++++++ screen-api/src/main/java/com/moral/api/service/impl/RectifyServiceImpl.java | 14 ++++++++++++++ 3 files changed, 29 insertions(+), 0 deletions(-) diff --git a/screen-api/src/main/java/com/moral/api/controller/RectifyController.java b/screen-api/src/main/java/com/moral/api/controller/RectifyController.java index c667c5a..5dfac34 100644 --- a/screen-api/src/main/java/com/moral/api/controller/RectifyController.java +++ b/screen-api/src/main/java/com/moral/api/controller/RectifyController.java @@ -13,6 +13,8 @@ import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; +import java.util.Collections; +import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; @@ -63,6 +65,16 @@ return ResultMessage.ok(response); } + @GetMapping("exportRectify") + public ResultMessage exportRectify(HttpServletRequest request) { + Map<String, Object> params = WebUtils.getParametersStartingWith(request, null); + if (params.get("cityCode") == null || params.get("time") == null) { + return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg()); + } + List<Rectify> rectifies = rectifyService.exportRectifyByCityCode(params); + return ResultMessage.ok(rectifies); + } + @PostMapping("updateRectify") public ResultMessage updateRectify(@RequestBody Rectify rectify) { if (rectify.getId() == null) { diff --git a/screen-api/src/main/java/com/moral/api/service/RectifyService.java b/screen-api/src/main/java/com/moral/api/service/RectifyService.java index 60d091d..0eb5400 100644 --- a/screen-api/src/main/java/com/moral/api/service/RectifyService.java +++ b/screen-api/src/main/java/com/moral/api/service/RectifyService.java @@ -28,4 +28,7 @@ //������id������ int deleteRectify(Integer id); + + //������ + List<Rectify> exportRectifyByCityCode(Map<String, Object> params); } diff --git a/screen-api/src/main/java/com/moral/api/service/impl/RectifyServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/RectifyServiceImpl.java index d7fe321..c7cd5cb 100644 --- a/screen-api/src/main/java/com/moral/api/service/impl/RectifyServiceImpl.java +++ b/screen-api/src/main/java/com/moral/api/service/impl/RectifyServiceImpl.java @@ -63,6 +63,20 @@ } @Override + public List<Rectify> exportRectifyByCityCode(Map<String, Object> params) { + //������������������ + Integer cityCode = Integer.parseInt(params.get("cityCode").toString()); + String time = params.get("time").toString(); + + QueryWrapper<Rectify> queryWrapper = new QueryWrapper<>(); + queryWrapper.eq("city_code", cityCode) + .eq("is_delete", Constants.NOT_DELETE) + .likeRight("create_time", time); + List<Rectify> rectifies = rectifyMapper.selectList(queryWrapper); + return rectifies; + } + + @Override public int updateRectify(Rectify rectify) { UpdateWrapper<Rectify> wrapper = new UpdateWrapper<>(); wrapper.eq("id", rectify.getId()); -- Gitblit v1.8.0