罗元桥
2021-08-21 07f4cb2bb4e648dcf4e646cd56404be58505eb81
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationHouseDAO.java
@@ -229,7 +229,7 @@
            " cmp.`name`, " +
            " IFNULL( cmp.phone, '暂无' ) as phone, " +
            " cmp.card_no, " +
            " cmp.label, " +
            " cmpct.label, " +
            " cmp.address, " +
            " cmp.nation, " +
            " cmphu.create_at, " +
@@ -237,6 +237,7 @@
            "FROM " +
            " com_mng_population_house_user AS cmphu " +
            " LEFT JOIN com_mng_population AS cmp ON cmp.id = cmphu.popul_id  " +
            " left join com_mng_population_community_tags AS cmpct on cmp.id = cmpct.population_id " +
            "WHERE " +
            " cmphu.house_id = #{houseId} " +
            "<if test='relation != null '>" +