修改bug

huanghongfa

2021-12-16 db4ce5457d10e10b9bab1ab9bbd75be0e9611bd5

修改bug

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/screen/event/EventPopulationSpecialStatisticsVO.java

@@ -33,9 +33,6 @@
    @ApiModelProperty("退役军人")
    private Integer tyTotal = 0;

    @ApiModelProperty("退休人员")
    private Integer txTotal = 0;

    @ApiModelProperty(value = "吸毒人员",hidden = true)
    private Integer xdTotal = 0;


 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml

@@ -916,21 +916,6 @@
            ) as tyTotal,
            (
            SELECT
            count( cmpct6.id )
        FROM
            com_mng_population_community_tags AS cmpct6
            LEFT JOIN com_act AS ca6 ON ca6.community_id = cmpct6.community_id
            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' and ca6.is_screen_statistics = 1
        <if test="streetId != null and streetId != 0">
            and cs6.street_id = #{streetId}
        </if>
            AND cmp6.death = 0
            ) as txTotal,
            (
            SELECT
            count( cmpct7.id )
        FROM
            com_mng_population_community_tags AS cmpct7