From 3d665d84b1a4ffd6749ca9354247838ce0622f4b Mon Sep 17 00:00:00 2001
From: jinpengyong <jpy123456>
Date: Tue, 13 Dec 2022 13:47:53 +0800
Subject: [PATCH] 修改sql语句问题
---
screen-api/src/main/java/com/moral/api/service/impl/RectifyServiceImpl.java | 14 ++++++++++++++
1 files changed, 14 insertions(+), 0 deletions(-)
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