From 4acf044b0986d8844af5ddb95f30b2e4dee1b5b1 Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期四, 16 十二月 2021 14:32:24 +0800
Subject: [PATCH] 修改大屏一标三实模块数据查询屏蔽某些社区
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml | 32 ++++++++++++++++----------------
1 files changed, 16 insertions(+), 16 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 dbd058a..abcb1af 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
@@ -849,7 +849,7 @@
com_act AS ca
LEFT JOIN com_street AS cs ON cs.street_id = ca.street_id
<where>
- and ca.area_code = '510423'
+ and ca.area_code = '510423' and ca.is_screen_statistics = 1
<if test="streetId != null and streetId != 0">
and cs.street_id = #{streetId}
</if>
@@ -868,7 +868,7 @@
LEFT JOIN com_act AS ca1 ON ca1.community_id = cmpct1.community_id
LEFT JOIN com_street AS cs1 ON cs1.street_id = ca1.street_id
WHERE
- cmpct1.label LIKE '%低保户%' and ca1.area_code = '510423'
+ cmpct1.label LIKE '%低保户%' and ca1.area_code = '510423' and ca1.is_screen_statistics = 1
<if test="streetId != null and streetId != 0">
and cs1.street_id = #{streetId}
</if>
@@ -881,7 +881,7 @@
LEFT JOIN com_act AS ca2 ON ca2.community_id = cmpct2.community_id
LEFT JOIN com_street AS cs2 ON cs2.street_id = ca2.street_id
WHERE
- cmpct2.label LIKE '%高龄老人%' and ca2.area_code = '510423'
+ cmpct2.label LIKE '%高龄老人%' and ca2.area_code = '510423' and ca2.is_screen_statistics = 1
<if test="streetId != null and streetId != 0">
and cs2.street_id = #{streetId}
</if>
@@ -894,7 +894,7 @@
LEFT JOIN com_act AS ca3 ON ca3.community_id = cmpct3.community_id
LEFT JOIN com_street AS cs3 ON cs3.street_id = ca3.street_id
WHERE
- cmpct3.label LIKE '%特殊情况（重大病史/孕）%' and ca3.area_code = '510423'
+ cmpct3.label LIKE '%特殊情况（重大病史/孕）%' and ca3.area_code = '510423' and ca3.is_screen_statistics = 1
<if test="streetId != null and streetId != 0">
and cs3.street_id = #{streetId}
</if>
@@ -907,7 +907,7 @@
LEFT JOIN com_act AS ca4 ON ca4.community_id = cmpct4.community_id
LEFT JOIN com_street AS cs4 ON cs4.street_id = ca4.street_id
WHERE
- cmpct4.label LIKE '%特扶家庭%' and ca4.area_code = '510423'
+ cmpct4.label LIKE '%特扶家庭%' and ca4.area_code = '510423' and ca4.is_screen_statistics = 1
<if test="streetId != null and streetId != 0">
and cs4.street_id = #{streetId}
</if>
@@ -920,7 +920,7 @@
LEFT JOIN com_act AS ca5 ON ca5.community_id = cmpct5.community_id
LEFT JOIN com_street AS cs5 ON cs5.street_id = ca5.street_id
WHERE
- cmpct5.label LIKE '%退役军人%' and ca5.area_code = '510423'
+ cmpct5.label LIKE '%退役军人%' and ca5.area_code = '510423' and ca5.is_screen_statistics = 1
<if test="streetId != null and streetId != 0">
and cs5.street_id = #{streetId}
</if>
@@ -934,7 +934,7 @@
LEFT JOIN com_street AS cs6 ON cs6.street_id = ca6.street_id
left join com_mng_population as cmp6 on cmp6.id = cmpct6.population_id
WHERE
- cmpct6.label LIKE '%养老金人员%' and ca6.area_code = '510423'
+ cmpct6.label LIKE '%养老金人员%' and ca6.area_code = '510423' and ca6.is_screen_statistics = 1
<if test="streetId != null and streetId != 0">
and cs6.street_id = #{streetId}
</if>
@@ -948,7 +948,7 @@
LEFT JOIN com_act AS ca7 ON ca7.community_id = cmpct7.community_id
LEFT JOIN com_street AS cs7 ON cs7.street_id = ca7.street_id
WHERE
- cmpct7.label LIKE '%吸毒人员%' and ca7.area_code = '510423'
+ cmpct7.label LIKE '%吸毒人员%' and ca7.area_code = '510423' and ca7.is_screen_statistics = 1
<if test="streetId != null and streetId != 0">
and cs7.street_id = #{streetId}
</if>
@@ -961,7 +961,7 @@
LEFT JOIN com_act AS ca8 ON ca8.community_id = cmpct8.community_id
LEFT JOIN com_street AS cs8 ON cs8.street_id = ca8.street_id
WHERE
- cmpct8.label LIKE '%社区矫正%' and ca8.area_code = '510423'
+ cmpct8.label LIKE '%社区矫正%' and ca8.area_code = '510423' and ca8.is_screen_statistics = 1
<if test="streetId != null and streetId != 0">
and cs8.street_id = #{streetId}
</if>
@@ -974,7 +974,7 @@
LEFT JOIN com_act AS ca9 ON ca9.community_id = cmpct9.community_id
LEFT JOIN com_street AS cs9 ON cs9.street_id = ca9.street_id
WHERE
- cmpct9.label LIKE '%邪教人员%' and ca9.area_code = '510423'
+ cmpct9.label LIKE '%邪教人员%' and ca9.area_code = '510423' and ca9.is_screen_statistics = 1
<if test="streetId != null and streetId != 0">
and cs9.street_id = #{streetId}
</if>
@@ -987,7 +987,7 @@
LEFT JOIN com_act AS ca10 ON ca10.community_id = cmpct10.community_id
LEFT JOIN com_street AS cs10 ON cs10.street_id = ca10.street_id
WHERE
- cmpct10.label LIKE '%刑释人员%' and ca10.area_code = '510423'
+ cmpct10.label LIKE '%刑释人员%' and ca10.area_code = '510423' and ca10.is_screen_statistics = 1
<if test="streetId != null and streetId != 0">
and cs10.street_id = #{streetId}
</if>
@@ -1000,7 +1000,7 @@
LEFT JOIN com_act AS ca11 ON ca11.community_id = cmpct11.community_id
LEFT JOIN com_street AS cs11 ON cs11.street_id = ca11.street_id
WHERE
- cmpct11.label LIKE '%上访人员%' and ca11.area_code = '510423'
+ cmpct11.label LIKE '%上访人员%' and ca11.area_code = '510423' and ca11.is_screen_statistics = 1
<if test="streetId != null and streetId != 0">
and cs11.street_id = #{streetId}
</if>
@@ -1013,7 +1013,7 @@
LEFT JOIN com_act AS ca12 ON ca12.community_id = cmpct12.community_id
LEFT JOIN com_street AS cs12 ON cs12.street_id = ca12.street_id
WHERE
- cmpct12.label LIKE '%精神障碍患者%' and ca12.area_code = '510423'
+ cmpct12.label LIKE '%精神障碍患者%' and ca12.area_code = '510423' and ca12.is_screen_statistics = 1
<if test="streetId != null and streetId != 0">
and cs12.street_id = #{streetId}
</if>
@@ -1023,7 +1023,7 @@
LEFT JOIN com_act AS ca ON ca.community_id = cmpct.community_id
LEFT JOIN com_street AS cs ON cs.street_id = ca.street_id
WHERE
- cmpct.label LIKE '%残疾人%' and ca.area_code = '510423'
+ cmpct.label LIKE '%残疾人%' and ca.area_code = '510423' and ca.is_screen_statistics = 1
<if test="streetId != null and streetId != 0">
and cs.street_id = #{streetId}
</if>
@@ -1038,7 +1038,7 @@
LEFT JOIN com_act AS ca ON ca.community_id = cmpct.community_id
LEFT JOIN com_street AS cs ON cs.street_id = ca.street_id
<where>
- and ca.area_code = '510423'
+ and ca.area_code = '510423' and ca.is_screen_statistics = 1
<if test="streetId != null and streetId != 0">
and cs.street_id = #{streetId}
</if>
@@ -1056,7 +1056,7 @@
LEFT JOIN com_street AS cs ON cs.street_id = ca.street_id
<where>
- and ca.area_code = '510423'
+ and ca.area_code = '510423' and ca.is_screen_statistics = 1
<if test="streetId != null and streetId != 0">
and cs.street_id = #{streetId}
</if>
--
Gitblit v1.7.1