From 2a600eae2ad4bab763ae61f2fe362298eec78d09 Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Sat, 03 Feb 2024 15:22:26 +0800
Subject: [PATCH] 代码优化
---
src/main/java/org/springblade/modules/place/mapper/PlaceCheckMapper.xml | 3 ---
src/main/java/org/springblade/modules/taskPlaceRectification/mapper/TaskPlaceRectificationMapper.xml | 6 +-----
2 files changed, 1 insertions(+), 8 deletions(-)
diff --git a/src/main/java/org/springblade/modules/place/mapper/PlaceCheckMapper.xml b/src/main/java/org/springblade/modules/place/mapper/PlaceCheckMapper.xml
index 649a479..f0d827b 100644
--- a/src/main/java/org/springblade/modules/place/mapper/PlaceCheckMapper.xml
+++ b/src/main/java/org/springblade/modules/place/mapper/PlaceCheckMapper.xml
@@ -132,9 +132,6 @@
and date_format(jpc.create_time,'%Y-%m-%d') <= #{placeCheck.endTime}
</if>
- and jpc.create_time=(
- SELECT MAX(create_time) FROM jczz_place_check where jpc.house_code=house_code
- )
order by jpc.create_time desc
</select>
diff --git a/src/main/java/org/springblade/modules/taskPlaceRectification/mapper/TaskPlaceRectificationMapper.xml b/src/main/java/org/springblade/modules/taskPlaceRectification/mapper/TaskPlaceRectificationMapper.xml
index 045adea..1c55c13 100644
--- a/src/main/java/org/springblade/modules/taskPlaceRectification/mapper/TaskPlaceRectificationMapper.xml
+++ b/src/main/java/org/springblade/modules/taskPlaceRectification/mapper/TaskPlaceRectificationMapper.xml
@@ -256,12 +256,8 @@
</when>
</choose>
</if>
- and jtpr.create_time=(
- SELECT MAX(create_time) FROM jczz_task_place_rectification where jtpr.house_code=house_code
- )
- order by jtpr.create_time desc
</where>
-
+ order by jtpr.create_time desc
</select>
--
Gitblit v1.9.3