From aa8b95156a4712de31ffb2e14a15faac15d0b0f3 Mon Sep 17 00:00:00 2001
From: puhanshu <a9236326>
Date: 星期五, 31 十二月 2021 16:57:57 +0800
Subject: [PATCH] 大屏修改-3116
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml | 7 ++-----
1 files changed, 2 insertions(+), 5 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml
index 472c680..461b5f2 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml
@@ -1125,10 +1125,8 @@
<if test="pageBaseDTO.param3 != null and pageBaseDTO.param3 == 2">
AND event_deal_status != 4
</if>
- ORDER BY e.create_at DESC
)
- UNION ALL
- (SELECT
+ UNION ALL (SELECT
CASE
WHEN classify_id = 4 THEN 1
WHEN classify_id = 6 THEN 2
@@ -1149,7 +1147,6 @@
<if test="pageBaseDTO.param3 != null and pageBaseDTO.param3 == 2">
AND handle_status != 2
</if>
- ORDER BY create_at DESC
- )
+ ) ORDER BY create_at DESC
</select>
</mapper>
--
Gitblit v1.7.1