From cadc325e8a83652330ebfc4ce4ee888a43d24d70 Mon Sep 17 00:00:00 2001
From: tangxiaobao <303826152@qq.com>
Date: 星期三, 21 七月 2021 17:59:28 +0800
Subject: [PATCH] 社区后台基础数据库bug修改

---
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java |    7 -------
 1 files changed, 0 insertions(+), 7 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java
index 98908e0..ca21666 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java
@@ -150,7 +150,6 @@
             "cmp.special_situation, " +
             "cmp.phone, " +
             "cmp.remark, " +
-            "cmv.alley, " +
             "cmp.native_place, " +
             "cmp.nation,  " +
             "cmp.label,  " +
@@ -163,11 +162,8 @@
             "cmp.update_at,  " +
             "cmp.address,  " +
             "cmp.is_rent,  " +
-            "cmphu.relation  " +
             "FROM  " +
             "com_mng_population AS cmp " +
-            "LEFT JOIN com_mng_village AS cmv ON cmv.village_id = cmp.village_id " +
-            "LEFT JOIN com_mng_population_house_user AS cmphu ON cmphu.popul_id = cmp.id " +
             "<where>" +
             "<if test='comMngPopulationVO.name != null and comMngPopulationVO.name != &quot;&quot;'>" +
             "AND cmp.`name` LIKE concat(#{comMngPopulationVO.name},'%') " +
@@ -198,9 +194,6 @@
             " </if> " +
             "<if test='comMngPopulationVO.houseNo != null and comMngPopulationVO.houseNo != &quot;&quot;'>" +
             "AND cmp.house_no = #{comMngPopulationVO.houseNo} " +
-            " </if> " +
-            "<if test='comMngPopulationVO.alley != null and comMngPopulationVO.alley != &quot;&quot;'>" +
-            "AND cmv.alley LIKE concat(#{comMngPopulationVO.alley},'%') " +
             " </if> " +
             "<if test='comMngPopulationVO.sex != null and comMngPopulationVO.sex != &quot;&quot;'>" +
             "AND cmp.sex = #{comMngPopulationVO.sex} " +

--
Gitblit v1.7.1