From a5d7c8b6cbdb998ba02159ba57f56e58b36e2fa2 Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期五, 30 六月 2023 10:51:51 +0800
Subject: [PATCH] 区分西区 花城分类
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDynTypeDOMapper.xml | 12 ++++++------
1 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDynTypeDOMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDynTypeDOMapper.xml
index bb4bd83..d063bce 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDynTypeDOMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDynTypeDOMapper.xml
@@ -39,10 +39,10 @@
LEFT JOIN sys_user AS su ON su.user_id = cadt.create_by
LEFT JOIN sys_user AS su1 ON su1.user_id = cadt.update_by
where cadt.community_id = 0 and cadt.is_del = 2
- <if test="comActDynTypeDTO.area != null">
+ <if test="comActDynTypeDTO.area == '2'">
AND cadt.area in (1,2)
</if>
- <if test="comActDynTypeDTO.area == null">
+ <if test="comActDynTypeDTO.area == null or comActDynTypeDTO.area == '1' ">
AND cadt.area in (1)
</if>
<if test="comActDynTypeDTO.category != null">
@@ -68,10 +68,10 @@
LEFT JOIN sys_user AS su ON su.user_id = cadt.create_by
LEFT JOIN sys_user AS su1 ON su1.user_id = cadt.update_by
where cadt.is_del = 2
- <if test="comActDynTypeDTO.area != null">
+ <if test="comActDynTypeDTO.area == '2'">
AND cadt.area in (1,2)
</if>
- <if test="comActDynTypeDTO.area == null">
+ <if test="comActDynTypeDTO.area == null or comActDynTypeDTO.area == '1' ">
AND cadt.area in (1)
</if>
<if test='comActDynTypeDTO.category != null '>
@@ -127,10 +127,10 @@
LEFT JOIN sys_user AS su ON su.user_id = cadt.create_by
LEFT JOIN sys_user AS su1 ON su1.user_id = cadt.update_by
where cadt.is_del = 2
- <if test="comActDynTypeDTO.area != null">
+ <if test="comActDynTypeDTO.area == '2'">
AND cadt.area in (1,2)
</if>
- <if test="comActDynTypeDTO.area == null ">
+ <if test="comActDynTypeDTO.area == null or comActDynTypeDTO.area == '1' ">
AND cadt.area in (1)
</if>
<if test='comActDynTypeDTO.category != null '>
--
Gitblit v1.7.1